ASHISH AGRAWAL
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.