AJITH NAGARAJAN
Chennai
Summary
I am an IT professional with six years of full-time experience as a Data Engineer, specializing in developing and optimizing data solutions. I have a proven track record of delivering complex data projects, including data migration and ETL pipeline development, while ensuring 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
Senior Software Developer
IRAS-NCS
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.
Senior Data Engineer
IRAS - NCS
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:(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
- 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
- Data Engineering & Tools
- 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
- Programming & Scripting
- Languages: Python, PowerShell, NET
- Big Data Tools: Hadoop
- Version Control: Git
- Operating Systems: Linux,Windows
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
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)
Timeline
Senior Software Developer
IRAS-NCS
09.2024 - Current
Senior Data Engineer
IRAS - NCS
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
AJITH NAGARAJANAJITH NAGARAJAN
Senior Data Engineer at IRAS - NCSSenior Data Engineer at IRAS - NCS
AJITH NAGARAJANAJITH NAGARAJAN
Senior Data Engineer at IRAS - NCSSenior Data Engineer at IRAS - NCS
AJITH NAGARAJANAJITH NAGARAJAN
Senior Data Engineer at IRAS - NCSSenior Data Engineer at IRAS - NCS