EXPERIENCE SUMMARY:

• Having overall 8+ years of experience in IT Industry as QA Analyst.
• Having hands on experience as Quality Analyst in ETL Testing, all web applications & Database/Data warehouse testing using Oracle SQL Developer tool & TERA DATA SQL Assistant in Agile and Waterfall testing methods.
• Having hands on Experience as a mainframe Tester using JCL, COBOL, VSAM, DB2 & CICS.
• Involved in all Phases of STLC for Agile and Waterfall methods, good experience with analysis, designing Test Execution, Defect Tracking, Test Closure and Gathering/Reporting Metrics.
• Expertise in performing different types of Testing: Black box, Integration, System, Regression and Parallel testing.
• Expertise in Testing QNXT & FACETS applications for Member Enrollment, Claims Processing, Encounter Processing and Authorization load receiving from several Vendor files.
• Expertise in Testing business critical Mainframe applications using COBOL, JCL, SQL, DB2, CICS, SPUFI, QMF, TSO/ISPF, ENDEVOR, INSYNC, File - Aid, IBM Utilities, APIs, Table bases, REXX JCL Automation utility, OPC scheduling and executing, Message Queues testing.
• Strong SQL knowledge and writing SQL procedures and great analytical skills on understanding complex SQL queries.
• Deep knowledge on data warehousing concepts and ETL tools INFORMATICA, TABLEAU & COGNOS VIEWER tools with various transformations knowledge.
• Good knowledge on cloud-based Salesforce CRM tool on admin and developer work activities.
• Automated the several EDM Business rules and Scrub rules with Java & JSON using the CAFE360 automation framework with Eclipse Oxygen.
• Expert in using Test Management Tools like HP Quality Center 9.0 & 9.2, ALM 11, IBM RQM.
• Involved in all Phases of SDLC, good experience with analysis, designing and unit testing.
• Coordinated with the operations areas and lines of business to spot out and specify complex business requirements and processes.
• Support, enhancement or maintenance existing applications. Debugging and diagnostic skills in batch processing.
• A solid understanding of structured analysis techniques. Familiar with all MS Office products (Word, Excel, Power Point & Access).
• Able to work under pressure, use own initiative and motivation to meet deadlines, juggle multiple projects, and set priorities without close supervision.
• Pro-active, flexible, enthusiastic, and results driven. Attention to detail and accuracy.
• Knowledge transition for the new joiners in the project on technical and business aspects as well. riented with good communication & interpersonal skills, an efficient team player.

SKILLS SUMMARY:

Hardware: General Personal Computer Hardware.

Operating Systems: All Versions Windows Environment, IBM ZOS/390, UNIX & LINUX

Languages: COBOL, JCL, SQL/PLSQL, C#, UNIX, APEX & VISUALFORCE

Databases: SQL SERVER, ORACLE, DB2 UDB 8.1, VSAM, TERA DATA

Web Related: HTML BASICS & VISUAL FORCE

ETL Tools: TABLEAU & IBM COGNOS VIEWER

CRM Tools: Salesforce Developer and Admin modules

Tools & Utilities: RQM, ALM, ENDEVOR, FILE-AID, SPUFI, ABEND-AID, TERADATA SQL ASSISTANT, ORACLE SQL DEVELOPER, QMF, TRACE MASTER, DUMP MASTER, TWS, QTP.

Domain Knowledge: Health Care Management (PBM, Medicaid Business and CMS), Banking and financial solutions (Investment management).

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Test Analyst - Team Lead

Modules: EDI 837 Prof-Inst for IN and OB, 834, 820, 835 EFT & ERA, 27X, Enrollment and Claims Processing.

Database: SQL Server (QNXT)

O/s: WINDOWS

Tools: FACETS 5.4, SQL SERVER 2014, EDM, FHG and NetworX, ALM, SOUP UI, POSTMAN & Eclipse Oxygen

Responsibilities:

• Leading the team with the size of 7 members includes assigning tasks on daily basis and reviewing all the test activities conducted by the team on daily basis.
• Reviewing Test Strategy, Design for the EDM, FHG, NetworX and Facets Upgrade requirements.
• Co-ordinating with Business and Dev team for open questions in design and execution phase.
• Creating the claims test data for satisfying all Business and Scrub Rules requirements for EDM.
• Creating the Claims Test Data for satisfying the Pricing Calculation requirements for NetworX
• Creating the Member Enrollments, Claims and Billing for testing FHG Application for variant type of transactions - 834, 837, 835, 820, 27X.
• Validating 837 Outbound files for Prof and Institutional, 835 EFT and ERA, 27X Response transactions.
• Develop automation scripts for EDM Business and Scrub rules with Eclipse Oxygen using CAFÉ 360 framework.
• Utilizing the automation scrips build for FHG 837 Process and identifying the defects and reporting to the team.
• Writing complex SQL for validating the test results for Business rules and Scrub rules.
• Analyzing the Stored Procedures for prior identifying the bugs helping the dev team to improve the quality of the products.
• Validating REST API response for the EOB and Member and Provider Billing information by sending the request to HCSC using SOUP UI/POSTMAN.
• Supporting offshore team with the issue that they come up and leading upfront in all the testing activities by providing adequate support in all testing activities.
• Involving in all phased of STLC and Defect Management Life Cycle.
• Providing Knowledge transfer to newly joined folks on existing system.
• Participating in all QA huddle meetings actively and forecasting upcoming risks and challenges with deliverables.
• Scheduling daily status calls with Offshore to speed up the execution and reviewing offshore assigned tasks on daily basis.
• Scheduling triage calls with Business and Dev team to discuss on open defects.
• Loading the 837 Inbound and Extracting 837 Outbound files from EDIFECS. And Submitting the 837 Outbound to State and CMS. And sending the 999 and 277CA response of 837 Inbound to the Vendor.
• Performing the Parallel testing with the existing EDIFECS system to ensure that our new FHG and EDM system is not broking the existing functionalities.
• Scheduling results review with the clients and seeking for their approval on System Integration and Parallel Testing activities.
• Helping the project management team on identifying the early risks in the projects during all the testing phases.

Confidential

Sr. Test Analyst - Team Lead

Database: SQL Server (QNXT)

O/S : WINDOWS

Tools : QNXT 5.1, MS-OFFCIE, Case Trakker Dynamo, SQL SERVER 2012 R2, TABLEAU, ALM, Clear Quest.

Responsibilities:

• Onshore Delivery POC & onshore coordinator, assigning work activities to offshore and effort estimation etc.
• Actively participated in all QA support activities.
• Worked on many change requests and incident tickets with shorter SLA’s.
• Extensively used and developed SQL scripts/queries in backend testing of Databases.
• Reviewing test plan and test design corrections and uploading the test cases in IBM RQM.
• Defects identified in testing environment are communicated to the developers using IBM Clear Quest - Defects module.
• Lead the defect triage meetings with project stakeholders and ensure it to closure.
• Using Case Trakker Dynamo preparing the all the task related to Case Management Activity.
• Using TABLEAU generating the Claims Reports and validating them against to the date flowing the SQL Server for Medicaid Members.
• Prepared daily status reports with details of executed, passed, and failed test cases and defect status.
• Validated the functionality of core batch jobs includes Inbound and Outbound file processing
• Component.
• Raise the defect and help developer in resolving the same in case of any critical issue. Keeping track of Defects and closing the defects once they are resolved after Re-test
• Providing status reports to the customer.
• Presenting Test Design or Test Result Walkthrough to Business and all project stakeholders.
• Test data preparation which requires for the team on regular basis.
• Peer reviews regard to improve artifact standards in the team.
• Leading the defect triage meetings and actively participating in all the project meetings.
• Doing production check outs after the QA delivery during the production go live date.

Confidential

Sr. Test Analyst/Sr. ETL Analyst

Languages : JCL, COBOL, UNIX SCRIPTING

Database : ORACLE, DB2

O/S : WINDOWS, Z/OS

Tools : INFORMATICA, MS-OFFCIE, ORACLE SQL DEVELOPER, ALM, PUTTY, QTP, CA LISA, TWS, Stored Procedures, FILE-AID, SYNCSORT

Responsibilities:

• Creating Detailed Design Documents for the required Phases.
• Coordinating with Onshore and distributing the tasks among the team.
• Developed complex SQL queries for querying data against different data bases for data verification process.
• Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.
• Extensively interacted with developers, business& management teams to understand the project business requirements and ETL design document specifications.
• Tested several complex ETL mappings and reusable transformations for daily data loads.
• Creating test cases for ETL mappings and design documents for production support.
• Setting up, monitoring and using Job Control System in Development/QA/Prod.
• Providing active technical support to the ongoing batch system using TWS.
• Involved in solving several business tickets without missing any SLA.
• Running the Daily batch jobs in QA region and responsible for providing test data for other teams like MYFA and AWMS.
• Coordinating the performance of my team members.
• Creating real time stock transactions using CICS screen.
• Testing - unit testing & integration testing.
• Developing test strategy, unit test cases and unit testing.
• Validating the Stored Procedures using the data available in ORACLE database.
• Daily status reporting to onshore.
• Preparing business deliverable documents.
• Functional test support & functional testing.
• Responsible for overseeing the Quality procedures related to the project.
• Tracking all the test activities using JIRA.
• Participating in Automation of Stored Procedures using CA LISA and UFT tools.
• Ensuring to execute the automation test scripts developed via UFT in various browsers and identifying the defect and reporting to the team.
• Ensure to deliver the project closure documents with project stakeholders.

Confidential

Test Analyst - Team Lead

Languages : UNIX SCRIPTING

Database : TERADATA, ORACLE, MS-ACCESS DB

O/S : WINDOWS

Tools : MS-OFFCIE, ORACLE SQL DEVELOPER, TERADATA SQL ASSISTANT, ALM, COREFTP, SNAGIT, PUTTY

Responsibilities:

• Performing analysis of CRS.
• Delivery of Sprints for every 3 weeks without missing any SLA.
• Involved in all review and clarification meetings related to Analysis, Design and Execution and making sure to drive the project in a smoother way to ensure to get it closure.
• Providing daily status in Scrum call to the Scrum master.
• Reviewing the User Story requirements with Scrum master and responsible to get the clarification and share it across the team.
• Creating Detailed Design Documents for the required Phases.
• Coordinating with Onsite and distributing the work to the offshore team.
• Coordinating the tasks among the team.
• Providing active technical support to the ongoing batch system.
• Coordinating the performance of my team members.
• Involving in Several meetings conducted for Requirement Analysis and Design queries.
• Testing - unit testing & integration testing
• Developing test strategy, unit test cases and unit testing
• Generating LTR reports for WellPoint carriers.
• Validating the reports using the data available in TERADATA database.
• Participated in daily scrum call for status update.
• Scheduling the review meetings for open queries and triage calls for discussing the open defects with Business and Dev team.
• Preparing daily status and coordinating with Onshore.
• Preparing business deliverable documents.
• Responsible for overseeing the Quality procedures related to the project.

Confidential

ETL/Test Analyst - Team Member

Languages : PL/SQL

Database : TERADATA

O/S: Z/OS

Tools: MS-OFFICE, ALM, COGNOS VIEWER

Responsibilities:

• Performing analysis of SGR.
• Creating Detailed Design Documents for the required Phases.
• Creating the SQL queries for backend DB to validate the reports generated from COGNOS.
• Coordinating the tasks among the team.
• Creation of Test Strategy, Test Plan, Test Scenarios and Test cases.
• Generating the reports using COGNOS VIEWER and validating them using the data present in TERADATA.
• Developed complex SQL queries for querying data against different data bases for data verification process.
• Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.
• Extensively interacted with developers, business& management teams to understand the project business requirements and ETL design document specifications.
• Tested several complex ETL mappings and reusable transformations for daily data loads.
• Creating test cases for ETL mappings and design documents for production support.
• Setting up, monitoring and using Job Control System in Development/QA/Prod.
• Following all phases of STLC which including Estimations, Strategy, Design, Execution and Test Closure.
• Executing the test cases using the testing tool ALM and created the defects and followed the phases in Defect life cycle management.
• Validating the reports using the data available in TERADATA database. Preparing business deliverable documents.
• Functional test support & functional testing.
• Scheduling the review meetings for open queries and triage calls for discussing the open defects with Business and Dev team.
• Preparing daily status and coordinating with Onshore.
• Preparing business deliverable documents.
• Responsible for overseeing the Quality procedures related to the project.