Education

May **** Baldwin-Wallace College Berea, OH

Bachelor of Arts, Major: Business Administration Minor: Computer Information Systems

Dean’s List Mary Sedlak Scholarship Sinema Scholarship

Experience

2021-Present CDK Global Destin, FL (Remote)

Azure Data Architect

Responsible for overall Azure health for Synapse and Business Intelligence developer, design, and health

Reduced yearly Synapse consumption cost by 250,000.

Implemented code-as-infrastructure design for BI and data models.

2018-2021 CDK Global Destin, FL

Cloud Data Engineering Manager

Architected central data warehouse and business intelligence system of over 50 tb for 3000 disparate automotive dealers for CRM and Service data

Maintained daily operation of enterprise data warehouse with team for multiple sites and projects with Azure Synapse, Azure Data Factory, and Data Bricks, using real time data streaming and ingesting from host systems.

Winner of Destin 2019 Hackathon for voice recognition in automotive call center analytics using sentiment analysis and machine learning

Effectively managed team of 15 disparate talents on various enterprise cloud projects

Proficient in latest methods of cloud data ETL, design, and implementation at Azure and AWS.

Developed AWS Enterprise Customer Data Warehouse with API and PowerBI integrations for customer self-service reporting solution

Managed series of high impact projects and completed CDK SAFE training.

2016-Present Stone Donut, Inc. Cleveland, OH

Azure Cloud Data Engineer

Lead SQL data warehouse developer for Microsoft Gold Partner

Constructed full Azure data warehouse environment leveraging Synapse, machine learning, and PowerApps.

Developed and designed enterprise purchasing data warehouse for 72 companies from disparate data sets, such as Sage and d365.

Designed real time JSON data ingest through Azure Data Factory for ML insights through Azure and Data Factory.

Azure Integration with existing ERP systems and data warehouse

Completed auditing and data dictionary for enterprise use.

Built PowerBI and Tableau front end for SSAS data cubes

Served as lead Azure data engineer for VRBL Intelligent Calling Software, creating real time data ingestion, sentiment analysis, and data reporting framework.

2015-2018 Garland Industries Cleveland, OH

Data Warehouse Manager

Managed data warehouse for Garland Industries and sixteen subsidiaries.

Deployed various Azure based data warehouse replacements which include feature analysis and AI insights

Migrated existing data warehouse and infrastructure to cloud resources

Designed future business intelligence initiatives via MS SQL through SSAS and various reporting suites

Maintained business improvement projects at various subsidiaries to increase profitability.

Implemented new ad hoc and mapping tools to increase sales and market penetration.

2013-2015 The Accurate Group, LLC Independence, OH

Senior Database Administrator

Responsible for operation and optimal performance of Archer Business Suite for several companies.

Performed daily system functions including log shipping, backup, index tuning, and replication.

Implemented and maintained new installation of Microsoft Dynamics Great Plains accounting system.

Managed Microsoft Certified Partner Program, including Silver and Gold Partner planning and training.

Constructed multiple SQL Reports and dashboards to address various business requests.

Upgraded existing SQL platforms and reporting environments to Microsoft SQL 2014.

Assigned lead data architect on Archer Direct Software-As-A-Service product line.

2008-2013 Cleveland Clinic Foundation, Decision Support Services Independence, OH

Database Administrator / Data Warehouse Developer

Constructed Revenue Cycle, Payroll, and Budget database warehouse for main campus and satellite billing systems while managing new change and support requests.

Managed daily file loads and processing for finance database warehouse.

Designed Service Line Reports to measure financial performance and cost management.

Team won the Data Warehousing Institute 2011 Best Practices for Performance Management and 2012 second place Healthcare Informatics/AMDIS IT Innovation Advocate Award.

Lead department agile development team.

Responsible for department SQL, Business Objects, and technical skills training.

Created and updated SSAS cubes and reporting models for several warehouse data marts.

Member of Finance Data Analytics, Employee Engagement, and Department Retreat Teams.

2005-2008 Avtron Aerospace, Inc. Independence, OH

Database Administrator

Supervised upgrade and transfer of 20 databases on 2 servers from SQL 2000 to SQL 2005. I did this for additional functionality, increased performance, and to remain current with BaanIVc4 system requirements.

Managed entirety of BaanIVc4 Accounting and Business Production System for inventory management, financial data, and business processing.

Deployed 20 report models, migrated 50 Crystal Reports, and wrote over a 100 new production reports to SQL Reporting Services for finance, accounting, engineering, and production control.

Administered three production SQL 2000 and SQL 2005 Production servers for three hundred users. This includes event log, patch management, and miscellaneous tasks such as index tuning and account changes.

2002-2005 Avtron Manufacturing, Inc. Independence, OH

LAN Administrator

Managed and designed Windows 2000 and 2003 network with over 30 production servers. During this time, we added 10 new servers, 100 user stations, improved latency, and with 40% less manpower in the department than 2002.

Enacted disaster recovery procedure and testing for every production server with a yearly goal of faster recovery times and better documentation of procedures.

Controlled Inter-Tel 4 node PBX network phone system. I have moved this system between several plants using VOIP, and doubled its current user base to 350.

Deployed Microsoft Internet and Security Server for email security, firewall, and web use. This reduced incidents from viruses, malicious code, and other Internet based threats to a point of near non-existence.

Facilitated migration to Active Directory system from Windows NT environment using a parallel Domain Trust. This allowed our department to take advantage of the easier management Active Directory allowed.

Directed the Departmental Technical Training for six person MIS Department focusing on Microsoft Server and networking related materials for MCSE Certification.

1998-2002 Knight Ergonomics, Inc. Twinsburg, OH

Network Administrator

Installed error proofing systems at Ford Motor Company to improve productivity and increase efficiency on

assembly line at air conditioner compressor station.

Maintained 40 user network on NT based system with servers between Cleveland, Columbus,

and Louisville .

Integrated current system with Knight Industries network, 150 user network with 11 servers

over 5 nodes.

Administered Intra and Internet email with MS Exchange 5.5.

Consulting Work

2020-2021 Monogram Foods Memphis, TN

Azure Cloud Development

Built real time Azure data pipeline using LogicApps and Azure Functions

Create Synapse data warehouse for manufacturing and logistics

Utilized 2019-2020 PoliAnna Software Suite Destin, FL

Azure Cloud Development

Designed Azure based Blazor application to manage political campaigns for PoliAnna.

Utilized machine learning and social media to find campaign insights.

Built back end cloud infrastructure, stored procedures, and reporting for software suite.

2019-2022 Southern Vacation Rentals Destin, FL

SQL Project Development

Developed real time Azure Data Lake to integrate Track system and various vendor APIs

Completed project to allow for PowerApp project for employee property inspections, utilizing Azure SQL,

Azure Data Factory, and BLOB storage

2019 Insight2Profit Cleveland, OH

ETL Engineer

Updated existing SSIS and PowerShell process to use new standardized ETL framework.

Streamlined ETL process to allow for conversion of over 2000 legacy packages modernized design

2015 Athletic Assistant North Olmsted, OH

SQL Project Development

Create new product to manage student achievement with Visual Studio MVC for North Olmsted Schools.

Architected data model and supporting procedures for Athletic Assistant product.

2013 Intwine Energy, Inc. Chagrin Falls, OH

SQL Performance Consulting

Reduced system overhead and redesigned all existing indexes for their actual use

Updated maintenance plans to be self-sustaining.

Technical Certifications

Inter-tel Axxess Certified System Engineer

Microsoft Certified Professional : 70-290

adrxhb@r.postjobfree.com

440-***-****

Contact this candidate