Keyvan Salehi
Auckland,New Zealand
Summary
Versatile Data Analyst with a comprehensive background in analytics, proficient in SQL, Python, Excel, Power BI. Demonstrated expertise in data modeling, forecasting, and statistical analysis, complemented by practical experience in warehouse data management and financial reconciliation (MYOB Exo, Xero). Adept at leveraging machine learning techniques to uncover insights and drive business decisions. Seeking to apply my analytical acumen and problem-solving skills in a challenging environment, focusing on data-driven decision-making and strategic innovation. Committed to continuous learning and staying abreast of the latest trends in data analysis and business intelligence.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Digital Data Analyst
My Food Bag
Parnel , Auckland
03.2024 - Current
- Analyzed large datasets to identify trends, patterns and correlations for business insights.
- Created predictive models to forecast customer behavior.
- Provided data-driven solutions to support decision making.
- Gathered requirements from stakeholders to design data models and reports.
- Leveraged SQL queries to extract, transform and load data into databases.
- Designed automated ETL processes for efficient data extraction, transformation and loading in order to improve accuracy and reliability of reporting systems.
- Implemented machine learning algorithms like Linear Regression, Logistic Regression and Random Forest for classification and prediction purposes.
- Collaborated with stakeholders across the organization to understand their needs from a data perspective.
- Automated manual reporting processes by developing scripts in Python or R.
- Defined KPIs based on collected data sources.
- Built visualizations that enabled users to quickly interpret results from complex analyses.
- Leveraged software to compile and model data.
- Developed dashboards with BI to monitor key performance indicators.
Warehouse Recon Operative
Sealegs International Ltd
06.2023 - Current
- Spearheaded warehouse reconciliation processes, leveraging analytical skills to ensure high levels of data accuracy and inventory management efficiency
- Enhanced financial operations by processing invoices and performing financial reconciliation, utilizing advanced tools including MYOB Exo, Xero, PostgreSQL, and Excel
- Played a key role in operational streamlining, applying Python programming to improve data integrity and increase operational efficiency
- Fostered collaborative relationships across departments (Sales, R&D, DBA, FAB, Services) to ensure accuracy in invoicing and effective goods delivery
- Acted as the primary contact for Creditors, managing invoice inquiries and ensuring accuracy in financial documentation
- Developed a Python-based tracking application to accurately monitor inwards goods, significantly improving inventory tracking processes
Mathematics Researcher
Massey University
01.2021 - 02.2024
- Managed Amazon RDS (Relational Database Service), ensuring efficient database solutions for data-intensive research
- Conducted advanced SQL querying and database operations, optimizing data retrieval and manipulation
- Implemented and queried AWS DynamoDB, enhancing data storage and retrieval capabilities
- Led data migration to AWS using the Database Migration Service (DMS), ensuring secure and efficient data transfer
- Maintained stringent data security protocols and access management using AWS Security and IAM
- Integrated various AWS services with SQL databases, demonstrating expertise in cloud-based data management
- Specialized in data preprocessing and model objective function optimization for accurate machine learning models
- Developed machine learning models using Regression, Logistic Regression, and TensorFlow, contributing to data-driven insights
- Proficient in key machine learning libraries (Sklearn, TensorFlow, Stats, SciPy) for complex data analysis and model development
- Implemented Deep Learning (Neural Networks) in business case studies, applying theoretical models in practical applications
- Conducted data analysis using Pandas, NumPy, SciPy, Stats, and Math, extracting and interpreting complex data sets
- Created visualizations using Matplotlib and Seaborn to represent data findings effectively
- Performed web scraping using Beautiful Soup and Scrapy to collect and analyse web data
- Applied predictive modelling techniques using regression for forecasting and trend analysis
- Conducted hypothesis testing, including Z-score and T-student tests, to validate data models and ensure statistical significance
Product Service & Warehouse Assistance
Good Health Products New Zealand Ltd
02.2023 - 07.2023
- Conducted regular inventory checks, ensuring accurate stock levels through meticulous data entry and verification, identifying and resolving discrepancies
- Performed quality control checks on incoming and outgoing products, maintaining high standards through detailed data recording and analysis
- Efficiently operated warehouse equipment such as forklifts and pallet jacks, contributing to the smooth movement and management of stock
- Collaborated with the warehouse team to optimize product storage and streamline order fulfillment processes, with a focus on accurate data entry and management to support operational efficiency
Student
DataCamp
01.2022 - 01.2023
- Proficient in database design and normalization
- Skilled in writing complex SQL queries for data manipulation and retrieval
- Experienced in using aggregate functions and grouping for data analysis
- Utilized subqueries and common table expressions for advanced data querying
- Developed stored procedures and functions for efficient database operations
- Managed data import/export tasks, ensuring smooth data exchange between systems
- Developed DAX formulas for complex data calculations and analytics
- Utilized drill-down and drill-through for detailed data exploration
- Implemented data filtering techniques for refined analysis
- Created dynamic data visualizations to communicate insights
- Used Power Query for advanced data transformation and preparation
- Designed interactive reports with slicers for user-friendly data navigation
- Engaged in data modeling and created measures and calculated columns for data analytics
- Mastered advanced formulas and functions
- Utilized PivotTables and PivotChart for data analysis and visualization
- Implemented data validation and conditional formatting for data quality
- Employed XLOOKUP functions for efficient data referencing
- Automated tasks with Macros and VBA scripting for process efficiency
- Specialized in data analysis and visualization and financial modeling
Education
Doctor of Philosophy - PhD - Mathematics
Massey University
02.2023
Master's degree - Mathematics
Amirkabir University of Technology - Tehran Polytechnic
03.2014
Bachelor's degree - Mathematics
University of Tabriz
05.2010
Skills
- Decision-Making
- Flexibility Training
- Critical Thinking
- Teamwork
- Easily Adaptable
Certification
- Certified Big Data Professional - Udemy
- Python for Business Analyst - DataCamp
- Xero Advisor Certified - Udemy
- Certified Data Scientist - Udemy
- Git & Git hub -Udemy
- Certified Data Scientist - World Quantity University
- SQL - W3Schools.com
- Analyzing and Visualizing Data with Microsoft Power BI - DataCamp
- Cert Prep: Certified Analytics Professional (CAP) - LinkedIn
- TensorFlow Deep learning - ZTM
- Machine Learning - ZTM
- Docker& Docker Hub -youtube founder
- Flask -youtube founder
- Streamlit - ZTM
Honorsandawards
- PhD Scholarship, Marsden Grant, 01/01/20
- Silver Medal In Mathematics, Iranian Mathematical Society, 11/01/09
Languages
kurdish
Native/ Bilingual
Persian
Native/ Bilingual
Arabic
Elementary
Turkish
Elementary
English
Full Professional
Timeline
Digital Data Analyst
My Food Bag
03.2024 - Current
Warehouse Recon Operative
Sealegs International Ltd
06.2023 - Current
Product Service & Warehouse Assistance
Good Health Products New Zealand Ltd
02.2023 - 07.2023
Student
DataCamp
01.2022 - 01.2023
Mathematics Researcher
Massey University
01.2021 - 02.2024
Doctor of Philosophy - PhD - Mathematics
Massey University
Master's degree - Mathematics
Amirkabir University of Technology - Tehran Polytechnic
Bachelor's degree - Mathematics
University of Tabriz
Similar Profiles
Grace AlanoGrace Alano
PICK PACKER at MY FOOD BAGPICK PACKER at MY FOOD BAG
Saviuni MAAMALOASaviuni MAAMALOA
My Food Bag at My Food BagMy Food Bag at My Food Bag
Krisalyn SipeniKrisalyn Sipeni
Picker Packer at My Food BagPicker Packer at My Food Bag
Aaron SomersetAaron Somerset
Business Development Manager at StarshipitBusiness Development Manager at Starshipit
Georgina Awubawuni AdaatuahGeorgina Awubawuni Adaatuah
C.A.P. Clinical Placement at St. Margaret Hospital/Care HomeC.A.P. Clinical Placement at St. Margaret Hospital/Care Home