Deepankar

PROFESSIONAL EXPERIENCE Adobe Noida, India Customer Insights Specialist November 2022 – Present IHS Markit Noida, India Senior Technical Business Analyst March 2022 – November 2022

• Automated multiple processes using python

• Linked multiple sources and created efficient solutions for complex problems

• Prepared, maintained and owned multiple Power BI Desktop Dashboards

• Published multiple dashboards to Power BI server and managed the server for senior leadership BizOps Senior Analyst December 2020 – March 2022

• Automation - multiple process automated using extensive use of python. From data preparation to data manipulation, everything went through python.

• PostgreSQL – persisting all data into postgre via python and connecting & scheduling tableau desktop workbooks to postgre.

• Script Scheduling - multiple python scripts scheduled to run daily at the backend, allowing the user to multitask.

• Web Crawler – a web-crawler was created in python for a portal based on company network, fulfilling the client requirements without any manual intervention.

• Tableau Server & Prep – explored and learnt the usage of tableau server & prep, using it in day-to-day activities. BizOps Analyst July 2019 – December 2020 • Data Extraction, Data Cleaning & Data Preparation – Extracting data from multiple sources (MySQL, Salesforce, etc.), cleaning it as per the requirement and preparing the data to be analyzed.

• Automation – multiple processes were automated in python, which were otherwise done manually in excel. Processes initially taking 2-3 hours would now take less than 5 minutes, post the automation in python.

• Built forecasting models – Predicting revenue generation for future months/years were done in python using linear regression, ARIMA, SARIMA, Prophet, CAGR, etc.

• Tableau – built 100+ customizable, fully automated, client specific & Executive level dashboards using Tableau Desktop & Tableau Server.

• Power BI – built certain views/dashboards in Power BI as per the client requirement. DMI Finance New Delhi, India Data Analyst June 2018 – June 2019

• Data Cleaning & Data Preparation – Missing value imputation, outlier treatment, Exploratory Data Analysis (EDA) on continuous & categorical variables

• Built a classifier model – using Natural Language Processing (NLP) to classify products based on their respective categories

• Writing and executing queries in Athena – an Amazon Web Service(AWS)

• Web Scraping & Google APIs – Scraped data from various websites and read the required data into Python. Invoked APIs (in Python) such as Distance Matrix and generating latitudes & longitudes for various places

• Model Deployment – Deployed model developed on Amazon server to fetch results in real time

• Tableau – Analyzed and published multiple reports using various features (including maps) of Tableau Desktop & Tableau Online