Mani Sharma

Mani Sharma

Mentor
5.0
(4 reviews)
US$10.00
For every 15 mins
5
Sessions/Jobs
ABOUT ME
A data wizard with ~8+ years expertise on Excel, SQL and Python
A data wizard with ~8+ years expertise on Excel, SQL and Python

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

New Delhi (+05:30)
Joined January 2019
EXPERTISE
3 years experience
I have worked on data warehousing solutions, automated several processes like creating jobs using API connections, accessing databases,...
I have worked on data warehousing solutions, automated several processes like creating jobs using API connections, accessing databases, working on big data frames, build sustainable models for utilization planning.
8 years experience
Expertise in modeling using Excel, handy with all the shortcuts & functions to evaluate and create insights or dashboard
Expertise in modeling using Excel, handy with all the shortcuts & functions to evaluate and create insights or dashboard
8 years experience
I have been working on SQL for 8 years, very familiar with querying on different schemas, complex queries.
I have been working on SQL for 8 years, very familiar with querying on different schemas, complex queries.
3 years experience
Creating multiple dashboards with dynamic filters for data visualisation, reporting & modelling
Creating multiple dashboards with dynamic filters for data visualisation, reporting & modelling
8 years experience | 2 endorsements
8 + years of experience in data analytics. Designing the metrics for any product feature to evaluate its business impact. Created alertin...
8 + years of experience in data analytics. Designing the metrics for any product feature to evaluate its business impact. Created alerting systems to figure out the development gaps in data products.

REVIEWS FROM CLIENTS

5.0
(4 reviews)
Joshua Gordon
Joshua Gordon
March 2022
Mani is a great tutor. She is patient and teaches you to understand the code you are writing. She has solved several complex issues for me, and I highly recommend her.
Paul
Paul
March 2022
Great teacher! Highly recommend
EMPLOYMENTS
Lead Data Analyst
BlinkIt (Formally Grofers)
2019-05-01-Present
- Managed data analytics for Ad monetization platform, daily reporting figuring out next steps for business using data insights. - 200% g...
- 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.
PostgreSQL
Tableau
Amazon Redshift
View more
PostgreSQL
Tableau
Amazon Redshift
View more
Senior Data Analyst
Netomi
2017-03-01-2019-05-01
- Configured the analytics dashboard for the clients using MySQL and Druid, defining and designing all the KPIs required for each busines...
- 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
JSON
PostgreSQL
Cassandra
View more
JSON
PostgreSQL
Cassandra
View more
Business Analyst
Fella Homes
2016-02-01-2017-02-01
• Statistical data analysis for company growth projection and investor reporting • Designing performance dashboard on SQL and EXCEL for d...
• Statistical data analysis for company growth projection and investor reporting • Designing performance dashboard on SQL and EXCEL for daily/weekly and monthly tracking • Designing various tools for assisting specific departments for streamlining the workflow and automating various process reports providing detailed insights into operation and sales buildout • Formulating & implementing strategies and policies for targeting unexplored market/customers for business expansion • Designing end to end process KPI for the organization and managing data warehousing of the company with single point ownership • Managing various audits for data compliance and maintaining data integrity and hygiene
SQL
Excel
Microsoft Power BI
View more
SQL
Excel
Microsoft Power BI
View more
PROJECTS
Daily Manpower Prediction for vendors and merchants
2022
A very basic model based on three variables as sales, current utilization, and capacity. Learning from the demand trends and utilization ...
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
Python
PostgreSQL
Amazon Redshift
View more
Python
PostgreSQL
Amazon Redshift
View more
Sales attribution Model for Advertising Platform
2021
Designed an attribution model to most accurately calculate the ROAS (return on advertising sales) for users using learning and market res...
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.
SQL
Automation
Data Modelling
View more
SQL
Automation
Data Modelling
View more