Uploaded File
add photo
Jeff
jsbish@gmail.com
816-507-3192
5908 NE Turquoise Drive
Lees Summit, MO 64064
Cloud Data Strategy Manager
22 years experience W2
0
Recommendations
Average rating
2
Profile views
Summary

Experience
Cloud Data Strategy Manager
Aug 2020 - present
  • Lead the data architecture strategy for clients seeking to utilize the Azure platform to improve scalability, flexibility, and capability
  • Partner with Microsoft on developing programs and solutions that assist customers in modernizing data infrastructure and analytics
  • Manage a team of data engineers in the execution of projects to improve analytic capabilities through data visualization, machine learning, and AI in conjunction with better data governance and more economical data storage
Data Architecture Data Engineering Data Governance Data Visualization Machine Learning MS Azure
Remove Skill
Principal Architect
Jan 2020 - Aug 2020
  • Enterprise Data Architect leading the migration of data assets to Microsoft Azure based services including all related processes and analytical tools for the nation's largest tax services provider
  • Designed the infrastructure for the enterprise migration from on-premise data integration processes utilizing Informatica and SSIS to cloud-based platforms like Azure Data Factory. Published best practices for data architecture, analytics, and integration and mentored staff on implementing those best practices
  • Designed the enterprise operational data hub for operational systems to exchange data in near real-time utilizing master data and reference data, and ensure consistency between and operations and analytics
  • Consulted with C-level management on strategies for accomplishing cost reductions with improved capabilities by migrating to a cloud platform and how to implement those strategies including staff training, ensuring data security, and processes to consistently check progress toward the goals
Azure Data Factory Data Architecture MS Azure SSIS
Remove Skill
Data Architecture Consultant
Information Technology
Aug 2018 - Jan 2020
  • Guided senior management and developers in designing data architectures to support application integration, operational BI, and advanced analytics with minimal redundancy
  • Conducted detailed product comparisons of ETL vendors, SaaS data warehouse vendors, data catalog/lineage vendors, master data management vendors, and analytical tool vendors for several clients using a self-developed process and deliverable template later adopted by H&R Block
  • Designed and developed an Azure Synapse-based analytics ecosystem for a major grocery supplier in the Midwest utilizing Azure SQL Data Warehouse, Azure Data Factory Services, Azure Data Lake, and Power BI to identify logistics improvements
  • Lead the data migration from multiple legacy operational systems to a single SaaS vendor including data mapping, ETL design and development, QA process definition and production migration from SQL Server on-premise to Azure SQL and Cosmos
Data Architecture Data Mapping Data Migration Data Warehousing ETL MS Azure MS Power BI SQL SQL Server
Remove Skill
Jan 2010 - Jan 2020
consultants Key Engagements Logistics Intelligence System -
No skills were added
Remove Skill
Sr. Manager, Business Intelligence
Aug 2017 - Aug 2018
(QTS)
  • Lead the modernization of a traditional operational reporting team to end user self-service, increased automation, introduction of advanced analytics, and mentorship of staff on how to transition to our new function
  • Designed and developed the enterprise data integration architecture to facilitate efficiency and automation of cross division processes through the exchange of information between the enterprise CRM system (Salesforce), the ITSM system (ServiceNow), the ERP system (UltiPro), and the corporate accounting system (Microsoft Dynamics GP)
  • Led the migration of data integration processes from unorchestrated ETL packages and batch scripts with multiple points of failure to end-to-end orchestrated processes in a single platform, Informatica Cloud, with streamlined, consistent, and non-redundant storage and processing
  • Redeveloped the enterprise data warehouse in SQL Server and modernized the reporting infrastructure with Power BI dashboards drilling though to traditional SSRS reports and started the adoption of advanced analytics through training of end users on Power BI and Alteryx to replace traditional spreadsheets
  • Managed and served as lead technical architect on several top corporate initiatives including leading the enterprise data governance committee, and initializing a cloud-first strategy for corporate systems by moving data integration to Informatica Cloud and business intelligence to Azure
  • Received formal training in Lean Six Sigma principles and lead key process improvement initiatives utilizing those principles
Business Intelligence CRM Data Governance Data Integration Data Warehousing ERP ETL Informatica MS Azure MS Power BI MS Visio Process Improvement SQL SQL Server SSRS
Remove Skill
Director, Business Intelligence
May 2016 - Aug 2017
  • Lead the formation of the Business Intelligence division, developed the vision and plan of execution for leading AAFP to be a more data-driven organization integrated existing data analysts into new processes and procedures, recruited and trained new staff, and communicated our goals, plans, and progress to the organization
  • Designed, modeled, and developed a new enterprise data warehouse composed of the core operational systems (ERP, marketing, CRM, and accounting) of the organization to improve member retention and drive personalization in interactions through all channels. Delivered self-service business intelligence capabilities through Tableau, Power BI, SQL Server, SSIS, and SSRS.
  • Managed and consolidated the information needs of 26 independent divisions, implementing data governance and master data management across the enterprise
  • Technical lead of the enterprise data catalog initiative to develop a consolidated platform and portal for sharing key data assets
  • Technical lead over the health outcomes improvement initiative coordinating with vendors to exchange patient data and treatment recommendations
Business Intelligence CRM Data Analysis Data Governance Data Warehousing MS Power BI MS Visio Project Management SQL SQL Server SSIS Tableau
Remove Skill
Data Architecture Consultant
Medical Devices
Feb 2015 - May 2016
  • Managed the Microsoft BI environment for the Health & Wellness division of an international laboratory services organization in SSIS, SQL Server, SSAS, SSRS, and Alteryx for collecting and analyzing health analytes
  • Designed and developed a data warehouse for the largest federal health benefit provider for analyzing procedure and diagnosis codes relative to the cost of treatment from medical claims data
Data Architecture Data Warehousing SQL SQL Server SSIS SSRS
Remove Skill
Director, Data and Analytics
Jan 2004 - Jan 2015
  • Managed a team of software and database engineers in the design and development of custom software and business intelligence solutions for customers
  • Served actively as Project Manager and Lead Consultant on many large and complex application development, business intelligence, and data management projects
  • Responsible for P&L and business development for a staff of
Application Development Business Intelligence Project Management
Remove Skill
Technical Architect
Jan 2006 - Jan 2010
* Technical Architect responsible for data architecture, and BI system development (SAP Business Objects Enterprise, Data Services, Web Intelligence, and Xcelsius) on a 5-year engagement to improve mission capability and logistics analysis for a key program with the U.S. Air Force
Data Architecture
Remove Skill
Technical Architect, Project Manager
Jan 2006 - Jan 2009
and DBA (SQL Server) over development of a web-based physician and hospital assessment and education program focused on improving early diagnoses and treatment of Severe Sepsis
DBA Project Management
Remove Skill
Technical Architect and Lead Developer
Information Technology
Jan 2004 - Jan 2007
Data Warehouse - * Technical Architect and Lead Developer in the replacement of a legacy mainframe reporting system for the internal and state compliance reporting of a property/casualty insurance organization with an enterprise business intelligence system using SQL Server and SAP Business Objects
Business Intelligence Data Warehousing SAP SQL SQL Server
Remove Skill
Senior Data Management Architect
Jan 2003 - Jan 2004
No skills were added
Remove Skill
Senior Data Warehouse Architect
Banking/Financial
Jan 2000 - Jan 2002
  • Designed enterprise data warehouse and systems to facilitate cross-sell between life insurance customers, brokerage customers, and retail banking customers i
  • Managed the implementation of the CRM system for the retail bank and integration with the data warehouse
Data Warehousing
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
University of Missouri 1997
Business Administration majoring
University of Missouri 1993
Minor: Economics
Certifications
Certified Data Management Professional - DAMA
Master Level
Certified Business Intelligence Professional - TDWI
Mastery Level
Skills
Business Intelligence
2018
16
Project Management
2017
15
Application Development
2015
11
Data Warehousing
2020
10
Data Architecture
2021
8
SQL
2020
8
SQL Server
2020
8
MS Azure
2021
4
MS Power BI
2020
4
Data Governance
2021
3
DBA
2009
3
ETL
2020
3
SAP
2007
3
CRM
2018
2
Data Mapping
2020
2
Data Migration
2020
2
MS Visio
2018
2
SSIS
2020
2
SSRS
2018
2
Data Analysis
2017
1
Data Engineering
2021
1
Data Integration
2018
1
Data Visualization
2021
1
ERP
2018
1
Informatica
2018
1
Machine Learning
2021
1
Process Improvement
2018
1
Tableau
2017
1
Azure Data Factory
2020
1