KARTIKEY BHATT
Ahmedabad
Summary
Experienced in SQL and Microsoft Excel for extracting insights from complex datasets and creating advanced data extraction and transformation scripts. Skilled in analyzing and interpreting large datasets to uncover insights for informed business decisions, utilizing advanced data management techniques. Proficient in developing user-friendly dashboards using Power BI and other visualization tools to effectively communicate data, insights, and trends. Demonstrated ability to establish seamless data pipelines, ensuring data flow and integrity. Strong understanding of data visualization techniques to enhance data comprehension and presentation.
Overview
17
17
years of professional experience
1
1
Certification
Work History
Data Specialist (CoE Member)
S&P Global Market Intelligence
06.2022 - 02.2024
- Defined project requirements, gathered stakeholder needs, and conducted research on relevant technologies and methodologies as a Center of Excellence (CoE) Member
- Developed detailed plans for Proof of Concepts (POCs), including timelines, resource allocation, and testing environments
- Validated proposed solutions rigorously
- Documented processes, communicated progress and findings to stakeholders, and addressed feedback effectively
- Identified and mitigated potential risks, evaluated cost-effectiveness, and provided operations support
- Assisted teams in improving workflow systems and activities related to data/content management
- Tracked and analyzed metrics to measure process and content quality, proactively identifying and resolving operational process issues
Data Specialist
S&P Global Market Intelligence
10.2019 - 06.2022
- Developed and maintained Power BI reports tracking departmental accuracy KPIs, collaborating closely with the operations team to provide comprehensive support in data collation and management
- Tracked the team's accuracy health, delivered regular updates with detailed data analysis, identified error trends, and devised action plans to prevent future errors
- Facilitated evaluations of workflow systems to enhance processes and functionality, created Power BI reports for quality and productivity, and monitored metrics using Tableau and Power BI
- Offered guidance to team members on data-related projects, ensured adherence to SOPs, and fostered collaboration and continuous improvement through regular meetings and workshops
Senior Data Researcher II, Data/Content Management
S&P Global Market Intelligence
10.2017 - 10.2019
- Executed straightforward tasks and handled high-volume transactions according to detailed instructions
- Provided advanced data and operations support for research and client assistance, along with developing daily reports while rectifying dataset errors
- Collaborated with project teams to strategize and execute process changes, created process guidelines and training materials, and utilized Tableau and Power BI to track and analyze metrics for process and content quality
Industry Specialist, Data Stewardship and Analysis
S&P Global Market Intelligence
04.2017 - 10.2017
- Conducted in-depth analysis of industry-specific data to identify trends, opportunities, and risks
- Served as a steward for data integrity, ensuring accuracy, completeness, and consistency of datasets
- Collaborated with internal teams to develop and maintain data models, taxonomies, and classification schemes
- Provided subject matter expertise to support the development and enhancement of data products and solutions
- Generated insightful reports and presentations to communicate findings and recommendations to stakeholders
Industry Specialist
S&P Global Market Intelligence
01.2013 - 04.2017
- Presenting Departments accuracy health to relevant stakeholders along with the mitigation plans and challenges.
- Entering client error details in specified format to provide accurate details of error, accountability, and preventive actions.
- Create Training program for the department and to provide Training to new hires.
- Serves as the subject matter expert for a range of research activities.
- Leads the data collation, analysis, extraction, manipulation, and validation process through extensive research of data sets.
- Designing new process guidelines and writing business procedures and training materials & content policies.
- Performs research and extracts required information from various sources, tools, and documents to respond to requests from internal and external clients.
- Analyzing the error trend and provide action items to prevent future errors.
- Identifying the error prone audits and getting them completed within stipulated time
frame.
Senior Analyst II
SNL Financial (India) Pvt Ltd
01.2012 - 01.2013
- Responsible for entering, editing, and managing data in work tools as per specified guidelines and checklists.
- Creating reports of work performed during the day via reporting tools.
- Working with other related teams to complete tasks assigned to them, ensuring quality and performance to set standards with little supervision.
- Applying basic understanding of operations principles, theories, and work tools to complete assignments.
- Solving straightforward problems in operational processes and providing solutions based on practices, existing precedents, or procedures.
- Working within the team; and interacting with other related teams. Providing training to other junior colleagues on processes and procedures.
Senior Analyst I
SNL Financial (India) Pvt Ltd
01.2009 - 01.2012
- Responsible for entering and editing data in work tools as per specified guidelines and checklists.
- Delivering on predefined individual and team targets including delivering outcomes with quality and excellence.
- Collaborating with cross teams to complete tasks assigned to them.
- To work within parameters and with supervision to ensure quality and performance to set standards.
- Acquiring basic understanding of the business and the data/content.
- Working within the team; and to interact with other related teams. Working with supervisor and team members to understand processes and procedures.
Analyst
SNL Financial (India) Pvt Ltd
06.2007 - 01.2009
- Responsible for entering and editing data in work tools as per specified guidelines and checklists.
- Delivering on predefined individual and team targets including delivering outcomes with quality and excellence.
- To work within parameters and with supervision to ensure quality and performance to set standards.
- Acquiring basic understanding of the business and the data/content.
- Working within the team; and to interact with other related teams. Working with supervisor and team members to understand processes and procedures.
Education
Bachelor of Commerce -
Bhavnagar University
Skills
- SQL
- Microsoft Power BI
- Microsoft Excel
- Data Analysis
- Data Visualization and Reporting
- Data Mining
- Data Manipulation
- KPI Tracking
- SOP Creator
- Real-Time Data Processing
- User Acceptance Testing (UAT)
- Process Analysis and Improvement
- Quality Assurance
- Project Management
- Stakeholder Management
- Process Documentation
- Operational Support
- Data Auditing
- Cross-functional Collaboration
- Team Coordination
- Problem-solving
- Analytical Thinking
Accomplishments
- Defined requirements, rigorously tested concepts, and mitigated risks to validate and ensure solution success.
- Provided operations support, improved workflow systems, and managed data activities to enhance process functionality.
- Established a stakeholder communication system for regular project updates.
- Conducted data analysis to track accuracy and error trends, providing updates and action plans to stakeholders.
- Created interactive Power BI dashboards, enhancing KPI monitoring and decision-making.
- Conducted training and mentorship on data manipulation, improving team performance.
- Facilitated workflow evaluations, improved data management processes, reviewed guidelines, and ensured SOP adherence.
- Conducted data audits, enhancing overall data integrity.
- Collaborated with cross-functional teams to support data initiatives and successful project launches.
Certification
- Power BI for Beginners, Simplilearn, 01/01/24
- Excel PivotTables in Depth, LinkedIn Learning, 01/01/22
- SQL Data Reporting and Analysis, LinkedIn Learning, 01/01/22
- Introduction to Automation, ML, and AI, S&P Global Learning, 01/01/21
- Power BI Desktop, LinkedIn Learning, 01/01/21
- Data Analytics, LinkedIn Learning, 01/01/21
- Certified Lean Facilitator, S&P Global, 01/01/20
Languages
English
Hindi
Gujarati
Timeline
Data Specialist (CoE Member)
S&P Global Market Intelligence
06.2022 - 02.2024
Data Specialist
S&P Global Market Intelligence
10.2019 - 06.2022
Senior Data Researcher II, Data/Content Management
S&P Global Market Intelligence
10.2017 - 10.2019
Industry Specialist, Data Stewardship and Analysis
S&P Global Market Intelligence
04.2017 - 10.2017
Industry Specialist
S&P Global Market Intelligence
01.2013 - 04.2017
Senior Analyst II
SNL Financial (India) Pvt Ltd
01.2012 - 01.2013
Senior Analyst I
SNL Financial (India) Pvt Ltd
01.2009 - 01.2012
Analyst
SNL Financial (India) Pvt Ltd
06.2007 - 01.2009
Bachelor of Commerce -
Bhavnagar University
Similar Profiles
Aditya SinghAditya Singh
Research Analyst at S&P Global Market IntelligenceResearch Analyst at S&P Global Market Intelligence
Robert SackaRobert Sacka
Senior Account Manager at S&P Global Market IntelligenceSenior Account Manager at S&P Global Market Intelligence
Kya EndresonKya Endreson
Client Services Associate at S&P Global Market IntelligenceClient Services Associate at S&P Global Market Intelligence