Junior data analyst with 06 months of data analysis experience in healthcare and finance industry. Data Science user group member First Rank – Datathon-2023.
Downloaded restaurant data from zomato website for more than 10000 restaurants across india.
Ingested this data in MySQL database and performed ETL to remove outliers, clean up bad records, normalize revenue numbers to standard format using python, jupyter notebook and two standard deviation along with some other statistical techniques.
For analysis of ahmedabad restaurants, used Excel, VBA macros and pivot table.
Figured out best restaurants for punjabi and south indian cuisine based on reviews.
Used Tableau to build various BI dashboards that can show revenue growth in different restaurants based on cuisine and how people’s preferences have changed over a period of 5 years.
Curated a data story for annual data analytics initiative, now available on GitHub, encapsulating key insights to foster collaboration within the team.
Learned how data transparency is brought to big organizations enabling users to make data informed decisions.
Connected Power BI with MySQL, Excel to import 4 million records.
Performed data transformation in Power Query.
Built a dashboard in Power BI from scratch for finance, sales, marketing, supply chain and executives which will support the organization in gross margin improvement.
Learnt project management skills: Project charter (using Mural), stakeholder mapping analysis, Kanban board for task assignment to improve productivity.
Helped automate manual data extraction processes by doing auto classification of health care documents (prescriptions, doctor notes, equipment orders) using python tesseract and regex.
Improved SLA for the classification process from 50 minutes to 2 minutes per document.
Prepared various BI dashboards in Tableau for month on month insurance business report.
Evaluated and analyzed insurance claims dataset using Excel V-lookup, Chi-square, Normal and T-distribution.
Removed outliers using Python and Pandas.
Helped business to decide in dynamic pricing by identifying business insights and forecasting the trends for future months using time series analysis using Excel.
Worked closely with the engineering and business team using scrum/agile methodology.
The AI-first Recruitment Operating System that unifies and automates the entire hiring lifecycle for modern enterprises worldwide.
Dr Job FZ LLC. 2026 © All Rights Reserved
