Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Pranay Sarode

Pune

Summary

Ability to analyze complex data sets, derive actionable insights, and develop streamlined solutions using Excel, PowerBI, SQL, and Python. Capable of producing advanced reports, infographics, and interactive dashboards, using a thorough understanding of these technologies to not only increase efficiency but also improve forecasting accuracy and predictive modeling. Profound experience includes statistical analysis and machine learning approaches, as well as the use of Python libraries for data manipulation, modeling, and automation, all of which contribute to the development of novel solutions. My background spans multiple industries, demonstrating a track record of generating results through data-driven approaches. This includes refining operational processes, discovering cost-cutting opportunities, and driving revenue growth plans, all while conveying complicated results to stakeholders effectively. I am committed to using cutting-edge approaches to drive business objectives and nurture data-centric decision-making by staying up to date with the newest breakthroughs in data analytics and technology.

Overview

10
10
years of professional experience
1
1
Certification

Work History

Junior Data Scientist

BMO Data Analytics
10.2021 - Current
  • Experience with Power BI, SQL, and Python for sophisticated data analytics, providing meaningful insights, and improving business processes is required
  • With Python, you have a proven track record of constructing analytics solutions, creating visualizations, and conducting statistical analysis
  • Experience interpreting data, presenting findings, and communicating ideas to a wide range of stakeholders
  • Analytics solutions were implemented, which improved operational efficiency and strategic decision-making.

Sr. Technology Support Executive (Power BI & SQL)

Infosys
03.2021 - 09.2021
  • A track record of using Power BI and SQL to create business intelligence and data-driven decision-making is required
  • Proven success in creating powerful visualizations and reports with Power BI and SQL databases
  • Experience analyzing, interpreting, and presenting data to a variety of stakeholders
  • Power BI solutions linked to SQL databases are being used to increase operational efficiency and business outcomes.

Support Officer (MIS Executive, Power BI)

Mphasis
05.2019 - 02.2021
  • Demonstrated experience in developing Power BI solutions to drive business outcomes
  • Successful track record of creating impactful dashboards and reports
  • Expertise in data analysis and interpretation using Power BI tools
  • Experience in training and supporting teams in Power BI utilization.

Senior Associate (MIS Executive)

Wipro
12.2016 - 02.2019
  • Create and maintain databases, software applications, and information technology infrastructure
  • Analyze data to generate reports, discover trends, and provide decision-making actionable insights
  • Implement and monitor security procedures to safeguard sensitive information
  • Work with cross-functional teams to solve technical problems and optimize systems
  • To improve efficiency and effectiveness, evaluate new technology and solutions.

Resident Engineer

Dhruva Enterprises
08.2013 - 05.2016
  • Detailed network documentation, including network diagrams and device settings, was created and maintained
  • Updated and maintained the internal network infrastructure of the business, which boosted network dependability and speed
  • Created a system for tracking and regulating network traffic, which improved network performance by 100%
  • Analyzed network traffic using packet sniffers to find and fix network issues.

Education

Bachler of Arts -

External Pune University
01.2020

H.S.C -

National Institute of Open School
01.2011

S.S.C -

KHS
01.2006

Skills

  • Excel: Data Entry and Formatting, Formulas and Functions, Conditional Formatting, Macros and VBA
  • Power BI: Data Transformation, Data Modeling, Data Visualization, Data Insights, Dashboards and Reports
  • Tableau: Data Connection, Data Preparation, Calculations and Expressions, Mapping and Geospatial Analysis
  • SQL: Data Definition, Data Constraints, Data Joins, Aggregation Functions, Stored Procedures and Functions
  • Python: Basic Syntax, Control Structures, Functions, Modules and Libraries, Object-Oriented Programming (OOP)
  • Data Analysis: Data Collection, Data Cleaning and Preprocessing, Data Exploration
  • Machine Learning: Supervised Learning, Unsupervised Learning, Data Preprocessing, Cross-Validation

Certification

  • Hardware and Networking Technician, Silicon Valley, 06/2010, 05/2011
  • Data Science and Analytics Specialist, ITVEDANT, 06/2023, 02/2024

Timeline

Junior Data Scientist

BMO Data Analytics
10.2021 - Current

Sr. Technology Support Executive (Power BI & SQL)

Infosys
03.2021 - 09.2021

Support Officer (MIS Executive, Power BI)

Mphasis
05.2019 - 02.2021

Senior Associate (MIS Executive)

Wipro
12.2016 - 02.2019

Resident Engineer

Dhruva Enterprises
08.2013 - 05.2016

Bachler of Arts -

External Pune University

H.S.C -

National Institute of Open School

S.S.C -

KHS
Pranay Sarode