• Worked with Business /Technical Analyst in analysis of functional design specifications of ETL/Data warehouse applications of Global Direct , Sales Order Processing and Blue Hornet Email for Microsoft & Adobe clients• Analyzed Source to Stage and Stage to Target mapping document based on Facts & Dimensions and validating the DDL, Counts, Not Nulls, Duplicates, PK & FK validation, business rules to be applied on target tables.• Tested loading of Source Commerce data (Catalogs/Products, Sites & Companies, Sales Transactions, Invoice, Orders, Payments, Returns, Shipments, Offers etc) to ERP & EDW target Oracle systems.• Involved in creation of Test Plans, Test Cases, and Test Execution based on mapping specs to validate the platform data.

• Worked with Business Analysts understanding and analysis of design specifications for conversion and ETL of Coverage Administration Module for CNO & SHIP carriers.• Analysis of ETL Mappings based on Facts & Dimensions from Source to target tables for directs moves and indirect moves based on transformation rules & lookup tables.• Used MS SQL server Management studio for Creating & executing SQL queries for testing the conversion & ETL process.• Tested Full load & Incremental load by entering the sample test data to couple of entities.• Validated SCD Type 2 related to Coverage Change entities based on premium increase/decrease, DOB, Benefit change.• Created Test Plans, Test cases for the related Testing tasks, Test scripts to validate the CNO design specifications.• Created SSIS packages for loading data to data warehouse databases and process SSAS cubes to store data to OLAP databases.• Performed Extraction, Transformation and Loading (ETL) data from Flat file, Excel (spread sheet), MS SQL and Oracle to MS SQL Server database by using SSIS services and BCP utility.• Validated conversion data loading from source to target for Life, Policy, Coverage, Product Setup, FMS Billing, Waiver of premium, Restoration of benefits, Commissions, Attained Age, Non- forfeiture etc...• Used MS Visual Studio & TFS (Team Foundation Server) as test management tool to manage and organize Requirements Coverage, Test Cases, Test Scripts and Defect Management.• Validating the conversion data through front-end modules like System Setup, Commissions, Coverage Administration, Customer Service, Billing & Collection, Claims Examination, Claims payment Request, Underwriting, and Kit printer.• Performed Negative, Smoke & Regression tests as per design specs.• Prepared Traceability Matrix for each entity and marking down Test requirement, Test Headline, Actual result & Expected result.

• Developed test matrix based on business requirements, functional and technical specifications and development standards for assigned applications.• Developed test cases based on test matrix including test data preparations for data completeness, Data transformations, Data quality, Performance and scalability.• Performed data quality analysis using SQL skills• Used MS Sql server Management studio for Creating & executing SQL queries for testing the conversion & ETL process.• Ensured Error logs and audit table are generated and populated properly.• Performed UAT and Regression testing.• Tested Full load & Incremental load by entering the sample test data to couple of entities.• Created Test Plans, Test cases for the related Testing tasks, Test scripts to validate the CNO design specifications.• Validating the conversion data through front-end modules like System Setup, Commissions, Coverage Administration, Customer Service, Billing & Collection, Claims Examination, Claims payment Request, Underwriting, and Kit printer.• Involved in troubleshooting, resolving and escalating data related issues and validating data to improve data quality.• Implemented Agile - Scrum Methodology for frequent changes to client requirements and following parallel development and testing.• Updating maintain existing test matrix and test cases based on code changes and enhancements to assigned applications.• Followed Defect management life cycle and raised the defects based on priority and severity level on TFS.• Extensive SQL querying on staging, data warehouse and data marts.

• Worked with Business analysts to understand High Level/System requirements in order to transform business requirements into functional specifications.• Analyzed Source to Stage and Stage to Target Mapping document indicating the source tables, columns, data types, transformations required, business rules to be applied and target tables.• Analyzing Data Processing implementing Data Mart applications mainly transformation processes using ETL tool and understanding of ETL workflows and ETL mappings and also monitoring the Production Environment.• Developed SQL queries for Back-end testing/Database testing and participated in end to end testing.• Involved in writing Test Plans, Test Cases, Test Scripts to validate the functionality and executed using WinSQL• Used MS Access and Mercury Quality Center as test management tool to manage and organize Requirements Coverage, Test Case Management, Test Execution and Defect Management.• Involved in Testing of reports by extracting the SQL generated by Micro Strategy and executed them in backend and validated them in QA and PROD environments.• Extensively interacted with the developers and users to resolve technical issues and tracked defects.• Performed Regression testing to test the impact of bug fix.• Maintained and executed Change Promotion Requests from DEV to PROD and TEST environments.• Prepared Traceability Matrix with requirements versus test cases• Experience in maintaining support documents, Test Plans, QA Sign off Documents and Maintaining Weekly Status Reports

• • Worked with Business analysts to understand requirements in order to transform business requirements into functional specifications.• Responsible for reviewing Functional specs, user documentation and use cases and developing manual test cases out of it.• Responsible for planning and directing Quality Assurance and Software change control policies.• Study and analysis of the mapping document indicating the source tables, columns, data types, transformations required, business rules to be applied, target tables, columns and data types• Tested Informatica Mappings and worked with Staging area to validate the data with Sql queries• Coordinated in setting up Test Environments and Test Plan needs with team members.• Developing various Test Scripts, Test Execution using Quality Center based on the Functional Specifications.• Executed Test Cases using positive and negative data in Quality Center's Test Lab and reported results and defects using Quality Center's Defects tool.• Involved in validating the Data mart tables as per the business logic applied to the staging tables.• Developed SQL Queries for Back-end testing/Database testing and performed end to end testing.• Executed the test scripts against Teradata source and validated the rules according to mapping documentation.• Written SQL statements manually to validate data from Teradata, Tested Entity relationship of the database.• Testing and validation of the developed Informatica mappings.• Validated the source system data with the staging data using SQL and Pl/SQL scripts.• Reached Testing Goals by doing Data Completeness, Data transformation, Data Quality, Performance and Scalability• Expertise with System Testing, Functional Testing, Regression Testing.• Prepared Traceability Matrix with requirements versus test cases.• Involved in identifying the defects and developed Defect Tracking report using Mercury Quality Centre which involved Bug life cycle.• Provided daily and weekly status reports.