Overview
Work History
Education
Software
Soft SKills
Timeline
Generic

Manvir Kohli

Vancouver,BC

Overview

5
5
years of professional experience
5
5
years of post-secondary education

Work History

Senior Data Analyst – Internal Audit

United Airlines
Delhi NCR, India
02.2020 - 06.2022
  • Built Python scripts to automate SOX controls through web scraping, evidence collection (downloading files and taking screenshots) and Excel preparation, resulting ina savings of 300 man-hours annually
  • Built an Alteryx workflow (which was later converted to a Python script and deployed in production) as part of an audit to validate the accuracy of Air Navigation fee invoices worth USD 40 Mn
  • Built a Python script to automate extraction of audit files- achieving approximately 66% time efficiency - during the transition process to a new audit management software
  • Assisted in building Python and SQL queries to identify cases where balances of internal test accounts set up for United's loyalty program were misused by employees for travel benefits
  • Built a Spotfire dashboard to show instances where employees were using their discounted travel benefits to block seats on a flight and fly free of charge

Service Operations Associate

Gartner
Delhi NCR, India
10.2019 - 01.2020
  • Performed thorough review of clients' marketing collateral containing Gartner researches, to ensure compliance with the Gartner's Copyrights and Quotes policy
  • Handled booking, processing and delivery of Single Reprint Orders by clients

Risk Analyst

Ernst&Young LLP
Delhi NCR, India
06.2017 - 10.2019
  • Led centers in 6 different Indian cities and supervised end to end audit activities across functions- F&,HR and Admin for a leading education sector client.
  • Spearheaded a team of 5 people and reviewed certifications for 2000+ students for scholarship testing for the same client.
  • Prepared and presented audit reports to senior management of a leading education sector client
  • Implemented the use of Alteryx for repeated test steps performed on a monthly client audit thereby achieving approximately 20% time efficiency per audit cycle
  • Analyzed a client's pan India payroll worth USD 7.4 Mn to validate the accuracy of payments
  • Reviewed ad-revenue(worth USD 1 Mn) and distribution cost (worth USD 7.4 Mn) of a leading news broadcasting channel in India

Education

Master of Data Science - Expected (June 2023)

University of British Columbia
Vancouver, BC
09.2022 - Current

Post Graduate Certificate - Data Science And Business Analytics

Great Lakes Institute of Management
Gurgaon,India
Sep.2019 - Apr.2021

Bachelor of Arts (Honors) Economics -

SGTB Khalsa College , Delhi University
Delhi, India
07.2014 - 05.2017

Software

Python (Pandas, NumPy, Selenium, PyTorch, matplotlib, AltAir)

R (dplyr, tidyr, ggplot)

SQL (PostgreSql, TeradataSql, MySql)

Alteryx

Spotfire,Tableau,PowerBi

Soft SKills

  • Team Management
  • Presentation and Communication
  • Critical Thinking and Problem Solving
  • Adpatability

Timeline

Master of Data Science - Expected (June 2023)

University of British Columbia
09.2022 - Current

Senior Data Analyst – Internal Audit

United Airlines
02.2020 - 06.2022

Service Operations Associate

Gartner
10.2019 - 01.2020

Post Graduate Certificate - Data Science And Business Analytics

Great Lakes Institute of Management
Sep.2019 - Apr.2021

Risk Analyst

Ernst&Young LLP
06.2017 - 10.2019

Bachelor of Arts (Honors) Economics -

SGTB Khalsa College , Delhi University
07.2014 - 05.2017

Similar Profiles

CREATE PROFILE
Manvir Kohli