John A. Lucero

703-***-**** ad3ge7@r.postjobfree.com

SUMMARY

Insightful financial, business, budget analyst, and process improvement specialist. Ability to drive business transformation and improve performance. Collaborate with internal and external partners to deliver innovative solutions to problems that add business value.

Excel, Access, PowerPoint, Project, Visio Google Suite Agile SharePoint Oracle Financial VBA Tableau

Salesforce Workday Power BI Cognos Scrum Master Six Sigma Database & SQL Verizon August 2022 – Current

Phoenix, AZ

Budget Consultant

• Prepare and present detailed capital and expense budgets. Present weekly budget performance.

• Streamline budget process to be a consolidated method of data collection and automated process.

• Report budget variances and investigate differences between the expected and actual.

• Responsible for evaluating budgets, cost projections, financial planning, and analysis activities.

• Provide insights and recommendations on financial performance.

• Establish capable and transparent working processes supporting cost efficiency, improved productivity, minimize risk, and support business objectives.

• Provide timely management information and financial reporting to drive decision making. Create financial models and analysis for review.

• Increased the effectiveness of data collection and display data in visual format to help with interpretation. Federal Home Loan Mortgage Corporation April 2012 – January 2022 Fairfax, VA

Business Management Senior

• Collaborate with senior leadership to develop business approaches to achieve business expectations.

• Performed the assessment and provided the methods and solutions for continuous improvement opportunities.

• Automated tasks to improve and accelerate the business processes, reduce cost, and put in place a versatile system design to accommodate future business changes.

• Monthly presentation to VP and directors on business performance and provide recommendations and solutions to overcome underperforming business activities.

• Prepare financial and budget analysis and deliver via reports and presentations for management.

• Responsible for collecting, tracking, and reporting business units’ financial data and performance.

• Accountable for the analysis for new mortgage loans data requirements and write impact review to mortgage loans volume and possible business challenges.

• Worked with mortgage servicers experiencing a high number of mortgage submission failures. Set up a system to fast-track mortgage settlements to meet demand.

• Design interactive visual dashboards that analyze, monitor, and visually display key business metrics and trends allowing leadership to interact with the information and make well-informed data-driven business decisions.

• Managed project teams: Coordinate stakeholder meetings and messaging between business partners and present weekly updates.

Acentia, Falls Church, VA December 2011 – March 2012 Falls Church, VA

Business Consultant

• Establish system processes for aligning payment schedules with vendor payment cycles, improving transaction reporting, transparency, and monitoring. Wrote statement reports on contract pricing variations and presented weekly to unit directors. Navy Federal Credit Union January 2008 – November 2011 Vienna, VA

Senior Saving Portfolio Analyst

• Assemble data platforms for collecting and organizing information from various sources to build customer profiles.

• Analyze business financial data and industry trends to make reliable recommendations.

• present monthly portfolio performance and potential portfolio risk from competitors and the economy.

• Evaluate market risk to determine possible penetration opportunities on price or introducing new savings products and communicate to senior management.

• Evaluate competitors and market trends to implement strategies to mitigate financial risks to the portfolio.

• Present monthly industry and competitors’ products, regulation information and market promotional offers that could possibly shift assets away from the portfolio.

• Led the evaluation of savings products and services monthly meetings. George Washington University February 2001 – December 2007 Washington, DC

Senior Business and Financial Analyst / Accounting Analyst Supervisor

• Supervised two analysts. Controlled the budget cycle preparation, approval, and execution.

• Accountable for financial planning and analysis, financial modeling, forecasting, and developing budgets. Present financial performance monthly to VP.

• Oversee indirect budget costs for projects, maintenance expenses and utilities.

• Collected and analyzed data to evaluate retail performance and customer experience.

• A/P, A/R, P&L business income and expenses review and payroll responsibilities. Financial statement reporting.

• Review and analyze accounting data and prepare financial reports that comply with GAAP.

• What-if analysis to establish confidence in business decisions for strategies and promotions.

• Present monthly variance analysis. Financial analysis to identify patterns, improve revenue and business value. Ad-hoc analysis on request. Monthly KPI performance analysis.

• Evaluate vendor contracts for products and services to determine suitability and business risks. Evaluate vendors requests for price increases and gauge the impact on revenue and volume. EDUCATION

Master of Science, International Management and Finance (MS) University of Maryland University College, Adelphi, MD 2014 Master of Business Administration (MBA)

New York Institute of Technology, Old Westbury, NY 2009 Bachelor of Science, Business Administration (BSBA) George Mason University, Fairfax, VA 2000

Contact this candidate