SUMMARY:

10 years of IT experience. 7 years of Oracle Applications ERP experience on various versions (11.0.28, 11.0.3 & 11i è 11.5.10.2) and 3 years in customizing and implementing custom ERP for various clients.
.
Oracle Apps Skills:
Extensive knowledge of almost all major functional areas in Oracle Apps including Manufacturing, Order to cash, Procure to pay life cycle, warehouse management, EDI process, & supply chain solutions.

• Extensive 11i Upgrade Implementations experience (version 11.5.10.2). ). Extensively worked on pre-upgrade & post-upgrade activities during upgrade related to application side.
• Delta transactions for 11i upgrade: Implemented MV Logs to capture oracle transactions during the 11i upgrade. Also developed scripts to load the captured transactions back to oracle base tables.
• Purge/Archive to tape: Experience in purge to archive & archive to tape for oracle applications tables.
• Experience in Oracle replenishment process.
• Experience in extending self-service applications using OA Framework (Jdev forms), Oracle Workflow.
• Experience in setup/ configurations & Oracle System administrator activities.
• Experience in Order to Cash oracle life cycle.
• Experience in PO process & Procure to pay life cycle.
• Experience in AR (Accounts receivable) & AP (Accounts payable).
• Experience in Warehouse management system.
• Worked extensively on Item process, manufacturer part & subparts creation process.
• Good working experience on form personalization.
• Experience in using Oracle tools to integrate various legacy applications with Oracle Apps.
• Experience in Forms, Reports, Interfaces, Customization & Extension.
• Oracle Patch Management: Identifying latest patch, patch analysis, TAR follow up and bug fixing for any issues.
• Auto Loading to Oracle tables through shell scripts/ sql*loader.
• Experience in Oracle Periods Open / Close.
• Strong technical and functional knowledge of Oracle application modules OM, Shipping, INV, PO, Warehouse management system, Accounts receivable (AR), Accounts Payable (AP).
• Familiar with Financials GL modules & GL postings.
• Familiar with iStores module.
• Experience on new customers implementation supporting on initial requirement gathering, design, proof-of-concept on process change & providing support during customer testing.
• Good understanding of SDLC methodology & change management process.
• Have experiences on writing technical & functional documents, test plans/ cases, unit testing on many of the processes.

SKILLS: ERP: Oracle Applications Rel. 11i (11.5.10.2), 11.0.3, 11.0.28

Oracle Manufacturing: Oracle Manufacturing: Inventory, Order Management / Order Entry, Shipping, Accounts receivables (AR), Purchasing, Accounts payable (AP), BOM, Oracle Alerts, Oracle System Administration and AOL
Languages: Working experience in SQL & PL/SQL, Unix programming, shell scripting, knowledge in COBOL
Database: Various versions of Oracle database from oracle 7.3 to oracle 10g
Operating System: Unix (Solaris, HP), Linux, Windows NT/98/2000/XP
GUI: Developer 2000 (Forms 4.5/ 5.0/ 6i , Reports 2.5/ 3.0/ 6i),
Tools: PL/SQL, SQL*Plus, SQL*Loader, SQL Navigator, TOAD, JDeveloper with OA Framework, Oracle Workflow
Utilities : Oracle utilities such as SQL Loader. Apps utilities such as FNDLOAD, WFLOAD
Configuration Management Tools: Kintana, PVCS 7.5, Team Tracker, CC Manager, winscp3, putty.

Work Authorization:
Authorized to work in: U.S (EAD / H1 Visa) and India.

EXPERIENCE:
Details in reverse chronological order:

1. Techno Functional Consultant at Confidential,GA from 05/2005 to Current
(Employer: Confidential,Troy, Michigan, USA)

UPS-SCS is a global leader in providing supply chain solutions involving a vast array of services, including transportation/freight/logistics/global distribution and post-sales service parts logistics. The service parts logistics group is supported by SPLUS - a set of applications encompassing Oracle Order Management (Vantive/RTM/ERP), Inventory Management (Oracle ERP), Warehouse and Shipping (Connectware /ERP). As an external Senior ERP consultant, achieved implementing Oracle 11i (version 11.5.10.2) for Inventory Management. Some of the major roles included:-

• Currently working on purge & archive to tape project. Involved solely in design, development & testing of Oracle, Vantive & Connectware table data purge.
• Extensively worked on Item creation process & interface. WE built wrapper around the standard process (Item interface - INCOIN) to make the item process available for batch processing with parameterized control & also making this available for immediate mode. I am quite comfortable on public API\'s(ego_item_pub) for the item process. Also worked on manufacturer part process, substitute Part process.
• Worked on PO interface, Requisition interface for the PO process (Batch & Immediate mode). Even i have good work experience on setups for PO, INV & OM.
• Worked on receiving setups & handled receiving against PO & ASN.
• Handled oracle order life cycle in UPS.
• Having good experience on receiving transactions, shipping transactions & inventory transaction including move order transactions and good experience on internal order, Drop ship orders, Back-to-Back orders life cycle.
• Solely designed and coded customization to create custom shipping API which is called by Connectware application with XML (order & shipping) input parameters & XML output with success or failure for warehouse application systems.
• Move Order Process: For the 11i ERP upgrade project, designed and developed custom Move Order API’s to support OMS reservation process.
• Experience in extending self-service applications using OA Framework (Jdev forms), Oracle Workflow.
• ERP SO/Transient Purge: Developed custom solution integrated with Oracle ERP to purge Sales order related/transient data. The transient data purge provides the flexibility to purge transient/Interface tables by setting up control tables, with purge parameters – Duration to hold data for maximum records to purge, transient tables to purge.
• MO / INV Transaction purge: Worked on this process to purge aging MO/ INV related transactions.
• Worked on several new customers implementation supporting on initial requirement gathering, design, proof-of-concept on process change, system setup data, Items, PO, manufacturer parts, sub part loading etc & providing support during customer testing.
• Implemented custom replenishment process (RR & FIFO method) to handle replenishment activities within warehouses across different organizations.
• Worked on Oracle Period Open/ close for year ending activities.
• Coded several forms, reports, PL/SQL packages and triggers, UNIX shell scripts and also apps objects like – Executable, Conc. Program, request set, menus, value set, profiles, request gr., responsibility, registering table & columns, new users, flex fields & other AOL objects.
• Worked on form personalization to force the reason code for standard MMT form & also made changes to few custom forms.
• Worked as an Oracle Application consultant, doing the setup/ configuration, pre/post upgrades activities during 11i upgrade project (version 11.5.10.2) from 11.0.3.
• Upgraded custom forms during 11i upgrade.
• Implemented MV Logs to capture oracle transactions during the 11i upgrade. Also developed scripts to load the captured transactions back to oracle base tables. Business was uninterrupted during upgrade & missing online transactions were inserted back to upgraded system through DELTA MVLOG process.
• Support set up issues: Carrier, Level of service, customer, vendor, flex field setups etc.
• Created .LDT file for the code promotion related to Value set, Menus, Conc. Program, profiles etc.
• Analyzed Oracle functional patch, debugged issues, done follow up task with Oracle on TAR & involved on post patch support issues, SQL tuning.
• Support: providing ongoing technical support to all ERP related issues.
• Requirements Analysis: Performed gap analysis on several business processes by interacting with functional users. Created MD70 (technical) documentation, for the above mentioned processes and underwent technical and management review. Created test plans, and undertook system and unit testing for many of the process

2. Technical Consultant at Confidential,CA from 11/2002 to 05/2005
(Employer: Confidential, Santa Clara, CA, USA)

Applied Materials is one of the world\'s leading information infrastructure providers helping Semiconductor manufacturers to produce powerful, portable and affordable chips. Objective of the CAST Oracle Manufacturing projects is to support, sustain and continually improve the existing oracle distribution and manufacturing Applications system on Release 11.0.28, 11.0.3 for uncompromising business continuity. List of major role included: -

• Developed and implemented plans for legacy data conversion.
• Extensively involved on procure to pay cycle.
• Involved in data mapping and data conversion for Items, Bills of Materials and Routings.
• Worked on Order Import interfaces to identify & debug the problem in Order Processing
• Worked on Accounts receivable (AR) interfaces and PL/SQL APIs (Customer Interface, Receivable interface, Auto Invoice, AR Interface for single invoice, lockbox etc).
• Accounts payable (AP) module (Payable Open interfaces & Payable invoice import, period open/close), & fixed asset module.
• RMA Interface program – Analyzed the RMA program & supported issues related to RMA. Good knowledge of RMA cycles both functionally & technically.
• Created a new concurrent program to push the cycle status of order line as per the business requirement.
• Disable all newly created users that do not activate in Oracle in last 90 days and Security feature in the Oracle Logon screen to lock-out any user that tries to logon unsuccessfully for more than 3.
• Worked on few alerts to make the support application more efficient.
• Tech-functional troubleshooting of the Shipping Execution (WSH), Order Entry (OE), and Inventory modules within Oracle Applications. Also supported for day-to-day Sales activities related to Drop Ship Orders, Internal Orders and RMA orders.
• Good experience of oracle application developer’s task (creating menus, form function, request group, responsibilities, users, Value set, Profiles, Flexfields etc).
• Worked on various report customizations :-

Pick slip & Pack slip report, Inactive item report, Customers ageing item report, Customers order summary report, Back Order report etc.

• As onsite coordinator, managed customer expectations, guided the customer in making several decisions related to the apps implementation & support.
• Coordinated daily development activities between onsite consultants and offshore developers.
• Involved in user manual documentations and user training at customer sites.

3. Oracle Apps developer at Confidential,Thailand-Bangkok from 12/2001 to 11/2002
(Employer: Eastern Software Systems ltd., New Delhi, INDIA)

Tsutaya was first established in Japan in 1983, the largest video franchise and aiming at the creation of Tsutaya franchise chain throughout Bangkok and other cities in Thailand. Objective of oracle custom ERP “Ebizframe”, is to provide the best industry solution on video online rental & taking care of customers request online & supporting on customer billing solutions. Project involved coordinating offshore activities with onsite, status reporting and enhancement on reporting activities. Team’s responsibility was to work on the business enhancements functionalities & continual support on the existing systems. Efforts include analysis, enhancements and resolution of problems faced by the customer. Activities involved mostly customizations to Inventory and purchasing modules reports / interfaces.
Major role included:-

• Implemented oracle ERP “Ebizframe” at client’s place.
• Customized the aged inventory reports with Locators, Receipt Transactions Report, Item reservation report, item quantities summary report etc.
• Worked on interfaces and PL/SQL APIs (Open Item interfaces, order interfaces) to match the change in business functionality and also worked on item receiving transaction interfaces.
• Customized PO Approved Supplier List Report, Aged open PO report , vendors on hold report , Purchase order listing Report & over shipment reports etc.
• Developing SQL Loader control scripts to process the legacy data and to load them into temp staging area.
• Documentations related to customization in oracle business process functionality.
• Comfortable on other activities: - Creation of values sets in various modules of the application, Alert Creation & testing , defining concurrent programs, executables, PL/SQL method of submitting Concurrent programs.
• Reduced high priority bug backlog to a minimum level.

4. Oracle Apps developer at Confidential,Bangalore, India from 09/2000 to 12/2001
(Employer: Confidential, New Delhi, INDIA)

The Project involves Implementation of Oracle Custom ERP package “Ebizframe” at WadPack Pvt. Ltd., a Bangalore based Paper Box manufacturing company. Wadpack Pvt Ltd. is a market leader of paper box industries. The scope of the project included implementation of module Sales, Inventory, Finance & Purchasing in the organization etc. Responsibility includes:-

• Involved in all aspects of requirements gathering to implementation.
• Implemented oracle ERP “Ebizframe” at client’s place.
• Coded several forms, reports, PL/SQL packages and triggers, UNIX shell scripts.
• Developed and implemented plans for legacy data conversion and user training at customer sites.
• Resolved several critical support issues.

5. Oracle Apps developer at Confidential,Bangalore, India from 11/1999 to 09/2000
(Employer: Confidential, New Delhi, INDIA)

The Project involved implementation, Customization of Oracle custom ERP package Ebizframe” at Bangalore, a Jewellery sales & marketing company. Our package takes care of their Inventory, Finance, Purchasing & franchise module for their franchisee point of sales plus the web development to facilitate the complete business.

• Unique part of this project was two-way data replication, between the corporate office & the Point of Sales (PoS). Client’s PoS which are located at different parts of India refresh their data with head office at Bangalore through replications mode only by connecting to the Internet.
• Handled franchise module form customization– cash memo, sales refund, lost sales, walk in, advance receipt / exchange, Customer order booking & stock verification etc.
• Handled reports customization on inventory & purchasing module.
• Developed and implemented plans for legacy data conversion and user training at customer sites.
• Supported production issues & documentation on process flow.

Manufacturing Industry Experience

Senior Engineer at Confidential,Jamshedpur, India from 10/1996 to 10/1999.

Tinplate Company of India is a part of TATA group of companies & leader in steel industries. Responsibilities handled:-

• Inventory management, Planning & maintenance of steel manufacturing industry.

Corporate Affiliations:

• Confidential,Troy, Michigan, USA (May’2005 to Current)- System Analyst.
• Confidential,Santa Clara, CA, USA(Nov’2002-May’2005)- Senior Programmer
• Confidential,New Delhi, INDIA(Nov’1999-Nov’2002)- Senior Programmer
• Confidential,Jamshedpur, INDIA (Oct’1996-Oct’1999)- Senior Engineer

EDUCATION: B.E (Electrical Engineering)

trainings:

• TCS Quality Management System (QMS)
• SEI CMM Awareness Training
• Project Risk Management
• AMAT Security Management
• Quality and PCMM Training