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