Eugene Bolotin, Batch Scripting Developer in Richmond Hill, ON, Canada
Eugene Bolotin

Batch Scripting Developer in Richmond Hill, ON, Canada

Member since May 28, 2020
Eugene is a data developer with 11 years of experience in SAS (including SAS/Base, SAS/Macros, SAS/SQL), and 17 years of SQL Server and Excel. He has a proven track record of finding obscure bugs, improving code efficiency, and solving complex problems.
Eugene is now available for hire

Portfolio

Experience

Location

Richmond Hill, ON, Canada

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.

Employment

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

Skills

  • Languages

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

    Microsoft Excel, Slack, Visual SourceSafe, Visual Studio
  • Paradigms

    Test-driven Development (TDD), Testing
  • Storage

    SAS SQL, Microsoft SQL Server
  • Platforms

    Windows
  • Frameworks

    ASP.NET, NUnit
  • Other

    Batch Scripting, Tools

Education

  • Master's degree in Computer Science
    2007 - 2011
    City University of New York - Brooklyn - Brooklyn, NY
  • Bachelor's degree in Computer Science
    1999 - 2003
    City University of New York - Brooklyn - Brooklyn, NY

To view more profiles

Join Toptal
Share it with others