Senior Business Data Analyst

Jerrod Young

Data Architect

****.***********.*********@*****.***

linkedin.com/in/jerrodyoung

EDUCATION

DeVry University/Institute of Technology

Business Telecommunications Management 1999 - 2001 (Completed 3 semesters towards degree)

SPECIALTY COURSES

Oracle VCP – Implement Demantra Demand Management Ed 1 (Oracle)

Oracle VCP – Advanced Demantra DM Ed 1 (Oracle)

JD Edwards Enterprise One Development Tools Part 1 Rel 9.X (Oracle)

SAP Business Planning & Consolidation Administration (SAP)

Microsoft Power BI Development & Administration (Microsoft)

ZoHo CRM Development (Zoho/Deluge)

CEH/CCNA Training (Self Study)

AI-100 for Beginners (Mphasis)

Github Copilot Essentials - S1 (Mphasis/Microsoft)

DATA/SOFTWARE SKILLS

Operating Systems - Windows/Linux

Database Systems - Oracle, Microsoft, MySQL

Microsoft SQL Server (SSIS, SSAS, SSRS)

Oracle PL/SQL Programming

VBA Scripting/Programming

BAT (Batch)/Shell Scripting

M365 Administration & Automation

Visual Studio (VB.NET)

IBM MQ Analysis

C/Pro*C Analysis

Data Modeling

Application Interface Modeling

Application/Data & Parent/Child Relationship Modeling

PROFESSIONAL EXPERIENCE

Mphasis Limited (Corporation) 2023 - Present

Senior Consultant (Database Analyst)/Business Data Analyst

Client Projects: CPKC

Team leader in the analysis of ~7k programming objects and ~1k interfaces to document all object purposes, object relationships, and identify all MasterData (MDM) flags identified by client in advance before retrofitting for merger cutover.

Analyzed 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 based on available resources or implementation of AI technologies.

Analyzed 20+ applications to compare mileage data across various systems to determine a single source of truth to improve system resources.

Analyzed ~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 support level required.

Westlake ACE Hardware 2019 - 2023

Business Applications Analyst/Integration Architect

Architected, designed, developed, and supported data integration/migration & development technologies and application administration activities including but not limited to Microsoft SQL Server (SSAS, SSIS, SSRS), Oracle JD Edwards EnterpriseOne, VB.NET, SharePoint, ZoHo CRM, ZoHo Analytics, Deputy, Fishbowl, BAT & Shell Scripting

Key projects included the implementation of Inventory Management/Order Fulfillment system, CRM system, and timeclock reporting system. Responsible for requirements gathering, budgeting, researching, and implementation.

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

Oracle Database Developer/Integration Architect

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 data archiving/removal processes.

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

Compass Minerals 2008 - 2018

Integration Architect

Architected, designed, developed, and supported various data integration/migration & development technologies and application administration activities including but not limited to Microsoft SQL Server (SSAS, SSIS, SSRS), SAP BPC, PL/SQL, Oracle JD Edwards EnterpriseOne, VB.NET, ASP.NET, Oracle Demantra, SharePoint, C#.NET, 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

DAMA International 2019 - Present

VP Online Services/Security & Privacy Committee Chair

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

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

Author and enforce data governance, security, privacy, and compliance policies and procedures.

Manage & train staff, volunteers, and other members on organizational policies and procedures.

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

DAMA Kansas City 2016 - Present

VP Online Services/Shadow Officer

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

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

Organize, budget, & implement M365 E3 environment (Global Administrator), polices, AAD, SharePoint, Office, Planner, Teams, and other services.

Author and enforce data governance, security, privacy, and compliance policies and procedures.

Train volunteers on organizational policies and procedures. Manage budgets for all IT resources; delivered sub-budget results.

Contact this candidate