Manan Desai

Data Analyst
New Brunswick, US.

About

Highly analytical and results-driven Data Analyst with 2+ years of progressive experience, specializing in end-to-end SQL/Python data pipeline development, advanced BI dashboard design (Tableau, Power BI), and workflow automation. Successfully improved data accuracy by 20% and reporting efficiency by 30% across diverse data platforms including Snowflake, Redshift, and BigQuery. Proven ability to translate complex data into actionable insights, driving strategic decision-making and fostering cross-functional collaboration to achieve measurable business outcomes.

Work

Research with Quest Global CTO
|

Data Analyst

New Brunswick, NJ, US

Summary

Led data analysis initiatives for the CTO, focusing on developing robust data pipelines, predictive models, and interactive dashboards to inform strategic executive decisions.

Highlights

Engineered automated Python/SQL pipelines, leveraging Pandas, NumPy, and SQLAlchemy, to integrate and process over 250,000 records from WRDS, Compustat, BoardEx, and SEC data with 0% data loss.

Developed and trained XGBoost models with SHAP interpretability for succession forecasting, achieving 78% prediction accuracy and delivering critical KPI-driven insights that informed strategic restructuring decisions.

Created interactive Tableau dashboards to visualize executive turnover and succession metrics, accelerating stakeholder decision-making speed by 35% through enhanced data accessibility.

Youbloom
|

Business Intelligence Analyst

New Brunswick, NJ, US

Summary

Architected and optimized data infrastructure and developed advanced BI solutions to enhance feature delivery and drive user engagement for a streaming data platform.

Highlights

Architected and optimized PostgreSQL schema and SQL views for streaming data (300+ records/day), reducing redundant queries and accelerating feature delivery by 50%.

Implemented GA4-based A/B testing frameworks to evaluate Click-Through Rate (CTR) and session duration, leading to a 10% improvement in CTR and an 8% increase in user engagement.

Developed over 10 Tableau dashboards with advanced drill-down capabilities for product and marketing teams, boosting cross-functional adoption of data insights by 25%.

Nintee
|

Data Analyst

Mumbai, Maharashtra, India

Summary

Streamlined data consolidation and analysis processes, leveraging BI tools to improve retention and operational efficiency.

Highlights

Consolidated onboarding and retention data using SQL and Power Query, enabling real-time KPI monitoring and eliminating over 5 manual hours per week.

Performed comprehensive funnel and cohort analysis using Power BI, which directly contributed to a 22% improvement in user retention within four weeks.

Collaborated with cross-functional teams to define key metrics and develop dashboards, reducing the insight cycle time by 30%.

IBM
|

Data Analyst

Mumbai, Maharashtra, India

Summary

Supported strategic financial forecasting and risk monitoring by modeling financial statements and developing comprehensive BI dashboards.

Highlights

Modeled complex financial statements within BigQuery, ensuring data integrity to 95% accuracy for enhanced strategic forecasting.

Developed over 15 Power BI and Excel dashboards to monitor liquidity, margins, and returns, improving risk monitoring and forecast accuracy by 30%.

Education

Rutgers University
New Brunswick, NJ, United States of America

Master of Science

Data Science

Grade: 3.87/4 GPA

University of Mumbai
Mumbai, Maharashtra, India

Bachelor of Technology

Electronics Engineering (Honors in Data Analytics issued by IBM)

Awards

Nasdaq Hackathon Winner

Awarded By

Nasdaq

Won the Nasdaq Hackathon by engineering a comprehensive Python/SQL ETL solution and Tableau KPI dashboards to address a real-world financial planning and analysis (FP&A) problem, delivering actionable insights.

Skills

Programming & Scripting

SQL, Python, R, VBA, Git, Java, Javascript, Pandas, NumPy, SQLAlchemy.

Business Intelligence & Visualization

Tableau, Power BI (DAX), Looker Studio, Alteryx, Streamlit, Plotly, Excel (PivotTables, Power Query).

Databases & Cloud Platforms

Snowflake, BigQuery, Redshift, PostgreSQL, MySQL, MongoDB, Azure Data Studio, Data Warehousing (Star/Snowflake Schema).

Data Analysis & Modeling

EDA, KPI Design, A/B Testing, Cohort/Funnel Analysis, Statistical Modeling, Data Cleaning, Forecasting, Data Visualization, XGBoost, SHAP, Data Modeling, GA4, Funnel Metrics, Financial Analysis, Data Validation, Experimentation Design.

Project Management & Collaboration

Agile/Scrum, Stakeholder Communication.

Projects

Retail BI Warehouse

Summary

Designed and implemented a star-schema data warehouse for retail operations, integrating diverse data sources and visualizing key performance indicators.

Revenue Analytics App

Summary

Developed an interactive analytics application to automate revenue segmentation and optimize pricing strategies.

Real Estate Price Forecasting

Summary

Developed a predictive regression model for real estate price forecasting, leveraging machine learning techniques.