Financial Analyst Senior

KELVIN MEDRANO

**** ******* **. ***** ***, VA ***37

571-***-**** ************@*****.***

PROFESSIONAL SUMMARY

Results-driven Senior Financial Analyst with over 7 years of experience in financial reporting, budgeting, forecasting, and variance analysis. Proven track record in managing multimillion-dollar budgets, developing financial models, and collaborating with cross-functional teams to drive strategic initiatives. Adept at utilizing advanced Excel functions and ERP systems to streamline processes and enhance data accuracy. Committed to delivering actionable insights to support organizational growth and efficiency.

CORE COMPETENCIES

Financial Planning & Analysis (FP&A)

Budgeting & Forecasting

Variance Analysis

Financial Modeling

ERP & BI Systems Proficiency

KPI Development & Reporting

Cross-Functional Collaboration

Process Improvement & Automation

PROFESSIONAL EXPERIENCE

Senior Financial Analyst

GPI Enterprises Inc., Reston, VA August 2023 – May 2025

FedSync March 2020 – August 2023

Federal government contractor overseeing multimillion-dollar budgets and financial operations for the Department of Interior (DOI).

Managed and oversaw a $25M+ annual budget across multiple DOI accounts, ensuring accurate fund allocation and expenditure tracking.

Prepared quarterly financial projections for 20+ bureaus/agencies, aligning costs with contract requirements.

Conducted variance analysis to identify budget discrepancies and recommended corrective actions.

Developed complex algorithmic reports detailing fiscal year services and shared costs among bureaus/agencies.

Performed monthly reconciliations to validate billing accuracy, resolving discrepancies with vendors.

Generated detailed financial statements to support telecommunications billing operations.

Partnered with accounting teams to ensure fund availability and resolve financial inconsistencies.

Key contributor to a cross-functional initiative transitioning all DOI telecommunications services to new contracts.

Led billing dispute resolution meetings between DOI agencies and vendors, ensuring accurate and timely payments.

Utilized advanced Excel functions, including Pivot Tables and VLOOKUP, to extract and analyze specific data sets.

Billing Analyst II

DC Water and Sewer Authority, Washington, D.C. April 2018 – March 2020

Managed billing processes for suspended customer accounts, ensuring accuracy using SAP.

Identified and resolved invoice discrepancies, communicating solutions to leadership.

Analyzed customer accounts to ensure proper balances and identified billing errors.

Calculated adjustments for back billing and credit reconciliations.

Performed in-depth financial reviews of government, key account, and commercial accounts with complex billing structures.

Contributed to process improvements, analyzing operations to enhance productivity.

Assisted in transitioning to a computerized billing system, streamlining financial workflows.

Senior Billing Account Manager

Studebaker Submetering, Inc., Alexandria, VA June 2017 – March 2018

Billing Account Manager

Studebaker Submetering, Inc., October 2013 – June 2017

Managed a portfolio of 60-70 large commercial clients, ensuring accurate billing and account management.

Generated profit/loss statements and recapture comparison reports for clients.

Conducted residential rate analysis, optimizing utility billing for clients.

Prepared annual consumption reports, detailing usage trends and cost analysis.

Monitored and tracked utility expenditures, improving financial oversight.

Promoted from Customer Service Representative to Account Manager within 3 months, demonstrating strong analytical and client management skills.

EDUCATION

B.A. in Business Management

Radford University, Radford, VA May 2011

PROFESSIONAL AFFILIATIONS

La Sociedad Hispánica – Organized meetings and activities, fostering cultural engagement.

Limestone College, NCAA Division II Wrestling – Collegiate-level athlete, demonstrating leadership and discipline.

Contact this candidate