Bharat K

SUMMARY:

**+ years of functional experience in design and implementation of ORACLE E-Business suite modules including Manufacturing (BOM,WIP,MRP), Order Management, Shipping, Purchasing, Inventory, ASCP, Oracle Demantra 7.2, 7.3 (DM & RT-SOP), HRMS and worked on versions R12 and 11i (11.5.10 and below), Upgrades to 11.5.10, 12.

Working experience in Oracle Application Financials modules 11i/R12 (General Ledger, Account Receivables, Account Payables, Fixed Assets).

Additional implementation experiences with Oracle Demantra, WMS, and ASCP for specific clients.

Design Series, Worksheets in Demantra

Define server and Client expression

Experience working in Solar, Semi-Conductor and Sporting Goods industries.

Full cycle implementation of Oracle applications with track record of on-time delivery and customer satisfaction.

Experience using WEBADI tool

Experience using AIM methodology

Experience in supporting Production environments.

Skilled in analyzing business processes and configuring applications incorporating best business practices.

Experience in System Analysis (AS IS) (TO BE), Gap Analysis, Functional Design Specification (MD050), Unit testing, System Integration Testing, Issue Management and Documentation.

Proficient in Integrating and automating EDI transactions like PO Inbounds, ASN and Invoice Out bounds using e-Commerce Gateway and Gentran / Custom Programs translation.

Well-versed in writing PL/SQL queries, understanding Packages, Stored Procedures, Functions, Database Triggers and SQL * Loader scripts.

Highly innovative and customer oriented with strong understanding of high level business flow.

Possess excellent communication skills, organized and goal oriented.

SKILLS:

Oracle

Order Management, Inventory, Purchasing, iSupplier, BOM, WIP,MRP,ASCP, OSFM, Demantra 7.2, 7.3 (DM & RT-SOP), Shipping, WMS, Account Receivables, Account Payables, e-Commerce Gateway, WEBADI, OBIEE, BI Publisher

Languages

SQL, PL/SQL, C,C++, Java

Software Tools

PL/SQL Developer, TOAD, MS Project, MS office, Eclipse, JDeveloper

WORK EXPERIENCE:

Period

Project

Client

Position

May 2015 – Present

Planning Implementation

Grupo Bimbo

Techno Functional Lead

Project Description:

Implement Oracle Demantra and ASCP for Demand Planning and Forecasting process for various BU’s. Demantra Demand Management and ASCP will be used planning needs.

Job Duties:

Design and Develop custom programs to load data from ERP to Demantra

Design and Develop custom reports to manage exceptions using Webadi and BI Publisher

Work with stakeholders for collecting and designing the data flow within components.

Configure workflows for import and export of data.

Guide development team in CEMLI development

Design interfaces for forecast data from Demantra from other systems

Setup test environments

Develop Migration scripts for Production migration in Cloud environment

Support production deployment

Period

Project

Client

Position

Jan 2014 – May 2015

Demantra Implementation

Synaptics, USA

Techno Functional Lead

Project Description:

Implement Oracle Demantra for Global Demand Planning and Forecasting process. Demantra Demand Management will be used as a collaborative platform to meet the global demand planning needs of Operations, Sales, Business Units and Finance.

Job Duties:

Configure Date Model, Integration Interface, Workflow Manager, Rolling Data profiles and Worksheets.

Integrate Salesforce.com with Demantra to collect opportunities data into planning.

Work with stakeholders for collecting and designing the data flow within components.

Configure Waterfall Analysis worksheets of actuals vs. forecast demand to determine prior period forecast baselines and variances.

Configure workflows for import and export of data.

Design Worksheets and Series (Server/Client Expressions) as per requirements.

Provide Status updates to stakeholders and management

Project leadership through all phases including: Design, Build, Test and Deployment

Design interfaces for forecast data from Demantra to other systems

User Training

Conduct Status meetings, CRP sessions, UAT

Support production deployment

Period

Project

Client

Position

Dec 2012 – March 2014

EBIS – Gateway

Cisco, CA

Consultant

Project Description:

External Business Integration Services provides services to integrate with external partners. The scope of this project is to onboard partners (Contract manufacturers and Customers) and to automate transactions related to manufacturing and shipping.

Job Duties:

Work with stakeholders to provide a solution for Partner Integration

Co-ordinate with other tracks (Make, Deliver) on the integration points

Co-ordinate with Development and QA teams.

Project leadership through all phases including: Analysis, Design, Build, Test and Deployment

Provide Status updates to stakeholders and management

Support E2Open upgrade to 8.1.5 version

Prepare cutover plans

Schedule rehearsal for upgrade and rollback

Period

Project

Client

Position

July 2012 – Nov 2012

Supply Chain – LSS

Cisco, CA

Analyst-IT (PLAN Track)

Project Description:

Supply Chain Large Scale Services (SC LSS) is a business critical initiative comprised of standardized systems and technology that will enable enhanced commercial capabilities for Cisco. During this project the existing functionality (Order Scheduling & MRP) in 11i will be migrated to R12 in a phased approach.

Job Duties:

Support Q1 and Q3 Test environments under PLAN Track.

Design and Document MD 50 for various customization and Integrations with other systems

oOrder Scheduling Results (OSR)

oDemantra-ASCP integration

oEDI 830

Preparation of Q1 Cut-Over activities.

Work with off –shore team for MD 70s

Provide status updates on Defects and resolutions to the management team.

Co-ordinate with other tracks (Make, Demand Planning, ODS, BI) on the integration points

Period

Project

Client

Position

May 2012 – July 2012

R12 re-implementation Phase I

Sony Computer Entertainment America (SCEA), CA

Business Analyst

Project Description:

The Project is to re implement Oracle EBS R12.1.3 Version. Phase I is to understand the existing business processes and to gather requirements.

Job Duties:

Conducted design workshops to understand Sales As-Is Process and requirements.

Document As-Is process and RD30.

Preparation of MoSCoW list (requirements).

Document and list all customizations in current process

Period

Project

Client

Position

Jan 2012 – Apr 2012

BDA ERP Implementation

BDA Inc, WA

Project Lead

Project Description:

The Project is to implement Oracle EBS R12 Version integrated with Agile PLM, CRM OD and other external interfaces. The tracks include Procure to Pay, Order to Cash, Lead to Order, Design to Sell, Financials and integration with B2B.

Job Duties:

Conducted design workshops to gather business requirements.

Effectively negotiated design solutions with client on major gaps.

Managed, delivered all major project deliverables.

Led Conversions design and extracts from legacy system “YODA”

Led off-shore resources in complex RICE development.

Project management of day to day activities (risk log, mitigation log, task tracking etc.).

Period

Project

Client

Position

Nov 2011 – Dec 2011

Mexicali Setup – Phase II

SunPower Corp, San Jose, CA

Functional Lead

Project Description:

The Mexicali Project at SunPower is a multi-phase implementation of Oracle Release 12.1.3 E - Business Suite software applications in the new plant at Mexicali. Project involves implementation of Oracle modules such as OM, AR, BOM, WIP, OSFM activities and user training.

Job Duties:

Led the implementation of Oracle WIP, BOM and Order Management.

Conducted design workshops to gather business requirements.

Effectively negotiated design solutions with client on major gaps.

Managed, delivered and evaluated financial risk for all major project deliverables.

Led off-shore resources in complex RICE development.

Configured WIP, BOM and OM modules, conduct CRP's and get client buy in for all proposed solutions.

Project management of day to day activities (risk log, mitigation log, task tracking etc.).

Improved business processes in areas that need significant directional change and provide change management expertise.

Period

Project

Client

Position

Apr 2011 – Dec 2011

Automation of Commercial Flow

SunPower Corp, San Jose, CA

Functional Lead

Project Description:

The purpose of this Project is to align the physical material flow with the system for the intercompany transactions and automating the commercial transactions through automation.

1.) Eliminate the intermediate IR/ISO.

2.) Automate intermediate AP/ AR transactions.

3.) Complete control with Finance & Tax for the shipping patterns.

4.) Key Modules involved here were Purchasing, Order Management, Shipping, Inventory, AP, AR and SLA.

Job Duties:

Led the forum to define shipping patterns and conducted workshops for data collection.

Defined metrics and SLA’s to the business team.

Identified and managed high priority gaps.

Conducted multiple training sessions for the users across the globe.

Smoothened transition without effecting operations.

Prepared high quality deliverables (training guides, adoption metrics, As Is / To Be Processes).

Project Management with effective communication on the status of the project.

Period

Project

Client

Position

Nov 2010 – Mar 2011

MRP : MES Integration

SunPower Corp, San Jose, CA

Manufacturing Lead

Project Description:

MES Integration is the part of the whole MRP implementation and is to integrate the existing Shop Floor System by Light House with Oracle EBS. The scope of this integration is to integrate Items, BOM, Routings, Material Usage, Scrap, Rework transactions between WIP, Quality modules in Oracle EBS and Light House MES system. Integrated with Quality Module for Solar Panel test data.

Job Duties:

Led the Oracle WIP, Quality and MES System solution design for Manila Module Manufacturing Plant.

Conducted design workshops to gather requirements and map AS IS Process.

Performed a fit gap analysis for all the business requirements.

Designed the process to manage exceptions.

Reduced Production downtime during month end close process.

Led the off shore development team.

Lean BOM and Inventory cleanup process.

Led conference room pilots to demonstrate solutions for complex business processes and multiple UATs with the users.

Period

Project

Client

Position

Jun 2010 – Oct 2010

Poly/ Wafer Procurement Process

SunPower Corp, San Jose, CA

Project Lead

Project Description:

This project is the setup a process to manage Poly Distribution based on the contracts with the suppliers and setup OSP process to track Ingots and wafers procurement.

Job Duties:

Design Oracle WIP, BOM and Purchasing and ASCP solution for Manila FAB.

Conduct design workshops to gather requirements and map AS IS Process.

Perform a fit gap analysis for all the business requirements.

Coordinate with off shore development team.

Define BOM and Inventory cleanup process.

Lead conference room pilots to demonstrate solutions for complex business processes and multiple UATs with the users

Period

Project

Client

Position

Sep 2010 – Feb 2011

OSP Process implementation for Contract Manufacturers

SunPower Corp, San Jose, CA

Project Lead

Project Description:

This Project is to enable the OSP process and rollout the solution to the entire contract Manufacturers which Include Flextronics USA, Schweizer Swiss, JBil Mexico, JBil Poland, Sun Energy China.

Job Duties:

Led the Oracle WIP, BOM, Purchasing solution design for SunPower’s Contract Manufacturing Process.

Conducted design workshops to gather requirements and map AS IS Process.

Perform a fit gap analysis for all the business requirements.

Reduced Production downtime during month end close process.

Define BOM and Inventory cleanup process.

Led conference room pilots to demonstrate solutions for complex business processes and multiple UATs with the users.

Period

Project

Client

Position

Apr 2011 –Nov 2011

EDI Phase -I

SunPower Corp, San Jose, CA

Project Lead

Project Description:

This Project is to implement EDI 204,214 and 861 transactions for 13 warehouses managed by 6 different 3PL across the globe. The transactions include Carrier Load Tender, Ship confirmation based on delivery confirmation and automate PO / IR receiving.

Job Duties:

Design Oracle Purchasing and Order Management solution for SunPower’s 3PL communication.

Conduct design workshops to gather requirements and map AS IS Process.

Perform a fit gap analysis for all the business requirements.

Coordinate with off shore development team.

Roll-out solution across multiple Business Units.

Conduct conference room pilots to demonstrate solutions for complex business processes and multiple UATs with the users.

Period

Project

Client

Position

Apr 2009 –Dec 2009

ENI-JR286 Entity Setup

JR286 Inc, Redondo Beach, CA

Analyst

Project Description:

JR286 Inc is the licensee for Nike fitness products. This Project is to setup new entity to manage Nike business.

Job Duties:

Implement Inventory, OM, WMS, AP, AR, GL and e-Commerce gateway modules.

Implement Shipping Label solution to generate UCC128 labels.

Implement 850 (I), 856(O) and 810(O) EDI transactions with multiple trading Partners (Customer).

Implement multi-Segment Item solution for easy identification of items by brands.

Led conference room pilots, UAT sessions and user training.

Period

Project

Client

Position

Jun 2006 –May 2010

Implementation of Oracle EBS and support post production

JR286 Inc, Redondo Beach, CA

Analyst

Job Duties:

Implement and support OM and e-Commerce Gateway Modules.

Functional support in Inventory, OM, Shipping, WMS, AP and AR modules of Oracle EBS (11.5.10).

Managed, Monitor and maintain both Master data and Transactional Data like Customers, Item uploads, Price Lists, Orders Inbound, ASN and Invoice Out bounds using Gentran and e-Commerce Gateway.

Designed and developed Custom applications to meet new Customer / User requirements.

Communicated with Customers, understand specifications and develop Maps to integrate Systems using EDI so as to reduce delays and human errors because of Data Entry.

Defined Design and Develop new business processes to reduce cost.

Handled exceptions in both transactional and Master Data.

Managed Interfaces built to handle transactional data with Trading Partners which include Customer, Suppliers and Banks.

Designed and developed interfaces built for UPS and FEDEX Systems integration.

Configured / Generated shipping Labels as per Customer specification using Zebra Labels and Nice Labels.

Ad-hoc reporting required for Top Management and support all reports built to generate Customer facing Documents like Purchase Orders, Sales Order Acknowledgements, Packing Slips, Bill of Lading, Commercial Invoice, Invoice etc.

Uploaded Inventory status to customers and Item information for Price Stickers.

Built alert notifications to notify users to avoid potential charge backs.

Managed Reports Security by defining Proper roles and responsibilities.

Conducted User trainings and Created User Manuals on Applications and reports usage.

Communicated with and managed Offshore Team to track new developments and issues statuses.

Period

Project

Client

Position

Apr 2008- Feb 2009

NA

Triniti Corporation

Support Manager

Job Duties:

• Managed application support team to provide technical services to all Triniti Global Customers which include Sony Semi-Conductors, Qualcomm, CSR, Cavium Networks, and Pixel Works etc.

• To act as a bridge between Customers and the team members in understand requirements and issues.

• Resource allocation and Task Prioritization.

• Managed resource work load to meet delivery dates.

• Requirements and User Manual Documentation.

Period

Project

Client

Position

Nov 2005- Apr 2006

Logistics Tracking System

Chiquita Brands International

Architect & Lead

Project Description:

The Project was designed to develop an application to provide Visibility on the Products in-transit so that the users can plan on docking spaces, resource requirement and any other items needed for Value added services, which in turn gives visibility on the delivery dates to their customers.

Job Duties:

• Interacted with Users and understand Business requirements, Design Solution, create Technical Specifications.

• Developed Forms using JSF to enter in-transit information.

• Conducted user training and develop User Manuals to end users.

• Created and executed functional test cases.

• Developed custom forms using JSF to handle exceptions.

• Automated the retrieval of Shipment tracking information from QTS Rail Transport system.

• Designed and Configured email alerts with escalation to notify users on exceptions at various stages.

Period

Project

Client

Position

Feb 2005 - Oct 2005

Planning Data Analyzer

Triniti Corporation

Solution Architect

Project Description:

Triniti Planning Data Analyzer is Triniti Proprietary Product designed and developed mainly to manage Data Quality. Using TPDA (Triniti Planning Data Analyzer) user will be able to define KQI (Key Quality Indicators) with tolerances to maintain data Quality and KPI (Key Performance Indicators) to identify key items with high revenue or high usage and to maintain data quality for those items. Based on this TPDA output user will be able to judge if the data can be used to run demand plans. The key features include alerts, scheduling of KQI’s, audit trial, Graphs to show trends etc. on key items which can impact demand planning.

Job Duties:

Designed and developed Triniti Planning Data Analyzer.

Prepared BSD’s, Creation and execution of functional and unit test cases.

Database design to store set-up details and key transactional data for auditing.

Designed and developed Go/No Go Module to identify high impact end items and set tolerance values.

Alerts module to send email notifications to users on KQI’s which are either failed or exceeded the tolerance values.

Designed dashboard with which the user can focus on key KQI Items which can impact demand planning based on Red, Yellow and Green buttons.

Designed and developed custom form using JSF to include or exclude specific items manually which might not impact demand planning.

Designed graphs using JFree Charts to show the trends of various key items which include Plans, Items, and Exceptions etc.

Developed program to identify components for an FG which can impact Key KQI’s and which are having either High Revenue or Maximum Usage.

Period

Project

Client

Position

Mar 2003 – Jan 2005

--

Triniti Corporation

AMTS /Lead/ Associate

Main responsibility was to design and develop Triniti’s tool Triniti Data Viewer. Also responsible in conducting Product Demos to various Clients discuss and design interfaces to integrate with all Triniti Products mainly used for master data creation and maintenance in Supply Chain.

Triniti Data Viewer is a reporting tool with and updates functionality built on Triniti’s Application Builder using Java Swings, Servlets and JDBC technology. The key features of the tool are:

• Web Based application to access reports.

• Access level security at both User and Responsibility levels.

• Data will be shown in Tabular Format.

• Drag n Drop – To create filters on the data available in the report.

• Configuration Module – To configure new Reports / Modify existing reports.

• Conditional Coloring – To color the data in a cell based on user Conditions.

• Export to excel – To export data into excel including conditional coloring.

• Format Save – the visual representation of the report can be customized and saved at user level.

• Schedule – Reports can be scheduled to run to take snapshots.

• Cross Tab Data Representation (Pivot Table).

• Integrated with all Triniti Products like TPM, TWM and Tri2.

• Integrated with JFreeCharts.

Period

Project

Client

Position

May 2001 – Jan 2003

--

Central Library – IIT Kharagpur

Junior Project Assistant

Main responsibility was to design and develop application to handle daily operations at Central Library using Oracle web dB, JavaScript, HTML, and PL/SQL. Also developed various scripts to extract data from legacy system and imported in to this new application. Conducted user training and prepared user Manual documents. The Key features of the application are:

• OPAC – Online Public Access Catalogue to search books and Journals based on key words, authors and publishers and to know the availability.

• Acquisition Module: To Handle Purchasing and Receipts of Books.

• Circulation Module: To handle books Issue, Returns and Renewals.

• Catalogue Printing: Printing Catalogue cards based on the keywords.

• Reports: Created Reports on Various data elements required for Chairman, Librarian and for Deputy Librarians.

Contact this candidate