Information Technology Sql Server

SUMMARY:

Information Technology Consultant

An adaptable professional who has been consistently praised as hard-working by my co-workers and management.

Over the course of my 45-year career, developed a skill set, including application design and development, diagnostic unit testing and user support.

Excelled in all project lead roles and team management.

Utilizing mature (3rd or 4th Generation) programming methodologies and languages and adhering to coding standards, procedures and techniques was able to participate in Project Planning sessions with Project Directors, Business Analysts and Team Members to analyze business requirements to outline the proposed IT Solution.

Overall, have consistently demonstrated problem-solving, leadership, and technical abilities in every aspect of my career.

Engaged in SDLC Development practices (Agile, Waterfall and DevOps).

Professional Environments:

Banking/Financial

Insurance

Manufacturing

Marketing

Medical

TECHNICAL SKILLS:

Software: IMS DB/DC, IMS DL-I, ANSI-COBOL, COBOL-2, MF-COBOL CICS, DB2, SQL, DOS, CPCS, DATA STUDIO, ORACLE DEVELOPER, PUDDY, LINUX, MICROSOFT ENTERPRISE SERVER, SHARPOINT,WEBFOCUS DEVELOPMENT (CSS AND INFO ASSISTANT), ACCESS, DBASE-3, MICROSOFT OFFICE, JIRA, AGILE, WAREHOUSE ACH PROCESSING, FTP, STORED PROCEDURES, SQLBASE, GUPTA SQLWINDOWS, SQLTALK, MICROSOFT SQL SERVER, ACCESS, SDLC, DEV-OPS, PAM360.

SPUFI, FILE-AID, EASYTRIEVE, PANVALET, ENDEAVER, IEBCOMPR, IDCAMS, IEBCOPY, IEBEDIT, IEBGENER, SYNC-SORT, IEBPTPCH, DFSRRC00, ENDEVOR CHANGE MANAGEMENT, OS/MVS, VM/CMS/ OS MVS, Z/0S, DOS/VSE, SDLC, CNTL-M, OS-JCl, CA7 and CNTL-M

EDUCATION:

PEIRCE JR. COLLEGE, 1974-1977 Associate Business Automation Management.

PHILADELPHIA COLLEGE TEXTILE AND SCIENCES, 1977-1980 Bachelor of Science in Computer Center Mgt.

Microsoft University SQL Server Marketing Certification

EXPERIENCE:

1/2023 – 06-2023

AFS – Senior Technical Programmer

For 2 years I was contracted to Modis, Inc and assigned to AFS as a Senior Technical Programmer. I was recruited by AFS to become an employee on January 5, 2023. All job responsibilities executed at AFS during employment by Modis, are also executed as an employee for AFS. See Modis on resume to obtain AFS responsibilities and endeavors.

Environment: MF-Cobol, SQL, SQL-Server, Oracle Developer, DB2, Putty, Mainframe, Linux, Cobol, Vsam. Endeavor

EXPERIENCE:

06/2020 – 12/2022

Modis, INC. – Software Engineer Consultant/Employee

Modis is a corporation that prides itself on hiring extremely capable consultants to work at their client sites. For 2 years I was assigned to AFS (Automated Financial Systems) as a Senior Technical Programmer.

AFS ‘focus was converting financial organizations to work within their software referred to as “VISION.” VISION was programmed to execute banks’ online and reporting systems. Banks converted from mainframe parallels to distributive system using Micro Focus Cobol, Vsam and DB2. All programs and libraries were transmitted to distributed systems using FTP and CLOUD processing. SQL Server, ORACLE, LINUX and PUDDY were used in the distributive systems. My responsibilities using DEVOPS as a SDLC development practice, were to follow instructions from JIRA management tool, to modify mainframe programs, test and promote to distributive system where parallel testing occurred. I was also responsible for converting customer bank data by creating transaction data to load SQL tables.

Endeavor used for mainframe source management.

I applied fixes to production source code or enhancements when required. Endeavor was used retrieve elements from production, make changes to elements, adding or updating elements into test environment for compiling and unit testing.

Using a BASE system for a new bank, copy all BASE JCL, PROGRAMS, UTILITIES, PARM LIBS, etc., to a mainframe PDS and modify all that applies to conform to the standards of the new bank.

During conversion of various banks, using JIRA requirements test modification on the mainframe and FTP programs to the Micro Focus Distributed system in LINUX for distributed unit testing. This would include any modifications made to JCL, Programs, utilities and parm libs converted from BASE system. Both unit, integrated and migration testing were used before programs moved to production environments.

Using Oracle Developer created SQL statements required to review updated tables updated in loading process.

Using subversion software, created databases, and tables set up to load data to be reviewed in ACCESS.

Attended all Jira meetings, reporting on progress for all responsibilities during defined requirements.

Report to project managers all updates verbally and using Jira Comments.

Worked with Business Analysts for all testing verification.

Participated in dry runs and dress rehearsals before final conversion of banks. This endeavor required a 2am start time which lasted 12 hours.

Lead Team in a major history conversion project. The conversion team had three members. My management responsibilities were to modify existing systems to conform to all new bank standards, modify programs by cloning modifications made for other banks, test JCL and verify program results. Set up step by step execution with other members’ projects and led them to final stages that not only created desired reports, but also zipped output to move to drive for FTP transmission. I also created job scripts for each member and worked with them to update script with their procedures. I updated Jira with conversion progress and reported progress to the Director of project.

Environment: MF-Cobol, SQL, SQL-Server, PAM360, Oracle Developer, DB2, Putty, Mainframe, Linux, Cobol, Vsam. Endeavor

EXPERIENCE:

3/2019 to 03/2020

Decision Research Corp– Software Engineer

DRC Is a major consulting company offering solutions to companies nationwide. DRC’s client, Homesite insurance, provides the platforms necessary for various insurance companies to manage and support their business. DRC provided the batch, SQL online development required to meet these objectives. In a SQL Server environment, utilizing MF-Cobol and Visual Basic online procedures, solutions were implemented to meet various state requirements. In a remote environment my responsibilities using a Waterfall SDLC approach for development and implementation, were as follows:

Develop or modify existing batch and online Cobol programs to meet proposed requirements.

When abend situations occurs and a fix must be applied to production source code or enhancements are required, Endeavor was used retrieve elements from production, make changes to elements, adding or updating elements into test environment for compiling and unit testing, and using packages to move into QA environment for testing. In emergency situation programs move back into a emergency prod environment.

Program, load and test all SQL Scripts required to add, update, or delete endorsements for state tables for prescribed companies within the state.

Test the Horizon Online System to make sure all endorsements were being applied and properly rated.

Utilize Release Engineering Tool to propagate development programs to the QA and UAT environments.

Support QA testers by researching and if necessary, apply modifications to fix any defects that were identified during testing. Unit integrated and migration testing was used before programs moved to production environments.

Attending all SCRUM, and Jira meetings, reporting on progress for all responsibilities during defined Sprints.

Report to project managers all updates verbally and using Jira Comments.

Environment: MF-Cobol, SQL, SQL-Server, Visual Basic, Endeavor

EXPERIENCE:

12/2018 – 03/2019 VANGUARD GROUP – Sr. Programmer Analysis Consultant DB2 Tester and Developer

As a Senior Consultant, DB2 tester and developer, my daily activities using Agile as a standard SDLC approach to project management, included, reviewing all production parallel test jobs in 5 regions to identify and correct all DB2 abends which occur in the programs developed in Cobol. Market data is populated in tables and accessed by marketing users. Any issues developed during evening testing must be corrected.

Responsible for the review of any jobs that have not been abended but are awaiting execution because Control-M scheduler. Responsible for the execution of these jobs which involves working in Control-M to review the Pre-Requirement executions and make corrections, when necessary, to get the jobs executed. Make the decision to force complete or run the jobs waiting.

Endeavor source code management used for modifications and additions to production environment.

Also, responsible for testing any job that has data issues in the DB2 tables. This includes running SPUFI and Insync to review the data in the tables that have issues. Each member of the team has work requests that contain data issues which require testing to determine the issue and make corrections.

Also have assignments that require modifications to Cobol DB2 programs am responsible for the modifications and testing of the changes.

Required to attend Scrum secessions giving a report on all my activities that have been updated in Jira.

Through Batch File Mapping created procedures to map files for FTP transmissions

Utilities and JCL executed under a ZOS environment.

Environment: DB2, Cobol, OSJCL, SPUFI, Control-M, Jira, SDLC, Z/OS, Endeavor

EXPERIENCE:

06/2000 - 06/2018

FEDERAL RESERVE BANK OF PHILADELPHIA Senior Technical Specialist

All Federal Reserve Systems in the country were using their own version of programs batch and online for Cash Letter System. This system processed paper checks through sorters which created Vsam files containing check transactions. The Vsam data was used to update IMS tables. The online system relied on the daily update of IMS tables to determine if a Cash Letter was complete and could be transmitted. We were tasked to rewrite and redesign the batch and online CLS system to allow all FRBs execute from same version of the programs. This involved modifying code to unit/ SQA test and production support on all converted systems. Unit integrated and migration testing was used before programs moved to production environments. . This system was written in Cobol, IMS, CICS and Vsam.

As a team member participated in the consolidation of all Federal Reserve Banks in the country. After conversion lead the effort to maintain the Cash Letter System for Federal Reserve Banks throughout the country. I was responsible for all modifications, testing and implementation of changes to the system. Modifications were made using Cobol, IMS and VSAM.

Through Batch File Mapping, created procedures to map files for FTP transmissions.

Aided in the conversion was the Check 21 systems which was a Paperless Entry Processing system for all Reserve Banks, which allowed check images to be processed. The Cash Letter System was modified to accept data into the CLS payment system using input from Check 21 system, FEDWIRE and ACH File processing (used to electronically send and receive funds in a batch environment), FTP transmissions were used to send data to servers controlled by various banks. I continued to maintain and lead all projects that were used to maintain the CLS system. After 8 years of support and maintenance of the IMS system, CLS was taken off the mainframe and rewritten on a distribution platform created by IBM. I worked with IBM as an advisor to help them understand the CLS system.

Lead the process to maintain the Treasury Control System written in IMS DB/DC and DB2. The maintenance was done remotely and in Philadelphia Federal Reserve office.

Participated in a lead role in a three-year multi-phase effort to design a process written in Cobol to warehouse Treasury Payment data from the mainframe IMS DBDC environment into tables accessed in Oracle. This data was used to feed the Post Payment Processing System. Millions of records were transmitted (FTP) into the Post Payment Process Servers. In design met with client community to identify what data would be selected and eliminated to create warehouse data in the tables designed in Oracle.

Participated in the Treasury disaster recovery procedures for all test and production systems. Converted DB 2 to recent processing versions; version 6 to 7, and 7 to 8. The conversions consisted of modifying and parallel test of all OSJCL job streams, and programs in test and production libraries.

I trained in SharePoint and created a SharePoint POC (Proof of Concept) duplicating a Cold Fusion online application which was the system used for the environment. This helped users build a confidence level with SharePoint that was becoming a standard in the environment.

Using SQL-SERVER’s report writer software (SSRS), lead effort to design and code all new report programs that could interface with a SharePoint online system. The data was converted from ACCESS to DB2 before utilized to populate the cash reports.

Transferred in 2013 to the PPS (Post Payment System). I was responsible for the creation of the Web Focus team and was responsible for the development of 200 reports in WEBFOCUS interfacing with Oracle Developer.

Since 2007 all utilities and Job Control have operated under a Z/OS environment.

Federal Reserve Web FOCUS responsibilities included:

Created and technically managed Web Focus team that would be responsible for the design, programming and implementation of all reports generated from Oracle tables. The SDLC approach to endeavors was a combination of DEVOPS, and Waterfall.

Assist with the gathering of report requirements for new reports and the conversion of reports already in mainframe production environment.

Converted 100 report programs written for Bank Fraud system that was originally written in Web Focus with an HTML menu into a more structured user friendly, maintainable system allowing the input of parameters to access database information to populate the Web Focus reports.

Design and developed over 200 programs in Using Info Assist, and CSS(Cascading Style Sheets). Programs included parameter driven menus, drilldowns, and detail summarization with minor and grand total generation.

Create SQL stored procedures to be accessed by Web Focus reports. Data was also accessed utilizing Web Focus data extraction methods.

Modified HTML code generated by Web Focus (Java Script), when necessary.

Participated in all Scrum meetings utilizing Jira and Agile and for all project status and monitoring.

Environment: Cobol, CICS, VSAM, IMS/DBDC, MID/MOD, DIF/DOF, SPF, ENDEAVOR, WebFOCUS, Info Assist, Oracle Developer, Report Caster, XML, OSJCL, FTP, SCRUM, JIRA, CPCS, SDLC,.

EXPERIENCE:

04/1999 to 06/2000 INDEPENDENCE BLUE CROSS – Sr. Programmer Analysis Consultant

Following SDLC Life Cycle Methodology, participated in Project Planning sessions with Project Managers, Business Analysts and Team Members to analyze business requirements, design, code, test and maintain implemented specifications.

Activity included production support and solution management, the maintenance of the programs written in IMS DB/DC and VSAM.

Environment: Cobol, IMS/DBDC, TSO-SPF, OSJCL, MID/MOD, DIF/DOF, VSAM, MS Office, Endeavor

EXPERIENCE:

05/1994 – 03/1999 SMITH KLINE – Lead Consultant

In a Cobol IMS DBDC environment managed a team responsible to extract marketing data used for various product launches. Data was extracted using SQL and loaded to files used for marketing research.

Participated in the design of DB2 tables in preparation of an IMS to DB2 conversion.

Participated in the conversion of all Cobol IMS programs to DB2.

Aided in the design of the ARTIC marketing system written in Cobol DB2

Endeavor Source code management used for all source activity.

Environment: Cobol, CICS, VSAM, IMS/DBDC, MID/MOD, DIF/DOF, SPF, DB2, SPUFI, SQL and MS Office, OSJCL,

TSO-SPF. ENDEAVOR

EXPERIENCE:

01/1991 - 05/1994 INDEPENDENCE BLUE CROSS Lead System Analysis

Lead a 5-member team responsible for the development, maintenance, QA testing, and production support of the OPL (Other Party Liability system.) The OPL system was written in Cobol IMS and VSAM.

Responsible for the management, development and maintenance, and QA testing of the Drug Information system. The drug system managed the claim transactions for all drug purchases. Research data for claim processing was extracted from IMS tables using SPUFI and IMS utilities to unload data. SDLC Waterfall approach was used in all aspects of development, testing and integration of programs.

When abend situations occurs and a fix must be applied to production source code or enhancements are required, Endeavor was used retrieve elements from production, make changes to elements, adding or updating elements into test environment for compiling and unit testing, and using packages to move into QA environment for testing. In emergency situation programs move back into a emergency prod environment.

Environment: COBOL, VSAM, IMS/DBDC, MID/MOD, DIF/DOF, TSO/SPF, OSJCL, MS Office, TSO-SPF ENDEAVOR

EXPERIENCE:

03/1989 – 12/1989 CESARS HOTEL CASINO Systems Manager/Consultant

Lead Consultant joined the team responsible for the development and implementation of Emperors Club Slot Card System. The team was responsible for the development, testing and implementation of the new system

Environment: COBOL CICS, VSAM, DOS.

EXPERIENCE:

01/1990 – 12/1990 Adaptive Strategies Director of Software Advertisement and Implementation

I was responsible for leading the direction for the sales, demonstration, and implementation of Gupta SQL Windows.

I was responsible for creating PowerPoint presentations as a sales tool to educate clients on the capabilities of SQL Windows.

I was responsible for directing the installation of the hardware and software on client sites for those who purchased the product.

Environment: GUPTA SQL WINDOWS, Word, PowerPoint

REFERENCES: Available upon request.

Contact this candidate