Hi, I’m
Prashant Modi
Lead Data Analyst
Gandhinagar
Summary
Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.
Overview
9
years of professional experience
3
years of post-secondary education
11
Certifications
1
Language
Work History
S&P Global Market IntelligenceAhmedabad
Data Analyst
11.2022 - Current
Job overview
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
- Produced monthly reports using advanced Excel spreadsheet functions.
- Worked with business intelligence software and various reports to glean insights into trends and prospects.
- Used statistical methods to analyze data and generate useful business reports.
- Extracted and interpreted data patterns to translate findings into actionable outcomes.
- Identified, analyzed and interpreted trends or patterns in complex data sets.
S&P Global Market IntelligenceAhmedabad
Data Researcher II
08.2021 - 11.2022
Job overview
- Reviewed source documents and listings to compile resources for identifying and correcting data allocation issues.
- Identified and resolved data-handling errors and hardware conflicts to maintain organizational IMS infrastructure.
- Partnered with subject matter experts in continuous improvement process, upgraded data quality and recommended innovative information management strategies.
- Analyzed content access, retention and evaluation projects to maintain nonstop information repository.
- Assessed accuracy and effectiveness of new and existing data sources and data analysis techniques.
- Developed process improvement initiatives and analyzed problems to create corrective action strategy.
S&P Global Market IntelligenceAhmedabad
Data Researcher I
07.2019 - 07.2021
Job overview
- Worked with stakeholders to develop quarterly roadmaps based on impact, effort and test coordinations.
- Completed accurate data input or corrections into computer files.
- Utilized advanced querying, visualization and analytics tools to analyze and process complex data sets.
- Assessed accuracy and effectiveness of new and existing data sources and data analysis techniques.
- Identified, measured and recommended improvement strategies for KPIs across business areas.
- Compiled, cleaned and manipulated data for proper handling.
- Analyzed large datasets to identify trends and patterns in customer behaviors.
Tata Consultancy ServicesGandhinagar
Market Research Analyst
03.2015 - 07.2019
Job overview
- Created and presented real-time reports on current market conditions to upper management.
- Analyzed survey data and generated insights by importing data sheets from survey projects into survey analysis software.
- Devised and evaluated methods and procedures for collecting data such as surveys, opinion polls or questionnaires.
- Prepared reports of findings by illustrating data graphically and translating complex findings into written text.
- Forecasted and tracked marketing and sales trends by thoroughly analyzing collected data.
- Gathered data on competitors to analyze prices, sales and methods of marketing and distribution.
- Collated information to interpret data for clients.
- Collected and analyzed data on customer demographics, preferences, needs and buying habits to identify potential markets and factors affecting product demand.
- Analyzed data to uncover insights and identify key opportunities to inform strategic decisions.
- Utilized specialized software to capture and process data.
- Researched and evaluated potential new markets and products.
Education
Saurashtra UniversityRajkot, Gujarat
BBA from Marketing & Finance
05.2011 - 07.2014
Skills
Advance Excel
Powerpoint
SQL
VBA
Data formatting
Data validation
Data quality assurance processes
Data analysis
MS office product
Data cleaning and preprocessing
Database Management
Problem-Solving
Accomplishments
- Have received appreciation from the client (Nielsen) for successfully implementing an e-mail Auto Delivery tool for a Czech Republic retailer as part of the automation initiative
- Achieved Star Performer for May’16 & Mar'18
- Certificate in CPG Industry course
- Achieved BPS Champions League- Teamwork (Best teamwork in Whole Nielsen account) on Jul 17
- Rewarded for the Service and commitment award on Mar 18
Certification
SQL Learning Path
Timeline
Data Governance Foundations
09-2023
Agile Product Owner Learning Path
09-2023
Agile Scrum Master
09-2023
Google Data Analytics Professional Certificate - Pursuing
08-2023
Introduction to Agile 2.0
08-2023
Certified Lean Facilitator
02-2023
Data Analyst
S&P Global Market Intelligence
11.2022 - Current
Blockchain and Cryptography
05-2022
SQL Learning Path
11-2021
Data Researcher II
S&P Global Market Intelligence
08.2021 - 11.2022
Agile Scrum Practitioner Learning Path
06-2021
Agile Scrum Practitioner Learning Path
06-2021
Agile Mindset: Think, Breathe, Be Agile
08-2019
Data Researcher I
S&P Global Market Intelligence
07.2019 - 07.2021
Market Research Analyst
Tata Consultancy Services
03.2015 - 07.2019
Saurashtra University
BBA from Marketing & Finance
05.2011 - 07.2014