Petchiappan Subramanian

Retail

• - Architecting Azure Data Lake solution for Marks & Spencer, defining ingestion strategy, storage standards, and metadata models. - Conducting data profiling and analysis to design conceptual and physical data models aligned with business requirements. - Collaborating with data governance teams to standardize object naming conventions and ensure compliance with enterprise standards.

Insurance (Life, Health & Commercial)

• - Led Data Lake and Data Warehouse architecture for Aviva Insurance, designing AWS based solutions leveraging S3, Spark, Sqoop, and Informatica. - Developed reusable Spark-based utilities for data ingestion, archival, and change management (update/delete) in S3 objects. - Defined data lineage and governance standards using Informatica EDC and Web Analyst. - Built end-to-end data models (conceptual, logical, physical) supporting ETL and reporting teams. - Delivered data architecture solutions for Pruhealth (UK) and Hartford (US), including data warehouse modernization initiatives. Tech Stack: AWS, Informatica PowerCenter, BDM, EDC, Oracle, DB2, Hive SQL, SQL Server, UNIX, ERWIN, MSBI (SSIS, SSAS, SSRS)

Banking (Credit Card)

• - Led offshore delivery teams (10+ members) for clients including Mastercard and Capital One. - Designed and implemented data models and ETL processes using PL/SQL and Unix scripting. - Ensured on-time, high-quality module delivery with detailed design and testing documentation. Tech Stack: Oracle, Unix, PL/SQL, PVCS