William A. Huaman

IT PMO Analyst

Summary

Distinguished specialist in data visualization and analysis with 10+ years delivering outstanding results in a data driven world. Possess expertise in understanding business needs, data exploration, preparation, modeling, validating, and visual execution. With a strong background in a variety of Business Intelligence tools and automation processes. Seeking to leverage abilities and provide key insight into complex data for end-users.

achievements

Assisted in the separation of Johnson Controls and Clarios. Tracking transition projects progress and incidents. Completing a 2 year initiative ahead of schedule.
Migrated circulation systems twice accounting for over 80 million records. Sustaining a data quality standard.
Part of a development team creating an online self-service portal UI. Testing customer experience and logic.
Optimizing and automating multiple reports to remove manual processes and increase efficiency. Effectively reducing work load and time.
Discovered a fraud ring costing the company 100,000+ dollars and implementing safe guards to prevent future attacks.

References

Disclosed upon request

Work experience

Nov 2021Now

IT PMO Analyst (Contracted as Power BI Developer for 5 months)

Johnson Controls

Part of the 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% of 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.

Mar 2020Sept 2021

Report Analyst - Contractor

Clarios

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.

Jun 2017Mar 2020

Regional Data Analyst

Gannett

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.

Dec 2012Jun 2017

System and Sales Coordinator

Milwaukee Journal Sentinel

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.

Mar 2011Nov 2011

Payroll Agent

ManpowerGroup

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.

Dec 2009Feb 2011

Customer Service Representative

FIS

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 date.

Skills

Tools

Power BI, Tableau, ServiceNow, QlikView, Adobe Omniture, Data Studio, Daptiv, IBM Cognos, Brio, and MaaX

Computer Languages

SQL, VBA, DAX, and M language

Data Reporting

Sales, subscriptions, projects, inventory, financials, website, ads, and social media

Microsoft Office

Excel, PowerPoint, Access, Outlook, Word, Visio, Projects, SharePoint, OneDrive, Booking, and Teams