Description
The following is a list of some of my specific areas of expertise : During my extensive career, I have worked in Operations. I have installed Syncsort and installed and updated source code. I have programmed in Sas and Easytrieve. The last 23 years I have focused on fine tuning my existing Tech Support skills which include fixing abends for many varied reasons. This includes various types of Jcl errors, sb37 space problems (which include exceeding 4 gig maximum as well as simple space issues, and sortwork space exceeded). Many varied Db2 problems including (timestamp problems due to program being bound to production when running from test, valid and / or operative = no, online program being implemented but newcopy not completed prior to job execution, batch program being implemented while job is executing), Db2 table exceeded (sql -804), % of tablespace exceeded, contentions, many different DB2 reason codes, rollback occurring etc. Different types of Changeman problems, including job being set up to run from single instead of from multiple Db2 Stc's, Db2 ctrk migration not being completed. Dcb conflict status=39 due to Changeman package not being implemented for the job that reads the dataset that was altered via another package, which I determine by checking the Cobol source code. Status=35 due to contention and not because the dd (dataset) does not exist in the proc. Vsam contentions (alternate index(s) not being built, delete / define failing, vsam lrecl problems for various reasons (including program change and / or proc not being implemented). Control-m problems due to pre-requisite job(s) not being defined, condition code checking not being set up properly which can either cause a job to abend or not abend as well as jobs not being forced in, autoedit(s) not being defined properly causing the wrong dataset and / or symbolic to be used. I have also worked extensively with a lot of (Adp) Broadridge Tech Support Technicians over the last 30 years while I worked for Bear And Stearns for 19 years and JP Morgan Chase for 5 years. This is just a small sample of the types of issues that I handle. I look forward to going into greater detail at your convenience. ***************************************************************** The following is a list of some of my accomplishments : This is a small list of the many things I have done that stand out over my 23 year career working for Bear And Stearns 1990-2008 and JP Morgan Chase 2008- to present: 1) All 3 IB Mainframe systems crashed. The systems were down for 3 hours. There were 175 batch jobs that failed that night. I was the only Tech Support Analyst working that night. There were 24 batch jobs that were running when the systems crashed. As a result, the buffer was lost and interrogating these jobs was a much more difficult task, because this is similar to shutting down a PC without saving what you were doing and only being able to recover part way thru. I was able to determine what to do with 22 out of 24 of these jobs by myself and restart them successfully. I had to call the Programmer for only 2. 2) When Our new client was brought on board, I was the on the firm wide conference call all night because there were many batch jobs that failed. A lot of these jobs failed due to the 4 gig limit of space being exceeded on vsam and sequential files. I was also on several other conference calls with multiple Programmers and DB2 Technicians simultaneously, where I was able to determine the course of action with many other batch jobs that failed for other reasons, cross referencing vsam and sequential datasets to see where they were used and how to proceed with the recovery. 3) I joined a conference call with over 50 individuals who were installing a new release of software because I heard a speaker phone conversation talking about a DB2 timestamp problem. There were 2 DB2 support individuals on the call at the time. I asked what the reason code was and told them they needed to do a DB2 bind and offered a batch job that needed to have Pds libraries changed. I walked them thru an Online DB2 bind where the Pds libraries are determined by DB2. This was successful and they were then able to successfully test the new release of the software. 4) I set up 96 itpams for Year End processing in my own temporary Pds libraries, prior to year end. The reason I did this is because A) there was very little chance for error doing it myself whereas if multiple individuals did it there would be a much greater chance for error, B) I directly coordinated with the Programmers myself and made any changes that needed to be made, C) there was only 1 day for all of these Itpams to be set up and that was definitely not enough time to accomplish this task. It took me 1 week working a lot of extra hours to accomplish this. 5) I was crucial in debugging the problems with 2 new releases of CDB (DB2) along with the IB DB2 Technician and the IB Tech Support Manager on 2 separate occasions months apart. 6) I was the point Tech Support Technician when an incorrect restore point for IBM (DB2) was done because the job that did the backup that was used to restore was cancelled after it had unknowingly already created the backup to the tablespace that had to be restored. I stayed many hours after my shift ended to accomplish this. 7) I conferenced in many Programmers due to incorrect Auto-edit variables being used in Control-m and assisted them in determining how many batch jobs were affected via cross referencing datasets and checking jobs that were dependent on those that had the problem. I was also able to determine which jobs used the incorrect Auto-edit variables, which helped the Programmers to determine the correct course of action. 8) I was Point Tech Support Technician when a new version of Control-m was installed and a bug was discovered that affected hundreds of batch jobs. I orchestrated the recovery along with the Manager of Scheduling. 9) I was Point Tech Support Technician for the week of 9/11/2001 when the Trade Center was destroyed, working many hours to determine how to recover each night due to an extensive amount of files not being able to be sent. 10) There were many other varied disasters over the years that I was the Point Tech Support Technician, different than those listed.