SUMMARY

• Over 12 years of experience as an Oracle Apps Technical Consultant/Oracle Apps Senior Lead Technical Consultant/Oracle Techno - Functional consultant in identifying and clearly understanding requirements provided, estimating work, design custom components, development, customization, testing and documentation, post implementation maintenance, end-user training and providing production support of Oracle Applications from 11.0.3 to 12.2.4 version.
• Experienced in Implementation of Order to Cash Process (O2C), Procure to Pay (P2P), Financials (AP, AR, GL, FA and FAH modules) and CRM modules.
• Extensively worked on RICEW Reports, Interfaces, Conversions, Extensions, Workflow, OAF (Jdeveloper) and Java Based Web-Services components.
• Experienced in implementation of Oracle Financials Accounting Hub (FAH) to integrate 3rd party financials data to Oracle EBS.
• Experienced in Data Conversion, Interfaces, Extensions, Customization and new development in Oracle Application including Oracle General Ledger, Oracle Payables, Oracle Receivables, Cash Management,, Purchasing, Order Management, Shipping, Advanced Pricing, Inventory, Bill of Materials, Work in Process, CRM Foundation, Install Base, Service Contracts, Quoting, EBIZ Tax, Sub ledger Accounting, iStore, iReceivables and iExpense.
• Expertise in preparing AIM (Application Implementation Methodology) Documents and User Manuals Functional Specification Document (MD050), Technical Design Document (MD070/CV060) and Conversion Mapping Document (CV040).
• Good working experience with Agile methodology and also Certified Scrum Master.
• Expertise in AOL, System Administration, XML/BI Publisher, Workflow, Alerts, Discoverer, Oracle Forms, Reports, Web ADI, Business Events, Java, Integrated SOA Gateway, OA Framework, BPEL and Trading Community Architecture (TCA).
• Extensive experience in Oracle backend objects like Database Triggers, Stored Procedures, Functions, and Packages using PL/SQL.
• Expertise in developing database applications using Oracle with Developer 2000 (Forms 6i, Reports 6i), Oracle Application Framework (OAF), Web Applications using Java, Servlets, JSP, XML and other web programming tools.
• Good Exposure to different source control tools such as VSS, PVCS, GitHub, SVN.
• Working experience with deployment tools such as Kintana, Stat and custom developed deployment tool.
• Experience in Oracle Applications R12 features, and architecture.
• Having strong Business and Analytical skills.

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Senior Oracle EBS Tech

Responsibilities:

• Designed Interfaces from non-oracle website reservations - FAH to Oracle GL for transactional reservations and subscriptions model. Designed the Events Model by interacting with the accounting users and configured the Account Derivation rules, Mapping sets, Journal line types.
• Conceptualized, designed and developed real time integration of customer data into Oracle by exposing REST based web services using Integrated SOA gateway framework.
• Designed and developed a custom WebADI to upload the bank statements used in custom 3-Way match cash matching solution
• Customized and extended the i-Receivables OAF screens, and extended the layouts using Bill Presentment Architecture (BPA)
• Developed custom AR invoice templates using XML publisher that supports multiple European languages
• Architecture, designed and developed OLAP cubes by interfacing data to SQL server using SQL Server Integration services and SQL Server analytical services
• Designed a custom 3-way cash match solution between Traveler reservations, merchant records(eCP) and bank statements.
• Designed custom dashboards using Tableau to provide visibility of transactions, accounting, SSAS cubes and General Ledger
• Created a custom Java app to scramble data in custom FAH tables. This is as part of EU GDPR (General Data Protection Regulation) initiative
• Resolved critical Month end close issues between sub ledgers and General Ledger. Also streamlined the Business process to accommodate recurring issues.
• Extensive hands on experience on Zuora application - Cloud based solution for subscription billing application.
• Designed and developed reports using XML Publisher.
• Provided assistance and training for business users

Environment: Oracle APPS R12 (12.1.3), SSIS, SSAS, CI/CD, Jenkins, GitHub, Tableau, TortoiseSVN, Dell STAT, AP,AR, GL, FA, Financial Accounting Hub(FAH), OAF (JDeveloper).

Confidential, Temple, TX

Lead Oracle Applications

Responsibilities:

• Designed and developed Interfaces from non-oracle applications (Sales Orders, AP, AR, FA, Payroll data) via FAH to Oracle GL by defining Sub ledger Accounting setups using Accounting Method Builder: Event Model, JLT’s, JED’s, Sources, Application Accounting Definition, Mapping Sets, Sub ledger Lookups based on Business Requirements. Achieved business complex accounting rules via Account Derivation Rules.
• Designed and developed custom accounting event programs and custom accounting summarization programs for reconciling the journal entries on regular basis.
• I was part of multiple AR implementation projects for 3 business units. Involved inCustomer Conversionsto load Customer details into HZ tables by creating staging tables and performing validations and finally loading them in to base tables usingTCA APIs
• Designed and developed programs to interface AR receipts using Auto Lockbox functionality. Also developed pre-draft solutions for auto draft customers. Played major role in implementing i-Receivables by customizing and extending OAF screens. Developed claim settlement jobs to settle the over payments, deductions during receipt applications
• Used Data Templates, Bursting features in BI Publisher to generate custom AR statement reports, Lockbox transmission details, and Auto Invoice transmission details.
• Developed custom WEBADI templates to upload custom data entries
• Designed, developed custom business events to generate the AR payments extracts on near real time basis
• Designed the data warehouse solution for customer outstanding payments information to be consumed by custom online applications.
• Designed AR online invoicing reports using Bill presentment architecture
• I was part of implementation team for Oracle Payables and payments modules. Designed and developed supplier conversion and customizing the check format
• Worked closely with Control-M scheduling team to schedule the jobs using file watchers and on-completion on dependent jobs
• Deployed technical components using STAT application.
• Published AIM documentation on Intranet WIKI applications.

Environment: Oracle APPS R12 (12.1.3), Red hat Linux, Oracle 10g, Forms 10g and Reports 10g, OAF (JDeveloper), Oracle Application Express (APEX), TortoiseSVN, Dell STAT, AP,AR, GL, FA, Financial Accounting Hub(FAH), PO, INV, AP, AR, CM, Trade Management, CRM Foundation, Territory management.

Confidential, Durham, NC

Techno-Functional Consultant

Responsibilities:

• Involved in restructuring and cleaning of the Party & Customer data. Managed party and customer merge processes including implementation of best practices for the merge process. Created the match rules, attributes and transformations using DQM. Designed and developed a custom workflow process to take required approvals before merging the duplicate customer set data.
• Worked as business analyst to gather requirements for and designing a custom tool for merging duplicate set parties and customer data. For identification of duplicate customer data worked with Duns and Bradstreet (for Organizations) and Acxiom (for Person).
• Designed and developed WSDL’s and web services for near real time data integration between Confidential and partner site applications
• Extensively worked on business events to integrate the customers with partner applications
• Did various setups in XML Gateway to accept Sales Orders from 3rd party applications
• Designed and developed 2-way near real time interfaces with partner sites and applications. Inbound interface constitutes of a synchronous BPEL process exposed as a web service and outbound interface by registering subscriptions for seeded oracle applications business events.
• Defined Custom modifiers, Context and Attributes, Qualifiers in advanced pricing module for the orders booked from Quoting and Order management module.
• Performed extensions and Customizations in Oracle Customer Online OAF pages using jDeveloper.
• Involved in the upgradation of the Oracle Apps from 11i (11.5.10.2) to R12 (12.1.3). Involved heavily in both Functional and Technical issues during the upgrade.
• Involved in the testing of Business cycles in OM, INV, PO, AP, AR, Payment, and GL modules. Worked with business users to resolve the issues.
• Designed and developed OM Order Header workflow to send email notification to the customers who purchased event orders. Prepared MD.050 and MD.070 for this enhancement.
• Designed and developed the custom OM Order Line workflow to create Service Contracts.
• Designed accounting and cash reconciliation integration between custom CRM application and oracle applications using Fusion middleware. Interfaced with external systems by defining common XML schemas
• Developed common utility programs for FTP, Archiving to be used by multiple interface programs.
• Implemented parallel process for critical programs to cut short the nightly batch jobs window.
• Developed custom Java concurrent programs to call native Java API’s in Trillium address standardization software.
• Created Service Requests and worked with Oracle support for bugs and patches.
• Worked on tracing and performance improvement.

Environment: Oracle APPS R12 (12.1.3), Oracle SOA Suite 11g, Red hat Linux, Oracle 10g, Forms 10g and Reports 10g, OAF (JDeveloper), Oracle Application Express (APEX), TOAD, PVCS, OM, INV, Install Base, Service Contracts, XML Gateway, PO, AP, AR, CM, Projects, Customer online, Payment, GL and Advanced Pricing.

Confidential, Pine Brook, NJ

Techno-Functional Consultant

Responsibilities:

• Developed a Customization for Credit and Re-bill for the corrected Meter Reads in Service Contracts and AR Modules.
• To avoid duplicate customer records designed and developed a custom solution that matches the existence of the record in TCA and provide a percentage of the match. Then Customer Maintainer group reviews the matched record and decides whether to select the matched record or create a new. The solution includes DQM setups, 2 forms and a program that derives the % of match.
• Customized OM Order Line workflows depending on order type and order source. Custom workflows include Lease, Rental and Lease orders.
• Designed and developed the existing advanced shipment notification (ASN) report to include the On- going maintenance and Compensation details for the order taker and Installer.
• Developed Preliminary and final shipment profile reports which gives up the heads up of the items to be shipped along with the Installer and order taker information. This is reports include the customer building information along with Floor/Suite/Room, number of stairs where it is stored at order line level DFF.
• Customized the Lockbox process for Receipts Import and applied against Invoice for various matching requirements in AR Module.
• Developed Custom forms for the Aggregate Billing extension solution in Service Contracts and Billing.
• Worked on the customization of Service Contracts Main Billing Program.
• Used CUSTOM.pll for validations and zoom functionality.
• Developed various adhoc reports for the Business using Reports6i and PL/SQL Package Programs.
• Developed Custom Solution to upload files using attachment from a Custom form using Forms6i for various data uploads.
• Customized the Account Generator Workflow to Rebuild Charge Account in iProcurement Module.
• Setup the Approval Group, Rules in the Oracle Approval Management Engine.
• Worked on Performance improvement of Custom PL/SQL Code, Forms and Reports.
• Worked with the Business users for gathering the Business Requirements gathering, Analysis, Functional Test and UAT stages.
• Extensively used FNDLOAD utility to Upload, Download the AOL objects
• Worked on Production Support to fix the issues logged by the application users for order to cash (OTC) modules. This includes first level techno functional triaging and provide the solution.
• Wrote short functional designs for the enhancements required or if there are any technical issues addressed.
• Worked with end users in training them for the enhancements made and helped them to understand the functionality available in the oracle application software.

Environment: Oracle APPS 11i(11.5.10)/R 12.0.3, HP UNIX, Oracle 9.i, Forms 6i and Reports 6i, TOAD, SQL*Loader, Service Contracts (OKS), Install Base, OM, AR, AP, E-Commerce gateway, iProcurement, iExpense.