Devarati Dasgupta, MBA
Los Angeles,CA
Summary
Strategic-minded Finance Manager/Senior Financial Analyst bringing 9 years of experience in financial landscape. Well-versed in variance analysis and forecasting. Highly motivated, goal-driven and skilled in collecting, monitoring and studying data to analyze financial status and recommend business strategy. Experienced in qualitative and quantitative analysis, contract management and forecasting. Tech-savvy in use of spreadsheets, accounting and financial management software. Adept at utilizing top-of-the-line communication skills to build and foster long-term relationships.
Overview
12
12
years of professional experience
Work History
Senior Financial Analyst (Contract)
MICROSOFT via BROOKSOURCE
08.2023 - 11.2023
- Developed a Travel Tracking Model from scratch, utilizing advanced Excel formulas and tools like Power Queries
- Implemented features within the model to record estimated amounts, budget allocations, and actual expenditures, providing a comprehensive overview of financial data
- Designed and implemented a dynamic dashboard using Excel table functions, charts, and advanced formulas
Senior Financial Analyst (Contract)
PEPSICO
11.2022 - 08.2023
- Own and manage baseline expenses of $32M for CTO IT organization
- Lead and manage 2-person support team responsible for facilitating critical administrative processes like creating purchase orders (POs), extensions of resources, Statements of Work (SOWs) registration, following up on approvals, Cross- Charge process, etc
- Utilize SAP enterprise resource planning (ERP) system proficiently to manage and track GR and invoicing data, ensuring data integrity and financial accuracy
- Collaborate closely with stakeholders to provide financial insights on budgets, confirming spend plans, offer guidance and support to ensure alignment with financial targets and goals
- Regularly presented data findings and analysis to leadership and stakeholders, performed multi-parameter expense/headcount forecasting, delivering engaging and informative presentations that conveyed key insights and actionable recommendations.
Financial Data Analyst
LINESIGHT (CLIENT: GOOGLE)
08.2019 - 11.2021
- Leading monthly cash flows for Google for all its Data Center Construction portfolio of $10B
- Performed Data Pull of historical actuals from finance and forecasts from sites and implemented accruals to generate monthly cash flows across 2000 + projects and delivered monthly regional reports for five regions spread across globe
- Streamlined and automated data pull process by 65% by reducing time taken to deliver regional reports from 12 to 4 hours
- Led quarterly accruals process including planning, preparation, and delivery of accrual template. Implemented process improvement of quarterly accruals prep process by 66% (Time taken reduced from 3 days to 1 day). Also, implemented Monthly Accruals process from scratch
- Ideated and implemented multiple process improvement initiatives including streamlined opex cash flow & prepping opex cash flow in local currency, generation of cash flows with and without accrual conditions, separate out WIP and Accrual Variance for ALL projects in the regional reports, usage of prorated FX rate for projects in SGD currency in the Quarterly accruals process
- Provided intensive training to seven new team members, other teams as well as new key clients on accruals and cash flow
- Key contact in the Cash Flow Team for the Change Management process when the client was upgrading its systems. Led the UAT Testing, data reconciliation efforts & updating of cash flow process, POC for data related query, attended SUPERUSER meetings
- Led monthly presentation to client on monthly cashflows for OPEX and CAPEX. Lead regular syncs with sites, clients, other teams and management.
IT Financial Analyst (Contract)
Kohl’s
03.2019 - 08.2019
- Prepare expense burn report basis information received from internal invoicing executive for bi-weekly updates
- Led of monthly project forecast of materials and headcount and conduct variance analysis and reporting to management
- Achieved significant cost savings by identifying financial inefficiencies and implementing improved processes.
- Streamlined financial reporting for better decision-making with clear, concise analysis and presentation.
IT Financial Analyst (Contract)
Pure Storage
12.2018 - 03.2019
- Streamlined financial reporting for better decision-making with clear, concise analysis and presentation.
- Built common framework and performed analysis of historical spends by Expense Categories, Subscription/Support Contracts Renewal Model to track upcoming renewals, developed detailed budget and built Spend Tracking Model by headcount, materials, licenses, etc to track department spend by category
- Worked closely with CIO and IT leadership to consult and get feedback on projects.
IT Financial Analyst (Contract)
PG&E
05.2017 - 09.2018
- Support and manage budgets of IT Program containing ~ 15 IT Funded Projects of ~$1Million/year and ~200 Client Funded Projects of ~ $10 Million/Year
- Developed new financial report to track monthly financials for client funded projects saving ~ 40 hours of reporting effort
- Proactively monitor and analyze monthly project costs and perform variance analysis
- Support labor/headcount forecasts with projects and coordinate material and service procurement, contract/license management and vendor management
- Lead regular meetings with Project Managers, Program Managers, and leadership for variance explanations and to provide financial recommendations.
Financial Analyst (Contract)
WELLS FARGO
08.2016 - 02.2017
- Owned and managed budgets of ~ $1 Million/release for whole QA division for >70 QA resources across >100 projects
- Performed gap and variance analysis on headcount/labor
- Streamlined accuracy and efficiency of forecasting and capacity utilization model
- Coordinated daily with Project Managers, QA Leads, Finance Leads and Management.
Business Analyst
ACCENTURE
08.2011 - 04.2014
- Performed Requirement Gathering, Mapping and Analysis, Process and Data Mapping, Test Planning, Preparation and Execution for Change Management and Application Releases
- Coordinated with stakeholders, clients, third-party vendors, and users across globe for application release
Education
MBA - Finance
Mason School of Business At College of William & Mary
Williamsburg, VA05.2016
Bachelor of Science - Electronics And Telecommunication Engineering
University of Mumbai
Mumbai, India06.2011
Skills
- MS Excel Skills: vlookups, hlookups, Pivot Tables, sumifs, countifs, array formulas, filter formulas, list formulas, Power Query, Power Pivot
- Database: Bigtable, MYSQL, Oracle
- Languages: SQL, VBA
- ERP Tools: SAP, Oracle NetSuite
- Data Visualization Tools: Tableau, Data Studio
- Microsoft Office Tools: PowerPoint, Project, Access
- Google Tools: Sheets, Docs, Slides
- Other Tools: Minitab, SAP ARIBA, SAP Analysis for Office (AO), SAP BPC, PPMc, QuickBooks
- Financial Planning and Analysis
- Financial and Operational Reporting
- Financial Modeling and Management
- Financial Statement Analysis
- Variance Analysis and Reporting
- Forecasting Techniques
- Cash Flow Analysis and Management
- Preparing Annual and Quarterly Budgets
- Strategic Planning
- KPI Monitoring and Management
- Cost-Benefit Analysis
- Stakeholder Communication
- Team Leadership
- Time Management
- Project Management
- Data Analysis
- Automation Initiatives
- Bookkeeping
- Business Operations Analysis
- Account Reconciliation
- Performance Metrics
Timeline
Senior Financial Analyst (Contract)
MICROSOFT via BROOKSOURCE
08.2023 - 11.2023
Senior Financial Analyst (Contract)
PEPSICO
11.2022 - 08.2023
Financial Data Analyst
LINESIGHT (CLIENT: GOOGLE)
08.2019 - 11.2021
IT Financial Analyst (Contract)
Kohl’s
03.2019 - 08.2019
IT Financial Analyst (Contract)
Pure Storage
12.2018 - 03.2019
IT Financial Analyst (Contract)
PG&E
05.2017 - 09.2018
Financial Analyst (Contract)
WELLS FARGO
08.2016 - 02.2017
Business Analyst
ACCENTURE
08.2011 - 04.2014
MBA - Finance
Mason School of Business At College of William & Mary
Bachelor of Science - Electronics And Telecommunication Engineering
University of Mumbai
Similar Profiles
Hassan JavedHassan Javed
Datacenter Technician at BrooksourceDatacenter Technician at Brooksource
Caleb StinsonCaleb Stinson
Service Desk Analyst at BrooksourceService Desk Analyst at Brooksource
MORGAN HOWELLMORGAN HOWELL
Senior Techncial Recruiter at BrooksourceSenior Techncial Recruiter at Brooksource
IRIS LOPEZIRIS LOPEZ
Senior Improvement Coach at CORE DistrictsSenior Improvement Coach at CORE Districts
Liam FrankLiam Frank
Cart Attendant at Kemper Sports Management- Iron Horse Golf ClubCart Attendant at Kemper Sports Management- Iron Horse Golf Club