We provide IT Staff Augmentation Services!

Techno-functional Consultant Resume

2.00/5 (Submit Your Rating)

Philadelphia, PA

SUMMARY:

Confidential is an expert in helping organizations deploy Oracle’s value chain planning solutions. Confidential has spent the last 15 years applying his deep product, technical and industry experience helping top global companies line value through improved supply chain performance. Clients span multiple industry verticals ranging from High Technology, Contract Manufacturing, Banking, Finance, Energy, Consumer Goods and Entertainment. Deep product knowledge (Senior Product Lead for Oracle Planning products) and extensive Industry expertise (Manufacturing & Distribution) makes Raghav an optimal fit to solve complex problems and design creative solutions that accelerate business value.

TECHNICAL ENVIRONMENT:

SKILLS: Solaris, Linux (Ubuntu, Debian, Redhat), Oracle 11g, 10g, 9i, 8i, C,C++, Java,, BC4J, Oracle RDBMS 6, 7, 7.1,8.x, 9.x, Oracle Forms 6.0, 2.3, 3.0, 4.5, Reports 2.5, 2.0 (Developer 2000), 1.1, PL - SQL, Pro*C, MQ-Series, Active Web Object Request Broker, Corba, Case*Generator 2.0, Case*Dictionary 5.1, OCI, Filenet, Filenet Oracle E-Business Suite Integration (Imaging and Document Solution), Oracle Identity Manager ( Xellerate ), Oracle Access Manager ( Netpoint ), Netegrity Identity Minder, Sun Identity Manager 8.0, HIPAA Compliance

Packages: Oracle Manufacturing & Financials, Release 12, 11i (11.5.10, 11.5.8, 11.5.7, 11.5.4), 11.0, 10.7 SC, 10.6, 10.5, 10.4, AOL (Application Object Lib.); Oracle Value Chain Planning suite (ASCP, GOP, SNO, Demantra, IO, APS, APCC)

Modules: Manufacturing (WMS, MRP, OSFM, INV, WIP, MRP, BOM), Oracle Purchasing, Order Management, Order Entry, Inventory, General Ledger, AR, AP, QTC (Quote to Cash)

Languages: C++, C, Basic, Java, HTML,PL/SQL, SQL, C

Methodology: Oracle AIMS Methodology

Industry Experience: Manufacturing & Production, Hi-tech, Contract Manufacturing, Banking, Finance, Medical Equipment, Media & Entertainment

PROFESSIONAL EXPERIENCE:

Techno-Functional Consultant

Confidential, Philadelphia, PA

Modules: Inventory, BOM, ASCP, Inventory Optimization, Demantra 7.3.x

Responsibilities:

  • Created custom integration profiles and customized seeded integration profiles for data flow from Demantra to Inventory Optimization (safety stock planning) and ASCP
  • Extensive Experience with Customizing EP Load Processes,
  • Extensive Experience standard workflows and customized workflows
  • Worksheet performance issues and under* Created custom integration profiles
  • Customized Seeded Integration Profiles
  • Extensive Experience with Customizing EP Load Processes,
  • Extensive Experience standard workflows and customizing
  • Analyzed Worksheet performance issues and optimized Forecast Engine Setups and Nodal tuning.
  • Extensive Expertise in Installing Demantra and ASCP (Single and Multiple Node Setups)
  • Extensive Expertise in Identifying Patches for specific instance configurations and applying patches in Windows, and Unix Environments.
  • Designed custom forecast archival process to archive unconstrained forecasts from Demantra
  • Modified seeded integration profile to source data (break dimension data to granular level) for computing forecast accuracy and updated EP LOAD process for data loads.

Confidential

Supply Chain Architect (IT)

Modules: ASCP, Inventory Optimization, R12, Demantra 7.3.x

Responsibilities:

  • Implementation of Oracle Advanced Planning Solutions
  • Implementation of Spend Management Solutions to track spending on Flash Memory and Drives
  • Implementation and testing of ASCP EDD plans
  • Implementation and testing of End Item Substitution
  • Implementation and testing of Component Substitution
  • Implementation and testing of Forecast consumption at ATO Model Level
  • Implementation and testing of Forecast Consumption at Product Family
  • Implementation of Project Netting
  • Implementation of Reservation at Planning Group
  • Multi Node Installs of R12 on Linux (Ubuntu)
  • Cloning and creation of multiple R12 Instances.
  • Configuring of Oracle ASCP with R12 Destination and Source 11.5.10
  • Installed, Configured Demantra 7.3 and created proof of concept prototype for breadboard forecasting for data centers. Customized EP LOAD collections to collect breadboard forecasts and created granular forecasts at component level by exploding BOMs . Integrated with R12 system for end to end flow of source master/transaction data, unconstrained forecasts, constrained forecasts in ASCP and back to source ERP system.
  • Performed stress testing with multiple years of historical data to identify Engine performance issues and assess scalability of solution.

Managing Principal Consultant

Confidential, Fremont, CA

Modules: ASCP, Demantra 7.2.x

Responsibilities:

  • As a Principal Consultant, my role was involved implementation of Oracle Advanced Supply chain modules. The current responsibilities include implementing Oracle ASCP and GOP and giving solution presentation and leading proof of concept for the engagement. The brief summary of my experience is as follows.
  • Functional and technical consultant ASCP/GOP consultant
  • Business requirements gathering for Supply Planning and integration between Contract Manufacturers
  • Gap Analysis between Oracle Vanilla ASCP/GOP and Business requirements
  • Techno Functional Consultant for Oracle ASCP implementation
  • Techno Functional Consultant for Oracle Demantra Implementation - Assessed required patches to source system for standard collections - Installed patches and setup integration to Oracle source and ASCP modules.
  • Preparation of BR100, MD70 and MD50
  • Solution Design for Oracle ASCP/GOP
  • Proof of Concept for Various GOP scenarios (CTP ATP, SKU level ATP etc)
  • Proof of Concept for Allocation scenarios (% based and demand class based)
  • Implementation and testing of Forecast consumption at ATO Model Level
  • Implementation and testing of Forecast Consumption at Product Family
  • Proof of concept - Priority based pegging
  • Design and Proof of concept - Product Family based ATP
  • Region level sourcing - Design and proof of concept
  • Collections and Pre-and Post plan customizations - Design and development
  • ASCP Setup - Sourcing rules, Assignment sets, Priority rules etc
  • Design and Development of Custom Reports (Factory extract, Order scheduling vs MPS variance etc)
  • Integration, Support, Customization and Deployment of Oracle Applications 11.5.10
  • Design, Architect and Develop custom interfaces between custom Supply Chain application and Oracle Applications (ERP)
  • Supported a rules based fulfillment process between Oracle Applications and a Custom Confidential Finished goods system.

Program Manager - Supply Chain

Confidential

Responsibilities:

  • Implementing, scoping and deploying Oracle Manufacturing Application 11.5.10
  • Modeling sourcing rules and supply network
  • Setup supplier capacity constraints
  • Setup and Run plans in CRP, analyze supply plans and pegging information
  • Worked closely with Demand planning consultant to bring in Forecast/Demands
  • Worked closely with business users in the deployment of Work Orders, Routings and Bills of Material.

Confidential

Technical Lead SCM Consultant

Responsibilities:

  • Scope requirements for implementation of Oracle Manufacturing and Supply Chain
  • Working closely with 3rd party vendors to evaluate barcode and RF solution. (clearorbit, Oracle Mobile web Apps, HighJump etc)
  • Estimate hardware sizing for Oracle APS and DP.
  • Work closely with SCM users and help them with functional and technical issues
  • As a Senior consultant and techno-functional lead my role is focused on implementation and customization Surrounding the Oracle Applications - APS/Supply Chain and Manufacturing modules for a leading player in the PC Industry.
  • Orchestrated CRP1 and CRP2 activities
  • Orchestrated the Supply Chain Business Requirements gathering process
  • Designed the “to be” business flows for ASCP
  • Designed, scoped and coded the Rosetta interfaces to integrate with Contract Manufacturers
  • Integration between Agile and Oracle (SCMNet)
  • Supply Chain Consultant through Oracle Consulting

Confidential, Palo Alto, CA

Technical Lead

Responsibilities:

  • I was involved in the solution design, implementation and Go - Live support activities spanning across modules, along with various aspects of ERP/ MES integration.
  • Activities: Interfacing with users, identifying functional and technical gaps, estimating work, architecting system interactions, designing custom solutions, programming, leading developers, scheduling, producing documentation, and providing production support.
  • Technical lead r for implementation ofManufacturing Modules (WIP,BOM, APS, OSFM,INV,WMS,OM)
  • Development ofSchedulingscripts for Tidal Wave Scheduling tool. Designed anddevelopedschedulingroutines between Oracle apps ConcurrentManager and Tidal Wave.
  • CustomDevelopment of WMS Desktop Screens to Pick Load, Pick Drop and Print Labels.
  • Developed Conversion Scripts to Convert Invoices from Legacy to Oracle AR using AutoInvoice Interface.
  • Customized the APS data collection routines between Oracle WIP/OM/BOM/INV/PO to Oracle ODS
  • Customized Demand Planning Collections
  • Customized Quote to Cash processes, including order management, order fulfillment, billing and service cycles.
  • Performed all Quote to Cash testing for BOM changes (in OM, WIP, INV and AR modules).
  • Addressed configuration management initiatives and participated in developing prototype demonstrating varying levels of complexity in pricing strategies.
  • Designed and Developed LPN Interface from WMS of Oracle Apps 11i to Shipping and Logistics of 3rd party Apps.
  • Designed and Developed Interfaces from WMS to Third party Scanning and RF Terminal system.
  • Designed and Developed Rossetanet Interfaces between Oracle and AIH/ BizTalk components.

Senior Project Lead

Confidential

Responsibilities:

  • Developed and coded MBP (Memory based Planner) enhancements for the planning engine
  • Design and development of the Collection Routines of Oracle APS . (Integration of Oracle APS with the rest of manufacturing modules)
  • Designed and Developed the Releases Interface Between Oracle APS and Oracle WIP / Oracle Purchasing
  • Designed and Coded the Planners workbench Release Interfaces
  • Designed and coded enforcing integer requirements options of the Advanced planning system
  • Designed and Coded Data Collections from ERP to ODS
  • Designed and Coded Data Collections from ODS to PDS
  • Implemented the Partition feature of the APS planning system
  • Designed and Coded the OSFM (Shop Floor Management) to APS interfaces
  • Designed and Coded the OPM (Process Manufacturing) to APS Interfaces
  • Designed and Developed the Complex Planners Workbench UI using Forms 6.0, PLL libraries.

Environment: Oracle Manufacturing & Financials - 11i,11.0, Oracle 9.x, 8.x Forms 6.0, Pro*C, SQL*Plus, PL/SQL

Consultant

Confidential, Orange, CA

Responsibilities:

  • Implementation and Customization of Oracle Financials And Manufacturing Applications - v10.7 SC
  • Worked with following modules: Manufacturing - INV, MRP, BOM, Order entry, Accounts Receivables, Sales compensation.
  • Developed costing conversions routines to bring from costing input information from legacy system to the Oracle Applications.
  • Developed item conversions routines to bring data from legacy.
  • Developed category conversion routines to bring data from legacy.
  • Developed customized receivables interface, and auto invoice interfaces.
  • Developed and customized pick slip reports, invoice reports and bill of lading reports.
  • Developed a bit mapped invoice report
  • Developed an auto cancellation concurrent program based on a cancel date at order header level.

Environment: Oracle Manufacturing & Financials -10.7,Oracle 8.x Forms 4.5, Reports 2.5,Pro*C, SQL*Plus, PL/SQL

Techno Functional Lead Consultant

Confidential

Responsibilities:

  • Involved in the implementation of Oracle General Ledger. Design of GL chart of account structure, setting up GL profile. Options, converting over the chart of accounts from the legacy application to Oracle General Ledger, GL import interfaces to Oracle Inventory, Oracle Receivables.
  • Involved in customization of Order Entry module. Recreated the accounts receivable interface programs with order entry by coding in Pro*C. The new interface program would handle discounts as per user requirement rather than as per the Oracle application rule sets.
  • Customized pick slip handling and shipping routines by interfacing with a third party pick ticket management system, which would generate bar codes.
  • Developed customized reports as per user needs for pick slip printing in OE and forecasting in inventory and MRP modules. The forecasting report would print all changes in forecast either entered by user or generated by MRP processes.
  • Customized the mechanism of discount handling.
  • Designed and developed a custom AR interface utilizing C and Pro*C.

Environment: Oracle Manufacturing & Financials - 10.5, Oracle 7.1, Forms 2.3, Reports 2.0, Reports 2.5

We'd love your feedback!