DHRUV PANCHAL
Gurgaon
Summary
Budding data professional with 3 years in operations management, excelling in process optimization, efficiency enhancement, and strategic decision-making. Proactive learner, skilled in Power BI, SQL, and Excel, dedicated to staying ahead in data analytics. Possessing a growth mindset and thriving on challenges, aligning seamlessly with a culture of innovation and excellence. Seasoned collaborator experienced in meeting needs, improving processes and exceeding requirements in team environments. Diligent worker with strong communication and task prioritization skills.
Overview
13
13
years of professional experience
1
1
Certificate
Work History
Data Analyst
PSYLIQ
12.2023 - 01.2024
- Worked with business intelligence software and various reports to glean insights into trends and prospects.
- Utilized data visualization tools to effectively communicate business insights.
- Documented effective and replicable methods for extracting data and organizing data sources.
- Created dashboards to monitor and track key performance indicators.
- Developed customized reports, summarizing and presenting data in visually appealing format.
Data Analyst
Tata Data Visualisation
12.2023
- Completed simulation involving creating data visualizations for Tata Consultancy Services
- Prepared questions for meeting with client senior leadership
- Created visuals for data analysis to help executives with effective decision making.
Data Analyst
Accenture North America
11.2023
- Completed simulation focused on advising hypothetical social media client as Data Analyst at Accenture
- Cleaned, modeled and analyzed 7 datasets to uncover insights into content trends to inform strategic decisions
- Prepared PowerPoint deck and video presentation to communicate key insights for client and internal stakeholders.
Power BI Job Simulation
PwC Switzerland
11.2023
- Completed job simulation which strengthened Power BI skills to better understand clients and their data visualization needs
- Demonstrated expertise in data visualization through creation of Power BI dashboards that effectively conveyed KPIs, showcasing ability to respond to client requests with well-designed solutions
- Strong communication skills reflected in concise and informative email communication with engagement partners, delivering valuable insights and actionable suggestions based on data analysis
- Leveraged analytical problem-solving skills to examine HR data, particularly focusing on gender-related KPIs, and identified root causes for gender balance issues at executive management level, highlighting commitment to data-driven decision-making.
Assistant Operations Manager
Fotuwalle by DHP Labs
12.2020
- Supervised and mentored team of 3 operational staff, fostering culture of accountability and continuous improvement
- Identified and implemented process improvements resulting in 15% increase in operational efficiency and 30% reduction in costs
- Collaborated with other departments to streamline communications, coordinated activities, and resolve customer issues
- Monitored department performance and identified areas for improvement in order to increase efficiency
- Utilized data analysis tools to identify trends and opportunities, leading to increase in operational efficiency
- Established and maintained positive relationships with key vendors, ensuring timely deliveries and cost-effective procurement
- Implemented technology solutions to streamline operations, resulting in increase in productivity
- Provided training and development opportunities for staff, improving team skills and performance.
Operations Analyst
Fotuwalle by DHP Labs
08.2016 - 11.2020
- Developed and implemented new operational processes and procedures to expedite delivery of services
- Monitored and analyzed operational performance indicators to identify areas for improvement
- Leveraged data analysis to develop insights and solutions to optimize operational efficiency
- Prepared and presented operational performance updates to executive leadership on monthly basis
- Coordinated project plans and timelines to ensure that all operational goals were met
- Utilized problem-solving skills to quickly identify and troubleshoot operational issues.
Operations Assistant
Faagio
03.2014 - 05.2016
- Assisted with development and implementation of operational procedures, policies, and systems
- Proven ability to work independently, prioritize tasks, and meet tight deadlines
- Utilized advanced knowledge of computer software to generate reports, update databases, and create spreadsheets
- Developed and maintained positive relationships with co-workers, vendors, and customers.
Public Relation Assistant
Wishbox Studios
01.2013 - 05.2013
- Developed content for website, newsletters, and other publications
- Assisted in the development and implementation of public relations and social media campaigns for clients
- Monitored on media coverage, PR metrics and other KPIs
- Conducted research for PR initiatives and campaigns.
Associate Web Content Writer
India TV Broadcast Center
04.2011 - 07.2012
- Wrote, edited and proof-read web content for accuracy, clarity and conciseness.
- Worked with design and development teams to ensure content works within their designs and technical specifications.
- Collaborated with team members to create content that meets web standards, SEO objectives, and client needs.
- Assisted in maintenance of content management systems and webpages.
Participated in brainstorming meetings to generate content ideas and strategies.
Education
Advanced Certification in Data Science And AI -
IIT Madras - INTELLIPAAT LEARNINGS
Gurgaon, HR12.2023
Bachelors in Journalism and Mass Communication -
Trinity Institute of Professional Studies
Dwarka, New Delhi01.2011
Skills
- Microsoft SQL
- Microsoft Power BI
- Microsoft Excel
- Dashboards
- Data Cleansing
- Data Visualization
- Strong Analytical Skills
- Problem Solving
- Detail-oriented
- Critical Thinking
- Interpersonal Communication
- Adaptable to change with learning mindset & Self-motivated
Certification
- Advanced Certification in Data Science and AI
IIT-Madras / Intellipaat - January 2023 to August 2023
ID : DSA053210477
- Power BI
Intellipaat - October 2023
ID: 31679-52499-184699
- SQL
Intellipaat - April 2023
ID: 31679-2853-184699
- MS Excel
Intellipaat - October 2023
ID: 31679-26609-184699
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Quote
Every problem is a gift—without problems we would not grow.
Tony Robbins
Timeline
Data Analyst
PSYLIQ
12.2023 - 01.2024
Data Analyst
Tata Data Visualisation
12.2023
Data Analyst
Accenture North America
11.2023
Power BI Job Simulation
PwC Switzerland
11.2023
Assistant Operations Manager
Fotuwalle by DHP Labs
12.2020
Operations Analyst
Fotuwalle by DHP Labs
08.2016 - 11.2020
Operations Assistant
Faagio
03.2014 - 05.2016
Public Relation Assistant
Wishbox Studios
01.2013 - 05.2013
Associate Web Content Writer
India TV Broadcast Center
04.2011 - 07.2012
Advanced Certification in Data Science And AI -
IIT Madras - INTELLIPAAT LEARNINGS
Bachelors in Journalism and Mass Communication -
Trinity Institute of Professional Studies
Similar Profiles
Vanitha NallaniVanitha Nallani
SQL Developer Intern at PsyliqSQL Developer Intern at Psyliq
Siddhesh ParabSiddhesh Parab
HR Data Analysis Intern at Psyliq InternshipHR Data Analysis Intern at Psyliq Internship
Siddhesh ParabSiddhesh Parab
HR Data Analysis Intern at Psyliq InternshipHR Data Analysis Intern at Psyliq Internship
Sameer AryaSameer Arya
Interior Design Consultant at Sameer AryaInterior Design Consultant at Sameer Arya
Vaibhav DubeyVaibhav Dubey
Principal Software Engineer at PepsiCoPrincipal Software Engineer at PepsiCo