Senior Data Architect & Data Engineer

• Led full-scale modernization of the enterprise data platform by architecting and implementing a centralized three-tier data architecture featuring a dimensional model and integrated data marts.
• Engineered modular, fault-tolerant data pipelines using Apache Airflow and dbt, reducing failure rates by over 50% and improving pipeline stability.
• Integrated critical data sources and built scalable ETL/ELT workflows to ensure timely, accurate, and reliable data delivery for analytics and reporting.
• Implemented comprehensive data lineage for Tableau and Salesforce CRM dashboards, improving auditability, transparency, and accelerating root-cause analysis of data issues.
• Tuned Snowflake environment through strategic use of clustering keys, result caching, and compute resource allocation, achieving a 25% reduction in cost and significant query performance gains.
• Key Technologies: Snowflake, Airflow, dbt, Tableau Cloud, Salesforce CRM Analytics, Python, SQL, AWS

Designed and implemented enterprise-scale data and analytics solutions for multiple global clients. Provided strategic guidance on cloud data platforms, data warehousing, and business intelligence. Led end-to-end cloud migrations, data architecture modernization, and AI-driven analytics initiatives.

• Data Warehouse Migration to AWS: Migrated a large Oracle data warehouse to AWS, leveraging Amazon Redshift and Informatica Cloud Data Integration. Designed a cloud-native data model and architecture, integrating Amazon S3 for data lake storage and AWS Lambda for automated processing. Enabled multi-region data sharing for improved accessibility and disaster recovery, achieving a 40% cost reduction and 35% faster queries.
• Business Intelligence Platform on Azure: Architected a modern BI platform using Azure Databricks for ETL, Azure Data Lake and Synapse for storage and analytics, and Power BI for visualization. Implemented real-time data pipelines, improving data availability for business users. Reduced BI report generation time by 50%.
• Enhanced Data Vault Modeling: Optimized Data Vault modeling for efficient data ingestion and transformation. Improved data loading performance by 60%, enabling faster processing of large datasets and ensuring scalability to meet evolving business needs.
• Master Data Management Migration: Transitioned on-premises MDM to Informatica IDMC (cloud MDM), ensuring master data consistency. Developed data mapping, transformation, and validation processes to improve data quality and accuracy. Reduced data processing time by 30% through performance tuning.
• Strategic Advisory & Client Engagement: Conducted technical assessments of clients’ data ecosystems and developed roadmaps for cloud transformation. Delivered executive presentations and technical workshops to drive data strategy adoption. Collaborated with cross-functional teams to align data architecture with business objectives.
• Key Technologies: Oracle, AWS (Redshift, S3, Lambda), Informatica Cloud DI/IDMC, Azure Databricks, Azure Data Lake, Azure Data Factory, Azure Synapse, Power BI, Data Vault 2.0

Led the architecture and implementation of advanced data solutions, analytics platforms, and cloud transformation projects for enterprise clients. Developed data-driven strategies to optimize data platforms and drove AI/ML adoption for business intelligence and predictive analytics. Provided thought leadership in big data engineering and cloud migration initiatives.

• Enterprise Data Transformation: Modernized legacy data environments into scalable cloud-based architectures. Implemented high-volume ETL pipelines for real-time data ingestion, achieving 40% faster processing and improved data availability for stakeholders.
• External Data Monetization (Telecom): Built data monetization frameworks that enabled telecom providers to derive insights from subscriber data for third-party services. Developed secure data-sharing models with privacy compliance and implemented data anonymization and segmentation for benchmarking.
• Centralized Data Warehouse: Consolidated disparate data sources into a centralized enterprise data warehouse. Established data governance policies to ensure consistency, quality, and compliance. Improved data accessibility and reporting efficiency, reducing decision-making time by 35%.
• IoT Architecture and Predictive Maintenance Analytics: Designed an IoT-driven analytics platform for predictive maintenance in the manufacturing sectors. Integrated real-time sensor data ingestion from IoT devices into a cloud-based data lake for advanced analytics and forecasting.
• Data Governance, Security and Cloud Migration Strategy: Developed frameworks for data governance, security, and data strategy, ensuring GDPR compliance. Led cloud data migration initiatives, evaluating AWS, Azure, and GCP for optimal scalability and cost efficiency. Migrated critical business data to the cloud, reducing infrastructure costs by 30% while enhancing system performance.
• Leadership and Customers Engagement: Provided strategic advisory to C-level executives on data modernization and AI-driven BI. Conducted technical workshops and executive briefings. Managed cross-functional teams, aligning business goals with modern data solutions to drive measurable impact.
• Key Technologies: Cloud data platforms (AWS Redshift, Snowflake), big data ETL tools (Spark, Python), data governance

• Designed and implemented a scalable data warehouse and BI platform to support advanced analytics and reporting. Led ETL development and dimensional modeling, utilizing PostgreSQL and Talend to automate data ingestion and transformation from multiple sources. Optimized the database schema and indexing, improving query performance by 40% and cutting BI report generation time by 50%. Automated data validation workflows, reducing manual effort by 60%.
• Key Technologies: PostgreSQL, Talend, ETL automation, data warehousing, business intelligence, Tableau

• Managed over 100 high-transaction production databases (Oracle, MS SQL Server, MySQL) for online gaming services. Performed extensive database tuning, backup management, and AWS cloud integration to reduce storage costs and improve query performance. Automated ETL workflows with Pentaho and built a BI reporting environment on Amazon Redshift and Tableau. Ensured high availability through MySQL clustering and virtualized SQL Server instances, optimizing infrastructure and reducing latency.
• Key Technologies: Oracle, SQL Server, MySQL, Pentaho, Amazon Redshift, Tableau, database virtualization

• Led development of IaaS cloud management software, focusing on database architecture, replication, and transactional integrity. Implemented cross-platform Oracle-to-non-Oracle replication using LogMiner, Oracle Streams, and Redo log parsing. Automated database deployment and configuration processes to enable rapid scaling. Optimized query performance, indexing, and partitioning strategies, improving data retrieval speeds by 60%. Enhanced system scalability and processing efficiency. Provided technical support for sales, including product demos and architecture consultations.
• Key Technologies: Oracle, Oracle Streams, Oracle LogMiner, database replication, automation scripting

• Managed high-volume Oracle databases for telecom billing systems, maintaining 99.99% uptime and peak performance. Led migrations, performance tuning, and disaster recovery initiatives. Developed PL/SQL and ETL workflows to optimize data processing and system efficiency. Executed data conversions and ensured integrity across ETL pipelines. Tuned database architecture, partitions, and indexing strategies, improving query runtime by 35%. Enforced security policies, access controls, and data encryption to meet compliance standards.
• Key Technologies: Oracle Database, PL/SQL, ETL processes, Unix, telecom billing systems