An information Management Professional with Oracle technical/development background.
Los Angeles, CA 90035
Summary of Qualifications:
Enterprise Information Management professional with 20 years of integrated experience in:
Information and Data Architecture
Knowledge Management, Enterprise/Canonical/Conceptual and
Application (Navigational/Relational/Dimensional/NoSQL) Data Modeling
Information Product and Solution Architecture
Master Data Management (MDM)
Data and Data Warehouse/ETL/Quality Assurance
Team Leadership in Information Products, Services, and Data-related Software Development, Advanced Database Application Development, and (oracle) SQL Performance Tuning within Government, large scale Enterprise Architecture and Planning (SDLC/ITIL), as well as within Agile and Outsourced Development Environments.
Project Coordination and Entry Level Project Management
Tools and Methodologies Utilized:
Enterprise Architecture/Metadata Management:
Sybase Power Designer
Open Text ProVision
Data Modeling (principles and techniques outlined by the DAMA DMBOK 1st Edition):
oracle Designer 2000-10g
TOAD Data Modeler
Quest SQL Navigator
oracle SQL Developer Modeler.
Relational: oracle (versions 6-12c), MS SQL Server 2005/2008 R2/2012, IBM DB2 UDB, MySQL, Postgress 9, Teradata 13
NoSQL: MongoDB, Lexis Nexis proprietary Data Analytics Supercomputer (DAS) high performance clustered MPP (Multi-Terabyte/Petabyte Massive Parallel Processing/MapReduce) NoSQL platform
BI and Reporting Tools(following Bill Inmon,Ralph Kimball and dynamic data-fusion based methodologies):
SAP Business Objects
MS SSAS 2008
Informatica PowerCenter 9.x
Microsoft: SQL Server 2008/2012 SSIS
Data Quality Tools:
Informatica Analyst/ /Informatica Data Quality
Master Data Management Tools:
Business Analysis (following principles and techniques outlined by the IIBA PMBOK V2 and Agile Project methodology):
Requirements Elicitation, Requirements Analysis and Engineering,
Solutions Assessment and Validation,
Technical Documentation utilizing MS Visio,
UML Use Cases
Hands-On Programming Languages:
SQL (Any ANSI:2008 compliant flavor)
Unix/Shell Scripting/Utitilies (Korn, Bash, sed, awk)
Enterprise Knowledge Works
Information Management Consultant
In Support of an emerging Financial Advisory and Insurance Services Portal
Instrumental in incorporating the following Information Management disciplines into Product Development practices:
Synchronization between Data, Object(Class) Models, and internal and external Information Exchange Interfaces based upon common element(attribute) definitions.
Glossary of Business and Product Terms augmented by Lineage/Traceability of data elements as they move across the information supply chain.
Security education and proposed set of (Information Security) policies focused on human factors.
Security/CRUD and Enterprise Search/Documents Retrieval (ACL, Suggested Query Terms trimming) needs assessment and optimization base upon Business Value Classification
Roles, Responsibilities, and Accountabilities/Ownerships Mapping to Each Stage of Information Lifecycle.
Co-Designed Interlinked Data Lake based Master Repository as a base of Platform’s Risk assessment and advanced Analytics capabilities.
LA Care Health Plan
September 2014– June 2016
Enterprise BI Solution Architect and Product Development Lead
In Support of the Company’s Transformation Strategic Objectives of increasing Health Care Providers accountability, and developing Enterprise Information Integration (EII) Architecture and a single On-Demand Self-Service Platform for all Operational, BI, and Analytics needs.
Initiated, researched/developed into the mainstream activities, influenced, lead, or contributed to the following improvements to the existing Enterprise Data Architecture and IT Services and Processes:
Re-purposing of the newly developing (3NF) Enterprise Data Warehouse Data Model into the Enterprise Canonical Model.
Establishing the Template for the Enterprise Glossary while extending its Metadata to include topics such as Purpose/Business Triggers, Security (Classification/Access Rights), Compliance, Quality Requirements/Quality Checks, Authoritative Sources, and Data Lifecycle.
Mentorship on the topic of Creating High Quality Business Definitions to the variety of audiences as a part of the Data Governance Training Program.
Lead Design and Prototyping of the H(ealth)L(evel)7 Informatica /ETL – based External Data Ingestion Framework in support of risk mitigation for “at-rest” an