Professional Summary:

Skilled software professional with over 7 years of IT industry experience with Microsoft SQL Server, Integration Services SSIS, Reporting Services SSRS, and Analysis Services SSAS environments.

Created databases, and tables and provided constraints and user-defined rules and defaults.

Hands-on experience in Performance Tuning and Query Optimization

Developed SSIS Packages to Extract, Transform, and Load (ETL) data into the Data warehouse from SQL Server.

Involved in building a data warehouse and Datamart with Dimensions and Fact Tables based on Business requirements.

Write Stored Procedures to populate various dimensional tables and fact tables for the Data Warehouse.

Experience in loading facts and dimensions using SSIS Packages on data warehousing projects.

Designed data structure with multiple facts and dimension tables to hold the source data to be used for building new reports.

Worked on T-SQL programming, stored procedures, and views in the process of developing Power BI and SSRS reports.

Understand business requirements in BI context and design data models to transform raw data into meaningful insights.

Hand-on experience using Azure DevOps, TFS, and GitHub for managing source code changes.

Worked in Development, Testing, and Production environment.

Organized, self-starter, and effective team member with excellent problem-solving skills.

SQL:

Experience in writing T-SQL Stored Procedures, Triggers, Constraints, Views, Functions, and Indexes using various DDL and DML commands.

Strong knowledge of Data Warehouse methodologies and including Star schemas, and snowflake concepts.

Maintained data integrity by Creating checks and constraints.

Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins, and created indexes.

Handled performance tuning and optimization, with strong analytical and troubleshooting skills for quick issue resolution.

Troubleshoot slow-performing queries by using SQL Profiler.

Performed some DBA Tasks like checking the jobs that fail and troubleshooting the issues.

Developed, tested, and implemented Referential Integrity rules and regulations through constraints, triggers, and views in the centralized SQL database.

SSIS:

Created and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying, and dynamic configuring of SSIS packages.

Used SSIS to create ETL packages to validate, extract, transform, and load data to data warehouse databases, and DataMart databases.

Transferred data from various OLTP data sources such as XML, MS Excel, Flat files, and Tera data Studio into SQL Server 2012/2014/2016/2019.

Troubleshooting of processes, issues, and errors in SSIS Packages to improve their performance.

571-***-****

Implemented Various Error handling and Event Handling Techniques in SSIS to ensure efficient package execution.

Involved in performing incremental loads while transferring data from OLTP to the data warehouse using different data flow and control flow tasks in SSIS.

Involved in automating SSIS packages using SQL server agent jobs.

SSRS:

Wrote SQL queries and stored procedures to generate data for reports.

Defined the report layout and identified datasets for the report generation.

Created, formatted, and maintained various reports in SSRS like drill-down, drill-through, sub reports, Ad hoc reports, parameterized reports, interactive reports & custom reports.

Configured the report viewing security for various users at various levels using Report Manager.

Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly, and quarterly Reports including current status.

Education/Certifications:

BA major in Accounting Information Systems at Addis Ababa University, Ethiopia-2015

Introduction to Computing Certificate: Grace Virtual University, Ethiopia

Professional Experience:

1.Wells Fargo July 2022 -Present

North Carolina, Charlotte

SQL/SSIS Developer/Software Engineering

Responsibilities:

Developed logical and physical database (using ER-win, Normalization, Dimension Modelling, and Enterprise Manager).

Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files, etc.) and then loaded the data into destination tables by performing complex transformations using SSIS/DTS packages.

Made sure that standards and best practices in database development were followed and maintained.

Defined and designed the data sourcing and data flows, data quality analysis

Identified the data source and defined them to build the data source views.

Wrote Complex Stored Procedures, Triggers, Views, and Queries. Created indexes, Constraints, and rules on database objects.

Developed and deployed SSIS packages to load data from OLTP to the Data Warehouse system.

Designed ETL packages dealing with different data sources (SQL Server, CSV, Flat Files, Tera Data, etc.) Transferred data from various sources like MS Excel, MS Access, and SQL Server using SSIS2005/2008 and then created reports using this data using SSRS.

Configured and maintained Report Manager and Report Server for SSRS.

Identified and added the report parameters and created the reports based on the requirements using API.

Optimized schema, performance, and capacity planning of various data transformation processes related to the reports.

Tested and managed the SSIS 2005 and SSIS 2008 packages and was responsible for its security.

Scheduled and monitored all maintenance activities of SQL Server 2005 including database consistency checks and index defragmentation.

Set up database backup and recovery strategies.

Designed and Implemented the Stored Procedures and Triggers for automating tasks.

Maintained all records of project status and followed changes as per control procedures.

Provided technical support to internal developers.

Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.

Business Skills / Technical Skills:

MS SQL Server 2012/2008R2/2008/2005/2000, Visual Studio 2010/2008 (SSAS/SSIS/SSRS), Microsoft Access 2007/2003, Microsoft Excel (Pivot Table), OLAP and OLTP, Outlook, MS SQL Profiler, SQL Server Query Analyzer, Index Tuning Wizard, C#. Net, VB.Net. / Share point, Crystal Reports 8/ 9/10, ADO.NET, ASP.Net, Frame Work 2.0, C#, MDX, MDM, Oracle, DB2, Dash Board by Crystal report, Erwin8/7.3/3.5, Windows 2007/2005 Advanced Server/Professional, Window XP, MS Access, Java, My SQL

2.KPMG June 2020 -June 2022

New York

SSIS/SQL Developer

Developed logical and physical database (using ER-win, Normalization, Dimension Modelling, and Enterprise Manager).

Optimized schema, performance, and capacity planning of various data transformation processes related to the reports.

Made sure that standards and best practices in database development were followed and maintained.

Defined and designed the data sourcing and data flows, data quality analysis

Identified the data source and defined them to build the data source views.

Wrote Complex Stored Procedures, Triggers, Views and Queries. Created indexes, Constraints and rules on database objects.

Developed and deployed SSIS packages to load data from OLTP to the Data Warehouse system.

Designed ETL packages dealing with different data sources (SQL Server, CSV, Flat Files etc.) Transferred data from various sources like Tera Data Studio, MS Excel, MS Access, and SQL Server using SSIS2017/2019/2022.

Configured and maintained Report Manager and Report Server.

Tested and managed the SSIS 2017 and SSIS 2019 packages.

Scheduled and monitored all maintenance activities of SQL Server 2016 including database consistency checks and index defragmentation.

Designed and Implemented the Stored Procedures and Triggers for automating tasks.

Maintained all records of project status and followed changes as per control procedures.

Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.

Set up database backup and recovery strategies.

Business Skills / Technical Skills:

MS SQL Server 2012/2008R2/2008/2005/2000, Visual Studio 2010/2008 (SSAS/SSIS/SSRS), Microsoft Access 2007/2003, Microsoft Excel (Pivot Table), OLAP and OLTP, Outlook, MS SQL Profiler, SQL Server Query Analyzer, Index Tuning Wizard, C#. Net, VB.Net. / Share point, Crystal Reports 8/ 9/10, ADO.NET, ASP.Net, Frame Work 2.0, C#, MDX, MDM, Oracle, DB2, Dash Board by Crystal report, Erwin8/7.3/3.5, Windows 2007/2005 Advanced Server/Professional, Window XP, MS Access, Java, My SQL

3.Washington Care Source

Seattle, WA January 2017- May 2020

SQL Server BI Developer

Responsibilities

●Create ETL SSIS packages both designed and coded to process data to target databases.

●Identify and resolve problems encountered during both the development and release of the SSIS code.

●Debugging and troubleshooting technical issues while implementing the applications.

●Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with the incremental load.

●Created Packages for extracting data from Flat Files, Excel, MS Access, Tera Data Studio, Oracle, and MS SQL Server 2014/2016/2019

●Created packages in SSIS with error handling and worked with different methods of logging in SSIS

●Developed, Maintained, and Monitored all import/export and Data Transformation into the Staging and Production environments.

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

●Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files, etc.) and then loaded the data into destination tables by performing complex transformations using SSIS/DTS packages.

●Used ETL to implement Slowly Changing Dimension to maintain historical data in the Data Warehouse.

●Responsible for Deploying, Scheduling Jobs, Alerting, and Maintaining SSIS packages.

●Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views, and other T-SQL code and SQL joins for applications following SQL code standards.

●Responsible for data analysis and loading data from Data feed to Data Warehouse tables.

●Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

●Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.

●Created views to display required information on the user interface, and triggers to validate consistent data entry into the database.

●Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Tabular, Matrix, Drill Down, Drill Through, and web reporting.

●Designed different kinds of reports from scratch depending on the requirements of the markets, vendors, providers, and scanners.

●Documented all the work and all the process of integration and reporting services for further references

●Worked extensively on system analysis, design, development, testing, and implementation of projects (Complete SDLC).

Environment: MS SQL Server 20014/2012/2008R2, SSRS, SSIS, SQL Query Analyzer, SQL profiler, Windows Server 2003/2008, DTS, Share Point Portal Server, HTML, XML, C#, .Net, ASP.NET, Visual Studio 2005/2010/2015/2017/2019/2022, MS Access, Crystal Reports 2013, MS Excel 2007.

Contact this candidate