Piyush Shishodia
Analyst-Data Science
Delhi
Summary
Data Analyst with 2 years and 9 months of experience in data management, analytics, and visualization. Skilled in converting complex datasets into actionable insights through advanced analysis and visualization tools. Known for strong analytical abilities, attention to detail, and translating business requirements into effective solutions. Proficient in creating interactive dashboards and reports to enhance data accessibility and drive business intelligence.
Overview
2
2
Certifications
Work History
Analyst - Data Science
Adglobal360 India Pvt. Ltd
11.2021 - 7 2024
- Developed Power BI Solutions: Created and optimized Power BI dashboards, KPI scorecards, and reports, enhancing performance and DAX queries for maximum efficiency.
- Client-Focused Deliverables: Delivered tailored Power BI solutions for high-profile clients, including Tata, Nestle, Mondelez, Mars, and Coke.
- Analytics with Google: Designed and implemented advanced analytics solutions, integrating Google Looker Studio and GCP to develop comprehensive dashboards.
- Real-Time Monitoring: Implemented Grafana for real-time KPI monitoring and collaborated on custom dashboard designs to enhance data visibility and decision-making.
- Data Management Expertise: Managed end-to-end data processes including collection, cleaning, database development, and validation using SQL.
- ETL and Efficiency Improvements: Enhanced ETL operations by 15-20% through SQL stored procedures; performed ETL tasks with Python (Pandas) and utilized AWS Lambda for efficient data processing.
- Web Data Extraction: Developed Python Selenium web crawlers for extracting data from major e-commerce platforms such as Flipkart and Amazon.
- Diverse Dataset Experience: Worked extensively with various datasets, including sales, e-commerce, and advertising data.
Education
Bachelor's of Technology - Computer Science Engineering
BPIT, IP University
04.2001 -
High School - Non-Med
GRM Public School
04.2001 -
Skills
Technical Proficiency: Expertise in Power BI, Python, and SQL for data analysis and visualization
Other Data Visualization Tools: Skilled in Grafana, Preset, Metabase, and Google Looker Studio
Analytical Expertise: Strong research and analytical skills for actionable insights
Problem-Solving: Innovative and effective in tackling complex challenges
Attention to Detail: Ensures data accuracy and high-quality standards
Client & Team Collaboration: adept at understanding client needs and providing solutions
Certification
Certificate for Completion of C Training by Spoken Tutorial Project, IIT Bombay
Projects
Face Recognition Attendance System - using Haar Cascade, opencv and LBPH algorithm. Twitter sentiment analysis - in python using tweepy, textblob, matplotlib.
Timeline
Analyst - Data Science
Adglobal360 India Pvt. Ltd
11.2021 - 7 2024
Bachelor's of Technology - Computer Science Engineering
BPIT, IP University
04.2001 -
High School - Non-Med
GRM Public School
04.2001 -