EXPERIENCE SUMMARY:

• 19+ years of experience in oracle ERP and EBusiness suite of applications performing Application and Business Process design, Business systems Analyst, Project Management, functional and technical lead for Implementation, Upgrade, Deployment and Performance Management of Oracle 11i/R12.2.x ERP application.
• This includes oracle applications versions 12.2.3, 11.5.10.2 (11i), and 10.7. Expertise on functional and technical aspects of Procurement Contracts, Sourcing, Supplier lifecycle Management, Purchasing (PO), iprocurement, isupplier, Order Management (OM), General Ledger (GL), Accounts Receivables (AR), Accounts Payables (AP), Oracle Inventory (INV), Bills of Materials (BOM), Engineering (ENG), Costing (CST) and several EDI interfaces.
• Has strong subject matter expertise in Procure/Source 2 Pay, Order to Cash, Inventory business processes for Hi Tech Manufacturing.
• Started working as a software engineer/developer; then began working in Oracle Applications; next moved to being a technical development team lead; after that began working as a functional lead/BSA.

TECHNICAL SKILLS:

Functional: requirements gathering workshops, functional gap analysis, application design, configuration, module setup, test script generation and production support.

Technical activities: interfacing with users, identifying technical gaps, estimating work, architecting system interactions, designing custom solutions, programming, leading developers, scheduling, producing documentation and providing production support.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle R12 EBS Consultant

Responsibilities:

• Functional Set ups for Accounts Payables and Procurement modules for many new legal entities that are being created for one of the large Seperation project from Confidential.
• Lead Functional SME for implementing “Config Snapshot” tool which is being used to create new set ups for P2P, O2C and many other ERP tracks.
• Also doing many other set ups like Responsibilities, AGIS, EBTAX, OM, INV, SABRIX, VERTEX and other modules as and when required.
• Configured and tested Legal entities, Banks, Bank Accounts, Payment process profiles, payment process request templates, Smart forms, PO document types, financial options, payable options, purchasing options, inventory organization parameters and many other modules.
• Merger of new company that Confidential acquired with existing Oracle ERP R12: Working closely with the business process owners, business process analysts, SMEs and global business applications team to understand the business needs to provide new capabilities and functionality, resolve issues and ensure standards and procedures are followed and maintained.
• Solution Architect for designing Custom Purchase Order Details view for oracle R12 EBS integration to 3rd party system. Wrote the functional design document for the project and helped develop the solution.
• Solution architect for Mass Pricing upload project. I facilitated the discussions with Product and Pricing team to understand requirements, drive key decisions and found resolution to the issues.
• Solution Architect for Order Cycle Dashboard. This is a complete custom solution for Confidential which is developed using Oracle Application Framework (OAF).
• Created and implemented Integrated SOA web service between oracle R12 and third party licensing system endpoint and outgoing.

Confidential

SME, Sr. Business Systems Analyst, Solution Architect

Responsibilities:

• Oracle EBS R12 upgrade from R11i. Subject Matter Expert for Purchasing/Sourcing to pay track.
• Solid understanding of Procurement Contracts, iSupplier Portal, Sourcing, Supplier Life Cycle Management, Supplier On Boarding.
• Designed and developed a highly customized Supplier On Boarding Process with several different approval steps (Procurement and Payables Business groups).
• Created end to end (BR100/MD50) Solution Design Documents / Functional design documents and project plans for several projects.
• Conduct regular status meetings with business on existing projects and new projects in the pipeline.
• Oracle EBS R12 upgrade from R11i. Subject Matter Expert for Oracle Manufacturing track.
• Configured the Advance Procurement modules for test and Production instances. These modules include (Contracts, Sourcing, Supplier On boarding, isupplier portal, iprocurement, Purchasing).
• Conduct CRP and UAT testing with business users. Work closely with Business Super Users to address any functional issues.
• Implemented isupplier portal for worldwide procurement team. Helped design solution to automatically upload thousands of isupplier user accounts and register them in ERP.
• Help IT internal and external Audit Teams with SOX compliance related queries.
• Working closely with consulting partners to arrange workshops for Requirements gathering and gap analysis for Oracle Sourcing and Procurement Contracts.
• Implementing highly customized Supplier Life Cycle Management functionality for Oracle R12.
• Solutions Architect for integrating oracle ERP with third party Materials Management System.
• Managed and attended several fact finding and design workshops for new features in R12.
• Worked with Technical team leads and guided them with WIRE objects conversion and retrofitting from R11i to R12.
• Managed the redesigning of the Period End /Month end process for Procurement and inventory period closing for R12.
• Set up Appworx to run Create Accounting Cost Management and Create Accounting Receiving Jobs to transfer GL entries into XLA tables for the new Sub ledger Accounting (SLA) in R12.
• Oracle SME for Workday to Oracle Integration project.
• Successfully completed over 200 small to medium size projects in oracle 11i and R12.
• Configured and Implemented AME for Advance Procurement.
• Configured cXML PO transmissions to several vendors
• Set up various Punchout stores in iprocurement with vendors.
• Implemented iSupplier portal with nearly 7000 supplier users worldwide.
• Designed and developed scripts to automatically create and register isupplier users in oracle.
• Managed several Consultants for many different projects.
• Conduct regular meetings with offshore teams from Malaysia, Europe, India and Thailand.
• Working with consulting partners to manage, plan and design integration from PLM system to Oracle R12. This includes Engineering Change Order and Bill of Material integration from PLM to Oracle R12.
• Designed and implemented effective process for copying daily standard cost change to 70 inventory orgs.
• Highly experienced in configuring, designing and developing Workflow.
• Experience in Purchase requisition, Engineering change order, Sales Order workflows and other Workflows in R11i as well as R12.
• Designed inventory items creation and maintenance integration tool from a legacy web system to oracle R12.
• Designed Bills of Material creation integration tool from Legacy web system to oracle R12.
• Closely working with QA team to assist them in test script preparations, creation and execution in HP Quality Center.
• Resolved more then 100+ high to medium priority production support issues post upgrade to oracle R12.2.3. This helped to stabilize the post upgrade oracle R12 instance quickly.
• Successfully completed several performance tuning projects.

Confidential

Sr. Business systems Analyst/Project Manager

Responsibilities:

• Successfully completed some medium size projects in oracle 11i.
• Managed Implementation of a legacy Web tool for laptop tracking with integration to oracle fixed assets.
• Managed a few small projects for oracle 11i Order Management.

Confidential

Sr. Analyst, Technical lead

Responsibilities:

• Successfully completed over 200 small to medium size projects in oracle 11i.
• Designed and implemented effective process for copying daily standard cost change to 70 inventory orgs.
• Highly experienced in configuring, designing and developing Workflow.
• Experience in Purchase requisition, Engineering change order, Sales Order workflows.
• Designed inventory items creation and maintenance integration tool from a legacy web system to oracle ERP.
• Designed Bills of Material creation integration tool from Legacy web system to oracle ERP.
• Closely working with QA team to assist them in test script preparations, creation and execution in HP Quality Center.
• Designed and developed Sales Orders Inbound Interfaces which will create sales orders in Oracle Order Management from several sources such as Online Store, Outside Repair Center and Clarify RMA’s.
• Designed and developed Inventory Outbound interfaces to send inventory data to a custom “Inventory Dashboard” on web. This dashboard will be utilized by warehouse personnel to view daily issue and receipts.
• Created Several Functional and Technical Designs for converting entities like Customers and Open Sales Orders to oracle 11i platform.
• Designed and developed interfaces with EDI for the JIT Warehouse Automation project. This project was implemented to replace the manual Jit management done by account managers. It automated the whole JIT pull process and saved several man hours. The project involved EDI, oracle ERP and Shipping execution system (custom Shipping system called Drive Logistics System).
• I was responsible for the enhancements and support of all the modules involved in Order to Cash cycle.
• I was also involved in generating several inbound and outbound translation maps in EDI.
• Implemented ORACLE COLLABORATION SUITE application for document management purposes by Doc control and several engineers. This project was undertaken to replace legacy DMS system. This project is now been considered as benchmark by other teams as it was managed very efficiently and economically. We had a very high availability and highly scalable architecture of 3 tiers which were configured by using Linux cluster manager and oracle 9i Real Application Clusters.

Confidential

Sr. Techno/functional Consultant

Responsibilities:

• Done several customizations to the Enter Orders Form and applied various Patches to OE, INV, AR modules with help of Oracle World Wide Support.
• PL/SQL Interface created for creating Trade Orders directly based on the on hand quantities from warehouse.
• Extensive Customizations Done to the Custom Advance Credit Checking module
• In depth knowledge of all the Interface Processes starting from booking an order to Credit check, Pick release, update shipping, Inventory Interface, Receivables interface, Autoinvoice. (ORDER to CASH).
• Implemented Oracle Applications Purge Programs with highly customized modules for Oracle Applications 10.7 SC. Used Outer bay Technology Software for the same. Removed row chaining for tables which showed extensive chaining.
• Developed a Trace program to find why an Order Line is not getting Pick Released. PLSQL Program and Report.
• Created and modified several reports like Commercial Invoice, Pick Slips, Delivery Order, Summary Commercial Invoices etc.
• Done Enhancements to highly complex and completely customized INTERCOMPANY SHIPMENTS system.
• Developed the EDI Inbound / Outbound transactions for Direct Shipment. This includes development of SQL LOADER scripts, Shell scripts, PL/SQL Packages and Reports for transactions like 867,856,860 etc.
• Customized form to enter the Country of Origin for the Export and the branded products.

Confidential

Application Developer/DBA Support

Responsibilities:

• Involved in the migration process of all the systems from HP series to K460 series server along with the sr. DBA.
• Optimized SQL and PL/ SQL scripts. Prepared SQL*Plus and SQL*LOADER scripts for migration of data to and from flat file to Oracle database.
• Responsible for creation of database triggers, packages, procedures, indexes and synonyms.
• Solved problems like adding data files, creating spaces and recreating indexes.
• Involved in all aspects of software development life cycle including design, development, implementation and support of the application system.
• Wrote programs that generated reports and queries and also that created raw dump on magnetic tapes.
• The application system included the procurement and Material management system.
• Actively involved in the analysis, design, coding and implementation of workers welfare system.
• Programs were written in the application area of accounts payable and accounts receivables.
• This system was successfully completed and implemented followed by the documentation procedure and methodology for the business analyst, programmer and user.
• Responsible for design, coding and implementation of waste sales system which is integrated with the financial accounting system.
• Work included report writing in the area of purchasing and invoicing.
• Designed security profiles for outgoing commodity after the entry of data in the online waste sales system.