Mike W. work email
- Valid
- Valid
- Valid
Mike W. personal email
I’m currently leading a team that specializes in automation, ETL/ELT, system integrations, Business Intelligence and custom adhoc reporting. We’ve been successfully driving analytics and automation at Sikich through building relationships with business leaders to understand their needs and turn them into actionable items. Our success is possible by keeping multiple disparate systems in sync through custom integrations/monitoring and building a custom data warehouse to meet reporting requirements. My tool belt includes: MS SQL (10+ years), multiple reporting tools (SSRS, PowerBI, Crystal Reports, Business Objects), Azure Data Factory/SSIS, Python, Snowflake, Microsoft Power Automate, Postman, SmartConnect, MySQL, and a passion for learning new technologies and solving puzzles.
-
Principal Data EngineerSikich Jan 2023 - PresentChicago, Illinois, UsLead engineer responsible for migrating on premise integrations, analytics and dashboards to Azure. We’re currently utilizing a hybrid environment consisting of Azure Data Lake storage/Azure SQL/various REST endpoints, custom python scripting and on premise MS SQL Servers (2016,2017,2019) to support integrations, reporting and Power BI adoption across the firm. Our goal is to migrate 95%+ of our integration infrastructure from custom python scripts to ADF pipelines utilizing data flows, azure SQL and numerous linked services/datasets. -
Senior Data EngineerSikich May 2021 - Dec 2022Chicago, Illinois, UsFocus on improving business operations through analytics and automation. Design and develop custom ETL solutions to consume and push data to and from onsite and cloud solutions from Microsoft, SAP, Oracle, Concur and others. Utilize Python and Postman for API work. Create, deploy and maintain custom SSIS packages. Use SolarWinds DPA monitoring tools to investigate, diagnose and resolve on-premise SQL issues, resulting in a 95% decrease in wait times and resolving all current blocking issues. Provide data pipelines for our financial analysts. Configure security for PowerBI workspaces, apps and RLS which has led to wide adoption of PBl. Perform SQL upgrades, installs, migrations and maintenance plans for 10+ instances of SQL. Utilize Microsoft Power Automate to create business automations.
-
Manager Business Intelligence & AutomationSikich May 2019 - Apr 2021Chicago, Illinois, UsLead the dev opps and analytics team. Design, develop and implement custom integrations between Dynamics CE and other business applications, business process automation, SharePoint customizations and workflows, business intelligence reporting, data warehousing and custom MSSQL development.
-
DeveloperSikich Apr 2018 - Apr 2019Chicago, Illinois, UsWork with team leads to identify and provide meaningful data to help improve business processes and facilitate accurate analysis. Build custom reporting solutions using SSRS, Microsoft Power BI, Jet Reports, and other BI tools.Extensive experience writing adhoc T-SQL queries, stored procedures, views and functions. Deploy, maintain and update various versions of SQL.Create, monitor and maintain custom data integrations from SAP's Concur, ConnectWise, CCH Time and Billing, Microsoft Dynamics and custom Microsoft SQL Server data warehouses. Automate business processes utilizing workflow utilities, SharePoint, Microsoft Flow, and custom applications.
-
Senior Managing Consultant, Strategic TechnologySikich Mar 2017 - Apr 2018Chicago, Illinois, UsResponsible for scoping, constructing and managing custom development projects. Create and manage Azure virtual environments for development and testing solutions. Collaborate with clients to assess needs, discuss potential solutions, and manage/create solutions to improve business processes. Perform fit/gap analysis, use cases, test plans, and final documentation. Extensive work analyzing and completing data integrations, server migrations, data analysis and other custom solutions.
-
Managing Consultant, Strategic TechnologySikich Jan 2015 - Mar 2017Chicago, Illinois, Us
-
Senior Application ConsultantSikich Jan 2013 - Jan 2015Chicago, Illinois, Us
-
Application ConsultantSikich Feb 2012 - Dec 2012Chicago, Illinois, Us
-
It ManagerAccesstek Dec 2009 - Jan 2012Naperville, Il, Us -
Technology SpecialistAccesstek Aug 2006 - Nov 2009Naperville, Il, Us
Mike W. Skills
Mike W. Education Details
-
Benedictine UniversityGeneral
Frequently Asked Questions about Mike W.
What company does Mike W. work for?
Mike W. works for Sikich
What is Mike W.'s role at the current company?
Mike W.'s current role is Data Engineer.
What is Mike W.'s email address?
Mike W.'s email address is mi****@****ich.com
What schools did Mike W. attend?
Mike W. attended Benedictine University.
What skills is Mike W. known for?
Mike W. has skills like Microsoft Sql Server, Business Analysis, Ssrs, Business Intelligence, Microsoft Azure, Sql Azure, Project Management, Data Warehousing, Microsoft Dynamics, Erp, Software Implementation, Microsoft Dynamics Gp.
Who are Mike W.'s colleagues?
Mike W.'s colleagues are Karen Davis, George Ball, Aaron Sullivan, M.s., Kyle Middleton, Victoria Dailey, Erica Ross, Amanda Dombrowski.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial