SUMMARY:

Senior .Net Developer/Analyst - Full Stack Developer.

TECHNICAL SKILLS:

Hardware : Web servers, DB servers, Windows workstations, IBM mainframes.

O/S Systems : Windows-95/98/2000/XP/Vista/W7/W8/W10 Windows Server, Apple Mac OS, MVS/ESA, CICS, Novell Netware..

Languages : C#, AJAX, ASP.MVC, JavaScript, APS.Net, VB.net, Visual Basic, XML, VBScript, ASP and APS.Net Pages, XML, HTML, Biztalk, C, C++, Java, dBase, K-MAN, Cobol (Microfocus), Basic, Microsoft Assembler.

Mainframe: Cobol, Ideal, Mantis, JCL, 370-assembler.

Databases : MS-SQL versions 6.5 thru 2016, MS-Access, MSDE, Essbase.

Mainframe: DB2, VSAM, Datacom/DB.

Software : IIS, Com+, MTS, SSIS / DTS, Visual Interdev, MS-Office, Visual Sourcesafe, Visio,, Frontpage, Dreamweaver, Erwin, Crystal Reports, Win-FTP.

Mainframe: TSO/ISPF, EDI, XCOM, VSAM Assist/Util, Intertest, Librarian.

Applications : Reinsurance, Manufacturing Costing and Control, ISO Document Management, Patient Case Management, eCommerce, Payroll, Purchasing/MRP/Inventory/Production Control, Vehicle Maintenance, Financial Analysis, Cost Accounting, Disbursements, Order Processing, Point Of Sale/Inventory, Title Insurance, Shipping/Billing, EDI, Insurance Client Management, Accounts Receivable, Stock Analysis, Scheduling, Accounts Payable, G/L.

PROFESSIONAL EXPERIENCE:

Confidential, King of Prussia, PA

SENIOR DEVELOPER / ARCHITECT

Responsibilities:

• I am working in a team on initial phases to build a ‘Core’ web application to support the entire denomination.
• The application is being developed in ASP.NET Core MVC / C# and will be using SQL Server 2016. I am doing the initial SQL DBA work for the application and IIS installation.
• I will be coding one or more of the components the interface with the existing web application.
• I am working on rewriting 2 internet applications into ASP.Net / C# using VS 2012/2015.
• This rewrite is in a phased approach, replacing parts of the system in several major releases.
• I am working on the migration the existing DB from SQL 2000 to SQL 2012. The new UI is designed with Master Pages, JavaScript, AJAX and CSS.
• This effort includes the configuration and deployment to IIS. This includes upgrading the reporting / warehousing components of the system.
• The system supports 3 in-house divisions and 35 regional offices. One component is designed to support all 5200 churches directly using a synchronized two-way feed on the data.
• I am the primary provider for non-business tech support issues for the current 2 web applications during this rewrite. I am working on an interim solution to use Web Services / WCF and XML HttpRequest to support code in the current system to replace RDS. This includes moving and reconfiguring current 2 web applications to run on IIS in Windows 2012. Also will be converting client side VBScript to JavaScript.
• I have replaced one of the two Windows Servers / SQL Servers. The other server requires changes in application to support changes in newer versions of SQL Server. Also, I am working on the design and specs for the Windows 2012 R2 server that will replace the current IIS server. Coding changes/upgraded must be completed prior to this upgrade.
• I worked on a user extract process from this system to the account system format. UI was being developed in ASP.MVC in VS2012 - it was never completed.
• I supported final phases of development / conversion / implementation of a VB.Net 2005 / SQL 2005 ASP.NET app. This included DBA processes for re-indexing and backups.
• I developed C# system to accept excel file / XML files receipts to be verified and inserted into a SQL Server based application.

Confidential, Wilmington, DE

SENIOR DEVELOPER

Responsibilities:

• I worked working on the upgrading and rewrite of internal financial and investment analysis applications to VB-2005 and VB-2008 that exist in VB6 and bTrieve (ISAM/Indexed files).
• The work included analysis of the current business rules and placing new code into the correct tier in new .Net applications using object oriented programming.
• Additional work is required to change the access of the data in a new relation model in SQL-2005.
• Analysis of the existing non-SQL/non-relational access of the data was being performed to use SQL and Stores Procedures to access the new relational data model.
• I used SSIS in creating test databases.

Confidential, Wayne, PA

SENIOR DEVELOPER

Responsibilities:

• I worked on internet web application for the Automotive Finance and Insurance for automotive dealerships.
• The system integrated with Dealer Management Systems (DMS) to assist with the sale of insurance products that may be sold with both new and used autos.
• The system was developed in Microsoft .Net / ASP.Net application from the start, with most of the code in VB.Net and some underlying components in C#. The database is SQL-2005 on Windows 2003 server.
• The source in under VSS. Used both Visual Studio 2003 and 2005 (VB 2003 and 2005) for development.
• Primary work efforts have been in the development of ASP.Net and VB.Net programming.
• Additional programming has included exchange of data and data requests via web services and XML.
• These processes allowed for real-time rating with several 3 rd party insurance provides that allowed integration of rating into the system.
• Used SQL-2005 to develop the tables and stored procedures to support the underlying business and data layers of the application.
• Lead an effort to tune stored procedures and tables using SQL tools on the Windows 2003 server to eliminate issues of ‘deadlocks’.
• I worked on analysis of XML data between the system and external DMS integrators.
• This required detail analysis of current process and testing plans to insure that all data was correctly mapped from the same base system thru multiple DMS integrators.
• I worked on analysis, scope and proof-of-concept of coding changes needed to retrofit current ASP.NET application to use AJAX to enhance the performance of the flagship application.
• Additionally, used Javascript, HTML, CSS and Themes on the client side of the application.

Confidential, Bala Cynwyd, Pa

SENIOR DEVELOPER

Responsibilities:

• I worked on insurance applications that interface data between customer contact and ratings systems to backend business applications for accounting, financial and regulator reporting. Additional external data exchanges occurred with customers, vendors and government authorities.
• The first system was the DVM (Department of Motor Vehicle) reporting system using VB.net/C# based applications to collect and transmit data to services that report motor vehicle information to different states. The front-end/UI used VB.Net/ADO.Net with the components in C#.
• The second system was Automated Payment system that sent current client balances to a third party check/credit card payment system.
• Both applications were developed using VB.net with ASP.net, Web services and Windows services components.
• All processing used SQL 2000 / ADO.Net. The use of secured FTP and encryption had been implemented in both systems.
• Active Directory security had been implemented to secure the ASP.net user interface.
• I worked on an Insurance Bordereau process to collect other agency policy information and in corporate into internal systems.
• A policy issuance sub-system created the actual declaration page and supporting forms using this data.
• The system used Web services and Windows services in VB.Net/C#.
• Additional, the data formatting and transformation was accomplished from data provided by the outside agencies and processed using Microsoft Biztalk 2004, VB.net, C# and XML. The sub-system used Acrobat scripting called from .Net programs to populate and build the policy images.
• The underlying DB was SQL 2000. The user interface for the Meta-data was in ASP.Net and ADO.Net.
• The ASP.Net pages were in VB.Net, with the components in C#.
• I worked both on the design of the database (normalized and referential integrity issues), Stored Procedures using T-SQL and XSD schemas in system.
• I used both VB.Net and C# scripting in the Biztalk 2004 processing.
• The base insurance forms in PDF format where stored in Sharepoint folders.
• System design and documentation was also stored in Sharepoint.

Confidential, Philadelphia, PA

SENIOR CLIENT/SERVER DEVELOPER

Responsibilities:

• I worked a large multi-tier reinsurance application using VB-6 and MS-SQL 2000. The work included major changes to SQL Stored Procedures for both new business models and to improve processing performance.
• Major enhancement to the business and data layers of the VB programs.
• The system consists of over 90 programs, almost exclusively VB programs with data exceeding over 400 GB of data.
• My additional responsibilities were as a backup for the DBA / Systems Administrator.
• This included DBA tasks, Windows server support, Terminal Server support, and software deployment.
• I was the backup admin for the Visual SourceSafe. In VSS, created and managed branches, merging of code, deployment and versioning.
• Worked on support and enhancement of VB.net, ASP.net and Active Template based applications.

Confidential, Fort Washington, PA

SENIOR SOFTWARE DEVELOPER

Responsibilities:

• I worked on new functionality, enhancements and extensions to VB based 'Strategic Contract' document and rating system.
• The application used 3 tier processing approach, with DB2 on an OS/390 server as the repository for the rating information and NT server for the Word documents.
• I worked on breaking system in smaller code component objects.
• One of these components included all interactions with MS-word into a separate DLL component.
• Work included identifying current issues with components that did not meet with current component design rules.
• I coded extensively with caching data to the local workstation to improve performance.
• This local caching involved extensive SQL query designs.
• Improved and documented the current build process and worked on upgrading VB app install process to support Windows-XP.
• I worked on issues of multiple project development in Visual Source Safe.

Confidential, Collegeville, PA

SOFTWARE PROGRAMMING MANAGER

Responsibilities:

• Lead the conversion/rewrite of older VB3/VB4 and other language apps to VB5. I worked with the development of VB5/VB6 applications in SQL Server via RDO2 and ADO. I implemented standards and setup deployment scripts using Wise software.
• Setup environment for testing of the deployment of applications, worked on the installation and development of Internet Information Server (IIS) software and applications using ASP pages with VBScript, JavaScript, HTML, ADO, SQL Server thru a Visual Interdev environment.
• Lead the development of ‘Explorer’ and ‘Web Browser’ style applications.
• Our Intranet apps performed inquiry and Web-based updating of databases.
• Worked on implementing MTS based VB code for both Desktop VB client apps and Intranet applications.
• Developed Internet based Customer Order / Shipping information system and Bid Item system.
• I implemented DTS data tranfers from company databases to hosting databases. I worked on initial planning and testing of VB6 to Vb.net conversion.
• I managed apps and staff resources with MS-Project, Visio, Visual SourceSafe and Visual Test. We used Appsdev SQL-7 and Visual Interdev 6 in-house training material. An additional source of training material was from Keystone for XML and Java.

Confidential, Philadelphia, PA

SENIOR CLIENT/SERVER DEVELOPER

Responsibilities:

• I worked in the development of a 3 tier Visual Basic 5 application in MS-SQL 6.5.
• Worked on common ‘Wizard’ interface for insurance rules and developed a formula rules expression builder that build MS-SQL selection criteria from an end-user interface.
• Worked on ActiveX in-process (DLL), out-of-process (EXE) and controls components (OCX).
• I worked on the definition of MS-SQL 6.5 tables, stored procedures (T-SQL) and triggers on the server side and RDO 2.0 on the client side.
• Ws used 32-bit Windows API calls to extend functionality of the VB programs.
• I worked with Desaware sub-classing for VB.
• We used SourceSafe, Net-Meeting, Access-97, and Erwin data modeling to assist in the development of the project.

Confidential, Philadelphia, PA

SENIOR APPLICATIONS DEVELOPER

Responsibilities:

• I worked in the development of Visual Basic 4 applications using Access and DB2/2 database environment.
• DB2/2 was an ODBC compliant database used for Client/Server applications.
• The source code for the group was controlled by Visual SourceSafe. I worked on implementing coding standards and group based development.
• I worked with systems analyst on database using Erwin.
• Worked on transfer of data between a CICS system and an imaging database using a VB based Screen Scraper in a Windows-95/NT environment.
• The underlying databases for the imaging system were in MS-SQL Server and Access.

Confidential, Philadelphia, PA

SENIOR PROGRAMMER ANALYST

Responsibilities:

• I worked on Financial Analysis systems.
• Systems were in DB2 and used for download to Essbase, a Multi-dimensional Client/Server OLAP database.
• Client/Server environment was Windows 3.1 / Windows-95 / Windows NT environment using Essbase with Excel/VBA.
• I worked on installing/tuning the Essbase and tuning multiple Raid5 Windows-NT4 servers for Essbase when both were upgrade to the new version.
• The download process required modifications and new Cobol/DB2 programs. I worked with REXX scripts on the NT.
• Maintained and enhanced a two tier client/server Visual Basic 4.0 / Access based system for tracking Vendor performance.
• The system used OLE servers and was networked in a Windows multi-user environment.
• I worked on a Windows based GUI front-end to DB2.
• This was a real-time system using a DB2/2 gateway and using ODBC.
• The project used Microsoft Access and Cognos Impromptu in Windows-95.
• The Access required the use of the Report, Query, Macro and the Access Basic to build the GUI front end.
• I attended Platinum DB2 training.