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
Portfolio
Experience
  • Database Design, 13 years
  • SQL, 13 years
  • Business Intelligence (BI), 12 years
  • JavaScript, 9 years
  • Node.js, 4 years
  • Express.js, 4 years
  • React, 3 years
Buffalo, United States
Availability
Part-time
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.
Employment
  • Senior Software Engineer
    2015 - PRESENT
    M&T Bank
    • 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
    2008 - 2015
    Weight Watchers
    • 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
    2004 - 2008
    City of New York - HRA - APS - Financial Management Unit
    • 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
Experience
  • 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.

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