SUMMARY:

• Confidential serves as Sr. Techno - Functional Consultant for Confidential and is responsible for delivery of overall technical objects and integrations of Oracle ERP and Oracle Value Chain Execution solutions.
• He has been acting as a Techno-Functional resource for various Oracle Application Implementation projects for the last 12 years and has extensive experience in various technologies involved in Oracle Transportation Management and Oracle E-Business Suite (11i and R12) including various Integration methodologies and technologies mainly Oracle SOA (10g, 11g & 12c).
• He performed various roles starting from Developer, Architect, Lead and Techno-functional roles throughout his experience and possess consulting experience across multiple industries.
• These industries include manufacturing, Confidential, finance, distribution, and technology.

CONSULTING SKILLS:

• Analytical Skills
• Business Process Design
• Business Requirements Gathering
• Solution Design
• Communication Skills
• Site Experience
• Systems Integration
• Customization Support
• Oracle Transportation Mgmt (G-Log)
• Global Trade Management (GTM)
• Fusion Transportation Intelligence
• Justransform
• Oracle SOA Suite (10g,11g & 12c)
• PL/SQL
• BI Publisher
• XML/XSL
• Discoverer 4i/10g
• Oracle Workflow 2.6
• APEX 3.0
• Oracle Forms 6i/9i/10g & Oracle Reports 6i/9i/10g)
• Oracle E Business Suite(11i, R12)
• Order Management
• Shipping
• Accounts Receivable
• Accounts Payable
• Inventory
• Advanced Pricing
• Cash Management
• Bill Of Materials
• EDI
• Projects
• JD Edwards E1
• AS/400

EXPERIENCE:

Confidential

Oracle EBS and OTM Consultant

Responsibilities:

• Primary Technical owner of all objects related to Oracle E-Business suite (OM, WSH and WMS).
• Performed multiple roles starting from Techno-Functional resource, Architect and finally Service Delivery manager/Lead responsible for the whole Oracle Foot print at the organization.
• Involved in on-going Oracle Enhancements including numerous XML Publisher Reports, Forms and existing custom solutions in all the Financial, Supply Chain modules available.
• Involved in Oracle support for Oracle 12.0.3 to 12.1.3 upgrade project.
• Involved in regular Production Support activities.
• Involved in full life cycle implementation of OTM (Oracle Transportation Management) 6.2.8 as an integration specialist at all business units under various Line of Businesses (LOB).
• Involved in rolling out OTM to a LOB (AS400) developing and designing custom integrations between AS400 and OTM using Oracle SOA 11g.
• Involved in implementing Pool Distribution solution for 2 plants in a LOB (AS400) as techno functional role including developing multiple custom OTM web services.
• Primary owner for all the support and enhancement activities related to OTM and its integration to multiple systems like Oracle EBS and AS400.
• Acting as a primary OTM support resource covering both functional and technical areas. Some of the functional duties include Agents, Recurring processes, Carrier Rating setup etc.
• Involved in multiple server related migrations for applications like OTM, SOA11g and EBS and this involves re-implementations and configuration of all SOA application, FTI, SMC3 and Milemaker/PC*Miler etc.
• Involved in Oracle CRM OnDemand implementation. Responsible for design, development and support for Customer master conversion into CRM-OnDemand.
• Involved in Full-Life cycle Oracle Application Financials implementation for their Mexico division (as separate Operating Unit).

Confidential

OTM Technical Consultant

Responsibilities:

• Technical resource for a brand new OTM & GTM 6.4 Cloud implementation utilizing Justransform as middleware from the source ERP JDE 9.1.
• As a technical resource, responsibilities included getting involved in requirement gathering sessions, assisting with functional configurations, involved in efforts to troubleshoot application issues as well as developing numerous integrations and BI reports.
• The Integrations developed include the transactional interfaces of Sales order, Purchase Orders and Master data integration of Items and Address Book (locations). A total of 8 integrations altogether have been developed incorporating complex webservice calls from within the Justransform mapping.
• The reports developed include Commercial invoice, Packing List, Bill of lading etc.

Confidential

Oracle Technical Consultant

Responsibilities:

• Performed the role of Lead technical consultant for a 7 person development team including onsite and offshore. Charged with many tasks related to new custom development (in OA Framework, Oracle 10g and Forms 6i) and maintenance service requests.
• Helped with many root cause issues and primarily to streamline the current issues with the upstream system (EBS + Custom Applications).
• Performed the role as an architect for a major project which was used for recording the Customer Statement of Works (SOW) and have it run through a series of approvals from different teams and management levels before eventually converting the SOW into pricelists. The team size is 6 comprising both offshore and Onsite resources.
• Developed & customized multiple custom forms in Capacity Planning, Work in Process etc.
• Fixed multiple issues related to Bill of Materials Routings, Capacity Planning and Custom Configurator Solution interface.
• Developed interface programs to perform InterOrg inventory transfer and Receipts in the event of multiple Plants (Inventory-Orgs) Close.
• Provide efficient and quick Root cause analysis for High priority Issues.
• Develop new enhancements starting from gathering requirements, writing MD50s and MD70s, development and assisting users in UAT.
• Work with complete custom solutions other than just E-Business Suite (11.5.10).
• Develop customization and enhancements in Oracle technologies like Oracle Reports 6i/10g, Oracle Forms 6i/10g, PL/SQL and Oracle EBS.
• Worked on creating XML Publisher reports.
• Work in Multi-Org and MRC environment.

Confidential

Sr. Developer

Responsibilities:

• Responsible as a primary Technical Lead/owner for Quoting, Purchasing, Advanced Pricing, Order Management and Inventory Modules and developed various customizations in AP, AR, GL.
• Involved actively in upgradation project from 11i to R12.
• Lead multiple projects under numerous modules including custom applications, some of them are mentioned below:
• Inventory - Item Status Change Program, Item Auto Assign Program, Cycle Count Program.
• Quoting - Custom Print Quote Report, Options & Upgrades (Oracle), Take-Off Report, Quote Line Rounding, AME Approvals.
• Purchasing - Change PO Program (CreatePO Workflow), Receiving Tolerances, Back to Back Program (Requisition Import).
• Advanced Pricing - Custom Sell Price Program, New Sell Price Program, Custom Division Zone based Pricing, Surcharge(Tax) Calculation.
• GL/AR/AP - Conversion of Division (Inventory Org) based Discoverer Reports to BI/XML Publisher Reports, GL Interfaces.
• Order Management: Custom Sales Order Contracts, Custom Ship Confirm Form, Custom Schedule and Dispatch.
• Custom Modules: Masco Sales Application, Division Scorecard Application, Schedule and Dispatch Application.
• Developed numerous XML\BI Publisher reports including conversion of numerous Discoverer10g divisional reports and modified xslt templates for FSG (Financial Statement Generator) reports.
• Responsible as primary owner of all workflow customizations and customized various workflows like Requisition Approval Workflow, PO Approval Workflow, Create PO workflow, AME for Quoting Approvals, Order Line Workflow, and PO Requisition Account Generator as per user requirements.
• Communicated with the offshore team and maintained daily status meetings with offshore team and Onsite technical team.
• Developed a custom OAF page to create ShipTo and BillTo addresses for a Sales order called from the Standard Sales Order Create form.
• Actively involved in performance tuning task force team, fine tuning all the affected processes (Reports, Concurrent Programs, Nightly Jobs etc) which would have High I/O Cluster waits, Poor Explain Plan, High CPU Cost. Reviewed (by generating trace files, explain plans etc) and modified (or redesigned) the existing programs to drastically increase the performance.
• Created Shell Scripts for Host Concurrent programs and migration scripts for code deployment.
• Performed the job as a Database Architect and designed a brand new database (ERD etc) including development and testing for a custom SALES application developed in Adobe Flex, basically intended to be used as a CRM application.
• Involved in various Interfaces and conversions, some of them are mentioned below:
• Interfaces: Receiving Transaction Processor, Requisition Import, and GL Interfaces etc.

Confidential

Techno-Functional Consultant

Responsibilities:

• Involved in the whole setup of Journal Approval ensuring journal entries and batches are approved by appropriate management personnel before the journals and can be posted to account balances.
• Involved in complete system life cycle implementation starting from requirements gathering to executing test scripts/Production installation.
• Some functional duties include Enabling Journal Approval to SET OF BOOKS, specifying journal sources for journal approval, defined authorization limits and created approval hierarchy (entering new employees).
• Loaded HR into oracle from different HR system with employee number (company Employee number used as cross ) and cost center information.
• Created a report in Reports 6i which shows the status of Cost Centers and other info about Approvers etc.
• Customized Journal Approval notification incorporating attachments attached to the journals at Batch and Journal levels
• Performed and of the new Journal Approval process for around 40 business users.
• Involved in development and customization of various Workflows in AR and Oracle Trade management including development of a whole new custom Workflow all from scratch incorporating email notifications, report generation and custom business process implementation.

Confidential

Technical Consultant

Responsibilities:

• Involved in Customer Statement Conversion programs for generating consolidated Statements for all parties.
• Created custom OAF pages using JDeveloper as per user requirements.
• Actively involved in various design and technical peer reviews of various development deliverables and extensively worked for expedited output/resolution of various issues.
• Created a custom interface program to update credit information at the party level with the one provided by D&B on a quarterly basis and simultaneously maintain a history of each party’s credit over period, which is again used by the credit analysts to review reports and determine parties credibility.
• Responsible for the production support as a technical resource for a period of 4 months and addressed various issues related to various technologies like Oracle Discoverer, Oracle Workflow and other interface and business process issues.
• Proficient in Oracle standard public APIs in AR, AP and OZF modules.
• Involved in performance tuning of Discoverer Reports and conversion programs.

Confidential

Oracle Developer

Responsibilities:

• Worked on Interfaces and data conversions from Legacy system to Oracle 11i.
• Developed SQL*Loader scripts to load data from legacy system into Payables, Receivables and GL interface tables after validating data through a custom built Concurrent Programs.
• Developed Auto lock Box interface program.
• Performed active role in analyzing, designing, building, testing and implementing several add-on modules/interfaces/customizations in an effort to implement Fixed Assets and Inventory.
• Developed many reports like Pick Slip, packing Slip, Mailing Label for Shipping and Credit Order Detail, Orders by Item, Order Detail & Summary Reports for Order Management and also created new reports as per client requests.
• Customized the Standard Order Entry Form for preferred customers.
• Customized various transactions in Accounts Receivables like Invoices, Receipts, Credit Memos and Debit Memos etc.
• Integrated employee data into Oracle Applications using APIs.
• Customized Transmission formats for inbound interfaces, Receipt sources, and Receipt classes.
• Updated Oracle Inventory item on-hand quantity from the old system.
• Customized the existing LOV's (Created/Modified several value sets).
• Created a spreadsheet based application and several complex reports and forms using Oracle Application Express (2.0).