John
Braica
1300 Stuyvesant Avenue Union, New Jersey 07083
Telephone:
908.265.0249
Email: john@braica.com
Summary
Expertise
in multiplatform data integration / warehousing for OLAP reporting.
Skills include back-end system interfaces, data replication, and
replacement system, seeding of tables for conversion projects.
Advanced expertise in data modeling, data parsing, cleansing and
advanced data transformations.
Data
Structures
IBM
z/OS DB2 - system administration/applications use 25 years.
ORACLE
10G - under SUN SOLARIS/applications use 15 years.
Microsoft SQL
Server – desktop access with Open Database Connectivity (ODBC).
MySQL
IBM z/OS VSAM / ISAM / IMS
Operating
Systems
IBM
z/OS - 25 years experience.
Sun Solaris – 10 years
experience.
Linux - System Administration / home use.
Application
Tools
SAS
v9.1 – BASE and Business Intelligence Suite
SAS BASE – Over 25 years experience covering hundreds of applications and unique solutions. Proven skills developing log parsing procedures on click-stream data.
SAS
DATA INTERGRATION STUDIO
– Designed, constructed, scheduled and deployed over 500+ ETL
job flows / jobs against numerous operational data sources residing
on numerous diverse platforms. Designed and deployed numerous
processes to build Data Warehouse targets in the FACT / DIMENSION
star schema model.
SAS
INFORMATION PORTAL –
Built and deployed HTML reports, OLAP Cubes, stored procedures.
COGNOS
v8.4
FRAMEWORK MANAGER
REPORT STUDIO
CUBE
STUDIO
INFORMATICA
POWER BUILDER SUITE
Utilities
PARSING
Proven
expertise in LOG PARSING processes.
SORTS-Syncsort,
DF-SORT, CompareX.
FTP-under
all operating systems.
SCRITS-UNIX-Perl,
z/OS/REXX, CLIST, JCL, and PROCS.
EDITORS-ISPF,
EMACS, SPF/PC
SCHEDULERS-Autosys,
CRON and various z/OS Batch SCHEDULERS and output archives.
DISK-DFHSM
administration/applications use 25 years.
SECURITY-RACF
group level administration. Working knowledge of server FIREWALLS.
PROFESSIONAL
EXPERIENCE
SAS
Architect
Resort Condominiums Int. / Wyndham Worldwide Parsippany,
NJ
03/2005 to Present
Architect,
and lead developer on for 500+ SAS ETL processes which transformed
operational data into dependable, cleansed, analytic data. Lead
support for hundreds of scheduled “user written” SAS
processes for an International user community. These
complex ETL processes source operational transaction data,
transformed and load multiple targets worldwide. 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, confirmations, cancellations, membership
renewals, and various other customer service metrics and financial
feeds. Expertise in foreign currency conversions.
SAS
Programmer / Consultant / Analyst
Health Products Research, Inc.,
Whitehouse, NJ
01/2004 to 04/2004
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 Bayer partnership. Analyzed 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
prescriber populations. Delivered product market share reports using
internal calls, detail, and RX market data.
Architect
/ Consultant / Programmer / Analyst
Provident Bank – Jersey
City, NJ
07/2002 to 01/2003
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 Developer
AT&T Consumer Services –
Morristown / Basking Ridge, NJ
01/1998 to 08/2001
Customer
Sciences - Converted z/OS-SAS job streams to COBOL II. Converted
SASDBs 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
Schering Plough, Union, NJ
09/1997 to 01/1998
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, DB2 COBOL programming, FOCUS report writing, and various
ad-hoc SAS data cleansing utilities.
Consultant
Blue
Hill Data Services, Pearl River, NY
04/1997 to 08/1997
Added
enhancements to a very large DB2 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 DB2, and SAS programs to integrate new data sources
into the warehouse; performed all production control, DBA, DASD
management, backup and recovery tasks.
Staff
Consultant Computer Sciences Corp, Consulting and Systems
Integration, NY Metro office
10/1995 to 04/1997
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 DB2 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/1988 to 09/1995
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.
EDUCATION
English
/ Computer Science 110 credits Seton Hall University, South Orange,
NJ.