Peningo Systems, Inc.

Resume of Candidate: PEN176








Netezza Consultant - NK






SUMMARY:  Over 35 years of experience in the computer and engineering industry, with a strong background in relational database management
systems, applications programming, some database administration, systems analysis and communications/networking. Employment history includes
experience in a supervisory capacity, managing up to 10 employees.


HIGHLIGHTS: Excellent background in relational database management systems; including PL/SQL, Pro*C, Data Warehousing concepts (STAR Schema);
Conceptual and Physical Modeling (ERWIN); Partitioning; ETL (Informatica); nzsql (Netezza); tuning SQL statements and full life cycle development.
Background as a communications engineer selecting hardware and software for particular customer requirements and developing configurations.


Languages
ORACLE 10g, 9i, 8i, 8.0, 7.3
DB2
Informatica 8.1,7.1,9.1
Netezza
ERWIN
Actuate
PL/SQL
TOAD
SQL*Loader
PRO*C
Visio
Javascript
MS Access 2003/2002/2000/97
Visual BASIC 6.0, 5.0, 4.0, 3.0
VB Script
SQL*Forms 6.0, 4.5, 3.0, 2.3
Oracle Discoverer
SQL*Reports 5.0, 4.0. 3.0
ORACLE Financials        
Microsoft/UNIX C, Shell scripting (Bourne, Korn)
FORTRAN
LISP/PROLOG        
Pascal        
Web Developer using ASP
Powerbuilder (Ver. 3.0)
DBASE III/IV
Foxpro
Paradox

Operating Systems                        
HP UNIX, AIX, SCO
SOLARIS        
VMS/COBOL        
MVS
Banyan VINES
NOS/VE        
OS/2 (2.1 & 3.0)
MS DOS

Networks
TCP/IP;X.25;CSMA/CD                                                
EDI 850/840/843/810/997                                                        
                                                            

HARDWARE/OPERATING SYSTEMS EXPERIENCE:        

HP RP8400/9000/800
IBM AIX, 370/3033
VAX 4000, 6310
VAX 11/780, 785
MicroVax 3100
Sun SPARC 1000
CYBER 720
Altos EISA 486/Unix
NRC/Unix
Windows 2000, XP, Me, 98, 95


FUNCTIONAL AREAS:   Managed infrastructure changes. Structured programming, database administration, Tuning Oracle SQL,  military standards, user
interfaces, functional specs, program testing, problem determination, network analysis, hardware integration, software integration, proposal preparation,
software conversion, program specs, cost/benefit analysis, requirements analysis, documentation, program maintenance and data modeling, linear
programming, montecarlo simulations, mathematical analysis.

*Note: I’m particularly adept at tuning SQL queries: references will be provided upon request*



EMPLOYMENT HISTORY:


9/11/2000 – Present, Bethesda, MD

Employee:  Ported an Oracle 9i/10g/11 data warehouse to the Netezza platform (Netezza is a data appliance similar to Teradata). Re-wrote Pro*C and DB2-
to-Oracle Sync jobs using Informatica 7.1.; developed Extract, Transform, and Load (ETL) routines using Informatica PowerCenter and Oracle/Netezza as
the backend databases. Re-writing PL/SQL routines using Netezza nzsql and nzload utilities. Provide 24 x 7 Support to an existing, 1.2 terabyte, Oracle 9i
star-schema data warehouse. Duties include (but not limited to), troubleshooting PL/SQL and UNIX shell scripts. Tuning SQL statements;
creating/enhancing new /existing programs. Reverse Engineering Schema’s using ERWIN. Partitioning/Indexing/compressing ¼ terabyte tables.
Managing resources (e.g. DASD, CPU, etc). Managing Infrastructure upgrades/changes (e.g. HP RP8400 Frame Migrations). Managing database upgrades
(Oracle 8i/9i, 9i/10g). Creating data extracts using VB script, MS Access 2003 and Unix Shell scripts. Designing and implementing Informatica jobs to load
datamarts and create flat files used to generate reports. Designed forms & reports to support our Demand Query Data Mart using Oracle Forms 4.5 and
5.0 and Reports, Actuate and SQL Reports. Tuned SQL/PLSQL scripts using both cost based and rule based (hints) optimization techniques. Created
PL/SQL scripts for extracting, transforming and loading data to/from a number of both Oracle and non-Oracle sources.

1/1/2011 – 9/30/2011

Contractor: Worked on the Federal Election Commission (FEC) Data Warehouse Design Implementation Project. Developed and coded Oracle (11g)
PL/SQL routines for processing FEC form data.  The FEC Data Warehouse (FDW) system that was developed consists of three distinct repositories
(schemas) as well as three stages for data Extraction, Transformation and Loading (ETL). The two initial data repositories maintain source data – the first
(Ingest) (ETL-1) contains unmodified data and will form a historical record. One of the goals of this design is complete traceability; meaning that any piece
of information that is found in the data warehouse should be traceable back to its source. The second data repository (ETL-2) (Processed) will be the
“work area” in which incoming records may be properly processed before being parsed out into the data mart layer (CFDM schema – the third repository)
(ETL-3). My task involved coding ETL-2.

1997 – 2003

Consultant: Provided ongoing support for a contract management system created using SQL Server 7.0/2000 and MS Access 7.0/2000/2002.
If your organizations has an IT Staffing or Consulting need for
a  Netezza - IBM PureData Resource, please email us at
sales@peningo.com . If you wish to speak with someone from
Peningo Systems,
please click here to contact Peningo.
Back to the Peningo Netezza Consultants resume page
Back to the Peningo Netezza Consultants home page.