SUMMARY

• Oracle Technical/Techno Functional Consultant with more than 8.3 years of aggregate Experience.
• Extensive experience with being a Technical Consultant in Supply Chain modules and Manufacturing modules of OM, PO, i - Procurement, WMS, Enterprise Asset Management (EAM), BOM, Inventory, Shipping, Engineering, Costing, WMS, WIP, ASCP, Costing, Advance Pricing, BOM, AR
• Over 8 years of experience in Supply Chain Management and IT Consulting.
• Core Team-member during Oracle Application Implementations for several clients
• Extensive experience with Technical tracks
• As an Oracle EBS Techno-Functional Consultant, has executed Six projects that includes end-to-end implementation, support, enhancement and upgrades.
• He has expertise in Oracle Finance (GL, AR, AP, FA), Oracle SCM (OM, PO, INV, BOM, Adv. pricing, Quoting) and P2P (PO, AP, iProc and iExpense).
• Experience on both Order to Cash and Procure to Pay cycle.
• He has extensively worked on Oracle SQL, PL/SQL, Report, Forms, XML/BI Publisher, UNIX shell script and having knowledge SOA (Oracle SOA11g).
• Experience with performing detailed analysis, collecting requirements, technical specifications, development and unit testing, integration and production install and support.
• Extensive experience in Design, Development, Customization and Implementation of business applications using Oracle Applications, SQL, PL/SQL, Oracle 11g/10g/9i, Developer 2000/6i and XML/BI Publisher.
• Proficient working in modules which include Order management, Purchasing, Inventory, Integrated Receivables Account Payable, I-Procurement and I-Supplier.
• Strong conceptual knowledge on business processes in Inbound and Outbound Logistics, Operations and Supply Chain Management.
• Strong programming experience in creating Procedures, APIs, Packages, Functions, Triggers views, collections (nested tables and arrays), records, sequences, Materialized views, Constraints and other database objects using SQL and PL/SQL.
• Worked out with RICE components involved in creation of Reports that are not available as standard reports, creation of the Interfaces to external systems, creation of Conversion programs to transfer data from a legacy system to the new system and Extensions to the existing system to add additional functionality to existing system without disturbing the core software functionality of the system.
• Experience in System Administration responsibilities such as registration of concurrent programs, request sets, creation of Users, Responsibilities, Forms, Functions, Values Sets and Flex fields in Oracle Applications.
• Developed SQL Program to load data from Excel files, flat files into temporary table using UTL FILE utilities and SQL loader.
• Experience in developing, customizing, modifying forms, reports existing in Oracle Applications according to the business requirements and specifications using Oracle Developer Suite 10g/9i (Forms, Reports) and other front-end tools.
• Experience in creating a new workflow and calling the workflow in the forms as done in the standard Oracle forms.
• Extensively involved in SQL tuning, troubleshooting, debugging and fixing the codes/scripts, Month-end activities and production support.
• Ability to work individually as well as in a team with excellent problem solving skills, troubleshooting capabilities, learn new tools and concepts.
• Involved in preparing the functional specification, technical documentation, schema documents, test cases, flow charts, production support and user support documents.

TECHNICAL SKILLS

Oracle E-Business Suite: Oracle Applications R12.1.3, 11.5.10.2, 11.5.8, 11.5.5 & 11i

Oracle ERP Modules: Extensive Experience OM, PO, i-Procurement, WMS, Enterprise Asset Management (EAM), BOM, WMS, Inventory, Shipping, Engineering, Costing, WIP, ASCP, Costing, Advance Pricing, BOM, AR

Oracle E-Business Components: Oracle Financial Statement Generator (FSG), Oracle Approval Manager (AME), Oracle Hyperion Finance Management and OBI.

Databases: Oracle 10g (10.2.0.4), Oracle 9iR2, Oracle 8/8i

Development Tools: Oracle SQL, PL/SQL

General Tools: Toad, Microsoft Office, MS Visio, MS Projects

OS Platforms: Sun Solaris, Oracle Linux, Windows NT/XP

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

SCM Technical Analyst

Responsibilities:

• As a Technical/Techno Functional Analyst worked on the RICEW components around the following modules: PO, i-Procurement, WMS, Enterprise Asset Management (EAM), BOM, Inventory, Costing, WIP, ASCP and OM
• Worked on the Technical mapping of data Conversions & Enhancements for Engineering, Costing, WIP, OM, INV, PO modules and developed the data conversion scripts.
• Involved in developing the Item Import Program In oracle INV module
• Worked on preparing RICEW list for the different phases of the projects.
• Worked on preparing instance plan and part of team having preparing cutover plan.
• Supporting high level conversion and interface design and development.
• Designed and developed custom exception handling and debug processes.
• Creating Custom Pricing and Pricing Formula in the application.
• Worked on Order Import Interface and customizing different oracle Workflow.
• Facilitated workshop for R12 Delta Features, CRP’S, UAT, SIT and Key user trainings.
• Configured enhanced functionality and delivered business deliverables per project scope. Worked with Technical Architect on RICE (Report, Interface, Customization, Extension) component to developed customized solution.
• Worked on Oracle advanced technology like Oracle Advance Queue like: Enqueuer & Dequeue and oracle payload to develop different integration between ERP systems by using SOA11g with WSDL.
• Lead the team to deliver the component timely bound manner and Involved on peer meeting
• Designed and worked on B2B Expansion project using the tool like E2Open and Just Transform.
• Worked on Integrating the Oracle EBS with Other system to on board B2B partner.
• Develop custom BI Publisher Report in Quoting, pricing, PO and OM modules.
• Worked on converting Oracle workflow customization to AME component development.
• Worked on the AME setup for Pricing variance and discount approval.
• Design the Notification frame work for the project.
• Design the custom objects to attach all the reports in quote header level generated during quote creation.
• Worked on retrofit of different RICEW objects.
• Supported developing different AIM documents templates for the technical team.
• Created MD050 and Setup document.
• Facilitate CRP (Conference Room Pilots), SIT (System Integration Testing), and UAT (User Acceptance Testing).
• Worked on different customization of pricing and quoting modules during implementation.

Environment: Oracle Apps Release 12.1.3/11.5.10 e-Business suite (OM, PO, i-Procurement, WMS, Enterprise Asset Management (EAM), BOM, Inventory, Shipping, Engineering, Costing, WIP, ASCP, Costing, Advance Pricing, BOM, AR)

Confidential, Chicago, IL

Oracle SCM Technical Analyst

Responsibilities:

• Customize the PO Approval Workflow to attach multiple files in po header level and send with the mail notification.
• Worked on preparing RICEW list for the different phases of the projects.
• Working on PO, Requisition, I-procurement and AP Account Generator Workflow.
• Involved in performance fixes by using multi-thread and hints.
• Worked on preparing instance plan and part of team having preparing cutover plan.
• Resolution of issues and handling post implementation support on AP, PO, I-procurement and FA and Inventory module.
• Responsible for creating the new custom Vendor form to support the Invoice printing.
• Worked on new organization rollout and Supplier consolidations.
• Involved in analysis, specification, design and implementation of business solution using AIM methodology
• Involved in various activities like preparation of technical documents MD70, discussions with the client regarding the proposed solution, unit level and user acceptance testing
• Interacting with the client and updating the daily status report
• Working on PO PDF report for all the PO types.
• Worked on customized XML Publisher report with Bursting and Translation.
• Worked on different types of AP, PO, I Procurement, Isupplier issues assigned.
• Worked on AP Check Printing Report (BI Publisher).
• Done the core setup for i-procurement and i-supplier
• Worked on setup like information template,realms,attachment.profile options, security
• Worked on the AME setup for PO approval
• Setup new Punch out using Oracle exchange XML server gate way.
• Responsible for developing the Order Import and AR transaction, Pricing and Inventory Item Interface.
• Worked on i-supplier setup like supplier registration and securing attributes
• Creation of ASN (Advanced Shipment Notice) for buyer once the product is shipped by i-supplier.

Confidential, Germantown, TN

SCM Technical Analyst

Responsibilities:

• Worked on the RICEW components around the OM, PO, i-Procurement, WMS, Enterprise Asset Management (EAM), Inventory, Engineering, Costing, WIP, ASCP, BOM Modules.
• Defined the rules and strategies for Picks for Sales Order/Work Order
• Defined the rules and strategies for Put Away for PO and RMA Receipts
• Worked on customizing as well as developing new Workflow processes.
• Lead the team from Off-shore to deliver the component timely bound manner and was part of on technical team review meeting.
• Provided high level designing of interface and conversion processes.
• Worked on Unix shell script for Interface Data Load, Encryption, Description and other utility.
• Executed below conversion and interfaces design and development:
• PO and PO Receipt Conversion
• AP Invoice Interface
• Responsible for Customizing Purchase Order Workflow and different Processes for the business.
• Involved in setup the PO and Order Management modules.
• Responsible for developing the Order Import and AR transaction, Pricing and Inventory Item Interface.
• Involved in Converting the Oracle Report into XML Publisher.
• Worked on PO print report for Standard and Blanket release type PO
• Responsible for converting the RDF reports to BI Publisher report.
• Involved in form personalization and Custom.pll for different forms.
• Involved in creating the User manual and to train the users.
• Involved in various activities like preparation of technical documents MD70, discussions with the client regarding the proposed solution, unit level and user acceptance testing
• Worked on AME setup for PO,AP, I procurement, Isupplier modules.
• Worked on different notifications on Po, Requisition, Release document.
• Worked on different i-supplier workflow like ASN creation notification, Po acknowledgement and change promise date workflow.
• Hosting the self-service application to external partners.

Confidential, Jersey City, NJ

SCM Technical Analyst

Responsibilities:

• Responsible for Customizing Order Management Workflow and different Processes for the business.
• Responsible for developing the Order Import and AR transaction, Pricing and Inventory Item Interface.
• Responsible for Customizing Sales Online Task Workflow and Customizing the Notes on Telesales module
• Working on Customer and Transaction Interface.
• Involved in Integrating the Oracle Apps with Product database to Bill the service contract according their usage.
• Working on Custom.pll and Form Personalization’s.
• Responsible for creating the new custom report and BI Publisher repot for Contract, Usage and billing details also for customer, credit card, contract and Payment due etc.
• Creating the concurrent programming for the assigned objects and develop assigned object and their test cases.
• Involved in preference tuning for different program
• Involved in various activities like preparation of technical documents MD70, discussions with the client regarding the proposed solution, unit level and user acceptance testing.
• Have a greater knowledge of different Order flow.
• Involved in creation of BI Publisher report.
• Worked on AR aging and other report customization and converting it to BI Publisher.

Confidential, Kansas City, MO

SCM Technical Analyst

Responsibilities:

• Responsible for Customizing Order Management Workflow and different Processes for the business.
• Converted all the Order Cycle 11i into OM Flow (EBS R12i) and creating their MD50 and MD70.
• Setup the Pricing and Order Management modules.
• Responsible for developing AR transaction, Pricing and Inventory Item Interface.
• Responsible for converting all the RDF report to BI Publisher report.
• Created the User manual and to train the users.
• Preparation of technical documents MD70, discussions with the client regarding the proposed solution, user acceptance testing.
• Have a greater knowledge of different Order flow.
• Responsible for personalizing the different FORM and worked in Custom.pll.
• Involved in fixing the bug and enhancement of PO,OM, I procurement, Advance Pricing module.
• Worked on Custom Advanced Pricing formula, qualifier and modifiers.
• Maintaining RICEW status and update to engagement and client.
• Tested several patches that were applied to the 11.5.10 instance for functionality as well as performance.

Confidential

Technical Team Member

Responsibilities:

• Responsible for creating the new custom report and BI Publisher report PO, AP and OM module.
• Involved in Customizing the OM order Header Workflow to send the FYI notification, according to the client requirement.
• Responsible for Creating User manual and MD070 for the new objects
• Involved on end-to-end analysis of an object by discussing with user.
• Responsible for creating the User manuals.
• Responsible for creating the different periodic and event based Alert for Customer, BOM and Item creations.
• Involved in fixing various bug for Order Import, AR Transaction Interface and Customer Interface.
• Responsible for creating the different alert, trigger and UNIX mail processes for Sales Online modules.
• Worked on Lead, Opportunity and Quote creation processes.
• Updated and creating the new MD070 for different development activity.
• Reviewing the developed reports.
• Unit Testing the Reports through use of Unit Test cases.
• Providing Offshore support to the implementation team on site.

Confidential

Oracle Technical Consultant

Responsibilities:

• Collaborated with casting suppliers, analyzed gear demand data and built demand forecast model to ensure material availability.
• Introduced inventory control model based on the replenishment time of raw material and demand of finished product. Reduced the inventory from 10,000 to 4,000 and saved $15,000 per annum.
• Prepared Master Production Schedule (MPS) depending upon the production plan and inventory level.
• Planned material requirements for the 15 components according to MPS. Adjusted production and inventory quantity according to holiday events for the workers.
• Designed database to automate employees, workers and supplier record keeping. Reduced and eliminated the non-value added activities to make lean manufacturing.