Alan Seelan

- Leads the internal data engineering team, delegating tasks, enforcing coding standards, and ensuring on-time, high-quality deliverables. - Supports enterprise applications with database design, reporting, performance tuning, and data integration. - Oversees database activities for development, deployment, and optimization, ensuring compliance with evolving security standards. - Collaborates with infrastructure and cloud teams to architect scalable, future-ready database and integration solutions. - Drives modernization initiatives by aligning legacy applications and data models with the digital products vision and enterprise data strategy.

- Directed a cross-functional team of 20+ data engineers, developers, and technical leads to deliver a multi-year program on time and within budget. - Built and scaled a new data engineering stream within the ADMC project, enabling advanced reconciliation, validation, and integration workflows. - Oversaw project milestones, UAT cycles, and release management, ensuring data governance compliance. - Spearheaded API development for real-time data streaming, improving data accessibility for external stakeholders. - Established dedicated application support workflows, enhancing operational efficiency and reducing turnaround for issue resolution.

- Designed and implemented scalable data models and database development standards to support enterprise systems. - Architected and built an ETL solution using .NET, streamlining data loads from transactional systems. - Led migration of enterprise data from Informix to SQL Server, ensuring accuracy and performance. - Worked with cross-functional teams to troubleshoot and resolve production/data issues in DWH and CT. - Developed solutions for centralizing master data loads, improving data consistency across systems. - Onboarded internal and external applications, enabling reporting from enterprise databases.

𝐂𝐨𝐧𝐬𝐮𝐥𝐭𝐚𝐧𝐭 - 𝐂𝐨𝐯𝐚𝐧𝐜𝐞 𝐒𝐫. 𝐃𝐚𝐭𝐚 𝐖𝐚𝐫𝐞𝐡𝐨𝐮𝐬𝐞/ 𝐄𝐓𝐋 𝐃𝐞𝐯𝐞𝐥𝐨𝐩𝐞𝐫 | 𝐎𝐜𝐭 𝟐𝟎𝟏𝟐 𝐭𝐨 𝐀𝐩𝐫 𝟐𝟎𝟏𝟖 - Designed and implemented ETL solutions for NorthStar project, ensuring data quality and scalability. - Provided production support for DWH and CT Data Loader applications, troubleshooting and resolving critical data issues. - Developed centralized monitoring/metrics tools using .NET, proactively identifying data anomalies. - Partnered with offshore teams to validate object design, review test plans, and optimize ETL workflows. - Enhanced Data Loader using PERL, streamlining data conduit processes. 𝐂𝐨𝐧𝐬𝐮𝐥𝐭𝐚𝐧𝐭 - 𝐖𝐚𝐥𝐭 𝐃𝐢𝐬𝐧𝐞𝐲 𝐖𝐨𝐫𝐥𝐝 𝐄𝐓𝐋 𝐃𝐚𝐭𝐚 𝐒𝐞𝐫𝐯𝐢𝐜𝐞𝐬 𝐋𝐞𝐚𝐝 | 𝐉𝐚𝐧 𝟐𝟎𝟏𝟎 𝐭𝐨 𝐎𝐜𝐭 𝟐𝟎𝟏𝟐 - Designed and delivered end-to-end ETL and reporting solutions for Rapid Mart modules (Purchasing, Inventory, AP, Cost Objects). - Migrated BODS objects from version 3.2 to 4.1, ensuring backward compatibility and enhanced performance. - Converted Informatica Data Objects into optimized BODS objects, improving ETL efficiency. - Tuned complex SQL/ETL queries using database logs and AWR/ASH reports. - Led development of BI reports (WebI and DeskI), enabling advanced data insights. - Conducted volumetric and growth analyses to plan resource and storage requirements for future projects.