Kriti Jain
Financial Analyst
About Me
Financial Analyst with around 5 years of experience in financial modeling, budgeting, P&L management, balance sheet reporting, variance analysis, and strategic forecasting across healthcare, Banking, and manufacturing sectors. Expert in building financial models (DCF, NPV, IRR, ROI) to support investment decisions, cost optimization, and capital allocation. Expert in leveraging SQL, Python, R, and Advanced Excel to automate reporting, analyze large datasets, and streamline finance workflows. Skilled in GAAP-compliant month-end close processes, accruals, prepaid accounting, and audit preparation.
Technical Skills
Accounting & Financial Reporting
General Ledger Accounting
Fixed Asset Accounting
Accruals & Prepaid Accounting
P&L Management
Balance Sheet Reporting
Cash Flow Analysis
ERP Platforms & Financial Tools
NetSuite
SAP FI/CO
QuickBooks
Tally ERP
Oracle Financials
Bloomberg Terminal
Scripting & Data Query Languages
SQL
R
Python
VBA
DAX
Investment Strategies & Valuation Methods
IRR
ROI Analysis
Capital Budgeting
Financial Ratio Analysis
NPV
DCF
Automation & Regulatory Reporting
GAAP Reporting
UiPath
Excel VBA
Alteryx
Financial Close
MS Power Automate
MIS Reporting
SOX Compliance
SEC Reporting
Financial Reconciliation
BI & Analytical Dashboards
Tableau
Crystal Reports
Excel Dashboards
KPI Dashboards
Power BI
Data Storage & Database Systems
AWS Redshift
MySQL
MS SQL Server
Google BigQuery
PostgreSQL
Snowflake
Financial Forecasting & Analytical Models
Forecasting
Sensitivity Analysis
Earnings & Capital Analysis
Cash Flow Forecasting
Budgeting
Scenario Modeling
Risk Assessment
Variance Analysis
Agile Workflow & Project Coordination
Jira
Confluence
Agile (Scrum, Kanban)
Financial Controls
Business
Professional Experience
Finance Analyst
Goldman Sachs (Contract)
Jul 2024 – Present
Chicago
- Built end-to-end Power BI dashboards to track credit risk exposure, loan performance metrics, and monthly revenue trends across high-volume consumer portfolios, enabling leadership to make timely decisions that unlocked $6.5M in cross-functional budget shifts.
- Designed Excel-based frameworks linked with NetSuite and SAP to enhance P&L management, monthly reporting accuracy, and balance sheet visibility, which improved department-level budget accountability and flagged $1.2M in variances ahead of audits.
- Created advanced liquidity and capital sensitivity models using Python and Excel, simulating interest rate, loan loss, and macroeconomic shocks, which supported regulatory stress tests and influenced $4M worth of contingency capital realignments.
- Developed investment evaluation models using DCF, IRR, and NPV frameworks across multiple business cases, supporting five expansion proposals with a combined forecasted ROI of 22% and total capital impact exceeding $9.4M.
- Led month-end and year-end close activities including journal entries, reserve adjustments, and ledger finalizations, which accelerated SOX-aligned financial reporting timelines by 35% and improved interdepartmental audit readiness.
- Engineered a real-time automated cash flow forecasting tracker by integrating NetSuite outputs with Excel Power Query, empowering treasury teams with daily liquidity insights and proactively avoiding overdrafts exceeding $700K across key accounts.
- Conducted root-cause variance analysis on indirect costs and fixed operations, identified gaps in vendor spend controls, and renegotiated contracts, driving $2.1M in savings over three quarters and boosting department-wide cost discipline.
- Integrated Salesforce CRM lead-to-cash data with Oracle NetSuite's revenue modules to streamline quarterly FP&A cycles, enabling faster pipeline-to-revenue analysis and improving forecast agility across $12M+ in annual revenue channels.
Finance Analyst
Accenture
May 2021 – Jul 2023
India
- Analyzed vendor and supply chain spend across four major hospitals using SAP and Excel models, which led to the consolidation of surgical and pharmaceutical suppliers and delivered annualized cost savings of ₹20.8 crore (~$2.5M USD) by optimizing bulk procurement deals.
- Uncovered misallocations in department-level cost centers through standard vs. actual cost variance analysis using SQL, identifying over ₹7.6 crore (~$915K USD) in inaccurate allocations, which were corrected to improve service line profitability and billing precision.
- Reduced overproduction and excess inventory of surgical kits and disposables by 12% through the development of cost-driver-based budgeting models in SAP BPC, aligning quarterly forecasts with real-time operating room demand and inventory thresholds.
- Automated Tableau-based dashboards to track real-time trends in patient volume, bed occupancy, and treatment material usage, improving decision-making speed for operations managers and reducing manual reporting efforts by 45%.
- Advised finance leadership on capital reinvestment decisions by evaluating ROIC across various medical service lines, helping redirect funding from underperforming outpatient services to high-performing oncology units, boosting capital efficiency by ₹2.3 crore (~$275K USD).
- Improved monthly close accuracy and reduced delays by 3 days by streamlining reconciliation of WIP, pharmacy stock, and medical equipment depreciation schedules for a ₹98 crore (~$11.7M USD) hospital asset base using Excel and SAP integration.
- Monitored CapEx budgets tied to medical device acquisitions and facility expansions, partnering with compliance and procurement teams to ensure all expenditures followed internal controls and IFRS, which enhanced year-end audit readiness and transparency.
- Maintained full audit compliance across two hospital regions by leading SOX documentation efforts, coordinating internal testing, and addressing control gaps in finance workflows, resulting in zero major findings for two consecutive audit cycles.
Associate Finance Analyst
Zensar Technologies
Jan 2017 – Aug 2018
India
- Prepared monthly plant-level financials and SKU-wise margin reports for finished goods across domestic and international markets, improving profit analysis accuracy by 22% and enabling quicker pricing decisions across procurement and distribution cycles.
- Managed quarterly forecast process by consolidating inputs from production managers, procurement heads, and warehousing teams, improving forecast accuracy by 13% and enabling more effective working capital planning for raw material stocking and machine maintenance.
- Architected a SKU-level margin tracking system using Advanced Excel (INDEX-MATCH, conditional formatting, VBA macros), leading to a 50% reduction in manual reporting time and significantly reducing pricing discrepancies during seasonal production fluctuations.
- Monitored and analyzed production output and defect trends across 10+ product lines using Excel dashboards and SQL logs, identifying a 17% increase in rework and scrap costs, which led to corrective actions in vendor audits and a reduced material rejection rate.
- Collaborated with supply chain and logistics teams to track inbound freight costs and delivery SLA breaches, resulting in ₹18 lakh (~$21,500 USD) in savings by optimizing transport schedules and minimizing delays in raw material warehousing.
- Worked with marketing and product cost control teams to monitor promotional spend on distributor campaigns and trade shows, ensuring spend stayed within the ₹3 crore (~$360K USD) quarterly limit and contributing to an 11% improvement in cost-to-sale efficiency.
Projects
Here are a few examples of projects I've worked on. These can be replaced with your actual work.
Financial Risk Assessment Model
Developed a comprehensive risk assessment model using Python and Excel to evaluate credit risk exposure across consumer portfolios. The model incorporated stress testing scenarios and helped identify potential losses, supporting regulatory compliance and strategic decision-making.
Python
Excel
Risk Assessment
Financial Modeling
Automated Financial Reporting Dashboard
Built an automated Power BI dashboard integrating NetSuite and SAP data to provide real-time P&L management and balance sheet visibility. This solution improved reporting accuracy and reduced manual effort by 45%.
Power BI
NetSuite
SAP
Financial Reporting
Healthcare Cost Optimization Analysis
Conducted comprehensive vendor and supply chain spend analysis across multiple hospitals using SAP and Excel models. Identified cost consolidation opportunities that delivered $2.5M in annualized savings through optimized procurement strategies.
SAP
Excel
Cost Analysis
Healthcare Finance
Education
Master of Science in Data Analytics
University of Illinois
Aug 2023 – May 2025
Springfield, IL