Functional Consultant Resume
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 teh 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 Smootaning teh 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 teh existing business processes and designing new business processes that are scalable to meet teh 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 teh 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 teh 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 teh 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 teh Functional Skills: requirements gathering, functional gap analysis, application design, configuration, module setup, writing training guides, training 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 Training Sessions.
- Strong analytical and problem solving skills, TEMPeffective 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:
- Confidential ’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
- Confidential ’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 teh business users and providing support for teh 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 teh upstream and downstream applications
- Maintenance of teh system to ensure smooth transaction processing, record keeping, financial reporting and reconciliations
- Customizing SLA to ensure teh custom accounting needs as per teh 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 teh Automatic Receipts and Auto-lockbox interfaces to streamline teh receipt processing
- Working with banks and setting up teh templates for bank statement loaders for Automatic Bank reconciliations
- SABRIX Integration with Oracle eBusiness suite for Tax computation.
- Supporting teh user issues, product and process enhancements
- Managing teh SLA and delivering teh solutions per teh business requirements
- Setting up teh system to cater to teh new acquisitions (3 New Companies has been acquired recently)
- Instrumental in working on teh IR/ISO process streamline teh Inter-Org material transfers and managing them via shipping networks
- Facilitating Consignment process in Oracle Order Management and configuring teh drop shipment and back order processes
- Configuring teh system to cater to teh accounting requirements and to teh ease of user transactional processing and period end reconciliations by setting up teh rules to defer teh COGS until Revenue is recognized
- Streamline teh Order to cash cycle utilizing teh standard oracle modules to teh extent possible (OM, AR, CE, Advance Collections) from order entry till teh cash collection process automated teh process where ever applicable
- Defining Process constraints to limit / extend teh user transactional processing in oracle order management
- Ensuring that teh production system be stable and streamline teh 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 teh external systems integrations to Markview, IQN, Endeca, Blackline etc.
- Multi-Country, Multi Currency footprint constitute North America, Europe, APAC Implementation.
- Responsible for all teh Financials & SCM Modules (GL, AP,AR,FA,CM,PO, iProc, EBTax)
- Participating in teh business meetings to gather teh current business requirements
- Understand teh current business process and identify teh key process improvements
- Perform teh Fit-Gap Analysis for teh business requirements and identify teh customizations
- Coordinate with teh Technical team to design teh custom interfaces and reports, perform teh unit testing of teh custom components
- Anchoring CRP, UAT and User Training Sessions for teh new System (R12)
- Documenting teh System configurations (BR100’s & MD120’s)
- Establishing teh communication and Interfacing teh dataflow by Integrating Oracle eBusiness Suite into teh new system BEELINE which replaces teh current system of Vendor management and consultant’s project assignment and accounting tool IQN.
Confidential
Lead Functional Consultant
Responsibilities:
- Understanding teh current system and teh day-to-day business operations their by analyze and suggest teh process improvements
- Creating functional design documents for new enhancements.
- Conducting CRP and Trainings to teh business users and providing resolution of Functional issues reported during UAT.
- Documenting teh solution for teh issues reported during teh systems testing and during all other phases of teh project in teh upgrade cook book
- Designed teh solution to retire teh existing customizations around teh Mastercard’s custom payment process for SEPA Payments and leveraging teh Standard functionality.
- Instrumental in working on teh bank reconciliations
- Devising teh Upgrade project cut-over plan coordinating various teams, listing down all teh activities of teh upgrade and teh respective owners of each of teh activity and running through dis plan and making each member of teh project aligned with their respective activities performing a seamless upgrade rehearsals
- Conducting CRP sessions to ensure teh system caters to all teh business functions
- Conducting teh Trainings and preparing teh business users to go through successful UAT and getting teh systems sign-off.
- Documenting all teh nice-to-has options and creating a road-map plan for teh future enhancements
Confidential
Lead Functional Consultant
Responsibilities:
- Understanding teh current system and teh day-to-day business operations their by analyze and suggest teh process improvements
- Creating functional design documents for new enhancements.
- Conducting CRP and Trainings to teh business users and providing resolution of Functional issues reported during UAT.
- Devising teh usage and teh applicability of teh new features of teh R12 viz., MOAC, Ledger Sets etc where ever possible and leveraging them for teh betterment of teh processes where ever it can be.
- Review teh customizations around teh account generators and design teh appropriate derivations using SLA
- Documenting teh solution for teh issues reported during teh systems testing and during all other phases of teh project in teh upgrade cook book
- Devising teh Upgrade project cut-over plan coordinating various teams, listing down all teh activities of teh upgrade and teh respective owners of each of teh activity and running through dis plan and making each member of teh project aligned with their respective activities performing a seamless upgrade rehearsals
- Conducting CRP sessions to ensure teh system caters to all teh business functions
- Conducting teh Trainings and preparing teh business users to go through successful UAT and getting teh systems sign-off.
- Documenting all teh nice-to-has options and creating a road-map plan for teh 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 teh re-implementation of Oracle R12 for SalesForceDotCom. Also, worked on re-designing teh chart of accounts and SLA customizations in order to support for teh operations in multiple countries to enhance managerial and GAAP reporting.
- Managed and lead teh production support and maintenance from teh 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 TEMPhas worked on a production support project on Hyperion Financial Management (HFM).
- Simulated Oracle GRC Environment by configuring all teh 4 Control governors. Hence, developed a prototype to help teh Confidential pre-sales team give a working demo of teh GRC implementation to teh customers
- Undertaken multiple trainings and TEMPhas contributed to teh 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 teh project activities that comprises - Understanding teh current business process, gathering teh requirements and design teh best fit solution, configure, test, and execute teh project providing all teh deliverables with optimal quality and Standards. Worked on multiple projects that has complex data migration activities as well.
- Instrumental in performing teh complex data conversions - Open & Historical balances successfully completed loading teh AR historical balances for teh 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 teh semi-annual cost rollup activity for all teh standard costing organizations in Applied Materials (AMAT)