PROFESSIONAL PROFILE:

• A dedicated and enthusiastic professional with a successful background as a senior programmer analyst, who specializes in developing complex projects on Mainframe environments, SQL Server environments and DB2 database administration.
• More than 30 years of experience in developing, coding, testing, modifying and executing batch and
• CICS COBOL programs for mainframe system and related applications.
• 5+ years experience as a SQL Server developer.
• 5+ years experience functioning as as a DB2 database administrator and SQL Server database administrator and developer.
• Thorough knowledge of programming in mainframe operating environment, mainframe application, and system programming, SDLC, system troubleshooting and enhancements, requirement gathering and analysis, software documentation and technical specifications designing, project management, application system analysis, continuous integration and deployment strategies, code debugging and optimization, unit and integration testing, user interface and database designs
• Capable of analysing and translating user requirements into technical specifications as well as performing code compiling, debugging, documentation, and enhancement functions.
• Possess excellent communication, analytical thinking, problem - solving, decision-making, time- management, multi-tasking, team-working, organizational, and report-writing skills.

TECHNICAL SKILLS:

Mainframe: IBM-Cobol (Batch), IBM-Cobol (CICS), SQL, JCL, TSO, VSAM, DB2, MQSeries, $AVRS, ControlM, FILEAID, ABENDAID, IBM Utilities, XPEDITER, Intertest, FTP, QMF, SPUFI, DDL, DCL, SQL, TSO/ISPF, Syncsort, Ice Tools, IDCAMS, VM/CMS, Easytrieve+, Datacom, ROSCOE, TRMS, Panvelet, IMS, IBM DB2 Utilities, Endevor, Platinum DB2 Utilities, BMC DB2 Utilities and MYSQL.

SQL Server: SQL Server Management Studio (2000, 2008, 2012, 2014), SQL Server Business Intelligence Development Studio, T-SQL, Integration, Analysis and Reporting Services

Other: Teradata SQL Assistant, Teradata Utility Pack, PowerDesigner, Visio, Microsoft Word and Excel, Lotus Notes, Citrix, MS Query

CAREER SUMMARY:

Confidential, ATLANTA, GA

SENIOR MAINFRAME ANALYST DEVELOPER

Responsibilities:

• Worked with the development team and clients in identifying and documenting project requirements as well as coding, enhancing and implementing high-quality mainframe applications and software products using COBOL, VSAM, Datacom and DB2 accordingly.
• Analysed and translated user or business requirements into detailed system functionality and various application components as well as designed, coded, compiled, debugged and modified complex online and batch COBOL and SQL programs and created efficient test data, plans and procedures as required.
• Created accurate and complete mainframe software documentation that included troubleshooting guides and user manuals as well as actively responded to user requests and provided effective technical support regarding system or application usage for Mainframe and SQL Server.
• Analyzed, developed, tested and maintained T-SQL queries, SQL Server Jobs, SQL Server packages and SQL Server tables..
• Defined DB2 and SQL Server Tables, Indexes, views and stored procedures
• Used DB2 utilities to unload and load data from production to test environment.
• Wrote complex SQL queries involving multiple tables with inner and outer joins and correlated subqueries
• Involved in upgrading from SQL Server 2000 to SQL Server 2008 and later to SQL Server 2012
• Set up utilities for pulling and reformatting data from VSAM, DB2, Oracle, Teradata and flat files in a format that was moved to SQL Server using FTP.
• Provided on-call support on a rotating basis for both mainframe and SQL Server environments.

Confidential, ATLANTA, GA

SENIOR MAINFRAME ANALYST DEVELOPER / CONSULTANT

Responsibilities:

• Coding and testing Y2k changes to the Dun and Bradstreet E Series Payroll/HR System
• Converting batch and CICS Cobol programs to Cobol II using VSAM data

Confidential, ATLANTA, GA

SENIOR MAINFRAME ANALYST DEVELOPER / CONSULTANT

Responsibilities:

• Modifying Cobol batch and CICS programs to use DB2 instead of VSAM
• Setting up DB2 loads to load data to a new DB2 Database from VSAM data
• Coding DDL to create the Database, Storage Group, Tablespaces, Tables, Indexes views and Stored procedures
• Running DCLGENS, setting up and running DB2 utilities (loads, unloads, reorgs, runstats)
• Coding and testing conversion and report programs using Cobol and Easytrieve
• Monitoring and tuning DB2; Running DB2 explains and access path analysis
• Coding complex SQL queries
• Unloading VSAM data to files that were then loaded to DB2
• Converted the Exam Board System from VSAM to a DB2 Database

Confidential, ATLANTA, GA

SENIOR MAINFRAME ANALYST DEVELOPER / CONSULTANT

Responsibilities:

• Designing, writing and supporting batch and online computer systems
• Converting macro CICS programs to Command Level COBOL II
• Working as part of the MVS/ESA 5.2 and the CICS 4.0 implementation team
• Contributing to team effort by accomplishing related results as needed

Applications included:

• Clinical Order Communications
• Laboratory Information System
• Radiology
• MicroMedex
• Medipac
• Dun and Bradstreet E series Payroll/Personnel System

Confidential, ATLANTA, GA

SENIOR MAINFRAME ANALYST DEVELOPER / CONSULTANT

Responsibilities:

• Designing, implementing and maintaining batch and online computer systems
• Materials Management
• ASI Inventory Control Systems

Confidential, ATLANTA, GA

SENIOR MAINFRAME ANALYST DEVELOPER / CONSULTANT

Responsibilities:

• Designing, implementing and maintaining mainframe batch and online computer systems

Applications included:

• ASI Purchasing / Materials Management system
• MSA Payroll and Financial Systems

Confidential

MAINFRAME ANALYST DEVELOPER

Responsibilities:

• Designing, implementing and maintaining mainframe batch and online computer systems

Applications included:

• Payroll and Human Resources (MSA)
• Customer Billing, Accounts Payable, Accounts Receivable and General Ledger
• Inventory Control (ASI), Materials Management and Insurance
• State Applications (Medicaid, Motor Vehicle, Child Welfare and Exam Boards)