John Braica
1300 Stuyvesant Avenue Union, New Jersey 07083
Cell: 908.577.1655
Email: john@braica.com

COMPUTER SKILLS

Application Languages / Tools

  •  z/OS COBOL 22 years experience.
  • IBI FOCUS on z/OS, NT, WEBFOCUS, system administration and applications use, 22 years experience.
  • SAS v9.3 Enterprise, BASE SAS, EG4, and Intergration Studio, SAS PORTAL, Business Intelligence expertise. Over 25 years total SAS experience under z/OS, Solaris, and Windows. Skills include MACRO use, ODS reporting, and BI application development.   

Data Structures

  •  z/OS DB2 System administration and applications use 22 years.
  • ORACLE under HP-UX applications use.
  • MS SQL 2000 Server/Desktop with Open Database Connectivity (ODBC).
  • ANSI SQL, MySQL.
  • Microsoft ACCESS.
  • SAS-DB.
  • VSAM / ISAM / IDMS.

Operating Systems

Utilities and other skills

  • Syncsort, DF-SORT, CompareX.
  • FTP, under all operating systems.
  • UNIX-Perl, z/OS/REXX, CLIST, JCL, and PROCS.
  • ISPF, EMACS, SPF/PC editors.
  • UNIX-CRON and various z/OS Batch SCHEDULERS and output archives.
  • DFHSM System administration and applications use 17 years.
  • RACF group level administration working knowledge of server FIREWALLS.
  • PHP http server side language for accessing SQL data via the web.
  • Microsoft Office Suite.
  • Expertise in multi-platform data warehousing, data cleansing and reporting.
  • Advanced expertise in data modeling, date de-normalization and normalization.
  • Skills include use of BASE SAS, PROC MEANS, PROC FREQ, PROC RANK, and PROC UNIVARIATE and ODS for statistical analysis, market segmentation and reporting directly into EXCEL or HTML applications.
  • Skills include accounting back-end system interfaces, data replication, and replacement system seeding of tables for conversion projects.  McCormack & Dodge Fixed asset, GL, and payables analysis and reporting expertise.   

 

PROFESSIONAL EXPERIENCE

SAS Architect – Business Intelligence 
Resort Condominiums International,  a unit of Wyndham World Wide, Parsippany, NJ
03/05– Present

  • Working onsite for three months at RCI’s Indianapolis, Indiana data center, in a development role, designed,  built and delivered multiple SAS ETL Studio SAS jobs.  These complex ETL processes sourced RCI’s operational systems transactional data, transformed and loaded this information into a MS SQL business intelligence data mart located in Kettering, UK.  Sources of data included Z/OS/DB2 tables, AS400/DB2 and SAS Enterprise data warehouse transactional sources.  Among the near-real time business processes captured:  customer bookings, conformations, cancellations, membership renewals, and various other customer service metrics and financials. Built numerous star schema data warehouse tables using the Ralph Kimbel methodology. Functioned as subject matter expert for all aspects of the SAS BI tools, and RCI operationa data stores.         

SAS Programmer / Consultant /  Analyst via Smith Hanley Consulting
Health Products Research, Inc., Whitehouse, NJ
01/04– 4/04

  • Using UNIX/ Base SAS and SAS MACRO features, wrote numerous programs to streamline the process of importing SAS reports into POWERPOINT presentations.  End-client was a major international drug manufacture analyzing internal and RX market data for a product launch.  Utilizing SAS ODS features generated HTML, and EXCEL ready reports for the client’s use.
  • Wrote SAS programs to analyze sales force productivity for a major international drug manufacturer. Heavy statistical analysis using PROC FREQ and PROC UNIVARIATE to create deciles and segments on RX perscriber populations. Delivered product market share reports using internal calls, detail, and RX market data.         

Architect / Consultant / Programmer / Analyst
Provident Bank – Jersey City, NJ
07/02 – 01/03

  • Corporate Marketing – Using SAS Enterprise, and base SAS v8 software, and Microsoft SQL SERVER 2000 with Open Database Connectivity (ODBC), designed Retail Customer Data Warehouse in support of a customer relationship management initiative.  Implemented retail customer PROFITABILITY / CHANNEL USAGE segmentation models.  Created numerous SAS programs accessing AS400/BD2 SQL TABLES to interface with ALLTEL HORIZON BANK SYSTEM, HARLAND MAXSELL, PRODUCT-4 CRM systems.  Delivered comprehensive attrition, escheatment and diminishment analysis to senior decision makers.     

System Architect / Lead Programmer via Genusys Consulting
AT&T Consumer Services – Morristown / Basking Ridge, NJ
01/98 – 08/01

  • Customer Sciences - Converted Z/OS-SAS job streams to COBOL II. Converted SAS-DBs into Z/OS flat-files. Converted 3000 lines of "unstructured" SAS programming logic to a less complex and efficient structured COBOL II environment. Created production batch processes in COBOL II to cleanse, warehouse, and summarize over 5,000 very large UNIX piped datasets on the Z/OS platform. Tasks include Z/OS platform system design, programming, testing and ad-hoc reporting of AT&T customer survey data.
  • Operational Results Reporting Group - functioning as lead architect and programmer on a large data warehouse. This application will support AT&T marketing efforts in the long distance calling marketplace. Data sources include telephone switch statistics from a Lucent Center-Vue 800 calling system. Tasks include Z/OS platform system design, programming, and testing. This application requires creating and testing numerous SAS, COBOL AND FOCUS Z/OS batch procedures / programs to collect via FTP, files from over 12 UNIX systems across the AT&T network. Developing programs to identify, reformat, cleanse and summarize large amounts of data that will be loaded into a three-tier data warehouse for reporting

Consultant via RHO Consulting Services
Schering Plough, Union, NJ
 09/97 to 01/98

  • Supported the development of a dual platform (Z/OS and UNIX) data warehouse. This warehouse supports  targeted marketing of prescription pharmaceuticals to doctors, hospitals, and asthma sufferers. The warehouse is sourced using medical claims data from over 40 leading HMOs and benefit plans across the U.S. My involvement includes analysis, DB-2 COBOL programming, FOCUS report writing, and various ad-hoc SAS data cleansing utilities.

 

Consultant

Blue Hill Data Services, Pearl River, NY

04/97 to 08/97

·         Added needed enhancements to a large DB-2 data warehouse. The end use client was America Online. This mission critical data repository facilitated all marketing, promotions, and customer retention efforts. Wrote batch COBOL II DB-2, and SAS programs to integrate new data sources into the warehouse; performed all production control, DBA, DASD management, backup and recovery tasks. Implemented Blue Hill's web presence: http://www.bluehilldata.com.

Staff Consultant
Computer Sciences Corp, Consulting and Systems Integration, NY Metro office

10/95 to 04/97

  • Consolidated Edison NYC- Worked nine months at the client site in NYC programming interfaces to allow a migration of a large financial data warehouse from Z/OS-DB2 to NT-SQL Server. This project involved writing and testing over 100 DB-2 COBOL II programs with utilities that create flat-files that were downloaded and processed as input transactions on a NT-SQL publishing server platform.
  • Bristol Myers Squibb NYC- As a member of a fifty-person project team aided construction of a very large data mart using HP-UNIX/ORACLE 7 relational database technology. Concentrating on the data consolidation of customer and product master tables. Supported data team with through analysis and coding changes that produced design enhancements.
  • Mead Johnson, a division of Bristol Myers Squibb - On site for 5 months at this nutritional formula manufacturer in Evansville Indiana. Performed analysis of sales data in support of a Business Area Architecture engagement. Wrote mainframe ad-hoc queries against Z/OS-DB2 and various other data sources in preparation of the BAA conceptual data design document and data metrics.

Manager – Market Databases
Sea-Land Service – Edison / Port Elizabeth / Liberty Corner, NJ
03/88 to 09/95

·        Designed, implemented, and supported 4GL databases for world trade analysis. Sources of data included US Census foreign trade tapes, Journal of Commerce Port Import/Export reporting tapes (PIERS), DRI-McGraw Hill and internal corporate databases. These accomplishments provided quality information for senior decision-makers. Databases provided detailed commodity trade analyses, which aided the corporation's expansion into Soviet, South American, and intra-Europe transportation markets. Provided market data and analysis that led to the development and ongoing success of the Global Accounts Group.

·        Supported fourth generation languages for an international user community utilizing FOCUS and SAS. Heavy database design and development work. Designed, wrote, and maintained FOCUS code, production batch jobs, log procs, and clists for the corporation's decision support systems. Accessed data from all major in-house systems for user reporting.

 

Info-Center Programmer

AIG Data Center 

03/83 to 03/88

·        As a one-man project team migrated over 25 PC/FOCUS sites across the US to mainframe FOCUS in eight weeks. Rewrote FOCUS code and transferred data records to run under Z/OS/TSO. This system recorded over $70 million in receivable accounts to AIG Recovery Inc. Project was completed without travel. Cut over to Z/OS Host was accomplished over three weekends with no interruption in processing to AIG Recovery field offices. Designed and wrote recovery billing system and management reports.

 

EDUCATION

English / Computer Science 110 credits
Seton Hall University, South Orange, NJ.