Ayush Patel
Oshawa,ON
Summary
Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data. Seasoned collaborator experienced in meeting needs, improving processes and exceeding requirements in team environments. Diligent worker with strong communication and task prioritization skills.
Overview
4
4
years of professional experience
Work History
Data Analyst
Olajide Tech
08.2023 - Current
- Worked closely with the CMO/Co-Founder and the content creation team to design an advanced course recommendation system that provided users with personalized course suggestions
- This initiative led to a 19% increase in students' screen time and a 27% improvement in their academic performance
- Executed comprehensive feature engineering on the dataset by analyzing data, and extracting insights that were incorporated into the recommendation system
- Utilized R and Python for data cleaning, manipulation, and visualization
- Built the recommendation model by gathering data from a MongoDB database and mixed panel events.
- Produced monthly reports using advanced Excel spreadsheet functions.
- Collaborated with cross-functional teams to ensure data integrity and accuracy, resulting in better-informed decisions.
Business Intelligence Analyst
BeamByte Solution Pvt Ltd
05.2020 - 06.2023
- Led a dynamic team of 3-5 data analysts, collaborating with the CFO & business stakeholders to elevate sales and performance tracking across E-Commerce marketplaces, Mobile applications, and retail stores
- Spearheaded data integrity initiatives, bolstering the accuracy and reliability of the data-driven insights provided, by creating extensive SQL queries and generating data warehouse
- Significantly improved data refresh/update cadence to a 15-minute cycle by creating and maintaining a robust data pipeline, seamlessly integrating data from diverse sources such as SQL, SAP, POS, Warehouse Management
- Systems, and Increff
- Leveraged Microsoft PowerBI to generate multiple reports and KPIs that not only aided in performance evaluation but also facilitated the identification of market gaps, identifying categories that provided potential market opportunities
- Used JIRA to keep track of the projects and maintained the project documentation using Confluence and performing regular scrums to manage projects following Agile methodology
- Performed data analysis on request and created ad hoc reports in support of various business processes
- Collaborated closely with the team, conducted UAT, and successfully migrated on-premises data to a cloud-based database ensuring a smooth transition that had no adverse impact on the existing process
Education
Master of Science - Information Technology Business Analyst
Conestoga College Institute of Technology And Advanced Learning
Kitchener, ON08.2023
Bachelor of Science - Bachelor of Computer Applications
Dharmsingh Desai University
Gujarat IN07.2020
Skills
- Data Visualization: Tableau, PowerBI
- Microsoft SQL Server
- Business Intelligence
- MySQL
- Agile Methodology
- Project Management
- Python
- Tableau
- Microsoft Azure
- Cloud Server
- Excel
- Jira
Timeline
Data Analyst
Olajide Tech
08.2023 - Current
Business Intelligence Analyst
BeamByte Solution Pvt Ltd
05.2020 - 06.2023
Master of Science - Information Technology Business Analyst
Conestoga College Institute of Technology And Advanced Learning
Bachelor of Science - Bachelor of Computer Applications
Dharmsingh Desai University
Similar Profiles
Olajide GastonOlajide Gaston
CDL A OTR Driver at Olajide Logistics LlcCDL A OTR Driver at Olajide Logistics Llc
ANUROOP T RANUROOP T R
Sr. Operations Coordinator at Crimen Tech Pvt Ltd (Trydan Tech)Sr. Operations Coordinator at Crimen Tech Pvt Ltd (Trydan Tech)
APPIREDDIGARI SUNILAPPIREDDIGARI SUNIL
Sales Executive Manager at Ofbusiness- OFB Tech Private Limited (Noble Tech)Sales Executive Manager at Ofbusiness- OFB Tech Private Limited (Noble Tech)
Hannah McGuireHannah McGuire
Personal Support Worker at Glen Hill Strathaven Lifecare CentrePersonal Support Worker at Glen Hill Strathaven Lifecare Centre
Lillian LandryLillian Landry
Restaurant Hostess/Takeout Attendant at East Side Mario's RestaurantRestaurant Hostess/Takeout Attendant at East Side Mario's Restaurant