PROFESSIONAL SUMMARY:

• Over Nine Years of Oracle EBS experience in implementing/supporting Oracle Financial (GL/AR/AP), SCM (OM, PO, Advanced pricing and OKS) and Manufacturing (BOM, WIP) applications as a Techno - functional Consultant.
• Over Four Years of Oracle APEX experience in design and developing Web Applications / KPI Dashboards. Creating custom Themes and Templates, and Client-side development using JavaScript, jQuery, Bootstrap, HTML5 and CSS3
• Strong Techno-functional experience in Quote/Order to Cash, Drop-ship and Procure to Pay business processes.
• Functional Expertise in following Oracle E-Biz modules: OM, AR, PO and OKS modules
• Extensive experience in Integrating Oracle EBS with Oracle APEX and other Third party applications using custom APIs and familiarity with Enterprise Application integration (EAI) technologies.
• Diversified business knowledge on various Distribution, Manufacturing and Financial industries.
• Extensive work experience in developing FRICEW components using Oracle Developer tools (APEX 5/4.2/4.1, BI Publisher, Forms/Reports 6i/10g and jDeveloper 10g/11g).
• Strong programming knowledge on SQL, PLSQL, Java, JavaScript and jQuery
• Have working knowledge in Oracle Fusion Middleware stack (SOA 11g, BPEL), ADF 11g and OAF Frameworks
• Experience in documentation using OUM (AN100, DS140, TE20) and AIM (MD50, MD70 and MD120) Methodologies.
• Expertise in understanding Business flows, GAP analysis, Data conversions, Interfaces, Unit & Integration testing, System appreciation, Training, Production support, Enhancement of business processes and application development. Have worked at Client Business sites on defining and implementing Business Process Flows.
• Excellent Verbal, Analytical skills and ability to work in a time-constrained and team-oriented environment
• Focused and hardworking, self-motivated and team oriented; with proven capability to meet high-pressure deadlines and coordinate multiple projects.

TECHNICAL SKILLS:

Oracle e-Biz R12/11i Modules: GL, AR, AP, OM, QP, PO, INV, BOM, ENG, WIP and Service Contracts (OKS)

Oracle Tools : Oracle APEX 5/4.2/4.1, Developer 6i/10g, JDeveloper 11g, SQL Developer, BI Publisher and TOAD.

Databases: Oracle 9i/10g/11g.

Fusion Middleware Stack : SOA 11g and BPEL

Version Control Tools: STAT 5.6.4, TFS 2010, MKS Integrity client

EPM Tools: ServiceNow ITSM, CA Clarity and CA Service Desk

Web App Dev Tools: Bootstrap, Angular JS, HTML5 and CSS3

Languages: SQL, PL/SQL, Java and JavaScript/jQuery

PROFESSIONAL EXPERIENCE:

Confidential, Coppell, TX

Senior Oracle Apps Consultant

Responsibilities:

• Re-wrote the existing Oracle BI Reports using Pipelined Table Functions to significantly reduce the execution times from 16 to 5 Hours
• Developed Conversions for Customer and Supplier for the newly added Business units
• Created numerous Interfaces for GL Journal Imports, Receivable/Payable Invoices, Credit memos and Receipts to support scheduled imports from Legacy systems to Oracle EBS.
• Developed UNIX Shell script to TAR the Consolidated invoice files (more than 20000) and FTP it to Remote server
• Implemented an Interface using Oracle Advanced Pricing APIs to create new Price Lists and modifying the Price List Rates on existing Service Contracts annually or need basis.
• Developed an Interface using Oracle Service Contract APIs to Auto-Extend the functionality of Service Contracts such as bulk creation of Contract Lines/Coverage’s/Billing Schedules.
• Build the Queue tables and APIs to generate XML Payloads to Enqueue / Dequeue the payloads through Fusion Middleware for any data changes across the Integrated Oracle EBS modules and Legacy/Third party Applications
• Created Purchase Orders, Invoices and Service Agreements using BI Publisher
• Developed High Volume Data reports in eText format for Customer EDI transfers
• Created a Customer Address Mapping application using RESTful Webservice and Google Geocode JSON API to load the Location details into Oracle EBS.
• Designed and developed a large Revenue Management application using Oracle EBS and MS SQL Server (Line of Businesses) databases which contains various KPI Charts and customized seeded Oracle EBS Financial reports in Drill-down, Pivot formats
• Designed and developed a File-based Loader application to load High Volume Master and Transaction data originated from Legacy systems to Oracle EBS. And also created the APIs to store the Flat file and load the Flat file data to staging and Auto-triggering the Oracle EBS Concurrent Programs to validate and import the parsed data to Base tables.
• Developed different Authorizations/Authentications using Custom APIs to authenticate the Application users to support the SOX Compliance
• Developed numerous Dynamic Actions and PLSQL On Demand Processes using AJAX Calls in the applications to render the Dynamic data asynchronously..
• Developed Custom Templates and Themes using Bootstrap/ jQuery/HTML5/CSS3
• Supporting Month-end activities, Working on Incidents/Change Requests raised through ServiceNow ITSM, Creating documentation for the Project deliverables using OUM Methodology, Migrating Code between environments using STAT 5.6.4, Maintaining the code versions using Microsoft TFS 2010 and Maintaining the document versions in CA Clarity PPM.

Environment: Oracle applications 12.1.3 (AR, AP, GL, PO, OM, OKS and AOL), PL/SQL, APEX 5/4.2, XML Publisher, UNIX, Microsoft TFS 2010, ServiceNow ITSM and STAT 5.6.4.

Confidential

Technical Analyst

Responsibilities:

• Involved in the implementation of Voucher Management Application using Oracle ADF to create Pages, Task Flows and Page Fragments
• Developed Interfaces for Drop-ship/Blanket Sales Orders, Purchase Requisition/Order Imports using OM/PO APIs
• Customized the Pre and Post processing Oracle Quoting (ASO) User hooks to accommodate the custom logic to support the Drop ship process.
• Developed a custom Interface using Advanced Pricing User Hook APIs to extend the existing Price Lists, Modifiers and Qualifiers.
• Developed UNIX Shell scripts to copy the invoice files from APPLCSF to local UNIX server and email the files to respective customers based on their BILL TO.
• Developed an outbound B2B interface to send out Invoice information to customers and also designed the process using Business Events and Subscriptions to create XMLs.
• Developed Interfaces that get triggered using Oracle Business Events. Have worked on creation of custom Business Events, Event Subscription, Agents, etc. Have worked on integrating Oracle Business Events with SOA (Oracle Enterprise Service Bus (ESB)).
• Worked on workflow changes to change the PO approval process, custom pl/sql programs to customize the PO grouping logic for creation of drop ship POs and automatic PO Receipt interface programs.
• Developed several customizations on OM module using Forms personalization and Custom.pll
• Attending Change Request review calls to review new requirements of the End user.
• Involved in the implementation of two complex applications to accommodate the custom custom B2B Drop Ship and Service Contracts Management processes
• Developed JavaScript / jQuery libraries to handle the Application business logic.
• Developed numerous Dynamic Actions and PLSQL On Demand Processes using AJAX Calls in the applications to render the Dynamic data asynchronously.

Environment: Oracle applications 11.5.10.2 (ASO, PO, OM, AP, AR, Advance Pricing and AOL), PL/SQL, APEX 4.1, BI Publisher, Workflow, SQL Developer, UNIX, CA Service Desk and MKS Integrity Client.

Confidential

Consultant

Responsibilities:

• Developed a GL Interface to import Journals against transactions coming from Legacy systems and also created GL Daily Rate Interface to Import Daily Conversion rates
• Developed AP invoice import Interface to import invoices to Accounts Payables from Legacy Systems.
• Designed and developed an interface program to load the journal transactions and beginning balances into General Ledger by using SQL*Loader, PL/SQL package and Journal Import Concurrent program.
• Customized the Order Management and shipping Workflow processes and notifications.
• Involve in Tuning procedures and packages to rectify the performance bottlenecks.
• Designed and developed an outbound interface to process the Cash applied Receipts into Legacy system using UTL FILE

Environment: Oracle applications 11.5.10.2 (GL, AR, OM, PO, INV and AOL), PL/SQL, Toad, Workflow, SQL Developer, UNIX, IBM Tivoli.

Confidential

Programmer Analyst

Responsibilities:

• Developed Order Import, Items Import and Shipping Interfaces,
• Developed WIP and BOM Interfaces for day to day Transactions across the Operating Units.
• Developed Custom.pll and new custom Forms using Forms 6i to support the business processes.
• Developed Zoom functionality and other Custom Events/Actions on OM module using Forms personalization
• Involved in the implementation of custom iSupplier Web application using OA Framework to manage the Supplier Invoices, Payments and other Communication activities.
• Developed Purchase Orders and Invoices using BI Publisher.
• Developed numerous OM, BOM, ENG, WIP and MRP reports using Reports 6i
• Provided functional/technical production support for OM, INV, BOM and ENG modules, worked with oracle support and resolved numerous production issues.
• Gathered requirements for enhancements, prepared functional and technical documentations, developed test cases and training plan for the enhancement rollout.
• Working on resolution of tickets irrespective of the modules and maintaining the SLAs.
• Coordinating with Functional & QC team which is responsible for activities like Functional setups, User creation, assigning Responsibilities.

Environment: Oracle applications 11.5.10.2 (OM, Shipping, INV, BOM, ENG, WIP, MRP and AOL), PL/SQL, JAVA, OAF, Forms 6i, Reports 6i. jDeveloper 9i, XML Publisher, LINUX.

Confidential

Technical Consultant

Responsibilities:

• Developed Customer and Supplier Conversions to import the legacy data from Home grown applications.
• Developed two large Custom Modules using Oracle Forms to accommodate the Sugar Manufacturing and Power Generation processes and also built the APIs to integrate these with Oracle EBS modules.
• Created numerous Oracle OPM (Process Manufacturing) Reports related to Sugar manufacturing and Power generation processes such as such as Consolidated Cane Crushing Report, Daily Production Report, Power Contribution Report, Variance Cost Wise/Department wise Reports, and Operation High Lights Reports using Reports 6i / XML publisher.
• Attending Change Request review calls to review new requirements of the user.
• Providing reports and data to the Business as per the requirements.

Environment: Oracle applications 11.5.10.2 (OPM, OM, PO, INV, and AOL), PL/SQL, Forms 6i, Reports 6i. Discoverer 10g, LINUX.