Data analytics

IMRAN AHMAD

New Delhi, INDIA • +91-798******* • *****.***********@*****.*** •

www.linkedin.com/in/imran2211

PROFESSIONAL EXPERIENCE

CISCO Networking Academy Oct 2023 – Nov 2023

Data Analytics Essential Course

• Explained how the data analytics process creates value from data.

• Explained the characteristics of data, including formats, availability and methods to acquire.

• Transformed data using analytics tools.

• Analyzed data using basic statistical and data preparation techniques.

• Completed hands-on project using Excel, SQL, Tableau and other tools. The Spark Foundation @ GRIP Sept 2023 – Oct 2023

Data Science & Business Analyst Intern

• Developed interactive and informative Tableau dashboards to visualize and analyze COVID- 19 case data presenting global new cases, deaths and vaccination trends facilitated data- driven decision-making for public health organizations worldwide.

• Expertly executed data cleaning, extraction, transformation and loading (ETL) processes in MS Excel ensuring 100% accuracy and data consistency for the COVID- 19 and superstore project leading to more robust data analysis.

• Designed data transformation workflows in MS Excel handling missing values to achieve 99% fill rate, outliers and normalization to prepare raw data for analysis.

• Extracted valuable insights from the superstore dataset identifying sales trends showing 38% profit coming from Western region of US with opportunities for revenue optimization.

Forage

KPMG AU Data Analytics Job Simulation Aug 2023

• Completed a simulation focused on advising a client on customer targeting to achieve 30% increase in sales.

• Analysed data to target high-value customers based on demographics and attributes. 48% of sales were reported from 25-50 age bracket Male customers.

• Developed Tableau dashboard to communicate potential customer attributes. Trainity, New Delhi, INDIA Mar – Jul 2023

Data Analytics Trainee

• Designed data solutions for 8 live projects starting from data cleaning to final insight generation.

• Generated actionable insights for operations teams for effective manpower plans for call centers to increase response rate to 90%.

• Facilitated the Human Resources team's comprehension of the ongoing recruitment processes within the company, showing 39% of hired candidates being Females.

• Completed successfully 2 LIVE Data Analytics projects based on analysis of user data of a social media platform using SQL.

• During 8 week of data analytics specialization training, gained Proficiency in utilizing MS-Excel, and its various functions, including Pivot tables, Pivot charts, VLOOKUP, and more.

• Visualized 8 live Projects with the use of Tableau and used Microsoft PowerPoint for Storytelling.

Jawed Enterprises, Mughalsarai, U.P Oct 2019 – Feb 2023 Senior Site Engineer

• Streamlined 80% project workflows by assigning tasks to supervisors and subcontractors, ensuring timely completion of all assigned work.

• Reduced average project completion time by 20% and improved overall project efficiency

Sangam Secure Structure, Varanasi, U.P Jul 2017 – Sept 2019 Project Co-Ordinator

● Setting out 75% of Projects including civil work, steel, casting, electrical base fitting, plumbing in accordance with drawings & specification.

● Collaborated with 5 team’s members of client, supervisors and subcontractors to develop and modify project plans.

Shiva Engineers, Jaisalmer, Rajasthan Jul 2015 – Jun 2017 Site Engineer

• Collected and analyzed data related to engineering projects, including cost estimation. Analyzed traffic data to optimize the design of a transportation system, reducing commute time by 15%.

EDUCATION

Annamalai University, Chidambaram, Tamil Nadu May 2015 Bachelor of Engineering, Civil Engineer CGPA: - 7.13 / 10.00 SKILLS & OTHER

Tools & Programming Skills: SQL Tableau Microsoft Excel Microsoft Power BI Basic Python AutoCAD STAAD PRO Basic Statistics

Contact this candidate