SUMMARY

• Over 7 years of progressive working experience in Software QA and Testing with diverse projects, clients and industry, over 12 years in Information Technology with added benefits of development background and support on Mainframe/AS400, UNIX.
• Expertise on Systems Development Life Cycle (SDLC; Agile/Scrum and Waterfall) and Structured Analysis using Integrated System Definition Methodology (SA - ISDM) which include Analysis, Design, Development, Testing, Implementation, and Documentations, on different platforms.
• Expertise to translate business requirements documents (BRD/FRD/SRD/TDD/Use Cases) (Business Requirements, Functional Requirements and Technical Requirements) into test strategies/plans, test scenarios and test cases.
• Worked as Lead Quality Analyst with the team of 5-7 software Tester.
• Proficiency in Time/Task management for the project.
• Very good knowledge on P&C insurance Business (Commercial and Personal Lines).
• Experience in both Manual and Automated (web testing used QTP) testing, and Analysis.
• Proficiency in Rational Quality Manager (RQM) /Quality Center (defect tracking tools).
• Excellent experience on STLC, its Methodology and used RQM and ALM (HP QC) (Defects Management Tools) for defects/bugs tracking for automated and manual testing.
• Expertise on end to end, system integration, User Acceptance Testing.
• Performed planning and development of Test Plans, Test Cases and Test Scenario to meet product’s business requirements and test execution to make Quality of software.
• Extensively used SQL to Analysis determine root cause of the problem and suggest solutions.
• Used SQL queries on different Data Bases and performed backend testing, and check data integrity and consistency, extensively used TOAD to create and run SQL.
• Analyzed test results to ensure existing functionality and recommend corrective action where necessary. Participated in UAT and wrote Test Cases for UAT.
• Maintained Test Matrix, Requirements Traceability Matrix (RTM), and also performed Gap Analysis.
• Implemented Unit Testing, Sanity (Performance) Testing, Smoke (Functional) Testing, White/Black Box Testing, Positive and Negative Testing, Security Testing, Stress Testing, Integration Testing, System Testing, Volume Testing, Load Testing, and Regression Testing of Web Based Applications and Client-Server Applications.
• Excellent understanding of Policy administration System (PAS) and testing of its components;Portals, Underwriting profitability, Servers, Forms Management, Access Control, UI GeneratorService, API, Claim process, retention and cross sell opportunities.
• Excellent working experience on IBM Mainframe (MVS) environment on multiple applications on all phases includes; Analysis, Programming, coding, testing and implementation and support new applications and maintain Legacy applications as per company’s Application Architecture using TSO/ISPF, COBOL, CICS, JCL, DB2 (Relational Data Base), SPUFI, SQL, VSAM/GDG Files, SyncSort, Easytrieve, Endeavor, Xpediter, etc
• Extensive knowledge on SAP ERP Package and components of SAP.
• Expertise on HIPPA-EDI and conversion from and ICD-9 to ICD-10.
• Expertise on DWH process which include, Data modeling (Conceptual, Logical and Physical), ETL process and tools, B.I process and tools (Erwin).
• Possess excellent organizational, interpersonal, communication and documentation skills with good process management skills along with a remarkable ability to gather requirements to bring out quality product.
• Ability to successfully manage multiple deadlines and multiple projects effectively through a combination of business and technical skills.

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Sr. QA Analyst

Responsibilities:

• Working on Pricing Solution application deal with DW (Data Warehouse).
• While working with Confidential, representing IBM, a most popular a world renewed company in Computing world.
• Prepare test plan test strategies and test cases, use BRD/FRD etc.
• Attending SCRUM on every morning.
• Performing Multi role; working as Quality Assurance Analyst/tester and as Data Analyst, as Data Analyst providing full support to Sr. Data Analyst (Specialist).
• Pricing application receiving problems which relate with business while data is loading in DW.
• Working with Data Analyst (specialist) to analyzing problems and suggesting solutions.
• All problems schedule to implement rectification every month under monthly release.
• Performing testing for all problems listed in requirement document for monthly release.
• Documenting all testing efforts in every month release document, under testing.
• Extensively working on SQL using Oracle-TOAD to create and run SQL.
• Working on MARI (Measuring Actuarial Rate Impact), it is part of Actuarial work on Mainframe.
• Using Rate Control software to modify rate and then move in to mainframe and running job.
• Modify COBOL program to meet Business requirement and tested.
• Using IBM Rational Quality Manager (RQM) for defects Management, defects Analysis, defects reporting.
• Prepare Test Strategy for all monthly releases.
• Providing daily status report for problems and testing efforts to application and Iteration Manager.

Environment: IBM Mainframe, OS/390, COBOL, JCL, DB2, Unix, Teradata, Oracle, TOAD, Rational Quality Manager, MS Office, Windows, etc.

Confidential, IL

Lead QA Analyst

Responsibilities:

• Working with 4-5 Quality Assurance.
• Using Tracker (Excel) for task and time management for jobs and QA as well.
• BCBS KC has developed own standard for this project call CDMA (Codes and Data Mapping Application).
• Participated in development of MS Access SQL utility (Model) to create and run query for verification of DataStage job.
• About 15 DataStage are working to convert DataStage Server jobs in to DataStage Parallel jobs.
• Create and run Query on DB2 for each Parallel job when completed successfully and tested by DataStage developer.
• Performed end to end testing, integration testing, User acceptance testing.
• BCBS KC using DB2 as Data base maintaining on IBM Mainframe.
• EDW consist all transactions of HIPAA-EDI.
• Using Daptiv (3rd party tool) for defect management and to communicate with developer to fix defect.
• Closely working with BCBS KC staff in Kansas City and Project Manager/Project Architecture. Involved in planning the Test Strategy for the whole testing period.
• Prepared Test Strategy, test plans and Test Cases, Scenarios as per requirements and executed as and when needed.
• Provided daily status report about problem to project Manager.
• Used MS office suite (Excel/Word/Visio etc).

Environment: MS Access, Mainframe, OS/390, DB2, Daptiv, MS office suite, Windows.

Confidential, Syracuse, NY

Sr. Testing Analyst

Responsibilities:

• Converted Business requirement document in Test planning and test cases.
• Currently working on EDW - FRDM, FRDM (Facets Reporting Data Mart) is a project under Enterprise Data Warehouse; MVP is migrating from Sagent (a Pitney Bowes ETL tool) to Informatica and Business Objects to COGNOS (a B.I. tool).
• Work on Project EDI software upgrade from and compliance.
• Worked on System Testing (functional Testing) of NYS 837I (Institutional Claims and NYS 820 Medicaid Premium Payment).
• Work closely with EDI development team (Lead Systems Analyst and Systems Analyst) to resolve issue comes up during functional testing.
• Moving data from production to test environment called refresh on bi-weekly basis.
• Performed Data Analysis, using Oracle SQL Developer to execute Queries to make sure its correctness and completeness in test environment.
• Participating in SOA and Performance testing.
• Involved in planning the Test Strategy for the project with Team Lead.
• Prepared Test Strategy, Test plans and Test Cases, Test Scenarios as per requirements and executed as and when needed.
• Using UBE (Ultra Edit) to view all EDI Transactions.
• Using Facets to check claims and benefits after data successfully moved from database to Facet Database based on Oracle database.
• Created defects in Rational Quality Manager.
• Using IBM Rational Quality Manager (RQM) for defects Management, defects Analysis, defects reporting.
• Prepare Test Strategy for all monthly releases.
• Providing daily status report for problems and testing efforts to application QA Manager.

Environment: Rational Quality Manager, FACETS, Oracle SQL Developer, TOAD, UBE (UltraEdit), Unix, MS office suit, Windows.

Confidential, VA

Sr. Application Analyst/Lead QA (Systems testing)

Responsibilities:

• Directly involved in download data from production environment to different test environment, defined in Oracle Database.
• As Sr. Application Analyst, performed QA Lead role and interact directly with QA Manager.
• Prepared Test plan test cases from BRD and FRD.
• Performed Data Analysis to make sure its correctness and completeness in test environment.
• Worked on new business as well as expansion in business areas in different states including Louisiana (New Business) Washington (New Business), Texas (TX-JP expansion), leading role on NY (NY Homeless, NY Health Plus expansion) projects.
• Participated in weekly meetings to keep up to date with issues and business changing elements.
• Executed SQL Query through MDE and then performed Manual Testing on FACETS to verify claims/Bill.
• Worked on conversion of from ICD9 to ICD10.
• Attended meetings on cross walking between ICD9 and ICD10.
• Worked on Claims, member enrollment, and billing transactions as well as ICD 9 and ICD 10.
• Reviewed Requirements to define testing scope for various levels of testing (Functional, System, Regression, and UAT).
• Worked on HIPAA Transactions and Code Sets Standards according to the test scenarios such as 270/271, 276/277,837/835 transactions.
• Recommend ways and workarounds for HIPAA 5010 (EDI X12 837,834,278,270) upgrades.
• Involved in planning the Test Strategy for the whole testing period.
• Prepared Test Strategy, test plans and Test Cases, Scenarios as per requirements and executed as and when needed.
• Validated Medical, Hospital and Dental claims in FACETS, verified Codes with description and requirements, verified adjudication process of Claims of FACETS.
• Extensively used Claims processing, Provider, Subscriber/Member, Utilization Management in FACETS, verified Co-pays and Co-insurance information in FACETS.
• Used Mercury Quality Centre (MQC) (defects management tool) for defects/bugs tracking.

Environment: Mainframe, OS/390, TSO/ISPF, JCL, COBOL, DB2, SPUFI, FACETS 4.71, MDE 4.2.3.2080 (Claim Test Pro), Oracle, SQL Server, HP MQC, MS Office, Windows.

Confidential

Lead QA Analyst / Tester

Responsibilities:

• Leading a team of 6-7 Software Tester, distributed the work among them as per their strength and knowledge and resolved issues for each tester.
• Performed task management and time management for the project/team.
• Participated in developing Test Plans, Test Cases for System Testing.
• Developed the test cases as per the HIPAA regulations (270, 271, 275, 276, 278, 834, and 837).
• Performed manual testing considering both positive and negative scenarios.
• Conducted Regression testing, identified software errors and interacted with developers to resolve technical issues.
• Performed Unit Testing, Integration Testing, Functional and Regression Testing of FACETS.
• Involved in creating test cases and test scripts in QTP.
• Performed Functionality and GUI testing using QTP.
• Provide management with metrics, reports, and schedules as necessary and participated in the design walkthroughs and meeting.
• Worked with EDI transactions 837 and 835 Remittances and validated the Claims in FACETS.
• Involved in processing Claims in FACETS and validating the full cycle process to make sure the checks are generated
• Worked on the continuous improvement of QA Process by reviewing and evaluating existing practices with standard testing guidelines.
• Used Quality Center to track and report bugs and defects and was also responsible for communicating the status to everyone involved.
• Used SQL to performed Back End Testing for data validation to ensure the accuracy of data.

Environment: Quality Center, QTP, Facets, MS SQL Server, Windows, HTML, MS Word, MS Excel.

Confidential

Sr. ETL Analyst /Data Analyst

Responsibilities:

• Involved in requirements gathering, source data analysis, and identified business rules for data migration and for developing Data warehouse / Data Mart.
• Involved in identifying and defining the data inputs and Captured Meta Data and associated rules from various source of data for ETL Process for Data Warehouse.
• Created source to target mapping documents from staging area to Data Warehouse.
• Worked on DataStage to cleansing data from VSAM as per requirement of project and then uploaded in Data Warehouse, based on Teradata Data Base.
• Created new and modified existing jobs (Proc) and JCL for test run of application on Mainframe using TSO/ISPF, DB2, IMS (DB).
• Used DB2 data and VSAM/GDG’s files as source to upload data in Data Warehouse (based on Teradata).

Environment: IBM z/OS, COBOL, VSAM, JCL, DB2, SPUFI, TSO/ISPF, Endeavor, Xpediter, SyncSort, DataStage 7.5, Teradata and utility (BTEQ, FastLoad, FastExport), MS Office, Windows.

Confidential, MI

Mainframe Tester

Responsibilities:

• Involved in planning the strategy for the testing efforts.
• Prepared Test Plans and Test Cases, Scenarios as per requirement and executed.
• Excellent knowledge on QA (STLC) Methodology used Mercury Quality Centre (Defects Management Tool) for defects/bugs tracking and for Manual Testing.
• Tested new and modified programs to check functionally of business as well as requirement of end-user.
• Conducted Unit testing and Integration testing and verified the impact manually.
• Worked and provided production support, maintenance and testing. Developed new programs and modified the existing programs to in corporate new changes.
• Supported Transportation and Utility Billing Project using TSO/ISOF, COBOL, COBOL II, MVS JCL, CICS, VSAM, DB2, SQL, SPUFI/QMF, File-Aid, Endeavour, XPEDITER, etc.

Environment: Mercury Test Director 8.0, IBM OS/390, TSO/ISPF, COBOL, COBOL II, JCL, VSAM, CICS, DB2, Easytrieve, SyncSort, Endeavor, Xpediter, FTP, File-AID, Windows 2000/XP, etc.

Confidential

Sr. System Developer (Mainframe)

Responsibilities:

• Worked as team member to launch credit cards for clients used COBOL, JCL, VSAM/ GDG, SyncSort, TSO/ISPF, Easytrieve, FTP, NDM, CA-7, File-Aid and Endeavor.
• Redeveloped RMS application running on AS/400 used RPG IV, COBOL/400, CLP/400, DB2/400, SQL, Embedded SQL, Query/400, PDM, SEU, SDA, RLU and Interactive Source Debugger, reduced processing time by 40.0%.
• Directly responsible to keep running RMS application and resolved all problems with production.
• Performed Unit testing, system testing and participated in UA testing on AS400 and Mainframe.
• Worked as effective team member in the development and implementation of credit cards for Visa for Confidential and clients (AMEX and Shopper Drug Mart) on Mainframe environment.
• Performed Unit and Integration testing.

Environment: COBOL/400, CLP/400, DB2/400, Query/400, PDM, RLU, IBM OS/390, TSO/ISPF, COBOL, JCL, VSAM, SyncSort, Easytrieve, FTP, NDM, SAR, CA-7,, MS Office, Windows, etc.

Confidential

Programmer Analyst (Mainframe)

Responsibilities:

• Worked on EDI (Electronic Data Interchange), transfer of data (in-bound) from broker system to host system (Mainframe), uploading data, into system, formatting data as data file, validating, uploading valid data in to applications, running policy application, uploading data which is still having error and sent back to broker for further rectifications.
• Worked on Commercial and Personal lines both
• Worked on Policy administration System (PAS), new policy, Claims, EDI as well.
• Worked on Insurance Package HUON (Personal and Commercial) to customize according to Canadian Insurance Standard CSIO and company standard as well.

Environment: IBM-OS/390, MVS/VSAM, COBOL, DB2, CICS, VSAM, GDG TSO/ISPF, MVS JCL, Endeavor, SPUFI, File-Aid, FTP, SyncSort, Easytrieve, XPEDITER, MVS CEDF.

Confidential

Programmer Analyst

Responsibilities:

• Actively participated in the conversion of the application and Data from Legacy Mainframe application to HP UNIX (Micro Focus COBOL and Oracle Database).
• Designed & developed aCOBOLconversion process to convert the mainframe application toMicro FocusCOBOLthat used an SQL Server DB.
• Analyzed legacy system and used that knowledge to design the new target system.
• Managed & mentored a team of developers.
• Updated production JCL.
• BuiltCOBOLdata comparison programs used for validation.
• Set-upMicroFocusenvironments in Enterprise Server.
• Investigated and solved issues raised during the testing on the new platforms.
• Designed & developed solutions for various issues that arose during migrations.
• Worked on COBOL, JCL Easytrieve, CMS/Xedit, to maintained insurance applications for auto and home (Property and Casualty).

Environment: HP/9000, IBM 3090, VM/ESA, COBOL, Micro Focus COBOL, UNIX, CMS/XEdit, JCL, IEBGENER, Easytrieve.