Brian Armbruster Email & Phone Number

United States

United States

Responsible for reporting and analysis for all aspects of the $100 plus million Information Technology investment portfolio. Prepares financial status reports and briefing materials for agency senior leadership explaining obligation and spending resources exceeding $5 million. Analyzes, develops, and validates cost estimates for budget requests, reimbursable contracts, and monthly dashboards. Reviews project and program office input for the Department of Labor, Office of Management and Budget, and Congressional Budget requests and communicates financial issues to officials for timely resolution.• Develops and utilizes advanced Microsoft Excel tools to analyze, track, and project financial costs and performance data exceeding $10 million• Creates and maintains Excel-based financial models, analysis, and projections.• Communicates updates and recommendations to portfolio managers and sector team building MS Excel forecast/valuation models with multiple operating and capital structure scenarios

Rising Leader who attended the 2018 Disability In week long Rising Leadership Academy and Conference. Mentee in Next Gen Mentorship Exchange o Participated in Technology Innovation Lab challenge – worked with eight other Rising Leaders to create a presentation within 24 hours focusing on improving the lives of individuals and pitched to conference attendeeso Networked with fortune 500 companies o Attended sessions on best practices for diversity and inclusion, new technology innovations, professional development, and communicationso Worked with mentors from the Hartford and Freddie Mac on resume, building confidence for transitioning to the workforce, networking skills, communicating how I use blindness as an advantage, and creating a roadmap and vision statemento Attended Freddie Mentoring day to learn about top five strengths and how to incorporate strengths into discussions, gain advice for my career, and network with leadership at Freddie Mac

• Reviewed Major Command’s Management Directive 715 Equal Employment Opportunity reports to identify non-compliance triggers, barriers to compliance, and inclusion of individuals with disabilities• Built and utilized advanced operations and formulas in excel for data analysis to manage EEO training compliance of 250,000 employees and formulated an efficient solution to track and monitor the percentage of employees taking required training • Compiled data from Human Resources enterprise system and created spreadsheets for further Equal Employment Opportunity compliance analysis• Prepared trend analysis to manage variances within Management Directive 715 workforce analytics data tables; reengineered workforce analytics dashboard to provide an effective strategy to identify triggers• Reviewed and wrote Strategic Employment Policy manual, Equal Employment Opportunity and Secretary of the Navy manual, memorandums for special awareness month, and team lead for 508 strategic plan

Bala Cynwyd, Pa, Us

• Compiled and gathered data on new business contacts for organizations listed in Guide Star Non-Profit database • Created Excel spreadsheets to determine agent specialty lines of business to identify new business partners• Researched and analyzed the ten major competitors of the company and identified financial strengths for the first and second quarter of 2015 • Wrote data analysis for publication in representatives marketing handbook to be used for financial pitches

Herndon, Va, Us

• Used trend analysis to review variance reports to identify discrepancies and proposed solutions• Troubleshoot and resolved accounting problem which included identifying and matching customer names to billing codes • Managed and analyzed quarterly revenue trends against company data and industry averages• Utilized RazorSight and TMI (IBM Cognos) financial software to compile and analyze data• Presented data charts and excel spreadsheets to senior management

Herndon, Va, Us

• Completed reconciliations using Excel • Tested and reviewed procedures for accounting , procurement and Telco departments • Created XO journal entries for monthly closing according to the timeline• Created notes on credit reserves for manager during usage reviews

Bachelor’S Degree, Finance With A Minor In Economics

Bachelor'S Degree, Finance With A Minor In Economics

Education record