Darpan Sahni
Dehradun
Summary
Experienced Senior Project Analyst specializing in driving impactful reporting and analytics strategies within global operations. Proficient in advanced tools like Power Pivot and Power Query to uncover insights that enhance financial decision-making. Skilled at overseeing project teams, fostering collaboration, and improving operational efficiency. Known for implementing innovative reporting mechanisms to provide critical insights into sales trends and performance metrics for leadership. Committed to continuous improvement and delivering high-quality results supporting business objectives.
Overview
6
6
years of professional experience
Work History
SR. PROJECT ANALYST
Buck, A Gallagher Company
01.2024 - Current
- Designated as Lead for Reporting & Analytics within Global Operations Team.
- Developed interactive report to streamline management of advance bills, commission balances, and deferred charges. Leading to 30% reduction in invoice processing time.
- Analyzed data of 1500+ clients across all different platforms used by company. And further summarized outputs to provide insights to Client facing team. Resulting in overall 20% increase in revenue for one US region.
- Formulated approach to evaluate revenue conversion rate leveraging sales data and client P&L.
- Optimized reporting processes by implementing automation in Excel reports using Power Query, Power Pivot, VBA.
- Managed a team of five, focusing on reporting and analytics training.
PROJECT ANALYST
Buck, A Gallagher Company
01.2022 - 01.2024
- Created dynamic Excel dashboard to analyze annual client revenue.
- Streamlined invoice submission process by developing a report that reduced submission time by one day.
- Created detailed reports and interactive dashboards using Salesforce.
- Facilitated UK region support through comprehensive client billing analysis.
- Applied Quadrant methodology to provide insights on clients in US region. Assisted in targeting Top 10 revenue generating clients.
- Collaborated with BI team to enhance dashboard functionality using given datasets.
SUPPORT ANALYST
Buck, A Gallagher Company
12.2019 - 01.2022
- Managed client billing operations utilizing Suite Projects Pro by Netsuite.
- Enhanced billing accuracy by providing system-based support to project managers for invoice preparation.
- Created Excel-based report for analyzing time entries across projects. Reduced time entry modification requests by 30%
- Compiled and summarized information on revenue leakage transactions for Leadership, focusing on write-offs. Further helping in moderation of such transactions.
Education
Bachelor Of Business Administration -
Institute Of Technology And Management
Dehradun, Uttarakhand, India08.2019
Skills
- Advanced Excel
- Microsoft Office Suite
- Financial Data Reporting
- SQL (Beginner)
- SFDC (Salesforce)
- Suite Projects Pro NetSuite
- Power Pivot
- Power Query
- Revenue Operations
- Project Execution
- Data Analysis
- Critical Thinking
- Power BI (Beginner)
- Tableau (Beginner)
- Communication
- Team Player
- Individual Contributor
- Creative Writing
- Leadership Skills
- Fast Learner
Courses
Introduction to SQL by Izzy Weber, Datacamp
Intermediate SQL by Jasmin Ludolf, Datacamp
Introduction to Power Query in Excel, Datacamp
Microsoft Excel VBA - Percipio Course
Power BI - Beginner (YouTube)
Tableau - Beginner (YouTube)
Timeline
SR. PROJECT ANALYST
Buck, A Gallagher Company
01.2024 - Current
PROJECT ANALYST
Buck, A Gallagher Company
01.2022 - 01.2024
SUPPORT ANALYST
Buck, A Gallagher Company
12.2019 - 01.2022
Bachelor Of Business Administration -
Institute Of Technology And Management
Similar Profiles
Karandeep SinghKarandeep Singh
Associate Business Analyst at BUCK A Gallagher CompanyAssociate Business Analyst at BUCK A Gallagher Company
Anet JoseAnet Jose
Software Engineer at Buck, A Gallagher CompanySoftware Engineer at Buck, A Gallagher Company
Jobin S SJobin S S
Associate Lead Software Engineer at Buck, A Gallagher CompanyAssociate Lead Software Engineer at Buck, A Gallagher Company
Isha PareekIsha Pareek
Marketing Intern at Quality AIMarketing Intern at Quality AI
Vaibhav MawalVaibhav Mawal
Operations Coordinator at BAMKO India Pvt. Ltd.Operations Coordinator at BAMKO India Pvt. Ltd.