We provide IT Staff Augmentation Services!

Business Intelligence Architect Resume

SUMMARY

  • I have over 15 years of experience in the area of Business Intelligence (BI) with multiple implementations in a variety of industry settings.
  • I have modeled and built operational databases and data marts in the Health Insurance, Manufacturing, Education, and Finance Industries.
  • In addition, I have created the metadata reporting models, as well as, designed and written the reports.

TECHNICAL SKILLS

  • SQL Server
  • Cognos Data Manager
  • Framework Manager
  • Report Studio
  • SSIS

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence Architect

Responsibilities:

  • Provide BI best practices and leadership
  • Work with internal and external data stewards and stakeholders throughout the design, development, and maintenance of clients BI systems.
  • Model and Build Star Schema Databases
  • Build and document
  • Cognos Framework Manager Models
  • Cognos Analytics Data Modules
  • Cognos Analytics Reports and Dashboards
Confidential

Data Architect

Responsibilities:

  • Model and build both operational and reporting databases
  • SQL Server 2012
  • ER/Studio was used to model, document, and build the initial star schema
  • Tortoise (Subversion) for versioning
  • Worked with their data stewards and stakeholders throughout the project design and development
  • Worked with their java developers on the development of their operational database for their Consumer Complaints application
  • Worked with their Machine Learning Team to develop their Machine Learning Database
  • Uncovered their previous systems’ business rules within Informatica and applied those rules within their new reporting ETL process
  • Documented the ETL process

Confidential

Data Architect

Responsibilities:

  • Industry: Confidential
  • Lead Data Architect
  • Work with data stewards and stakeholders to apply modeling expertise, Confidential Data Governance standards, and to determine their data and business requirements
  • Model and Build Star Schema Databases
  • Includes analyzing, organizing, and cleansing data
  • Model and Build Tabular Reporting Model
  • SQL Server Analytical Services (SSAS ) Modeling
  • Consumed using Microsoft Power BI
  • Model and Build SSRS and Power BI reports
  • Document and present database designs
  • Metadata documentation utilizing ERWIN
  • Document and set standards for Blue Cross and Blue Shield’s star schema designs, processes, and best practices.

Confidential

Business Intelligence Architect

Responsibilities:

  • Lead Architect for Claims Group Reporting
  • Responsibilities: Model and build dimensional databases
  • Platforms: SQL Server 2008 R2, DB2, Oracle
  • Tools: SQL Server, Cognos Data Manager, Framework Manager, Report Studio, SSIS
  • Database responsibilities
  • Load, Clean, and Transform Data
  • Maintain Data Integrity
  • Create and Maintain Stored Procedures, Functions, Views, Jobs
  • Set Database and Object Level Security
  • Resolve ETL and Reporting Performance Issues
  • Database Size: ~3 Terabytes
  • Lead in Meta Data Modeling
  • Responsibilities: Model and deploy reporting packages.
  • Tools: Cognos Framework Manager
  • Claims Group and Eligibility Reporting Guru
  • Generate reporting templates for iterative report sets.
  • Develop report writers and training documents
  • Performance tune reports when needed
  • Advanced competency level using SQL Server, Cognos Data Manager, Framework Manager, Report Studio, Analysis Studio, Metric Studio, Event Studio and Planning
  • Practices Robert Kimball methodology
  • Recent Accomplishments
  • Redesigned the Blue Cross Blue Shield star schema, a more than 3 Terabyte data mart, into a sleek less than 1 Terabyte data mart while expanding the data mart.
  • Decreased ETL build times from 24 hours to 12 hours.
  • Eliminated the need for cubes and table versions of the star schema.
  • Eliminated grain and cardinality inconsistencies.
  • Greatly improved reporting response times.
  • Increased the data mart's querying ease and flexibility

Confidential

Business Intelligence Contractor

Responsibilities:

  • Industries: Confidential
  • Aid in modeling and building dimensional databases using Cognos Data Manager on DB2 and Oracle platforms
  • Model and publish packages using Cognos Framework Manager
  • Model and build reports using Cognos Report Studio
  • Advanced competency level using Cognos Data Manager, Framework Manager, Report Studio, Transformer, Analysis Studio, Metric Studio, Event Studio and Planning

Confidential

Technical Project Manager / Business Intelligence

Responsibilities:

  • Aid in modeling and building a relational database of healthcare data using SQL Server 2000
  • Modeled and built a dimensional database of healthcare data using SQL Server 2000
  • Modeled and built packages using Cognos Framework Manager
  • Modeled and built finance and accounting healthcare reports using Cognos Report Studio
  • Developed, documented and maintained the operational and contingency policies, procedures and rules for the company

Hire Now