JIM ESPAILLAT • Senior .Net Developer / Architect Upper Saddle River, New Jersey (201) 489-1360 solutions@delphinusinc.com linkedin.com/in/espaillat • Full Stack Development • Mobile Development • Database Application Development • E/R and Data Modeling PROFESSIONAL EXPERIENCE Bloomberg Senior .NET Developer New York, NY (Remote) Jun 2022 – Jun 2023 Performed numerous enhancements on an employee compensation system, written using C#, .NET, Angular 11, and PostgreSQL. System consists of three primary components: a C# WebAPI application to handle complex business rules regarding user data access permissions, a separate C# WebAPI application hosting the primary business logic, in addition to an Angular 11/Node.js front end. Converted several batch applications, originally written with .NET Framework and Entity Framework, to .NET Core 6 and EF Core running on Linux. Modified several supporting programs written in Python. Summit Rock Advisors, New York, New York (Remote) Senior .NET Developer Nov 2021 – Jun 2022 Performed maintenance and enhancements on a portfolio management application, written in C# and .NET Core and implemented as a hybrid of WinForms and WPF, using SQL Server 2017. Converted database operations from Entity Framework 5 to EF Core. SES Satellites, Princeton, New Jersey (Remote) Senior .NET Developer Jan 2021 – Nov 2021 Developed a satellite and ground station monitoring system. Written in C# and .NET Core, with a Blazor UI, the system incorporates real-time telemetry data sourced from both Kafka and Azure DataLake, which is then propagated to the browser using gRPC streams. Interface elements were built using various Blazor (DevExpress, Radzen) and JavaScript (LightningChart, goJS, Cesium) components. Entity Framework Core was used to connect to both SQL Server and PostgreSQL databases. National Basketball Association, Secaucus, New Jersey .NET Technical Lead Nov 2019 – Jun 2020 Oversaw a team of five offshore developers in developing an application to manage security preparations for upcoming events. The application was written in C# and ASP.NET Core MVC, and used Entity Framework to interact with a SQL Server 2014 database. Corbin Capital Partners, New York, New York Senior .NET Developer Feb 2019 – Nov 2019 Performed maintenance on portfolio and risk management applications, written in C# and ASP.NET MVC, and implemented as single-page applications using Angular and WebAPI, and interfacing with WCF services. Used SignalR to apply real-time updates from Bloomberg Terminal API. Applied refactoring and performance improvements to numerous SQL Server stored procedures. Wrote SQLCLR procedures to invoke R libraries from within the database. Solely responsible for design and implementation of a new DevOps environment, consisting principally of TeamCity, Bitbucket (Git), and Jira. Migrated production database from SQL Server 2008 to 2017. Created process, integrating Git, TeamCity, and PowerShell, to not only perform continuous integration/deployment of source code, but to also synchronize production and test/dev databases with their respective release branches. U-Swirl, Durango, Colorado (Remote) Senior .NET Developer Jan 2018 – Oct 2018 Designed and developed a cross-platform mobile inventory system using Xamarin.Forms. Data entry applications were written to operate on both Android and iOS mobile devices using Azure offline sync features, with reporting and analysis functions written as a Windows desktop application. Microsoft SQL Server database was designed as a multi-tenant system on Microsoft Azure, exposed as a REST OData service, with third-party authentication provided by Auth0. BioReference Laboratories, Elmwood Park, New Jersey Senior .NET Developer Jul 2015 – Aug 2017 Performed extensive refactoring and maintenance on several business-critical application systems. Applications were written using a variety of tools, notably ASP.NET and both C# and VB.NET, using a Microsoft SQL Server 2012 database. Designed and wrote a new WebAPI interface for the internal order update subsystem. Performed maintenance on an Angular/WebAPI application to monitor order message traffic to the company’s billing system. Responsible for enhancements which included use of the Confluence REST API to store and retrieve documents, front-end integration with Tableau Server, and use of Ghostscript utilities to convert images to and from PDF. Responsible for setting up Git/Stash and TeamCity in a new continuous integration server configuration, and automating deployment to QA and Production environments. PwC (formerly Booz & Co), New York, New York (Remote) Senior .NET Developer Aug 2013 – Jan 2015 Designed and developed a single-page application website for internal use as part of the Fit for Growth product offering, to analyze and optimize proposed corporate restructurings being undertaken by Booz’s own clients. The data-centric application was written using ASP.NET and MVC 5/Razor, against a Microsoft SQL Server 2012 database, and was designed to make heavy use of JavaScript/jQuery and Knockout.js client-side view models to provide a responsive user interface. The application leverages Tableau Server software to provide enhanced data visualizations on the front end, and interfaces with the FICO Xpress optimization engine to provide cost-effective solutions to clients. Entity Framework 5 was used to manage interactions with the database. Completely redesigned the previous versions of both the application and the database, to effect not only a sizable reduction in the amount of data being processed, but also a resulting significant improvement in performance and reduction in the technical debt attributable to the original design. American Society of Mechanical Engineers, New York, New York Senior .NET Developer Jul 2012 – Aug 2013 Designed and developed a number of internal- and external-facing websites, using ASP.NET and MVC 4, against a Microsoft SQL Server 2008 database. JavaScript, AJAX and jQuery features were used extensively to optimize the user experience. Redesigned the single sign-on system (including front-end interface, web services, and database schema) used by most of the association’s public websites to improve data quality and allow for more flexible user registration. OneWorld, Inc., Parsippany, New Jersey .NET Architect / Senior Developer / Database Administrator Sep 2007 – May 2012 Responsible for multiple roles as an application developer, data architect, and database administrator. Created CLD, a platform for delivering pharmaceutical marketing content to health care providers at conventions, collecting provider data, and interfacing with clients’ CRM systems. Written in .NET, the system comprises multiple applications, all of the following which I personally designed and developed: • A VB/C#/SQL Compact front end which serves as the engine for dynamically displaying graphic content (both static and Flash images) based on custom configuration files, collecting data from physical card scans, and formatting data for transmission • Numerous SQL Server stored procedures used to configure the front end • A set of SSIS packages used to import client customer data into the primary SQL Server database • A number of C# and VB desktop applications used internally for scheduling and reporting Created DataVault, a CRM-like system for tracking the activities of individual health care providers across multiple clients and conventions. The system uses sophisticated algorithms written in .NET and deployed to SQL Server using SQLCLR, to standardize and match identifying information from various data sources, and hence of varying quality, along several dimensions (names, addresses, degrees, specialties, etc.) simultaneously. Served as development DBA supporting all OneWorld applications. Responsible for designing and maintaining table schemas, and enforcing coding standards for stored procedures. Used PowerDesigner to create and maintain E/R diagrams, and to generate change scripts as needed. Provided performance tuning and debugging support to other developers. Unilever (formerly Best Foods), Englewood Cliffs, New Jersey .NET Technical Lead May 2006 – Aug 2007 With a team of four developers, designed and developed a commission system to calculate payments to brokers. Application consists of an ASP.NET front end, written in C#, with business logic deployed as Transact-SQL stored procedures in a SQL Server 2005 database. Primarily responsible for overall application design and data modeling, as well as implementing most of the back-end business rules. Implemented numerous reports using SQL Server Reporting Services (SSRS). Also responsible for performing maintenance and enhancements on the legacy commission system, written in PowerBuilder 9 and Oracle 7/8. NYC Human Resources Administration, New York, New York .NET Developer Mar 2006 – May 2006 Converted Distributed PowerBuilder components to.NET components deployed on a COM server, and running against an Oracle 9i database. Used Sybase DataWindow.NET to leverage business rules embedded in legacy code. SetFocus, Parsippany, New Jersey .NET Developer Apr 2005 - Mar 2006 As team leader, designed and developed a multi-tiered IT Recruiter Placement Application, similar to Monster.com web site, with the capabilities to post jobs, search jobs and query reports. Project included building a Windows based front-end interface for managing the system and database. Created administrative security levels for different users, and wrote stored procedures. Technologies utilized included: C#.NET, SQL Server 2000, Transact-SQL, ADO.NET, ASP.NET, Web Services, COM+ and HTML. Developed a Windows n-tiered "Public Library Management System" application and then ported the application to a dynamic ASP.NET Internet/Intranet model utilizing the same secure middle tier data access components. Non-public web pages were secured using Windows integrated and ASP.NET forms security models. Used C#.NET and ADO.NET to define and implement secure middle-tier components using both connected and disconnected environment strategies. Components were consumed by web applications and windows applications utilizing SQL Server and stored procedures to perform logical business transactions. Created and deployed XML Web Services using ASP.NET. Consumed Web Services from both Windows forms and ASP.NET web applications. Created complex business components in C#.NET using .NET Class Library assemblies while migrating and implementing them in a multi-tier environment suitable for Microsoft Transaction Server (MTS) and COM+ to address application infrastructure issues associated with building scalable enterprise level applications used by many clients. Time Inc., New York, New York Senior PowerBuilder Developer Jun 2005 - Mar 2006 Performed enhancements on OMS, a magazine layout and composition system written in PowerBuilder 9, to improve the performance of image rendering and page manipulation routines. Added several reports using Sybase EAServer as an application middle tier. Using Java 1.4 and JAXB, enhanced the XML interface between OMS and BOSS, an ad sales tracking system. Instituted new procedures for using PVCS version control. Alliance Capital Management, New York, New York Senior PowerBuilder Developer Jan 2004 - Jun 2005 Performed enhancements on APEX, a fixed income trading system, to improve compliance with Sarbanes-Oxley audit and security requirements. Made extensive improvements to the tracking of bond quality ratings and sector classification schemes within the application. Responsible for dozens of minor corrections and enhancements to the system. APEX was written in PowerBuilder 6.5 and converted to PowerBuilder 9, running against Sybase ASE 12. Pepsi Bottling Group, Somers, New York Senior PowerBuilder Developer Aug 2003 - Jan 2004 Performed maintenance and enhancements on a vending machine servicing application. Identified numerous errors and performance issues not originally identified in project scope. Also performed enhancements to an inventory system to allow users to define relationships between PBG and Pepsi North America products. Applications were written in PowerBuilder 6.5, running against both Oracle 9i and Sybase ASE 12. Footstar, Mahwah, New Jersey Senior PowerBuilder Developer Apr 2002 - Apr 2003 Designed and developed an application to automate distribution and tracking of vendor shipments. Written in PowerBuilder 8 on Windows 98, against an Oracle 8.1 database running on UNIX. Database was converted to Oracle 9i after initial deployment. Batch processes were written in either COBOL or Oracle PL/SQL using SQL Navigator, and executed using UNIX shell scripts. Bank of New York, Teaneck, New Jersey Senior PowerBuilder Developer Apr 2000 - Apr 2001 Designed and developed an asset management application to be used to automate purchasing decisions, track orders, and manage inventory. Application was written in PowerBuilder 7 on Windows NT, against a Sybase 11.x database running on UNIX, using a Delphinus-designed custom 3-tier application framework (originally developed for another client), to which client-side support for the Model-View-Controller (MVC) paradigm was added. Application was designed to allow easy conversion to a browser-client interface. CIT Group (formerly Newcourt Credit), Parsippany, New Jersey Senior PowerBuilder Developer Aug 1998 - Apr 2000 Designed and implemented a distributed architecture for an existing lease origination application. Initial project assignment involved performing performance and architecture improvements to the original application, written in PowerBuilder 6.5 on Windows 95, and deployed against a Sybase 11.x database on UNIX. Project evolved into re-designing system to support reuse of existing business logic by both PowerBuilder and HTML/ASP (Web) clients. This was accomplished by developing modular business components and deploying them to a Distributed PowerBuilder (DPB) server. ASP access was provided through custom COM bridge objects, written in PowerBuilder and deployed under MTS. Subsequent deployment effort involved the migration of PowerBuilder clients to Version 7.0, and conversion of the server objects to run under a Sybase Enterprise Application Server (EAServer/Jaguar CTS), using a Delphinus-designed, custom 3-tier application framework. New components were written in Java and deployed to EAServer. ASP pages were modified to directly access EAServer via COM. Migration was undertaken as part of a company-wide effort to establish a uniform middle tier to host common business logic across applications. Delphinus Consulting, Upper Saddle River, NJ Consultant Aug 1998 - Present Provide application design and development services to numerous small business clients. Projects not listed elsewhere include: • Dynamic Delivery Services, South Kearny, New Jersey Designed and developed an ASP.NET application to monitor EDI transaction logs. Written in C#, against a SQL Server 2000 database. • Independent Computer Consultants Association, Morristown, New Jersey Provided ongoing administration of the Northern New Jersey Chapter's public website, www.iccannj.org. Developed Microsoft Access application to maintain membership information and automate the generation of HTML pages for the site, based on templates created in HomeSite. Volunteer position. • BrainBench, Chantilly, Virginia Author/developer for an online PowerBuilder 9 skills evaluation exam. • DoAll Disk Jockeys, Flanders, New Jersey Designed and developed a disk jockey scheduling and contract management system, written in PowerBuilder 8 on Windows 98 and XP, against a Sybase SQL Anywhere 7 database. • myrestaurantwebsite.com, Wurtsboro, New York Designed and developed a web (e-commerce) application to allow consumers to place restaurant orders online. Application is customizable with the intent of re-selling the service to various restaurant clients. Written in Java Server Pages, running on a Tomcat servlet engine against a mySQL database. • ReviewNet, Jenkintown, Pennsylvania Paid reviewer for an online PowerBuilder 7 skills evaluation exam. • New Horizons, Concord, New Hampshire Provided technical training in advanced PowerBuilder 8 techniques to the NH Department of Health and Human Services. • Refund Consultants, Franklin Square, New York Designed and developed an application to analyze water usage bills received from the City of New York. Written in PowerBuilder 7 on Windows 98, the application uses OLE automation of Attachmate Extra! terminal software to download data from the City's CICS billing system. Data is then stored locally in a Sybase SQL Anywhere 7 database, and subjected to various business rules to identify potential billing discrepancies. • Professional Software Consortium, Morristown, New Jersey Provided database (Sybase SQL Anywhere 7) and object-oriented application design services for development of a travel expense system, written in Visual Basic 6, for the Department of Defense. • XO Communications, Paramus, New Jersey Developed Microsoft Access application to assist in identifying potential customers based on proximity or hierarchical relationships to existing customers. • AT&T Wireless Services, Paramus, New Jersey Developed Microsoft Word scripts to automate personnel review documents. • Nextlink Communications, Paramus, New Jersey Developed Microsoft Access application to assist in assigning sales territories. • Footstar/Meldisco, Mahwah, New Jersey Designed and implemented SAMS, a size management system to control store allocation and distribution of merchandise on a size basis. Written in PowerBuilder 5 using a mainframe DB2 database system, the application included extensive graphing abilities to enable users to visually identify sales patterns. Vitech Systems Group, New York, New York Senior Programmer/Analyst May 1995 - Aug 1998 Designed and implemented a commercially successful software product to assist trade unions and public pensions with the administration of member benefits. Written in PowerBuilder, and designed to work using either a Sybase or an Oracle database server, the system is (as of mid-1998) in its third version, with five completed installations and six others in progress. Version 1 was originally written using PowerBuilder 4, and featured: • Powerful VCR object with user-defined query and browse capabilities. • Workflow-based design that leads users through the business process. • OLE integration with Microsoft Word for document maintenance and printing. • Dynamic, table-driven definition of visual objects, providing greater flexibility across clients. Version 2 was updated to PowerBuilder 5, and featured: • Three-tiered architecture, with the business logic separated from the user and database interfaces. • Optimization of VCR object to dynamically generate server stored procedures to improve performance. • Extensive implementation of application-level and object-level services to improve developer productivity. Version 3 featured: • Standardization of database across all clients, using a custom-designed data dictionary to define client-specific data elements. • Full replacement of database tier with Sybase (Transact-SQL) and Oracle (PL/SQL) stored procedures. Personally responsible for all aspects of Version 1 system, from application and database design, to development and testing, and finally installation at two clients. Responsibility for subsequent versions gradually shifted to a technical lead role, with an emphasis on application and database design, and extensive development involving database stored procedures. Meldisco, Mahwah, New Jersey Programmer/Analyst Oct 1992 - May 1995 Designed and implemented systems for various facets of retail operation. Performed major overhaul on design of the foreign store operations system, written in PowerBuilder 4 against a Watcom database, resulting in significant performance improvements. Developed RASTA application, in PowerBuilder 4 and XDB, to assist in geographic and seasonal inventory analysis. Mainframe projects on the IBM System 390 included automatic distribution (COBOL 2), demographic store allocations (COBOL 2/DB2/CICS), sales analysis (COBOL 2/DB2/CICS) and reporting (COBOL 2/DB2), and operations support (COBOL 2/DB2). FORMAL EDUCATION SetFocus, Parsippany, New Jersey Master's Program in .Net Chubb Institute, Jersey City, New Jersey Diploma in Computer Programming Arizona State University, Tempe, Arizona Graduate program in Zoology Cell and Developmental Biology Predoctoral Fellowship University of Pennsylvania, Philadelphia, Pennsylvania Bachelor of Arts in Biology Benjamin Franklin Scholars/General Honors Program Certificate