Badges
Certifications
Work Experience
Market Research Analytics Consultant
RenewableTech Ventures•  January 2019 - April 2019
• Led a team to develop Impact Reporting scorecard, conducting competitive market analysis and identifying KPIs, improving business decisions through analytics • Developed analytical reports interpreting trends in cleantech space and presented them to the executive team
Digital Marketing Analyst
Switchpoint Financial Planning LLC•  January 2019 - March 2019
• Led a team to implement multi-channel funnel attribution model to run a geo-tagged Digital Marketing campaign on Google AdWords acquiring 26.67% new users, increasing average time on page by 65.99% and achieving Click Through Rates of 10% • Analyzed traffic behavior through Google Analytics, implemented predictive time-series analysis to recognize seasonality, increasing lead generation by 25% • Analyzed competitor pages, locating backlink and keyword opportunities, achieving 30% increased traffic and low Average CPC and Cost per Conversion • Drafted and presented a plan to the executives – demonstrating an increase in website traffic by a further 20%
Data Analyst Lead
Tech Mahindra •  June 2016 - June 2017
• Cleaned 10GB+ in Salesforce cloud by performing regular Data Maintenance activities • Created various reports and dashboards in SalesforceDotCom to assist managers; demonstrating 99% clarity of customer churn • Analyzed data using statistical techniques, produced Tableau reports and presented them to the BI team • Wrote SQL and PL/SQL scripts and tuned the performance of existing queries/scripts – reducing required time by 35% • Mentored a group of Software Engineers to improve customer service level by 20%
Data Analyst
Tech Mahindra •  November 2014 - June 2016
• Led three teams simultaneously, served as Wherescape RED ETL Subject Matter Expert, and helped improve the quality of service provided by 33% • Reduced ETL time by 30% by automating scripts using shell, allowing timely updates • Created ad-hoc reports to answer business questions as per the BI team’s requirement • Centralized data sources, checked for data quality, analyzed data, and built dashboards for managers using Tableau
Associate Data Analyst
Tech Mahindra •  July 2014 - November 2014
• Provided support for Database Server and production DB decreasing downtime by 30% • Provided support for production data loads and ongoing refreshes of data warehouse reducing SLA breaches by 25% • Used Python to script tasks saving a total of two days/week labor
Education
University of Utah
Business Administration, MBA•  August 2017 - May 2019
GPA: 3.71 Courses – Data Analytics & Decision-Making, Data Science & Big Data, Business Analytics, Data Visualization Clubs - Analytics, Tech Club
University of Utah
Business Analystics, Graduate Certificate•  August 2017 - May 2019
West Bengal University of Technology, Kolkata
Electronics and Communication Engineering, B.Tech•  August 2010 - June 2014
Julien Day School, kalyani