Accomplished Software Engineer with Integrations Expertise

Anthony Victor Lorenzo

347-***-**** Sebring, FL 33870

*****************@*****.***

www.linkedin.com/in/anthony-victor-lorenzo-kaizen/

SOFTWARE ENGINEER

Seasoned and hands-on Software Engineer optimizing and managing database reporting systems,

integrations and ETL for the nonprofit, behavioral health, financial and eCommerce industries

Skills

Experience Highlights

Languages

T-SQL, C#, VB.Net, ASP.Net, Delphi, JavaScript, PowerShell

Technologies

ETL, EHR, CRM, HL7 v2.x, FHIR stu2/3, JSON, XML, SOAP, API, RESTful, Web Services

Tools

Visual Studio, JIRA, TFS, GitHub, SSMS, SSRS, SSIS, SQL Server 2000-2019, Excel, MS Project, Visio, Neuron ESB, Mirth. Spark, DevExpress, Infragistics, Crystal Reporting

Processes

Agile, Scrum, Kanban, SDLC, OOP, WCF/MVC Software Systems

Standards

HIPAA, PHI, FHIR, ICD10/CPT, EDI, SEC, FSA, ONC

Director of Software Engineering (Software Integrations)

The Fortune Society, NYC, NY [remote] Dec 2013-Nov 2022

Revamped internal CRM with C#/VB.Net MVC, SQL Server 2012, enhancing user productivity by 30%, optimized 200+ SSRS reports for 50% faster queries

Optimized integration of internal CRM with Accumedic EHR, converting SQL data to FHIR as conical for HL7 consumption, leveraging tools including Mirth, Spark, and MongoDB, resulting in a 30% increase in effic iency and 25% reduction in errors

Managed ETL migration to new external Case Worthy CRM providing PowerShell scripts to sequence stored procedures and SSIS optimizing and reducing database size from 200 GB by 75%

Spearheaded BRP NYC Office of the Mayor’s contract expanding staff and clients by 20%. Developed ETL and back-end integrations for EHR and CRM bi-directional transfer using SQL Server 2019, SSIS, Stored Procedures, ESB, JSON, RESTful APIs C# to CRM Web Services increasing daily transaction count by 30,000

Software Engineer Consultant

Red Bit Systems, Long Island City, NY [hybrid] Oct 2012-Nov 2013

Automated the Integration multiple inventory data feeds into the Magento eCommerce B2B system, reducing the manual processing time from 2 days to just 1 hour, significantly enhancing system efficiency via C#, SQL Server 2014 Web Services, and SSIS

Remodeled SQL Server table-based utility system written in C# to add in and sequence new file imports thus not requiring any code adjustments unless a new file format was provided, CSV, Fixed, EDI, JSON, XML

Director of Software Engineering (co-Owner)

Financial Sockets Hoboken, NJ [hybrid] Oct 2004-Sep 2007

Accomplished a completely new system, RECAP, for a global post-trade order management system for UK/US clients providing FSA/SEC compliant reporting on budgeting procedure, increasing clients to 15 from 2. Target client base of top 10% buy-side brokers

System built in SQL Server, 2000. ASP.Net, C#, and Crystal reporting. SSIS trade data imports and integrations into the system. Designed and implemented to be housed within internal LAN of client or on the internet where we managed the SQL Servers and exposure

Incorporated external currency exchange Web Services consumption to house the necessary exchange rates between brokerage and clients for both internal and external reporting for clients. Written in combination of C#, T-SQL and SSIS

Software Engineering Manager

Eze Castle Software, Boston, MA Jan 2004-Aug 2004

After the purchase of the "Commission Optimizer" software package from BNYESI, continued with Eze maintaining the product and managing staff. Assisted with integration of software processes and integration into software development, database, QA, and customer service teams along with coordination of senior management

Established direct integration of Eze's TOMS (Trade Order Management System) which primarily focused on Hedge funds increasing clients by 50% from 35 to 50

Development in SQL Server 2000 and Delphi v6-7, Microsoft SourceSafe, Visual Studio C# dot Net framework 1.0-2.0, and DevExpress controls

AVP Commission Optimizer

BNY ESI, division Bank of New York, NY, NY Oct 1998-Jan 2004

Commission Optimizer (CO) version 2.0 was built using Borland Delphi v2-5 and SQL Server 7.0-2000, Crystal Reports v7-10 and DevExpress. Complete redesign of database schema, ETL of commission trade data in various file formats from external trading applications planned as a tabular and configurable based integration

Complete OO implementation of front end with heavy use of Component design, implementation, reuse, and global exception handler providing a consistent UI (User Interface) application for data entry and reporting capabilities

March 2001, promoted to AVP (Assistant Vice President) providing coordination between Senior Management, project management of development and client support

Senior Software Developer

PSCU Services, St. Petersburg, FL May 1996-Sep 1998

Hired as Junior Developer to assist with development and maintenance of internal Borland Paradox projects. Developed and managed importing and aggregating raw transaction data into internal databases. Supported and extended reports with "norm"/"asset" level comparisons of credit card usage and credit card programs

In June 1997, promoted to Sr Developer, designed new CSCDB (internal Client Database and reporting system) written in Borland Delphi 2.0 and Inter Base RDMS and Microsoft SQL Server 6.5, providing data entry support as well as extensive reporting

Education

BS Aviation Computer Science

ERAU Embry-Riddle Aeronautical University Daytona Beach FL

Software Engineering accredited by Carnegie Melon with focus on Software paradigms CMM model and SDLC, Database Design, AI, and models and simulation

Awards

Marquis’ Who’s Who 2024

Listing in Science and Engineering cohort 2024

Marquis

Fortune Fellows Award

Management acknowledgement

The Fortune Society

Fortune ES Committee

3-week Employment Services focused group

The Fortune Society

BNY Employee Award

Management recognition of excellence and major contributions

Bank of New York

PSCU Employee Month

Recognition of outstanding performance.

PSCU Services

Contact this candidate