Summary
Overview
Work History
Education
Skills
Timeline
Generic

Swara Shelat

Canton,MI

Summary

Results-driven Senior Financial Analyst with experience in financial planning, analysis, and strategic decision support. Proven track record of leveraging advanced quantitative skills and financial modeling to provide actionable insights for executive-level decision-making. Skilled in collaborating cross-functionally, communicating complex financial concepts effectively, and implementing process improvements.

Overview

8
8
years of professional experience

Work History

Senior Financial Analyst

DTE - Distribution Operation and Major Enterprise Projects
01.2020 - Current
  • Prepared a monthly budget portfolio for the fiscal year 2024, by performing various financial analysis like creating seasonality report and cost trends, scenario analysis, sensitivity analysis; overseeing an annual investment totaling $1.5 billion
  • Along with conducting weekly presentations on month-end and year-end cost estimates, I also presented monthly spend variance to leadership, including VP of Finance
  • Provided details like key cost drivers, overhead variance, and an outlook based on YTD spending
  • Manage integration of monthly actuals, annual budget, and forecasts into ERP systems, including Oracle and SAP, ensuring accurate and up-to-date financial data for informed decision-making for leadership
  • Collaborated closely with project managers and cost engineers to gain insights into daily activities
  • Identified key performance and timing indicators, resulting in a 20% reduction in the variance between monthly projected and actual values, enhancing financial accuracy and strategic decision-making
  • Oversaw operational management budget, demonstrating expertise in forecasting and controlling overhead costs
  • Implemented a detailed labor model, incorporating overhead count, material and outside labor cost analysis to streamline resource allocation
  • Successfully contributed to cost-effectiveness and operational efficiency by meticulously managing budgets and providing strategic insights into overhead expenses
  • Utilized advanced data analysis tools such as Oracle, SAP, PowerBI, Excel and Access to derive actionable insights from financial data, enhancing forecasting precision and overall financial performance
  • Developed comprehensive project evaluation models for capital investment projects over $10M, to assess financial viability, cost-benefit analysis, time value of money, payback periods, and risk assessment using Monte-Carlo analysis
  • Mentored and coached junior financial analysts and student co-ops, fostering their professional growth and enabling them to take on more advanced responsibilities.

Finance Associate

DTE Energy Company
01.2018 - 11.2020
  • Spearheaded and successfully executed multiple continuous improvement projects using Excel, incorporating advanced functions such as V-Lookups, IF statements, pivot tables, macros, and other Excel features
  • These initiatives optimized data accuracy and streamlined operations
  • Collaborated closely with the Controllers organization to meticulously manage backlog and Current Work in Progress (CWIP), ensuring alignment with target levels for efficient financial control and reporting
  • Assumed responsibility for the thorough analysis and unitization of capital work valued at over $500 million, spanning substation, overhead, and underground projects
  • Demonstrated expertise in managing substantial capital investments
  • Conceptualized, designed, and implemented comprehensive Standard Work Instructions, providing users with an intricate understanding of operational processes within the Business Unit
  • Enhanced process consistency and operational efficiency
  • Demonstrated an unwavering commitment to workplace safety by consistently adhering to safe practices and actively championing the significance of safety across all areas of the workplace
  • Possess a high level of proficiency in Fixed Assets management, Account Reconciliation, Accounting, and General Ledger practices, which have contributed to accurate financial reporting and meticulous financial control.

Internal Audit Service Co-op

DTE Energy Company
08.2016 - 01.2018
  • Collaborated closely with management to support audits, including specialized projects like SOX Testing, ensuring the timely delivery of valuable feedback and recommendations
  • Proficiently executed audit programs, employing data accumulation, sampling techniques, and analysis with tools such as SAP, wDesk, TeamMate, and SharePoint
  • Skillfully interpreted results, devised audit testing programs, and conducted thorough analyses of existing conditions, with a focus on communicating findings to audit clients
  • Authored and presented in-depth audit reports, developing clear presentations that outlined objectives, scope, conclusions, and findings
  • Methodically documented systems, processes, risks, and controls using narratives and flowcharts, facilitating a robust assessment of the current state, gap identification, continuous improvement initiatives, and cost savings strategies
  • Maintained a proactive role in preparing weekly performance metrics for the team, enhancing project execution tracking, and fostering a culture of continuous improvement within the department.

Business/Technology Intern

Thomson Reuters
12.2015 - 04.2016
  • Demonstrated proficiency in the preparation and maintenance of 1120 Corporate and 1065 partnership tax returns, ensuring accuracy and compliance with tax regulations
  • Proactively identified and resolved client issues related to 1120 and 1065 tax returns and GoSystem RS, showcasing a problem-solving mindset and commitment to client satisfaction
  • Utilized Salesforce to efficiently log client calls and maintain detailed cases, ensuring accurate record-keeping, organized communication, and streamlined issue tracking
  • Consistently delivered outstanding client service by addressing inquiries, providing expert guidance, and ensuring a positive client experience.

Education

Bachelor of Business Administration in Finance and Accounting -

University of Michigan
12.2017

Skills

  • ERP Systems: SAP, Oracle, Excel, Access, PowerBI, Sharepoint, Tableau, PowerPlan
  • Experience in: SalesForce, GoSystem, WDesk, TeamMate, Sarbanes Oxley testing, Traditional and Non-Traditional Audit Testing

Timeline

Senior Financial Analyst

DTE - Distribution Operation and Major Enterprise Projects
01.2020 - Current

Finance Associate

DTE Energy Company
01.2018 - 11.2020

Internal Audit Service Co-op

DTE Energy Company
08.2016 - 01.2018

Business/Technology Intern

Thomson Reuters
12.2015 - 04.2016

Bachelor of Business Administration in Finance and Accounting -

University of Michigan

Similar Profiles

CREATE PROFILE
Swara Shelat