Eugene Bolotin
Verified Expert in Engineering
Software Developer
Richmond Hill, ON, Canada
Toptal member since June 26, 2020
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
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
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
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.
Senior SAS Developer
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.
Software Engineer
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.
Software Quality Assurance Engineer
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.
Experience
School Quality Guide
Education
Master's Degree in Computer Science
City University of New York - Brooklyn - Brooklyn, NY
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
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring