Jerry Ogwa

• Planned, designed, implemented, and maintained data warehouse on Snowflake cloud data warehouse on AWS and Azure
• Designed and designed implemented data vault and dimensional data models
• Designed and implemented data acquisition, enrichment, quality checks, ingestion into data lake and Snowflake database
• Designed and implemented Snowflake data flowing using stream, snow pipe, stored procedu

• Gathered, analyzed, and translated complex business rule into conceptional, logical and physical models
• Designed and implemented data models for the analytic solution on Snowflake
• Implemented the data cloning, sharing and replication
• Designed and implemented Lakehouse data architecture
• Led the design of data acquisition, enrichment, quality checks, ingestion into data lake and Snowflake

• Gathered, analyzed, and translated complex business rule into conceptional, logical and physical models
• Designed and implemented both on-premises and cloud-based data analytic on Azure, GCP and AWS solutions
• Designed and implemented Snowflake data warehouse including modeling, development of data pipeline, Snowpipe, user access, data sharing, streams, tasks, resource monitoring, stored proc

• Planned, designed, implemented, and maintained Azure SQL data warehouse, and Snowflake
• Gathered, and translated business logics into logical designs
• Designed and implemented data pipeline using GCP Dataflow, Cloud Composer, Google Data Fusion that feeds data into BigQuery and data lake
• Designed complex data model utilizing dimensional model and associative models
• Designed and implemente

• Researched, designed implemented RBC Capital Market Qlik Sense Business Intelligence Solution
• Gathered, analyzed, and translated complex business rule into conceptional, logical and physical model
• Provisioned Azure data warehouse and migrates data from on premise databases to Azure data warehouse.
• Designed and implemented cloud-based data warehouse solution such as Azure Data Warehouse,

• Served as Subject Matter Expert that researched, recommended, and managed the implementation of the business intelligence solution
• Designed, implemented, and supported Dealer FX AWS based analytic solution
• Designed the DFX Data warehouse and Business Intelligence Solution from end to end
• Translated business requirements into BI solutions
• Designed Azure Data warehouse, Azure blobs, Redshi

• Supported strategic decision making through the collection, mining, analysis, interpretation, and communication of information to key decision-makers
• Designed, developed, and managed NIBSS Enterprise Data Warehouse
• Gathered business requirements and translated them into technical specifications
• Designed and implemented ETL process that fetch data from relational and NOSQL databases and sto