Experience Summary

Capitalizing on a career within Business Intelligence and Data Warehousing, I have over seventeen years of experience with numerous industries and specialty areas Insurance, Banking, Telecommunications, Retail, Power, CPG, CRM, Benchmarking, Scorecarding in the design, development, implementation, and support of information technology systems across a variety of hardware environments. I'm knowledgeable in all aspects of designing and constructing efficient data warehouses, operational data stores, and data marts, and have performed as a lead database designer/modeler and application specialist with direct responsibility for managing project teams. I'm adept at translating business needs into physical design specifications and providing quality deliverables that exceed client expectations.

Skills

• Extensive data warehouse design and modeling experience Star and Snowflake
• Widespread experience with tools utilized in all phases of Business Intelligence development ETL, database design, reporting, etc.
• Providing detailed assessments of multi-system data integration efforts
• Gathering complex user requirements and translating them into detailed design specifications
• Analyzing source and target data relationships
• Extensive knowledge of data quality and Master Data Management techniques
• Full system life cycle testing unit, system, string, integration, and user acceptance testing
• Strong communication and interpersonal abilities

Professional Experience

Confidential

Responsibilities

• Responsible for the oversight of Business Intelligence, Data Warehousing, and Data Management initiatives across a variety of hardware and software platforms.
• Solely responsible for managing/overseeing the development and delivery of all data files sent to external interests outside of WellPoint. This required overseeing numerous offshore developers and making sure internal resources database, Informatica, FTP were used in a way that best leveraged corporate software/hardware.
• Responsible for managing/ resolving all of the production Lights On issues for the Information Management department. This required working with numerous business units to understand/document their issues, creating/managing numerous detailed cross department project plans, and driving all project plans to completion for each issue. Under my guidance and leadership, the number of ongoing active issues very quickly went from over forty to less than four.

Environment: Teradata, SQL Server, DB2 UDB, Business Objects, ERwin, Informatica

Confidential

Responsibilities

• Managing a team of seven DBA's 3 for Teradata, 1 SQL Server, 1 Oracle, 1 Sybase, 1 IDMS , six to ten ETL developers the size of this team varies based on project demand , five data modelers, and a support team of seven.
• Support all functions for the Enterprise Data Warehouse in Teradata design, build, modification, maintenance, data loading, support, etc.. .
• Provide application DBA services for a wide variety of OLTP systems that reside on SQL Server, Oracle, Sybase, and IDMS.
• Supported thousands of users and hundreds of reports across all organizational units and business functions by maintaining an active and trusted business intelligence environment

Environment: OBIEE reporting suite, Teradata, Oracle, SQL Server, Sybase, IDMS, DataStage, ERwin

Confidential

Responsibilities

• Developing the vision and strategy for an integrated enterprise data warehousing initiative ODS, DW, DM's .
• Managing a team of DBA's, ETL developers, data modelers, and report writers in the design, build, and implementation of the Enterprise Data Repository to support numerous Business Intelligence activities ranging from data mining, traditional Business Intelligence reporting, real time reporting, scorecarding, dashboards, etc..
• Formulating enterprise standards in the following areas: Project Management, Enterprise Reporting, Enterprise Data Architecture Modeling logical and physical , Metadata, data security, and Extraction Transformation Load ETL routines.

Environment: SQL Server, Business Objects, SSIS, ERwin

Confidential

Responsibilities

• Creation and administration of weekly, monthly, and adhoc reporting for the Retail Line of Business which assists with monitoring and driving balance sheet growth Campaign Management, Deposit Activity, Overdraft, Rate Analysis Tracking, StaffSmart, Balance Trending, Month Over Month Variances, Account Migration, New Money By Product, Product Tiering, Product Trending, New and Closed Account Tracking, etc. .
• Liaison for the Retail LOB with the Enterprise Data Management Group to coordinate all Business Intelligence and Data Warehousing activities. This has led to significant architectural/application changes and numerous project initiatives that have, and will, significantly increased Retail's ability to monitor key business drivers and performance indicators.

Senior Data Warehouse Architect

Responsibilities

• Independently captured business requirements and then designed, built, documented, and placed into production numerous departmental Business Objects Unviverses.
• Acted as the point person for all incoming Universe Change Requests Received requests, contacted the client to complete the requirement gathering process, updated the Change Request with pertinent information, represented the Change Request work effort within Data Delivery, and personally completed a majority of the incoming Change Requests. .
• Created a Production Control report that assisted with the monitoring of key IBM DataStage jobs by tracking the number of records that flowed in and out of each transformation in a DataStage mapping.

Environment: Hyperion Enterprise, Business Objects, Essbase

Confidential

Responsibilities

• Project Manager leading a team of eight in the deployment of an Agency reporting system that allows Agencies and their Territory Managers to track performance against plan.
• Developing the vision and strategy for an integrated enterprise data warehousing initiative ODS, DW, DM's .
• Formulating enterprise design architectures and standards in the following areas: Enterprise Project Management, Enterprise Reporting, Enterprise Data Architecture Model logical and physical , Metadata, Security Strategy Framework row-level , Extraction Transformation Load Informatica .

Environment: Unix, Oracle, DB2, DB2 UDB, Informatica, ERwin, Brio

Confidential

Data Warehouse Consultant

Responsibilities

• Team leader of three consultants with responsibility for manually writing sophisticated ETL routines in SQL to pull data from PeopleSoft and the budgeting and forecast database.
• Providing data integration and mapping services to assimilate Actuals with Forecast and Budget data.
• Took lead role in product development by translating business requirements of users into product design specifications.
• Designing, customizing, and implementing a web based Brio reporting system to produce financial income statements and balance sheets for both internal and external reporting.

Environment: Unix, NT, Oracle, Cognos, Essbase, ERwin, Brio, PeopleSoft

Confidential

Data Warehouse Consultant

Responsibilities

• Creating and scheduling complex ETL extraction, transformation, and load routines containing numerous source types flat file extracts, pulls from numerous relational databases , transformation types Aggregator, Filter, Expression, Joiner, Lookup, etc. , and mappings utilizing Informatica PowerMart Designer and Server Manager.
• Designing and developing Verizon's Subscriber Line Usage Study System reports and reporting architecture with Seagate Info Desktop and Crystal Reports.
• Working with DBA to design partitioning and summarization strategies.

Environment: Unix, NT, Oracle, Seagate Info 7 Product Suite, Crystal Reports, ERwin

Confidential

Data Warehouse Consultant

Responsibilities

• Working in conjunction with executive project sponsor to prepare project plan / timeline.
• Developing and revising phased production of a logical, dimensional, and physical model.
• Interfaced daily with client Directors, Managers, and various development teams to review project status and coordinate project related multi-departmental activities.
• Designing and implementing a datamart to support an Executive Information System for Clorox, in addition to, leading a development team in creating and implementing Clorox's EIS using MicroStrategy's DSS Web.

Environment: Unix, NT, Oracle, ERwin, MicroStrategy

Confidential

Data Warehouse Consultant

Responsibilities

• Providing a detailed product comparison and recommending a best-fit DSS product based on client's functional reporting needs and growth estimates.
• Designing the Enterprise Data Warehouse Model to assimilate numerous financial reporting environments from recently acquired companies into a single financial reporting system.
• Designing, creating, and populating a datamart to demonstrate a proof of concept reporting environment utilizing Business Objects.

Environment: Oracle, Unix, NT, ERwin, MicroStrategy, Business Objects, Actuate, Adaytum, Confidential

Data Warehouse Consultant

Responsibilities

• Manually writing sophisticated ETL routines in SQL incorporating complex business rules data filtering, aggregation, conversion, joining, etc. .
• Providing expertise in database indexing and SQL coding to optimize database load routines.
• Providing recommendations to enhance current MicroStrategy reporting environment and assisted with the implementation of these recommendations.

Environment: Oracle, Unix, ERwin, MicroStrategy