Roy Ammeraal

Roy Ammeraal Email and Phone Number

Senior Data Engineer | Delivering High Quality Data in a Timely Manner | DBT | Data Architecture @ ROR
Roy Ammeraal's Location
San Pedro, California, United States, United States
Roy Ammeraal's Contact Details

Roy Ammeraal personal email

About Roy Ammeraal

Driven by a passion for making high quality business data available in a timely and consistent manner, I've built a strong foundation in data engineering, through 15+ years of experience at a number of companies like SpaceX, Myspace, American Honda and a number of smaller startup companies in different industries.In these roles, I consistently demonstrated problem solving by automating the manual process of gathering all parts that went into rocket manufacturing (taking 1 person 1 month previously), architected a cloud-based data store from scratch enabling a flexible approach to create more reports.Now, I'm eager to continue to leverage my skills in data engineering, where I can continue to streamline data flows, put in checks and balances during the ETL process, creating more data pipelines to have more availability on data while I mentor people on best practices and evangalize data throughout the company.Most recently, I worked at Hyperloop One, where I created the architecture for simulation software to predict optimal schedules on linear networks with autonomous vehicles. This involved complex data modeling, processing, and analysis, as well as collaboration with engineers, analysts, and stakeholders across the organization. Previously, I was a data engineer and manager at Ruggable and PeerStreet, where I led the development and improvement of data warehouse and reporting platforms, implemented DBT and Agile methodologies, and reduced run-time of large data sets. I am passionate about solving data challenges and delivering value through data-driven insights and innovation.

Roy Ammeraal's Current Company Details
ROR

Ror

View
Senior Data Engineer | Delivering High Quality Data in a Timely Manner | DBT | Data Architecture
Roy Ammeraal Work Experience Details
  • Ror
    Principal Data Engineer
    Ror Feb 2024 - Present
    Las Vegas, Nv, Us
  • Hyperloop One
    Senior Data Engineer
    Hyperloop One Nov 2022 - Dec 2023
    Created architecture for simulation software to predict optimal schedules on linear networks with autonomous vehicles.
  • Ruggable
    Data Engineer & Manager
    Ruggable Sep 2021 - Oct 2022
    Created architecture for near real-time reporting while stabilizing current architecture. Spear-headed theimplementation of DBT, including mentoring the data engineering team. Helped transitioning the dataengineering team to use Agile methodologies. Reduced run-time of larger data sets on Redshift by moving these to DBT.
  • Peerstreet
    Data Engineer++
    Peerstreet Jan 2018 - Aug 2021
    Los Angeles, California, Us
    Created a data warehouse from scratch. Directed general architecture, coding and processing standards for the Data Warehouse. Provided guidance to business users on the various databases created, usage and data ready expectations.
  • Space Exploration Technologies
    Data Warehouse Engineer
    Space Exploration Technologies 2012 - 2016
    Hawthorne, California, Us
    Created an enterprise class data warehouse from scratch, including orchestration, ETL and Data Quality processes. Responsible for setting coding and processing standards for the data warehouse side as well as the OLTP side. Mentored and guided BI developers on Data Warehouse best practices.
  • Myspace Music
    Lead Data Warehouse Engineer
    Myspace Music 2009 - 2011
    Beverly Hills, Ca, Us
    Managed daily operations (including daily maintenance, monitoring, troubleshooting, resolving production issues, identifying and implementing data life cycle management strategy and ensuring quality) of all music related data warehouse data and processes on an Aster nCluster environment in a dynamic, agile and high data availability environment. Requirement gathering and analysis, planning tasks, estimating level of effort, identifying dependencies and collaborating with front-end teams across multiple verticals, designing and developing data feed processes to support business reporting and delivery of data to consumers. Managed team of three software engineers and one QA engineer.
  • Adconion Media Group
    Sr. Data Warehouse Engineer
    Adconion Media Group 2007 - 2008
    London, Gb
    Created an automated regression test suite to support testing the ETL procedures. Created a framework that facilitates the creation and administration of aggregation tables used in the data warehouse. Set up a reporting environment based on both Pentaho and Jasper Reports environments. Design and development of SQL queries required for reporting. Set up procedures to release reports to the QA and production environments.
  • American Honda Motor Company, Inc.
    Sr. Database Developer
    American Honda Motor Company, Inc. 2006 - 2008
    Torrance, Ca, Us
    Designed, developed and deployed a data warehouse (including related ETL processes for both fact and dimensional data) to support reporting for the interactive sales and marketing department. Created standards for stored procedure programming and database object naming. Redesigned structure and interaction between SQL Server jobs, DTS packages and stored procedures.
  • Itg Inc
    Sr. Software Engineer
    Itg Inc 2001 - 2006
    New York, Ny, Us
    Designed, developed and deployed a number of upgrades to enhance ticket booking from brokerage transaction. Migrated legacy code from C to C++. Enhanced development environment to facilitate deployments. Performed enhancements on the report calculation engine. Enhanced the database schema as well as interaction with the database by implementation of referential integrity, reducing the number of critical errors by 80% and redesigning major parts of the data model, improving performance of the application by 10%.
  • C-Bridge
    Technical Lead
    C-Bridge 2000 - 2000
    Us
    Provided technical direction to team of (6 people) to launch an intranet portal designed to allow more accessibility to hard disk design process (definition, design, development and deployment). Assisted in defining technical architecture. Successful completion of this project led to a number of follow-on projects with Seagate.Provided technical direction to development team to create company-wide framework to monitor internal processes using HP Openview.
  • Cambridge Technology Partners
    Technical Lead
    Cambridge Technology Partners 1993 - 2000
    Minato, Tokyo, Jp
    Led a team of four associates responsible for designing a data warehouse for a leading home construction company. Led a team responsible for integrating external systems in a Scopus-based CRM system for a satellite TV company. Design, development, design and deployment of a data warehouse migration toolkit to enable new data feeds into an existing data warehouse. Provided general UNIX guidance and support to the client team. User Interface coordinator, DBA and deployment lead for a team that created a automated data transfer process between financial institutions. Senior developer of a travel reservation system for a leading travel agency.

Roy Ammeraal Skills

Data Warehousing Sql Microsoft Sql Server Etl Databases Data Modeling Unix Data Integration Software Engineering Perl Unix Shell Scripting Database Design T Sql Scrum Performance Tuning Testing C Linux Oracle Project Management Sql Server 2000/2005/2008 Postgresql Solaris Microsoft Windows Ssis Sybase Aster Ncluster Sybase Ase Oracle Sql C++

Roy Ammeraal Education Details

  • De Haagse Hogeschool / The Hague University Of Applied Sciences
    De Haagse Hogeschool / The Hague University Of Applied Sciences
    Computer Science

Frequently Asked Questions about Roy Ammeraal

What company does Roy Ammeraal work for?

Roy Ammeraal works for Ror

What is Roy Ammeraal's role at the current company?

Roy Ammeraal's current role is Senior Data Engineer | Delivering High Quality Data in a Timely Manner | DBT | Data Architecture.

What is Roy Ammeraal's email address?

Roy Ammeraal's email address is ro****@****cex.com

What is Roy Ammeraal's direct phone number?

Roy Ammeraal's direct phone number is +131056*****

What schools did Roy Ammeraal attend?

Roy Ammeraal attended De Haagse Hogeschool / The Hague University Of Applied Sciences.

What skills is Roy Ammeraal known for?

Roy Ammeraal has skills like Data Warehousing, Sql, Microsoft Sql Server, Etl, Databases, Data Modeling, Unix, Data Integration, Software Engineering, Perl, Unix Shell Scripting, Database Design.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.