Eugene is available for hire
Hire EugeneEugene 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
Experience
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.
Education
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
Skills
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