Hadees Khokhar
Aurora,Il
Summary
Highly analytical and process-oriented Analytics Engineer with in-depth knowledge of data warehouses, data modelling, transformation, analysis, and visualization. Expertise with database management using DBT, SQL, python and PowerBI all used to identify opportunities to grow, meet stakeholder needs and provide actionable insight
Overview
3
3
years of professional experience
Work History
Analytics Engineer
Association Analytics
06.2023 - Current
- Conduct data mining, data modeling, statistical analysis, business intelligence gathering, trending, and benchmarking
- Onboard clients to A2’s data analytics and predictive platform based on DBT/SQL model integrations with their CRM’s
- Curated PowerBI reports to match client’s needs to analyze their consumer demographics, event traction, product sales, platform engagement and key KPI’s such as churn rate & retention rates
- Collaborate with stakeholders to validate reports & create custom reports through workflow consisting of initial data requirements, data source gathering, data validation and modelling with DBT, and creating data products with PowerBI
- Minimized onboarding time and client handoff of portfolio made up of 10 clients within 3 months followed by successful onboarding of 5 new clients withing first 6 months
- Overlook junior Analytic Engineers providing training for database management, data modelling and technical support
Analytics Engineer
SCI Lease Corp
10.2021 - 05.2023
- Process multiple data development & insight requests from various stakeholders across departments to provide data models using DBT and SQL along with actionable data insight based on requested KPI’s with visualizations using TABLEAU
- Conducted A/B testing on variables such as private offers, lease variables such as loan terms and interest rates along with delinquency rates focusing on minimizing lease maturity losses, retain vehicle value using tools SQL & Python with Jupyter Notebook resulting in reducing delinquencies by 13% YOY and improving vehicle value at retainment by 5% YOY
- Validated data integrity, preparing data for analysis and modelling using Python modules including Pandas, Pandas profiling, dbt custom tests, and SQL business logic test ensuring data met standards set by stakeholders including data distributions, ranges of data, business logic and data types
- Manage data development projects working in an agile workflow using JIRA project management software (Atlassian) and managing DBT models within GITTY
- Migrated legacy database infrastructure consisting of over 150 tables to a DBT centralized infrastructure rewriting legacy tables/views into models with best practices, creating ETL scripts from scratch and implementing Airflow as the orchestration tool
- Clients: GMC, Maserati, Lucid
Education
Honours BSc - MATHEMATICS AND STATISTICS, Data Analytics
UNIVERSITY OF TORONTO
Toronto, ON07.2021
Skills
- Data Modelling
- Data analysis
- Jira project management
- Data integrity & auditing
- Data Transformation
- Bash scripting
- Data Visualization
- Version Control
- Git
technical skills
- SQL
- DBT (certified developer)
- Python (pandas, pandas profiling, sqldriver, seaborn, numpy, etc)
- Git (version control)
- Command line scripting
- PowerBI
- Tableau
- Jira
Timeline
Analytics Engineer
Association Analytics
06.2023 - Current
Analytics Engineer
SCI Lease Corp
10.2021 - 05.2023
Honours BSc - MATHEMATICS AND STATISTICS, Data Analytics
UNIVERSITY OF TORONTO
Similar Profiles
Manan ContractorManan Contractor
Volunteer at Business Analytics AssociationVolunteer at Business Analytics Association
ONKAR BELGAMWARONKAR BELGAMWAR
Architect at Fractal Analytics, Formerly Neal AnalyticsArchitect at Fractal Analytics, Formerly Neal Analytics
Ankush CHAUHANAnkush CHAUHAN
Subject Matter Expert at Optima Technology (Payroll on Optima Technology (Payroll on Proziod Analytics) Analytics)Subject Matter Expert at Optima Technology (Payroll on Optima Technology (Payroll on Proziod Analytics) Analytics)