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.
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.
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
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
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
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.
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.
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
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
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.
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
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.
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.
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
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
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.
B.A. in Psychology
M.A. in Criminal Justice
Certificate of Proficiency in Computer Programming
Dimensional Modeling in Depth
May 2007 to May 2007
Kimball University Certificate of Completion
November 2016 to November 2016