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