Deepanshu Soni

Results-driven Business Analyst with 4+ years of experience in data analysis, business intelligence, and performance reporting. Demonstrates strong quantitative, analytical, and interpretive skills with a proven ability to manage multiple priorities and deliver under fast deadlines. Proficient in Advanced Excel, Power BI, SQL, and Python; experienced in database management, data mining, cleansing, and transformation.

Known for an inquisitive and investigative nature, meticulous attention to detail, and the ability to communicate insights through well-crafted reports and PowerPoint presentations. Comfortable taking initiative, demonstrating resourcefulness, and interacting professionally with stakeholders at all levels — from operational teams to senior executives.

Business Analyst at Aeroprime Group (2025-09 – Present)

• Lead business analytics and sales performance reporting by creating Power BI dashboards tracking revenue, sales growth, and customer churn.
• Perform data mining, cleansing, and transformation using SQL and Advanced Excel to ensure high data accuracy and database integrity.
• Identify trends, anomalies, and performance gaps; translate quantitative analysis into strategic recommendations for senior executives.
• Collaborate with business stakeholders to understand requirements and convert them into analytical solutions.
• Prepare executive-ready PowerPoint presentations summarising insights with flair for clear, structured writing and attention to detail.

Senior Analyst / Executive at SpiceJet Limited (2023-09 – 2025-09)

• Designed and maintained 5+ Power BI and Excel dashboards tracking KPIs across operations, resulting in a 15% improvement in decision-making time.
• Automated and optimised data extraction from multiple sources using SQL, improving report generation efficiency by 30%.
• Conducted deep-dive analytics on flight performance and route profitability, supporting strategic planning initiatives.
• Delivered tailored analytical solutions to stakeholders across commercial and operations teams; improved interdepartmental communication and reporting accuracy.

Analyst at SpiceJet Limited (2022-07 – 2023-08)

• Developed flight analyst performance dashboards in Power BI, enabling leadership to track KPIs with precision and speed.
• Led a project to improve revenue monitoring efficiency, reducing manual data handling by 35% through resourceful process redesign.
• Delivered actionable insights contributing to a 6% increase in route profitability and 10% growth in passenger load factor.
• Proposed data-driven recommendations that improved load factor by 5% across low-performing segments.

Data Analytics Associate at Omnie Solutions (I) Pvt. Ltd. (2021-08 – 2022-07)

• Analysed and visualised multi-channel marketing data using Power BI and Looker Studio, enabling a 12% boost in campaign ROI.
• Created stakeholder-focused dashboards and reports directly impacting marketing strategies and customer segmentation.
• Identified conversion drop-off points in the user funnel, helping reduce bounce rates by 18%.

Business Analyst Trainee at Jobsy India (2021-03 – 2021-07)

• Built interactive dashboards using Power BI and Tableau to visualise KPIs and performance trends.
• Executed SQL queries for data extraction and used R for statistical modelling.
• Assisted in developing influencer marketing reports, assessing engagement metrics, and measuring campaign effectiveness.

Analyst at Accenture (2019-04 – 2019-09)

• Managed and resolved 100+ service tickets monthly, improving SLA compliance by 15%.
• Documented troubleshooting processes and technical flows, reducing average issue resolution time by 20%.

MSc in Business Intelligence and Analytics – University of Westminster, London, UK (2020-10)

B.Tech in Electronics and Communication – Inderprastha Engineering College, Ghaziabad, IND (2018-06)