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 within Onsite-Offshore mode.
• Complete exposure to all stages of SDLC process with 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 with 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 with 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 withHIPPA, 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 within time frame.
• A good team player with 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 the 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 with 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 with 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:

• The Project has been implemented based on rapid Agile SDLC Methodology.
• Involved in Onsite and Offshore Model by coordinating the 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 with the track leads to gain better understanding of the 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 the Business users; interact with the business users on constant basis.
• Worked on Business Requirement Document,& Schedules. Provided project life cycle Artifacts.
• Interacted with the Business Team on continues basis, coordinated meetings with the vendor
• Provided Daily Status reports to the Business owner, Project executives & Team,
• Monitor and control the project without schedule slippage
• Analyzed requirements of the existing systems and suggested the improvised business process model.
• Assigned work efforts of different tracks to the team member, Mentoring the teams and resolving day to day issues
• Worked closely with the project Managers and assisted in creating project timeline with MS Project.
• Gap Analysis of requirements, generated workflow process, flow charts
• Defined and documented the vision and scope of the project.
• Worked closely with the PM in establishing the team goals,
• Managed the entire UAT set up & UAT testing effort.
• Created requirements for testing purpose to map with HP ALM.
• Performed data profiling and data mapping to map various source data systems to the new Basel database.
• Logged the errors, reported defects, determined repair priorities and tracked the defects until resolution using HP ALM.
• Modified data with appropriate test members, providers, and dates of service prior to being loaded via key word file to the test environments (FAC 3Q, 4Q)
• Executed test cases for the existing market’s various lines of business. (The 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 the FACETS.
• Used EDIFECS to process 837, 270/271 & 276/277 transactions and perform End-to-End testing with Payers.
• Validated Plan Profiles inIMS (Main Frames)andDiamond (Claims processing system)
• Prepared837 filesfor Electronic claims submission for ITS Claims.
• Worked on the HIPAA 4010 conversions and worked on the EDI 834, 837, 835 and 278 files and validated the functionality according to the new HIPAA 4010 changes.
• Worked on the EDI 834 inbound and 834 outbound data movement with our trading partners.
• Extensively performed Functional, Integration, Regression, GUI and Web Testing
• Coordinated with the developers and IT architects to design the interface of the new system according to the X12 (270, 276, 278, 834, 837 (I, P, D) and 820) standards
• Tested Cognos reports to check whether they are generated as per the company standards
• Performed both Manual and automation testing during the 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 with a good understanding of defect severity.
• Executed test script using Rational Quality Manager (RQM).
• Worked with Development team to articulate the defect clearly and ensure the errors are fixed and did not occur again.
• Involved in testing the Cognos reports by writing complex SQL queries
• Tracked and logged Defect and Issue using defect tracking tool Rational Clear Quest and document the defect with greatest level of detail based on the understanding of the application.
• Conducted Smoke Testing of different Applications using SOAPUI pro. Involved in designing the mock-up screens of the new GUI for claim entry
• Primarily focused on the system, integration, release, regression and automation testing the 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 with the 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 the development lifecycle.
• Verify that applications meet specified performance requirements.
• Experience with 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 the requirements gathering phase by reviewing the source data model and running SQL queries.
• Performed complex defect reports in various environments like UAT, SIT, and QA etc to ensure the proper delivery of the application into the 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 the 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 within the Oracle database tables.
• Tested web services by generating XML SOAP requests and validated the corresponding XML SOAP responses.
• Supported new business requirements by extending the functionality of the core Facets system using the Facets extensibility architecture feature.
• Gathered requirements from the users and analyzed the requirements for RQ System, Facets etc.
• Worked withFacetsApplication 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 with the State to review and modify process flows to increase productivity and effectively utilizeFACETSfeatures not provided by the legacy systems.
• Performed Functionality and GUI testing using QTP.
• Extracted Data from Teradata using Informatica ETL and DTS Packages to the target database including SQL Server and used the 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 the 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 the job fails on any critical error.
• Involved in Data Extraction from Teradata and Flat Files using SQL assistant
• Worked with the co-testers closely in determining both medium and high severity defects, that would potentially affect the downstream systems before the release of the project.
• Involved in Integrating and Functional System Testing for the 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 the tables and columns from which data is extracted
• Extensively used the Report Inspector tool to change, multiple reports database schemas, scheduling multiple reports, deploying and publishing.
• Testing the reports and maintenance of daily, monthly and yearly.
• Written complex SQL queries for validating the 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 help testing team on creating test cases to make sure the data originating from source is making into target properly in the right format.
• Analyzed the data and applied relevant transformations and verified that the source data types are correct.
• Applied appropriate validation rules and created graph parameters to check the validations are correct so that the graph should stop.
• Maintained the Traceability Matrix between Requirements, Design Components, Test Cases and Defects.
• Logged of defects in Quality Center to maintain Test requirements and to communicate the bugs with the Developers
• Participate in weekly meeting with the 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 the Onsite / Offshore coordinator for a team.
• I have imparted and organized training to newcomers in the 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 the 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 with 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 the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
• Worked with Source system Subject Matter Experts (SMEs) to ensure that the 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 within the Oracle database.
• Written complex SQL queries for validating the 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 the tests in both the 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 the tables and columns from which data is extracted
• Created the Requirement Traceability Matrix (RTM) to verify the test scripts are in sync with the Business requirements in Quality Center.
• Tested several data migration application for security, data protection and data corruption during transfer
• Analyzed the data and applied relevant transformations and verified that the 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 with the data architecture and data analyst team in designing the model and in creation of the data mapping documents
• Used Unix Diff command to compare two text files.
• Involved 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.
• 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 the 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 with different teams and prepared Test Plans and Test Strategy documents and helped other QA members with Business Requirements.
• Extensively worked with 837 and 837 P Claim files.
• Worked with providers and Medicare or Medicaid entities to validate EDI transaction sets or Internet portals. This 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 the Testing procedures.
• Prepared Traceability Matrix and mapping Requirements and Test cases
• Performed regression, integration and functional testing on the builds of the application
• Involved with requirement gathering and analysis for the 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 the Integrity of the Database.
• Responsible for creating and uploading the 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 the 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 the front end of the 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 the 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