SUMMARY:

• Over 9 years of experience in IT consulting as an ERP Oracle Functional Financial Consultants in multiple business domains in analyzing, implementing and training of Oracle applications which includes Oracle EBS (11i - 12.2.7), Oracle Fusion R12, R13 (19D).
• Hands-on experience in Oracle EBS/Fusion which includes Design, Development, Programming, Integrations, Data Migrations/Conversions, Testing/QA for HCM/HRMS, Payroll, GL, IP/PO, FA, AP, AR, CM, E-Business Tax, iExpense, i-supplier and e-sourcing module/offerings.
• Extensive experience in implementing and testing Oracle Financial Modules including Procure to Pay process (P2P) & Order to Cash (O2C), Assets to GL, Inventory, TCA, Credit Card Transactions, GL Accounting processes. for various versions of Oracle Applications such as R12, 11i. Fusion R13.
• Conversions and Data Migration from Legacy Systems to Oracle Cloud using FBDI, ADFDI, HDL and Spreadsheet Loader.
• Experienced Software Quality Assurance with strong custom programming and direct end-user support skills
• Experience in developing PL/SQL and SQL statements in databases such as ORACLE SQL, MS SQL and MySQL.
• Expertise involving system analysis, programming and Software Quality Assurance (using HP Quality Center, QTP, TOAD, and SQL Developer).
• Design and Development of Reports and Analysis using BI Publisher, OTBI, transform XML files to Text / HTML Files using XSLT
• Exposure in SOA, Orchestration and Integration Technologies in the areas of Web Services, SOAP, WSDL, XML, XSLT, XSD.
• End-to-End Implementations Testing in Oracle applications R12i/R11i/Fusion from requirement gathering to post production.
• Expertise and hands on experience with implementation of Hyperion planning and Budgeting solution including Finance & Workforce Planning, Management Reporting and Hierarchy Management. Well versed with the planning application and Essbase cubes being developed in Oracle EPM.
• Updating the Verbiage of iprocurement approval notification, loading Item through XML schema.
• Support of production and test instances for upgrade/regression/integration/User acceptance testing. Trained users and developed training material.
• Functional understanding of the workflows and its configurations.
• Creating financial statements and ad hoc reports using FSG (financial Statement Generator).
• Support of production and test instances for upgrade/regression/integration/User acceptance testing..
• System administration skills include defining request groups, responsibilities, users, assigning responsibilities to user setup of profile options and maintaining concurrent programs.
• Experienced in SysAdmin Role, Sub-ledger Accounting (SLA), Accounting Setup Manager, Multi Org Access Control (MOAC).
• Proficient in the concepts of Multi-Org, Global Consolidation System, Multiple Reporting Currencies and Flex field setups.
• Good experience working with Business owners and users; Gathering business requirement; Solution Design; Preparing specification documentation; Designing process workflow; Identifying and resolving Gaps; Providing functional inputs for specifications, Good understanding of business process, and Post implementation Support.
• Proficient in designing and requirements for RICE (Reports, Interfaces, Configuration, Enhancements) Implementation, Conversion, Data Migration.

TECHNICAL SKILLS

Databases: Oracle RDBMS V7, 8i, 9i and 10g,11g,12c,18c

Languages: JAVA, C, C++, BASIC, PL/SQL, SQL*Plus, HTML, XML

Tools: Oracle Portal, PL/SQL, SQL*PLUS, Application Object Library, Developer2000, Developer 6i (Oracle Forms 10g, Form 6i, Forms 5.0, Forms 4.5 & Reports 10g, Report 9i, Reports 6i, Reports2.5), Oracle SQL*Loader, Oracle Enterprise Manager, Hyperion Essbase 9.x, Hyperion Planning 9.x PL/SQL Developer, TOAD, HP ALM/Quality Center, QTP, JIRA, Confluence.

Applications: Oracle EBS R11-12.2.7, Oracle Fusion Cloud R13 (19D), OCR, BPM, OAC, OIC, OIM, SciQuest SEAL (Contract Management Software), KFS(Kuali Financial System), TSM(Total Supplier Management), SmartView, Oracle iSuppler, iProcurement

Operating System: UNIX (SUN Solaris, HP-UX), Windows

Methodologies: Agile, Water Fall, Oracle AIM 3.0

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Fusion Cloud Financial Lead SME

Responsibilities:

• Lead the year long migration/implementation project from JD Edwards to Oracle Fusion Cloud (including key modules like Purchasing, Payables, General Ledger, Fixed Assets, Receivables/Billing etc)
• Designed solutions for data conversion from legacy system, SAAS Fusion Cloud implementation and integrating different third-party systems (Metranet,GEP,OCR, Concur, SAP/Tally/EDI/OMS/DMS/Warranty/Red Prairie/JDE)
• Key stakeholder in discussions around OTBI/BIP Reporting, OAC (Oracle Analytics Cloud) & OIC (Oracle Integration Cloud).
• Designed the whole Oracle Fusion Security Model under Security Console using custom roles, security profiles, RDS (Reference Data Set Assignments, data security policies etc)
• Implemented a new COA (Chart of Accounts) structure instance with currency based ledgers for APAC, EMEA, LATAM and NAM legal entities according to diversified enterprise structure of DTCC.
• Designed all the approval workflows (invoice, requisition, PO, journal, supplier changes) under BPM (Business Process Management) using BPEL (Business Process Execution Language) logic rulesets as per the client requirement
• Customized all the SLA/Changes, Account hierarchies, tree version, DRM (Data Relationship Management) integrations, publishing hierarchies to the Essbase Cubes policies.
• Worked extensively with EPM (Enterprise Performance Management), FR&A (Financial Reporting & Analytics), FP&A (Financial Planning & Analysis), HCM Team (for instance level strategies, payoll integration), EPBCS (Enterprise Planning and Budgeting Cloud Service), FCCS (Financial Consolidation and Close Cloud Service)
• Single handedly carried out the cut-over activities, user training sessions at the time of go-live and since post-live been leading the SysAdmin/PROD Support Team for P2P.

Environment: Fusion R13 (19D), OTBI/BIP, BPM, OAC, OIC, FCCS, SmartView.

Confidential

Sr Oracle EBS/Fusion Financial Functional Consultant

Responsibilities:

• Involved in setups for Ledgers, Responsibilities Multi org, financial options, Payable Options, Suppliers, Tolerances, and Banks.
• Closely worked on a project called Account Standardization at Citi for different countries (implemented around 23 countries) where all the GL accounts were aligned to UNSPSC mapping based on commodity.
• Led a team of analysts (on procurement side) for end to end implementation of Fusion cloud offerings as a part of CITI 2018 Fusion Road map. Major player in decisions revolving around co-existence of EBS and Fusion modules.
• Well versed with Rapid Implementations and configuration packages in Fusion Cloud using FSM (Fucntional Setup Manager), creating Implementation users, role assignments and LDAP (Lightweight Directory Access Protocol).
• Provide solutions to functional issues and involve in testing of the application releases
• Leading an initiative where PRENAX (Subscription Management Company) was on-boarded and integrated with P2P.
• Closely worked with business users to understand the business processes and prepare the business requirements definition documents
• Involved in advisory team for GST implementation for client roll out for CITI India legal entity.
• Learnt an additional tool SEAL (Contract Discovery and Analytics) as a part of e-sourcing solution package for CITI and integrating it with Fusion modules.
• Gathered requirement data, mapped data elements to Oracle functionalities, reviewed gaps, defined work-around solutions to proactively reflect company’s business future outlook. Used descriptive flex fields to cover additional data and to reference historical data during transaction processing.
• Successfully merged multiple sub-ledgers in FAS to one consolidated sub-ledger, responsible for conversion and migration of fixed assets from the Legacy system into oracle,
• Ability to impart Functional training in Oracle General Ledger, Account Payables and Purchasing
• Participating in CRP phases. Train the team members in Sub Ledger Accounting (SLA), Multi Org Access Control (MOAC).
• Supported Oracle R12 Applications - Human Resources, Payables, iProcurement, iExpense, General Ledger, Web ADI and timesheets.
• Create/Maintain/Administration of Hyperion Financial Reporting, applications in HFM & FDM
• Installation of Hyperion Planning, Essbase, HBR, Reports, Analyzer, HAL & license server for new production environment.
• Created SR’s with Oracle for supporting Oracle R11 support tickets and for patch analysis and its implications.
• Creating iprocurement Category hierarchy, punchout catalog setups, setting up content zone and stores.
• Patch analysis and Pre-requisites for one-off and rollup patches for oracle projects and iexpense
• Extensive work with Hyperion Essbase administration, User privileges, creating filters, tuning and optimization of cubes
• Resolved support issues for iprocurement approval testing and payable accounting process.
• Document existing functionality for iprocurement and HR for process improvements.
• Cutover Planning and Management
• Built and maintained detailed (450+ steps) MS Project technical/functional cutover plan used for production cutover and rehearsals
• Managed cross-team integration (including independent data warehouse/reporting group) throughout cutover process

Environment: R11i/R12- General Ledger, AP, AR, Fixed Asset, CE, Alerts, Order Management, Report Manager, iProcurement & iExpenses, Hyperion Essbase 9.x, Hyperion Planning 9.x

Confidential

Oracle EBS Functional Consultant

Responsibilities :

• Involved in implementation and testing of Oracle Applications Financial R12 GL, AP,FA and CM modules
• Involved in requirement gathering and analysis and design of the application.
• Worked with the client team to understand the current Business Process.
• Developed test plans and scripts and conducted testing for quality assurance.
• Configured GL, AP modules in R12 Environment.
• Worked on requirements gathering, gap mappings, and various functionalities in General Ledger.
• Working on Payables and Cash Management setups and issues.
• Determined business requirements for Asset summary by category report, Asset register report Customized Asset addition by cost summary report, Asset category report, Asset retirement report, Asset additions report, Annual additions report.
• Worked on Setting Instances for new acquisitions.
• Reviewed and refined the Common Apps setup steps shared across modules like Oracle SYSADMIN, GL, AR, AP, PO, INV, and PO (such as Set of Books, Currency (enabled), Locations, Organizations, Customers, Suppliers, Tax- Codes, Key and Descriptive Flex fields and UOM).
• Involved in implementation, migration and validation for Hyperion Essbase upgrade from V6.5.4.2 to V7.1.6
• Maintained Essbase databases using Planning application to meet financial requirements. Developed applications using Hyperion Financial Management (HFM) Suite for automation and reporting process.
• Working on post upgrade support and interacting with Business users on Issue resolutions.
• Fixed assets setting up of Asset Categories, Asset Keys, Locations, Fiscal Years, Book Controls, Calendars, Prorate Conventions, Depreciation Methods, Bonus rules, Ceilings and Security.
• Prepared Module design (MD050) Documents for Customizations.
• Implemented a major Enhancement “Journal entry creation for Cash management Entries” to perform reconciliation of Treasury entries which saves significant cost & Benefits the Customer to avoid manual intervention.
• Worked on Setting up and customizing dunning letter, statement cycle in Accounts Receivable module.
• Developed FSG Reports in GL like (Income statement, Dept Expenses, Inter Company Summary).
• Created custom responsibilities to which were attached specific menus, forms and reports for restricted user access.

Environment : Oracle Application R12, Oracle General Ledger, Oracle Payables, Oracle Receivables, Cash Management & Fixed Assets, Hyperion Essbase 7.1.6, Hyperion Financial reporting9.x, Hyperion Application Link

Confidential

Financial Functional Consultant

Responsibilities :

• Interacted with the Business users for understanding the Requirements and subsequently developed the functional design to meet the client requirement.
• Responsible for gathering Business Requirements (RD 020), Identifying Gaps & Fit Gap analysis (BR 010).
• Designed & implemented a Customization on “Refund process” (with the help of Technical team) to refund the amount to the Customer by cutting a check in AP.
• Implemented a major Enhancement “Journal entry creation for Cash management Entries” to perform reconciliation of Treasury entries which saves significant cost & Benefits the Customer to avoid manual intervention.
• Evaluating the Reports and testing them for the desired outputs after development as Per the Business requirements.
• Gathered requirement data, mapped data elements to Oracle functionalities, reviewed gaps, defined work-around solutions to proactively reflect company’s business future outlook. Used descriptive flex fields to cover additional data and to reference historical data during transaction processing.
• Used systems options, profile options, financial, payables, purchasing options to control data usage and integrity, to default list of values into forms and windows, and restrict access to functions when users were unauthorized to view or access data.
• Participated in Setting up Asset Key Flex fields, Asset Categories, Asset Locations, and Asset Calendar.
• Responsible for Baseline configurations for Accounts Payables, Accounts Receivables & Cash Management.
• Providing solution for Revenue Recognition for Pacific Bio Sciences orders in AR.
• Helping technical team develop a customized Revenue Recognition program in AR.
• Developed and executed test scripts and drove resolution of fixes to the system prior To User Acceptance Test.
• Responsible for end to end testing on Accounts Payables.
• Testing the entire process of Payables transfer to GL, AP Assets creation and mass Additions create through Payables.
• Performed hands on configuration setups for GL and AP, including budgets, multi-org & multi reporting currency.
• Participated in setting up of Multi-Org for managing multi-org setups.
• Set up of Desktop ADI and test the creation of Journals along with WEB ADI.
• Evaluating and adding account combinations so Account Generator runs smoothly for Depreciation run.
• Played significant role in system Integration testing.

Environment: R11- GL, AP, AR, FA, CE, IPPO, Project Accounting.