SUMMARY:

• Highly experienced data quality analyst and ETL/BI testing and data modeling professional with a record of developing and supporting successful projects and solutions.
• Excel in coordinating and performing engineering design, specifications, planning and scheduling, and validation execution for large - scale projects. Excellent interpersonal skills to help foster cross-functional team partnerships.

TECHNICAL PROFICIENCIES:

ETL Tools: SSIS, Control M, Talend, IBM Data stage

Query Tools: Sql Server, Teradata SQL Assistant, Oracle Sql developer, Netezza Aginitiy work bench

Other: Teradata, Oracle, Sql Server, Netezza, DB2 HP ALM, Zephyr, Jira, Radar Micro strategy, Pentaho, Net Acumen, Business Objects SAP Power Designer, Microsoft TFS, Unix, Active Batch Admin

PROFESSIONAL EXPERIENCE:

Data Architect

Confidential, MN

• Create data models collaborating with development, technical architects and the business

• Conduct data model reviews with the development teams and technical architects
• Collaborate with the technical architects to enforce standards and conventions to ensure data model standards are maintained and support the end users.
• SAP Power Designer is the data modeling tool used for creating physical data models and effective model management of sharing and reusing model information and design for productivity improvement
• Create DDLs and maintain it in TFS
• Work with the development team to understand and decide table structures, Primary key columns and indexes, data types, nulls and not nulls and relationships
• Provide BestBuy legal team with customer, order, purchase, sales, return, payment information

Lead Data Quality

Confidential, MN

Responsibilities:

• Performed complete data quality validations to ensure business accuracy using SQL Server Management Studio and Aginitiy Workbench Sql tools

• Applied data quality dimensions and principles to validations and data analysis
• Successfully determine the solution to SSIS Packages, production issues, determine root cause analysis and fix the issues and verified the code in lower environments and deployed the changes to production
• Monitored and corrected any issues of the entire job flow plan for daily data loads and processing from source to destination for credit systems/Application via Active Batch Admin tool
• Completed data profiling analysis, understanding, defining, and implementing business needs from a business intelligence perspective
• Created SSIS package for data loads from SSIS to Netezza database, loading data from source to destination.
• Created Store Procedures to load data into SSIS and Netezza database tables
• Created Store Procedures to load data from Netezza to a file via SSIS package
• Applied business logics and transformation logics to updates and inserts, so the finance business teams were able to tie transactions amounts from source systems to destination
• Developed data quality monitors to identify issues and help the business identify shortcomings
• Collaborated to create Collection dashboard to help the business identify, analyze, plan and forecast customer contact information and the best possible way to contact the customers
• Work with the team to analyze the technical and data issues and investigate data for accuracy and business consumption
• Analyzed and updated source to target mappings to ensure accurate based on business needs

Senior Associate

Confidential, CA

Responsibilities:

• Analyzed ETL mappings based on edw core to semantic tables for based on transformations and logics.

• Determined, created and implemented the overall DQ testing strategy and DQ process
• Created test plan and executed test cases, validation of queries and execution walkthrough
• Interpreted data analysis, data profiling and preparation of test data including mock up scenarios
• Executed verification and validation using MySQL workbench (SQL Queries) to check the source to target mapping and the data flow as per the business needs
• Performed report test execution on Business Objects.

Senior Associate

Confidential, MO

Responsibilities:

• Analysis of design Level and requirements documents and analysis of ETL mappings, source to target tables for direct moves and indirect moves based on transformation rules and look up tables, counts, PK, FK, duplicates, referential integrity and business rules

• Created and implemented the overall testing plan and strategy, estimated, designed, developed and executed test cases
• Completed the verification and validation using Teradata SQL Assistant Tool (SQL Queries)
• Performed data warehouse files verification and validations through UNIX systems as well as report testing
• Created system documentation, approvals from the Business, and DQ sign off.

Software Engineer

Confidential, PA

Responsibilities:

• Surveyed the data migration requirements for data warehouse, Order Management system (OMS) and online stores for various retail companies within the new enterprise commerce platform

• Created and performed test execution, data verification/validation for data warehouse from legacy to the new platform, Order Management System from JDA to Sterling OMS, online store legacy to new online store
• Performed store report test execution on Pentaho and NetAccumen as well as data feeds execution to verify the data sets/result set from the data warehouse.

Team Lead/Senior Engineer/Software Engineer

Confidential

Responsibilities:

• Offshore and Onshore

• Created and implemented the overall testing plan and strategy
• Analyzed Source to landing, landing to staging and stage to target mapping documents based on validating the counts, PK, FK, duplicates, referential integrity, transformation rules and business rules
• Applied Advanced Query Tool in creating and executing SQL queries for testing ETL process and data validation
• Tested optimum load and incremental load by entering the sample test data and making sure inserts and updates of loading the data is done correctly
• Communicated with business analysts, dev teams to comprehend high level/system requirements to transform the business requirements into functional specifications
• Maintained support documents, test plans, QA sign off documents, and maintaining status report