Sevious Chipara Email & Phone Number

•Data specialist proficient in designing, coding, testing, and providing comprehensive support for data solutions within both on-premises and cloud environments.•Proficient in a wide range of Data management technologies, including Azure Data Platform (Synapse, ADF, Data Lake, Databricks), MS SQL Server, SSRS, SSIS, Azure SQL, Excel, and Power BI.•With a range of skills such as critical thinking, decision-making, problem-solving, time management, multitasking, and communication.Technical Proficiencies•DW/BI - Dimensional Modelling (Kimball, Star/Snowflake), ETL, Reports, Dashboards.•Requirements Analysis – Stakeholder liaisons, Data Warehouse Bus Matrix. •Azure –SQL (Database, Managed Services and VM), Synapse, Databricks, Data Factory, Notebooks, Data-Lake, Delta Lakes, Blob Storage, Queues, Cosmos DB, Active Directory, Key Vault •SQL Server – SSMS, SSIS, SSAS, SSRS, SSDT, T-SQL, MDX, DAX.•Version Control – Azure DevOps (Branches, Merges, Pull Requests, CI/CD, Pipelines), GitHub, TFS, Git.•Automation –SQL Server Agent, Python (Pandas, SQLAlchemy, Openpyxl, XlsxWriter).•Data Factory – Pipelines, Datasets, Data Flows, Linked Services, Triggers, Monitor•TSQL - Stored Procedures, Functions, Indexing, Temporal tables, Partitioning, Auditing.•SSIS - DFT (Merge, Lookup, Multicast, Merge Join, Sort), Execute SQL Task, Script Task.•PowerBI – Measures, Dimensions, Calculated Columns, Reports, Dashboards, Matrix, Filters, Table, Charts, Drill through, Paginated reports•Microsoft Fabric – Data Lake, Data Lakehouse, Pipelines, Data Flow, Connectors, Integration Services, Notebook, SQL Pool, Automation•Apache Spark – SparkSQL, Pysaprk, Data Frames, RDD, SparkR•Python – NumPy, Pandas, PySpark Matplotlib, Requests, SQLite, SQLAlchemy, Openpyxl, XlsxWriter, Requests.