Data Conversion Test Analyst Resume
Chesterbrook, PA
SUMMARY
- 7+ years of experience in IT with emphasis on Software Quality Assurance in Healthcare & Pharma domains.
- Detailed knowledge of various phases of Software Development Life Cycle (SDLC) with emphasis on the Test and Requirements gathering phases in RUP, SCRUM and Waterfall.
- Working knowledge of government - sponsored Healthcare programs, focusing on HIPAA EDI X12 Medicaid & Medicare and CLAREDI to test for HIPAA compliance.
- Excellent knowledge of Software Testing life Cycle, QA Methodology and Test Process Documentation.
- Sound knowledge in HIPAA conversions and X12 EDI for Claims Adjudication process.
- Performed comparative analysis and gap analysis to identify variation in the process as per HIPAA X12 4010 and 5010 guidelines to in corporate updates as per 5010 guidelines.
- Worked with different Business Areas like Claims Adjudication to Test Plan proposed ICD9 - 10 Code changes.
- Good working experience in software development environment, with focus on developing Test Plan, Test Specification, Test Cases, Test Script.
- Involved in all phases of QA Life cycle, including Test Design, Development, and Implementation of the entire QA process and documentation of Test Cases, Requirements Traceability and Defect reports.
- Experience in conducting Requirement Analysis and developing business based functional test scenarios.
- Extensively involved in Black box, back end, functional and data driven testing using testing techniques.
- Experience in Test management and defect tracking tools - Quality Center, ClearQuest and Bugzilla.
- Experienced in performing Back end/Database testing by writing and executing complex SQL queries.
- Good working knowledge of Databases like Oracle, MS SQL Server, MS Access and DB2.
- Liaison between users and cross functional teams to resolve conflicts, and building working relationships.
TECHNICAL SKILLS
Testing Tools: Quality Center 9.0/10.0, Rational Clear Quest, ITKO LISA, SOAPUI.
Operating systems: UNIX, AS/400, Windows 2000/XP, HP-UX, Solaris.
Database: Oracle 8i/9i/10g, MS-SQL Server, MS-Access and DB2
Data Warehouse & Servers: Informatica, Web Sphere, BEA Web Logic, IIS and Apache
Protocol: HTTP, HTTPS, FTP, DHCP, SOAP and TCP/IP
Languages: C, C++, .NET, Cobol, Java, J2EE, JavaScript, JCL, XML, HTML, PL/SQL.
Management Tools: Ms Office Tools, PVCS Tracker, PVCS Version Manager, Clear Quest, Clear Case
PROFESSIONAL EXPERIENCE
Confidential, Chesterbrook, PA
Data Conversion Test Analyst
Responsibilities:
- Performing System Integration testing (SIT) to validate the Integrity of the data between the Siebel.
- Assisting in test planning, documenting requirements Traceability Matrix and mapping test cases.
- Executing test suites for data integrity of Siebel data through Ad-Hoc reports from Business Objects.
- Responsible for updating Test Completion Matrix reports to monitor testing progress.
- Testing the web services to get the Sales people updates from Integration Database.
- Writing SQL Queries on local Sybase database to retrieve data and match Siebel data.
- Developing complex SQL queries using joins, sub queries to test data tables against the source and target and to validate data and verifying referential integrity.
- Testing the ETL process for external source data migration process. Tested the audit and QC process built by ETL and data loaded into various (marts) databases for end user reporting.
- Verifying the Log Files and executed the Shell Scripts in UNIX environment.
- Responsible for logging and updating Defect Status in Quality Center. Performed Regression testing of fixes.
Environment: UNIX, Windows, Quality Center, HIPAA Validator, SQL, PL/SQL, Oracle 10g, Mainframes (Cobol, DB2, QMF, TSO/ ISPF, JCL, CICS),TOAD,, XML, PVCS, Informatica Power Center 8.1/9, Siebel ePharma 8.0.
Confidential, NYC
Mainframes/ EDI Test Analyst
Responsibilities:
- Reviewed Business Requirement (BRD), IT design document and prepared Test Plan /Test Cases.
- Participated in Walkthrough meetings with Business analyst and provided feedback on BRD.
- HIPAA Conversion Analysis - Involved in the documentation of HIPAA 5010 changes to EDI 837, 834, 835, 276, 277 Transactions.
- Participated in analysis workshops for ICD 9 Procedure and Diagnosis Codes in accordance with ICD 10 CM and ICD 10 PCS Conversion Compliances.
- Wrote Test Plan and Test cases from use cases for Acceptance, Functional, and Integration testing.
- EDI Claims Processing - documented enhancements to the EDI Claims Processes to ensure accurate processing of claims of various member/provider scenarios.
- Validated mapping of ICD 9 codes with corresponding ICD 10 Diagnosis/Procedure Codes.
- Validated conversion of the data to 5010 format to ensure all data was received by the Facets system.
- Performed day-to-day EDI mapping and translation activities for inbound and outbound transactions.
- Involved in documentation of Acceptance, Functional, Integration Test scenarios and Bug Log.
- Manipulated data in the database tables using SQL queries to create various testing conditions.
- Generated weekly Status Reports to the team manager & participated in weekly status meeting with Team members, Team managers, Business analysts & Technical team.
- Tracking Software defects collected from different sources and categorized severity in Quality center
Environment: UNIX, Windows XP, TIBCO, SOA, XML, SoapUI, Quality Center, Facets, Edifecs,XML DB2, Oracle 10g/11g, Business Objects XIR2 SQL Server 2005.
Confidential, Chicago IL
Software EDI /ETL QA Analyst
Responsibilities:
- Interacted and attended meetings with Business End users to gather business requirements for changes triggered by Government regulations and HIPAA.
- Attended JAD (Joint Application Development) sessions between the end users and Dev. Team.
- Involved in development of Test Plans and Test cases as per clients Business Requirements.
- Interacted with business people and developers to exchange the updated status and interacted with developers to resolve technical issues.
- Tested HIPPA regulations in Facets HIPPA privacy module and performed integration testing.
- Responsible for verifying HIPAA EDI transactions such as 835, 837 (P, D, I) 276/277.
- Developed and executed several SQL queries in DB2 as part of backend testing and involved in data validation and verifying data-integrity and also to check the data flow between different Systems.
- Performed Integration testing to check the integrity between the modules.
- Analyzing the Test Results and errors logged into Defect Tracking Tool Quality Center.
- Reported functional issues to appropriate developers using bug tracking tool Quality Center.
- Participated in QA weekly meetings and various other meetings and discussed.
- Enhancement and Modification Request issues and defects in the application.
Environment: UNIX, Windows, Mainframes, Visual Basic, IIS, SQL, TOAD, Oracle, Java Script, Quality Center.
Confidential, NJ
Software WEB QA Analyst
Responsibilities:
- DevelopedManual test cases to test User Statements, Transfers and History of payments and other functionality’s
- Created Automated Test cases for each functionality specification for bug free performance
- Created and executed detail function test scripts based on the business req Created Test Data in flat files from production data.
- Worked as a QA Analyst on different projects for web base Mortgage application.
- Performed GUI testing, integration testing, regression testing, Ad -hoc testing, negative testing on multiple projects.
- Created appropriate test cases, test scenarios, logged defects in Q.C9.2.
- Was involved in testing Main Frame base Mortgage application called ‘Citilink’. Successfully completed the training for Citilink application.
- Mapped Test Cases to Requirements.
- Tested different links for the user's in the site
- Developed several data driven and individual test cases to satisfy both positive and negative testing.
- Performed different types of Regression testing, Unit testing, Build verification and integration
- Generated Test data for various types of testing to valid data, Invalid data, Partial data bad data testing.
- Determined the nature and severity of bugs uncovered while testing
Environment: Q.C 9.2,SQL Server 2005,Weblogic, Informatica.UNIX,XML,.NET, Oracle 9i/8i.
Confidential
Software QA Analyst
Responsibilities:
- Developed Manual test cases to test User Statements, Transfers and History of payments and other functionality’s
- Created and executed detail function test scripts based on the business req Created Test Data in flat files from production data.
- Responsible for testing Branch reports Application developed for Branch Managers.
- Involved in cross browsing testing of the application on various Browsers to ensure that it functions similarly on all browsers.
- Tested different links for the user's in the site
- Developed several data driven and individual test cases to satisfy both positive and negative testing.
- Identified several test cases and created test data.
- Performed different types of Regression testing, Unit testing, Build verification and integration
- Prepared user requirements and developed business and technical specifications in accordance to business rules
- Modularized the test cases by creating Generic functions that deal with different sets of data.
- Created test descriptions for all Use Cases kept under Load test
- Work with developers, business and Release managers to discussed ways to fix the defects.
Environment: Win Runner and Manual testing, Java1.2, DHTML, HTML, Servlets, Java script, JDBC, Oracle, SQL, PL/SQL, Swing, UNIX.