SUMMARY:

• 16+ years of experience in all phases of design, development and implementation of Oracle Applications.
• Functional responsibilities: requirements gathering, functional gap analysis, application design, configuration, module setup, test script generation, training end users, and production support.
• Planned and managed Oracle EBS upgrade projects
• Technical (technical lead, developer, etc.) activities: interfacing with users, identifying functional and technical gaps, estimating work, architecting system interfaces, designing custom solutions, programming, leading developers, scheduling, producing documentation, and providing production support.
• Experience spans extensively in design, development and building enhancements and extensions across various Oracle Applications modules.
• Expertise in O2C and P2P cycles. Strong in Order Management (OM), Inventory (INV), Account Payables (AP), Accounts Receivables (AR), Purchasing (PO) - PO Matching 2-way, 3-way, General Ledger (GL), Advanced Pricing, Approvals Management (AME)
• Extensive knowledge in Oracle Business Intelligence (OBIEE) - RPD work - creation of Business Areas, Workbooks, Subject Areas, Answers. Implemented Oracle BI Publisher - including report development, creation of interactive dashboards and integrating reports into OBIEE dashboards.
• Worked on ETL development tools - Informatica, Oracle Data Integrator (ODI), SQL Server Integration Services (SSIS).
• Experience in large-scale Implementations - version upgrades, data conversions, data migration, testing of data.
• Extensive experience in RICE Components - reports, interfaces, conversions and extensions. Hands-on experience with Oracle Forms/Reports, SQL, PL/SQL, Oracle Workflow, Open Interfaces, and APIs.
• Designed and customized reports using XML Publisher. Designed and developed customization in Lease Management using OA Framework.
• Keen focus on performance tuning, testing, and quality assurance.
• Experience in creating AIM Documents - MD 050, MD 070, MD 120 and CV 040 documents, coordinating UAT and cutover activities. Worked with Oracle Support - creating TAR’s - on many projects

TECHNICAL SKILLS:

Oracle Applications: R12, R11i, R11, R10.5.7

Other Components: SQL Server, SSIS, OBIEE, Informatica, ODI, Oracle Transportation Management (OTM), CRM On Demand, RMS, ReIM

System Implementations: New Module Installations, Upgrades, Customizations and Extensions; Interfaces and Data Conversion

PROFESSIONAL EXPERIENCE:

OTM SOA Consultant

Confidential

Responsibilities:

• Worked on deploying SOA (BPEL) Components for the integration of OTM with Oracle EBS. Worked on SOA 11g. Did setups required for the OTM Oracle EBS integration to work through the SOA BPEL Processes.
• Worked on Voucher, EDI and the standard BPEL Composites.

Data Warehouse, ETL and Business Intelligence

Confidential, Cleveland, OH

Responsibilities:

• SW Custom OBI Informatica to ODI: Convert all the custom OBI Informatica mappings to ODI. Working on converting the Advance Collection Informatica mappings to ODI Interfaces as the client is migrating from Informatica to ODI.
• Item Categories and UDA’s: Designed and developed the whole flow of bringing in the Item Categories and UDA’s from Oracle EBS to the Warehouse for the APAC Implementation. Built all the Informatica mappings, DAC setup to run the workflows. Did the RPD changes to bring in the Item Categories, UDA’s to OBIEE Presentation layer.
• Developed new analysis, dashboards in OBIEE for APAC Go-Live. Made changes to the existing dashboards which are specific to APAC implementation.
• AR Project: Made changes to the existing dashboards to bring in Business Unit and Focus Account as per business needs. These changes involve modifying the underlying source objects, changing the Informatica mappings, RPD changes, modifying OBIEE dashboard prompts, analysis’ to show these additional columns and filter data accordingly.
• Worked with business users and SME’s to gather requirements and work on the solution design for various BI needs.

Confidential, Dodgeville, WI

OBIEE/BI Publisher Specialist

Responsibilities:

• Worked on the reporting requirements for R2A release for Lands’ End - implementation of Direct Procurement & Invoice Matching
• Designed and developed all the reporting requirements for Oracle Retail Merchandising (RMS) and Oracle Retail Invoice Matching (ReIM), v16.0.1. Scheduled BIP Reports to run and FTP automatically.
• Most of the reports are BI Publisher reports. There are four Dashboards where ADF Customizations are done. For the reports - ‘Unmatched Invoices and Receipts’ and ‘Control Report’ - had to write PL/SQL Packages to populate temporary tables that extract data from RMS with complex logic.
• BI Publisher Reports: PO Print, PO vs Item Cost, PO Version Audit, Delivery Slide Reason Code, Receiving Exceptions, Invoices ReIM to EBS, Credit Debit Memo, Invoices due by Supplier, Unmatched Invoices and Receipts, In Transit PO Lines, Customs Compliance Invoice Variances, Detail Control Report
• Dashboard Reports: Item Enrichment Dashboard, Approved POs Dashboard, Receiving Exceptions, Merchandise Totals Dashboard

Confidential

Data Architect

Responsibilities:

• Worked on OBIEE 12c Upgrade project - upgraded the 11g RPD to 12c and moved all the content to 12c.
• Solved issues with the upgrade - worked with Oracle support.
• Did RPD Merge between two teams and tested all the dashboards for data accuracy. Built new dashboards for CFO’s and Underwriters.
• Developed analysis and dashboards based on Essbase Cubes and SQL Server. Worked on drill reports with lot of dimensional hierarchy.
• Data Security - implemented row level security, so that the logged in user can only see the data that he is supposed to have access to.
• Created user roles and made sure proper Catalog access is established.
• Worked on support tickets - to make changes to the existing reports and dashboards. Developed SQL Server Integration Services (SSIS) Packages to populate data for the warehouse - pulling data from People Soft (PSFT) into the SQL Server warehouse.

Confidential, Pittsburg, PA

EBS Architect

Responsibilities:

• Supporting the Oracle R12.1.3 Environment - with focus on P2P and O2C cycles. Solution design and development of the customization's and enhancements to Oracle.
• Worked on integrations with external systems.
• Supported the OBIEE reporting system - using Informatica as the ETL tool. RPD Changes, new report development.
• Worked on AME Setup changes for REQ Approval Process
• Designed the solution for AR Receipt Creation process - using custom tables and API’s. Customer has incoming data from PayPal, First Data which is loaded in to Oracle
• Some of the customizations worked on: created a new ACH Payment Format and developed a solution to send the payment files to the bank; developed a number of reports - RDF, XML Publisher, OBIEE - in P2P and O2C cycle; Major reports - Trial Balance, Inventory Aging Report, Metrics Report, Returns Margin Report, GC MC Open Balance Report, Open Invoices Report, State Sales Tax Report, PO Barcode Report
• Integrations worked on: Inbound PO, AR Invoice Inbound, AR Receipt Creation, Legacy Gift Card/Store Credit Conversion, Receiving Interface, Item Import (Inventory), Outbound PO to HighJump, Integrations with PayPal and First Data.
• Worked on changes for the Thesis Project - PO Matching process, Inventory Aging Reports, PO Barcode Reports, GAAP Reports.

Confidential, Dallas, TX

OBIEE Consultant

Responsibilities:

• Implemented Wolper Punchout Process from Confidential Oracle Procurement website where employees can subscribe to the publications from Wolper website seamlessly.
• Designed and developed the FITS Interface - categorizing the Procurement Spend. Modified the Emptoris program for the global release to bring in India onto R12.
• Did the solution architecture, design and development of the reporting requirements for the global implementation of the R12 upgrade project for Account Payables
• Created EBS views, did the Noetix workbench set up. Published the RPD generated by Noetix - and created analysis, dashboards and dashboard prompts for all the AP Reports
• Created a POC for using the iBots to send email to Project Managers and Delivery Managers with their projects information extracts as attachments. Created one agent that can be used to send emails to all the mangers with the information that is specific to their projects.
• Co-ordinated with offshore team for requirements and during testing phase.

Confidential, Dallas, TX

Oracle Techno Functional Lead

Responsibilities:

• R12.1.3 upgrade - successfully implemented the upgrade project. Worked as the technical lead in the upgrade project responsible for all the RICE components.
• Built all the EDI Processes from end to end using BPEL. Built SOA composites using BPEL components that exposed some EBS sales order processing functions as web services accessible by all technology platforms in the enterprise through SOAP/WSDL interface. This fed into SOA Fusion Middleware, leveraging BPEL PM, B2B components as well as Oracle XML Gateway. Built all the data mappings for the solution, as well as interfaces, logic and rules. Sample supported EDI transactions are: 850, 855, 856, 810, 214, etc.
• Designed and built SOA composites and BPEL processes that polled the legacy system for incoming EDI Processes. Performed filtering and transformation operations on it before inserting into EBS system. Error handling was also done for handling the faults in BPEL Processes
• OTM Implementation (6.1) for EBS - solution all the integration work between EBS and OTM. Designed and developed BPEL Processes for all touch points. Worked as an architect for all the integration work. Designed and developed the customization in the delivery creation process, sending the deliveries to OTM, getting the trips back from OTM, actuals and freight invoices.
• OTM Implementation for other business units on AS 400 - Lead this project from end to end. Designed and developed processes for OTM and AS400 communication. BPEL Processes with two way communication - polling data from the AS400 system, sending it to OTM and then writing back the rate information provided by OTM. Did the OTM setups required for this integration - agents, bulk plan rules, web service set up, carrier and rate set ups.
• CRM On Demand Integration - Designed and developed the integration between EBS and CRM On Demand which is loosely coupled with our EBS System. All the customer data, contacts information is stored in CRM for easy access and analytical need to the Customer Service team.
• Credit / RMA Workflow Process - Designed a new Workflow process for approving Credit / RMA Orders and integrated it with the Order Entry process. Setup the approval hierarchy in Approvals Management (AME) and use that in the WF Process.
• Worked with the managers at all the Distribution Centers and streamlined the Shipping (WMS) process. Designed the pick list and pack list customizations, LPN pick process changes. Worked with Oracle Support on pending transactions, LPN issues.
• Advanced Pricing Contracts - Customers need Pricing Contracts before a price increase happens. Did a complete re-design of these contracts with accurate and detailed information on item pricing.
• Sales Order Form Customizations - Included the Broken Carton Charge (BCC) whenever a carton needs to be broken for the items ordered by the customer; Carry over DFF information when creating one-time ship to address; Displaying site (DFF) information on the SO Form;
• Item Import (Inventory) - designed and developed an interface to get Items in to Oracle.
• FedEx Implementation - Tomkins uses FedEx for parcel shipments (LTL). The FedEx system is fully integrated with EBS passing the tracking information to the delivery, Ship Confirm, closing the delivery.
• Helped the business users with OBIEE Reports - building new reports in the OM, Pricing area; helping them with fixing the existing reports.
• Direct API integrations with Oracle EBS and XML Gateway integrations.
• Worked on O2C Cycle: Worked on lot of customizations in OM Area – created new forms(Custom Pricing and Availability), reports; made Workflow changes to standard processes; designed and developed a completely custom solution for Credit / RMA approval process – with the approval hierarchy in Oracle AME (Approvals Management). On the Shipping side - we have integrated EBS with OTM which involves lot of interfaces (transactional data to and from between EBS and OTM). We also have EDI Interfaces with OM data and shipping data being sent to the customer at various stages in the O2C cycle. I was the sole person designing and developing all the customization in the OM area.

Confidential, Dallas, TX

Techno Functional Architect

Responsibilities:

• Architected the data migration strategy for the client.
• Designed data mappings for migrating Items and assign Item Categories from client's legacy system to the Oracle E-Business Suite. Designed and developed Inventory Item Data Conversion (IDC), On Hand Balance and Lot Control Material Transaction Conversion (OLDC).
• Worked on Supplier Conversion (SDC) - migrated Supplier and Supplier Sites from the legacy system to EBS. Delivered data mappings and the build of the conversion program.
• Delivered all the relevant AIM documents – CV 040, CV 060, CV 070 and CV 120. Managed offshore resources – doing client communication, code review, documentation review and testing.

Confidential, Plano, TX

Technical Architect

Responsibilities:

• Worked on integrating them with Confidential (OTM).
• OTM is integrated with PO Source Systems (EBS and APROMS) for receiving Purchase order information. OTM is also integrated with Vendors and carriers via Sterling Commerce Gateway (B2B).
• Customer has implemented OTM 6.1 and the integrations are on the latest SOA 11g platform. The Oracle delivered integration between EBS 11.5.10 and OTM is on a SOA 10g platform. This 10g integration is upgraded and modified to fit the client requirement.
• Worked extensively on the SOA infrastructure using Weblogic console and Enterprise Manager (EM) console to fix some critical performance, memory and transaction timeout issues in the system
• Worked extensively on the File Adapter, developed XSD Schema to format the data in extracted file as per requirement, using pipeline delimiters
• Delivered nine use cases that were identified as part of this implementation – Purchase Order Integration, Tender Offer Integration, tender Response Integration, Order Release Integration, Shipment Integration, etc.
• Worked on code Deployment from the Development instance to Test and other instances. Provided detailed documentation to the client on these processes

Confidential, Jacksonville, FL

BI Team Consultant

Responsibilities:

• Worked on all the reporting requirements for Confidential .
• Led the Business Intelligence team responsible for the reporting requirements in GL, AP, AR, HR, PA and FA modules.
• Designed and delivered ‘Detail activity of all Journal Entries Report’, ‘AP Invoices on Hold Report’, ‘AP Trial Balance Report’, ‘Employee Total Pension Contributions Report’, ‘Accounts Payable Total By Funds for Checks and EFT/ACH’, ‘AP Discounts Taken and Lost Report’ and several other reports using BI Publisher on EBS and OBIEE.
• Delivered ‘Projects Created Within the Past 24 Hrs’, ‘Overtime Callout Report’, ‘Projects by AFF Download Report’, ‘Maximo PWO Creation Report’, ‘Employee Attribute Changes Report’ using BI Publisher on OBIEE.
• Developed custom answers and dashboards for revenue recognition module using OBIEE. Created interactive dashboard for revenue recognition functional area. Developed custom reports using BI publisher for Order Management functional area. Few complex reports were developed using execution of direct SQL from OBIEE answers.

Confidential, Atlanta, GA

EBS R12 Integration Specialist

Responsibilities:

• Worked on GL Balances Inbound Interface – a monthly interface, using first week of that month; GL Outbound Interface (BHAG, Hyperion) – daily interface and it fills the abase cube (DW system); GL Outbound Interface (Transaction) – monthly interface, used before closing the period.
• Designed and developed GL Daily Rates Interface - a daily interface between Oracle and Routers system.
• Designed and Developed Supplier Conversion, Open Invoices Conversion, Closed Invoices Conversion programs using the MOAC responsibility.
• Worked on AP P-Card Invoice Import - a monthly interface that gets the file from P-Card and also from Oracle (project related data). Merges the files and loads them through AP Invoice Interface. Delivered AP Expense Amex Credit Card Interface – daily; Cash management bank statement interface – daily.
• Mapped legacy data fields to Source System Data and data cleansing.
• Designed and developed Positive Pay File for negotiable and voided checks. Generated the output in fixed length XML template using BI Publisher.
• Architected inbound AR Invoice interface. Mapped homegrown legacy data fields to Source System.
• Designed and developed Invoice Print New invoices and Invoice Print Selected invoices. Generated the output in custom XML template using BI Publisher.
• Delivered Employee, Employee Assignment, Job, Address, Contractors conversion and ongoing interface from PeopleSoft to Oracle HR.
• Mapped PeopleSoft HRMS data fields to Oracle R12 HRMS; Data Mask of Employee SSN using Form Personalization.
• Designed and developed custom program to update bank information for the employees who got converted as Suppliers during the process of submitting the expense reports.
• Worked on inbound interface from Hyperion to Oracle Project Costing to create Projects, Budget and Class Codes for Classification using the predefined templates. Designed and developed an outbound interface from Oracle Project costing to Hyperion by extracting the actual expenditure spent on all projects, which have a capital budget number.
• Designed and developed Construction in Progress (CIP) report and Project Summary Report using BI Publisher.
• Workflow: Account Generator modification, supplier provisioning, imaging & expense workflow process to place the expense report on hold and release; Project costing approval and timecard approval modification.
• XML Reports: Payments (ACH, Positive Pay, Check Printing), Send Remittance Advice, PO Print (Standard, Blanket & Agreement). AR Invoice, Spend Data, Over/Under 40 Hours Timecard, Auto-Approved Timecard, Supplier & Journal Audit reports.
• Created OAF page forms for GL mapping and supplier inquiry.
• Designed and developed AP expense imaging integration using AXF and BPEL process (Stellant).