Post Job Free
Sign in

Supply Chain Sql Server

Location:
Aurora, IL, 60503
Posted:
March 09, 2010

Contact this candidate

Resume:

Venu Bandla Resume phone: 630-***-****

Venu G. Bandla

630-***-****

abnjlj@r.postjobfree.com

CAREER PROFILE:

Demonstrated ability to successfully plan, design and implement Supply chain

projects, specifically in Demand Planning, Replenishment, Transportation and

Warehouse management.

Proven Ability in Systems Evaluation/ Needs assessment and coming up with

creative solutions.

Excellent track record in completing projects on time and within budget.

Ability to Simplify business processes and to streamline operations.

Extensive experience in delivering Supply Chain projects (8 years) for top

Consumer Packaged Goods companies (ConAgra Foods and Kraft Foods) with

14 years of overall experience in designing, developing and managing IT

projects.

PROFESSIONAL ACCOMPLISHMENTS:

Solution Architect/Consultant

KRAFT Foods 2006 - 2009

• Successfully implemented Demand Forecasting for Canada market by

integrating the market into ADF (Advanced Demand Forecast) system

(Manugistics SCPO). This resulted in significant forecast accuracy

improvement for Canada market compared to existing legacy forecasting tool.

• Fine tuned short term forecast (Short term Pacing) for US market by

implementing a cutting-edge demand-sensing tool, Terra Technologies’ DS

resulting in significant short-term forecast accuracy improvement obviating

the necessity of too much Planner’s involvement for managing short-term

pacing.

• Responsible for design and implementation of VMI forecast (Vendor Managed

Inventory forecast) for France market into ADF system.

• Responsible for improving the functionality of ADF and APS (Advanced

Planning and Scheduling) systems.

Supply Chain Consultant

ConAgra Foods 2001 - 2006

• Successfully Designed and implemented Integration of SAP ERP, TMS

(Manugistics 6.x) and WMS (RedPrairie Process) systems for SAP Order-to-

Cash ERP implementation (Release 1).

• Responsible for designing and developing the interfaces between ERP,

Transportation and Warehouse management systems resulting in seamless

transaction communication.

• Successfully synchronized master data between SAP, TMS and WMS systems

for SAP implementation project.

• Successfully handled system integration for 3 new Dry and TCDN Mixing

Centers.

• Responsible for defining, capturing, measuring and distributing Key

Performance Indicators (KPI) Reports for Logistics division.

• Designed and Developed a Reporting System for Logistics for capturing KPI

and distributed the reports using Crystal Enterprise Dash board.

Page 1 of 3

Venu Bandla Resume phone: 630-***-****

Technical Lead

Whittman-Hart, Inc 1997 - 2001

• Designed and developed Respiratory Asset Tracking and Billing Application for

a pharmaceutical services company. This is a mobile computing application,

with the company technicians having the tracking application on their laptops

and visiting the nursing homes, scanning equipment and usage and

replicating the data with central server frequently. The billing is done on the

central server.

• Administered SQL Server database for a financial services company.

• Designed, developed and implemented a financial subsystem that was used to

fill the gaps in functionality between the original system on the AS/400 and

the package software purchased to replace the existing system.

• Developed a number of custom reports for an insurance company using

Crystal Reports and SQL Server’s Transact-SQL.

Sr. Programmer Analyst/Consultant

The Coca-Cola Company 1995 - 1997

• Designed, developed and tested a “Financial Accounts Payable Processing

System” (FSAPPS) that automated a large portion of the manual A/P voucher

process that the user was required to perform monthly.

• Installed SQL Server RDBMS and designed logical and physical database and

implemented database design. Responsible for security, backup and recovery,

tuning and troubleshooting.

• Designed and developed the “Check Transmission” application, which was

used to transmit check distribution information to CITI Bank.

• Designed and developed an “AS/400 to SQL Server Vendor Account Transfer

System” that transferred the vendor and account number information from

AS/400 to SQL Server tables using RUMBA File Transfer.

TECHNICAL SKILLS:

Full Software Development Life Cycle (SDLC)

System Architecture, Integration, Interfaces

Project Management

Supply Chain Software: Manugistics SCPO, Manugistics Transport,

Terra technologies DS, Red Prairie WMS, SAP

Platforms: Windows, UNIX, AS/400

Languages: Visual Basic, SQL, T-SQL, PL/SQL

RDBMS: Oracle, SQL Server

Report Writer: Crystal Reports, Crystal Enterprise

EDUCATION:

Master of Science in Computer Science, Western Michigan University, 1993- 1995.

Bachelor of Engineering in Electronics and Communications, Andhra University, India.

CERTIFICATION:

Pursuing Certification in Supply Chain Professional (CSCP)

Page 2 of 3

Venu Bandla Resume phone: 630-***-****

Page 3 of 3



Contact this candidate