Gnanasekaran MP

Solution Design and Architecture: Engaged in solution design for various RFI, RFQ, and RFP processes related to data governance and quality. Responsible for architecting, sizing, estimating, and delivering solutions for cloud modernization, data warehousing, data quality, governance, and data marketplace initiatives across multiple cloud hyperscalers based on customer requirements.

Client Engagement and POCs: Participated in client discussions for requirement understanding, provide points of view (POVs), and deliver oral presentations for RFP responses. Involved in customer proofs of concept (POCs) utilizing IDMC, Collibra, Purview, and DQLabs.

Due Diligence and Implementation Strategy: Assisted in due diligence assessments, tool recommendations, and the development of implementation roadmap strategies. Provided guidance and best practice recommendations to ongoing implementation projects.

Ø Technology: IDMC, Azure, MS SQLserver, Snowflakes,PowerBI

Project Implementation: Led the complete Software Development Life Cycle (SDLC) for the Marketing Data Store (MDS) project, encompassing requirement gathering, analysis, solution design, data modeling, planning, development, testing support through to final production deployment.

Data Architecture Design: Designed the hub-and-spoke model to create the MDS Data Hub using IDMC. Integrated third-party solutions via REST protocols and developed a data-as-a-service approach by publishing IDMC application processes through Azure app registration, enabling data provisioning to external partners.

Feasibility Assessments: Conducted feasibility assessments and proofs of concept (POCs) for new data enhancements, including migration from SQL Server to Snowflake, IDMC data catalog initiative, and legacy PowerCenter to cloud migration. Additionally, managed the creation of architecture diagrams and reviewed key architectural changes and enhancements.

Ø Technology: Informatica Powercenter, IDQ, IDMC, SQL Server, GBQ, Google Cloud DB, Tableau

Architecture Design: Conducted feasibility assessments and architectural design enhancements for the existing Enterprise Data Warehouse (EDW) on Oracle and Teradata. Responsibilities included data modeling design, archival strategies, performance optimization, and preparation of data dictionaries and metadata.

GCP migration of Data warehouse & Enterprise Data Store: Designed and implemented the multi-tier data architecture for the EDW migration (Teradata to GBQ) and Enterprise Data Store (EDS) on Google Cloud DB (SQL Server).

Salesforce Data Migration: Developed a three-tier data architecture and reusable components, along with an ETL framework for automated data reconciliation, logging, and reprocessing of failed records during Salesforce data migration. Implemented data quality (DQ) rules for master data identification of account and customer data using Informatica IDQ.

Ø Technology: Informatica powercenter, Platinum DW, Teradata

Enterprise Data Warehouse (EDW) Design:Participated in the High-Level Design (HLD) and Low-Level Design (LLD) of the Enterprise Data Warehouse (EDW) on Teradata and the Financial Services Data Model (FSDM), including the modularization of data marts.Engaged in comprehensive data modeling activities, analyzing source systems and designing the landing and intermediate layers leading to the final EDW/datamart visualization.Designed the ETL framework, focusing on audit control, error handling, scheduling flows, and a Data Quality framework. Collaborated with the data architect to define coding standards for development.

Ø Technology: Informatica powercenter, Oracle, TeraData, MicroStrategy

Data Centralized Platform Development/ETL: Collaborated with business stakeholders to gather functional requirements and authored comprehensive Technical Specification Document, involved in creation of HLD & LLD and lead the implementation team for Data Centralized Platform (DCP). Directed the team in developing complex ETL mappings using Informatica to load data from diverse sources, including Oracle, SQL Server, flat files, fixed-width and Xml data

Ø Technology: Informatica powercenter, Oracle, DB2,Crystal Reports, Tivoli work load scheduler

ETL Processing and Report Development: Executed ETL processes for a variety of source systems into data marts, facilitating reporting and market replay. Implemented performance tuning on Informatica data pipelines, focusing on targets, sources, mappings, sessions, and workflows. Additionally, optimized database performance through indexing, materialized views, and partitioning to enhance report generation speed. Designed and developed reports using Crystal Reports on DB2, ensuring accurate and timely data presentation.

• Application Development: Developed Account/Clearing/Depositry/Financial Instrumental modules of TCS BaNCS product suite. Incorporated the complex trade matching and book keeping functionalities.