Architected analytics solutions on Snowflake DB.

Architected and built data warehouse and business intelligence solutions, utilizing AWS technologies such as Redshift, Redshift Spectrum, Athena, Data Pipeline, and EMR to improve player experience and game performance and to increase player retention and monetization.

• Architected and designed data marts to support gameplay, financial, and operational reporting and business intelligence for Star Wars: The Old Republic using dimensional and 3NF modeling techniques.• Architected and developed high-volume ETL processes in PL/SQL, utilizing bulk loading techniques, parallelism, and partitioning, leveraging Oracle Exadata features.

Senior Oracle Consultant (Contract) @ ERCOTJanuary 2008 - July 2008Oracle Data Warehouse/PLSQL Developer (Contract) @ Texas Commission on Environmental Quality (TCEQ)February 2009 - August 2009April 2007 – October 2007 June 2006 – August 2006March 2005 – August 2005

• Designed data warehouse composed of dimensional star schemas strongly adhering to Ralph Kimball methodologies.• Designed and developed ETL processes in PL/SQL to load millions of records into the data warehouse, utilizing partitioning strategies and parallel query and DML processing to maximize performance.• Developed PL/SQL program units supporting business intelligence, reporting, and analytics applications.• Developed import and export processes to load or produce XML-based extracts in a format specified by the EPA for easier data exchange. The processes were developed using Oracle’s XDB features.

• Developed back-end processes for mass movement and manipulation of financial data for Planview’s web-based product suite in both PL/SQL and T-SQL.• Developed scripts for migration of customer data from one major release to another due to a considerable re-architecture of the product suite data model utilizing VBScript.

• Developed PL/SQL framework to generate extracts for a real-time reporting platform to handle large data sets to optimize report rendering.• Designed and implemented normalized Oracle database to track real-time report generation and delivery and to provide a mechanism to support retry capability in case of system failures.• Developed logging strategy to support PL/SQL framework for support and debugging capabilities using log4plsql.• Designed, developed and documented extensions to the document repository which was based on Oracle’s Content Management SDK.

• Developed process to merge hundreds of millions of records, utilizing advanced partitioning strategies, from the European order management system into a 2.5 terabyte corporate customer repository with no system downtime and virtually no impact to the user experience as a step in moving towards globalization.

• Developed PL/SQL code to support a proprietary, web-based search engine for multi-terabyte file and email repositories for RenewData Corporation; heavy use of bulk operations and collections.• Evaluated and prototyped a replication strategy for replicating application data real-time across multiple schemas and databases using Oracle’s Asynchronous Change Data Capture (CDC).

• Re-architected and normalized application data store supporting work flow processes using ERWin to resolve data integrity and performance issues; migrated data from old structures into new data structures utilizing PL/SQL.• Developed method of table auditing using Oracle XML DB including DBMS_XMLQuery, XSU, XMLType, and enriched XPath support.

• Developed integration solution between Newgistics’s transactional data store and Oracle Receivables to automate weekly billing process utilizing Oracle PL/SQL• Designed data warehouse utilizing dimensional modeling standards and Ralph Kimball methodologies to be deployed on a SQL Server platform• Developed and implemented core pieces of technology to perform ETL of data across multiple platforms using tools such as PL/SQL, Oracle Materialized Views, Oracle SQL*Loader, Microsoft DTS, and Informatica PowerCenter 7.1