BI Consultant Resume

Professional Capsule

ETL Architecture and Development with Datastage 12 years. Technical Team Leader with strong User Interface from concept to delivery. Hands-on IBM InfoShere Parallel Datastage 8.5. Star schema, dimensional modeling with EDW, Marts, CRM. Heavy Oracle 11g, Netezza, SQL Server, DB2. Sun Solaris, AIX and other Unix platforms, working in R&D and Applications. Proven track record with large Enterprises at Equifax, Walt Disney World, Home Shopping Network, and CN Railway.

Experience

7/11 – present
BI Consultant Confidential,St. Petersburg FL
Netezza/Datastage ETL architecture and loads. Design and create parallel Oracle to Netezza environment, conversion stategy, nzload, nzsql. Datastage RCP job utilities. Datastage 8.5 consultant mentoring internal team. Design and develop Internal Data Integrity System.
3/11 – 6-11
BI Consultant Confidential,
ETL Design, Specifications, Mapping, and ETL coordination. Focus on Mart Presentation Layer. Netezza, Datastage 8.0/8.5 environment.
1/11 – 2/11
IBM Contractor Confidential,Tampa, FL
Temporary assignments for IBM in client locations, for IBM Datastage. For a General Casualty Company, this involved a Health Check for a new install of Datastage 8.5. Provide configuration support and ETL recommendations for a NYC client having recently installed Datastage 8.5.
7/10 – 12/10
ETL Architect Consultant Confidential,Detroit, MI
ETL Architect and Developer in association with Intricity Consulting. Design and build best practices ETL environment, for this 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.
2/05 – 7/10
Data Warehouse Architect Confidential,St. Petersburg FL
ETL Development and Architecture, 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, dimensional modeling. Architect a summary data approach using Materialized views to eliminate redundant aggregate job streams.
2/02 – 2/05
ETL Developer Confidential,Orlando FL
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.

3/00 – 2/02

Consultant/ ETL Developer Confidential,Orlando FL

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.

10/99 – 3/00

Consultant/ Developer Confidential,Miami FL

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.

5/99 – 10/99

Consultant/ Developer Confidential,Tampa FL

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, 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.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship