Chandan Gupta
Mumbai
Summary
As a motivated and results-oriented Data Analyst with nearly one year of professional experience, I seek to leverage my skills in data analysis, visualization, and database management to drive strategic insights and business growth. My expertise in tools such as Excel, Power BI, Python, and SQL, combined with a strong background in data cleaning, preprocessing, and reporting, allows me to deliver actionable intelligence and optimize decision-making processes. I am eager to contribute to a dynamic team where I can apply my analytical skills and continue to develop my expertise in data science and analytics.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Data Analyst
A One Salasar Pvt Ltd
Mumbai
2023.07 - Current
- Conducted in-depth data analysis, resulting in a 20% data accuracy improvement through extraction, cleaning, and transformation of diverse datasets.
- Developed Power BI dashboards, reducing executive data review time by 15%, streamlining decision-making with an average review time drop from 60 to 51 minutes.
- Managed SQL databases, ensuring data integrity and security for datasets exceeding 100,000 records.
- Worked on multiple internal and external projects, addressing data cleaning, pre-processing, and structuring using ETL tools like Power BI, Python Jupyter Notebook, Microsoft Excel, and SQL.
- Analyzed and derived insights using Python's Jupyter Notebook, Power BI, and various web scraping tools.
- Managed various internal and external projects related to data analysis and database management, collaborating with cross-functional teams to meet project deadlines and objectives.
Junior Analyst Intern
Fathom Marine Consultants
Mumbai
2021.08 - 2022.06
- Carried out Daily Analysis of vessel port of call
- Gathered and scrutinized data using ETL tools
- Responsible for specifications, implementations, and analytics.
- Prepared business models, flowcharts, and diagrams
Education
Master of Science - Data Science & AI
Ramniranjan Jhunjhunwala College
Mumbai2024-04
Bachelor of Science - Information Technology
MSG-SGKM College of Arts, Science And Commerce
Mumbai2022-04
Skills
- ETL (Data Cleaning)
- EDA ( Exploratory Data Analysis)
- Excel Functions (Pivot Table, Pivot Chart, Lookup Functions, Power Query)
- Data Warehousing
- Technical Analysis
- Statistics and SAS
- Data Integrity Validation
- Power BI (DAX, Power Query)
- Python Programming (NumPy, Pandas)
Certification
- IBM Data Science Methodology(IBM,Coursera)
- IBM Python for Data Science, AI & Development (IBM,Coursera)
- SAS Programming (Internshala)
Languages
Hindi
First Language
English
Proficient (C2)
C2
Marathi
Proficient (C2)
C2
Tools
- Microsoft Office
- Excel
- Python
- Power BI
- SAS
Timeline
Data Analyst
A One Salasar Pvt Ltd
2023.07 - Current
Junior Analyst Intern
Fathom Marine Consultants
2021.08 - 2022.06
Master of Science - Data Science & AI
Ramniranjan Jhunjhunwala College
Bachelor of Science - Information Technology
MSG-SGKM College of Arts, Science And Commerce
- IBM Data Science Methodology(IBM,Coursera)
- IBM Python for Data Science, AI & Development (IBM,Coursera)
- SAS Programming (Internshala)
Similar Profiles
Alan RejiAlan Reji
Senior Account Executive at Salasar Autohaus Indore Pvt.Ltd.Senior Account Executive at Salasar Autohaus Indore Pvt.Ltd.
Alan RejiAlan Reji
Senior Account Executive at Salasar Autohaus Indore Pvt.Ltd.Senior Account Executive at Salasar Autohaus Indore Pvt.Ltd.
Manish ChaudharyManish Chaudhary
Assistant Manager (Transmission Projects ) at Salasar Techno Engineering LtdAssistant Manager (Transmission Projects ) at Salasar Techno Engineering Ltd