PAUL D. BOHLI, MBA

PROFESSIONAL PROFILE

Creative, detail-oriented Supply Chain Management (SCM) programmer /

analyst with over 10 years of diverse, client-facing IT experience covering

entire lifecycle of JDA / Manugistics software to include implementation,

customization, work-flow analysis / automation, development, maintenance

and extract / translate / load (ETL) methodologies. With a strong database

analyst / engineer background, also have extensive knowledge in RDBMS, DSS

and data warehousing integration verification and validation (IV&V).

Throughout progressive career development, honed interpersonal skills and

sharpened both business and technical knowledge to effectively perform as

team player or independently. Three of my customers were listed among

Global 500 companies.

SELECTED ACCOMPLISHMENTS

. Changed Vice President of SCM perspective of Manugistics by re-

engineering integrations to include proper programming methodologies thus

initiating follow-on contract to perform training and go-live assistance.

. Redesigned NetWORKS Demand application to allow for detailed information

at the ship-to level of major customers thus providing a centralized

platform for customer service, supply chain planners, marketing and

sales.

. Mentored junior co-workers in technical support of Manugistics Transport,

Demand and Fulfillment implementation / troubleshooting including

training in Oracle, SQL, PL/SQL and WebConnect Integrate

TECHNICAL SKILLS

APPLICATIONS: NetWORKS Demand, NetWORKS Fulfillment, NetWORKS

Transport, NetWORKS Freight Payment, Request For

Quote (RFQ), NetWORKS Monitor, NetWORKS Collaborate.

DATABASES: Oracle (9i, 8i, 7), MS Access, DB2

OPERATING Windows 9x, Windows NT/2000/XP, UNIX/AIX HP-11, SUN

SYSTEMS: Solaris, IBM Mainframes/MVS/XA (3081, 3090)

SOFTWARE: WebConnect Integrate, Vignette Business Integration

Studio (VBIS), BEA WebLogic, Oracle SQL*Plus, ERWin,

MS Office, MS Project

LANGUAGES: PL/SQL, SQL*Loader, Perl, C & Korn Shells, Batch

Scripts, SQL Data Definition Language (DDL), SQL

Data Manipulation Language (DML)

EDUCATION

MBA Virginia Polytechnic Institute and State University

Management Science concentrating in Computer Science

BS Bridgewater College

Mathematics and Computer Science

PROFESSIONAL EXPERIENCE

VACO Richmond, VA

JDA Development Team member 2010-2010

Assisted with correcting defects for the IPFR Phase 2 Implementation NeWORKS

Demand/Fulfillment version 7.4 at Loblaw in Toronto, Ontario, Canada.

Presented Support training for 2 of six deliverables after preparing

documentation.

CHEP Orlando, FL

Sr. Programmer/Analyst (JDA) 2006-2010

Redesigned NetWORKS Demand to be customer/plant focused with a flexible

hierarchy providing more detailed analysis for the demand planners.

Upgraded JDA applications NetWORKS Transportation, NetWORKS Freight Payment,

NetWORKS SCPO from 6.1.4 to 7.2.

Designed / implemented NetWORKS Freight Payment integrations.

Supported three regionally based implementations of NetWORKS with differing

code bases.

Hamilton-Murphy Associates Hamden, CT

Manugistics Consultant 2006-2006

Contracted to Schick Wilkinson Sword to implement global processes for

redesigned implementation of NetWORKS Demand and NetWORKS Fulfillment versions

7.2 using PL/SQL, SQL*Loader, IGP and windows batch scripts.

Documented global data flow, batch processes and scripts for a global design

that included four regions spanning the world. Each region had various ERP

systems that were interfaced.

Church & Dwight Co., Inc Princeton, NJ

Senior Business Analyst (Manugistics) 2004-2005

Promoted to technical lead of all Manugistics applications after 6 months

working for the company and having successfully upgraded NetWORKS Transport

from versions 7.0 to 7.1. Manugistics applications supported consisted of

NetWORKS Demand 6.1.4, NetWORKS Fulfillment 6.1.4, NetWORKS Transport 7.1 and

NetWORKS Transport Request for Quotation (RFQ) 7.2.

Redesigned SCPO to be customer focused thus allowing VMI implementation, more

detailed analysis for the supply chain planners, and a single centralized

platform for marketing and sales.

Mentored co-worker in technical support of Transport including training in

Oracle, SQL and PL/SQL.

Oversaw implementation and upgrade of NetWORKS Transport RFQ 7.2 being among

the first Manugistics clients to implement the application

Designed, implemented and documented modifications utilizing UNIX, Kornshell,

SQL, PL SQL, Perl, SAP, and Microsoft Access.

Prepare SCPO database for migration from NetWORKS Demand/Fulfillment 6.1.4 to

the NetWORKS 7.x environment by eliminating the referential integrity issues

and the special character issues.

Optimal Solutions Integration Irving, TX

Manugistics (UNIX) Administrator 2003-2004

Contracted through Optimal Solutions Integration to Accenture to support the

Defense Logistics Agency (DLA) Defense Supply Center, Columbus (DSCC)

maintenance of Manugistics applications

Provided design / maintenance / enhancement input for the technical

architecture which consisted of UNIX HP-11 and Windows 2K servers executing

SAP, Oracle 8i, and eGate

Supported, troubleshot and tuned Manugistics applications through working with

other Application Technical Administrators, Database Administrators, and

Configuration Control Administrators. Manugistics applications consisted of

NetWORKS Demand 6.1.4, NetWORKS Fulfillment 6.1.4, and NetWORKS Collaborate

6.1.2, NetWORKS ONEView 6.2 and NetWORKS Strategy 6.2.

Performed basic environment operations and on-going administration of

Manugistics applications.

.

Manugistics Rockville, MD

Senior Integration Consultant 2001-2003

Changed Vice President of SCM perspective of Manugistics by re-engineering

integrations to include proper programming methodologies thus initiating

follow-on contract to perform training and go-live assistance

Trained customers' DBAs in technical aspects of the applications, Oracle DML,

Oracle DDL, Maintenance / Recovery, and WebConnect Integrate and provided

tuning suggestions

Mentored other Integration Consultants in identifying development requirements

and best methodologies.

Performed data mapping from customers' systems to Manugistics database;

documented technical and integration specifications. Modeled staging database

and generated Manugistics database utilizing SQL scripts after installing

Oracle (8i or 9i) and Manugistics software on customers' servers; maintained

multiple database instances.

Developed scripts using WebConnect Integrate, SQL, PL/SQL, SQL*Loader, C &

Korn Shells, batch files and Perl to extract, transform and load (ETL) data

for Supply Chain Profit and Optimization (SCPO) ERP solutions.

o SCPO implementations consisted of NetWORKS Demand, NetWORKS Fulfillment,

NetWORKS Collaborate and Common Security Module (CSM) (a front-end to BEA

WebLogic).

o Integrated client systems: MQ-Series, SAP, SQL Server, Oracle 11i.

o WebConnect Integrate is a java-based ETL tool based on VBIS.

Traveled to client sites nationally and internationally. Clients included

United States Naval Supply Systems Command (NAVSUP), ExxonMobil, Aqua Glass,

J.M. Huber Corporation, Abbott Laboratories, and Kraft de Mexico

Operating Systems: Windows 2000, Windows 98, UNIX HP-11; Oracle 9i, 8i.

Senior Software (Manual) Tester 2000 - 2001

Contracted through GRC International for the first six months. Upon completion

of contract, as a result of my broad technical background and ability to work

as a team member, I was offered a position with Manugistics in December 2000.

Automated testing of Configurable Plug-In Utility Adapters and Manugistics

SubIntegration (MSIs) for NetWORKS Transport with SAP as part of WebConnect

Integrate using C shells, batch scripts, and VBIS integrations.

Reported deficiencies in requirement specifications and coding

Documented and reviewed test artifacts: testability assessment reports, test

plans, test scripts, test cases and test results. Reviewed test artifacts of

co-workers.

Operating Systems tested: Windows 98, Unix/AIX HP-11; Oracle 8i

GRCI International (AT&T Government Solutions) Vienna, VA

Programmer / Analyst 1987-2000

Held a Top Secret Clearance issued by Defense Investigative Security Agency

Analyzed strategic mobility scenarios for Department of Defense and

implemented enhancements to the models used.

Managed three database IV&V testers after performing thorough requirements

analyses and risk assessment that identified the need.

Awarded Department of Defense task order based on detail-oriented workflow

analysis

Contact this candidate