Summary
Overview
Work history
Education
Skills
Certification
Projects
STRENGTHS
Languages
Timeline
Generic

Saikat Dey

Northampton,Northamptonshire

Summary

A data analysis specialist with expertise in data modelling, SQL, and data cleaning, proficient in Pyspark and Python programming. Demonstrates strong analytical skills and experience with Hadoop and Hive for effective data warehousing solutions. Skilled in machine learning using R programming and Python, with the solid foundation in databases such as MySQL, Oracle, and SQL Server. Adept at working across Linux and Windows XP operating systems to optimize data processes. Committed to leveraging technical skills to drive impactful insights and support strategic decision-making within organizations.

Overview

10
10
years of professional experience
4
4
years of post-secondary education
1
1
Certification

Work history

Senior data analyst

Capgemini UK
Northampton, Northamptonshire
04.2023 - 08.2025
  • Collaborated closely with business units to analyse current product release flow.
  • Delivered tailored SAS solutions through thorough understanding of business rules.
  • Executed comprehensive testing on regulatory reports leveraging SAS and Hive tools.
  • Managed migration tasks, focusing on optimization of SAS code.
  • Clarified complex concepts for stakeholders by removing technical jargon.
  • Fostered effective communication between SAS developers, testing teams, and Business Analysts.
  • Migrated data from Cloudera warehouse to open source Hadoop by using SQL achieving 20% cost reduction.
  • Optimized data transformation by migrating SAS ETL jobs to AWS EMR, cutting processing time by half.
  • Technologies used were Azure, Cloudera, Databricks, Spark and pyspark, hue, HDFS and Hive.

Data analyst

Capgemini India Private Limited
Bangalore
06.2021 - 04.2023
  • Served as Data analyst leading end-to-end cloud-based data solutions.
  • Developed and owned reporting with Python, SQL saving ~90 hours of monthly labor.
  • Optimized code for efficient output generation.
  • Created and executed jobs using SAS Studio.
  • Scheduled tasks via SAS Management Console to ensure timely execution.
  • Monitored job statuses with Flow Manager for operational oversight.
  • Addressed change requests to enhance project deliverables.
  • Provided SAS solutions tailored to specific business requirements.
  • Solid understanding of Evaluating Data Sources and understanding of Data Warehouse/Data.
  • Experience in descriptive analysis of data with SQL, Tableau & Python.

Associate manager

Standard Chartered Bank
Bangalore
04.2020 - 06.2021
  • Processed data from multiple sources like SAS , SQL , making it accessible in R server for KPI calculation, downstream analysis.
  • Automated web development tasks using Python and Selenium for improved efficiency processing efficiency by 40% and reducing infrastructure costs by 25%.
  • Design, build, and optimize data architecture and extract, transform, and load (ETL) pipelines to make them accessible for Business Data Analysts, and Business users to enable data-driven decision- making.
  • Involved in Data Exploration, Data wrangling/cleansing and deriving deeper insights from it through various channels like Python Pandas, NumPy, SQL.
  • Responsible for owning deliverables and driving them end to end, all way from gathering requirements, development, testing and deployment to ensure high availability post deployment.
  • Worked in variety of Data Ingestion process from source system(RDBMS,SFTP & API Endpoints).


Data analyst

Infosys
Bangalore
03.2019 - 03.2020
  • Developed rule-based fraud detection solution for major German grocery retailer.
  • Identified fraudulent transactions linked to cashiers and registers, mitigating revenue leakage.
  • Built algorithms for price lookup, receipt voiding, empties redemption, and suspended transactions.
  • Executed development in Agile model through structured sprint sessions.
  • Processed data from various sources and executed queries in SAS environment.
  • Automated code execution using shell scripts for AWS deployment.
  • Contributed to SAS migration from on-premise to AWS cloud, integrating diverse data sources.
  • Utilised technologies including SAS, SQL, Azure, Cloudera, Databricks, Spark, PySpark, HDFS, and Hive.

Associate system engineer

TCS
Pune
09.2015 - 02.2019
  • Led a team to develop reports tailored to client requirements for a major US banking and insurance client.
  • Utilized SAS Enterprise Guide , SQL and Excel for effective data visualization.
  • Interacted with stakeholders to gather comprehensive requirements and understand project scope.
  • Analyzed data from diverse source systems, implementing logic in SAS & SQL for report generation.
  • Extracted data from various sources like oracle SQL , SQL Server into SAS, facilitating accurate reporting processes.
  • Employed SAS macros to automate job execution, enhancing operational efficiency.
  • Accumulated 4.1 years of experience in banking and insurance domains, focusing on product data collection.
  • Delivered insightful reports and matrices to clients, highlighting trends in collected data.

Education

BACHELOR of ENGINEERING - Information Technology

Kalyani Government Engineering College
Kolkata
06.2011 - 06.2015

Skills

  • Primary Skill : Data Analysis Data Modeling SQL Data Cleaning Data Warehousing Analytical Skills PySpark Python (Programming Language) Hadoop Hive
  • Operating Systems: Linux, Win XP
  • Machine Learning: R programming, Python
  • Databases: MySQL, oracle , SQL server

Certification

  • SAS Certified Base Programmer from Pearson.
  • Appreciation by managers once in a month in TCS.
  • TCS Agile internal Course Completion.

Projects

Internship: building a project in asp.net and another project in php. Completed a project in image processing using matlab.

STRENGTHS

  • Creative, strong technical skills, good presentation and interpersonal skills, quick learner and maintains positive and competitive environment within the team.
  • Encourage continuous improvement through research, automation and process improvement.

Languages

English
Fluent

Timeline

Senior data analyst

Capgemini UK
04.2023 - 08.2025

Data analyst

Capgemini India Private Limited
06.2021 - 04.2023

Associate manager

Standard Chartered Bank
04.2020 - 06.2021

Data analyst

Infosys
03.2019 - 03.2020

Associate system engineer

TCS
09.2015 - 02.2019

BACHELOR of ENGINEERING - Information Technology

Kalyani Government Engineering College
06.2011 - 06.2015

Similar Profiles

Create profile
Saikat Dey