Umang Patel
Dombivli
Summary
Data Analyst with a strong foundation in building analytical solutions, automating processes using Python, and creating high-quality dashboards and visualizations. Proficient in collaborating with cross-functional teams to meet business objectives, ensuring data quality and integrity, and driving continuous improvements in analytics capabilities.
Overview
6
6
years of professional experience
Work History
Data Analyst
Ergode IT Services Pvt. Ltd.
2022.12 - Current
- Automated processes using Python and SQL to streamline repetitive tasks, enhancing overall operational efficiency and accuracy in data handling.
- Construct interactive dashboards to visualize monthly return analysis, aiding in trend identification
- Constructed interactive dashboards and visualizations using Python and SQL to integrate datasets from various source systems, aiding in trend identification and performance tracking.
- Led key projects involving analytics requirements, ensuring timely completion of deliverables by collaborating with leadership and cross-functional teams.
- Utilized SQL for querying large datasets, ensuring data integrity, and optimizing queries for faster processing in analytical applications.
Graduate Trainee
Godrej and Boyce Mfg Co Ltd.
2019.06 - 2021.06
- Rolled out daily sales reports to various business unit heads, utilizing advanced Excel and SQL for data extraction and complex query writing.
- Managed warehouse inventory reports and coordinated with sales teams for timely updates and accuracy.
- Produced monthly reports using advanced Excel spreadsheet functions
- Coordinated statistical data analysis, design and information flow
- Transformed project data requirements into project data models.
Accounts Executive
Tinco Chemicals
2019.01 - 2019.01
- Assisted in processing payments and documents such as invoices, journal vouchers, reimbursements and statements
- Used accounting software to prepare weekly and monthly financial reports
- Checked financial records to make sure they were accurate and followed company rules and legal requirements.
Education
Full Stack Python Development -
Codeachive Learning
01.2023
Bachelor of Management Studies - Finance -
Model College
Mumbai, Maharashtra01.2019
HSC - Commerce -
Model College
Mumbai, Maharashtra01.2016
SSC -
SJM English High School
Mumbai, Maharashtra01.2014
Skills
- Dashboards
- Process Automation
- Python
- Advanced Excel
- SQL
- Metabase
- Data Extraction
- Data Visualization and Presentations
Languages
English
Hindi
Marathi
Gujarati
Hobbies and Interests
- Star Gazing
- Swimming
- Camping
- Cooking
Timeline
Data Analyst
Ergode IT Services Pvt. Ltd.
2022.12 - Current
Graduate Trainee
Godrej and Boyce Mfg Co Ltd.
2019.06 - 2021.06
Accounts Executive
Tinco Chemicals
2019.01 - 2019.01
Full Stack Python Development -
Codeachive Learning
Bachelor of Management Studies - Finance -
Model College
HSC - Commerce -
Model College
SSC -
SJM English High School
Similar Profiles
Sandeel SelvarajSandeel Selvaraj
Vendor Relationship Manger at Ergode IT Services Pvt. LtdVendor Relationship Manger at Ergode IT Services Pvt. Ltd
Faisal KhanFaisal Khan
Manager - Corporate Accounts & Finance at Ergode IT Services Pvt. Ltd | Ecommerce, USA | Company Size - 600+ EmployeesManager - Corporate Accounts & Finance at Ergode IT Services Pvt. Ltd | Ecommerce, USA | Company Size - 600+ Employees
Shubham PawarShubham Pawar
Operations Team Leader at ERGODE IT SERVICES PVT. LTDOperations Team Leader at ERGODE IT SERVICES PVT. LTD