Software / RDBMS Development n ERP Expert n EDI Expert

Degrees in Information Systems and Marketing; over 20 years’ experience designing, programming and supporting databases; 13 years of management experience; 16 years’ experience implementing and supporting ERP systems; 12 years’ experience supporting EDI development and communications.

Managed an ERP system (QAD - MFG/PRO) and all EDI communications for a multi-national company providing Tier-1 products for the automotive industry.

Able to effectively communicate with users of varying levels of technical expertise; 21 years of project management experience, which includes gathering user requirements, developing and validating the specs, designing, coding, testing, implementing and supporting the database(s) required to satisfy the customer’s needs. One of these databases was published and used by over 100,000 users internationally.

Skills Summary

Programming Languages:

Visual Basic (15 years)

SQL (4 years)

Progress (8 years)

Shell script (8 years)

SigConnects (4 years)

Dreamweaver (1 year)

Cognos (1 year)

XQuery (2 year)

Administration:

Linux (6 years)

SQL Server (5 years)

EDI (11 years)

EAM (3 years)

Other Skills:

Project Management (21 years)

Management (13 years)

ERP Experience (15 years)

Database Development (20 years)

Accounting (3 years)

Microsoft Dynamics AX (2 years)

Systems Analyst (21 years)

Career Progression

Senior Business Analyst: UnitedHealthCare (Dublin, Ohio) March 2016 – February 2023

Analyze, review, forecast, and trend complex data.

Present analysis and interpretation for operational and business review and planning.

Support short and long term operational/strategic business activities through analysis.

Develop recommended business solutions through research and analysis of data and business process and implement when appropriate.

Business Analyst (Consultant): Cardinal Health (Dublin, Ohio) September 2015 – November 2015

Managed the integration efforts of the recently acquired Cordis Division from Johnson & Johnson into the Cardinal Health medical instruments catalog. Duties included testing and validating EDI and eCommerce

processes, point of contact for EDI related questions and working with the end users and customers on issue tracking and issue resolution.

EDI / ERP Systems Analyst: Accellos (Columbus, Ohio) March 2013 – May 2015

Programmed EDI translation maps using XML data with XQuery as the programming language.

Supported all aspects of implementing the Accellos / Microsoft Dynamics AX ERP application.

Developed shipping labels used while packaging and shipping cartons and pallets.

Worked with customers to gather requirements and later managed the go live process.

Business Analyst (Consultant): Nationwide (Columbus, Ohio) October 2012 – December 2012

Gathered user requirements from the Nationwide Projects Group for a customized database. Developed, tested and pushed into production the database designed to track all projects within Nationwide. Some the information tracked and reported on within the database was the priority of the project, specific skills needed by associates to implement the project and current status of all projects.

Systems Analyst / Assistant Manager: TS Tech NA (Reynoldsburg, Ohio) January 2003 – July 2012

Managed a team of developers supporting MFG/PRO (QAD) ERP system for a Tier 1 automotive supplier.

Maintained Progress databases in a Linux environment.

Administered, monitored and maintained EDI functions (Gentran / VL Trader) for the American and Canadian manufacturing plants.

Developed custom reports, lookups and browses based on business requirements.

Implemented, supported and trained end users on the EAM application.

Helped design and personally build an award-winning intranet site (Espresso) using Dreamweaver MX.

Education & Certifications

BS in Information Systems and Marketing, The Ohio State University (Columbus, Ohio)

Microsoft Certified Database Administrator

Microsoft Certified Solution Developer

Designing and Implementing Desktop Applications with Microsoft Visual Basic 6.0

Designing and Implementing Distributed Applications with Microsoft Visual Basic 6.0

Developing Applications with Microsoft Visual Basic 5.0

Programming with Microsoft Visual Basic 4.0

Microsoft Access Developer’s Toolkit

Microsoft Visual InterDev 6.0

Microsoft Windows 2000 Server

Microsoft Solution Architecture

SQL 7.0 Administration

SQL 7.0 Designing and Implementing

ITIL – Foundations

Tableau

Contact this candidate