Ekhlak Ahmad
Gurugram
Summary
Data Analyst with a strong analytical mindset and a passion for extracting meaningful insights from complex datasets. Proficient in statistical analysis, data mining, and visualization techniques, with a proven track record of providing data-driven solutions to optimize business processes and drive strategic decision-making. Possessing a solid understanding of data management principles and advanced proficiency in SQL, MS Excel, and data visualization tools such as Tableau and Power BI. Strong communication and presentation skills, enabling effective collaboration with cross-functional teams and the ability to convey complex findings in a clear and concise manner. Adaptable and detail-oriented, committed to delivering accurate and actionable recommendations to drive business growth.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Data Analyst
Quess Corp
Gurugram
09.2023 - Current
- Design, Manage, and maintain the dashboard, ensuring data accuracy and consistency
- Managing stakeholders requirements with cross-functional team
- Acted as a single point of contact for all data repositories and develop metrics to analyze pertinent information
- Designed Power BI workspaces for different teams to integrate with salesforce and workday
- Designed and implemented data cleaning and preparation pipelines
- UAT testing for reports
- Automation of reports through macros to improve efficiency and accuracy
- Managed Compliance, Benefits and L&D project
- Provided training and support to team members in using data analysis tools and understanding reports
- Skills Used - Power BI, MS Excel, SQL, Alteryx
Data Analyst
KKSEPL
Barhmer
10.2022 - 08.2023
- Conducted comprehensive data analysis and created insightful reports to support strategic decision-making and improve operational efficiency
- Developed and implemented data models and algorithms to identify trends, patterns, and correlations within large datasets
- Built data infrastructure from scratch
- Supporting business insights resources in presenting business insights
- Maintains data sets to ensure high-quality deliverables
- Designed and implemented data cleaning and validation processes to ensure data accuracy and integrity
- Skills Used - MS Excel, SQL, Power BI
Associate Analyst
Globallogic
Gurgaon
08.2021 - 09.2022
- Communication findings and insights to senior management to establish best practices and guide analysis into action and results
- Applying knowledge of data modeling and statistical analysis to note trends and draw conclusions
- Analyzing program data to provide input for key decision-making and strategic planning
- Organized and analyzed data and marketing results
- Skills used - MS Excel, SQL, Tableau, SAS, Google Analytics
Network Analyst
Maintec Technologies Pvt LTD
Noida
06.2020 - 02.2021
- Maintaining SOPs and providing reports so that productivity could be enhanced and Operation runs smoothly
- Complete Day-to-day operational tasks which include work on in-house tools and CRMs
- Performed in-depth data validation on data from various suppliers across the world
- Worked to assess the company's needs and resolve issues with the use of data
- Skills used - MS Excel, SQL, Tableau, CRM, Google Analytics
Intern
Escorts Agri Machinery
Faridabad
01.2020 - 05.2020
- Root cause Analysis and Rigorous inspection to find out the reason behind the defect
- Served as a dedicated and supportive Intern in a fast-paced environment
- Used SQL queries to identify the list of parts used to attach Lever and identify the problem
Intern
Icehill Omega PVT LTD
Rudrapur
05.2018 - 06.2018
- Analyzed and detected the problems in the production line of Laser welding process and diagnosed the cycle time by implementing optimization techniques
- Maintaining KPI Charts and using excel to analyze data for visualization
- Served as a dedicated and supportive Intern in a fast-paced environment
Education
B.tech - Mechanical Engineering
JK Lakshmipat University
Jaipur05.2020
XII STD -
St. Mary's convent Sr. Sec. School
Panipat03.2016
X STD -
St. Mary's convent Sr. Sec. School
Panipat03.2014
Skills
- Data Analysis
- Tableau
- Microsoft Excel
- SQL
- Qlik
- Microsoft Power BI
Certification
- R Programming for Data Visualization
- The fundamental of SQL
- Tableau
- Zoho CRM
- The fundamental of Digital Marketing
- Business Analyst: Project Management Techniques and Tools
Awards
Work-o-joylic Award, Globallogic, For Highest Productivity rate.
Projects
Data analysis with EXCEL, Analyzed data by applying charts, Pivot table, Data validation, Automation V Lookup's, Macros, and Interactive Dashboards Analyzing Data with BigQuery, Worked with various dataset using BigQuery applying WHERE, GROUPBY, ORDER BY, JOIN, Aggregate function, and Common table expressions.
Languages
- English
- Hindi
Personal Information
- Passport Number: U7713630
- Date of Birth: 10/26/97
- Driving License: Valid Indian License
Timeline
Data Analyst
Quess Corp
09.2023 - Current
Data Analyst
KKSEPL
10.2022 - 08.2023
Associate Analyst
Globallogic
08.2021 - 09.2022
Network Analyst
Maintec Technologies Pvt LTD
06.2020 - 02.2021
Intern
Escorts Agri Machinery
01.2020 - 05.2020
Intern
Icehill Omega PVT LTD
05.2018 - 06.2018
B.tech - Mechanical Engineering
JK Lakshmipat University
XII STD -
St. Mary's convent Sr. Sec. School
X STD -
St. Mary's convent Sr. Sec. School