TECHNICAL SKILLS

• z/OS, OS/390, Windows 2008 - 14, Windows 7-10, Unix (Solaris 10), iOS 10.x-11.x
• Back Office: Microsoft Office Suite/360, Dropbox, SharePoint
• Cloud Microsoft Azure
• ERwin Data Modeler (v1.5-v9),
• ERwin Business Process Modeler (aka BPwin)
• IDERA ER/Studio Enterprise Team Edition (v7-2017),
• Casewise Modeler Tool Suite (v16), Visio (Data/Process Diagrams)
• Texas Instrument IEF, Bachman/Data Analyst
• DBMS: DB2/UDB iSeries, MS SQL Server, Oracle, Teradata,
• MS Access, IDMS, VSAM
• CA ERwin Workgroup and Web Portal
• IDERA ER/Studio Repository and Team Server
• CA z/OS Platinum Repository (PR/MVS),
• Meta Integration (MITI) Metadata Management Solution,
• Troux eaGov, Rochade,
• Microsoft Office SharePoint Services (MOSS),
• IBM Enterprise Content Manager (ECM) - Records Management DocFinity - Records Management
• Informatica Power Center, IBM InfoSphere DataStage
• PL/SQL, COBOL (VS, II, Realia, Microfocus), PL/1, SAS,
• Visual Basic, CICS (VS, Real), HTML, XML/XSD
• TSO/ISPF, Librarian, Panvalet, RACF/ACF2, BMC Remedy-Change Manager, ENDEVOR, IBM WebSphere
• Enterprise Architecture Frameworks (Zachman, FEA, FSAM),
• Data Architecture Standards (DMBOK),
• ISO 11179 Metadata Registry (MDR) Standards & Metadata Management
• Common Warehouse Model (CWM),
• Data Modeling Notations (IDEF1X, IE) - Relational & Dimensional (Snowflake/Star Schemas)
• National Information Exchange Model (NEIM),
• Business Process Modeling Notation (BPMN 2.0, IDEF0),
• Privacy/FOIA Standards,
• Records Management (NARA, DoD, OMB, ISO 15489) standards,
• Healthcare IT Exchanges & Standards - HIPAA, ICD 9/10, LOINC, HCPCS,

PROFESSIONAL EXPERIENCE

Confidential

Primary Principal

Responsibilities:

• Architected the internal business model, marketing/pricing strategy and baseline course curricula.
• Developed and conduct training needs assessments and training evaluations to gauge effectiveness.
• Negotiate training engagement agreements with prospective customers.
• Oversee approval of data modeling, business process modeling, repository and team server training materials and courses.
• Conduct internal technical support staff training on developed training materials and professional services processes.
• Conduct on-site customer training sessions for ER/Studio Enterprise Team Edition software product suite, as needed.

Confidential

Re-Seller

Responsibilities:

• Developed sales marketing and pricing strategy.
• Established and nurture key relationships with product sales account managers & software distributors.
• Defined and implemented internal data collection and quotation process utilizing the ERwin Data Modeler and Casewise Business Process Modeler software toolsets to facilitate automation.

Confidential, Alexandria, VA

Lead Business and Data Analyst

Responsibilities:

• Conducted As-Is and To-Be business program and technical architecture analysis. Initiated and facilitated stakeholder requirement gathering workshops.
• Created analysis artifacts such as conceptual data models, data mappings and business process diagrams.
• Conducted gap analysis of current records management strategy, proposed recommendations and project roadmap to close gaps.
• Developed proposed records management policies, procedures and guidelines/best practices based on Federal (NARA, DoD 5015)/State (Library of Virginia)/Local (Alexandria) legislation and mandates.
• Promoted and educated Alexandria Renew personnel on current industry best practices in Records Management.
• Coordinated and facilitated the evaluation of vendor-specific COTS tools and underlying data models.

Confidential, Woodlawn, MD

Project Manager/Lead Data Architect

Responsibilities:

• Established and enforced Enterprise Data Architecture and Data Modeling standards for unstructured data content and integration strategies for mission-critical CMS software applications.
• Developed standard document taxonomy classification, and designed application-specific conceptual/logical/physical data models according to existing CMS data administration standards. CMS utilized the ERwin toolset as a key component in producing data artifacts for the SDLC process.
• Facilitated CDM, LDM and PDM data model reviews and walkthroughs with applicable stakeholders for over 20+ application development efforts.
• Defined ECM metadata standards (ISO 11179) to support application integration and CMS security standards. Supported ECM integration development efforts of 20+ CMS applications.
• Promoted and educated CMS community on current ECM data management strategy.
• Provided recommendations and maintained current ECM enterprise data standards and presentation overviews.

Confidential, Washington, DC

Project Manager/Lead Data Architect

Responsibilities:

• Provided documentation, development, and maintenance support of the PBGC Enterprise Data Model (EDM) and the governance processes necessary to establish a baseline, address and mitigate audit findings as well as ensure sustainability in the future.
• Applied existing PBGC EA and IT Solutions Life Cycle Methodology (ITSLCM) standards/references in the development of the PBGC EDM.
• Authored internal EA process documentation to support the effective utilization of the PBGC Enterprise Data Model and Segment Architecture Conceptual Data Models (CDM),
• Established baseline inventory of all PBGC data models.
• Developed security, version control, and access control for PBGC data models residing in a centralized repository (i.e. ERwin Model Manager).
• Developed data model harmonization and alignment strategy with FEA utilizing ERwin compare and merge functionality.
• Authored migration plan of the Confidential from 4.x to 8.x to ensure compatibility with Windows 7 standard desktop.
• Performed gap and needs analysis necessary to effectuate the next phase of EDM modernization planning and prioritization efforts.
• Managed 2 support staff members and generated recurring project management deliverables.

Confidential, Washington, DC

Project Manager/Lead Data Architect

Responsibilities:

• Develop strategy for constructing and documenting As-Is application-specific logical and physical data models (LDM/PDM). Successfully vetted and published data dictionaries for three (3) mission critical IDMS application systems utilizing ERwin reverse-engineering capabilities.
• Lead data architect responsible for construction of As-Is and To-Be Enterprise conceptual/logical data models (CDM/LDM) to support future ELIS development efforts. Construction of enterprise LDM involved normalizing and harmonizing application-specific physical data models. Ensure alignment of As-Is/To-Be models with DHS Enterprise Data Management Office (EDMO) and NIEM Immigration domain standards.
• Develop agency/component specific data governance strategies, data management standards, data modeling templates and guidelines to support on-going program/project/application development efforts.
• Develop other data architecture artifacts for EA program as needed.

Confidential, Woodlawn, MD

Project Team Lead/Senior Data Architect

Responsibilities:

• Managerial oversight of data management team consisting of 8 data administrators. Primary point of contact for CMS DA government task lead(s).
• Development and enhancement of data administration policies, processes and standards including but not limited to data stewardship, data governance, naming conventions, and enterprise data modeling standards (relational and dimensional) and development efforts.
• Developed and presented DA overviews & briefings to promote knowledge and awareness of the program throughout the agency via brown-bag and outreach sessions.
• Performed Section 508 technical compliance assessments and provided recommendations on data modeling tool suites.

Confidential, Arlington VA

Senior Project Manager/Lead Data Architect

Responsibilities:

• Resurrected the Data Management team which administered, monitored and implemented data modeling, data architecture best practices, logical/physical naming standards, change control process, impact analysis standards and web-based meta-data database repository.
• Technical Subject Matter Expert (SME) for the following billing data model subject areas: Customer, Network, Service Ordering, External Interfaces. Documented and maintained relational and dimensional logical/ physical data models (ERWIN) for these subject areas. Coordinated physical data model implementations with DBA group.
• Served as ERWIN Model Manager Administrator; Configured and supported data model repository on Unix/Oracle platform.
• Configured and supported UDB v7.2 DB2 Connect on Windows NT environment.
• Constructed and performance tuned SQL queries for external application access requests.
• Performed and managed data quality team responsible for a 20% reduction in data integrity errors. Constructed semantic integrity and business rules queries for data validation and correction.
• Developed billing data ETL strategies for Enterprise Customer Marketing Data Warehouse/Marts, meta-data application repository and Employee Compensation Data Warehouse.
• Conducted vendor assessments of the following meta-data management and ETL