Matthew Ropp Email and Phone Number
Matthew Ropp's Location
Los Angeles Metropolitan Area, United States, United States
Matthew Ropp's Contact Details
Matthew Ropp work email
- Valid
- Valid
- Valid
Matthew Ropp personal email
n/a
Matthew Ropp phone numbers
About Matthew Ropp
At Revenue.io, my focus on migrating legacy ETL/ELT jobs to Apache Airflow has dramatically improved job reliability and visibility, showcasing my proficiency in data architecture and Python programming. My work in leveraging Salesforce data via API integrations has delivered actionable insights for sales pipelines, a testament to my commitment to impactful data solutions.My design and implementation of data pipelines using Generative AI for customer interactions highlight my ability to innovate and drive value. With the support of my team, we've enhanced coaching and follow-up mechanisms, empowering our clients with refined sales strategies and performance insights. My role as a mentor underscores my dedication to fostering technical growth and excellence within our engineering community.
Matthew Ropp's Current Company Details
Matthew Ropp Work Experience Details
-
Senior Data EngineerRevenue.Io Apr 2020 - PresentLos Angeles, Ca, Us• Migrated all legacy AWS Glue ETL/ELT jobs into Redshift to run in Apache Airflow, substantially increasing visibility and reliability of those jobs.• Architected and developed system to extract customer Salesforce data via Salesforce Bulk API and leverage that data to enhance the metadata for customer conversations on our platform, resulting in valuable insights for customer sales opportunity pipelines.• Designed and implemented data pipeline to create summaries, follow emails, coaching feedback, and coaching scorecards for customer conversations using Generative AI.• Mentored junior engineers in design and best practices, as well as reviewing their work both interactively and via pull request.• Performed performance tuning on Redshift cluster and tables, resulting in significant performance improvements for customer facing reports.• Technologies: Python, Airflow, Redshift, S3, SQS, SNS, AWS RDS: PostgreSQL and MySQL, Bash, AWS Glue, Salesforce, Metabase, Git, GitHub, Jira
-
Senior Data EngineerRingdna (Rebranded As Revenue.Io) Apr 2020 - Nov 2021
-
Senior Data EngineerLereta, Llc May 2019 - Feb 2020Pomona, Ca, Us• Delivered a modern cloud-based ETL pipeline to replace components of a 30+ year old IBM mainframe system, enabling acquisition of new loans for mortgage tax services clients• Mentored junior team members in Python coding standards and Git• Technologies: GCP, Python, BigQuery, Cloud SQL, SQL, dbt, Airflow, PostgreSQL, Bash, Git, GitHub, Jira -
Senior Data EngineerWizeline Aug 2018 - Apr 2019Zapopan, Jalisco, Mx• Delighted client by creating bookkeeping website, including ML to auto-categorize transactions, as part of a cross-functional team (designed and implemented PostgreSQL RDS database, Lambda functions, and API Gateway endpoints)• Delivered a quality product through a key role in QA of the project and code review of backend components• Technologies: AWS, RDS, Lambda, API Gateway, S3, IAM, Python, PostgreSQL, Docker, Bash, Git,GitHub, Jira -
Senior Software Engineer (Data)Openx Jun 2016 - Aug 2018Pasadena, Ca, Us• Reduced unit costs without sacrificing performance by moving multi-terabyte datasets from Vertica to Impala, writing PySpark ETL jobs to source data from various APIs, HDFS, and Vertica, transforming the data, and writing to Parquet format files on HDFS• Supported critical business initiatives by adding new features and data points to Python and Vertica ETL framework, coordinating with product management, business users, and reporting teams• Enabled internal reporting teams by instructing and supporting users on nuances between Vertica and Impala SQL, as well as important performance tuning considerations• Enhanced key partner reporting dashboards by adding addition data points to ETL for Druid datastore• Technologies: Spark, Python, Impala, Vertica HPE (MPP), Hive, SQL, Parquet, HDFS, webhdfs, Bash, Druid, Java, RIAK, Docker, Chronos, Apache Mesos, Git, GitHub, Jira -
Senior Software Development Engineer (Data)Yahoo Feb 2015 - Jun 2016Sunnyvale, Ca, Us• Made major improvements to Oozie jobs by implementing a shared library, standardizing alerting job failures and SLA miss, analyzing and documenting job dependencies, and optimizing jobs for parallelism, resulting in maintainable ETL and significantly reducing HDFS namespace usage• Supported new business initiatives by developing and testing DDL and ETL scripts for loading new tables into Oracle data warehouse• Implemented HDFS data retention process for various output grains and archived data beyond retention into HAR files, greatly reducing our namespace usage and allowing project to survive with existing namespace• Technologies: Oozie, Pig, Oracle, SQL, PL/SQL, HDFS, Bash, Git, GitHub, JIRA -
Sr. Software Development Engineer (Sales Tools)Yahoo Jul 2011 - Feb 2015Sunnyvale, Ca, Us• Kept critical sales tools running by greatly improving ETL needed to support those tools, replacing legacy "shoestring" ETL with a production framework using Oozie, Pig Latin, Perl, HDFS Proxy, and MySQL• Enabled monitoring and alerts at various stages in this framework, significantly reducing the complexity of ETL debugging• Successfully migrated sales tools for over 15 international markets to the Yahoo! Bing Network by taking point in understanding new features and how those changes would affect sales, the data received, and sales tools features and modifying ETL to support those changes• Trained Beijing contracting team on best practices and clarified requirements for that team to be successful developing PL/SQL packages for an Excel reporting plugin, enabling sales users to sell ads effectively after migration to the Yahoo! Bing Network• Empowered sales and other business users to understand the data and drivers for Yahoo’s emerging search advertising products through ad hoc reporting• Technologies: Oozie, Pig, Perl, Hive, MySQL, Oracle, PL/SQL, Bash, Subversion, Git, Jira
-
Sr. Software Development Engineer (Business Information Group)Yahoo Oct 2007 - Jun 2011Sunnyvale, Ca, Us• Provided key insights to sales teams through development of reporting dashboards, coding pages in PHP and JavaScript and developing aggregated datasets and the SQL to retrieve them• Enhanced team productivity and quality by mentoring team members in best practices for Perl, Unix shell scripting, and SQL programming• Provided high level of support to internal business users by developing production and ad hoc reports in a Unix based multi-terabyte and multiple instance Oracle environment• Technologies: PHP, JavaScript, MySQL, Oracle, SQL, PL/SQL, Perl, Bash, Subversion, Bugzilla
-
Senior Data Warehouse EngineerIdealab Apr 2006 - Oct 2007Pasadena, Ca, UsPerfect Market Technologies, Inc. (Snap.com) -
Senior Database DeveloperYahoo! Search Marketing Jun 2004 - Apr 2006Sunnyvale, Ca, Us Led the migration of over 900 reports and jobs from legacy data warehouse to new data marts along with a major change in business logic. Took the lead for the reporting team on development of non-SQL based aggregations using Perl and shell script based frameworks. Built numerous very large (yet scalable) aggregated tables using these methods. Provided consistent, timely, and accurate adhoc support for a variety of business groups, most notably Content Solutions, Customer Services, Product Management, Business Planning, and various departments in the Tokyo office. Primary point of contact for all legal related reporting requests, delivering data both for internal litigation needs and 3rd party subpoenas under strict deadlines. Mentored new hires to the reporting group.
-
Senior Database DeveloperYahoo! Search Marketing Sep 2003 - Jun 2004Sunnyvale, Ca, Us(renamed to Yahoo! Search Marketing)
-
Senior Database DeveloperOverture Services Oct 2001 - Sep 2003Us(acquired by Yahoo!) Developed various near real-time tools to monitor hourly revenue by affiliate partner implementation, hourly revenue for various matching technologies, and potential negative advertiser affects of new matching technologies. Took the lead on understanding and internalizing various new product initiatives throughout the company, most of which ultimately affected reporting and the numbers our internal and external customers needed to see. Distributed that information to the rest of the group. Successfully managed transition to the Tokyo office where I was the single first point of contact for all data related requests. Handled this primarily in the Japanese language. -
Database DeveloperGoto Oct 2000 - Oct 2001(renamed to Overture Services) Rescued an ailing implementation of Goto's LWES (light-weight event system) based data capture system for Goto Shopping, producing reliable data feeds, relevant aggregations, and end user reports. Took the development lead on both adhoc and published reports for Overture's proprietary advertiser editorial and customer relationship systems. In the absence of documentation, this often involved reverse engineering the data present in the database in order to meet customer requirements. As a result turned a damaged relationship between the end reporting users for these systems into happy customers of the reporting group.
-
EngineerPaymybills.Com Jun 1999 - Oct 2000 Led design and implemented API and XML interface for three-tier architecture, using mod_perl, XML, and Java. Played integral role in coding team for database migration to Oracle, migrating many complex queries and modules dealing with the database from Perl DBI to a software database layer. Wrote technical specifications and implemented new features for web site application. Determined specifications, coded, and tested reporting, fraud detection, and database maintenance scripts. Developed and maintained major features of customer support tool web interface. Maintained MySQL database integrity, performed emergency data restoration, and executed manual updates to meet customer support requests. Produced front-end of web application using HTML, JavaScript, and CSS.
-
Software Localization IntegratorJumpstart / Knowledge Adventure Jul 1994 - Dec 1997 Responsible for preparation, management, and implementation of the localization of children's educational multimedia titles for international software markets in over ten European, East Asian, and Semitic languages. Trained engineers in Dublin, Ireland office on use of Knowledge Adventure software engines and integration of products. Products localized include 3D-Body Adventure, My First Encyclopedia, Aviation Adventure, Spider-Man Cartoon Maker, Steven Spielberg’s Director's Chair, and JumpStart Pre-K and Kindergarten.
Matthew Ropp Skills
Hadoop
Software Development
Big Data
Databases
Apache Spark
Pyspark
Apache Pig
Impala
Oozie
Hive
Shell Scripting
Oracle
Mysql
Pl/sql
Sql
Oracle Sql
Data Warehousing
Relational Databases
Data Marts
Sql Tuning
Unix
Linux
Bash
Python
Perl
Javascript
Php
Xml
Html
Css
Git
Subversion
Cvs
Search Advertising
Business Intelligence
Project Management
Adtech
Agile Methodologies
Performance Tuning
Integration
Docker
Druid
Vertica
Scala
Spark
Data Engineering
Postgresql
Database Development
Matthew Ropp Education Details
-
Kalamazoo CollegeJapanese -
Fuller Theological SeminaryMissiology
-
University Of MichiganJapanese
-
Waseda UniversityJapanese Studies
Frequently Asked Questions about Matthew Ropp
What company does Matthew Ropp work for?
Matthew Ropp works for Revenue.io
What is Matthew Ropp's role at the current company?
Matthew Ropp's current role is Senior Data Engineer at Revenue.io with 30+ years experience in data engineering.
What is Matthew Ropp's email address?
Matthew Ropp's email address is ma****@****pps.com
What is Matthew Ropp's direct phone number?
Matthew Ropp's direct phone number is +166179*****
What schools did Matthew Ropp attend?
Matthew Ropp attended Kalamazoo College, Fuller Theological Seminary, University Of Michigan, Waseda University.
What are some of Matthew Ropp's interests?
Matthew Ropp has interest in Social Services, Children, Computers, Gardening, Reading, Poverty Alleviation, Rollerblading, Science Fiction, Singing.
What skills is Matthew Ropp known for?
Matthew Ropp has skills like Hadoop, Software Development, Big Data, Databases, Apache Spark, Pyspark, Apache Pig, Impala, Oozie, Hive, Shell Scripting, Oracle.
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
Aero Online
Your AI prospecting assistant
Select data to include:
Total price:
$0.00
0 records × $0.02 per record
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.
Start your free trial