Professional Summary

With over *+ years of extensive experience in database design, development, and business intelligent of MS SQL Server versions 2012/2016/2019 using SSIS, SSAS and SSRS on various business domains like Health care, Financial, Insurance and manufacturing.

Hand on Experience in installing, configuring, managing, monitoring, and troubleshooting SQL server versions 2012/2016/2019.

Extensive experience and deep knowledge on writing with T-SQL Programming in constructing database object like Views, Tables, Store Procedures, Triggers, Function, and Index.

Experienced on performance Tuning, query optimization and troubleshooting.

Experienced in optimization tools such as index tuning wizard, SQL profiler and windows performance monitor for monitoring and tuning MS SQL server performance.

Great ability to create and manage database objects like Tables, Views, Store Procedures, Triggers, Function, and Index

Excellent T-SQL development skill to write complex queries involving multiple tables, to develop and maintain Stored Procedures, Views, Triggers, User defied Functions.

Experienced in client interaction and understanding business applications, Data Modeling, Data Mapping, Table Normalization.

Good understanding in database and data warehousing concepts (OLTP & OLAP).

Expert in Data Extraction, Transformation and Loading using SSIS.

Experienced in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS and SSIS Packages.

Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge, and union all and Proficient in Resolving Complex Issues and Error Handling in SSIS

Experienced in business intelligent tools (SSIS, SSAS, SSRS) in MS SQL server 2016.

Data loading experience SQL server 2016 using SSIS ETL and experience in developing packages in SSIS and DTS in according to the task.

Experienced in logical and physical Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, Fact and Dimensional tables and Operational Data Store (ODS).

Developed Multi-dimensional Objects (Cubes, Dimensions) using SSAS.

Managing medium and large databases in 24/7 environment which includes installation, backup/recovery, upgrade and configuration of Microsoft SQL Server and databases

Good understanding of SQL Server Reporting Services (SSRS) with Report authoring, Report management, Report delivery and Report security.

Expert in creating simple and parametrized report and complex involving sub reports, Matrix/Tabular Reports, chart, and graphs using SSRS in Business Intelligent Development Studio (BIDS)

Experienced in writing expressions in SSRS and expert in fine tuning the report. Create many drills through and Drill down report by using SSRS.

Developed various visualizations by creating reports and dashboards with Power BI and deploying them to Power BI Services.

Experience in Project Management and Software Development lifecycle (SDLC).

Strong troubleshooting, problem-solving skills, and ability to prioritize multiple tasks.

Excellent Analytical, Interpersonal and Communication skills, fast learner, hardworking, detail oriented and versatile team player

Capable of forming and maintain positive and productive working relationships in internal/external and team environment.

Technical skills

Relational DBMS: SQL Server 2012/2016/2019

Programming Languages: T-SQL, MDX, DAX, C, C#, VB, XML, HTML AutoCAD, Solid work, ANSYS

BI and Data Analytics Tools: SSIS, SSAS, SSRS, Power BI, Tableau

Data Warehousing PL/SQL Database Design

Performance Tuning Tools: SQL- Profiler, Index/Database Tuning Advisor, SQL Execution Plan

Job scheduler: SQL server agent

Data modelling tools: Lucid Chart, Draw.io, Visio, Día

Operating Systems: Windows XP/NT/2000, DOS, window server 2003

MS Office: MS Word, PowerPoint, MS Excel, MS Access

Azure SQL database, Azure SQL server, Azure SQL management

EDUCATION / CERTIFICATION

Bachler Of mechanical engineering

Professional Experience

SQL Server (T-SQL, ETL/SSIS, SSAS, SSRS) Developer Client at

St Paul’s Hospital Millennium Medical College, Addis Ababa, Ethiopia July 2012- Nov 2019

Key Responsibilities:

Worked on all activities related to the development, implementation, and support of ETL processes.

Used SSIS to create ETL packages to validate, extract, transform using Derived Columns, Condition Split, Data Conversion, Aggregations, Multicasting

Contributed to the development and modification of coding standards for the team to ensure consistency, efficiency and accuracy in reporting and data analysis.

Enhanced performance using optimization techniques-normalization and indexing.

Performed performance tuning of Queries, Stored Procedures and existing ETL packages.

Designed various SSRS reports such as Drill down reports, Drill through reports, Parameterized reports using SSRS and applied security to reports on item and folder level.

Rendered reports in different formats like pdf, excel etc. to be executed automatically on weekly or monthly basis and managed subscriptions.

Developed various visualizations by creating reports and dashboards with Power BI and deploying them to Power BI Services.

Experienced with AGILE SCRUM methodologies.

Tools and Technologies:

T-SQL, MS SQL Server 2012 /2014, 2016, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), ETL, SSAS, XML, MS Excel, C#, .NET, MS, Visual basic.

Projects

Database Development and Querying Project

Reporting Service Project

SQL Server Database Development, BI and Data Analytics Comprehensive Project – With Agile methodologies.

Contact this candidate