SUMMARY:

• 9 years of experience in Quality Assurance Testing of Web, Client - Server and Mainframe based applications.
• Strong expertise in testing Data warehouses and ETL testing.
• Experienced working in Waterfall and Agile methodologies with knowledge in Software Development Life Cycle, QA Life Cycle, and software engineering standards like RUP and CMM.
• Information Technology experience involved in various Business Domains including Banking, Financial and Point of Sale.
• Good understanding of ETL testing principles and concepts
• Ability to perform backend data validation/testing
• Conducted Quality Assurance tests and Data Warehousing and ETL projects.
• Experience in ETL Testing/Data warehousing testing /Data Quality testing.
• Experienced in creating Test Plans, Functional Test Strategies, and Test Cases, working with Test Data, executing Test Sets, identifying and reporting Defects.
• Solid working knowledge on EDI 834, 820, 837 and 835.
• Involved in verifying payment (remittance) retrievals by using ASCX12N 820 for the Binder Premium payments; ASC x12N 834 for the Inbound Enrollment and Maintenance
• Experienced in Manual and Automated testing using tools like Quick Test Professional, Performance Centre, JMeter, Selenium, WinRunner for Functional, Regression and Performance testing of Web and Client-Server based applications.
• Proficient in all types of testing including System, Integration, Regression and Performance.
• Extensive experience in defining testing methodologies, designing test cases, verifying and validating web-based applications and documentation based on standards for software development.
• Good experience in Back-End Testing using SQL queries on Toad, P/L SQL to validate the consistency of data.
• Experienced in maintaining Requirements Traceability Matrix (RTM), capturing data flow from multiple Sources, Scope Breakdown Document.
• Good experience in tracking bugs and created reports using test management/defect tracking tools like HP ALM, and documented Test Documents Using MS Office Tools - Word and Excel.

WORK EXPERIENCE:

Confidential, NYC, NY

Sr. QA Tester/ ETL Tester

Responsibilities:

• Tested eligibility criteria, scenarios(positive/Neagtive), Created scenarios/data, run the scenarios for eligibility determination, validation on HCR Curam, Connecture, Self Registration Portal as per the State requirements, user stories, functional design documents and validated the data in the datawarehouse as per the business requirement.(end to end process).
• Extensively used Data warehouse ETL methodology for testing and supporting data extraction, transformations and loading processing in a corporate-wide-ETL Solution.
• Extensively involved in validating End-to-End workflows that involves self registration, eligibility criteria, plan shopping, and data flow through the integration layer, EDI(834, 837P, 937I, 837D,270,271,276,277) and Medicaid enrollment data transmission(medicaid management information system MMIS).
• Developing strategic testing plans to achieve performance quality by coordinating with the project manager.
• Tested several different types of reports including Report Layout, Naming Conventions, Totals, and Sub-Totals, Drilling options, prompts, metric calculations, drill maps and security filters.
• Reviewing testing documentation to ensure that it meets the software development and testing standards
• Evaluating defect metrics data and updating the findings to the appropriate management
• Examining the level of testing process to ensure product quality
• Providing recommendations to improve testing process for supporting quality assurance initiatives
• Escalating unresolved problems to senior staff and provide guidance to less experienced testers
• Developed and implemented test cases as a part of ETL testing.
• Develop Test Scenarios, Test plan, Test Cases, Test Suites, Test Scripts.
• Validated the Carrier admin portal that includes carrier certification, health and dental plan upload and approval.
• Validate the data in the database using SQL, middleware request and responses through soapUI.
• Validated the report generated out of Cognos against the datawareshouse.
• Tested Regression EDI 834, 820 Transactions following the HIPPA compliance EDI Standard of X12.
• Used QTP to write Data driven test scripts to handle positive and negative sets of data.
• Worked on 837,835, 834,276 and 277 Institutional and Professional, EDI Gateway.
• Responsible for creating the test plan and designing test cases for the EDI 834 members' enrollment file loading Created reports that included a general overview, open bugs, new bugs and enhancement requests. Entered new bugs and maintained the current status of those bugs.
• Wrote complex SQL queries to validate data in database.
• Utilized HP Quality Center for test plan creation and execution. Involved in Regression testing using QTP
• Mapping of Requirements to Test Cases, ensure that all requirements are covered.
• Involved in Smoke Testing (in each build), System Testing, Functional/Non-Functional Testing, Regression Testing(in each Sprint), Cross-Browser Testing, End to End Testing, and supported UAT.

Confidential, Rochester, NY

Sr. ETL Tester/ BI Tester

Responsibilities:

• Worked with several states Health Exchange Application to enroll a member, validated the subsidies against APTC calculator, selected various metal plans, verified payment integration with Siebel and Carriers, and verified 834 generation in Siebel.
• Responsible for validation of Target data in Data Warehouse and Data Marts which are transformed and loaded using Data warehouse ETL Informatica Power Center.
• Interacted with Carriers (Health Insurance companies such as UHG, MVP Health, Delta Dental) team during 834 processing and during meetings.
• Worked on EDI 834 for member enrollment and maintenance through Vermont Health Connect Application during which I verified the EDI 834 flat files for New, Change, Termination & Cancellation and Re-enrollment for new Enrollment periods in Facets.
• Verified the 834 flat files for Open Enrollment and SEP for different scenarios.
• Validated different loops and segment of Enrollment &Maintenance (834) generated for different scenarios.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
• Verified the Inbound and Outbound 834 generated for CHIP, Medicaid, APTC and QHP flavors scenarios.
• Verified the all the values and data in backend using simple and complex queries using Toad, P/L SQL.
• Worked with legacy system ACCESS and CHIP program.
• Analyzed various requirement documents such as Project Requirement Documents, Functional Specification Documents, Technical Design documents, Use Cases, various rule books from state, Gap Analysis document in order to create test data, test cases, test scenarios.
• Worked on 837 I and P, sending the batch request for mock files to Dev. team, after batch is completed I validated the claims are populating in Facets or not as expected.
• Validated the data transformations developed by DB2 stored procedures and Ab Initio.
• Involved in validation of the data in 837 transactions in accordance to companion guide.
• Running the mock file inClaredi in order to check the HIPAA compliance
• Worked on Member/Subscriber, Billing and Claim Processing modules of Facets.
• Participated in scrum meetings, stand-up meetings, BA/QA meetings to co-ordinate with Dev team, BA team, State of Vermont and get update of status of the project.
• Logged defects in ALM, linked them to appropriate test cases and requirements and assigned them accordingly and communicated with the QA, BA and Dev team regarding the defect in defect triage calls or War Room
• Participated in Project Requirement Documents walk through meetings, Gap Analysis sessions with Project managers, BAs, IT Architects and developers in order to create test cases, test data.
• Participate in JAD sessions, Walkthrough meetings, Defect Triage meetings, Daily Scrum meetings, Stand up meeting, Sprint planning meetings throughout the various projects within Optum.
• Participated in JAD, JAR sessions with the Client and BSBS and maintained meeting minutes and upload them in SharePoint
• Performed regression testing, End to End, GUI testing, Backend testing, functionality testing, integration testing, UAT testing etc throughout different releases.
• Created test cases in MS Excel and uploaded the test cases in HP ALM, and link the test cases with the requirements.
• Participate in regular scrum meetings to coordinate the progress or risks and the ways to mitigate those risks.
• Participated in Defect Management Life Cycle and Software Development Life Cycle where I interacted with large number of team members such as BAs, QAs, Dev team, Project managers etc.
• Managed documents Issue logs, Query logs, Team Status Reports in SharePoint for easy access of the QA team and management.
• Worked with the State, Architecture, QA and the Dev teams to ensure that all deadlines are met and the required deliverables are produced as per the project.
• Wrote SQL queries to perform the Back End testing of the Oracle database to ensure data integrity.

Confidential, Lexington, MA

ETL Tester/ BI Reports Tester

Responsibilities:

• Review and understand the technical and functional specs for business logic and requirement.
• Understand the business intelligence of data warehousing environments and the data flow from the source systems to the target systems.
• Develop test strategies and approaches that align with business users.
• Work with the Development team to ensure feasibility of design and clarify user requirements.
• Wrote Initial and Incremental load ETL test cases to validate the data flow between each layer in datawarehouse system (i.e source to Ingest to ECS to DCS layers)
• Created ETL test data for all ETL mapping rules to test the functionality of the business systems.
• Develop test plan, test scenarios, scripts and test cases that match the business user's objectives to confirm the system functions are met.
• Develop complex SQL queries/scripts involving joins, aggregate functions, sub-queries etc.
• Used Netezza database to write complex SQL queries to fulfill Backend Testing
• Used SQL for Querying the SQL Server database for front end ecc application to source data validation.
• Involved in Data Analysis for the data warehouse and data mart system for the process of report generation.
• Worked with Data Warehousing developers who extensively used informatica, to design mapping to move data from source to target database using Stages to do the functionality.
• Involved in all phases of SDLC steps and all the project meetings, review meetings.

Confidential, Cary, NC

Business Analyst

Responsibilities:

• Involved in gathering the requirements from the Business team.
• Extensively involved in Developing Components for Business Layer and Data Layer in C#.
• Used HTML, CSS and jQuery to provide uniform layout in the presentation layer.
• Used Master Pages, Partial Views, Templates and HTML Helper Extension to render multiple views.
• UI design based on HTML5, CSS3, ASP.Net MVC 5, JavaScript, JQuery, KendoUI, Bootstrap. 
• Implemented ASP.NET MVC Architecture to separate the business logic and data of the application from the presentation by creating views, controllers.
• Worked on creating Layout Pages for Razor Views to maintain Uniform look and feel across the applications and its Sub-Sites. 
• Developed models using Code-First Design of Entity Framework. 
• Implemented web based front end using ASP.NET, JQuery, CSS, HTML controls and business logic using C#.
• Developed and Implemented Web Forms using ASP.NET MVC and coded the Business logic in C#.
• Extensively used Cascading Style Sheets (CSS) for Styles, Fonts and Themes. 
• Designed and structured the SQL database to specifically use for this application. 
• Involved in creating tables, stored procedures in SQL for data manipulation and retrieval.