Scroll To View More
Izzy Lazerson

Izzy Lazerson

Buffalo, United States
Member since September 25, 2017
Izzy is an expert developer with over a decade of experience in building database-centric applications. His extensive background extends to core database development and administration, designing back-end server APIs, and constructing front-end UIs and reporting portals. Izzy has excelled on teams of various sizes and often takes on responsibilities outside of his primary role.
Izzy is now available for hire
  • SQL, 13 years
  • Database Design, 13 years
  • Business Intelligence (BI), 12 years
  • JavaScript, 9 years
  • Node.js, 4 years
  • Express.js, 4 years
  • React.js, 3 years
Buffalo, United States
Preferred Environment
Windows, Linux, Sublime Text, Git, SSMS, Toad
The most amazing...
...thing I've developed is a highly complex, full-stack Anti-Money Laundering (AML) application under an extremely tight deadline.
  • Senior Software Engineer
    M&T Bank
    2015 - PRESENT
    • Build back-end database systems to store AML cleansed data.
    • Worked on ETL processes that pulled and transformed data from numerous data sources.
    • Developed a back-end REST API and front-end web app to facilitate admin related tasks and analytics.
    • Drafted complex reports and dashboards for AML and Comprehensive Capital Analysis and Review (CCAR). Many of these reports were later delivered to the authorities.
    • Helped to migrate data from Oracle 11g to SQL Server 2014 to handle the AML data in the Hudson City bank acquisition.
    • Tuned performance parameters on application back-end.
    • Refactored the regulatory and risk reporting application to safeguard it against SQL injection attacks.
    • Used the TensorFlow machine learning library to identify possible location matches in our Master Data Management (MDM) system.
    • Followed a test-driven development (TDD) approach for all database ETL processes using Ruby-plsql-spec.
    • Setup transactional replication from our OLTP environment to the reporting environment.
    • Led code-reviews, established best practices, and taught classes on deep-dives in various programming topics.
    Technologies: Oracle, SQL Server, Node.js, React, SSRS, Azure, T-SQL, PL/SQL, JavaScript
  • Senior Software Developer
    Weight Watchers
    2008 - 2015
    • Built a back-end REST API and front-end web reporting/analytics portal.
    • Managed several data warehouse environments and their associated ETL processes.
    • Generated numerous reports across the enterprise including Finance, HR, and Supply Chain departments.
    • Developed report models that enabled users to create their own reports with drag-and-drop functionality.
    • Created multiple metadata layers and entity-attribute-value models to ease BI development and maintenance; among these environments were complex ERP systems.
    • Tuned performance of multiple applications/reports including intricate query-tuning and converting many cursor based processes to a declarative set-based approach.
    • Leveraged OLAP cubes for advanced analytics.
    • Led code-reviews, established best practices, and taught classes on deep-dives in various programming topics.
    Technologies: Oracle, SQL Server, Node.js, React, SSRS, SSAS, Azure, T-SQL, PL/SQL, JavaScript
  • Database Developer
    City of New York - HRA - APS - Financial Management Unit
    2004 - 2008
    • Built custom database processes to enhance the ERP system’s usability and functionality.
    • Implemented a front-end web reporting portal pulling primarily from an OLAP cube.
    • Enhanced the reporting permissions model to use row level security.
    • Generated dozens of reports that pulled from multiple modules including GL, AP, AR, etc.
    • Migrated legacy system data from multiple data sources and formats into the ERP system.
    • Developed shell scripts to launch and cooridnate Oracle Financials Concurrent Requests.
    • Developed batch processes to import bank transaction files into Oracle Financials.
    • Tuned performance of multiple applications/reports.
    Technologies: Oracle, SQL Server, SSRS, SSAS, T-SQL, PL/SQL, JavaScript
  • Book App Back-end (Development)

    Back-end demo database and API built with SQL Server and Node.js.

  • Book App Fron-tend (Development)

    Front-end demo book app built using React.

  • Sample Tax Database (Development)

    Database system to manage information on the collection of various types of taxes by a state agency.

  • Languages
    SQL, JavaScript
  • Libraries/APIs
    React.js, Node.js
  • Paradigms
    Database Design
  • Misc
    Business Intelligence (BI)
  • Frameworks
  • NVCC Business Intelligence Certifcate in Database Development
    Noetix - Orlando, Florida
    2006 - 2007
  • Oracle Developer Certificate in Database Development
    GuruSoft - Ontario, Canada
    2004 - 2005
  • Microsoft SQL Server Developer Certificate in Database Development
    SEC - Haifa, Israel
    2003 - 2004
  • B.S. in Computer Science
    SEC - Haifa, Israel
    2000 - 2004
I really like this profile
Share it with others