Eugene Freydenzon

**** ********* ***, **********, ** 95834

ac1sn1@r.postjobfree.com 949-***-****

EXECUTIVE SUMMARY

Data Architecture Experience

Acted as principal architect specializing in data warehousing and data integration.

Planned, constructed, and lead developments of data warehouse, integration and custom OLTP solutions for multi- terabyte and high transaction volume implementations.

Performed both high and detail-level business requirements definition and developed logical, physical and dimensional data models based on business requirements and performance needs. Designed both tool-based and custom ETL solutions and integration modules.

Engineered enterprise reporting strategy and architecture. Performed vendor analyses, including cost/benefit. Conducted an infrastructure planning for Data Warehousing and reporting solutions, including determining licensing and support costs for all the solutions’ components (hardware, software and people costs).

In recent years was involved in establishing architecture, interfacing with and evaluating NoSQL solutions and platforms.

Adopted activities as Database Programmer, Oracle DBA, ETL designer, Report Developer and Data Analyst. Leadership Experience

As a project manager, administered enterprise-wide solutions with up to 21 professionals in project staff. Developed and maintained project budgets and project plans, staff phasing and customer expectations management documentation.

As practice manager, managed day-to-day activities of a Data Warehousing practice, including P&L, personnel and methodology aspects. Supervised organizations up to 52 reports, including 6 managers.

As a career manager (mentor), provided career management and counseling for up to 9 individuals at a time. Primary Functional Expertise

Healthcare, Energy, Education, Telecom, Retail, Utilities, Finance, Logistics, CRM, Manufacturing SKILLS

Management : Division, Practice, Project, Program, Small Enterprise

Analysis : Functional Analysis and Design, Database Architecture and Design, Technical Architecture

Methodologies : Kimball, Inmon, Imhoff, Zachman, TOGAF, TPM, Six Sigma

Databases : Oracle, DB2, MS SQL Server, Sybase, Informix, Teradata, Netezza, Vertica

Non-Structured : MongoDB, SQL-on-Hadoop (Hbase, Hive), MarkLogic

Data Warehousing Tools : MicroStrategy, Business Objects, Cognos, Oracle Express, MS Analysis Services, Informatica, DataStage, DecisionBase, Actaworks, DSS

CASE Tools : Power Designer, S-Designor, ER-Win, ER-Studio, COOL-BIZ

Programming Languages : C, C++, Pascal, FORTRAN, BASIC

Version Control : VSS, PVCS

Standards : PPDM, HIPAA, ASC X12, HL7, ACORD, IAA, ARTS, GJXML

Clearance : Secret (ADPII/NACLC) Department of Defense – inactive EMPLOYMENT, CONTRACTUAL WORK AND PROJECTS

Chief Data Architect 02/17 – 04/17

Delgata Sacramento, CA

Performed proposal preparation and assisted marketing with all aspects of bidding for State of California’s agencies.

Performed a detailed analysis and review of MarkLogic for the purpose of integration bid.

Assisted CDCR with few technical issues related to integration and reporting from ARMS system. 1

Lead skills development of junior developers in terms of data and NoSQL systems. Contractual Work 12/11 – 12/16

Data Architect

ConocoPhillips

Technologies: SQL*Server, Teradata, Hadoop, Informatica, Spotfire, ER-Studio

Provided technical leadership in production data warehouse based on largest US mature gas basin (over 9000 wells).

Participated in planning and scoping, business requirements, data modeling, physical architecture, PPDM mapping, performance tuning for fully-developed, timely and on-budget “tactical” SQL Server solution as well as initial stages of Teradata and PPDM-based long term strategic solution.

Developed statistical predictive models for daily production by well and frozen meters.

Architected final solution(s)-based combination of Teradata/SQL-Server/HDFS with Informatica/Spotfire.

Assisted with data design and performance of various applications. Chief Data Architect

Lifenexus

Technologies: MongoDB, SQL*Server

In a short project assisted start-up company to define business requirements to personal health data, the preliminary form X12 837 and develop data framework to serve needs for years to come.

Worked with CIO, external physician consultant, client health insurance company, and development team to fit requirements into aggressive schedule.

Established MongoDB schema and integration framework. Principal Data Architect

Bank of America

Technologies: Vertica, Teradata, HDFS Integration

Lead appliances research and preliminary architecture for initial phase of planning and scoping a large project that reconciled data from disparate Teradata subsystems into a consolidated Vertica/HDFS platform.

Established methodology and KPIs for technology transformation. Guided source and gap analysis.

Performed PoC design and scoped PoC development effort. Principal Solutions Architect (Managing) 08/11 – 08/12 Apollo Group Phoenix, AZ

Technologies: Oracle, ER*Studio, Informatica, MicroStrategy, GoldenGate, HDFS Integration

Supported and enhanced an existing data platform and simultaneously researched and developed a completely new data warehousing and integration platform which supported restructuring of Apollo business offering.

Managed small team of individuals including mentoring and skills development.

Performed research, PoCs and preliminary vendor selection of hardware and appliances evaluating multiple appliance vendors (Netezza, Exadata, MS PDW Hardware Appliances and Teradata, Cognitio and Vertica’s software only option) as well as open-source options (PostgreSQL, Enterprise DB).

Created and tested hardware platform based on low-cost commodity SSD infrastructure.

Worked closely with Hadoop architecture and team ETL (Talend) establishing common integration open-source framework. Performed Hive/HBase performance analysis and rationalization of HQL/MapReduce access methods. Contractual Work 07/09 – 08/11

Data Architecture Team Lead

Wolters Klewer Health

Technologies: Oracle Exadata, Oracle, ER*Studio, Informatica, MicroStrategy

Acted as a technical lead on 837 (4010 and 5010) re-factoring project. 2

Acted as a designer and an architect of a back-end of data quality validation module of main data processing platform

(evaluation of over 2.5 billion new data records per month).

Acted as an IT technical oversight on global (multi-national vendors) drug integration initiative.

Participated in development and tuning proprietary statistical prediction model for generating missing Rx records.

Performed performance analysis and various PoCs related to Oracle Exadata implementation, resolving architectural challenges of different architectural foundation as compared to legacy Netezza/Oracle solution.

Participated in architecture review board and process improvement activities. Data Architect

Triwest

Technologies: MS SQL Server, Oracle, SSIS, SSRS

Performed architecture, design and management of all technical aspects of project that provided a reporting solution for Health Care Services.

Performed various implementation functions as required to successfully deliver two phases of a project on time.

Notable technical aspect of the project was trickle-feed based on Oracle materialized view logs in average window of 29 seconds.

Principal Consultant, Global Enterprise Integration 06/07 – 11/08 CIBER Scottsdale, AZ

Position reporting to Vice President GEIP. Provided strategic data architecture, management consulting for CIBER’s clients.

In addition to primary responsibilities, participated in organization methodology and human capital development of then- recently formed Global Enterprise Integration Practice. Architect, Enterprise Consultant

Chesapeake Energy

Technologies: Oracle, Informatica

Performed business analyses, data modeling, architecture, design and mapping for Delivery Systems EDW expansion. Consulted client in area of process improvement, architecture and design best practices, templates and methodologies. Solutions Architect

Wolters Klewer

Technologies: Oracle, ER-WIN, DataStage

Performed business analysis, physical data modeling and architecture of the drug module. Lead lifecycle effort from architectural concept to UAT.

Performed various roles to fill gaps in understaffed team, including PL/SQL programming and test planning. Information Domain Architect (i.e. Technical Director, Data Architecture) 05/06 – 02/07 CSAA Glendale, AZ

Position (reporting to CTO) entitled ultimate responsibilities for enterprise data architecture and engineering and included voting privileges on enterprise architecture council, representing data domain.

Executed strategic planning, IT organizational budget related to data systems, development and enforcement of standards and methodologies, project review and architectural assistance and data stewardship oversight.

Responsible for technology and vendor selection and licensing negotiations.

Participated in data architect and reviewer capacity in every major data, data warehousing, integration and reporting project in-flight and in-planning.

Technical Manager 03/04 – 03/06

Oracle Consulting, BI&W North America

As a member of Strategic Architecture Group, focused on data architecture and project management consulting for strategic Oracle installations over 10 TB in size. 3

Duties included project management, architecture and organizational data management consulting. Participated in methodology development, mentoring and pre-sales activities. Most significant projects:

Solutions Architect

State of Illinois

Technologies: Oracle, ER-WIN

Performed business analysis, logical data modeling, and reference technical architecture of the first phase of law enforcement data integration for the State of Illinois that integrates over 200 disparate data sources for HLSA needs and local crime reduction.

Principal Architect

Procter and Gamble

Technologies: Oracle, ER-WIN

Evaluated, provided recommendations on, and lead summary management and performance design of the global enterprise-wide multi-terabyte 24/7 data warehouse initiative for the world largest consumer product company. Project had distributed delivery and requirements gathering approach, reflecting the global nature of the business with development sites in US, Canada, Poland and India.

Most notably, this project was first in a world that had compete reliance on Oracle query rewrite. Project Manager, Lead Architect

SBC Communication

Technologies: Oracle, ER-WIN, Teradata

Project manager and lead architect in major enterprise Teradata to Oracle re-platform initiative for the world largest Teradata Telecom installation during the time of acquisition of AT&T. Complex project that required multiple PoCs in order to find a right technology solution.

After few failed attempts, successfully implemented 40 TB PoC for what is to be 1000TB project. Enterprise Data Specialist

Coles Myer

Technologies: Oracle, ER-WIN, OWB

Evaluated and provided recommendations to the data warehouse program initiative for one of the largest retail corporations in Australia.

Reviewed the design of Merchandizing, Customer and POS data warehousing projects (overall 75 TB over 5 years) within the program and provided recommendations to the program director and steering committee. Contractual Work 06/02 – 02/04

Data Warehouse Architect

Giant Eagle

Technologies: Oracle, AIX, ER-WIN, Designer 6i

The project consisted of the assessment of existing Data Warehousing Architecture and creation of the new re-engineered solution of reporting needs from Enterprise Data Warehouse.

Responsibilities included overall architecture review, methodology assessment, data modeling and data architecture. Conducted the proof of concept that provided data related to technical feasibility and load window of load of Point-of-Sale transaction log data (13 GB pack decimal raw data per day). Architect

FreeMarkets

Technologies: MS SQL Server, Business Objects, DTS, .NET 4

The project provided a data warehousing and reporting solution in hosted .NET environment based on multiple symmetric data sources.

Each data source was a stand-alone database, which corresponded to a source solution for supplier facing downward auctions.

Performance Tuning

FreeMarkets

Technologies: Oracle, Analysis Services, Decision Stream, .NET

The customer required a hosted solution for extensive data analysis of material and services procurement with intent to minimize expenditures.

The project had two releases: one based on Cognos solution, and another based on Analysis Services with custom XML drill-down component; both in .NET environment.

Practice Director 07/99 – 03/02

TMP Worldwide, Inc. Torrance, CA.

Oversaw project management, account management, pre-sales activities, personnel management, career management and counseling, and allocation for data warehousing practice.

Created reporting structure, methodology and standards for data warehousing practice including design, estimating guidelines, and templates.

Led pre-sales activities, discovery projects, and managed a multi-million-dollar engagement for TMP client. Various Roles – 07/99

Programmer, analyst, architect, DBA, manager, CEO of a small company EDUCATION

Ural State Technical University Yekaterinburg, Russia

Diploma of Engineering (equivalent to MS in Engineering in US)

Major: Automation

Course work: “Mathematical Modeling and Optimization of Fluid Dynamics Dual Reverse Furnaces”. Completed on FORTRAN on BSM6. Published.

5

Contact this candidate