Financial Analyst with 7+ years across Financial Services, EdTech and Telecom, focused on financial reporting, budgeting, forecasting, variance analysis and account reconciliation. Currently in FP&A and Financial Reporting at PNC Financial Services. I work in Excel, SQL, Python and Power BI, and I use generative AI for analysis while validating every output against source records.
Forecast accuracy 85% → 92% · Budget variance 8% → 5% · $450K potential savings · $1.2M revenue leakage found · 60% less manual reporting time
|
Three Statement Model Linked income statement, balance sheet and cash flow. Every shock test keeps the balance check at 0. |
GL Variance Analysis Operating income 1.8% below budget, traced to Marketing programs (+15.8%) and Travel (+27.0%). |
Sales Power BI Dashboard $4.0M sales over 4,000 transactions with month to date and same period last year views (+19.8% YoY). |
|
Bank Peer Benchmarking PNC vs 7 regional peers: leads on ROE (12.6%) but ranks 5th of 8 on efficiency (59.2%). |
SEC 10K Peer Analysis Five consumer products companies on growth, margin and cash cycle. P&G operating margin 22.7%. |
Account Reconciliation Bank vs GL rules flag duplicates and missing postings. Open exceptions down 67.9% (184 to 59). |
More projects by area
| Area | Projects |
|---|---|
| Public data forecasting | Macro Driver Revenue Forecast FRED, 98.3% backtest accuracy · NYC Budget vs Actual $6.99B over adopted budget |
| Forecasting and planning | Fee Income Forecast accuracy 85.3% to 92.9% · Rolling Forecast · Scenario Planning · Headcount Forecast · 13 Week Cash Forecast |
| Reporting | AI Variance Commentary 42 of 42 figures validated · KPI Scorecard · Board Flash Report |
| Cost, spend and margin | Vendor Spend Savings $457K · Price Elasticity +$852.9K margin · Margin and Mix Bridge · Unit Economics · Cost Accounting · Zero Based OpEx Budget |
| Revenue assurance and close | Revenue Assurance $1.24M leakage · Month End Close Tracker 32 tasks |
| Valuation and cash | DCF Valuation · Capex Investment Case · Working Capital |
| Customer analytics | Churn and Lifetime Value $2.01M revenue at risk · SaaS ARR Bridge |
Northline is a fictional company used for sample data. Real data projects use public FDIC, SEC EDGAR, FRED and NYC Open Data sources. No employer data.
Financial Analyst, FP&A and Financial Reporting · PNC Financial Services · Cleveland, Ohio (Remote) · Jun 2025 to Present
- Revenue forecast accuracy from 85% to 92% using revenue, transaction volume, fee income and seasonal trends
- Monthly budget variance from 8% to 5% across departments and cost centers
- $450K potential annual savings from vendor, processing fee and department spend reviews
- SQL reconciliation of transactions vs general ledger cut unresolved exceptions 30%; report automation cut prep time 60%
Financial Analyst · upGrad · Hyderabad, India · Apr 2022 to Jul 2023
- Enrollment forecast accuracy from 80% to 90%; lead to enrollment conversion from 8% to 10% across 100,000 prospects
- Cost per enrolled student down 15% by tying ad spend, CRM and enrollment data in SQL
Sales Analyst · BYJU'S · Vijayawada, India · Aug 2020 to Mar 2022
- Campaign attributed revenue up 12%; counselor productivity up 20%
- Automated SQL and Power BI reporting, cutting weekly prep from 10 hours to 3
Data Analyst · BSNL · Hyderabad, India · Sep 2018 to Aug 2019
- Usage vs billing reconciliation found $1.2M potential annual revenue leakage
- Monthly churn from 2.8% to 2.4% across 500,000 subscribers; Python forecasts from 82% to 90% accuracy
Financial analysis: financial reporting · variance analysis · budgeting · forecasting · financial modeling · revenue and profitability analysis · expense management · cost optimization
Accounting and operations: general ledger · account reconciliation · management reporting · revenue assurance · billing reconciliation
M.S. Business Analytics, University of New Haven · Beta Gamma Sigma · 2023 to 2025
MBA, Accounting and Finance, JNTU Kakinada · 2018 to 2020
Bachelor's, Accounting and Finance, Acharya Nagarjuna University · 2015 to 2018
