X hits on this document

16 views

0 shares

0 downloads

0 comments

4 / 5

Employment Details:

Page 4

Precision marketing & online registrations website stats(BigData). Data modeling (logical & physical) on VLDB’s. Taught advanced Oracle8i features. Used Er/Win 3.5 & Model Mart, Sql*Navigator, EZ/SQL tools to reverse engineer the logical model from existing data model. Finished logical model , took it physical (w/ scalable options: partitions, bitmaps, etc.). Databases: OLTP & Operational Data Store(ODS). Developed ETL process. Performed DBA duties. Surveyed Oracle’s XML capabilities. Installed Oracle’s JVM (JServer) & wrote Java Stored procedures for web developers.

12/1999 - 2/2000 Sql*Loader. Web DB

4Anything.com - Oracle 8i, Data Mart Suite, Data Modeling, Data Marts, VLDB, PL/SQL, , Sun O/S

4anything.com was a dotcom that needed a data mart to analyze web traffic data (website stats / Big Data). Did the data modeling & architecture design & construction of the logical models, physical models & physical database. Also built the Traffic Data Mart. Tuning/diagnosis. Installed & setup Oracle’s Data Mart Suite.

8/1998-8/1999

UNISYS - Oraclev8, Oracle Parallel Query, Oracle/UNIX, Oracle/NT, Data Modeling, Data Marts,

VLDB, PL/SQL, Sql*Loader, Oracle Enterprise Mgr, Oracle Designer/2000, OADW, international data privacy, Peoplesoft.

Did data modeling & architecture for design/construction of logical models, physical models & physical database. Built initial Sales Data Mart & integrated Query Tools(Business Objects & Oracle Discoverer), Tuned & diagnosed bottlenecks (network, ISS related or Oracle bugs). Launched Data Marts & coalesced their feeds & Conformed data elements. Data Marts fed from Oracle Applications (Oracle PA, Oracle Financials, & PeopleSoft). Used ISS as the Web Server. Used Oracle 8 features to tune & enable complex OLAP queries. Tuned Oracle for NT dbs & diagnosed problems with Web front- ends to UNIX & NT Oracle databases. Configured Oracle DW Builder for Oracle PA, PeopleSoft, & Oracle Financials.

2/1998-8/1998

COPELCO – Oracle v7.3; Oracle Parallel Query, HP/UX, Data Modeling, Operational Data Store,

VLDB, PL/SQL, Sql*Loader, Designer/2000 v1.3, Oracle HR, Oracle Financials

Developed Data Conversion Methodology, managed conversion team, data modeling, & the preliminary development of the data conversion framework. Anlayzed Lease Administration system & interfaces to Oracle Financials. We ETL’ed data from old OLTP system & from ORACLE Financials & ORACLE HR dbs to populate the Operational Data Store.

8/1997-1/1998

PECO Energy - Oracle v7.3; Oracle Parallel , IBM AIX, Oracle for NT, Data Modeling, Data

Warehouse, VLDB, Data Marts, Developed Warehouse Methodology, Data Pivoting, Oracle Name Server v2.0

Developed PECO’s Data Warehouse & Data Mart strategies & wrote white papers. Demonstrated the proof-of-concept by building a Data Warehouse lab demonstrating the various tiers & how the infrastructure worked. After proof of concept, I mentored the Data Architects to design Data Marts utilizing the Data Warehouse Workbench & Methodology. Also tuned a Data Mart.

6/1997-7/1997

Clark Shoes – Oracle v7.3; Oracle for NT, PL/SQL, Data Mart, Data Pivoting, ETL

Developed a Sales Data Mart. Wrote stored procedures to load the fact table using data pivoting techniques.

7/1996-6/1997

Coopers & Lybrand @ FirstUSA – Oracle v7.2/7.3;

Oracle Parallel Server,

Pyramid

MPP/Reliant-Unix, Data Modeling, Data Warehouse, VLDB (3.5TB), ERwin/ERX 2.5, SUMMIT-D Methodology

Data Warehouse Architect using the latest hardware & software available to build a VLDB (> Terabyte raw data), Data Warehouse on Pyramid Massively Parallel (MPP) Unix platform.

3/1995-6/1996

Ajilon

with

CSC

(Designer/2000; CaseWise), Client/Server, ODBC

SQL*Net

v2/

Partners

  • Oracle

v7.1/7.2;

Oracle

Parallel

Server,

NetManager/Oracle

Names,

HP/UX;

Catalyst

Methodology

VLDB,CASE (for BPR),

Data Architect used CATALYST methodology to re-engineer the PPL business processes., using distributed technologies. Data modeling (Conceptual, Logical & Physical), & Data Architecture, DBA & CASE repository Mgt.(Designer/2000). Work Mgt. & GIS systems. Project used off-the-shelf packages then evaluated, did package system design & gap analysis. Integrated the packages, migrated legacy data.

11/91-3/95

Aston Brooke Corp - Oracle v5,v6,v7, SQL*Forms v3.0, SQL*Loader, Pro*C and realtime Vax

C programming, SQR, PL/SQL, C / Kshl / Tcl,Tk /Perl /DCL scripts, & Lotus 1-2-3 add-in , VMS, SCO Unix, AIX , HPUX &

Oracle for NLM. DBA, Unix Admin.

3 Oil systems & Employee Scheduling system @ Mobil Oil. refinery simulation & modeling. The employee scheduling overtime payment. Developed Drug Discovery DB @ FMC.

Oil systems from process control, to oil movement & mgt, to crossed 3 shifts, with complex union rules for scheduling & DBA @ Towers-Perrin, for 45-50 UNIX(v6), some DOS(v5)

C. Michael Eliasz-Solomon

7/28/2014

Document info
Document views16
Page views16
Page last viewedTue Dec 06 08:47:26 UTC 2016
Pages5
Paragraphs211
Words3062

Comments