Functional Consultant Resume
PROFESSIONAL SUMMARY:
- Over 14 Years of experience with strong knowledge and expertise on Financial and Distribution modules of Oracle eBusiness suite
- Over 6 years as Business Process SME/ Architect
- About 8 years as Sr. Business Analyst/Functional Analyst
- Masters in Computer Applications and Certified R12 Oracle Financials Implementation Expert
- Implemented Oracle Cloud Financials Release 11 for a Biomedical Client scope includes
- Procure - to-Pay Solution PO-AP-FA and GL
- Footprint across Multi Country with multi-currency and multiple ledgers
- Fusion Payables, Assets, Cash Management - Bank Reconciliations
- Fusion Financial Reporting Cloud Services
- Fusion OTBI & ADFDI
- Financial Reporting Studio and SmartView
- Expert domain knowledge in the Procure-to-Pay(P2P), Quote-to-Cash (QTC/O2C), Record-to-Report(R2R) business processes
- Extensive knowledge of enabling various accounting principles and their application to various business processes in Oracle eBusiness Suite as per US Generally Accepted Accounting Standards (US GAAP), International Financial Reporting Standards (IFRS) & Indian Accounting Standards
- Expertise in Smoothening the Period closure procedures, Reconciliations and Management & Corporate Financial Reporting.
- Industry Domain Knowledge in Telecommunications & Networking Solutions, Retail, Insurance & Brokerage, Investment Banking & Finance Corporations
- Experience in various Finance Business Transformation Initiatives in optimizing the existing business processes and designing new business processes that are scalable to meet the business strategies & objectives for various clients.
- Highly skilled in Identification of High Level Business Capabilities, Business Case Preparation, Formulation of Business Capability & Delivery Roadmap, High Level Impact Assessment on various finance process due to changes in accounting rules & other business initiatives
- Vast experience in identification of high level & detailed requirements to support the business processes/capabilities and documentation of business requirements(BRD)
- Experience in implementation of Oracle Financials (Accounts Payables, Cash Management, Fixed Assets, General Ledger, Accounts Receivables, eBusiness Tax, Trading Community Architecture etc) and Oracle Project Accounting (Project Costing, Project Billings, Project Management and Oracle Time & Labor)
- Experience in integrating oracle eBusiness suite with the third-party tax engines viz Vertex, Taxware etc., and enabling Oracle E-Business Tax calculations for US Sales Tax and Use Tax.
- Experience in simulating the configurations of Oracle GRC (Governance Risk & Compliance)
- Involved in various Implementation projects, Upgradation projects, Support projects, custom solutions/enhancement projects of Oracle Financials 11.5.8, 11.5.9, 11.5.10 & R12
- Acquaintance with Project Execution Methodologies - AIM, Waterfall & Agile
- Working experience in the Functional Skills: requirements gathering, functional gap analysis, application design, configuration, module setup, writing guides, and change management
- Proven Leadership qualities in managing various complex projects with high cross functional impact.
- Working experience in Project Scoping, Project Plan, Resource Assignment, Project Delivery
- Instrumental in conducting CRP, UAT and User Sessions.
- Strong analytical and problem solving skills, effective communication skills and leadership skills to develop a creative solution for challenging task.
TECHNICAL SKILLS:
Oracle Applications: Oracle Cloud Financials Release 11, Oracle Financials Releases: 11.02 & 11i and R12.0 - R12.1.3 General Ledger (GL), Fixed Assets (FA), Accounts Payable (AP), Accounts Receivable (AR), Cash Management (CM), Subledger Accounting (SLA), Oracle EBTAX, Oracle Project Costing and Project Billing (PA), Purchasing (PO), Order Management (OM), Inventory (INV) and Relevant Areas of System Administration (SA), Application Developer (AD) and Oracle Cost Management (Discrete Costing).
Methodologies: AIM - Application Implementation Methodology, SDLC, AGILE
Business Cycles: Procure to Pay (P2P), Order to Cash (O2C), Record to Report (R2R)Project Accounting, Project Billing & Standard Costing
Operating Systems (O/S): Linux, Sun Solaris 2.8, Windows 2000/NT 4.0/98/95 /Windows XP /Windows 7
Databases (RDBMS): Oracle 9i/ 8i/10g
Tools: /Utilities: PL/SQL, TOAD, Data Loader, ADI, FSG, Discoverer, Work Flow, Forms 6i, Reports 6i and MS-Office Tools.
Testing Tools: Mercury Test Director 7i, Quick Test Professional 8.2
Domain Knowledge: Banking & Finance, Asset & Fund Management, IP networking Technologies, Engineering, Entertainment, Airline, Semi-Conductor, Telecom, Cables, Paper & Paperboards, Retail, Insurance & Brokerage, Investment Banking & Finance Corporations etc.
PROFESSIONAL EXPERIENCE:
Confidential
Functional Consultant
Responsibilities:
- SMBC’s application eco system consists multiple subsystems tightly integrated with each other and Oracle EBS being their main system for transactional processing, record keeping and financial reporting
- SMBC’s landscape spans to multiple geographies across North America, EMEA & Asia-Pacific.
- Supporting and designing new interfaces and making enhancements to new functionalities in GL & FA Modules
- Working with the business users and providing support for the issues originated with Financial reports, period closure procedures, integration of interface systems, and reconciliations etc
- Coordinating and working with multiple teams to ensure correctness to and from the upstream and downstream applications
- Maintenance of the system to ensure smooth transaction processing, record keeping, financial reporting and reconciliations
- Customizing SLA to ensure the custom accounting needs as per the GAAP Standards for US, Japan and Canada
Confidential
Functional Consultant
Responsibilities:
- Integra’s application footprint consists multiple sites across North America and Europe.
- All Financials, SCM, Project Accounting modules support and maintenance
- Multiple inbound and outbound interfacing systems and a cohesive ERP application
- Integration to multiple payment systems (Paypal, Cr Card, XML Payments)
- Instrumental in working on the Automatic Receipts and Auto-lockbox interfaces to streamline the receipt processing
- Working with banks and setting up the templates for bank statement loaders for Automatic Bank reconciliations
- SABRIX Integration with Oracle eBusiness suite for Tax computation.
- Supporting the user issues, product and process enhancements
- Managing the SLA and delivering the solutions per the business requirements
- Setting up the system to cater to the new acquisitions (3 New Companies have been acquired recently)
- Instrumental in working on the IR/ISO process streamline the Inter-Org material transfers and managing them via shipping networks
- Facilitating Consignment process in Oracle Order Management and configuring the drop shipment and back order processes
- Configuring the system to cater to the accounting requirements and to the ease of user transactional processing and period end reconciliations by setting up the rules to defer the COGS until Revenue is recognized
- Streamline the Order to cash cycle utilizing the standard oracle modules to the extent possible (OM, AR, CE, Advance Collections) from order entry till the cash collection process automated the process where ever applicable
- Defining Process constraints to limit / extend the user transactional processing in oracle order management
- Ensuring that the production system be stable and streamline the period close procedures.
Confidential
Functional Consultant
Responsibilities:
- Footprint across North America, Europe and Asia Pacific Multi Country with multi-currency and multi Ledgers.
- Procure to Pay Solution - PO - AP - FA and GL
- Worked on standard outbound and inbound bank interfaces like ACH, Positive Pay and Bank Statements
- Implemented Approvals for Requisitions, PO’s and AP Invoices
- Developed reports using OTBI, Smart View and FRS
- Web service Integration to download FX rates
- Web services integration with concur to interface T&E Expenses
- Implementing Integrated Scanned Invoice Imaging to import scanned PDF and JPEG invoices
- Consolidations for multiple entity corporations
- Created financial Statements using FRS
- Conversion of Data using FBDI Templates.
- User creation using Oracle Identity Manager and created custom roles using security console or authorization policy manager
Confidential
Lead Functional Consultant
Responsibilities:
- Implementation involves all financial and SCM modules along with Oracle Project costing and OTL with all the external systems integrations to Markview, IQN, Endeca, Blackline etc.
- Multi-Country, Multi Currency footprint constitute North America, Europe, APAC Implementation.
- Responsible for all the Financials & SCM Modules (GL, AP,AR,FA,CM,PO, iProc, EBTax)
- Participating in the business meetings to gather the current business requirements
- Understand the current business process and identify the key process improvements
- Perform the Fit-Gap Analysis for the business requirements and identify the customizations
- Coordinate with the Technical team to design the custom interfaces and reports, perform the unit testing of the custom components
- Anchoring CRP, UAT and User Sessions for the new System (R12)
- Documenting the System configurations (BR100’s & MD120’s)
- Establishing the communication and Interfacing the dataflow by Integrating Oracle eBusiness Suite into the new system BEELINE which replaces the current system of Vendor management and consultant’s project assignment and accounting tool IQN.
Confidential
Lead Functional Consultant
Responsibilities:
- Understanding the current system and the day-to-day business operations there by analyze and suggest the process improvements
- Creating functional design documents for new enhancements.
- Conducting CRP and s to the business users and providing resolution of Functional issues reported during UAT.
- Documenting the solution for the issues reported during the systems testing and during all other phases of the project in the upgrade cook book
- Designed the solution to retire the existing customizations around the Mastercard’s custom payment process for SEPA Payments and leveraging the Standard functionality.
- Instrumental in working on the bank reconciliations
- Devising the Upgrade project cut-over plan coordinating various teams, listing down all the activities of the upgrade and the respective owners of each of the activity and running through this plan and making each member of the project aligned with their respective activities performing a seamless upgrade rehearsals
- Conducting CRP sessions to ensure the system caters to all the business functions
- Conducting the s and preparing the business users to go through successful UAT and getting the systems sign-off.
- Documenting all the nice-to-have options and creating a road-map plan for the future enhancements
Confidential
Lead Functional Consultant
Responsibilities:
- Understanding the current system and the day-to-day business operations there by analyze and suggest the process improvements
- Creating functional design documents for new enhancements.
- Conducting CRP and s to the business users and providing resolution of Functional issues reported during UAT.
- Devising the usage and the applicability of the new features of the R12 viz., MOAC, Ledger Sets etc where ever possible and leveraging them for the betterment of the processes where ever it can be.
- Review the customizations around the account generators and design the appropriate derivations using SLA
- Documenting the solution for the issues reported during the systems testing and during all other phases of the project in the upgrade cook book
- Devising the Upgrade project cut-over plan coordinating various teams, listing down all the activities of the upgrade and the respective owners of each of the activity and running through this plan and making each member of the project aligned with their respective activities performing a seamless upgrade rehearsals
- Conducting CRP sessions to ensure the system caters to all the business functions
- Conducting the s and preparing the business users to go through successful UAT and getting the systems sign-off.
- Documenting all the nice-to-have options and creating a road-map plan for the future enhancements
Confidential
Lead Functional Consultant
Responsibilities:
- Worked on 1 Implementation and 2 Production Support and Maintenance Projects on Orale R12.1.3
- Instrumental in designing complex customizations up on AGIS during the re-implementation of Oracle R12 for SalesForceDotCom. Also, worked on re-designing the chart of accounts and SLA customizations in order to support for the operations in multiple countries to enhance managerial and GAAP reporting.
- Managed and lead the production support and maintenance from the customer’s site (USA) for Marsh and McLennan Group of Companies (Marsh, Mercer & Guy Carpenter)
- Experience working with interfaces and Third party invoice imaging systems like Markview, and Integrating with Oracle eBusiness Suite.
- Got Trained and has worked on a production support project on Hyperion Financial Management (HFM).
- Simulated Oracle GRC Environment by configuring all the 4 Control governors. Hence, developed a prototype to help the Confidential pre-sales team give a working demo of the GRC implementation to the customers
- Undertaken multiple s and has contributed to the competency team building and capacity planning.
Confidential
Sr.Functional Consultant
Responsibilities:
- Worked on 3 Implementations, 3 Rollouts, and 2 Production Support & Maintenance of Oracle eBusiness Suite for various premier customers of Satyam viz., (JDSU, Electronic Arts, Al Bayan, Balfour Beatty, AMAT, BMI, Cisco and Khanna Papers Ltd. ) at onsite spanning across various geographies viz., Dubai, Singapore, Germany, Kenya, USA and India.
- Duly performed all the project activities that comprises - Understanding the current business process, gathering the requirements and design the best fit solution, configure, test, and execute the project providing all the deliverables with optimal quality and Standards. Worked on multiple projects that have complex data migration activities as well.
- Instrumental in performing the complex data conversions - Open & Historical balances successfully completed loading the AR historical balances for the multiple previous years without any reconciliation issues.
- Implemented Oracle Daily Business Intelligence for a couple of premium customers of Satyam (TECOM, Kenya Airways).
- Experience working with third-party systems viz., Markview, Get Paid etc. and integrating them with Oracle eBusiness Suite Applications.
- Experience on working with Asset life cycle management modules viz., Oracle eAM, Oracle Asset Tracking, etc.
- Responsible for carrying out the semi-annual cost rollup activity for all the standard costing organizations in Applied Materials (AMAT)
