Sandeep Gupta

Objective:

To work as a Project Manager/Lead position, contributing to improve business process, enhance business applications and increase the organizations efficiency and profitability.

Areas of Specialization:

Business analyst and functional design

Application consultant in financials and Distribution

J D Edwards EnterpriseOne and J D Edwards World

[A] Summary

oMore than 18 years of business experience

oMore than 8 years of experience in JD Edwards E1-9.1 & JD World A9.2 working as Finance Functional consultant/Team Lead

o3 Rollout Implementation experience & 4 Support Projects

oJDE Functional experience in finance

oStrong knowledge of finance domain

oModules : GL, AP, AR and Fixed Assets, Job Cost, Manufacturing A/cting)

oIntegration of finance with OTC (Order to Cash), P2P (Procurement 2 payment), IM (Inventory Management), Work order, Landed cost, DMAAI setup

oAs-Is & To-Be Document -Conducting Workshops with Business Process Owners to understand the existing business processes and finalize the To Be processes, Gap Analysis with system flow diagrams

oResponsible for Preparation of Weekly project status report, Issue tracking report, Finalization of Chart of Accounts, Business Unit, setup AAI, Creation of menus & versions as per user requirement, involved in Test, CRP, ICRP, User Training

oPrepare Functional Design Documents for Reports, Application, Interface

oWell-developed interpersonal and communication skills, having dealt with diverse professionals, clients & team members at global locations

oKnowledge and experience with SQL and JDE Database structure to analyze data

oTakes ownership of functional issues by identifying underlying problems, analyzing potential solutions and implementing system resolution including workaround

[B] Skillsets

Operating Systems: MS Windows 2000 / NT 4.0, Win 9x, IBM OS/400

ERP: JD Edwards Enterprise One 9.1, OneWorld Xe, JD World Version A9.2, Oracle E-Business Suite 11i

Databases: Oracle-9.x, MS Access, FoxPro

Other Software: MS-Office, MS-Project, Tally (A/cing S/W)

[C] Project Experience Summary

Project Summary

Project Name

Duration

Project Type

Environment

Role

Atlantis The Palm, Dubai

Aug 2016 – Present

Implementation of Finance (GL/AP/AR/FA)

JD Edwards Enterprise One 9.1

Associate Team Lead

Amway India

April 2015 – July 2016

FA Implement & Support of Finance (GL/AP/AR/Job Cost)

JD Edwards Enterprise One 9.1

Associate Team Lead

Orient Refractories Ltd

December 2014 – March 2015

Upgrade from 8.12 to 9.1 & FA Implementation

JD Edwards Enterprise One 9.1

Associate Team Lead

Akorn India

January 2014 – November 2014

Roll out’ and Full Life Cycle Implementation’

JD Edwards Enterprise One 9.1

Associate Team Lead

Sennheiser India

November 2013 – December 2013

Implementation of India Localization

JD Edwards Enterprise One 9.1

Senior Finance Functional consultant

Denso International

July 2013 – October 2013

Roll out’ and Full Life Cycle Implementation’

JD World Version A9.2, Database (AS400)

Senior Finance Functional consultant

Mikuni India

May 2013 –June 2013

Implementation of India Localization

JD Edwards Enterprise One 9.1

Senior Finance Functional consultant

Tupperware

December 2012-April 2013

Finance Functional Support & Report Requirements

JD World Version A7.2, Database: (AS400)

Senior Finance Functional consultant

Baxter India

May 2012 – November 2012

Support Project (Integrity Issues)

JD World Version A7.2, Database: (AS400)

Senior Finance Functional consultant

Denso India

September 2011 – April 2012

Roll out’ and Full Life Cycle Implementation’

JD World Version A9.2, Database (AS400)

Finance Functional Consultant

PC Jeweller

March 2011 – August 2011

Post Live Support

JD Edwards EnterpriseOne 8.12

Finance Functional Consultant

Orient Abrasives

July 2010 – February 2011

Functional support post Go-Live of Finance Module

JD Edwards EnterpriseOne 8.12

Finance Functional Consultant

PC Jeweller

April 2009 – June 2010

Implementation & Post Live Support

JD Edwards EnterpriseOne 8.12

Finance Functional Consultant

K S Oils

February 2009 – March 2009

Implementation of Finance Module

JD Edwards EnterpriseOne 8.12

Associate Finance Consultant

Designco Exports

Sept.2008 – January 2009

Implementation of Finance Module

Oracle Apps.11i) (11.5.10.2

Financial Functional Consultant

[D] Project Experience Detail

Amway India

Amway India is the largest Direct Selling FMCG company. Amway India sells more than 140 daily use products across categories like Nutrition, Beauty, Personal Care and Home Care. .

Project Details

Duration: April 2015 – Present

Project: Support of Finance (GL/AP/AR) & Post Implement Support

Role: JD Edwards Finance Functional Consultant/Associate Team Lead

Environment: JD Edwards Enterprise One 9.1

Project Scope & Responsibilities

Functional support post Go-Live of Finance Module

Preparation of Functional specification & Testing of Report Requirements

Orient Refractories Ltd

Orient Refractories Ltd, Bhiwadi, Manufacturer of Refractory Materials for Steel Plants having

Turnover over around 500 crores.

Project Details

Duration: December 2014 – March 2015

Project: Implementation of Fixed Asset & Post Upgrade Support

Role: JD Edwards Finance Functional Consultant/Associate Team Lead

Environment: JD Edwards Enterprise One 9.1

Project Scope & Responsibilities

Implementation of Fixed Assets Module & Integration with Purchase

Post Upgrade support from 8.12 to 9.1

Akorn India

(Akorn is a niche generic pharmaceutical company engaged in the development, manufacture

and marketing of multi-source and branded pharmaceutical products across the globe)

Project Details

Duration: March 2014 – November 2014

Project: Implementation Full Cycle

Role: JD Edwards Finance Functional Consultant/Associate Team Lead

Environment: JD Edwards Enterprise One 9.1

Project Scope & Responsibilities

This was a ‘Roll out’ and Full Life Cycle Implementation’ project was already implemented in USA the parent company. The system is totally Mapped for Indian scenario keeping global set ups common to USA and INDIA

Responsible to analyze the AS IS and TO BE and Gap Analysis

Created Chart of Accounts, AAI Setups, FA Setups

Configuration and functional setups of Finance Module (AP/AR/GL/FA)

Established DMAAI, involved in the integration with other modules (Finance)

Prepared Functional Specification & Tested customized reports like Trial balance for I-Gap/US Gap, EFT file generation

User Training, Process scripts, User Acceptance Test

Post Live Support includes Issue Resolution, suggests better methods of entries

Setup for Group A/P payments with EFT & Manual Cheques

Akorn Pharmaceutical, USA

(Akorn is a niche generic pharmaceutical company engaged in the development, manufacture

and marketing of multi-source and branded pharmaceutical products in the United States and

across the globe)

Project Details

Duration: January 2014 – February 2014

Project: Implementation of Multi-Currency

Role: JD Edwards Finance Functional Consultant

Environment: JD Edwards Enterprise One 9.1

Project Scope & Responsibilities

Setup of Multi-Currency, AAI, DMAAI

Testing from PO to Payment(P2P) & SO to Receipt process with Multi-Currency

User Training, Creation of process script, User Manual

Sennheiser India

(Sennheiser electronic is an international organization offers headphones, microphones,

Wireless microphone and monitoring systems, conference systems)

Project Details

Duration: November 2013 – December 2013

Project: Implementation

Role: JD Edwards Finance Functional Consultant

Environment: JD Edwards Enterprise One 9.0

Project Scope & Responsibilities

Implementation of India Localization (Taxes) Like TDS (Tax Deduction at Source) & LCR (Landed cost Rule)

Testing from PO to Payment(P2P) & SO to Receipt process

Setup AAI, DMAAI, User Training, Creation of process script, User Manual

Denso International

(Manufacturer of Auto Electrical Components, Auto Electric Fans, Ventilators, Magnetos etc)

Project Details

Duration: July 2013 – October 2013

Project: Implementation

Role: JD Edwards Finance Functional Consultant

Environment: JD World Version A9.2

Database : (AS 400)

Project Scope & Responsibilities

Understand the process flows in the Critical Areas so identified and broadly suggest, how the same can be mapped in JD Edwards

Created Chart of Accounts, AAI Setups, FA Setups

Configuration and functional setups of Finance Module (AP/AR/GL/FA)

Prepared Functional Specification & Tested customized applications like Travel expense / Advance Upload, Bank Statement Upload for Auto bank Reconciliation, Salary Journal Voucher Upload

User Training, Process scripts, User Acceptance Test

Post Live Support includes Issue Resolution, suggests better methods of entries

Setup for Group A/P payments with EFT & Manual Cheques

Mikuni India

Mikuni is a global Manufacturer of Auto Components, Carburettor, Throttle body etc.)

Project Details

Duration: May 2013 –June 2013

Project: Implementation

Role: JD Edwards Finance Functional Consultant

Environment: JD Edwards Enterprise One 8.12

Project Scope & Responsibilities

Implementation of India Localization (Taxes) & its Financial Impact

Testing from PO to Payment(P2P) & SO to Receipt process

Setup AAI, DMAAI, User Training, Creation of process script, User Manual

Tupperware

Tupperware is a global manufacturer of storage, containment, and serving products for kitchen and home

Project Details

Duration: December 2012-April 2013

Project: Support Project

Role: JD Edwards Finance Functional Consultant

Environment: JD World Version A7.2, Database: (AS400)

Project Scope & Responsibilities

Functional support post Go-Live of Finance Module

Preparation of Functional specification & Testing of Report Requirements

Baxter India

Baxter is a global medical products and services company with expertise in medical

Devices, pharmaceuticals and biotechnology

Project Details

Duration: May 2012 – November 2012

Project: Support Project (Integrity Issues)

Role: JD Edwards Finance Functional Consultant

Environment: JD World Version A7.2, Database: (AS400)

Project Scope & Responsibilities

Analyzing & suggest best methods to solve Integrity issues between Inventory Ledger & General Ledger

Analyzing & suggest best method to solve Integrity issues between A/P, F/A & General Ledger

Denso India

(Manufacturer of Auto Electrical Components, Auto Electric Fans, Ventilators, Magnetos etc)

Project Details

Duration: September 2011 – April 2012

Project: Implementation & Post Live Support

Role: JD Edwards Finance Functional Consultant

Environment: JD World Version A9.2

Database : (AS 400)

Project Scope & Responsibilities

This was a ‘Roll out’ and Full Life Cycle Implementation’ project was already implemented in Japan the parent company. The system is totally Mapped for Indian scenario keeping global set ups common to JAPAN and INDIA

Understand the process flows in the Critical Areas so identified and broadly suggest, how the same can be mapped in JD Edwards

Created Chart of Accounts, AAI Setups, FA Setups

Configuration and functional setups of Finance Module (AP/AR/GL/FA)

Prepared Functional Specification & Tested customized applications like Customer SRV & Receipt Upload against SRV, Bank Statement Upload for Auto bank Reconciliation, Salary Journal Voucher Upload

User Training, Process scripts, User Acceptance Test

Post Live Support includes Issue Resolution, suggests better methods of entries

Setup for Group A/P payments with EFT & Manual Cheques

PC Jeweller

PC Jeweller, Delhi, Leading Retail & Export & Manufacturer of Gold & Diamond Jewellery

Project Details

Duration: March 2011 – August 2011

Project: Post Live Support

Role: JD Edwards Finance Functional Consultant

Environment: JD Edwards EnterpriseOne 8.12

Project Scope & Responsibilities

Functional support post Go-Live of Finance Module

Worked on functional specification for new Finance reports requirements

Orient Abrasives

Orient Abrasives Ltd, Bhiwadi, Manufacturer of Refractory Materials for Steel Plants having

Turnover over around 400 crores.

Project Details

Duration: July 2010 – February 2011

Project: Post Live Support

Role: JD Edwards Finance Functional Consultant

Environment: JD Edwards EnterpriseOne 8.12

Project Scope & Responsibilities

Functional support post Go-Live of Finance Module

Worked on functional specification for new Finance reports requirements

Worked on user documentation and issue/analysis/resolution documentation for support tickets

Resolution of Financial integrity issues.

PC Jeweller

PC Jeweller, Delhi, Leading Retail & Export & Manufacturer of Gold & Diamond Jewellery

Project Details

Duration: April 2009 – June 2010

Project: Implementation & Post Live Support

Role: JD Edwards Finance Functional Consultant

Environment: JD Edwards EnterpriseOne 8.12

Project Scope & Responsibilities

Configuration and functional setups of Finance Module in PY and PD Environment

Pre Go-live activities like UDC, Master upload

Participate in meetings, discussions for requirements/directions.

Process mapping and setups & Testing for Bolton applications (Customized Application for Gold Purchase)

User Training, Process scripts

K S Oils

K S Oils Limited, Morena, Leading Manufacturer of edible oils

Project Detail

Duration: February 2009 – March 2009

Project: Implementation

Role: JD Edwards Finance Functional Consultant

Environment: JD Edwards EnterpriseOne 8.12

Project Scope & Responsibilities

Pre Go-live activities like UDC, Master upload

Participate in meetings, discussions for requirements/directions

Users training

Designco Exports

Designco Exports, Moradabad is the India’s leading diversified Manufacturer & Exporter of Handy craft items of metals as per requirement of Overseas Customers.

Project Details

Duration: September 2008 – January 2009

Project: Implementation (Oracle Apps.11i) (11.5.10.2)

Role: Financial Functional Consultant

Environment: (Oracle Apps.11i) (11.5.10.2)

Project Scope & Responsibilities

Conduct Communication with Client to understand Customization

Setup India Localization (TDS)

Study business applications to understand the Customization implemented based on the inputs given by the client and also through self analysis

Documenting Customization in the form of User Manual

Scope of the project includes Oracle E-business Suite Functional Financials

[D] Other Industry Experience

S. Gulati & co. (Chartered Accountant) (August 1995 – September 1997) - Asst. Accounts

Responsibilities:

Performs Audits

Assist is preparation of Balance Sheet

Preparation and filling of VAT, Service Tax, TDS Returns

National Council For Cement & Building Material (October 1997 – September 2000) -Accounts Officer

Responsibilities:

Manage General Ledger, Accounts payable, Accounts receivable

Skilled in analyzing data, performing audits

Prepare and submit Service Tax, TDS returns

Review work of staff accountant and approve journal transactions for data entry

Assist with the corporate budget in preparation and maintenance of budgets and projections. Prepare monthly budget to actual reports and distribute to managers

Saraswati Engg. Works (October 2000 – August 2008) – Asst. Manager Finance

Responsibilities:

Statutory and internal audit co-ordination, entrusted to achieve target completion dates and smooth conduct of audit.

Supervision of Accounts Receivable, Accounts Payable, Fixed Assets & General Accounting functions of Finance.

Management reporting related to Product costing, cost control and valuation of Finished Goods, Work in process & Raw Material.

Conducting Statutory, Tax, Internal Audits by preparing, presenting the results of audit work & recommendations to management / audit committee

KPIT Technologies, India (September 2008 – to Till Date) – JDE Finance Functional Consultant

Responsibilities:

Implemented JDE Financial Module & Post Implemented Support

Facilitate and actively participate in all phases of the Implementation cycle, to include Requirements Gathering & Analysis, System Design and Development, Testing, and Implementation

[F] Training & Education

MBA (Finance)

Oracle Certified Implementation Specialist in JD Edwards Financial Management

Bachelors of Commerce,(B.Com), Delhi University

Microsoft certified professional (VB6,SQL Server)

Diploma in computers & systems management (Uptron ACL)

Certificate of Computing (IGNOU)

Diploma in web technology (E.R.D.C.I)

[G] Personal Information

Date of Birth = 10-10-1972

Mobile = +91-999*******

Email = acx5eo@r.postjobfree.com

Resident Country = India

Contact this candidate