Ankit Wadhwa
Financial Analyst at DTE
- Role
- Financial Analyst at DTE Energy
- Location
- Detroit, MI, US
- LinkedIn followers
- 500 followers
About Ankit Wadhwa
I’m Ankit Wadhwa, a Senior Financial Analyst at Quest Diagnostics and a 2023 graduate of…
Experience
Financial Analyst
May 2023 — Present · Detroit, MI, US
Led the month-end Unbilled Liabilities (UBL) accrual process, overseeing vendor data validation, forecasting, and reporting while partnering with Controllers and PMO to ensure accurate financials and process improvements.• Consolidated vendor UBL data from Smartsheet into Power BI and Excel, producing polished company-wide reports reviewed across multiple DTE organizations.• Generated and validated financial reports in SAP and Maximo, leveraging advanced Excel functions (XLOOKUP, SUMIFs, PivotTables) to reconcile vendor-submitted UBL data and prepare accurate accrual files for leadership review.• Performed detailed UBL analysis by comparing forecasted vs. actual spend, calculating variances based on prior and current month accruals, and highlighting discrepancies to improve forecast accuracy and vendor accountability.• Coordinated accruals with Controllers and PMO, validating vendor data before booking, conducting monthly after-action reviews (AARs), and implementing process improvements that enhanced data quality and reporting timeliness.• Managed POs and PRs, including quarterly adjustments for changing fuel rates, to ensure accurate vendor billing, cost allocation, and compliance with company policies.• Prepare and validate quarterly OCIP reports by reconciling vendor payroll, labor rates, and cost data, supporting compliance, risk management, and transparency across DTE’s capital projects.• Led bi-weekly billing touchpoint meetings with three vendors and reconciled both overhead and underground work in SAP/Maximo, consistently improving billing accuracy and performance metrics.• Trained and onboarded new team members on billing processes including PO closure, PO/PR creation, and advanced reconciliation techniques, accelerating ramp-up and knowledge transfer.
Education
Michigan State University - Eli Broad College of Business
Bachelor of Arts - BA, Finance
Michigan State University
Bachelor of Arts - BA, Economics
2019 — 2023
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.