Summary
Overview
Work History
Education
Skills
Certification
Projects handled
Accomplishments
Languages
Timeline
Generic
Kripali Sharma

Kripali Sharma

Ahmedabad

Summary

  • A technocrat with 7+ years of experience in Data Analysis, Data Visualization, Client Management & Queries, Project Execution and Team Management.
  • Proven track record of managing financial forecasting, reporting analysis, client interaction and mentoring.
  • Expertise of working on multiple projects in very short time period and has experience of reviewing the code implemented by other team members.
  • Strong communication, collaboration & team building skills with proficiency in grasping new technical concepts quickly.
  • Deft in successfully interpreting data in order to draw conclusions for managerial action and strategy.
  • Skilled in using statistical techniques for hypothesis testing to validate data and interpretations.
  • Strong communication, collaboration & team building skills with proficiency in grasping new technical concepts quickly.

Overview

8
8
years of professional experience
1
1
Certification

Work History

Data Analyst

S&P Global Market Intelligence
Ahmedabad
02.2017 - Current

Data Analyst - Dec '22 - Present

Data Researcher II - Jan '19-Nov '22

Data Researcher I - Feb '17-Dec '18

  • Handling a gamut of activities encompassing.
  • Networking with the project team and conducting periodic project progress review meetings to ensure effective delivery of project solutions in line with time and quality parameters.
  • Delivering and implementing the project as per scheduled deadlines; coordinating, discussing, and handling different client issues with quick and prompt response.
  • Delegating the work to the team members on a priority basis in the absence of leads and also based on the skill set.
  • Monitoring and analyzing Key Performance Indicators and present the key issues to the management.
  • Responsible for evaluating in coordination with team lead in regard of new policies and clarifications received and analyzing data by using data visualization tools such as Excel Plug-in, and SQL for decision making.
  • Handling and suggesting various lean ideas and providing extensive support to Automation experts related to content; involved in identifying and escalating new ideas and forwarding them to the management.
  • Liaising with Team Lead in regard of new policies and clarifications; conducting/providing training and clarifications to new employees for in-depth knowledge on products.
  • Effectively working on team’s internal quality checks process for identifying and clearing the bad data audits.
  • Collecting financial and investment information about companies, stocks, bonds, and other investments using daily stock and dividends, corporate actions from company financial statements, and other financial reports.

Notable Accomplishment

- Distinction of being an Individual Champion in market data domain in Q4 2018.

- Successful tool interface suggestions for tool enhancement 2022

- Reward & Recognition Award nomination for May & August 2023

Education

Master of Business Administration -

Parul University
Vadodara
01.2018

B.Com. -

Maharaja Sayajirao University
Vadodara
01.2015

Skills

  • Data Analysis
  • Data Visualization
  • SQL
  • Client Management
  • Microsoft power BI
  • Pattern & Trend Identification
  • Problem Management
  • Escalation Management
  • Training & Development
  • Technical Support
  • Data Quality Assessment
  • Probability & Statistics
  • Client Queries
  • Liaison & Coordination
  • Team Management

Certification

  • Microsoft Power Business Intelligence from Udemy in 2023
  • Google foundations of Project Management from Coursera in 2023
  • SQL Data Management from APTECH Computer Education in 2020
  • Python Programming Expert with Grade A from Edureka in June 2023

Projects handled

Sales SQL Data Analysis project

  • An exploratory data analysis was performed on the company's KPI-Profits, Sales, P/E, Market Cap, EPS, more fundamental data points.
  • After cleaning and preprocessing the data, the profits trends were visualized by Profits, Sales, P/E, Market Cap, EPS etc.
  • Analysis will provide valuable insights into the sales and profits performance and identified areas for improvement & firm decision-making

Power BI Dashboard for Energy Trade Analysis Worldwide

  • Dashboard include data on the production, trade, and consumption of primary and secondary energy, conventional and non-conventional energy sources, as well as new and renewable energy sources.
  • Power BI visualization types including bar charts, flow maps, cards for the overview page, ribbon charts, tree maps, and bar charts for energy generation can all be used for the dashboard.

Power BI Dashboard for Company performance evaluation

  • Build interactive dashboard, by establishing relationship between multiple tables, including sales trends, regional performance maps, product category, orders, profits, KPIs, top customers for company, developing measures for expected results for DAX, overcame data integration challenges by developing custom ETL steps, power BI artificial intelligence features- decomposition tree, key influencers using (Bar chart, scatter,line chart, maps, gauge chart, cards , KPIs,slicers, tables & matrix)

Power BI Dashboard for Ecommerce Company

  • Created interactive dashboard for Ecommerce company to track & analyze sales, profits, geographical & customer data by using different types of customized visualization (Bar chart, scatter chart, donut chart, slicers, line chart, pie chart, clustered bar chart, etc.)

Data Migration Issues

  • Involved in reviewing the data based on alerts created when dependent team data changes; demonstrated key benefits and the advancements with the customized alerts to the team members and the management team.
  • Responsible for identifying the operational process inefficiencies and recommended necessary improvements; evaluated utilization and capacity against performance goals. Developed Offline Query in SQL to clear day-to-day records of missing Migrated Data in the collection tool.

Australian/New Zealand Franked/Imputation Dividend collection

  • Actively researched on the imputed/franked dividends paid by the Australian & New Zealand companies; enhancing the dividend collection procedure to provide a detailed view on dividends paid in these countries to the client.
  • Involved in designing & testing the user interface by coordinating with technology team, business owners and collection users; imparted training to the team members on using the user interface and collecting the data.
  • Involved in the Q&A of the product and developing the check logics for the quality improvement.

Accomplishments

  • Distinction of being an Individual Champion in market data domain in Q4 2018.
  • Successful tool interface suggestions for tool enhancement 2022
  • Reward & Recognition Award nomination for May & August 2023

Languages

  • English
  • Hindi
  • Gujarati

Timeline

Data Analyst

S&P Global Market Intelligence
02.2017 - Current

Master of Business Administration -

Parul University

B.Com. -

Maharaja Sayajirao University
Kripali Sharma