Summary
Overview
Work History
Education
Skills
Current/ Previous Projects
Timeline
Generic

Manmeet Kaur

London,ON

Summary

Seasoned business analyst with over 5 years of experience in data extraction, data cleaning, data analyses, and automation using Excel, Macros, SQL and R. Attention to detail in following through due diligence and work as per the process requirements. Hold knowledge on data management visual reporting using Tableau.

Overview

9
9
years of professional experience

Work History

BUSINESS DATA ANALYST

CARFAX
07.2021 - Current
  • Working on one of the crucial data types of the company that adds value to the product month-on-month basis and providing data driven recommendations.
  • Help in business and strategic decision making process by running insights on millions of records.
  • Monthly reports and dashboard generation for the stakeholders to track key performance indicators (KPIs) and metrics.
  • Analyzing large datasets to identify trends, patterns, and insights related to automotive data.
  • Automated repetitive tasks through scripting, freeing up time for more complex analysis projects.
  • Working with teams across business to understand the process requirements and working towards it for a better customer experience, along with account handling and processing invoices.
  • Keeping up to date with the industry, emerging technologies, and competitors to drive continuous improvement in data analytical and strategic decision making.


DATA ANALYST

Osianama Learning Experience Pvt Ltd
12.2018 - 02.2021
  • Experience in data clean up and standardization with VBA/Macros (Loops, UDFs, Add-ins) Web content management using basic HTML and interlinking on Joomla and WebApp
  • Exceeded goals through effective task prioritization and great work ethic managing data of over 100k records, across over 200 fields in 40 categories
  • Kept team on track by assigning and supervising their activities and giving constructive feedback during projects.

PAYMENTS DATA ANALYST

UrbanClap Technologies Pvt Ltd
06.2015 - 06.2018
  • Cash-flow analysis and forecasting using SQL queries.
  • Service provider data presentation and interpretation using Tableau resulting in increased value addition of 40%
  • Descriptive statistical analysis to help product team make better decisions.

Education

Master of Science - Business and Marketing Analytics

Aston Business School
07.2015

Bachelor of Science - Business and Management

Aston Business School
06.2011

Skills

  • MS Office
  • Advanced Excel (with Power query)
  • SQL Queries
  • R Studio
  • UltraEdit
  • Tableau Software
  • VBA and Macros
  • Strategic Gap Analysis
  • Report Generation
  • Oral and Written Communication
  • Problem-Solving Skills
  • Validating Data
  • Attention to Detail
  • Descriptive Statistics

Current/ Previous Projects

  • Redundancy and Gap Analysis- Working with assorted data to determine relationship between data sets and variables and finding the value add of a variable set (from new or existing source) by running the samples against existing database and inferencing the gaps which helped in only retaining the data useful to the company, saving time, money and database memory.


  • Ticketing Automation (Excel) for El Gouna Film Festival- Created Excel Macros for automating the cost file for the guests arriving at the festival in terms of flights, hotels, meals, transport etc. The file created a new rows depending on what services the guests opted for, which helped in overall planning and budgeting.


  • Impact and understanding of Scriptures of Temples of Khajuraho- Worked with a team of anthropologists to determine the importance and idea behind the scriptures of the temples. Helped in creating questionnaire with quantitative and qualitative questions, which later helped in gaining substantial funding from the Indian government (Archeological Survey of India)

Timeline

BUSINESS DATA ANALYST

CARFAX
07.2021 - Current

DATA ANALYST

Osianama Learning Experience Pvt Ltd
12.2018 - 02.2021

PAYMENTS DATA ANALYST

UrbanClap Technologies Pvt Ltd
06.2015 - 06.2018

Master of Science - Business and Marketing Analytics

Aston Business School

Bachelor of Science - Business and Management

Aston Business School
Manmeet Kaur