Matthew Ropp Email & Phone Number

Los 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

Pomona, 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

Zapopan, 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

Pasadena, 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

Sunnyvale, 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

Sunnyvale, 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

Sunnyvale, 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

Pasadena, Ca, Us

Perfect Market Technologies, Inc. (Snap.com)

Sunnyvale, 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.

Sunnyvale, Ca, Us

(renamed to Yahoo! Search Marketing)

Us

(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.

(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.

• 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.

• 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.

Bachelor Of Arts, Computer Science, Japanese

Master Of Arts, Cross Cultural Studies, Missiology

Intensive 2Nd Year Summer Course, Japanese

Japanese Studies