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, AZ12.2023
Bachelor of Science - Electronic and Communication
Chitkara University
HP, India05.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