Highly skilled Data Analyst with 5 years experience expertise in Tableau, SQL, AWS and Python seeking a challenging role to leverage analytical abilities and data visualization skills to drive insights and decision-making. I always believe that my progress lies in the progress of organization. My objective is to work in a challenging and competitive environment where I have the scope to improve my knowledge in all fronts without compromising my duties in the organization.
Overview
6
6
years of professional experience
Work History
Manager
Prudent Insurance Brokers Pvt Ltd
Mumbai
03.2024 - 09.2024
Automated excel data processing using python which team was doing manually on daily basis. Earlier the processing was taking 45-60 minutes, after automation it is taking less than 3 minutes to process data.
ITMS to JIRA Migration.
Web automation to download daily data - used selenium library in python to automate the downloading of data from SAIBA website. Scheduled the script using windows task scheduler which automatically runs early morning and make's the data available on OneDrive before the team logs in.
Developed interactive Reports and Dashboards using Power BI.
Designing and development of reports and Dashboards using Tableau.
Publishing reports and dashboards on Tableau server, managing user access and distribution of Tableau viewer license.
Exposure to Insurance Broking and Financial domains and worked on KPI's such as Revenue, Brokerage, Brokerage % and interpreting large datasets to identify trend and patterns.
Built SQL queries to perform data validation.
Exposure of SAP HANA database and using same to build reports on Tableau.
Coached, mentored and trained team members in order to improve their job performance.
Built interactive, optimized and insightful dashboards following Tableau best practices for revenue tracking.
Data Analyst
Session AI (formerly known as Zineone India pvt ltd.)
Mumbai
05.2022 - 09.2023
Generated reports and obtained data to develop analytics on key performance and operational metrics.
Developed python script for data processing and automated same using Crontab and AWS glue.
Analysed e-commerce customer data to identify performance issues and suggested changes in campaigns to generate positive Incremental Revenue.
Generating weekly analysis reports to make sure campaign is performing as expected.
Collecting, analyzing, and interpreting large datasets to identify trends and patterns.
Developing interactive dashboards using Tableau to present key insights to stakeholders.
Managing dashboards, datasources, users and access on Tableau server. Development, publishing and designing Tableau dashboards to fulfill requirements and provide meaningful insights.
Exposure in e-commerce domain and worked on KPI's such as AOV(Average Order Value), RPV(Revenue Per Visit), Conversion and Incremental Revenue.
Generating performance reports for e-commerce customers and leadership team.
Weekly report generation and data extraction
Creating SQL queries for validation, adhoc analysis and pulling data from database.
Re-designed Company's Tableau Platform architecture and encouraged users to use Tableau dashboards for their queries.
Conducted Tableau training for new users to make them familiar with the Reports/Dashboards operations and functionalities.
Creating visualizations and reports using Tableau to support business operations.
Involved in data extraction, transformation and loading and automation using python and crontab.
Working collaboratively with other teams in the organization.
Analyzing data to identify performance issues.
Building custom athena queries for data extraction and validation.
Maintained or updated business intelligence tools, databases or dashboards.
Conducting ad-hoc analysis and generating actionable insights for decision-making.
Optimized Tableau dashboard performance following best practices.
Provided technical support for existing reports, dashboards or other tools.
Software Engineer
CitiusTech Healthcare Technology Pvt. Ltd.
Navi Mumbai
10.2021 - 05.2022
Involved in requirement gathering for Tableau Dashboard Development.
Performing Unit testing and data validation.
Bug fixing in existing dashboards.
Adhoc changes in reports, dashboard layout and calculated fields.
Publishing Tableau dashboards and datasources to Tableau Server.
Debugging SQL queries and making changes in queries to fetch required data from database.
Provided technical support for existing reports, dashboards or other tools.
Maintained or updated business intelligence tools, databases or dashboards.
Data Engineer
Here Solutions India Pvt Ltd
Navi Mumbai
01.2019 - 08.2021
Automated and Optimized Trace2D manual Image ingestion process(Python Jobs) to ingest bunch of images for annotation and created executable file so that the task can be performed by non technical person as well.
Weekly data extraction and report generation for Clickwork Tool.
Designing and developing highly interactive Tableau dashboards and Tableau story for various stakeholders in GIS domain.
Capable of creating visually rich and highly optimised visualisations. Well versed in using sets, groups, parameters and calculated fields in Tableau Desktop.
Documenting Business Requirements Document (BRD). Comfortable in dealing with end users while working on KPI's, Requirements and detail designs.
Working with data warehouse teams and understanding data. Proficient in writing SQL queries, creating joins, Indexes as per requirements. Ability to handle multiple data sources.
Responsible to ensure the accuracy of the information that is being provided by carefully and continually scrutinizing the data to ensure the right information is portrayed in the reports being delivered.
Data processing and transformation using Pandas, Python.
Developed Tableau visualisation using Cross tabs, Heat maps, Scatter Plots, Geographic Map, Bubble Chart, Pie Charts, Trend Lines and Bar Charts.
Education
Bachelor of Science - Information Technology
University of Mumbai
Mumbai
Skills
Proficient in Tableau for data visualization and interactive dashboards
Experience with data manipulation, cleaning, and transformation
Familiarity with SQL for querying and data extraction
Query Tools
Report Preparation
Report Generation
AWS
Pandas
Process Improvement
MIS Automation
Analytical Problem Solving
Data Quality
Data Exports
Languages
Hindi
First Language
English
Proficient
C2
Marathi
Advanced
C1
Affiliations
1st Runner ups of Pimpri Chinchwad Municipal Corporation Hackathon 2020
Spot Recognition for resolving Places Annotations Clickwork production issue to avoid delay in project deliveries and idle time of resources (Here Solutions India Pvt Ltd).
Timeline
Manager
Prudent Insurance Brokers Pvt Ltd
03.2024 - 09.2024
Data Analyst
Session AI (formerly known as Zineone India pvt ltd.)