Michael Heitz Email & Phone Number

Glenview, Il, Us

Leading a cross functional team that consists of Data Governance, Engineering, and Analytics. PrimaryStrategy & Operational lead for Enterprise Data Warehouse architecture and migration consistingof over 100 datasources being integrated to a comprehensive enterprise reporting platform. Developedand led project plans with key stakeholders across organization including Marketing, Finance,Business Development, and Educational Outcomes. Spearheading collaboration betweenData team and UX/Dev teams to improve our Agile implementation and provide better project visibilityand accountability. Partnered with IT and other departments to develop AI strategy and roadmap for the organization with goal of improving processes and enhancing our analytics capabilities.

Glenview, Il, Us

Lead Analyst, applying advanced analytics techniques and algorithms, and wrangling large volumes of internal and external data. Managing analytical team, including performance reviews, work assignment and development plans. Leading team to improve our company data culture including coaching and mentoring, training, and adoption of best practices focused on improving organizational efficiency. Leading Analytics team in Agile/Scrum training including acting as Product Owner and Scrum Master for Analytics team sprints.Responsible for designing projects with key stakeholder input and developing analyses leading to actionable insights that impact revenue and growth goals. Building and maintaining advanced analytical products, in collaboration with Data Engineering, providing direction and technical scope. Deliver all projects on time, within budget and agreed upon scope, all while collaborating and communicating with key stakeholders as needed through the process.

Rosemont, Il, Us

Senior Business Analyst - Insights & AnalyticsSME for Python and Alteryx within I&A DivisionAutomate Enterprise data refreshes and business reporting with Python scripts.Build complex SQL queries from Snowflake and Oracle enterprise data warehouses for use as data sources for Tableau or Excel reporting.Work with business stakeholders to create engaging and data driven reporting.

Glenview, Il, Us

Working within a collaborative team to analyze health care data.Create Python scripts to wrangle data and prepare for import to SQL server. Utilizing SSIS Packages to import data to MS SQL server.Writing custom SQL queries and views to aggregate data.Importing data to Tableau for Visualization.Using embedded Python and R scripts to perform Time Series and Forecasting analysis in Tableau.Utilizing Excel, SQL, Tableau, and Tableau Prep to analyze and visualize Clinical Survey data for quarterly publication.

Data Collection, manipulation, and analysis. Python scripting for data analysis and process automation.Excel spreadsheet creation and training - including VLOOKUP's, Pivot Tables, etc...Data & Business Analysis backed by 20 years in corporate realm - I have worked at companies big & small!

Santa Ana, Ca, Us

Utilized data analytics with Microsoft Excel to earn President's Club Award within first 6 months with new company.Tracked and analyzed previous sales performance as well as current performances to ensure team met and exceeded target goals.Performed online training for new broker partners to ensure ease of transition to new lending platform.Visited broker partner offices to give face-to-face presentations to executive, sales, and operations staff.

Using data analytics applied to our sales team, we partnered with over 400 mortgage brokers nationwide with a startup lending platform.Exceeded sales goals and surpassed $27 million per month within our first year with company.Performed in office and online presentations for training and marketing purposes for broker partners around the country.Acted as liaison between sales and operations teams to ensure our partners received the best customer service in the industry.Tracked and analyzed sales and business development data using Microsoft Excel and Data Analytics.Managed Constant Contact marketing email lists and campaigns to over 10,000 email addresses daily. Also, created social media platform for team to allow us to better market to and interact with our broker partners.

Iselin, Nj, Us

Managed migration of sales team and broker partners to new lender.Created action plan using Data Analytics with Microsoft Excel to set goals for new business and existing partners.Within 7 months we surpassed all other sales teams in the company.

Applied data analytic methods and procedures to help increase sales team performance from approximately $10 million per month to over $45 million per month.Performed data analysis of our business partners and their business to ensure increase in our market share with our preferred partners.Acted as liaison between over 300 business partners and our internal operations staff to ensure partners received the highest level of customer service.Implemented Constant Contact marketing email campaign to send daily marketing messages to over 7,000 partner email addresses. Created email templates including layout and content.

Managed implementation of Mac OSX Server to support startup application development team. Created user accounts, mailboxes, and implemented network security protocols.Supported both Windows PC and Mac OSX employees working on GIS Application to import data using Ruby on Rails SAAS application.Assisted in data collection and ETL process to import collected data into clean format for import into SQL Database for analysis.

Menlo Park, Ca, Us

Worked with client companies to place full time, permanent, IT staff.Utilized my technical background to vet candidates prior to submission.Used Salesforce for CRM and candidate and client tracking.

Beverly Hills, Ca, Us

Managed local IT team to provide desktop and remote support to approximately 300 employees.Successfully implemented rollout of 250 new computers to local offices including expansion office of 100 sales staff.Managed Windows Active Directory, backup procedures, anti-virus support, and legacy application support for Mortgage Banking office.Trained in ITIL procedures and practices for disaster recovery and business continuity. Successfully implemented plan to ensure business continuity that was tested by Hurricane Charley a short while later.Assisted in deployment of Automated Underwriting system that included SQL Server backend support.Utilized Excel Data Analytics to assist sales teams in meeting forecasted goals.Awarded 2004 Customer Service Employee of the Year for Southeast Region.

Chicago, Il, Us

Planned and led migration from Windows NT to Windows 2000 Active Directory - including approximately 500 MS Exchange Mailboxes.Implemented network and workstation anti-virus protection to shield against viruses, hacks, and intrusions.Team Lead responsible for management of four desktop support technicians for Mac and Windows environment.Managed SQL Database Server and connections to Adobe Cold Fusion. Helped write and clean code for internal web pages entering data into SQL Database.Managed and improved backup server efficiency to ensure business continuity was met in case of an emergency.Interacted daily with senior management and executive team to ensure timely completion of technical projects.

Ba, Economics, German

Diploma, College Prep