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 Skills
business intelligence and data warehousing expertise, Project
Management experience, and is a Business Objects Certified Business
Professional. Matthew also has proven team building and leadership Objects XI
skills, backed by professional successes, analytical ability and a R1,R2
passionate pursuit of best practices. Experience expands from project Business
management, tech config, migration, design, report building expertise. Objects
5.x,6.x -
Business
EXPERIENCE Objects Xi
w/SAP-BW
Cetera Business
Project Manager Objects
May 2010 to Present Supervisor
Project: Business Intelligence Road Map & Advisory Reporting Business
Managed Advisory Reporting project team that consisted of internal and Objects
external resources. Designer
Resolved reporting issues that affected over 8000 external clients Business
reports. Objects Web
Developed project charter, timetable, and manageable deliverables. Intelligence
Created companywide report and analytic inventory
Developed Business Intelligence gap assessment and project plans to Business
eliminate reporting gaps. Objects CMC
Business
State Farm Insurance Objects
Business Intelligence Analyst Dashboard
2008-2009 Manager
Managed team of report developers, data modelers, and ETL developers Business
charged with developing an automated aggregated reporting environment Objects
to eliminate multi manual processes. XCelsius
Assisted with managing departmental change processes. Crystal
Developed a collection of complex Business Objects reports to support a Reports
new, and the world's largest, claims system. Cognos
ReportNet -
Deloitte Consulting Cognos 8
Senior Consultant Hyperion/Brio
2007-2008
PL/SQL
Client: Good Year SQL
Project: Business Intelligence Assessment
Provided recommendations supporting Business Intelligence Governance Certification
and best practices to client team members. s
Led and developed Business Intelligence Roadmap for a multi-division
analytic solution which reduced costs and increased revenue to the Business
corporation. Objects XI
Responsible for working with various business departments to grasp a Business
firm understanding of the corporation's global business intelligence Objects
practices. Certified
Professional
Client: Disney Studios - Business
Project: Cognos Assessment Objects
Responsible for working with Corporate Business Unit to grasp a firm Enterprise Xi
understanding of the corporation's business procedures. R2
Led and developed Business Intelligence Roadmap for a multi-division
analytic solution which reduced costs and increased revenue to the Business
corporation. Objects
Created business project plan that includes multi-national staffing, Certified
technical infrastructure, budget, timeline for key deliverables, etc. Professional
- Business
Objects Xi
Client: Cessna Migration
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
Wisconsin Ironman Triathlete
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)