Prakash Chandra

acy4ws@r.postjobfree.com Harrisburg, PA 434-***-****

Summary

Solutions focused IT professional with 12+ years’ experience as a Software Quality Assurance Lead in Health Analytics specializing in ETL Testing &Web/Mobile Based Applications. Led budgets up to $25M. Agile Certified.

Goal

Obtain a leadership position in Software Quality Assurance in a fast paced and growth oriented environment

Areas of Expertise

Quality Assurance Innovation, Strategic Improvement, Analytics, and Technical Leadership

ETL Data warehouse, ODS, and BI Concepts

Risk Eradication and Mitigation Planning and Implementation

Experience

Acclaims Systems Clients: Geneia and Capital BlueCross July 2014 - Present

Geneia’s Theon analytics platform (Capital BlueCross subsidiaries) enables its clients (Payers, ACOs, Providers, and Employer Groups) to manage Healthcare costs and utilization, improve population health, and improve quality of care delivered.

Led Technical ETL QA team (12+ onsite/offshore multi-vendor resources)

Validated HL7 architecture for Master Patient Index (MPI) needed to unify records at 3 Health Systems Mirth Match & De-ID Concept Privacy Analytic

Employer/Payer/Provider/Claims Data Integration of data warehouse to connect 3 information systems

Pioneered automated data testing resulting in savings of more than 20% QA-hours

Scope covered 30+ Employer groups, 700+ hospitals, 800k+ members, remote monitoring devices, 5 HL7 interfaces, and 3 data warehouses connected to 8 information systems.

Cognizant Tech Solution Clients: OptumHealth & United Health Group May 2012 – July 2014

Worked on Optum’s Collaborative Care (CCARE) that deals with an innovative care management group for various marketplaces that are structured to improve integration and accountability of care.

Led Technical ETL QA team (15+ onsite/offshore multi-vendor resources)

Applied Six Sigma Methodology to reduce turnaround time of SLA performance report by 75%

Re-sequenced the Dev-Ops model to reduce resource by 20%

Hand-on Transformation Mapping Validation on ETL Tools (SSIS Execution with Metadata) and Reporting (Cognos) for Integration, Functional, and Regression in the Test/Sandbox Environments.

Established communication networks among Project Teams for Cause-Effect to streamline projects goals

Scope covered 15+ Employer groups, 900+ hospitals, ~1M+ members, 8 data warehouses connected to 5 information systems.

Logical Paradigm/Cognizant Tech Soln Client: OptumInsight Feb2011 – May 2012

Market Insight Report Sales, Marketing, Finance (SMF-BIDW) Ingenix (OptumInsight) Plan view

Performed as a QA Lead for Data Management Systems Team with 5-7 Onsite/offshore QA resources

Have setup and tested the QA and Staging Environment with new servers

Performed Integration, Functional, End to End and Regression Testing in the specific Test Environments.

Involved in preparation of Traceability Matrix, Test Summary Report and Bug Report.

Worked with the development team to create a suite of test data to exercises data validation and actual ETL functionality.

Scope covered Ingenix to Optum Insight rebranding 400K~ data points 12 DW Integrations Onyx Salesforce.

Logical Paradigm/ XcelTech Client: SilverChair Oct 2009 –Jan 2011

SSC Journal was a web project for AMA (American medical association) for providing medical journal’s article content online (View & Pay-Per view Service).

AMA Journal Platform prototype JAMA-Evidence Publication

Part of Agile .Net Development coded/Validate/Deploy/modify sprint for JAMA Project

Developed the object model Journal, Articles, Issues, and Sections etc.

Integrated the Pub-med API which is a web service and consumed in portal to display the search results in the widget.

Wrote Stored procedure for the data access layer and multiple classes in object model

Scope covered AMA Client portal POC Development

NOA Soft Solutions Client: EDW Extract Processing Oct 2005 –Dec 2007

Conducted Functionality, Back-end, and Regression testing for Claims data processing

Education and Certifications

2016 Penn State University Certified Scrum Master, Scrum Alliance

2008-2009 Stratford University MS Management Information (Security Specialty)

2001-2005 SVITS, JNT University B.Tech Computer Science & IT

Skills

Functional Models

OATS (Orthogonal Array Testing), TQP (Total Quality Process), Agile and SDLC Process Model, Test Case Point (TCP) Estimation, Behavior Driven Development, Data Model, Mapping Validation

Healthcare Concepts

Payer/Provider/Risk/NCQA/HEDIS/ESI/Attribution/TOS/Cost-Bucking/Attribution/Confinement/Cohorts & ID Strat/Claims/ICD10/HHS/FACETS/PBM

Test & BI Reporting Tools

JIRA, HP Rally & Quality Center 12(ALM), Cognos 8.1 (Ad-hoc package, cubes. Query/Report studio),Tableau, Trello, Service now

Work Flow

Appian, PEGA, SSIS, Data Stage, Informatica, SAS EG/DI Suite, Talend, Apache Spark, MongoDB,SoapUI

Scheduler Tools

Tivoli Work Scheduler (TWS), SQL Agent, Autosys

Databases

Oracle, MS SQL Server 2012, MS Access, Toad for data analyst, HP Vertica, Netezza, PG Admin/Post Greg

FTP Cloud Technologies

HL7, XML,S3 Archival, AWS, Electronics Communications Gateway (ECG), Win SCP/ SSH File Transfer Protocol

Testing Tools & Utilities

Ervin, Remedy, SVN,GIThub/GITLab, Zephyr Devices, Robo(Usability) & cmdMode SQL, UNIX/Linux

Contact this candidate