Personal details

Mani S. - Remote data analyst

Mani S.

Timezone: New Delhi (UTC+5.5)

Summary

I have worked on several projects like payout automation, building alerting systems based on business insights, creating dashboards, debugging & testing the data for the backend services. Writing a new SQL query every hour is like scrolling an Instagram feed. I have worked on big unstructured data dumps, almost all type querying systems like (Amazon Redshift, MySQL, PostgreSQL, BigQuery, etc). Written python scripts to automate the redundant jobs using Panda, Numpy, and other python libraries

Work Experience

Lead Data Analyst
BlinkIt (Formally Grofers) | May 2019 - Present
PostgreSQL
Tableau
Amazon Redshift
- Managed data analytics for Ad monetization platform, daily reporting figuring out next steps for business using data insights. - 200% growth in revenue with 2 quarters with learning the data insights. - Worked on data visibility within the organization.
Senior Data Analyst
Netomi | Mar 2017 - May 2019
JSON
PostgreSQL
Cassandra
- Configured the analytics dashboard for the clients using MySQL and Druid, defining and designing all the KPIs required for each business client. - Develop complex reports using Druid and Python to examine the classification score for various bots. - Designed and developed an automated system to extract data from the system using postman and python to reduce the dependencies and wait time. - Data Analysis and strategies for the company growth, defining the business hypothesis on basis of data insights. - Identify unnecessary reasons affecting the classification performance score down and increased the performance by 6.5%. - Conduct data mining and data modelling for the client project proposal. Maintain up-to-date documentation of all the analytics process - Manage multiple client accounts totaling $75 million. Sharing the multiple periodical reports for all the clients to share the bot performance improvement. - Interpreted the raw data to bring out the business insights for the management to support the business decisions

Personal Projects

Daily Manpower Prediction for vendors and merchants
2022
Python
PostgreSQL
Amazon Redshift
A very basic model based on three variables as sales, current utilization, and capacity. Learning from the demand trends and utilization values to predict the manpower required at a given vendor at an hourly level
Sales attribution Model for Advertising Platform
2021
SQL
Automation
Data Modelling
Designed an attribution model to most accurately calculate the ROAS (return on advertising sales) for users using learning and market research in the advertising industry.