Test Cases Data

RESUME

Vimal Kumar Koti ( : +1-480-***-****

*: *********@*******.***

Location: Philadelphia

CAREER OBJECTIVE

To work in a challenging environment where I can put my talent into best possible use and which allows me to improve my skills and makes me competent enough to reach higher positions.

SUMMARY OF SKILLS

10 years of Professional Experience in Software Quality Assurance and Testing in different environments and platforms. Expertise in Automation Testing & Manual Testing.

7 years of experience on Healthcare domain. Good knowledge on Claims, Providers, Membership, Case Management, EDI transactions, Medicaid & Medicare plans.

3 years of experience on banking domain. Good knowledge on Payment Systems.

5 years of experience in Data Warehouse applications testing using Datastage, PLSQL, SQL. Good Knowledge on Business intelligence, OLAP, Dimensional modeling, Star and Snowflake schema, extraction, transformation and loading (ETL) process

Experience in Business Intelligence report development using Crystal Reports. Reports testing experience on Crystal Report and Microstrategy tool.

Experience in Functionality testing, Database Testing, GUI testing, Mainframe Testing System testing, Ad-hoc testing, Regression testing, E2E testing and Automation testing using HP Unified Functional Testing (UFT/QTP), Mercury Quality Center.

Extensive experience in reviewing Business Requirement Documents, Software Requirement Documents and

preparing Test Estimations, Test plan, Test Cases, Test scripts and Execution.

Experience in implementing Cost saving best practices in the project. Good at project tracking, process related works, Maintaining SharePoint for the Project.

Experience of different roles Onsite Coordinator, Independent Contributor, Leading the projects and SME (Subject Mater Expert)

Ability to develop complicated SQL script for Data validation testing by running SQL script, procedures.

Worked collaboratively with in-house and offshore development teams and lead the team size of 4-6 members successfully by coordinating calls, getting status updates and managing resources efficiently.

EDUCATIONAL QUALIFICATION

B.Tech in Electrical & Electronics Engineering with distinction 2006 pass out.

Intermediate (M.P.C) with distinction 2002 pass out.

S.S.C with distinction 2000 pass out.

PROFESSIONAL EXPERIENCE

Company Name: Cognizant Technology Solutions.

Experience : Feb 2007 to Feb 2010

Roles : Software Tester, Onsite Test Cordinator

Had 2 months experience in ZenQA Company before joining Cognizant (from Nov 30th to Jan 4th).

Company Name: United Health Group Information Services Pvt. Ltd.

Experience : Feb 2010 to May30 2016

Roles : Associate Lead

Company Name: Optum Services, USA (subsidiary company on United Health Group)

Experience : May31,2016 to till date

Roles : Sr. IT Quality Analyst

CERTIFICATIONS AND ACHIEVEMENTS:

Software testing certification awarded by Cognizant on Feb 2007.

QTP certification awarded by Cognizant on Jan 2008.

L0 Banking certification awarded by Cognizant on March 2008

Received Appreciation award from Cognizant for best performance in Payment Hub project in 2008.

International Software Testing Qualifications Board (ISTQB) – Foundation Level Certification awarded by Indian Testing Board on Oct 2008.

Received ‘SPOT AWARD’ awarded by United Health Group for best performance in 2010.

Received ‘STAR AWARD’ awarded by United Health Group for best performance in 2012.

Academy for Healthcare Management (AHM) certification awarded by America’s Health Insurance Plans(AHIP) on Dec 2012.

Test Optimization Certified Professional awarded by TCOE, UHG in 2013.

Oracle Certified Associate (certification code - IZ0–051 Oracle 11g ) on 27th July 2015.

PROJECTS UNDERTAKEN:

1) UnitedHealth Group IT – Community & State BI

Client : United Health Care

Duration : July 2012 to till date.

Role : ETL QA Lead

Team Size : 10

Databases : Oracle 10g/11g, Oracle 12C,IBM DB2, SQL Server 2008, MS Access

Utility Tools : SQL Developer, Beyond Compare, Ultra Edit, Notepad ++

ETL Tools : Datastage

Reporting Tools : Crystal Reports, Microstrategy

Operation Systems : UNIX

Microsoft Office : Word, PPT, Excel and Visio

Programming : PL/SQL, VB scripting,SQL

Summary:

UHC Community & State Serving more than 4 million people in Medicaid, Medicare, Children's Health Insurance Programs (CHIP), SNP, LTC, ABD in 24 states and the District of Columbia and provides personalized public sector health care programs. SMART was developed in-house to store all Community & States health plans data in one unified system, utilized for business and state compliance reporting and analytical purposes. SMART is a single database instance containing data from all health plans/companies, including Diamond, COSMOS, and Facets data sources.

SMART is growing as the Community & States (C&S) business expands and requires regular upgrades. There are continuous requirements to set up new Extract, Transform, and Load (ETL) processes, upgrades to existing ETL processes, ad hoc business requests from BI teams, and new data to BI teams to comply with state requirements. As every state government health plan levies heavy penalties on health plans in cases of non-compliance or time delay for any reporting requirements, it is very critical to ensure that all reports are generated on time and contain accurate data and are submitted to states or federal regulatory bodies on time and in the correct format. SMART ETL QA has important role in maintaining the quality of the data. Below are few critical deliverables I've been part of below major projects

1.Growth & Expansion - PA New Member Data, Vendor DB 837 Feed etc

2.Internal & Corporate Initiatives (Data Migration) - Oracle 10g to 12C, ETL process upgrade from Oracle to Datastage, ICD9 to ICD10 codes conversion, COSMOS to Facets migration, 49295 ICUE replace CareOne UM Migration etc

3.Data Loads - Increase frequency of Data Warehouse loads(Weekly data load)

4.Change requests (Data integrity) - Cosmos claims interest overreported in data warehouse, Adding Auto Adjudicated Rate logic into SMART feeds, Cosmos null values being defaulted to 0 instead of -1 etc

5.Report testing - Reports generated by Microstrategy & Crystal Reports.

Responsibilities:

Attending walkthrough meetings and prepared Test Plan from the Business Requirements and Functional Specification.

Lead the SMART ETL QA team.

Developed Test Cases for Deployment Verification, ETL Data Validation, Report testing.

Expert in writing Complex SQL/PLSQL Scripts were written to verify the data in both source and target schemas to validate the Data migration

Resolve clarifications raised by the team, Subject Matter Expert for the project.

Involved in designing Test strategy, Test planning, Test estimations, Test Scenarios, Test Cases and Test Data

Worked closely with the Business Analysts, Systems Analysts, Developers, and DBAs to solve the issues

identified during the testing process in a timely manner.

Communicated discrepancies determined in testing to impacted areas and monitored resolution.

Performed Data Analysis and developed Data Mapping documents for ETL projects.

Developed SQL Queries/Scripts to perform data validations, validate reports and experience in query tuning.

Scheduling status calls and addressing release management call.

Validated reports based on Functional Requirements.

Used Mercury ALM for Bug Tracking, Reporting and Analysis.

Participate in Root Cause Analysis, Test metrics.

Participate in preparing Break Fix Document.

Ensuring that team meet milestones set by the management for the quarter.

Implementing Cost saving techniques. Organize initiatives like Cross Applications Training etc.

Involved in providing feedback and setting goals to the team.

2) UnitedHealth Group IT – COSMOS

Client : United Health Group

Duration : Feb 2010 to June 2012.

Role : Test Automation Engineer, Senior Test Engineer

Team Size : 20

Project Skills : IBM Mainframe Testing, QTP, VB scripts, ALM

Summary:

United Health Group: UHG is a 90 billion dollar company, provides high diversified health services and well being products for more than 70 million individuals. COSMOS (Comprehensive On-Line Software for Management and Operational Support) is one of United Health Group’s Claim Processing Engines, primarily used for local health plan business for small market and middle market employers. COSMOS is mainly used for gathering and maintaining member/provider/employer data calculate payments, set-up provider contracts, research historical data, perform utilization, financial, membership, underwriting, and quality assurance reporting.

Responsibilities:

Attending walkthrough meetings conducted by the BSAs for the SRSs.

Working closely with the virtual team to understand the process flow of the COSMOS application. Attend meetings with teams at different locations and do the co ordination.

Get clarifications from the BSAs.

Resolve clarifications raised by the team, Subject Matter Expert for the project.

Involved in Test planning and strategy, Testing estimations.

Scheduling status calls and addressing release management call.

Prepare Test coverage matrix and Test cases.

Prepare test data and execute test cases.

Logging and tracking the defects in Quality Centre.

Participate in Root Cause Analysis, Test metrics.

Participate in preparing Break Fix Document.

Project Deployment activities.

Support Business partners during the warranty period of the project, backout plan support.

Managing test artifacts in SharePoint and attending internal audits. Working on Non Compliances received from SQA.

3) Cognizant - Release Acceptance Testing

Client : Lloyds Banking Group, UK.

Duration : March 2009 to Feb 2010.

Role : Onsite Coordinator & Senior Test Automation Engineer

Team Size : 6

Project Skills: QTP

Summary:

Release Acceptance Testing is the last test to take place prior to deployment of changes to the live environment. It is a pre-production test within an environment that is the closest to the production environment.

Responsibilities:

Maintaining Automation Test Scripts

Performing Backout testing

Interacting with developers for any clarifications

Logging and tracking the defects in Quality Centre.

Create test cases, Review and Execute test cases

4) Cognizant - FPS (Faster Payment Service) - Payment Hub Support.

Client : Halifax Bank of Scotland plc.

Duration : Nov 2008 to March 2009.

Role : Tester/QA Analyst

Team Size : 12

Project Skills: Knowledge about Video Client, PE, PB, PG, UNIX, Oracle 9i, Text pad. Bug Tracking Tools: Test Director

Summary:

The Payment Hub support team was formed to do a regression testing of all the defects fixes that happened after the System testing of Release 3 and Release 4 and to promote the code to the next testing environment. The Payment Hub support team will run the regression pack for the following modules

1.Payment Engine

2.Payment Bus

3.Payment Gateway

4.Aggregate Accounting

5.MI Reporting

6.Reconciliation.

Based on the Bundle that needs to be tested, the team will execute the appropriate module regression after getting an approval from the Payment Hub – Test Manager.

Responsibilities:

Involved in study/analysis of business functional specifications document.

Wrote and executed various Test cases for conducting Functionality testing, System Testing and Regression testing.

Used Test Director for Software Bug tracking and reporting.

Document and report test result reports, bug reports and observations.

Participate in tele and web conferences with clients.

Interacting with developers for any clarifications.

Used Version Control to maintain documents and participated in internal audit.

Involved in training and reviewing the new resources added to the team.

5) Cognizant - FPS (Faster Payment Service) - Payment Engine

Client : Halifax Bank of Scotland plc.

Duration : October 2007 to November 2008

Role : Tester/QA Analyst

Team Size : 8

Operating Systems: UNIX, Oracle 9i, Websphere MQ

Project Skills : Knowledge about Video Client, Payment Bus, Payment Gateway, Work Flow Monitor(WFM), RPI(Remote Payment Initiation and Inquiry),Liquidity Management(LQM),USM(Un-Solicited Messages), APACS(Association for Payment Clearing Services, Secure Shell, Oracle 9i, Text pad.

Summary:

FPS (Faster Payment Service) is a new payment system going to be implemented by the UK banking services for payments which need to be done faster then BACS and cheaper than CHAPS which are the two types of paying systems currently in use in UK. This project involves system testing of the components forming the FPS.We are involved in the system testing of the Payment Engine which is an important part of the FPS .Here is where all major validations of all the transactions or payments are done and payments are processed. The testing involves posting the transactions, checking the responses, validating the settlements, checking the internal databases, validating the data obtained in the responses as well as that stored in the database.

Responsibilities:

Perform requirement analysis

Create test cases, Review and Execute test cases

Verification of the bugs and assigning severity / priority

Document and report test result reports, bug reports and observations

Daily updates to the QA Manager and Project Managers on the progress of testing

Plan and report daily and weekly activities

Interacting with developers for any clarifications.

6) Cognizant - FPS (Faster Payment Service) - Aggregate Accounting and MI reporting

Client : Halifax Bank of Scotland plc.

Duration : March 2007 to September 2007

Role : Tester/QA Analyst

Team Size : 5

Environment : Oracle SQL Developer

Operating Systems: AIX

Bug Tracking Tools: Test Director

Summary:

FPS (Faster Payment Service) is a new payment system going to be implemented by the UK banking services for payments which need to be done faster then BACS and cheaper than CHAPS which are the two types of paying systems currently in use in UK.

We are involved in the system testing of the Aggregate Accounting and MI reporting. Aggregate Accounting is the process of consolidating FPS transactions from Payment Engine for posting to Core Banking System (CBS) account categories. The transactions are retrieved from Entia to RGW database. The aggregation process will use the data store as input to create aggregate entries. The aggregate records are then associated with appropriate settlement accounts to be fed to CBS. The Transaction log generated in PH is fed to reconciliation process.MI Reporting is the process of consolidating FPS reports from Payments Hub (PH) RGW and Control & Settlement(C&S) database. These reports are validated against RGW and C&S database. These reports constitute of Daily, Monthly and ACI reports.

Involved in study/analysis of business functional specifications document.

Wrote and executed various Test cases for conducting Functionality testing, System Testing and Regression testing.

Used Test Director for Software Bug tracking and reporting.

Document and report test result reports, bug reports and observations.

Participate in tele and web conferences with clients.

Interacting with developers for any clarifications.

Used Version Control to maintain documents and participated in internal audit.

Involved in training and reviewing the new resources added to the team.

PERSONAL PROFILE:

Father’s name : Cheralu. K

Sex : Male

Date of Birth : 16th Feb, 1985

Marital Status : Single

Nationality : Indian

Languages Known : English, Hindi, Telugu, Tamil.

Visa : H1B

Declaration: I hereby declare that the information furnished above is true to the best of my knowledge.

Date: Signature

Place: Philadelphia Vimal

Contact this candidate