Programmer Analyst/Architect/Lead Resume Wilmington, DE - Hire IT People

SUMMARY:

Information Technology Professional with over 18 years of experience as a Programmer Analyst/Architect/Lead Worked on IBM Mainframe, Unix and PC/LAN environments.
Has extensive experience in Gathering functional requirements from business users and System Design. Participated in number of large projects, developing end - user software using structured programming techniques and generator tools, working in-house and formal development methodologies.
Participated in various stages of Software Development Life Cycle (SDLC) such as Analysis, designing, developing, debugging, conversion, testing, implementation, and production support.
Strong communication skills, with the ability to work in demanding environment
Used Micro Focus cobol on Windows & Unix environments and use Micro Focus Animator tool to debug programs.
Used Enterprise Cobol, Vs-Cobol, and Cobol/390 extensively to write structured and efficient programs that deliver required business functionality.
Used CICS to develop pseudo conversational programs, develop BMF screens as per flow of the application functions.
Participated in impact analysis and submitted various forms and flow diagrams for new CICS transactions and Batch flows.
Experience working on the project built using the Agile Methodology. Involved in the estimate planning, design discussions and scrum meetings for the project.
Used JCL and JCL utilities like IDCAMS, IEBGENER, SYNCSORT, etc. to manipulate VSAM datasets, backup datasets, analyze data, load VSAM datasets, and extract data for test conditions. Created JCL to run job flows in various test environments. Prepared JCL for production environments.
Converted VSAM files to DB2 during application migration process
Written complex Insurance Policy Rerating Offset process using MF-Cobol on HP-Unix
Used SQL and DB2 STORED PROCEDURES to write complex queries to retrieve/manipulate data from various tables to match business functionality. Used Explain facility to check/tune the efficiency of the SQL calls
Extensively used XML parser and generator to convert interfaces between applications to exchange data
Used DLI calls in Cobol programs to extract segments data from IMS/DB
Used MVS, TSO/ISPF facilities to maneuver thru the system resources and tools.
Used FILE-AID to manipulate datasets and Vsam datasets.
Used EZTRIEVE and REXX to perform regular routines to prepare reports and output files.
Used CHANGEMAN/ENDEVOR/LIBRARIAN/SCLM to manage change control process for various applications.
Used PVCS to Prepare documentation about applications and changes made to them subsequently
Debugged batch programs with XPEDITOR/IBM Debug tool and Online CICS programs with INTERTEST. Some installations also have XPEDITOR for CICS that I also have used.
Used IBM Websphere MQ extensively to manage data flow from various application interfaces.
Used Db2 partition numbers to segregate data to different MQ’s, so that the started task jobs picks the data in timely and efficient manner by always hitting same partition to perform efficiently.
Used FTP/NDM to transfer files and reports to other Mainframe LPARS and FTP servers
Used Micro Focus Cobol on UNIX platform to write complex systems that take input from various interfaces, converting data from Oracle 5.0 database and Foxfro tables, and subsequently converting them to ISAM files and vice versa.
Implemented Accounting software in many districts and supervised installation and maintenance of UNIX systems
Lead a team of 8 members for 2 years in the District computer center at my age of 22.
Lead an off-shore team of 6 members for 9 months for client Sea-Land for my first project in mainframe world.
Lead many onsite projects and involved in Resource Planning, Planning project deliverables and schedules, Mentoring Junior staff, etc.
Involved in collecting Business requirements, interacting with Subject matter experts to decide the design, delivering data flow diagrams, Preparing technical specifications, etc.
I acted myself as Subject matter expert and architect for US State of South Carolina Unemployment application project for 3 years due to my prior experience with state of OH for 2 years.
Prepared Test Plans and Test cases to suite business functionality and all possible errors .
Ran the test plans and test cases thru Unit Test, Regression Test, User Acceptance testing stages.
Supported the applications during production and post-production stages
Used Ms-Office products to prepare documentation of applications, Project schedules, Multi-tasking activities, etc.

TECHNICAL SKILLS:

IBM Mainframe, HP-UX, VAX-11/750, Unipower-30, Sun Fire T2000, IBM PCs, Windows-NT Server/Workstation, Zenith Superlan, Pentium Class Machines, Windows NT/98/2003 Server/XP/VISTA, MVS, z/OS, VMS, UNIX / Sun Solaris 10, DOS/VSE
VS COBOL II, COBOL/390, MF-COBOL, CICS, SQL, JCL, EZTrieve, REXX, DB2 Stored Procedures/Subroutines, IBM Websphere MQ Series for z/OS v5.3, Agile SDLC, CICS Web Services, Unix Shell Scripts, C Language, Java 1.2, HTML, CA for DB2 (RC Query), CA View, BMC Utilities, SPUFI, QMF, TOAD for Oracle & DB2, DB2 Connect, CA-7, IBM VisualAge for COBOL, Shadow Direct Server, TSO/ISPF, PANVALET, Changeman, Librarian, Endevor, SCLM, PVCS, Xpediter, MF-Animator, INTERTEST, IBM Utilities, Abend-Aid, File-Aid, Infoman, VSAM, ISAM, FTP, NDM, ESP, Contol-M, Lotus Notes, MS-Office Suit, MS Visio 6.0, Cognos Impromptu, Cognos Powerplay
DB2 ver 11 NFM, IMS/DB, ORACLE 7.1, DBASE, MS-ACCESS, FOXPRO, Informix 7.31
INSURANCE, RISK MANAGEMENT, TRANSPORTATION, UN-EMPLOYMENT INSURANCE, TREASURY ACCOUTING, SHIPPING, FINANCE, BROKERAGE

PROFESSIONAL EXPERIENCE:

Confidential, Wilmington, DE

Programmer Analyst/Architect/Lead

Environment: IBM Mainframe, COBOL, DB2 v11, CICS, CICS Web services, JCL, VSAM, MQ, ISPF, Xpeditor, Changeman, JIRA

Responsibilities:

Design and Development of new business enhancements to the Automated Credit Evaluation application that deals with Credit applications for Loans
Enhancing existing application process and interfaces, as Credit bureau change rules and priorities set forth by government agencies.
Redesign COBOL, DB2 programs as process is redesigned. Performance tuning SQL queries.
Developed interface programs using CICS, Cobol, XML Parser and generator and MQ
Design/enhancing CICS screen
Working with Front end application teams to streamline interface and process
Developing test plans & test cases to thoroughly testing new changes

Environment: IBM Mainframe, COBOL, DB2 v11, CICS, JCL, CA-7, CA SYSVIEW, VSAM, XML, MQ, ISPF, Xpeditor, Endevor, Agile methodologies.

Confidential, Madison, WI

Programmer Analyst/Architect/Lead

Responsibilities:

Requirement Analysis, Technical design, Unit/Integration/Acceptance testing, mentoring junior teams and interaction with Client in completing FUSION/MINDI development projects.
Involved in writing technical specifications as per Fusnion/Mindi project business requirements.
Developed COBOL/DB2 programs to reflect technical specifications.
Used IBM debugger to make sure the flow of the programs touching all the test cases.
Developed Rexx/Eztrieve routines to handle enormous data
Written DB2 stored procedures to extract data and run business rules. Worked with online teams to provide data access thru db2 stored procedures and coordinated with online teams to exchange process specifications
Handling monthly jobs for data interfaces with various other outside agencies like Medical Michelle, Safelight auto glass, Xactware, etc.

Environment: IBM Mainframe, COBOL, DB2, CICS, JCL, VSAM, ISPF, IBM Debugger, Agile methodologies, Jira, MS Visio, SFTP, etc.

Confidential, Lorain, OH

Tech Lead

Responsibilities:

Interacting with business owners and user communities to understand the business objectives
Coordinating with Offshore team to complete technical specifications and test plans
Identifying mainframe COBOL/CICS/DB2/JCL components where the changes are required.
Modifying COBOL/DB2/Datacom programs
Maintaining VSAM datasets
Enhancing COBOL/Datacom programs to delink Confidential ’s credit card system

Environment: IBM Mainframe, COBOL, CICS, JCL, VSAM, XPEDITER, CA-Datacom.

Confidential, Columbia, SC

Mainframe Architect/Lead/Developer

Responsibilities:

Understanding new federal requirements from Business users, Examining existing Legacy applications to determine how the new requirements can be met
Identifying mainframe COBOL/CICS/DB2 components where the changes are needed.
Designed the Db2 database and coordinated with DBA to create tables and backup procedures.
Coding and Testing COBOL/CICS/DB2 programs
Coordinating with users to complete Test cases that can be used for unit testing, System Testing and User Acceptance testing.
Coordinating with test team to explain the batch flow and batch testing cycle process.
Claimants defined contributions, etc are managed using Omni suite of solutions
Developed COBOL/DB2 batch interfaces to Department of Labor Sun OS (UNIX) systems, to forward the un-employment trend and numbers and match un-employed individuals to Nation New Hires
Assisted in maintaining and matching management reports for Beneficiary Accuracy Management with Department of Labor.
Designed/Developed new COBOL/CICS/DB2/VSAM system to Refresh Issues and errors in UI benefit system (ABPS). The new CICS/COBOL programs and Maps are developed from scratch.

Technical Skills Utilized: VS-COBOL II, CICS, DB2 v8, SQL, DB2 Rc/Update, DB2 Detector, Spufi, BMC, TSO/ISPF, JCL, SYNCSORT, CHANGEMAN, Xpediter, Intertest, Sun Solaris UNIX, Shell scripts, VI editor.

Confidential, Chicago, IL

Mainframe Developer/Technical Manager w

Responsibilities:

Design & Development and support of the application.
Design and performance tuning, watching job executions and fixing problems and performance issues in them.
Interacting with CMS and clients to get their business requirements met in a timely manner.
Direct the team in Coding and Testing COBOL/DB2 programs.
Assisted the team to modify many CICS transactions and BMS on-line screens to match the new requirements.
Assisted the team in modified existing COBOL/CICS programs to exchange data and flow of the new process
Written Cobol procedures to exchange information using PDE, 837 & 835 EDI formats

Environment: IBM Mainframe, COBOL, DB2, JCL, CICS, TOAD for DB2, IBM Debug, Changeman, etc.

Confidential, Tampa, FL

Mainframe Developer

Responsibilities:

Coding COBOL/DB2 programs
Test plan & test case preparation, data preparation, testing, documenting changes etc

Environment: IBM Mainframe/COBOL/JCL/DB2/IBM Debug too/Changeman etc.

Confidential, Jefferson City, MO

Mainframe Developer

Responsibilities:

Responsible for Provider module of MMIS application.
Rewritten Cobol, Db2 programs to replace VSAM files
Analyzing Job streams to understand the flow of VSAM updates and replicate similar process to Update db2 tables.
Mapping VSAM files to DB2 tables and writing new COBOL, DB2 programs to migrate data from VSAM files to DB2 tables
Writing utilities to purge, Load, Unload, backup DB2 tables.

Environment: IBM Mainframe, zOS, JCL, COBOL, CICS, IBM-DB2, VSAM, Endevor etc.

Programmer Analyst

Confidential, Morristown, NJ

Responsibilities:

Analyzed functional requirements and written detailed design
Designed main control program that calls pickup & delivery programs
Designed Pickup program that looks into pickup profiles to pickup delays
Coded COBOL/DB2 control program that retrieves data from Origin & Destination programs and populates SDDRDD table, pickup table and Destination tables
Modified many CICS transactions and BMS on-line screens to match the new requirements
Modified existing COBOL/CICS programs to exchange data and follow the flow of the new process
Tuned sql queries using explain reports for maximum performance
Used MQ SERIES to transfer data between applications and Balance load on started tasks
Implemented Data propagation on other Lpars so the Front-end applications access
Perform Unit testing, Integration testing, System testing and UAT testing
Supported the application during post-production
Shared Production support 1 week in every 5 weeks

Technical Skills Utilized: VS-COBOL II, CICS, IBM Websphere MQ for z/OS v5.3, SQL, DB2 v8, IMS DB, DB2 Rc/Update, DB2 Detector, Strobe, Spufi, BMC, TSO/ISPF, Infoman, JCL, SYNCSORT, CHANGEMAN, Xpediter, Intertest.

Senior Programmer Analyst

Confidential, Columbus, OH

Responsibilities:

Analyzed functional requirements and written detailed design
Written Technical specifications
Made enhancements to Main Rerating control module on HP-Unix system
Developed new shell scripts for newly added functionality
Made enhancements to Main Rerating control module on Mainframe that’s running on VS-Cobol and Db2 database
Made enhancements to Cobol/Db2 programs to add new functionality
Written Cobol programs that extract data from various VSAM and Db2 to convert to flat files in oracle table structures to load to Oracle database
Made enhancements to Main Rating module
Developed new Rate Trace Logger program
Performed Proof of concept testing for Rate Trace Logger program that is memory resident
Analyzed functional requirements and written detailed design
Written Technical specifications
Developed Technical specifications from functional requirements
Developed new Offset program as per technical specifications using MF-Cobol on HP-Unix platform
Developed new Unix Shell scripts to handle connection to Oracle database and start the SQL Loader so the MF-Cobol programs can retrieve data from Oracle database
Used TOAD to navigate thru ORACLE db examining various properties
Made enhancements to Cobol/Db2 programs to add new functionality
Performed Unit testing and Integration testing with Online and offline interfaces

Technical Skills Utilized: Micro Focus-COBOL, Micro Focus-Animator, HP-UX, SQL, ORACLE, TOAD for Oracle, VS-COBOL, DB2, TSO, ISPF

Senior Programmer Analyst

Confidential, Columbus, OH

Responsibilities:

Primary role in correcting and maintaining Trade related programs, converted legacy data.
Maintenance of MQ series programs and enhancing them.
Working with MQ Admin to resolve version problems that lead the data to dead letter MQ.
Resolving the defects that are identified by users by either correcting the programs or correcting the data problems.
Incorporated new business rules in Trade adjustment programs and tested thru various stages to production deployment.
Wrote complex DB2 queries and tested them using QMF, SPUFI, and Advanced Query Tool (AQT).
Debugged Db2 stored procedures to resolve problems faced by online users
Compared Java code with Cobol Db2 stored procedures to find any interface issues
Have extensive knowledge on Change management control applications such as Changeman, Endevor & SCLM. Used SCLM extensively to store and manage programs and other components.
Implemented standards as per State rules and maintained program documents
Used IBM Visual Age for Cobol for rapid application development
Created Test Plans and Test Cases for Unit Testing & Integration testing.
Created JCL for different testing environments
Performed Integration, System & Regression testing
On On-Call support 24/7

Technical Skills Utilized: COBOL 370, SQL, DB2 v6, DB2 Stored Procedures (Subroutines), DB2 Platinum, Spufi, BMC, CICS, MQ Series, TSO/ISPF, JCL, SYNCSORT, SCLM, Xpediter, PVCS, MS Visio 6.0, Test Director and MS Access 7.0.

Senior Programmer Analyst

Confidential, Cranford, NJ

Responsibilities:

Designed & Developed XML Parser programs in Cobol to retrieve data from SQL Server database and format the output in a MQ layout
Enhanced COBOl/CICS MQ series programs to send data to various clients
Helped .NET programmers to write complex SQL queries.

Technical Skills Utilized: COBOL-II, CICS, INTERTEST, MQ Series, Spufi, Endeavor, XML, SQL, IMS DB/DC

Confidential

Programmer Analyst/Architect/Lead

Responsibilities:

Primarily responsible for Billing interface programs & Dials (Deliveries) interface programs
Analyzed business requirements and Technical specifications and enhanced many IBM Cobol/ Websphere MQ/IBM DB2 programs for three enterprise releases
Setup Parallel process to handle MQ’s with huge data based on Db2 partitions
Coded various Websphere MQ programs to eliminate job dependency
Setup Started tasks and modified Cobol programs to process data when available in the MQ queues
Integrated Retry logic into COBOL/DB2/ MQ programs to handle db2 deadlocks
Created Test Plans and Test Cases for Unit Testing & Integration testing.
Created JCL for different testing environments
Performed Integration, System & Regression testing
On Production support for entire UPS applications for 1 week in every 8 weeks

Technical Skills Utilized: VS-COBOL II, IBM Websphere MQ for z/OS v5.3, SQL, DB2 v7, DB2 Rc/Update, DB2 Detector, Spufi, TSO/ISPF, Infoman, ESP scheduler, JCL, SYNCSORT, CHANGEMAN, Xpediter

Senior Mainframe Programmer Analyst

Confidential, Edison, NJ

Responsibilities:

Primary role in Development of IBM DB2 Stored procedures using COBOL. Wrote 85% of stored procedures that are used in OJI application.
Developed IBM COBOL batch programs & IBM Db2 stored procedures for Trade Re-adjustment Allowance program.
Developed IBM Db2 stored procedures for wage related interfaces to front-end applications
Have extensive knowledge of IBM DB2 Stored procedures, Visual Basic and JAVA applications on various platforms and Architecture, where by debugged stored procedure problems on both back-end and front-end, with great ease and confidence.
Developed IBM Cobol batch programs for Initial Claims & Monetary Calculations
Wrote batch COBOL-370 programs based on program specifications.
Wrote complex DB2 queries and tested them using QMF, SPUFI, and Advanced Query Tool.
Have extensive knowledge on Change management control applications such as Changeman, Endevor & SCLM. Used SCLM extensively to store and manage programs and other components.
Implemented standards as per State rules and maintained program documents
Used IBM Visual Age for Cobol for rapid application development
Prepared program specifications and documented them.
Tested DB2 Stored procedures (Subroutines) using IBM DB2 Stored Procedure Builder and Xpeditor.
Created Test Plans and Test Cases for Unit Testing & Integration testing.
Created JCL for different testing environments
Performed Integration, System & Regression testing

Technical Skills Utilized: COBOL 370, SQL, DB2 v6, DB2 Stored Procedures (Subroutines), DB2 Platinum, Spufi, TSO/ISPF, JCL, SYNCSORT, IBM Visual Age for COBOL, SCLM, Xpediter, PVCS, Visio, Test Director and MS Access 7.0.