Data Professional producing insights through SQL, Python, Power BI and Tableau
-
Ai And Database AnalystExplorer Research Oct 2022 - Aug 2024Toronto, Ontario, Canada- Led the development of a machine learning pipeline in Python to optimize package design and improve operational efficiency through root cause analysis- Created a Flask-based full stack web application for TURF analysis leveraging Flask's SQlite database for data management- Automated manual Excel processes by building Power BI dashboards, which transformed raw data into actionable insights- Built a centralized database using Python and SQL scripts to automate data collection from various sources, enhancing data management and process examination - Collaborated across teams to address ad hoc requests, utilizing data-driven analysis to deliver timely solutions and support business objectives -
Research Assistant - Data ScienceDurham College Mar 2022 - Oct 2022Oshawa, Ontario, Canada- Developed ETL scripts in Python with Beautiful Soup to web scrape and ensure data accuracy from various websites- Created a Tableau dashboard to visualize data reports, enhancing decision-making and reporting capabilities for the client- Conducted data wrangling and exploratory data analysis using pandas, feature engineering, and trained a predictive model with machine learning techniques, delivering analytical insights and supporting continuous improvement efforts through detailed analysis -
Data ConsultantEyecan Apr 2022 - Jul 2022- Conducted extensive research on YOLO Algorithm and its various advancements as a potential tool- Created a customized dataset of currency notes, and worked on its data preparation, data augmentation, and pre- processing for model usability- Developed currency detection model to identify banknotes in real-time using supervised classification techniques -
Data AnalystThe Stratagem Group Jan 2021 - Apr 2021- Researched and collected film industry data and automated data extraction using a web scraping script in python- Cleaned and prepared the data for analysis to create a report for displaying metrics in Power BI- Started the work on a job portal on Azure for posting and searching career opportunities in the film industry and forwarded it to the next team for subsequent steps- Documented tasks and processes for knowledge transfer to future teams and the client, detailing the framework for project planning -
Data EngineerTantrabyte.Pvt.Ltd Jan 2019 - Dec 2020Gurugram, India- Designed and implemented data pipeline architectures for multi-vendor datasets using AWS services- Extracted, cleaned, and filtered data from raw sources to load into the data warehouse- Automated report generation using data modeling in Excel/Google Sheets and Python- Used Airflow for orchestrating workflows and managing ETL processes.- Built, published, and scheduled interactive dashboards in Tableau, identifying patterns and trends in datasets- Utilized AWS Athena to analyze S3 files prior to loading them into the data warehouse- Wrote Pyspark scripts to fetch data from API calls and store it in dataframes- Strategically analyzed and communicated data to help stakeholders make data-driven business decisions- Optimized database performance, tuned queries, supported database objects, and executed stored procedures for production migration
Abhishek Joshi Education Details
-
Artificial Intelligence -
Big Data Analytics -
Information Technology
Frequently Asked Questions about Abhishek Joshi
What is Abhishek Joshi's role at the current company?
Abhishek Joshi's current role is Data Professional - SQL | Python | Power BI | Tableau | AWS | Pyspark | Apache Airflow | Databricks | ETL | Machine Learning.
What schools did Abhishek Joshi attend?
Abhishek Joshi attended Durham College, Georgian College, Dr. A.p.j. Abdul Kalam Technical University.
Not the Abhishek Joshi you were looking for?
-
Abhishek JOSHI
Head Of Pax@Airports Yul | It Strategy & Innovation Leader | Enhancing Cx With Agile AutomationMontreal, Qc -
-
Abhishek Joshi
Station Manager At Intelcom | Dragonfly | Expertise In Operational Excellence, P&L Management, And Team Leadership In Supply Chain Logistics And Transportation.Nanaimo, Bc -
Abhishek Joshi
Technical Operations Manager | Aws & Serverless Expert | Software Development Leader Driving Innovation & EfficiencyMississauga, On1virtuallogistics.ca
Free Chrome Extension
Find emails, phones & company data instantly
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial