Summary
Overview
Work History
Education
Skills
Certification
Timeline
background-images

Sateesh Kumar Chillakuru

Toronto,Canada

Summary

Accomplished Senior Data Engineer with experience designing and optimizing cloud data architectures on Microsoft Azure and Big Data Hadoop. Skilled in optimizing ETL workflows, developing Data pipelines, and driving business insights through data-driven solutions in complex environments. The AI Enthusiast.

Overview

22
22
years of professional experience
1
1
Certification

Work History

Azure Data Engineer, Big Data & Data Science

TCS Canada Inc - Client: ROGERS Communications Inc
04.2019 - Current
  • Enhanced BI capabilities by designing data solutions using Azure Databricks.
  • Streamlined data extraction with ADF and Databricks for various sources.
  • Collaborated with Data Scientists to optimize datasets for machine learning.
  • Optimized Azure infrastructure, supporting high-volume data processing needs.
  • Improved forecast accuracy by 25% through predictive model integration.
  • Developed Power BI reports, incorporating machine learning insights for users.

Big Data Engineer

TCS Canada Inc -BMO, Capital Market Customer Information
12.2018 - 03.2019
  • Developed a comprehensive migration plan for Netezza Data Model & Scripts.
  • Created Hive/HQL Scripts for daily data loads and Sqoop for one-time loads.
  • Implemented SCD Type 2 logic for customer data and optimized SQL reads.
  • Applied data warehousing techniques including ETL processes and schema design principles.
  • Led CMCIF Migration project using Hortonworks, Hive, and Informatica technologies.

Big Data Engineer

TD Bank, Risk Management Credit Cards
08.2018 - 11.2018
  • Streamlined Mainframe SAS-JCLs, reducing jobs and optimizing monthly scheduling.
  • Developed data models and built Hive data mart for SAS and SQL datasets.
  • Created interactive Tableau dashboards with various visualizations for user engagement.
  • Utilized Talend and Sqoop for efficient data import from Oracle and SQL Server.

Big Data Engineer

TELUS, Technology Strategy, Telecom
08.2017 - 10.2017
  • Developed data model for Big Data Lake, enhancing data processing efficiency.
  • Designed interactive dashboards with diverse widgets for comprehensive data visualization.
  • Executed data filtering, cleansing, and aggregation within Hive tables effectively.
  • Utilized Hadoop and related tools to optimize RAID ETL dashboard performance.
  • Streamlined data management processes using Oozie and UNIX environments.

Big Data Engineer

Deloitte - End Client: Metrolinx (Go Transit)
05.2017 - 06.2017
  • Enhanced data integration into Hive through effective cleansing and transformation.
  • Developed static reference tables in Hive for efficient data lookups.
  • Automated data loading into HDFS using Oozie workflows for pre-processing.
  • Monitored Cloudera Manager to ensure system reliability and address issues promptly.
  • Contributed to creating User Manual documents for seamless data ingestion processes.

Big Data Engineer

Citi Bank- Fraud Detection System (AML) L&T Infotech
10.2015 - 01.2017
  • Facilitated requirements gathering with architects and validated test results with users.
  • Created high and low-level design documents, developing partitioned Hive tables.
  • Enhanced AVRO data processing speed by developing Spark-SQL code in Java.
  • Executed comprehensive testing phases, validating unit and SIT results effectively.
  • Optimized Spark jobs through collaboration with developers and system support teams.
  • Led VALLAR NG project focused on AML and internal fraud detection.

Mainframe Lead

CIBC Canada. IBM India
01.2014 - 07.2014
  • Environment: Mainframes-Dev&Test- COBOL, SAS-JCL, DB2, IMS-DB

Mainframe Test Lead

Bank of America -IBM India
01.2013 - 12.2013
  • Environment: Mainframes-Dev&Test-PL/1, COBOL, SAS-JCL, DB2, IMS-DB, Informatica
  • Project: Securities Information System (SIS) Canada-

Mainframe Test Lead

SIS Canada -IBM Canada Inc
12.2008 - 12.2012
  • Environment : Mainframes-Dev&Test-PL/1, COBOL, SAS-JCL, DB2, IMS-DB, Informatica
  • Project: Securities Information System (SIS) Canada

Mainframe Dev Lead

IBM, AMEX, Sprint Nextel - IBM India
04.2004 - 11.2008
  • Environment :Mainframes-Dev & Enhancements- PL/1, COBOL, JCL, DB2, IMS-DB, CICS and SCM
  • Project: CEDS (Customer Engineering Data Server)

Education

M.Sc. - Master of Science- Statistics

Skills

  • Frameworks & Cloud: Azure Databricks/Spark, AWS, Cloudera Hadoop, Kafka, Azure AI & ML, SAS & Mainframes
  • Programming: PySpark, Scala, SQL, HQL, SAS, Unix, R, Core Java, COBOL, PL/1, JSON & JCL
  • Database & Tools: Azure Data Lake, ADF, Databricks Lakehouse, Snowflake, Power BI, HIVE, DB2, Oracle & MySQL
  • Utilities & Software: GitHub, Jenkins CI/CD, Eclipse, Intellij, Autosys, Jira, Erwin, Control M

Certification

  • Microsoft Certified: Azure Fabric Data Engineer Associate 2025
  • Microsoft Certified: Azure AI Engineer Associate 2025
  • Microsoft Certified: Azure Data Scientist Associate 2024
  • Databricks Certified: Generative AI Fundamentals 2024
  • Databricks Certified: Associate Developer for Apache Spark 2023
  • Microsoft Certified: Azure Data Engineering 2022
  • AWS Certified: Cloud Practitioner 2021
  • Machine Learning Specialization: Coursera (Stanford University) 2020
  • Cloudera Certified: Hadoop Developer (CCDH) 2014

Timeline

Azure Data Engineer, Big Data & Data Science

TCS Canada Inc - Client: ROGERS Communications Inc
04.2019 - Current

Big Data Engineer

TCS Canada Inc -BMO, Capital Market Customer Information
12.2018 - 03.2019

Big Data Engineer

TD Bank, Risk Management Credit Cards
08.2018 - 11.2018

Big Data Engineer

TELUS, Technology Strategy, Telecom
08.2017 - 10.2017

Big Data Engineer

Deloitte - End Client: Metrolinx (Go Transit)
05.2017 - 06.2017

Big Data Engineer

Citi Bank- Fraud Detection System (AML) L&T Infotech
10.2015 - 01.2017

Mainframe Lead

CIBC Canada. IBM India
01.2014 - 07.2014

Mainframe Test Lead

Bank of America -IBM India
01.2013 - 12.2013

Mainframe Test Lead

SIS Canada -IBM Canada Inc
12.2008 - 12.2012

Mainframe Dev Lead

IBM, AMEX, Sprint Nextel - IBM India
04.2004 - 11.2008

M.Sc. - Master of Science- Statistics

Sateesh Kumar Chillakuru