Business Analyst

• Jul 2022 - Present

Data Reporting Analyst

• Nov 2021 - Jul 2022

Data management & providing analytical support to manage the budget for the university’s IT division in various funding projects o Responsible for monitoring computer usage & printing statistics and reporting it in the form of a Power BI dashboard o Responsible for assessing the need of library patrons by analysing the usage of paid software licenses installed in the systems o The usage analysis reports helped in saving $3500 for the Spring 2022 semester. The reports were presented in the form of Excel or Power BI dashboards Show less

Data Analyst and modelling Associate.

• Oct 2017 - Dec 2020

Campaign execution & management, A/B testing & reporting for a Fortune 500 organization (automobile) o Vital member of the analytics scrum team responsible to organise leads data (using ETL) obtained from campaigns executed in 11 European markets through multiple media channels and analyzing it by performing EDA using MySQL & R o Performed evaluation of key variables(KPIs) using correlation analysis that eventually aided in envisioning leads conversion o KPI evaluation along with regression analysis on the leads data yielded a 27% increase in customer conversion in Q4 2019 o Performed EDA & generated valuable insights using statistical analysis techniques like hypothesis testing, 1-tail & 2-tail tests on car sales time-series data o Precisely predicted 16% YoY increase in car sales with an accuracy of 92% using Prophet package in R o Designed an analytical dashboard depicting customer’s car brand migration from competitor brands for last 15 years of data Web application development , time series analysis & stakeholder management for a Fortune 500 organization (automobile) o Led a team of 3 Jr. data analysts to develop and publish a web app to predict monthly lead acquisition basis media spend o Responsible for leading communications between the onshore and offshore teams o Created PRDs to prioritize requirements from the stakeholders on the working of the web application o Formulated a 45 days detailed roadmap for self and development team to build the web app by executing bi-weekly sprints o Web app had an accuracy of 93.6% and accurately predicted 24% hike in lead acquisition & conversion for Q3 in 2020 o Analyzed and summarised client website's incoming traffic data it using Adobe analytics and advanced MS Excel o Successfully identified 4 traffic channels responsible for 55% decrement in incoming traffic and reported ideas in the form of a weekly MS Excel (Power Query) & Power BI dashboard to tackle the decrement Show less

Data Analyst

• Aug 2016 - Oct 2017

Achievement: Decreased attrition of high net-worth (HNW) customers from 21% in Q2 in 2017 to 15% in Q3 Customer Profiling - Performed HNW- NRI customer profiling to identify customers for possible attrition - Identified gaps in the product portfolio and suggested recommendations to the product team Data Extraction & Analysis - Performed data extraction and applied analytical techniques to increase cross-sell of products for HDFC - Created weekly analytical dashboards for assets like personal loan, gold loan & home loan using excel Show less