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