Project Oracle

Anup Kumar Manepure

*****@********.*** // 510-***-****

Profile Summary

. Dynamic and accomplished professional with more than 9+ years of

proven IT Operation and Project Management experience with strong

credentials and international exposure in end-to-end Implementation,

maintenance, migrations, upgrade and integration of Oracle E-business

Suite.

. Have been working in Oracle Apps SCM - ASCP (Advance Supply Chain

Planning), Demantra, Purchasing,iSupplier, PIM - (Product

information Management ) modules for client Navistar Inc, USA.

. Possess strong Oracle apps financials GL, AP, AR, OM, Purchasing,

iSupplier, Inventory, PIM modules, OTC(Order to case), P2P(Procure to

Pay), ASCP, PIM,

. Possess strong technical' s in Oracle 9i/10g/11g, SQL, PL/SQL, Unix

Shell Scripting, Oracle forms, reports, Workflow, BI tools like

Business Objects XI and Oracle discoverer.

. Lead a team as Project Leader in major full cycle implementations and

end-to-end business support projects within the assigned time, cost

and with quality parameters.

. Providing standardized and global solutions to specific, segregated

and customized business processes, performing feasibility analysis,

impact analysis, RCAs, proof of concepts for complex business problems

and issues.

. Proficient in maintaining relationship with key customers, identifying

& sourcing new business, delivering quality service and attaining

customer satisfaction.

. Developed complex PL/SQL Packages, Stored Procedures, Functions,

Database Triggers and SQL * Loader scripts and tuned (PL/SQL) using

SQL Trace, Explain Plan, TkProf, AWR report, Indexing and Hints.

. Design & Development of Interfaces, Conversions, Migrations and

Customizations programs to import data from legacy systems and

integrate it into Oracle Applications and ETL using open interfaces,

Appworx, APIs and UTL_FILE Packages.

. Worked as a Technical solution Architect for up-

gradation/implementation - GL, AP, AR, FA, Purchasing,PIM, ASCP

modules of Oracle Applications.

. Experience in successfully handling Multiple clients and Projects.

. Being involved in Project Management Activity :

DART reporting, Project status reporting, Client WSR,

Team's Week work plan.

Onsite/offshore Management.

Peer Review's for Deliverables documents.

Deliverables Estimation & Planning

Project Process Improvements.

. Certification:

Green Belt Certified (Six Sigma Methodology).

Passed the exam - Oracle 11i E-Business Suite Essentials.

Certification

Certification of Oracle ASCP and Demantra oracle training attended.

Technical Skills:

ERP : Oracle 11i & R12

Data Bases : Oracle 9i/10g/11g

Language : SQL, PL/SQL, Unix shell scripting

GUI : SQL*Plus, Forms, Reports, Workflow

Other Tools : PL/SQL Developer, TOAD, Putty, Psftp,

wincsv, Control-M

Operating Systems : UNIX, Windows NT/XP/98/2000/VISTA

Business Intelligence : Business Objects XI, Oracle

Discoverer

Others : Clarify, Maximo,

MS-VSS, WinCvs for source code control.

Qualifications:

. Master of Computer Applications : (MCA) from Government Eng. College

(NIT) Raipur(C.G.), year 2003.

Professional Experience and Project Details:

Duration - (July 2010 to till Date)

Client : Navistar, USA

Location: Lisle, IL (USA)

Navistar Inc, USA. is a leading international Truck and Engine corporation

and one of the largest global manufacturers of medium-heavy duty trucks and

mid-range diesel engines. Multiple divisions handling trucks, engines and

parts.

Project & Role Description : Working as a Team lead/Team Member, Demand

management meeting to prioritize the work, work distribution among the

team, Business requirement Analysis design, development, and migration.

Project : Oracle Apps Ebiz R12 - ASCP(Advance Supply chain planning),

Demantra, Purchasing, iSupplier, PIM ( Product information Management)

and Inventory Support Project.

. Integrating new businesses and data from across the various business

entities.

. Providing maintenance, support and enhancement on application(s).

. Support, Development, enhancement on Supply chain planning solution

which decides the supplies and demands based on that Inventory is

managed and Purchase order deployed within an extended supply chain.

. Support on Demantra forecasting processes, collection and ASCP Plan

processes .Jobs are running through Control-M tool, process

monitoring.

. Process performance Improvements for ASCP, Demantra jobs, Collection

process and Demantra forecast job by doing sql tuning using SQL Trace,

Explain Plan, TkProf, AWR report, Indexing and Hints.

. Supporting PIM ( Product information Management ) processes, NIR (

New Item Requests), Change Order, Item-People Role associations and

privileges processes and Item interfaces, ICC(Item Catalog Categories)

structure, modifying User defined attributes on business requirement,

BOM Creation. Extensively worked with Oracle to streamline PIM

standard processes.

. Educate the client to understand the business processes like ASCP PO

recommendation, PO creation, PO receipts, supporting planners on ASCP

plan recommendations and for generating POs,

. Analyzing and Fixing issues for any inconsistencies on demand and

supply across SCM modules and PIM item Creation processes etc.

. Enhancement, New business requirement, Analysis, Design, Developments,

testing, documentation and migration.

. Extensively involved in Problem Analysis, Design, Build, Unit and

Regression Testing for data and code fixes, configuration and

deployment management, enhancement analysis.

Project : Oracle Apps Ebiz R12 - PIM ( Product information Management)

implementation Project

. Complete Implementation of Oracle Product Information Management (PIM)

module, Multiple interfaces have been built to integrate different

legacy system.

. Built the interface for Cross references, Related item, Manufacturing

items, BOM(Bill of Material Interface), ICC structure conversion

process, stream line NIR, Change Order process.

. Implementation and Support PIM ( Product information Management )

processes, NIR ( New Item Requests), Change Order, Item-People Role

associations and privilege processes and Item interfaces, ICC(Item

Catalog Categories) structure, modifying User defined attributes on

business requirement, BOM Creation. Extensively worked with Oracle to

streamline PIM standard processes.

. Built a Generic interface script to make it common for all the

interfaces resulted as cost saving.

. UDAs/DFF, Values sets Creations on business needs.

. Interface built for Cross references items, Manufacture cross-

references and Related items data. Built the data conversion scripts.

. Trigger relationships from data keyed at NIR(New Item Request)

process.

. Implementation of publish interface updates to different legacy system

like NPSU and TsOLAS.

. Control publication to different systems.

Duration - (Aug. 2006 to May 2010)

Client : GE Commercial Finance, GE Capital (USA)

Location : Danbury, CT (USA)

GE Commercial Finance is the branch of GE(General Electric) which deals in

Commercial Finance business. The project deals with support and maintenance

of the Oracle Applications Financials Instances of GE Commercial Finance

worldwide.

GE Capital global vision is to integrate and consolidate all its business

under same common GE standards (GSS) with common Chart of accounts, Tax

rules, reporting aspects etc. . Business consists of EFS (Energy Financial

Services), GECAS (Aviation Services), CRE (Commercial Real Estate),

Consumer Finance and Commercial Lending and leasing businesses and is a

worldwide provider of leases, direct loans and a wide variety of financial

and equipment management services.

Projects : GECF Global Oracle Apps Support, Business - Cap Sol, CEF and VFS

Support, Upgradation, Implementation and Development

Project

Worked on : Oracle Apps- GL, AP, AR,FA,Purchasing, Order management.

OTC(Order to case), P2P(Procure to Pay),

SQL, PL-SQL, Oracle Forms, Report,Unix shell, BO XI, Oracle Discoverer.

Project & Role Description : Worked as a team lead/Team member, team

management, Business requirement Analysis, Managing, coordinating,

planning and executing the project.

. Implementation and Support for GL, AP, AR, FA and PUR Modules, WEB

ADI, Discoverer and BO tools for GE CEF, VFS and Capsol business.

. Planned, Managed and Coordinated Discoverer upgrades, application

upgrades, server upgrades and Database upgrade.

. Planned, designed and developed data migration strategies to integrate

GL, AP, AR and FA data into existing businesses and as well as new

businesses.

. SQL tuning to enhance the performance of customized PL/SQL

programs/Interfaces,

. Monthly and biweekly pitch preparation, project status reporting and

SLA discussions with client

. DR solution planning, coordinating, testing and obtaining Business

sign-off

Define the executable, concurrent program and scheduling the weekly

and monthly program.

. Interfaces developed to interface GL, AP, AR, FA, PO related data to

oracle using PL/SQL scripts, unix shell scripting and workflow.

Extensively involved on creating Inbound and outbound interfaces based

on client requirements.

. Defined value sets and DFF, Created request sets, responsibilities,

request groups, security rules and cross validation rules and request, request groups.

. Supporting Month Close activities as defined by the Business.

Organization: Easter software system Pvt. Ltd. Mumbai

- Mar. 2005 to Jun. 2006

Jupiter Web Solution, Delhi

- Jan. 2004 to Feb. 2005

Location : Mumbai

I worked as a software Engineer with Estern Software system Pvt. Ltd.,

Mumbai. I have been working here in ERP EbizFrame with the various

financials modules Finance, Sales, Purchase, Inventory. I extensively

involved on implementing and developing a whole new life cycle based on the

client requirements. Few clients I have worked for and implemented the ERP

as follows.

Hindustan Coals Ltd,Mumbai

WWS SKY SHOP Pvt. Ltd. Indore (M.P.)

MultiArc Pvt. Ltd., Pune

Worked on : Oracle SQL, PL-SQL, Oracle Forms, Report

Roles and Responsibilities:

. Database designing, Coding, creating forms and reports.

. New Development for sales module the complete life cycle for

MultiArc India Ltd., Development of New forms, reports etc.

Wrote stored procedures, functions and packages in PL/SQL.

. Analysis the sales Cycle for WWS SKY SHOP PVT. LTD. And

developed the new cycle of sales module,developed the new forms

and oracle reports.

. Customized Standard Oracle Reports and built custom reports

using Oracle Report builder 6i and integrated them with the

application to solve the client's reporting needs as per

Business Requirements.

. Full involvement in day-to-day activities of system and Support

users by solving their problems related to day-to-day

Activities.

. Tune existing reports to improve performance speed and execution

time.

. Analysis, Design, Development, Testing, Documentation, Debugging

and Trouble-shooting.

. Worked for Jupiter web solution, Delhi for the client Urastum

Metal Pvt. Ltd. Delhi. Have implemented oracle forms, Reports

for the ERP being used for the client. I was involved in

Database Design, coding, development, testing and migration.

Contact this candidate