PROFESSIONAL CAPABILITIES

Confidential has over 20 years of experience, knowledge, and skills in enterprise architecture EA , data management, and providing information technology IT services. Her professional expertise spans strategic planning to tactical implementation, applying her skills and experience in project management, building and sustaining customer relationships, and supporting IT activities in all phases of the system development lifecycle SDLC and operations. Ms. Duque is proficient in all aspects of planning and enabling EA programs that provide business value to the organization. She is a Certified Enterprise Architect from FEAC Institute. She supports various federal agencies, implementing government wide initiatives on IT governance and standards, and incorporating EA practice into organizational and IT management disciplines. She develops strategic plans and roadmaps to guide business improvement and IT modernization initiatives. She has in-depth knowledge of data management DM , improving data quality through data governance standards, methods, and guidelines and realizing cost savings through data sharing and reuse. She applies DM best practices integrated into all phases of the system lifecycle, from requirements definition, analysis, database design/creation, and implementation. Ms. Duque has implemented data warehouses/ data marts with business intelligence BI tools to support data discovery and data analytics for planning and decision-making. She is skilled in metadata and repository management, facilitating knowledge sharing and asset reuse across the enterprise. Ms. Duque is experienced in the application of various IT standards, methods, and procedures, using applicable COTS/GOTS tools, as a senior IT consultant, project manager, and member of the technical staff. She is highly skilled in working with business and technical subject matter experts to identify, define, and analyze requirements, and subsequently, in developing effective solutions that meet/exceed business needs and expectation.

TECHNICAL EXPERIENCE

METHODOLOGIES AND TOOLS SOFTWARE:

• OMB Federal Enterprise Architecture FEA , DoDAF, TOGAF, Zachman Framework, Business Process Modeling BPMN, IDEF0 and IDEF1 , Data and Business Modeling ERWin, BPWin , Oracle Designer, PowerBuilder, CA's Metadata Repository ARDS - CA , Troux METIS EA Tool, System Architect SA Repository, Capital Planning, Project Management, Master Data Management MDM , Federal Cloud Strategy and Implementation

• Microsoft Office Suite, MS Project, Project Workbench, Computer Associate's Info Pump, RiskAdvisor Insurance Data Mart/Business, IBM Cognos Impromptu and PowerPlay business intelligence BI suite, MicroStrategy BI suite, Serena Software's PVCS Change Management

LANGUAGES AND DATABASES: Informatica PowerCenter's ETL , TOAD database utility tool, COBOL, PL/SQL, Unified Modeling Language UML , Oracle DBMS, Microsoft SQL Server, NCR's Teradata, Datacom, Sybase, IBM's DB2 and UDB

PROFESSIONAL EXPERIENCE

Senior Enterprise Architect

Ms. Duque currently supports the enterprise architecture EA and data management DM programs at the U.S. Department of Housing and Urban Development HUD . She supports the EA and DM programs in planning, defining, and enabling management and governance processes to accomplish client's mission and objectives. She leads the contractor team in performing analyses and recommending solutions to support business transformation. She provides guidance on regulatory and administrative mandates to ensure compliance and adherence to OMB and GAO directives and guidelines. Ms. Duque provides value-added support and services in the following capacities:

• Led the development and completion of HUD's Enterprise Roadmap, which guides HUD's IT reform initiatives, using OMB's FEA Common Approach framework and reference models. The effort involved the restructuring of business segments and aligning the IT investment portfolio to the new business architecture, and creating lines of sight to HUD's mission, goals and objectives. This effort also resulted in IT savings with the identification and retirement of obsolete and/or redundant IT systems and services, migrating commodity IT toward shared services and cloud computing. The Department ranked at the top 5 of OMB's Enterprise Roadmap submission scorecard for relevance and composition.
• In collaboration with business and technical staff, completed the restructuring HUD's business segments and realigning the IT investments to the new segments. This effort ensured a direct line of sight of the IT investments to HUD's strategic and priority goals. Through this process, identified redundant systems 18 of 268 systems to be decommissioned, resulting in cost savings and cost avoidance of over 8.5M, recurring annual cost, while defining total cost of ownership TCO for HUD's IT systems and services.
• Planned and coordinated the completion of HUD's Target EA document, which depicts HUD's desired future to-be IT services to better serve our citizens. This involved defining HUD's current environment, identifying desired business needs gaps , and strategy towards shared services and on implementing HUD's cloud first policy. In collaboration with key stakeholders and the integrated project teams, the Target EA encompass the performance, business, data, systems/applications, and technology architecture layers, reflecting the desired future business and technical environments for the Department. This effort involved the establishment of HUD's Architecture Working Group AWG to oversee EA segment governance, and the creation of the AWG Charter to define its mission, roles, and responsibilities.
• Developed and implemented the HUD Segment Architecture Methodology HSAM to develop segment architectures and create modernization blueprints for prioritized transformation implementation. This effort involved training the EA staff to ensure comprehensive knowledge and application of the methodology. The significant results of this effort include the development of HUD's core segment architectures that aligned with HUD's Target EA and complied with OMB requirements. The EA Segment Reports created for each business segment are used in the FY2014 Budget Formulation, supporting the IT Investment Management ITIM staff in performing its Capital Planning and Investment Control CPIC process.
• Provided EA guidance in all phases of project management PM lifecycle, promoting data sharing and re-use of existing HUD capabilities and services. In collaboration with other OCIO and business teams, established a new OCIO IT management and governance processes to improve IT portfolio management. Integrated HUD EA practice into OCIO's IT strategic planning, IT budget formulation and capital planning, system development lifecycle SDLC , security/ risk management, and IT acquisition.
• Continued design and deployment of the EA repository IBM's System Architect , and enable sharing and re-use of EA artifacts for project support and decision-making. This effort involves defining the repository framework, establishing naming standards, prioritizing functionalities and usage, and worked with subject matter experts and knowledge workers to validate repository contents. The repository provides relevant information to support decision-making and reuse of EA artifacts for planning. It is used as the central information storage for HUD's enterprise, segment, and solution architectures.
• For the Enterprise Information Management EIM program, developed the strategic and implementation plan to guide the data architecture and operational data management activities. The EIM program aims to identify HUD's data assets, improve data quality, and promote data sharing and leveraging of data assets across HUD, with other federal agencies, and in support of the Open Gov initiative. Analyzed and developed HUD's data categorization topics e.g., place of performance, customers, financial data to help prioritize department wide data standardization effort in order to improve data//information sharing.
• For EA governance, updated the EA policy document to reflect HUD's new IT governance process. Developed and/or updated EA documentation e.g., project plans, standard operating procedures, standards, training manuals, outreach presentations and conducted user trainings. Effort also involved the re-design and continuing update of the HUD EA website to ensure access and usage of EA products and services, and promoting a continuous feedback loop with HUD EA.
• Prepared and conducted EA executive briefings to create awareness and promote EA value across the Department, among key stakeholders and senior management. Facilitated EA focus groups to socialize the HUD Target EA, and validated the target EA through input/feedback from business and technical teams and senior management. This resulted in increased communication and additional requests for EA team support and guidance in project management, business case and investment analysis.
• Supported business development efforts for Citizant by defining technical requirements on Request for Proposals RFPs submitted to prospective customers. In support of employee recruitment, participated in candidate assessments by conducting face-to-face and telephone interviews and provided input for decision-making. Developed job position descriptions and qualifications required to specify the appropriate level of knowledge, skills, and proficiencies to assess viable candidates for employment.

Confidential

Principal Enterprise Architect

• As directed by Director of the Community Development Financial Institution CDFI Fund of the U.S. Department of Treasury, led the contractor team in planning and implementation of the EA Program. Promoted EA value through collaboration and integration of EA practice into CDFI Fund's management and operations as follows:
• Using the OMB EA Assessment Framework EAAF v3.0 assessment criteria, assessed CDFI Fund's EA program and recommended business improvements, one of which is the development and of the EA governance framework, procedures, and guidelines to clarify roles and responsibilities of key stakeholders.
• Developed and implemented the CDFI Fund's Data Architecture as-is and to-be architectures aligned with OMB's Federal Data Reference Model DRM directives. Involved establishing the Fund's Data Quality Improvement Program to resolve data issues and infuse data quality in the Fund's IT systems.
• Provided support to Treasury's governance bodies, such as the EA sub-Committee TEAC , Enterprise Repository Management Team ERMT , and the Fund's Technical Investment Board Executive Committee TIBEC . in planning and deploying EA program activities. This included the ongoing development and updating of segment architectures, the EA baseline and target architectures, EA transition strategy and sequencing plans for the DO and CDFI Fund EA programs.
• Worked with the Treasury EA repository development team to implement the Treasury EA Management System TEAMS using Troux's METIS Treasury and IBM System Architect CDFI Fund EA tools. This involved defining end user requirements and authoritative data sources for the TEAMS repository.
• Provided supported in planning and implementing Treasury's Budget Formulation and Execution Management BFEM Project, in compliance with OMB's shared services policy for budget planning standardization across the Federal government. Developed and implemented DO's EA control review procedures and guidelines to ensure alignment of the DO and CDFI Fund's investments with Treasury's Target EA and integration into the Department's capital planning process.

Principal Enterprise Architect, Security Architecture

• Supported the Certification and Accreditation C A of WMATA's Metro Information Technology System MITS general support systems GSS as they relate to the IT security infrastructure, which include:
• Jointly with the security infrastructure team, assessed the security and risk management functions and operations at WMATA and recommended risk mitigation activities to resolve security issues/challenges. Developed baseline and target Security Architecture, addressing security components applicable to the applications and IT infrastructure environment to ensure compliance with FISMA requirements
• Reviewed the MITS system security plan SSP and configuration plans and coordinated appropriate actions to resolve identified risks reported on the Plan of Action and Milestones POA M documentation.
• Reviewed and updated the organization's Certification Accreditation C A methods and procedures to ensure compliance with the WMATA's security standards and achieve a secure IT systems and infrastructure environment.
• Developed a high-level, conceptual model of WMATA's security architecture, which described its security components data centers, HW/SW devices, telecommunication/ networks , and their interdependencies.

Principal Enterprise Architect

• Led the EA contractor staff in providing support and assistance to the agency's EA Program Manager in developing, maintaining, and institutionalizing the agency's Enterprise Architecture EA strategy. Provided advice and counsel on the agency's EA Program, developed and updated the EA Program Plan, supporting ongoing EA initiatives in close collaboration with multi-functional teams across the Department of Labor DOL , which include:
• Under the direction of the OSHA IT Director, defined the bureau's EA program plan, aligned with the Department's EA practice. Developed EA procedures, standards, and guidelines, aligned with DOL EA initiatives, to support EA enablement and institutionalization across the agency. Coordinated the collection and analysis of information to assess and recommend on the impact of directives and/or inquiries from OMB, GAO, and other authoritative sources.
• Coordinated and facilitated EA assessment reviews with Investment/Program Managers to ensure alignment of IT investments to DOL Target EA and e-Gov directives. Defined user output requirements to generate line-of-sight reports for EA control reviews of IT investments, impact/change analysis decision support, and OMB EA assessment annual reporting.
• Updated EA artifacts in the DOL EA Management System DEAMS Troux Metis , in collaboration with IT portfolio managers. Coordinated with system/program Managers in collecting and validating EA artifacts populated into the DEAMS.
• Developed and presented EA overview briefings to promote knowledge and awareness of the agency's EA program. Participated in the agency's monthly EA Sub-committee EAS meetings on EA progress and ongoing collaborations for business transformation
• Updated and maintained the EA Transition Strategy Plan TSP and Target EA TEA for the agency, in joint collaboration with the DOL EA and CPIC teams and the IT investment and project managers. Performed gap analysis and provided recommendations for feasible solutions to address/resolve gap satisfy business needs and opportunities.

Senior Enterprise Architect

• Provided support and assistance to the Department's Chief Enterprise Architect and EA Program Manager to successfully develop and implement the Department's EA Program, which consists of the following EA functional components:
• Provided advice and counsel on the EA Program and initiatives, led the EA contract staff, and provided progress reports on EA activities. Collected, and analyzed EA component artifacts to comply with federal directives and requirements OMB, OIG, and GAO and apprised senior executives, to continuously improve the DOT EA program and processes.
• Working collaboratively with business and technical teams across operating administrations OAs , updated the Department's EA Transition Strategy and Sequencing Plan. Ensured alignment of IT investments to DOT's Target EA, reviewed and approved by designated investment and system managers. Assisted the EA Chief Architect in coordinating the quarterly EA Subcommittee meetings which focused on EA implementation and usage across the Department
• Developed EA policies, governance framework and procedures, conducted quarterly control reviews as part of the portfolio management process, support prioritized IT projects in all phases of the systems development life cycle SDLC and recommended feasible solutions for implementation. Presented EA briefings to educate and promote the EA Program among IT investment managers, Project Managers, and Integrated Project Teams IPTs .
• Developed the DOT Grants Segment Architecture, in joint effort with the integrated project team IPT and key stakeholders, and creating a Grants Management consolidation / modernization blueprint. Coordinated with the integrated program teams IPTs and other cross-functional groups to collect EA artifacts to be populated into the EA tool, to be used for strategic planning, impact analysis and decision-making, and to promote information sharing across the Department and with other federal agencies
• Participated in communities of interest COIs across federal agencies to collaborate on cross-agency initiatives e.g., Information Sharing Environment ISE , Grants Management standardization, Data Reference Model DRM strategic planning and implementation.
• Coordinated responses to DOT Office of Inspector General OIG and General Accountability Office GAO audit findings on EA program activities. To align IT investments with the Target EA, developed and applied scoring criteria to IT investments, in collaboration with the CPIC Team and the agency's Budget Office. Recommended feasible solutions to meet business needs and generate cost savings.
• Defined, planned, and deployed the Data Architecture Program Plan for FY2007-2008, aligned with the Department's Data Architecture. Supported the establishment of the Data Architecture Group DAG to resolve data issues, with designated data stewards across the Department.
• Supported the planning and implementing the EA repository tool Troux METIS Project. Defined the meta-model structure and required data architecture components to be populated into the repository tool.

DM Project Manager / Senior Data Architect

• In support of the State Department's Data Management, led the DM contractor team establishing the Department's data governance and data stewardship programs to promulgate data accountability, data quality improvement, and facilitate data and information sharing and re-use across the agency.
• Assisted the client in implementing the Department's data architecture to comply with OMB's directives on Data and Information Reference Model DRM , which involved developing the architecture roadmap, Supported DM activities to update and institutionalize the Department's data policies, data standards, and associated data management standard operating procedures SOPs .
• Supported the DM Program outreach by coordinating the Data Administration Working Group DAWG activities. The focus group was formed to facilitate data sharing and resolve data issues, to educate the data stakeholders and business users about DM initiatives.
• Coordinated the ongoing update and usage of the Enterprise Data Model EDM , its alignment with the Department's EA Data Architecture framework, developing the information categories taxonomy and XML Registry for information exchange.
• Worked collaboratively with various bureaus e.g., Consular Affairs, Diplomatic Security, and EA Planning to implement and use the Meta-Data Repository MDR .
• Supported client in budget planning e.g., OMB300 budget submission to obtain funding for the data management program, including the monitoring of budget execution.

Project Lead/Senior Systems Analyst

• Assessed and recommended implementation of U.S. Custom's and Border Protection's CBP's Data Governance program, which establishes its data policy, procedures, standards, and guidelines.
• Defined the CBP Data Architecture framework, developed procedures and guidelines to ensure alignment with departmental goals and objectives, and integrated into the system development life cycle process.
• Updated data policies, standards, procedures and guidelines to incorporate the department-wide Data Stewardship Program into the data management functions.

Project Manager - Data Management

• Managed and led the contractor team to support the U.S. Department of States' DOS Data Management Program, which includes program planning, resource allocation, monitoring, reporting, outreach, etc. , and ensured DM alignment with OMB's Data Reference Model DRM guidelines. Developed data policies, procedures, standards, and guidelines and supported the DM manager in their deployment and institutionalization. Conducted just enough and just in time DM training, as needed.
• Coordinated and supported DM efforts on the implementation of the Metadata Repository MDR , ongoing update and maintenance of the Enterprise Data Model EDM , and the usage and maintenance of the Standard Reference Data application. Planned and implemented the Standardized Data Reference SDR initiative to standardize commonly used look-up tables for ease of use and improve data quality.
• Coordinated working group sessions for the Data Administration Working Group DAWG , a focus group formed to facilitate DM data sharing and data issues resolution. Participated in the planning and deployment of the DM Program outreach efforts designed to promote the Department's data improvement initiatives, collaborating with DOS project teams and key stakeholders.
• Enterprise Architect
• Supported the development of EPA's Administrative Systems Architecture ASA , a mission critical segment of the agency's EA. The ASA encompasses the business functions and information systems applications, data, and technology under the direction of the OCFO, Office of Human Resources Management OHRM , and Office of Environmental Information OEI .
• Assisted the EPA client in the assessment of their capital planning and investment control CPIC funding submissions BY2005 , to comply with the Office of Management and Budget's federal capital planning and budgeting and FEA requirements OMB Circular A-11, OMB Exhibits 300 and 53 .
• Analyzed, identified, and recommended changes/upgrades to the existing ASA Sequencing Plan transition plan for migrating from the as-is to the to-be architecture to ensure alignment with the current ASA EA Target Architecture initiatives, e-Gov cross-agency efforts, and OMB FEA directives.
• Evaluated the effectiveness of the Architecture and Repository Tool ART, METIS tool and recommended changes/upgrades for improvement. Developed the ASA Data Naming Standards and Data Standardization documents to provide guidance to the ASA project teams to reduce data redundancies in IT systems/ applications that are to be integrated
• Assessed and identified data management processes needed to support the implementation of the ASA Target Data Architecture. Assisted the client in developing and deploying a web-based ASA customer survey to determine EPA's regional and program offices data requirements.

Senior Systems Analyst Project Lead

• Provided support for implementing the Customs and Border Protection's CBP's Enterprise Data Warehouse EDW datamart projects for the Office of Human Resources and Office of Field Operations, in full compliance with the agency's system development life cycle SDLC standards and guidelines. Activities included planning, requirements definition, database design, coding, testing, and deployment.
• Performed systems and data analysis, developing data models entity relationship and star schema models to design and implement the Operational Data Store ODS and data mart schemas and front-ends. Performed extract, transform, and load ETL functions to convert and migrate data from legacy data sources to the data mart's target database, using the Informatica PowerCenter ETL tool. Addressed and resolved data standardization and data quality issues to ensure data integrity and confidentiality.
• Reviewed and updated project plans, identified and resolved issues/concerns, and coordinated completion of project activities, resulting in a successfully deployed an EDW datamart. As lead systems analyst for the Seized Property/P F Case Management PFC Data Mart, successfully completed the project on time and within budget, with excellent project team support and collaboration. Coordinated and completed beta-testing of data mart in June 2003, conducted by SEACATS business users.

Senior Data Analyst/Consultant

• For the Sprint Inc. client, managed and led project teams to define user requirements and implement multi-level logical data models to physical databases, which required reverse and forward engineering, data conversion and migration. Worked with system planners, developers, and Database Administrators DBAs , and to implement and maintain IT applications and databases.
• In collaboration with data management teams, developed and implemented project plans and coordinated data modeling activities. Collected data requirements and performed data analysis/modeling for data warehousing initiatives, systems integration, transactional systems re-write, and/or COTs customization.
• Designed and deployed structured applications programs in COBOL and mainframe platform. Developed system test plans, QA standards and procedures, and conducted system training and reviews

Senior Data Analyst/Consultant

• In support of the Toyota, USA client, performed business area analyses of various functional subject areas in partnership with cross-functional business managers and information systems development teams, facilitated by the Enterprise Data Management Division.
• Led data management teams across the organization on strategic planning and implementation of data administration functions, which included enterprise-wide data policies, standards, and procedures, defined within the CIO organization's Data Architecture infrastructure framework.
• Provided data management training to data architects and modelers, and established data mentorship programs. This included data requirements gathering, data analysis and modeling, physical database design and implementation. Developed and implemented the Data Administration Standards and Guidelines.

Program Manager/Senior Data Architect

• Led contractor team in EA program development using Zachman's EA framework and Spewak's Enterprise Architecture Planning EAP methodologies, with skills and knowledge in data and business process modeling to document the architecture components of HUD's Data Architecture Program
• Acquired knowledge and understanding of the Federal CIO Council's Federal Enterprise Architecture Framework FEAF to define HUD's EA strategy, aligned with other federal agencies' common EA vision, principles, and integrated activities. Managed data management project and led the contract support staff to define user requirements, design, and built a data warehouse in support of HUD's Information Technology Architecture ITA initiative.
• Provided business area analyses of various functional subject areas in partnership with cross-functional business managers and information systems development teams HUD's Program Areas . Developed and updated Data Administration Standards and Guidelines and conducted training on data management procedures to institutionalize HUD's data management best practices.

IT Program Manager

• Led a team of 15 multi-vendor consultants and coordinated with various HUD IT staff to successfully deploy the Community and Planning Development's CPD's data warehouse. This effort involved defining the data requirements, data analysis and modeling, designing the database star schema, creating and performance tuning of the physical database.
• Identified authoritative data sources, planned, mapped and migrated the legacy data from source systems to the target MS-SQL server database. Developed and implemented front-end application customization using a vendor-provided OLAP tool, and conducted end user training to ensure knowledge and proficiency in using the DW. Utilized HUD's mainframe repository PR/MVS for the DW metadata management and as a data dictionary reference for end-users
• Support the planning and implementation of the Financial System Integration FSI Project. In joint collaboration with the Office of the Financial Officer OCFO , implemented FSI's data standardization and data clean-up. This included identifying and resolving data issues with designated HUD data stewards. Coordinated data collection and data modeling effort needed by the FSI project, as well as data profiling, data clean-up and migration to the new database structure created data dictionary and data models.
• Developed CIM/CFO joint project plan to implement HUD's overall data quality improvement program , Facilitated meetings and working sessions with HUD directors across the Department FHA/Housing, GNMA, Office of the Chief Financial Officer, Public and Indian Housing, Multi-Family Housing, FHEO, etc. to gain buy-in and become advocates for HUD's data quality initiative.

Senior Data Architect

• Developed and implemented HUD's Repository Project Plan for the phased implementation of its Platinum PR/MVS repository tool. Researched and consulted with the Platinum vendor and other repository users outside of HUD, and interviewed prospective HUD repository business users to determine usage requirements, tool capabilities and functionality, and implementation scope.
• Developed HUD's Repository Standards and Procedures document, which included standard naming conventions for the repository objects, guidelines, and step-by- step procedures addressing repository usage and maintenance
• Planned and implemented HUD's Integrated Detail Data Store IDDS Project to streamline the metadata extract process from the legacy sources to the data warehouse/data mart databases. Assisted in repository loading, executed vendor programs and utilities, identified and reported system errors, and validated output results. Led the DA team in analyzing and mapping the metadata from source systems to the target DW systems, needed for the IDDS logical data base design.
• Assessed recommended upgrades to HUD's Data Stewardship Program, helped revised its guidelines and procedures document, and proposed the initiation of a pilot project to test program effectiveness. Performed data modeling assessments and provided recommendations to correct data modeling deficiencies, including improvements to the database design procedures.