SUMMARY:

• Senior Data Architect, Data Modeler, Business/Data Analyst and Technical Project Manager with over 20 years of IT experience in government and commercial sectors.
• Certified ERwin Data Modeler Specialist (CACP), with over 15 years of specialized experience in advisory and implementation of Enterprise Architecture Frameworks (TOGAF, Gartner, etc.), Enterprise Data Management/Architecture, Enterprise Information Architecture (EIA), Source to Target Data Mapping, Data Governance, Data Migration, Data Quality, ETL, BI and Web Services Technologies/Solutions.
• Senior Data Architect supporting Data Architecture and Data Governance Advisory initiatives.
• Industry experience includes Healthcare, Public Sector (Government), Technology, Banking/Finance (including Capital Markets, Mortgage Banking, and Primary/Secondary Mortgage Markets), Microfinance, International Finance & Global Development, Procurement, Telecommunication, Retail, Manufacturing, and Energy.

TECHNICAL SKILLS:

OS/Environments: DOS, Novell Netware 3.1x, UNIX (Sun Solaris, SunOS 4.x/5.x, System V, AIX, HP - UX), Windows 3.x, 95, 98, NT, XP, 2000/2003/2008 Server and Professional, Windows Vista/7.

Development Applications: Assembly, BASIC, C/C++, COBOL, Pascal, JAVASCRIPT, ASP, SQL, PL/SQL, Visual Basic, VBscript, vi, Unified Modeling Language (UML), IBM Rational Rose Toolset including Rational Data Architect, SOA, J2EE.

Change Management Software: IBM Rational ClearCase/ClearQuest, MKS Source Integrity Enterprise (SIE) and Integrity Manager 4.x products.

Networking/Internet Tools: TCP/IP, IPX/SPX, NetBIOS, OSI, DHCP, WINS, SLIP, PPP, DNS, FTP, Telnet, SMTP, Netscape, Internet Explorer, HTML, DHTML, XML, XSD, IIS, Content Management Systems (CMS) including SharePoint 2007/2010/, Dreamweaver, Drupal, SilverStripe & WordPress.

Applications/Software: Microsoft Visio, Microsoft Office, Microsoft Project, dBase III+, Harvard Graphics, Lotus SmartSuite, WordPerfect, Lotus Notes, GroupWise, SAP R/3 Release 4.6., Remedy.

Information Worker Applications: Microsoft Online Services/Microsoft 365 (Exchange, Lync, SharePoint).

RDBMS/Data Modeling Tools: ORACLE 7.x-11g, IBM DB2, MS SQL Server 6.5-7.0/ /2012 , Sybase 11.x-12x, IBM DB2, MySQL, SQL*PLUS, TOAD v9.7.0.51, SQL*NET v.2, Net8, Oracle Enterprise Manager (OEM), Oracle Developer/2000 - Forms/Reports, Microstrategy 7.x, Cognos

PROFESSIONAL EXPERIENCE:

Confidential, Arlington, VA

Sr. Data Warehouse Modeler/Senior Technical Specialist

Responsibilities:

• Responsible for ensuring that the data assets of the agency are supported by an architecture, allowing National Science Foundation to achieve Strategic Data Analytic and BI Reporting goals as well as corporate initiatives. The architecture covers databases, data integration, and the means to get to the data;
• Developed and documented logical and physical data models,datadictionary, mapping of data elements to requirements, data analysis, specifications and data flows using ER/Studio, Oracle SQL Developer and Agile Software Development Methodology to provide efficient, cost-effective solutions for complex business problems;
• Integrated system/subject area data from varied data sources into an EnterpriseDataArchitecture, as well as identified and resolved dataquality and integrity issues across the enterprise;
• Responsible for collaboration and execution of the program vision by designing and developing data architecture for the Enterprise Data Warehouse (EDW);
• Provided support for all data integration needs by following data modeling standards and worked closely with the Enterprise Information Architect, ETL/BI team to implement and deploy solutions to meet client needs;
• Worked directly with the Project Manager and Business Analysts to assess business needs and translated them into effective technical and data architecture solutions to meet enterprise-wide reporting/analytical needs and applied best practices to enhance performance;
• Maintained the EDW data security architecture and also created necessary SQL scripts for database integration and deployment;
• Supported the ETL, QA and BI teams for all development needs including the implementation and maintenance of the Data Dictionary;
• Worked with users and Business Analysts to elicit and analyze data requirements, performed data mapping and generated high level data models for communication with business stakeholders;
• Provided status reports with detailed description of the current project’s progress and indicated time devoted to each task oftheproject ;
• Participated in design walk-through with appropriate focus groups and stakeholders to verify accuracy of data design architecture to meet business needs.

Confidential, Washington, DC

Sr. Data Architect/Senior Technical Specialist

Responsibilities:

• Senior Technical Specialist/Data Architect supporting the Department of State client on Data Architecture and Data Governance advisory initiatives.
• Developing a Data Governance advisory initiative for CA/CST to include documentation of a Data Governance Charter, Checklist, Maturity Model and Framework that will guide CA/CST staff in the implementation of a sound and successful Data Governance and Data Quality structure within DoS.

Confidential, Washington, DC

Lead Information and Data Architect

Responsibilities:

• Lead the development of Data Architecture including data dictionaries, Data Models, ETL Source - to - Target mapping, data governance, data quality, review database schemas, documentation of “as-is” and “to-be” future State architecture and processes and the implementation of best practices to support Business Intelligence (BI) systems.
• Lead user requirement gathering sessions for Operational Data Store and documented business cases, objectives and high level system requirements to develop Technical Specifications and Mapping Documents.
• Analyzed business requirements gathered and developed appropriate information flow, defined matrices and document templates to capture Information in granular business context.
• Served as a senior resource for troubleshooting Business Intelligence (BI), Data Architecture and Data Model related issues in a Cognos, Oracle and Sybase environment.

Confidential, Elkridge, MD

Principal/Lead Technical Project Manager

Responsibilities:

• Managed IT contracts/consulting assignments on behalf of Confidential for high profile government and private sector customers (including Banking/Financial Services) in The Gambia.
• Managed the full project management life cycle and software development life cycle for the implementation of highly complex, large-scale, strategic IT and Business Corporate Initiatives.
• Provided technical project management support to IT solutions teams in identifying the appropriate solutions required by clients’ user areas.
• Wrote and responded to Requests for Information (RFI), Requests for Proposals (RFP), Request for Quotations (RFQ), prepared invoices for external services, designed and maintained technical and project documentation as well as managed multiple technical teams.
• Created and maintained the project plan that communicated project tasks, goals, budget cost estimates, milestone, status reports, resource allocation and deliverables from design and development to production utilizing software life-cycle methodology.
• Developed and maintained effective relationships with customers and key stakeholders, foster trust to influence key decisions and managed client expectations throughout the project life cycle.
• Coordinated the delivery of development (beta) and production releases that meet quality assurance standards.
• Efficiently identified project issues and created strategies for risk mitigation/contingency planning as well as provided technical direction for the development, design, and systems integration across multiple client engagements from definition phase through implementation.
• Suggested alternative technical solutions to meet client requirements more efficiently and applied significant knowledge of industry trends and developments to improve services to our Customers/Clients.
• Created and executed development plans across multiple projects and revised them as appropriate to meet changing Customer/Client needs and requirements.

Confidential, Washington, DC

Advisory IT Architect/Lead Data Architect

Responsibilities:

• A $7.5 Million project that involves helping TSA establish a permanent Enterprise Data Management Office (EDMO) to ensure consistent design and management of TSA data enterprise-wide.
• Lead the team providing services that governed and guided business and technical users and producers of data in the governance, design, implementation and use of sharable data across the enterprise as well as helped TSA manage information in an integrated manner in order to establish standards for managing its data, and facilitate compliance with NIEM.

Confidential, Harrisburg, PA

AllFusion ERwin Process/Data Modeler Consultant

Responsibilities:

• A two months project where I provided knowledge and guidance in the component called ERwin Process Modeler, and how to integrate that with ERwin Data Modeler to create logical and physical data models.

Confidential, Bethesda, MD

Sr. Data/Strategic Analyst

Responsibilities:

• A $44.8 Million large-scaled multi-phase Community Housing Development (HCD) Strategic Data Re-Platform project to integrate all of their Operational Systems data into the Operational Data Store (ODS), standardize Reporting, retire EUCs applications and improve Data Quality and Business Processes, providing Confidential with 5-year saving of $17.2 M.
• Lead the team to interface with the customer to gather requirements, gap analysis, data analysis/mapping, source-to-target mapping, metadata management and data modeling.

Confidential, McLean, VA

Sr. Data Analyst

Responsibilities:

• A $16.5 Million Significant Deficiency #13 Mitigation and Remediation (GA/GO) Project - Controls over Data Quality of the Enterprise Data Program implementation to support the identification, mitigation and remediation of Material Weaknesses & SD#13 of Data Quality Control issues tied to Financial Reporting.
• Lead the team to interface with the customer to gather requirements, gap analysis, data analysis/mapping, source-to-target mapping and data modeling.

Confidential, Hanover, MD

Sr. Information Technology Specialist

Responsibilities:

• Conducted work order orientation meetings to define roles and responsibilities, reviewed vision, purpose, strategy, objectives, scope, and constraints for the Medicare Modernization Act (MMA) Release 4.0 Part B Income-Related Monthly Adjustment Amount (IRMAA) and the Comprehensive Work Opportunity Support System (CWOSS) Systems Development Life Cycle (SDLC) efforts for the Social Security Administration (SSA) and Centers for Medicare and Medicaid (CMS).
• Analyzed current business processes, conducted user sessions and technical meetings, performed requirements management activities, developed and updated logical data models, Business Process Requirements (BPR) and Detailed Functional Requirements (DFR) for the MMA Release 4.0 Part B IRMAA.
• Prepared and documented the MMA Release 4.0 Part B IRMAA Business Process Requirements (BPR) that adheres to the Project Resource GuIDE (PRIDE) standards.
• Work with senior management, Project Managers, user community and IT Professionals to create high-Level conceptual solutions to Business problems.

Confidential, McLean, VA

Sr. Business Systems Analyst

Responsibilities:

• Lead requirements gathering definition, analysis and documentation of the SDLC implementation/enhancement of a large-scaled Web-based software application project.
• Performed Systems Integration Testing (SIT), User Acceptance Testing (UAT), trouble-shooting and problem resolution.

Confidential, McLean, VA

Sr. Data Analyst

Responsibilities:

• A $1.5 Million large-scaled full SDLC Web-based Metadata Repository project implementation, which was successfully implemented into production, which provided an estimated $6,000,000.00 in annual savings.
• Lead the team in providing Project Charter, cost/benefit, data/gap analysis, metadata management, translated user requirements into Technical specifications/Business Solutions, created/tested Ad-hoc Reports and Queries participated in the Proof-Of-Concept (POC).

Confidential, St. Louis, MO

Technical/Metadata Architect

Responsibilities:

• Architect a Metadata Repository solution from user requirements gathering to implementation with responsibilities of assessing implementation alternatives, integration strategies and techniques.
• Lead and facilitated structured interviews and JAD/JRD sessions, Business Rules creation, validation, transformation and implementation, resolution of conflicts over data and business rule definitions, data rationalization, data cleansing and creation of layouts and specifications for end-user reports, delivering an end-to-end Metadata management solution in the process.
• Worked with the Project Manager to provide integration of a distributed Metadata solution into the enterprise utilizing CAARDS.
• Developed data distribution by the creation of Physical Metadata Repository database.
• Performed Metadata extraction and source-to-target mappings from SAP, PeopleSoft, IBM DB2, Oracle, MS SQL Server, and other source systems through Forward and Reverse Engineering of Data Models using AllFusion ERwin 4.1 Data Modeler.

Confidential, Columbia, MD

Technology Specialist

Responsibilities:

• As Technical Liaison/Project Lead, provided technical support and consulting services of high-end Data Warehousing, web-based software products, Metadata Repository Management, ETL ERP and Business Intelligence tools to internal and external users.
• Implemented, upgraded, configured and troubleshoot Metadata Repository tools, Oracle, IBM DB2, MS SQL Server/Sybase databases, middleware, ODBC and IIS in Windows and UNIX platforms.
• Assisted users in developing processes and procedures for using new Metadata Repository product features modified Metadata Repository Database System and supported its overall administration.
• Identified, gathered and populated Metadata from Mission Critical Databases, ERP and knowledgebase applications into the Metadata Repository.
• Performed testing, debugging, communication of product problems, design verification of current and future releases and enhancements of Metadata Repository product suites.
• Performed logical/physical data modeling, data distribution, Forward/Reverse Engineering of Data Models using AllFusion ERwin 3.x/4.x Data Modeler.

Confidential, Gaithersburg, MD

Technical Support Engineer

Responsibilities:

• Provided customers with technical support services including analysis and problem resolution on post sale and installed systems, tested system serviceability as required, and assisted Engineering in problem evaluation and resolutions.
• Performed client sites and in-house installations, upgrades and conversion of Oracle database applications, data access, collection and billing of Telecom Operations Support Systems (OSS).
• Performed ftp of packaged call detail record files in real-time and batch modes, converted EMI call detail records to EMR formats, conducted rating and toll processing, corrected errors during usage processing, and performed QA on generated customer invoices.
• Provided to customers and employees on company’s data access, collection, billing, and other OSS products.
• Performed Oracle Reports enhancement and maintenance, wrote SQL and Unix Shell scripts using Developer/2000 Reports 2.5, SQL*Plus and vi for EMI conversion, EMR call detail record rating, and populating billing account tables for mass production of customer invoices.
• Installed, configured, and troubleshot ODBC and SQL*NET v.2 connectivity for Oracle-based clients and applications documented/maintained product upgrade and installation procedures.