Project Manager System

ADITYA PAMULAPATI

Summary:

Eighteen years of experience in Information Technology which encompasses

all areas of the Software Development Life cycle from requirement gathering

to post implementation support. Out of the 18 years of experience 17 years

are in discrete manufacturing environment. Extensive experience in ERP

system products like Control (Cincom), ORACLE 11.5.10 and11i.

ERP Packages: Oracle 11i, Oracle 11.5.10.2 system, CONTROL (1.5.1) Unix

version and CONTROL VMS version from Cincom

BANNER system from SCT, Databases: Oracle 9i, Oracle 7.3, Total, Supra,

Oracle 8.1.7.3

Front End Tools: Developer 2000, Forms 4.5, Oracle reports 6i, Oracle Forms

6i, Designer 2000, TOAD, APPWORX, CITRIX

Programming

Languages: COBOL, FORTRAN, Pro*COBOL, Pro*c, SQL, PL/SQL, JCL, DCL, Mantis

OS: VAX VMS version 7.1, MVS, Windows NT, VSAM, CICS, TCL AND TSO, UNIX

version 5.1a

Databases : Access, Supra, Oracle 10.2.03 64bit Enterprise edition.

Work Status: I am a permanent resident (green card) and can work legally in

the U.S.

Total Life cycle implementations: 6 life cycle implementations of Oracle, 4

in US, 1 in Japan and 1 in UK

Professional Experience

04/2006 - Present SMITH MEDICAL Keene, New Hampshire

Business Analyst

Configure Oracle Inventory, BOM, WIP, Cost, Shipping and Routing modules

to suit Smith Medical manufacturing practice.

Create and maintain BR100's for INV, BOM, WIP, Cost and Routings.

Created UAT scripts for D2B (Demand to Build) modules.

Trained users in all the modules of D2B

Create and manage service request when needed help from Oracle in solving

production problems.

Research and resolving problems that user encounter on a daily basis in

different Oracle modules (ITEM, BOM, SHIPPING, WIP, ROUTINGS and COST).

Monitor daily WIP, Shipping, and Inventory transaction so the month end

closing process will be smooth.

Research and resolve stuck transactions.

Defining Units of Measure, Locations, setting up Inventory Organizations,

defining Sub inventories, check Item attributes and Creating Items.

Define cost types, assign items to cost types, resources, rates and assign

resources to departments and create routing.

Wrote instructions on how to perform Std. Cost roll. Assisted plant

controller with the yearly cost roll up, roll over and standard cost

update.

Created MD50 documents and handed them over to the development team.

Worked as a project manager on the implementation of complaint tracking

system (Smart Complaints) from Pilgrim.

Participate on regular basis in Change control meeting to manage and

implement changes to the Oracle ERP system.

03/2004 -04/2006 FLEETGUARD Cookeville, Tennessee

Business Analyst

Support BOM, MPS, MAT, MRP, PUR, SFC, and CMS modules in CONTROL ERP system

Involved in evaluating security features on in house developed system for

Sarbanes-Oxley (Sox)

Applied password maintenance forms on the in house developed systems to

give users a means to reset the password when they expire.

Worked with users in Supply chain to gather requirement for NAFTA

Certification process and convert them into technical specification

(Rec/spec) for development.

Provide ongoing support to daily batch and on line processing.

Involved in deploying the system and provide guidelines for their ongoing

maintenance of various modules in CONTROL ERP system.

Used Order Change (ORDCHG) screen in CONTROL as base and created a new

function in CONTROL called CHGPKG. This screen has lot of field that are

unique to FleetGuard business ex.UPC code, carton weight, super family info

etc.

Created a table similar to PART table in CONTROL called FPRT that has

fields unique to Fleet Guard business practice.

Wrote a script similar to BLLMLI and BMLLMLX in CONTROL in PL/SQL so user

can request this job to be run in batch with a file provided by them.

Created a new code called "I"(Infant Care) Code in CONTROL. This code is

similar to ABC code in CONTROL. This gives added functionality to keep

track of new products.

Developed reports to capture discrepancies between Vouchers and purchase

Orders in the CONTROL ERP System using Oracle PL/SQL.

Enhance and Implemented Inventory valuation reports in CONTROL ERP(MPSCM

341, MPSCM342, MPSCM 343, MPSCM345) to provide a snap shot of inventory

dollars on weekly and monthly basis.

8/2001 - 11/2003 SANMINA-SCI, LYNCHBURG, VIRGINIA

ERP Business Analyst

Implemented ORACLE 11.03, 11i ERP packages at different plants. This

involved data migration, business application set up and configuration.

Prepared functional and design documents for interface with other systems

Lead classroom pilot session to give users over view of Oracle and

Trained business users in the use of Oracle Modules.

Gathered information from end users about existing business processes,

Used IDEF0 methodology to document the "AS-IS" business processes.

Evaluate the existing business processes and compared them with Oracle

processes to identify gaps.

Have a good understanding on how the Oracle application modules operate and

the Inter-workings of the different modules.

Reengineered existing business practices to implement Oracle modules.

Participated in unit, integration and acceptance testing.

Migrated data from COPICS manufacturing system to ORACLE ERP System.

Migrated Data from SUPRA Data Base on VAX Alpha system to COPICS

manufacturing system running on IBM mainframe and IDMS DATA BASE.

Migrated data from Alpha/Mater system running on HP SYSTEM to Supra

Database on VAX System

10/1998 - 7/2001 ERICSSON LYNCHBURG, VIRGINIA

Programmer/Business Analyst

Maintain and support various modules in CINCOM System's Control

Manufacturing package in Electronic manufacturing environment

Acted as a liaison between business users and development team to design,

develop and enhance new and existing business applications

Support SUPRA DATABASE in test and production VMS /ALPHA4100 environment

Provided operation support to all the manufacturing modules in CONTROL.

Write queries using 4GL languages Mantis, to go against SUPRA. Maintain DCL

Command procedures for Support batch processing.

Wrote scripts to help production planning to monitor supply chain

activities.

Wrote MANTIS (CINCOM system's proprietary language) program to give users

additional functionality to better use the ERP system.

Wrote in MANTIS a stock room system to monitor and issue materials for

production lines.

Helped with interface to receive order from SAP into CINCOM control system.

Monitor and maintain SUPRA Database from CINCOM SYSTEM on VMS VAX ALPHA

2000.

Migrated data from SUPRA to IDMS database.

Wrote program to imported PART, BOM, ROUTING, VENDOR info (the static

data), Po's and inventory files, sales order (dynamic data) into CONTROL

ERP system when Ericsson's manufacturing was sold to Sanmina-sci.

Implemented ITEM, BOM, ROUTING, MRP modules on ORACLE ERP system

Migrated data both static and dynamic data from CONTROL ERP system to

Oracle database.

Created scripts to delete obsolete parts from BOM'S in the CONTROL ERP

system.

Wrote a script to identify end products that are affected when a component

is changed in the bill of material structure so the end customers will be

notified as per contractual obligations.

Help production planning, configuration management, accounts payable and

shop floor control department to identify root causes for problems that

arise on a daily basis and provide solutions to problems so CONTROL ERP

system will work with out any glitches.

11/1997 - 10/1998 MONTANA STATE UNIVERSITY, MISSOULA, MONTANA

Senior Programmer Analyst

Software maintenance and enhancement in the BANNER system. Primary

responsibilities were in student administration module. This system was

developed On Dec Alpha 4100, using various oracle tools. Used developer

2000, forms4.5, developed individual student account review for Residence

life.

Modified work order form for resident life.

Used SQL, PL/SQL, PRO*C, PRO*COBOL. Designed new forms to retrieve, update,

and delete data.

4/1989 - 9/1997 MONTANA SOUVENIR COMPANY MILES CITY, MONTANA

Successfully owned and operated Montana Souvenir Co., Inc. for 10 years.

Traveled extensively in India, Hong Kong, China and Sri Lanka developed new

business sources and contacts with manufacturers and trading companies.

Negotiated contracts with distributors and manufacturers in Hong Kong,

India and Korea Led delegations of prospective buyers from US, France and

Korea to view production facility and negotiated sales contracts for

ceramic products in India.

4/1984 - 4/ 1989 PARKER-HANNIFIN CORP IRVINE, CALIFORNIA

Programmer Analyst

Develop, enhance, and maintain various manufacturing programs in Material

requirement Planning (MRP), Inventory control, Bill of materials, and

Master schedule systems. These systems were developed on IBM mainframe

environment using COBOL and TOTAL DBMS. Involved in full life cycle

development of Master schedule system. Developed specifications, designed,

tested, implemented, trained users in Master schedule update systems. This

system was written in Mantis. Trained users in writing their own queries

using spectra.

EDUCATION

10/1983 Arizona State University US-Arizona-Tempe

Master of Science in Industrial Engineering (information system design)

6/1980 Regional Engineering College, India-Haryana- Kurushetra

Bachelor of Science in Mechanical Engineering

Contact this candidate