SUMMARY

• Certified Oracle Cloud Fusion cloud 2016 Certified Implementation Specialist (1Z0 - 327)
• Around 14 years of extensive experience in Oracle ERP including functional Analysis, development, implementation, production support and upgradation of Oracle Cloud ERP and EBS 11i/r12 SCM/Financials (GL, AP, AR, OM, PO, Procurement, Project Costing) EPM Suite (ePBCS)
• Part of multiple implementations of Oracle Cloud ERP and developed data conversions, reports and integrations using FBDI, OIC, Oracle Cloud ERP REST web services
• Part of Lawson to Oracle Cloud ERP migration and worked with users across GL, AP, AR, FA, CE, Procurement and migrated reports and developed custom reports using OTBI, BIP, FR Studio and Smart View reports
• Over 13 years of understanding both functional and technical experience across GL, AP, AR, FA, PO, Inventory and well versed with back-end tables, SQL, PLSQL and reports
• Automated FBDI data loading using OIC and build real time integration using Oracle Cloud ERP REST Api’s and OIC
• Leader of global cross-functional teams using open communication and flexible problem-solving approach. Effectively prioritized broad range of responsibilities to consistently meet tight deadlines and achieve performance objectives.
• Proven hands-on experience in development of customizations across P2P, O2C and Financials modules including reports, forms, OAF customizations, AME, workflow, interfaces, PLSQL API’s, Alerts and XML/BI Publisher reports
• Highly creative and innovative Oracle professional with advanced communication skills and abilities, who seeks and enjoys responsibility, a problem solver, experienced with multi-tasking and resolving complex problems.
• Managed key organizational IT initiatives, such as system performance enhancement, continuous improvement initiatives, and documentation.
• Expert in scoping, set-up, implementation and support of Oracle ERP (Oracle OM, Oracle Advanced Pricing, Oracle Purchasing, Oracle Inventory, Oracle Shipping, Oracle BOM, Oracle AR, Oracle Payables, General Ledger, Warehouse management, Oracle iProcurement, Oracle iSupplier and Advance Supply chain planning).
• Excellent skills in Functional Requirement analysis, Application Design, Gap Analysis, Module Setup and Production Support.
• Extensive experience in handling Functional & Technical responsibilities: -
• Functional: Requirements gathering, AS-IS Study, TO-BE processes, GAP analysis, application design & configuration, test script, System Integration Testing (SIT), CRP testing, writing training manuals, training end users and production support.
• Technical: Identify technical gaps, Development estimate chart, architecting system interfaces, designing custom solutions, leading development team, coding, Release rollout Plan and production support.
• Utilized Oracle’s Application Implementation Method (AIM) approach, and documented the processes using the recommend AIM documentation.
• Provide customer support for business-critical application problems and issues, Assist in testing and deployment of solutions in production environment. Proactively work through service requests with oracle SR’s as needed.

TECHNICAL SKILLS

Packages: Oracle Cloud ERP

Modules: Order Management (OM), Oracle Purchasing (PO), Oracle Inventory (INV), Account Receivables (AR), Spares Management (CSP), Application Object Library (AOL), Advanced supply chain planning (ASCP), iProcurement

Language Programming: SQL, PL/SQL, Shell scripting, JSF

MiddleWare Technologies: ADF, ADF Faces, ADF BC4J,SOA

Database: Oracle 11g

GUI: (Forms 6i&11g & Reports 6i&11g), JDeveloper 11g,OAF personalization

Tools: TOAD, SQL* LOADER, SQL* Plus, Oracle Forms Builder, Reports Builder.

Methodology: AIM (Application Implementation Methodology)

Others: Oracle XML Publisher, Functional Point counting, QTP(Automated testing Tool)

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Part of post go live support of Oracle Cloud ERP (Financials, SCM and PPM) and responsible for month end closing of sub ledgers and GL and documented brand new custom RICE objects and trouble shoot and fix day to day operational issues including performance issues of OTBI, BIP reports, add new login to existing reports, build brand new reports and integrations using OIC, BIP, FBDI and VBCS
• Developed various outbound BIP data files to share the supplier/customer master with down steam health care applications including health care procurement and accounting applications
• Helped users to resolve month end closing activity and GL and Sub Ledger reconciliation

Confidential, Indianapolis, IN

Oracle Cloud Techno-Functional consultant

Responsibilities:

• Prepared FBDI data conversion templates and loaded to Oracle cloud ERP across Financials and SCM/P2P modules
• Developed brand new integrations with Bank to send AP payment files, positive pay, AP checking printing using BKIP, XML/BIP templates
• Assisted users during UAT/SIT and production cut over planning and fixed functional and technical issues
• Worked with EPM(EPBCS) team and provided meta data of GL COA, Accounts and accounting calendar and build continue data flow
• Part of implementation of OAC and used BICC as an ETL tool and build BIP extracts
• Used OIC to automated file-based integrations and replaced with REST web services and on demand event-based integrations across AP, AR, PO and Inventory

Confidential

Oracle Cloud Techno-Functional consultant

Responsibilities:

• Prepared FBDI data conversion templates and loaded to Oracle cloud ERP across Financials and SCM/P2P modules
• Developed brand new integrations with Bank to send AP payment files, positive pay, AP checking printing using BKIP, XML/BIP templates
• Assisted users during UAT/SIT and production cut over planning and fixed functional and technical issues
• Worked with EPM(EPBCS) team and provided meta data of GL COA, Accounts and accounting calendar and build continue data flow
• Part of implementation of OAC and used BICC as an ETL tool and build BIP extracts
• Used OIC to automated file-based integrations and replaced with REST web services and on demand event based integrations across AP, AR, PO and Inventory

Confidential

Oracle Cloud Techno-Functional consultant

Responsibilities:

• Worked with business users and documented data conversion requirements, prepared FBDI/ADFDI templates, data mapping, development of data reconciliation reports using BIP across AP, AR, GL, PO and Inventory modules
• Part of CRP, UAT, SIT and production cut over planning and worked on fixing pre-go live tickets across reports and integrations
• Developed and implemented REST OIC web services for integrations with downstream applications across PO, Inventory and GL
• Explored OIC and automated end to end AP invoice loading on day-to-day basis from suppliers and down stream systems
• Build custom REST using BIP report to share supplier/customer master with downstream invoicing application
• Interacted with Business users for requirements, analysed the existing process Involved in Solution Design for different business requirement.
• Prepared Business Process Document, Setup Document, Functional Document, Technical Document and Unit Test Cases/Results based on AIM Methodology
• Development of software sales, Importing the orders related to sales orders from custom application SOM to OM
• Developed customizations across P2P, O2C and Financials modules including reports, forms, OAF customizations, AME, workflow, interfaces, PLSQL API’s, Alerts and XML/BI Publisher reports
• Worked on implementing drop ship process for waste liner items
• Supporting day to day issues related to the application from production
• Worked on setting up EDI transactions for drop ship process.
• Setting up the new procurement business unit for performing the purchasing transactions like Standard Purchase Order, BPA (Blanket purchase agreement) and receiving the parts

Environment: Oracle Applications R12- 12.1.3 - Oracle Order to Cash O2C, Oracle Procure to Pay P2P, Inventory (INV), PL/SQL, SQL Developer, Oracle Developer Suite (Forms & Reports)

Confidential, NY

Responsibilities:

• Worked on R12 upgradation of ASCP, Service Contracts, Install Base and post upgradation support of ASCP, SCM and financial modules
• Prepared R12 upgradation test plan, test cases and creation of test data and providing end user procedures and end user training
• Deliver the weekly status report of different applications that we support to all stake holders of the client.
• We are also involved in doing enhancements which are value addition to the day-2-day business operations.
• SLA reporting, ticket handling, Quality assurance, monitoring of scheduled jobs, Customer interaction and coordination for various issues
• Responsible for converting the orders from legacy system to ERP using theOpen Interfaceto import data fromOMinterface tables into the base tables.
• Developed Conversion program to importVendor/SupplierInformation into Purchasing by loading data into staging tables from legacy system, validating data using PL/SQL API and then loading the data into Vendor Information Base tables.
• Month end coordination with business Team for Period closing and Pending Transactions Handling.
• Member of a release management board, which involves the code review and performing impact analysis of the code changes so that support will go smoothly
• Performed physical inventory and cycle counting of items in the warehouses
• Co-ordinate with business team for testing the codes that are modified for day to day issues
• Developed code for performing WIP job completion, which is interface from QAS system

Environment: Oracle E-Business Suite 11i/R12(12.1.3) Distribution/Financial (OM, PO, INV, CSP, AOL, ASCP), Oracle Database 11g/10g/9i, Oracle XML Publisher 10g, Developer Suite 10g/6i, Solaris 10, Toad, SQL*Plus, WebLogic 11g, SQL*Loader

Confidential

Techno-Functional consultant

Responsibilities:

• Prepared the MD050, MD070
• Prepared the Inspection log for Design Spec
• Coordinated with business and prepared the necessary setup documents for different countries deployment of ES project and performed the setups in development environments testing the setups and moved them to different testing environments for business testing.
• Involved in the data conversion of sales orders and item conversion
• Developed a program for assigning of items from one organization to other organizations
• Designed and developed various interfaces like user fetching the data for identifying the open orders for him and quantity need to be received. After fetching the necessary data perform the receipts
• Designed and developed average on hand cost conversion program
• Designed and Developed the EDI Transactions required for NCR and Third-party logistics who maintains the NCR Sub inventory in APAC region.
• Designed and developed various outbound interfaces for sending data to EDW for reporting purposes for P2P and O2C cycles
• Designed and developed program for enabling an organization from locator controlled to non-locator controlled sub inventories.
• Involved in Performance Testing of the ES Project using OATS tool
• Supported the business testing in various phases of testing CIT, SAT

Environment: Oracle E-Business Suite R12.1.3 Distribution/Financial (Service Contracts, Install Base, OM, PO, INV, CSP, AOL), Oracle Database 11g/10g/9i, Oracle XML Publisher 10g, Developer Suite 10g/6i, Solaris 10, Toad, SQL*Plus, SQL*Loader

Confidential

Techno-Functional consultant

Responsibilities:

• Prepared the F-spec and D-spec for different requirements
• Prepared the Inspection log for Design Spec
• Designed and Developed the conversions required for creating the Customer Engineer Addresses, Sub inventories, On hand and Average cost of items
• Designed and Developed the EDI Transactions required for NCR and Third party logistics who maintains the NCR Sub inventory in APAC region.
• Coordinated with business and prepared the necessary setup documents for different countries deployment of ES project and performed the setups in development environments testing the setups and moved them to different testing environments for business testing.
• Designed and Developed the EDI Transactions required for NCR and Third party logistics who maintains the NCR Sub inventory in APAC region.
• Involved in Performance Testing of the ES Project using OATS tool
• Designed and developed the Inventory onhand discrepancy report and Inventory adjustment forms between Third Party and NCR
• Performed setups required for cycle count, like ABC classification setups, item organization assignments.
• Travelled to Honkong for providing KT to business users along with Business Analysts
• Supported the business testing in various phases of testing CIT,SAT and UAT
• Active Member of Go live war room and supported the go live issues for smooth deployment

Environment: Oracle E-Business Suite R12.1.3 Distribution/Financial ( OM, PO, INV, CSP, AOL), Oracle Database 11g/10g/9i, Oracle XML Publisher 10g, Developer Suite 10g/6i, Solaris 10, Toad, SQL*Plus, SQL*Loader)

Confidential

Techno-Functional consultant

Responsibilities:

• Done the Up-gradation of oracle application from 11i to R12.
• Worked with API’s and interfaces.
• Some of the tables are obsoleted in R12. So created views with same name to execute the existing custom code without any issue
• Development of new PL/SQL programs for O2C cycle
• Involved in upgradation of MOVE interface, which actual perform the inventory transactions
• Ex: working on orders stuck in interface; working on flow of data from Oracle to Data warehouse; trouble shooting Unix Job failures, Developed scripts to send the data from Oracle to EDW using xmlgen process which is used for reporting purposes
• Performing Function Point counts for Projects/Releases
• Performed Unit, SAT, CIT and UAT Tests
• Active Member of Go live war room and supported the go live issues for smooth deployment

Environment: Oracle E-Business Suite R12.1.3 Distribution/Financial ( OM, PO, INV, CSP, AOL, AP, AR), Oracle Database 11g/10g/9i, Oracle XML Publisher 10g, Developer Suite 10g/6i, Solaris 10, Toad, SQL*Plus, SQL*Loader)

Confidential

Oracle Apps Developer

Responsibilities:

• Involved mainly in the implementation and customization of the tasks related to the Oracle Purchase Order module.
• Reports have been developed to furnish information as required by the client for reporting and generated customized reports using Reports Builder.
• Worked with Form builder to modify and create the forms, record groups, libraries, menus and giving access to them by using maintain security.
• Customized PO forms according to the client specs like adding check boxes, radio buttons, disabling certain fields.
• Worked with PL/SQL for hide/unhide the fields, set the default values, data validations and implementation as business rules.
• Query Tuning to run reports/scripts faster

Environment: Oracle Applications 11i (OM, INV, PO, AOL), PL/SQL, Developer 2000, TOAD and HP-UX.

Confidential

Oracle Apps Developer

Responsibilities:

• Extensively Worked in Oracle Applications Standard Reports Customization
• Worked with Form builder to modify and create the forms, record groups, libraries, menus and giving access to them by using maintain security.
• Customized forms according to the client specs like adding check boxes, radio buttons, disabling certain fields.
• I worked with PL/SQL for hide/unhide the fields, set the default values, data validations and implementation as business rules.
• Developed Packages and Procedures and Functions to convert the Legacy data to new Oracle System
• Developed PL/SQL programs using UTL FILE package to generate output files.
• Worked with the designing of inbound and outbound interfaces like move the data from flat files to Oracle Applications tables and make the data from Oracle Applications tables to flat files with the combination of PL/SQL and SQL*Loader.

Environment: Oracle Applications 11i (OM, INV, PO, AOL), PL/SQL, Developer 2000, TOAD and HP-UX.

Confidential

Oracle Developer

Responsibilities:

• Played a major role to develop custom screens in the Forms 6i
• Developing various reports as per customer requirements.
• Developing backend Procedures, Functions, Triggers etc.