Mike Czerwonky

Experience

• 

  Marine Corps Recruiting

  Jun 1982 - Jun 1988

  Radio Repair - Electronics

  Skills included basic electronics and ground radio repair. Served 2 years on active duty and 4 years in the reserves.Honorable discharge / Veteran

• 

  Hard Warehouse

  Jan 1989 - Jan 1994

  General Manager

  Hard Warehouse was a 9 store computer retail chain selling computers, consulting and network services. I was the service manager for 3 years before being promoted to General Manager. The Indianapolis store was consistently the highest profitable store in the company. I managed a staff of 11 sales and services professionals before leaving to open my own business.The company closed in 1996 after the Internet became a viable place to sell computers and profit margins for brick and mortars stores evaporated. Show less

• 

  Lubicz Communications, Inc.

  Jun 1994 - Dec 2008

  Consultant and Trainer

  Automotive Industry Information Technology ProfessionalMarketed and sold more than 50 complete automotive accounting systems to franchised new car dealerships in Indiana, Ohio and Kentucky. As the owner of Lubicz Communications, I provided a range of software management services including sales, site analysis, cable Installation, hardware procurement and installation, data conversion, software training and follow up technical support. Certified to provide installation and training on ABMC - ADAM automotive accounting software. Performed more than 200 multi day training sessions at dealerships all across the United States over a 10 year period of time.Developed data mining and conversion division of the company. Using modems, IP connections, remote communications and ad hoc reporting tools, captured and converted accounting, vehicle sales & service history and parts inventory data from ADP, Reynolds and Reynolds and other legacy automotive system. Process was ever evolving and improving and more than 250 conversions were completed in 4 year time period from 2005 to 2008.The recession of 2008 significantly changed the automotive industry, Many of my established clients were small town Chrysler and GM dealerships that were bought out or closed down around this time. Show less

• 

  St.Vincent Health

  Dec 2009 - Jun 2012

  Data Analyst

  Quality Assurance DashboardsProcess Improvement projectsDesign Access Databases

• 

  Blue & Co., LLC

  Jun 2012 - Mar 2014

  Data Analyst - Health Care

  Performance Improvement ProjectsDevelopment of QlikView Visual Analytics ReportsData Mining of Healthcare data from CMSHealthcare ConsultingProject Management

• 

  Accountable Care Consortium

  Mar 2014 - Jun 2014

  Business Intelligence Analyst

  Data mining and analysis on historical health care claims using Optum Data Mart and SQL. Perform trend analysis and collaborate with population health management and patient care services staff to improve patient outcomes and reduce egregious expenses.Design, develop and support a multi user SQL database with MS Access front end to manage and maintain the analytics for the ACC provider network.

• 

  Key Benefit Administrators

  Aug 2014 - Jun 2016

  BI Developer

  Design, develop, support and administer Qlikview applications.NPrinting report development.

• 

  Modis Deutschland

  Jun 2016 - now

  Qlikview Developer

  Senior member of the business intelligence development team for a Fortune 500 company.Manage projects to provide visual analytics solutions for stakeholders using Qlikview and Nprinting.