Dhruvi Desai
Thousand Oaks,CA
Summary
Aspiring Data Analyst with a solid foundation in data analysis and a strong commitment to advancing expertise in the field. Proficient in SQL for data extraction and analysis, with hands-on experience in data visualization using tools such as Excel and Tableau for report and dashboard creation. Demonstrated practical experience through projects in financial data analysis and employee management systems. Skilled in data integration and ETL processes, with a keen understanding of optimizing data workflows.
Experienced in leveraging AWS services, including EC2, S3, and Lambda, to enhance network performance and operational efficiency. Adept in using enterprise tools such as Git, GitHub, and MS Visual Studio for developing and optimizing SQL queries and scripts. Dedicated to continuous learning and applying advanced data analysis techniques to drive informed decision-making.
Overview
2
2
years of professional experience
1
1
Certification
Work History
Graduate Student Assistant
California Lutheran University
Thousand Oaks, CA
09.2022 - 04.2024
- Maintaining donor files and records, scanned, and filed documents, and prepared deposits to the business office, demonstrating strong organizational and administrative skills
- Managing and querying the fundraising database using SQL, highlighting proficiency in data mining techniques and data management
- Enhanced data accuracy and facilitated informed decision-making through data management
- Played a pivotal role in the development and maintenance of data infrastructure, focusing on leveraging SQL for efficient data management and analysis
- Assisted in the integration of diverse data sources into centralized databases, employing SQL-based ETL (Extract, Transform, Load) processes and techniques
- Conducted root cause analysis of business problems, recommended solution alternatives, and developed reports to monitor key metrics and outcomes
- Utilized reporting tools, including Tableau, to actively oversee and report on crucial Key Performance Indicators (KPIs)
- Employed data visualization techniques to create comprehensive reports, enabling clear and effective communication of order accuracy and delivery timeline results.
Education
MS IN INFORMATION TECHNOLOGY -
California Lutheran University
Thousand Oaks, CA05.2024
Bachelor of Science - Computer Engineering
S.S. Agrawal Institute of Technology & Engineering
Navsari,INSkills
- Python
- SQL
- HTML
- CSS
- C/C
- MySQL
- Oracle
- T-SQL
- PL/SQL
- MongoDB
- R
- Statistical methods
- Amazon Web Services (EC2, ECS, S3, EKS, Lambda)
- Tableau
- Data Mining
- Microsoft Suite
- Project Management
- Git
- GitHub
- MS Visual Studio
- Computer Programming
- Project Coordination
- Data Modeling
- Research ability
Projects
Financial Data Analysis, Completed as part of a data management course, this project involved analyzing financial datasets to identify trends and insights., Utilized SQL for data extraction and transformation, Excel for detailed analysis and reporting, and Tableau for creating interactive visualizations., Provided actionable insights that supported financial planning and decision-making. Employee Management System, Built an employee management system using SQL, including automated salary calculations and payroll reports through stored procedures., Conducted in-depth analysis and developed a well-structured and optimized database., Analyzed a.csv dataset, visualizing findings using Tableau. Processed the dataset, constructing a comprehensive Star Schema, and deploying cubes for enhanced Business Intelligence., Aug-2023
PROJECT:02
IoT Based Smart City Bin (Artificial Intelligence), Designed and implemented an automated waste management system with features such as automatic opening/closing of bins, SMS alerts upon bin capacity, and live data monitoring., IoT, Artificial Intelligence, Python, October 2019 - July 2020 Data Analytics with Python, Analyzed and visualized complex datasets to derive actionable insights and trends., Python, Pandas, Matplotlib, Excel, January 2022 - May 2022
Certification
- Dominant Infotech, Surat, Gujarat, Learnt ”Android App Development” from July 2019-June 2020., Learnt ”Web Development” from May 2018-June 2018.
- Research Paper and Survey Paper on IoT and got published in IJCA -USA
- Data Analytics Certification from Coursera (endorsed by Google)
- Excel for Data Analytics Certification from IBM
- SSP Technology, Internship in Python as a part of academic project work from October 2021-June 2022.
Personal Hobbies
- Travel
- Playing badminton
- Listening to music
- Art
- Calligraphy
English,Hindi,Gujarati
English
Full Professional
Timeline
Graduate Student Assistant
California Lutheran University
09.2022 - 04.2024
MS IN INFORMATION TECHNOLOGY -
California Lutheran University
Bachelor of Science - Computer Engineering
S.S. Agrawal Institute of Technology & Engineering