Employment Overview

• Have 6 years of extensive experience in IT industry in software Testing and integration of various applications, worked as QA Tester.
• Hands on experience in Software Testing process, which includes executing tests, record results, test reports and defect tracking.
• Highly skilled in creating and executing Test Cases and having good knowledge in QA Methodologies.
• Extensive experience in Functional, Integration, Regression, User Acceptance.
• Have experience in Healthcare core processing systems Facets.
• Have experience in Testing Client Server and Web based applications
• Experience in Automated testing using QTP and Manual testing.
• Good Knowledge in understanding applications developed using ETL tools Informatica Power center
• Hands on experience in preparing the data according to the project requirements
• Strong in Analyzing Business spec and Develop Test Plans, Test Scripts & Test Cases and Execute them.
• Strong skills in back end testing using DB2, Oracle.
• Experience in writing Test cases, developing and maintaining Test scripts.
• Experience in Software Development Life Cycle and Testing Methodologies.
• Experience working individually and in team environment.
• Good knowledge of identifying various test scenarios in accordance with the Functional Requirement Documents and Use Cases.
• Holds strong ability to handle multiple priorities and prioritize workload.
• Ability to interact with developers and product analysts regarding Testing Status and Defect & Change Tracking using Quality Center and Clear Quest.
• Extensive experience in testing different file formats like XML, VSAM and Flat file
• Having excellent communication skills and fast learning capabilities.
• Excellent analytical, problem solving and technical skills.

Technical Skills:
Languages : C/C++, Java, SQL and PL/SQL
Databases : DB2 9.2, Oracle 9i, Sybase central, Winsql
Operating Systems : Windows 95/98/NT/2000, UNIX.
Automated Tools : Quick Test Pro 8.1
Bug Tracking Tools : Mercury Quality Center 10
GUI : Visual Basic5.0/6.0
Others : MS Office, Lotus Notes

EDUCATION:

Bachelor’s in Engineering.

Project Summary:

Confidential, Mar\'12 to Present
QA Tester
Description: Blue Cross Blue Shield - HealthNow New York Inc. has been an innovator in providing quality healthcare services to companies and individuals. HealthNow does business as BlueCross BlueShield of Western New York, BlueShield of Northeastern New York, HealthNow New York, and Brokerage Concepts, Inc. HealthNow provides the full spectrum of healthcare services and innovative funding arrangements. It meets the needs of more than 13,000 client companies throughout the United States, including many international businesses.
I was involved in Project Transform initiative to replace the Company’s core operating system (Facets) with the AMMS system built and maintained by Blue Cross Blue Shield South Carolina. Based on the current claim processing system(Facets) and tools used in HealthNow, analyzed the design requirements of proposed claim processing system(AMMS) and written test cases for various scenarios.

Responsibilities:

• Developed, modified, and documented test cases from approved project requirements and design as related to Claims processing system.
• Created test scenarios based on business requirements.
• Daily kick-off meeting with QA Lead and the team to discuss on issues and daily tasks.
• Prepared weekly status reports on the tasks assigned.
• Analyzed data models of proposed data marts and existing operational DB.
• Worked on Sybase central, Winsql tools for accessing DB2, Sybase and SQLSERVER databases.
• Analyzed current claims data model tables and relationships and wrote queries to understand the data related to Claims processing
• Participated in review meetings with team lead and peer reviews of test cases to ensure adherence to standards and ensures test case completeness
• Involved in importing Requirements and uploading test cases and test scripts to Quality Center.
• Test data entry into Facets application in the test environment for creating groups, subscribers and family members.
• Tested the EDI 837 interfaces, developed test cases and test scripts for 837, 835, Institutional and Professional HIPPA transactions.

Environment: Facets, Tiger, SharePoint site, UNIX, Sybase, SQLServer, DB2 9.2, Windows2000, Sybase central, Winsql and Quality Center.

Confidential, Nov\'10 to Feb’12
QA Tester /QA
WA-MMIS
Description: The Washington State Department of Social and Health Services (DSHS) is replacing its\' current Medicaid Management Information System with a new payment processing system we have named ProviderOne. ProviderOne will be DSHS\' primary provider payment processing system. When fully operational, it will pay about 100,000 providers who serve 1 million people who qualify for DSHS services each year.ProviderOne is being developed with unprecedented cross-administration support within DSHS - hundreds of DSHS employees have participated in discussion on development and design.
The ProviderOne system has Several Sub-Systems like Provider, Claims, Financials, Contract Management, Reference, Prior Authorization, Client, Interfaces, Conversion Testing, Data warehouse etc subsystems. I worked for Interfaces, Conversion Testing and Claims-screens. In Claims the Provider can submit the claims (Institutional, Professional, and Dental) online and then after it goes to the adjudication Process to verify the claim submitted is correct or not according to the standards.
In Interfaces, we will get data in form of MQ messages or flat files from the external systems such as ACES, SEMS, CMS, CSHCN, AFRS etc.


Responsibilities:

l Worked under general guidelines established in the Test Strategy, day-to-day instruction and assignments from the Test Lead/Test Manager.
l Developed, modified, and documented test cases from approved project requirements and design as related to Informatica ETL jobs
l Created test scenarios based on business requirements.
l Uploaded and scheduled test cases in Quality center.
l Performed SIT/UAT testing by running ETL jobs, validating data loads, troubleshooting job execution errors and executing test scripts.
l Performed Data completeness, transformation, quality checks and reconciliation(checksum or Record counts) on the incoming and target data that was loaded using ETL jobs.
l Worked with TOAD, SQL developer for accessing DB2 & Oracle database.
l Created/Modified/Executed SQL Queries to verify the data from Oracle and DB2 databases.
l Responsible for carrying out manual testing for Functionality testing, System, Integration testing and various phases of testing.
l Captured results following established project standards for testing and defect management
l Worked closely with developers in reproducing bugs reported.
l Used Quality Center to store, tracking and reporting bugs.
l Interacted with developers & various members of team to discuss and resolve defects and their priorities.
l Interacting with Developers and Business Analyst regarding requirements, test scenarios, and defects.
l Created test data, as required, to support planned tests.
l Provided testing status updates to the Test Manager.

Environment: DB2 9.2,Oracle 9i,VB, Windows2000, SQL, Toad, SQL developer, Quality Center, Data Stage.

Confidential,MD Sep\'09 to Oct’10
QA Tester
SD-MEDX

Description: The South Dakota Department of Social Services is replacing the current Medicaid Management Information System with a new system we have named South Dakota Medical Electronic Data Exchange (SD MEDX).
Our common goal is a system that enhances our ability to meet the needs of the individuals we serve, offers more efficient claims and payment processes, enables access to the information most useful to our providers and recipients, and helps us to more effectively manage Medicaid operations. When fully operational, it will pay about 10,600 providers who serve more than 130,000 people annually.
I involved myself in many Phases of testing in Conversion Testing and the Data warehouse. These are some of them—
I have loaded the legacy data from the old SDMMIS flat files into the SD MEDX system. Tested whether the data that got loaded is according to the specifications or not. We have tracked our defects through Quality center. Ran data stage jobs in order to test whether the data is getting loaded properly to the ware house or not and checked whether all the data got loaded using the required transformations specified in the mapping documents using SQL.

Responsibilities:

l Worked under general guidelines established in the Test Strategy, day-to-day instruction and assignments from the Test Lead/Test Manager.
l Developed, modified, and documented test cases from approved project requirements and design.
l Created test scenarios based on business requirements.
l Worked with TOAD for accessing DB2 database.
l Created/Modified/Executed SQL Queries to verify the data from Oracle and DB2 databases.
l Responsible for carrying out manual/automated testing for Functionality testing, System, Integration testing and various phases of testing.
l Captured results following established project standards for testing and defect management
l Worked closely with developers in reproducing bugs reported.
l Used Quality Center to store, tracking and reporting bugs.
l Interacted with developers & various members of team to discuss and resolve defects and their priorities.
l Interacting with Developers and Business Analyst regarding requirements, test scenarios, and defects.

Environment: Flat file and DB2 9.2, Oracle 9i, Windows2000, SQL, Toad, SQL developer, Clear Case and Quality Center.

Confidential,TX Apr\'08 to Aug’09
QA Tester /QA
BACARDI

Description: BACARDI stands for Bank of America CARD Information warehouse. It stores all the CARD customer information in DB2 tables and makes it available for the Business users to make decisions and generate reports. It stores different Line of Business Information such as Consumer Credit, Small Business, Government and Merchant accounts for more than 5 years retention. For each LOB, it receives data from multiple upstream applications in the form of Flat, VSAM, XML files and direct table pulls from DB2 & Oracle databases. The maestro batch process will execute Daily, Weekly, Monthly and quarterly basis, process the data, apply transformation on the data and finally load it into DB2 tables. Using Information Power center jobs, the data get processed in multiple stages such staging tables, apply transformations on the staging table data and finally load it in the PERM DB2 tables.
CARD IVR data is stored in Oracle tables and BACARDI has an interface with it. On daily basis, Informatica jobs will directly pull data from Oracle tables and load it in the DB2 data ware house tables. It will join multiple IVR input tables, apply transformations and load it in DB2 tables.

Responsibilities:

l Developed, modified, and documented test cases from approved project requirements and design as related to Informatica Power Center ETL jobs
l Created test scenarios based on business requirements.
l Created/Modified/Executed SQL Queries to verify the data from Oracle and DB2 databases.
l Performed Data integrity checks, Range of values, types of values, negative checks and reconciliation process on the incoming data.
l Responsible for carrying out manual testing for Functionality testing, System, Integration testing and various phases of testing.
l Captured results following established project standards for testing and defect management
l Worked closely with developers in reproducing bugs reported.
l Used Quality center to store, tracking and reporting bugs.
l Interacted with developers & various members of team to discuss and resolve defects and their priorities.
l Interacting with Developers and Business Analyst regarding requirements, test scenarios, and defects.
l Created test data, as required, to support planned tests.
l Provided testing status updates to the Test Manager.

Environment: AIX , DB2 UDB, Oracle, Windows2000, SQL, Toad, SMGT version control and Quality center, Informatica power center 8.1.1.

Confidential, Apr’07 to Mar’08
Test Engineer/QA
Web-Bank

Web bank is a service for the customers provided by SCB so that customers can access their accounts and send payments from any part of the world through internet. The payments are routed through STS and captured in DB after validating the data. The payments will be sent to back office for processing and once the payments are processed they will be sent to the back office through ISIS mechanism. Once the payments are processed by the back office they are sent back to STS DB and latest status of the payment is captured into DB. Customer will be able to track the status of his payment online at any point of time

Responsibilities:

• Worked with Business Analyst to review business requirements then translate those into test cases.
• Worked on Automated testing using QTP tool.
• Developed and executed manual test cases to test functionality, data integrity, and negative scenarios.
• Utilized Mercury’s Quality Center for test case development and defect tracking.
• Participated in Walk through of test plans and test cases.
• Backend testing of the DB2 by writing SQL queries to test the integrity of the application and oracle databases using TOAD.
• Coordinated and scheduled UAT Testing with the various Business Units.
• Reported daily and weekly testing progress to the QA manager.
• Helped to manage defects by leading the daily defect meetings and then upgrade the defects accordingly.
• Communicated defects to development found during testing and ensured all high and urgent priority defects were resolved prior to implementation.

Environment: Manual Testing, Quick test pro, Quality Center, Java, Java script, Oracle, XML, HTML.

XML, HTML.