PROFESSIONAL SUMMARY:

• Over 10 years of experience as Oracle EBS Techno - Functional Consultant and Lead.
• Involved in multiple successful life cycle implementations, upgrades and production support of Oracle Applications releases 11i and R12.
• Extensive experience in requirements gathering, impact and gap analysis, design and development of RICE components, customizing workflows, performance tuning, application integration and authoring technical documents.
• Highly motivated, hardworking and adaptable professional capable of leading team of developers and coordinating with cross-functional teams.
• Excellent written and verbal communication skills and strong analytical and problem-solving skills.
• Self-starter and quick learner who can work independently or as part of a team in a competitive and fast-paced environment.

TECHNICAL SKILLS:

Database Products: Oracle 8i, 9i, 10g, 11g

Developer Tools: Oracle Forms and Reports Builder 6i/10g, Workflow Builder 2.6, ADI, XML/BI Publisher, SQL*Plus, SQL Developer and TOAD

Languages: SQL, PL/SQL, Java, JavaScript, SOQL, XML, HTML, Unix Shell scripting

EBS Modules: OM, Inventory, WIP, BOM, Purchasing, Advanced Pricing, Shipping, AR, AP, GL

Integration Tools: IBM WebSphere Cast Iron, Pervasive Data Integrator, SSIS

WORK EXPERIENCE:

Confidential, Indianapolis, IN

Senior Oracle EBS Techno-Functional Consultant and Lead

Responsibilities:

• Redesigning old and inefficient integration processes using Cast Iron.
• Providing maintenance support for existing Cast Iron-based integrations for College Grad division.
• Tuning custom Oracle forms by running a trace to identify most expensive sections of code and rewriting the same in an efficient way to optimize performance and improve user response time.
• Resolving production critical issues for multiple divisions using different versions of Oracle E-Business Suite.
• Led a team of developers tasked with designing and developing Oracle - Salesforce integration solution and assisted Project managers in facilitating information exchange between cross functional teams. Some of the main responsibilities on this project included:
• Gathering business requirements and developing Technical solution documentation as per AIM standards.
• Designing and developing interfaces to export customer information, contracts, products and pricing to Salesforce and also importing orders placed via College bookstore sites built on Salesforce’s Heroku platform.
• Assisting in the design of Salesforce data model to store customer related information.
• Working with IBM Cast Iron integration team to develop orchestrations that facilitated seamless data exchange between multiple applications.
• Assisting QA team in developing and implementing test plans.

Confidential

Responsibilities:

• Developing Technical Solution documentation for various RICE components covering modules such as Order Management, Pricing, Inventory, WIP, BOM, Shipping and Accounts Receivables.
• Designing and developing custom forms, reports and interfaces in accordance with Oracle’s best practices.
• Testing and validating all standard and custom functionality as part of upgrade process.
• Designing and developing robust Sales Order Interface to import sales orders from multiple channels into Oracle after running them through extensive validation rules, custom scheduling engine and auto create WIP jobs to kick start the manufacturing process.
• Designing and developing custom invoice account distribution process that assigns appropriate GL accounts based on complex business logic not handled by Auto-accounting engine.
• Designing and developing data conversion programs to load items, categories, catalog elements, BOM, routings and pricelist information from legacy into Oracle.
• Customizing Order header and line workflows as per business requirements.
• Modifying the behavior of seeded Oracle forms using Forms Personalization and CUSTOM.pll.
• Assisting in the integration of Taxware with Oracle, setting up STEP interface and monthly incremental update of Tax rates in Oracle.
• Developing multiple BI Publisher reports based on business requirements and Converting existing Oracle Reports into BI Publisher reports by redesigning the layout using Template builder Add-in for MS Word.

Confidential

Responsibilities:

• Participating in requirement gathering and gap analysis.
• Developing technical design documentation for various RICE components based on AIM specifications.
• Developing data conversion programs to import item information and related BOMs and Routings from legacy mainframe application.
• Developing Customer Interface program that loads Customer accounts, Sites, Site Uses, Contacts and Locations from the Customer Master application using TCA APIs.
• Developing custom form to facilitate prebill approval for sales orders by invoking WF ENGINE APIs.
• Developing custom form to automate creation of credit/debit memo and a new rebill invoice for all or select lines of an invoice, to handle billing related errors.
• Customizing Tax functions in ARP TAX VIEW TAXWARE package to implement complex taxation logic applicable to certain groups of Customers and Salesreps.
• Developing custom workticket reports for the shop floor to view configuration options chosen on each assembly item by retrieving information from Configurator (CZ) tables.
• Developing interfaces to export sales order and invoice-related information to the data warehouse for use in BI reporting.
• Developing custom workflow to facilitate announcement text approval process.
• Working closely with Oracle Support in identifying variety of application-related bugs and fixing the same by applying requisite patches.

Confidential

Responsibilities:

• Developing multiple custom reports covering modules such as Oracle Purchasing, Order Management and Accounts Receivables.
• Developing custom order lookup form to review and edit sales order information, add or remove items, change billing and shipping details, generate reports and release holds.
• Tuning custom reports and PL/SQL programs using EXPLAIN PLAN and other tuning techniques.
• Designing and developing custom Order import process by interfacing orders from the web and other stand-alone applications.
• Developing data conversion programs to load Inventory Items and Pricelists from legacy mainframe system into Oracle’s Inventory and Pricing modules.