Sanjeev Kumar
Mobile: 09810422871
E-Mail: sankum1@rediffmail.com
Oracle Apps Finance Functional Consultant
PROFESSIONAL ABRIDGMENT
? A dynamic professional with over 27 years of rich extensive experience in IT, which also includes 10 Yrs of strong experience in Oracle Applications R12 (General Ledger, Payables, Fixed Assets, Receivables, iProcurement, Purchase Order, eBiz Tax).
? Presently working with Polaris Services Pvt. Ltd., Gurgaon as Oracle Apps Functional Consultant (TL), Leading a Team of 8 People involved in data migration project from Oracle Apps R11 to R12.
? Proven skills in Functional Knowledge of Oracle Applications (Release 12.1.3). I’m also involved in Operating Unit Roll Outs and the testing of new Reports and Interfaces and enhancement for new process.
? Have experience in configuring Finance, and documenting as per AIM methodologies like RD020 (Requirement Gathering), BR100 (Setup), MD050 (Functional Spec), CV040 Functional Process, TE040 (Test Scenarios) and customizing the system according to GAP analysis.
? Worked extensively on user requirements gatherings and documentations, gap analysis, and development of User and Functional Requirements Specifications to accomplish projects goals.
? Also involved in getting the Application Audit done for Financial Modules
? Specialization in P2P and O2C Cycle.
? Extensive experience in Oracle Apps Rollouts, New Implementation projects and Upgrade projects
? Involved in Change Management and Incident Management Process.
? Two Full Life Cycle Implementation Experience.
? Excellent domain knowledge of Finance Management, Manufacturing ,PPC, Sales Management, Material Management and HRMS.
? Expertise in providing functional inputs in multiple areas of process design for ERP implementations. Have handled & managed full implementation cycle.
AREA OF EXPERTISE
Role
? Identifying business process design and solution.
? Understanding business process, studying and analysing workflow to design solutions
? Conducting GAP analysis & preparing Requirement Document for approval on various projects.
? Integration with other modules, integration testing & extending Post Go-live support, including training support to end-users.
? Providing implementation, maintenance and support to ERP Solutions; involved in Report customization.
? Implementing Finance ,Purchase, Inventory, Sales& Shipping, HR & Production Modules at client site.
? Customer interaction for requirement gathering, finalization of functional specifications.
? Understanding and coordinating customer’s needs / enhancements, customization of product accordingly to produce effective MIS.
Technology Skills
ERP : Oracle Apps R12, 11.5.10 (GL, AP, AR,FA,PO/iProc,Inventory,iExpense)
RDBMS /DBMS : Oracle 11g, 9i
Languages/GUI : D2K (Forms 9i/6i /4.5 & Reports 10g)
Operating System : Windows 98/NT 4.0/2K/XP, UNIX
DBA Tools : Oracle Enterprise Manager 2.x, SQL* Plus, PL / SQL, SQL* Loader
EMPLOYMENT HISTORY
? 9. Worked as Lead Consultant for Polaris Services & Consulting , Gurgaon from Dec 2016 onwards.
Project - Oracle Apps Data Migration from 11.5.10 to R12.1.3 (30 Countries)
Oracle Apps R12 Implementation (5 Countries)
Client - DHL LTD ,UK
Duration - Dec,16 to till date.
Team Size - 8
Position - Functional Consultant.
Environment - Oracle Apps R12
Responsibilities:
• Implementing Oracle apps as per AIM Methodology for different countries.
• Identifying the functional specs, preparing the documentation setups and maintaining Business Requirement Documents, Setup Documents (BR100) and other design documents as MD050, Functional Process Document CV40.
• Mapping setup is defined to link between R11 and R12 Master & Transaction data for different modules as per new setup in R12 side.
• TCA Master Data maintenance (Supplier, Bank, Customer’s).
• Assets data migration including Assets transferred from corporate to tax book.
• Setup Performed in R12 related to GL,PO,AP,AR and FA modules.
• Data reconciliation between R11 Extraction , Staging Tables , R12 Base Tables.
• Data reconciliation using standard reports.
• Create Accounting and GL Sub-Ledger Posting in R12, GL Reconciliation between 11i & R12.
• Month end closing activity and performed the data reconciliation with standard report.
• Ebiz Tax Setup in R12.
• Resolved Master and transaction data migration issue.
• Testing on various environment before GO-Live (SIT, UAT, Pre-Prod).
• Cut-over planning activities
? 8. Worked as Team Lead for Accenture Services Pvt Ltd, Gurgaon from Apr 2014 to Dec 2016.
Project - Support and Implementation of Oracle Application.
Client - Orange Business Services,UK
Duration - April,14 to Dec,16
Team Size - 10
Position - Functional Consultant.
Environment - Oracle Apps 11.5.10
Orange Business Services is a global IT and telecommunications services provider, with services in 220 countries, supporting every aspect of digital transformation having more than two million businesses in France and 3,000 multinationals customers. This project was implemented R12 Oracle ERP and they needed someone who can support the applications & work on roll out activities.
Responsibilities:
• Identifying the functional specs, preparing the documentation setups and maintaining Business Requirement Documents, Setup Documents (BR100) and other design documents as MD050.
• Providing the suggestions/options of the best way to implement their need in Oracle Applications.
• Troubleshooting the production issues on various applications replicating the issues in TEST environment, and testing the fix prior to apply in Production instance.
• Done Roll Out of new Operating Units including Thailand & Brazil countries of APEC & LAM region.
• Defined Asset Setup (Fiscal Year ,Depreciation Calendar ,Prorate Convention, Assets KFF, Setup Book Control, Assets Category, System Control).
• Support monthly period closing Activities (GL, FA, AP, Purchasing, GRNI Accruals). Run the seeded reports to check pending transactions & performed the month end closing Reconciliation.
• Interacted with the client having regular meeting with them to update the current status of work completed.
• Arrange knowledge sharing session with my team.
• Handling of change request process.
• Resolve the GL-AP Reconciliation Issues.
• Perform Root Cause Analysis (RCA) for various repetitive problems and provided suggestions for speedy problem resolution.
• Implement various improvised processes to prevent user errors and stabilizing the system.
• Implement major modifications in the application with focus on making the system more user friendly and ease in extracting the required data from Oracle.
• Work on major upgrades of database and application that included testing of major upgrades and releases.
• Responsible for training of end-users and provided the aggressive support to resolve the UAT, Production issues.
• Monitoring SLA for all the issues logged by client for financials module (GL,FA,AP,PO/iProc).
• Maintenance of accruals of expenses for every month.
• Coordinating with Client Change Management Group (CMG) for any changes in the existing setup.
• Differentiating the change request into chargeable and non chargeable.
• Giving effort estimate for the proposed change and discussing the commercial aspect of change request.
• Coordinating with Oracle/Technical Team for all critical SR’s resolution.
• Handling changes in oracle apps with respect to change in client organization setup.
• Coordinating with the Tech Consultant for the solution of customized enhancement.
• Responsible for successful roll out of Oracle applications for Financial and Purchasing modules.
• Understanding the current business process and troubleshooting the Production issues to find the Root Cause and replacing the issues in TEST instances and testing the resolution / work around to fix the issues in Production
? 7. Worked as Business Analyst for Mind-InfoTech Ltd, Noida from March,07 to Dec,14.
Project – Implementation.
Client – Motherson Sumi Systems Ltd,Noida
Duration - May,08 to Dec,13
Team Size - 15
Position - Functional Consultant.
Environment - Oracle Apps R12
Motherson Sumi is one of the leading manufacturer of automotive wiring harnesses, mirrors for passenger cars and a leading supplier of plastic components and modules to the automotive industry.
Responsibilities:
• Implementation of Oracle Apps R12 finance system, Developing customized product solutions as per agreed business definitions, project schedule, integration and involved into business process study, gap analysis and transaction process mapping & testing.
• Involved in the project from Kick off meeting, project planning, gathered information through interview sessions with key users in order to understand the existing business processes, current issues and challenges of the business.
• Involved in Data Conversion, Data Migration activities using DBLINK & SQL Loader which includes Data Extraction , Data Validation & Data Upload in Interface tables. Run the seeded programs to transfer data from interface to standard tables.
• Mapped processes for the flow of orders information considering the India localization requirements.
• Preparation BR100 and User Manuals for financial modules.
• Decision regarding Org Structure of client in Oracle.
• Decision regarding Chart of Account of client.
• Designed and setup various Intercompany flows in Oracle Apps, to facilitate an efficient and automated business among all subsidiaries.
• Performed application setup for financials module (GL,FA,AP,PO,AR) for various operating units.
• Defined Ledger with Chart of Accounts , Legel Entity ,Operating Units and Assets Organizations.
• Defined Payable Setups (Financial & Payable Options, Payment Terms , Supplier Setup, Banks Setup).
• Defined Document Category & Document Sequences.
• Defined Asset Setup (Fiscal Year ,Depreciation Calendar ,Prorate Convention, Assets KFF, Setup Book Control, Assets Category, System Control).
• Defined AR Setups like System Options, Transaction Types and Sources, Receipt Sources/ Classes, Auto accounting, Define Customer, Payment Terms, Automatic Receipt, Auto Lock Boxes, Invoice Upload process.
• Designing custom extensions/proposed workarounds to suit client's business and operational requirements. Worked closely with technical consultants and developers to build these extensions.
• Involved and extensively contributed to the full life cycle implementation from requirements gathering, documentation, data conversion, implementation, training, testing and support.
• Identified gaps between business requirements and system capabilities and proposed solutions/workarounds.
• Designing functional specs for additional reporting requirements
• Testing on various environment before GO-Live (T1,T2,UAT,Pre-Prod).
• Cut-over planning activities
• Handling post go-live support activities.
? 6. Worked as Project Manager –ERP for Eastern Software Systems Pvt. Ltd., Delhi from Aug,06 to Jan,07.
Role
? Successfully implemented Ebizframe, a primarily ERP solution across multiple industry segments.
? 5. Worked as Project Manager –ERP for Askud Consultancy Services, Ghaziabad from Sep,04 to Aug,06.
Technologies: Oracle 9i, Report and Forms 6i, PL/SQL
Team Size: 6
Duration: Sep’04 to Aug ’05
Role:
• Handled projects of Spectra Products (P) Ltd. and Ghaziabad Precision (P) Ltd., companies manufacturing automobile components/parts.
• The Work involves implementation of 3i-Infotech ORION ERP system (Procurement, Inventory, Manufacturing, Sales ,Finance), Business Process Study, Gap Analysis, Transaction Process mapping, ERP Administration, Customising ERP system as per user requirement, Organising training programmes for employees of the company.
• Customised ERP system as per user requirement and coordinated between ICICI- InfoTech and companies.
• Conducted training programmes for employees of the company.
• Performed Unit testing, UAT and End-User training for Go-live.
? 4. Worked as Assistant Manager-IT for Hanung Groups, NOIDA from Mar’01-Aug’04.
India’s largest manufacturer and exporter of home furnishing products.
Project: Sales Order Management System, Export-Import Management
Team Size: 5
Duration: Aug,’01 to July’02
Responsibilities:
? Project Management activities through the SDLC.
? Project delivery and implementation as per schedule.
? 3. Worked as Executive Officer-Systems for Flex Engineering Ltd., NOIDA from Jan’99 to Dec’00.
Venture of Flex Industries Ltd., with group turnover of Rs.400 crores, Manufacturer of Packing Machines
? 2. Worked as Asst.Manager-Systems for GOM Group of Companies, Mohali from May’95 to Jan’99
A reputed group of companies with ventures like MOI Engineering Ltd., Mohali and EEI Industries Ltd., Sahibabad, with a group turnover of Rs.200 crores, Manufacturer of Packing and Capsule making Machines.
Project : Process & Production Planning Shop floor Control System for EEI Ind. Ltd., Sahibabad
Team Size: 3
Duration: Feb’97 to Oct’97
Technologies: Pentium, Developer 2000, Oracle 7.1, Unix
Scope: The application facilitates entry of Sales Order details, with multiple delivery dates and destination. Customer Quotation, Price List Master, Customer Master, Payment Terms, Sales Return. The other major modules include MRP, booking of fabrics and accessories against the order, invoice and packing list generation, shipping bill for export of duty free goods, GSP, Form A.R.E.1, Multiple country declaration and evidence of country of origin.
It also generates several reports, including Summary of order received/exported/pending, Pending order details (week/date/ buyer wise), Cash inflow projection and MIS Reports.
Responsibilities:
• Project Management activities through the SDLC.
• Project delivery and implementation as per schedule.
Project : Engineering Issue, Purchase, Inventory Management &Accounts Payable System for GOM Group
Team Size: 3
Duration: Jan’98 to Dec’98
Technologies: Compaq Prosignia 200, Developer 2000, Oracle 8i, Windows NT.
? 1. Worked as Programmer (Casual) for BES (I) P Ltd., New Delhi from Jan’90 - Aug’94
Project : Clean Cash Balancing Accounts Package
Duration: Nov’91 to May’93
Client : State Bank of India, Main Branch, New Delhi
Team Size: 8
Role: Programmer
Technologies: UNIX, COBOL
Scope: The application has features like daybook balancing, Head Balancing, Clearing, Cash & Transfer Balancing, Daily Debit/Credit Transaction and Ledger posting.
EDUCATION
1990 M.Sc.(Maths with Computer Science) from Jamia Millia Islamia University, New Delhi.
Secured 61.4% marks.
1987 B.Sc. from Delhi University, Delhi.
Secured 63.4% marks.
CERTIFICATION
? OCP (Oracle Certified Professional) in Oracle 9i DBA Track.
PERSONAL DOSSIER
Date of Birth : 12th December, 1967
Passport No. : M2459284 valid till Dec,2024.
Permanent Address : 10240, Street No.1, West Gorakh Park, Shahdara, Delhi-110 032
Current Address :Supertech Avant Garde, Plot No-1, Flat No 002, Sector -5 ,Vaishali ,Ghaziabad-201010.