SUMMARY:

• Sr Analyst - Programmer, technical support, some z/OS DB2 DBA, IMS DBA; Experience: insurance companies, banking sector, telecom, manufacturing, government, healthcare, transportation & utility sectors. Mainframe z/OS, Cobol, PL/1, ASSEMBLER, TELON, CICS, DB2, SQL, Stored Procedures, IMS DB/DC, MFS, NATURAL, ADABAS, TSO, JCL.
• Results oriented, excellent writing and communication skills, leadership skills, takes initiatives, hard-working, versatile, succeeds in taking new challenges, rigorous and conscientious.
• Seasoned Analyst-programmer working in the development and maintenance of various applications.
• In many instances, write functional and detailed analysis (program specifications), create and maintain complex programs written in procedural languages such as Cobol, PL/1 and ASSEMBLER, using IMS and DB2 databases, or written in 4GL NATURAL using ADABAS/DB2 DBs, and TELON code generator.
• Create unit and integrated test cases/scenarios, execute, debug and implement components into production, and do the production support.

SKILLS:

Methodologies: DMR Productivity +, Macroscope, Systems Development Life Cycle (SDLC), Yourdon

Development Tools: Abend-AID, File-AID, Message Format Service (MFS), QMF, SPUFI, SQL Query Analyzer, Xpediter

Programming Languages: AllFusion, Assembler, BMS Map, CICS, CICS Web Services, Clist, COBOL, Cobol for z/OS and OS/390, COBOL II, COBOL III, DB2 Stored Procedures (SQL PL), Dialog Manager, DL/1, Easytrieve Plus, IMS/DB, IMS/DC, JCL, JCL-MVS, MFS Map, Natural 4GL, PL/1, Rexx, SQL, Syncsort, Telon

Tools: BMC (DB2/OS390 Utility), Control-M, E-Mail, Endevor, File-AID DB2, File-AID IMS, File-AID MVS, Flasher, Flowchart, IBM BookManager, IBM File-AID, IBM ISPF Dialog Manager, IMS DB, IMS DC, Internet Explorer, Jobscan, Lotus Notes, Microsoft Excel, Microsoft Office, Microsoft Word, MQSeries, Netron, Norton Utilities, PC3270, Platinum DB2 Utilities, QuickRef, Supersession, Syncsort, TraceMaster, TSO/ISPF, Xpeditor, Zeke

Operating Systems: IBM MVS/OS390, MVS Utilities, MVS/ESA, OS/390, TSO, z/OS, EXEC 8, TIP

Databases: DB2 FOR Z/OS, IMS/DB, VSAM, ADABAS, DATACOM

Computers: 30XX, IBM, IBM 390, IBM PC, Mainframe, Sperry Univac / Unisys 1108

Equipment: Monitors / Displays, Terminals

Technology: FTP, Microsoft Office

Systems: IBM Mainframe

WORK EXPERIENCE:

Confidential

z/OS technical support

Responsibilities:

• Upgrade multiple development environments on mainframe z/OS platform, including programs, database structures (IMS / DB2 / VSAM), JCL, Bind Packages / Bind Plans, etc.
• I use a scheduler Control-M to start jobs for this purpose. I then monitor the running jobs through the scheduler and use job output software SDSF to troubleshoot errors when necessary.
• After that re-start the scheduler up to the delivery of the environment to the project manager;
• Do a complete refresh of a dev environment starting from an extraction of the production environment; the procedure uses the scheduler in a manner similar to the above;
• Resolve incidents assigned to me regarding problems occuring on z/OS and related platforms. I troubleshoot the problems, find the root cause, write down my analysis and various conversations with users. I document everything on the ticket tracking system HPS M;
• Perform the morning verifications of 2 major z/OS systems: SIC (bank operations) and Hogan (credit cards); and check the health of various components: IMS MPP regions, IMS / DB2 databases, areas, IMS transactions and programs, certain jobs in scheduler, the Golden Gate. When required re-start components that were stopped.

Environment: IBM z/OS, DB2, SQL, JCL, IMS DB/DC, IMS MPP regions, TSO/ISPF, JMR, In-Sync, Endevor, VSAM, Session Manager, Dump Master, SDSF, IOF, Control-M, QuickRef, Pulse Secure for remote access to my work computer. BMC Catalog Manager for DB2.

Confidential

Analyst-programmer - Mainframe

Responsibilities:

• In accordance to business rule changes, do the following in the large application ‘Operational Accounts‘:
• Make enhancements to Online programs written in TELON/COBOL accessing IMS/DB2 databases, using the TP monitor IMS/DC;
• Make changes to and test various Batch Cobol programs accessing IMS / DB2 databases in the system;
• Produce the test plans, execute the tests and describe the tests results, and hand them over the Quality Control team;
• Develop and test common modules responsible for the physical considerations of accessing IMS fast path databases in an optimal way.
• Create and test new Batch Cobol programs accessing IMS / DB2 databases, in the Registered R etirement Savings Plans and investment systems;
• Create and test multiple steps JCL using various features of utility programs such as DFSORT, JOINKEYS, and the language Easytrieve, to extract data from the Loan system and build statistical reports;
• Develop and test a new stand-alone Cobol Batch BMP (Batch Message Processing) accessing IMS databases, with the objective of updating a ddresses in the Client Central File. The program uses checkpoint / restart logic.

Environment: IBM z/OS 2.01, IBM Enterprise COBOL for z/OS 4.2, OS/JCL, TELON, IMS DB/DC, MFS, PSB, XPEDiter IMS, BTS, TSO/ISPF, File-AID IMS/DB2/VSAM, Endevor, VSAM, SDSF, Z/OS DFSORT V2R1, Abend-AID, CA-Optimizer/II.

Confidential

Analyst-programmer - Mainframe

Responsibilities:

• Develop Cobol programs and JCL accessing DB2 and IMS databases, on an important project impacting many banking systems;
• Develop and execute unit & integrated test scenarios, as well as detailed documentation of the test results;
• Develop the instructions to the operators, for proper restart of batch jobs that failed to finish normally;
• Document the logic flow and functions inside the Cobol programs and JCL;
• The project relates to a Common Declaration Standard between financial institutions of many coutries, and aims at counteracting Tax Evasion; therefore impacting important operational banking systems residing on the IBM mainframe of the company;
• The project will enhance the scope of an already existing IT implementation that came as a result of an american tax evasion law: FATCA (Foreign Account Tax Compliance Act).

Environment: IBM z/OS, IBM Enterprise COBOL for z/OS 4.2, DB2, SQL, JCL, SPUFI, IMS, BMP, XPEDiter, TSO/ISPF, In-Sync, Endevor, VSAM, Session Manager, Dump Master, SDSF, XCOM, Control-M, ICETOOL, GDG, IDCAMS, Citrix Virtual Portal for remote access to my work computer.

Confidential

Sr Analyst-Programmer - Mainframe

Responsibilities:

• Provide application support & development for the Claims Management System (CMS). Many tasks are driven by a ticket system from BMC: Service Desk Express;
• I am a player in the On-Call rotation for production support of CMS;
• Troubleshoot various problems that users experience Live; some are solved using in-house developed tools;
• Make enhancements to existing legacy CMS, in batch / online modes;
• Batch uses JCL, Cobol, ASSEMBLER, NATURAL accessing ADABAS databases, VSAM files, GDGs, flat files;
• Online uses NATURAL accessing ADABAS files / DDMs.

Environment: IBM z/OS, NATURAL, ADABAS, Natural Debug, Cobol, ASSEMBLER, DB2, SQL, JCL, XPEDiter, TSO/ISPF, File-AID, Endevor, VSAM, Abend-AID, SDSF, FTP, $AVRS, CA-7, CA-11, TPX session manager, DFSORT, GDG, IDCAMS, Citrix Virtual Portal for remote access to my work computer.

Confidential

Sr Analyst-Programmer - Mainframe

Responsibilities:

• Do the analysis and work / cost estimates for application changes related to the project “New Code of Civil Procedure”;
• Program and test changes to components dealing with the financial system “Claim Management” in scope with the above project: pseudo-conversational programs written in CICS / Cobol accessing Datacom/DB, and Batch programs written in Cobol / Datacom-DB embedded in JCL (job control language);
• Use Xpediter/CICS to debug in CICS TEST AOR (Application Owning region);
• Create and modify IDEAL / Datacom (4 th GL) programs related to the management of Court of Justice files;
• Use DataQuery tool to investigate and update Datacom tables; very useful to synchronize data for test purposes, in the TEST CICS TOR regions and Acceptance CICS TOR (Terminal Owning regions).

Environment: CA-MetaCobol (pre-compiler CICS/Datacom), CA Enterprise Cobol for z/OS (Cobol 4), IBM z/OS 2.1.0, CICS Transaction Server for z/OS, IDEAL 4th GL, Datacom DB, DataQuery, BMS (Basic Mapping Support), SDF II, Xpediter/CICS, z/OS JCL, TSO/ISPF, CA-LIBRARIAN 4.4 (Source code management), SDSF, Session Manager 3.2, Abend-AID, Top Secret (Security software), File-AID 10.2, SYNCSORT for z/OS, Word, Internet Explorer, Excel, Novell GroupWise (emails), MS Project Web Access (timesheets), Windows 7, PDF, SharePoint, etc.

Confidential

Sr Analyst-programmer

Responsibilities:

• Build new programs, maintain existing programs using Natural language, accessing ADABAS databases on the mainframe. JCL is also used for Cobol batch programs which perform: reporting, updating DB2 tables, FTP files to shared drives.
• Build new Natural Online modules, using maps, help maps and programs, that allow navigation through multiple screens, and display data retrieved from ADABAS DDM’S, for the project ABR (Alignment of Business Rules).
• Use Debug facility for Natural.
• Develop Cobol program for initial load of a project, doing retrieval from DB2 tables and outputting to file with fields of variable lengths. This required some interesting Cobol table manipulations.
• Do enhancements to Cobol programs and sub-programs for the purpose of upgrading existing complex business rules (First Mile / Last mile project is an example). The Cobol programs are running under IMS/DC as transactions.
• To participate in the analysis and the development of programs written in Natural / ADABAS, using MQ Series, for the project Trap Router Retirement; and on a recent project called US Customs Automated Export.
• Of course, do the unit tests, integrated tests, debug, produce tests scenarios, document/prove the test results, etc, with help from the Debug facility for Natural, and debug tool from IBM for COBOL. Also use Dump Master from Macro4 to view clearer job/program execution dumps.
• Produce containers with ISPW software to include all components that I am assigned to, for version control / change management purposes. Often various projects compete to acquire modules and make changes to them. This must be carefully managed, and ISPW is of great help for that.
• Maintain efficient communication with various partners/colleagues, using technology such as Instant Messaging, Outlook, internal telephone to convey information efficiently and get things done
• Use IBM DB2I SPUFI to perform various actions on DB2 tables; like to understand the data better, to query views and tables, to update, insert, delete rows, to build and synchronize DB2 data while performing the tests.
• Use Platinum for DB2 for z/OS software to perform other DBA related activities on DB2 objects.

Environment: IBM z/OS 2.1, Software AG’s NATURAL, ADABAS DB, including Natural maps and Help maps, IBM Enterprise COBOL for z/OS 4.2.0, IMS/DC, FTP (File Transfer Protocol), MQ Series, ISPW version control, TSO/ISPF, DB2, Platinum for DB2 for z/OS, SDSF job output, VSAM, GDG (Generations Datasets), z/OS files, File Manager (IBM), SuperSession, TSO Extended Search utility, various Time recording systems (SAP, Tedi from Jovaco, Agile Collection from MS).

Confidential, Buffalo, NY

Mainframe Analyst-programmer

Responsibilities:

• Document the multiple system interfaces that feed the Credit data warehousing system in scope for the high visibility project « Greenfield ». Explore various mainframe components, and document results in many different spreadsheets: Cobol programs, ASSEMBLER programs, Easytrieve and SAS programs, DB2 tables, IMS databases, jobs (JCLs), GDGs, CA7 schedule, Endevor, etc;
• Do some changes to JCLs, unit / systems tests, document test scripts / test results for Release 1 of « Greenfield »;
• Develop new programs and make enhancements to existing programs of the Credit data warehousing system , utilizing the Cobol language accessing DB2 and IMS databases for Rel. 1 of Greenfield;
• Participate in meetings about business processes, data modeling, with users, architect and various analysts, for solutions in the Greenfield project.
• Enterprise Cobol for z/OS, ASSEMBLER, DB2, IMS, SQL, JCL, CA7 scheduler, TSO/ISPF, Endevor, z/OS 1.13, IBM File Manager, IBM Debug, SAS, VSAM and GDGs, DB2I / Spufi, Syncsorts, SDSF, CLIST, FTP, Lotus Notes, Word, VISIO, Internet Explorer, Excel, SharePoint, Clarity, etc.

Confidentia z/OS IMS DBA, technical support

Responsibilities:

• Improved the RUNSTATS statements/clauses on TABLESPACE / TABLE and INDEX of DB2 databases, by understanding clearly the various parameters of the utility, and the statistics collected by it;
• Worked with DB2 utilities: LOAD, UNLOAD, FAST UNLOAD, COPY, REPORT TABLESPACESET, LISTDEF, RUNSTATS (on TABLESPACE / TABLE and INDEX);
• Used DB2 commands to Terminate utilities, Display / Stop Databases or Tablespaces;
• Created / altered / dropped the following DB2 objects: databases, tablespaces, tables, unique & non unique indexes, index spaces, image copies;
• Modified the AUTHID, SQLID and SCHEMA names for different users;
• Queried and interpreted the information from the SYSIBM catalog tables;
• Created new LISTDEF INCLUDE INDEXSPACES TABLESPACE DB2 utility statements;
• Created new DB2 Image Copy jobs utilizing LISTDEF and Templates;
• Production support of the IMS / DB2 environment, On call 24/7 in a rotation;
• Cleanup activities surrounding IMS transactions & components, resulting in more free space and resources for IMS regions (TEST, ACCEPTANCE, QA and Production);
• The activities that were involved for the above: delete IMSGEN source, inactivate PSB source in Panvalet libraries, delete PSB executables from partitioned datasets, stop and dequeue transactions in IMS, delete ACB executables from partitioned datasets (TEST, ACCEPTANCE, QA and Production), delete source IMS programs, delete IMS transaction entries from DB2 tables using File-AID DB2, delete MFS formats, run the IMS Mod Blocks gen for IMST, IMSA, IMSQ and IMSL (prod), enter IMS and Master terminal commands to cause the Mod Blocks online changes to occur, run IMS Sync jobs;
• Used IEBCOPY utility to backup members from PDS before doing cleanup above;
• Analyzed a few TELON / PL1 programs, ASSEMBLER programs having long running SQLs;
• Replace BATCH IMS Database Image Copy jobs using DFSUDMP0 utility, by ONLINE IMS Database Image Copy jobs (JCL) using DFSUICP0 executed as BMP; create new PSBs using existing DBDs as a base, new PSBGEN JCL and ACBGEN JCL to support this change; also create and generate new IMSGEN source statements; create PROCS to make this change flexible.

Environment: IBM mainframe, DB2 ver 9 & 10, IMS ver 11, DB2I / SPUFI, DB2 utilities & commands, z/OS JCL, DCLGEN, TMON for DB2, ASSEMBLER, VSAM, Panvalet, TSO/ISPF, IOF (interactive output facility), REXX / CLIST, ChangeMan 5.6 (version control / change management), CA7 scheduler, IMS DBRC (database recovery control), TELON, ACF2, TSO utilities, File-AID/DB2, IMS control blocks: DBD, PSB, ACB, PCB; IMSGEN source statements.

Confidential

Job Scheduler and System Implementation Analyst

Responsibilities:

• Work on the high visibility project « Pacioli » that aims at replacing the accounting systems of Confidential with the ERP eBusiness Suite;
• Develop a functional analysis that transforms the accounting entries according to the new charter of accounts, coming from 42 business lines, and link these entries to the new General Ledger of the eBusiness Suite in batch mode;
• Develop program specifications, the coding of COBOL modules, copybooks and JCLs, for the above functional analysis;
• Perform the Unit & Integrated tests for the series of COBOL modules that transform the accounting entries according to the new charter of accounts;
• Develop functional analysis using Macroscope methodology for switching and splitting modules dealing with accounting entries, used in gradual production implementation of the new system, as well as during the period of «parallel». These processing units are developed with OO technologies such as .NET, SQL Server and WinBatch, with help from programming staff which I supervise.
• Understand the highly normative, structured and methodological environment that prevails at Confidential ; including the Systems Development Life Cycle (SDLC), from the business analysis to the migration into production, including the 4 layers of architecture and analysis: functional, detailed, technological and security; with this knowledge I could perform various functional and business analysis activities, interacting with architects, users and developers;
• Look into the current production batch job schedule of « GEAC », a mainframe system that automates accounting operations and produces various reports of financial data (developed in the 80’s). From this analysis, I have created a « reduced cycle » which will be necessary to support a remaining subsidiary called InvestIA outside the eBusiness Suite. Record all details of my findings into a spreadsheet totalling more than 800 entries. This is done to inform various analysts working on the project, about the impacts on files, jobs, audit reports and schedule dependencies;
• To analyse the GEAC General Ledger job dependencies to other systems in the job scheduler ZEKE, identifying the triggering / triggered jobs that will need to change, in the forthcoming GEAC « reduced cycle »;
• From a technological standpoint, « GEAC » has been developed by McCormack and Dodge in languages COBOL, JCL and Easytrieve accessing VSAM files; other mini-systems complete GEAC using software such as KeyMaster, Spitab, .NET, ACCESS and Excel; 240 files come daily into the system in batch mode, loaded with an average of 250,00 accounting transactions;
• From a business view point - to understand better the scope of the project Pacioli - aiming at replacing the current accounting and financial systems by the ERPs, let’s say that they are being used by several entities: Confidential «Corporate» (including 20 small subsidiaries), IA Pacific, IA American, InvestIA, MD Life, IA Fiducie, IAGP and «distinct and mutual Funds».

Environment: OS/390 JCL, ZEKE, WinBatch, SharePoint, .NET, SSIS, SQL Server, TSO/ISPF, Endevor, File-AID, VSAM, GDG, Excel, Word, VISIO, Outlook, SDLC, Structured Analysis, KeyMaster, Spitab

Confidential

Mainframe Migration specialist

Responsibilities:

• Described to clients the benefits of moving their legacy applications off the mainframe: the new ‘Look and Feel’ and reduced costs brought by contemporary technologies such as C# .NET, JAVA, Windows Forms, Web Forms, UDB DB2, SQL Server;
• Responsible to develop Migration Solution stacks of technology replacement for potential customers;
• Identified mainframe technologies used in the environment of the client, and proposed the best migration strategies to target platforms Linux, Unix or Windows (LUW);
• Used migration products from Alchemy Solutions: Neo Batch and Neo Kicks; to transform mainframe JCL, CICS programs, and Cobol code accessing DB2 databases batch / online, into C# .NET accessing SQL Server, in Windows and Visual Studio environment;
• Developed technical documents: Response from Proposals (RFPs), Complimentary Modernization Assessments (CMAs) and Detailed Modernization Assessments (DMAs) as a way to inform potential clients of their available options in migration strategies, the costs and timeline involved;
• Developed a partner solution grid in excel that highlights many mainframe technologies / languages, versus their target platform counterparts; with a list of Migration partners that provide solutions to go from the mainframe to the target environment of choice;
• Taken advanced courses on NATURAL 4 th GL accessing ADABAS databases, to become more knowledgeable on the subject, therefore in a position to propose accurate replacement solutions to clients wanting to move away from the Natural / Adabas costly mainframe environment.

Environment: NeoBatch & NeoKicks, XFrame in Windows, SQL Server, Visual Studio, JAVA, C# .NET, UDB DB2, Windows Forms, Web Forms, Software AG: Natural / Adabas, Microsoft Outlook, Word, Excel, VISIO.

Confidential

Systems analyst

Responsibilities:

• Analyze, program and test changes in COBOL / DB2 programs, copybooks and JCLs of various Bell invoicing interfaces that are part of the DIS (Downstreamer Interface Subsystem);
• Produce a Systems Design document for each Bell Invoicing interface that is part of the DIS outlaying the programming changes that must be done for the Harmonized Sales Tax project;
• Participate in the systems tests; help users in the Client Acceptance tests;
• Participate in the resolution of Changeman’s Audit Package errors, related to the components being migrated into production;
• To collaborate with the India Global Delivery Center of Confidential in performing the programming, tests, the test plans and in documenting the test results.

Environment: IBM’s Enterprise Cobol for z/OS 3.3.1, DB2, IBM’s SQLPA (SQL Performance Analyser), QMF, SPUFI, OS/390 JCL, TSO/ISPF, Changeman 5.6, z/OS 1.9, XPEDiter TSO, File-AID for DB2 6.0, File-AID for MVS, VSAM.

Confidential

Sr Analyst-programmer

Responsibilities:

• Functional / Detailed Analysis of Batch Cobol / DB2 functions within the important project Single Commission.
• Actively participate in the knowledge transfer of system Single Commission, in the area of activities of Online - CICS, for the benefit of the Saguenay operation. Participate in the definition of CICS infrastructures for the User Acceptance Tests (UAT) of the new system.
• Production support of the Single Commission system, On call 24/7 in a rotation;
• Acted as a mentor in the development of batch Cobol - DB2 functions, towards junior mainframe resources of the Saguenay.
• Analyze and code changes in COBOL programs and JCLs to put in place the solution that handles Tel# changes in the SNAP Volt Commissions system: DB2 Commission table updating, production of revenue & commission (+/-) amounts records in Snap out file. Discount removal in calculations/reporting. Removal of irrelevant roundings in revenue/commission calculations.
• Produce, execute, monitor and report the results of execution of dozens of jobs (JCLs) in the course of the User Acceptance Testing of new system BUNDLE. The latter connects conventional Yellow Pages customer accounts, to account information relative to the ads posted on the Internet.
• Produce all PDS libraries and members, various files, in order to execute, monitor and report the results of execution of Cycle 0, Cycle 1 and Cycle 2 of User Acceptance Tests, for project 'Price by Heading'. The goal is to test further 13 programs that I modified / Unit tested earlier.
• Various systems are involved here, in the job streams: SFA, Yellow pages, EDW (data warehouse), using IMS and DB2 database technology.

Confidential

Analyst-Programmer

Responsibilities:

• To analyze, program and test changes in COBOL / IMS BMP (Batch Message Processing) modules for the important project ‘Chip cards’, which function is to produce embossed debit / credit banking cards. The programs are to communicate with the ‘Cryptographic Architecture’ application and obtain master and derived keys, as well as the PIN block counter;
• To embed checkpoint / restart mechanism in above COBOL/IMS programs, to safeguard data integrity in case they abend;
• To analyze & program using COBOL IMS DB/DC, produce test plans, perform the tests for the systems: Mortgage, Credit Card financing and Personal loans;
• To analyze, program and test changes using COBOL IMS/DC - DB2 for systems: Collect and Pay Interests and Fees, Consolidation of Commercial Accounts. Make adjustments to maps using MFS’s control blocks: DIF / DOF, MID / MOD.

Environment: IBM’s Enterprise Cobol for z/OS 1.3.0, IMS DB, BMP (Batch Message Processsing), PSB, IMS DB/DC, BMP, MFS, PSB, DIF/DOF, MID/MOD, DB2, SQL, OS/390 JCL, XPEDiter, TSO/ISPF, z/OS 1.6.0, File-AID IMS / DB2 / standard, files of types VSAM and GSAM, Spufi, SDSF, IBM and TSO utilities, SuperEdit, Abend-AID.