SUMMARY

• Over 14 years of experience in design, development, architecting, implementation & support of Oracle Applications e - Business Suite Projects & Finance in Oracle Fusion, R12 & 11i versions and over 10 years of functional expertise.
• Expertise working on multiple projects in implementation, up-gradation, rollouts, support & proof of concept (POC) projects in Oracle Fusion & Oracle E-Business Suite.
• Professional expertise in Design, Develop, Implement, Customize & Debug of Oracle Applications e-Business Suite
• Project Portfolio Management Suite - Project Financial Management - Project Accounting, Project Costing, Project Revenue & Billing, Project Grants Management, Project Execution Management - Project Planning, Project Controls, Project Resource Management.
• Financials Suite - General Ledger, Sub-Ledger Accounting, Accounting Hub, Account Payables, Cash Management, Account Receivables, iExpense & Fixed Assets
• Supply Chain Management Suite - Purchasing, iProcurement, Order Management, Inventory, Landed Cost Management.
• Experience in working on project auto accounting setups, costing & billing extensions, standard and custom workflows & business process configuration and enhancements as per expanding business needs, with rollout of Project Portfolio Suite to over 40 countries and legislations.
• Experienced in analyze, design, development, enhance and debug RICEFW components (Reports, Interfaces, Customizations, Extensions, Forms and Workflows), REST APIs, SOAP services & Oracle Fusion Database Map.
• Experience in using Oracle Application Implementation Methodology(AIM) & Oracle Unified Method(OUM): Business Functional Requirement analysis, Understanding AS-IS process, TO-BE process, Gap analysis, Solution designing, System configuration, Conducted POC’s and CRP’s, Co-ordinate UAT & extensively worked on Preparing documentation (BR100, BR150, BR30, MD50, BP80, RD20, CV40 & TE40, FSD & TSD).
• Experience in working with global implementation of AGIS (Advance Global Intercompany System), Involved in Multi-Org & Multi-Currency, re-valuation, translation and GCS (Global Consolidation System), Design & develop Financial Statements (FSG’s) as per Business Requirement.
• Good Experience with design, configure & implement Approvals through Approval Management (AME / AMX), Daily Business Administration (DBI), Workflows, Web ADI, Discoverer, BI Publisher (BIP) & Oracle Transactional Business Intelligence OTBI Reports.
• Experienced with Data Conversions/Migration/ Integration with various system integrations with e-Business Suite which includes PeopleSoft, Maximo, Inspyrus, Concentric, Hyperion, Microsoft Projects, ASW, Alpha, Manhattan Warehouse Management, Oracle Business Intelligence, Denodo, Power BI, Sabrix and various other .NET and Java based custom in house applications.
• Excellent communication skills with customer at all levels as well as Coordinating with various teams of outside vendors, Off-shore team and leadership qualities with analytical problem solving skills thriving to achieve proactive approach & thorough knowledge on Microsoft technologies (Office, Visio & Visual Studio).
• Completed Oracle Cloud Training for Certification in Implementing Oracle Project Portfolio Management (PPM) and Implementing Oracle Cloud Financials (FIN) including General Ledger, Fusion Accounting Hub, Expenses, Accounts Payables, Purchasing, Account Receivables, Cash Management, Project Costing, Project Billing, Project Management & Execution, Project Resource Management Business Intelligence (BIP and OTBI), Integration Cloud (OIC) and REST API’s.

TECHNICAL SKILLS

EBS Versions: Oracle Application Fusion 19C & 19D, Oracle e-Business Suite R12.2.5, R12.1.3, 11i - 11.10.2

ERP Modules / Offerings: Financials - General Ledger (GL), Sub Ledger Accounting (SLA), Accounting Hub (FHA), Accounts Payables (AP), Cash Management (CE), Fixed Assets (FA), iExpenses, iPayment, Account Receivables (AR), Advance CollectionProcurement - iProcurement, Purchasing (PO), Order Management (OM), Procurement Contracts, Inventory (INV), Landed Cost Management (LCM)

Projects: Project Portfolio Management (PPM), Project Management & Execution (PJT), Project Intelligence (PJI), Project Controls (PJC), Project Resource Management (PJR), Project Costing & Project Billing (PA)

Databases: Oracle 12c / 10g / 9i

Development Applications: Oracle Forms & Reports 6i / 10g, Workflow Builder, AME / AMX (Approval Management), XML Reports, Crystal Reports, Oracle Discoverer Reports

Languages: C, C++, SQL, PL/SQL, HTML, SOAP & REST APIs

Support Tools: Service Desk, Remedy, Jira, HP Help Desk, Mercury Kintana, Maximo

Business Intelligence Tools: Daily Business Intelligence (DBI for HRMS, Procurement and Financials), Oracle Business Intelligence Enterprise Edition (OBIEE Financial, Procurement, Projects and HCM Analytics), Business Intelligence Publisher (BIP for Ad Hoc Reporting) & Oracle Transactional Business Intelligence (OTBI)

Applications Integrated with: PeopleSoft, Maximo, Hyperion, Inspyrus, Markview, Concentric, ASW, Oracle SoA, Zema, Sabrix, Microsoft Projects, Oracle Integration Cloud (OIC), Manhattan Warehouse Management System, Alpha Invoice Processing, TIBCO

Office Tools: MS Word, MS Excel, MS PowerPoint, MS Access, MS Visual Studio, MS Projects

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, Georgia

Oracle Project & Financial Functional Consultant

Responsibilities:

• Solution Design, application Configuration & Demonstration Oracle Fusion 19D emphasizing Accounting Hub integration with Alpha and ASW for balanced & reliable accounting process.
• Design & Implement “Import Duty” Cost Factor in pricing
• Document & Configure Roll out of new Business Entity. entire projects & financials suite including accounting configurations, Ledgers, Legal Entities, Currency, Chart of accounts, Accounting Hierarchies, Allocation rules, Cross validation Rules, project costing & billing extensions, Intercompany Accounting.
• Implemented process improvement in Integrations with Manhattan Warehouse Management application
• Document & coordination of Internal Bank Change for Payments & Automated Bank Reconciliation
• Single point of contact for Year End & Month End activities from Oracle Finance IT, focus on resolving Account Reconciliation issues.
• Automation of supplier maintenance reducing manual intervention in deactivating in active suppliers.

Confidential, Houston, Texas

Oracle Project & Financial Functional Consultant

Responsibilities:

• Solution Design, Application Configuration & Demonstration Oracle Fusion 19D for Financials & Project Portfolio Management (PPM)
• Documenting Business Requirements & Identified Gaps in Oracle Fusion
• Emphasized on use of Financial Accounting Hub components utilizing existing Oracle Hyperion at Cheniere and enhancement to Project Budgeting & Forecasting capabilities.

Confidential, Houston, Texas

Oracle Project & Financial Functional Consultant

Responsibilities:

• Application upgrade from R12.1.3 to Oracle Fusion Cloud 19C IAAS Configuration & Migration for Financials & Project Portfolio Management
• Document & Configure Rolled out of new Operating Units for acquired business along with restructuring of organization
• Design & Implement Project Work plan Progress Tracking by utilizing Resource Breakdown Structure for budget & forecast.
• Designed & Implemented improved project commitment tracking process using project cost extension
• Documented & Improved Revenue Recognition & Project Billing using extensions & auto accounting for inclusion of taxation in multicurrency, multi-organization environment following FERC Accounting Standards.
• Designed & implemented new dashboards and reports for Procurement, improved Project and Financial Analytics targeting global data requirements with least possible reports at same time ensuring integrity and security of critical information. Some of them are Unbilled Aging Report, AR Invoice Aging, Project Margin Analysis, Man Hours Analysis and various operational and Income Statements

Confidential, Houston, Texas

Oracle Project & Financial Functional Consultant

Responsibilities:

• Design, developed & implemented Projects Outbound interface for Projects & Tasks also Inbound interface for Projects Budget & Forecast interface with Oracle Hyperion
• Implemented new processes for Service Procurement using Oracle Time & Labor along with Custom Contingent Worker Expense solution fully integration with PO, AP and PA.
• Enhancement & coordination of interfaces while upgrade of Maximo from 7.5 to 7.6, Oracle SoA from 11g to 12c, Hyperion from 11.1.1.2 to 11.1.2.4, OBIEE to 12c version, HRMS upgrade from R12.1.3 to HCM Cloud 18B.
• Analyze, design & implement process improvement solutions for instance Re-configured AP-PO Hold setups, tolerances & workflow, Sub-Ledger Accounting following FERC Accounting Standards as well as changing business requirements.
• Single point of contact Oracle Support & OBIEE Reporting team in off-shore for Finance and Project modules.
• Re-configuration of OBIEE while upgrade to 12c for Procurement and Projects Dashboard Re-implementation.
• Design & Implementing Hyperion Integrated dashboard for Financial, Projects and Production Budget & Forecast.
• Design & Introduced new dashboard for Internal Controls (Payables, Employee Expenses, Account Receivables, Fixed Assets), EBS & Maximo Reconciliation.
• Design and implementation of Bank Integration interfaces for payments and automatic Bank Reconciliation that requires virtually no manual intervention.

Confidential, Los Angeles, California

Oracle Financial Functional Consultant

Responsibilities:

• Requirement gathering, Design, Configure and implement upgrade from 11i.10.2 to R12.1.3
• Improvised on General Ledger structure for improvement used of Cost Center and Intercompany features.
• Division of One Business Group into two for data security between the various companies to comply with government rules & regulation of healthcare accounting in alignment with accounting standards driven by OSHPD.
• Reconfigure Fixed Assets Categories & Clearing Account to streamline tracking of their asset addition & CIP projects.
• Payroll & Benefits restructuring to blend in with the new GL structure, helped in reducing to less than 4,000 elements links as compared with existing 22,000+ element links that resulted in ease of payroll maintenance & faster payroll processing.
• Carried out Proof of Concept (POC) to Implementation of Daily Business Intelligence (DBI) for Finance, Purchasing & HRMS
• Design, develop & Customized Web ADI’s & FSG Reports for improving efficiency.
• Documented & Executed Data Migration Plan for all modules of Finance, & Purchasing & Payment Methods, GL Balances, outstanding PO’s and invoices’ etc.
• Set-up of Chart of accounts structure, Segment, Values Sets, Flex fields and Segment Qualifiers, Cross Validation Rules, Security Rules, Calendar, Currencies, Standard Journals, Statistical Journals, Recurring Journals and Suspense Accounts and Mass Allocation, Defining FSG’s, Creating Ad-hoc Reports, Consolidation Ledgers & AGIS for intercompany Transactions.
• Set-up of AP and PO including pay groups, payment terms, payment profiles for check and wire, sub ledger accounting of payables transactions, Setup Banks, Bank Accounts and documents.
• Conducting User Training and prepared user training manuals using Oracle’s User Productivity Kit (UPK).

Confidential, Pasadena, California

Oracle Projects Onshore Lead

Responsibilities:

• Carried out Proof of Concept (POC) to Implementation of Oracle Projects Suite (PPM) on R12.1.3 across USA.
• Design, Document & Implemented Project Portfolio Management in complex hybrid environment where Financials was on 10.5, HRMS on 11.10.2 and Projects on 12.1.3.
• 100+ RICEFW components were enhanced as well as built from scratch in coordination with multiple vendors, Off-shore team and individual contractor.
• Configuring the Application for Project Management & related modules like General Ledger, Purchasing, Payables & Receivables in R12. Includes debugging and providing solutions functionally as well as technically (RICEFW components)
• Setting-up Project Management components like Implementation Options, Organizations, Project Types, Statuses, Roles, Periods, Classifications, Control Item Types, Resource Classes, Deliverable Types, Resource Types, Budget and Forecast, Planning Resource List, Resource Breakdown Structure, Work Breakdown Structures, Project Templates, Expenditure & Revenue Categories, Non-Labor Resources, Rate Schedules, Costing Rules, Burden Structure & Rules, Auto-Accounting Rules, Key Performance & Project Status Indicator (KPIs and PSIs) etc.
• Re-evaluate post implementation setups / configuration / customizations against BP040, CV040, BR100, MD050 and test cases (TE040).
• Implemented Project Accounting and Project Management for Public Sector projects including U.S. government contracts with Army and Air Force.
• Rollout Projects to 40+ countries in America, Europe and Asian entities of Jacobs.

Confidential

Oracle Projects & P2P Tech Lead

Responsibilities:

• Design & reimplementation of iExpense across 22 countries of COLT operations involving implementation of new policies, approval rules & accounting for project based expenses.
• Designed & implemented enhancement in AME rules during major Organizational change along with 4 dimensional rules along with account rule generation changes.
• Debugged, designed and implemented process improvement in workflow of iExpense, iProcurement, Purchase Order, Account Payables, Order Management & Advance Collection achieving reduction by 98% of reoccurring issues in less than 1 year.
• Documented & Implemented P2P modules roll out of new business entities
• Represented ERP Team for COLT’s Rebranding Project and coordinated all the changes required in Oracle 11i modules for reports & screens displaying new name & logos.
• Designed, introduced & trained financials shared service team to maximize use of Payables discounts functionality.
• Designed & introduced pro-active monitoring of re-occurring issues utilizing alerts helped in reducing support requests & average resolution time to more than half on quarterly basis.
• Enhanced multiple BI Publisher reports, agent commission payable, Trial Balances, AP-PO Cycle Time etc.

Confidential, Sunnyvale, California

Oracle Finance Technical Analyst

Responsibilities:

• Debug & implemented Process improvement interface between Oracle Apps and PeopleSoft. Markview & Maximo data interactions & pro-actively fixed issues caused by interfaces helping reduce errors to 10%.
• Designed & developed FSG & XML Reports.
• Customizing Workflows for iExpenses, iProcuement, POs’ and AP Invoices, along with use of public API to minimize impact during patch applications & releases from oracle.
• Carried out full functional testing of all financial modules GL, AR, AP, PO, i-procurement, i-Expenses and prepared test documents (TE040) to assist Quality Assurance Team in Load Balancing & Automation Test scripts. Also carried out responsibility for internal team coordination for testing, team of 4.
• Issue resolutions for SIT/UAT Execution for enhancements & Production Support