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.
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.
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.
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.
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.
Coopers & Lybrand @ FirstUSA – Oracle v7.2/7.3;
Oracle Parallel Server,
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.
(Designer/2000; CaseWise), Client/Server, ODBC
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.
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