Shikhar Dixit
@shikhardixit
Data Analyst
London, United Kingdom
Shikhar is a Data Analyst Professional with 4.5 years of experience in data analysis. His expertise includes SQL, Python, R Language, and Microsoft PowerBI. He is experienced in data ETL processes using Informatica Cloud and SAP Cloud Platform Integration, and has worked across the Marketing and IT sectors.
Experience
Data Analyst
Omnicom Media Group
Working as a Data Analyst in an Agile Environment for a leading German Luxury Automotive client. Responsibilities include gathering requirements from clients on Data Briefs (BRD), developing SQL stored procedures to automate data collection, and analyzing customer market data using Data Mining/Machine Learning algorithms. Created dashboards using Microsoft PowerBI and performed data cleaning and EDA using Python (NumPy, pandas) and SQL scripts.
Data Analyst Intern
GetSociable
Created Data Matrices for analysis from scratch using SQL and gathered relevant data using R and SQL. Developed analytical/data mining algorithms using R and Python, and created data visualizations using ggplot2, dplyr, Matplotlib, shiny, and Tableau.
Senior System Engineer/ System Engineer
Infosys
Handled projects for an Agriculture Giant in an Agile Environment, performing ETL using Informatica Cloud (IC) and SAP Cloud Platform Integration (CPI). Developed data integration interfaces and used SQL queries to transform data from various sources (iDOC, sFTP, JDBC, SOAP, JSON, REST, Salesforce). Managed a team of 3 individuals and handled data rectification processes.
Education
The Queen's University Belfast
MSc Data Analytics
Data Analytics
Expertise in Fundamentals in Data Analytics, Database and Programming Fundamentals, Data Mining/Warehouse Techniques, Machine Learning & Neural Networking.
Galgotias University
B.Tech
Computer Science Engineering