Robert Odowd Email & Phone Number

Florida, United States

Atlanta, Georgia, Us

Atlanta, Georgia, Us

• Led the implementation of Snowflake Cloud Data Warehouse as the next-generation Enterprise Data Platform for the company. Worked with internal resources and external partners to consolidate multiple on-premise data silos into a unified cloud data platform. Collaborated with business stakeholders to create a self-service data strategy that enabled them to create their own data-driven solutions while simultaneously maintaining an IT-driven single source of truth for enterprise data.• Defined the standards around Snowflake platform usage and design patterns to build a robust data platform to meet the company's growing needs. Ensured platform stability, security, and compliance by working with infrastructure, infosec, change management, and compliance teams to develop the processes and policies for the Snowflake platform.• Responsible for the migration of Snowflake account from Azure cloud to GCP cloud• Managed Snowflake cloud platform operating costs and developed usage forecasts used for contract renewals.• Coached other BI architects and developers on data warehousing and modeling best practices and newer concepts (data lake, schema-on-read, columnar data stores)

Atlanta, Georgia, Us

• Architected and built the enterprise’s central repository of data shared across business units (Real Estate / Location Data, People Data, Active Directory Data, Common Hierarchies and Cross References). The central repository serviced all location tools (branch finder on websites, location directory) as well as all user provisioning and employee/contractor data integrations for numerous SaaS applications• Developed a PoC recommendation system using Cloudera Hadoop cluster and Mahout to perform basket analysis over multiple years of sales transactions from multiple lines of business. The resulting product recommendations were loaded to the ERP system and available to all sales associates at branch locations for cross-selling and up-selling• Led all data modeling and architecture of new data marts and data warehouse enhancements for the EDW• Created and maintained conceptual, logical, and physical data models for the Enterprise Data Warehouse using SAP PowerDesigner following data warehousing modeling methodologies (star and snowflake schemes, facts/dimensions, slowly changing dimensions)• Integrated numerous disparate data sources into the Enterprise Data Warehouse, both relational (Oracle / MSQL) and non-relational (json/xml) with IBM Data Stage and SAP Data Services• Served as a subject matter expert to line-of-business business intelligence groups for analytics and data warehousing solutions

Atlanta, Georgia, Us

• Experience using Sencha Architect for Javascript development of a web-based search application running on top of the Enterprise Data Warehouse. The application serviced 200+ unique field users daily; Awarded 2013 and 2014 CIO IT Innovation Award• Created a database continuous integration deployment process utilizing Git, Jenkins, and FlywayDB• Introduced context and spatial indexes into the data warehouse, adding geospatial and real-time search capabilities• Developed data flows to the EDW using pl/sql and IBM DataStage ETL• Optimized etl, ad-hoc, and reporting view SQL queries for performance• Led the EDW database upgrade from Oracle 10 to 11g. Performed all planning, migration activities, testing, and validation.

Atlanta, Georgia, Us

• Managed the change management and code review process for our team, reducing production implementation errors by 15%• Maintained Oracle Data Warehouse database environment including optimization and SQL performance tuning• Developed new database reporting layers using materialized views to meet business reporting requirements• Gathered business requirements from end users and created functional reporting to meet those needs in the data warehouse• Created Microstrategy reports• Reconciled existing data sources and performed data profiling on new data sources

Austin, Texas, Us

Support Engineer Intern on the Procurement - PO Accounting and PO Other teams within E-Business Suite support divisionPerformed knowledge management, new system testing, and assisted with resolving support requests

Master Of Science - Ms, Data Analytics

Master Of Business Administration (M.B.A.)

Bachelor Of Science (B.S.), Business Administration And Management, General