Business Intelligence & Data Architect Resume

SUMMARY

20+ years of hands - on experience applying systems thinking to challenging business problems.
Expert in creating strategy and executing technical roadmaps for data journeys.
Specific experience with modeling for transactional applications, data warehouses, and data lakes (Kimball, Inmon, & hybrids).
Additional experience in software design and constructing for application in business intelligence, analytics, and data science.
Operational skills include project management, product management, cost engineering, accounting, and system implementations/maintenance as applied to both internal and commercial systems.
Strong applied engineering and science mindset in project and operational settings.
Proven ability to work collaboratively with vendors and internal stakeholders on requirements, design, construction, operation, and maintenance of complex technical systems.
Experience and working knowledge of tasks contributing to project success.
Proven abilities in developing and using transactional systems, databases, business intelligence, data warehousing, and analytics/data science solutions.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence & Data Architect

Responsibilities:

Constructed an Enterprise Strategy and Architecture for Enterprise Data.
Created a data store (lake) concept for delivery of data warehouse, streaming, and other data from a variety of sources.
Implemented a business area focused data warehouse using a combination of Microsoft and SAP stack tools from a common ERP.
Modeled and reverse engineered OLTP and Dimensional data From MS SQL, Oracle, MySQL, Flat Files and PostgreSQL. Wrote and implemented ETL/ELT using TSQL, SSIS, and SAP Data Services.
Constructed a rolling product launch campaign to incrementally deliver components of the data warehouse on a priority basis.
Constructed a user accessible Data Catalog and Data dictionary that is maintainable by Data Stewards (MDM Lite).
Supported Tabular models and related reporting from an ERP source.
Provided support and advice on various operations projects.
Provided system support as DBA for select Data Store and Operations servers.

Confidential

Sr. Data Architect

Responsibilities:

Providing strategic and tactical hands-on architecture, modeling, and integration services for transactional and data warehouses in a variety of industries:
Created a transactional database for a combined membership, CRM, and product system for MS SQL and MySQL.
Cleaned and migrated data into the new OLTP structure.

Confidential

Sr. Data Architect

Responsibilities:

Creating, developing, and managing combined clinical and financial data marts for local markets from multiple data sources (flat files, MS SQL, and Oracle).
Contributing to the development of a national data warehouse.
Working with clinical and financial analysts to identify and resolve data issues including BI and analytic issues.
Creating data mart related infrastructure including planning and design for development, test, and production. Also involved in upgrade planning.
Specific Work: As-Is/To-be planning, dimensional modeling, QA, ETL (processes for staging, integration, and production), metadata construction for BI products, and data dictionaries.
Documentation of the above.