EXPERIENCE SUMMARY:

• More than 17 years of experience in Finance, Insurance, Healthcare, Agriculture & Chemicals, Discrete and Process Manufacturing domains. Over 15 years of extensive experience in Supply Chain (Manufacturing, Distribution & Refurbishment) as Senior Oracle EBS Techno Functional Consultant.
• Covering complete project life cycle in implementation, rollout, migration, gap analysis, customization, developing custom extensions and support for various Oracle apps modules.
• ERP Functional: Familiarity with AIM Methodologies. Experience in Order Management, Shipping Execution, Advance Pricing, Oracle Transportation Management, Oracle Inventory, Bill of Material, Work in Process, Purchasing, Costing, Advanced Supply Chain Planning, Oracle Process Manufacturing, Payables, Receivables, Cash Management, Oracle Trade Management and Demantra
• ERP Technical: Provided dedicated and result - driven consulting on Oracle Applications (R12, 11i, 11.0 and 10.7) to major clients such as CareFusion/ Confidential, State Street, Marsh, Sony, Confidential and others.
• Well versed with RDBMS: - Oracle 11i, 10g, 9i, 8i. MSSQL 2010, 08, 05. MS Access and query languages SQL and PL/SQL. Unix shell scripts, FTP, API’s and other Oracle development tools. Have worked on built in or extended Oracle Reports.
• System Analysis and Design: Delivered Oracle Apps (R12, 11i, 11.0 and 10.7) customizations with SQL, PL/SQL, SQL Loader,
• Experienced in managing multiple full project lifecycles from business development to final delivery
• Program Management: Assertive planning for releases, prioritizing and scheduling, creation of development and coding standards, Functional specification, technical documentation, technical/functional team management, resource allocation and mentoring. Handled increased responsibilities and challenging assignments to harness technical and managerial skills.
• Proven ability to lead teams (onsite & offshore) involving defining activities, managing and mentoring staff.
• Have performed roles as project manager, delivery consultant, lead and analyst. My career has covered all aspects of functional and technical program delivery and have a successful track record in leadership; defining, communicating, mentoring architecture, process and motivation of team members
• Demonstrable expertise in technical leadership from converting business requirements into functional solution architecture within formal engineering processes and communicate those solutions to stakeholders both in the business and the delivery team, providing impact analysis where change is needed.
• Have displayed strong migration abilities, capability in planning the migration. Successful hands on experience of migration
• Data Migration: Expert in CranSoft Data Garage, CranPort, DSW, DCS, EZMap, Address Server and Admin.
• Excellent writing skills: Hands on experience in authoring technical infrastructure plan, Root cause analysis documentation, Application Understanding documentation, User Manuals, Migration plan, Design documents, Technical and Functional specifications.

TECHNICAL EXPERTISE:

Primary Skills: Oracle Applications R12, 11i, 11, 10.7

Operating Systems: Windows, Unix, Solaris, AIX, HP Unix, Linux

Languages: C, Java

Development/Reporting Tools: Oracle Discoverer Administrator, Oracle Discoverer Desktop, PL/SQL (Expert), SQL Loader, TOAD, SAP Business Objects and OBIEE

Middleware: SOA BPEL

Scripts: HTML Scripts

Database Connectivity: ODBC

Databases: Oracle 11G, Oracle 8i, 9i,10g, 11i, MSSQL 2005, 08, 10, MS-Access

Domain Knowledge: Finance, Insurance, Healthcare, Agriculture & Chemicals and Manufacturing

ERP: Oracle Applications R12, 11i, 11, 10.7x

EXPERIENCE:

Confidential, Alsip, IL

Environment: Oracle Application R12, / Oracle Transportation 6.3, Oracle 11.2 Database. (Linux)

Supply Chain SME & Project Manager

Responsibilities:

• SME for projects in pipeline to determine possibilities Link, Ariba, Concur, and Manufacturing Operations Excellence projects
• Serve as Subject matter expert for supply chain process including forecasting, purchasing, planning, scheduling, order management and shipping.
• Elicit functional requirement gathering for Forecast to Build (F2), Procure to Pay (P2P) and Order to Cash (OTC).
• Project/Delivery Management for key projects including project charter.
• Ensuring overall operational efficiency, identifying improvement and managing risks
• Tracking team member performance against schedule and targets, providing feedback, resolving issues, and coordinating changes to enhance project performance
• Provide ongoing communications and change management including training and process rigor.
• Managing incoming projects and provide prioritization including business case.
• Maintaining responsibility for all resource planning
• Assist to stream line the IT/Business process
• Assist with business on KPIs

Confidential, Alsip, IL

Environment: Oracle Application R12, Oracle Transportation 6.0, Oracle 11.2 Database. (Linux)

Supply Chain SME & Project Manager

Responsibilities:

• SCM Lead & Project Manager - Oracle EBS Rollout of acquisition for RSI (Feb 2014 - Nov 2014)
• Project Manager Database Upgrade (Mar 2014 - Jun 2014)
• SCM Lead - Label Print Project - (Jul 2013 - Aug 2013)
• Project Manager Application upgrade projects (Aug-2013 to Nov 2013)
• SCM Lead - Mexico EBS Roll-out project. (Mar 2012- Jun 2012)
• Enhancement and automation of the application right from requirements gathering, configuration, development, testing to implementation and post implementation support.
• Successfully conducted the workshop with core team to understand the business process, Analyzed and Identified gaps/improvement between existing business process and Oracle Standard process
• Worked extensively on Order Management, Shipping Execution, Advance Pricing, Oracle Transportation Management, Oracle Purchasing, Inventory, Receivables, Payables, Oracle Trade Management, ASCP and Demantra modules. Enhanced the system using Oracle API’s
• Internal Sales Order/Internal Requisition process was automated to establish simplified Intercompany sales across operating Units and Toll manufacturing. After OPM Batch close entire Internal sales process will compete automatically and Warehouse will receive Pick slip, BOL and Advance shipment notification automatically.
• Configured Available to Promise(ATP) and Auto-Scheduling functionality
• Implemented Drop Ship Functionality to enable the Customer Service team to ship the goods directly to Customers from Supplier warehouse.
• Configured RMA and Approval Management functionality.
• Implemented Commercial Invoice automation for international shipment
• Designed and Developed On-time Info project.
• Implemented Oracle EDI through IBM Sterling - Purchase Order Acknowledgment, Oracle Acknowledgement, Advance Shipment Notification and Invoice
• Automated Pre-pick slip, Pick slip, BOL Print process based on Shipping warehouse
• Established Purchase Requisition process and Approval hierarchy to manage Items purchases in the Organization
• Configured Auto-Sourcing rules and Approved Supplier List (ASL) to enable Buyers to release purchase orders automatically from Planners Workbench
• Implemented and Managed Global Trade Item Number (GTIN) project
• Configured Cycle counting and physical counting
• Implemented Oracle Order Management and Oracle Shipping Execution integration with Oracle Transportation Management using SOA
• Automated LTL and Parcel Rate Load in Oracle Transportation Management.
• Implemented Auto Planning for Parcel, LTL and Truckload shipment.
• Provided extensive month end support to the Oracle end users to close the Purchasing & Inventory period as well as have also played the role to identify the recurring issue and implement permanent solutions to improve the overall stability and performance of the system
• Responsibility for all deliverables of the projects
• Managing and directing efforts of project managers to ensure effective planning, coordination and synergy between projects
• Overseeing all project execution activities such as budgeting, planning, costing, delivery, and post-delivery review
• Managed AMS project, Project Link, Auto Invoice creation and Electronic Payment Automation Projects
• Managed Sales Force and EBS Data integration
• Analyzed the whole business process with business users and optimized the whole system.

Confidential, San Diego, CA

Environment: SAP ECC 6.0, SAP CRM 7.0, CranSoft 5.3, Oracle Application 11.5.9, MS SQL Server 2005

Data Migration Lead

Responsibilities:

• Defined a consistent data migration project plan for end-to-end development and execution of each Object
• Interacted with business SPOCs and work stream leads for requirements gathering and developed functional and technical specification for critical objects.
• Analyzed the legacy data and derived respective mapping with SAP data.
• Coordinated with other developers and team members in developing the data migration technical objects LSMW, conversion programs and BOA CranSoft developments.
• Worked in My-SAP CRM migration objects like Installed Base, Business Partner, Quotes, Contracts, Service requests and Service Orders.
• Worked in SAP-ECC migration objects like Material Master, Equipment master, Customer Master, Engineering Change Order and Routing.
• Defined conversion cut-over plan with all pre-production activities. Did data extraction and cleansing, developed conversion scripts using CranSoft.
• Development of Pre and Post load validation Reports.
• Worked in performance monitoring and optimization of data load execution process.
• Configured SAP ECC, SAP CRM, Oracle Applications, PeopleSoft and IDS data sources for data extraction in Data Garage.
• Developed packages for Data Import and Packages for Data Export using CranPort
• Configured Legacy and SAP Master Data Mapping using Data Construction Server (DSC)
• Mapped source and target fields using EZMap, maintenance of CranSoft users using CranSoft Admin.

Confidential, San Diego, CA

Environment: Unix, Oracle 9i, Oracle Application 11i and Oracle 6i

Consultant

Responsibilities:

• Worked on Order Management, Shipping, Oracle Transportation Management, Inventory, Costing, Receivables and Payables modules. Enhanced the system using Oracle API’s
• Enhancement of the application right from requirements gathering, development, testing to implementation and post implementation support.
• Analyzed the whole business process with business users and optimized the whole system.
• Developed and delivered interfaces between Oracle Application, PeopleSoft and SAP.
• Designed and developed the customer interface between Oracle Application and Vastera (a third-party vendor).
• Developed Discoverer Reports - Delivery Accuracy Report, RMA Order List and Inventory Analysis.
• Worked on TAR Analysis and Patch Analysis

Confidential, Boston, MA

Environment: Solaris, Oracle 9i, Oracle Application 11i and Oracle 6i

Consultant

Responsibilities:

• Enhancement of AP, AR CM and GL modules, COA and CPD Tools
• Customization of bank Statement and auto reconciliation in CM
• Worked on Essbase, Actuate, Discoverer and custom applications like FDW and GEER
• Worked on TAR Analysis and Patch Analysis

Confidential

Environment: HP-Unix, Oracle 9i, Oracle Application 11i and Oracle 6i

Consultant

Responsibilities:

• Enhanced standard modules - AP, AR and GL and Mark View
• Customization of Forms, Reports, PL/SQL Stored Procedures and Shell Script, consolidated billing invoices, customer import program and Marsh stress tests
• Worked on TAR Analysis and patch Analysis, tuned reports and programs

Confidential, San Diego, CA

Environment: HP Unix, Oracle Applications 10.7/11.0.3 , Oracle 8, Forms 4.5 & Reports 2.5

Consultant

Responsibilities:

• Collecting the Business requirement study, preparing technical specifications, developing the code and testing the application.
• Support and Enhancement of the following Applications
• Inventory Reserve Profit Elimination PO Faxing Anti Terror Process
• Tuning of reports and programs.

Confidential

Environment: Windows NT, Windows 98/2000, Oracle Applications 11i, Oracle 8i, Oracle 6i

Consultant

Responsibilities:

• Responsible for Customization of Forms, Reports and Interface Development of AP, AR & GL
• Scope requirements for implementation of Oracle Manufacturing and Supply Chain
• Review and Maintenance of Documents, Code, and database objects.
• Training end-users on how to use the applications

Confidential

Environment: Solaris, Windows NT, Oracle Applications 11/11i

Consultant

Responsibilities:

• Responsible as a Team member for the Product development and Execution of various Oracle tool like FND LOAD, FND PROGRAM, etc

Confidential

Environment: Windows 98, Oracle 8i, Oracle 6i

Programmer

Responsibilities:

• Responsible as a Team member for the development, implementation and testing of the Application.
• Creation of Oracle Reports