SUMMARY

• 7+ years of excellent IT experience in requirement gathering, data analysis, design, development, Testing and Implementation of Data Warehouses using ETL & Business Intelligence solutions, UNIX, OLAP for multiple domains.
• Expertise in understanding Business/Functional/technical requirements and compliance rules.
• Experienced in writing test plans, test cases and test scenarios.
• Experienced in co - ordinating resources wifin Onsite-Offshore mode.
• Complete exposure to all stages of SDLC process wif strong skills in writing various test plans, developing, maintaining test cases and test scenarios.
• Experience on Various modules of FACETS system such as claims, membership and pre-pricing etc.
• Experience wif external membership/enrollment/claim system of Facets 4.71 and 5.01
• Excellent Understanding in relational Data modelling, Dimensional data modelling, logical/Physical Design, ER Diagrams, analyzing data sources.
• Proficient in working wif FACETS, claim processing systems.
• Experience in testing complex reports generated by Cognos, Business Objects including dashboards, summary reports, master detailed, drill down and score cards.
• Expertise in Data Analysis, Understanding in Dimensional Data Modelling, Data Extraction, Transformation & Loading (ETL), Cubes and End User Reports.
• Well versed in Health Care wifHIPPA, HL7, EDI and x12data formats and270/271,276/277,278,820,834,837and835Transactions.
• Work experience on 820, 834, 835 and 277CA transactions for both versions (4010A1 and 5010)
• Experienced in playing multi-tasking roles like PEGA LBA/QA/Dev.
• Good Understanding on Star Schema Modelling, Snowflake Modelling, FACT and Dimension Tables, Physical and Logical Data Modeling.
• Extensive experience in using SQL, PL/SQL Procedures/Functions, Triggers and Packages for testing purposes.
• Expertise in “Agile” (Scrum) Methodology.
• Expertise in writing Selenium Web Driver automation scripts in JAVA
• Experienced in functional, integration, regression, compatibility, security, back end, acceptance testing (UAT), and GUI Testing.
• Advanced user in using Test management tools like HP Quality Center/Test Director, JIRA.
• Worked on Oracle 11g/10g/9i/8/7.3, MS SQL Server 2008/2005/2000/7.0/6.5, IBM DB2 7.1/8.2/v9, Teradata V2R6/R5 databases.
• Prepared and loaded test data in different environments for different testing needs.
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently wifin time frame.
• A good team player wif excellent written and verbal communication skills.
• Experience using testing tools such as Quality Center ALM, Quick Test Pro and SOAP UI.
• Performed an End to Endweb servicestesting and XML validation using teh SOAP UI
• Involved in creating various artifacts like BRD, functional specifications, Use Cases, UML diagrams, data mapping documentation, pre and post RTM, weekly reports etc.
• Capability to communicate wif configuration manager, production manager and end users.
• Developed thorough Use Case Diagram, Activity diagrams based on UML, methodology and Data transformation rules, Data mapping documents, state chart diagram using Microsoft Visio.
• Excellent problem solving skills wif a strong technical background and good interpersonal skills. .

TECHNICAL SKILLS

Reporting Tools: IBM Cognos v9, MS SQL Reporting Services, Pegs Testing

Operating Systems: Windows NT/2000/2003/XP, UNIX, Solaris and MSDOS

Databases: Oracle 11g/10g/9i/8i, SQL Server2008/2005, DB2, MS Access, Teradata V2R5.

Data Modeling: Erwin, Microsoft Visio, Rational Rose (UML), ER Studio

Testing Tools: Quality Center/Test Director, Issue Tracker, Team Foundation server, Fiddler 2,Rational Quality Manager(RQM), Rational Clear Quest(RCQ),MS Test Manager, HP ALM, SOAP UI

Languages: XML, HTML SQL, PL/SQL, X12, C, C++, VB, Java

PROFESSIONAL EXPERIENCE

Confidential, McLean, VA

Sr. QA Analyst

Responsibilities:

• Teh Project TEMPhas been implemented based on rapid Agile SDLC Methodology.
• Involved in Onsite and Offshore Model by coordinating teh various QA teams and other cross-functional Teams.
• Reviewed business requirement documents and technical requirement documents to understand business workflows and application data models and relationships between entities.
• Actively participated in decision making, QA meetings and regularly interacted wif teh track leads to gain better understanding of teh Business process and requirement.
• Developed detailed specifications on testing approach, testing strategy, testing scope, and deliverables.
• Developed Test plan, Test scenarios, Test Scripts and Test cases based on use-cases for different modules.
• Gather requirements from teh Business users; interact wif teh business users on constant basis.
• Worked on Business Requirement Document,& Schedules. Provided project life cycle Artifacts.
• Interacted wif teh Business Team on continues basis, coordinated meetings wif teh vendor
• Provided Daily Status reports to teh Business owner, Project executives & Team,
• Monitor and control teh project wifout schedule slippage
• Analyzed requirements of teh existing systems and suggested teh improvised business process model.
• Assigned work efforts of different tracks to teh team member, Mentoring teh teams and resolving day to day issues
• Worked closely wif teh project Managers and assisted in creating project timeline wif MS Project.
• Gap Analysis of requirements, generated workflow process, flow charts
• Defined and documented teh vision and scope of teh project.
• Worked closely wif teh PM in establishing teh team goals,
• Managed teh entire UAT set up & UAT testing effort.
• Created requirements for testing purpose to map wif HP ALM.
• Performed data profiling and data mapping to map various source data systems to teh new Basel database.
• Logged teh errors, reported defects, determined repair priorities and tracked teh defects until resolution using HP ALM.
• Modified data wif appropriate test members, providers, and dates of service prior to being loaded via key word file to teh test environments (FAC 3Q, 4Q)
• Executed test cases for teh existing market’s various lines of business. (Teh test cases covered: Authorization of claims, Benefits, Claim Payment and Pricing, as well as member and provider data updates)
• Processed claims in Facets and verified 835X12's are generated and sent to Provider.
• Entering Claims and Customer Service Tasks into teh FACETS.
• Used EDIFECS to process 837, 270/271 & 276/277 transactions and perform End-to-End testing wif Payers.
• Validated Plan Profiles inIMS (Main Frames)andDiamond (Claims processing system)
• Prepared837 filesfor Electronic claims submission for ITS Claims.
• Worked on teh HIPAA 4010 conversions and worked on teh EDI 834, 837, 835 and 278 files and validated teh functionality according to teh new HIPAA 4010 changes.
• Worked on teh EDI 834 inbound and 834 outbound data movement wif our trading partners.
• Extensively performed Functional, Integration, Regression, GUI and Web Testing
• Coordinated wif teh developers and IT architects to design teh interface of teh new system according to teh X12 (270, 276, 278, 834, 837 (I, P, D) and 820) standards
• Tested Cognos reports to check whether they are generated as per teh company standards
• Performed both Manual and automation testing during teh project.
• Thoroughly checked decision tables in and out, to check for eligibility results.
• Extensively conducted manual testing for Smoke, Functional, System, Regression, System, Integration, Database, Compatibility testing, etc.
• Used Oracle SQL Developer to do backend testing to perform data validation and to check on data driven results like reports.
• Generated report on test case results wif a good understanding of defect severity.
• Executed test script using Rational Quality Manager (RQM).
• Worked wif Development team to articulate teh defect clearly and ensure teh errors are fixed and did not occur again.
• Involved in testing teh Cognos reports by writing complex SQL queries
• Tracked and logged Defect and Issue using defect tracking tool Rational Clear Quest and document teh defect wif greatest level of detail based on teh understanding of teh application.
• Conducted Smoke Testing of different Applications using SOAPUI pro. Involved in designing teh mock-up screens of teh new GUI for claim entry
• Primarily focused on teh system, integration, release, regression and automation testing teh pricing application, SOAP UI, Web services, Hyperion reports, Oracle databases for new development and enhancements in thepayerpricing system.
• Conducted regression testing on new builds/versions.
• Delivered test scenarios/cases for use in system test and UAT environments
• Maintained Traceability Matrix to ensure test coverage of requirements; documented and re-verified all defects and test result and prepared Summary Report.
• Actively participated in daily defect triage and release meetings.
• Attended several walkthrough meeting wif teh track lead, Project Manager and developer/DBA and provided feedback accordingly.
• Extensively executed SQL queries to view successful transactions of data and validating data.
• Examined application performance, scalability and Load testing using Rational Performance Tester.
• Identified and eliminated performance bottlenecks during teh development lifecycle.
• Verify that applications meet specified performance requirements.
• Experience wif external claim editing system on front-end system of FACETS.
• Reviewed computer logs and reports to identify application processing errors and possible improvement.

Environment: Rational Quality Manager (RQM), FACETS, Cognos, Rational Clear Case (RCC) Rational Performance tester,(RPT), ALM, Oracle SQL developer, Share Point, MS Office, FTP, XML, Snagit, Mainframes, USERIMS, IMS, FILEAID, XML, Oracle, SQL Navigator,X12,XML,Citrix

Confidential, Philadelphia, PA

Sr. QA Tester

Responsibilities:

• Responsible for Business analysis and requirements gathering.
• Performed Data Analysis during teh requirements gathering phase by reviewing teh source data model and running SQL queries.
• Performed complex defect reports in various environments like UAT, SIT, and QA etc to ensure teh proper delivery of teh application into teh production environment.
• Developed data quality test plans and manually executed ETL and BI test cases.
• Experience in ETL Data Warehousing, database testing using Informatica for Workflow process.
• Wrote test scenarios and test cases for testing teh migration from legacy mainframe systems to Java systems and Oracle databases.
• Worked on Data mapping, logical data modeling and used SQL queries to filter data wifin teh Oracle database tables.
• Tested web services by generating XML SOAP requests and validated teh corresponding XML SOAP responses.
• Supported new business requirements by extending teh functionality of teh core Facets system using teh Facets extensibility architecture feature.
• Gathered requirements from teh users and analyzed teh requirements for RQ System, Facets etc.
• Worked wifFacetsApplication Groups: Claims Processing, Customer Service, Guided Benefit Configuration, Medical Plan, and Enrollment, Pricing Profile, Provider, Subscriber/Member, and Workflow Configuration.
• Data mapping on Enrollment Module (EDI 834) ofFACETS.
• Responsible for working wif teh State to review and modify process flows to increase productivity and effectively utilizeFACETSfeatures not provided by teh legacy systems.
• Performed Functionality and GUI testing using QTP.
• Extracted Data from Teradata using Informatica ETL and DTS Packages to teh target database including SQL Server and used teh data for Reporting purposes
• EDI 274/275 code for transaction of electronic prescription according to patient information and healthcare provider information. In addition EDI 270 (Eligibility and Benefit Request) and teh EDI 271(Eligibility and Benefit Response).
• Analyzed HIPAA 4010 and 5010 standards for 837P EDI X12 transactions, related to providers, payers, subscribers and other related entities.
• Providing Cognos end-user support throughout my project and prepared documentation for Cognos end-user security.
• Experience in loading from various data sources like Teradata, Oracle, Fixed Width and Delimited Flat Files.
• Worked on test data and completed unit testing to check all business rules and requirements are met. Also tested for negative data to check that teh job fails on any critical error.
• Involved in Data Extraction from Teradata and Flat Files using SQL assistant
• Worked wif teh co-testers closely in determining both medium and high severity defects, that would potentially affect teh downstream systems before teh release of teh project.
• Involved in Integrating and Functional System Testing for teh entire Data Warehousing Application.
• Used HP Quality Center for defect tracking, developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards.
• Performed data quality analysis using advanced SQL skills.
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfil data and reporting requirements including identifying teh tables and columns from which data is extracted
• Extensively used teh Report Inspector tool to change, multiple reports database schemas, scheduling multiple reports, deploying and publishing.
• Testing teh reports and maintenance of daily, monthly and yearly.
• Written complex SQL queries for validating teh data against different kinds of reports generated by Cognos
• Tested several data migration application for security, data protection and data corruption during transfer
• Responsible to halp testing team on creating test cases to make sure teh data originating from source is making into target properly in teh right format.
• Analyzed teh data and applied relevant transformations and verified that teh source data types are correct.
• Applied appropriate validation rules and created graph parameters to check teh validations are correct so that teh graph should stop.
• Maintained teh Traceability Matrix between Requirements, Design Components, Test Cases and Defects.
• Logged of defects in Quality Center to maintain Test requirements and to communicate teh bugs wif teh Developers
• Participate in weekly meeting wif teh management team and walkthroughs
• Involved in developing UNIX Korn Shell wrappers to run various dependency graphs.
• Created lookup files where necessary for validation of critical enterprise codes, lender identifiers and service numbers.
• Created different user defined functions for applying appropriate business rules

Environment: SQL, PL/SQL, HP Quality Center, Oracle, MS Excel, Cognos, Teradata V2R6 (Multi-LOAD, Fast-LOAD, FAST EXPORT, TPUMP, BTEQ),FACETS, Informatica power center, Teradata SQL Assistant, XML, XSLT, XSD, Xpath, XML Spy, MVS, COBOL II, JCL, VSAM Files, Putty.PEGA RULES Process Commander, DCO, PMF, TMF& MS Visio

Confidential, Albany, NY

QA Tester

Responsibilities:

• Responsible for Business analysis and requirements gathering.
• Functioned as teh Onsite / Offshore coordinator for a team.
• I has imparted and organized training to newcomers in teh team regarding different technologies like SQL, PL/SQL and different processes.
• Prepared Claim, Member, Provider Test data for test cases
• Conducted Smoke Testing of different Applications using SOAPUI
• Attending Client calls for Business understanding and Clarifications.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve teh system performance
• Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.
• Extract data from Mainframe data sets to compare against Target Values.
• Reported bugs and tracked defects using Quality Center
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked wif data quality issues.
• Involved in Data Extraction from Teradata and Flat Files using SQL assistant Designed.
• Tested several data validation graphs developed in Informatica environment.
• Tested teh reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
• Worked wif Source system Subject Matter Experts (SMEs) to ensure that teh extracts are properly mapped. Used SQL for data mapping and querying
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data wifin teh Oracle database.
• Written complex SQL queries for validating teh data against different kinds of reports generated by Business Objects XIR2
• Validated SOAP and REST services using SOAP UI pro
• Involved in data warehouse testing by checking ETL procedures/mappings.
• Performed teh tests in both teh SIT, QA and contingency/backup environments
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfil data and reporting requirements including identifying teh tables and columns from which data is extracted
• Created teh Requirement Traceability Matrix (RTM) to verify teh test scripts are in sync wif teh Business requirements in Quality Center.
• Tested several data migration application for security, data protection and data corruption during transfer
• Analyzed teh data and applied relevant transformations and verified that teh source data types are correct.
• Involved in FACETS Implementation, involved end to end testing of FACETS Billing, Claim Processing and Subscriber/Member module.
• Set claim processing data for different Facets Module.
• Logged defects in Quality center
• Tested HIPAA regulations in Facets HIPAA privacy module.
• Worked wif teh data architecture and data analyst team in designing teh model and in creation of teh data mapping documents
• Used Unix Diff command to compare two text files.
• Involved designed and developed UNIX shell scripts as part of teh ETL process to automate teh process of loading, pulling teh data for testing ETL loads.
• Created lookup files where necessary for validation of critical enterprise codes, lender identifiers and service numbers.
• Tested graphs for extracting, cleansing, transforming, integrating, and loading data using Informatica ETL Tool.
• Created different user defined functions for applying appropriate business rules
• Worked on test data and completed unit testing to check all business rules and requirements are met. Also tested for negative data to check that teh job fails on any critical error.

Environment: Quality Center, Agile, SQL, PL/SQL, Business Objects XIR2, Informatica Power Center, Mainframe Flat Files, Teradata V2R6, COBOL II, UNIX, Oracle 10G, DB2, TOAD

Confidential, Tampa, FL

EDI QA Analyst

Responsibilities:

• Coordinated wif different teams and prepared Test Plans and Test Strategy documents and halped other QA members wif Business Requirements.
• Extensively worked wif 837 and 837 P Claim files.
• Worked wif providers and Medicare or Medicaid entities to validate EDI transaction sets or Internet portals. dis includes HIPAA 4010; 837, 835, 270/271, 273, 278, and others.
• Reviewing Test plans, Test conditions, Test scripts, and Test results.
• Involved in black box testing, data driven testing, security testing, performance testing.
• Translated Use Cases into Test Cases and Test procedures and actively participated in brainstorming and walkthrough sessions.
• Supporting Team members in Preparation of Test Plan, Scenarios and teh Testing procedures.
• Prepared Traceability Matrix and mapping Requirements and Test cases
• Performed regression, integration and functional testing on teh builds of teh application
• Involved wif requirement gathering and analysis for teh data marts focusing on data analysis, data quality, data mapping between ODS, staging tables and data warehouses/data
• Conducted Backend test using SQL queries to verify teh Integrity of teh Database.
• Responsible for creating and uploading teh project artifacts in Share point site and providing release support.
• Created manualTest CasesinHP QC for variousUser Storiesbased onReleaseandSprintPlan.
• Automated Test Scripts in QTP using VBSCRIPT (Low level Descriptive Programming).
• Created manualTest CasesinHP QC for variousUser Storiesbased onReleaseandSprintPlan.
• Extensively usedQuality Centerfortest planningandUsed Rational Clear Questfor bug tracking and reporting.
• Involved In Testing teh EDIs according to HIPPA code set 834 enrolment and disenrollment in a health plan using QTP.
• Expertise in Claims, Subscriber/Member, Plan/Product, Claims, Provider, Commissions and Billing Modules of FACETS.
• Experience of Facets in Billing Entity, Premium Rates, Product Billing Component, Billing Group, Fees and Discounts, Adjustments, Claims, Provider, Member.
• Involved in FACETS Implementation, involved end to end analysis of FACETS Billing, Claim Processing and Subscriber/Member module.
• Involved in Testing Out-Bound Transactions (835 Health care claims Payment, 277 Claim Status Response).
• Performed SOAP based and Restful base web Service testing using soap UI pro for data driven testing
• Experienced in Health Informatics and HL7 standards.
• Developed Test plans and scripts using Quality Center and utilized use cases as a basis for performing Integration and System testing.
• Reported defects and bugs to development team using Quality Center.
• Involved in backend testing for teh front end of teh application using SQL Queries in Teradata data base.
• Involved in Data Extraction from Teradata and Flat Files using SQL assistant.
• Assisted in User Acceptance Testing (UAT), developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.
• Prepared test Data sets and performed data testing using teh PL/SQL scripts. Also used MS excel for data mining, data cleansing, data mapping, data dictionary and data analysis.
• Extensively used Parameterization of data from Excel as well as using MS SQL Server Database for Data Driven testing.

Environment: QC, Teradata, XML, SQL, UNIX, Windows 2000/XP,TOAD, Win SCP, MS Office suite, HP QTP/UFT, Loadrunner, VBscript