We provide IT Staff Augmentation Services!

Bi Sol Engineer Resume Profile

NY

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

BI Sol Engineer

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

Manager

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

Manager of Business Intelligence

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

Assistant Vice President Retail Administration

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

Manager Business Intelligence Solutions

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

Hire Now