Data Integration Architect

Jerrod Young

Data Integration Architect/Business Data Analyst

Professional Experience

Senior Consultant (Database Analyst)/Business Data Analyst

Mphasis Limited (Corporation) 9/2023 - 7/2025

-->Client Projects: CPKC

Team leader in the analysis of ~7k programming objects and ~1k interfaces to document all object purposes & relationships, and identify all MasterData (MDM) references in the code prior to retrofitting for merger cutover.

Educated team members on how to utilize AI technology to analyze existing code, generate modified or new base code, and generate support documentation, which saved time on development and documentation creation processes.

Analyzed & visualized ~30 year old legacy data issue, identified hidden patterns in the data, and built dashboard architecture to allow the business to identify the core problems and address them based on priority and available resources or AI technologies.

Analyzed & visualized 20+ applications to compare mileage data across various systems to determine a single source of truth to improve system resource cost efficiency.

Analyzed & visualized ~300 interfaces for core applications within a legacy SADB system to confirm legacy diagram accuracy, and expand details for multi-level and conditional analysis based on required support level for future system/data modernization projects.

Business Applications Analyst/Integration Architect

Westlake ACE Hardware 11/2019 - 5/2023

-->Architected, designed, developed, and supported data integration/migration development technologies and application administration activities including, but not limited to, Microsoft SQL Server (T-SQL, SSIS, SSAS, SSRS), Oracle JDE Enterprise One, SharePoint, ZoHo CRM, ZoHo Analytics, Deputy, Fishbowl, BAT & Shell Scripting

Key projects included the implementation of Inventory Management/Order Fulfillment, CRM, and California timeclock reporting systems.

Responsible for requirements gathering, budgeting, researching, and implementation.

Oracle Database Developer/Integration Architect

Associated Wholesale Grocers, Inc. (AWG) 12/2018 - 11/2019

-->Oracle PL/SQL debugging & programming. Assisted with the identification of slow running and/or defective stored procedure packages and modifying to resolve issues.

-->Custom function, procedure, & package development. Query optimization via indexing, bulk merge/update, and archiving/removal processes.

-->Consulted with MasterData (MDM) department to relieve pressure on development to code around bad data governance practices.

Integration Architect

Compass Minerals 1/2008 - 12/2018

-->Architected, designed, developed, and supported various data integration/migration development technologies and application administration activities including, but not limited to, Microsoft SQL Server (T-SQL, SSIS, SSAS, SSRS), SAP BPC, Oracle PL/SQL, Oracle JDE Enterprise One, VB.NET, ASP.NET, C#.NET, Oracle Demantra, SharePoint, VBA Scripting, and custom Microsoft Access database applications.

-->Consulted with the MasterData (MDM) department, and other branches of IT, including infrastructure, security, and privacy to ensure proper data governance.

-->Key Projects

Architected, designed, and developed the implementation of MasterData (MDM) integrations for Oracle Demantra installation.

Architected, designed, and developed the implementation of MasterData (MDM) integrations for SAP Business Planning & Consolidation (BPC) installation.

Integral part in the complete overhaul necessary to upgrade from JDE 9.0 to 9.1; assisting with MasterData (MDM) policy changes, data conversion diagrams, custom table definitions, and application retrofitting via OMW development.

Volunteer Experience

VP Online Services/Shadow Officer

DAMA Kansas City 1/2016 - Present

-->Organized, budgeted, & designed, initial launch of website and current membership management platform.

-->Managed development & production CRM, Point of Sale (POS), website systems and the related vendor relationships.

-->Organized, budgeted, & implemented M365 E3 environment (Global Administrator), polices, AAD, SharePoint, Office, Planner, Teams, and other services.

-->Authored and enforced data governance, security, privacy, and compliance policies and procedures.

-->Trained volunteers on organizational policies and procedures.

-->Managed budgets for all IT resources; delivered sub-budget results.

VP Online Services/Security & Privacy Committee Chair

DAMA International 1/2019 - 4/2024

-->Managed development & production CRM, Point of Sale (POS), website systems and the related vendor relationships.

-->Global Administrator of M365 E3 environment, polices, AAD, SharePoint, Office, Planner, Teams, and other services.

-->Authored and enforced data governance, security, privacy, and compliance policies and procedures.

-->Managed & trained staff, volunteers, and other members on organizational policies and procedures.

-->Managed budgets for all IT resources; delivered sub-budget results.

Contact this candidate