THIRUMALAI GOMATHI AVUDAIYAPPAN

• Involved in development of 20+ datamarts , managing a 5 member team.
• Gathered and documented business requirements to design and develop efficient Datamarts and Data Warehouses,worked closely with stakeholders to define KPI's and reporting needs.
• Developed Star and Snowflake schema models to optimize data retrieval and performance aligning data structures with business requirements.
• Ensure proper design and datamart loads using Abinitio ETL tool with required data integrity and transformations before loads.
• Identified areas for improvement within existing ETL frameworks to maximize efficiency without sacrificing accuracy,provided training and support to users for report utilization.
• Utilized data visualization tools to effectively communicate business insights.

• Designed 10+ scalable and maintainable data models to support business intelligence initiatives and reporting needs.
• Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.
• Streamlined complex workflows by breaking them down into manageable components for easier implementation and maintenance.
• Enhanced data quality by performing thorough cleaning, validation, and transformation tasks.

Worked as a part of the below major projects,

• Matters Requiring Attention(MRA) Sales :As a full stack developer , Implemented scenarios and load standardization tables using Pyspark and HQL
• Airtool Agile Project: As a Pyspark developer , worked in conversion of SAS code logic into Pyspark code, automation of code and schedule through autosys as monthly run.
• GFE Comprehensive Database Solutions: As a full stack developer, Performed transformations and load target tables and sent error reports to users , Implemented Slowly Changing Dimension 2 graph to maintain history data.
• CPP Proof of Concept Fraud HLA: As a Ab Initio developer, set up shared drive to receive source files, validating input files and loading detail and summary tables.