Project Manager Business Systems

Robert Dietrich

Jacksonville, Florida *****

Phone: 904-***-**** mobile

Email: ***@*********.***

www.linkedin.com/in/robert-dietrich-colorado

Candidate Summary

Robert is a seasoned IT professional with 25 years of experience across project management, business systems analysis, and data analysis. He has a strong background in coordinating and managing UAT activities, ensuring business requirements are accurately translated into functional solutions. Throughout his career, Robert has worked closely with stakeholders to define acceptance criteria, develop UAT plans, and facilitate end-user testing sessions. His expertise in Microsoft tools has enabled him to efficiently track test cases, document results, and report on testing progress.

With hands-on experience as a Project Manager and Business Analyst, he brings deep knowledge of IT methodologies, enabling seamless integration of UAT within the broader software development lifecycle. Robert's strengths in communication and collaboration have been critical in aligning cross-functional teams and ensuring successful validation of deliverables before deployment. He is also passionate about innovation and emerging technologies, including the use of AI and ChatGPT to optimize testing workflows and enhance quality assurance processes.

Technical Skills

Data warehouse – Hadoop, HIVE, Sailfish, JSON, Oracle, DB2, Columnar and Row based table structures

AS400, MSSQL SSIS. ETL Oracle 10g-11g, Salesforce, HL7/FHIR Testing

TOAD for Data Analyst/Toad for Data Point/Presto Interface

HP ALM for development and Data Testing

PL/SQL, SCCM, Visual Studio .NET VB.Net ASP.NET ADO.NET, ChatGPT, Guidewell ChatGPT

MS Project/Word/Excel/Access/SharePoint, SQL Enterprise Manager

Field Centrix Mobile Software, AsteaAlliance Systems, i2 Trans

I2 Manager and Optimizer, PDL Freight Management Systems

WMS – PKMS and other 3rd Party Developed System

Interfaces developed and maintained to internal and external users and systems.

EDI Interfaces/Connections– VANs/FTP/Direct/email

EDI - translation software (EXTOL), TCP/IP Communications for iSeries

Business Skills

Teamwork & Organizational efficiency

Collaboration & Adaptability

Time Management

Excellent Communication skills

Interpersonal Skills

Employment History

Florida Blue(BCBSFL), Jacksonville, FL Florida Blue - Full Time Employee

Job Title: Sr Business System Analyst & Sr Data Testing Specialist

Dates: March. 2018 to Present

BSA – Led Data Testing & Gap Analysis: Conducted thorough data testing and gap analysis for Big Data Transformation projects, ensuring accuracy, completeness, and alignment with business requirements.

BSA - Facilitated Data Review Sessions: Organized and facilitated data review sessions with cross-functional teams, gathering feedback and ensuring consistency across the data lifecycle.

BSA - Documentation & Metadata Mapping: Managed the documentation and mapping of metadata to essential table attributes, enabling infrastructure readiness for each application and facilitating seamless data integration.

BSA - Agile Project Support: Assisted the Project Manager with Scrum ceremonies in Rally CA, contributing to the coordination of sprint planning, stand-ups, and retrospectives to ensure timely delivery of data-driven solutions.

Test Analyst - Integrated ChatGPT for SQL Automation: Incorporated ChatGPT technology into the automation of SQL scripts for daily data monitoring, streamlining data validation processes and improving efficiency by 30%.

Test Analyst - Data Quality Monitoring: Developed and optimized SQL-based scripts to monitor and validate large datasets, identifying anomalies and ensuring the integrity of data used across platforms.

Test Analyst - Collaboration with Cross-Functional Teams: Worked closely with developers and data engineers to implement AI-driven tools for data validation, improving overall testing accuracy and reducing manual effort.

Test Analyst – Dynamic Loading of XML to SQL Server Tables: Tested and validated the automated dynamic loading of XML files into SQL Server tables to support daily data monitoring and streamline SQL script execution. Focused on enhancing data validation processes for HL7 (Health Level 7) standard messages, and FHIR resulting in improved efficiency and reliability in healthcare data workflows.

Catholic Health Initiatives, Centennial, CO WIPRO, Ltd

Job Title: IT Project Manager, Project Coordinator

Dates: Aug. 2013 to Sept 2017

PM & BSA - Travel extensively to Mergers and Acquisition sites to gather and document Application integration information

BSA - Facilitating Requirement Gathering workshops with application owners

BSA - Documentation of requirement as per required attributes essential for enabling the infrastructure of each application.

BSA - Work as a SPOC for applications team for any requirement fulfillment from the infrastructure perspective

BSA - Verify through AD and Network Architect if the application requirement is met

BSA - Confirmation of Application infrastructure requirement is fulfilled.

PM - Facilitating the IP Server and Network IP Remediation to CHI standard subnets at remote MBO site locations.

PM - Facilitating the Active Directory Trust, Exchange, Free Busy, GAL Sync and Lync at remote MBO site locations.

PM - Facilitate VDI Project for All of CHI St. Luke’s Baylor Clinical users

PM - Facilitate Completion of the PC Refresh (XP to WIN7) Project for All the CHI St. Luke’s Baylor - 11 member Team

PM - Facilitate Completion of the PC Refresh (XP to WIN7) Project for All the CHI St Anthony WA - 4 member Team

Professional Designs, Ltd., Aurora, CO

Job Title: Developer/Technical Analyst, Transportation/Logistics Applications

Dates: Oct. 2012 to Dec. 2014

Lead developer for conversion of AS400/DB2 Applications to .net/MSSLQ Database

Requirement Gathering workshops with application owners

Business Requirements Documentation

Usage Requirements and Analysis Documentation

Prepare Logical Architecture and Design Documentation

Initialized New database and prepared SQL scripts to Converted DB2

Analyzed AS400 Application code and created C#.net code to replace

Created test scripts to validate conversions

Gambro Renal Products, Lakewood, Colorado

Job Title: Project Coordinator, Business Systems Analyst

Dates: Feb. 2009 to Aug. 2012

Responsible for vendor and project management on AsteaAlliance system upgrade with data conversion and interfaces to SAP ECC 6.0 within an FDA compliant company and Salesforce.

Conducted Work Group JAD and JAR sessions with user SMEs and stakeholders to document and discover business workflow and requirements.

Managed the expansion project for implementation and integration of AsteaAlliance into Canada. Developed FDA data integration test scripts for SAP ECC 6.0 implementation. PM and BA roles for the Decommissioning of the Astea System.

Past Duties included the support for the ETL integration between SAP 6.0 and AsteaAlliance Field Service Applications utilizing an (Oracle Db). Other Duties include providing second-level support for the wireless field service Astea applications.

Committed to deploying and providing robust solutions that eliminate the costs and inefficiencies of tactical, paper-based operations, while optimizing service resources.

My focus is to provide standardized practices to support key business improvement initiatives and faster deployment of solutions.

Managed Decommissioning project for Astea system to SharePoint and Oracle 11g Database

Administered and loaded the SharePoint Site for the Astea Decommissioning project.

ETL Development of SQL scripts for data migration to GFS Services application. (New Global Field Service Software System)

ETL Development of SQL and FTP scripts for SAP / AsteaAlliance Interfaces and Application servers

ETL Setup and migrated SAP 4.7 Master Data into AsteaAlliance i.e.(Customers, Product, Inventory & Equipment)

ETL Installed and Managed an Integration interface for AsteaAlliance / SAP ECC 6.0

Support for 140 Field Service Engineers using the Synchrologic product with access to AsteaAlliance Field Service Applications. ie.(Service Orders, Contracts, Timecards, Inventory, Invoicing for Field Service Apps)

Managed Development and Deployment of AsteaAlliance / SAP 6.0 integrations

Regular interface with internal business units, and understanding their objectives and challenges.

Created Project plans for the Astea software upgrade, Canadian field service expansion Service Application Training, Implementation & Rollout

Undertake programming or reporting tasks

Assisted in the coordination of IT project and planning activities between business units and IT

Prepared documentation, training materials and test scripts for company systems.

SourceOne Healthcare Technologies, Inc., Jacksonville, Florida

Job Title: IT Service Applications Manager

Dates: Jun. 2003 to Feb. 2009

Responsible for working with the various internal company business units to evaluate and define business system’s needs; advising and training end-users on effective use of systems to solve business problems, and managing the implementation of Information Technology (IT) solutions in the business area.

Formulated project plans to integrate Field Service Applications to a Baan ERP System (Oracle Db). Other Duties include providing second-level support for the wireless field service applications.

Other working experience has included the implementation and integration of a wireless service application using XML, SQL Db, AS400 ERP application (Db2).

Over the past year, I also have worked to automate and streamline manual processes and centralize disparate applications associated with service lifecycle management.

Committed to deploying and providing robust solutions that eliminate the costs and inefficiencies of tactical, paper-based operations, while optimizing service resources.

I have also strived to provide standardized practices to support key business improvement initiatives and faster deployment of solutions.

Assisted in Development of .NET Interfaces for Wireless Application servers

Setup & Configured Windows 2000 Adv Servers for Network Load Balancing Web Applications

Installed and Managed an Internet Web Portal for 900 Field Service Engineers using the Seagull/JWalk product with access to AS400 Applications. ie.(J D E World & Field Service Apps)

Analyzed Multiple PDA’s, Wireless Carriers, & CF/SD Cards for Remote Field Service Applications.

Managed Development and Deployment of new software features integrated into wireless applications

Work as a SPOC for applications team for any requirement fulfillment from the infrastructure perspective

Verify through AD and Network Architect if the application requirement is met

Confirmation of Application infrastructure requirement is fulfilled. Assisted in the coordination of IT project and planning activities between business units and the IT

Prepared documentation and training materials for company systems.

Held training sessions on Wireless applications for other departmental Knowledge Base learning sessions

APL LOGISTICS, Inc. (Formerly GATX Logistics, Inc.), Jacksonville, Florida

Job Title: Manager, Business Applications Delivery

Dates: Jun. 2000 to Apr. 2003

Manager for I2 Transportation Development/ecommerce and Integration

Directed and managed multiple projects and staff of more than 18 developers and contractors for both transportation development and EDI/ecommerce department translating over seven million documents per year.

Budgeted and managed expenditures over $800,000 annually for both departments. Provided professional management for projects and enhancements of both product and process on time and within budget results.

Served as mentor to developers on numerous supply chain projects from global customer integration to internal applications.

Developed and maintained interfaces to 60 warehouses, deployment center and west coast deconsolidation center

Mentored all developers on all projects in design and coding using RPG IV ILE and Extol tools.

Worked with testers to develop regression tests on all application modifications.

Directed and managed 20 to 25 on-going projects of various scopes at all times.

Reduced total ecommerce interface costs by $540,000 per year through developing cost saving plans and projects with integration into current applications.

Reduced 3PL transportation operating costs by $650,000 per year through directing the migration of a Client Server (C/S) TMS for a $100 million customer to the AS400 i2 system.

Directed and managed the ecommerce/EDI integration to multiple Warehouse Management Systems (WMS/PkMS) and Transportation Management Systems (TMS) Supply Chain Systems.

Directed the development of Product Enhancements and modifications to the i2 Transportation Manager and Optimizer products for external and internal business needs.

Directed and designed EDI web interfaces and enhancements to both TMS and WMS/PkMS products built and enhanced for current and future global business needs.

Managed daily Extol translator used for EDI integration to internal WMS and TMS for more than 80 customers in over 60 warehouse locations using X12 standard and flat file formats.

Directed and managed the physical map conversion and integration to a new mainframe application of more than 60 customers with over 200 EDI maps using Extol/AS400 platform.

Total EDI department document translation volume was estimated at more than 14-million document translations per year.

Developed “eView” Internet Connectivity over Extol Integrator database for external customers and internal developers/support desk.

Recipient of multiple awards for outstanding contributions for successful integrations of processes and systems.

Education

Degree

University

State

Bachelor of Science in Industrial Engineering

UNIVERSITY OF NEBRASKA @ Omaha

Omaha, Nebraska

Trainings

Years 2018 – 2025 Completed numerous training classes with Florida Blue i.e(ChatGPT/Security/Privacy/Human Resources)

Completed numerous IT training seminars with IBM and other related vendors.

Year 2012: IBM OPTIM – Data Management for Distributed Systems

IAG Consulting – Business Analyst Bootcamp (Defining Business Requirements & Conducting Requirements Discovery Sessions)

Year 2013: C#.NET Coding using Visual Studio 2010

TMS/Motor Freight Systems Copyrights: Billing, Rating, A/R, A/P, G/L, P/R, Claims, Operator Settlements, Equipment Dispatch and State Fuel and Mileage Tax Reporting System

Military Experience

US ARMY Nebraska National Guard, Medical Unit (6 years’ service with Honorable Discharge)

Contact this candidate