Badges
Certifications
mmhapusk has not earned any certificates yet.
Work Experience
Business Data Analyst
Liontree• June 2016 - November 2017
Collaborated cross-functionally with various stakeholders to understand business requirements and translate them into measurable KPIs. Managed the implementation of new relational data warehouse in SQL Server and handled subsequent ETL operations from legacy data sources using Alteryx. Developed and optimized complex SQL queries to extract data and perform transformations to prepare the data for analysis. Performed data analysis using Excel, SAS and Python while using statistical techniques such as clustering, regression, classification and forecasting models. Built decision support pipeline by maintaining interactive KPI dashboards in Tableau for weekly, monthly and quarterly reporting to management, reducing manual effort by 10%. Proposed data-driven recommendations for changes to tools, techniques and strategies employed by the consultants. Successfully generated a 40% increase in all major KPIs including CVs sourced, interviews generated and candidate selections. Oversaw a 30% revenue growth from client and candidate billing over the previous financial year
Data Analyst Intern
Liontree• February 2016 - May 2016
Collected, cleansed, analyzed company historical data and executed changes to establish data quality and consistency. Utilized MS Power Query to connect and aggregate data and performed data analysis using Excel functions such as VLOOKUP, Pivot tables, Goal Seek and Macros to extract valuable insights. Designed multiple standard and custom ad-hoc reports in Excel and Tableau by creating visualizations such as histograms, scatter plots and heat maps to report on several key business metrics.
Education
Stevens Institute of Technology
Information Technology, MS• January 2018 - December 2019
Relevant Coursework: Business Process Management, Data and Knowledge Management, Knowledge Discovery from Data, Multivariate Analytics, Marketing Analytics, Managing Emerging Information Technologies, Integrating IS Technologies, IT Strategy, Organizational Behavior and Design, Project Management Fundamentals
University of Mumbai
Computer Science, BE• August 2011 - May 2016