Data Analyst SQL Developer

Dhruvil Hiren Shah

Jersey City, NJ ***** 551-***-**** ***********.****@*****.*** LinkedIn: https://www.linkedin.com/in/dhs658135224/ GitHub: https://github.com/Dhruvil1012

Summary

Detail-oriented Data Analyst and SQL Developer with a Master's in Computer Science, specializing in AI and Machine Learning. Proven experience in managing end-to-end data pipelines, automating ETL processes, and optimizing business workflows to drive operational efficiency and informed decision-making. Proficient in leveraging a diverse technical skill set, including Python (Pandas, NumPy, TensorFlow, PyTorch), SQL, Power BI, and SAP S/4 HANA Cloud, to deliver impactful data solutions. Adept at building predictive models, developing interactive dashboards, and collaborating with cross-functional teams to solve complex business challenges. Recognized for leadership, technical excellence, and the ability to translate data insights into actionable strategies, resulting in cost savings, process improvements, and enhanced system performance. Certified in AWS and passionate about applying advanced analytics and machine learning techniques to real-world problems in dynamic environments.

Technical Skills

Python C++ Java SQL Oracle Spark Pytorch Linear / Logistic Regression Analysis Decision Analysis

Data Processing Machine Learning Clustering Data Mining Supervised and Unsupervised Learning Models Data Mapping Data Cleaning Data Wrangling Data Modelling Data Cleaning Data Visualization MATLAB Microsoft Excel Google Sheets Python (Pandas NumPy Matplotlib Seaborn sci-kit-learn SciPy TensorFlow Keras Bert Open CV2) Decision Tree KNN Regression (Linear Logistic Multiple) Naive Bayes Random Forest SVM Neural Network NLP K-Means Classification Microsoft Azure AWS SAP S/4 HANA Cloud Cloud Computing

Projects

Easify Application

●Led a team 5 in implementing Scrum methodologies and GitHub collaboration for efficient code deployment, utilizing Laravel and React JS for robust development.

●Spearheaded AWS integration for enhanced application scalability and secure image storage, achieving 90% efficiency while ensuring data integrity.

Serverless Computing

●Established a serverless cloud infrastructure on Azure and crafted a serverless application.

●Conducted a comparative analysis between serverless and containerized applications, determining serverless app development efficiency at 90%.

●Number Plate Detection System

●Developed high-accuracy deep learning models to detect number plates on cars via street cameras, achieving a 90% accuracy rate.

Experience

ElevateMe Bootcamp, Columbus, Ohio

Data Analytics & Machine Learning Fellow Trainee September 2024 – Present

●Engaging in 150+ hours of hands-on learning and project work, including active participation in a live project and two optional capstone projects.

●Apply data analytics and machine learning techniques to address real-world problems.

●Utilize advanced tools such as Python, Jupyter Notebooks, Pandas, NumPy, Matplotlib, Seaborn, and Scikit-learn to build and evaluate machine learning models.

●Deploy machine learning models on Microsoft Azure, integrating Azure ML with Azure SQL databases to enable real-time analytics and predictions.

●Perform data preprocessing, feature engineering, and model selection, and evaluate regression, classification, and clustering algorithms to optimize performance.

●Collaborate in a professional team environment using tools like Jira, Confluence, and Slack for project management and effective communication.

Kaye Drug Store Newark, NJ

SQL Developer and ETL Engineer May 2022 - Present

●Led end-to-end Oracle-based software operations to manage procurement and planning for 2,000+ pharmaceutical products, achieving 99.5% inventory accuracy and ensuring full compliance with FDA and GMP standards.

●Designed and implemented SQL-driven ETL pipelines to automate data extraction, transformation, and loading, reducing manual data entry by 40% and increasing data accuracy by 20%.

●Developed automated reporting dashboards using SQL and Power BI, enhancing real-time supply chain visibility and increasing operational efficiency by 25%.

●Optimized procurement workflows and business processes through Oracle system enhancements, resulting in a 15% improvement in system performance and a 10% reduction in software-related downtime.

●Conducted in-depth data analysis of procurement patterns using Python (Pandas, NumPy), identifying cost-saving opportunities and reducing procurement expenses by 12% through strategic vendor selection.

●Reduced supply chain disruptions by 30% through predictive analytics and demand forecasting models, leveraging historical data to maintain consistent product availability.

●Developed and maintained complex SQL queries, stored procedures, and data models to support integration, reporting, and analytics, improving data accessibility for cross-functional teams by 20%.

●Collaborated with finance, supply chain, and IT departments to design data-driven solutions, improving decision-making speed and accuracy by 18% and supporting key business objectives.

●Trained and mentored junior data analysts on SQL best practices, data governance, and ETL processes, leading to a 15% increase in team productivity and fostering a culture of continuous learning.

Prima Automation (India) Pvt. Ltd. Gandhinagar, India

Data Analyst May 2021- August 2021

●Contributed to the successful implementation of an ERP software project, collaborating with the IT department to enhance system functionality across Design, Purchase, Production, and Finance departments, utilizing SAP S/4 HANA Cloud and SQL to achieve a 20% improvement in cross-departmental data integration and operational workflows.

●Coordinated cross-functional efforts with Logistics, Inspection, and Stores teams to streamline workflows, leveraging Python (Pandas, NumPy) and data mapping techniques, resulting in a 15% increase in operational efficiency and reduced project bottlenecks.

●Demonstrated exceptional communication and interpersonal skills by liaising between departments, ensuring project alignment and delivering milestones on time, earning a 98% project satisfaction score from stakeholders and contributing to seamless project execution.

●Earned recognition from supervisors for dedication, work ethic, and adaptability, contributing to on-time project delivery and fostering a collaborative team environment that improved project cohesion by 18%, while utilizing Microsoft Azure for real-time project tracking and task management.

●Led data analysis and system optimization efforts using SQL, Power BI, and data visualization tools to address performance bottlenecks, resulting in a 10% reduction in system downtime and improved ERP response times across departments.

Education

Pace University, Seidenberg School of Computer Science and Information Systems, New York City, NY

Master of Science, Computer Science Concentration: AI & Machine Learning GPA: 3.80 May 2023

Ahmedabad University, Ahmedabad, India

Bachelor of Technology, Information & Communication Technology

Certifications

Data Analytics and Machine Learning Certificate of Completion Sep 2024 – Dec 2024

ElevateMe Bootcamp

150+ hours of hands-on coursework, having completed a Data Analytics project and Machine Learning project using Tableau, Python, Machine Learning and SQL

Contact this candidate