Karan Bansal
Toronto,ON
Overview
11
11
years of professional experience
Work History
Senior Business Intelligence Engineer
Amazon Web Services
10.2019 - Current
- Led the development and launch of a new VP-level decision acceleration dashboard, providing real-time visibility into target attainment for business critical metrics, enabling faster, data-driven decision-making, and driving improved company performance
- Leading a data-driven initiative to analyse and optimize a 100+ dashboard portfolio, using usage metrics to guide strategic decisions for investment, deprecation, and consolidation, with a focus on continuous improvement in user adoption and decision-making
- Developed the design and implemented a centralized goals reporting infrastructure, which streamlined goal tracking and reporting processes, improved data consistency, and enhanced collaboration across the organization
- Partnered with senior business leaders to develop a comprehensive KPI framework, encompassing business critical metrics for evaluating the health and performance of diverse teams within the organization
- Led monthly tracking and analysis of target attainment and forecast accuracy for all established KPIs, communicating results to stakeholders and recommending data-driven adjustments as needed
- Mentored peers across the organization to transition to the Business Intelligence Engineer (BIE) roles
- Provided guidance on data modelling, ETL processes, and performance tuning, resulting in their career development
Business Strategy Consultant
Affine Analytics (Client: Microsoft Corporation)
06.2018 - 10.2019
- Lead a team of 3 consultants to drive campaign analytics identifying patterns that improve user engagement and drive customers down the marketing funnel
- Automated the reporting, dashboarding cadence and help stakeholders with the following: Audience Segmentation: Defining conversion and segmenting users into potential customers
- Identify drivers that influence conversion and storyboarding conversion paths across a user’s journey
- Subscription Renewal Model: Identifying customers that are at a risk of non-renewal by running machine learning models and running targeted campaigns to mitigate customer churn
- Campaign Analytics: Perform A/B testing and statistical significance testing on treatment and control groups that were a part of the segmented audience, described above
- Dashboards: Utilize outcomes of the above analysis and generate dashboards for effective storytelling and support the management’s goal for performance improvement and develop new business strategies
Senior Data Analyst
Tata Consultancy Services (Client: McKesson Corporation)
02.2015 - 07.2017
- Developed interactive “Pharma Dashboard” on Tableau, identified KPIs for a product, how they drive value
- Worked along a team to work on Time Series Survival Analysis model to estimate the effect of multiple drugs on a patient with chronic disease
- Analysed demand patterns of categories using predictive modelling which helped the category managers to plan in an efficient way and studied the data using statistical techniques in R and Tableau
Data Analyst
Tata Consultancy Services (Client: City University of New York)
08.2013 - 02.2015
- Used SQL and Excel to analyse and manipulate raw data and make it ready for further use
- Used advanced Excel (VLOOKUP, PIVOT TABLES, Charts, VBA, Index/Match, Macros) to represent data and present the findings to stakeholders
- Coordinate with other cross functional teams to obtain the necessary data to improve the analysis
Education
Master of Science - Business Analytics
Arizona State University
Tempe, AZ05.2018
Bachelor of Engineering - Production Engineering
PEC University of Technology
Chandigarh, India10.2013
Skills
- Predictive Analysis
- Data Visualization
- Machine Learning
- Statistical Modelling
- KPI and reporting Strategy
- Data Architecture
- Data Analysis
- Product Management
Accomplishments
- Invited to Judge the prestigious Globee Awards for Technology 2024
- Recipient of 'AWSome Builder Award' at AWS
- Received 'Transformer of the quarter' award at Affine Inc
Timeline
Senior Business Intelligence Engineer
Amazon Web Services
10.2019 - Current
Business Strategy Consultant
Affine Analytics (Client: Microsoft Corporation)
06.2018 - 10.2019
Senior Data Analyst
Tata Consultancy Services (Client: McKesson Corporation)
02.2015 - 07.2017
Data Analyst
Tata Consultancy Services (Client: City University of New York)
08.2013 - 02.2015
Master of Science - Business Analytics
Arizona State University
Bachelor of Engineering - Production Engineering
PEC University of Technology