Resume

Sign in

Test Data

Location:
Connecticut, United States
Posted:
March 09, 2018

Contact this candidate

SHYAM GANTA

Apt ****, **** S Syracuse Way, Centennial,CO – 80111– 607-***-**** – ac4rbo@r.postjobfree.com – www.linkedin.com/in/shyam-ganta-80771751

BUSINESS AND QUALITY ANALYST

ELECTRONIC ENGINEERING ~ IT MANAGEMENT ~ PROJECT MANAGEMENT

CERTIFIED LEAD SAFE AGILIST 4.0 CSM CERTIFIED ISTQB ITIL ITSM

Health Insurance Management

Healthcare Claims Adjudication

Agile Methodology

Application Testing

Vendor’s Relationship

Quality Assurance

Data Center Testing

Cross-Team Collaboration

Databases Upgrade Testing Analytical, highly adaptable Business & Quality Analyst having experience of more the five years with extensive experience in evaluating systems aimed at improving quality and efficiency.

Strong knowledge and comfort within different environments, along with all peripheral processes.

7 years of vast experience in working on Health Insurance Platforms.

Expertise in Eligibility, Enrollment, Adjudication systems

Accomplished communicator skilled in building and strengthening relationships across functions to drive cohesive, strategic operations.

CAREER PROGRESSION

CIGNA INC. AT WIPRO TECHNOLOGIES • Denver. Colorado Jun’16 - Present

OPERATIONAL DATA STORE - BA & TEST LEAD

Ensure smooth transition from the existing vendor, understand CIGNA’s Health Insurance system and devise a testing strategy, bringing about Wipro’s proprietary Automation tools to reduce redundant and manual efforts.

Author Test Strategy, Test Plan, Test Reviews, Execution and Test Audits.

Working in Agile Teams, co-ordinate with multiple agile team, Scrum Master and Product Owner on Testing work items.

Maintain and Track Teams efforts in rally by creating User Stories and Tasks in Rally.

Involved in PI Planning, Capacity Planning, Sprint Planning, Sprint Grooming, Sprint Story Refinement and Daily Stand Up calls.

Conducted Sprint Demo and Additional Review sessions with Business Teams and Consumers to validate the volume and nature of Production like scenarios during our Testing Phases.

Informatica ETL Testing: DDL validations, DML Validations, Cross Table data Validation.

Involved in ETL testing (Informatica Power Centre) for validating source to target data transformation,

Involved in Back End Testing, understand the complex mapping logics and design queries in Oracle/SQL developer to validate data across Staging, Derived Masters, Integrated Derived Masters and Data Marts layers.

Experience in working with PL/SQL and Data Marts, validate data from Stored Procedures and make it available for consumers to test.

Co-ordinate with Source Teams ( ePRO, Proclaim, Facets and Payer systems) for Data requests

Extensively worked with downstream systems like TIBCO, 270/271, Web IT, Mobile, CCW portals during Enterprise Regression and Integrated Testing phases.

Work with Business Teams on System and Integration Test Evidence Reviews, Release Testing and co-ordinating with participating applications during Release Testing.

Devised a dashboard to automate the test data process, which has substantially reduced the Test data mining process by 15 %.

Work with a Team of System Analysts, Business and Development teams to convert the technical requirements into Functional and testable requirements.

Single Point of Contact for Testing Activities and Test Lead for Operational Data Store Systems.

TOOL:

SQL, Toad for Oracle, Trizetto Facets, Informatica Power Center, Workflow Manager, Oracle Database, PL/SQL, ETL Informatica, SOAPUI Testing, Model Based Testing Tools, ALM, Data Mining Automation, Hive - Big Data Testing, DVO, Toad Data Point, CA Dev Test Lisa, HPSM, Rally.

CORNING INC. AT WIPRO TECHNOLOGIES • Corning, New York Dec’14 - Jun'16

BIZTALK 2013 SOFTWARE TEST LEAD

Authored Test Plan, Test Scripts Creation, and Test Reviews for BizTalk 2013 Server and for Control M (Agent, Server Upgrades, File Movers) and created Test Suites for Integration and Regression Testing Phases.

Worked extensively and pro-actively with Corning Business, Technical teams to convert technical design documents into testable requirements, handled EDI testing with External vendors and Extensive Negative Testing.

Complete ownership of End-to-End integration testing involving various source and target systems with BizTalk 2013 server as middle ware, spearheaded Data Centre Migration Testing for BizTalk 2013 server (middle-ware).

Owned the Testing phases in Software development life Cycle 4 Step process maps, maintained documents required as a part of Sarbanes Oxley (SOX) compliance, controlled root cause analysis of defects during warranty phase.

Conducted Test cases reviews, test execution audits with timely reports to all stakeholders, timely execution, tested status reports to the stakeholders as well as planned requirements of the Business users during the testing phase.

Provided necessary support for the BizTalk Production Support team to handle issues during go live.

Actively provided inputs on ways to Performance Test BizTalk Applications.

TOOLS:

HP Application Life Cycle Management, BizTalk 2013 Server, Sarbanes Oxley Audits (SOX), SDLC Process Map

PROFESSIONAL EXPERIENCE CONT.…

WIPRO TECHNOLOGIES • Corning, New York Jan’16 - Jun'16

SERVICE NOW AND CONTROL -M TEST LEAD

Liaised Integration Analysis for Testing, and implemented specifications provided by Corning, spearheaded incident management, tasks service level agreements, service request fulfilment (SRF).

Coordinated Data Source Integration System Testing, Authored Test Plan, Test Schedule and Scripts as well as fared with Testing Reviews, Test Execution and Test Reporting.

TOOLS:

HP Application life cycle Management, Service Now (Software As a Service), Control-M BMC. Sarbanes Oxley Audits, SDLC Process Map, Incident Management.

PROFESSIONAL EXPERIENCE CONT.…

MEDAVIE BLUE CROSS BLUE SHIELD• Hyderabad Nov’09 - Nov'14

TEST ENGINEER AND BUSINESS ANALYST

Expertise in Healthcare Payer, Group Eligibility Systems.

Expertise in Short Term, Long Term Disability, LIFE, Accidental Death and Dismemberment, Death, DENTAL, MEDICAL,VISION claim adjudications

Expertise on Re-Insurance Processing, Medical Under Writing, Benefit Amount Calculations, Coverage Amount Calculations, Coverage Dates, Benefit Dates and other Eligibility systems

Expertise COLA, Offsets, Integration Incomes, Rehabilitation Amounts, Claim Payable Calculations.

Good knowledge on Master Data Management, Hosted Carrier Book of Business, Explanation of Benefits and Payments.

Good hands on experience on End-End Group Benefits Administration systems- Benefit Management Suite Application

Experience on EDI and Batch claim processing.

Performed Functional Testing, Integration Testing, System Testing, Regression Testing, User, Acceptance testing (UAT), White Box Testing, Black Box Testing, Smoke Testing, compatibility testing, ad-hoc testing, End to End testing, Language Testing and Non Functional Requirement Testing

Extensive experience in Test Case/Test Scenarios/Test Conditions Creation from Use Case, Test Case Execution, Test Data

Preparation, Test Environment Setup, Defect Verification and Management

Expertise in QA methodology and Software Development Life Cycle (SDLC).

Strong understanding of project life cycle and SDLC methodologies like Waterfall

Involved in preparing Test Plans, Test Cases, and Test Procedures and Test Scripts for System based application.

TOOLS:

HP Quality Center, SOAP UI, Microsoft Excel- VB Macros

EDUCATION AND CERTIFICATIONS

BACHELOR OF TECHNOLOGY IN ELECTRICAL AND ELECTRONICS ENGINEERING, Chaitanya Eng. College

CERTIFICATIONS

ISTQB - Foundation Level Scrum Master Certified Lead Safe Agile 4.0



Contact this candidate