SUMMARY

• Overall 9+ 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, iSupplier 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, Oracle Fusion SCM and Cloud Procurement.
• Worked as a Scrum master for the Receivables functional team.
• 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, FixedAssets, 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) and Cloud Procurement

Oracle EBS: Order Management (OM), Oracle Shipping (WSH), Bill of Materials (BOM), Oracle Process Manufacturing (OPM), Oracle Purchasing (PO),iSupplier, 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(Version 11i, R12 (12.0.4, 12.1.3,12.2.4)

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.

PROFESSIONAL EXPERIENCE

Confidential, Louisville, KY

Senior Oracle Apps Techno-Functional Consultant

Responsibilities:

• Gap Analysis and Resolution. Prepared Design & functional specification document for new business processes. Mapped business process with the oracle modules.
• Worked on building a custom supplier portal to overcome the limitations of the existing system which is integrated with oracle iSupplier portal.
• Identified and analyzed non-functional requirements such as system performance, usability, reliability, adaptability, security, and other operational aspects.
• Worked on Vendor sourcing rules, Blanket Purchase Agreements, Purchase Order Release methods in Oracle Purchasing
• Worked on assessing the supplier risks in supplier risk management.
• Identifying the functional specs, preparing the documentation setups and maintaining Business Requirement Documents, Setup Documents (BR100) and other design documents as MD020 and MD060.
• Extensively worked with Oracle Metalink on a few SRs (TARs) to fix the issues in Oracle Supply chain management, Financials, Manufacturing areas.
• Worked on EDI Mapping for Order Import Data, Invoice Data in AR, Purchase Order data.
• Extensively worked on troubleshooting, fixing the issues on Internal requisition, Approved Supplier list, Request for Quotes in Oracle Purchasing
• Troubleshooting and fixing the PO Approval issues, Stuck Purchase Orders from the Workflow utilizing the standard scripts from Oracle
• Worked on SQL, PL/SQL,OracleReports, EBS Integration (XML, XSD and Integrated SOA Gateway) technologies.
• Worked on EDI inbound and outbound interfaces like 850,855 and 865.
• Worked on various integrations mapping like EBO and DDT.
• Worked on PO outbound and ASN outbound integrations which is integrated with SOA and AWS.
• Involved in consignment process by creating IR-ISO cycle.
• Extensively worked on 3rd party logistics systems like Derby and Roper.

Environment: Oracle Applications R12 (OM, INV, PO, iSupplier, BOM and WIP), PL/SQL, Oracle Developer 10g, XML/BI Publisher, Workflow, Jira, Sharepoint, UNIX.

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 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.
• Implemented 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.
• Configured entire fusion financials accounting configurations, Ledgers, Legal Entities, Currency, Chart ofaccounts, Accounting Hierarchies, created and modified Trees and Tree versions, Allocation rules.
• Worked on uploading the values/journals using ADFDI & FBDI.
• Implemented oracle transactional business intelligence (OTBI), worked on multiple subject areas, various BI
• Involved in month end and year end activities.
• 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 me-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.

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.
• Setup & Configuration of Oracle Cloud Financials - Fusion General Ledger, Fusion Payables, Fusion Receivables
• Experience in Transactional BI for Cloud Financials.
• Mapping the requirements gatheird 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
• Performed loading conversion data using external data integration functionality by populating spreadsheettemplates, loaded suppliers, payables invoices, journals, budgets, cash management external transactionsCOA values and hierarchy, code combinations etc. Worked on rapid implementation model.
• Worked on privileges and fusion security features, strong understanding of Oracle enterprise repository (OER)to access various fusion templates and processes. Worked on financial reporting center and enterprise performance manager (EPM), access to calculation manager, FRS and smart view installation.
• FBDI and ADFDI for Suppliers, AP Invoices, Customers, AR Invoices, AR Receipts.
• Involved in month end and year end activities.
• Functional flow: iProcurement flow including Punch out, Capitalized Assets, Mass Additions, Catalog Bulk load and approval hierarchy
• Involved in Design Reviews, Code Reviews, Coding, and Testing usingAIMmethodology throughout the project.
• Worked onItem Conversionin theINVModule.
• 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 theanalysisof the assignedsupportticketsincluding 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 ofissueresolution.
• Developed variousCustom reports, Customized existing reports according to the functional specifications usingReports 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 Fusion SCM (INV, OM, PO) 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.

Sr. 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 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, me Supplier) PL/SQL, SQL, Reports, XML/BI Publisher, Workflow Builder, PVCS, Kintana, DB2, Sybase and UNIX.