Software Developer Project Manager

Jerome Edward “Jerry” Banasik

Lynn Haven, Florida 32444

Email: ad5uyl@r.postjobfree.com

Cell: 281-***-****

(Central Time Zone)

Data Migration, Data Integration, SQL, and .NET Software Developer

Excellent written and oral communication abilities

Very strong analytical and decision-making skills

Reliable, strong sense of accountability

Works well with clients and customers

Flexible, Enthusiastic, Committed

High Quality of Work

Experience / Knowledge Summary

IT System Architect, Team Leader, and Software Developer as well as Data Conversion Consultant on many projects for over 20 years, Workato Certified Automation Pro

Project Manager with 11 years on domestic and international projects, Multi-methodology Project Execution, Scrum, Agile, Scaled Agile Framework® (SAFe®), Kanban, Jira, Waterfall

Developing WBS (Work Breakdown Structure), SOW (Scope of Work), Project Strategic Planning, Team Building, and Providing User Support, Working closely and professionally with Owners, Clients, Product Managers, and Project Managers

Advanced MS SQL knowledge with over 19 years of experience: Tables, DDL, Views, Stored Procedures, DML, Functions, Triggers, Indexes, Jobs, Performance Tuning, Record Locking, Security, Primary and Foreign keys, Indexes, Constraints, Transactions, Querying System Catalog Views, Error Handling, Logging, and Data Models and Tables from Business Requirements, SQL Clustering, Disaster Recovery, Upgrades, Backups, Restores, Encryption, SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS), creating SQL Scripts for all parts of MS SQL work. Using Redgate SQL Compare and SQL Prompt.

Experience with Oracle MySQL Database, and MongoDB NoSQL database.

SQL Server Management Studio (SSMS), Toad for Oracle, DBeaver, Oracle SQL Developer

Oracle PL/SQL Functions and Queries, Problem Analysis, Updating existing SQL Scripts

NetSuite’s SuiteScript, SuiteScript Environment Setup, Running Scripts in NetSuite, Creating custom fields and data type in NetSuite.

Azure SQL Managed Instance database, Azure Cosmos DB NoSQL database, Azure Web Application Firewall (WAF), Azure Application Gateway, Azure Service Bus, Azure API Management

Azure DevOps, Docker, Azure Kubernetes Service (AKS), Automated testing using Azure DevOps Server, Selenium, Git, GitHub.

ASP.NET MVC, ASP.NET Razor, TypeScript, JASON, Bootstrap Framework, Libraries like Telerik, ComponentOne, or Infragistics, JavaScript Frameworks, Entity Framework

.NET 6 CORE, .NET Framework, HTML 5, Cascading Style Sheets (CSS), Sassy Cascading Style Sheet (SCSS), JavaScript, jQuery.js, Node.js, React.js, Next.js, JavaScript syntax extensions (JSX), Updating legacy applications to modern architecture.

VB Script, Python scripts, C#, VB.NET, ASP.NET, Microsoft Widows Services, Win Forms, Web Forms, REST Web Services, Team Foundation Server (TFS), Visual Studio Team Services (VSTS), Visual Studio 2022, Visual Studio Code, IIS Admin, XML/XSD/XSLT

Installing Microsoft Windows Servers, installing MS SQL Servers, installing Microsoft Workstations, installing, and upgrading Commercial Software, Solid SDLC (software development life cycle) knowledge, PowerShell automation

Strong knowledge of encryption, public key infrastructure (PKI), understanding of how to avoid OWASP security vulnerabilities in the software design, AD Federation Services, OAuth 2.0, Design Patterns and SOLID Principles, NuGet Dependency Management

SQL Scripts or developed ETL (Extract, Transform, Load) for Integrating or Migrating Data

Integrating data between applications using Workato, SQL Scripts, SSIS, or C# and develop monitoring methods for large data moves.

Produce Integration Mapping diagrams between Source and Destination tables.

Migrating flat files and data from older system to new system using SQL Scripts, SSIS, Python, or a combination

Prepare for migration by reviewing, cleaning, and transforming the data for the target system.

Perform multiples Tests of Data Integration or Data Migration code and its execution.

Office 365, Microsoft Teams, Microsoft Word, Microsoft Excel, Microsoft Outlook, Microsoft Project, Microsoft Visio, Microsoft OneDrive, Microsoft Power BI (PBI)

Used QuickBooks and other accounting systems for over 20 years to manage Payroll, Accounts Receivable, Accounts Payable, and other related accounting records for two domestic companies.

Azure, SQL, and .NET Experience 2001 – Current

Architected and created package for Windows Desktop for users to install a C# Win Application. This .NET application is to control a SQL stored procedure that runs calculations and generates XML forms for submittal to the Federal government.

Architected and assisted in developing a .NET MVC C# Responsive Web application that manages sensitive corporate emergency notifications. This application collects images, emails, other documents and then emails this data to selected individuals. Collected information is for the preparation of corporate presses releases or private internal releases. Information in this web application is usable with Smart phones or workstations, and automatically adjusted size and content to match the viewing screen sizes.

Architected and assisted in developing a .NET MVC C# Responsive Web application that allows for remote entries of EHS incidents into the main EHS application.

Combined ASP.NET, ADO.NET, JavaScript, JASON, jQuery into “add-on” code that could be applied to the Essential Suite application HTML code without modifying the core compiled code. This “add-on” code took information from the database and preloaded the web page entries saving users from copy-and-paste work.

Used VB.NET to create an order entry web page for the existing Epicor Prophet 21 (P21) ERP system and integrate the web site data with the P21 SQL Server database.

Used ASP.NET and C# along with SQL Server to create a home-schooled curriculum registration web application.

Familiar with many Azure Technologies

Worked with domestic company evaluating their Azure security selections for a commercial SaaP application.

Worked with a United Kingdom software supplier to improve their software code so that its Azure SaaP EHS application can be reliably used on offshore gas platforms in the Gulf of Mexico.

Worked with a U.S. software supplier to have their Azure SaaP EHS application installed on the Gulf of Mexico offshore gas platforms.

Worked for several manufacturers and provided/developed eCommerce capabilities for them.

10+ years of database ETL (Extract, Transform, and Load) experience.

24 years of experience with SQL databases and SQL components.

22 years of experience with .NET technologies producing web sites and applications.

11 years of experience as Project Manager for various projects.

Work Experience

E-ComWorks, LLC., Missouri City, Texas 03/23 – Current

Per Gratis (for free) Architect

E-ComWorks®, my family’s business, provides innovative, unique, and distinctive .NET Internet solutions and Electronic Commerce. Lead architecture team on cross-functional application projects, ensuring the delivery of robust and scalable solutions offer hands-on assistance and mentorship to support the professional growth of team members. Develop a business growth plan and conversion plan to Azure where DevOps is being applied. Completing studies for Microsoft Azure DevOps Engineer – Expert Certification Exam AZ-400. Renewing Angular framework, Entity Framework Core, Visual Studio 2022, NetSuite features, as well as keeping abreast of and learning new software technologies.

SimplyPut Consulting, Philadelphia, PA 12/21 – 2/23

Data Migration Consultant

Supported a team of over 40 remotely working contractors by generating formatted ERP import data for migrating Oracle E-Business Suite (EBS) and SYSPRO Enterprise Resource Planning systems for direct importing into the Oracle NetSuite ERP Cloud system. Migration code was developed with Oracle PL/SQL Scripts to perform an ETL (Extract, Transform, Load). Work included identifying incomplete or inconsistent data in source systems. Worked with clients to resolve data problems. All work was performed remotely and completed successfully. Atlassian’s Jira was utilized for project and issue tracking as well as Confluence for content collaboration. This project was for Xperi Inc., which is a global company with nearly a billion dollars in annual revenue and over 2,000 employees worldwide. Some of their consumer products are DTS, HD Radio, IMAX Enhanced, and TiVo. Over 100 billion devices are powered by Xperi technologies.

Oxy, Houston, TX 12/19 – 12/21

EHS Software Consultant

Responsibilities are combining and moving Anadarko Petroleum EHS applications to Occidental Petroleum and providing user support for on-premises Sphera Proscient application. Initiating discussions to use Microsoft Azure Cloud for hosting Proscient (produced in United Kingdom). Prepare migration of Proscient application to the EHS Control of Work application and move on-premises Production instance to Sphera’s SaaS instance hosted on Microsoft Azure Cloud. Working with Sphera establishing a scope of work, execution plans, and costs. Arranging for a Proof-of-Concept trial for EHS using Microsoft Azure Cloud SaaS Control of Work application from offshore platforms. Organizing team to measure performance of VSAT, LTE and Fiber network communication systems from Offshore platforms while using EHS Proscient and Control of Work applications. Also worked with a U.S. software supplier to have their EHS Azure SaaP application installed on the Gulf of Mexico offshore gas platforms. Supporting Procurement and Legal while the Oxy and Sphera contract negotiations are completed for the applications on Microsoft Azure Cloud. Assisted end users with their applications.

Spectra Energy / Enbridge, Houston, TX 10/07 – 11/19

System Architect / .NET Team Lead

The EHS commercial applications that I was responsible for were the following: Essential Suite, Cority Medgate, TapRooT, KMS, MIR3, Examinetics, OSI, K2, and Enablon as well as several additional in-house developed ancillary applications. These different applications were integrated to modernize the Environmental, Health, and Safety departments and to deliver accurate reports for the federal government as well as to the company.

Some of the EHS software sub-projects and applications that I developed are the following:

Workato read non-private Peoplesoft demographics directly from a database table, merged this data with private data from another Peoplesoft database table, and then selected the columns needed by the EHS MIR3 cloud application. Workato then formatted this data into a CSV file with a structure dictated by the MIR3 DataSync specifications. The CSV file was then encrypted using the Workato’s PGP module to prepare it for transmission over the internet.

XML report generator written in Microsoft T-SQL Scripts for the annual Federal EPA’s e-GGRT Greenhouse Gas Reporting system.

Bi-directional T-SQL integration between the EHS Essential Suite Incident system and the Cority Medgate (Medical) Case system, created with SQL Scripts.

Automated data integration from HR records to the records in EHS for Essential Suite, Cority Medgate, TapRooT, KMS, MIR3, OSI, and Examinetics, created with SQL Scripts.

Transitioned team from labor intensive report generation to creating reports with Microsoft SSRS (SQL Server Reporting Services)

Migrated data using Microsoft SSIS (SQL Server Integration Service)

Incident notification systems for new incident types recorded in the EHS Essential Suite application, all written with T-SQL Scripts and ran within SQL Server.

Data preload add-on code for EHS Essential Suite using JavaScript, jQuery, JSON to transfer existing data from one portion of Essential Suite to new user entries, eliminating the need for copying and pasting existing information.

Integrated the asset/site hierarchy held in EHS Essential Suite to push additions and changes to EHS applications Medgate, TapRooT and KMS, created with SQL Scripts

Architected the design for two custom EHS .NET C# MVC Responsive web applications.

Installed, configured, and updated the Development, QA, and Production instances for the following applications: Cority Medgate, Essential Suite, TapRooT, KMS, K2, and Enablon. Worked as IIS Administrator for all applications.

Converted EHS Cority Medgate and Essential Suite applications from an Oracle database to a Microsoft SQL Server database while taking a very short system outage.

Developed SQL scripts and a process to make a major application revision to Medgate with only a one-hour outage.

Move EHS applications from SQL Server 2005 to SQL Server 2008 R2 to SQL Server 2012

Upgraded Windows Server 2003 to Windows Server 2008 R2 to Windows Server 2012 R2.

Write complex Microsoft T-SQL Scripts to enhance the EHS applications.

Evaluated security for an Azure SaaP commerce application.

Acted as mentor for younger developers.

Managed 6-person .NET/SQL development team.

Assisted end users with their applications and provided training.

Occidental Petroleum Corporation (Oxy), Houston, Texas 04/05 – 10/07

EHS Software Advisor and Developer

Install, upgraded, and then provide support for the EHS Knowledge Management System (KMS) application onsite. Write custom Oracle PL/SQL Scripts to update and modify KMS production data. Maintain web servers and Oracle databases. Develop scheduled DTS / SSIS packages to interface PeopleSoft to KMS. Provide product functional feedback and improvement suggestions to producer of KMS. Create MS Project schedules. Worked as IIS Administrator on KMS web server.

DXP Enterprises, Inc., Houston, Texas 12/04 – 04/05

Application Architect, Team Leader, and Software Developer

Technical lead to develop a VB.NET electronic commerce web site for DXP Enterprises, Inc., for their Global Pump Sales and Service (GPSS) membership consortium. Created the GPSS Order Entry / Order Modification / RMA web site and integrated the web site T-SQL data with the Prophet 21 (P21) Commerce Center ERP. This web site requires users to validate their login via LDAP using ADSI. Additionally, the web site design allows the users to change their login password remotely via LDAP / ADSI in ASP.NET. Worked as IIS Administrator on Development and Test servers.

Phoenix Special Programs and Academes, Inc., Phoenix, Arizona 06/04 – 12/04

Application Architect and Software Developer

This client delivers educational courses to homebound / home schooled, 7th through 12th grade students either by mail or Internet. The project involves moving the customer from an MS Access based client-server application to a web-based C#, ASP.NET and T-SQL application. Developed all business use cases, sample web pages, SQL database structure, and ASP.NET web pages.

Stroman Realty, Conroe, Texas 04/04 – 06/04

Application Architect

Develop application architecture for a call center project for Stroman Realty, a timeshare real estate marketing firm in Conroe, TX. Work includes defining the SQL database structure, component interface structure, .NET programming execution plan, schedules, and staffing requirements.

Thomson Corporation, RIA Group, Carrollton, Texas 04/03 – 04/04

Software Developer

The Thomson Corporation, with $7.6 billion in annual sales, is a leading global provider of integrated information solutions to business and professional customers. The RIA Group produces the eForms RS, GoSystems, InSource RS, InSource CS and InSource Express Tax Compliance and Planning Software products.

Using VB 6.0 and third-party components from Infragistics, ProtoView, Sheridan, VideoSoft and ComponentOne, add new functionality and correct errors in client portion of InSource CS Tax Planning client-server software package.

Write T-SQL Script for stored procedures and make client software changes to reduce the response time for a section of code from 17 seconds to 250 milliseconds.

Houston Livestock Show and Rodeo, Houston, Texas 12/02 – 04/03

Software Developer

The Houston Livestock Show and Rodeo is a non-profit charitable organization that annually generates more than $250 billion of economic global impact. The Houston Livestock Show and Rodeo mission is to benefit youth, to support educational programs and institutions, to expand agricultural horizons and to preserve and honor pioneer heritages and cultures. Using VB.NET, ADO.NET and T-SQL stored procedures to:

Develop a .NET Windows application assisting international guest check-in and printing of custom badges and tickets.

Develop a .NET web site to administer international guest registration and to edit guest entries.

Develop a .NET Photo administration web site to upload JPG images, dynamically create thumbnail images, store the full-size image on a secure file server and store the thumbnail image in a SQL database.

Most of this code was still operational in 2020.

Am-MetricSeal, Inc., Stafford, Texas 07/02 – 12/02

Application Architect & Software Developer

Am-MetricSeal, Inc. is a manufacturer of shaft seals for submersible pumps and other equipment with a rotating shaft. Work with the company President to develop an understanding of his product line and marketing intentions. Reflect this information into an overall site design concept. Develop a marketing and E-Commerce web site using .NET C# and T-SQL Script. The ASP.NET web site presents a functional way for customers to select one of the many hundreds of available seal materials and configuration combinations. Worked as IIS Administrator.

E-ComWorks, LLC., Missouri City, Texas ` 10/01 – 07/02

Application Architect & Software Developer

E-ComWorks® provides innovative, unique, and distinctive Internet solutions and business promotion, including Electronic Commerce.

Design and develop a demonstration commercial Sales web site using .NET C#. This web site uses ADO.NET interface to SQL Server while incorporating 256-bit HySecure encryption process for protecting user data stored on the database server. This web site also provides direct integrated QuickBooks® qbXML accounting entries to reduce errors and workload.

Using .NET C#, interface VeriSign PayFlow Pro payment services to the Sales Order Completion web site to handle personal and business credit cards, debit cards, checks, and electronic funds transfer.

Using ASP.NET and C#, interface Federal Express ShipManager API for order shipping.

Develop the proprietary HySecure encryption for protecting private information.

Design SQL database structure and Stored Procedures for E-ComWorks® office records and its international web site.

Built and maintained privately owned server farm for hosting web applications. Worked as IIS Administrator.

mPlanners.com, Houston, Texas 10/00 – 10/01

Software Developer & SQL Administrator

Develop Microsoft classic ASP (VB Script) web site, COM objects, T-SQL Script for stored procedures, JavaScript code a web site that manages large-scale events and attendee transportation. Several well-known Fortune 500 companies are using this one million-dollar ($1,000,000) web site. The site allows end users to identify their travel dates and routes, select lodging, and sign up for meetings and activities. The site provides a very robust administration functionality to manage purchasing of airline tickets, booking of hotels, and assigning support staff as well as generating management reports. Work as IIS Administrator.

PhotoFrames.com, Houston, Texas 08/00 – 10/00

Software Developer

Successfully develop an XML based E-Commerce web site to sell picture frames and related products online. This site transforms XML data into web pages on demand. My work also includes creating COM objects and writing T-SQL Script for stored procedures as well as writing XHTML code.

Kara Technologies, Houston, Texas 06/00 – 08/00

Software Developer

Incorporate company’s core security and stamp printing technology into ASP (VB Script) web sites for several clients. Develop web sites that were used by government agencies to allow the public to purchase and print postage or taxation stamps via the Internet.

Cyber-Dyne, Inc., Missouri City, Texas 03/99 – 06/00

Software Developer

Develop a C# and SQL data-driven product selection system with online ordering for a local equipment manufacturer – Am-MetricSeal. Perform IIS Administrator Duties.

Fluor, Inc., Sugar Land, Texas 04/89 – 03/99

Project Engineer and Manager

Manage sixty-five million-dollar ($65,000,000) Control Systems and Information Technology project for the development phase of new petrochemical complex in Venezuela.

Manage the three hundred million-dollar ($300,000,000) portion of a project for Saudi Arabia.

Manage thirty million-dollar ($30,000,000) Information Technology project for the development phase of a new Equate petrochemical complex in Kuwait.

Manage several projects for DuPont in Sabine, Texas.

Manage the engineering and design staff for a one hundred sixty-five-million-dollar ($165,000,000) plant modification project for Sun Oil in Philadelphia, Pennsylvania.

Very profitably manage the engineering and design staff for a thirty-five-million-dollar ($35,000,000) lump-sum plant expansion for Valero in Corpus Christi, Texas

Managed the engineering and design staff very profitably for a two hundred and eighty million-dollar ($280,000,000) lump-sum plant expansion for Valero in Corpus Christi, Texas.

Education:

Bachelor of Science Electrical Engineering, West Virginia University, School of Technology

Including advanced mathematics and electronics

Certifications:

Registered Professional Engineer, Computers and Electrical, Texas No. 54134, Inactive

Workato Automation Pro I & II; OAuth 2.0 Courses; Enterprise Blockchain Course

Several Azure Courses

Contact this candidate