AADITYA KUMAR SINGH

Bengaluru,India

Summary

Accomplished Senior Data Management Analyst at Synechron Technologies, adept at optimizing ETL pipelines and enhancing data processing efficiency. Proven expertise in SQL and team leadership, driving significant improvements in anomaly detection and system performance. Committed to delivering high-quality data solutions through innovative strategies and collaborative efforts.

Overview

years of professional experience

Certification

Work History

Senior Data Management Analyst

Synechron Technologies

03.2024 - Current

Built and optimized alerting systems in Pega PRPC, improving real-time anomaly detection and reducing false positives.
Enhanced Oracle and Teradata ETL pipelines, increasing data processing speed by 25%.
Developed advanced SQL queries and stored procedures to support complex data transformations.
Collaborated with engineering teams to eliminate performance bottlenecks, reducing system downtime by 15%.
Led data validation and quality assurance for critical financial data assets.

ETL Developer

Empaxis Data Management India Pvt. Ltd.

12.2019 - 03.2024

Designed and implemented scalable ETL pipelines to process high-volume financial data.
Led a 6-member team responsible for data transformation, cleansing, and migration using Informatica and SQL.
Executed cloud migration projects involving structured flat files and Oracle databases to CouchDB.
Implemented Agile practices, conducted sprint demos, and managed JIRA workflows for task tracking.
Mentored new team members and delivered internal training on ETL tools and data quality techniques.

Education

Bachelor of Technology (B.Tech.) - Computer Science and Engineering

Supreme Knowledge Foundation Group of Institutions

Hooghly

05.2020

Skills

SQL
Java
Groovy
PEGA
JIRA
Jenkins
Git
Oracle
Teradata
CouchDB
AWS
Data validation

ETL Development
Data Integration
Data Migration
Data Warehousing
SQL query optimization
Stored Procedures
Data Cleansing
Normalization
Performance tuning
Agile Methodology
Scrum Methodology
Team leadership

Project Highlights

Alert Management & Data Optimization

Client: Commonwealth Bank of Australia
Company: Synechron | Mar 2024 – Present

Designed and implemented real-time monitoring alerts in Pega PRPC to track critical system metrics and proactively flag anomalies.
Customized alert thresholds to minimize false positives while ensuring immediate detection of performance degradation.
Engineered optimized SQL-based ETL pipelines across Oracle and Teradata, resulting in reduced data processing runtime and improved data accuracy.
Worked closely with DevOps and support teams to ensure continuous monitoring and zero-latency alert response for production systems.

ETL Management Integration Project

Client: CitiBank
Company: Empaxis | Nov 2021 – Mar 2024

Led the design and development of robust ETL mappings to transfer data from flat files and Oracle source systems into downstream data warehouse structures.
Developed and fine-tuned SQL stored procedures, database views, and complex data logic to streamline ingestion and transformation workflows.
Utilized JSON-based data loaders for integrating datasets into CouchDB, ensuring compatibility with NoSQL architecture.
Partnered with data scientists and analysts to ensure high-quality, clean data delivery for business intelligence and predictive analytics.
Conducted rigorous data quality checks, normalization, and enrichment to maintain integrity across enterprise data pipelines.

TAMP - Cloud based security platform

Company: Empaxis | Mar 2020 – Oct 2021

Migrated raw financial datasets—such as foreign stock exchange records, bonds, and securities—to a client-facing cloud-based analytics platform.
Designed and implemented business logic to transform, clean, and validate input data, ensuring it met operational standards and reporting requirements.
Developed secure, scalable ETL processes using industry best practices to enable real-time access to financial data assets.
Ensured seamless cloud integration by coordinating with infrastructure and DevOps teams during deployment.