Jd Edwards Project
Resume:
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 = ***********@*****.***
Resident Country = India
Contact this candidate