Akashh Dixit
New Delhi
Summary
Highly skilled Data Analyst with expertise in SQL, Power BI, Excel, and data visualization to extract valuable insights and empower data-driven decision making. Proven ability to develop impactful dashboards and visualizations, optimize key business metrics, and uncover revenue growth opportunities.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Sr Data Analyst
Bharti Airtel LTD
08.2021 - Current
- Analyzed CDRs (Call Detail Records), usage patterns, and customer behavior to identify anomalies indicative of fraudulent activity
- Leveraged data analysis to optimize KPIs, resulting in a 12% increase in overall business performance
- SQL & Power BI analysis cut customer churn 10%, boosting revenue for stakeholders.
- Built interactive Power BI dashboards for stakeholders , resulting in a 15% sales conversion increase. This empowered regional teams with data for further optimization.
- Delivered comprehensive reports highlighting key trends, patterns, anomalies, presenting findings to senior management for informed decision-making purposes.
- Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data.
Data Analysts
Kotak Bank
01.2021 - 06.2021
- Created and delivered 50+ database reports, enhancing decision-making efficiency by 20%
- Expertise in developing stored procedures and SQL queries to manipulate and analysis data, streamline data management processes, and reduce errors by 25%
- Designed and implemented a new data analysis dashboard that helped to increase sales by 10%.
- Produced monthly reports using advanced Excel spreadsheet functions.
- Utilized data visualization tools to effectively communicate business insights.
- Used statistical methods to analyze data and generate useful business reports.
Stock Analytics
Indiabulls
02.2020 - 05.2020
- Conducted fundamental and technical stock analyses to identify investment opportunities, generating an average return on investment of 12% for clients
- Design a Power BI dashboard to provide real-time insights into sales performance, resulting in a 10% increase in sales revenue
- Coordinated with RMS, Risk, and Compliance departments to ensure that all regulatory requirements were met, saving the company an estimated 1 million in fines.
- Streamlined analytics processes, increasing efficiency and reducing turnaround time for deliverables.
Data Specialist
Reliance Retail
12.2018 - 01.2020
- Developed and maintained mutually beneficial partnerships with key clients, resulting in a 15% increase in annual revenue
- Supervised the integration of MIS procedures and conducted evaluations using VLOOKUP, Lookup, conditional formatting, and sorting, ensuring the accuracy and timeliness of data reporting, reducing errors by 25%.
- Maintained files, records and chronologies of entry activities.
- Produced monthly reports with advanced Excel spreadsheet functions.
- Built and maintained tracking databases for variety of measuring aspects.
Education
B.Tech -
RGPV
Bhopal, India06.2017
Skills
- Communication
- Problem-solving
- Leadership
- Creativity
- SQL
- MYSQL
- PSQL (Stored Procedure, Trigger, DDL, DML)
- Power Bi Desktop
- Power BI Report Server
- Dashboard
- Advance Excel
- Ms Access
- DAX
- Teamwork
- Adaptability
- Business Intelligence Testing
Websites
Languages
English
Hindi
Projects
2022, 08/01/23, Automated CDR Validation with SQL, Gurgaon, India, Developed a SQL script for validating CDR data accuracy, slicing 40M+ call records., Identified and rectified 5,500 data inconsistencies in the weekly data loads., Reduced manual review effort by 6 man-hours per week with automated data validation., Enhanced performance tracking of GSM/4G/5G networks with data integrity checks., Ensured billing system received validated CDRs, improving charging accuracy to 98%. 10/01/23, 03/01/24, Recognition of Excellence Award in Migration Progress and Pricing, Gurgaon, India, This award is presented to Bharti Airtel in recognition of their outstanding achievement in customer migration progress and the development of competitive pricing strategies. Their dedication to streamlining the migration process and offering attractive pricing options has resulted in a significant boost in customer satisfaction and loyalty.
Certification
- CBAP - Certified Business Analysis Professional
Timeline
Sr Data Analyst
Bharti Airtel LTD
08.2021 - Current
Data Analysts
Kotak Bank
01.2021 - 06.2021
Stock Analytics
Indiabulls
02.2020 - 05.2020
Data Specialist
Reliance Retail
12.2018 - 01.2020
B.Tech -
RGPV
Similar Profiles
Yacouba SoireYacouba Soire
Inventory Manager at Airtel Burkina, Bharti AirtelInventory Manager at Airtel Burkina, Bharti Airtel
Ranjit PanikarRanjit Panikar
Account Manager - B2B Business Development at Bharti Airtel Limited (Airtel Business)Account Manager - B2B Business Development at Bharti Airtel Limited (Airtel Business)
Sufyan KhanSufyan Khan
NOC Engineer at Bharti AirtelNOC Engineer at Bharti Airtel
Jitendra KapdeJitendra Kapde
Global Supply Chain Manager at M/S BHARTI AIRTEL LIMITEDGlobal Supply Chain Manager at M/S BHARTI AIRTEL LIMITED
Manav SaxenaManav Saxena
Technical Lead at Digicommerce Solution LLPTechnical Lead at Digicommerce Solution LLP