MATTHEW R BRERETON *** YACHT CLUB WAY, #***
REDONDO BEACH, CA 90277
***************@*******.***
Summary of Experience and Qualifications
Matthew is a seasoned Business Intelligence expert with almost 10 years of experience in the Business Intelligence industry. He has extensive business intelligence and data warehousing expertise, Project Management experience, and is a Business Objects Certified Professional™. Matthew also has proven team building and leadership skills, backed by professional successes, analytical ability and a passionate pursuit of best practices. Experience expands from project management, tech config, migration, design, report building expertise.
EXPERIENCE
Cetera
Project Manager
May 2010 to Present
Project: Business Intelligence Road Map & Advisory Reporting
• Managed Advisory Reporting project team that consisted of internal and external resources.
• Resolved reporting issues that affected over 8000 external clients reports.
• Developed project charter, timetable, and manageable deliverables.
• Created companywide report and analytic inventory
• Developed Business Intelligence gap assessment and project plans to eliminate reporting gaps.
State Farm Insurance
Business Intelligence Analyst
2008-2009
• Managed team of report developers, data modelers, and ETL developers charged with developing an automated aggregated reporting environment to eliminate multi manual processes.
• Assisted with managing departmental change processes.
• Developed a collection of complex Business Objects reports to support a new , and the world’s largest, claims system.
Deloitte Consulting
Senior Consultant
2007-2008
Client: Good Year
Project: Business Intelligence Assessment
• Provided recommendations supporting Business Intelligence Governance and best practices to client team members.
• Led and developed Business Intelligence Roadmap for a multi-division analytic solution which reduced costs and increased revenue to the corporation.
• Responsible for working with various business departments to grasp a firm understanding of the corporation’s global business intelligence practices.
Client: Disney Studios
Project: Cognos Assessment
• Responsible for working with Corporate Business Unit to grasp a firm understanding of the corporation’s business procedures.
• Led and developed Business Intelligence Roadmap for a multi-division analytic solution which reduced costs and increased revenue to the corporation.
• Created business project plan that includes multi-national staffing, technical infrastructure, budget, timeline for key deliverables, etc.
Client: Cessna
Project: Reporting & Dashboard System Design
• Managed report development team responsible for capturing Business Objects report requirements.
• Developed Business Objects XCelsius Dashboard pilot.
• Created Supply Chain and Financial reporting specifications.
• Created Financial ETL specifications to capture historical and future data within the Enterprise Data Warehouse.
• Provided expertise around the capabilities and the functionality of the Business Objects XI R2 suite.
The Revere Group
Manager
2005-2007
Client: Baldwin & Lyons Insurance
Project: Business Objects Migration
• Managed the work of report developers and data base team members tasked with migrating legacy Business Intellignece platform.
• Created the Project Roadmap to highlight key milestones when creating the project deliverables, defined requirements, scope, duration and cost of project.
• Scoped and developed several Business Objects XI reports.
• Performed the reporting system migration.
• Organized and oversaw the functional and data quality testing activities.
• Created Red Brick to SQL Server DB migration.
• Designed future plans for system growth.
• Developed and conducted knowledge transfer phases.
• Managed team responsible for conversion of Red Brick databases to SQL Server databases.
Client: The Hub Group
Project: Business Objects Migration
• Managed the work of client Information Technology resources to complete Business Intelligence platform migration.
• Created the Project Roadmap to highlight key milestones when creating the project deliverables, defined requirements, scope, duration and cost of project.
• Designed and built the Business Objects XI R2 environment.
• Performed the reporting system migration.
• Organized and oversaw the functional and data quality testing activities.
Accenture
Senior Consultant
2003- 2005
Client: Silverpoint Capital
Project: Business Intelligence Roadmap
• Created the Project Roadmap to highlight key milestones when creating the project deliverables.
• Resulting technical solution was developed using the Business Objects Xi platform.
• Developed several Business Objects XI reports to meet customer requirements.
• Worked with the project steering committee to track and manage project milestones, and with business analysts from various functional areas to define and agree on requirements, scope, duration and cost of project.
• Managed the work of client and contracted Information Technology (IT) resources based off-shore and on-shore.
Client: Nissan
Project: Business Intelligence Roadmap and Reporting Environment Design
• Lead the completion of the Analysis Phase deliverables including functional requirements documentation, screen mock-ups, As-Is & To-be process flows, & data elements.
• Worked with the project steering committee to track and manage project milestones, and with business analysts from various functional areas to define and agree on requirements, scope, duration and cost of project.
• Analyzed the Pricing Processes within the organization and the industry, noting issues of concern.
• Based on the Ad-hoc Reporting requirements gathered from the functional users, designed the Business Objects Xi environment, including the security and functional processes.
• Designed in detail, Static, “Pixel Perfect” Business Objects Xi (Crystal) reports with detail for user signoff and adhering to standards for 3rd Party Build team acceptance.
• Defined Report Scheduling, Distribution, and Alerting process.
• Developed Business Objects XI and Crystal Reports to meet customer specifications.
• Cultivated client relationships to facilitate requirements gathering and design completion
• Created detailed project plan for project build phase for the defined requirements to hand off to off-shore developers, and managed the work of these resources.
• Mentored and coached other BI team members to assist with the development of their skill sets.
Client: Miller Beer
Project: Cognos Roadmap
• Developed Standards and Guidelines around Business Intelligence Governance for the Reporting Environment for the user committee.
• Responsible for working with the power users and business analysts to develop project milestones, requirements, scope, duration and cost of the project.
Client: The Capital Group
Project: Business Objects Implementation
• Conducted POC testing to prove functionality between Business Objects Xi and SAP BW using a BAPI Driver.
• Outlined in detail, Business Objects Reports and Universes, adhering to the guidelines outlined by functional users.
• Designed and developed Universes based on multi-cube data sources.
• Designed and developed multiple business objects reports utilizing Business Objects XI.
• Designed and Integrated BI Ad-hoc Reporting environment.
• Created departmental guidelines and standards for report design and development.
EDUCATION
Information Technology, Bachelor of Science August 1995 – December 1999
Indiana University, Bloomington, IN
ACTIVITIES & AWARDS
Florida Ironman Triathlete
Member of the Clif Bar Marathon Pace team
St. Jude Children’s Cancer Research Hospital Chicago to Peoria Run Captain (10 years)
Skills
Business Objects XI R1,R2
Business Objects 5.x,6.x -
Business Objects Xi w/SAP-BW
Business Objects Supervisor
Business Objects Designer
Business Objects Web Intelligence
Business Objects CMC
Business Objects Dashboard Manager
Business Objects XCelsius
Crystal Reports
Cognos ReportNet -
Cognos 8
Hyperion/Brio
PL/SQL
SQL
Certifications
Business Objects XI
Business Objects Certified Professional – Business Objects Enterprise Xi R2
Business Objects Certified Professional – Business Objects Xi Migration