Aman Shaikh
Summary
Dedicated and detail-oriented Data Analyst with hands-on experience in ensuring timely and accurate
Processing of transactions, tracking trends in performance (SLA/KRA), and creating formal reports using advanced Excel features.
Proficient in data analysis, issue resolution, and working independently or within teams to achieve
Deliverable
Skilled in Excel, Power BI, MySQL, and reporting tools to generate critical business insights and support operational Procedure
Overview
1
1
Certification
Work History
Data Analyst Intern
AI Variant
05.2024 - 08.2024
Project: Banking Analytics
Tools: Power BI, Tableau, Excel, MySQL
• Used SQL, Tableau, Power BI, Excel tools to Extract, Transform, and Load (ETL) data, which sample data were
collected from the source systems to data warehouse designed to analyze data.
• In this project, we understood the overall distribution of key variables such as loan amounts, interest rates,
customer demographics, and loan terms. Statistics, visualizations, and data insights provides an initial understanding
of the datasets.
• Customer demographics and loan characteristics can be utilized to segment the customer base into distinct groups.
- Optimized SQL queries for faster processing times, increasing overall productivity within the team.
- Conducted thorough data validation and cleanup, ensuring accuracy and reliability of datasets used for analysis.
Education
B.Tech - Mechanical Engineering
Walchand Institue of Technology
Solapur, India07-2023
Skills
- Python Programming
- Data Cleaning
- Advance Excel
- R Programming
- Tableau Software
- Data Mining
- SQL and Databases
- Powerbi
- Statistics
Certification
• Data Analyst – ExcelR Solutions (2023)
- Data visualization – ExcelR Solutions (2023)
Projects
PROJECT NAME: E-COMMERCE (OLIST STORE ANALYSIS)
• We leveraged a variety of Excels 3 analytical features, such as pivot
tables, charting, and statistical functions, to explore the data
• We utilized advanced MySQL querying techniques to extract and analyze
the data.
• Team leveraged the advanced visualization capabilities of Power BI and
Tableau to present critical data insights in a visually compelling and easily
understandable format.
Timeline
Data Analyst Intern
AI Variant
05.2024 - 08.2024
• Data Analyst – ExcelR Solutions (2023)
- Data visualization – ExcelR Solutions (2023)
B.Tech - Mechanical Engineering
Walchand Institue of Technology
Similar Profiles
Kailash TalkarKailash Talkar
Data Analyst Intern at AI VARIANTData Analyst Intern at AI VARIANT
P KrishnadityaP Krishnaditya
Data Analyst at Ai VariantData Analyst at Ai Variant
Jyoti DixitJyoti Dixit
Data Analyst Intern at AI VariantData Analyst Intern at AI Variant