Izzy Lazerson
Verified Expert in Engineering
Software Engineer and Database Developer
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.
Portfolio
Experience
Availability
Preferred Environment
Toad, Git, Visual Studio Code (VS Code), Linux, Windows
The most amazing...
...thing I've developed is a highly complex, full-stack anti-money laundering (AML) application under an extremely tight deadline.
Work Experience
Senior Software Engineer
M&T Bank
- Built 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.
- Performed complex and advanced database and query tuning.
- 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.
- Set up transactional replication from our OLTP environment to the reporting environment.
Senior Software Developer
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.
Database Developer
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 coordinate Oracle Financials Concurrent Requests.
- Developed batch processes to import bank transaction files into Oracle Financials.
- Tuned performance of multiple applications/reports.
Experience
Back-end Book App
Front-end Book App
Sample Tax Database
Skills
Languages
Go, T-SQL (Transact-SQL), SQL, Python, JavaScript
Tools
BigQuery, Git, Toad, SSAS
Paradigms
ETL, Database Design
Platforms
Oracle, Azure, Windows, Linux, Visual Studio Code (VS Code)
Storage
PL/SQL, Databases, Database Architecture, Database Testing, Microsoft SQL Server, SQL Server 2016, MySQL, PostgreSQL, SQL Server Reporting Services (SSRS)
Other
Data, Performance Tuning, Query Optimization, Schemas, Data Engineering, Reporting, Data Migration, Machine Learning, Data Warehousing, Data Warehouse Design, Front-end
Libraries/APIs
Node.js, React
Education
Bachelor of Science Degree in Computer Science
SEC - Haifa, Israel
Certifications
Data Science Certificate
Springboard
NVCC Business Intelligence Certifcate in Database Development
Noetix
Oracle Developer Certificate in Database Development
GuruSoft
Microsoft SQL Server Developer Certificate in Database Development
SEC
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