We provide IT Staff Augmentation Services!

Data Conversion Test Analyst Resume

0/5 (Submit Your Rating)

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.

We'd love your feedback!