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

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