I turn financial and operational data into forecasts, variance analysis, and executive ready reporting.
PNC Financial Services · Operations Finance / FP&A · Greater Boston, MA
At PNC, I own KPI dashboards, SQL driven variance analysis, and forecasting across a $50M expense base. I redesigned monthly reporting and cut the month end close from 5 days to 3.
Before that: forecasting and dashboards at upGrad, BYJU'S, and BSNL. MS Business Analytics (Beta Gamma Sigma), University of New Haven · MBA Accounting & Finance.
| Problem | Leadership needed one view of sales performance vs plan, not scattered Excel tabs. |
| Outcome | Executive KPI dashboard with MTD and SPLY tracking, sample data, and reusable DAX measures. |
| Stack | Power BI · DAX |
| Result | Clear MTD / SPLY signal for sales and ops reviews. |
| Repo | northline sales powerbi dashboard |
| Problem | Month end flash mixed Actual, Budget, and Forecast across separate files. |
| Outcome | Monthly FP&A flash pack: Actual vs Budget vs Forecast, margin and OpEx variance, volume vs rate. |
| Stack | Excel · FP&A |
| Result | One flash pack ready for variance meetings. |
| Repo | fpna variance dashboard |
| Problem | Standalone P&L models break when balance sheet and cash flow stay unlinked. |
| Outcome | Fully linked income statement, balance sheet, and cash flow for a sample company. |
| Stack | Excel · Financial modeling |
| Result | Books that balance across IS, BS, and CF. |
| Repo | three statement model |
| Problem | Investment cases need a transparent path from free cash flow to value. |
| Outcome | Unlevered DCF with FCF build, WACC, terminal value, NPV, and IRR. |
| Stack | Excel · Valuation |
| Result | NPV and IRR ready for capital decisions. |
| Repo | dcf valuation model |
More models and dashboards: github.com/saisiri1207
| Area | Tools |
|---|---|
| Analytics | SQL · Power BI (DAX) · Tableau |
| Code | Python (pandas) · R · Excel (Power Query, Power Pivot) |
| Finance | Forecasting · Variance analysis · Driver based modeling · NPV / IRR |
| Systems | Oracle NetSuite · Banner · SAP · Oracle ERP |
| Role | Company | Period | Focus |
|---|---|---|---|
| Financial Analyst, Ops Finance / FP&A | PNC Financial Services | Jun 2025 to Present | KPI dashboards, SQL variance, month end close from 5 to 3 days |
| Financial Analyst | upGrad | Apr 2022 to Jul 2023 | Power BI / Tableau, BvA, tuition forecasting, NPV / IRR |
| Sales Analyst | BYJU'S | Aug 2020 to Mar 2022 | Monthly MIS, pricing models, ROI / payback |
| Junior Financial Analyst | BSNL | Jan 2019 to Aug 2019 | SAP / Oracle BvA, EBITDA and leverage MIS |
