Carlos J. Ramirez

Cleveland, Ohio *****

Email: ad4bm4@r.postjobfree.com Cell: 917-***-**** L: https://www.linkedin.com/pub/carlos-j-ramirez/2b/154/28a

SUMMARY: Responsible, analytical, and technically oriented systems professional (Fluent in English and Spanish) with heavy expertise hands on using Mainframe/JCL-Informatica/Oracle/DB2 in both UNIX and z/OS MVS MAINFRAME with SAS, COBOL / SYNCSORT / IBM UTILITIES environments and EDI Protocols, File Transfer Protocols.

Over 10 years of PC SAS BASE experience and SAS Enterprise Miner Guide including SAS Data Studio. 8+ years of current experience within the Financial Services/Banking industry.

• Extensive experience in data architecture, migration management, data structures, and platforms Mobility applications/systems SME, data integrity, data security with CITIGROUP.

• Particularly skilled in structured flowcharting and programming. Creative problem solver and trouble shooter, resourceful and consistent accustomed to a fast-paced environment and multiple projects, able to work under pressure and meet deadlines.

• Diplomatic negotiator and dealing effectively with all levels of management and staff.

EXPERIENCE:

TD Bank, N.A/FIS Sr. Mainframe Developer Remote, Ohio 07/2022 – 12/2022

Work Remote as a Sr. Associates in TD Software Mainframe Developer – Team to assist TD employees. Primary skills in COBOL, DB2, JCL, EZTRIVE, SAS, VSAM, PROC, PARM, PARMNDM, ENDEAVOR, CA7, TSO and SYNCSORT Environment. Design, Code, test and maintain applications and assist Quality Assurance teams in testing applications. Participate in On-call rotation to resolve applications failures. Assist in research to resolve issues (on-call issues, performance issues, etc.) and coordinate with respective support teams to resolve software and hardware issues. Approve technical specification documents for new and modified code. Utilize source control software to maintain integrity of production software, including prior versions of code. Follow defined Software Development Life Cycle (SDLC) and Change Control processes. TMS (Tape Management System which is used for all backup & recovery. IBM RMM is used for conversion to the latter. Constantly get the job done and hands on experience.

KEY Bank, N.A/Genesis 10 Sr. Mainframe Developer Brooklyn, Ohio 11/2021 - 03/25/2022

Work Remote as a Sr. Associates in KEY TIC SLT 2021 -2022 Global Trust Platform Delivery Phase for Software Mainframe Developer – Team to assist KEY employees. Primary skills are Cobol (Mainframe) and helping in the mainframe Cobol programming world for a long time (overall skills constantly get the job done and hands on experience). Also, provide production support and on-going maintenance and enhancement projects for in depth knowledge/SME with COBOL include MVS MAINFRAME/ Z/OS JCL, VSAM, PROC, PARM, PARMNDM, ENDEAVOR, CA7, TSO and SYNCSORT Environment.

JPMorgan Chase/ACS Groups Sr. Mainframe Developer Columbus, OH 08/2021 09/2021 Designs, Develops and Tests Mainframe (COBOL, CICS, DB2) Code in the support and implementation of US

Mainframe Developer – Liquidity systems and projects joined the team and shared information with member of the OFFSHORE team to assist JPMC employees. Primary skills are Cobol (Mainframe) and Informatica - Hadoop is Responsible for ensuring code has a high degree of quality and implements with zero defects. Also, Will act as support backup for handling production calls related to applications in depth knowledge/SME with COBOL include MVS MAINFRAME/ Z/OS JCL, VSAM, PROC, PARM, PARMNDM, ENDEAVOR, CA7, TSO and SYNCSORT Environment.

PNC BANK, N.A/INDOTRONIX Sr. Mainframe Developer Strongsville, OH 07/2020 – 02/2021

Work Remote as a PNC backup performance Software Development Engineer designs

Mainframe Developer – ETL Informatica or Hadoop just a plus. I am a senior experienced individual joined their team and shared information with member of the OFFSHORE team to assist PNC employees. Primary skills are Cobol (Mainframe) and Informatica - Hadoop is a HUGE I am helping in extensive experience in mainframe world and has been in the Cobol programming world for a long time (over all skills and hands on experience). Also, provide production support and on-going maintenance and enhancement projects for in depth knowledge/SME with Cobol include MVS MAINFRAME/ Z/OS JCL, VSAM, PROC, PARM, PARMNDM, ENDEAVOR, CA7, TSO and SYNCSORT Environment.

COGNIZANT / KEYBANK Sr. Associate Brooklyn, Ohio 44144 07/2018 – 03/2019

Work ONSHORE as a KEYBANK backup performance and shared information with member of the OFFSHORE team to assist KEYBANK employees of Lending, Digital and other areas. Assisting the ADVANCE LENDING SYSTEM(ALS), SLS and others. Also, provide production support and on-going maintenance and enhancement projects for existing systems. Using MVS MAINFRAME/ Z/OS processed and monitored jobs running in the system on TSO / SAS / COBOL / JCL / VSAM / IBM UTILITIES and SYNCSORT Environment.

NLB / COGNIZANT IT ANALYST Moline, IL 61265 08/2017 – 12/2017

Monitoring and fixing SAS Jobs and JCL with invalid data coming into the Programs. They have been running for some time. Resolved issues with Jobs and programs with false alert warnings because volumes no longer in Production files. Also modify SAS programs to change reports heading. Created and automate a process in SAS to capture UNIX data from all Data Center & send email to owners of FTP jobs running on the systems. Requested by the users. This implementation of the FTP jobs is in Production and scheduled to be run on the first quarter of January 2018. Monitor all Data centers for UNSUCCESSFULLY JOBS RUNNING ON ALL DATA CENTER and notify Mainframe Storage team to clean up the Mainframe/ Z/OS environment. Got familiar with environment related to Capacity Planning and Performance and shared information with members of the OFFSHORE team.

SEDGEBROOK Programmer Lincolnshire, IL 60069 12/2016 – 08/2017

FCWS INC./SEDGEBROOK Consultant Des Plaines, IL 60016 08/2016 – 12/2016

Full Time position for both Corporation to automate Programming and Implementation of A/R Reports developed technologies in STRUCTURED COBOL PROGRAMING environment.

COMPUTECH/BOEING, Remote Data Engineer Renton, WA 98056 07/2015 – 02/2016

Production and Test Support for installation Systems. Working with IT department to evaluate, manipulate and determine valuation of the move off mainframe to AIX system from existing MAINFRAMES/ Z/OS TERADATA/SQL/ORACLE/SAS/COBOL Micro Focus Development and SYNCSORT Environment. Create and maintain scripting conversion programs and SQL queries for Ad-hoc report requests, ongoing maintenance, and issue debugging. Pre-Compile, Compile and Set environment for the programs for testing. Transfer Data to other environments.

ALLSTATE / SYNTEL INC. NORTHBROOK, IL PROJECT LEADER 01/2015 – 05/2015

Production and Test Support for installation Systems. Working with IT department to evaluate, manipulate and determine valuation of the future UNIX/LINUX system from existing SOLARIS UNIX /SQL/ORACLE/SAS Environment. Install correct versions of 3rd party software online for SAS 9.3.

EXPRESS SCRIPT/IBM/GLOBALNEST Franklyn Lakes, NJ Consultant 05/2013 – 03/2014

Production Support for all Claims Systems. Working with IT department to extract data, manipulate and determine valuation Claims for existing projects on TERADATA, PC SAS, and MAINFRAME/ Z/OS UNIX COBOL/SQL/DB2/SAS Environment. Assisting Mangers to Research, clean data and fix errors on all require Claims System for all DHL Department.

AIG / ALICO WILMINGTON, DELAWARE Consultant 09/2008 – 07/2010

Develop markets in Europe, Asia, the Middle East, Africa, and Latin America. ALICO has regional headquarters in Tokyo, Paris, Athens, Dubai, and Santiago, Chile.

Working with IT department to extract data, manipulate and determine valuation reconciliation for existing projects on PC SAS, AS/400 MAINFRAME/ Z/OS UNIX Cobol/SQL/DB2/SAS Base, Enterprise Miner environment.

Assisting vendors to create data dictionary for the purpose of creation Prophet Models insurance policy for all Actuary Department.

Utilized Vendors Product/Securities Processing, Portfolio Market, Reference Data and Integrated Monetary Processing and Control System (IMPACS).

CITIGROUP O’FALLON, MISSOURI Sr. Programmer/Analyst 01/01 – 08/08

Primary responsibilities with Citibank are to develop and maintains productive working relationships with key internal clients, vendors and other IS resources.

Support existing system processes and maintain data integrity of the systems. Also, provide production support and on-going maintenance and enhancement projects for existing systems. Automated Pre-Process batch job to pull information from Mainframe to Unix Box to move all kind of files using NDM or FTP transmission job to create daily schemas Sourcing Star, Fact/Cube and Atomic build process for input to build the Daily Data Mart. Also, create data dictionary showing all variable names, DW Table, DW Column Name, Business Transformation, Flat file, Join etc. Extracted Data Warehouse from DB2 SQL ORACLE SAS COBOL MVS MF SYSTEM.

Evaluated data and produced Ad Hoc Matrix reports to do audits for direct marketing and database marketing systems.

Selected Accomplishments:

• CBNA BI Specific Activities

• SIR/STR/EMR Process and attend Weekly Implementation Meeting

• TNC Cycle/Schedule and Jobs for Daily Weekly and Monthly Cycles/Schedule

• AFS TNC Current process and jobs

• RELATIONAL DOWNLOAD FILES SI/CL to AFS Conversion Project

• ACAPS Trim Process and associated Jobs

• Recreate ACAPS Monthly Report sent to LIC and ACAPS Team from Missouri

• Understanding of feeds to TNC and DW/CDM

• ACAPS Daily, Full Weekly, Monthly, CUSTOM CRIS CAS DLS GPS CACS

• Location of all SAS code to review Outstanding Issues, Overview of new DW

• TNC COB, Data Masking Ongoing and Review of Data Model……

Chase Manhattan Bank New York, NY Consultant 11/99 - 12/00

Extracted Data Warehouse from DB2, SQL, ORACLE, SAS, COBOL MVS Mainframe(Z/OS). System to evaluate Data and produce Ad Hoc Matrix reports to do audits for various PRE-SCREEN and ITA direct marketing and database marketing projects.

Prodigy Communications Corp., Westchester, NY Consultant 11/98 - 10/99

Creating Ad Hoc reporting required by Company using SAS Mainframe and SAS DB2 SUBSYSTEM. Also, developed production system on Mainframe and then Download all Spreadsheet Report to the LAN to be use in Microsoft Excel format. Converted all Report to run on Prodigy Central (WEBSITE) for Viewing by vendors.

Prudential Insurance Roseland, NJ Consultant 06/97 - 10/98

Assisting Coopers & Lybrand in Health Insurance Application to do Audit for Prudential insurance. Creating AD HOC report required by Coopers & Lybrand using COBOL/CICS/DB2/SAS MAINFRAME & PC. AF / SCL Processing previous old years data.

Citicorp Long Island City, NY Consultant 02/96 - 05/97

Creating and maintaining Database, SAS and COBOL programs for PHOTOCARD PENETRATION, BALCON and Aims System Projects. DOWNLOAD and RESTORE FILES using FDR and IBM Utilities. Transmitting reports to users to keep track of all credit card accounts in X/L Software. Also, automate and create system for programmer’s users to evaluate Mainframe Data VS Data Warehouse (CAM).

Medco Containment Services, Woodcliff Lake, NJ Consultant 01/95 - 01/96

Wrote and maintained SAS, EZTRIVE & COBOL Program for Pharmaceutical company. Process claims filled at the pharmacy or mail-order to send report required by clients / or insurance companies for which they manage the distribution of prescribed drugs.

LCS Direct Marketing Services, Clifton, NJ Consultant 09/93 - 01/95

Worked with all Canadian Telephone companies. Wrote SAS and COBOL programs for all these telephone Companies. Also teach MVS SYSTEMS.

Coopers & Lybrand, New York, NY. Consultant 01/93 - 08/93 Wrote Cobol/CICS/DB2/SAS programs. Processed claims submission & mortgages customer information.

Metropolitan Life Insurance, New York, NY Sr. Systems Engineer 05/1989 – 12/1992

Worked as a technical specialist on non-technical team to design and automate. Disaster Recovery Program for company. Evaluated software packages and recommended package selected for Company. Installed and managed BEST/1 (MVS, CICS & NETWORK Modeling Packages at 5 Data Centers).

Selected Accomplishments:

Developed, simulated, evaluated, and maintained multiple recovery scenarios using BEST/1. Modeling Packages to determine optimal recovery strategy. Documented all steps necessary to utilize BEST/1 Product and trained other staff members. Balanced workload for all production applications and Automated Disaster Recovery.

MERRILL LYNCH, NY & NJ Consultant 01/1988 – 04/1989

•Created capacity planning to report resource usage in system to senior management.

•Converted COBOL program to SAS. Installed PC and software packages

DEAN WITTER REYNOLDS; INC. NYC Capacity Planning Analyst 02/1984 – 12/1987 Responsible for installing capacity planning packages to generate performance data for Senior Management review. Assisted technical support with troubleshooting and verified production jobs for Test Assurance Committee, using BAL. Reported to V.P. Technical Services.

Selected Accomplishments:

•Set up new release of SAS color graphics and SAS/FSP

•Installed new release of Epilog and created Epilog reports.

•Installed new release of OMEGAMON; created new screens.

•Managed project to merge two major brokerage systems.

•Installed SMF Dumps. Collected SMF and RMF data from six different systems.

•Selected data for creation of own database to develop and produce automatically generate usage report for Management review of resources (CPU utilization, I/O devices, batch production job on-line, Response Time, Testing and TSO) - accomplished using SAS and MERRILL/MXG.

Performed feasibility study and implemented Capacity Planning Reporting Systems.

EDUCATION: HS Diploma / A.A.S. Data Processing BMCC, / Diploma, Computer Science I C I, NYC

Technical Skills:

Languages: COBOL, SAS.

Databases: SQL, ORACLE, DB2.

O/S: MVS IBM 370/3033/308X/309X/AIX.

Tools: MAINFRAME / UNIX.

HARDWARE: IBM 370, 3033, 308X, 309X, AIX/6000, AS/400, PC MS/DOS/AST/WINDOWS.

SOFTWARE: PC SAS, MACROS, SAS COLOR GRAPHICS, TWS / REXX / CLIST, DB2, ACCESS, CITRIX, ORACLE, ETL, PL/SQL-UNIX, CLIENT/SERVER, COGNOS, OS/MVS, VM/CMS, CICS, OS/JCL, UTILITIES, VSAM/IDCAMS, FTP/NDM, FILEAID, FDR, SYNCSORT, TSO/ISPF, ROSCOE, COBOL, ENDEAVOR on the Mainframe, BAL, SAR, BEST/1(MVS, CICS, NETWORK) MERRILL/MXG, EPILOG, OMEGAMON, RMF, SMF, HSM, SMS, MS VISIO 2007, SHAREPOINT.

PROFESSIONAL TRAINING:

Specialized IBM courses in Structured Computer Programming, Command level CICS, Capacity Planning (3) BGS SYSTEMS Courses in MVS, CICS and NETWORK, SAS INSTITUTE Courses, PL/SQL-UNIX

Contact this candidate