Stephen Kalpin

** ******* ******

Winsted, CT ***98

Home Phone: 860-***-****

ad2pq3@r.postjobfree.com

OBJECTIVE:

To obtain employment as a fully remote software engineer compatible with my professional programming experience, knowledge, training, education and experience.

PROFESSIONAL EXPERIENCE:

Quest Global

Senior Software engineer

Windor, CT

Aug 2021 – Present

Designed, developed, implemented, and maintained websites, API’s, software, and databases using the following tools and technologies: React, Python, Java script, Node JS, Fast API, Visual Studio Code, C#, Razor pages, MVC, enterprise framework, SQL server, SSMS, Oracle, DBeaver, Agile Point, Windows forms applications VB, and VBA macros.

Novitex/Exela

Programmer/Analyst-IT Specialist

Windor, CT

July 2016 – 07/13/2020

Designed, developed, implemented, and maintained the following:

oVarious database applications (Access) for Revenue computation and Billing (several versions, each contract specific). (Using VB.net and visual studio version 2010)

oPostage rate computation software. Software read files used to run inserting machines and oracle database of job data to build a database of composition, mail date and postage rate for each mail piece. Mail piece volume varied from 2-3 million per week. Data was used both for billing and as a control. (Using VB.net and visual studio version 2010)

oBatch software used to validate, categorize, and create detailed cost client cost center reporting for postage and revenue charges. (Using VB.net and visual studio version 2010)

oBar code driven Labor hours tracking system. Used to track billable labor to a database to could be fed into the billing system. Software contained numerous supervisor designed crystal reports used for managing labor efforts. Software was so well accepted it was implemented for non-billable labor as well. (Using VB.net and visual studio version 2010)

Designed and developed SQL, procedures, and workbooks needed for reconciling postage to postage account.

Designed and developed SQL, procedures, and workbooks needed for reconciling material usuage billed to inventory.

Designed and developed numerous ORACLE SQL queries, workbooks and macros used for SLA reporting.

Designed and developed numerous ORACLE SQL queries used for identifying various operational issues as well as for management reporting.

UTC

Programmer/Analyst

Danbury, CT

October 2005 – 10/30/2015

Designed, developed, implemented, and maintained the following:

oVarious database applications (Access and SQL server) for tracking and metric reporting of audits and associated findings, Electrostatic Discharge Certification Program (ESD), requirements management, corrective action systems, and computer based training. (Using VB.net and visual studio versions 2005 and 2010)

oInterface software used for controlling, operating, reading, and storing data on server database (Access and SQL server) from various probes, machinery, and instruments. Developed software used for monitoring, analyzing, and sending automated email alerts for the probes, machinery, and instruments. (Using C# in and visual studio versions 2005 and 2010)

oBatch software used to create detailed cost of quality metrics from data that had to be derived from disparate sources such as trial balances, spreadsheets, or data cubes, and saved the compiled data to an Access database. (Using VBA, VB.NET, BEX, and webi)

oNumerous sub reports based on the data derived from the Cost of Quality Batch Process for distribution to various end users.(In VBA using ODBC to prepare reports with unusual formatting)

oBatch software used to compile and create “as built” parts lists from spreadsheets derived from various systems for review by quality engineers and submission to the customer. (Using VBA and C# in and visual studio version 2010)

Created web sites and web pages to allow general access to non-sensitive information required by the production staff, as well as Computer Based Training – CBT’s (VB.NET in Visual Studio 2005 Results of tests as well as completion data were saved to MS Access database on server).

Developed various dashboard pages for use by directorate level (Using Java script VB Script as well as VB.NET and C#.NET in Visual Studio 2005)

Created BEX, SAP Business Objects, and Web Intelligence (Webi) reports from data cubes and SAP to provide timely data to management.

Performed various data mining activities using SQL, data cubes/report writers, VBA scripts, or other suitable tool to derive the requested data for management use.

Wrote code over the years as needed to service numerous one time/short term customer requirements.

Achievements included bringing accountability to the ESD Certification Program, ending data loss and corruption from critical probes and sensors, designing Foreign Object Damage Training (FOD), and improving the suitability of the facility through improved tracking, metrics, and communications for the audit program.

Genesys Consulting

Programmer/Analyst 3

Albany, NY

February 2004 –May 2005

Redesigned the new tax payment system to process data in a generic table driven fashion.

Designed, coded, and tested new programs used for corporate tax payments by the New York State department of Taxation and Finance.

Prepared cycles and conditions for unit testing of modules. Performed unit and integration testing. Used CA File Master and SQL to ensure data processed correctly.

Achievements included winning the Excelsior Award; a peer nominated award given only to the most skilled employees.

This Position was mostly COBOL DB2

TMC Services

System Consultant

Livingston, NJ

August 2003 – February 2004

Designed and implemented a point of sale system used for tracking store room inventory for a mechanical services contractor.

Built database of UPC’s, printed bar codes, and oversaw initial inventory. Trained staff on system use.

Accenture United Health Care

Programmer/Analyst

Hartford, CT

August 2002 – May 2003

Modified and maintained existing online and batch programs.

Designed, coded, and tested new programs used by the financial services industry for processing health insurance claims.

Prepared cycles and conditions for unit testing of modules. Performed unit and integration testing. Used File Aid to ensure data processed correctly.

Accenture SSO

Programmer/Analyst

Philadelphia, PA

May 2001 – July 2002

Modified and maintained existing custom programs.

Designed, coded, and tested new programs used by the financial services industry for processing stocks, bonds, mutual funds, employee benefit accounts, pension, and trust funds.

Prepared cycles and conditions for unit testing of modules. Performed system, unit, and string testing. Queried database to ensure data processed correctly.

Equitable Mortgage

Owner

Sellersville, PA

1997 - 1999

Created and built entire business. Purchased, set up, troubleshot, and maintained all computers, hardware and peripherals. Created database and trained staff on a variety of software. Managed a staff of 10 people, oversaw all departments. Set up and oversaw all financial and accounting records. Negotiated and contracted loan correspondent relationships. Fixed daily pricing, managed and oversaw marketing and advertising.

Stroh Associates

District Manager

Skillman, NJ

1994 - 1997

Managed 17 on-site managers at 14 hospitals nationwide for a building maintenance company.

Monitored hours worked and supply usage to ensure each account remained profitable.

Helped implement Environmental Management System (EMS), a relational database used to measure labor requirements on an ongoing basis.

Set up Lotus spreadsheet macros to automate man-hours control reports, purchase order tracking, and inventory.

Negotiated with vendors, and issued purchase orders for supplies, equipment, and vehicles.

Automated purchasing system, and created reports to improve management efficiency.

Processed payroll for approximately 400 employees nationwide. Automated process of maintaining records of disability, holiday, and vacation time. Prepared various tax and insurance reports not processed by ADP. Automated several reports and records, resulting in greater accuracy.

Processed accounts payable, closed books on a monthly basis, prepared amortization and depreciation schedules, completed bank reconciliations, and computed supply usage from inventory reports.

TECHNICAL SKIILS:

Languages

Visual basic.NET (versions 8.0 and 10.0), SQL, Microsoft VBA, VBScript, JavaScript, VB for Crystal Reports, Crystal Syntax, .chm extensions, C++, C#, Visual Basic (All versions 1-6), BASIC, QBASIC, Turbo Basic, PL1, COBOL, COBOL II, Micro Focus COBOL, CICS, OS/VS2, MVS, JCL, Lotus Script, FORTRAN, NATURAL.

Databases

Oracle, Oracle 8i, Oracle ERP, Microsoft Access (versions 7, 10, and 14), DB2, ADABAS, and SAP.

Hardware

Client server architecture for: windows 95, windows XP, and windows 7, asynchronous com protocols for various probes, devices, and instruments (both USB and RS-232), IBM 370/390 architecture, IBM 3090 mainframe, DEC Mainframe, IBM compatible PCs.

Software

Visual studio 2005 and 2010, Crystal Reports (Versions 10-14), Windows (all versions), .Chm Ide’s (Various), IIS,Webi, report writers (various), BEX, Word, Excel, Visio, Power Point, Project, QuickBooks, Microsoft Works, Lotus Notes, Lotus 123, ENDEVOUR, DADS, File Aid, Abend-Aid, EXPEDITER, File Master, SPUFI, MVS/ESA, TSO/PDF, VSAM, Hummingbird, FHLMC Prospector, FNMA Desktop Underwriter, Credit Link.

Concepts

Business analysis, structured analysis and design, testing (unit, cycle, and system), system development lifecycles, database design, data conversion, table handling, editing functions, solving (internal and external abends, stack overflows, and memory leaks), multi-threading applications, com components, pointers, thread delegations, external asynchronous com protocols, data cubes, ActiveX controls (design, development and usage), version control, multi-platform/multi-targeted executable deployment, boot strapper applications, click once applications, table driven data processing, bug and issue management, and project management.

Applications

Database access, data validation, random and sequential file processing, sorting, multi-level control break processing, subprogram linkage, table handling, remote device operation, control and query, real time data monitoring, and notifications.

EDUCATION:

The Chubb Institute

Computer Programmer Diploma

Raritan Valley College

Associate Degree in Business/Computer Science

Contact this candidate