We provide IT Staff Augmentation Services!

Db2/mainframe Programmer Resume

4.00/5 (Submit Your Rating)

PROFESSIONAL SUMMARY:

  • Built structured analysis and design of online and batch DB2/IMS/IDMS/CICS/MVS COBOL mainframe programs, using several SDLC strategies for all project analysis, development, testing, and performance tuning,
  • Created and executed JCL, Procs, SET statements, INCLUDE statements, in the Z/OS Mainframe environment, and using symbolics and condition codes, and job scheduling software and their processes (CA7, Zeke),
  • Created and modified applications built with COBOL, Assembler, JCL, VSAM, IMS, IDMS, ADS/O, MQ middleware, and DB2 Stored Procedures, as well as load - and-go programming - Easytrieve, SAS, Quikjob, and Rexx,
  • Conducted research and debugging efforts, using tools such as Xpediter and IBM debug for batch and online, and CA-Intertest for CICS, and worked with various mainframe file and data manipulation tools (Syncsort, DF Sort, IEBGENER),
  • Utilized various change management software packages including Endevor, Changeman, Roscoe, and Librarian,
  • Utilized data transfer protocols such as Network Data Mover (NDM) and Secure File Transfer protocol (SFTP), and collaborated with managers, clients, team members, and other project teams - with correspondence utilities such as Lotus Notes, SharePoint, Visio, Clarity, and Outlook,
  • Built and uploaded project initiatives, analysis and design documents, and testing cases, into JIRA, SharePoint, and Rational as repositories,
  • Worked with managers and team members on short and long-term projects as well as providing production and on-call support on demand using SDLC methodologies such as Waterfall and Agile.

TECHNICAL SKILLS:

Tools/SoftwareProgramming Languages: JCL / Copybooks / Procs, TSO/ISPF20 yrsCobol20 yrs CICS, CEDF, SDF, BMS, VSAM, IDCAMS15 yrsCICS Cobol Xpediter/CICS, CA - Intertest, Abend-Aid CICS10 yrsDB2 Sql Xpediter/TSO, File Aid/MVS, Abend-Aid MVS10 yrsIDMS ADS/O, IDMS/R, IDMS Cobol/DC12 yrs DB2, SQL, Spufi, QMF, File Aid/DB28 yrsBasic Assembler

Administration Tools: IBM Utilities, DF Sort, Extra10 yrsIMS, DL/I, Easytrieve Syncsort, SAR, TMS, JIRA, Sharepoint

Platinum Tools: RC Query, Data Warehousing DB2 Stored Procedures, Mainview for WebSphere CA7, CA11, FTP, NDM, QuickRef Changeman, Endevor/MVS, CA-Panvalet, Librarian15 yrsUnix/Oracle (Not used since 2005) IDMS OLQ, IDD, MAP/C, OLM12 yrsUNIX, Exceed, Telnet, Oracle 9i, Datastage1 yr DML/O, IDMS/SQL, OCF, ADS/A Windows 95/98/NT/20xx/XP/Windows 815 yrsPL/SQL Microsoft Word, Excel, Lotus Notes, Visio, Outlook DataStage Basic HP Quality Center, Appwatch, MQ Control-M, Control-D, Smartest, SmarteditDebug CICS and Batch (GUI and Mainframe)File Manager/TSO, BMC Catalog Manager

Operating Systems: IBM Mainframe and IBM compatible PCs, CICS, IDMS, IMS, DB2, CMS, Unix

SDLC Methodologies: Method 1, Waterfall, Agile (some exposure)

PROFESSIONAL EXPERIENCE:

Confidential

DB2/Mainframe Programmer

Responsibilities:

  • As a Programmer Analyst at Total System Services (Payment Card Industry), was placed within the Financial Control Services Division for North America applications. These included executing card transaction processing such as reporting, handling settlement information, posting, and routing electronic transaction information to and from the following associations (Visa, MasterCard, Discover, Amex, Discover, and Diners Club).
  • Within the FCS Division, my services were performed for the Incoming and Outgoing project team. Daily activities include creating, analyzing, designing, coding, debugging, and maintaining existing elements, and testing and implementing all elements within and under project timelines. Another key activity within the Incoming and Outgoing team included participation in detailed technical reviews for a member preparing for an upcoming implementation of a project.
  • This process was documented very extensively and became part of the design documentation. Members would review and offer advice and point out mistakes and how to make corrections. These reviews also applied to ticket resolution.
  • The manager of the team was also involved and every person was responsible for making certain that the new solutions were fault-free and production-ready.
  • The Incoming and Outgoing team also collaborated and communicated with other teams including Business Analysts, Production Support personnel, and Operations to confirm that the implementations of the project / ticket went into production smoothly, with no issues. Incoming and Outgoing team members and the team manager, also assisted with on-the-job and provided guidance and mentoring to other developers.
  • Was assigned as the main programmer analyst for the Incoming and Outgoing team for the second annual Compliance Release issued from the TSYS associations (Visa, MasterCard, Discover, Amex, Discover, and Diners Club). Association requirements included updates to interchange rates, price changes, additional products, category codes, currency codes, and text descriptions. I was responsible for attending meetings related to the release, reporting my own updates, taking notes to assure that all relevant business requirements were understood, and reviewing and discussing solutions provided by business analysts. Was also required to collaborate with other I/O team members to assure that my analysis, designs, and testing documents were accurate and fit TSYS standards for development. Was responsible for keeping up-to-date changes as the associations made changes during the release, and also writing technical documents and posting them into SharePoint and Rational sites. Made revisions in COBOL and Assembler programs, copybooks, jobs, procs, symbolics, cond conditions, and JCL and CA7 schedules.

Environment: Enterprise Cobol, Assembler, Endevor, Easytrieve, REXX, CICS, JCL, Procs, Copybooks, VSAM, DB2, z/OS, Syncsort, Spufi, File Manager, IBM Debug, SAR, QuickRef, TSO/ISPF, CA7, Microsoft Word, Microsoft Excel, Outlook, Lync, NDM, SharePoint, Rational, IBM utilities.

Confidential

Mainframe Consultant

Responsibilities:

  • Using Microsoft Word, wrote prototypes of CICS screens for the Customer Account and Meter Electric Systems containing the new remote disconnect codes and descriptions.
  • Wrote new batch programs, and revised existing programs in COBOL, DB2, and VSAM - to initialize the new disconnect codes before production implementation, and modifying existing files and tables to accommodate the new data.
  • Using BMS and CICS Cobol, revised maps and program code, adding the new disconnect codes and descriptions. Over 100 screens and programs were built from scratch and/or modified, with three programmers.
  • Participated in project meetings including the IT staff for the project, as well as managers and Customer Account and Meter Electric staff members.
  • Wrote technical specifications for modules and maps, jobs, procs, and stored procedures.
  • Wrote unit test cases to present to the management and staff of the Customer Account and Meter Electric Systems, and worked with staff to validate the correctness of the new fields. (Ran batch jobs myself and presented results to the business side; business side performed testing of CICS screens).
  • Worked with production implementation staff and wrote documentation to include all modules and jobs assigned to me.

Environment: Enterprise Cobol, CICS, BMS, OS/JCL, VSAM, DB2, DB2 Stored Procedures, Spufi, TSO/ISPF, CA7, Roscoe, Librarian, XPEDITER, Microsoft Word, Microsoft Excel, IBM utilities.

Confidential

Mainframe Consultant

Responsibilities:

  • Performed project development, applications support, and production support, at the client site of Bank of America Merrill Lynch, a global banking and global markets business of Bank of America Corporation.
  • The business emphasis involves lending, derivatives, and other commercial banking activities, post trade confirmation, settlement, custody, transaction management, and client services for the banks’ equity market products - equities, electronic trades, and commodities.
  • Assisting Settlements and Transaction Management teams on large to small scale projects on the mainframe platform, co-existing with distributed environments.
  • In order to comply with an enterprise audit finding for the Deceased Client Notification process, a new field was added - called a unique ID, into the Abandoned Property system. This new field was needed to comply with corporate due diligence practices and state reporting, and was designed to be sent to an external vendor that would identify Merrill Lynch accounts owners as deceased.
  • The unique ID field was used to match up related accounts within the enterprise so that all accounts within the enterprise for the same deceased owner would be marked as deceased.
  • This way, the updated client information on the Abandoned Property system could be used to age accounts for escheatment. Wrote new cobol programs to initialize the abandoned property data on DB2 tables, and revised cobol code, jobs, procs, and other elements within the Abandoned

Environment: Cobol LE (batch and CICS), JCL, TSO z/OS, MVS ISPF, DB2 v10, Spufi / DB2 Commands (DB2I), CICS v8.1, VSAM, IDCAMS, Xpediter/CICS, Appwatch, MQ, Syncsort, DF Sort, File Aid for Batch, File Manager for TSO, FTP, NDM, MVS, SAR, TMS, Endevor, Waterfall and Agile Methodologies, QuickRef, IBM Utilities, distributed technology, DCAR, OSDA, DB2 Catalog Manager (BMC).

Confidential

Mainframe Programmer

Responsibilities:

  • As a team member of the CDH PSO (Consumer Driven Health, Product Support Organization) - on a daily basis, participated in the resolution of incident-related production defect ‘tickets’ raised by clients or the CDH Triage team, conforming to strict timelines based upon the urgency of the issues.
  • In all cases, started process of performing ticket resolution with an initial ticket review by looking up the specific ticket information on the Remedy 7.5 system, followed by gathering documentation from individuals who formerly worked on the ticket, ticket-related emails, application documentation on network repositories (Sharepoint sites, network files), mainframe elements in pds files or Endevor, and communications with subject matter experts (technical leads, team leads, project leads, and co-workers).
  • Proceeded to next steps, performing research and analysis using various debugging tools and utilities to determine the exact source of the defect, and developed strategies for resolving the defects.
  • For each ticket, determined if defects originated within the CDH application, and if so, proceeded to the ‘build’ phase, making source code changes - batch and online, including DB2 sql statements, jobs, procs, job schedules, control cards, online maps, and any needed file additions, modifications, adjustments, re-sends, and extracts. Remaining steps consisted of two phases of testing, one phase for unit testing, and a second, for ‘Maintenance’ testing, using a production-like environment.
  • During testing phases, also provided documentary screen shots to the clients (before and after), to verify the correctness of the changes to the modules or files/tables. Followed with the deployment phase, where the changed modules/files/tables, are moved into the production environment. This phase was then followed by validation of the implemented changes in the production environment.

Environment: Cobol LE, Cobol II (batch and CICS), Easytrieve, Rexx, JCL, TSO/ISPF, SDSF, TPX, CICS v 8.1, BMS, DB2 v9, Spufi, DB2 Commands (DB2I), Unicenter Tools, VSAM, IDCAMS, CA-Interest (mainframe and batch), CA-7, CA-1, Syncsort, File Manager, Endevor/MVS, Sharepoint, QuickRef, NDM, FTP, SOA, XML, MQ, MVS Utilities, Remedy 7.5, HP Quality Center, Microsoft office suite, Waterfall, Agile (some exposure) methodologies.

Confidential

Cobol Programmer

Responsibilities:

  • Participated in a collaborative effort in developing and implementing three ‘RFS’ (request for service) projects from the business units managing health care claims, with the purpose of revising selected categories of procedure codes to add or delete one or more procedure codes within each category. Another objective of the ‘RFS’s was to add or delete other categories, adding new procedure codes to the new categories, or to delete categories altogether. The procedure codes within each category, also known as CPT (Current Procedural Technology) codes, were identified by the business groups to conform to the changing medical insurance requirements. (The appropriate CPT codes exist to show the reason a procedure is performed).
  • All revisions were unit, system, acceptance, and parallel tested on the BCBS mainframe and distributed Claims environments, and included various database methods, including Vsam, DB2, and others within distributed environments (for program calls from the mainframe). Built batch job streams in all testing environments to mimic those in production, and executed and monitored all test job runs and determined and resolved abends in job control, source code, and files - using Debug for batch. Used NDM to port test files to and from different regions and partitions.
  • The programming language used was Cobol LE. Word was used for project documents and client correspondences, with the Waterfall methodology. Tools used were Syncsort, Spufi, Platinum Tools, Debug (CICS and batch), Pan Statements, QuikRef, and NDM.
  • Performed database searches on DB2 tables to assist in trouble-shooting of discrepancies in vendor payment amounts for specific time frames.
  • Participated in a project for the ICD-9 to ICD-10 conversion (International Classification for Diseases) to redesign a CICS screen to use the newly converted ICD-10 diagnostic codes. The screen was revised to accept the new format, presenting the converted codes from a Vsam database.

Environment: Cobol LE (batch and CICS), JCL, TSO/ISPF, DB2 v9, Spufi, Platinum tools, VSAM, IDCAMS, Debug (mainframe and batch), NDM, Syncsort, File Manager, Panvalet, QuickRef, IBM Utilities, Microsoft office suite, Waterfall methodology.

Confidential

Applications Programming Consultant

Responsibilities:

  • Working with multiple teams, took part in analysis and debugging of programming and design errors and abends, and supported QA team in installing initial and remediated code and monitoring and trouble-shooting CICS and batch components through to implementation. During testing, resolved abends and traced logic errors in program logic using CEDF and Xpediter for CICS. Performed implementation tasks such as migrating code into QA and Staging environments, creating Endevor packages for each project, and monitoring the installations and validating the output of the initial production runs. Created word documents documenting the testing processes, including Test plans, Test Results, and validations post-implementation.
  • Performed ad-hoc changes to CICS back-end programs to correct error messages from trades processing sent to production support staff, reformatting message contents and adding new messages as needed. Working with distributed staff, arranged for time slots for testing and delivery by distributed staff to management and technical staff responsible for responding to problems identified by error messages. Built test data for tasks using production backup files using IBM utilities. Worked with CEDF and Xpediter for CICS to resolve abends and diagnose logic errors.
  • Performed multiple phases of testing of CICS back-end programs where coding was performed by others, including unloading and loading tables, Vsam datasets, flat files, and MQ files, validating all test outputs, and correcting programming errors encountered during testing. Maintained correspondence with requestors of the testing and created documentation as required. Employed CEDF and Xpediter for CICS during testing to resolve errors in processing. Employed Waterfall methodology as the SDLC tool.
  • Performed changes, additions, and updates on batch job scheduling management system (PODS) to keep current with business needs.
  • Performed some coding revisions to MQ instructions within batch programs in order to comply with Bank of America MQ coding standards, and tested program revisions and batch job streams to validate the correctness of the changes. Used Xpediter for Batch to find and correct errors in execution. Built batch job streams for Q/A and coordinated nightly Q/A job runs with the Q/A team.
  • Performed enhancements to batch jobs/programs to increase speed and efficiency by revising processing of Vsam datasets, or by adding sorts to consolidate records on relevant keys or to change orders of fields, or to consolidate processing from several job steps into a single job step. After each enhancement was completed, full-scale, full-volume testing was conducted in Q/A and UAT environments and compares of production and test CPU/elapsed times were compared to validate that the revisions were accurate and more efficient. Personally built all batch job streams for every level of testing from unit to Q/A. Added new jobs and job steps as necessary and updated changed/new jobs to the job scheduling management system (PODS).

Environment: Cobol LE (batch and CICS), JCL, TSO z/OS, MVS ISPF, DB2 v9, Spufi / DB2 Commands (DB2I), CICS v6, VSAM, IDCAMS, CA-Intertest, Xpediter/CICS, Viasoft SmartTest, Mainview for CICS, Appwatch, MQ, Syncsort, File-Aid/MVS, NDM, SAR, TMS, Endevor, Waterfall Methodology, QuickRef, IBM Utilities.

Confidential

Mainframe Developer

Responsibilities:

  • Created and executed ad-hoc programs and jobs to update or add records to production files and databases in response to requests from the business in order to maintain data integrity in the TLC (Tender Loving Care) and SET (Southeast Toyota) application environments. Both batch and online programs were affected, as well as batch job streams, job schedules, and job/program documentation.
  • Wrote numerous new SAS programs and jobs to create excel-type delimited-format files to provide production data that emulated CICS transaction screens using filters from the business. Inputs to these programs were DB2 or Vsam unload or back-up files of the tables/files read by the CICS screens. The delimited files written out were imported into excel spreadsheets and these were attached to emails and sent to the business analysts advocating for the client.
  • Revised source code and batch job streams to extend history on month-to-date sales activity transactions to 25 months from 12 months for all TLC production DB2 tables. This was completed in order to allow increased visibility to this activity on the CICS screens, and also to extend the historical archiving of month-to-date sales activity. Used NDM to send/receive datasets for testing from other regions and partitions. For testing, built batch job streams for all testing phases, and worked with schedulers to add/update jobs to the ZEKE batch job scheduling system.
  • Completely revised the process to create audits for the Accounting department to add columns listing various invoice related fields to Vehicle Sales files for the SET line of business. The purpose for these changes was to allow the customer service department to distinguish between various categories of sales.
  • Debugged and corrected batch job streams launched by CICS transactions, to include missing datasets that caused production batch abends. Revised code and jobs and procs to include the missing datasets and re-started all abended jobs. Built all batch job streams for testing environments and executed and monitored all testing, and worked with schedulers to add/update jobs to the ZEKE batch job scheduling system.
  • Made many enhancements to the process of invoice printing for Courtesy Warranty Services and Fidelity Warranty Services dealers for the A/R department within JM & A, in response to claims that invoices were not being printed at the dealerships.
  • These changes encompassed CICS and batch processes for screens, programs, jobs, procs, and control cards. Included in the changes were A/R customer print parameters, report codes, company print parameters on several CICS screens, and batch program, job, and control card changes for the same parameters as the CICS screens.
  • Wrote a SAS program for the purpose of monitoring completion times and elapsed times of selected jobs in SAVRS, with the purpose of providing job run statistics to IT management after large-scale batch scheduling changes were put into effect. Input to this job was the production dataset for SAVRS; output was the punched SAS Report to a held class.

Environment: Cobol for z/OS, Cobol II, Pacbase, CICS, DB2, VSAM, TSO/ISPF, SDSF, QuickRef, JCL, File Aid/MVS, File Aid/DB2, Spufi, DB2 Administration Tools, DB2 Commands, Syncsort, Xpediter/TSO, Xpediter/CICS, Microsoft Office suite, SAS for Z/os, TRMS, SAVRS, Changeman, Service Desk, Outlook, Waterfall methodology, HP Quality Center, and NDM.

Confidential

Mainframe Developer

Responsibilities:

  • Completely rewrote the batch process for formatting institutional delivery trade confirmation authorization records in the PDQ (Pre-Determined Quality) trade cycle sent by Merrill to the Depository Trust Company - the primary clearing and Settlement Company for Merrill’s domestic trades, to conform to the CCF/II formatting conventions in the trading industry. Project included rewriting all programs and jobs that receive transmission records back from DTC. Performed extensive unit, systems, and integration testing of all re-worked jobs and programs as well as those further downstream to validate the correctness of database updates to Merrill Lynch tables and files from the PDQ cycle.
  • Added modifications to back-end daytime CICS transactions used to receive MQ messages from the clearing house - DTC, containing confirms and affirms of institutional trades. Added extensive error routines to the transactions to identify and document DB2, VSAM, CICS Link, and MQ errors occurring during transaction processing. The newly added error messages were then routed to pagers carried by team members responsible for reviewing and researching the error messages to determine the causes of the errors and to correct them. The enhancements to these transactions were installed to remedy the problems that occasionally occurred within the process of reconciliation of CNS confirms on the DTC side - to the
  • Performed modifications to back-end daytime CICS transactions to send pledge messages via MQ to the clearing house - DTC, for pledges of stock and logging of all MQ error messages that would occur during the transactions. Transactions were enhanced to add MQ pledge errors to the Merrill Lynch online Vsam log file. Purpose of this enhancement was to maintain error messages beyond the 2-day window they were kept on MQ log files, to enable Merrill Lynch customer support staff to

Environment: Cobol for z/OS, (batch and CICS), DB2, DB2 Stored Procedures, Spufi, VSAM, JCL, File Aid/MVS, Abend-Aid, Syncsort, Microsoft Office suite, Endevor/MVS, QuickRef, CA-Intertest, CICS, NDM, MQ, OSDA (in lieu of SDSF).

Confidential

Mainframe Programming Contractor

Responsibilities:

  • Tasks included analyzing business requirements and business functional specifications, writing technical specification documents to support the functional designs provided by a business analyst, and developing programs to support the specifications. Developed enhancements, fixes, and regulatory maintenance to the BASE2000 credit card processing application, using JCL, batch Cobol, BMS, CICS, TSO, IBM Utilities, VSAM/IAM utilities, Abend-aid, File-aid, Xpeditor, Endevor, word, and excel.
  • Performed some duties as a business analyst, creating project plan, external functional design, and test plan - for major projects affecting the debit and credit transactions within the BASE2000 system.
  • Wrote the technical design specification for the Payment Hold Modifications Project and developed all code enhancements, environmental parameters controlling logic by corporation, test strategy, and unit testing for the project - in order to enhance the BASE2000 payment hold process to remove or clear a payment hold if the payment was misapplied and subsequently adjusted, and also to allow an institution the option of initiating payment holds based upon the payment transaction date, or the payment posting date.
  • Wrote the technical design specification for the Automatic Fraud Charge off Project and developed all code enhancements, test strategy, and unit testing for the project. The system focus of this project was to correct the BASE2000 calculations of charge off days and dates for fraud accounts, to include the online entry and editing of pending charge off dates on the Account Charge Off Screen, and to include the fraud charge offs in the file maintenance and pending charge off reports.

Environment: Cobol II, DB2, File Aid/MVS, Abend-Aid, Endevor/MVS, JCL, Syncsort, QuickRef, CA-View, Xpediter/TSO, Xpediter/CICS, Microsoft Word, Microsoft Excel, Microsoft Office, Lotus Notes, Easytrieve Plus, TSO/ISPF, Visio, SmartIS, CA7, CICS, BMS.

Confidential

Senior Programmer Analyst

Responsibilities:

  • Participated as an analyst, designer, and developer for conversion of heritage Bank One wholesale and retail accounts for customer/account relationships, name and address accounts, and DDA transactions, to heritage JP Morgan database structures within JP Morgan’s Deposits / DDA line of business.
  • Conducted design, code, development, and testing of merger related modules during all phases of conversion testing, from integrated systems testing through user acceptance and environment testing. Wrote all technical specifications for the Account Name and Address and Customer Account Relationship modules.
  • Worked with DBA personnel in establishing referential integrity environments for multiple DB2 tables and helped to insure consistency of rules across multiple regions.
  • Assisted in all implementation activities, including endevor migrations of code, maps, copybooks, jobs, and procs, and including onsite coverage on a 24 by 7 basis.
  • Completely wrote the batch scheduling for go-live conversion weekends and supplied all conversion implementation documentation for team members using Visio, Excel, and Word.
  • Developed Visio diagrams to display all flows of batch modules within the DDA transaction services job streams. Performed additional enhancements to conversion modules to improve efficiency and readability of reports and screens, employing DB2 best practices for efficiency, and streamlining sysouts to reduce redundant reporting and eliminate unnecessary processing.
  • Played a major role in the Endevor Cross-Region Library Concatenation Project, working with the endevor support specialists to create a special compile process to allow compiles for each test environment, enabling developers to fetch the most relevant copylibs and dclgens for their programs, based upon the projected timing of the related project’s production installation.
  • Developed new CICS screens and programs for the Automated Investment, Dollar Pooling, Intraday, and End of Day investment products, combining functionality and data sources from JP Morgan and Bank One.

Environment: Cobol 3, Cobol II, DB2, DB2 SQL, DB2 Stored Procedures, Spufi, Fileaid/MVS, Abend-Aid, IBM Administration Tools for DB2, Endevor/MVS, Endevor/PDM, JCL, Syncsort, Quickref, Xpediter/TSO, Microsoft Word, Microsoft Excel, Lotus Notes, Easytrieve Plus, TSO/ISPF, Visio, CA7, NDM, WSF, CICS, BMS, Intertest, HP Quality Center.

Confidential

Senior Programmer Analyst

Responsibilities:

  • Performed extensive database fixes to revise key elements in the data warehouse at the request of the business units.
  • Provided analysis, design, development, and ongoing support for the data warehouse and data marts to support business analysis showing trends in customer lending.
  • Wrote functional and technical specifications for software development teams in multiple locations.
  • Worked with other team members to analyze, design, and develop changes to the data warehouse, using requirements from the business units to change or add data elements to the warehouse.
  • Provided production support for the warehouse and the marts, addressing changes or enhancements in the source systems, and participating in an on call rotation for after-hours support, and worked with team members to ensure that the data warehouse met its daily and monthly SLAs for the availability and
  • Completely rewrote the Enterprise Data Warehouse for the Credit Card Services division with other team members, working at all levels of the systems development life cycle to create a data repository consisting of DB2 tables (mainframe) and data marts (Oracle - UNIX).
  • Performed project management for the Spring Compliance 2004 project, delivering key regulatory changes across numerous batch processes and databases.
  • Designed and developed a new portfolio for an oracle data mart, converting two million prime accounts for the Confidential Credit Services Enterprise Data Warehouse.

Environment: Cobol 3, Cobol II, DB2, DB2 Sql, Spufi, Fileaid/MVS, Abend-Aid, Fileaid/DB2, IBM Utilities/Tools for DB2, Platinum Utilities, RC Query, JCL, Syncsort, Quickref, Xpediter/TSO, Microsoft Word, Microsoft Excel, Lotus Notes, Changeman, Easytrieve Plus, TSO/ISPF, Visio, CA7, NDM, FTP, SAR, IDMS/R, CICS, Unix, Oracle, PL/SQL, Datastage.

We'd love your feedback!