SUMMARY

• Over 13 years of experience in SDLC and QA Life cycle and involved in analysis, design and Quality Assurance of Web, Client - server, ETL (Informatica and Datastage) and Mainframe applications for Financial, Healthcare & Health Insurance (HIPPA and EDI), Technology, POWER and JDA Warehouse and Transportation systems.
• Expertise in Manual and Automation Testing.
• Testing Methodology and Test Plan Formulations.
• Test Case analysis and design, Test Script development and Test Coverage.
• Test Summary Reports and Defect Tracking.
• Extensive experience in working on Agile/Scrum Process, Water Fall methodology, RUP and CMM.
• Requirement analysis, use-case analysis, changes management and configuration management.
• Functional/GUI/Regression automation using Rational Robot and QTP, Winrunner.
• Defect tracking and change management using Quality Center, MS TFS, ClearQuest, Test Director.
• Unit Testing, Integration Testing, System Testing, Load Testing, Performance Testing, Functional Testing, Regression Testing, Smoke Testing, Database testing, User Acceptance testing and End-End Testing.
• White Box Testing by focusing on the internal structure of the software.
• SQL, PL/SQL to test database integrity using SQL Navigator, TOAD and SPUFI.
• Possess excellent communication skills and the ability to work as a team member, as well as independently
• Able to cope up with tight schedules.
• Unix Shell Scripts & FTP jobs to transfer data between servers.
• High interpersonal skills and ability to work individually and as a group member.

TECHNICAL SKILLS

TOOLS: HP/Mercury Tools (11.0/10.0/9.0 ), JIRA Software, IBM- Rational Tools, Facets 4.31/4.71

OPERATING SYSTEMS: DOS, Linux, UNIX (Sun, AIX, HP), MVS, AS/400, Windows XP/NT

LANGUAGES: C++, VC++, Java, COBOL, PG/400, JCL, SQA BASIC, TSL and 4Test.

GUI: Developer/2000, Visual Basic 5.0/6.0.

DATABASE: Oracle 11/10g/9i, SQL Server, Sybase, DB2, Adabas, IMS and MS Access.

INTERNET TECH: HTML, XML, Java Script, VBScript, ASP, JSP Java Beans, EJB, RMI, CORBA, MQ-Series, FTP, Perl, TCP/IP, J2EE environment

WEB SERVER: Java Web Server, BEA WebLogic, IBM Websphere, IIS.

PROFESSIONAL EXPERIENCE

Confidential, MD

Senior SIT Tester

Responsibilities:

• Involved in test plan and test case preparation forSITand wrote SQLscripts based on STM Logic and extended business rules for MEMB, MEMB ENRLT, CLM HDR and CLM LINE tables.
• Extensively usedSQLqueries for data validation andbackedtesting.
• Processing of claims and adjudicating them using Facets.
• Tested Subscriber/ Member - Group/Subgroup and Subscriber/Family, Claims processing (MedicalClaims/Hospital Claims and Dental Claims), Billing, Utilization Management modules of the FACETS application..
• Validating the data files from source to make sure correct data has been captured to be loaded to target tables.
• Worked extensively onHP ALM (QC)to track requirements, test conditions and defects.
• Prepared test cases based on business requirement and business rules and uploaded test cases to theHP ALM.
• Tested theETLmapping and otherETLprocesses (Data Warehouse Testing).
• Performed data analysis inOracleSQLdeveloper for parallel testing.
• TestedSQLqueries to validate the data and performance of the database.
• Coordinated the EDI efforts and Facets upgrade.
• Processed the Medical and Hospital Claims in Facets Medical/Hospital Claims Processing applications
• Involved data analysis for source and target systems.
• Extensively usedETLmethodology in testing for supporting data extraction, transformations and loads.
• Reviewed extensiveSQLqueries with complex multi table joins, views, functions and nested queries.
• Built complexSQLqueries and PL/SQL procedures and functions to extract data from various source tables.
• Moved the test cases form the test plan tab to the test lab tab and executed test cases in theHP ALM.
• Conducted the defect report and test execution report using the document generator in theHPQC.

Environment: HP ALM/Quality center Version 12.55, Facets, SQL server, ORACLE SQL developer4.1.5, MS Office, Informatics power center V10.0 and MSBI

Confidential, Canandaigua, NY

Senior QA Analyst/QA Team Lead

Responsibilities:

• Participated in WMS and TMS design documents review and Requirement review meetings.
• Developed Test Plans, Test Cases, Test Scripts, Test Scenarios, Test Beds, Test Data and Traceability Matrix.
• Participated POC (proof of Concept) meetings with JDA core team.
• Provided feed back to the Business analysts regarding the Gaps in functional requirements.
• Created and maintained the overall release and project specific test strategy and scope that include the types and amount of testing based on resource capacity and skill set adhering to testing standards.
• Developed and executed the WMS core functionality test cases such as Yard operation, Receiving, System Directed Putaway, Outbound Planning, Picking, Loading and shipping and inventory control.
• Developed and executed the TMS core functionality test Cases such as Tariff Modelling, Load creation, Load planning, Load Tendering, Optimization strategies, Dock Scheduling and Invoice generation.
• Migrated and maintained Test cases for JD Edwards host system in HP Quality Center/ALM 12.01.
• Developed Test Cases and Test Scripts using Quality Center / ALM.
• Prepared Requirement Matrix using Quality Center / ALM.
• Performed JDE and TMS and WMS interface testing.
• Performed JDATMS and JDA WMS interface testing.
• Performed all phases of end-to-end testing which includes User Acceptance testing, Functionality testing, Regression Testing and system testing.
• Performed end to end testing for SO/PO orders (Outbound and Inbound).
• Tested the order status in JDE host system after the shipment reached to the destination.
• Tested EDI 204,210 and 214 transactions.
• Ran SQL queries to validate the data (how the data moves from source to target tables)
• Scheduled and Run the nightly batch jobs.
• Logged defects in HPQC and conducted defect triage meeting every day for defect statuses with management teams.
• Tracked the defects using HP Quality Center 12.01 and generated defect summary reports.
• Expertise in Agile and Coordinated Scrum Meetings and Sprint Retrospectives.
• Created the test data for interpreting positive/negative results during functional testing.

Environment: Oracle SOA, Oracle SQL developer 4.1.5 version, MS excel, MS Access, SQL, ETL, INFORMATICA, Java, Dot Net, HTML, Windows and Test Management Tool - Jira Software

Confidential, Allentown, PA

Senior QA Analyst

Responsibilities:

• Participated in Requirement Analysis, Business Analysis, Use-Case Analysis and Gap Analysis.
• Developed Test Plans, Test Cases, Test Scripts, Test Scenarios, Test Beds, Test Data and Traceability Matrix.
• Managing and Leading the testing efforts between IT & Business.
• Developing the Test Strategy, Test Plan, Test Schedules & Testing Dash.
• Managing and leading the Testing efforts between IT & Business.
• Reviewing Test Cases written by Testers and Analyzing and Building Test Data for Testers.
• Assign tasks and Monitoring the team.
• Conducted the Daily / Weekly Status meetings with the Business, Developers, Testers and Project Managers.
• Migrated and maintained Test cases for all projects in HP Quality Center/ALM 12.01.
• Developed Test Cases and Test Scripts using Quality Center / ALM.
• Prepared Requirement Matrix using Quality Center / ALM.
• Performed all phases of end-to-end testing which includes User Acceptance testing, Functionality testing, Regression Testing and system testing and its interfaces and Client-Server Utilities.
• Performed OMS - MOM/Restore interface testing.
• Performed OMS - AMI/DMS interface testing.
• Integration of AMI data with existing OMS.
• Tested the two-way communication (pricing and Energy information) between utilities and customers Via Advanced Metering Infrastructure (AMI).
• Tested the AMI Remote Connect/Disconnect functionality to all Service Points with RF Functionality, Smart Meter devices and equipment at commercial and residential premises.
• AMI Outage Management functionality to integrate two-way communication between the Smart Meter Platform & Outage Management System for detection and verification of customer or transformer outage(s), scoping and inferring outages, and verifying restoration and detection of nested outages.
• Verify and ensure that the Advanced Metering Infrastructure (AMI) mission critical applications were implemented according to specification, and met performance requirements.
• Dispatches the orders (NL, PSP and Streetlight) into MOM system and close the orders with Assessment and ERT details.
• Refer the orders and verify the status in OMS.
• Worked on confirmed circuit breaker outage, partial restoration with red tag applied at a location of loops cut.
• Tested on predicted outage on a remote operated OCR and perform a move down the order.
• Testing the orders assigned to Additional crews and verification of DUP orders.
• Created a momentary outage on a remote operated VCR.
• Performed ERT functionality in different shifts. (Day and Blue sky modes) Testing on Municipality ERT - Resetting
• Performed OMS - MOM regression testing for every release.
• Performed Auto dispatch functionality.
• Ran SQL queries to validate the data.
• Expertise in Agile and Waterfall methodology.

Environment: MS SQL SERVER 2008, MS excel, MS Access, SQL, ETL, INFORMATICA, Scripting, Java, Dot Net, HTML, Windows, MSBI, HP Quality Center/ALM 12.01, QTP, TFS and JIRA

Confidential, Allentown, PA

Senior QA Analyst

Responsibilities:

• Participated in Requirement Analysis, Business Analysis, Use-Case Analysis and Gap Analysis.
• Developed Test Plans, Test Cases, Test Scripts, Test Scenarios, Test Beds, Test Data and Traceability Matrix.
• Migrated and maintained Test cases for all projects in Quality Center 12.01
• Developed Test Cases and Test Scripts using Quality Center / ALM.
• Prepared Requirement Matrix using Quality Center / ALM.
• Performed all phases of end-to-end testing which includes User Acceptance testing, Functionality testing, Regression Testing and system testing.
• Communicate test readiness and test communication to team including business for UAT.
• Create, maintain and manage test execution phases and cycles.
• Generate testing status reports / metrics throughout the testing phase.
• Conduct defect triage during UAT for defect priority and assignment.
• Verification of Relay/ Device new settings
• Device password management verification.
• Performed Event response and investigation verification.
• Ran SQL queries to validate the data.

Environment: MS SQL SERVER 2008, MS excel, MS Access, SQL, ETL, INFORMATICA, Scripting, Java, Dot Net, HTML, Windows and HP Quality Center/ALM 12.01, QTP, TFS and JIRA

Confidential, Chicago, IL

Senior QA Analyst / Lead

Responsibilities:

• Participated in Requirement Analysis, Business Analysis, Use-Case Analysis and Gap Analysis.
• Followed Agile Process throughout the SDLC.
• Participated in Requirement analysis, Sprint Planning, Review, Walkthrough sessions with business and maintain all the release and project specific QA high-level plans (includes timelines, assumptions & risks.
• Coordinated Scrum Meetings and Sprint Retrospectives.
• Created and maintain the overall release and project specific test strategy and scope that include the types and amount of testing based on resource capacity and skill set adhering to testing standards.
• Coordinating the Testing effort to facilitate test driven development as per Scrum processes.
• Test Management done using Quality Center / ALM.
• Developed Test Plans, Test Cases, Test Scripts, Test Scenarios, Test Beds, Test Data and Traceability Matrix.
• Conducted the Daily / Weekly Status meetings with the Business, Developers, Testers and Project Managers.
• Migrated and maintained Test cases for all projects in Quality Center 10.0/ALM 11.0.
• Tested all the migrating scenarios for GCPS CONVERSION TOOL.
• Developed Test Cases and Test Scripts using Quality Center / ALM.
• Prepared Requirement Matrix using Quality Center / ALM.
• Performed all phases of end-to-end testing which includes User Acceptance testing, Functionality testing, Regression Testing and system testing of the ITS and Blue2 Application, its interfaces and Client-Server Utilities.
• All the test scenarios which have been satisfied with the functionality are moved to automation testing using QTP.
• Conducted Functional, Integration and Regression testing using QTP.
• Extensively worked on Shared Objects Repository and Re-usable functions in QTP.
• Tested Claims processing, pricing and adjudication of claims in Facets.
• Developed Test Plan on Edit Changes for all Medicare & Medicaid Claims with help of Edifecs list for ICD-10
• Conducted UAT Meetings and UAT Sessions on a regular Basis.
• Developed Cases on Reporting systems in different Roles of Diag codes for ICD-10 Implementation
• Tested the provider, Enrollment, members, Benefits, Billing and claims in Facets.
• Tested the loading of claims data into Facets.
• Creating Jobs to run daily, weekly and monthly basis to process ETL Jobs.
• Responsible for Data Warehouse and data mart testing
• Responsible for Backend testing and executing Simple and Complex SQL queries
• Wrote and executed SQL Statements to test Database Integrity.
• Performed Smoke test for each New Environment and New build in Facets 4.31 and Middleware Applications.
• Performed ETL testing and validated the target fields.
• Involved in validation of ANSI X12 5010 Transactions 837,835,270,271,276,277.
• Involved in validation of HIPAA for 837 and 835 claims used for Professional, Institutional and Dental Claims by Writing Test cases, Test Plans.
• Tested Medicare Part A and Part B claims.
• Tested Medicaid claims submitted through ITS and Blue Card.
• Created ANSI X12/EDI 5010 transactions, Processed them via EDIFECS spec builder for format and validated the EDI transactions.
• Validated HIPAA Compliance errors using EDIFECS.
• Using EDIFECS map builder converted 4010 files to 5010 files.
• Tested HIPAA 5010 Claims processing through the Clearing house.
• Extensively worked on 837 I/P/D files and Transactions for Claims.
• Involved for Professional/Institutional and Dental claims processing through Facets 4.31 (Claims ITS) and determine the amount of coverage a customer should receive according to the procedure done and the coverage on the account.
• Tested Claims in pre-adjudication process.
• Extensively worked on EDI 834 for Benefits, Enrollment and Maintenance applications.
• Conducted Integration, System, Functional, Regression, Smoke, Database Integrity and User-Acceptance (UAT).
• Verified Benefits obtained on 271 Responses against RTB-Real Time Benefits.
• Verified 277 Responses against Blue Chip & Blue Star for 4 states IL, OK, TX & NM.
• Tested both Blue Exchange & Local Transactions for 270/271 & 276/277.
• Validated both Professional & Institutional Claims.
• Hands on experience validating Local, Home & Host scenarios for 270/271 & 276/277.erm
• Worked with X12 /EDI transactions and validated the specifications/mapping for 837 transactions and 835 responses.
• Tested the database integrity by writing SQL Queries using QMF on Mainframes.
• Tracked the defects using HP Quality Center 10.0/HP ALM 11.0 and generated defect summary reports.
• Maintained Test Logs, Test Summary reports and participated in defect review / Status / GO-NOGO Meetings.

Environment: Blue Chip, Blue Star, Facets 4.71/5.01, X12 RS, MS SQL SERVER 2005, MS excel, MS Access, SQL, ETL, INFORMATICA, UNIX, Korn Shell Scripting, Java, HTML, MVS, VSAM, IMS DB/DC, COBOL, OS/z, ISPF, DB2,TSO,CICS, JCL, Copy Books, XML, Windows and HP Quality Center 10.0/ALM 11.0, GCPS CONVERSION TOOL and Jira Software.

Confidential, Cleveland, OH

Senior QA Analyst

Responsibilities:

• Developing the test strategy, test plan and test schedule and followed Agile Process.
• Coordinated Daily Scrum Meetings and Sprint Retrospectives.
• Developed Test Cases and Test Scripts for each Sprint.
• Involved in white box and Grey Box testing (C#, XML, Web Services and .NET applications).
• Developed and reviewed C# / .NET to ensure naming conversions and code optimization.
• Tested and Validated FX interfaces and FX Data.
• Developed Test Cases and Test scripts for Portfolio Management, Fixed Income, Investment, Mutual Funds, Foreign Exchange (FX) Markets, Trading, Currency Changes, Money Transfer System (MTS), Bonds, Stocks and SWIFT Messages.
• Tested the functionality of MTS (Money Transfer System), Mutual Funds and Portfolio Management.
• Validated the SWIFT messages and FIX Protocols.
• Developed and maintained Test Cases, Test Scripts and Test conditions in Microsoft Test Manager and Microsoft Team Foundation Server (TFS).
• Created and managed various Lab Environments in Lab Management of Microsoft Test Manager.
• Tracked and Managed defects using MS TFS (Team Foundation Server)
• Responsible for updating and maintaining the MS TFS for all the defects found during functional and regression testing and follow up the bug life cycle.
• Writing test cases and test scripts for functional testing, design data logic test scenarios.
• Defining test automation strategy, outlining functional test automation scenarios
• Managing the requirements traceability matrix and prioritization of test cases / scenarios.
• Executed process control and service charge type test scripts manually.
• Tested the Data Warehouse (ETL) applications developed using Informatica
• Tested ETL Mappings and Data Validation using Informatica.
• Tested DW Reports developed in Business Objects.
• Tested the source database and target databases.
• Validated the data loading process.
• Validated the data extraction process.
• Tested various transformations and rules.
• Writing SQL queries, SQL Functions, Stored procedures to validate the referential integrity scenarios
• Performed Backend Testing, by executing the SQL queries.
• Performed Database testing to verify the data using SQL to ensure integrity and consistency of data.
• Manually test the application from end-to-end and check for discrepancies.
• Wrote SQL statements to extract data from the Tables.
• Used TOAD tool to perform backend validation on Oracle DB.
• Heavily involved in procuring and mining of Data that is needed for testing.
• Created and executed SQL queries as part of Data Mining.
• Involved in recording and executing scripts.
• Designed Use cases and flow diagrams using MS-Visio
• Validated the data on Oracle.
• Created the test data for interpreting positive/Negative results during functional testing.
• Maintained Test Logs, Test Summary reports and participated in defect review / Status / GO-NOGO Meetings.

Environment: Windows, MS Visual studio 2010, MS Test Manager, MS TFS,.NET framework 4.0, ASP.NET ADO.NET, C, C#, IIS 6.0, Web Methods, MQ Series, Mainframe, DB2, TIBCO, Informatica, Business Objects, SQL Server 2005, SQL Management Studio, SQL, PL/SQL, and TOAD.

Confidential, Charlotte, NC

QA Analyst

Responsibilities:

• Gathered Business Requirements and performed Business Analysis and Requirements Analysis.
• Developed Master Test Plan, Test Strategy, Test Conditions, Test Scenarios and Work flow based on Requirements and Technical Specification.
• Created test scripts for Web Data Collector, ETL and Transform in Rational Test Manager.
• Testing of Web Data Collector and web services.
• Performed Manual and Automation Testing.
• Automated the functionality using Rational Functional Tester
• Performed extensive database testing for SQL Server and Oracle databases by using AQT.
• Involved in testing PEGA UI Version 5.
• Tested and validated the XML’s in PEGA.
• Created regression scripts for Web Data Collector.
• Reported and tracked defects using Rational Clear Quest.
• Performed extensive Regression Testing.
• Performed User Acceptance Testing.
• Followed Agile processing throughout the SDLC.

Environment: IBM-Rational Tools- Rational Test Manager, Functional Tester, Manual Tester and Clear Quest, PEGA PRPC, PEGA UI V5, Windows XP, Ms-Project, Visio, MS-Word, MS-Excel, NET, TFS, Java applications, Oracle 10G, SQL Server 2000, Advanced Query Tool, Windows XP, Ms-Project, Visio, MS-Word, MS-Excel.