Beta

Pankaj Patil

Data Scientist

Technologies

My Portfolio Highlights

My New Github

EDA of Charity donation dataset using SQL and R

My New Github

EDA of Charity donation dataset using SQL and R

My Work

Take a look at my latest work.

course

Data Manipulation in SQL

github

EDA of Charity donation dataset using SQL and R

course

Data Manipulation in SQL

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Data Manipulation in SQL

Courses

Data Manipulation in SQL

My Work Experience

Where I've interned and worked during my career.

sonnen GmbH | Aug 2022 - Present

Data Scientist

Responsibilities: Integral member of the global insights team, actively contributing to the development of innovative data products to foster data-driven decision-making across various departments. Created and maintain ETL pipelines in Databricks, ensuring data quality and data accessible to stakeholders with reports in Tableau Organized monthly AI-Breakfast club sessions companywide to enhance data literacy towards AI products. Achievements : Forecasting Energy Consumption: Created forecasting algorithm using ML models to optimize the battery performance & reduce energy cost for the customers. Prescriptive Algorithm Development: Developed algorithms using Python to automatically detect issues in the storage systems and create service cases to prevent hardware failures. Technologies : Python, Pyspark, SQL, Tableau, Databricks, AWS services, Git

Flaconi | Aug 2020 - Apr 2022

Data Analyst

Responsibilities: • Responsible for the conception, implementation & optimization of entire customer analytics area • Implemented statistical techniques for strategic deep dives, incl. segmentation, targeting, regression analysis to improve customer experience and retain customers • Created different ML models using Python and provided recommendations to management • Created and optimised SQL queries for strategic reports and data visualisation in Tableau • Promoted data culture within the company through monthly data workshops for business teams and organised Data meetups throughout the company Achievements: • Improved previous customer segmentation using ensemble model, increased the accuracy to 83 % to design tailored customer journeys. • Identified key factors affecting the low CR of the webshop using OLS regression model and provided the product team with relevant insights. • Identified and clustered high value driving customers groups using measures of variability and central tendency for strategic decision making and implemented in the company reporting Technologies : Python, SQL, Tableau ,Airflow ,Git, Databricks

trivago | Oct 2019 - Mar 2020

Data Analyst

Responsibilities: • Analyzed the performance of the advertisers on growth, daily activities and business development using the data exploration and statistical analysis • Monitored KPI’s, key business metrics and provide actionable insights by creating dashboard/charts on visualization tools like Salesforce (Einstein Analytics), Power BI for the Sales and Account Management team • Collaborating with Product owners, Data engineers and Account managers for defining data strategy in order to respond to the user data needs Achievements: • Delivered an interactive heatmap chart in Salesforce (Einstein Analytics) for Sales and Account team to effectively optimize the advertising spends • Created the logic using SQL for internal data categorization to automate the update of business metrics Technologies : Hadoop, Hive, Impala, SQL, Python, Salesforce (Einstein Analytics), Power BI

Societe Generale Corporate and Investment Banking - SGCIB | Jul 2018 - Dec 2018

Data Scientist

Subject :Technical analysis of financial market volatility using Data Science Role: -Projects with the FX sales Desk and performed data analysis on forex data -Created an algorithm to classify the volatility according to the market’s behaviour -Created dashboards, graphs to visualize the trend of volatility in the market - Technologies : Python, Pandas, Numpy, Scikit-learn, Matplotlib

My Education

Take a look at my formal education

ESSEC | CentraleSupélec - Master Data Sciences & Business

Master of Science - MS, Data Science and Business AnalyticsAnalytics | 2019

Master of Engineering - MEng, Computer Systems EngineeringLancaster University | 2016

About Me

Pankaj hasn't filled in a bio text

Create Your Data Portfolio for Free