Candidates About

SUMMARY

Information Technology Project Manager, Analytics with additional experience as a business intelligence analyst with a successful track record of developing business intelligence and analytics solutions. Experienced in relocation, manufacturing, and transportation industries and strategic planning, developing roadmaps, and managing budgets.  Key areas of strength include:

PROFESSIONAL EXPERIENCE

Project Manager, IT Analytics – SIRVA, Worldwide

Oakbrook, IL, July 2014 to September 2017

SIRVA Worldwide, Inc. provides more than 280,000 relocations per year to corporations or individuals offering over 50 mobility solutions in 170 countries.  They have 73 disparate systems being brought together in a common data warehouse and data lake for reporting, dashboarding, and analysis to provide deep insights for their client base. 

Reported directly to the CTO/CIO and worked daily with all levels of executive management including the CEO and CFO.  Responsible for a $3 MIL+ annual CAPEX budget.  Directly responsibility for data architecture, modeling, data quality, data warehousing, business intelligence, and metadata management.  Daily management of the Business Intelligence team for Information Systems.  Developed and implemented policies and procedures and established standards for the team.  Worked cross-functionally with the IT Infrastructure team to design hardware configuration to support reporting and analytics software development and provide disaster recovery.  Worked with Network Security to implement security procedures to secure PCI and PII data.  Organized team for project work as well as ongoing maintenance, and troubleshooting and resolving incidents. 

Built a highly efficient Business Intelligence team to improve development through-put.  Team grew from 4 people to a 16-person team including onshore/offshore resources as demand in all areas of reporting, analytics, and visualization for our client base grew.  Interviewed and hired all team members. Provided leadership, direction, and coaching to several direct reports including a BI technical architect, Integration Architect, project managers, ETL, and ESB Developers, Report and Dashboard designers, and Quality Assurance Analysts

·         Improved the speed to market for data by 200% by implementing Operational Data Stores, Azure Data Lake Store and SQL Data Warehouse using Microsoft Azure Cloud Services while maintaining governance and compliance to SIRVA standards and providing one version of the truth for reporting.

·         Tripled the data available for reporting through successfully managing projects adding three of the largest customized systems, including Servicengine, Relo Advantage, and Assignment Pro to the enterprise data warehouse.  This allows combined reporting of fact tables through common dimensions and star schemas used with SAP Business Objects and Birst Dashboards.  Reporting and analysis now can be done for five different process flows including client finance, operations, supply chain, travel lanes, and quality

·         Improved relationship between IT and the business by 100% through setting proper expectations and working with the business to prioritize work

·         Improved quality and reduced number of defects by 45% prior to hand off to UAT by implementing a proper SDLC with improved forms for requirements gathering, data modeling, data mappings, and QA testing.  Implemented both waterfall and agile type project management methodologies.

·         Successfully led project to upgrade SAP Business Objects XIR2 to BI4.2

·         Showed innovation by naming and developing new product “SIRVAlytics” the largest differentiator for the business helping them win over $10 million in sales in Europe alone building competitive advantage and further developing business.

Principle Business Intelligence Analyst - WMS/Scientific Games

Waukegan, IL, April 2009 to July 2014

Team leader responsible for designing, implementing and supporting business intelligence roll out of Business Objects and a data warehouse across an Oracle ERP platform for a $750 Million dollar developer and manufacturer of casino gaming devices.  Worked independently utilizing proper time management and multitasking to complete assignments.

·         Increased business engagement by 200% through business partnership

·         Completed over 55 requirements documents for three hundred reports that would utilize Business Objects SAP Web Intelligence allowing users to decrease manual time spent on reports by half

·         Built two highly functional Business Objects universes utilizing star schema model in Information Design Tool (IDT) for Quality Department expected to improve supplier sigma from current 3.95 sigma to 5 sigma

·         Built an additional five Business Objects universes for Supply Chain to automate planning, purchasing, inventory management, and assembly processes providing 100% more reporting flexibility

·         Saved over 160 (FTE) hours monthly by developing long term training strategy, creating online training opportunities, and directly training 700 individuals in basic Web Intelligence report building

·         Guided ETL development for over 20 business processes with several contract ETL developers

Business Analyst / Consultant - Disys

Downers Grove, IL, August 2008 to March 31, 2009

On site contractor with Havi Global Solutions, supply chain management company for McDonald's Corporation

·         Decreased project rollout defects by 20% by reviewing and approving business requirements, functional designs, and technical designs for ETL jobs, data warehouse, Business Objects universe and reports and developing test scripts and unit testing of the final implementation using Toad and SQL against the data source and comparing it to the data warehouse and report output

Sr. Staff Analyst – Automation - United Airlines - Airport Operations and Cargo Technology Department

World Headquarters Elk Grove Township, IL, April 2005 to July 2008

Project manager and business technology analyst overseeing technology projects as liaison between Airport Operations and Cargo divisions and ISD (Information Services).  

·         Improved reporting process cutting report creation process by 75% by successfully implementing Business Objects XI R2.  Moved reporting from Cognos Cubes to Business Objects Universes. 

·         Reduced cargo processing time and customer wait time by 25% by moving cargo acceptance software from AS400 platform to a speedier web based platform

·         Recognized in last review for exceeding expectations for decision making and for the ability to find unique and creative business solutions

·         Implemented ISD Work prioritization process utilized by Cargo and Airport Operations which assisted business units in identifying millions of dollars and time savings through cost benefit analysis to determine proper ISD work priorities

·         Increased division document search efficiency by 75% by converting paper files into electronic files allowing vendor contracts, sales documents, and customer contracts to be quickly identified and utilized

Store Owner/Operator - Hoagi’s Fascini

Lombard, IL Yorktown Mall and St. Charles, IL Charlestowne Mall, November 2004 – April 2005

Owner for two retail locations set up over Christmas season specializing in modular jewelry sales.  Improved my own understanding of business management and the meaning of cash flow in business by 100%

Order Fulfillment Manager/ Call Center Manager - Pella Windows and Doors, Inc.

Carol Stream, IL, January 2002 to November 2004

Converted service department into a state of the art call/contact center.  Promoted to Order Fulfillment manager to apply techniques and implement technology to improve customer service and business workflow in Order Fulfillment Department.

·         Reduced call abandon rate by 41%, successfully implemented Rockwell Transcend Call Center Software and implementing first call resolution and other key metrics.

·         Co-led two Kaizens, a week long continuous improvement initiative, which reduced call wait times by 40% and reduced 30 step work flow steps by 7

·         Successfully lead and implemented project expected to save Pella $5 Million by reducing the number of multiple service calls by technicians nationwide

EDUCATION

DEVRY UNIVERSITY, Illinois

Bachelor of Science, Telecommunications Management 2002             

RAPPORT LEADERSHIP INTERNATIONAL, Nevada

Leadership Breakthrough I - August 2004

ORGANIZATIONAL MEMBERSHIPS

ASUG (America’s SAP Users Group), Chicago, IL

Member since 2005    

Speaker during the SAPPHIRENOW 2011 SAP Conference

Subject Title:  Self-Service Support for End Users Through Your Intranet  

Project Management Institute (PMI)

PMP Training, working toward PMP Certification

Toastmaster International, Glendale Heights, IL

Chapter President 2009 - 2010

Glendale Heights Chapter