SUMMARY

• Over 10+ years of Professional Experience in Software Development Life Cycle (SDLC) including Business, System and Data Analysis, Testing, Implementation and Documentation 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 Plans, Test Cases, Test scripts and Execution.
• Good knowledge of ETL Testing/ETL Analysis, Data warehouse, DataMart to Views designing of the flow and the logic for the Data warehouse project and performed the ETL testing for them.
• Extensive knowledge of Healthcare Industry, including all HIPAA mandates, ERP systems, ICD disease codes/conversions, Medicare/Medicaid, EDI files etc.
• Strong working knowledge requirements of FDA QSRs.
• Deep understanding of QA Process, Test Methodology and Software Development Life Cycle (SDLC), Waterfall, Agile and RUP.
• Solid experience with all levels of testing including Smoke Testing, Unit testing, Functional Testing,Integration Testing, System Testing, Regression Testing and UAT.
• Experienced in writing Test plans, Test Cases, Test Scenarios and defining the Testing methodologies and verifying and validating the web-based applications.
• Experienced in both Manual and Automated testing tools using HP Quality Center/ Application Lifecycle Management, Test Director and QTP with VB Script.
• Excellent knowledge and working experience in Test Planning, Test execution, Test Results Analysis, Requirement Traceability Matrix and analyzing business requirements.
• Good Working knowledge of Linux and Microsoft operating systems.
• Experience working with HP Load Runner for performance testing and developed test scripts
• Extensively verified and validated XML request and response files Web Services from the third party service provider.
• Extensively involved in Build Acceptance Testing, Functional Testing and Database Testing using SQL Server / 2008/2010/2015.
• Excellent working Knowledge of Databases like MS Access, SQL server, Oracle with PL/SQL and Stored Procedure.
• Extensive use of defect tracking tool like HP Quality Center (ALM), Service Now, JIRA.
• Excellent hands on MS office applications.
• Good knowledge working with version control / Management tool - Git, Github.
• Good knowledge using the reporting BI tools like Cognos andTableau.
• Excellent Knowledge of Data Warehouse/Data Mart design concepts, UML diagrams, Fact and Dimension tables, views.
• Organized, detail-oriented and have the ability to work well in a time sensitive environment.
• Excellent communication and presentation skills, self starter, quick learner and team player.

TECHNICAL SKILLS

Languages: Java, VB Script, VBA, C, C++, SQL, PL/SQL, T-SQL, UML, XML, Shell Scripting

Tools: QC, UFT, SOAP UI, Data warehouse tools, ETL Tools, Informatica, Control M, Erwin.

Bug Tracking Tools: HP Quality Center, Clear Quest, JIRA, ServiceNow.

Databases: MY SQL, SQL Server, Oracle 9i/10g/12g,Exadata, Big data/Hadoop

Operating system: Unix/Linux, Windows NT, Windows 2000/2003/2008 Server & Windows XP/Vista

Web Technologies: XML, HTML, CSS, J2EE, PHP, VB Script, web services, .NET

PROFESSIONAL EXPERIENCE

Confidential, Charlestown, Massachusetts

Technical ETL QA Lead

Responsibilities:

• Extensively interacted with developers, data modelers, data architects, business and management teams to understand the DWH Redesign project business requirements and ETL design document specifications.
• Worked with ETL groups and Acquisition team and business analyst for understating mappings for dimensions and facts.
• Overviewed all the testing activities performed by offshore QA team (Total 8 QA team members) and assisted them in their testing efforts.
• Participated in the Business Requirement Review meetings for accuracy and Completeness.
• Responsible for setting up a bi-weekly defect triage meeting with Developers, modelers to get clarification on the issues identified, and ensure all the defects are correctly keyed in ALM with accurate summary and required information.
• Responsible for preparing ETL test specifications including test source data preparation, writing the use cases to test Data Completeness, Data Transformations, Data quality, Performance and Data aggregations− match aggregated data against staging tables and/or ODS and ensure that the data in the ODS and dimension tables are populated as per specifications.
• Performed sanity checks in the new warehouse tables vs the existing tables to ensure there are no any gaps and perform data analysis between the two data sets.
• Involved in Scheduling and automating jobs to be run in a batch process using Control M.
• Ensure the SQL Queries/Scripts written by the QA team members are accurate and helped in validating the Completeness, Integrity and Accuracy of Data within an ETL process testing cycle.
• Participated with the development team in creating different sessions and workflows to load the data to Data Warehouse using Informatics Workflow Manager.
• Involved in user training sessions and assisting in UAT (User Acceptance Testing).

Environment: DataWarehouse, SQL Server Management Studio, Application Life Cycle Management (ALM), Service Now, Facets, Control M, Informatica Powercenter, Erwin, MS Office Applications.

Confidential, Lexington, Massachusetts

Sr. ETL QA analyst

Responsibilities:

• Extensively involved in Data Analysis Activities including Enterprise Data Management (EDM), Data Profiling, Data Quality, Data Governance, Source to Target Data Mapping and Data Testing/validation.
• Generated, formatted, and distributed data validation checklists and reports and collected sign off’s from business users and stakeholders for the same
• Written complex SQL queries for validating the data against different reports generated by Business Objects.
• Developed a simple and easy mechanism of database application for users to enter data without having to enter data into numerous delivered screens using Microsoft Excel/Access/VBA.
• Involved in Integrating and Functional System Testing for the entire Data Warehousing Application.
• Efficiently maintained all the documents and trackers up to date and following up on any defects that require immediate attention.
• Created Business Requirement Document outlining detailed Business requirements (Functional and Non Functional), Data Requirements, ETL Specs, Timing, Constraints and Exceptions etc.
• Collaborated with data modelers, ETL developers in creating the Data mapping document.
• Experience in handling large volumes of data and played a key role in building transformations to meet the Confidential /HIPPA requirements.
• Attended daily standup meeting for daily update from the team. Co-ordinate with different scrum teams for updates and defect tracking.
• Experience working with Java Frameworks and general design patterns.
• Extensively used ETL tool Informatica for extraction, transformation and loading process.
• Used HP ALM for Requirements and Defects Tracking.
• Worked on test data to check all business rules and requirements are met. Also tested for negative data to check that the job fails on any critical error.
• Performed complex defect analysis in various environments like UAT, SIT, and QA to ensure the proper delivery of the application into the production environment.
• Involved in Writing Detailed Level Test Documentation for reports and Universe testing.
• 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.
• Developed Test plan, Test cases, Test scripts, Test results and various other project documentation in HP Application Lifecycle Management.
• Analyzed the data and applied relevant transformations and verified that the source data types are correctly transformed to Target tables as per the transformation logic.
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.

Environment: IBM Netezza, Oracle Exadata 12g, SQL Server Management Studio, PL/SQL,HP UFT 12.0, HP Quality Center,ALM 11.0, Toad, SQLDeveloper, ETL, MS Office applications, Datawarehouse, Informatica, Business Objects, Tableau.

Confidential, Olympia, Washington

Sr. Quality analyst

Responsibilities:

• Worked as a Quality analyst (backend and front end) in the financial management, member enrollment and eligibility module for the UAT and production environment for the Washington Health Finder web application.
• Involved in testing to verify that all data were synchronized after the data is troubleshoot, and also used SQL to verify/validate.
• Responsible for testing entire member enrollment and eligibility workflows as per business requirements using Facets 5.01
• Used JIRA to raise defects and submit the tickets to the respective level.
• Responsible for communicating with the client for weekly status report and also with the offshore team.
• Participated in Daily and weekly status meeting with team members and coordinated with teams (Development, Business, and QA) for the progress of the work done in application.
• Responsible for running batch jobs (daily and monthly) to create the EDI files from the existing XML.
• Responsible for validating and analyzing the EDI 834 and 820 files.
• Created jobs to schedule multiple reports in Cognos connection.
• Reviewed Informatica ETL mappings/workflows and SQL that populates EDW and data mart Dimension and Fact tables to ensure accuracy of business requirements.
• Performed Back end testing by writing SQL statements like Join, Inner Joins, Outer joins and Self Joins used TOAD and SQL Developer.
• Participated in business requirements reviews and software system (application) designs for testability.
• Track and report upon testing activities, including the test case execution stage, defect status if any defects opened during execution and the testing results status.
• Performed end to end data validation using ETL and BI tools.
• Wrote Use Cases, prepared use case diagrams (using Rational Rose & UML) and followed Agile at every stage of the processes.
• Developed SQL Queries for checking the Data Transaction and Database Integrity.
• Provided technical and procedural support for User Acceptance Testing (UAT).
• Assisted in GAP analysis for any available requirements and communicated through the CR process.

Environment: Oracle 11g, Automation, ETL, Datawarehouse, Alteryx, SQL server management studio, MS Outlook, Linux, MS Excel, MS Access, QTP, HP ALM, MS Visio, JIRA, Cognos.

Confidential, Solon, Ohio

Quality Analyst

Responsibilities:

• Coordinated, Managed, Mentor and Lead the offshore team in all the activities regarding Testing and conversion of legacy system and data migration to Facets 4.81.
• Worked on Member Enrollment and Billing module for the implementation of Facets.
• Highly Responsible in developing High Level Test Scenarios from the Business requirement/Functional requirement document.
• Get approval from the business/ Client for the Test Cases/Test Plan, Data Setup and Execution of Test Cases.
• Logged defect in Quality Center (QC) 10and assigned to appropriate developer Designers/Architects.
• Document all the Test Results (TR) from the Scenarios and submit to respective POC.
• Supported and provided valuable suggestions to the ETL Tester / ETL Analysis, for designing of the flow and the logic for the Data warehouse project and performed the testings.
• Validated Extract/Transform/Load (ETL) processes that load Teradata test databases with data feeds from upstream applications and provided information deliveries of warehouse data to downstream users which was in the Oracle Database.
• Involved in Adjustment of the Pharmacy Claims (Reversing the Claims, RR, RRCR, RRMR), and paying various types of claims. I.e. DMR (Paper Claims), PTP, Government claims, E-claims, MSP (Medicare secondary payer), COB, steps on running ERIC, EXTRACT, CET and NDM process.
• Performed smoke, Integration, Functional, and Regression Testing.
• Handled and worked in multiple projects at the same time within the given time frame.
• Reviewed Informatica ETL mappings/workflows and SQL that populates EDW and data mart Dimension and Fact tables to ensure accuracy of business requirements
• Attend multiple meetings with the client Lead, Developer, and Project Manager to fully understand the functional and technical requirement, and to discuss the Test Scenarios Created.
• Highly involved with the Client to better understand the system and the business requirements.
• Wrote and Review test cases in QC, and Matrix the requirement documents along with it.
• Provide answers to the users for the test cases created and explained the final results, and the important functionality in the project.
• Conducted the Test Results walkthrough with the Clients and getting Sign off to deploy project on time.
• Prepare TR (Test Results) documents via Quality Center and provide to the Clients on each project.

Environment: HP Quality Center 10.0, MSWindows, Facets 4.81, Rational Clear Quest, MS Excel, MS Visio, Teradata, Oracle 10g, Business Objects, SSIS, Informatica, DWH, XML, Selenium, Cognos.

Confidential, Buffalo, NY

EDI Tester/Quality Assurance Analyst

Responsibilities:

• Responsible for testing entire claims processing workflows as per business requirements using Facets 4.71.
• Gathered requirements and reviewed Use Cases for the applications that used SSN and DOB as unique identifiers.
• Analyzed URS and Functional Requirements Specifications to understand business rules of application.
• Validated displays of Patient Screen to include masked SSN & DOB Information.
• Claims Process validation - Identified Claims Matching Scenarios upon which millions of Claim records were matched daily based on Patient’s Information
• Involved in writing Test plans, creating Test scripts, and Team Co-ordination
• Performed Analysis of ICD 9 Procedure and Diagnosis Codes in accordance with ICD 10 CM and ICD 10 PCS Conversion Compliances
• Participated in meetings and JAD sessions to ensure legal and compliance deadlines of CMS (Centers for Medicare and Medicaid Services) are met
• HIPAA Conversion Analysis - Involved in the documentation of HIPAA 5010 changes to EDI 837, 834, 835, 276, 277 Transactions.
• Defined the approach for automating significant parts of the QA framework.
• Responsible for carrying out manual testing like Integration, Regression testing during various phases of test cycles.
• Interacted with dev. & various members to discuss and resolve defects based on priorities.
• Supported and provided valuable suggestions to the ETL Tester / ETL Analysis, for designing of the flow and the logic for the Data warehouse project and performed the testing’s.
• Developed and Maintained Test Schedule for Quality assurance deliverables.
• Responsible for working with application team in UAT and Production Release.
• Documented defects in IBM Clear Quest and provided test execution progress updates. Involved in writing functional automation framework code by using Descriptive programming. Validated the internal processing of the MMIS, or other transaction processing system.
• Developed Test scripts to meet the requirement by using the Business Scenarios and Business Requirements for different kind of Claims.

Environment: SOA Framework, MS Visio, Word, Excel, Facets 4.71, DB2, Rational Rose, Requisite Pro, Clear Quest, SQLServerManagement Studio, Oracle 9i, J2EE, Load Runner, Cognos, Datawarehouse.