Dhananjay Jain
Financial Analyst | FP&A, Forecasting & Financial Modeling | SQL, Python, Alteryx | CAPEX, DCF, Variance Analysis | Driving $30M+ Capital Allocation & Cost Optimization
- Role
- Financial Analyst at PNC
- Location
- Charlotte, NC, US
- LinkedIn followers
- 500 followers
About Dhananjay Jain
Financial Analyst with 4.5+ years of experience in FP & A, budgeting, forecasting, and financial modeling, supporting enterprise-level decision-making across banking and consulting environments.I specialize in translating complex financial data into actionable insights that drive capital efficiency, risk mitigation, and strategic growth. My work has supported $32M+ in capital allocation, improved forecast accuracy by 15%, automated 120+ hours of manual work annually, and delivered $1.8M in cost savings through variance analysis and process optimization.I bring strong hands-on expertise across SQL, Python, R, Excel VBA, Alteryx, and modern cloud data platforms (Snowflake, Redshift, BigQuery) to build scalable financial models, automate reporting pipelines, and enable real-time KPI visibility for leadership.Core strengths include:FP & A, budgeting, forecasting & scenario modelingCAPEX planning, DCF, NPV, IRR & Monte Carlo simulationsP & L and balance sheet analysisFinancial automation & analytics-driven decision supportGAAP, IFRS & SOX complianceI thrive in cross-functional environments partnering with finance, operations, tax, and compliance teams to deliver data-backed strategic insights.Open to conversations around FP & A, Strategic Finance, Finance Analytics, and Corporate Finance roles.
Experience
Financial Analyst
Nov 2024 — Present
Developed and maintained financial models (DCF, NPV, IRR) to evaluate investment opportunities, M&A scenarios, and capital projects, supporting capital allocation decisions of $32M across multiple business divisions- Redesigned monthly financial reporting process by integrating Excel macros, SQL scripts, and workflow automation, reducing report preparation time from 8 days to 2 days and providing actionable insights to senior management- Performed variance analysis and scenario modeling using Alteryx and Excel VBA, identifying operational inefficiencies, cost-saving opportunities, and risk exposures, improving department-level resource utilization by 18%- Led enterprise budgeting and forecasting for six business units, validating assumptions, performing sensitivity analysis, and improving forecast accuracy by 15%, supporting senior leadership in strategic resource allocation- Automated data validation and reconciliation tasks using UiPath StudioX, saving 120+ hours annually, enhancing team efficiency, and ensuring SOX and audit compliance- Created interactive Tableau dashboards to visualize KPIs, departmental expenses, project-level performance, and trend analysis, enabling faster decision-making and reducing dependency on static reports by 30%- Implemented ERP data extraction and automated KPI monitoring, streamlining reporting pipelines and providing timely, accurate financial insights across multiple departments- Collaborated with tax and compliance teams to optimize corporate structures, intercompany transactions, and regulatory reporting, improving global tax efficiency and adherence to regulations- Performed quantitative analysis for strategic initiatives, including regression modeling, sensitivity analysis, and Monte Carlo simulations, enabling data-driven decisions that mitigated financial risk by 10% and supported strategic growth initiatives.
Education
Southern New Hampshire University
Master of Science in Business Analytics
2023 — 2025
Devi Ahilya Vishwavidyalaya (DAVV), Indore
Post Graduation Diploma in Computer Applications
2021 — 2022
Devi Ahilya Vishwavidyalaya (DAVV), Indore
Bachelor's degree
2017 — 2021
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.