Eugene Bolotin, Developer in Richmond Hill, ON, Canada
Eugene is available for hire
Hire Eugene

Eugene Bolotin

Verified Expert  in Engineering

Software Developer

Richmond Hill, ON, Canada

Toptal member since June 26, 2020

Bio

Eugene is a data developer with 11 years of experience in SAS (including SAS/Base, SAS/Macros, and SAS/SQL) and 18 years of SQL Server and Excel. He has a proven track record of finding obscure bugs, improving code efficiency, and solving complex problems.

Portfolio

Enrich Software Corp
SQL, IBM Db2, Query Optimization
NYC Department of Education
Batch Scripting, Slack, Microsoft Excel, Microsoft SQL Server, SAS
Thomson Reuters
Batch Scripting, Visual Studio, Visual SourceSafe, NUnit, JavaScript...

Experience

  • Testing - 17 years
  • SQL - 17 years
  • Microsoft Excel - 17 years
  • Excel VBA - 17 years
  • Test-driven Development (TDD) - 13 years
  • ETL - 11 years
  • SAS - 11 years
  • SAS SQL - 11 years

Availability

Part-time

Preferred Environment

Slack, Windows

The most amazing...

...thing I've done is a massive redesign of the back end of the NYC School Quality Guide, reducing the production time of an annual product by four months.

Work Experience

Senior Database Developer

2020 - 2022
Enrich Software Corp
  • Improved performance of queries embedded in a proprietary application dramatically, allowing a major rollout to the company’s biggest client to go out on time.
  • Reduced internal support requests by 85% by providing comprehensive instructions and documentation.
  • Became the go-to expert in a system I've never seen before within 2 weeks.
Technologies: SQL, IBM Db2, Query Optimization

Senior SAS Developer

2009 - 2020
NYC Department of Education
  • Re-implemented the back end, shortening the annual release cycle of the high school progress reports by four months.
  • Cut the production time of the NYC School survey reports, which serve 1.1 million students, parents, and teachers, by a factor of 10.
  • Re-implemented a high-priority data aggregation process, reducing its runtime by 75%.
  • Designed and developed code to assemble, sanitize, process, summarize, and output 100 million record datasets.
  • Developed tools to clean data and assist in analysis.
  • Automated basic tasks for other team members, saving them an average of approximately 15 minutes per day each.
  • Created and produced complicated reports and dashboards in Excel.
Technologies: Batch Scripting, Slack, Microsoft Excel, Microsoft SQL Server, SAS

Software Engineer

2007 - 2009
Thomson Reuters
  • Shortened a daily compliance export service runtime by 94% (from over 13 hours to under 45 minutes).
  • Improved an ETL application's performance by 30%, extending its service life by one year and allowing sufficient time to develop a replacement.
  • Developed and deployed robust back-end and middle-tier components that service 250,000 customers.
Technologies: Batch Scripting, Visual Studio, Visual SourceSafe, NUnit, JavaScript, Visual Basic, SQL, ASP.NET, C#, C++

Software Quality Assurance Engineer

2003 - 2006
Thomson Reuters
  • Discovered nearly 40% of all bugs reported against the Reuters messaging system in 2005 (approximately 2,500 out of 6,500 unique issues reported).
  • Created scripts to aid in data collection and reporting, decreasing bug analysis and repair verification time by 10%.
  • Received "Reuters Ship It!" awards for Reuters Messaging 5.0 and 6.0 releases.
  • Performed manual and automated testing against back-end, middle-tier, and front-end components, testing functionality, scalability, and resilience.
Technologies: Batch Scripting, Tools, Microsoft Excel, SQL

School Quality Guide

https://tools.nycenet.edu/snapshot/2019/
A set of reports used by parents, school administrators, and central staff to evaluate school quality, target interventions, and flag potential problems and opportunities. I was the lead back-end developer responsible for collecting, assembling, sanitizing, checking, aggregating, and providing data to the front-end developers and other teams.
2007 - 2011

Master's Degree in Computer Science

City University of New York - Brooklyn - Brooklyn, NY

1999 - 2003

Bachelor's Degree in Computer Science

City University of New York - Brooklyn - Brooklyn, NY

Tools

Microsoft Excel, Slack, Visual SourceSafe, Visual Studio

Languages

SQL, SAS, Excel VBA, Visual Basic for Applications (VBA), C++, C#, Visual Basic, JavaScript

Paradigms

Test-driven Development (TDD), ETL, Testing

Storage

SAS SQL, Microsoft SQL Server, IBM Db2

Platforms

Windows

Frameworks

ASP.NET, NUnit

Other

SQL CTEs, Batch Scripting, Tools, Query Optimization

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