Resume

Sign in

Data Engineer

Location:
Bettendorf, Iowa, United States
Salary:
97k
Posted:
February 21, 2018

Contact this candidate

CARLOS J. RAMIREZ

A Candidate for: Sr. Programmer Analyst / Email: ac4kb3@r.postjobfree.com Mobile: 917-***-****

SUMMARY: Responsible, analytical and technically oriented systems professional with heavy expertise hands on using SAS in both UNIX and MAINFRAME with COBOL/SYNCSORT environments. 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 level of management and staff.

EXPERIENCE:

NBL/JOHN DEERE I T ANALYST Moline, IL 61265 08/2016 – 12/2017

•Monitoring and fixing SAS Jobs and JCL with invalid data coming into the Programs. They have been running for sometimes.

•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 center for UNSUCCESSFULLY JOBS RUNNING ON ALL CENTER and notify to Mainframe Storage team to clean up the Mainframe environment.

•Got familiar with environment related to Capacity Planning and Performance and shared information with member of the OFFSHORT team.

BOEING, Remote Data Engineer Renton, WA 98056 10/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 TERADATA/SQL/ORACLE/SAS/COBOL 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 environment.

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 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/2009 – 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 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 develops 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. Using Mainframe processed and transfers data to the UNIX box.

Extracted Data Warehouse from DB2 SQL ORACLE SAS COBOL MVS MF SYSTEM.

Evaluated data and produce 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. 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 Down load 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 1990 - 1997 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 1989 – 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 elected 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 member. Balanced workload for all production applications and Automated Disaster Recovery.

MERRILL LYNCH, NY & NJ Consultant 1988 - 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 1984 – 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 implement 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, 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, BAL, 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