We provide IT Staff Augmentation Services!

Etl Qa Analyst/sql Backend Tester Resume

NC

SUMMARY:

  • Over 8+ years of Professional Experience in Software Quality Assurance and Testing in different environments and platforms including Data Warehousing, Client - Server and Legacy Mainframe applications.
  • Extensive experience in reviewing Business Requirement Documents, Software Requirement Documents and preparing Test Cases, Test scripts and Execution.
  • Experience in Black box testing with a complete QA cycle - from testing, defect logging and verification of fixed bugs.
  • Tested Cognos reports to check whether they are generated as per the company standards
  • Involved in FACETS Implementation Testing, involved end to end testing of FACETS Billing, Claim Processing and Subscriber/Member module. Experience in testing Business Report developed in Business Objects XIR2.
  • Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
  • Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio and data stage tools.
  • Involved in testing the Claims application and HIPAA EDI Transactions. Also tested the integration between Claims application and other applications like Providers, Eligibility and Member Services application.
  • Used QTP to update Automation Test scripts and executed for core features of the application.
  • Excellent Communication, Analytical and Interpersonal skills. Worked with IT Operations to ensure test environment readiness.
  • Experienced in working in Agile Scrum, Agile XP, Waterfall, RUP, RAD and SDLC methodology environments.
  • Extensive experience in Functional testing, Integration/System testing, Regression testing and User Acceptance testing.
  • Well versed in GUI application testing, Database testing and Front-end testing. Experience in Financial, Banking, Brokerage, and Securities industries.
  • Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica. Experience in Dimensional Data Modeling using Star and Snow Flake Schema. Experience in testing and writing SQL and PL/SQL statements.
  • Expertise in Developing PL/SQL Packages, Stored Procedures/Functions, triggers. Solid Back End Testing experience by writing and executing SQL Queries.
  • Experience with Agile Methodology. Ability to interact with developers and product analysts regarding testing status and to maintain detailed QA documentation.
  • Extensive background in QA methodologies. Strong Problem Analysis & Resolution skills and ability to work in Multi Platform Environments like Windows and UNIX.
  • Experience in Installation and Implementing Mercury Interactive Test Suite. Has expertise in Test Case Design, Test Tool Usage, Testca Execution, and Defect Management.
  • Experience in UNIX shell scripting and configuring cron-jobs for Informatica sessions scheduling. Experience in testing XML files and validating the data loaded to staging tables.
  • Good experience in Cognos & Business Objects Reports testing. Experience in Performance Tuning of SQL and Stored Procedures.
  • Automated and scheduled the Informatica jobs using UNIX Shell Scripting. Expert knowledge in UNIXshell scripting (Korn shell/Bourne shell). Excellent analytical, programming, written and verbal communication skills.

PROFESSIONAL EXPERIENCE:

Confidential, Durham, NC

Sr. DWH ETL Tester/BI Tester

Responsibilities:

  • Involved in testing Facets, Membership, Subscriber, Letter test, Medical Plan, Dental Plan modules and Claims applications.
  • Processed Medical Claims in Facets and tested the entire testing in coordination with Business Analyst for Emdeon.
  • Extensively worked in Facets application for Adding new Members, Class Definition and processed Billing.
  • Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
  • Involved in analysis Health Care Claim Acknowledgement for HIPAA and testing the HIPAA EDI Transactions for eligibility (270, 271), claims (837, 835) and enrollment (834).
  • Developed SQL queries on DB2, SQL Server Management Studio to setup test data and review test results. Validated Test data in UWS vs. DWH.
  • Checked the Auto Work Flow Rules fired correctly for particular Disease Management (DM) Condition screening program (DB, HTN, MetX, CAD, CHF, DPN, Asthma) in Alineo and also created Programs manually for DM conditions and verified in Alineo.
  • Performed Backend Testing using SQL Server Management Studio and DB2, extensively tested several ETL jobs developed using DB2, Sybase, MS Access Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic Created and executed test cases for DataStage jobs to upload master data to repository.
  • Designed test cases in the testing tool identified in the PTP, gathered information needed to report status during the Test Status meetings. Create a test script pretest list and executed during the Verify Test Environment activity to make sure the scripts work correctly.
  • Developed checklist for infrastructure for what the testers expects to be delivered before testing can begin.
  • Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
  • Creating, consolidating and executing SIT Test Cases and UAT test Cases using MS Excel and Quality Center Proficient as Lead role in most of the project analyzing business specification documents, developing test plans and communicating via Bug tracking systems.
  • Involved in testing the Cognos reports by writing complex SQL queries
  • Involved in testing HIPAA EDI Transactions and also tested the integration between Claims application, Providers, Eligibility and Member Services applications.
  • Identified a pre-condition, a post condition and the expected results for the requirements matrix.
  • Defined the pre-condition with scenario data needed during the Prepare Test Data activities. Ensured that all Test Cases included a Test Specification Technique chosen from the Test Specification Techniques Job Aide.
  • Developed traceability matrix between the test case and the requirements. Updated the Test Cases listed in the Test Cases column of the Requirements Matrix with any changes, additions or deletions of Test Cases
  • Breaking down the requirements to user & technical requirements for creating test cases/use cases. Worked with business team to test the Crystal Reports.
  • Performed data analysis and data profiling using DB2, Sybase, MS Access for extraction, transformation and loading process.
  • Prepared status summary reports with details of executed, passed and failed test cases. Interacted with developers, Business & Management Teams and End Users.
  • Queried databases using SQL queries in SQL Server Management Studio to validate the data loaded into target tables.
  • Tested the outgoing links from all the web pages from specific domain.
  • Executing both Functional and Regression test cases for Provider, Group, Subscriber/Family, member and Billing.
  • Involved in CMS FFM and SHOP End to End testing. Worked on DROOLS process for Letter Testing.
  • Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted and validating Crystal Reports
  • Preparing sample Test Data and executing Test cases using MS Excel and sometimes in TFS and MTM. Logging & re-testing defects in Daptiv and assigning them to the developers/BSA/responsible persons. Preparing dashboard reports on a weekly basis using Internal Reporting Method.
  • Preparing sample test data for UAT and assisting end users during User Acceptance testing. Conducting and participating Peer review meetings, Weekly project and Test Team meetings.
  • Responsible for Business analysis and requirements gathering and coordinating testing throughout both systems ODS and EDW which were two different teams.
  • Written test cases to test the application manually in Quality Center and automated using TFS and MTM. Developed automated test scripts from manual test cases for Regression testing based on the requirement documents using MTM.
  • Worked in AGILE Methodology. Involved in Integrating and Functional System Testing for the entire Data Warehousing Application. Tested slides for data flow and process flows using PowerPoint and Microsoft Visio.
  • Involved in HIPAA/EDI Medical Claims Analysis, Design, Implementation and Documentation.
  • Implemented and maintained tools required to support data warehouse testing. Performed all aspects of verification, validation including functional, structural, regression, load and system testing

Environment: DataStage, DB2, Sybase, Facets, Cognos 8.0 Series, MS Access, Agile, Alineo, Daptiv, XML, MS Office, SQL Server Management Studio, PL/SQL, Member360, Web Services, User Warehouse Interface, Transaction Manager, TFS/MTM.

Confidential,NC

Sr. DWH ETL QA Tester /Backend Tester

Responsibilities:

  • Responsible for Business analysis and requirements gathering.
  • Responsible for coordinating testing throughout both systems ODS and EDW which were two different teams.
  • Promoted Unix/Informatica application releases from development to QA and to UAT environments Worked with business team to test the reports developed in Cognos
  • Did end to end testing for SOA but delayed for system unavailability.
  • Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks. Involved in testing the HIPAA EDI Transactions for eligibility (270, 271), claims (837, 835) and enrollment (834).
  • Written test cases to test the application manually in MTM and automated using TFS Developed automated test scripts from manual test cases for Regression testing based on the requirement documents using MTM/TFS.
  • Experience in Leading the Offsite Project, managing a team of 8 Offshore and 4 Onsite consultants..
  • Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
  • Responsible for leading team and co-coordinating with offshore team. Developed data quality test plans and manually executedETL and BI test cases.
  • Worked in AGILE Methodology. Involved in testing Facets Member/Subscriber, Billing, Medical Plan, Dental Plan modules Designed and kept track of Requirement Traceability Matrix Test Lead for Defect Management and Migration in Test Management office using ALM.
  • Quality Center updates and test cases loading and writing Test Plan and executing Test Cases and printing status report for the team meetings. Involved in Integrating and Functional System Testing for the entire Data Warehousing Application.
  • Extensively used Informatica power center for extraction, transformation and loading process.
  • Used Quality Center for defect tracking. Performed data quality analysis using advanced SQL skills.
  • Tested slides for data flow and process flows using PowerPoint and Microsoft Visio Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance.
  • Involved in testing the Cognos reports by writing complex SQL queries
  • Involved in HIPAA/EDI Medical Claims Analysis, Design, Implementation and Documentation.
  • Worked as Onsite Coordinator for getting the work done from offshore team. Testing the reports and maintenance of daily, monthly and yearly.
  • Involved in Writing Detailed Level Test Documentation for reports and Universe testing. Involved in data warehouse testing by checking ETL procedures/mappings Implemented and maintained tools required to support data warehouse testing.
  • Performed the tests in both the FIT, QA and contingency/backup environments Performed all aspects of verification, validation including functional, structural, regression, load and system testing
  • Involved in testing Facets for Group Information, Enrolling Subscribers, adding members, Related Entities, Class/Plan definition, Premium Rate Tables and all.
  • Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
  • Worked on test data and completed unit testing to check all business rules and requirements are met.
  • Also tested for negative data to check that the job fails on any critical error.
  • Tested several data migration application for security, data protection and data corruption during transfer
  • Tested different master detail, summary reports, ad-hoc reports and on demand reports using Cognos Report Studio.
  • Responsible to help testing team on creating test cases to make sure the data originating from source is making into target properly in the right format. Functioned as the Onsite / Offshore coordinator and Team Lead
  • Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity. Created different user defined functions for applying appropriate business rules

Environment: Informatica 8.6.1/8.1,Quality Center 10.0, ALM, SQL, PL/SQL, Cognos 8.0 Series, MainFrame Flat Files, Facets, SOAP, SOAPUI, MTM/TFS, Web Services, Agile, Oracle 10G, DB2, TOAD9.7.

Confidential,MN

ETL QA Tester

Responsibilities:

  • Responsible for Business analysis and requirements gathering.
  • I have imparted and organized training to newcomers in the team regarding different technologies like SQL, PL/SQL and different processes. Involved in analysis Health Care Claim Acknowledgement for HIPAA Attending Client calls for Business understanding and Clarifications.
  • Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
  • Worked in an Agile technology with Scrum Written several complex SQL queries & PL/SQL stored procedures for validating Business Objects Reports Involved in testing the ANSI X12 EDI transactions for eligibility (270, 271), claims (877, 834) and enrollment (834).
  • Worked on projects independently and also managed a Facets testing effort Extensively used Informatica client tools.
  • The objective is to extract data stored in Oracle database, flat files to load finally into a single data warehouse repository, which is in Oracle.
  • Written several shell scripts using UNIX Korn shell for file transfers and clean up process.
  • Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance Created test suites for functional and regression testing using QTP.
  • Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
  • Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.
  • Extract data from Mainframe data sets to compare against Target Values.
  • Reported bugs and tracked defects using Quality Center (Test Director) Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
  • Involved in testing of Universes from different data sources like Oracle/SQL Server.
  • Managed and executed the test process, using Agile Methodology
  • Involved in data warehouse testing by checking ETL procedures/mappings. Performed the tests in both the SIT, QA and contingency/backup environments
  • Performed all aspects of verification, validation including functional, structural, regression, load and system testing.
  • Worked in Oracle DB for performing Data Analysis, Data Profiling using SQL server.
  • Conducted Functional and Analytical testing using Informatica tool to extract data stored in Oracle, created test case reports and logged defects by utilizing test directory tools.
  • Prepared sample EDI test sets for files like 276/77, 278,837 and followed HIPAA implementation guide in preparing them.
  • Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
  • Reported bugs and tracked defects using Quality Center Worked with business team to test the reports developed in Business Objects
  • As a QA Tester Involved in testing Facets /Membership and Claims applications
  • Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
  • Involved in creating source target mappings based on the Technical Design requirements. Involved in Manual and Automated testing using QTP and Quality Center.
  • Created different user defined functions for applying appropriate business rules Worked with business team to test the reports developed in Business Objects
  • Also tested for negative data to check that the job fails on any critical error.

Environment: Informatica Power Center 7.2,SQL,PL/SQL, HP Quality Center 10 Business Objects XIR2,Rational Clear Quest, Facets, MS Excel,, Teradata 12.0 Agile,Teradata SQL Assistant, Korn Shell Scripting, XML, SOAP, SOAPUI, Web Services, XSLT, XSD, XPath, XML Spy 2010, QTP, MVS, COBOL II, JCL, VSAM Files, Copy Books, TSO, Putty

Confidential,Chicago IL

ETL QA Analyst/SQL Backend Tester

Responsibilities:

  • Created test cases and test plans for user acceptance testing and system testing based on functional specifications.
  • Tested all the ETL processes developed for fetching data from OLTP systems to the target Market Data warehouse using complex SQL queries.
  • Tested PL/SQL procedures that were developed to load the data from temporary tables in staging to target tables in the data warehouse
  • Provided support to offshore QA team by giving them knowledge transfer and helping them with closure of the defects.
  • Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary.
  • Tracked defects to closure by coordinating with the dev team. Tested source data for data completeness, data correctness and data integrity.
  • Performed End to end testing starting from the source to the report. Conducted and coordinated integration testing and regression testing.
  • Participated in business requirements gathering and in modifications of the requirements based on the scope.
  • Involved in testing process flow of Financial Ledger in Oracle ERP (Enterprise Resource Planning) along with other modules like Order management (OM) and Account Receivables (AR).
  • Tested the order to Cash Life Cycle with all the standard items in OM, AR, Accounts Paybable (AP), Inventory and Financial Modules.
  • Worked with the DSO team to understand the source to target mapping document and accordingly helped them to clean the source data to decrease the defects and to ensure that final data matches with the data warehouse standards.
  • Prepared test data to cover all the test scenarios. Prepared UNIX scripts to run the Informatica ETL jobs from command line.
  • Maintained all the test cases in HP Quality Center and logged all the defects into the defects module.
  • Tested the migration of reports from Business objects 6.5 to XIR2

Environment: Oracle 9i, Informatica 7.1, Business Objects XIR2, SQL, PL/SQL, Quality Center 9.0, XML, TOAD for Oracle, UNIX, Shell Scripting

Hire Now