Karan Desai
Data Engineer
Melbourne
Summary
A data engineer with broad range of knowledge in data warehouse, developing & maintaining cloud infrastructure, data governance strategies, data modelling, customer experience and business management is keen to advance career in data space and committed to drive valuable impact for the business through growing skillset.
Overview
8
8
years of professional experience
6
6
years of post-secondary education
5
5
Certifications
Work History
Data Engineer
Flybuys (Loyalty Pacific)
2 2021 - Current
- Automated the daily sales report for Coles, facilitating their review of previous weekly trading and comparison of week-on-week percentage increase in sales
- Collaborated on the development of the Flybuys Data Sharing Platform (FDSP), enabling member and member segmentation shares with shareholder partners such as Coles, Target, and Kmart
- Developed and executed a comprehensive data discovery and impact analysis initiative, facilitating smooth transition of data assets from a tactical approach to the newly developed Enterprise Data Warehouse (EDW) for shareholder partners such as Coles, Target, and Kmart
- Uplifted the Talend Data Catalog tool to mitigate security risks and provide analysts with a seamless experience while utilizing the tool
- Led the onboarding of data assets from the Enterprise Data Warehouse (EDW) to the Talend Data Catalog for Target, Bunnings, Officeworks, and Coles
- Facilitated migration of dbt Core to dbt Cloud to improving overall tool performance and UX
- Involved in data flow analysis, data mapping, data modelling, and physical database design for onboarding partner inbound data into the Enterprise Data Warehouse (EDW)
- Architected initial phase of data archiving strategy, to optimise data management processes
- Played a key role in conducting a proof of concept (POC) for the migration of Control-M to Airflow.
Customer Service Representative
Coles Express
12.2018 - 05.2021
- Provide face-to-face customer service at registers
- Promote and explain product offers to customers
- Resolve customer queries related to product information, purchase and returns.
Intern Data Analyst and Visualisation
Ron Crouch Transport
03.2020 - 06.2020
- Performed requirement analysis to ensure all the needs of stakeholders are incorporated
- Developed dashboards in Power BI to compare different KPI’s of the company operations
- Compared key KPI’s of the company such as revenue per business unit, revenue per customer, revenue per route and facility, average monthly transaction per customer
- Performed data cleaning operations such as outlier removal, to make sure final reports are efficient and error free
- Created reports on findings derived from the dashboards and present it to stakeholders
- Gathered data required for the KPI analysis from the company’s data base using R and Power BI.
Business Development Executive
Ultima Chemicals
02.2018 - 07.2018
- Led meetings with top management of key clients, to evaluate business development opportunities
- Responsible for leading project teams, project coordination and work direction of the staff
- Assisted senior manager with planning and designing work portfolio for field sales executives
- Maintained strong relationship with clients using SAP based CRM system – Smarty CRM
- Resolved client queries related to product information, product purchase, delivery and after sales support
- Used email marketing and telemarketing methods to generate leads and convert prospective clients to regular customers.
Proprietor
Ecommerce Business Store
07.2016 - 05.2018
- Managed the digital store solely including but not limited to updating collection, responding to customer queries, explaining product specifications, receiving payments, and providing shipping details
- Updated social media platforms for product collections on regular basis
- Conducted market survey for production collection, pricing, and customer service.
Education
Master of Business Analytics -
07.2018 - 05.2020
- Attained score of 75% and above in 44% of subjects out of total 16 subjects.
- Managed a SCRUM based Capstone project which involved scraping tweets from twitter to conduct sentiment analysis, creating topic themes and analyse time-based patterns using Natural Language Processing (NLP) to evaluate the impact of social media activity on brand image of a company.
Bachelor of Engineering in Automobile -
05.2013 - 05.2017
Skills
ETL development
Data Pipeline Design
Data Modeling
Data Warehousing
Data Migration
SQL Expertise
Machine Learning
Data Security
NoSQL Databases
Metadata Management
Data Quality Assurance
Data Governance
Data curating
SQL and Databases
SQL Programming
Data Analysis
RDBMS
Database Design
Database Administration
Relational databases
Business Intelligence
Backup and recovery
Teamwork and Collaboration
Certification
dbt (Data Build Tool) Cloud, Udemy, 06/2023
Skillset
SQL, Python, R, Snowflake, AWS Cloud, Airflow, Oracle Database, Power BI, Microsoft Azure Cloud, dbt Core & Cloud, Tableau, Natural Language Processing, GitHub & GitLab, MS Advanced Excel, Microsoft Azure Machine Learning, Jira, Talend Studio, SQL database modeler, Cloud Computing, Data Warehousing, Data Modelling, ELT/ETL, Data Architecture, Machine Learning, Data Governance, Predictive Modelling and Text Mining, Data Story Telling, Business Intelligence, Market Basket Analysis, Sentiment Analysis, CI/CD Pipelines, Segmentation and Clustering, Agile Principles
References
Available upon request.
Timeline
Intern Data Analyst and Visualisation - Ron Crouch Transport
03.2020 - 06.2020
Customer Service Representative - Coles Express
12.2018 - 05.2021
La Trobe University - Master of Business Analytics,
07.2018 - 05.2020
Business Development Executive - Ultima Chemicals
02.2018 - 07.2018
Proprietor - Ecommerce Business Store
07.2016 - 05.2018
Mumbai University - Bachelor of Engineering in Automobile,
05.2013 - 05.2017
Data Engineer - Flybuys (Loyalty Pacific)
2 2021 - Current