Business/Data Analyst

Hi, I'm Nidhi Kekatpure

Business & Product AnalyticsThat Improve Conversion and ROI

Data Analyst specializing in SQL, Python, and BI dashboards to drive performance and growth.

Projects

A showcase of data analysis projects demonstrating business impact, technical expertise, and problem-solving capabilities across various industries.

Web Scraping: Largest U.S. Companies by Revenue
Web Scraping: Largest U.S. Companies by Revenue
Engineered a high-performance data extraction pipeline to monitor the Top 100 U.S. companies by revenue. Leveraged Python and BeautifulSoup to transform unstructured web data into structured financial datasets, facilitating comprehensive market benchmarking and industry trend analysis.

Key Metrics

Fortune 100 Data CoverageAutomated ETL PipelineReal-time Financial Metrics

Technologies

PythonBeautifulSoupPandasMS ExcelWeb ScrapingMarket Intelligence
Subscription Customer Churn Prediction with AWS
Subscription Customer Churn Prediction with AWS
Architected and deployed a comprehensive customer churn prediction solution using AWS SageMaker, XGBoost, and Python. Built a complete machine learning pipeline from data generation through real-time inference.

Key Metrics

79% AUC23% Churn Reduction$2M Revenue Saved

Technologies

PythonMachine LearningTableauSQLAWS
Vendor Performance
Vendor Performance
Conducted comprehensive vendor performance analysis for retail inventory management using Python, SQLite, and Power BI.

Key Metrics

Exploratory Data AnalysisMulti-vendor ComparisonRisk Assessment

Technologies

PythonSQLitePower BIData Analysis
A/B Testing ROI Analytics
A/B Testing ROI Analytics
Conducted rigorous statistical analysis comparing Facebook and AdWords advertising campaign performance through comprehensive A/B testing and hypothesis testing.

Key Metrics

Facebook vs AdWords AnalysisHypothesis TestingROI Optimization

Technologies

PythonStatistical AnalysisA/B TestingRegression AnalysisMS Excel
AI Inventory Management Chatbot
AI Inventory Management Chatbot
Developed an intelligent AI-powered chatbot using Python and Gradio to provide interactive demand forecasting insights.

Key Metrics

Interactive AI InterfaceTime Series ForecastingDemand Prediction

Technologies

PythonGradioMachine LearningTime Series AnalysisAI ChatbotSQL
California Housing Price Prediction
California Housing Price Prediction
Developed a comprehensive machine learning model to predict median housing prices in California using 1990 census data.

Key Metrics

20,640 Properties Analyzed8 Predictive FeaturesMSE Evaluation

Technologies

PythonMachine LearningRegression AnalysisScikit-learn
Stock Analysis Forecasting
Stock Analysis Forecasting
Developed advanced time series forecasting models to predict stock market trends using historical price data and technical indicators.

Key Metrics

Historical Price AnalysisMultiple Forecasting ModelsTrend Prediction

Technologies

PythonTime Series AnalysisLSTMARIMAMachine Learning

Experience

Delivering measurable business impact through data-driven insights and operational analytics excellence.

Operations Analyst
Wintec IndustriesSan Francisco Bay Area, CA
Full-time
Sept 2024 - Feb 2025

Drive business intelligence and operational excellence for supply chain optimization and semiconductor memory module NPI projects.

Key Achievements

  • Increased data processing efficiency by 40% by automating reporting workflows and standardizing 100K+ records across regions using MySQL, PostgreSQL, and Oracle.
  • Developed interactive BI dashboards in Tableau integrating SAP, SQL, Python, and Power Automate
  • Improved predictive accuracy by 60% and stakeholder engagement by 78% through Python-based ML models and interactive Power BI dashboards.

Skills & Technologies

TableauSQLPythonSAPPower AutomateExcel
Data Analyst, Product and Marketing
WhiteCrow ResearchMumbai Area, India
Full-time
Dec 2019 - Aug 2021

Drove marketing performance optimization and sales forecasting through advanced analytics and A/B testing.

Key Achievements

  • 20% improvement in website conversion rates through A/B testing with Adobe Analytics
  • 30% reduction in campaign reporting time via Tableau dashboards
  • 40% reduction in manual effort through automated data extraction

Skills & Technologies

Adobe AnalyticsTableauSQLSalesforce CRMA/B Testing
Business Process Analyst
QX Ltd.Greater Ahmedabad Area
Full-time
Mar 2018 - May 2019

Delivered business insights through data analysis and business process modeling.

Key Achievements

  • 30% improvement in decision-making accuracy through data analysis
  • 25% increase in email click-through rates through A/B testing optimization
  • 15% increase in efficiency via Power BI real-time KPI dashboards

Skills & Technologies

MySQLPostgreSQLOracleETLPower BI

About Me

Passionate about transforming complex data into actionable insights that drive business value.

Profile

Hi, I'm a Data Analyst

With over 3 years of experience in data analysis and business intelligence, I specialize in transforming complex datasets into clear, actionable insights that support data-driven decision-making. My passion lies in bridging technical analytics with real-world business and marketing objectives.

Throughout my career, I’ve worked across operations, product, and marketing teams in fast-paced global environments, helping organizations optimize processes, improve customer engagement, and drive measurable growth through analytics, experimentation, and automation.

Education

Master of Science in Engineering Management

California State University at East Bay

2023 - 2024 • GPA: 3.9/4.0

Specialized in statistical modeling, machine learning, and business intelligence.

Bachelor of Engineering in Computer Engineering

Savitribai Phule Pune University

2012 - 2016

Major in Computer Science and Engineering.

Technical Skills

Databases

SQLAdvanced

Languages

PythonAdvanced
RIntermediate

Visualization

TableauAdvanced
Power BIAdvanced

Analytics

Excel/VBAAdvanced
Statistical AnalysisAdvanced
Machine LearningIntermediate

Professional Skills

Strategic Thinking
Stakeholder Communication
Problem Solving
Project Management
Business Acumen
Data Storytelling
Cross-functional Collaboration
Critical Analysis

Get In Touch

I'm always open to discussing new opportunities, collaborations, or just having a chat about data analytics.

Send Me a Message
Fill out the form below and I'll get back to you as soon as possible.
Contact Information
Connect With Me
Resume
Get a detailed look at my professional journey and qualifications.