Data Warehouse Developer
Resume:
CONFIDENTIAL RESUME OF
Ned T. Kadoura
Frederick, Maryland 21701
Home: (301) 662- 4904
Cell: 301-***-****
Email: *******@***.***
SUMMARY: Over 26 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.
EDUCATION: 1988 M.S.E.E., Electrical Engineering, George Washington University
1980 B.S., Electrical Engineering, University of Michigan
1980 B.S., Engineering Mathematics, University of Michigan
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.
Security Clearances: 2008 – ISYS Corp – Secret Clearance (DoD - Active)
1981 – 1983 Vitro Corporation – Secret Clearance (DoD – Not Active)
1983 – 1984 Institute for Defense Analyses – Top Secret Clearance
1984 – 1987 MITRE Corporation – Top Secret (DoD – Not Active)
1987 – 1988 General Electric – Secret with Tickets
1988 – 1990 Litton Amecom – Secret Clearance (DoD – Not Active)
Languages
ORACLE 10g, 9i, 8i, 8.0, 7.3
DB2
Informatica 8.11,7.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.
TEACHING & TRAINING: FAES/NIH: Taught a C Language Course Winter/Spring (1987)
George Washington University: Taught courses in Algebra, Trigonometry and Calculus - 1984
Mitre Corporation - Professional education in Communications and Network Theory - 1984
Vitro Corporation - Professional education in simulation and programming methodologies - 1981, 1983
EMPLOYMENT HISTORY:
9/11/2000 - Present Marriott Corporation, Bethesda, MD
Employee: Ported an Oracle 9i/10g data warehouse to the Netezza platform. Re-wrote Pro*C and DB2-to-Oracle Sync jobs using Informatica 8.11.; 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 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.
1997 – 2003 PENN Detroit Diesel, Allison, York, PA
Consultant: Provided ongoing support for a contract management system created using SQL Server 7.0/2000 and MS Access 7.0/2000/2002.
1/2/1999 – 5/1/2003 Cook County Hospital, Chicago, IL
Consultant: Database Administrator for an Oracle 8.0.5 database running under Windows NT 4.0.
10/10/1999 - 11/21/1999 Bell Atlantic, Harrisburg, PA
Consultant: Set up and administered an Oracle 8i Data Warehouse for collecting and analyzing network traffic. Analyzed requirements; created database schema; created PL*SQL scripts for moving data between collection workstations and the Data Warehouse. Developed a DBA guide for managing the Data Warehouse and its associated collection workstations.
12/1/1998 – 7/1/1999 Marriott Corporation, Bethesda, MD
Consultant: Worked on debugging and modifying Oracle PL/SQL scripts that create flat files used for processing insurance claims.
07/18/1998 - 12/1998 Duty Free International, Glenburney, MD
Consultant: Worked on debugging and modifying a customized Oracle Financials application. Modified existing reports using Report Builder (ver. 3.0), and developed new reports in SQL*Plus.
09/01/1996 – 7/18/1998 Pointe Technology Group, Landover, MD
Consultant: Worked on a number of tasks using Oracle 7.2, SQL*Forms 3.0, SQL*ReportWriter 1.1, Pro*C 2.0, SQL*Plus and the Just In Time (JIT) financial management package. Also created a contract management system for PENN Detroit Diesel, Allison, in York, PA. Tools used were SQL Server and MS Access 7.0/2000.
06/01/1996 – 1/3/2000 Cook County Hospital, Chicago, IL
Consultant: Rewrote the interface between Cook County Data General (DG) system and their Emergency Department’s Novel Server. The tool used is Visual Basic 4.0/5.0 (32 bit). Creating a new RDBMS and computer infrastructure for the Department of Emergency of Medicine. Tasks included: (1) design, development and implementation of an Oracle 8.0 based RDBMS system; (2) Created a new interface to RDBMS using MS Access 7.0/2000; (3) Created a new scanning infrastructure for scanning and viewing patient charts using MS Access. Designed an ad-hoc query system using Oracle Discoverer.
06/01/1997 - 06/21/1997 Department Investigative Services (DIS)
Consultant: Created forms and reports for an internal Configuration Management (CM)/Trouble Report system. Tools used included Forms 4.5 and Reports 2.5 (Developer 2000 ver 1.4).
05/20/1996 - 5/16/1997 Alexander & Alexander
Consultant: Worked on modifying, enhancing and debugging a customized financial package for the Alexander & Alexander Insurance Company. The Oracle Financials Development Environment was used as a basis for developing the current product. Tools used include PL/SQL, Forms 2.3 and SQL*ReportWriter 1.1.
01/07/1995 - 5/1996 Cook County Hospital, Chicago, IL
Consultant: Created a complete patient registration and tracking system for the Emergency Department of Cook County Hospital. The application was written in Access 2.0 and Visual Basic 4.0. An Access 7.0 for Windows 95 is planned.
03/11/1996 - 04/01/1996 GRC International, Vienna, VA
Consultant: Created reports and enhanced Pro*C programs for a networked messaging system.
09/11/1995 - 02/14/1996 Sprint International, Reston, VA
Consultant: Created forms and reports for a system that supports the exchange and management of trouble tickets. Work was done on a PC running Windows 95, Oracle 7.1, PL/SQL,SQL*Forms 4.5 and SQL*Report 2.5.
09/03/1994 - 10/31/1995 Cygnus Corporation, Washington, DC
Consultant: Worked on converting a Wang COBOL based system to Microsoft Access 2.0. The current system supports the National Guard's decision support and management information system requirements.
10/01/1994 - 1/1995 - Microtemps, Greenbelt, MD
Consultant: Created three reports using SQL*Reportwriter (version 1.1) reports for contractor registrations contract. Work was done under OS/2 running ORACLE 7.0.
10/04/1994 - 02/6/1995 - Technet, Columbia, MD
Consultant: Working on an on-line dial-up system for accessing information relating to the Department of Assessments and Taxation. Application was created using OS/2 running ORACLE 7.0, PL/SQL, SQL*Forms 3.0, SQL*Reportwriter 1.1 and Pro*C. Application has been deployed to SUN Sparc Workstation 1000 running SOLARIS and ORACLE 7.0.
04/19/1994 - 9/30/1994 - Applied Physics Lab, Laurel MD
Consultant: Debugged, enhanced and maintained a project management tool for integrated management of cost and schedules. Designed, developed and debugged forms and reports using SQL*Forms 3.0 and SQL*Plus under ORACLE 6.0 in an IBM R/6000 AIX environment.
11/15/1993 - 08/01/1994 - Insight Corporation, Oregon
Consultant: Created a GUI interface for a Global Supply Chain Model (GSCM) using Visual BASIC Version 3.0. The interface was written using Visual BASIC and the Q+E Multilink/VB product. Multilink/VB provided the controls necessary for connecting the interface model to the required datafiles.
11/29/1993 - 03/07/1994 - Compus Corporation, Rockville, Maryland
Consultant: Debugged, enhanced and tested a decision support system for the Center for Biologic and Evaluation Research (CBER) Center of FDA. System currently runs on a VAX, VMS platform using Oracle 6.0, PL/SQL,SQL*Forms 3.0, SQL*Plus and SQR.
07/01/1993 - 10/08/1993 - Planning Research Corporation, McLean, Virginia
Consultant: Debugged, Modified and enhanced an Automated Billing System (ABS) for internal use at PRC. Application was written in Object Vision on a 486 PC. Application was ported to Oracle 7.0 using JAM as the front end GUI tool (front was latter re-designed using PowerBuilder 3.0). Application now runs on an HP 9000 running HP UX and Oracle 7.0.
08/05/1993 – 7/01/1993 - ANADAC Corporation, Arlington, Virginia
Consultant: Converted a Navy Furnished Material Tracking System (NFMTS) from Oracle 5.0 to Oracle 6.0. Port involved converting SQL*Forms 2.3 and SQL*ReportWriter 1.0 to SQL*Forms 3.0 and SQL*ReportWriter 1.1. Conversion was done under OS/2 2.1. System was tested and ported to a VAX 6310 running VMS. Created a client-server version of NFM system under Novell using Powerbuilder 3.0.
07/15/1993 - 09/15/1993 - Performance System Corporation, Springfield, Virginia
Consultant: Created forms for a real-time building security access control system. Forms were created under SCO UNIX using SQL*Forms 3.0 and Oracle 7.0.
08/19/1991 -- 05/24/1993 - Haliburton NUS Environmental Corporation - Gaithersburg, Maryland (Employer Aerotek, Reston, VA)
Consultant: Modified, enhanced, debugged and reverse engineered a Radiological Database Management System for tracking employees and their exposure histories at nuclear power plants. Gathered user requirements and wrote user and program specifications. Used Oracle CASE to develop Data flow Diagrams (DFDs), Entity-Relationship Diagrams and coded reports using SQL*Forms 3.0, SQL*Plus, SQL*ReportWriter (ver 1.1) and PRO*C under UNIX, VMS and Oracle 6.0, PL/SQL. Participated in the development of both a Factory and Site Acceptance test plans (i.e. FAT,SAT). Created, customized and debugged forms using SQL*Form 3.0. Converted user exists (in C) to PL/SQL code. Programmed sophisticated LaserJet form based reports for GE Nuclear's Shipping Paperwork System (SPS); reports were programmed using PRO*C under UNIX. Wrote Programmers Manual for SPS.
01/08/1990 - 06/0719/91 - Statistica - Rockville, Maryland
Senior Systems Analyst: Developed a relational database system for the Market News Service of the Department of Agriculture (USDA). Created entity relationship diagrams, structured charts, program specifications, and programming support. Developed screens and menus using SQL*Forms(Version 2.3); generated reports using SQL*Plus, PRO*C and Microsoft C 6.0. The RDBMS was created with ORACLE 6.0 running under Banyan Vines; ver 5.1C of the Oracle toolset was used to generate the menus, forms and reports.
08/01/1988 - 01-5/1990 - Litton Amecom - College Park, Maryland
Consultant: Developed a real-time computer simulation, which is used to evaluate various passive sensor systems for AWACS surveillance. Program was written in HP BASIC on a HP 9000/520 workstation.
01/12/1987 - 07/25/1988 - General Electric Corporation - Springfield, Virginia
Communications Engineer: Communications Engineer Consultant on a Sperry-based LAN
05/1984 - 01/09/1987 - MITRE Corporation - McLean, Virginia
Programmer/Analyst/Engineer: Member of the Air Defense C3 group. Provided analysis and programming support on the connectivity of an Enhanced Position Location Radio Service (EPLRS)/Joint Tactical Interoperable Data System (JTIDS). Documented Comparison between the MARK XII and MARK V Identification Friend or Foe (IFF) systems. Conducted an analysis of the track message loading incurred by the Short Range Air Defense Command and Control (SHORAD C2) architecture using a Single Channel Ground to Air Radio Service (SINCGARS). Conducted a study to access whether SINCGARS could be used to support the command and control requirements in the rear division for the SHORAD community of subscribers; conducted an analysis of a study to assess the functional contribution of radar and C2 to SHORAD effectiveness; help develop a VMS/COBOL based Security Application for NAVSEA.
Program Management: LANs and Protocols: Provided technical and program management support to the Army World-Wide Military Command and Control (WWMCC) Information System (AWIS) Program Management Office (PMO). Defined site configurations and provided transition management support. Defined and managed a complete performance evaluation of a proposed communication and protocol architecture for the WIS LAN.
Mathematical Modeling and Simulation: Worked on a force comparison model (FORCECOM) for the Central Army Group (CENTAG). Developed a prototype extension of this model, Statistical Comparison Model (STATCOM), which is used in conjunction with FORCECOM for sensitivity analysis. Developed a neural network to detect and classify Soviet AS and SS targets. The model used a Backpropagation paradigm with 256 processing elements. Work was done on an IBM AT in C; also developed a forecasting model using linear programming methodologies for projecting enemy positions and troop strength.
05/1983 - 05/1984 - Institute for Defense Analyses (IDA) - Alexandria, Virginia
Programmer/Analyst: Provided programming support for the International Security and Assessment Division (ISAD) of IDA. Helped conceive, construct, and program a strategic
and tactical C3I model for the Systems Evaluation Division of the Joint Chiefs of Staff (JCS).
Also worked as a subcontractor for IDA on Tactical Wargaming Models (TACWAR) during the 4-86 to 5-86 timeframe; developed stochastic models for predicting enemy movements using a linear programming paradigm and FORTRAN 77.
07/1981 - 05/1983 - VITRO Laboratories - Silver Spring, Maryland
Programmer/Analyst: Terrier Missile Department; worked as a programmer/analyst on missile simulations. Involved in the analysis and documentation of missile performance for the development and design of the "Weapons Direction System" (WDS MK 14. Was involved in the construction of engageability contours for the Standard Missile 1 (SM-1) and Standard Missile 2 (SM-2) BLK 2. Conducted studies to assess the sensitivity of diving target algorithms to random errors, and to investigate limitations imposed on outer engageability contours due to power availability to the missile's rear reference antenna.
Contact this candidate