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 wif 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 noledge of Oracle Fusion Financials, Oracle Fusion SCM and Cloud Procurement.
• Worked as a Scrum master for teh 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 teh 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 wif various other systems.
• Expertise in complete Life Cycle Development of implementation & upgradation of Oracle Applications.
• Strong noledge 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 teh 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 wif, 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 wif 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) wif 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

Sr. Oracle Techno-Functional Consultant

Responsibilities:

• Gap Analysis and Resolution. Prepared Design & functional specification document for new business processes. Mapped business process wif teh oracle modules.
• Worked on building a custom supplier portal to overcome teh limitations of teh existing system which is integrated wif 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 teh supplier risks in supplier risk management.
• Identifying teh functional specs, preparing teh documentation setups and maintaining Business Requirement Documents, Setup Documents (BR100) and other design documents as MD020 and MD060.
• Extensively worked wif Oracle Metalink on a few SRs (TARs) to fix teh 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 teh issues on Internal requisition, Approved Supplier list, Request for Quotes in Oracle Purchasing
• Troubleshooting and fixing teh PO Approval issues, Stuck Purchase Orders from teh Workflow utilizing teh 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 wif 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 wif 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 teh 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 teh 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 teh first FAADMIN login and IT security roles in Oracle Identity Manager Application, worked wif business users and gave on teh oracle fusion applications.
• As part of teh implementation, set up various tools such as teh 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 teh 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 wif 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 wif QA team and coordinated user participation in final testing phases.
• Developed test plans, executes scripts, and looks for any failures in teh 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 wif OM, INV, WSH, AR, GL modules.
• Also ensures compliance by steering teh project for milestone completion wifin specified time wif quality & functionality.
• Setup & Configuration of Oracle Cloud Financials - Fusion General Ledger, Fusion Payables, Fusion Receivables
• Experience in Transactional BI for Cloud Financials.
• Mapping teh requirements gathered in teh application wif teh standard functionalities.
• Configuration of stage and prod environment and executed teh 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 teh 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 teh 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 teh business requirements and done forms personalization in teh same requirement.
• Customized teh Sub Ledger Accounting Events, Journal Entry Lines and supplier entry Pages using OAF.
• Involved in theanalysisof teh assignedsupportticketsincluding replicating teh issue, analyzing teh custom processes, API’s, reports, forms and updating teh ticket wif teh appropriate information.
• Imported Bills and Routings through BOM Interfaces.
• Implementation of Oracle Advanced Pricing for calculating teh final price of products based on modifiers, qualifiers and pricing formulas, according to teh customer’s business rules.
• Work on teh development activities as part ofissueresolution.
• Developed variousCustom reports, Customized existing reports according to teh functional specifications usingReports 10g and XML publisher.
• Integrated SFDC customer registration wif Oracle AR customers where we have created teh invoices for teh 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 teh project, they have to migrate existing and few new reports that are related to Cognos.
• Coordinated wif teh business users to collect requirements.
• Developed queries to meet teh requirements as per functional specification, prepared teh test cases, and made sure we got teh sign off for all teh 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 wif 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 teh developed control file to an outbound/archive directory
• Customized existing reports for additional functionality (Parameters, sorting, calculations, and conditions) using XML Publisher.
• Worked wif Oracle to improve performance of Standard Invoice Validation and fine-tuned existing Materialized Views either replaced MV’s wif normal view logic or tuned teh existing queries.
• Customized a 4-bucket aging report. Aging reports are usually wif respect to teh 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 teh end user. Involved in taking backups and exports, FTP in UNIX environment
• Design of teh solution, including teh final price engine implemented in Oracle Advanced Pricing.
• Developed Reports to extract teh monthly sales information
• Developed custom reports and added columns in teh existing reports according to teh requirement
• Proficient in preparation of teh functional design documents MD50s and technical design documents MD70s and process maps.
• Prepared requirement specification document that gives teh comprehensive details about teh 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 teh data and working closely wif business for data validation after upgradation.
• Analyze and provide teh gaps between teh existing processes of Williams wif 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 wif Business Process Users during teh 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 wif teh 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 acnoledge 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 teh SQL loader program that transfers data in data file to staging table and runs teh 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 teh complete life cycle of Order to Cash (O2C).
• Converted several reports in OM using XML/BI Publisher.
• Involved in converting teh legacy system data into Oracle Applications e business suite target modules like OM, PO, INV as per teh customer requirements.
• Documented functional features and behavior of required customizations using AIM methodology.
• Customized standard reports and created new reports as per teh business requirements, using Oracle Reports.
• Prepared conversion documents CV 040 and CV 060.
• Trained end users on teh 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 teh PL/SQL packages, Discoverer Reports, Oracle Reports, Forms, XML/BI Publisher Reports as well as teh associated PL/SQL programs, Shell scripts and DB objects.
• Development of XML/BI Publisher Reports as well as teh 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 teh technical design documents for teh components developed.
• Performed GAP analysis to ensure that teh requirements are captured properly.
• Involved in teh Personalization of teh custom international budget form to fit teh US requirements.
• Created custom Shell scripts to handle teh loading teh data file into teh custom tables and archiving of teh data file.
• Worked as a Member of teh 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.