Summary
Overview
Work History
Education
Skills
Professional Links
Languages
Awards & Recognitions
Certification
Timeline
Generic

AJITH NAGARAJAN

Chennai

Summary

I am an IT professional with six years of full-time experience as a Software Engineer, specializing in application development and optimizing data solutions. I have a proven track record of delivering complex projects including data migration, ETL pipeline and application development, focused on high performance, data integrity, and scalability. Skilled in collaborating with international clients across multiple time zones, including Singapore and Sydney, with a strong focus on clear communication and effective problem-solving. Passionate about continuous learning, team mentoring, and leveraging data-driven insights to drive business value. Committed to delivering high-quality, efficient, and scalable data solutions that contribute to business success.

Overview

6
6
years of professional experience
1
1
Certification

Work History

Software Engineer

IRAS - PERSOKELLY Singapore Pte Ltd
09.2024 - Current
  • Production Incident Management: I handle production incidents promptly, ensuring swift resolution. This includes managing data patches or data extraction for investigations, providing essential support to the team to identify and resolve issues efficiently.
  • Support for User Queries and Incident Resolution: I provide continuous support to users, assisting with their queries and ensuring the timely resolution of production incidents to maintain smooth operations.
  • Automation and Process Optimization: I led the automation efforts for Corres Domain batch jobs and operational recurring DER’s, streamlining processes to improve operational efficiency. In addition, I collaborated with external vendors, to resolve file and notification issues, ensuring smooth data flows and communication.
  • End-to-End Reconciliation for Major Activities: I am actively involved in the end-to-end reconciliation process for major activities, ensuring that data is accurately reconciled, and issues are addressed promptly to ensure data integrity.
  • Daily Operational Reconciliation: I oversee daily common operational tasks, including performing end-to-end reconciliation to ensure the consistency and accuracy of operational data.
  • Developed and managed a PowerShell script to securely clean up 60 million View Corres documents on the staging server for AB2024.
  • Supported Production Ref Table Sync for NCS Domain Ref Tables using Azure Data Factory.
  • Provided technical support to the Reports Team, troubleshooting complex queries, Views, Stored Procedures (SP), and optimizing Azure Data Factory (ADF) workflows.
  • Technologies Used included: (.Net, C#, Angular, Azure Data Factory, Azure Blob Storage, IBM DB2, Sql Server, Python, Powershell Scripting,Git)

Data Engineer

IRAS - PERSOKELLY Singapore Pte Ltd
03.2023 - 09.2024
  • Worked directly with IRAS clients to deliver the data solutions, ensuring alignment with business requirements and technical specifications.
  • Designed and implemented a Blob File Migration framework using PowerShell scripts, optimizing the migration process of large datasets across diverse environments for enhanced efficiency and reliability.
  • Developed a reconciliation framework for both file and table migrations, ensuring data accuracy and consistency during the migration process.
  • Developed a strong understand of ETL framework ADF pipelines
  • Enhanced SQL query performance by identifying bottlenecks and implementing optimizations, resulting in faster data retrieval and improved pipeline efficiency.
  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
  • Provided mentorship, guidance, and technical support to team members, fostering a collaborative and productive work environment.
  • Managed end-to-end data engineering projects, from conception to implementation, ensuring adherence to timelines and quality standards.
  • Technologies Used included: (Azure Data Factory, Azure Blob Storage, IBM DB2, Sql Server, Python, Powershell Scripting,Git)

Associate Projects, Data Engineer

Kaiser Permanente - CTS
10.2022 - 02.2023
  • Developed strong understand of ETL framework pipelines
  • Worked directly with clients based in USA to deliver data solutions
  • Carried out day-to-day duties accurately and efficiently
  • Learned new skills and applied to daily tasks to improve efficiency and productivity
  • Used critical thinking to break down problems, evaluate solutions and make decisions
  • Used coordination and planning skills to achieve results according to schedule
  • Achieved service time and quality targets.
  • Technologies Used included: (Azure Data Factory, Azure Synapse, Sql Server, Python,Hadoop)

Senior Software Consultant

BI3 Technologies
12.2018 - 09.2022
  • Worked directly with clients based in Sydney and Singapore to deliver data solutions
  • Clients included: (Sydney Airport, Keystone -Singapore)
  • I developed a strong understand of ETL frameworks (i.e. Standardized patterns and frameworks that create consistency and efficiency for both developers and operations)
  • Developed data pipelines which ingested data from multiple platforms and then transformed and joined data to meet business needs
  • Developed DIM and Fact tables in Snowflake to serve Power Bi reports efficiently
  • Created Power BI reports which delivered insights and information to key decision makers within business
  • Developed team communications and information for meetings
  • Achieved service time and quality targets
  • Resolved customer queries and problems using effective communication and providing step-by-step solutions.
  • Technologies Used included:(.Net, C#, Python, Azure Data Factory, Logic App, Snowflake Data Warehouse, Power Bi Desktop and Report Builder, Hadoop, AWS, Git, Linux)

Education

Bachelor of Engineering - Electronics and Communication Engineering

MIET Engineering College
06.2018

Diploma - Electronics & Communication Engineering

MIET Polytechnic College
04.2015

Skills

  • Programming & Scripting: NET, C#, Angular, Python, PowerShell
  • Cloud Platforms & Services
  • Data Factory (Pipelines, Datasets, Triggers, Linked Services, Integration Runtime)
  • Logic Apps, Function Apps
  • Storage Account, Key Vault
  • Azure Kubernetes Service (AKS)
  • Azure Synapse Analytics
  • Azure SQL Server
  • Azure KQL
  • Data Base & Data Warehousing: Snowflake, Oracle, DB2, Azure SQL, Azure Synapse Analytics
  • ETL Development: Data Migration, Data Integration, Data Profiling, Data Mapping
  • Data Analysis: Power BI Report Builder
  • Big Data Tools: Hadoop
  • Version Control: Git
  • Operating Systems: Linux,Windows

Professional Links

  • Medium Blog - https://ajithnagarajan21.medium.com/
  • LinkedIn Profile - https://www.linkedin.com/in/ajith-nagarajan-9240841b1/

Languages

Tamil
Bilingual or Proficient (C2)
English
Bilingual or Proficient (C2)

Awards & Recognitions

  • NCS Heroes Award (IRAS TRIBE) - NCS Group (2024)
  • Star Performer of the Year - NCS Group (2023)
  • Shining Star of the Year - Bi3 Technologies (2022)
  • Star Performer of the Year - Bi3 Technologies (2021)

Certification

  • Azure Data Engineer Associate (DP 203)
  • AWS Certified Solution Architect - Associate

Timeline

Software Engineer

IRAS - PERSOKELLY Singapore Pte Ltd
09.2024 - Current

Data Engineer

IRAS - PERSOKELLY Singapore Pte Ltd
03.2023 - 09.2024

Associate Projects, Data Engineer

Kaiser Permanente - CTS
10.2022 - 02.2023

Senior Software Consultant

BI3 Technologies
12.2018 - 09.2022

Diploma - Electronics & Communication Engineering

MIET Polytechnic College

Bachelor of Engineering - Electronics and Communication Engineering

MIET Engineering College

Similar Profiles

CREATE PROFILE
AJITH NAGARAJAN