Siddharth Pandit
Fairfax,VA
Summary
Experienced and solution-oriented professional with a keen eye for detail and a passion for problem-solving. Equipped with a strong background in data systems and processes, possessing a solid understanding of data modeling and database design. Proficient in SQL and Python, able to effectively analyze complex datasets and extract valuable insights. Expertise in driving data-driven decision-making, committed to improving data infrastructure and optimizing business operations.
Overview
1
1
year of professional experience
1
1
Certification
Work History
Project Experience - Air Quality Dashboard
George Mason University
05.2024 - 06.2024
- Automated retrieving and storage of air quality data from AirVisual API using Python scripts, resulting in 95% reduction in manual data retrieval efforts and ensuring up-to-date information for dashboard
- Designed and implemented dynamic charts and graphs within Streamlit web application to allow users to interact with air quality metrics, resulting in 75% increase in user engagement and understanding of pollution levels across major U.S
- Cities
- Established CI/CD pipelines leveraging GitHub Actions for automated data fetching and application deployment, reducing deployment time by 50% and ensuring consistent updates to Air Quality Dashboard
Analysis of Fentanyl Trafficking, Scrum Master
George Mason University
01.2024 - 05.2024
- Led collaborative efforts with cross-functional teams to develop data analysis strategies, resulting in the discovery of critical evidence linking government officials to fentanyl precursor chemical production
- This led to the identification of 8 additional companies involved in illicit manufacturing practices, prompting further investigations by regulatory authorities and ultimately aiding in disrupting their operations
- Utilized agile methodologies to optimize data collection processes, increasing efficiency by 20% when extracting information from various sources
- The streamlined workflow enabled quicker identification of potential connections between Chinese Communist Party officials and fentanyl precursor chemical manufacturers, providing valuable insights for law enforcement agencies
- Conducted in-depth analytical research and data mining to identify synthetic opioid (fentanyl) precursor chemical manufacturers and complicit government officials
- Analyzed datasets from multiple sources, revealing direct links between Chinese Communist Party officials and fentanyl precursor chemical production
- This information, framed as user stories, played a crucial role in shaping legislative discussions around regulating the manufacturing and distribution of these harmful substances, demonstrating adaptability to evolving project requirements and stakeholder needs
Project Experience - Personalized Content Recommendation System
George Mason University
01.2024 - 02.2024
- Developed and implemented new algorithms to optimize the content recommendation system, resulting in a 10% increase in accuracy of movie suggestions based on user preferences, as measured by a decrease in user ratings below 4 stars
- Utilized AWS data visualization tools to track user engagement metrics, identifying a 20% increase in average time spent on the platform per session after the implementation of the new content recommendation system
- Led cross-functional team meetings to gather feedback on the platform's usability and functionality, resulting in a 15% increase in user satisfaction scores compared to previous versions
Project Experience - Credit Card Fraud Detection
George Mason University
01.2023 - 05.2023
- Utilized advanced Machine Learning GBTClassifier model to achieve high recall rate of 92% in detecting fraudulent activities, showcasing expertise in complex problem-solving and proactive decision-making
- Managed project timelines effectively to ensure timely delivery of results
- Implemented strategic time management techniques to consistently meet project deadlines, resulting in successful achievement of project goals on schedule
- Achieved high F1 score of 90% in fraud detection, demonstrating meticulous tuning of model for optimal performance
- Demonstrated strong leadership skills in driving projects forward, leveraging exceptional organizational abilities to deliver results independently
- Leveraged Machine Learning GBTClassifier model with precision tuning for high F1 score of 90% in fraud detection, showcasing deep understanding of intricate situations and proactive problem-solving approach
Project Experience - Collision Analysis in Manhattan Borough
George Mason University
01.2023 - 05.2023
- Designed a project utilizing Microsoft Azure VM, Docker, PostgreSQL, and Apache Spark to analyze collision data in Manhattan
- Identified that 73% of accidents occur on Thursdays and Fridays, with over 84% happening between 14:00 and 16:00, leading to actionable insights for improving road safety
- Utilized effective communication skills to collaborate with interdisciplinary teams in uncovering injury correlations within the collision data
- Facilitated knowledge sharing and teamwork to enhance the overall project outcomes
- Demonstrated the value of cloud computing for extracting meaningful insights from large datasets by showcasing how this technology can drive informed decision-making in road safety initiatives
Education
Master of Science - Data Analytics Engineering
George Mason University
Fairfax, VA05-2024
Skills
- Data reporting
- Data interpretation
- Data analysis
- Data cleaning
- Linear regression
- Machine learning
- Web scraping
- MySQL databases
- Tableau software
- Python programming
- Java programming language
- Docker containers
- Git
- Git workflow
Certification
- Tableau Desktop Specialist, https://www.credly.com/badges/88acdf6b-4fa0-4dee-9335-82fc23c8eba6/public_url
- Version Control with Git
- Data Structures and Algorithms
- Post Graduate Certificate in Software Engineering for Data Science (Aug 2021–Feb 2022) Academic
ePortfolio. https://eportfolio.mygreatlearning.com/siddharth-p
Accomplishments
Letter of Appreciation, Select Committee on the Chinese Communist Party, U.S. House of Representatives. Received formal recognition for outstanding contributions through my capstone project addressing fentanyl trafficking.
Timeline
Project Experience - Air Quality Dashboard
George Mason University
05.2024 - 06.2024
Analysis of Fentanyl Trafficking, Scrum Master
George Mason University
01.2024 - 05.2024
Project Experience - Personalized Content Recommendation System
George Mason University
01.2024 - 02.2024
Project Experience - Credit Card Fraud Detection
George Mason University
01.2023 - 05.2023
Project Experience - Collision Analysis in Manhattan Borough
George Mason University
01.2023 - 05.2023
- Tableau Desktop Specialist, https://www.credly.com/badges/88acdf6b-4fa0-4dee-9335-82fc23c8eba6/public_url
- Version Control with Git
- Data Structures and Algorithms
- Post Graduate Certificate in Software Engineering for Data Science (Aug 2021–Feb 2022) Academic
ePortfolio. https://eportfolio.mygreatlearning.com/siddharth-p
Master of Science - Data Analytics Engineering
George Mason University
Similar Profiles
Mina MahtabfarMina Mahtabfar
Outreach Coordinator of Patriot Activities Council at University Life George Mason University KoreaOutreach Coordinator of Patriot Activities Council at University Life George Mason University Korea
Sydney SalterSydney Salter
Clinical Graduate Teaching Assistant at George Mason UniversityClinical Graduate Teaching Assistant at George Mason University
Jacob VelazquezJacob Velazquez
Research Assistant at George Mason UniversityResearch Assistant at George Mason University