Ruth B Email & Phone Number

Hyattsville, MD, US

• Gathered and documented project requirements from stakeholders and translated them into functional and non-functional specifications for BI reports and applications and transformed them into deliverable solutions.
• Participated in data mapping process, figuring out and documenting meanings of columns and tables as well as relationships among them.
• Responsible for extracting data from internal and external resources using T-SQL and PL/SQL based on business requirements such as Stored Procedures, User Defined Functions (UDFs) and Views
• Tuned the performance of query statements by analyzing execution plans and logs/statistics in SQL Server Profiler/Database Engine Tuning Advisor
• Designed and developed ETL packages to realize full loading and incremental loading to convert and migrate data, transform data using lookup, merge joins, derived columns, and built the target data warehouse and data.
• Involved in designing ETL packages using breakpoints and analyzing progress to catch error information by SQL command in SSIS that sends an e-mail message when an error or a warning occurs or when a task fails.

• Gathered, analyzed, classified, and documented project requirements from BI analysts and directors and completed data mapping process, related to claim history, property value, three financial sheets, etc.
• Used T-SQL to create database objects based on business specifications such as stored procedures, user-defined functions, and views in SSMS.
• Involved in building Data Warehouse based on Star Schema and Data Marts
• Developed ETL packages in SSIS to import data on a weekly basis from the OLTP system to the landing zone in the staging area and migrate it to Data Warehouse and data marts.
• Performed incremental loading tasks to migrate the data from heterogeneous sources to Data Warehouses and Data Marts as well as implementing the slowing changing dimension to protect or discard historical data based on.
• Cleaned and validated the data in the staging area, corrected and unified the format, handled the missing values, transformed the data, and split or combined columns based on specifications.