Summary
Overview
Work History
Education
Skills
Contact Information
Languages
Personal Information
Residence
Timeline
Generic
Saranya Bakkiyanathan

Saranya Bakkiyanathan

Chennai

Summary

Data Engineer with over 7 years of expertise in Snowflake, PLSQL, and Python, executed complex ETL process migrations. Proven ability to solve complex problems, collaborate with teams, and drive successful project outcomes. Dedicated to ongoing learning and growth.

Overview

7
7
years of professional experience

Work History

PLSQL Developer

Capgemini India Pvt. Ltd.
Chennai, Tamil Nadu
11.2024 - Current
  • Developed stored procedures to process real-time and batch data for BI projects.
  • Coordinated with data modelers to ensure seamless integration of analytics requirements.
  • Modified existing code based on evolving business needs for improved functionality.
  • Executed new developments requested by analytics and product owner to enhance project outcomes.

Snowflake Developer

Capgemini India Pvt. Ltd.
Chennai
02.2023 - 12.2023
  • Migrated guest data and other domains, including Casino and Hotel, to Snowflake.
  • Developed SQL procedures, scripts, tasks, and streams as a Snowflake developer.
  • Addressed Airflow DAG issues to ensure smooth project operations.
  • Utilized CI/CD pipeline within Agile project framework to enhance development efficiency.

Snowflake Developer

Capgemini India Pvt. Ltd.
Chennai, Tamil Nadu
01.2022 - 01.2023
  • This project Integrated consumer products and licensing across various domain - Retail, Finance, Product
  • Migrated ETL processes from DB2 using Informatica to Snowflake.
  • Gathered requirements and developed jobs in UC4 based on Informatica mappings for data loading into Snowflake.
  • Designed and developed fact and dimension tables essential for visualization.
  • Enabled UC4 jobs in production, UAT, and staging environments, monitoring results through reports.
  • Facilitated discussions with clients to analyze development requirements and manage incidents via Jira.
  • Converted shell scripts into SnowSQL with modifications as per client specifications.
  • Developed SnowSQL scripts while validating data between DB2 and Snowflake.

Snowflake Python Developer

Capgemini India Pvt. Ltd.
Chennai, Tamil Nadu
10.2021 - 12.2021
  • This project is a Snowflake migration project to replace the Application developed Using Java Spring Framework
  • Wrote configuration files for Snowflake Stage integration and SQL scripts for data loading.
  • Used AWS DynamoDb for avoiding reprocessing file.

Python Developer

Infosys Ltd
02.2020 - 05.2021
  • Worked as a python developer for a python CLI(command line interface) tool. The objective of the tool is to Automate the validation of stored procedures.
  • Tool is developed based on python and Django framework for enabling automated way of functional testing.
  • User will provide the information in excel sheet as input and with the help of pandas will read the data and process it in python script and send the required data to Django using REST API’s.
  • For debugging purpose, implemented logs with different logginglevels (debug, info, warning, error and exception).
  • Followed Agile scrum in creating and picking up the user stories.
  • Technology used in project: Python – Django (Backend)
  • Environment: Database Related: DB2

Python Developer

Infosys Ltd
06.2019 - 01.2020
  • Project is a web based Automation tool which is used to perform data validations in ETL, migration and big data projects.
  • The features of a tool includes comparison, DB Connection, query playground, Sanity Checks, Batch mode and Test cases
  • Worked on Sanity Checks module which is used for performing different data checks such as null, duplicate checks.
  • Worked on DB Connection module for connecting to different database servers.
  • Worked on testcase modules to add, delete, display saved testcases.
  • Technology used in project: Python, SQL
  • Environment: Database Related: MSSQL, MYSQL, DB2, Sybase, Operating System: Windows 8

Pyspark Developer

Infosys Ltd
11.2018 - 06.2019
  • This project is a Cloud migration of real time data from AWS S3 to Redshift DB using pyspark
  • The project involves processing the large data stored in S3 object(xml, , csv) in parallel using spark standalone clusters.
  • Created different parsers to copy the processed data into Redshift using the copy command. Created different functionalities as an alternative to stored procedures.
  • Migrated Historical Data from SQL server to AWS S3 by analyzing stored procedures and tables.
  • Technology used in project: Pyspark
  • Environment: Database Related: AWS Redshift, ETL: Pyspark, AWS S3

Education

Bachelor of Engineering - Electronics and telecommunication

Vel Tech Multi Tech Dr. Rangarajan Dr. Sakunthala Engineering College
Tamil Nadu, India
06.2018

Skills

  • programming: Python, PL/SQL
  • Operating systems: Windows, Ubuntu
  • Database management: MySQL, DB2, MSSQL Server, Oracle
  • Cloud computing: AWS S3,EC2,Redshift,SNS
  • Data warehousing: Snowflake

Integrated development environments: Eclipse, Spyder, PyCharm, Visual Studio

  • Web development: HTML and CSS

Contact Information

+91-9566293258, saranyabprofession96@gmail.com

Languages

  • English
  • Tamil
  • Hindi

Personal Information

  • Date of Birth: 08/04/96
  • Gender: Female
  • Nationality: Indian
  • Marital Status: Married

Residence

Chennai, Tamil Nadu, India

Timeline

PLSQL Developer

Capgemini India Pvt. Ltd.
11.2024 - Current

Snowflake Developer

Capgemini India Pvt. Ltd.
02.2023 - 12.2023

Snowflake Developer

Capgemini India Pvt. Ltd.
01.2022 - 01.2023

Snowflake Python Developer

Capgemini India Pvt. Ltd.
10.2021 - 12.2021

Python Developer

Infosys Ltd
02.2020 - 05.2021

Python Developer

Infosys Ltd
06.2019 - 01.2020

Pyspark Developer

Infosys Ltd
11.2018 - 06.2019

Bachelor of Engineering - Electronics and telecommunication

Vel Tech Multi Tech Dr. Rangarajan Dr. Sakunthala Engineering College
Saranya Bakkiyanathan