Etl Developer Sql

Maereg Tsegaye A. (***) ***- ****

******.****@*****.***

Professional Summary:

●Over 9 years of in-depth experience in database design, development, administration and maintenance of SQL Server 2019/2017/2016/2012/2008R2/2005 large scale databases.

●A seasoned hard-core SQL/BI/ETL developer with a hands on experience managing, synchronizing, integrating, migrating, monitoring, troubleshooting and performance tuning MS SQL Server and Oracle database objects.

●Expert level skills in Objects creation such as Tables and Views, stored procedures, User created functions, views, user profiles, data dictionaries, data integrity, Performance tuning, Indexes and appropriate Triggers to facilitate and improve data quality, data accuracy data consistency.

●Expert in writing T-SQL queries, creating clustered and non-clustered Index, working on DTS, Data Cleansing and Data Migration

●Strong SQL and PL/SQL performance tuning skills.

●Extensive experience in Microsoft stack of BI solutions - SSRS, SSAS & SSIS in OLTP and OLAP (Data Warehousing) environments with MS SQL 2019/2017/2016/2012.

●Proficiency in creating different types of Reports such as Cross-Tab, Drill-down, Summary, Parameterized, Sub reports and formatting them using SSRS.

●Worked in a Data Warehouse environment on different datamarts and designed different stable ETL processes to maintain Historical Data in the data warehouse.

●Strong Knowledge in Enhancing and Deploying the SSIS Packages from Development Server to Production Server.

●Highly proficient in the use of SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models and data integrity, SQL joins and query writing.

●Used multi-dimensional and tabular design to provide a semantic layer and capabilities on top of the Data Warehouse

●Good knowledge of the Hadoop ecosystem and its components with in-depth knowledge of Hive (data analysis tool), Sqoop (a data loading tool) and Edge Node

●Experience of working with Azure data factory and Azure SQL server.

●Excellent experience in Designing, Maintaining and tuning various RDBMS using T-SQL & MS SQL Server 2019/2017/2016/2012/2008R2/2005 and MS Access databases.

●Experience in Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, DB2 to MS SQL Server by using Import Export Wizard, DTS SSIS pacakges, BCP & Bulk Insert utilities

●Extensive experience building data pipelines and efficient automated ETL/ELT solutions.

●Experience in transforming unstructured data from various data sources using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for cleaning bad data, validating data.

●Created SSIS packages using package logging, Breakpoints, Checkpoints and Event handling to fix the errors.

●Designed and Build the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).

●Solid knowledge and experience in migrating DTS packages, reports and analysis services projects from SQL Server 2012 to SQL Server 2017 and 2019.

●Hands on experience in implementing Key Performance Indicator (KPI) Objects in SSAS.

●Highly experienced in database server performance tuning and optimization of Complex SQL queries with encryption.

●Complete knowledge in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server Performance.

●Accomplished in creating Packages, scheduling Jobs and sending Alerts using SQL Mail.

●Experience working on Python in creating and automating data import from an API end and other sources to SQL Server.

●Designed an automated Process using Python to extract and export data from SQL Server to FTP folder using different file formats.

●Performed end-to-end development, testing and implementation of SQL and PL/SQL (Oracle)

●Extensive experience in Capacity Planning, Disaster Recovery, Troubleshooting, Backup and Restore procedures

●Good Knowledge in designing Database Models using UML, MS Visio and Erwin.

●An excellent team player & technically strong person who has capability to work with business users, project managers, team leads and architects, with ability to develop creative solutions for challenging client needs using agile methodologies.

●Flexible and versatile to adapt to any new environment and work on any project.

Tools and Technologies:

RDBMS: SQL Server 2008R2 - 2019, Teradata, DB2, Oracle, MS Access

Database Tools: SSIS, SSAS, SSRS, Toad Data Point 4, SAS, Datastage, Crystal Report

Cloud Ecosystems and Components: Microsoft Azure, AWS, Hadoop, Hive, Sqoop

Languages: VB.NET, C#, .NET Core, C++, T-SQL, VB Script, Python, Spark

WebAPI: RESTful (JSON/XML), SOAP

Security: OAuth 2.0 and JSON Web Token

IDE: Visual Studio 2003-2019, Eclipse, MS Office, MS Project 2013, Visual Studio Code

Operating Systems: UNIX, Windows

Code versioning tools: GitHub, BitBucket, TFS, Azure DevOps

Case Tools: MS Visio, Erwin

Methodology: Agile, DevOps (CI/CD), Waterfall

Professional Experience:

CareFirst BlueCross BlueShield, Baltimore, MD Oct, 2021 – Till Date

Senior SQL Developer/MSBI/Data Warehouse Developer (T-SQL/SSIS)

Responsibilities:

●Wrote complex Stored Procedures, Views, Triggers and Functions to implement business rules using SQL Server 2019.

●Created a stable & efficient T-SQL Queries that assures data quality, data consistency and data accuracy to meet the business requirement expectations.

●Worked on data warehouse development lifecycle (end-to-end) from design level to deployment to the production server.

●Designed complex SSIS packages to migrate data from different data sources to data warehouse by applying various data transformations like Aggregate, Sort, Multicasting, Conditional Split and Derived column.

●Meet with clients and managements to understand and clarify requirements and needs.

●Wrote C# code for Script task to perform functions that are not available in the built-in tasks and transformations that SSIS provides.

●Successfully integrated and synchronized data from different data source to the data warehouse.

●Used various SSIS tasks for data validation checks during Staging, before loading the data into the Data warehouse.

●Created ETL packages with different data sources (SQL Server, Flat files, Excel source files, Oracle) and loaded the data into target tables by performing different kinds of transformations using SSIS.

●Improved the existing SSIS package’s performance by adding and removing flow transformations and by tuning the SQL scripts the package uses.

●Performance tune the existing queries (specifically stored procedures) and significantly reduced the amount of resources used to process a query.

●Involved in scheduling SSIS packages for running AM and PM feeds from various departments and multiple servers and resources to Development Servers.

●Logged various packages as well as individual tasks using SQL server log providers like text file, SQL server database, trace file, xml file.

●Import XML Data into SQL Server using T-SQL and OPENROWSET to read the XML data

●Extracted data from heterogeneous sources and transferred to OLAP using SQL Server Integration Services (SSIS)

●Created Alerts for successful or unsuccessful completion of scheduled Jobs.

●Responsible for database tuning using normalization and application tuning.

●Create and use execution plans and statistic to help estimate the costs of retrieving data for a specific query plan

●Worked entirely in SDLC environment composed of different agile teams.

Herbalife, Los Angeles, CA Nov, 2017 – Sep, 2021

SQL Developer/ ETL Developer (SSIS)

Responsibilities:

●Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)

●Designed and created the Dimensions and Facts with star schema using SQL Server Analysis Services (SSAS) for OLAP

●Implemented multi-dimensional and tabular design patterns models

●Worked on facts, dimensions, attributes, and attribute hierarchies that were created used star schema for schema development

●Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.

●Design, build, and maintain efficient, reusable, and reliable C# code to be used in SSIS Script task

●Updated functional specification and technical design documents.

●Developed reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.

●Involved with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.

●Performed Data modelling and Developed logical and physical model using Erwin and implementing them to SQL server.

●Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2005.

●Worked on Oracle PL/SQL environment to develop and test a new metrics inclusion as per business requirement.

●Created different ETL Processes using SSIS to load data into Data Warehouse from different data sources.

●Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.

●Worked on Hadoop ecosystem to migrate data from SQL Server 2016 to HDFS.

●Ingested data from different data sources to Hadoop using Sqoop.

●Built simple to complex pipelines & dataflows using Azure Data Factory and Azure SQL DB

●Worked on UNIX environment and adapted different shell script commands that are necessary to work with files in the Hadoop cluster.

●Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).

J.P. Morgan Chase, San Mateo, CA Apr, 2014 – Oct, 2017

SQL Developer (TSQL/SSIS/Python) / Data Engineer

Responsibilities:

●Wrote PL/SQL Stored Procedures, Functions, and Packages to implement Business Rules.

●Created reports to retrieve data using database code objects, such as Stored Procedures, views, functions and multiple T-SQL queries.

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

●Wrote a scalable code in Python to extract and load data from an API end to SQL Server

●Created an automated ETL process using Python that extract and export data from SQL Server to

FTP folder.

●Developed SSIS package to load data into dimensions and fact tables using slowly changing dimension.

●Worked on developing Complex SSIS Packages to load data into Staging, ODS, and Data Warehouse systems.

●Developed SSIS packages using Lookup Transformations, Merge Joins, Fuzzy Look Ups, and Derived Columns with Multiple Data Flow tasks.

●Involved with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.

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

●Agile methodology was used throughout the project, Performed pivotal role in planning and developing as well as aligning with the assigned sprints.

●Developed logical and physical model using Erwin and implemented them in to SQL server.

●Used Execution Planer and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases

●Responsible for performance tuning, optimizing the queries, removing redundant and inconsistent data, joins from the database tables and normalizing them.

●Enhanced the old logical and physical database design to fit new business requirement, and implemented new design into SQL Server 2012

●Used Team Foundation Server (TFS) to provide a set of collaboration tools that work with the existing IDE or editor, to work effectively on the project.

●Worked with Workday team to assists human resources and financial requirements of the organizations for associates data

●Worked with business users and stakeholders to gather or refine requirements.

UNHCR-ARRA, Addis Ababa, Ethiopia Jan, 2013 – Mar, 2014

SQL Developer / ETL Developer

Responsibilities:

●Requirements gathering, Analysis and Design of all the requirements.

●Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.

●Created SSIS packages using various data transformations like fuzzy lookup and derived column transformation to migrate the old database, activities and other important data.

●Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases. Involved in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using SSIS services

●Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.

●Made various report parameters and query parameters to create parameterized reports using SSRS 2008.

●Designed, coded and implemented ad hoc reports using existing report models in SSRS.

●Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports using Variables, Expressions and Functions for the reports using SSRS.

●I Optimized SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

●Involved in testing, bug fixing and documentation for the project.

Education & Certification

●BSc in Computer Science (2006)

●Project Management Certificate

●Microsoft Certified Professional

Contact this candidate