Oracle E-Business Suite R** (Projects & Finance)
ITIL® Foundation V3
Financials, Projects, OBIEE
In quest of assignments in domain of Oracle Implementation and support to deliver consulting solutions for complex business requirements.
7.5 Years of relevant experience and overall 10+ years of experience in IT industry that includes Functional expertise in Oracle applications, Implementation, Rollouts, Upgrade, Production support in ERP (Oracle Applications). Extensively worked on Oracle R12 Financials and Projects (General Ledger, Payables, Receivables, Order Management, Oracle Purchasing, and Inventory, Project Accounting (Costing, Billing, Management, Resource Management)
Prior Domain Accounting knowledge and project controlling experience.
Design, Configure and testing for Financials and project costing, billing, management, Resources management.
Expertise in coordinating with team, users, clients and app-leads enabling competent production support.
Experience of working in Onsite - Offshore project execution model as an Offshore Lead and Onsite Co-coordinator.
Good knowledge of ERP implementation methodology and relevant associated quality processes.
Applications Worked : Oracle Applications R12 E-Business Suite (General Ledger, Payables, Receivables and Order Management, Fixed assets, Cash management, Inventory, Purchasing, Project Accounting modules)
Database : Oracle 9i, 10G
Operating System : Windows 2000, Windows XP
Language/ Tools : Basic PL/SQL, Toad
Employer : ASTAD Project Management. (Qatar)
Title : ERP Functional Lead-Finance
Date of Employment : Aug 2018 Till Sep-2018
Employer : Capgemini India Pvt Ltd.
Title : Oracle Financial Functional Consultant
Date of Employment : May 2006 Till Mar-2016
Employer : Marsh India Pvt Ltd
Title : Senior Finance Analyst
Date of Employment : October 2005 – May 2006
Employer : Cadbury India Limited
Title : Finance Analyst
Date of Employment : Oct 2004 till Sept 2005
Employer : ASTAD Project Management (Qatar)
Type : Oracle R12 Support
Technology/Software : Oracle Applications Release 12.2.4 Projects, GL, AP, AR, P2P, OBI Reports
Client : In House
Duration : Aug-18 till Sept-18
Role : ERP Functional Lead
ASTAD Project Management is Civil Construction & Project Management Company in Qatar and leader in construction business and having international clients and ranked 10th across the globe in construction business.
Providing Support to business users for Projects module and Financials (AP,AR,GL,PO )
Configured Business Unit and Project Unit Options.
Define Project related Organizations and Organization Trees.
Define Expenditure Types, Expenditure Categories, Revenue Categories, and non labour Resources.
Implemented Labour and Non Labour Costing.
Responsible to check and handle conversions related mapping from Oracle resource management application to projects.
Define project template and project types.
Handling and responding to tickets through ticketing tool (In-house ticketing tool )
Handling Change Request (Business Demand Request) and proving solution and implementing.
Doing testing and conducting UAT and get UAT sign off from business stakeholders.
Completing Various Documentations like User Manuals,MD 50, BP 80, BR 100
Designing Reports based on user requirements in OBI application.
Demonstrating New features in Oracle to reduce the manual work that is out of system.
Take responsibility of the update and enhancement of critical management reports
Project General Motors, Detroit (R12 Implementation and Production Support)
Employer : Capgemini India Pvt Ltd, Mumbai
Type : Oracle R12 Support
Technology/Software : Oracle Applications Release 12.1.3 GL, AP, AR, Cash management, PA,Fixed Assets
Client : General Motors- Detroit
Duration : Oct-13 till May-16
Role : Functional Consultant
General Motors commonly abbreviated as GM is an American multinational company headquartered in Detroit that designs, manufactures and distributes vehicles and vehicle parts with employee count of 180000 people.
Responsible for Financial Modules support and month end activity.
Understanding Business Requirements and Documentation
Knowledge of various standard interfaces.
Configured Project Billing related revenue, invoice method and bill plan to meet business need.
Defined project types and project templates to meet business requirements.
Testing and checking projects related new enhancements and automations.
Strong domain knowledge and expertise in AP, AR, GL, FA, CM and Project costing and Billing
Design integration with third party application and build exceptions and validations logic (SIT)
Preparing gap analysis and designing suitable solution
Co-ordination with Offshore Team, conduct calls for issue monitoring.
Understand and resolve Business issues on day to day basis.
Conducted data migration activity, including data conversion, data upload through Data load.
Implementation of budget carry forward functionality
Provided training to end users for new processes and modules
Preparing the status reports Weekly and Monthly.
Resolved the Reconciliation issues with Sub ledgers to GL
Setting up budgetary control process and designing new reports.
Preparing and maintaining AIM Documentations
Conduct CRP, UAT, Training
Issue logging and resolution on organizational internal ticketing tool.
Project Sogeti Netherlands R12 Implementation,Upgrade and Support
Employer : Capgemini India Pvt Ltd. Mumbai
Type : Upgrade and Post Go-Live Support
Technology/Software : Oracle Applications Release 12.1.3 GL, AP, AR, Cash management, Fixed Assets.
Client : Sogeti Netherland
Duration : Jan-09 till Oct- 13
Role : Functional Consultant
The Sogeti Group is an information technology consulting company specializing in local professional services with headquarters in Paris employing around 20000 people at around 300 branches in 15 countries. Involves upgrade of Oracle Applications Release 11.5.10 instance to Release 12.1.3
Worked on implementation of modules like Financials (Project Accounting, AP, AR, GL, CE, FA)
Configured implementation Option and Project related Organization Hierarchies.
Defined the classification categories and classification codes to configure the Auto Accounting.
Implemented labour and non labour costing, defined project type, project temples.
Experties in Project Budget and encumbrance accounting.
Experienced in working budgetary encumbrance environment for GL.
Well versed with data migration and data conversion activities.
Hands on knowledge on PL/SQL queries and packages.
Prepare RD50 document based on MOM.
Assessment of the impact of the key changes introduced by the new release (12.1.3) on the standard business processes of implemented E-Business suite (18.104.22.168)
Upgrade of Oracle Applications Release 11.5.10 instance to Release 12.1.3
Pre and Post Upgrade configuration and reconciliation of 11i and R12 before and after Upgrade.
CRP/UAT training for Business users and timely resolution of issues.
Testing of various test scenarios in P2P, O2C cycle, FA, Payables, Receivables, local taxes related part.
Implementation of Cash Ledger Functionality and secondary reporting ledger.
Identifying issues/bugs in application and resolving them in time
Preparing Visio process diagrams for AS IS/TO BE scenarios
Basic Form Personalization as per user requirements
Analyzing user needs, conferring with users to improve procedures and identifying and solving problems
Log, view, access, monitor, follow up and close Technical Assistance Requests (TARs) on-line-Oracle Metalink and Oracle Applications Patch Management
Analysis, design and implementation of seamless integration between 3rd Parties’ General ledger, Purchasing and Work in Process.
Guiding for Customized Report, Interfaces etc and interaction with technical team.
Post Go-Live Support
Project Project Controlling and Delivery Initiatives for SBU
Employer : Capgemini India Pvt Ltd.
Type : Project Controlling and Delivery Initiatives for SBU
Technology/Software : EM Portal Rollout
Client : Sogeti Netherland & Capgemini UK
Duration : May 2006 to Jan 2009
Role : Senior Consultant
EM portal is Oracle based application which provides facility for Engagement Managers & Delivery Managers to update current risk status of active engagements to senior management on weekly basis.
Conducted EM Portal Rollout trainings & Support for Engagement Managers and Delivery Managers
Provided support in operational issues to EM, DM and Delivery Directors
Weekly Operations Board for COO to review Red /Amber Engagements with Heads of Delivery
Handling Project Reporting and Sales Reporting and responsible for Adhoc analysis, preparation & presentation of Weekly/Monthly MIS reports to clients
Revenue analysis with respect to Divisions, Client wise and Sales Sector wise
Calculation of Revenue Corrections, Correction still to be booked
WIP/BIA project End Likely vs Project Budget Contribution Margin PTD: Profitability of project up and until this month (based on actual booking)
Identifying critical loss making projects, Single Project Analysis, Attention List, FAF (Financial Acknowledgement forms)
Generating Project reporting for all divisions which gives overall picture about profitability and weak areas division wise
Internal and external communications, project management, delivery and reporting
Employer : Marsh India Pvt Ltd
Duration : Oct 2005 to May 2006
Role : Senior Finance Analyst
Marsh Inc. is the World’s leading risk and insurance Services MNC firm. Marsh provides Risk management &Insurance broking Services to Business, Professional & public entity Organizations.
Marsh provides advice and transactional capabilities to clients with more than54000 employees in over 100 countries worldwide. Marsh is a unit of Marsh and McLennan Companies, a global professional services firm providing advice and solutions in the areas of risk, strategy and human capital.
•Payment Processing, Supplier outstanding statement reconciliation
•Credit Monitoring, Debtors Management and Revenue Recognition
•Fortnightly CSR Payments, Budgeting, Monitoring working capital requirements
•General ledger Accounting including Accruals and Outstanding Incomes/ Expenses
•Assisting Finance Manager in preparing Inter Company Reconciliations
•Preparing Profit & loss account as well as various annexure of the Balance Sheet
•System enhancement & streamlining
•Revenue Reporting, Reconciliation of Invoices & Collection of TDS Certificates for all Payments.
•Distribute Travel & entertainment Payments & reconciling the same
•Handling all queries relating to Vendors; Reconciliation of Vendor Statements
•Weekly Fund Position MIS. Monthly fund Flow and cash Flow Statement
•Preparing database & accounting for the Amex cards, Overhead management
•Identify and resolve invoice discrepancies and payment irregularities
•Assisting in preparing various Reports/Funs Flow Statements to Finance Manager
•Bank Reconciliation Statement on Monthly Basis, Budgeting
•Debtors Management, Debit/Credit Notes
•Preparing age wise analysis of debtors & reporting to Management
Employer : Cadbury India Pvt Ltd.
Type : Finance Analyst
Duration : Oct-04 to Sept-05
Cadbury India Ltd is India’s leading confectionery manufacturer with a 70% volume share of chocolate market with an annual turnover of Rupees 23 Billion approx. Oracle ERP Accounting Environment.
• Handling Accounts Receivable, Accounts Payable in Oracle R12
• Assist in Month End Closing, inventory evaluation
• Accrual/Deferral Documents; Passing JVs for closing accounts etc.
• Vouchers Payable, Collection of raw and packaging material receipts notes
• Raw and Packaging material cost Report, Stock Reconciliation
• Initiation of corrective actions based on expenditure trends for adjustment of expenditure booking
• Analysis of expenditure returns in respect of Central Purchase (CP) booking and resolving wrong and unidentifiable bookings
• Analysis of Expenditure like Power, Labor Exp.& Admin.Exp etc. and follow up with user departments
• Product-wise, Branch-wise Costing
• Valuation of Raw Material & Packing Material (with reconciliation of stocks from ERP System)
• Profitability Analysis; MIS Reporting
• Preparing Bank Reconciliation of Western region collection Accounts on monthly basis
• Preparing Re-distributors Debit/Credit notes for various field activities.
• Interacting with Depots for MIS function
• Overhead Costing like Activity based costing
• Preparing Monthly BPR (Branch Performance Reports)
• Analyzing and preparing various MIS Reports.
• Internal /Statutory Audit Support
• Preparing Fund Flow & Cash flow Statements on monthly basis
In the year Apr-2001 from Mumbai University securing First Class (68%)
In the year 1998 from Maharashtra Board securing First Class (73%)
In the year 1996 from Maharashtra Board securing First Class (71%)
Professional Qualification – ICWAI
Institute of Management Accounting (IMA) – Certified Management Accountant (CMA) USA
CMA Certification Course
Next Attempt in 2019
Got selected as best performer and won Incentive trip to Netherland in year 2012.Had an overseas on shore experience for gaining business knowledge of completely new process to be transferred to offshore. Many Appreciations from Onsite Counterparts.