OBJECTIVE:

Seeking a local role in Houston, either full time or W2 hourly contract (up to 50% travel with expenses paid, direct vendor only)

SUMMARY:

• Thought leader and practitioner of "business driven IT", focusing on the data strategy that will provide a competitive advantage, with the framework of Data Governance, Data Science, Enterprise Information/Data Architecture & Business Architecture, Data Modeling, Data Warehouse/BI, Data Management best practice with change control process, Project Management, Agile/Scrum methodology, SDLC, Process Improvement, Organizational Change Management
• Hands on design of Data Architecture for OLTP and OLAP systems.
• Facilitate modeling session with SMEs to ensure total business alignment, leading IT resources to implement data integration/migration.
• Familiar with Python, SAP HANA 2.0.

EXPERIENCE:

Confidential, Spring, TX

Data Strategist/Data Architect Consultant

Responsibilities:

• Per request from Enterprise Data Enablement Manager, provided Data Modeling and Process Modeling/Data Flow Diagram principles (To - do and Not To-do), included top-down and bottom-up modeling approaches and best practices
• Created strawmen of taxonomy and ontology for particular subject areas, to demonstrate how it would clarify the ambiguity of enterprise data semantics (For example, Location, Facility, Party.. .etc.)
• Advocated enterprise data strategy to drive taxonomy and common semantics, to govern and harmonize all kinds of data (master data, reference data, transactional data, data lake, SAP data, big data.. .etc.) . Created Business Enterprise Data Model proposition, with roadmap and strawmen to demonstrate Business Enterprise Data Model with taxonomy, to advocate for Data Ownership, Data Stewardship, and Data Governance. Cultivated culture change, to embrace top down data modeling approach (one subject area or capability at a time), to ensure business alignment, and govern change control process.
• Collaborated with IT Business Architect/SME from different capabilities, evangelized small victories of Enterprise Data Model as building blocks, that would facilitate common semantics, to provide enterprise data entities to enrich the reference architecture content ( Software AG’s Alfabet tool) .
• Established data strategy for downstream data integration initiative, based on current assessments and integration needs
• Created Conceptual Data Model for 3 different downstream subject domain areas, to demonstrate how the model served as the communication vehicle, to facilitate common semantics, as the baseline for data integration

Confidential, Houston, TX

Senior Enterprise Data Architect

Responsibilities:

• Collaborated with Product Owner and Business Analysts to groom user stories to clarify the explicit detail of Acceptance Criteria (including business rules and data requirements).
• Participated in daily scrum meeting, estimation, and demo, for the 2 weeks sprint deliverable.
• Created data architecture and collaborated with Enterprise Architect and Project Development team, for each sprint’s deliverable, and updated the backlog progress using Microsoft Team Foundation Server
• Initiated RACI framework to collaborate LOB IT resources with corporate Data Quality Manager, to bring clarity and order to the Data Quality initiative, and increase effectiveness and efficiency by 80%
• Provided data architecture in-take process and mentoring others on the team
• Established Data Strategy and Data Architecture Intake process in the LOB Enterprise Data Management team
• Provided mentoring to the Data Architecture team, using data modeling technique to facilitate the communication that translates business rules into data schema, using Erwin (data modeling tool) to create Conceptual/Logical/Physical Data Models, as well as metadata management
• Strategized solutions to enhance existing system's data architecture, to meet the user demand from the Agile team (using data model to facilitate the business needs and technical data enhancement).
• Translated business rules into Conceptual/Logical/Physical Data Models, generated ddl and implemented tables in SQL Server database

Confidential, Houston, TX

Data Architect Consultant

Responsibilities:

• Worked with Agile methodology, participated in Sprint Meeting with Agile team and manager/stakeholder to groom User Stories and provided updates in TFS.
• Created data architecture for the target data warehouse schema analyzed 3 different sou r ce systems for the data integration needs, and created data mapping specification (for each source to target mapping) for ETL development.
• Collaborated and managed deliverable of Teradata DBA and 3 ETL Developers, for the overall progress and deliverable, and completed project with aggressive timeline
• Promoted using Epics (highest level of User Story) and User Stories to capture business requirements and ensure business and IT alignment
• Worked with business stakeholders for business and data strategy to improve data quality, in order to report valuable information from BI/DW

Confidential, Houston, TX

Techn i cal Consul t ant (Da t a Management)

Responsibilities:

• Provided technical consulting and data architecture for Canonical Model, proposed Data Governance and Data Stewardship program, for the Common Ground program
• Facilitated SMEs' input to create Canonical Logical Data Model, to drive synergy with common semantics and taxonomy, to instantiate a virtual database that integrates enterprise petro-technical data
• Proposed Business Architecture and cross functional work flow, to include the “information flow” that correlates to the data integration needs
• Advocated correlation of bottom up data integration needs with the top down business requirements as EPICS, User Stories, and Acceptance Criteria (confirmation with business rules), to ensure IT implementation is meeting business needs, with agile modeling practice
• Promoted Common Ground Program via Expo and Brown Bag sessions

Confidential, Houston, TX

Sr. Information Modeler

Responsibilities:

• Evangelized Data Governance framework for Data Driven Accountability Program
• Developed working plan and data architecture for Business Intelligence bake-off project, engaged SMEs from different teams and rationalized different perceptions while capturing common semantics in the data model
• Established Enterprise Data Model and taxonomy, to derive master data
• Developed the framework of End-to-End Message Rationalization Process, to review and standardize online messages utilized by different applications, promoted consistency among various applications throughout the enterprise. Developed the “generic message” concepts in the framework, which using variables instead of hard coding messages, reduced 80% of translation cost and overhead

Confidential

Senior Associate/Data Architect

Responsibilities:

• Provided advisory consulting to validate findings for the mainframe cost reduction initiative
• Assessed current situation with data quality issues, provided recommendation for the future plan to address root causes, including roadmap for data governance, business and data architecture, data governance committee, data owners, data stewards, and enterprise information management with change control process.
• Recommended creating enterprise data model with metadata and data life cycle (CRUD), as well as enterprise business process with RACI, to demonstrate total transparency.
• Researched on various public and private sectors that have data quality issues, and their action plans to resolve these issues

Confidential, Houston, TX

Senior Data Architect /Enterprise Data Architect

Responsibilities:

• Worked with Enterprise Architecture team to come up with the meta model for Enterprise Architecture utilizing TOGAF framework (Business Architecture, Information/Data Architecture, Business Application Architecture, and Technology Architecture).
• Evangelized and advocated the enterprise information best practices. Developed and presented a framework of Data Governance (including Data Owner, Data Stewardship, SME, Data Modeler ... etc.), to improve enterprise business process and data transparency. Proposed creating and maintaining business process models and data models at application level and enterprise level, with common semantics and change control process, for the holistic view of the corporation. Proposed forming a Data Architecture group to enable long term change control process and synergy with Data Governance program.
• Established Information Forum to mentor other Data Architects/Data Modelers/Database Architect from various departments, facilitated weekly knowledge sharing, information sharing, collaboration, in order to drive synergy and conformed data strategy. Provided cross functional leadership by mentoring and developing Data Architecture team within Application Architecture group. Reviewed Application Data Architecture Handbook and provided feedback, mentoring and cultivating the interaction between Business Architect, Enterprise Data Architect, Application Data Architects, and DBAs.
• Developed data architecture principles, data model standards, and change control process. Provided oversight to different IT groups and contractors to adhere to the process and standard. Provided data modeling training across the organizations, coaching and mentoring new data modelers in the organizations and offshore contractors. Developed enterprise standard abbreviations as the naming convention of Erwin data model (nsm file). Developed data model template with the embedded standard abbreviations, which will save 90% of data modeling time, by having the tool to automatically abbreviate the attribute name in the logical model view to the column name in the physical model view

Confidential, Hartford, CT

Senior Data Architect

Responsibilities:

• Reinforced change control process and collaborative effort, between Data Management team and Application team, to govern the consistent data schema between the data model and database
• Facilitated working sessions with the Subject Matter Experts (IT technical director and business lead), discussed leading questions to drive the best solutions with the long term strategic goals, for the Electronic Payment System, which innovatively provided the payer portal capability--from “payer specific payment solution” to a “multi-payer product line”. Captured business needs and requirements to develop data architecture that yielded long term ROI, including conceptual data model, logical data model, and physical data model. Interfaced with DBA for access modeling (considering performance and access patterns), and generated ddl as data schema reference for the DBAs.
• Investigated DB2 issues within Erwin, worked with Computer Associates for these issues, suggested and justified “design enhancement” for the next release of Erwin (r7).

Confidential, Boise, ID

Information Architect

Responsibilities:

• Developed data architecture for asset management system. Worked with the enterprise data group and application team, to ensure proper data governance policies were being followed. Participated in the data model review with IARC (Information Architect Review Committee), when the proper Data Stewards of the appropriate subject areas will be able to review and approve the model, or disapprove for further modification.

Confidential

Technical Manager

Responsibilities:

• Educated IT leaders on the concept of data integrity and relational database, data management best practices, including utilizing data models, data flow diagrams, and business process models. Scheduled reoccurring meetings to interview “Subject Matter Experts” to create data models for the reporting database of YMS team (‘Yield Management System’). Created Microsoft Project Plan with the work-break-down structure, to include all the activities with the milestones
• Provided consultation for the needs of data warehouse, data mart, and enterprise data model, which will help to identify problematic areas and increase yield rate in the manufacturing process

Confidential, Plano, TX

Information Analyst/Data Modeler/Data Architect

Responsibilities:

• Utilized Erwin to create the logical data model and derive the physical data model, worked with the DBA of the particular DBMS platform to fine tune the physical data model (in Oracle, DB2, Sybase, SQL Server.. . etc.)
• Worked with Technical Team and Business Team for Confidential Service Excellence Dashboard, which would enable Confidential to become a portfolio management company with a competitive advantage. Analyzed existing logical data model and various versions of enhanced physical data model (based on different initiatives). Analyzed and consolidated the important entities from various enterprise applications to create a merged version of enterprise data model (As-Is version). Performed Gap analysis to identify discrepancy among various enterprise applications. Reviewed the gap with managers to resolve the discrepancy and rationalize the differences to create the To-Be version of the enterprise data model
• Gathered requirements and business rules by interviewing the Subject Matter Experts, scheduled modeling sessions to guide the SMEs, to obtain business rules and define data elements. Created both the logical data models (created subject areas with entities and attributes, established relationships among entities) and physical data models (with proper de-normalization, data types for the appropriate database platform, performance optimization with indexes), for a Credit Union application rewrite (conversion from flat tables in a proprietary database to SQL Server relational database for the .NET application)

Confidential, Plano, TX

Information Analyst/DBA

Responsibilities:

• Provided 24 by 7 on-call DBA support for customers with Sybase databases. Worked with development team for object changes on the database. Worked with people who monitored the nightly batch job cycle, to resolve production problem or backup failure
• Provided database administration with Sybase DBMS and SQL Server