Dhruvi Patel
Data Analyst
***********@*****.*** +1-732-***-**** Woodbridge, New Jersey
SUMMARY
● Data Analyst with 3+ years of experience in data analysis, visualization, and machine learning, with a strong foundation in
Python, R, and SQL to drive data-informed decision-making.
● Familiar with Agile methodologies (SDLC, Scrum) and version control with Git/GitHub, ensuring structured workflows and
collaborative teamwork.
● Proficient in data cleaning, transformation, and wrangling using Pandas and NumPy, ensuring data accuracy and integrity for
reliable analytics.
● Skilled in creating interactive dashboards and compelling visualizations in Tableau, Power BI, and Excel, enabling clear
communication of complex insights to stakeholders.
● Competent in big data processing and ETL operations using PySpark and AWS (S3, RDS, Glue) to efficiently manage and
process large-scale datasets.
● Advanced SQL skills with MySQL, SQL Server, and PostgreSQL, facilitating efficient data querying, analysis, and management
for business intelligence.
● Known for strong critical thinking, problem-solving, and presentation skills, with a proven ability to deliver actionable
insights and support strategic goals.
EXPERIENCE
Principal Financial Group, NJ - USA August 2024 to Present
Data Analyst
● Collaborated within an Agile environment, participating in Scrum meetings to maintain project timelines and enhance workflow
efficiency.
● Analyzed datasets using Python and SQL to uncover actionable insights, improving data accuracy and supporting team projects.
● Interpreted data trends and created dashboards using Power BI for key performance indicators to assist decision-makers.
● Utilized in tandem for efficient data manipulation and analysis NumPy’s powerful array processing supports the numerical
computations needed for large datasets, while Pandas enables structured data handling through data cleaning, transformation,
and aggregation.
● Cleansed and preprocessed data from MySQL and PostgreSQL databases, ensuring high data integrity.
● Synthesized and presented insights to cross-functional teams, using Excel and Python to provide data support for strategic
initiatives.
● Automated weekly data reports, reducing manual reporting time by {25%} and enabling faster data distribution to stakeholders.
● Built and maintained data pipelines using AWS Glue and RDS, automating recurring reports to increase team productivity.
● Supported the marketing team by delivering accurate, timely insights, contributing to an overall improvement in client
engagement strategies.
Principal Financial Group, PA - USA June 2017 to June 2020
Data Analyst
● Extracted and transformed large datasets using SQL and Python, supporting critical analysis for operational and financial
reporting.
● Developed interactive dashboards in Tableau to facilitate data-driven decision-making across departments.
● Leveraged for comprehensive data visualization Matplotlib offers flexibility for creating detailed, static or animated
visualizations, while ggplot2 (inspired by R’s ggplot) is ideal for layered, multi-faceted charts, making it easier to interpret
complex data patterns during analysis.
● Combined for rapid data analysis and basic visualization SQL extracts and pre-processes large datasets and Excel provides
flexibility for pivot tables, basic charts, and data manipulation, ideal for quick exploratory analysis and ad hoc reporting.
● Modeled data for forecasting, achieving a {15%} increase in prediction accuracy and providing insights that improved sales
projections by {20%}.
● Conducted data wrangling and data cleaning operations to improve overall data quality and database efficiency.
● Collaborated with stakeholders to align data deliverables with business goals, enabling a seamless transition to data-driven
processes.
Spectrum Webapps, GUJ - IND Jan 2016 to July 2016
Data Analytics Intern
● Assisted in extracting and transforming datasets using SQL to support operational and financial analysis.
● Created basic visualizations and reports in Excel to generate quick insights for ad hoc requests.
● Contributed to the development of interactive Tableau dashboards, aiding departments in making data-driven decisions.
● Performed initial data cleaning and wrangling to improve data quality for analysis.
● Helped collect and organize data to streamline data entry and storage processes.
● Supported team efforts by preparing documentation for data processes and analytics projects.
● Collaborated with team members to ensure data deliverables aligned with business objectives.
● Assisted in preparing summary reports to share key insights with stakeholders, enhancing data-driven practices.
SKILLS
Methodologies : SDLC (Agile, Scrum)
Languages : Python, R, SQL
IDEs : Visual Studio Code, PyCharm, Jupyter Notebook
Python Packages : NumPy, Pandas, Matplotlib, SciPy, ggplot2, Scikit learn, PySpark, Keras, TensorFlow
Visualization Tools : Tableau, Power BI, Microsoft Excel
Database : MySQL, SQL Server, Mongo DB, PostgreSQL
Cloud Technologies : AWS (S3, RDS, Glue)
Other Skills & Tools : Data Cleaning, Data Wrangling, Critical Thinking, Presentation Skills, Problem-Solving
Version Control Tools : Git, GitHub
Operating System : Windows, macOS
EDUCATION
Master of Science in Information Technology University of the Potomac Virginia Campus - Falls Church, VA
Bachelor of Engineering in Electronics and Communication Gujarat Technological University, Ahmedabad - GJ