SUMMARY:

• Over 8 years of IT experience in various phases of IT projects such as Development, Testing, deployment and application support. Hands on experience with all phases of Software Testing Life Cycle (STLC)
• Have the ability to elicit, understand and articulate business requirements and perform detailed analysis to map them to functional QA requirements.
• Experience in testing Data Marts, Data Warehouse/ETL Applications developed in Informatica, Ab Initio and Data stage using Oracle, DB2, Teradata and UNIX.
• Extensive experience in testing Client/Server and Web - based Applications. Experience in both Manual and Automated testing.
• Good Understanding of the EDI (Electronic data interchange), Implementation and Knowledge of HIPAA code sets.
• Very Good experience in using Quick Test professional for automation testing.
• Participate in plan and development of Test Plans, Test Cases and Test Scenario to meet product's business requirements.
• Participated and performed in retrieving database information by writing SQL Queries in Oracle and Microsoft SQL data base to transforming data to information as needed from databases
• Vast knowledge and experience in the health care industry-experienced in testing different health care ERP solutions such as Facets and other claim processing solutions.
• Strong knowledge of EDI Claims, member enrollment, and billing transactions as well as ICD- 9 and ICD- 10.
• Understanding of HIPAA Standards and Compliance for both HIPAA 4010 and HIPAA5010
• Experience in testing Electronic Data Interchange (EDI) according to HIPPA Compliance.
• Have good knowledge of HIPPA 40 10 /50 10 versions.
• Worked to make the platform compatible with Affordable Care Act (ACA) provisions
• Profound understanding of insurance policies like HMO and PPO and proven experience with Medical Claims experience in Process Documentation, Analysis and Implementation in … Standards) processes of Medical Claims Industry from the Provider/Payer side
• Experienced in Data-Driven Testing, Batch Testing, Functionality Testing, GUI Testing, Regression Testing, Back-end Testing using SQL queries
• Maintained Test Matrix and Requirement Traceability Matrix.
• Strong knowledge of SDLC (Software Development Life Cycle) methodologies (Agile, Waterfall, RUP).
• Excellent communication and writing skills with the ability to adapt to new and dynamic environments
• Good team leader, Player and can work alone with minimal or no supervision
• Ability to multi-task, prioritize and work with time constraints while paying attention to details
• Good problem-solving, judgment, and decision-making skill

WORK EXPERIENCE:

Kearney, NE

ETL QA Tester/Manual Tester/BI Tester/Backend Tester

Responsibilities:

• Extensively involved in Developing Test Plans, Test Scenarios, Test Strategies and Test Cases with inputs from the assigned Business Analysts.
• Prepared and executed different test cases of HIPAA ANSI X 12 EDI 82 0, 834 , 837 and 83 5.
• Extensively used ETL methodology in testing for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL solution using ETL tools like Informatica
• Developed test scripts based upon business requirements and processes, in line with defined workflows and use cases. Processed transactions from system entry to exit. Tested functionality across applications and workflows. Developed various EDI documents for 837, 820, 270/ 271 and 83 5.
• Prepared Test Cases based on business requirements and business rules for HIPPA EDI Transaction 834, 835, 837. Analyzed HIPAA 5010 standards for 837P EDI X12 transactions professionals.
• Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in HP Quality Center/ALM. Built a library of test cases for regression testing and automated them using QTP
• Tested the HIPPA EDI 834, 835, 837 transactions according to test scenarios and verify the data on different modules.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata.
• Prepared Test Cases based on business requirements and business rules for HIPAA EDI Transaction 270/271, 837/835, 834.
• Wrote Complex SQL queries to validate the standard reports, Dashboards and Business objects Universes.
• Involved in validating SSIS and SSRS packages according to functional requirements.
• Involved in testing designing and development of Data warehouse environment.
• Used XSLT for document is transformed into another XML document that uses the formatting vocabulary
• Help testers in building test case files in Excel that would be input files for automation.
• Expertise in writing SQL Statements in database to make sure whether the data is populated in Data Mart/Data warehouse According to Business Rules.
• Worked on HIPAA Transactions and Code Sets Standards according to the test scenarios such as 834, 835 transactions.
• Validated the Insurance claims data using SQL queries in Backend Testing
• Worked on Autosys for Batch Processing ETL, PL/SQL subprograms and performed backend testing.
• 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.
• Created traceability matrix in Excel and in Quality Center/ALM by mapping out test cases with requirements tab.
• Tested reports developed by Business Objects Universes for both Adhoc & Canned Reporting users of Business Objects.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Involved in extensive DATA validation on data marts by using SQL queries.
• Validated Business Objects reports by running the SQL queries based on the business rules.
• Created reports and graphs for Analysis and Tracking for Test processes with Quality Center/ALM.
• Experience in testing Business Report developed in Business Objects XIR2
• Prepared and ran regression scripts, shell scripts and performed sanity tests and end-end testing.
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• Performed the tests in both the SIT, QA and contingency/backup environments

Environment: HIPPA EDI 834, 835, 837, ICD- 10, CPT, Informatica Power center 9x (ETL), Business Objects XIR3, HP Quality Center/ALM, Rational Clear Quest, Rational Clear Case, QTP, SQL SERVER, SSIS, XML, Toad for Oracle, ORACLE, Unix, Auto sys, Hyperion, DB2, Teradata, Windows XP, MS Excel, VBScript, .Net.

Phoenix, AZ

Sr. ETL Tester/EDI Analyst/SQL Tester

Responsibilities:

• Involved in the entire software Testing Life Cycle of the projects from Initiation to Implementation.
• Create test plan and test cases for manual and automated testing from the business requirements to match the project's initiatives.
• Experience working with HIPAA 4010A and HIPAA 5010 for Claims and Electronic Remittance advice.
• Tested various ETL transformation rules based on log files, data movement and with help of SQL.
• Created and executed detailed test cases with step by step procedure and expected result. Maintained the test logs, test reports, test issues, defect tracking using Quality center/ALM.
• Worked Extensively with Inbound 837 I and 837 P, 835s (Outbound) claims processing systems.
• Extensively used Data Stage for extraction, transformation and loading process. Worked with ETL group for understating Data Stage.
• Followed HIPAA implementation guides for preparing the EDI files. Created test cases for testing the 276/277, 270/ 271 and 27 8 transactions.
• Tested to verify that all data were synchronized after the data is troubleshoot, and also used SQL to verify my test cases.
• Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD/Exceed.
• Performed Analysis of ICD 9 Procedure and Diagnosis Codes in accordance with ICD 10 CM and ICD 10 PCS Conversion Compliances
• Performed execution phased: Executing test cases, identified products issues, wrote detailed bug reports and participated in bug review during the product development stages.
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
• Reported bugs and tracked defects using Quality Center/ALM (Test Director)
• Worked with ETL group for understanding Data Stage graphs for dimensions and facts.
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Experience on various modules of a FACET system such as claims, membership and pre-pricing etc.
• Written several complex SQL queries for validating Cognos Reports. Test the data which loads Weekly and Monthly. Testing of different types of ICD 9 as per requirements
• Tested Data stage Hashed files for extracting and write data - an intermediate file in a job.
• Written several complex SQL queries for validating Cognos Reports.
• Good experience in validating the Adhoc and OLAP cube. Validated Cognos Standard Reports created based on Frame work manager and Cube.
• Worked with Perl and UNIX shell scripts. Worked with releasing scripts live and tested.
• shells scripting. Automated and scheduled the Data stage jobs using UNIX Shell Scripting.
• Participate in weekly meeting with the management team and walkthroughs
• Participated in various meetings and discussed Enhancement and Modification Request issues
• Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.

Environment: ETL Data stage 8.1.1, Oracle, Cognos, HIPPA EDI, Quality center/ALM, ICD, CPT, TOAD, Windows NT/2000/XP, SQL SERVER 2008, .NET, TOAD, Java, QTP, UNIX, QTP, DB2.

Alpharetta, GA

Sr. QA Tester/EDI Tester

Responsibilities:

• Responsible for creating Test plan, development of test scripts, execution and validate Test results and document test evidence.
• Developed Ab Initio test environment for UAT testing and used all Ab Initio components while testing the graphs and ran the jobs on back ground
• Monitored EDI Eligibility/Inquiry/Response (270/271) transactions via reports generated by the developers.
• Executed test cases, and test scenarios for User Acceptance (UAT), Functional and Regression test cases.
• Reviewed unit test cases and test results and certified the code for Integration testing
• Use Business Objects OLAP Intelligence to natively access and analyze OLAP servers. OLAP Intelligence tool helps to Slice, dice, and drill directly on multidimensional sources and deliver workflows via the Web, Windows, and Microsoft Excel.
• Analyzed and worked with HIPAA specific EDI transactions for Claims, member enrollment, billing transactions. Worked specifically with 837, 835.
• Tested the ETL Ab Initio graphs and other ETL Processes (Data Warehouse Testing)
• Created user acceptance testing documents and reviewed them with the customer.
• Mapped test cases to requirements using Quality Center. Involved in entering and tracking defects using Rational Clear Quest.
• Experienced on EDI 837 interfaces, developed test cases and test scripts for 837, 835, Institutional Professional HIPPA transactions.
• Involved in communicating with support, business and development teams to resolve issues during test execution. Tested initial and daily loads for various Ab Initio graphs.
• Validated several SSIS and SSRS packages to verify that they are working according to BRS.
• Involved in testing the batch programs by using the Autosys tool.
• Tested the ETL graphs and other ETL Processes (DW Testing). Prepared Test Scenarios by creating Mock data based on the different test cases.
• Effectively communicate testing activities and findings in oral and written formats.
• Facilitated the sharing of structured data across different information systems using XML
• Extensively used SQL programming in backend and front-end functions, procedures, packages to test business rules and security.
• Done data validations for Business Objects reports. Extensively used Ab Initio Co-op to execute the graphs and verify the logs.
• Involved in testing the reports and UI screens containing those reports. Provided status reports on test execution, and defects identified during testing.

Environment: Ab Initio 2.12, Oracle, Toad, DB2, SQL, PL/SQL, HIPPA, EDI, FACETS, ICD, CPT, Business Objects, MS Visio, SQL Server 2003/2005 SSIS, SSRS, HP Quality Center, UNIX.

Marietta, GA

QA Engineer

Responsibilities:

• Develop test plans based on BRDs and Technical Specifications. Created and executed test cases based on test strategy and test plans based on business requirement documents and ETL design documents.
• Written complex SQL queries for querying data against different data bases for data verification process.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Applications.
• Extensively used Informatica Workflow Manager to run the workflows.
• Preparation of technical specifications and Source to Target mappings. Verified the Data completeness, Data Migrations, Data transformations and Data Quality
• Written Test Plans and Test Cases on Mercury Test Director Tool.
• Quality Center updates and test cases loading and writing Test Plan and executing Test Cases and printing status report for the team meetings
• Defects identified in testing environment where communicated to the developers using defect tracking tool Mercury Test Director.
• Strong Perl Scripting experience in writing conditionals, subroutines, Perl packages, OOP and Debugging in Perl.
• Wrote SQL scripts and PL/SQL queries using TOAD and Oracle SQL Developer to query DBs and analyzed the results.
• Tested a number of complex ETL mappings and reusable transformations for daily data loads.
• Used Data Stage Director to run the ETL mappings and monitor the status.
• Creating test cases for ETL mappings and design documents for production support. Extensively used Informatica for extraction, transformation and loading process.
• Worked with ETL group for understating mappings for dimensions and facts.
• Tested the different sources such as Flat files, Mainframes Legacy Flat Files, DB2 and Oracle to load into the Oracle data warehouse.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Extensively tested several Crystal Reports and Hyperion reports for data quality, fonts, headers & cosmetic.
• Participated in review meetings for defect status, priority and information exchange.

Environment: UNIX, Informatica, Perl Scripting, Mercury Test Director 6.5, SQL *Loader, MS Excel, Crystal Reports, Hyperion Reports, Oracle 9i, SQL Server, Java, Quality Center.