Lakshay Sethi
Gurugram
Summary
Results-driven Senior Finance Associate at British Telecom (Openreach) with expertise in financial analysis, revenue management, and process optimization. Skilled in SAP, Power Query, and Excel, with a proven track record in month-end accounting, forecasting, and revenue allocation improvements. Recognized with two Wall of Fame awards for contributions to MTP planning and Market KPI revenue unbundling, and led automation initiatives saving 30+ hours annually.
Overview
3
3
years of professional experience
Work History
Senior Finance Associate
British Telecom
Gurugram
12.2022 - Current
- Professional Summary
- Senior Finance Associate in the Revenue Team at British Telecom (Openreach) with expertise in revenue management, financial analysis, and process improvement.
- Manages internal revenue consolidation, variance analysis, month-end journal entries (accruals, deferrals, reclassifications), and revenue unbundling as per Market KPIs.
- Prepares external revenue forecasts for NGA (Fibre) products based on commercial volume projections and Board Metrics reports for Centre Team reporting.
- Key Achievements & Contributions
- Led Openreach Reorganization Project by designing a new revenue mapping process to ensure correct allocation across profit centers.
- Automated discount file consolidation, saving 30 hours annually across six payment rounds (two for 112 discounts and four for Equinox discounts) using Power Query.
- Implemented Market KPI Revenue Reclassification by introducing journal entries in SAP to shift revenue from product-based to Market KPI-based reporting.
- Optimized Internal Trading Processes, reducing incorrect revenue postings to 10215 profit center by working with the Internal Trading Team.
- Streamlined external revenue allocation, ensuring accurate financial representation.
- Actively involved in the MTP process, contributing to revenue forecasting and financial planning.
- Recognition & Awards
- Wall of Fame Award – MTP 24 Process for significant contributions to the Medium-Term Planning process.
- Wall of Fame Award – Unbundling for Market KPI View for enhancing revenue reporting accuracy.
- Engagement & Leadership Initiatives
- Conducted a Drop-in Session with the UK Team on Mental Health, promoting workplace well-being.
- Actively participates in Office Olympics (Gold Medal Winner), Fun on Floor, and Sell for a Cause events to enhance employee engagement.
Audit Associate
Balram & Associates
Panipat
02.2022 - 12.2022
- Assisted in conducting audits of financial statements, ensuring compliance with regulatory standards and accuracy in financial reporting.
- Continuously learning about new accounting standards, tax laws, and best practices to stay updated and apply them effectively.
- Prepared tax returns and supported tax planning activities, ensuring timely and accurate submission.
- Collaborated with clients to gather necessary information and provide updates, fostering strong client relationships. Conducted internal audits to assess the effectiveness of internal controls and identify areas for improvement.
Education
Semi Qualified CA - Accounting, Finance & Taxation
ICAI
New Delhi07-2021
Bachelor of Commerce - Accounting And Finance
University of Delhi
Delhi09-2019
High School Diploma - Commerce
SD Vidya Mandir
Panipat05-2016
MBA - Accounting And Finance
University of Delhi
New DelhiSkills
- Problem-Solving & Critical Thinking
- Engagement & Team Building
- Microsoft Power BI
- Power Query & Excel
- Quick Learner
- Cool Minded
Timeline
Senior Finance Associate
British Telecom
12.2022 - Current
Audit Associate
Balram & Associates
02.2022 - 12.2022
Semi Qualified CA - Accounting, Finance & Taxation
ICAI
Bachelor of Commerce - Accounting And Finance
University of Delhi
High School Diploma - Commerce
SD Vidya Mandir
MBA - Accounting And Finance
University of Delhi