Summary
Overview
Work History
Education
Skills
Websites
Certification
Languages
MASTER’S ACADEMIC EXPERIENCE
Timeline
Generic

Gurleen Kohli

Dallas

Summary

Experienced Data Analyst with a proven track record in fulfilling critical business requirements, complex real-time data analysis, and successful cross-team collaboration. Demonstrated expertise in data pipeline migrations, developing reports and visualizations, and improving existing systems. Proficient in implementing scalable solutions and providing mentorship.

Overview

11
11
years of professional experience
1
1
Certification

Work History

Data Analyst

Lantern
01.2024 - 01.2025
  • Designed and implemented data tests using DBT to ensure robust data transformation and validation across pipelines.
  • Developed a data quality framework using SODA, enabling automated monitoring and anomaly detection across critical datasets.
  • Led the design and construction of a centralized data warehouse in Databricks, optimizing data storage and enabling scalable analytics.
  • Built semantic layers tailored to specific business domains, facilitating self-service analytics and improving data accessibility for stakeholders across departments.
  • Stood up the warehouse to make analysts data enabled by building golden reusaable models

Senior Data Analyst

Accenture
06.2021 - 06.2022
  • Led a high-performing team in successfully migrating 2500 complex financial BI reports from Discoverer to Oracle BI, resulting in improved analytical related solutions and resolution of technical problems.
  • Improved data warehouse modeling increased report performance by 70% and accelerated data migration efforts.
  • Collaborated seamlessly with cross-functional teams and provided technical guidance, including functional and Change management, to provide invaluable support to deliver analysis on Oracle Business Intelligence systems.
  • Utilized JIRA to coordinate and track development tasks, ensuring on-time project delivery and effective communication among cross-functional teams.
  • Developed a robust reporting process, using Agile development methodologies, that empowered over 200 customers with meaningful insights into the general ledger data.
  • Engineered comprehensive user acceptance test scripts with 100% accuracy rate for BI reports and minimal margin of error.

Senior Oracle Developer

HCL
02.2019 - 06.2021
  • Spearheaded the development of data-warehousing projects, orchestrating the extraction of data from standardized data sets to drive highly effective business applications with 100% fulfillment of client’s business requirements.
  • Leveraged advanced SQL scripting, Oracle PL/SQL, and various data tools like Informatica to streamline ETL processes and construct powerful business processes that execute data handling with exceptional efficiency and accuracy.
  • Designed data strategy for migration project of a retail project worth 1.1 million, skillfully converting PostgreSQL code to automated analytics ETL pipelines in snowflake, leading to enhanced data management and efficiency.
  • Collaborated closely with DBAs, BI Developers, Data scientist teams, and cross-functional teams to enhance overall system performance and data quality, achieving outstanding results through Agile methodologies.

Associate Data Analyst

Infosys
02.2014 - 02.2019
  • Conducted a comprehensive analysis of the client’s IT infrastructure, supported change management, resulting in a 30% reduction in IT costs and a 60% increase in system performance.
  • Engaged in the evaluation of business requisites and examination of data origins from Excel and multiple Data Sources to facilitate the creation, testing, and deployment of reporting and analysis initiatives in Power BI. This contributed to a 15% increase in annual sales based on improved customer demands.

Education

Master of Science - Business Analytics

University of Arizona
Tucson, AZ
12.2023

Bachelor of Science - Electronic and Communication

Chitkara University
HP, India
05.2013

Skills

  • Tools: Tableau/Power BI, OBIEE, Oracle SQL, Apache Hadoop, GIT, Jira, SharePoint, Confluence, PowerPoint, SDLC, Waterfall
  • Languages: Python (NumPy, Pandas, Matplotlib, Seaborn, Scikit-learn), R, MATLAB, C, JAVA, R Studio, SQL
  • Big Data & Machine Learning Algorithms: Linear Regression, Logistic Regression, Clustering, Tree Models - Decision Tree & Random Forest (CART), Time Series Analysis & Forecasting, KNN, SVM, K-Means Clustering, Statistics, Hypothesis Testing, A/B testing, ETL (Extract Transform Load), EDA (Exploratory Data Analysis), Deep Learning, NLP

Certification

  • Insta Award for good performance Mondelez International
  • Insta Award for good performance BioMarin Pharmaceutical
  • Best Speaker Award Toastmasters International
  • Most dedicated volunteer Arpan NGO

Languages

English
Full Professional
Hindi
Native or Bilingual

MASTER’S ACADEMIC EXPERIENCE

  • Graduate Assistant | University of Arizona and Institutional Research: OBI, AWS, JIRA
  • Led data cleansing efforts, resulting in a significant improvement in data quality and accuracy, thereby enhancing decision-making processes and overall organizational efficiency.
  • Designed and developed a custom AWS Lambda function, with the help of CloudWatch logs, for automating the startup process of an OBIEE (Oracle Business Intelligence Enterprise Edition) server, hosted on Amazon EC2. Predictive Modeling for a Bank
  • Developed a predictive model, using machine learning techniques such as Logistic Regression and Naive Bayes, in R with accuracy of 85% to identify potential customers for personal loans, resulting in improved targeting and increased revenue.
  • Conducted exploratory analysis to identify key factors influencing customer decisions regarding personal loans, enabling more effective marketing strategies. Instacart data analysis
  • Delivered a data warehouse model for a retail project, using SSIS, with a comprehensive and well-structured star schema
  • Developed reports with meaningful insights, using Power BI, to analyze data across geographical locations and over multiple attributes like time, stores and products.

Timeline

Data Analyst

Lantern
01.2024 - 01.2025

Senior Data Analyst

Accenture
06.2021 - 06.2022

Senior Oracle Developer

HCL
02.2019 - 06.2021

Associate Data Analyst

Infosys
02.2014 - 02.2019

Bachelor of Science - Electronic and Communication

Chitkara University

Master of Science - Business Analytics

University of Arizona