RAVI PRAKASH VERMA

• Developing and implementing an overall enterprise data strategy that is in line with business processes. Strategy includes data model designs, database development standards, implementation, and managing end to end architecture of the Enterprise Data Management Platform - Data Lake and Cloud Solutions
• Create architectural blueprints and technical specifications for new data solutions ensuring the solution architecture aligns with the firm’s strategic goals and regulatory requirements.
• Work closely with business stakeholders, data stewards, and IT teams to understand and translate business requirements into technical solutions.
• Helped businesses to migrate from existing Data-warehouses to Snowflake and building an efficient Data Architecture in Snowflake.
• Evaluate and recommend data management technologies, tools, and platforms and ensure chosen technologies are compatible with existing systems and future business needs as per Enterprise Architecture goals
• Coordinating and collaborating with cross-functional teams, stakeholders, and vendors for the smooth functioning of the enterprise system.
• Assessment of current architecture and integration patterns and identifying the gaps and setting up the mapping between current and target end state.
• Ensure data quality, consistency, and governance throughout the data lifecycle
• Designed & Implemented Unified Metrics Master - Enterprise Metrics Platform to ensure the consistency and authenticity of metrics across the organization
• Defining Key metrics to measure success and setting up capabilities based on complex business use cases across application and data initiatives.

Data Architecture & Data Governance

• Designed multi-layer Data Lake - Data Architecture to serve the various Initiatives and business cases across the organization.
• Designed Data Contracts with 41 source systems including core banking platform to ensure seamless flow of data into the data take along with Data Veracity, Data Quality, Data Security and Governance through speed (Event Driven) and batch layer
• End to End Architecture for the Digital marketing. Integration Architecture with various Digital Technological Stack - Campaign Management, CRM, DataLake, Customer Data Platform and Lead Aquisition.
• Designed data models for the Enterprise wide initiatives to cater the business needs with Layered Data Architecture - Raw, Aggregated, Domain Data Models (Curated/Insights)
• Defined and designed the Data Ingestion and consumption patterns for the Datalake - Current state & End state architecture

SMDS - Master Data Platform

• Laying out the Platform Architecture for the Master Data Platform and the base that teams could develop on Azure Cloud.
• Designed conceptual and logical data models for Enterprise wide curated data models and Domain Data Models
• Automating the Platform Infrastructure creation using Azure Pipelines and Terraform scripts
• Laying out the Data Migration strategy for the On-Prem. to Cloud Migration which validated data using a Data Quality framework and Data Cleansing (if needed) before loading into Azure Cloud.

Data Governance - Enterprise Architecture

• Established a Data governance framework to ensure organization goals are met for the Data driven strategies.
• Designed and Implemented the DQ Baseline to measure the data quality metrics based on various Data Quality dimensions
• Established the data contracts and Enterprise wide Data veracity framework for Datalake
• Setting up End to End process for the data enrichment and data cleansing to address the Poor data quality of the legacy systems.

Data Architecture & Data Management

• Performing Data Ingestion, Data Transformation and Data Loading using Azure Cloud stacks.
• Creating Data Pipelines to validate, transform and Load the data with multiple sources & target Systems
• Leading a team of developers to get the data validated by applying the business validation rules in data lake and then getting them enriched and cleansed before loading into the Repository.

Enterprise Data Repository - Enterprise Architecture

• Designing and developing Staging/Load Strategy for Master Data Management and Data Governance Framework
• Designed and Developed Enterprise data repository with Master Data using IPC & IDQ
• Business interaction and requirement analysis to propose the design strategy & Enrichment
• Created KPI reports to show Data quality and quantitative trends for decision making

Data-warehouse, ETL Development

• Design creation and build ETL code using Informatica Power Center and Informatica DQ
• Created DQ Profiles, Scorecards, Rules, mapping Specifications using Informatica Analyst tool for data health checkup
• Automated the validation of the result-set using Informatica Analyst