A decade-plus building enterprise data platforms.

Enterprise Data Warehouse & Cloud AI Platform Engineer. Lead the operation, modernization, and optimization of enterprise data platforms with a focus on Snowflake AI Data Cloud, cloud-native analytics, AI enablement, and secure data governance across hybrid and AWS environments.

Key responsibilities

• Manage and enhance Enterprise Data Warehouse Services (EDWS), ensuring availability, scalability, performance, and reliability.
• Architect and optimize Snowflake Data Cloud using cost-efficient, cloud-native design principles.
• Implement Snowflake Cortex (LLM functions, embeddings, classification, summarization) to enable AI-powered analytics and automation.
• Design RAG pipelines using Vector Search and Cortex Search to support semantic and context-aware applications.
• Develop Snowpark (Python/Java) transformations, UDFs, and scalable compute workflows, plus cloud-native ELT/ETL pipelines for analytics and AI/ML workloads.
• Build Streamlit & Python applications integrated with Snowflake for reporting, audit, governance, and dashboards.
• Implement Snowflake Data Clean Room for secure, privacy-preserving data collaboration.
• Integrate Snowflake with AWS services for scalable, resilient, cost-governed architectures.
• Enforce SSO, MFA, KeyPair, and RBAC controls aligned with cybersecurity, data governance, and GRC best practices.
• Collaborate with architecture, risk, and business teams to deliver compliant, AI-ready data solutions.

Key achievements

• Improved EDWS efficiency through automation and performance optimization.
• Delivered a secure, scalable Snowflake AI platform strengthening governance, compliance, and cost management.
• Established AI-ready data architecture enabling semantic search and generative AI integration.

Enterprise Database Architecture & Management. Designed, developed, and maintained large-scale enterprise databases across on-premises and cloud-based data warehouse environments, ensuring high availability, performance optimization, and secure data storage and retrieval.

• Data platforms & technologies: Extensive experience with Oracle, MS SQL Server, MySQL, and Snowflake, with strong working knowledge of relevant ecosystems and system lifecycle management principles.
• Data engineering & pipelines: Architected and implemented scalable ELT/ETL pipelines for efficient data ingestion, transformation, orchestration, and distribution across enterprise analytics platforms.
• Advanced SQL & programming: Expert in SQL and PL/SQL for complex query optimization and database programming; applied Python in data engineering workflows and data-driven applications.
• Analytics & BI: Leveraged SQL, Power BI, Tableau, Excel, and Python to deliver actionable insights, executive dashboards, and decision-support systems.
• Communication: Translated complex technical concepts into clear business value, collaborating with cross-functional technical and executive stakeholders.

• Managed and supported the operations, performance, and reliability of large-scale Enterprise Data Warehouse Services (EDWS) on on-premises SQL Server, ensuring high availability and optimized performance for enterprise analytics and reporting.
• Administered and maintained highly customized, enterprise-grade applications supporting provincial workforce operations, ensuring stability, scalability, and business continuity across critical functions.
• Led a corporate IT services initiative to upgrade the Provincial Workforce Management System, coordinating cross-functional technical teams, business stakeholders, and external partners for a seamless transition with minimal disruption.
• Acted as a key liaison between technical and business units, providing coordination across multiple projects to align system capabilities with operational and strategic objectives.
• Contributed to knowledge transfer and capability building through technical guidance, documentation, and training support.

• Led the design and optimization of enterprise Reporting & Information Systems within a large-scale IT corporate environment, delivering scalable, high-performance data solutions.
• Transformed complex, multi-source quantitative and statistical data into predictive insights and executive-level reports to support strategic decision-making.
• Developed data-driven reporting applications and interactive dashboards using Tableau and Python, leveraging the Snowflake Streamlit framework for real-time analytics and stakeholder visibility.
• Strengthened data governance and operational efficiency by improving data flow processes — ensuring consistency, accuracy, and high data quality across cross-functional teams.
• Produced comprehensive technical documentation and user manuals to support system sustainability, audit readiness, and knowledge transfer.

Data migrations and integrations process, and client onboarding process. Administered and maintained a cloud-based MySQL Database Management System.

• Responsible for the monitoring and maintenance of four data centres across the globe, consisting of highly available distributed Oracle database instances on Linux/Unix OS platforms.
• Monitored database space management and performance and automated backup/restore procedures; superintended activity and utilization for performance investigation using Foglight.
• Performed investigation, troubleshooting, and created follow-up Service Requests (SR) with Oracle Support as required.
• Responsible for data security — managed and assigned passwords to maintain database access.
• Created and maintained automated processes for scheduled tasks/jobs using Unix/Linux shell scripting.
• Used SQL and PL/SQL to write efficient, complex queries against large data sets; implemented and deployed fixes in existing packages, procedures, and functions (database development).
• Sole responsibility for maintenance and upgrade of the company’s reporting system; introduced several new customized reports of high business value.
• Completed several data migrations from various sources with validation and metadata issue investigation; established new procedures for data cleaning, filtration, translation, and quality control.
• Conducted mass data modifications, updates, and backfills safely via procedural programming.
• Supported and maintained data-driven applications including User Management, Billing Generator, and Report Launcher, with close coordination across End Users, QA, and Development teams.

• Database documentation and segregation of code and data tables.
• Created clean, empty databases (devoid of unnecessary data) for distribution.
• Reduced and compacted existing databases (optimization) and performed query optimization.
• Identified and removed old, unused tables.

Successfully planned, designed, and implemented an Oracle 11g Relational Database Management System project in a real-world scenario. Core tasks included system analysis, proposal writing, project planning, database modeling, backup & recovery strategies, database and object creation, security setting, network administration, script building & reporting, web integration, performance & tuning, documentation, and presentation.

• Prepared and generated financial and technical reports using MS Excel, MS Access, Oracle, and ERP systems for accounting and billing generation.
• Reviewed and scrutinized records, data, and information for inconsistencies (data analysis) per laid-down procedures.
• Set up and maintained manual and computerized record-keeping / filing systems and developed standard official documentation and report designs.
• Developed procedures to streamline and simplify data compilation and filtering, reducing time required by 40%.
• Compiled and filtered technical data for Flight Procedure Designing software, used in designing commercial flight paths (airways, routes).
• Trained officials to record information and generate reports using Oracle applications and provided desktop support across units.