Power BI Developer - Contractor

Johnson Controls

Nov 2021 - Now

• Part of IT ePMO team task to develop Power BI solution for IT PMO. Focusing on providing insight into portfolio, financials, RAID, demand, and phase gates for projects through data visualization.  An average of 400 IT projects a year.

• Implemented a Power BI IT Portfolio Health Dashboard giving actionable awareness to data quality and warnings within projects in IT PMO. Aided in maintaining less than 5% data issues, improving data quality and trustworthiness.

• Created a development process for requirements, security, data sources, modeling, design, functionality, distribution, training, monitoring, and maintenance. Improving efficiency in the development process of Power BI builds and enhancements to cut down on release time.

• Implement IT Power BI Governance for workspace, data, and content. Providing security for access and sharing. Data trustworthiness, security, and performance. Content usage monitoring, performance, and support.  Setting a best practice standard.

 

Report Analyst - Contractor

Clarios

​Mar 2020 - Sep 2021

• IT TMO Command Center analyst tasked to track progress, critical go-lives, and incidents on 94 transition projects between Johnson Controls and Clarios.  Over 125,000+ incident records were examined providing a proactive approach allowing only .003% of production impact globally.

• Developed automated migration tracking for emails, One Drive, PC assets, and server assets. A scope of 9,300+ emails, 9300+ One Drives, 9000+ PCs, and 9000+ servers.  Accomplished by blending multiple data sources and ETL process for a 98%+ migration success rate. 

• Created Asset Management data quality process and lease analysis for global IT.  With a growing asset record of 25,000+ in CMDB, it can be maintained over 95% accuracy and completeness.  Asset Leasing analysis of 40,000+ records identified a 1.6 million dollar potential savings a year. 

• IT PMO long-term solution for portfolio financials, project milestones, and demand.  Optimizing dynamic reporting to free up weeks of work into mere minutes.  Providing key insight across the organization for IT projects.

​

Regional Data Analyst

Gannett

​Jun 2017 - Mar 2020

 

• Managed 16 sites acquisition, retention, and volume of subscriptions across the US.  Providing insight into campaign performance and trends.

• Leadership level business intelligence reporting and dashboard build.  Handling 80 million rows of data to provide day-to-day company-wide aggregated subscription volume, revenue gained, and losses.

• Monthly, quarterly, and yearly forecasting and budgeting process. Comparing WOW and YOY analysis.

• Provide training material, documentation, and meetings to give team knowledge on new techniques, processes, and tools. 

​

System and Sales Coordinator 

Milwaukee Journal Sentinel

​Dec 2012 - Jun 2017

​

• Daily reporting and analysis on subscriptions for main and sub-products. Utilizing business intelligence to interpret 250,000 records of data in a simple and comprehensive way.

• Design customer penetration reporting and potential growth within selected areas.

• Manage retention strategy to maintain strong loyalty and decrease churn.

• Outbound/Inbound marketing strategies throughout the customer life cycle.

• Strong vendor relationships to meet sales goals and expectations.  

​

Payroll Agent

ManpowerGroup

​Mar 2011 - Nov 2011

 

• Provided information on contractor payroll inquiries and issues within the account.

• Review of contractor information and update process to keep everything current.

• Income tax procedure and distribution within our US entities.

• Track employee progress through various clients.

​

Customer Service Representative

FIS

​Dec 2009 - Feb 2011

 

• Inbound call center handling PPD and credit card account inquiries.

• Financial transaction analysis to spot any strange activity on a customer card.

• Fraudulent activity tracking and initiating disputes process.

• Customer information review and update to maintain records up to data.