Roman Polonsky, Developer in San Francisco, CA, United States
Roman is available for hire
Hire Roman

Roman Polonsky

Verified Expert  in Engineering

Data Architecture Developer

Location
San Francisco, CA, United States
Toptal Member Since
June 18, 2020

Roman is a senior IT professional specializing in creating sustainable and flexible solutions. He has over 20 years of experience working for consulting companies, startups, and large corporations across multiple systems. Roman has a deep understanding of SQL queries for complex data analysis, profiling, and transformation and has successfully implemented relational, multidimensional, and object-oriented database models for clients.

Portfolio

Toptal Clients
Snowflake, Agile, SQL, PostgreSQL, Data Modeling, Data Architecture, Python...
Uber
Oracle ERP, Database Optimization, PL/SQL, Oracle, Oracle Database...
Google
Scalability, Data Architecture, Database Design, Google Development Tools...

Experience

Availability

Part-time

Preferred Environment

SQL, Amazon Web Services (AWS), Linux

The most amazing...

...project I've worked on saved $100 million in Google Grants—thanks to a solution architected to remediate waste and inefficiencies.

Work Experience

Technical Consultant | Database Engineer

2019 - PRESENT
Toptal Clients
  • Assisted multiple Toptal clients in implementing and enhancing multiple database solutions using PostgreSQL, Snowflake, BigQuery, and other database technologies as a technical consultant and database expert.
  • Converted clients' BigQuery data warehouse from Google Analytics 3 (GA3) sources to Google Analytics 4 (GA4). Worked with product and business teams to identify changes. Analyzed technical differences between GA3 versus GA4.
  • Prototyped various solutions to satisfy business needs for many metrics while building BigQuery solutions with GA4 data. Established a mechanism for defaulting missing GA4 data and linking various event types.
  • Integrated multiple external data sources using Fivetran, Hightouch, and Tray.io to move data into and out of Snowflake. Data is supplied in custom, pre-defined interfaces (Clickstream, Salesforce, etc.) and by calling various APIs.
  • Improved database performance by 10 times on multiple occasions. Built several executive reports and dashboards.
Technologies: Snowflake, Agile, SQL, PostgreSQL, Data Modeling, Data Architecture, Python, Data Engineering, ELT, Google BigQuery, Data Analysis

Senior Financial Engineer

2019 - 2019
Uber
  • Served as a technical lead on a five-person engineering team for a significant process improvement project, including reviewing and steering design practices and project designs. Implemented integrations and migrated between internal systems. Collaborated with global accounting teams and the product and compliance teams.
  • Rehabilitated and completed a stalled project that reduced accounting processes 3-4 days off of a process that formerly took a week, executed monthly. Eliminated frequent errors and added audit controls by designing and implementing a flexible and user-configurable system to automate transaction calculations and posting to meet global payroll, tax, and other obligations.
  • Delivered an executive reporting solution 1,000% faster than existing tools. It enabled on-the-fly setting reconfiguration to remediate a slow system with poor flexibility by designing and architecting the solution in collaboration with the finance and product teams. This resulted in a tool that streamlined and compiled data from multiple global markets and currencies used in strategic executive decision-making.
Technologies: Oracle ERP, Database Optimization, PL/SQL, Oracle, Oracle Database, Data Engineering, ETL, Data Analysis

Senior Sales Data Architect

2014 - 2019
Google
  • Took on the senior leadership architect and business analyst roles and delivered numerous solutions, generating over $100 million in savings. Built reporting tools, integrated reporting metrics, and transitioned reporting infrastructure platforms.
  • Delivered savings of $100 million for the Google Grants program that donates $2 billion annually to nonprofits. Designed a ranking mechanism facilitating communication prioritization and integrated APIs and pipelines with internal Google tools.
  • Created a BigQuery data warehouse for Google Grants with multiple data sources, including Google Analytics, external data, spreadsheets, and internal databases. Matching data allowed for greater transparency and improved accuracy.
  • Created architecture and design tools that compiled data, enabling executive reporting and generating insights—with the flexibility to adapt to ever-changing products. Collaborated with multiple teams to gather requirements and identify needs.
Technologies: Scalability, Data Architecture, Database Design, Google Development Tools, BigQuery, Data Engineering, Google BigQuery

Business Analyst

2013 - 2014
Google
  • Provided technical expertise to the business team while architecting reports and dashboards, sourcing data, and managing the quarterly reporting process. Collaborated with global agency sales operations in designing strategic and tactical solutions.
  • Delivered the capability to analyze the impact of team performance and presented findings to senior Google decision-makers. I was the sole senior technical resource on a business-focused agency support team, including partnering with clients and teams in over 30 countries to identify common threads and test multiple hypotheses. This resulted in the development of predictive algorithms applied to multiple regions and lines of business and integrating external data and internal pipelines.
  • Designed and built pipelines and dashboards to present data up to the CEO level, reflecting data gleaned from Google’s annual product and support customer survey executed in over 30 countries with 10,000 respondents.
Technologies: Database Optimization, Tools, Reporting

Senior Business Engineer

2005 - 2012
Google
  • Provided expertise in developing solutions and integrating client system’s with third-party products, including creating and customizing standard programs and reports, leading large-scale migrations into data warehouse environments, assessing and upgrading Oracle applications, designing/developing the Oracle-Salesforce-Oracle integration package, redesigning the Salesforce integration workflow, creating/customizing Oracle Apps Forms and Reports, developing notification and alert systems, improving client business workflows, automating external data processing, integrating Salesforce.com to client systems, Microstrategy, as well as Oracle Order Management with up and downstream systems, and implementing Oracle Data Warehousing solutions as well as customizations to Oracle Trade Management and International Trade Management.
  • Created a multimillion-dollar revenue stream by monetizing the enterprise-level Google Maps product. Built an interface to Maps API that extracted daily usage of each commercial client. Cross-referenced and loaded the data into the Oracle EBS Service Contracts module, where a pricing engine calculated billing charges encompassing integrating the needs of multiple teams, as well as products and technologies.
  • Increased the retention of paying Google Suite customers from less than 50% to more than 95% by automating customer renewals and two-way interfaces that handled numerous conditions and flows—in collaboration with a team comprising five business analysts and engineers.
Technologies: Oracle ERP, PL/SQL, Salesforce, Oracle, Data Analysis

Engineer

1994 - 2005
Previous Experience
  • Served as a project leader on the Cisco system (Oracle CRM/ERP installation).
  • Acted as a senior system designer and project leader on the Oracle Corporation lease management.
  • Worked as the project manager and senior consultant for Tarn Consulting, San Fransisco.
  • Worked as the database analyst and senior programmer for Cisco Systems (Oracle Financials).
  • Worked as the database analyst, senior programmer, and project leader at Reuters (South Africa, Switzerland, UK, and Canada).
  • Served as a designer, analyst, and trainer for IBM, Australia.
  • Performed activities as an analyst and programmer for the Roads and Traffic Authority, Australia.
  • Consulted on DBA projects at Services Pty. Ltd. (Australia).
Technologies: Web Technologies, Reporting, Oracle

Google Grants Dashboard

Delivered 1st-year savings of approximately $100 million for the Google Grants program that donates $2 billion annually to non-profits. I architected a solution that remediated waste and inefficiencies related to disbursements and created tools, dashboards, reports, and notifications to identify recipients needing assistance. I designed a ranking mechanism, facilitating communication prioritization and integrated APIs and pipelines with internal Google tools.

Oracle EBS Migration from On-Premises to Cloud

The client needed to move and upgrade multiple Oracle EBS modules from on-premise to a Cloud solution. Designed and implemented code generators to extract, validate, transform, and load data between instances.

Google Maps Monetarization

I created a multimillion-dollar revenue stream by monetizing the enterprise-level Google Maps product. I built an interface to Maps API that extracted daily usage of each commercial client, cross-referenced, and loaded the data into the Oracle EBS Service Contracts module, where a pricing engine calculated billing charges. This integrated the needs of multiple teams as well as products and technologies.

Customer Retention

Increased retention of paying Google Suite customers from less than 50% to more than 95% by automating customer renewals and two-way interfaces that handled numerous conditions and flowed between Oracle EBS and Salesforce.
2018 - 2019

Associate Diploma in Databases

Stanford University - Palo Alto, CA, USA

1992 - 1995

Bachelor's Degree in Computer Science

University of Technology, Sydney - Sydney, Australia

Libraries/APIs

Oracle API, Salesforce API

Tools

Oracle ERP, Adobe ColdFusion, BigQuery, Google Development Tools

Languages

SQL, SQL DDL, Snowflake, Python, Python 3, Python 2

Platforms

Oracle, Oracle Database, Amazon Web Services (AWS), Linux, Salesforce

Paradigms

Database Design, Agile, Waterfall Development, ETL

Storage

Oracle 11g, Oracle RDBMS, PL/SQL, Oracle PL/SQL, PL/SQL Developer, Databases, Database Triggers, SQL Architecture, Database Modeling, Apache Hive, PostgreSQL, MySQL

Other

Database Optimization, Database Table Optimization, Query Optimization, PL/SQL Tuning, Data Architecture, Data Modeling, Data Engineering, ELT, Google BigQuery, Data Analysis, Scalability, Reporting, Tools, Web Technologies, Salesforce Apex, Computer Science, APIs

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring