We provide IT Staff Augmentation Services!

Sr. Etl Qa Analyst Resume

Hartford, CT

SUMMARY:

  • With 8 years of Professional Experience in Software Quality Assurance and Testing in different environments and platforms. Data warehouse experience with ETL - Informatica and BO report testing. Extensive experience in reviewing Business Requirement Documents, Software Requirement Documents and preparing Test Cases, Test scripts and Execution.
  • Good Experience with Test Management and Defect tracking tools Mercury Test Director/HP Quality Center and Rational Clear Quest.
  • Great interpersonal and communication skills; strong leadership; experience in engaging audiences in all levels.
  • Strong in Manual Testing, Automated testing in Visual Basic & other protocol of automation tools Experience in testing applications under. Net, Windows.
  • Experience in Functional Testing, Integration Testing, GUI Testing, Regression Testing, Smoke testing, Test Data Management, Ad-hoc testing and System Testing and UAT.
  • Knowledge of Test Data Management using IBM Optim.
  • Experience in testing Data Marts, Data Warehouse/ETL Applications developed in Informatica, Ab Initio and Data stage using Oracle, DB2, Teradata and UNIX.
  • Strong experience in testing Data Warehouse (ETL) and Business Intelligence (BI) applications.
  • Knowledge of Data Warehouse concepts, applications, and ETL tools
  • Experience in Black Box testing, which includes System Testing, Functional testing and Regression Testing, GUI Testing
  • Expertise in developing test cases for ETL processes.
  • Strong experience with MDM skills that comprises data profiling, data dictionary, updating views and data consistencies.
  • Experience in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
  • Knowledge in Analysis of Bug Severity, Bug Tracking system and Bug Reporting.
  • Solid understanding of Master Data Management (MDM) and Pharmaceutical related Customer, Product and Identity data.
  • Experience in Functional testing, Integration/System testing, Regression testing
  • Well versed in GUI application testing, Database testing and Front-end testing.
  • Very good knowledge of databases like Oracle and SQL server. And also proficient in database testing on UNIX and Windows environment by writing complicated PL/SQL queries.
  • Expertise in developing test cases for ETL processes.
  • Experience in analyzing Business Requirement Document (BRD), Functional Requirement Specification (FRS).
  • Experienced in Design and Execution of Test criteria from requirements.
  • Proficient in RDBMS like Oracle, MS-Access on Windows, UNIX platforms.
  • Involved in Planning and Translation of Software Business Requirements into test conditions, execution of all types of tests.
  • Expertise in working with Quality Center to store Business Requirements, Test Cases, Test Runs, and Test Results for every iteration and to store defects and link them back to the requirements.
  • Analysis requirements and developing as well as executing test cases for ETL
  • Excellent logical skills for understanding system workflows, computing and verifying Software Metrics and well suited for communicating with both technical and non-technical professionals.
  • Understanding & Experience of Data warehouse applications.
  • Highly adaptive to a team environment and proven ability to work in a fast paced teaming environment with excellent communication skills.

TECHNICAL SKILLS:

Languages: PL/SQL, SQL, Java, C, C++, .NET.

ETL Tools: Informatica Power Center/Power Mart

BI Tools: Business Objects XIr2, Cognos

Operating Systems: Windows NT, Windows, UNIX

RDBMS: Oracle, MS SQL Server, DB2

Testing Tools: Quality center, Rational Clear Quest

PROFESSIONAL EXPERIENCE:

Confidential

Sr. ETL QA Analyst

Responsibilities:

  • Managed and lead a process improvement initiative that identified, reengineered and documented of all service-related processes in the Technology Division.
  • Conducted Automation/manual testing using the Standards,guidelines and structured methodology in testing the application.
  • Worked with Data Completeness, Data Transformation, Data Quality, Integration, UAT testing and Regression testing for ETL and BI group.
  • Tested the ETL Ab Initio Graphs and other ETL Processes (Data Warehouse Testing)
  • Tested ETL Packages, Scripts from development to QA environment.
  • Created a detailed Test Plan, Test strategy, Test Data Management Plan, Test Summary Report based on Business requirements specifications.
  • Responsible for the full HIPAA compliance lifecycle from gap analysis, mapping, implementation and testing for processing of Medicare/Medicaid Claims.
  • Prepare test data; execute test cases; log defects and assign the criticality of defects based on QA standards.
  • Written complex SQL queries to validate the ETL transformation rules .
  • Worked with SQL queries using MS Access for data manipulations. built the foundation for process implementation in MS-SQL.
  • Create and maintain data model/architecture standards, including master data management (MDM)
  • Responsible for preparing EDI (Electronic Data Interchange) test files for Enrollment and Exchange according to 834 HIPAA Implementation guide Using Foresight EDISI and Ultra Edit.
  • Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
  • Used Query Analyzer, Execution Plan to optimize SQL Queries.
  • Used TOAD, DB Artisan tools to connect to Oracle database to validate the data that was populated by ETL applications.
  • Involved in test case design, execution, test data preparation, Test data management, defect process and cutover process.
  • Define Strategy and planning for Datawarehouse Testing and Test Data Management.
  • Worked on profiling the data for understanding the data and ETL mapping document.
  • Developed SQL scripts and wrote stored procedures to validate the flow of data from Legacy source to target application database and ability to perform data validation (of ETL processes, schema and DDL check, data flow from data warehouse to application databases, data marts, return marts, referential data, repositories).
  • Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
  • Executed Test Cases Manually, once the application is stable and documented the successful or unsuccessful completion of each test case in HP Quality Center (QC) for End-to-End Scenario based testing.
  • Understanding SDLC and the functionality of different types of applications from the Use Cases. Manual Testing across all Projects.
  • Authored test plans and test suites, implemented testing through HP Quality Center and assisted in debug of the SQL database by writing and executing scripts in Aqua Data Studio.
  • Used wildcards, order by, group by functions using SQL for backend testing.
  • Performed Black Box testing and conducted Functionality and Regression testing on various phases of the Management software
  • Created automated Load test scripts using Load Runner.
  • Conducted GUI and functionality testing using QTP.
  • Performed User Acceptance Testing (UAT) for various web based and database related applications.
  • Developed Test cases for manual testing and automated them using Win Runner, Silk, Load Runner, Silk performer and QTP.
  • Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
  • Extensively worked in designing the Testing approach for the ETL process in the Credit Data Provisioning Enterprise Data Warehouse (CDP).
  • Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
  • Reports generated for various departments like Tele Marketing, Mailing, New Accounts by using SQL, MS Access, Unix
  • Ad-hoc reports developed using Oracle, SQL, and UNIX.
  • Participated in status and defect tracking meetings and responsible for maintaining bug log
  • Written Complex SQL Queries to Check the data loads in Different Stages
  • Participated testing in ETL mappings/Jobs, based on the customer requests for Siebel Analytics.
  • Performed Positive & Negative Testing.
  • Tracked defect in the central defect tracking tool JIRA
  • Tested the data loads from and to various environments.
  • Performed Data testing, Transformation testing, Business rules and Data quality

Environment: Informatica, HP-UNIX, Business Objects, IBM,Oracle, Quality Center, TOAD, Appworx, FTP.

Confidential, Hartford, CT

ETL QA Tester

Responsibilities:

  • Involved in both Manual and Performance testing of the application.
  • Performed Requirements Verification Testing, Unit Testing, Functional Testing, Security Testing, Regression Testing, Positive, Negative testing, Post Production testing and End to end Testing of ETL code and reports.
  • Used Agile Process for developing the application.
  • Responsible for creating test scenarios, scripting test cases using testing tool and defect management for Policy Management Systems, Payables/Receivables and Claims processing.
  • Ensured that all the required documents are provided and prepared Test Plans and Test Cases and executed Test Scripts.
  • Involved in validating the ETL mappings from various systems (CRM, OLTP) to transaction history/reporting database.
  • Interacted with Solutions analysts, system staff, ETL developers and the data load staff.
  • Written and executed Test Scripts manually.
  • Extensively worked with QA team to review test cases, prepare test plans, test data management.
  • Lead & participated in daily Defect Triage meetings involving development teams, testing teams, testdata Management teams, Clients and business.
  • Used Master data management (MDM) to define reference data.
  • Involved in moving the workflows from Dev Environment to QA Environment
  • Facilitated meetings with business users, Project Managers, and IT personnel.
  • Tracking Change controls.
  • Carried out ETL Testing using Informatica and PL/SQL.
  • Test Data Management,
  • Worked with test data management team to get the required data prior to the execution of any project.
  • Created the test data for interpreting positive/negative results during functional testing.
  • Designs and directs the preparation of test data; prepares test data, documents detailed results, provides regular and ad-hoc test reports.
  • Performed extensive Testing on data modelling to differentiate between the OLTP and Data Warehouse data models.
  • Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
  • Performed troubleshooting and tracking defects using Jira.
  • Status reporting to Business/QA managers/Dev managers and defect management
  • Execution of Test cases.
  • Familiar with Informatica Designer, Workflow Manager, Workflow Monitor & Mappings
  • Configuration Management for version control of deliverable test artifacts and project documents using Perforce
  • Involved in loading the requirements, test plan into Quality center, moving Test cases to Test Lab mapping requirement to test cases.
  • Experience in running test cases using Quality center and updating test results
  • Involved in logging defects and mapping them to test cases using Quality Center

Environment: Informatica , HP-UNIX, IBM,Business Objects, Oracle, TOAD, Appworx, FTP.

Confidential, Hartford, CT

QA Analyst

Responsibilities:

  • Analyzed the Business Requirements and Functional Specs for developing Test Plan and Test Strategy
  • Conducted Test plan reviews, Test case reviews.
  • I was involved in the clinical data management system (CDMS) to manage the data of a clinical trial and medical writing.
  • Participated as a core team member of a Clinical Development initiative to create an architectural business end-to-end solution for clinical trials as a standard for all remote data capturing clinical trials.
  • Create and maintain data model/architecture standards, including master data management (MDM)
  • Worked on traceability matrix to map Test cases against Requirements using Quality Center.
  • Validated ETL DW load statistics and Data mart Loads on an Ongoing Basis.
  • Experience in Claims Processing per Medicaid Management Information Systems (MMIS) 42 CFR 433.
  • Responsible for Medicaid Claims Resolution/Reimbursement for state health plans using MMIS.
  • Validated Source - Target mappings applying various transformation rules and Business Rules.
  • Worked on Data balancing of measures
  • Validated Adhoc Reports, OLAP Reports for Data Accuracy.
  • Worked in creating scenarios for row count validations in EDW.
  • Created test sets based on scenarios to validate EDW.
  • Participated in Defect Review, Actuarial Review meetings periodically
  • Test management is done using HP Quality Center.
  • Validated Cubes, Adhoc Reports and Standard Reports built from Cognos.
  • Working Experience with Agile Development Methodology.
Confidential, Minneapolis, MN

QA Analyst

Responsibilities:

  • Involved in designing Test plan and Test Cases.
  • Conducted manual testing
  • Test and verify the proper operation of hardware and operating system software, that the operating procedures and staff could successfully execute the application (Sequence testing & Compatibility Testing).
  • Conducted GUI and Security testing during the various phases of the development.
  • Mainly included Functionality testing, Data Validation, Boundary Testing, Backup testing, print testing, Reports, Acceptance Testing, Regression Testing and Error handling and security.
  • Executed SQL queries to verify the flow of data between back end and front end.
  • Involved in conducting the Regression tests for reported bugs to test whether the fix has been applied or not and to test whether the caused another problem or not.
  • Monitoring the defect tracking process, trouble shooting and generating customized graphs and reports. Reported Bugs to the development team using Test Director.
  • Involved in Functionality, Black box, Integration and System Testing.

Hire Now