Post Job Free

Resume

Sign in

Sql Server Management System

Location:
New Rochelle, NY
Posted:
June 29, 2023

Contact this candidate

Resume:

Mark Stewart - Email: adxzx6@r.postjobfree.com

Summary

Ten plus years of working on IMS DB/DC applications written in COBOL and PL/1.

Skills

COBOL, PL/1, IMS DB/DC, ISPF, CLIST, DB2, JCL, SORT, IBM Utilities, SAS, DB2, VSAM, UNIX, Oracle, Java

Experience

Consolidated Edison, New York, NY May 2019-June 2020

Linux System Administrator

Worked as a Red Hat Linux System Administrator.

Educational Service Company, Westchester, NY:

Programmer May 2017-Dec 2017

I worked on a major revision to a popular Job Web Site for teachers with hundreds of thousands of users. The Web Site uses MVC, Angular and SQL Server. Developed multiple ASP.NET Webform and MVC Applications. I worked with SQL Server, SQL Server Reporting Services, and SQL Server Integration Services. I programmed with C#, JavaScript, JQuery and AngularJS.

Retired Sept 2015 – April 2017

Consolidated Edison, New York, NY

Project Leader/Developer 1998-2015

I worked on developing and integrating an Outage Management System. I installed the system initially on a Tru64 Cluster. But I subsequently updated and migrated the system to a HPUX Cluster, then onto a Linux Blade Server. I maintained a COBOL program that used FINALIST to standardized addresses. I updated the COBOL program at various times for different versions of FINALIST. I wrote and maintained MQ Series programs to transfer transactions from/to the legacy IMS Outage Management System to the new Outage Management System. I also maintained several PL/1 programs that expanded addresses from the Mapping System. I coded using Oracle P/SQL, KornShell, C, C++, Perl, and Python. I used CVS and Git to manage Source Code.

I also worked on a Gas Mobile Dispatching System. I wrote a program to translate XML transactions for the Gas Mobile Dispatching System to a JSON like format for input into the legacy Emergency Control system. And I wrote a program to take a JSON like formatted transactions to XML format for the Gas Mobile Dispatching System.

Consolidated Edison, New York, NY

Project Leader/Developer 1994-1998

I helped to implement an Engineering Drawing Version Control System on an HP T500 Unix Server and many HP Unix workstations all running HP-UX UNIX.

Later, I headed up a team responsible for upgrading the Drawing Management System from DMCS to Metaphase.

Consolidated Edison, New York, NY

Developer 1986 – 1994

I implemented an AM/FM (GIS) System to manage the low voltage electric distribution system and the gas distribution system on Intergraph Servers and workstations using FRAMME and MicroStation.

Consolidated Edison, New York, NY

Developer 1986 – 1986

I was added to a team to help finish the coding and testing of a Gas Meter Inventory System written in COBOL running under IMS DB/DC

I wrote and tested some of the online screens for the Gas Meter Inventory System.

I also assisted the junior programmers as needed.

Consolidated Edison, New York, NY

Project Leader/Developer 1984 – 1986

I was the team lead that designed, coded, tested, and installed into production a Power Interchange Billing System. The system was an IMS DB/DC system writing in COBOL and PL1. The system was responsible for generating bills for the transfer of power between utilities. The system had to handle complex calculations like “Avoided Cost” using Dispatch Curves.

I wrote the design documents, test plans and supervised the development staff and testing efforts.

Consolidated Edison, New York, NY

Project Leader/Developer 1982 – 1984

I supervised a group supporting and enhancing an IMS DB/DC system writing in PL/1 that was responsible for storing and processing customer load profile data. This system was also responsible for generating the demand and consumption data for large customers that went into the Customer Billing System.

Consolidated Edison, New York, NY

Developer 1980 – 1982

I worked on several mainframe systems responsible for the maintenance of distribution equipment. I wrote and maintained programs mostly in PL/1 and COBOL.I learned to use many mainframe tools and utilities like JCL, TSO, TSO CLIST, ISPF, FileAid, VSAM, JCL.

Education

Columbia University, New York, NY, 3.5 years 1976-1980

Western Governors University, Utah, Salt Lake City

BS in Data Management/Analytics 2017-2019

Western Governors University, Utah, Salt Lake City

MS in Data Analytics 2021



Contact this candidate