STEVE STACEL

adz234@r.postjobfree.com

786-***-**** (Cell)

INFORMATION TECHNOLOGY SPECIALIST

Have been a Sr. Software Developer and Team lead for the last 25 years. A proven track record of increasing efficiency of systems, reducing bandwidth and optimizing queries so that data is returned to the client lightning fast. The queries are both fast and accurate. My work helps increase sales and increase a company’s net revenue. Have worked in a variety of industries including, Banking, Healthcare, Travel and Insurance. I specialize in the following languages. C# (17 years), ASP.net (8 years), ASP.mvc (4 years), WPF (3 years), and SQLServer/T-SQL (30 years). Have down a great deal of work with APIs and microservices to streamline the production code and eliminate monolithic code. Monolithic code tends to create side-effects when improper testing procedures are performed and code is only tested where the changes occurred and not elsewhere. Have over 3 years of working with Azure and cloud technologies like Net.Core, Docker and Kubernetes. Managed 4 consultants (2 onsite, 2 offshore).

TECHNICAL PROFICIENCES

C#

Angular16-18

SQLServer 2008+

Web API

Net.Core

HTML5

T-SQL

MicroServices

ASP.mvc

JavaScript

SSRS

EF Core

ASP.net

CSS

SSIS

Python

Azure

UI/UX

Oracle

LinQ

PROFESSIONAL ACHIEVEMENTS

Integrated Resources Inc (Remote) Consultant 03 – 07/23 NYCHHC

ProviderPortal is a new application designed to allow patients to track changes to their health and medical conditions. The app will allow a person to keep track of changes to their health and give the Dr. up to the minute details as to whether the patient is experiencing a decline, improvement or new symptoms have emerged. The patient will also be able to track their medication, and many other important details such as weight, diet, emotional state on their road to recovery.

Added an API layer between the Angular front end and SQLServer DB to streamline the vertical paths for the data to travel from client to server. It allowed for easier debugging and testing using both Swagger and Postman.

Initiated a DB redesign due to the DBA having the SQLServer DB 3rd form normalized which was too complicated and complex for this application. The 3rd normalized form had too many intermediary tables that caused the APIs difficulty in adding the patient data to the SQLServer DB

Constructed ProviderPortal web pages using Angular 18 from mockups given to the development team by the stakeholders. ProviderPortal website was written using Angular 18, Swagger, Postman, and GitHub.

Crafted ProviderPortal login screen using bootstrap. Initially wrote the login data to the local Data memory and demo the design.

Customized the login screen to interface with the API token retrieval. The token was retrieved from the server and stored in the GAC using an interceptor. All additional API calls retrieved the token from the GAC interceptor.

Created Python webforms and performed backend processing for SDP project to reduce the bandwidth and increase the throughput of data transfers between front-end client and the SQL DB. Timing tests indicated the optimization efforts increased the speed of the transaction processing by 40%.

Technologies used: C#, SQLServer, Net core 6.0, APIs. SQLServer, Azure Cloud, GitHub, TFS task tracker.

Infosys (Remote) Sr. Software Developer 11/21-03/23

CVS

Upgraded Novologix app from Net 4.5.2 to 4.8 framework in preparation of moving to Net Core 6.0 Novologix is used to process prescriptions globally

Eliminated encryption from SQLServer DB. CVS has multiple layers of security and we determined that hackers would be unable to penetrate the multi-layer security protocols.

Removing the DB encryption increased the throughput by 54% globally. Allowing more prescriptions to be processed per hour.

Consolidated Productions ODBErrors into groupings to allow upper management to see which errors were occurring the most, and to pinpoint where the errors were occurring to improve the code and make it more efficient and readable.

Enhanced Novologix application to improve performance and increase readability of application using Try…Catch blocks.

. Molina

Redesigned the entire SQLServer DB structure to speed up the queries and eliminate many errors that were being generated nightly for financial reports by improper implementation of relational database techniques. Users had to manually enter the data into the queries

Eliminated flat file structure, added primary keys, indexes and moved much of the code into parameterized stored procedures. This effort increased the speed of the SSRS reports by 682%

Engineered a brand new SQLServer DB to consolidate 4 independent databases into one database and created relational tables using primary keys, indexes and 2nd normalized data

Transformed manual queries to parameterized queries to eliminate typos and incorrect data being passed in from improper understanding of parameter passing.

Recommended to management to implement a development environment that mirrored production so that continuous improvements could be made to speed up, enhance and improve the response, and execution time of the SSIS & SSRS reports that were running extremely slow and were generating many errors due to manual mistakes being made entering the data by hand.

Mphasis (Remote) Team Lead 01/21-10/21

Schwab

Transformed paper forms to DocuSign electronic forms. Schwab purchased TD Ameritrade. The goal was to eliminate all paper forms and use only electronic forms to save money, time, and make it easier for the investors and clients to complete the paperwork quickly and efficiently online.

Created VS2022 C# APIs, Microservices in support of the DocuSign modernization. These Python microservices were used to streamline the code and eliminate the monolithic code in the application. These changes also made debugging easier as well as testing the code and prevented side effects which cause programmers headaches trying to track down unexpected results.

Crafted a Proof-of-Concept DocuSign demo in C# to prove to upper management that using DocuSign templates will work in the Schwab environment. This application included SSO, Authentication, API calls, template creation and execution.

Designed Angular9 Proof of Concept demo using Schwab Everest Web-Component library. The Everest library is internal library created by Schwab to provide a uniform look and feel of all Angular, Python and C# projects across the Schwab network.

Used C# threading to perform OLTP processing to handle stock & Forex transaction (buy/sell) requests investment positions.

AIG

Part of the VALIC team to support Life insurance and annuities. This application used both Python and C#.net. Python was used on the front-end and C# was used for API and Microservices in the middleware layer. Oracle DB was used on the backend.

Performing module updates, enhancements and writing webservices and APIs as part of reducing the monolithic code and making the application more streamline and easier to maintain and debug for future updates.

Engineered APIs and Microservices to improve the efficiency of the data delivery to the end users. These Microservices and Web APIs also perform complex calculations for all VALIC products and followed he SOLID principals. Efficiency of the application increased by 37%.

TSR (Remote) Consultant 09/20-12/20

ConEd

MAMS team. Tested and documented electric meters test results that ConEd purchased from Honeywell, Dresser AON.

Testing was performed in Dev, PreProd, and Prod environments. Vendors would send sample files. We would update MAMS with the meter information, then create the sample files according to the vendor specs. Submit the files to MAMS to do both positive and negative tests on the electric meters purchased from the vendors. I would generate a report and present to the approval team.

Created Net.Core microservices and APIs to unwind the huge monolithic code that has been put in place over decades of development, design decisions. Some of the APIs I worked on included connecting ConEd to the vendors and linking the API and microservices to the MAMS environment to speed up the processing of over 500,000 electric meters that are being updated with the latest technology

TCM (Remote) Consultant 11/19- 03/20

DXC

Updating, modifying, bug fixes and modifying the State of Mississippi highly encrypted Medicaid website.

Angular8 used to create webservices and interface with server API calls to retrieve data from outside companies as part of having the user see the complete history regarding their claim and health benefits.

Python, HTML5, Visual Studio, C#, Net.Core, Azure, SQLServer, LinQ, Oracle, TFS, Agile, multi-tier three layered service pattern architecture. IIS and Norton Security

Python used to create N-tier architecture web services and interface with server API calls to retrieve data from outside companies as part of having the user see the complete history regarding their claim and health benefits.

Worked in a cross-team environment. Ported Python code to C#.Net platform.

Jenkins, GitHub and Docker were used for bug tracking, releases and environment distribution of the latest releases.

IPIPELINE (Fort Lauderdale, FL) Consultant 04/19-07/19

Update AFFIRM website by modifying Angular7 SPA webpages to qualify applicants for life insurance & annuity products.

Modified Angula7 Webpages to comply with DTCC industry requirements.

Excel SS were used to track the latest DTCC requirements and ensure the website conformed to the latest updates and changes.

Wrote Restful API using Angular8, JavaScript to retrieve life insurance and annuity information from providers.

C#, Net.Core, SQLServer, HTML5 CSS, XML, CSV, and Webservices...

Customized client applications to keep up with the clients ever changing requirements

Used Jenkins, GIT, GitHub, Octopus for version control and production releases.

SQLServer used to store all encrypted client data, and update the client stored procedures for changes requested by clients

INFOSYS (Miami, FL) Sr. Net Developer 10/15-09/18

Enhanced FPLES Billing Manager (BM) using C#, WPF, HTML5 and SQLServer 2016. FPL sells add-on products to our electrical customers. BM allows CSRs to service ELP, ESP, SSC and SSP products. Modified, enhanced and updated ASP.NET, HTML5 quality and marketing reports. These departments are constantly requiring additional data feeds for reports and expanding product offering.

Angular7 used to create dynamic SPA apps for different marketing departments so these analyze their monthly data feeds and create marketing campaigns based on specific criteria for those marketing campaigns. Some of the factors include geographic locations, salary, household members, demographics and much more.

Added Surge Shield (SS) IBM app to BM using C#, ASP MVC, HTML5 and SQLServer. Surge Shield added 2 new products SSC, and SSP to product base.

Designed new reporting system to generate 100+ new customer letters. Eliminated individual templates for each letter. Created a universal template for all letters and customer notifications. Created a DB subsystem where all letter paragraph info was stored in SQLServer. This eliminated changing the templates each time one of our 4 marketing departments updated the letters. It made maintenance much cleaner, easier and shifted the burden from the developers to the users. Paragraph data was pulled into app when CSR needed to print these letters on demand. The letters were then sent to the mail room where they were printed in PDF format, folded, stuffed in envelopes and sent out automatically.

Created a user interface and distributed it to the 4 marketing departments. The users could pull the letter into a webpage, make the necessary format changes and save the latest format back into the database without the developers being involved maintaining these letters. This saved an enormous amount of time and money. Upper management was ecstatic.

Engineered 100+ stored procs, functions, views, cursors, and table creation. Admin rights, interfaced with QA to ensure timely bug fixes and enhancements requested by Ops and ITI vendor.

Customized 25 SSIS packages to create fast data extracts, transformations, and data loading. Used SSRS to create 17 reports for the Marketing, HomeServe, Quality, and Redpoint departments. These SSIS and SSRS packages improved efficiency, streamlined the processes and made debugging easier.

Managed 4 consultants (2 offshore, 2 on-site). Assigned tasks, assisted them with their questions and technical difficulties, explained FPL infrastructure.

RANSTAD/HUMANA (Miami, FL) Consultant 08/15-09/15

Humana purchased a company in TX. Migrated disparaged data from eCW database to new Humana database called ACMG in SQLServer 2012. This entailed migrating patients, patient history, labs, schedules, vitals, appointments, allergies, referrals.

Engineered 18 SSIS packages to handle the data migration and convert old legacy data to Humana formats

Modified existing WinForms applications to add new forms, new fields and use updated controls in VS 2012 using ASP MVC to create easy to use windows application so CSR could assist customers with their medical, dental and vision healthcare plans.

ALORICA (Plantation, FL) Sr. Net Developer 04/13-07/15

Created, Designed, Tested Costco website changes to support new ITI vendor. Used VS2010, ASP/C# 4.0. Created 28 Webservices so ITI could update, insert & retrieve data from SQLServer 2008. Updated existing Website included use of CSS, Master Pages, and Ajax controls.

Designed Web APIs Restful applications to reach a broad range of clients including both mobile varied web browsers.

Wrote 3 webservices in C# for Alliant which allowed outside vendor to update our SQLServer DB.

Enhanced ASP MVC website so outside vendors could update customer employment data. Model contained data structures to perform SCUD operations in SQLServer. View (webpage) was created to update employee benefits, salaries, COA and 401k info. The controller handled HTTP requests using Post and Send requests

Modified 13 SSIS packages for Autosys environment to handle a variety of internal processes.

New York Institute of Technology BSCS

Nassau Community College ASCS

SharePoint Master’s Program SSMP

Microsoft Certified Programmer MCP

Microsoft Certified Systems Engineer MCSE

Microsoft Certified Technology Specialist MCTS

Contact this candidate