Sr. Db2 Developer Resume
Irving, TX
PROFESSIONAL SUMMARY:
- Programming and analysis specialist with over 23 years of industry experience serving in production support, DB2 development, stored procedures, maintenance, annual disaster recover, CA - 7 job scheduling, FTP and NDM transmissions.
- Designed, developed, maintained and enhanced software for both batch and online systems utilizing COBOL, DB2/SQL, C, IMS, JCL, Changeman and more.
- Designed stored procedures in batch COBOL and DB2.
TECHNICAL SKILLS:
Software: COBOL, COBOL II, VSAM, FileAid, DB2/SQL, Stored Procedures, JCL, REXX, CLIST, CICS, SDFII, MVS/OS390, AS/400, z/OS, TSO/ISPF, Xpediter, Changeman, Easytrieve, Endevor, Rexx, Microsoft Office, Natural, MS Visio, File Manager, Librarian, CA7/11, UNIX
Databases: DB2, IMS, QMF, ADABAS, Platinum, SQL Server, Focus
PROFESSIONAL EXPERIENCE:
Confidential - Irving, TX
Sr. DB2 Developer
Responsibilities:
- Analyze, design and build DB2 stored procedures for “de-duping” and “netting” per unique client requirements
- Provide assistance to peers on evaluating design and execution details
- Collaborate with developers to resolve defects in coding
- Modify existing software to correct errors, to adapt it to new hardware or to upgrade interfaces and improve performance
- Work with Business Systems Analysts to ensure programming code meets business requirements
- Balance and prioritize multiple projects concurrently
- Participate in QA and UAT testing
- Supervise and train Consultants and employees new to the team
Confidential, Plano, TX
Sr. Mainframe Production Support / Developer - COBOL / IMS / DB2
Responsibilities:
- Worked on the Trade Line application (import/export) and receive knowledge transfer for the application.
- Determine how MQ XML / Swift messages flow between Cash Pro, Trade Flow and Trade Line.
- Maintain responsibility for the application and play a major role in production support, development, maintenance and enhancements as per the requirements.
- Worked on other applications, including: World Banking System (WBS), Escrow Management, Customer and Product Profitability, Corporate Account Analysis, Credit Card Exception Reporting, Automated Investment System (Sweeps) and the Account Reconciliation System.
Confidential, Fort Worth, TX
Lead Mainframe COBOL / IMS / DB2 Developer
Responsibilities:
- Designed, developed, maintained and enhanced software for both batch and online systems utilizing COBOL, DB2/SQL, IMS, JCL, Changeman and more.
- Balanced and prioritized multiple projects concurrently.
- Adhered to SDLC approach throughout the projects.
- Demonstrated excellent troubleshooting skills.
- Provided complete production support of LISS application.
Confidential, Westlake, TX
Sr. Mainframe COBOL / DB2 Developer
Responsibilities:
- Converted existing COBOL, Natural and ADABAS programs to call DB2 service routines for dual updates.
- Developed programs in COBOL and DB2 to systematically identify tax authorities that allow wires and suppress creation of physical checks (saving thousands in cost).
- Designed several stored procedures in batch COBOL and DB2.
- Developed programs to load balance records file to automate the FMS Manual Payments.
Confidential, Dallas, TX
Mainframe Technical Analyst
Responsibilities:
- Effectively worked with the business partners on requirements to develop and enhance healthcare claims processing applications utilizing COBOL II, JCL, DB2, CICS and more.
- Implemented, installed and tested new releases from a third party vendor known as FISS.
- Maintained and supported the existing batch and online systems.
Confidential, Berlin, CT
Senior Programmer / Analyst
Responsibilities:
- Worked with the business partners, end users and IT personnel to gather requirements for the decommissioning project.
- Analyzed and documented the current stored procedures written in batch DB2 and COBOL for the legacy sub-systems to be retired.
- Developed a repeatable methodology to decommission customer service legacy applications and recommended a toolset for the retiring applications during phase I.
- Implemented methodology with detailed project plan developed in phase I.
Confidential, NY
Senior Applications / Specialist
Responsibilities:
- Developed several stored procedures in batch COBOL and DB2.
- Analyzed, developed, and maintained programs in the Accounts Payable, FSV Focus and CARMS Accounts Receivable systems.
- Utilized COBOL, DB2 and SQL, Stored Procedures, Easytrieve, VSAM, MVS and JCL, CICS and more.
- Worked with the internal and external auditors for Sarbanes-Oxley (SOX) compliance.
- Supported Capital Tracking System batch interface in UNIX.
- Provided complete mainframe production support.
- Analyzed, designed and developed the MICR application to collect customer bank accounts on an ongoing basis utilizing FileAid.
- Worked with Royal Bank of Canada on payment orders utilizing EDI 820, ACH.
- Maintained A/P sub-ledger automation, saved business hours of manual work by creating an interface into a G/L package called GLCM.
- Spearheaded retirement of over 8K assets from the Denver Shadow full service vending application.
- Developed an ad-hoc tool start to finish for the business in the full service vending application.
- Successfully completed check outsourcing to further limit manual check printing at PBG headquarters.
- Automated complex manual CASH test procedures using REXX and CLIST for the team.
- Documented the current-state of the CASH subsystem for the A/R upgrade (PARe2).
- Trained the teammates in the use of Virtual Data Access (VDA) architecture.
- Analyzed, developed, and maintained programs in the media and funds management systems utilizing ADABAS and Natural, Focus, and COBOL.
- Maintained the FMS online system utilizing ADABAS and Natural and Map Editor.
- Utilized ADAPREP host language interface in batch COBOL.
- Coded and implemented Y2K compliance enhancements for over 50 modules in Natural.
- Provided major contribution in remediation of the media system from VM and CMS to MVS.
- Documented the annual Nielsen process that applies the TV viewing hours’ ratings to the MAPS system before establishing the budgets for the New Year.
- Enhanced various business critical budget reports (e.g. Cents per Case, Market Summary, PostStam, etc.).
- Fixed a bug left by IBM during the Y2K test where online transactions were displaying incorrectly in a random order.
- Helped user to avoid tremendous manual work.
- Corrected the Accounts Payable interface program used to pay millions of dollars invoices to a national advertising agency known as BBDO.
- Provided on-call support for the daily, weekly and monthly batch cycles.
Confidential, Farmington, CT
Mainframe Business Applications Programmer
Responsibilities:
- Analyzed, developed, and maintained programs in the Customer Order Processing System (C.O.P.S) utilizing COBOL II, VSAM, CICS and DB2.
- Converted old COBOL II VSAM and CICS order entry applications to DB2 and CICS.
- Developed a common date subroutine to be invoked by accounting, sales and marketing and other applications.
- Developed the Williams Freight Expense reporting programs in batch DB2 and COBOL II.
- Modified programs for the Y2K compliance.
Confidential, Rye Brook, NY
Senior Staff Specialist
Responsibilities:
- Designed, developed and implemented communication applications utilizing COBOLII, TSO, DB2 and CICS for MCII Finance.
- Designed and developed the error suspense analysis system.
- Programmed several Crystal Reports from detail and summary DB2 database tables using the MDI gateway.
Confidential, Stamford, CT
Programmer / Analyst
Responsibilities:
- Developed and implemented the financial applications utilizing COBOLII, CICS, SDFII, DB2 and SQL.
- Wrote, tested and maintained production JCL and PROCS.
- Maintained sole development of the new landlord address maintenance system in CICS, SDFII and DB2.
- Provided major CICS enhancements to the vendor maintenance system.
- Performed major contribution in upgrading the DDA Integral Accounts Payable system to new 6.5 release.
- Combined the Home-Office and store Gift s to prevent redeemed not issued reconciling item.
- Developed new programs capturing multiple employee credit card returns for loss prevention.
