We provide IT Staff Augmentation Services!

Etl Qa Analyst Resume

Eden Prairie, MN

PROFESSIONAL SUMMARY:

  • Over 7 years of IT experience in Analysis and Testing of Business Intelligence solutions using Conversion Data, Data Warehouse/Data Mart Design, Manual, ETL, OLAP, Client/Server applications.
  • Good understanding concepts on Business Intelligence and Informatica Power Center 8.X/7.3 using Repository Manager, Designer, Workflow Manager and Workflow Monitor .
  • Worked on various Domains like E-Commerce, Health Care Insurance, Supply Chain, Investments and Pharmacy
  • Expertise in writing SQL Queries using Oracle, SQL Server and Teradata in validating data into Data Warehouse/ETL applications.
  • Strong working experience in the Data Analysis, Data Verification and Validation of an ETL Applications using Backend/Database Testing.
  • Experience with working tools like TOAD 10.0, MS SQL Server Management studio, Win SQL for creating and executing SQL Queries.
  • Experienced in complete Software Development Life Cycle(SDLC), Software Testing Life Cycle (STLC) and Bug Life Cycle.
  • Extensive experience in Black Box Testing Functional Testing, Integration Testing, System Testing, Regression Testing, Performance Testing on Warehouse Applications.
  • Expertise in OLTP/OLAP System Study, Slowly Changing Dimensions types (SCD'S) Analysis and E-R modeling, developing Database Schemas like Star flake schema and Snowflake schema used in relational, dimensional and multidimensional modeling
  • Involved in preparation of Test Plans, Test Cases based on High level requirements and make an ensure detailed/system level process wrote Test Scripts
  • Involved in preparation of Test Data to test the functionality of ETLSources Mappings and Targets.
  • Worked under testing methodologies like Agile-SCRUM and Waterfall Model.
  • Proficient in warehouse designs based on Ralph Kimball (Bottom-Up) and Bill Inman (Top-Down) methodologies.
  • Involved in testing of Business Objects reports by executing the SQL Scripts.
  • Expertise in Defect management, Bug tracking, Bug Reports and generating the graphs using Test Management Toolssuch as Quality Center, MS Visual Studio & TFS (Team Foundation Server).
  • Involved in preparation of Traceability Matrix based on High/Detail requirements and Test Cases.
  • Experience in maintaining support documents, QA Sign off Documents and maintaining Weekly Status Reports.
  • Familiar with PL/SQL Coding, Normalized Database creation in relational databases like Oracle 8i/9i, MS-SQL Server 2000 and optimizing the SQL to improve the performance.

PROFESSIONAL EXPERIENCE:

Confidential, Eden Prairie, MN Feb'11 - Till Date ETL QA Analyst Digital River a leading provider of global e-commerce services with a vision to use the internet instead of mail to deliver the software which is more efficient, more cost effective. This helps clients aggressively pursue online shoppers, market their products and win sales. Blue Hornet Email Engine, Sales Order Processing, and Global Direct (RegNow, SWReg, Mind vision) are different platforms of DR by which a client will upload their software to a repository of software available for affiliates to Market Client digital products and implementing ETL/DWH process of loading Client source data into respective target Sales Data (ERP) systems and Non Financial Data (EDW) systems for generating Reports and Dashboards to end-user.

Responsibilities:

  • 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.
  • Used TOAD for Oracle in creating & executing SQL queries for testingETL process.
  • Tested Full load & Incremental load by entering the sample test data to couple of entities and making sure Inserts & Updates of loading the data is done correctly.
  • Validated Type II SCD for loading current and history of Sale, Fraud Chargeback Reversal, and Chargeback Reversal in placing old and new Order_id's based on Commerce_Platform_ID.
  • Used Quality Center 10.0 as test management tool to manage and organize Requirements Coverage, Test Cases, Test Scripts and Creation of defects.
  • Followed Defect management life cycle and raised the defects based on priority and severity level in QC.
  • Performed Functional, Negative, Smoke & Regression tests as per design specs.
  • Prepared Traceability Matrix for each entity and marking down Test requirement, Test Head line, Actual result & Expected result.
  • Implemented Iterative and Incremental Agile - Scrum Methodology for rapidly changing or highly emergent requirements and following parallel development and testing.

Environment: Informatica 8.6, OBIEE, Oracle 10, TOAD for Oracle, Quality Center 10.0, MS Excel and Windows XP.

Confidential, Eden Prairie, MN June'09 - Feb'11 Data Conversion/ETL QA Analyst Univita Health leads in outsourced services to LTC insurance industry. It is largest long term care administrator providing services to, over 30 long term care insurers which offers assisted living, Adult Day care, Nursing home. The company offers comprehensive policy administration including Account Setup, Claims, Coverage Administration, Application processing, Premium Billing (FMS), Customer Service, Commissions, Underwriting. Univita successfully completed the Conversion & Data Ware Housing ETL process of 12,500 active LTC Claims & Converge Administration for the Senior Health Insurance Company of Pennsylvania("SHIP") & "CNO Health "insurances to its LTCAS administrative platform.

Responsibilities:

  • 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.
  • 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 Head line, Actual result & Expected result.
  • Implemented Agile - Scrum Methodology for frequent changes to client requirements and following parallel development and testing.
  • Followed Defect management life cycle and raised the defects based on priority and severity level on TFS.

Environment: Informatica, SQL Server 2008, MS SQL Server Management studio, TFS, MS Visual Studio, SSRS, MS Excel and Windows XP.

Confidential, Phoenix, AZ Oct'08-Apr'09 ETL Tester The purpose of this project is to retire the MLISDW from "QUE" server as part of the Sybase obsolescence initiative. All the functionality provided by the MLISDW will be migrated to the Supply Chain Data Warehouse (SCDW). Currently, the customers use the data from MLISDW and build their own MS Access reports. This functionality will be replaced by Micro Strategy in SCDW. SCDW is an Oracle database with Micro Strategy as the reporting tool.

Responsibilities:

  • 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

Environment: Sagent, Micro Strategy, MS Access, Sybase, Sql server 2005, Oracle 9i, Win SQL, Mercury Quality Center, MS Excel and Windows XP.

Confidential, OH Aug'07-Aug'08 ETL QA Analyst Nationwide Insurance have wide variety of services like Loans, Financial Income, Home loans, Automobile loans etc, and is wide spread all over the nation with 2600 branches. The Marketing Agent is the current application, sales which provides access to corporate published opportunities and service events. My role involved as QA developer for the loans data mart which is developed using Informatica.

Responsibilities:

  • 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.

Environment: Informatica Power Center 8.6, Oracle 9i, Teradata, SQL Assistant, Excel, Quality Center 9.0,UNIX, Windows 2000

Confidential, Seattle, WA Jan'06-June'07 ETL QA Analyst Adaptis Inc. is the second-largest distributor of pharmaceuticals and other medical supplies and equipment in the US. This process transforms company production strategy. The data warehouse provides a central data repository to store the data related to sales, inventory and transit of the medical supplies at weekly and daily granular level. Data from different systems such as PRMS, MFG-Pro, JD Edwards to the data warehouse which accessed by the user utilizing Informatica.

Responsibilities:

  • Participated in walkthroughs of requirements, specifications, database designs, ETL code, and test strategies
  • Developed testing environment and supported the data loads into the Management System with Informatica.
  • Maintained and executed Change Promotion Requests from DEV to PROD and TEST environments.
  • Coordinated and maintained Test Environment UNIX Directories to keep them in Sync with Production.
  • Created Test cases by taking input from Business Analysts and Technical Manager.
  • Involved in Testing the Sales, Inventory, Customer Market Ranking, Transit Targeting and Visibility Packages.
  • Independently designed and executed Test Scripts for Targeted Promotions.
  • Validated the Target data with reference to the requirement documents.
  • Responsible for supporting and mentoring other testers in the team.
  • Designed and Developed data validation, load processes and test cases using PL/SQL, SQL.
  • Used TOAD Software for Querying ORACLE and Used WinSQL for Querying DB2.
  • Conducted Integration, Regression and Functionality testing and investigated software bugs.
  • Performed Back-end testing using SQL.
  • Tested Informatica mappings and also tuned them for better performance and implemented various Performance and Tuning techniques.
  • Executed Informatica Workflows individually and validated the data.
  • Calculated feed processing times stage-by-stage and reported to Manager.
  • Validated the Target data with reference to the requirement documents.
  • Extensively interacted with the developers and users to resolve technical issues and tracked defects.
  • Prepared manpower estimates for QA activities and prepared status reports reflecting current and projected workloads.
  • Assigned QA tasks and scheduled status meetings.
  • Attended project meetings and release meetings to represent QA Team.
  • Worked with software testing methodologies with all phases and stages of testing desired (Functional, System, Integration, Regression, Data Validation, User Acceptance (UAT)).

Environment: SSIS, BO 6.5, Teradata, Oracle, Test Director, UNIX, and Windows2000.

Confidential, INDIA Aug'05-Jan'06 Database Application Developer Sierra Atlantic consulting services and business process outsourcing organizations. The purpose of the project was to computerize the existing manual operation of the State treasuries in India. The project implemented the logic to decide the operation on the trades sent by the client by looking at their positions.

Responsibilities:

  • Participated in requirement gathering and design phase
  • Worked extensively in Oracle and PL/SQL creating objects like tables, views, synonyms, Triggers, Stored Procedures, Functions and Packages.
  • Compiled, tested and debugged stored procedures, functions, triggers and packages in PL /SQL to implement business logic and to enhance modularity, reusability and serviceability for maintenance of the application.
  • Programmed largely in SQL to generate the necessary reports
  • Created front end applications using forms and reports
  • Handled alerting mechanisms, system utilization issues, performance statistics, capacity planning, integrity monitoring, population, maintenance, reorganization, security, and recovery of databases
  • Created template documents with header, footer and company logo.

Environment: Oracle8i (PL/SQL, SQL Plus), Forms 4.5, Reports 2.5, Unix/Windows NT

Confidential, INDIA Jan'05-June'05 Hand Held Computers - This project concentrated mainly on billing at consumer door steps for services like Electricity, Water supply, Gas from government or private sectors.

Responsibilities:

  • Created database objects for the system like tables, views, sequences, functions, synonyms, indexes, triggers, packages and stored procedures
  • Developed Front-end forms depending upon the logic such as Master-detail form and complex forms for the application.
  • Loaded data into various tables from Access database as well as from Excel Spreadsheets using SQL*Loader.
  • Developed stored procedures, packages and functions for the application that could be called by Forms & Reports.
  • Developed complex tabular reports for the systems using running totals, sub totals, grand totals and daily balance.
  • Developed new Data Input forms and Reports using Oracle Forms and Reports builder.
  • Written scripts to create Temporary tables various schemas and Audit Transactions.
  • Wrote SQL, PLSQL, SQL*Plus programs required to retrieve data from the Data repository using cursors and exception handling.

Environment: Oracle8i, Forms 4.5 and Reports 2.5, SQL, SQL*Plus, PL/SQL, SQL*Loader, Toad, Windows 2000.

Hire Now