PROFESSIONAL SUMMARY:

• Overall 8+ years of experience in design development, setup, support, Customization and testing in Oracle Fusion Financials, SCM and Oracle Applications E - Business Suite Release (R12, 11i) implementation.
• Outstanding Functional/Technical Knowledge in Oracle Applications with Distribution/Supply Chain Modules like (OM-Order Management, INV-Inventory, PO-Purchasing and iProcurement) financial modules like (GL-General Ledger, AP-Oracle Payables, AR-Oracle Receivables CE- Cash Management, Manufacturing Modules such as (BOM-Bill of Materials, WIP-Work in Progress) and CRM modules like Service Contracts and Install Base in Fusion, Release 12 and 11i.
• Hands-on working knowledge of Oracle Fusion Financials and Fusion Accounting Hub (FAH).
• Worked on Various Technical and Functional Documents using AIM (Application Implementation and Methodology).
• Good understanding of Agile methodology by creating and defining the user stories.
• Core competency lies in client facing roles, across sectors in and around areas related to Oracle financials (Release 12, 11i & Fusion) and integration of EBS system with various other systems.
• Expertise in complete Life Cycle Development of implementation & upgradation of Oracle Applications.
• Strong knowledge in sub-ledger flows: Order to Cash (O2C) and Procure to Pay (P2P) processes
• Very Good Understanding of Multi Org and TCA (Trading Community Architecture) concepts.
• 3+ years of experience in Development, Personalization and Extension of self-service pages using OA Framework (OAF).
• Experience in Tuning SQL statements to improve execution performance using TKPROF, SQL Trace, etc.
• Experience in designing and developing reports using XML/BI Publisher
• Excellent development skills in RICE components (Reports, Interfaces, Conversions and Form Personalization) in the domain of Oracle E-Business Suite Essentials
• Expertise in Design and development of interface and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader, UTL File etc.,
• Strong coding experience in PL/SQL development using Packages, Procedures, Stored Procedures with, Functions, Triggers and UNIX Shell Scripting
• Experience in registering Concurrent Programs, Form Functions, Reports, Applications, Creating Users and Defining Profile values by using Application Object Library (AOL), System Administration
• Strong ability to manage project tasks with changing priorities and tight deadlines
• Good Interpersonal, Reporting, trouble shooting and Communication skills.

TECHNICAL SKILLS:

Oracle Fusion Fusion Financial Offerings: General Ledger, Accounts Payable, Accounts Receivables, Fixed Assets, Cash Management (Version 11g Release9) with OTBI, Smart View, Financial Reporting Studio reports (FRS), ADFDI & FBDI integrations and Fusion Accounting Hub (FAH). Fusion SCM Offerings Inventory & Product Management, Purchasing, Cost Management, Order Management/ Order orchestration. (Version 11g Release9).

Oracle EBS: Order Management (OM), Oracle Shipping (WSH), Bill of Materials (BOM), Oracle Process Manufacturing (OPM),Oracle Purchasing (PO), Field Services(CSF), Depot repair(CSD) Work in Process (WIP), Oracle Inventory (INV), Oracle Payables (AP), Oracle Receivables (AR), General Ledger (GL), Oracle Sub-Ledger Accounting(SLA), Oracle e-business tax

Programming Languages: PL/SQL, Java, Shell scripting, HTML, CSS

Tools: EDI, XML/BI Publisher, Oracle Developer 10g, OA Framework, Workflow Builder, SQL * Loader, SVN, PVCS, Kintana.

WORK EXPERIENCE:

Confidential, Needham, MA

Sr. Oracle Apps Techno-Functional Consultant

Responsibilities:

• Collaborated with business partners and cross-functional teams supporting financial systems.
• Participated in Team Projects and helped to create & define stories to follow agile methodology.
• Served as the primary point person accountable for execution of each stakeholder’s strategic imperatives involving technology.
• Supported Worldwide Finance groups during quarter end by monitoring system, resolving issues, and instructing users.
• Involved in understanding of contemporary requirements elicitation, analysis, specification & verification.
• Translated business requirements into solutions that map to technology capabilities.
• Understanding salesforce customer registration and interfaced the data from SFDC to oracle AR customers.
• Good understanding of data from various business applications like Salesforce, Zuora, Z-quote and CPQ.
• Implemented fusion financials on cloud basis offering, starting from the first FAADMIN login and IT security roles in Oracle Identity Manager Application, worked with business users and gave training on the oracle fusion applications.
• As part of the implementation, set up various tools such as the ADF desktop integrator, Financial Reporting Studio (FRS), Smart view.
• Oracle identity manager to create and maintain user accounts, LDAP and sync processes, Roles and Authorization Policy Manager (APM), created custom Job roles, duty roles and data roles.
• I mplemented multiple balancing segment features, fusion offer 3 balancing segments, implemented inter-company functionality at various levels, Primary balancing level, COA level, legal entity level, Ledger Level.
• Worked on Fusion Accounting hub(FAH), configured FAH to integrate with SLA and non-Oracle applications
• Analyzed, designed and developed the Item Cross Reference conversion program for importing data from legacy systems into Oracle.
• Communicating with client /onsite functional personal on business requirements.
• AP Aging report - Customized standard report to meet client requirement.
• For inventory type requisitions, extended controller to enable Charge Account in I-Procurement edit lines page(OAF)
• Developed Separate Remittance configuration for Vendors and Individual contractors.
• Developed Zero-dollar payment Report in BI Publisher.
• Retrofitted Purchase order print Form
• Created Periodic Alerts for AP Invoice Custom Validation program and Payable Open interface programs when invoice got struck.
• Defined test cases with QA team and coordinated user participation in final testing phases.
• Developed test plans, executes scripts, and looks for any failures in the scenarios in our financial systems.

Environment: Oracle Fusion Financials (GL, AP, AR, CM, FA), Oracle Applications R12 (GL, AP, AR, CE, OM, INV), PL/SQL, Oracle Developer 10g, XML/BI Publisher, Workflow, OA Framework, Tortoise SVN, UNIX.

Confidential, Redwood City, CA

Sr. Oracle Apps Techno-Functional Consultant

Responsibilities:

• Understanding Confidential ’s technical requirements for implementation of Oracle ERP.
• Involved in O2C business flow cycle with OM, INV, WSH, AR, GL modules.
• Also ensures compliance by steering the project for milestone completion within specified time with quality & functionality.
• Financial Track lead for implementation of Oracle Fusion financial offerings like General Ledger, Accounts Payables, Oracle Receivables, Fixed Assets.
• Mapping the requirements gathered in the application with the standard functionalities.
• Configuration of stage and prod environment and executed the End-To-End testing.
• Worked on FBDI to upload account values and value hierarchies.
• Used ADFDI spreadsheets to upload open Invoices.
• Developed few real time reports from the subject area of OTBI
• Worked on Fusion Accounting Hub (FAH) to consolidate the accounting transactions from third party legacy applications, Oracle EBS. Implemented the integration process of Fusion Accounting Hub with Hyperion for financial analysis and reporting purpose.
• Involved in Design Reviews, Code Reviews, Coding, and Testing using AIM methodology throughout the project.
• Worked on Item Conversion in the INV Module.
• Involved in conversion process right from design, pre-conversion/data-cleansing, reconciliation of converted data to deployment of conversion packages onto go-live sites.
• Worked in customization of workflow in service requests in both automatic and manual process.
• Worked in customization of sales order and quote form as per the business requirements and done forms personalization in the same requirement.
• Customized the Sub Ledger Accounting Events, Journal Entry Lines and supplier entry Pages using OAF.
• Involved in the analysis of the assigned support tickets including replicating the issue, analyzing the custom processes, API’s, reports, forms and updating the ticket with the appropriate information.
• Imported Bills and Routings through BOM Interfaces.
• Implementation of Oracle Advanced Pricing for calculating the final price of products based on modifiers, qualifiers and pricing formulas, according to the customer’s business rules.
• Work on the development activities as part of issue resolution.
• Developed various Custom reports, Customized existing reports according to the functional specifications using Reports 10g and XML publisher.
• Integrated SFDC customer registration with Oracle AR customers where we have created the invoices for the customers in AR.

Environment: Oracle Fusion Financials (GL, AP, AR, CM, FA), Oracle Applications 12.1.3 (GL, AP, AR, OM, INV, WSH, PO BOM, QP, CSF, CSD, WIP, Service Requests), PL/SQL, Developer 10g, XML/BI Publisher, OA Framework, Workflow, SVN, UNIX.

Confidential, Plainsboro, NJ

Senior Oracle Apps Techno-Functional Consultant

Responsibilities:

• Integra recently upgraded its software from Oracle 11.5.10 to Oracle 12.1.3. As a part of the project, they have to migrate existing and few new reports that are related to Cognos.
• Coordinated with the business users to collect requirements.
• Developed queries to meet the requirements as per functional specification, prepared the test cases, and made sure we got the sign off for all the reports before SIT.
• Worked on customer conversions. Developed Customer Interface to transfer and validate Customer data from legacy system into AR. Created procedures and SQL*Loader Scripts to populate Customer interface tables with data such as Customer Profiles, Phone Contacts at various levels, Payment Method data & Customer Bank data.
• Developed a move shell program in order to move the developed control file to an outbound/archive directory
• Customized existing reports for additional functionality (Parameters, sorting, calculations, and conditions) using XML Publisher.
• Worked with Oracle to improve performance of Standard Invoice Validation and fine-tuned existing Materialized Views either replaced MV’s with normal view logic or tuned the existing queries.
• Customized a 4-bucket aging report. Aging reports are usually with respect to the receivables that are not paid.
• Experience in Creating Users, Responsibilities, Request Sets, Request Groups, Profile Options and registering Executables, Concurrent Programs, Form Functions, Reports by using Application Object Library (AOL), System Administration.
• Created Materialized Views to reduce query run time for the end user. Involved in taking backups and exports, FTP in UNIX environment
• Design of the solution, including the final price engine implemented in Oracle Advanced Pricing.
• Developed Reports to extract the monthly sales information
• Developed custom reports and added columns in the existing reports according to the requirement
• Proficient in preparation of the functional design documents MD50s and technical design documents MD70s and process maps.
• Prepared requirement specification document that gives the comprehensive details about the requirements.

Environment: Oracle Applications 11.5.10.2, 12.1.3 (OM, INV, WSH, PO, BOM, WIP, QP, AR, AP, GL), PL/SQL, TOAD, XML/BI Publisher, Oracle Developer 10g, AOL, UNIX

Confidential, Tulsa, OK

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Understanding Williams’s technical requirements for AP and PO modules for upgradation of P2P cycle.
• Worked on Proof of Concept (POC) for Oracle’s monthly change management process.
• Worked on creating technical migration documents for auditing purposes.
• Involved in tickets assignment, problem analysis, development and bug fixes, unit testing, User Acceptance Testing (UAT), support and deployment.
• Developed and customized Oracle seeded forms and reports as well as created several custom objects including forms, reports, interfaces, custom APIs.
• Worked across modules like General Ledger, Sub Leger Accounting, Account Receivables, Account Payables, Purchasing and Inventory.
• Performed critical pre and post upgradation steps like running AP, PO reports, analyzing the data and working closely with business for data validation after upgradation.
• Analyze and provide the gaps between the existing processes of Williams with that of Oracle E-Business Suite
• Extensively worked on Multi Organization structure, MRC (Multiple Reporting Currencies), MOAC (Multi Org Access Control), TCA (Trading Community Architecture).
• Created Oracle Business Areas and Workbooks using Discoverer.
• Interacted with Business Process Users during the Requirement Specification and Analysis phase. Documented various functional features and specifications using AIM methodology (MD 050, MD 070 and CV 060).

Environment: Oracle Applications 11.5.10, 12.1.3 (PO, AR, AP, GL and SLA), TOAD, Oracle 10g, SQL*Plus, PL/SQL, Reports 6i, XML Publisher, Workflow Builder, SVN, WINDOWS XP.

Confidential, St. Louis, MO

Oracle Apps Techno-Functional Consultant

Responsibilities:

• As a Techno Functional consultant responsible for creating multiple conversions to support client's migration from a legacy system to Oracle ERP suite of applications including WIP, BOM, Purchasing, Inventory, and Order Management.
• Played a key role in EDI transactions like Inbound and outbound purchase orders with the transaction codes like 850,855 and 865.
• Defined setups in PO module for EDI implementation.
• Worked on reports like item cross reference reports and sales order acknowledge report and various reports in OM, INV, and PO modules
• Developed Work Order Interface to import discrete job information into oracle apps base tables.
• Created Shell script program to call the SQL loader program that transfers data in data file to staging table and runs the custom concurrent program to transfer data from staging table to interface tables.
• Created and customized reports using XML/BI Publisher in OM, BOM, PO, AP, AR, WIP and INV modules.
• Customized several Forms using CUSTOM.pll

Environment: Oracle Applications 11.5.10, 12.1.3 (PO, INV, OM, WIP, BOM, EB-tax), Vertex Oracle 10g, PL/SQL, Oracle Developer 10g, Workflow Builder, SQL*Loader, PVCS, Kintana and UNIX.

Confidential, Houston, TX

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Involved in implementation of the complete life cycle of Order to Cash (O2C).
• Converted several reports in OM using XML/BI Publisher.
• Involved in converting the legacy system data into Oracle Applications e business suite target modules like OM, PO, INV as per the customer requirements.
• Documented functional features and behavior of required customizations using AIM methodology.
• Customized standard reports and created new reports as per the business requirements, using Oracle Reports.
• Prepared conversion documents CV 040 and CV 060.
• Trained end users on the functionality of Order to Cash modules.

Environment: Oracle Applications 12.0.4 (PO, OM, INV, WIP and BOM), TOAD, Oracle 10g, PL/SQL, SQL*Loader, Oracle Developer 10g, XML/BI Publisher, Workflow Builder, UNIX

Confidential, Houston, TX

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Actively involved in retro fitment of the PL/SQL packages, Discoverer Reports, Oracle Reports, Forms, XML/BI Publisher Reports as well as the associated PL/SQL programs, Shell scripts and DB objects.
• Development of XML/BI Publisher Reports as well as the associated PL/SQL programs and Oracle reports.
• Conversion of Discoverer Reports to BI/XML reports.
• Development of Outbound Interface Programs and Mailer Programs in Order Management.
• Development of Reports in Different Modules like Account Payable/ Account Receivable / Oracle Projects/ Order Management/Oracle Sales/ Oracle HRMS.
• Created the technical design documents for the components developed.
• Performed GAP analysis to ensure that the requirements are captured properly.
• Involved in the Personalization of the custom international budget form to fit the US requirements.
• Created custom Shell scripts to handle the loading the data file into the custom tables and archiving of the data file.
• Worked as a Member of the Production support system to address day-to-day issues.

Environment: Oracle Applications 11.5.10.2, 12.0.4 (PO, INV, OM, AP, AR, GL, I Supplier) PL/SQL, SQL, Reports, XML/BI Publisher, Workflow Builder, PVCS, Kintana, DB2, Sybase and UNIX.