We provide IT Staff Augmentation Services!

Enterprise Data Architect Resume

2.00/5 (Submit Your Rating)

SUMMARY

  • An accomplished IT professional with over 20 years of comprehensive experience in all aspects of system development life cycle (SDLC) and project management.
  • Diverse experience in the areas of systems analysis and design, data modeling, business intelligence & data warehousing, systems integration & testing, performance tuning, and systems administration.
  • Highly skilled in managing technical teams in multi - cultural business environments across wide range of industries including financial, petrochemical, manufacturing, housing, insurance and education.
  • Excellent communication and interpersonal skills to develop rapport with teams and business stakeholders.

TECHNICAL SKILLS

  • ODS Relational, OLAP Dimensional Modeling
  • Application Design/Capacity Planning / Disaster Recovery Planning / Migration Road Maps
  • Cognos
  • Actuate
  • Microstrategy
  • UNIX, Linux, Window, MAC
  • Claim processing, Membership, Billing, Case Management
  • Provider, Plan Product, Finance, Employer Groups
  • ICD codes, HIPPA Compliance, Health Care Reforms
  • Pharmacy, CCMS, Hedis, FACETS
  • Oracle 7.0/7.3/8.0/8 i/9i,10g,12g
  • Netezza
  • Teradata
  • SQL Server
  • Hypersion Essbase
  • Data Stage
  • Informatica

PROFESSIONAL EXPERIENCE

Enterprise Data Architect

Confidential

Tools: Erwin, Cognos BI 10.1, Oracle 11g, Cognos Sdk

Responsibilities:

  • Developed data and metadata policies and procedures for structural design and development to build, maintain and leverage the data model ensuring integration with corporate data standards
  • Defined and governed data warehouse best practices and standards to include software development practices, design styles and Naming Standards.
  • Architected and implemented high quality Data Warehouse solutions using company approved platforms such as Data stage, Oracle and Cognos.
  • Provided migration and implementation plans that addressed both tactical and strategic needs.
  • Analyzed technologies, technical processes and/or functions, document findings, identify areas for improvement and created specifications
  • Facilitate the discovery of entities, attributes, relationships, and business rules from the functional experts and the user community
  • Developed conceptual (canonical), logical, entity/relationship data models for medical management (Utilization, Case Management, Authorization and Codeset) by using Erwin Molder tools and Visio.
  • Mentor other team members on new and existing technologies and helped/guided ETL/Reporting development teams.
  • Developed Business terms and Datadictioneries for the end users and development teams
  • Define target state and the alignment of business objectives with data management strategy.
  • Establish and implement technology direction, standards and procedures to optimize data management architectures, reliability and performance
  • Profiled the source data and modeled BI domains in ERWIN. Led the source data analysis effort to conform dimensions and facts
  • Architected the subject ares such as provider,claims, products/plans, membership to make them available to the enterprise, rather than to a few applications. Established and modeled domains for providers, facilities, coverage groups, plans, and line-of-businesses from multiple sources including proprietary databases and the TriZetto (Facets Extended Enterprise database).
  • Developed target data architectures for reporting, analytic, and business intelligence functions from internal and external data sources.
  • Mentor other team members on new and existing technologies and helped/guided ETL/Reporting development teams.
  • Provided the expert level guidelines for “Healcare Reforms” implementation and extracts for downstream systems e.g Altegra
  • Introduced Master Data Management (MDM) concepts to the organization, including the creation of data standards and founding of a data stewardship group comprised of business and IT managers
  • Mentored and provided technical guidance to the technical development team
  • Produced the DDLs for the database implementations

We'd love your feedback!