Manish Chauhan

Data Analyst, Consultant at Thoucentric

Automated monthly timesheet reminders using Power Automate; built a Tableau dashboard for Unilever to visualize global KPIs (GMV, Order Value, Average Order Value, Customer retention) aiding decision making; developed a data extraction product for Jira data via REST API using Power Automate and Tableau for real-time project performance insights (burn rate, task status, team efficiency); led an NLP project in Python to assess QA note thoroughness; designed and executed A/B tests to evaluate nano-learning course effectiveness; created a Databricks data ingestion/transformation pipeline pulling from AWS S3, processing with PySpark, and storing results in SQL Server for BI use.

Senior Data Analyst, Reporting and Analytics Division at BrandMuscle, Inc.

Automated manual reporting by connecting to Snowflake with a dynamic date-range stored procedure, reducing LOE by 80%; performed exploratory data analysis (EDA) using Python to derive insights for a client recommendation model; conducted hypothesis testing to measure marketing campaign impact on impressions, clicks, leads and conversions; automated global marketing/sales reporting by linking Snowflake to Python scripts with dynamic filters; built and embedded Tableau dashboards for real-time campaign monitoring; ETL pipelines in Databricks (PySpark) to clean/standardize/aggregate data for self-service analytics and Power BI dashboards; data quality checks in Python reducing issues by 90%; loaded cleansed data into Snowflake for KPI dashboards.

Business Analyst at Nablasol Digital Service Pvt Ltd.

Designed Employee Tracking System using Wireframe and SugarCRM to capture task data and time, enabling measurement of employee efficiency and LOE; designed a data warehouse and automated ETL to move data from Azure Blob Storage to SQL Server Data Warehouse; gathered requirements, coordinated with developers, tested and deployed tools; created Ad-hoc reports in Power BI using SQL and managed administrative tasks in SugarCRM; developed scalable PySpark Databricks ETL pipelines for millions of transactions, scheduled with Apache Airflow; implemented dynamic data quality checks reducing manual issues by 90%; cleansed data loaded into Snowflake for KPI dashboards.

Senior Associate - PMO at Wipro Ltd.

Created account-level billing forecasting (Quarterly, Semi-Annual & Annual) using Moving Average; reduced backlog tickets from ~15% to ~9%, contributing to revenue growth at account level; built dashboards/reports in Tableau and Power BI for senior management; queried MySQL and SQL Server with complex SQL to fetch data for reports and dashboards.

Data Analyst Consultant at Thoucentric

Automated monthly timesheet reminder emails using Power Automate; built a Tableau dashboard for Unilever to visualize KPIs (GMV, Order Value, Average Order Value, Customer retention rate). Developed a product to extract Jira data via REST API with Power Automate and Tableau for real-time project performance insights (burn rate, task status, team efficiency). Led a Python NLP project to analyze QA notes for thoroughness. Designed A/B tests for nano-learning course impact on quality scores. Built a Databricks data ingestion and transformation pipeline reading from AWS S3 and storing results in SQL Server for BI.

Market Research Intern at The Business Research Company

Conducted secondary research across sectors, analyzing CAGR, drivers, restraints, market size, growth rate, trends, regulations, segmentation, and key players; compiled reports.

Trainee Engineer, R&D at Husk Power Systems

PCB designing with OrCAD; prototyped a wireless energy meter system for data transfer between main and sub-stations using Tarang Radio Module (XBEE protocol).