X hits on this document

15 views

0 shares

0 downloads

0 comments

2 / 5

Employment Details: 1/6/2014-present

TekSystems – (Data Architect/ETL) Oracle 11g, Oracle Developer, PL/SQL, KSH, Unix.

Page 2

Penn State (PSU) IdS. Did the Analysis for the migration of data and software and security components of the Cactus-CPR Transition. Oracle schemas, database objects, stored database code, external PL/SQL scripts, ksh/perl scripts, various Unix utilities scripts, java code were analyzed for inter-dependencies and relevancy to the new system and its data model. Some data model review, code review, architecture, review, inventory and analysis of components that needed to be moved, retired or archived. Transitioned to Data Modeler role (used Oracle DataModeler).

9/2013-1/2014

Eliasz.com – (Data Architect/ETL.) Oracle 11g, Sql-Navigator, PL/SQL, Er/Win 8.2, KSH, Unix.

WF Bank Marketing Data Warehouse project. I was Data Architect for Customer Leads & Offers subject area with four fact tables and six dimensions. We used Er/Win 8.2, Sql-Navigator, PL/SQL to develop custom ETL process. I also wrote SQL, PL/SQL and Unix shell scripts. Project work was almost entirely done remotely, collaborating with MS Lync / Outlook tools and Sharepoints. The Data Mart was a pilot (not production). Scale was huge (Multi-Billion record tables, Multi TB Mart).

7/2013-8/2013

Eliasz.com – (DBA/Data Conv.) MySQL v5.5, vi, TOAD for MySQL 6.3.

Moving data for meat processor from an old server to new server; Export, Import, some light cleansing of data. Used TOAD/MySQL to export data and/or sql statements to re-create database and reload on the new server. Used vi to globally replace(cleanse) some data to conform it to a standard.

2/2009-12/2011

SDI – (Data Modeler/ETL Developer), Oracle 10g-11g, KSH, Unix, PL/SQL, SQL, Toad 9.7,

partitioning, ETL, Er/Win. Sql-Server

Oracle ETL, PL/SQL development & Unix System Integration ETL Performance Tuning. Worked with innovative Healthcare software / data in the multi-Terabyte (>>10TB; DWH Data Factory). Worked on FDA project. Invented metadata and developed metadata driven process to pause, stop, start, restart, and prioritize large/medium/small jobs to get maximum through-put. It was automatic and I built-in a human-in-the-loop ability too. Imported Sql-Server into Oracle one-time.

7/2007-2/2009

AIG – (Data Modeler/ETL Developer /DBA) Oracle9i-10g, ksh, SunOS5.8, HP/UX, PL/SQL,SQL,

pkgs/procs Toad8x, SAS, ETL, SOX

Oracle DBA, Data Warehouse, Performance Tuning. SOX PL/SQL (package) application for recertification of Oracle DBs / preparing audit reports. Managed 10+ Terabyte Data Warehouse in Oracle 10.2. VL tables (>1TB).

11/2006-7/2007

Glaxo Smith-Kline / Phila. Mayor’s Office DataWarehouse (ETL Developer/DBA) Oracle 9i,

10g, Business Objects Designer 6.5, KSH, Perl 5.x, Sun OS 5.8, PL/SQL, SQL, stored procedures /db triggers, Sql*Developer, Sql*Navigator 5.5, partitioning, blobs/clobs, automated refreshes. SOX. SAS

01/2006-12/2006

Primavera – (Data Modeler/Data Architect/ETL Developer) Oracle 9.2/10g, CDC, ETL, Perl 5.8

Data Modeling, PL/SQL, SQL, stored procedures, shell scripts, Sql Developer, Java.

Data Architect / ETL. Designed the ETL process to support both Sql*Server & Oracle. It was a Data Mart / ODS reporting

tool 08/2005-12/2005

GMAC (Data Modeler/ETL Developer)

Oracle 9.2, Er/Win 4.1, Data Modeling, ETL, Data

Warehouse (Mortgage/Loan Products), PL/SQL, SQL, stored procedures / packages/ db triggers, Toad

Oracle DBA, Data Modeler, & ETL Developer. Customized industry standard model(MISMO) enhanced to support GMAC. Used Er/Win to model Enterprise Data Warehouse for Mortgage/Lending. Established naming standards, domains(std data types), PL/SQL programs to perform ETL. Tuning

04/2005-8/2005

McNeil (Data Modeler/ETL Developer) Oracle9.2, ksh, Er/Win 4.1, Data Modeling, SunOS 5.8,

PL/SQL, SQL, stored procs / pkgs, Unix shells, Toad. SAP Logon Pad, SAP R/3, BW, BEx Analyzer

Oracle DBA, Data Architect. McNeil did data modeling & performed application DBA work on Validated & non-Validated systems, including Sales Roster & Pharmaceutical Dashboard. Also worked as a Business Analyst on an SAP BW project (reporting using BEx). Developed & Trained the Trainers on BW Reporting using BEx.

01/2005-04/2005

Primavera (Data Modeler/ETL Developer) Oracle9.2, ksh, Er/Win 3.5.2, Data Modeling, Sun

OS5.8, PL/SQL, SQL, stored procs. / pkgs, Unix shells, Sql*Navigator 4.5/Toad, materialized view(replication); Agile Methodology.

Oracle DBA, DataWarehouse Developer. Did data architecture, data warehouse, data modeling, DBA, & developed with(ksh, SQL, PL/SQL). Used Change Data Capture to capture OLTP changes from redo logs (not the tables). Implemented the CDC process & ETL in staging tables & then replicated the data to a schema for near-real-time reporting & analysis on 30 minute intervals. Data modeling, Architecture, ETL, System Integration, & DBA duties.

05/2004-12/2004

Glaxo Smith-Kline(GSK) (DBA/ETL Developer) Oracle 8i/9i, KSH, Perl 5.x, Sun OS 5.8,

PL/SQL, SQL, stored procedures /db triggers, Sql*Navigator 4.5, Java (1.4), JDBC2.0, partitioning, blobs/clobs,

C. Michael Eliasz-Solomon

7/28/2014

Document info
Document views15
Page views15
Page last viewedSun Dec 04 01:05:35 UTC 2016
Pages5
Paragraphs211
Words3062

Comments