Summary
Overview
Work History
Education
Skills
Accomplishments
Phone
Activities
Projects
Certification
Languages
Timeline
Generic

JOSEPH A. CATALANO

Santa Ana

Summary

Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals. Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy.

Overview

1
1
Certification

Work History

  • Distributed platform experience on Windows and Unix machines running Oracle Solaris, IBM AIX, and HP-UX
  • Middleware and backend database administration of SQL Server and connection to DB2 through CICS Transaction Server and SAS
  • My CICS experience includes resource definition, supplied transactions, programming and web-enabling of legacy applications for e-commerce
  • Design and development of COBOL/DB2/CSP applications in operating environments z/OS, MVS, LAN; implementation in a client/server environment as COBOL with embedded SQL
  • Further Client-Server experience on Windows and Unix platforms; web page development with HTML, and web enabling of legacy applications through the CICS Transaction Server
  • Life-cycle support for computers with SAS and DB2 from Windows 10 or 11 clients with Office 365, and MS Edge.

  • Provided engineering technical support to users of Sybase (SAP ASE) connecting through TCP/IP or SNA to DB2, Oracle, MS SQL Server using Sybase middleware; server administration (DBA) including performance tuning and transaction processing for e-commerce using Java and the JDBC APIs
  • Backend interface to JDBC and Java
  • Also, using XML's transport capabilities, High availability (HA) installation and tailoring for 24x7 operations.

  • Design experience includes work with users, presentations, systems analysis and preparation of specifications, flow diagrams at both system and program level
  • Developed a COBOL-based hierarchical DBMS for interactive and batch retrieval (METROBASE)
  • Developed OLTP and batch COBOL applications for medical center, aerospace firm, big pharmaceutical company, and electric utilities
  • Also, developed data load, compression, extraction, conversion, and modeling systems for ambient control using real-time data from electric utilities.

  • My experience in data warehousing and mining includes RDBMS on z/OS, Unix, and Windows platforms aided by a strong academic background in statistics
  • Relational database experience with data load, compression followed by extraction from multiple platforms, conversion for web-enabled business intelligence or for uncovering relationships, trends and patterns in the CRM database
  • Experience with SAS applying multivariate time series using the ARIMA method to forecast business trends, where a solution includes data depiction followed by development of transfer functions or Statespace models to relate several input series to one or more response (prediction) series
  • Examples of these are stock price forecasts using selected indicators, crop commodity demand using climate variables, and worker health using industrial hygiene measures.

  • Statistical analysis experience with the SAS system using Base SAS, SAS/STAT, SAS/GRAPH, SAS/ETS, SAS VIYA for health and engineering applications at an electric utility, and other clients
  • Senior software engineer at Sybase, Inc
  • (now SAP), a major database and internet portal company
  • Tech Support engineer of Top-Tier customer accounts for quick resolution of issues on bugs, workarounds, upgrade, migration
  • Support of enterprises for backend database management and server interface (middleware) to DB2 and Oracle through TCP/IP, SNA, and CICS/VTAM.

  • Performed inspection, renovation, and testing of the inventory of SAS programs at Bristol-Myers Squibb and American Century Investments
  • Tools used were Base SAS, Hourglass, CompareX, and File-AID on MVS platforms
  • The Year 2000 renovation used techniques of interpretation, expansion, encoding; testing dates were 2-, 4-, 26-years into the future, verifying outputs with CompareX
  • Results were acknowledged as outstanding

  • Involved in maintenance of SAS codes and JCL PROCs at Bristol-Myers Squibb on IBM 9021 MVS sysplex
  • Planned, scheduled, and renovated the code inventory at BMS; interpretation and expansion were the primary techniques used along with several Y2K tools.

  • Active in life cycle maintenance at Hyundai Motors; responsibilities included scheduling, supervision, assessment, COBOL and CSP programming, coding and testing of software and relational tables
  • Also involved in new system development (vehicle distribution/inventory), Monroney labels, and production support of accounting software from GEAC.

Education

Bachelor of Science - Physics/Mathematics

Eastern Illinois Unviversity
Charleston, IL

Master of Science - Computer Science/Atmospheric Research

University of Missouri - Columbia
Columbia, MO

Skills

  • Excellent Communication
  • Multitasking
  • Dependable and Responsible
  • Attention to Detail
  • Friendly, Positive Attitude
  • Teamwork and Collaboration
  • Problem-Solving
  • Time Management

Accomplishments

  • Supervised team of 12 staff members as Technical Director of Aerocomp, Inc.
  • Collaborated with a team of engineers in the design of 20 electric transmission lines for a California Utility.
  • designed and developed a DBMS for environmental data by utilizing the MIMS (r) software to facilitate data handling and reporting

Phone

714-964-3353, 714-791-5624, 714-378-8621

Activities

Statistical analysis experience with the SAS system using Base SAS, SAS/STAT, SAS/GRAPH, SAS/ETS, SAS VIYA for health and engineering applications at an electric utility, and other clients. Senior software engineer at Sybase, Inc. (now SAP), a major database and internet portal company. Tech Support engineer of Top-Tier customer accounts for quick resolution of issues on bugs, workarounds, upgrade, migration. Support of enterprises for backend database management and server interface (middleware) to DB2 and Oracle through TCP/IP, SNA, and CICS/VTAM. My job also entailed advising DBA's for the resolution of cases, assisting in all aspects of product life cycle from deployment to migration, OLTP, optimization, backup/restore, server administration, client connectivity, monitoring, isolated bugs and develop workarounds. Self-managed, routinely handled multiple tasks; familiar with a variety of intranet tools and case management software., MM/DD/YY

Projects

Performed inspection, renovation, and testing of the inventory of SAS programs at Bristol-Myers Squibb and American Century Investments. Tools used were Base SAS, Hourglass, CompareX, and File-AID on MVS platforms. The Year 2000 renovation used techniques of interpretation, expansion, encoding; testing dates were 2-, 4-, 26-years into the future, verifying outputs with CompareX. Results were acknowledged as outstanding, MM/DD/YY

Certification

CCM certified by the American Meteorological Sociely.

Languages

Italian
Native or Bilingual
Spanish
Professional Working

Timeline

Bachelor of Science - Physics/Mathematics

Eastern Illinois Unviversity

Master of Science - Computer Science/Atmospheric Research

University of Missouri - Columbia
JOSEPH A. CATALANO