Steve Hamilton Email & Phone Number

Leander, Tx, Us

Data things. SQL Server,RDS mySql, Aurora, SQS, AWS, HevoData, BigQuery, Tableau, Snowflake, Kinesis Streams and Firehouse, Airflow MWAA

• Served as LA County's Cognos Expert, Project Manager, and liaison between LA County CIO and multiple consulting firms in order to complete multiple projects in reporting, modeling, and ETL development in an Oracle 9i environment. • Brought on-site to several multi-billion-dollar Fortune 500 companies at the request of IBM Services to solve critical issue with infrastructure or implementation. • Provided expert knowledge and feedback for Cognos 7.x, C8, Project Analysis and Re-focus, Implementation, ETL, Database Tuning, and Programming • Oracle, DB2, SQL Server SQL and Stored procedures created for multiple projects • Backup, recovery, and migrations or data • Project Lead for several high visibility critical projects

Ch

• Designed, developed, and supported large scale enterprise data warehouse to support 5 different companies.• Led a team of BI professionals to replace current BI environment with a modern environment capable of near real-time reporting.• Google Analytics, Google Ads, Facebook, Has Offers, Tune, Recurly, Sharepoint, and Acoustic integration into pipeline. • C#, Python, Scala, Java, Perl• SSIS, SSRS, Apache NiFi, SQL Server 2017, MySQL, Splunk, RabbitMQ, MySQL • Tableau Server, Data Catalog, Data Prep, advanced report writing

Redwood City, Us

• Designed, developed, and supported large scale data warehouse and logging infrastructure to support online several online video games • Designed and implemented the data warehouse from the ground up• Designed and implement a robust and scalable log ingestion pipeline supporting several concurrent titles• C#, Python, Java, Ruby • Hadoop, Hbase, Flume, Drill, NiFi installation, and upgrades of >petabyte cluster • Implemented GDPR Right to Forget and Data Portability and was the data lineage expert for all pipelines • Supported all games, platforms, 3rd parties, and was the expert on everything data related • SQL Server 2008-2017, MySQL, SSIS, SSRS, SSAS, Tableau, Qlikview, Splunk • Implemented real-time player facing if-this-then-that system used across all data sources • Real-time bot detection and spam detection and remediation • Marketing post back system for 3rd party partners and funnel from first web hit to in-game purchases • Created and maintained Google analytics, Marketo, Facebook, Twitch, PSN, Xbox, and Steam data pipelines

Waltham, Ma, Us

implementation, and maintenance of entire infrastructure and Cognos applications including Decisionstream, Powerplay, Transformer, Report Studio, and Query Studio. Ground up implementation of Global Enterprise Data Warehouse in multiple languages Procurement of software and hardware for Enterprise Data Warehouse Gathered business requirements internationally and trained end users on the use of Cognos Powerplay, Report Studio, and Query Studio Developed ETL process to pull from multiple ERP and CRM systems in multiple languages to create a global enterprise data warehouse Managed Full Life Cycle Development of custom e-commerce solution with a team of 19 that interfaced with multiple ERP systems seamlessly (SAP, Macola, Globe). This solution produced >$9,500,000 in additional international sales the first year it was live.