Summary
Overview
Work History
Education
Skills
Websites
Awards
Certification
Timeline
Generic

Mitali Patel

North York,ON

Summary

Diligent and results-oriented professional with 3 years of experience in database management, client service, and data analysis. Proficient in utilizing Microsoft Office Suite, SQL, Python, and Tableau to streamline operations and drive actionable insights. Skilled in implementing automation techniques and optimizing processes to enhance efficiency. Demonstrated ability to manage complex projects and adapt to new technologies, with a strong commitment to continuous learning and professional development

Overview

2
2
years of professional experience
1
1
Certification

Work History

Data Coordinator

United Trimen
05.2023 - Current
  • Manage all aspects of new item setup, sourcing, and item maintenance, ensuring accuracy and efficiency in operations.
  • Conduct detailed freight analysis to optimize inbound and outbound logistics, utilizing mathematical models and data analysis techniques to determine cost-effective transportation solutions.
  • Implemented automated data extraction techniques, resulting in an 88% reduction in copy-over time from Genisys to Excel spreadsheets and Google Sheets.
  • Proficient in extracting source image links and HTML data from internal company websites using SQL and Python.
  • Utilize SAP, specifically the Master Data Governance (MDG) module, to maintain data integrity and consistency across systems within the Gordon Food Services network.
  • Ensure compliance with company standards and policies for data management and governance, leveraging MDG workflows and approval processes.
  • Expertise in validating and verifying data attributes, analyzing mass data to investigate anomalies, and maintaining consistency across data sources.
  • Actively follow Agile methodology and offer valuable support to the manager in diverse analytical and inventory endeavors.

Data Analyst

Fillware Technologies Inc.
11.2021 - 05.2023
  • Collected, interpreted, and documented user requirements for database design and development, ensuring alignment with business objectives.
  • Conducted comprehensive data analysis tasks including profiling, validating, and cleansing data using Python, pandas, NumPy, and matplotlib for advanced data manipulation and visualization.
  • Developed Tableau dashboards and PowerPoint presentations, effectively communicating complex data insights to stakeholders.
  • Identified process improvement opportunities and proposed system modifications to enhance efficiency and accuracy of data reporting.
  • Collaborated with cross-functional teams to define new data collection and analysis processes, ensuring alignment with organizational goals.
  • Utilized SQL queries and scripting to troubleshoot reporting database environment and reports, ensuring data accuracy and integrity.
  • Played a key role in software conversion projects, analyzing data and adjusting program code to facilitate smooth transitions between systems.
  • Actively participated in team meetings and provided valuable input to drive continuous improvement initiatives within the organization.

Education

Ontario College Graduate Certificate - Web Design and Development

Conestoga College
Kitchener, ON
05.2021

Bachelor of Engineering - Computer Engineering

Gujarat Technological University
Gujarat, India
01.2019

Skills

  • Database Management: SQL, MongoDB, MySQL, MS SQL
  • Programming Languages: Python, Java, JavaScript, HTML5, CSS3, C#, C/C
  • Data Analysis Tools: Tableau, Microsoft Excel (including advanced functions and macros), Google Sheets
  • Project Management and Version Control: Agile/Scrum, Git, GitHub
  • Web Development Frameworks: Angular, Nodejs, Bootstrap
  • Other Tools/Software: Microsoft Office Suite (Word, PowerPoint, Outlook), JIRA, Visual Studio Code, Adobe Photoshop, Figma

Awards

  • Graduation with Distinction-Conestoga College, May 2021
    Outstanding performance in Web Design and Development, achieving an average of 89% across all courses without any failed subjects.
  • B.E. - Computer Engineering-Gujarat Technological University, June 2019
    Awarded first-class honors and distinction for academic excellence in Bachelor of Engineering in Computer Engineering.
  • Dean’s Honor List-Group of three, February 2019
    Recognized for exceptional achievement in the development of "FutureCamp" Android application, securing 1st place at the Gujarat Technological University project fair.
  • Smart India Hackathon, December 2018
    Issued for active participation in the Smart India Hackathon, showcasing collaborative problem-solving and innovation skills.

Certification

  • CPR / AED / First-Aid (Adult / Child / Infant / Choking) AED / Injury & Universal PrecautionsNational CPR Foundation, Issued Apr 2023, Expires Apr 2025
  • C# Essential Training: 1 Syntax and Object Oriented Programming LinkedIn, Issued Feb 2022
  • Advanced SQL for Query Tuning and Performance Optimization LinkedIn, Issued Dec 2021

Timeline

Data Coordinator

United Trimen
05.2023 - Current

Data Analyst

Fillware Technologies Inc.
11.2021 - 05.2023

Ontario College Graduate Certificate - Web Design and Development

Conestoga College

Bachelor of Engineering - Computer Engineering

Gujarat Technological University
Mitali Patel