Deepanshu Soni

Certified

Senior Analyst

SpiceJet Limited | Delhi

Technologies

My Certifications

These are the industry credentials that I’ve earned.

Introduction to SQL

Intermediate SQL

Other Certificates

Datacamp SQL For Business Analyst

Datacamp SQL Fundamentals

Datacamp Tableau Fundamentals

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

SpiceJet Limited | Sep 2023 - Present

Senior Analyst - BIU

N/A

SpiceJet Limited | Jul 2022 - Aug 2023

Analyst - Revenue Management

Data Management and Integration: *Collect, clean, and integrate data from various sources, including sales transactions, customer databases, and market intelligence. *Maintain data integrity and to ensure data accuracy to support informed decision-making in revenue management. Database Development and Maintenance: *Designed and maintained databases that store relevant revenue-related information, including pricing data, demand forecasts, network performance, and historical performance metrics. Reporting and Analytics: *Developed and generated reports, dashboards, and data visualizations to provide insights into revenue and network performance. *Used analytical tools and software to analyze trends, identify opportunities, and make recommendations for the pricing team, network planning, and revenue management team. *Collaborated with IT teams to troubleshoot technical issues and ensure system stability. *Continuously improved data analysis and reporting procedures to increase efficiency and accuracy. *Collaborated closely with revenue managers and other department heads (HODs) to align MIS solutions with revenue optimization strategies. *Played a critical role in ensuring that data-driven insights are readily available to support decision-making processes in revenue management.

Omnie Solutions (I) Pvt Ltd Noida | Aug 2021 - Jul 2022

Data Analytics Associate

*Gathered data from various sources, including website analytical tools (e.g., Google Analytics), social media platforms, email marketing systems, and advertising platforms (e.g., Google Ads, Facebook Ads), to create a unified view of digital marketing performance. *Utilized analytical tools and techniques to analyze marketing campaign performance, customer behavior, and conversion metrics. *Determined trends, patterns, and key performance indicators (KPIs) to provide actionable insights to the digital marketing team. *Developed regular reports and dashboards that convey data-driven insights in a clear and visually appealing manner. *Used data visualization tools (e.g.,Power BI, Google Data Studio) to present information effectively. *Performed A/B tests to assess the impact of different marketing strategies, such as ad variations, landing page designs, or email subject lines. *Helped improve campaign ROI, user experiences, and marketing strategies through data-driven insights.

Jobsy | Mar 2021 - Jul 2021

Business Analyst

N/A

MedTourEasy | Feb 2021 - Feb 2021

Business Analyst Trainee

N/A

NowIT Services | May 2020 - Jul 2020

Information Technology Intern

N/A

Accenture | Apr 2019 - Sep 2019

Network Analyst

N/A

My Education

Take a look at my formal education

MSc, Business Intelligence and Analytics University of Westminster | 2020

Bachelor's of Technology, Electrical, Electronics and Communications EngineeringInderprastha Engineering College | 2018

About Me

With a Master's degree in Business Intelligence and Analytics from the University of Westminster, I am currently spearheading data-driven strategies as a Senior Analyst at SpiceJet Limited. My core competencies lie in Data Analysis, Data Visualizatio

Create Your Data Portfolio for Free