Professional Summary:

Over *+ years of experience in MS SQL Server in various domains like Financial, Healthcare, Retail, and Insurance with expertise in MS SQL Server 2017/2016/2014/2012/2008R2/2008, SSIS, and SSRS.

Experienced in merging data from various heterogeneous data sources, populating dimension and fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.

Proficient in installing, configuring, managing, monitoring and troubleshooting MS SQL Server 2017/2016/2014/2012/2008R2/2008

Proficiency in using T-SQL, Writing Stored Procedures, Triggers, User Defined Functions, & Views.

Experienced in Data conversion, Data modeling, and Normalization.

Strong experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

Involved in creating operational reports in SSRS 2016/2012/2008r2/2008 i.e. Drill-Down, Drill-through, Dashboard, Sub-Report, and Matrix reports for various domains.

Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks DBCC Utilities.

Involved in Data Scrubbing, Data Staging, and Data Validation in preparation of pushing data to a production environment.

Defined and administered database standards, controls, procedures, and documentation.

Expertise in Microsoft SQL Server BI reporting applications and tools (Management Studio, Reporting Services, Visual Studio/SSDT, Integration Services).

Generated sub reports, cross-tab, conditional, drill-down reports, drill through reports, and parameterized reports using SSRS 2014 and SSRS 2012.

Good understanding in database Backup, Recovery and highly experienced in investigating and applying necessary MS SQL Server database service packs, hot fixes and security patches.

Experienced in creating report by using Power BI Desktop.

SKILLS:

Languages (T-SQL, PL/SQL),

Databases (SQL Server 2017/2016/2014/2012/2008R2/2008, Oracle),

Analysis/Reporting Tools (SQL Server Reporting Service (SSRS), SQL Server Analysis Service

(SSAS), Crystal Reports, Power BI Desktop),

ETL Tools (SSIS, DTS SQL Data tools, Business Intelligence Development Studio (BIDS)),

Data Modeling Tools (Erwin, Microsoft Visio),

Database Tools (SQL Query Analyzer, SQL Enterprise Manager, SQL Server

Management Studio (SSMS), SQL Server Query Editor, Solution

Explorer, Analysis Manager, Reporting Server, SQL developer, SQL Profiler, Query Analyzer, SQL Server data tools (SSDT)),

Operating Systems (Windows NT/2000/XP Pro/Vista, Windows Server 2003/2008, Linux, Unix),

Version Control/Utilities (CVS, SVN and GIT Hub, JIRA)

Work History

Atrium Health, Charlotte, NC May. 2020 to Present

SSIS/SQL Developer

Responsibilities:

Worked closely with end users/internal customers to understand project/requirement scope and involved in providing solution to implement or support production issues.

Designing and developing ETL process to integrate data among business systems and Data warehouses in Oracle and MS SQL Server.

Created Stored procedures, Triggers, Functions, Indexes, Tables, Views, SQL Joins and other T_sql code to implement business rules (used CTE, Temporary tables, and user defined table types in codes developed.)

Developing physical data models using ERWIN and created DDL scripts for DB schema and objects.

Maintain and develop system integrations among enterprise front and back end applications (ERP, CRM, EDI, Demand Planning, and Manufacturing Control Systems).

Extracting data from data sources Oracle, CSV files, text files, SQL-Server and applied required transformations to clean the data.

Working with VB script in SSIS packages to ensure the business requirements are met in the data flow.

Take part in Unit testing, User Acceptance testing to check whether the data is loading into the target, which was extracted from different source systems.

Working with SQL Profiler for troubleshooting, monitoring, and optimize SQL Server and T-SQL.

Check daily jobs and verify databases to ensure the correct flow of data from different systems like IFS (Industrial and Financial Systems) which is an Oracle Financial ERP system for Silgan, WMS (Warehouse Management system), Pivotal system which holds retail and distributor data.

Involving daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues, and errors using SQL Server Integration Services (SSIS) 2014.

Developing Flowcharts with Visio/VBA/Excel/SQL was used in storing Flowchart elements.

Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs, etc.) and reloaded the data into target data sources by performing different kinds of transformations.

Contributed to the creation of solid coding techniques and recommended and reviewed coding standards, evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery for the data.

Wrote documentation data warehouse artifacts and data lineage for ETL tools.

Capital One, McLean, VA Sept. 2017 to May.2020

SQL/SSIS/SSRS Developer

Responsibilities:

Worked with Technical Architects and DB analysts for Designing tables for efficient Report Design.

Developed the SQL Server Integration Services (SSIS) packages to transform data as well as created interface stored procedures used in SSIS to load/transform data to the database.

Created SSIS packages to Oracle and other SQL Server instances in SSIS 2012/2014.

Created database maintenance plans and deleting of history data using SSIS packages.

Deployed SSIS packages and Reports to Production Servers.

Extracted the data from the different sources (CSV files, Oracle, and MS SQL 2005) and stored the data into the intermediate Staging Database using the SSIS ETL tool.

Transformed the data from the staging DB and perform the transformation using the Data Flow Tasks.

Performed the task of data transfer from files in remote server to folders in another server using FTP.

Developed various reports using SSRS, which included writing complex stored procedures for datasets.

Involved report authoring, report delivery (using both Pull and Push strategy), and Report Management for various types of reports.

Prepared reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML, etc.

Scheduled the Reports to run on a daily and weekly basis in Report Manager and email them to director and analysts to review in Excel Sheet.

Develop complex SQL queries, stored procedures, functions and triggers.

Created several SSIS packages for performing ETL operations to transform data from a cube using MDX.

Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation, and implementation.

Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in the DW.

Developed cross-Tabbed and sub-reports in 2012

Designed and Developed matrix, tabular and parametric reports in the SQL server reporting services 2012.

Used breaks, Calculations, sorts, filters and sections to enhance data presentation in reports.

Premier Switch Solutions S.co, AA, Ethiopia Jan. 2016 to May. 2017

Role: SQL Developer

Responsibilities:

Collected business requirements from analysts and translated them as technical specifications, designed database, and documents for development.

Supported day-to-day operational activities for the BI platform like service requests and tickets, monitoring, performance tuning, troubleshooting long-running queries, locks, deadlocks.

Hands-on experience in installing, configuring, managing, and monitoring SQL Server 2005 to 2014.

Worked on High Availability technologies log-shipping, failover clustering management & mirroring.

Implemented the SQL agent jobs creation while deploying the database instance itself by adding them to the post-deployment scripts.

Interacted with Business Analysts and Users in requirement gathering, built complex queries using SQL.

Created Stored procedures, Triggers, Functions, Indexes, Tables, Views, Sql Joins and other T_sql code to implement business rules (used CTE, Temporary tables, and user defined table types in codes developed.)

Validated the solution met requirements and prepared documentation for same.

Education:

Bachelor’s Degree: Haramaya University, Ethiopia

Contact this candidate