Aditya Shukla

• Conducted comprehensive assessment of warehouse subject areas, usage statistics, and consumption patterns.
• Analyzed data flow patterns and established operational models with the necessary controls.
• Coordinated the decommissioning of HR streams in warehouses by identifying prerequisites and creating an operational model.
• Performed risk assessments with corresponding mitigations to ensure project success.

Led the planning, design, and development of data requirements for customer accounts at a banking firm, encompassing savings accounts, corporate accounts, credit cards, mortgages, and loans.

Designed and implemented ETL pipelines using Informatica, Teradata, and HDFS to extract, transform, and load large datasets for banking projects, ensuring efficient data flow and integration.

Developed complex SQL queries, views, and stored procedures to support real-time analytics and business intelligence.

Optimized ETL performance by fine-tuning the data processing job, reducing data latency, and improving pipeline execution times.

Developed and implemented data transfer processes using Control-M for job scheduling and monitoring.

Maintained communication with clients and Solution Architects to align on project objectives and deliverables.

Promptly addressed client and user queries to ensure project continuity.

Worked closely with downstream teams to manage production releases, resolve defects, and ensure timely project delivery.