Data State University
Resume:
William Horgan
**************@*****.***
Professional Summary
Mr. Horgan is a Certified Six Sigma Green Belt with more than 5 years’ experience in Data Management, Consulting, Process Management and Financial Analysis. He has researched, gathered, analyzed, cleansed and manipulated large amounts of complex data for reporting. He has established Key Performance Indicators by analyzing historical data and forecasting future trends. He has extensive experience utilizing Excel to cleanse large amounts of data, analyze financial data, formula inputs, template creation, and reporting. He can work independently or manage teams. He has excellent verbal and written communication skills.
Professional Experience
Ford Motor Company (Contract with Halo Group from May 15 – Nov 15) May 15 – Present
Analytics Architect/Business Analyst
Identify, research, test, and purchase analytics tools and software
Present findings to the Stakeholders and make tool and software and governance recommendations for analytics
Develop and implement internal customer solution
Collect requirements to understand the needs of the internal customer
Develop Use Cases for Proof of Concept testing
Develop architecture visualizations and diagrams
Manage IT architecture projects by planning key milestones, developing attainable timelines and meeting the needs of the business
Lead knowledge management proof of concept projects and initiatives in multiple areas of business and IT which concluded with a documented repeatable process
Conduct information studies to collect quantitative and qualitative data to analyze to drive performance
Utilize statistics and analytics to create models to representation the data
Defining project scope by investigative research and defining requirements
Discover, Plan and implement cost savings initiatives through process improvement
Perform internal interviews to identify operational bottlenecks and present solutions
Identify trends through data and research
Create SharePoint pages and libraries to streamline information storage
Create and perform organization wide communication of improvement and process planning
Information Services Group (ISG) Jan 14 – Apr 15
Consultant
Research, gather, analyze, and manipulate large, complex data
Perform seasonality and trend analysis of performance data, sales, hiring/sourcing, IT planning, and manufacturing
Establish Key Performance Indicators by analyzing historical data and forecasting future trends
Work with multiple clients and accounts concurrently
Create multiple base cases and business cases from the ground up for project goals, pricing, strategy, and execution
Responsible for step-by-step creation of RTP’s for customer corporate wide change initiatives
Utilize Six Sigma techniques while leading projects creating LEAN strategies enhancing output and efficiencies
Lead multiple project teams to ensure operational excellence by designing and implementing customized operations, IT, performance and sourcing solutions
Interact and communicate daily with stakeholders, including client executive team, corporate partners, internal customers, and operation managers
Design, document, and execute customized solutions to ensure short-term and long-term success of projects
Create desktop procedures to transition work to multiple departments
Use Excel daily to cleanse large amounts of data, analyze financial data, formula inputs, template creation, and reporting
Report findings and solutions to client executive teams
Work with large industry leading companies, including General Motors, Rolls Royce, Fossil, and Southwest Airlines
Analyzed application data
Identified trends through data and research
Created and operated Excel Pivot Tables
Uploaded data files to SharePoint repository
Documented training manuals and procedures
Blue Cross Blue Shield of Michigan Mar 13 – Jan 14
Operational Performance/Senior Quality Analyst
Oversaw and monitored daily production data to ensure adherence to key performance indicators and goals
Identified and created solutions to performance issues
Communicated with senior management on the solutions that were needed to meet and exceed acceptable performance levels
Wrote and analyzed sourcing contracts for multiple vendors
Managed multiple projects concurrently
Facilitated and supervised strategies to maximize production levels using LEAN philosophies learned through the Six Sigma Green Belt Certification process
Designed and implemented process improvement initiatives that saved over $800,000 in less than a year
Forecasted and scheduled call center volumes, claims volumes, sourcing, and employment needs by analyzing large data sets
Used Excel daily to cleanse large amounts of data, analyze performance data, formula inputs, and reporting
Designed Dundas Dashboards with programming team on the SharePoint platform
Used Excel Pivot Tables, and Formula’s extensively for data analysis
Used SharePoint for document management and project management
Documented training manuals and procedures
Michigan State University Aug 11 – Feb 13
Communication Planning/Implementation Manager
Organized and coordinated internal and external communication operations to promote the business school, enhance reputation, build relationships, and monitor image
Managed multiple projects concurrently
Spoke regularly to classes of 30-150 students about professional development opportunities
Only student selected by the Director of the School of Hospitality Business to represent Michigan State University as a Graduate assistant and guest lecturer
Developed customized solutions to marketing and production issues
Created and developed The School of Hospitality Business Website for the Eli Broad College of Business
Used Excel daily to cleanse large amounts of data, analyze communication statistics, formula inputs, and reporting
Gathered data from third party sources
Documented training manuals and procedures
TPI Consulting Jan 11 – Sep 11
Financial Analyst
Provided data, contract, and financial analysis support
Oversaw reporting process of outstanding and overdue invoices
Established Key Performance Indicators by analyzing historical data and forecasting future trends
Managed global financial forecast and process improvement data for General Motors IT Finance Team
Had daily interaction and communication with stakeholders, including client executive team, corporate partners, internal customers, and operation managers
Created desktop procedures to transition work to multiple departments
Prepared, coordinated, and assisted in the creation of statements of work
Provided negotiation support for transaction engagements
Worked with multiple clients and accounts concurrently
Used Excel daily for cleansing large amounts of data, analyzing financial data, formula inputs, template creation, and reporting
Reported findings and solutions to client executive teams
Analyzed application data
Identified trends
Used Excel Pivot Tables, and Formula’s extensively for data analysis
Uploaded data files to SharePoint repository
Documented training manuals and procedures
JPMorgan Chase and Company May 10 – Jan 11
Coordinator/Licensed Personal Banker
FINRA licensed – Series 6, Series 63, Life Insurance and Variable Products
Analyzed personal financial portfolios
Security coordinator who trained others on the security and safety process
Selected as the only banker to join the college recruiting team in the state of Michigan
Walt Disney Company Jan 10 - May 10
Disney Intern at the California Grill
Audited and reconciled all financial transactions, individual banks, international currency, and Disney dining plans daily
Selected by management as the Lead Financial Auditor
Achieved the lowest margin of error (.001%) in the audit process for the duration of the internship of any intern since implementing their new system in 2006
Eli Broad College of Business Career Center Mar 09 – Dec 09
Student Coordinator
Assisted companies in the recruitment process at the Eli Broad College of Business
Created and executed marketing strategies for the schools events and clubs
Selected by the Director of the school as the personal liaison to multiple Fortune 500 CEO’s and Presidents for special events
Managed more than 100 perspective student visits and 200 company visits
Used Excel daily for cleansing large amounts of data, analyzing corporate hiring data, report creation, and hiring statistics
Education
Michigan State University, 2012
Masters’ Degree in Communications, Public Relations
Michigan State University, 2009
Eli Broad College of Business
Bachelors’ Degree in Business
Certifications
Six Sigma Green Belt
Contact this candidate