Anikesh kumar
NEW DELHI
Summary
Dynamic Data Analyst with a proven track record at Estater Private Limited, skilled in SQL and Excel. Successfully developed automation tools that boosted productivity by 70% and created impactful Power BI dashboards for real-time KPI tracking. Adept at collaborating with teams to drive data-driven decisions and enhance operational efficiency.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Data Analyst
Estater Private Limited
NEW DELHI
07.2023 - Current
- Cleaned and processed data using Excel, SQL, ensuring accuracy and consistency for analysis and reporting; updated databases using MySQL based on inputs from cross-functional teams to maintain up-to-date and reliable data.
- Prepared Excel-based reports for clients and internal teams to ensure data accuracy, support informed decision-making, and enable effective performance monitoring.
- Developed automation tools using Excel macros based on business requirements, reducing manual processing time, and increasing productivity by up to 70%.
- Developed and maintained a Power BI dashboard for tracking key performance indicators (KPIs) across retail malls in Riyadh, Bahrain, Kuwait, and Jeddah. The dashboard was designed for internal use, enabling real-time monitoring of KPIs reflected on the Eater Market website. This tool supported the development team in identifying and resolving performance issues efficiently, improving site accuracy, and user experience.
- Collaborated with cross-functional teams to enhance operational efficiency and support business growth through data analysis and streamlined reporting.
Analyst
Global Logic Private Limited
NEW DELHI
08.2020 - 07.2023
- Used SQL and Excel to analyze feedback and help improve Google’s Knowledge Panel.
- Cleaned and prepared data by fixing missing values, outliers, and inconsistencies to keep the data accurate.
- Developed solutions to fix data issues across pipelines and constantly explored data to improve processes.
Education
Bachelor of Technology - Electronics And Communications Engineering
Jamia Hamdard University
Delhi 05-2019
12th - Science
Govt Boys Senior Secondary School
Delhi05-2014
High School -
Govt Boys Senior Secondary School
Delhi06-2012
Skills
- SQL analysis
- Excel
- Power BI
- Python
- Numpy
- Pandas
- Matplotlib
- PowerPoint
- Google Sheets
Certification
Certificate in Data Analytics (6 Months)
Excler Institute of Data and Business Analytics
- Coursework included: SQL, Excel, Power BI, Python, Data Visualization.
- Developed real-time projects including:
Sales Performance Dashboard
Timeline
Data Analyst
Estater Private Limited
07.2023 - Current
Analyst
Global Logic Private Limited
08.2020 - 07.2023
Bachelor of Technology - Electronics And Communications Engineering
Jamia Hamdard University
12th - Science
Govt Boys Senior Secondary School
High School -
Govt Boys Senior Secondary School
Similar Profiles
Vasuda KrishnamurthyVasuda Krishnamurthy
Financial Analyst at EMC SOFTWARE AND SERVICES INDIA PRIVATE LIMITED/Dell, Technologies India Private LimitedFinancial Analyst at EMC SOFTWARE AND SERVICES INDIA PRIVATE LIMITED/Dell, Technologies India Private Limited
B Hemanth KumarB Hemanth Kumar
Senior Ar Caller at U.S Medical billing, Visionary Rcm Infotech India Pvt Ltd, Omega Healthcare private limited and Access Healthcare private limitedSenior Ar Caller at U.S Medical billing, Visionary Rcm Infotech India Pvt Ltd, Omega Healthcare private limited and Access Healthcare private limited
Sandeep Kumar MadupojuSandeep Kumar Madupoju
Quality Specialist at OPELLA HEALTHCARE PRIVATE LIMITED (a unit of Sanofi Healthcare Private Limited)Quality Specialist at OPELLA HEALTHCARE PRIVATE LIMITED (a unit of Sanofi Healthcare Private Limited)
ANJALI SINGHANJALI SINGH
Admin at Kotak Mahindra BankAdmin at Kotak Mahindra Bank
Keshav VermaKeshav Verma
Software Developer Trainee at Netsquare TechnologiesSoftware Developer Trainee at Netsquare Technologies