Vivek Chattopadhyay
Data Strategy - Business Intelligence, Analytics And Data Science
Bengaluru,India
Summary
Astute, calculating and attentive to specific business requirements. Having 4+ years of experience in machine learning,reporting systems, and dashboard building. Keen in identifying patterns, making interpretations and producing reports. Skills setting up databases,data quality and engineering,analytics framework,prediction framework,managing systems and aligning procedures with business needs.
Overview
5
5
years of professional experience
22
22
years of post-secondary education
Work History
Data Strategist - Global BI Analyst
MiQ Digital Pvt. Ltd.
09.2022 - 07.2023
- Interpret business requirements into actionables and worked through the AGILE process to deliver them at every stage from development through testing and staging and lastly pushing to production.
- Analyzed, optimized and re-engineered existing data collection techniques, ETL pipelines, and dashboard data models using SQL, python and pyspark (using the databricks interface) and stored data in S3 datalake.
- Orchestrated and managed ETL jobs using databrick's scheduler tool for daily/monthly and weekly data refresh pipelines.
- Worked on sourcing and maintaining multiple lookup excel files from different teams and created/modified mapping logic upon the existing data in the OLAP cube.
- Created and maintained multiple materialized views in postgresDB (Used for analytics) to facilitate faster data reading into looker and other dashboarding platforms.
- Developed an entire framework on an end-to-end basis based on data provided in google sheets. The same was collected using the GSheets Python API, created and orchestrated ETL pipelines using pyspark in databricks and delivered the same in a form of dashboard built in Looker.
- Worked on creating an open pipeline to bring Netflix Ad Campaigns data from multiple DSPs across global regions and developed KPIs like Month on Month Revenue and Profit from Netflix Ad Campaigns along with their growth in Looker dashboard.
- Created documentations for multiple technical use cases to ensure transparency and easy to grasp concepts used in different frameworks for reference and learning.
- Worked with senior leaders to improve on data management practices, introduced bi-weekly data audits to ensure data accuracy while keeping data drifts on check.
- Worked with the team proactively to hunt for bugs in code, Performed RCA and maintained,fixed and updated several outdated logics in legacy python and lookML codes.
- Performed ad hoc data transformations, stored and maintained data in Amazon S3 datalake.
Associate - Data Science and Analytics
GALE Partners
01.2021 - 06.2022
- Maintained communications with clients and internal teams to understand the business problem, and developed data models and analysis strategies to find relevant insights and answers for BI reporting and relevant ad-hoc requirements.
- Performed Survival Analysis to measure out purchase volatility for a casino based client.
- Created NPS (Net Promoter Segments) Segments to cluster customers based on the reviews given on different channels and extracted Sentiment Scores from different Customer Review based data.
- Created and published performance reports on a monthly basis for a restaurant based client on different campaigns launched via salesforce and performed Hypothesis Testing to account for increasing sales and their relationship amongst those campaigns.
- Automated processes for data mining and reporting on an ongoing basis and created scheduled pipelines using CRON.
- Created ML-based ETL pipelines to filter out profane words on different text-based datasets using Python and Spacy.
- Created BI Reports for different client requirements using Tableau and Google Data Studio. Performed EDA and Data Quality analysis daily using python and sql to maintain data-health and structures.
- Created various master views and analytical base tables that would be used later in BI reporting using SQL (Amazon Redshift).
- Helped in optimization of Tableau dashboards,ETL pipelines and Amazon Redshift database for lowering ingestion lags and reducing load-times for data delivery in different use cases.
- Performed multiple data modelling tasks in AWS Redshift and deployed ML models in EC2 to backfill data on a periodic timeline.
Data Scientist
Trell Experiences Pvt. Ltd.
02.2019 - 08.2020
- Created Creators Insights Dashboard for Trell App, to enable personalized analytics to creators in the Trell Platform.
- Used Natural Language Processing, Topic Modelling and Naive-Bayes Classifier to tag Platform and User Generated content.
- Actively worked on building OLTP and OLAP frameworks for Trell using Clickhouse ,MySQL and Firebase Databases.
- Fetched,Parsed,Structured and Scraped Data from many 3rd Party APIs using python's request library.
- Hands on experience in using Flask to create Data APIs and Reporting APIs using Python. Data Engineering using MySQL, ClickHouse, pyspark and Pandas for Building ETL Pipelines.
- Web-Scraping Data using BeautifulSoup and Selenium. Worked on automations for automating reports and scheduling tasks using python. Worked with Google API for data mining and Google Drive Management.
- Worked with Product Managers in creating the Product Analysis Reports.
- Used KMeans Clustering Algorithm to segment customers and content in Trell platform for target marketing and performance insights.
- Deployed multiple data products (REST APIs and Plotly dashboards) in AWS EC2 and orchestration using CRON.
Customer Insights Analyst
GFactors OPC Pvt. Ltd.
06.2018 - 02.2019
- Identify and segment text & keywords from thousands of messages into relevant categories as given in guidelines.
- Interpret and tag content with respect to sentiment observed in the messages across social and web channels, without bias.
- Customer segmentation based on transactional, social, behavioral and other data analysis.
- Analyse text-based data (like email content and social media updates) to glean user and customer sentiment.
- Produce high volumes of accurate work output every day, within guidelines.
Education
Executive Post Graduate Programme - Data Science And Machine Learning
University of Maryland
Online 08.2023 - Current
Data Structures And Algorithms: Using Python - Machine Learning
Udemy
Bengaluru 11.2021 - 06.2022
Master Statistics & Math For Machine Learning - Machine Learning
Udemy
Bengaluru 12.2021 - 06.2022
Machine Learning A-Z : Python And Data Science -
Udemy
10.2017 - 12.2017
Python:Data Science And Machine Learning Bootcamp -
Udemy
10.2017 - 12.2017
Introduction To Finance, Accounting And Modeling -
Udemy
01.2018 - 03.2018
Post-Graduate Diploma -
Bhawanipore Education Society, Calcutta University
08.2017 - 08.2017
Certified in Retail Management Under Prime Minister Kalyan Vikas Yojana Programme, Certificate Issued ByMinistry of Skill Development And Entrepreneurship, Government of India -
Brainware Institute, Salt Lake
06.2015 - 03.2017
Bachelor - Accounting And Finance
Bhawanipore Education Society, Calcutta University
04.2014 - 07.2017
School (Junior,ICSE & ISC) -
Don Bosco High And Technical School, Liluah,Howrah
Liluah, West Bengal 01.2000 - 05.2014
Skills
MS-Word
Tableau
Data ProcessingPythonSQLStatisticsNLP
Automation
Dashboard Building
Machine Learning
ETL
Big Data
Amazon Redshift
Google BigQuery
AWS
Accomplishments
- Exploratory Data Analysis On Crypto-Currencies (Personal Capstone Project).
- Simple Linear Regression in Python Using Jupyter Notebook (Personal Capstone Project).
- Simple Logistic Regression in Python Using Jupyter Notebook (Personal Capstone Project).
- Employee Attrition Prediction (Personal Capstone Project).
- Web Scraping a Weather Forecast Data (Personal Capstone Project).
- Creating a Dashboard using MS-Excel (Personal Capstone Project).
- Creating a Database and Querying using SQL and MS-Access (Personal Capstone Project).
- Linear Regression For Predicting House Prices (Personal Capstone Project).
Timeline
Executive Post Graduate Programme - Data Science And Machine Learning
University of Maryland
08.2023 - Current
Data Strategist - Global BI Analyst
MiQ Digital Pvt. Ltd.
09.2022 - 07.2023
Master Statistics & Math For Machine Learning - Machine Learning
Udemy
12.2021 - 06.2022
Data Structures And Algorithms: Using Python - Machine Learning
Udemy
11.2021 - 06.2022
Associate - Data Science and Analytics
GALE Partners
01.2021 - 06.2022
Data Scientist
Trell Experiences Pvt. Ltd.
02.2019 - 08.2020
Customer Insights Analyst
GFactors OPC Pvt. Ltd.
06.2018 - 02.2019
Introduction To Finance, Accounting And Modeling -
Udemy
01.2018 - 03.2018
Machine Learning A-Z : Python And Data Science -
Udemy
10.2017 - 12.2017
Python:Data Science And Machine Learning Bootcamp -
Udemy
10.2017 - 12.2017
Post-Graduate Diploma -
Bhawanipore Education Society, Calcutta University
08.2017 - 08.2017
Certified in Retail Management Under Prime Minister Kalyan Vikas Yojana Programme, Certificate Issued ByMinistry of Skill Development And Entrepreneurship, Government of India -
Brainware Institute, Salt Lake
06.2015 - 03.2017
Bachelor - Accounting And Finance
Bhawanipore Education Society, Calcutta University
04.2014 - 07.2017
School (Junior,ICSE & ISC) -
Don Bosco High And Technical School, Liluah,Howrah
01.2000 - 05.2014