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
INDRANIL SENGUPTAINDRANIL SENGUPTA
Tax Manager at RSM US Integrated Services India Private Limited (formerly Known as RSM Delivery Center (India) Private LimitedTax Manager at RSM US Integrated Services India Private Limited (formerly Known as RSM Delivery Center (India) Private Limited
Arjit AdavalArjit Adaval
LEGAL COUNSEL at MATI Carbon India Private Limited; Swaniti Initiative & Stratengage Private LimitedLEGAL COUNSEL at MATI Carbon India Private Limited; Swaniti Initiative & Stratengage Private Limited
QROMIEO BARNABASQROMIEO BARNABAS
HR and Admin Assistant at VFlowTech India Private Limited & Sunkonnect Advisory Service Private LimitedHR and Admin Assistant at VFlowTech India Private Limited & Sunkonnect Advisory Service Private Limited
SANJAY KUMARSANJAY KUMAR
JUNIOR MANAGER - MIS & DATA ANALYST at SOMANY CERAMICS LIMITEDJUNIOR MANAGER - MIS & DATA ANALYST at SOMANY CERAMICS LIMITED
Nitin DhamijaNitin Dhamija
Chief Finance Officer (CFO) at Expo Stand Services Pvt. Ltd.Chief Finance Officer (CFO) at Expo Stand Services Pvt. Ltd.