Skip to content
View saisiri1207's full-sized avatar

Achievements

Achievement: YOLO

Achievements

Achievement: YOLO

Block or report saisiri1207

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
saisiri1207/README.md
Sai Siri header Typing intro

LinkedIn Portfolio Email Location

👋 About me

I turn financial and operational data into forecasts, variance analysis, and executive-ready reporting across U.S. banking and international operations. Currently a Financial Analyst in Operations Finance / FP&A at PNC Financial Services, building KPI dashboards, driver-based forecasts, and valuation models that hold up under scrutiny.

Core strengths: forecasting & budgeting · variance analysis · driver-based modeling · KPI design · NPV / IRR / ROI · the reporting infrastructure behind financial decisions.

📊 Impact at a glance

⏱️ Monthly close 💰 Expense base ⚙️ Throughput 🔍 Revenue leakage 📉 Churn
5 → 3 days $50M +2% $1.2M 2.8% → 2.4%
Redesigned reporting templates & processes · PNC Variance analysis with SQL, Python, R & Excel · PNC Workflow-bottleneck analysis with ops leadership · PNC Usage-vs-billing reconciliation · BSNL Across 500,000 subscribers · BSNL

🧰 Toolkit

SQL Power BI Tableau Python R Excel

NetSuite SAP Oracle ERP Banner US GAAP and SOX

🚀 Featured projects

📈 FP&A Variance Dashboard

Monthly flash: Actual vs Budget vs Forecast, margin and OpEx variance, volume vs rate.

💵 DCF Valuation Model

Unlevered DCF: FCF build, WACC, terminal value, NPV and IRR.

🧾 Three Statement Model

Linked income statement, balance sheet and cash flow. One change flows through all three and the books still balance.

📊 Northline Sales Power BI Dashboard

Executive KPIs with month-to-date and same-period-last-year views.

🧩 More samples

🔎 Account Reconciliation

Problem: Bank activity vs GL matched by hand.
Outcome: SQL rules flag duplicates, missing postings and aged items.
Result: Exceptions down 67.9% (184 to 59).

💰 Vendor Spend Savings

Problem: $9.5M vendor spend with no ranked savings list.
Outcome: Fee rate benchmarks, volume tiers and duplicate vendors ranked.
Result: $457K annual potential savings.

📡 Revenue Assurance

Problem: Usage never tied to billing.
Outcome: SQL recon finds unbilled usage, wrong tariffs and missed charges.
Result: $1.24M annualized leakage sized.

🏦 Fee Income Forecast

Problem: Same month last year forecast ran low.
Outcome: Volume and fee rate drivers with seasonality.
Result: Accuracy 85.3% to 92.9%.

📂 More models and analysis packs (click to expand)
Area Repos
Forecasting & planning Driver-Based Forecast · Rolling Forecast (Python) · Scenario Planning Pack · Headcount & Staffing Forecast · 13-Week Cash Forecast
Variance & reporting GL Variance (Python + SQL) · SQL FP&A Variance Pack · Monthly KPI Scorecard · Board / ELT Flash
Profitability & cost Margin & Mix Bridge · Unit Economics Workbook · Cost Accounting Workbook · OpEx / ZBB Pack
Capital & cash CAPEX Investment Case · Working Capital Dashboard · SaaS ARR Bridge

All projects use fictional or sample data. No employer data.

💼 Experience

Role Highlights
🏦 Financial Analyst, Operations Finance / FP&A
PNC Financial Services · Remote (Cleveland, OH team)
Jun 2025 – Present		 Cut monthly close from 5 to 3 days · executive KPI dashboards vs budget and quarterly targets · variance analysis across a $50M expense base · bottleneck analysis that helped lift throughput 2%
🎓 Financial Analyst
upGrad · Hyderabad
Apr 2022 – Jul 2023		 Power BI / Tableau dashboards · reporting automation in NetSuite and Banner cut a full day from monthly reporting · driver-based tuition revenue forecasts · NPV / IRR capital cases
📚 Sales Analyst
BYJU'S · Vijayawada
Aug 2020 – Mar 2022		 Monthly MIS on gross margin per unit and ops KPIs · dynamic pricing models · ROI / payback analysis · working-capital monitoring
📡 Data Analyst
BSNL · Hyderabad
Sep 2018 – Aug 2019		 Churn 2.8% → 2.4% across 500K subscribers · found $1.2M potential annual revenue leakage · SQL / Power BI dashboards · Python forecasting

🎓 Education & certifications

  • M.S. Business Analytics, University of New Haven · 2025 · GPA 3.95 · Beta Gamma Sigma
  • MBA, Accounting & Finance, JNTU Kakinada · 2020 · GPA 3.7 · Merit Scholarship
  • Bachelor's, Accounting & Finance, Acharya Nagarjuna University · 2018
  • 🏅 Scrum Fundamentals Certified · Six Sigma Yellow Belt

📈 GitHub activity

GitHub stats
GitHub streak

Open to Financial Analyst, FP&A, Business Analyst, and Data Analyst roles.

footer

Pinned Loading

  1. northline-sales-powerbi-dashboard northline-sales-powerbi-dashboard Public

    Northline sales Power BI dashboard: executive KPIs, MTD, and SPLY. Sample data + DAX.

  2. fpna-variance-dashboard fpna-variance-dashboard Public

    Monthly FP&A flash: Actual vs Budget vs Forecast, margin/OpEx variance, volume vs rate. Sample Excel.

  3. three-statement-model three-statement-model Public

    Linked 3-statement model (IS, BS, CF) for a fictional company. Sample annual Excel model.

  4. dcf-valuation-model dcf-valuation-model Public

    Unlevered DCF: FCF build, WACC, terminal value, NPV and IRR. Sample Excel valuation.

  5. driver-based-forecast driver-based-forecast Public

    Driver-based P&L forecast: volume × price, COGS drivers, OpEx by cost center, plan vs reforecast. Sample Excel file.

    1

  6. thirteen-week-cash-forecast thirteen-week-cash-forecast Public

    13-week cash forecast: receipts, disbursements, weekly ending cash, and a simple runway view. Sample file.