AJITH NAGARAJAN

• Worked directly with IRAS clients to deliver the data solutions
• Developed a Blob File Migration Framework using the Powershell scripts.
• Developed recon framework for file migration and Table migration recon's
• Developed a strong understand of ETL framework ADF pipelines
• Enhanced SQL query performance
• Improved cost optimization strategies through data-driven enhancements
• Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
• Designed and implemented effective database solutions and models to store and retrieve data.
• Analyzed complex data and identified anomalies, trends, and risks to provide useful insights to improve internal controls.

• I developed a 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
• Technologies Used included:

1. Azure Data Factory

2. Azure Synapse

3. Hive

4. Sql Server

5. Python

• Achieved service time and quality targets.

• Worked directly with clients based in Sydney and Singapore to deliver data solutions
• Clients included:

1. Sydney Airport (Sydney)
2. Keystone (Singapore)
3. Scalene (Sydney)

• 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 the data to meet business needs
• Developed DIM and Fact tables in Snowflake to serve PowerBi reports efficiently
• Created PowerBI reports which delivered insights and information to key decision makers within the business
• Technologies Used included:

1. Azure Data Factory
2. Logic App
3. Snowflake Data Warehouse
4. Power Bi Desktop and Report Builder

• 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.