Data Solution Architect

Senior technology architect specializing in transforming enterprise data landscapes through AI-powered solutions and cloud modernization. Proven track record of reducing development time by 60-70% through LLM-assisted development while delivering scalable, regulatory-compliant data architectures for Fortune 500 financial institutions.

Core Expertise

Data & Solution Architecture
Cloud Solutions
AI & Machine Learning
DevOps & Automation

About Me

Data Solution Architect with 18+ years of experience in designing and delivering enterprise-scale data platforms in the Banking and Finance industry. Proven expertise in modernizing legacy systems, leading mainframe and Informatica to cloud migrations, and implementing high-performance data architectures.

Recognized for driving business-critical transformations with Databricks, Azure Data Factory, Synapse Analytics, and Informatica. Adept at leading cross-functional teams, optimizing ETL/ELT pipelines, and ensuring regulatory-grade data quality in demanding, fast-paced environments.

18+ Years Experience
60-70% Development Time Reduction
7 Microsoft Certifications

Technical Skills

Cloud Platforms

Azure Databricks Azure Data Factory Synapse Analytics ADLS Gen2 AWS Glue Snowflake

Programming & Development

PySpark Python COBOL SQL PowerShell Unix/Shell

Data Engineering & ETL

Informatica PowerCenter Apache Spark HDFS Hive ETL/ELT Pipelines

Databases & Analytics

Oracle SQL Server MongoDB Cassandra Power BI SAP BO

DevOps & CI/CD

Azure DevOps GitHub GitLab Jenkins ARM Templates

Certifications

Azure Solutions Architect Azure Data Engineer Azure AI Engineer Lean Six Sigma Green Belt

Featured Projects

Mainframe to Databricks Migration

Led end-to-end solution architecture for mainframe-to-cloud migration using AI-powered code transformation, achieving 60-70% development time reduction.

Azure Databricks PySpark COBOL to Python GitHub Copilot

Financial Transaction Data Hub

Designed and enhanced Data Models for Financial Transaction processing for datalake and analytics, ensuring regulatory compliance and real-time data availability.

Azure Data Factory Data Architecture Banking Domain Compliance

Enterprise Data Warehouse

Designed and built enterprise DWH from scratch, leading project from requirements to production deployment with zero post-production defects.

Informatica PowerCenter ETL Architecture Data Modeling Performance Tuning

Autosys Monitoring Dashboard

Created automated monitoring dashboard for 7000+ Autosys jobs using Power BI, eliminating manual monitoring processes.

Power BI Process Automation Operations VBA

SSIS to Informatica Migration

Developed automated conversion tool using Excel VBA to transform SQL Server SSIS packages to Informatica mappings.

VBA Automation SSIS Informatica Migration Tools

Data Quality & Archival Framework

Designed metadata-driven data quality frameworks and archival solutions for enterprise data platforms with storage optimization.

Data Quality Metadata Framework Storage Optimization Azure

Get In Touch

I'm always interested in discussing new opportunities in data engineering, cloud architecture, and enterprise data solutions. Let's connect to explore how my expertise can contribute to your organization's success.

GitHub: @rm15lrng
Certifications: Azure Solutions Architect & Data Engineer