SUMMARY:

• I am an IT Consultant with over 17+ years of mainframe expertise in multiple functional areas within the utilities industry, Telecommunications, Confidential and Gas Utilities, Transportation, and State government programs and procedures and Federal Governments.Strong batch/host side development experience with expert level technical skills in Mainframe DB2 environments using SDLC
• Additional expertise in client side Unix/oracle environments.

TECHNICAL SKILLS:

LANGUAG ES: COBOL, MicroFocus Cobol, SAG Natural, Oracle PL/SQL, SQL and SQL Plus, SAS, Unix Shell Scripting, JCL, TSO, ISPF, PL1

DATABASES: IDMS, DB2, ADABAS, Oracle

OPERATING SYSTEMS: OS/VS - Z/OS. OS/2, MS/Windows, UNIX, MVS z/OS

HARDWARE: IBM Mainframe, IBM PC and Compatibles

TOOLS: /UTILITIES: TSO/ISPF, VSAM, SAS, CICS, Easytrieve, Clist, ISPF,File Aid, Insync, Sync/Sort (DF Sort), Visio, Install/1 for Customer/1, Expeditor, Trace Master, Animator, CAS, Group 1/Code 1 Mail Stream,IT Work Issue Tracker, SQL Developer, EDI (x12), FTP SFTP MS/Excel, MS/Word, MS/Outlook, MS/PowerPoint, SharePoint,XML, MQ Series, HP Exstream, IMS/DB

JCL Utilities: (Syncort, IDCAMS, ICETOOL, IEBGENR) VSAM.

PROFESSIONAL EXPERIENCE:

Confidential,CA

Customer One Support

• Performed impact analysis for application maintenance and enhancements.
• In Billing and Net Metering (Smart Meters).
• Performed code design, built and tested enhancements
• Wrote up UT documents for code changes.

Technologies Used: Mainframe Cobol, DB2, TSO/ISPF, JCL, JCL Utilities, Endevor

Confidential,Phoenix AZ

• Worked on conversion project to transfer data files from US Air over to Confidential system
• Made changes to MVS mainframe jobs using IBM Utilities. Wrote up test plans and tested JCL.
• Technologies Used: Mainframe TSO/ISPF, JCL, JCL Utilities (Syncsort) Job Scheduler, VSAM files, File Transfer SFTP, AGILE reporting project tasks Systems West Performance - Customer/1
• Worked on conversion project to transfer data files from US Air over to Confidential system
• Made changes to MVS mainframe jobs using IBM Utilities. Wrote up test plans and tested JCL jobs.

Technologies Used: Mainframe TSO/ISPF, JCL, JCL Utilities (Syncsort) Job Scheduler, VSAM files, File Transfer SFTP, AGILE reporting project tasks

Systems West Performance - Customer

Confidential,Phoenix AZ

• Worked on conversion project to transfer data files from US Air over to Confidential system
• Made changes to MVS mainframe jobs using IBM Utilities. Wrote up test plans and tested JCL jobs.

Technologies Used: Mainframe TSO/ISPF, JCL, JCL Utilities (Syncsort) Job Scheduler, VSAM files, File Transfer SFTP, AGILE reporting project tasks

Systems West Performance - Customer/1

Confidential,Phoenix AZ

• Worked on conversion project to transfer data files from US Air over to Confidential system
• Made changes to MVS mainframe jobs using IBM Utilities. Wrote up test plans and tested JCL jobs.

Technologies Used: Mainframe TSO/ISPF, JCL, JCL Utilities (Syncsort) Job Scheduler, VSAM files, File Transfer SFTP, AGILE reporting project tasks

Confidential,NY

Customer/1 Consultant

• Made updates and tested for the CRIS Conversion for Long Island Gas project that needed to be updated with changes from a previous implementation
• Developed and automated management reports through the CSS Batch system for Long Island Gas Management.
• Made enhancements and provided testing for updates for Long Island Gas.

Technologies Used: Mainframe Cobol, DB2,, SQL Developer, PL/SQL, TSO/ISPF, VSAMJCL Utilities, Job Scheduler, Insync

Confidential,Chicago,IL

Application Developer Integration Analyst/Customer One

• Interfaced with ComEd and PECO Customer Operations line management to gather requirements and receive subsequent business approval for changes.
• Perform analysis for CIMS fix-it work to identify issue cause.
• Review Test Plans and Test Results associated with CIMS fix-it work and small enhancement.
• Respond to line management ad hoc requests for retrieval of data from CIMS; perform analysis on retrieved data and deliver results to line management.

Technologies Used: Mainframe Cobol, DB2,, SQL Developer, PL/SQL, TSO/ISPF, JCL, JCL Utilities VSAM, Job Scheduler, Insync

Confidential,NY

Customer/1 Consultant

• Wrote test scripts for a process that parsed the XML response data from Itron meter read data
• Into Cobol copybook layouts and translated to CSS Pre Bill format.
• Wrote enhancements for Interval Processing modules for Summary Billing and Pre Bill.
• Added new tariffs/rates to billing modules for Time of Use and On/Off Peak Hours.
• Wrote enhancements for Interval Off Cycle Request Process for new accounts where the interval data didn’t start at the beginning of the day.
• Developed and modified a interface process to issue and outage ticket for OMS and to transfer Confidential Outage Trouble ticket from line department (ABB) back to the Service Dept. from CSS to OMS via remote server.
• Updated the Power On batch process to OMS batch process.
• Reformatted csv interface file and created interface between CSS and Geographic Information System (GIS) to populate tables in CSS that is needed to communicate outage information into OMS.
• Developed code for Customer/1 CSS system to support the CTLN third party vendors paperless billing system that gave the customer the ability to utilize an online electronic bill paying and viewing capability.
• Developed jobs using Cobol code for sending customers bill information in XML, CSV and EDI formats to a third party vendor using HP ExstreamDeveloped and wrote jobs to De-Enroll customers to third party vendor and wrote the JCL to run this function.
• Developed Cobol code to report to business on mismatch of customers data and the JCL to run this code.
• Developed code for Customer/1 system to support a third party paperless billing system that provides customers bills in XML format to third party vendor who would translate the XML to various different paperless output types (EDI, XML, CSV) Third Party vendor to deliver these bills to the customers in their desired formats. Updated existing client server windows and in CSS.

Technologies Used: Unix, Cobol, Oracle, DB2, VSAM, mainframe, Endevor, TSO, ISPF, JCL, JCL utilities, (Syncort, IDCAMS, IEBGener) Insync, SPUFI. HP Exstream, XML, VI editor, MQ Series, SAS