Bryan Weir Email & Phone Number

Dallas/Fort Worth Area

• Finance Consultant specializing in SAP BPC (Business Planning and Consolidation) software implementations and upgrades.• Lead Projects to develop environments and models used to improve forecast accuracy and reporting.• Liaison between Finance and IT for Finance and FP&A applications.• Successful working with Finance, IT, and cross-functional teams.

Dallas/Fort Worth Area

• Implemented upgrade to SAP BPC 10 for a multinational government contractor. Redesigned environment, models, dimensions, input and report templates to enhance the ability to perform entity and project reorganizations efficiently.• Led implementation of SAP BPC 10 for a large electric and energy corporation to improve operational awareness of corporate reporting and analysis.• Created SAP BPC environments and models to achieve greater flexibility, performance, forecast accuracy and less required maintenance for Finance and IT.• Provided onsite training to Senior Financial Analysts and IT for utilizing and supporting SAP BPC.• Managed project relationships such as demonstrations, mock-ups and setting expectations, goals, deadlines and deliverables.

Houston, Texas Area

• Onsite BPC MS Consultant for the ongoing development of the planning tool supporting upstream planning teams for a multinational integrated Oil & Gas corporation for six years.• Developed Global Planning applications to report on production volumes, capital expenditures, reserves, operating expenses, asset management, safety health environment and major project analysis using many complex input templates and reports utilizing BPC.• BPC administrator for daily master data maintenance and utilized SQL to update transaction data to align with master data updates.• Designed SQL allocation logic to automate management level adjustments.• Trained personnel in administering and maintaining the applications, dimensions, data updates, forecasting input schedules, and reports comparing actual data variances to forecast.• Reviewed client systems, structures, and processes to identify where improvements can be made to enhance operations and identify KPI’s (key performance indicators).

Round Rock, Texas

• Led projects automating the forecast, outlook, and sales reporting processes. Consulted on multiple implementations for the development of the Americas Planning Tools.• Prepared, reviewed, and distributed Daily, Weekly, and Monthly reports such as the Daily Sales Report, Americas Weekly Report, Cash Forecast, DPO Forecast, Outlooks, Management Discussion and Analysis, Facilities and Headcount and Backlog reports for Senior Management.• Developed annual forecasts and monthly outlooks and reported on variances to forecast.• Developed special pricing SQL models for the optimization of margins based on statistical analysis of demand along with headcount, product, manufacturing, sales and administrative costs to support the sales operations and maximize revenue.

Bachelor Of Business Administration (Bba), Accounting And Information Systems

Associate'S Degree, Mid-Management

Diploma