ASHISH AGRAWAL

+1-732-***-****

adv2c6@r.postjobfree.com

Summary

A capable and committed Business Analyst, ETL Datawarehouse Specialist, Quality Assurance Professional with 18+ years of IT experience. Possesses strong analytical and problems solving ability, good communication and interpersonal skills, excellent work ethic and the ability to work well in a team or individual environment as well as well as a team leader.

Skills --

●Experience as Business Analyst, Data Analyst, Data Warehousing, Data Modeling.

●Expertise in Data Migration, ETL Process and Business Intelligence.

●Strong analytical skills, ability to develop thorough understanding of Business requirements through direct interaction with Business Users/Analysts.

●In Depth knowledge & experience in all aspects of Data warehousing solutions (Data Discovery, ETL Development, Data Mapping, Metadata management, Data Quality).

●Experience in AWS Cloud, Redshift, AWS S3, Snowflake, DB2, Oracle PL/SQL, MSSQL, Teradata, PostgreSQL, Reltio MDM.

●Experience with ETL Test Automation Tools Querysurge, ETL Validator.

●Ability to develop complex SQL for data analysis & validation, experience with stored procedures, functions.

●Thorough understanding of different phases of SDLC, Waterfall & Agile Methodology.

●Extensively used JIRA & ALM for Test and defect tracking.

●Proficient in setting up testing processes, writing test strategy, test plans, assigning tasks to onshore/offshore team members, communication and co-ordination with team members, preparation of Daily, Weekly and Monthly Reports.

●Identifying improvement opportunities in overall test processes and implementing continuous improvement initiatives

●Interfacing with Program managers and development leads to ensure the quality of applications being delivered.

●Ability to work under stringent timelines and meet predefined project goals.

●Very good knowledge of Healthcare, Life science and Banking domain.

●Involved in all phases of projects that includes requirement analysis, Design test case design, test case execution, defect management for end-to-end IT solutions.

Key Expertise

ETL Data Warehousing, Quality Assurance, Business Analyst, AWS Redshift, AWS S3, Snowflake, MSSQL, Oracle, Teradata, Tableau, Power BI, Agile Methodology, JIRA, ETL Test Automation, Defect Management, IBM I5/AS400, UNIX, HP Quality Center/ALM

Experience Summary

Johnson & Johnson

Lead Business Analyst July 2022 – Till Date

Project Title Project Automate

Domain and Line of Business Life Sciences & Healthcare

Responsibilities

Gathering business requirement from business stakeholders/SMEs.

Defining & documenting detailed business rules, transformation, data mapping rules.

Analyzing data sources, defining source data collection & cleansing rules.

Defining detailed integration requirement specification & ensuring most efficient data flow.

Coordinating with IT Team to handover detailed mapping and business rules for development.

Regular touch base meetings with IT Team to resolve any queries related to implementation of data mapping, business rules, quality checks requirements.

Preparing UAT Test scenarios, UAT test execution ensuring data accuracy and consistency.

Preparing data catalog and handover to Business Analytics/Reporting Team.

Project

The project is to automate ingestion of Velys Robots Case Log in OneMD RADAR and integrating Case data with S&R(Service & Repair) data, Alignment, Customer Hierarchy, includes development of Surgeon Match Process to identify User NPI, Data densification and development of reporting optimized views to accomplish analytics, diagnostics, & visualization use cases.

The project scope also includes developing automated framework for ingesting Global Velys CRM data and build a semantic layer view to enable Global Velys Sales Funnel analytics &reporting.

Project Location Raritan, NJ, USA.

Johnson & Johnson

Lead Business Analyst May 2020 – June 2022

Project Title OneMD USROTC

Domain and Line of Business Life Sciences & Healthcare

Responsibilities

Gathering business requirement from business stakeholders/SMEs.

Defining & documenting detailed business rules, transformation, data mapping rules.

Analyzing data sources, profiling source data, defining source data collection & cleansing rules.

Defining detailed integration requirement specification and ensuring most efficient data flow.

Coordinating with IT Team to handover detailed mapping and business rules for development.

Regular touch base meetings with IT Team to resolve any queries related to implementation of data mapping, business rules, job schedules, quality checks requirements.

Preparing UAT Test scenarios, UAT test execution ensuring data accuracy and consistency.

Preparing data catalog and handover to Business Analytics/Reporting Team.

Project

This program is to migrate Johnson & Johnson’s Medical Devices Ordering and invoicing system from legacy JDE/PRMS ERPs to new SAP ERP system. The project is to integrate Sales and Orders data for All Johnson & Johnson Medical Devices operating companies from new ERP system to OneMD data warehouse with application of new business rules, ensuring no impact on sales analytics and reporting due to ERP migration.

Project Location Raritan, NJ, USA.

Johnson & Johnson

ETL Test Lead June 2019 – April 2020

Project Title OneMD DPS & Ethicon Payday

Domain and Line of Business Life Sciences & Healthcare

Responsibilities

Understanding Data discovery, business rules and developing Test strategy & Test Plan.

Implementing ETL Test Automation.

Providing effort estimates and testing timeline.

Guiding Team members on ETL/Data Warehouse Testing.

Review of test scenarios created by team members.

Test Execution and Reviewing Reported Defects.

Defect triaging with Development team, business/system analysts, IT PM and integration partners.

Providing daily and monthly testing status planning/execution report to all stakeholders.

Providing testing signoffs and planning evidence walk-through sessions.

Publishing testing metrics

Coordinating with Business Users on UAT.

Project

This program is to migrate Johnson & Johnson’s Medical Devices sales compensation system from SYNYGY to Optymyze & and Axtria for DPS & Ethicon companies respectively. This project is to ensure ingestion and integration large no. of Sales alignment files from new compensation systems and ensure no impact to Sales Alignment analytics & reporting due to change in sales compensation system.

Project Location Somerville, NJ, USA

Johnson & Johnson

ETL Test Lead June 2017 – May 2019

Project Title OneMD Data Backbone

Domain and Line of Business Life Sciences & Healthcare

Responsibilities

Ensuring comprehensive validation of Automated ETL Framework, Data Quality Frameworks.

Understanding Data discovery, business rules and developing Test strategy & Test Plan.

Implementing ETL Test Automation.

Providing effort estimates and testing timeline.

Guiding Team members on ETL/Data Warehouse Testing.

Review of test scenarios created by team members.

Test Execution and Reviewing Reported Defects.

Defect triaging with Development team, business/system analysts, IT PM and integration partners.

Providing daily and monthly testing status planning/execution report to all stakeholders.

Providing testing signoffs and planning evidence walk-through sessions.

Publishing testing metrics

Coordinating with Business Users on UAT.

Project

This program is to build an In-house comprehensive Automated Ingestion & Integration (ETL) Framework as well as Data Quality Framework to reduce external ETL platform dependency and reduce increasing data integration cost. This program also included implementation of JNJ Medical Devices Customer, Product & Alignment dimensions utilizing Automated ETL Framework.

.

Project Location Bengaluru, KA, INDIA

Royal Bank Of Scotland

ETL Test Lead Mar 2016 -- May 2017

Project Title Williams & Glyn's (W&G) Delivery Program

Domain and Line of Business Financial Services

Responsibilities

Responsible for the test management of projects throughout projects life cycle.

Guiding Team members on ETL & Database Testing

Creating test strategies and test plans for projects.

Providing effort estimates and testing timeline to program manager.

Review of test scenarios created by team members.

Test Execution and Reviewing Reported Defects.

Defect triaging with Development team, business/system analysts, IT PM and integration partners.

Providing daily and monthly testing status planning/execution report to all stakeholders.

Reporting to senior managers on progress and issues.

Providing testing signoffs and planning evidence walk-through sessions.

Publishing testing metrics

Project

The Williams & Glyn's (W&G) Delivery Program is driven by the restructuring plan submitted by RBS to European Commission. Under the terms of the restructuring plan RBSG has agreed with the European Commission, RBSG will divest 311 Royal Bank of Scotland (RBS) branches in England & Wales (E&W) together with personal and Small & Medium Enterprises customers. RBS Group will divest identified customers to Williams and Glynn Bank by building an independent technical platform and business operations to support all divesting banking services. This platform will be a mirror of the current RBS platform.

This project has been set up to deliver the W&G Delivery Program requirements from Cards BIS platform. And the Cards BIS platform for Williams and Glyn will be recreated with only divested customer’s data copied over from existing RBS environment..

Project Location Bengaluru, KA, INDIA

Depository Trust & Clearing Corporation

Test Lead Nov 2014 – Feb 2015

Project Title Global Trade Repository

Domain and Line of Business Financial Services

Responsibilities

Responsible for the test management of projects throughout projects life cycle.

Creating test strategies and test plans for projects.

Providing effort estimates and testing timeline to program manager.

Review of test scenarios created by team members.

Test Execution and Reviewing Reported Defects.

Defect triaging with Development team, business/system analysts, IT PM and integration partners.

Providing daily and monthly testing status planning/execution report to all stakeholders.

Reporting to senior managers on progress and issues.

Providing testing signoffs and planning evidence walk-through sessions.

Project

GTR holds detailed data on derivatives transactions globally and enables users to meet their regulatory reporting obligation across multiple jurisdiction. GTR is an essential tool for managing systemic risks by providing regulator various trade reports with unprecedented transparency.

.

Project Location Tampa, FL, USA

CIGNA HEALTHCARE

Test Lead Nov 2013 -- Nov 2014

Project Title AccelRx - Pharmacy RxClinical Applications Domain and Line of Business Healthcare Insurance

Responsibilities

Creating test strategies and test plans for projects.

Providing effort estimates and testing timeline to program manager.

Closely working with IT PM on Project plan.

Arranging KT sessions for team members with SMEs.

Arranging sessions with for testing team on CIGNA data flow.

Review of test scenarios created by team members.

Providing daily and monthly testing status planning/execution report to all stakeholders.

Monitoring Test Execution and Reviewing Reported Defects.

Defect triaging with Devlopement team, business/system analysts, IT PM and integration partners.

Reporting to senior managers on progress and issues.

Providing testing sign-offs and planning evidence walk-through sessions.

Publishing testing metrics

Project

As part of AccelRX Project, Cigna Pharmacy Applications are being integrated with Catamaran for Pharmacy Claim processing. as part of Accelrx Project, Drug Catalog Application has been newly implemented to maintain drug information in Cigna and has been integrated with Catamaran for pharmacy claim processing.

Project Location Hartford, CT, USA

Kaiser Permanente

Test Lead Oct 2012 to Nov 2013

Project Title Health Care Reform CHATS Domain and Line of Business Healthcare Insurance

Responsibilities

Responsible for the test management of projects throughout projects life cycle.

Creating test strategies and test plans for projects.

Providing effort estimates and testing timeline to program manager.

Arranging KT sessions for team members with SMEs.

Review of test scenarios created by team members.

Providing daily and monthly testing status planning/execution report to all stakeholders.

Monitoring Test Execution and Reviewing Reported Defects.

Defect triaging with Devlopement team, business/system analysts, IT PM.

Reporting to senior managers on progress and issues.

Providing testing sign-offs and planning evidence walk-through sessions.

Publishing testing metrics

Project

As part of Health Care Reform (HCR), Affordable Insurance Exchanges are designed to make buying health coverage easier and more affordable. Starting in 2014, Exchanges will allow individuals and small businesses to compare health plans, get answers to questions, find out if they are eligible for tax credits for private insurance or health programs like the Children’s Health Insurance Program (CHIP), and enroll in a health plan that meets their needs. CHATS Application is being enhanced so that CSRs can effectively handle calls for individuals that enroll through the Exchange.

Project Location Pasadena, CA, USA

Humana Healthcare

Test Lead May 2010 -- Aug 2012

Project Title New BUSINESS workflow and Application

Migration to Humana One.

Domain and Line of Business Healthcare Insurance

Responsibilities

Responsible for the test management of projects throughout projects life cycle.

Setting up testing process in KMG-Acquired by Humana.

Creating test strategies and test plans for projects.

Providing effort estimates and testing timeline to program manager.

Arranging KT sessions for team members with SMEs.

Providing KT sessions to team member on database testing.

Review of test scenarios created by team members.

providing daily and monthly testing status planning/execution report to all stakeholders.

Monitoring Test Execution and Reviewing Reported Defects.

Defect triaging with Developement team, business/system analysts, IT PM.

Reporting to senior managers on progress and issues.

Providing testing sign-offs and planning evidence walk-through sessions.

Guiding business users on UAT.

Project

The existing system receives the New Business Applications (Health Insurance Applications) in OCR form or as Web application form. The New Business data is converted in XML before processing through NBWF(.NET application). New Business Workflow is a .NET application which processes data through various underwriting rules before creating an Insurance Policy in I5 system. I was responsible for leading the testing effort of this flow for various enhancements. Also KMG system(Humana Acquired) was being migrated to Humana One(Fimmas – 3rd Party Healthcare system). There I was highly involved in Management of database migration testing.

Project Location Lancaster, SC, USA/Noida, India

Cigna Healthcare

Test Analyst/Test Lead February 2007 to Feb 2010

Project Title Power Managed Healthcare System

Domain and Line of Business Healthcare Insurance

Responsibilities

Analyzing Business requirement and functional specifications

Providing Effort Estimation for Testing based on Business requirement

Arranging KT sessions for team members with SMEs.

Creating Test Plan/Test Cases

Execution of Test Cases

Guiding offshore team members on test planning & execution

GUI & Database Testing

Defect logging & defect analysis for all the defects logged by QA team

Defect triaging with Developer Lead, IT PM, IT Architect.

Root Cause analysis of defcts.

Providing QA sign-off on projects

Project

The existing system processes the HMO claims for CIGNA Healthcare. The scope of this project is to develop and test the code for poduction support vantives and new enhancements at client site as well as at offshore.

Project Location Raleigh, NC, USA/Chennai, India

GE MONEY - IRELAND

I5/AS400 Developer FEB 2006 - JAN 2007

Project Title GE Money Nottingham Phase-2

Domain and Line of Business Banking and Insurance

Responsibilities

Analyzing the requirement

Understanding the functional specifications

Writing the technical design document

Getting Signoff from the owner

Effort Estimation

Involved in coding the various modules of the project in ILE RPG, RPG400, ILE CL, CL400

Unit Testing of the Code

User Acceptance testing of the deliverables

Project

In the existing GE Money Ireland system had manual process for posting of Written-Off Lease Loan Agreements on SAS. With this project the posting process was migrated and automated on AS400.

A new Insurance Product is launched by GE Money, Ireland in which monthly coverage will be provided to customers against various risks. This insurance product has to be implemented in line with the existing GE Money Lease Loan System.

Project Location Noida/India

Pegasus Transtech

I5/AS400 Developer November 2005 to February 2006

Project Title MSSQL to DB2/400 Migration Project

Domain and Line of Business Transportation

Responsibilities

Analyzing the MSSQL stored procedures

Understanding of the existing MSSQL database

Involved in preparation of the migration strategy

Involved in coding of the stored procedures on DB2/400, ILE RPG,

Writing the code for Performance measurement of the stored procedure.

Unit Testing of the code

Project

Analysis of MSSQL stored procedures and then converting those stored procedures in DB2/400 and unit testing of the same to achieve the same functionality.

Project Location Noida/India

AXA Insurance - Singapore

I5/AS400 Developer May 2005 to Nov 2005.

Project Title Singapore Roll Out of RLS Domain and Line of Business Insurance

Responsibilities

Analyzing the requirement

Understanding the functional specifications

Writing the technical design document

Getting Signoff from the stakeholders

Development Effort Estimation

Involved in coding the various modules of the project in ILE RPG, RPG400, ILE CL, CL400

Unit Testing of the Code

System testing of the code

Project

TCS has reengineered the IT system of AXA HongKong which is known as RLS version. Now this RLS version is rolled out in Singapore with some added business functionality. Our project basically dealt with those differences (identified as gaps) and resolved all those differences.

Project Location Noida/India

EDUCATION

B. TECH in ELECTRICAL ENGINEERING, VNIT Nagpur.

Contact this candidate