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

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