Summary
Overview
Work History
Education
Skills
Websites
Projects
Timeline
Generic

Dhruv Patel

Roanoke,United States

Summary

Experienced Data Analyst with expertise in Agile/SDLC processes, Python, SQL, and data visualization tools. Proven track record in developing web applications, generating graphical reports, and conducting exploratory data analysis. Skilled in database-level tasks, including writing triggers and stored procedures in MySQL. Proficient in Power BI and Tableau for creating insightful dashboards. Adept at business process modeling, data validation, and integrity testing. Strong problem-solving and presentation skills with a focus on delivering high-quality data insights.

Overview

6
6
years of professional experience

Work History

Data Analyst

Aptech Staffing
08.2022 - Current
  • Involve in complete Agile/SDLC Requirement Analysis, Development, System, and Integration Testing
  • Develop an inventory analysis web application in Python to generate graphical reports
  • Performing exploratory data analysis to find insight like difference efficiency among different devices using ggplot2 in R
  • Perform slicing and dicing of data using SQL and Excel for data cleaning and data preparation
  • Create and publish multiple dashboards and reports using the Tableau server
  • Involving writing, testing, and implementing triggers, stored procedures, and functions at the Database level using MySQL
  • Working with Data Cleaning, Wrangling, Modelling, Critical Thinking, Problem-Solving, and Presentation Skills.

Business Analyst

Prop Technology
07.2018 - 12.2020
  • Developed business process models in Waterfall to document existing and future business processes
  • Wrote SQL queries to perform Data Validation and Data Integrity testing to ensure data quality
  • Utilized Power BI to create various analytical dashboards that help business users to get a quick insight into the data
  • Used and maintained a database in MS SQL Server to extract the data inputs from internal systems
  • Participated in all phases of data mining data collection, data cleaning, developing models, validation, and visualization.

Education

Master of Science in Computer Science -

University of Maryland, Baltimore County
Baltimore, Maryland
12.2022

Bachelor of Engineering in Computer Engineering -

Gujarat Technological University
Ahmedabad, Gujarat
07.2020

Skills

    Languages: Python, R, SQL, SAS, Pl/SQL Java, NET, GoLang, C, C, HTML, CSS, JavaScript, JQuery, PHP, Angular, Reactjs

    Packages: NumPy, Pandas, Matplotlib, SciPy, ggplot2

    Visualization and Other Tools: Tableau, Power BI, Microsoft Excel, Jira, Salesforce

    Database: MySQL, SQL Server, Oracle, MS Access, Teradata

    Tools, Framework, and Libraries: OpenCV, MongoDB, Pandas, NumPy, Keras, SciKit-Learn, TensorFlow, Matplotlib, AWS, Google Cloud Platform, NodeJS, Express, Hadoop, Linux, Django

Projects

Satellite Image Segmentation, Python, TensorFlow, Keras, OpenCV, matplotlib, 01/2022, 05/2022, 

Implemented Image Segmentation using customized DeepCNN and evaluated along with UNet and ResNet for Satellite View Images. Reduced trainable parameters from 43.56 Million to 1.41 Million, also reduced the memory utilization and training time from 8 hours to 35 minutes. 

Counting Vehicles in Lane, Python, OpenCV, Numpy, 01/2021, 05/2021, 

Developed a detection program to count vehicles traveling in a single-lane video stream. Tackled the vehicle shadow overlapping issue with an accuracy of 92.22% on a cloudy day, 84.21% on Sunny days, and 89.79% at Night. 

Encrypted Distributed File System, Python, socket, 01/2022, 05/2022, 

Developed a Distributed File System (DFS) attributed with three server nodes, one master node, one scheduler, and multiple Clients. Contributed to implementing the following: DFS architecture, client authentication, input validation, data encryption, event logging, malicious activity detection, individual file accessibility, and scheduler for maintaining the functionality of the system.

Timeline

Data Analyst

Aptech Staffing
08.2022 - Current

Business Analyst

Prop Technology
07.2018 - 12.2020

Master of Science in Computer Science -

University of Maryland, Baltimore County

Bachelor of Engineering in Computer Engineering -

Gujarat Technological University
Dhruv Patel