January 2015 to Present (1 year, 9 months)
New York NY
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 (1 year, 2 months)
Netezza / Datastage Conversion strategy and development. Dashboard ETL design and development. Conversion from Oracle to Netezza. Tuning, explain plan, conversion loads and design.
October 2012 to September 2013 (11 months)
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.
July 2011 to October 2012 (1 year, 3 months)
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 (3 months)
ETL Design, Specs, 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 (1 month)
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 (6 months)
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 (5 years, 5 months)
ETL Architecture, Data Architecture, and Development, using Datastage, 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 (3 years)
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 (1 year, 11 months)
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 (5 months)
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 (5 months)
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 (11 months)
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 (10 years, 3 months)
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. Initially handled Cobol CICS and Assembler for claims processing.
B.A. in Psychology
M.A. in Criminal Justice
Certificate of Proficiency in Computer Programming