THIRUMALAI GOMATHI

• 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.

• Developed and maintained code with data warehousing tool - Abinitio and maintained datamart tables for each applications.
• Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
• .Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.
• Enhanced data quality by performing thorough cleaning, validation, and transformation tasks.
• Streamlined complex workflows by breaking them down into manageable components for easier implementation and maintenance.

The overall goal of this project is to automate process to move data from source to EAP platform to support identification of inappropriate sales data per Matters requiring attention scheme.

Role Description:

• Bring in source files or tables from teradata(TPT) into hadoop directory and hive tables.
• Implement scenarios and load standardization tables using Pyspark and HQL.
• Conversion of SAS code logic into Pyspark code and HQL.
• Developed code from scratch including requirement gathering, impact analysis and design phases.
• Proactive in following up with business counterparts for requirements.

The overall goal of this project is to help users get insights of portfolio,brand group and brand from the calculations that is calculated as per requirement and take decisions further.

Role Description:

• Conversion of SAS code logic into Pyspark code.
• Developed code from scratch including requirement gathering, impact analysis and design phases.
• Proactive in following up with business counterparts for requirements.
• Automation of code and schedule through autosys as monthly run.

The main objective of this project is to consolidate data from 6 different sources, perform transformation logics and load them into EDW tables maintaining history.

Role Description:

• Development and analysis using datawarehousing tool – Ab Initio.
• Unloading the source tables from teradata and validation of table inputs.
• Perform transformations and load datamart tables and error reports to users.
• Implemented Slowly Changing Dimension 2 graph to maintain history data.

The purpose of this project is to enhance existing process to shorten time needed for detection and counter measures regarding point of purchase compromise by automating process that occurs after CPP list been produced. It utilizes identified fraud activity to pattern and notify users prior to fraud occurrence.

Role Description:

• Full stack developer and Business analyst.
• Development using data warehousing tool – Ab Initio and load to specific data marts.
• Shared drive setup to receive source files, validating input files and loading to datamart detail and summary tables.
• Developed code from scratch including requirement gathering, business analysis,impact analysis and design phases.