Shrutika Nipane

Data Analyst

Mumbai, Maharashtra, India2 yrs 11 mos experience

Key Highlights

3+ years of experience in data analytics.
Expert in SQL, Python, and BI tools.
Passionate mentor for aspiring data professionals.

Stackforce AI infers this person is a Data Analyst specializing in MarTech with strong skills in predictive modeling and data visualization.

Contact

Skills

Core Skills

Data AnalysisBusiness InsightsPredictive ModelingData VisualizationBusiness IntelligenceData ManagementAutomationData Quality AssuranceReportingData Extraction

Other Skills

Google SheetsPython (Programming Language)Google BigQueryPythonLooker StudioBigQueryData ValidationMicrosoft ExcelApache SupersetMachine LearningMicrosoft Power BIGoogle Data StudioTableauPandas (Software)NumPy

About

I’m Shrutika Nipane, a Data Analyst with 3+ years of experience in digital marketing analytics, music streaming analytics, customer behavior insights, BI reporting, and predictive modeling.I work extensively with SQL, Python, BI tools, and data visualization to convert complex datasets into actionable insights that support decision-making and drive business growth. My experience spans user engagement analysis, campaign performance, funnel optimization, segmentation, and automation of reporting workflows.Core Competencies:SQL (Snowflake, BigQuery, MySQL)PythonPower BI, Tableau, Looker Studio, Apache SupersetAdvanced Excel & Dashboard AutomationCohort Analysis & Customer SegmentationMachine Learning (Regression, Classification, Forecasting) I hold a Master’s in Data Science from IT Vedant Education Pvt. Ltd. and a Bachelor of Science in Information Technology from Mumbai University.I’m passionate about solving business problems with data and constantly improving my skills in Business Intelligence, Statistical Analysis, and Data Science. I also enjoy mentoring aspiring data professionals and helping them navigate their analytics career journey. If you’d like more tips, tutorials, and mentorship: 📸 Instagram: [https://www.instagram.com/shrutikanipaneofficial] 🤝 1:1 Mentorship (Topmate): https://topmate.io/shrutika_nipane] Let’s learn and grow together! 🚀

Experience

2 yrs 11 mos

Total Experience

1 yr 6 mos

Average Tenure

1 yr 5 mos

Current Experience

Jiosaavn

Data Analyst - Business Insights

Dec 2024 – Present · 1 yr 5 mos · Navi Mumbai, Maharashtra, India · Hybrid

Google SheetsPython (Programming Language)Data AnalysisBusiness Insights

Pivotroots

2 roles

Associate Data Analyst

May 2023 – Nov 2024 · 1 yr 6 mos · Mumbai, Maharashtra, India

1)Analyzed upcoming movie campaigns’ trends and forecasted first-day revenue using a predictive regression prelaunch and lifetime model with 87.65% accuracy. Optimized promotional strategies, including social media campaigns, influencer marketing, and movie asset release planning. Ensured effective audience engagement and maximized revenue potential through strategic insights.
2)Created over 20+ automated dashboard reports utilizing Looker Studio & Big query to track digital marketing Key Performance Indicators (KPIs). Resulted in a remarkable 50% reduction in daily reporting time. This optimization facilitated enhanced data analysis capabilities and expedited decision-making processes.
3)Implemented and managed over complex connected Google Sheets integrated with Big query via data connectors, facilitating extraction of data. Developed advanced pivot tables with daily refresh capabilities, automating report generation and minimizing reporting times by 60%.
4)Developed and implemented a standardized dashboard validation automation solution using Python to ensure data accuracy. Engineered to detect data discrepancies between dashboard and API data, with a 5% threshold triggering automatic email alerts for affected clients. This solution reduced daily quality check time by 2 hours.

Google BigQueryPython (Programming Language)Data AnalysisPredictive Modeling

Data analyst intern

Feb 2023 – Apr 2023 · 2 mos · Mumbai, Maharashtra, India

1)Understood digital marketing platforms and built reports to generate actionable insights through comprehensive reporting.
2)Developed a YouTube Comments Crawler to extract comments from YouTube channels, enabling the sentiment analysis team to derive valuable insights from user sentiment expressed in comments.

Python (Programming Language)Microsoft ExcelData AnalysisReporting