We provide IT Staff Augmentation Services!

Sr. Data Integration Quality Analyst Resume

Buffalo New, YorK

OBJECTIVE

  • I have over 8 years of diverse experience in Information Technology with an emphasis on Software Quality Assurance in industries like Healthcare, Banking, and Finance.
  • My ambition is to take up a challenging position in the area of Software Quality Assurance and Testing in a progressive, fast - paced dynamic environment that will allow me to align my skills in the organization in the most efficient manner.

SUMMARY

  • Over 8+ years of Experience in Data Warehousing Analyst, Quality Assurance and 6+ years of ETL/BI testing experience with extensive backend testing Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
  • Expertise in creating Test Plan documents and developing test strategy documents and preparing the Traceability Matrices.
  • Expertise in designing the test scenarios and scripting the test cases in order to test the application.
  • Expertise in QA process and different levels of testing like unit, Functional, Regression, Integration and UAT Testing with business scenarios.
  • Comprehensive knowledge of agile, V-model and waterfall software development cycle
  • Strong knowledge of Business Intelligence, Data Warehousing and Business Architecture
  • Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
  • Experience in testing and writing SQL and PL/SQL statements.
  • Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)
  • Strong experience in testing tools like Test Director, Quality Center & RQM and RTC, JIRA
  • Expertise in writing SQL and PL/SQL statements.
  • Good expertise in using TOAD, SQL-DBX and SQL Management Studio.
  • Experience in testing and writing complex SQL, T-SQL and PL/SQL statements.
  • Experience in all aspects of project development life cycle.
  • Expert level skills in testing Enterprise Data Warehouses using Informatica Power Center, Data Stage, Ab Initio and SSIS ETL tools.
  • Strong on testing reports from reporting tools such as COGNOS, SSRS, And Business Object
  • Experience with automation tool like SOAP UI and QTP
  • Automated web services using Soap UI
  • Experience in debugging the issues.
  • Proficient in working with UNIX shell scripts putty Environment.
  • Involved in jobs scheduling, monitoring and application support in a 24/7 environment.
  • Excellent communication skills and Ability to work in-groups as well as independently with minimum supervision and initiative to learn new technologies and tools quickly.

TECHNICAL SKILLS

Testing Tools: JIRA, HP ALM, Quick Test Pro, RTC, RQM

Databases: Oracle, Teradata, sql server, DB2, SYBASE, GREENPLUM

Languages: C, SQL, UNIX, .NET Framework, JAVA

ETL Tools: Informatica Power Center, Data Stage, AB- Inito BRE, SSIS

Operating Systems: Windows, UNIX

Bug Tracking Tools: Rational Clear Quest, ALM 11, JIRA,TFS, RTC

Reporting Tools: COGNOS, Business Object, WebFocus

Web Technologies: SOAP UI 4.5, Web services

PROFESSIONAL EXPERIENCE

Confidential, Buffalo, New York

Sr. Data Integration Quality Analyst

Responsibilities:

  • Analyze Business Required Documents and Detailed Design Documents to create test cases and test scripts for all the extract.
  • Identified/documented Data Sources and Transformation Rules required populating and maintaining extract content.
  • Administrate project review, escalation, quality Assurance, task completion, project deliverables and project status reporting for the project.
  • Have lead offshore testing team and junior tester for various projects.
  • Part of test case and test script review meeting.
  • Prepared QA estimation document and Test strategy document.
  • Maintain Data integration project JIRA board to document deliverables and reporting purpose.
  • Extensively worked in Agile software development methodology.
  • Responsible for providing technical direction and guidance for team members in handling test script and software environment.
  • Worked with different vendors and business to collect the requirement for the extract.
  • Closely worked business Analyst and developers to understand the ETL Process for the Extract.
  • Involved in developing detailed test plan, test cases and test scripts for Functional and Regression Testing.
  • Review SQL queries written by team member to verify the data in both source and target schemas to validate the data migration.
  • Work on design of automation suits for validation of reports and extract for regression testing using PL/SQL.
  • Mapping Data Items from Source System to the Target System.
  • Validate Extract files from EDW.
  • Involved in extensive DATA validation using SQL queries and back-end testing.
  • Preparing the process flow diagram for ETL Jobs.
  • Verified the data in DW tables after extracting the data from source tables by writing SQL queries using SQLDBX
  • Tested SQL queries, PL/SQL scripts to validate the data and performance of the database.
  • Validate the reports by running SQL Queries against the source system(s).
  • Created ETL execution scripts for automating jobs.
  • Documented the purpose of mapping so as to facilitate the personnel to understand the process and in corporate the changes as and when necessary.

Environment: SSIS, Facets, Sybase, Green Plum, SQL server, HP ALM, JIRA,SQL/PLSQL, WEB FOCUS, SQLDBX, Agile, Management Studio.

Confidential, Buffalo, New York

Sr. ETL/ Data Quality Analyst

Responsibilities:

  • Responsible for the maintaining quality of the Extracts send to different vendor from EDW.
  • Analyze Business Required Documents and Detailed Design Documents to create test cases and test scripts for all the extract.
  • Identified/documented Data Sources and Transformation Rules required populating and maintaining extract content.
  • Worked with different vendors and business to collect the requirement for the extract.
  • Closely worked business Analyst and developers to understand the ETL Process for the Extract.
  • Mapped the source and target databases by studying the specifications and analyzing the required transforms.
  • Involved in developing detailed test plan, test cases and test scripts using HP AML Quality Center for Functional and Regression Testing.
  • SQL queries were written to verify the data in both source and target schemas to validate the data migration.
  • Using Cross walk for the data to identify the migration data from Power to Health Rules.
  • Mapping Data Items from Source System to the Target System.
  • Validate Extract files from EDW.
  • Involved in extensive DATA validation using SQL queries and back-end testing.
  • Used Informatica to move data to the warehouse using the stored Procedure thereby enabling faster moment of data.
  • Preparing the process flow diagram for ETL Jobs.
  • Verified the data in DW tables after extracting the data from source tables by writing SQL queries using TOAD
  • Tested SQL queries, PL/SQL scripts to validate the data and performance of the database.
  • Validate the reports by running SQL Queries against the source system(s).
  • Created ETL execution scripts for automating jobs.
  • Documented the purpose of mapping so as to facilitate the personnel to understand the process and in corporate the changes as and when necessary.

Environment: Informatica, Health Rules, Power, ORACLE, DB2, HP ALM, Surveyor 400, Beyond Compare, SQL/PLSQL, TOAD 11 and TOAD for analyst 3.0

Confidential, Albany, New York

Sr. QA Engineer

Responsibilities:

  • Gathered business scope and technical requirements
  • Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
  • Mapped the source and target databases by studying the specifications and analyzing the required transforms.
  • Involved in developing detailed test plan, test cases and test scripts using RQM (Rational Quality Manager) for Functional and Regression Testing.
  • Worked in RTC(Relational team Concert) for SDLC life cycle
  • Interacted with Management to identify key Dimensionsand Measures for business performance.
  • Completed Data Migration test cases as well as web based test scripts.
  • SQL queries were written to verify the data in both source and target schemas to validate the data migration.
  • Perform Regression testing EDW after facet upgrade
  • Mapping Data Items from Source System to the Target System.
  • Validate Interface files from EDW and ADW.
  • Validate Cognos Report.
  • Involved in extensive DATA validation using SQL queries and back-end testing
  • Used Informatica to move data to the warehouse using the stored Procedure thereby enabling faster moment of data.
  • Validating the Target data based on the test cases.
  • Preparing the process flow diagram for ETL Jobs.
  • Validated all the applications and successfully executed and unit tested the jobs with RQM.
  • Verified the data in DW tables after extracting the data from source tables by writing SQL queries using TOAD
  • Tested SQL queries, PL/SQL scripts to validate the data and performance of the database.
  • Validate the reports by running SQL Queries against the source system(s).
  • Compare the new reports to the original requirements for complete functionality.
  • Created Test input requirements and prepared the test data for Data Driven testing.
  • Created ETL execution scripts for automating jobs.
  • Creation of jobs sequences and job schedules to automate the ETL process.
  • Documented the purpose of mapping so as to facilitate the personnel to understand the process and in corporate the changes as and when necessary.

Environment: Informatica, FACETS 5.01/4.81, ORACLE, RTC, RQM, SQL/PLSQL, COGNOS, TOAD 11 and TOAD for analyst 3.0, CDMA Mapping Application

Confidential, Tampa, Florida

Sr. ETL/Data Quality Assurance Analyst

Responsibilities:

  • Worked on Agile SDLC approach implementation for the whole testing life cycle.
  • Reviewed Functional requirements documents, High level design requirement documents and finalize the testing in scoops and scenarios for Integration testing for each project.
  • Gathered requirements and created, executed and documented Test Cases as per requirements in Quality Center.
  • Tested HIPAA EDI Transactions and Code Sets Standards such as 837/835 and 834 transactions.
  • Interacted with the team member to ensure meaningful development of the scripts and simulated real time business scenarios.
  • Maintained QA lab standards, documentation review assisted in establishing and maintaining best practices for QA.
  • Acting as liaison between end user and Xcelys for user problems, outstanding issues, training needs and new software releases.
  • Maintaining knowledge of Medicare and Medicaid rules and regulations pertaining to the Xcelysconfiguration and evaluating the impact of proposed changes in rules and regulations.
  • ICD 9 - ICD 10 Conversion Project - Worked in the analysis of the ICD 9 - 10 codes conversion Project. Expertise in GEM processes and concepts.
  • Created test scripts for Security, Positive, Negative and System Integration Testing (SIT).
  • Worked with team manager in supervising, guiding, and supporting their testing efforts for Integration.
  • Worked with Claims, enrollment, eligibility verification for members and providers andbenefits setup.
  • Support UAT testing
  • Experienced with batch processing system for claims electronic and manual transaction.
  • Well known with frontend processing for the Claims, Subscriber/Family and with Providers.
  • Experienced with External claim editing system on frontend system of Xcelys6.3.
  • Responsible for writing the Test Cases and Test Scenarios based on the Functional Specification and technical Specification and documented in Mercury Quality Center.
  • Executed test cases for the existing market’s various lines of business. (The test cases covered: Authorization of claims, Accumulator, Benefits, Claim Payment and Pricing, as well as member and provider data updates)
  • Created transactions in the Mainframe and verified them in the web and vice versa.
  • Worked on Quality Center for bug status tracking and maintained and created status reports for the application.
  • Work extensively for regulatory report for HEDIS Reporting
  • Involved in weekly defect review meetings to review the status of defect fixes and upcoming build releases.
  • Used Quality Center for version control, tracking defects, enhancement requests, assign work activities, and assess the real status of project throughout the life cycle.
  • Identifying Test Cases to be run for Regression Testing and conducting Regression testing as and when new builds were made.
  • Documented the test execution summary results and reported the status of assigned test tasks and issues to project manager for approvals.

Environment: Informatica, Xcelys 6.3, ORACLE, HP ALM/Quality Center11, Informatica DVO, SQL/PLSQL, Business Objects XIR2, TOAD, UNIX, Windows XP

Confidential, St. Petersburg, Florida

Sr. ETL/BI Quality Analyst

Responsibilities:

  • Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 10.0
  • Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
  • Extracted Data using AB- Inito Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
  • Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
  • Created the test environment for Staging area, loading the Staging area with data from multiple sources.
  • Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping
  • Tested the ETL Ab- initio Jobs and other ETL Processes (Data Warehouse Testing)
  • Written several complex SQL queries for validating Cognos Reports.
  • Tested several stored procedures.
  • Involved in the error checking and testing of the ETL procedures and programs Ab-initio session log.
  • Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
  • Experience in creating UNIX scripts for file transfer and file manipulation.
  • Validating the data passed to downstream systems.
  • Worked with Data Extraction, Transformation and Loading (ETL).
  • Involved in testing data mapping and conversion in a server based data warehouse.
  • Worked with business team to test the reports developed in Cognos
  • Tested whether the reports developed in Cognos are as per company standards.
  • Used Quality Center to track and report system defects
  • Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.

Environment: Ab Initio BRE, DB2, Java, Cognos, SQL, XML, IBM AIX 5.5, UNIX, WINSQL, Ultra Edit, HP Quality Center 10.0, QTP

Confidential, Nashville, TN

ETL Tester/QA analyst

Responsibilities:

  • Participated in developing test plans templates and guidelines to be used by the project team with detailed screen layouts with regards to various types of corporate actions.
  • Involved in the development of Test Plans and Test Cases and coordinated the tests with the QA team to verify implementation of new features and enhancements.
  • Writing Test Plans/Test Scenarios/Test Cases/Test Matrix.
  • Followed the Agile methodology for the entire SDLC
  • Involved in writing and executing test cases using MQC based on the requirements
  • Performed Back-End testing using SQL Query.
  • Developed design Specification writing Test report s and documenting Test results
  • Identified customer requirements besides reviewingtest plans and documented the development of these plans
  • Used Soap UI to check the status of environment
  • Analyzed the system requirements specification and developed appropriate test plans, test cases, test scripts and executed testing
  • Worked on claim processing module which involved Receipt, Enrolment (834), Verification of Claims Form (837) and Claims Adjudication, Health Claim Payment/Advice (835) as per HIPAA guidelines.
  • Automated web services using Soap UI
  • Tested EDI 837,835,834 files in compliance with HIPPA 4010 and 5010.
  • Coordinate withreformsoperations group to build new marketing strategies for exchange products on portals; designing exchange products with addition of exchange specific attributes to SBCs
  • Mapped the Bloodhound tool (clinical editing tool) related data elements to the internal XML elements.
  • Created the data dictionary for the clinical aberrancy rules
  • Performed Health CareReformaudit for multiple Health CareReformprovisions. Provided recommendations for systems being developed to support the audit.
  • Developed automation test scripts for performing regression testing on the application using Quick Test Pro
  • Worked and support UAT testing with business
  • Conducted interviews and workshops for soliciting customer requirements
  • Performed Test execution and wrote and executed Test scenarios /Test Scripts
  • Interacted with the technical team for the 837 claims transactions design
  • Manage the Requirements (Business as well as System requirements), performed requirements analysis along with the creation of Test Scenarios.
  • Worked with the development team to make sure that they understood the user requirements and that the system developed met those requirements.

Environment: Accentual Data Stage 7.5-Designer, Facets 4.7, Director, Manager, Windows NT 4.0, Quality Center 8.0, DTS, TSQL, Oracle 9i, TOAD, SQL, PL/SQL, Congos, Microsoft MS Access, Flat Files

Hire Now