SANTHOSH KUMAR V

Client: Franklin Templeton

Project Title: FTI WEALTHX SEI Migration

Tools: Bitbucket and GitBash

Platforms: Snowflake(Platform) and Azure

Languages: Python and SQL

Description:

FTI WEALTHX is a Wealth management system and has been pursuing its objective to implement modern data platform on Snowflake for Fiduciary & Penn Trust wealth. The WealthX Data Platform solution with SEI migration will help in reaping the benefits of a modern data platform such as improved data ingestion/transformation operations, data management, governance, and consumption. FTI WEALTHX empowers wealth management businesses to optimize operations, drive innovation, and deliver data-driven insights for better decision-making.

Job description:

• Implemented robust ELT data pipelines using Snowflake (tasks, procedures) and snowflake-python-connector resulting in streamlined data processing and improved efficiency.
• Developed and implemented audit logging and meta-data validation process using Snowflake procedures, functions and transient tables for debugging, monitoring, and troubleshooting ELT processes.
• Experienced in data modelling, particularly in designing fact and dimension tables, implementing Slowly Changing Dimensions and optimizing schema structures for efficient querying.
• Developed and automated data orchestration for weekday’s business reports by transferring data from Azure Blob Storage to Snowflake tables using Snow-park procedure with SQL scripting and Snowflake task, stage and file-format.
• Well knowledge in Snowflake (RBAC roles, Virtual warehouses, Streams and Time-travel).