Keenan & Associates – Los Angeles, CA
Senior Data Warehouse Specialist (Consultant)
Keenan & Associates (http://www.keenan.com) is one of California’s largest insurance brokers delivering risk management, employee benefits, workers compensation, property liability, and healthcare consulting. I provided part-time support for the iVOS On-Demand program, resolving production incidents and evolving ETL code to meet new business requirements.
Software environment: SAP Business Objects Data Services XI 3.0 · SAP Business Objects XI · Business Objects Data Integrator 11.7 · Oracle 9i · COBOL & flat files · Excel · MS Vision · TOAD · Oracle Developer Explorer
- Developed Business Objects Data Integrator 11.7/BO Data Services XI 3.0 dataflows on Oracle while extracting COBOL flat files for AIG; used Case, Date Generation, Hierarchy flattening, MAP CDC, Merge, Pivot/Reverse Pivot, Row Generation, SQL, and Table Comparison.
- Created Crystal Reports for complex business rules, and led the offshore development team in India.
- Owned production support: tracked issues, analyzed data, implemented fixes, and tuned ETL jobs with audit rules to validate logic.
- Built workflows, jobs, datastores, file formats, and CDC configurations; installed/configured Data Integrator, managed repositories, Job/Access servers, backups, restores, performance tuning, and recovery handlers for batch/real-time services.
- Debugged via logs (trace/statistics/errors), verified target data, and published batch jobs/web services through Data Integrator Administrator.
Skills: SAP Business Objects Data Integrator/Services · Oracle 9i · COBOL · Crystal Reports · Data Quality · Production Support
People's United Bank – Bridgeport, CT
Senior Data Warehouse Specialist (Consultant)
People's United Financial Inc (NASDAQ: PBCT) is a full service bank serving Connecticut customers. Delivered a data warehouse sourced from ATM transaction feeds for the People’s Bank program.
Software environment: Business Objects Data Integrator 11.7.2 · Oracle 8i/9i · Sybase 11/12/IQ · MS SQL Server 7.0/2005 · Excel · COBOL/flat files · ERWin 7.2 · MS Visio · DOS · FTP · CDC
- Built ETL using Data Integrator 11.7.2 on SQL Server 2005, Sybase 12, and MySQL, processing flat-file uploads via BCP and applying file-specific logic while tracking metadata counts.
- Used BCP with DOS/FTP scripts for high-volume loads and authored common functions plus standards reviews for reusable code.
- Applied Data Quality transforms for address cleansing and converted ERWin logical/physical models into Data Integrator jobs.
- Administered central/local/developer repositories, user/profile setup, job servers, and CDC configurations for multi-user delivery.
- Monitored logs and debugger output, applied audit rules to validate record counts, and partnered with end users/business analysts on requirements.
- Documented and enforced data standards, source-controlled artifacts, and guided batch + real-time job development for heterogeneous sources.
- Connected sources/targets via datastore and file format definitions, ensuring resilient loads and metadata governance.
Skills: Business Objects Data Integrator · Oracle · Sybase · SQL Server · Data Quality · COBOL · Production Support
Knights of Columbus – New Haven, CT
Senior Data Warehouse Specialist (Consultant)
Knights of Columbus (www.kofc.org) is the world’s largest Catholic fraternal organization with 1.7M+ members and highly rated insurance programs. Led the Policy Data Mart (PDM) migration from development through implementation.
Software environment: Business Objects Data Integrator 11.5 · AS/400 · IBM DB2 · COBOL · Oracle · flat files · Excel · Tidal Scheduler · MS Visio
- Built ETL using Data Integrator 11.5 against DB2 on AS/400, modeling staging, ODS, and warehouse layers.
- Documented process/demonstration diagrams, gathered business requirements, and designed transformation strategies.
- Installed/configured Data Integrator servers, managed repositories, and authored backup/restore scripts for multi-schema deployments.
- Designed code migration processes, used embedded data flows for repeatable logic, and scheduled backups/jobs with Windows Scheduler.
- Analyzed logs/debugger sessions to resolve production issues, and created system profiles to handle multiple schemas.
Skills: Business Objects Data Integrator · AS/400 · DB2 · COBOL · Tidal Scheduler · ERWin
Forbes – New York, NY
Enterprise Data Warehouse Architect (Consultant)
Led the Forbes Audience Development (FAD) program to centralize customer data and deliver marketing insights.
Software environment: Business Objects Data Integrator 11.7 · Data Quality 11.5 · Business Objects XI · SQL Server 2005 · Oracle 10g · Flat files · Excel · Visio 2007 · ERWin 7.2
- Developed ETL with Data Integrator 11.7, Data Quality 11.5, and Business Objects XI to load SQL Server 2005 and Oracle 10g sources.
- Defined extraction-to-target strategy, staging/ODS layers, and star schema/change dimension models.
- Modeled logical and physical schemas in ERWin and leveraged InfoUSA for customer validation.
- Applied Data Quality transforms to cleanse millions of addresses and built repos (central/local/developer).
- Tracked logs/debug outputs for production fixes, maintained system profiles for multi-schema deployments, and scripted backups.
- Built universes/reports using joins, prompts, parsing, contexts, variables, filters, drilldowns, cross-tabs, and alerts; used embedded data flows for redundant work and Windows Scheduler for jobs.
Skills: Business Objects Data Integrator · Data Quality · SQL Server · Oracle · ERWin · Reporting
Time Warner Cable – Charlotte, NC
Senior Data Warehouse Specialist (Consultant)
TWC - Time Warner Cable provides basic, digital
cable, internet and phone services to around 40 regions throughout US. Customer Value Creation (CVC) is
TWC’s effort to centralize the data and standardizes the data for use in marketing and sales
applications. CVC is divided into multiple projects. The purpose of this project is to get the common
repository for the different billing systems like BMS, DNCS, CSG Vantage and Oracle.
- Developed complex data integration scripts using Source Analyzer, Data Warehousing designer, Mapping
Designer, Transformations, Informatica Repository Manager and Informatica Server Manager. Different
transformation logics were used to resolve issues such as Active and Passive Transformation, Connected
Lookup and Unconnected Lookup Transformation, Source Qualifier Transformation, Router Transformation,
Expression, Filter, Aggregator, Update Strategy Transformations Joiner transformation, Rank
Transformations, Expressions, Aggregator, Sequence Generator and Stored procedure.
- Redesigned UAT processes for mappings and enhanced performance of the overall loading process for
multiple regions to help for validation of data.
- Used Debugger for debugging mapping, used breakpoints to pause running process.
- Developed PL/SQL packages, Procedures, stand-alone back-end processes, functions, triggers, indexes,
partitions, Stored Procedures Functions, Constraints, Materialized Views, Partitioning, Index and
Nested Tables. Written complex stored procedures for dropping and recreating indexes on target tables,
triggers and database optimized for maximum performance.
- Implemented data model by surrogate keys and primary keys. Manipulated replacement and maintenance
plans.
- Wrote Unix Korn script for Job Scheduling, Batch Processing, various tasks, gathering data from Data
Warehousing system.
- Running and Loading of jobs, UNIX scripts, sessions and dependencies hierarchy and multiple loads
are scheduled using Tidal Scheduler.
Software environment:
Informatica Power Center 7.2, Tidal Enterprise Scheduler,Oracle 10g/9i, DB2/400, Data Dictionary,
Schemas, Tables, Partitions, Indexes, PL/SQL, Stored Procedures, Triggers, Packages, SQL*Plus,
SQL*Loader and, MS SQL Server 2000. AS/400, DB2/400, CL/400, RPG/400 and Window NT/XP, TOAD, Test
Director 7.2, WinCVS, Clear Case
Mayo Clinic – Rochester, MN
Senior Data Warehouse Specialist (Consultant)
Worked on Acta/Business Objects Data Integrator XI to modernize the Materials Management data loads for Mayo Clinic.
Software environment: Acta/BO Data Integrator XI · DB2 z390 · Lawson ERP · Oracle 9i · MS SQL Server 2000 · TOAD · IBM Mainframe z390 · Windows 2003/XP · Crystal Reports 10/XI · Business Objects XI · Rapid SQL
- Extracted from DB2, MS SQL, Sybase, Oracle, and flat files, then cleansed data with parallel-tuned loads.
- Provided Business Objects support, executed data loads, and tuned performance leveraging parallelism.
- Rewrote ETL jobs converting Oracle procedures and SQL Server DTS into Data Integrator jobs.
- Worked with Designer, Metadata Reports, Repository/Server Managers, and Web Administrator to deliver workflows, data flows, transforms, datastores, and custom functions.
Skills: Business Objects Data Integrator · DB2 · Oracle · SQL Server · Crystal Reports · ETL
Senior Data Warehouse Specialist (Consultant)
Processed healthcare supply chain systems to support neoForma’s analytics delivery.
Software environment: Informatica Power Center 6.2 · Oracle 9i · PL/SQL · Shell Scripting · MS Visual SourceSafe · Business Objects 5.x/6.1 · Web Intelligence 2.x/6.1 · MS Visio 2003 · Solaris/UNIX
- Designed and built ETL programs to extract, transform, clean, and move data into the warehouse/ODS.
- Fixed invalid mappings, validated stored procedures/functions, and executed unit/integration tests for Informatica sessions.
- Authored PL/SQL packages, triggers, stored procedures, functions, materialized views, indexing, and automation scripts for performance.
- Maintained Korn shell automation for scheduling and batch processing.
Skills: Informatica · Oracle · PL/SQL · Shell Scripting · Business Objects · Automation
Information Resources Inc. (IRI) – Chicago,
IL
Senior Data Warehousing/ETL Technical Consultant (Consultant)
Software environment:
Informatica PowerCenter 6.2–5.1, PowerMart 6.1–5.1, PowerConnect, Metadata Repository, MS DTS, XML,
Oracle 9i, TOAD, DBArtisan, NCR Teradata, Siebel 7.5, DB2 5.0/6.0, MS SQL Server, MS Access, MS Excel,
HP-UX 11.23 (Itanium), Business Objects 5.x/6.1, Web Intelligence 2.x/6.1, ERWin 4.1, MS IIS Server.
- Created Informatica repositories, user groups, and privileges, then refactored data marts by
translating business processes into reusable mappings.
- Developed Informatica workflows end-to-end, owning code implementation, data maintenance, defect
tracking, audits, walk-throughs, and design reviews.
- Extracted data from AS/400 operational systems into SCM DB2 and Oracle data marts with Informatica
PowerMart pipelines.
- Engineered PL/SQL packages, procedures, functions, triggers, and performance routines (drop/recreate
indexes) plus standalone backend automation.
Skills: Informatica PowerCenter/PowerMart · Teradata · Oracle 9i ·
DB2 · MS SQL Server · Business Objects/Web Intelligence · ERWin · HP-UX