Shashwat Shankar

Data Engineer

Allahabad, Uttar Pradesh, India4 yrs 10 mos experience

Key Highlights

Reduced manual data checks by 80% through automation.
Improved ad efficiency by 30% with a recommendation system.
Achieved 30% improvement in ESG reporting accuracy.

Stackforce AI infers this person is a Data Analyst with expertise in Marketing Analytics and ESG Reporting.

Contact

Skills

Core Skills

Data AnalysisRecommender SystemsStatistical Data AnalysisNatural Language Processing (nlp)

Other Skills

Analytical SkillsDeep LearningExploratory Data AnalysisGCPGitHubIrDAMachine LearningManagementMarket ResearchMongoDBPyTorchPython (Programming Language)ResearchSPSSSQL

About

At ShyftLabs, developed an automated anomaly detection system, reducing manual data checks by 80% and shortening issue detection time by 60%. Built a recommendation system that improved ad efficiency by 30%, increasing user engagement and ROI. Engineered a unified campaign-level data model to align metrics across platforms, enhancing data reliability and decision-making. Previous roles at Lloyds Technology Centre and TransUnion focused on ESG reporting and marketing analytics, leveraging advanced statistical techniques and tools like DBT and SQL. An MBA from IIIT complements technical expertise, enabling impactful data-driven strategies and fostering regulatory alignment. Committed to delivering actionable insights and optimized solutions through collaboration and innovation.

Experience

4 yrs 10 mos

Total Experience

1 yr 2 mos

Average Tenure

Current Experience

Shyftlabs

2 roles

Analytics Engineer

Oct 2024 – Jun 2025 · 8 mos

Developed an automated anomaly detection system using a 14-day moving average, enabling real-time alerts. Reduced manual data checks by 80% and cut issue detection time by 60%, boosting data reliability.
Led a POC to evaluate attribution accuracy between video and display ads, revealing 25% higher conversion reliability for display ads.
Created a recommendation system to improve low-performing ad items, boosted ad efficiency by 30%, driving higher engagement and better ROI on underperforming assets.
Conducted a POC to analyze the relationship between impressions and clicks, identifying a 20% gap in expected CTR for underperforming ads.
Engineered a unified campaign-level data model to align metrics across platforms, reducing reporting inconsistencies by 40% and accelerating insights generation by 50% for marketing stakeholders.

Python (Programming Language)SQLGitHubMongoDBData AnalysisRecommender Systems+1

Analytics Engineer

Oct 2024 – Jun 2025 · 8 mos

Lloyds technology centre india

Data Analyst

Feb 2024 – Sep 2024 · 7 mos · Hyderabad, Telangana, India · Hybrid

As part of ESG, calculated carbon emissions using Bigquery that collateral is producing for a
bank.
Normalised data using ER/Studio to create delta files for carbon emission calculations at the
building level.
Identified emission hotspots across portfolios, enabling a 30% improvement in reporting
accuracy and regulatory alignment.
Developed automated data pipelines using python to track changes in building-level emissions
over time, enabling 35% more timely insights for ESG compliance and strategic
decision-making.
Created DOD and DOR for analytical workflows, achieved a 25% faster turnaround and 40%
reduction in rework, enhancing overall efficiency and data quality.

Data AnalysisSQLPython (Programming Language)Secondary ResearchIrDA

Transunion

Analyst

Sep 2021 – Jan 2024 · 2 yrs 4 mos · Hyderabad, Telangana, India

Part of a Customer Analytics team, we design Marketing Mix Models (MMM) helps client understand contribution through media tactics , generate predicted revenue based on a future media plan , run optimization to allocate media budget and maximise revenue which uses advance statistical techiques, logistic regression etc.
Extract and transform heterogenous data sources including marketing agencies and third-party data to create integrated panel data with upto thousand variables and work closely with statisticians and strategy team to define the required variables.
Performing advance cleansing, exploratory data analysis, identifying data issues, and data validation to ensure the accuracy, quality and integrity of data for model development using complex Spark, SQL and python queries on the GCP platforms.
Managing multiple projects and working cross functionally with Consultants, Data Strategist and Technical Managers on different projects.
Support team initiatives, including on-boarding training of new employees and mentoring associates.

GCPPython (Programming Language)TableauStatistical Data Analysis

Leading edge communication pvt.ltd

Data Analyst

Jun 2020 – Sep 2021 · 1 yr 3 mos

Worked on a full-fledged product that downloads 50+ Indian ePapers (all languages) using Selenium Web driver and extracts newspaper cutouts from pdf using OpenCV. Further, the articles are processed to extract headline, author, and other relevant information to generate a collection with 20+ columns daily to act as a database for a live website. Tech Stack used: Beautiful Soup, Selenium, Amazon S3, MongoDB, OpenCV.
Built a service in Python to extract contact details from web for any company with its name as input using Beautiful Soup and Selenium and store data in MongoDB for further use. Tech Stack used: Beautiful Soup, Selenium, MongoDB.
Built a model to detect sentiment expressed through various news media like tweets, Print, Online articles and TV using NLTK library for text pre-processing and Naive Bayes Classifier for classification using supervised machine learning.
Built a module where data is collected from API like twitter and YouTube, then visualize the data according to the requirement of reports required for the project. Tech stack used: Tweepy, TextBlob, Flair, Vader sentiment, NLTK.
Worked on a project that is built to visualize data for various forms of news media i.e., Print, TV, Social
networks like Twitter. Tech stack used: Matplotlib, Seaborn, Ms-Excel.

Natural Language Processing (NLP)SQLStatistical Data AnalysisExploratory Data AnalysisPython (Programming Language)