Summary
Overview
Work History
Education
Skills
Timeline
Generic

Shikhar Amok Dixit

Bangalore,

Summary

Data Analyst with 6+ years of experience in analysing and processing data using tools like SQL, Python, and R. I specialize in creating robust data pipelines, automating workflows, and ensuring data quality through statistical analysis and machine learning techniques. My expertise lies in deriving actionable insights from complex datasets and presenting them through impactful visualizations using Power BI. Skilled in working across diverse domains such as energy markets, IT, and marketing, I excel in fast-paced, Agile-driven environments, delivering data-driven solutions tailored to business needs.

Overview

7
7
years of professional experience

Work History

Senior Data Analyst

Rystad Energy, Oil Market Team
05.2023 - Current
  • Leading the RealTimeCube project, a visualization tool for real-time consumption data in the road, aviation, and maritime sectors with city, road location, airport, and country-level granularity
  • Developed robust data pipelines, automated using Python and SQL, ensuring high-quality, real-time data processing and delivery
  • Used Bitbucket for version controlling python and SQL scripts
  • Extensively used MS Office – Excel Power Query for data analysis and visualised data using pivot table for data visualisation purposes also used Power BI extensively for data visualisation
  • Leveraged web scraping tools like Beautiful Soup and Selenium for data extraction and collection
  • Implemented machine learning models to predict and address data lags efficiently
  • Conducted advanced data analysis, applied statistical methods and developed reusable complex statistical function to remove unwanted noise from large data sets, ensuring top-quality datasets
  • Authored complex Python scripts and SQL stored procedures to streamline pipeline automation
  • Worked very closely with the research and product team to discuss changes in the data which could be taken as data points for new commentaries and reports, also worked with Data Engineers team to automate the processing of data pipelines
  • Managed a team of three data analysts, leading projects and mentoring team members, worked on many projects autonomously right from requirement gathering stage to delivering of the project
  • Actively participated in the hiring process to onboard new data analysts

Data Analyst

Omnicom Media Group
12.2021 - 04.2023
  • Analyzed customer market data for a leading German luxury automotive client, using machine learning algorithms to understand market trends and develop future strategies
  • Automated data collection processes, reducing SLAs from3 hours to30 minutes using SQL stored procedures and Adobe workflow
  • Built Power BI dashboards for sales performance analysis across different geographical regions
  • Cleaned and transformed data using Python and SQL, performing extensive exploratory data analysis (EDA)
  • Delivered insights on campaign performance by analyzing lead generation and conversion trends

Data Analyst Intern

GetSociable
09.2021 - 11.2021
  • Designed data matrices from scratch using SQL and conducted initial visualization for insight generation
  • Extracted, cleaned, and analyzed data using R, Python, and Postgres SQL
  • Developed and visualized analytical algorithms with tools like ggplot2, Matplotlib, and Tableau

Senior System Engineer

Infosys
11.2017 - 12.2020
  • Performed ETL tasks using Informatica Cloud and SAP CPI for data integration and manipulation
  • Created seamless data transfer pipelines for various sources (MDM, SAP, Salesforce) and implemented security measures like encryption and decryption
  • Led a team of three, providing training and overseeing deliverables
  • Worked directly with clients to gather requirements and implement solutions

Education

MSc - Data Analytics

The Queen's University Belfast
01.2022

B.Tech - Computer Science Engineering

Galgotias University
05.2017

Skills

  • Python (NumPy, Pandas, Beautiful Soup, Selenium, sklearn, scipy)
  • SQL (Data Cleaning, Stored Procedures, CI/CD with Bitbucket)
  • Machine Learning
  • Data Visualization (Power BI, Tableau, Matplotlib, ggplot2)
  • ELT Processes
  • Statistical Analysis (Hypothesis Testing, Noise Reduction)
  • Data Pipeline Automation
  • Git/Bitbucket

Timeline

Senior Data Analyst

Rystad Energy, Oil Market Team
05.2023 - Current

Data Analyst

Omnicom Media Group
12.2021 - 04.2023

Data Analyst Intern

GetSociable
09.2021 - 11.2021

Senior System Engineer

Infosys
11.2017 - 12.2020

B.Tech - Computer Science Engineering

Galgotias University

MSc - Data Analytics

The Queen's University Belfast
Shikhar Amok Dixit