EDUCATIONAL QUALIFICATIONS and ACHIEVEMENTS:

Prateek has 13+ years of industry experience in Functional consulting, Project Management, Business analysis, Design, Solution development, testing and implementation for Enterprise Solutions in US Healthcare and Human Services, Public Sector (Child Welfare), Financial Service domains.

Worked as Onsite Project Manager and successfully managed projects with varying complexity.

Working with Deloitte Consulting since February 2007 (till date).

6+ years of experience in Project Lead and Functional Lead role for healthcare and Public Sector domains.

Lead the SIT Testing and Regression Testing scenarios for Health and Human Services projects for over 5 years.

Worked on Healthcare – Health Plan domain client for system analysis of the project involving transitions and renewals. Was involved in the extract transformation and load process analysis and preparation of functional documents like Functional Design Document and Blueprints for multiple systems under scope.

4+ years of ETL development experience in SSIS (SQL Server Integration Services), Cognos Decision Stream, DataStage, Pentaho.

Has technical expertise on large scale Data Migration and Conversion jobs.

Worked in MS technology covering SSIS, SSRS, ASP.NET, ADO.NET, Winforms.NET using C#.NET language and SQL Server 2000/2005/2008 as database, SharePoint.

Worked on the deployment of projects on the live server.

Lead and managed DW/BI and ETL testing using PL/SQL.

Has sound knowledge of Software Development processes. Aware of CMM and CMMi processes.

Post-Graduation Diploma in Advanced Computing (DAC) from CDAC, Pune.

Master of Business Administration (MBA) in Information Technology from Institute of Business Management and Research, Chinchwad, Pune.

Bachelor of Computer Application (BCA) from Ajay Kumar Garg Engineering College affiliated to CCS University.

Created and published the Best Practices and Naming Convention Document for SSIS 2005 and 2008.

Received Applause Award for the excellent Performance during FY-09 for TMT client.

Received Applause Award for the contribution ‘Beyond Deloitte’ in FY -10.

Received SPOT Awards for the contribution in Health and Human services domain in FY -14, FY-15, FY- 16, FY-17, FY-18.

Received Applause Award for the contribution in Healthcare sector domain in FY-19

PRATEEK GOEL

adiljz@r.postjobfree.com

+1-669-***-**** (US)

Resume: Prateek Goel

Page 2 +919*********

TECHNICAL EXPERTISE:

Software/Products: - MS Visio, MS Products, MS InfoPath 2003, MS SharePoint 2003, MOSS 2007, NUNIT, TFS, Attachmate (Mainframe), MS Office Suite, HP ALM/QC, UFT/QTP, SAP Concur, SAP Solution Manager

Development Technologies: - C#, VB.Net, ASP.Net, ADO.Net, XML.Net, Visual Basic 6.0

Web Technologies: - HTML, DHTML, VBScript, JavaScript, ASP

Databases: - SQL (Oracle 8i), MS SQL Server 2000 / 2005 / 2008, MS-Access, Oracle (10g, 11g)

EAI Tools: - SQL Server Integration Services 2005, Cognos Decision Stream, SQL Server Integration Services 2008, DataStage 8.1, Quality Stage 8.1, Pentaho ETL, Informatica

Reporting Tools :- Crystal Reports (8.0, 10.0), SQL Server Reporting Services 2005

Operating Systems:- UNIX, MS-DOS, WINDOWS 98/2000/me/NT/2003/XP/Vista/7 CERTIFICATIONS and TRAININGS:

Post-Graduation Diploma in Advanced Computing (DAC) from CDAC, Pune.

DNIIT (2 year web curriculum program) from NIIT Ghaziabad.

Microsoft Certified Application Developer - 070-542 - Microsoft Office SharePoint Server 2007 – Application Development

Attended in-house 5 days training on MOSS 2007 imparted by Nauzad Kapadia (Microsoft MVP)

Attended training on SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and .Net 2.0 / 3.0 / 3.5.

Attended quality standard maintenance & improvement training on CMMI 5 process & standards.

Attended training on Informatica – Power Centre 8.6.2

Attended on-line virtual training on DataStage 8.1

Attended QualityStage 8.1 classroom training.

PROFESSIONAL EXPERIENCE:

Organization Name: Deloitte Consulting LLP.

Designation: Senior Consultant (12th Feb, 2007 – Present ) Projects Undertaken:

Industry: Financial Services

Role: Onsite Test Manager; Duration : 1 year

Client is an American multinational technology company that specializes in Internet-related services and products, which include online advertising technologies, a search engine, cloud computing, software, and hardware.

The S/4 Finance Transformation project includes an SAP S/4HANA Finance implementation that focuses on the following core areas - Master Data Governance (MDG), Central Finance (CFIN) and Business Planning &

Resume: Prateek Goel

Page 3 adiljz@r.postjobfree.com

Consolidations (BPC). The future goal of the project is to migrate SAP to a private cloud version and real time database, standardize and optimize processes, reports & tools, transform work from reconciling to analyzing, train employees so they can contribute exponentially. Key Responsibilities :

• Worked as Onsite Testing & Cutover Lead for SAP S/4HANA Implementation

• Provided best practices and direction for successfully organizing and executing system integration testing cycles and user acceptance testing

• Lead the SIT and UAT cycles across teams like MDG, Tax, Intercompany, Allocations, Core General Ledger, etc.

• Coordinated with Functional and Technical Consultants for the implementation.

• Provide the daily status reports to the client and maintain the status quo of the project.

• Lead defect management and worked on closure of defects with team members.

• SME for the Test Management tool(SAP Solman) for test scenarios, test cases, test execution, defects logging, and generating reports.

• As Business Cutover and Conversion Lead responsible to plan and execute business cutover and conversion activities

Industry: Financial Services

Role: Test Manager; Duration : 6 months

Client is a leading American multinational investment bank and financial services company. As part of the engagement, we (Deloitte) provide them the total spend management transformation in SAP Ariba, SAP Concur, S4, Fieldglass etc. As part of the total spend management transformation, SAP Concur

(Travel and Expense) application has been implemented for the client. Key Responsibilities :

• Worked as Testing Manager for SAP Concur and S2C Ariba.

• Setup the HP ALM – Test Management tool for the client and provided the training of the tool to the client.

• Lead the SIT and UAT cycles for Concur and S2C Ariba.

• Coordinated with client and Functional Consultants for the implementation and requirement-test coverage.

• Provide the daily status reports to the client and maintain the status quo of the project.

• Lead defect management and worked on closure of defects with team members.

• Maintained the Test Management tool for test scenarios, test cases, test execution, defects logging, requirements mapping with test cases and generating reports.

• Perform and Lead Test execution during SIT phase. Industry: Health Care

Role: Onsite Project Manager; Duration : 1 year 6 months In its efforts to remain market leader in all the states it operates, and to leverage the Health Insurance Exchanges (HIX) 2014 onwards as mandated by the Healthcare Reform Act. Key Responsibilities :

Resume: Prateek Goel

Page 4 +919*********

• Worked as Technical Project Manager for Enrollment and Billing.

• Maintained status quo of each project in Enrollment and Billing domains.

• Created and Maintained Implementation plans for every release.

• Coordinated with developers, Testers, IT and Business checkout owners for the projects

• Validating of eForms/Filenet (Intake, Release confirmation, Release Testing, Testing Defect Fix, Production Readiness)

• Reviewed/Updated the ROM estimates, documents for WGS and ISG and submitting for approvals (Dev and SIT)

• Track code Freeze, SIT/UAT extensions and test statuses of work efforts for a Release

• Executed Endevor Reports for code package analysis, statuses, reconciliation.

• Created and published Release Notes and summary.

• Reconciliation of release system change tickets through SNOW reports.

• Worked on ERM (Enterprise Release Management) activities to provide status updates for E&B via Release Attestation, Status Master, Production Readiness.

• Mentor offshore resources and help them develop their technical and functional expertise Industry: Public sector(Health and Human Services) Role: Project Manager; Duration : 5 years

Implemented an automated system, called FACES. The FACES application is a State Automated Child Welfare Information System (SACWIS) used to collect information about clients and providers. It is also used as a tool to organize that information and to enhance the client operations and services, which are provided to the families. Key Responsibilities :

• Worked as Onsite Functional and Technical Project lead.

• Estimation and planning of change orders

• Analysis of the business requirements

• Manage client expectations and lead them through a thought process.

• Mentor offshore resources and help them develop their technical and functional expertise

• Co-ordinate with external vendors to explain them business requirements of the client as well as work on designing feasible solutions with them to implement client requirements.

• Performing efforts estimations, project planning, risk management, task allocation, project tracking and monitoring.

• Lead and worked on System Documentation (Technical and Functional design) of the application covering over 600 screens and user controls.

• Development, Testing, Defect identification and resolution, Review, identification and resolution of performance issues of the system.

• Done SIT Testing of the critical modules

• Provided UAT support for user testing

• Involved in the Regression Testing of the system

• Created/Maintained Integration Testing Plan

Resume: Prateek Goel

Page 5 adiljz@r.postjobfree.com

Industry: Public sector(Health and Human Services) Role: Scrum Master; Duration : 3 Months

The client is responsible for providing and administering human services to county residents. It is dedicated to meeting these human services needs, most particularly to the county's most vulnerable populations, through an extensive range of prevention, early intervention, crisis management and after-care services provided through its executive, program and support offices. Key Responsibilities :

• Worked at Onsite as Functional and Technical lead.

• Followed end-to-end Agile methodology in delivering the key modules and initiatives for application

• Maintained Product backlog through JAD sessions

• Created/Maintained UST Detail Document

• Completed the Sprint/Project planning

• Maintained Initiatives Timelines

• Attended daily stand-up calls and resolved queries of team members

• Provided Demo to client after every sprint milestone

• Created/Maintained Integration Testing Plan

• Coordinated with external vendors

• Done SIT Testing of the critical modules

• Provided UAT support for user testing

• Involved in the Regression Testing of the system Industry: Public Sector

Role: Technical Lead; Duration : 3 months

The client has defined a vision for SNAP and TANF Eligibility Systems, an Enterprise Architecture and Shared Fiscal Services Layer that will result in an eligibility system platform for the future. To design and develop the solution, Deloitte also need to convert data from legacy application to to-be system. To achieve it, Deloitte need to develop conversion routines for the following programs:

• A new Supplemental Nutrition Assistance Program (SNAP) eligibility system.

• A new Temporary Assistance for Needy Families (TANF) eligibility system.

• A library of shared fiscal services to support the shared fiscal (accounts receivable and accounts payable) responsibilities associated with the issuance of eligibility and benefits for SNAP and TANF. Key Responsibilities :

• Worked as Senior ETL Developer and lead the team to build the complex ETL transformations.

• Creates high Level designs (HLD) and Low level Design (LLD) from requirements

• Estimated time required to design, develop, test and integrate each component

• Create and enforce database development standards and processes for coding, naming, data access and documentation.

• Coordinated with the onsite team for finalizing functional and technical project requirements.

• Designed ETL packages in PENTAHO for migrating huge volume of data from legacy mainframe system.

Resume: Prateek Goel

Page 6 +919*********

• Established SQL queries for complex data transformation activities and customized them in a handy manner to be used by peers.

• Design and developed logical & physical data models

• Defined and designed the business rules, data rules, extract rules, transformations Industry: Financial Services

Role: Team Lead; Duration 2 years.

The project is to track the various stages of Opportunities to Engagements, and its associated information. Key Applications in this project are:

- GCI (Global Client Intelligence): The Project is a Business Intelligence initiative focused on consolidating the global Revenue-Billing & Opportunities information.

- DGMF: Provides as complete and accurate entity information as possible. This will assist in achieving objectives for improved risk and independence compliance, quality controls, and client service.

- Matching Tool

- Global Client Hierarchy

- DESC Import

- Integration Services

- Smartnet: Opportunity Tracker

Key Responsibilities:

• Analyze/ understand client requirements.

• Requirement Impact Analysis and Estimations.

• Preparing project plan. Maintain Timesheet and process documents.

• Provide status updates on achievements, planned activities and issues/risks.

• Assign task to team members and track progress.

• Create/review detail design based on client requirements/ high-level design. Conduct detail design walkthrough with the client.

• Design and Create ETL routines using SSIS, Cognos DecisionStream Designer and DataStage.

• Coordinate with the onsite team.

• Performed DW/BI testing using PL/SQL and QC.

Industry: Financial Services

Role: Senior Developer; Duration: 1 year

• An application that read data from various sources (i.e. XML and txt files) and copies them into a raw set of tables.

• A Validation logic implemented using stored procedures runs on data and copies data from raw to standard tables

• The data from standard tables is read and moved to a STAGING database after applying complex transformation logic.

• IBM Quality Stage is configured to read data in staging and load it to another intermediate database.

Resume: Prateek Goel

Page 7 adiljz@r.postjobfree.com

• Finally the data from intermediate database is read and moved to the final database (CASE) after applying complex transformation logic.

Key Responsibilities:

• Analyze and understand requirements and design database schema.

• Impact Analysis and Estimations.

• Create/review detail design based on client requirements/ high-level design. Conduct detail design walkthrough with the client.

• Create ETL routines using SSIS as per design.

• Work on enhancements.

• Coordinate with the onshore team.

• Review code for compliance to coding standards.

• Creation/Review of mapping documents to map source to destination columns. Industry: Financial Services

Role: Developer; Duration: 2 years

The project is to provide as complete and accurate entity information as possible. This will assist in achieving objectives for improved risk and independence compliance, quality controls, and client service. Key Responsibilities:

• Analyze and understand requirements and design database schema.

• Impact Analysis and Estimations.

• Create/review detail design based on client requirements/ high-level design. Conduct detail design walkthrough with the client.

• Create ETL routines using SSIS as per design.

• Work on enhancements.

• Coordinate with the onshore team.

• Review code for compliance to coding standards.

DELOITTE REFERENCES:

Beryl Washington, US Office, +1-214-***-****, adiljz@r.postjobfree.com

Sachin Jain, Mumbai, +91-992*******, adiljz@r.postjobfree.com

Abhishek Joshi,, US Office, +1-678-***-****, adiljz@r.postjobfree.com

Cyril Wisniewski, Toronto, +1-416-***-****, adiljz@r.postjobfree.com

Abin Banerjee, Mumbai, +91-976*******, adiljz@r.postjobfree.com

Resume: Prateek Goel

Page 8 +919*********

Contact this candidate