Raymond Metz Email and Phone Number

I'm working on Warehouse automation and reporting with a large team of Slalom contractors at Amazon. One of my first assignments is to refactor, rebuild, secure, deploy, and support transportation, shipping and receiving website. I'm designing a new transactional database in Serverless Aurora Postgres and migrating data from DynamoDB. I'm syncing DynamoDB to Govcloud Redshift for Quicksight reporting. I do the backend data work for our team of middle tier and web developers. Working with Brazil, code deployment pipelines, CDK, security, bash shell scripting, web development change requests, Java, Javascript, Typescript. Jira, created 50 pages of Confluence documentation so far. Smartsheet and Quip spreadsheets.

Data Engineer on our client project team using Databricks, Spark, SQL PySpark, DBT, AWS, CLI, A3, Glue, Python, Lambda, Step Functions, Eventbridge, Parquet, Delta Lake, Hudi, Unity and Glue, Notebooks, Data Catalogs, and crawlers. Managing source control with Git, CodeCommit, GitLab, Visual Studio Code.Utilizing test/training environments of Databricks, Azure, and AWS, SharePoint.Passed Snowflake SnoPro Core exam, Studied for certification Exam DP-203: Data Engineering on Microsoft Azure. Took live Databricks Associate course.Preparing to design and implement big data pipelines for customers with cloud and on premise data. Data design, performance, and integration. Supporting data scientists and business intelligence engineers with predictable and well documented data. Participating on Agile Scrum teams for new data development, enhancements, troubleshooting, and data migrations.

Contracting through Slalom. Data Engineer in team of 20, working with Epic Clarity data using Databricks, Spark, SQL PySpark, DBT, AWS, CLI, A3, Glue, Python, Lambda, Step Functions, Eventbridge, Parquet, Delta Lake, Hudi, Unity and Glue, Notebooks, Data Catalogs, and crawlers. Managing source control with Git, CodeCommit, GitLab, Visual Studio Code.Took live Databricks Associate course.Earlier team with same client: Data Engineer for a team of 18 consultants and FTEs at Fred Hutch Cancer Care, Data Platform Team. Working on Data Warehouse Quality automation, test design, training team members, organizing and documenting. Helping the them discover modern tools like Snowflake and Databricks to more efficiently serve their customers. Some of the future state tools considered so far are Azure, AWS, MPP, Snowflake, dbt, Fivetran, Spark, Hive, and Databricks. I've created over 70 Sharepoint and Confluence wiki pages, 12 diagrams in Lucidchart and Visio, and participated in 5 Miro boards so far.

Contracting through Slalom. Participated as Data Architect in Discovery team, interviewing 40 departments about current and future Business Intelligence needs.

TEKSystems Contractor. Data Engineer working in Facebook Infrastructure Data Center, Strategic Planning and Analytics department, Facilities Operations assignment. Creating and maintaining data pipelines using Python, HIVE, MySQL, and Presto SQL. Data center asset management, asset end of life/replacement planning, contract and employee repair personnel work order management, quarterly and annual reports, alerts and logging for 15+ worldwide datacenters, location management, safety and health, pipelines that import/export from SharePoint Excel and Google Sheets. Big data pipelines with billions of rows. Performance tuning, security, HDFS, and internal Facebook data engineering tools. Many of my pipelines support Tableau and internal web reports and dashboards.

Teaching Fortune 500 companies, government IT staff, and college students blockchain architecture through onsite and web based training. Partnering with three blockchain training companies. Organized and led twelve Seattle blockchain meetups.Teaching private blockchain architecture concepts with Hyperledger and Ethereum.1:1 business consulting and training on scam tokens, investing, and use in business.I have hands on experience with over 30 public blockchains, wallets, and explorers. I own about half the coins and tokens listed in the top 400 market cap with the goal of using the top technologies first so that I can teach them.

Data Engineer on Amazon Web Services team, AWS. Cloud Computing, Data Warehousing, Business Intelligence. Redshift, MySQL, AWS Data Pipeline, Scrum.The main data warehouse ETL system I managed had petabytes of storage, 3 trillion rows of data, 1600 CPU cores, 12TB of memory, 100 nodes of redshift10/2017 to 6/2018: Python Spark ETL developer migrating Redshift data warehouse to Hadoop EMR. Developed ETL features for GDPR, integrated new datasources, standardized and documented ETL load templates. created content for operations guide.6/2017-8/2017: Repeated AWS data warehouse ETL migration for new government customer in 1/3rd the time.1/2017: Troubleshooting performance joining 100 billion row table with 50 billion row table.7/2016: Taught a 3 day Data Warehousing class in Washington DC, helping a new government related sister team onboard our team's ETL server, jobs, and Redshift Data Warehouse.6/2016: Migrating a 200 table cloud data warehouse from Oracle to Redshift, remotely with no access to data or network. Writing design, testing, instructions to local secured admins, and troubleshooting. Bringing remote secure warehouse in line with corp warehouse.4/2016: Recorded six data warehouse user bootcamp screen share videos to train users on our internal data warehouse. Design, user and data security, connecting from SQL tools and using team ETL tool.3/2016: Completed designing, documenting, building, testing, and deploying into production, a new 21 server cloud environment for ETL pre-processing billions of rows of minutely usage data from 5 unique sources. Used AWS, S3, EC2, Ruby, and Data Pipeline.12/2015: Reorganizing ETL jobs so that priority SLA code runs faster and more consistently on a shared cluster.ongoing: oncall ops support 24/7 pager rotation. Also rotate for helpdesk service to our team's internal customers. Writing and sharing reports on both.10/2015: Designing and implementing internal customer ETL change requests.

Over a year of Big Data consulting at a top wireless carrier. Part of a 15 person FTE Consultant team at our client. Designed and coded ETL, aggregation, and reports on Netezza and Hadoop platforms to support cellular engineers. Worked on billion and trillion row database fact tables of phone calls, data sessions, and text messages from all carrier sources. Used, designed, and populated data warehousing dimension tables to support user reports with nzSQL. Participated on platform and data model upgrades, migrating and testing SQL and ETL job code to new design. Server Environment: IBM PureData System for Analytics (Netezza), three 920 core massively parallel servers. 28 full racks for these three servers. 128-node Hortonworks Hadoop cluster. Multi-Petabyte environment. HIVE, HiveQL.Non-Client work included researching Hadoop for consulting Team. Used Redhat and CentOS Linux, Ambari, HDFS, MapReduce, Pig, Sqoop, HBase, and Phoenix, JDBC, SQL Workbench/J, SQuirreL. Also used AWS products RDS, Redshift, MySQL, PostgreSQL, SQL Server, MicroStrategy, SSRS.-3/2015 Found data bug after vendor migration, now developing ETL code and change management procedures to fix columns loaded for months with 2.5 billion rows a day. Involves multiple IBM servers, tables, and data relationships. Also working to resolve data and ETL issues other teammates found.-9/2014 Testing and scheduling 70 recurring reports for our Hortonworks Data Platform 2.1 upgrade (HADOOP HIVE) on 1,008 cpu core server.-9/2014 Deep troubleshooting on documented million dollar International marketing campaign loss. Took the lead developing and sending 20 detailed reports to team documenting the issue. Resulted in LG Ericsson acknowledging deploying the bug to our voice switches and correcting it.

My primary focus at f5 is Microsoft SQL Server development on our own 1st party, internal Manufacturing database. This is the database that tells our global vendors which parts to assemble, assigns serial numbers, mac addresses, registration keys, records passed and failed test results, shipping and interfaces. I maintain and write new stored procedures, views, tables, and relationships. I maintain and document code for multiple external interfaces, global replication, security, performance, and error handling on 20+ production, engineering, pre-prod, test, and development servers.Technologies used here:Database Design, ETL, SSIS, SQL Server Data Tools, ADO.NET, C# .NET, Oracle interfaces, Oracle view maintenance, TOAD, tnsnames, National Instruments LabVIEW test software, Flextronics, Oracle Agile PLM, Clarify, Siebel CRM Incident Management, Ceridian Dayforce Payroll and Time and Attendance, Amdocs Clarify CRM, Concur Travel and Expense, Visual Studio, Oracle Agile PLM integration, TortoiseSVN, SVN, Service-Now.com IT Service Management Suite

Hired into Sales IT as a Siebel CRM SQL backend developer. Stayed a SQL developer in Sales and Marketing IT for all eight years at Microsoft through 8+ reorgs and multiple technology changes from multiple versions of Siebel to Dynamics CRM 3.0, 4.0, and 2011 and SQL Server 2000, 2005, 2008, R2, and SQL 2012.The primary application I enhanced and migrated multiple times was a terabyte sized globally distributed, replicated, multiple line of business CRM supporting multiple call centers, field sales, executive reports, and extensive integrations to other Microsoft systems inside and out of Sales and Marketing IT.Experience with Microsoft Dynamics CRM, C#, .NET, and Siebel.

Database developer and administrator in the Washington Mutual credit risk department. Managed terabyte sized SQL databases, led database design and implementation on web development teams. Heavy integration with legacy lending systems.

Database and network administrator for Diagnostic Ultrasound for two years after the .com crash.

Hired into Excel Data. Temporarily bought out by Cambridge Technology Partners. Now it's CompuCom.Microsoft SQL Server consultant for about 15 clients located in New York, LA, Denver, New Jersey, Oklahoma, plus several local Seattle and Bellevue companies..com database modeling, disaster recovery planning, performance tuning, security, and business intellegince.