SUMMARY

• 9+ years of experience in Information Technology with expertise in Software quality Assurance in Healthcare and Telecommunication domains.
• Possess strong knowledge of healthcare terminology and extensive experience working on healthcare projects. Specialized experience in healthcare insurance domain. Profound understanding of insurance policies like HMO and PPO.
• Proven experience with HIPPA transactions such as 837(Health care claim), 835(Payment/remittance advice), 834(Benefit enrollment), 270/271(Inquire/response healthcare benefits), 276/277(Claim status).
• Experienced in Functional, Integration, Regression, User Acceptance (UAT), System, Load and Performance Testing.
• Good knowledge of HIPAA 4010/5010 versions and experienced working with x12 version 5010 transactions.
• Extensive working experience with healthcare application - Trizetto Facets.
• Extensive experience in testing and implanting Extraction, Transformation, and Loading (ETL) of data from multiple sources into Data warehouse using Informatica DVO.
• Experienced in writing and executing SQL queries on Oracle and Sybase databases using SQL query tools like SQL Developer, Toad, SQL Advantage and MS Access (by linking).
• Experience in Backend testing in Oracle, SQL Server and DB2 using SQL Queries.
• Hands on experience in validating and testing web services by using SOAP UI.
• Strong Problem Analysis & Resolution skills and ability to work in Multi Platform Environments like Windows and UNIX.
• Has expertise in Test Case Design, Test Tool Usage, Test case Execution, and Defect Management.
• Experience in UNIX shell scripting and configuring cron-jobs for Informatica sessions scheduling.
• In-depth knowledge of Software Development Lifecycle (SDLC) and Software Testing Lifecycle (STLC).
• Expertise in developing Test Plan, defining Test Cases and Test Conditions using Business Functional and Technical specification documents.
• Ability to organize, document and track changes and defects by Traceability Matrix using Quality Center.
• Possess strong analytical, verbal and inter-personal skills and commitment to work within the deadlines.

TECHNICAL SKILLS:

ETL Tools: Informatica 8.6.1/8.1/7.1

Data Modeling: Erwin 4.0/3.5, Star Schema Modelling, Snow Flake Modelling

Databases: Oracle 10g/9i/8i, MS SQL Server 2005/2000, DB2, Teradata V2R6

Languages: SQL, PL/SQL HTML/DHTML, XML, ASP, Visual Basic

Tools: Toad, SQL* Loader, SQL Assistant,

Operating Systems: Windows 2003/2000/NT, AIX, Sun Solaris, Linux

Testing Tools: QTP 10/9.2, Quality Center 10, Test Director

Workflow Tools: MS-Project, MS-Excel, MS-PowerPoint, MS-Word.

Reporting Tools: Cognos, Business Objects

PROFESSIONAL EXPERIENCE

Confidential, Eden Prairie, MN

ETL QA Engineer

Responsibilities:

• Formulated detailed Test Plan.
• Used ALM to create and maintain test requirements and Test Cases.
• Generated test scripts that provided extensive application coverage in both Application Life Cycle Management and Excel sheet.
• Experienced testing XML web services using Soap protocol.
• Identified the test scenarios and performed web services functional testing using Soap UI.
• Performed back-end testing using SQL queries to validate user interface values against database for Integration testing.
• Utilized SQL queries to extract data from MS SQL Server database
• Perform data validation and data integrity tests in SQL Server databases.
• Work with data warehouse QA team to implement Informatica Data Validation Option (DVO) tool and adopt best practices for its use.
• Wrote various documents describing DVO functionality, and how DVO should be used by group based on discussions with team lead.
• 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.
• Written several shell scripts using UNIX Korn shell for file transfers and cleanup process.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance
• Experienced in functional testing processes of member enrollment and eligibility and claims adjudication and payment.
• Tracked and reported the bug sand involved in Test Cases writing using Quality Center.
• Participated in defect reviews with the developers, managers and business people and presented the defect reports in defect review meetings.

Environment: ETL, Informatica DVO, SOAPUI, Web services, SQL, UNIX, XML, Excel, Oracle 10g, Teradata V2R4, SQL Server 2005, Windows 2000, Cognos8.4.1, Quality center 9.2

Confidential, Minneapolis, MN

ETL QA Engineer

Responsibilities: 

• Formulated detailed Test Plan using ALM after analyzing the WITs and enhancement requirements.
• Used ALM to create and maintain test requirements.
• Ran jobs for processing claims and creating outbound test files.
• Worked with business team to collect the UAT scenarios for UAT testing; collected the claims and generated their X12 files through Encounters Processing System for each UAT scenarios and delivered to business for UAT.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Tested Business Objects reports and Web Intelligence reports
• Performed Functional, Regression, Data Integrity, System, Compatibility.
• Used Quality Center for test management and defect Reports.
• Processed high volume claims through different validation level to verify the output. Compared source and target data to verify the data consistency.
• Ran batch jobs and analyzed error logs.
• Generated test scripts that provided extensive application coverage in both Application Life Cycle Management and Excel sheet.
• Tested the HIPAA EDI 837 transactions based on the different test scenarios.
• Participated in defect reviews with the developers, managers and business people and presented the defect reports in defect review meetings.

Environment: Informatica Power Center 9.1/8.5.1, Business objects, Teradata, Oracle 10g, SQL, PL/SQL, Excel Files, Windows NT & UNIX, Quality center 9.2

Confidential, Detroit, MI

ETL QA Engineer

Responsibilities:

• Involved in testing for Claims Inbound (EDI 837 P/I), Member Eligibility (EDI 834) and Claims Outbound (EDI 837 O) transactions and loading of the remit data into Resolute in 5010 implementation.
• Tested Claim adjudication process and Member eligibility process from end to end for 4010 and 5010 transactions.
• Coordinated UAT, Regression and Integration testing schedules and completed the same.
• Experienced in testing XML web services using Soap protocol.
• Identified the test scenarios and performed web services functional testing using Soap UI.
• Strong technical Knowledge of UNIX Utilities, Shell Script to automate process.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Involved extensively in doing back end testing of the data quality by writing complex SQL.
• Performed back-end testing using SQL queries to validate user interface values against database for Integration testing.
• Utilized SQL queries to extract data from MS SQL Server database
• Perform data validation and data integrity tests in SQL Server databases
• Experienced in functional testing processes of member enrollment and eligibility and claims adjudication and payment.
• Involved in conduction execution steps for member enrollment and claims processing.
• Performed regression testing to check the application with the new version of 5010.
• Logged defects and tracked the life cycle of defects along with creating test reports and defect reports for defect tracking meeting using Quality center.
• Participated in defect reviews with the developers, managers and business people and presented the defect reports in defect review meetings.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping.

Environment: Informatica power Center, Cognos, SQL, SOAPUI, UNIX, SQL Server, XML, UAT, Quality center

Confidential, Cleveland, OH

QA Tester

Responsibilities:

• Analyzed the Business Requirements and Rules and worked with Business Analyst and Business Users.
• Gone through the Functional Specifications and implemented their technical aspect In Functional Testing, System and Integration testing (SIT).
• Worked in AGILE Methodology.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Developed Test Cases for each mapping according to the business requirements.
• Queried data from different database tables as per the requirement by joining queries using TOAD tool.
• Experienced using database query tools for Oracle SQL such as TOAD and SQL Plus.
• Tested and developed the mapping for extracting, cleansing, transforming, integrating, and loading data using Autosys
• Written extensive UNIX Shell scripting for error logging, cleanup, data archiving & job scheduling
• Performed the Query Tuning for complex SQL and PL/SQL.
• Reported bugs and tracked defects using Quality Center.
• Involved in system testing and regression testing.
• Worked with QA team lead to review the test cases and worked with team members to prepare the final RTM with updated test cases and change requests.
• Tested several stored procedures and invoked into ETL Procedures.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases.
• Extensively test the reports for data accuracy.
• Experienced in data migration from one data source to another for testing purposes like migrating data from dev. to QA.

Environment: Informatica Power Center 8.6, UNIX, Oracle 11G/10G, DB2 8.0/7.0, XML, SQL, PL/SQL, Quality Center, ASP.net, TOAD, Autosys, UNIX.

Confidential, Minneapolis, MN

QA Analyst

Responsibilities:

• Developed Test Plans based on test strategy. Created and executed test cases based on test strategy, and test plans based on ETL mapping documents.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application.
• Responsible for creating manual test scripts to include Functional test, Regression test, UAT, Migration test, and Study configuration test.
• Analyzed SQL code to ensure Business Objects queries the correct data from the database.
• Extensively communicate testing activities and findings in oral and written formats.
• Reported bugs and tracked defects.
• Performed UAT testing.

Environment: Informatica, Business objects, SQL, UAT, Quality center