Post a Job Sign in

To help ensure jobseeker privacy, some information has been hidden.

To see full resume details, log in to your Indeed account or create an account for free.

Data Architect

Data Architect

Lutz, FL

-

Kimball trained Data Architect. Comprehensive Background with 15 years in BI. Strong User Interface from concept to delivery. Logical, Physical, Transactional and Dimensional modeling with ERwin. EDW, Marts, CRM. Heavy Netezza and Oracle 11g Exadata, SQL Server, DB2, Informix. Sun Solaris, AIX and other Unix platforms, working in R&D and Applications. Agile, SCRUM. Proven track record with large Enterprises at Equifax, PwC, AT&T, Walt Disney World, Home Shopping Network, CN Railway, and currently at Medica with Healthcare Data Marts. Certificates in NOSQL, Hadoop.

Work Experience

Data Architect

Medica
-
Minneapolis, MN
-

April 2015 to Present

Healthcare Data Marts, with multiple new sources. Primary architect for the new HealthEdge Individual and Family Business initiative, resulting in 1 billion in new revenue. Logical / Physical modeling for a new ODS and staging platform, and the integration and expansion of multiple dimensional Data Marts. Source data profiling, source-to-target mappings, model reviews, capacity planning, impact analysis. A second major initiative was to integrate a PBM Pharmacy Benefit Management system for CVS claims, leveraging the new ODS and staging areas. Environment is ERwin, Oracle 11g and Exadata, Informatica, Agile / SCRUM. Take complete ownership of subject areas, interfacing with product managers, DBAs, Reporting teams, and leading the technical and QA resources for deliverables. The latest initiative involves strategic and tactical solutions for retrofitting the current-state ODS and staging environment for a new product development approach for multiple third-party customers.

Datastage Architect

Intricity LLC
-
New York, NY
-

January 2015 to Present

Preliminary design for financial services Data Mart for New York Life. Identify and profile source systems, source to target mappings and Gap Analysis for a Wealth Management Reporting and Analytics Mart. Oracle 11g / Datastage 9.1 ETL environment.

Data Warehouse Consultant

Home Shopping Network
-
Saint Petersburg, FL
-

October 2013 to December 2014

Netezza / Datastage Conversion strategy and development. Dashboard ETL design and development, creating production back-end jobs streams for highly aggregated Netezza tables used in dashboards. Datastage jobs for conversion from Oracle to Netezza. Tuning, explain plan, conversion load jobs and design. Converted Datastage job streams from Oracle to Netezza. Create new production jobs and job streams for re-designed star schema in Netezza

ETL Architect

Convergence Consulting Group
-
Tampa, FL
-

October 2012 to September 2013

Comprehensive ETL and Data Architecture and Development. IBM Datastage 8.5, SAP Business Objects Data Services ETL Tools, with DB2 ZOS and LUW. Higher education subject area, design and development funded by federal grants and the RAND Corporation.

Data Warehouse Consultant

Home Shopping Network
-
Saint Petersburg, FL
-

July 2011 to October 2012

Netezza / Datastage ETL architecture and loads. Design and create the initial parallel Oracle to Netezza POC environment, conversion strategy, nzload, nzsql. Datastage. Datastage 8.5 consultant mentoring internal team in migration to 8.5. Design and develop Internal Data Integrity System. Householding and address standardization with SAP FirstLogic for customer prospects.

DW Consultant

CN Railway
-
Montréal, QC
-

March 2011 to June 2011

ETL Design, Specs, source to target mapping, and ETL coordination. Focus on Mart Presentation Layer. Netezza, Datastage 8.0/8.5 parallel environment. Datastage tools in support of development and agile implementation. Design incremental updates for Netezza mart.

Contractor

IBM
-
Tampa, FL
-

January 2011 to February 2011

Temporary assignments for IBM in client locations, for IBM Datastage. Health Check for new install of Datastage 8.5. Configuration support and ETL recommendations for new Datastage 8.5 client.

ETL Architect Consultant

Intricity LLC
-
New York, NY
-

July 2010 to January 2011

New York NY 
Design and build best practices ETL environment, for Dana Holding Corp. international parts distributor. Upgrade to Datastage 8.1, and convert from Oracle to SQL Server, building auditing and reconciliation controls, and a streamlined ETL development model for rapid application development. For Quality Attribute Software energy monitoring enterprise, support and enhance MSMQ real time sourcing, and C#/SQL. Recommendations with prototypes for auditing and scalability for the operational system, in advance of upcoming EDW project.

Data Warehouse Architect

Home Shopping Network
-
Saint Petersburg, FL
-

February 2005 to July 2010

Data Architect II. Data Architecture and ETL Architecture. Oracle 10g. Project coordination role for multiple consultants, and development team. User interface with CRM, financial, and Web business units. Develop utility load strategies and job stream approaches for fast and reusable load code. Streamline job streams to meet challenging SLAs. Consistent advances in Data Warehouse tuning, performance and balancing. Design/Build CRM Mart. Kimball trained Data Architect, star schema, responsible for all dimensional modeling for projects, new and revisions. Architect a summary data approach using Materialized views to eliminate redundant aggregate job streams.

ETL Developer

Walt Disney World
-
Orlando, FL
-

February 2002 to February 2005

Guest Data Mart Development and Architecture, using Datastage w/heavy Oracle, some Teradata. Collaborate with Siebel, CRM, and ODS teams to design and develop ETL processes and strategies for business marketing tactics; work with business units from concept to delivery for Marketing Campaigns built for ROI. Design, mapping, and specifications. Develop methodologies for replicating test environments. Design and install Householding Merge and Aggregation job streams.

Consultant / ETL Developer

Walt Disney World
-
Orlando, FL
-

March 2000 to February 2002

Key team member on Disney's first Data Warehouse and Sales Marketing Mart (SMART). Design Datastage ETL loads for reservations subject area in the DW. Design and implement conversion of sales channel Classification Mart into a DW subject area, working with Business Analysts and business units to develop requirements, mappings, and specifications. Create Perl DBI interface in support of the primary ETL tool Datastage.

Consultant

Developer Precision Response Corp
-
Miami, FL
-

October 1999 to March 2000

ORACLE, PL/SQL, GUI w/JAM. TCP/UDP Sockets, Inbound Contacts Application, Sun Platform. Establish reliable procedures, scripts, and socket interfaces for receiving inbound contacts from AT&T.

Consultant

Developer AT&T
-
Tampa, FL
-

May 1999 to October 1999

Analyze system technical requirements, for hands-on Unix Admin and DB2 set up of complete test environments on AIX for Y2K international testing teams. Back-end Unix Support with inter-process communications for GOM (Global Ordering Management) Web Servers running DB2 on AIX, MQ, C++ and Kornshell. Establish install procedures and scripts for server setups and operational control for proactive monitoring and user interface browser diagnostic tools for system Health Checks.

Consultant / DB Analyst

PriceWaterhouseCoopers
-
Tampa, FL
-

May 1998 to April 1999

QA planning for infrastructure support tasks on Y2K Project. Build technical approach and structure for recording due diligence on test results. Establish QA and migration procedures for Natural/Adabas conversion jobs.

Internal S&P Consultant

Equifax Check Services
-
Tampa, FL
-

January 1988 to April 1998

Develop multi-platform communication protocols, working in R&D. Hands-on C TCP/IP to build in Credit Score ratings in state-of-the-art real-time authorizations. Voice Response systems and packet interface, transferring data from diverse platforms. Pro*C, PL/SQL, Kornshell scripts, stored procedures. Consult with SAS and Neural Network team in training new real-time authorizations approach. Coordinate PLs on multiple platforms in building ORACLE Pathways Revenue Management systems. User and boardroom interface in developing a division-wide approach for MVS conversion to ORACLE/AIX apps. Guided major Financial System conversion project involving GL Interface, Billing, and A/R. Coordinated all Project Life Cycle development, programmer assignments.

Education

B.A. in Psychology

University of South Florida

M.A. in Criminal Justice

University of South Florida

Certificate of Proficiency in Computer Programming

Hillsborough Community College

Skills

Data Architecture (5 years), ETL Architecture (10+ years), ORACLE (10+ years), NETEZZA (3 years), Datastage (10+ years)

Certifications/Licenses

Dimensional Modeling in Depth

May 2007 to May 2007

Kimball University Certificate of Completion

MongoDB

November 2016 to November 2016

Code School