SUMMARY:

• Results - oriented, Data Architect Professional with diverse data management expertise utilized to successfully develop, integrate and manage global and virtual solutions to support broad-ranging operations and organizations. Execute data architecture principles through the development and maintenance of formal descriptions of the data and data structures e.g., data definitions, data models and dataflow diagrams. Proven ability to exceed expectations and develop solid relationships with internal and external clients to execute the following competencies’;
• Architecture/Development - As a Chief Data Architect, established and managed the governance process for sharing data across multiple directory environments and the Global Integration Factory. Yvette also implemented the data architecture layer by implementing a model repository. Because of centralizing the models, it increased the reuse of existing data and improved development time of applications. Also possess experience developing business rules and data relationship definitions using a variety of techniques and artifacts, conceptual and logical database modeling. Have designed and built database systems and repository databases and performed testing, report development, database system troubleshooting and administration. Reduced duplicated work efforts and work products by coordinating the integration of the overlapping work products with the other Enterprise Architecture Teams, thus reducing project cost and increasing efficiency.
• Data Analysis/Development - as a Data Analyst Yvette drove the taxonomy and common attributes across document management and the web content and reduced cost by leveraging project deliverables across multiple projects. Yvette conducted data profiling across multiple integrated platforms to improved data quality and drive data standards across the enterprise.
• Program Management - lead global deployments of up to $6MM; managing scope, finance, and timelines in support of Identity Management and Access Management Applications, Infrastructure, and Collaboration Services.
• Data Management and Database Design
• Identity Management
• Information Management
• Program Governance
• Vendor Relationship Management
• Group facilitation, presentation and teaching skills
• Content Services
• SLA Management
• Program Management
• Collaboration Services

TECHNICAL SKILLS:

Tools: & Methods: CA Platinum, Rochade, Popkin System Architect, ERwin Suite, Multi-Dimensional modeling, Star Schema, DB2, Oracle, LDAP, LiveMeeting, SharePoint, Dream weaver, Quickplace, Documentum, Pinnacle Studio, PVCS, Microsoft Office, Lotus, SQL, PL\SQL, Identity Manager, ADFS, Web Logics, CMMI, SDLC AIX, Unix, Mainframe, ENOVIA, Citrix, JRIA, Scrum, Tortoise Subversion, Clarity, SQL Server Management Studio, SQL Server DB, Visual Studio, CA Software Change Manager, SharePoint Designer, InfoPath, MySQL, PHP, Zend Framework, BMC Utility, Toad Data Modeler, SQL Loader, SQL Developer and Data Modeler, Excel VBA, eclipse, TomCat + Ant, Hadoop - Hive, Informatica

: SDLC, SDP, eBusiness, SupplyChain Mgmt, Data Warehousing, Harvard Manage Mentor, XML, Object Oriented Methodology/UML, Client Server Database Design, Master Data Management, Project Management, Developing and Facilitating Business Rules Management, Enterprise Life Cycle (Catalyst Methodology), CMMI, Technical Fundamentals of Documentum, Publisher, Portals and Content Management, TOGAF, PMP Part I, Network Security and Firewalls, ORACLE SQL Expert, Metastorm ProVision & Knowledge Exchange, Scrum, TDWI Business Intelligence, IBM University - Big Data, Hadoop, Informatica Enterprise Information Catalogue & Information Data Lake

PROFESSIONAL EXPERIENCE:

Confidential

Data Governance Analyst

Responsibilities:

• Facilitating and managing the Data Governance and Data Issue Management Forums
• Designing Taxonomies to support the Order to Delivery, Manufacturing and Purchasing Data Lakes
• Defining, designing, and creating structures and master data structures using Hadoop
• Modified and managed the Data Governance SharePoint site

Confidential

Oracle DBA - Solutions Architect

Responsibilities:

• Designed, built, loaded, tuned and maintained an ORACLE 11g database utilizing Toad Data Modeler, SQL Developer and SQL Loader
• Provided the availability of data to enable managing capacity across several wireless sites for the Midwestern region
• Developed an interface utilizing Microsoft Visual Studio to enhance the reporting and user experience with the Verizon planning information
• Enhanced the user experience with the Business Intelligence(BI) data by transitioning Visual Studio to IBM’s eclipse business intelligence tool

Confidential

Data Architect

Responsibilities:

• Develop new data structures in online transaction (OLTP) and data warehouse (OLAP) databases
• Develop conceptual, logical & physical data models
• Create, Review and Audit Database Change Requests and Data Definition Language (DDL) to implement, tune and maintain database structures i.e. DB2, Teradata, Oracle 11g & SQL Server
• Formalize data propagation requests to populate and maintain test environments
• Maintain GDD (Global Data Dictionary) information provided by customer such as column and table descriptions

Confidential

Database Developer

Responsibilities:

• Design, implement enhancements to multiple PHP applications and MySql databases in support of the Dean’s office of International Studies and Programs
• Cleaned existing data and modified MySql databases

Confidential

SR. Solutions Architect

Responsibilities:

• Define, implement and drive aspects of the Information Management Strategy
• Developing an Information Management Catalogue utilizing Erwin, SQL Server Management Studio 2012, SharePoint Designer, InfoPath and Visual Studio technologies
• Initial implementation of the Information Catalogue will consolidate over 20 Enterprise Architecture lists and consolidate over 140 surveys; that request information about the applications, technology, security, networking and support required to run the applications
• Designing a DB2 database repository to support mortgage loan reporting to the Federal Reserve Board while optimizing the manual management of data from external services, COBOL programs and internal processes

Confidential

SR. Data Architect/Solutions Architect

Responsibilities:

• Extended data warehouse model to support additional business intelligence reporting; utilizing Erwin, SQL Server Database platform
• Integrated various sources of Human Resources data to create a Global Common Profile to support the Heinz Global SharePoint Solution
• Developed multi-dimensional and relational models to support the financial management warehouse systems to support the supply chain management of the development of the automotive products and support utilities analytics; utilizing Erwin, SQL Server Database platform
• Developed star schema models to monitor and forecast the financials required for the manufacturing and quality management of the interior and exterior auto supplies; utilizing Erwin

Confidential

Program Manager

Responsibilities:

• Managed the deployment of Live Meeting across 140k user accounts, eliminating the use of WebEx thus saving $3+M/ year
• Drove the data clean-up before the Quickplace Migration eliminating the inactive websites and users therefore gaining a 50% return on investment before the start of the migration
• Drove the implementation of the Identity Manager which synchronized passwords for 130K+users thus decreasing Service Desk calls for password resets by 20% at $15 a call
• Drove block point releases of functionality and infrastructure for SUN Identity Manager
• Established and managed the governance process for sharing data across multiple directory environments and the Global Integration Factory (ORACLE database platform)
• Implemented a model repository changing the number of shared data models from 3 to 150. The centralization of the models increased reuse of existing data and improved development time of Oracle applications
• Drove the taxonomy and common attributes across content services and meta repositories
• Co-Chairperson and stakeholder of the EMC Vendor Relationship Management Council, Global Document Management (GDM) (Documentum/Oracle) and GDM Focus Team and the GDM Governance Team
• Created and facilitated monthly global forum for 40+ data architects, developers and business SMEs to leveraged data warehouse knowledge organization wide
• Designed and defined the personal data within the Service Oriented Architecture for distribution to the various process area LDAPs
• Realized return on investment of up to 50% of project cost before full project implementation
• Implemented and managed an Application Process for Web Applications accessing LDAP, to ensure compliance with Corporate standards and increasing the use of common id and passwords across applications
• Managed and integrated various business area deliverables from applications, infrastructures, and operations to create common processes for using LDAPs
• Developed and implemented corporate policies and standards for Global Data Management across multiple platforms
• Implemented applications and process oriented data models
• Managed and architected data for Data Warehouses, OLTP applications, LDAP and Active Directory
• Developed strategy for an integrated supply chain Oracle data warehouse.
• Deployed meta directory to implement and promote the interoperability and integration of common data sources
• Mentored architects and developers

Acting Data Architecture Team Lead

Confidential

Responsibilities:

• Developed the following artifacts to implement the Internal Revenue Service Data Management Strategy; business rules, shared data entities, data security policies and procedures thus providing data for interoperability and sharing
• Reduced duplicated work efforts and work products by coordinating the integration of the overlapping work products with the other Enterprise Architecture Teams, thus reducing project cost and increased efficiency
• Specified the baseline quality standards for project level data products and procedures

Corporate Data Sharing Team Lead

Confidential

Responsibilities:

• Facilitated collaboration with executives, stakeholders and external agencies to promote opportunities to further align the Enterprise Information Architecture across the corporation and other federal agencies
• Implemented strategic planning and cost avoidance mechanisms for new systems and system enhancements utilizing the Enterprise Architecture
• Worked with the Business Owners to execute operational, tactical and strategic developments of the Data Stewardship Program and the Corporate Data Sharing Project

Database Analyst

Confidential

Responsibilities:

• Developed, maintained and executed a Project Plan to monitor a data migrationproject to provide access to Confidential data from the ADABAS platform to the Sybase platform in order to populate the Enterprise Corporate Repository
• Conducted performance tests of Sybase Middleware Products for the Confidential

Senior Data Analyst

Confidential

Responsibilities:

• Validated and implemented logical data models to ensure compliance with the corporate data management standards, to support the Re-engineering and development of applications and data warehouses