PROFILE:

This candidate is an Information Technology professional and former Journalist who is proficient in:

Work experience has been in financial services, government and media sectors. He is an excellent communicator of IT and Geopolitical subject matters who is very capable of working with all levels of management or personnel.

EXPERIENCE:

BUSINESS ANALYST

Confidential

Developed Master Reference Datasets MRD for implementation at the U.S. Department of State in an effort to provide a centralized and authoritative source data that was compliant with the National Information Exchange Model NEIM

Data analysis

• Developed Recommendation Package Taxonomy, Glossary, Data Dictionary
• Conducted stakeholder meetings
• Business Process Modeling
• Methodology: SQL Server 2012, Visio, Project Management MS Access MS Office

DATA ANALYST

Confidential

• Created a Data Dictionary for usage within an Enterprise Data Warehouse EDW and Data Portal. Interaction with Business Departments for The Carlyle Group, a global asset management / private equity concern.
• Source-to-Target-Mapping STTM of source system data to be leveraged within the EDW.
• Created Business Process Models to capture Business departments, their systems and relative data for usage within the EDW and intended usage with an investor Data Portal
• Analysis of data from various source systems Investran .
• Methodology: SQL Server 2012, Visio, Agile Project Management best practices SalesForce , SQL for relational database querying OLTP, ERStudio Data Architect.

SENIOR INFORMATION ARCHITECT

Confidential

• Data Strategy Management: Enterprise development and information gathering of data flow throughout all systems and groups within DISA's Computer Services Directorate CSD
• Identified authoritative data systems
• Support for BMC Software Configuration Management System CMS .
• Data Analysis of various systems for data federation to the CMS
• Methodology: CA Erwin Data Modeling, Microsoft Office SharePoint, Systems and Data Analysis, Data Strategy, Visio, SQL for relational database querying, OLTP, BMC Software.

REQUIREMENTS ANALYST

Confidential

• Elicitation of requirements for documentation of various implementations such as Windows Server 2008, Windows 7, MS Office 2010 and Virtualization in compliance to NIH's Enterprise Performance Life Cycle EPLC
• Methodology: Requirements gathering. Rational RequisitePro, Rational ClearCase, Rational ClearQuest

DATA ANALYST

Confidential

• Data analysis of the DCPS Special Education system SEDS database application
• Source-to-target mapping
• Liaison with the Office Special Education OSE
• Liaison with the Office State Superintendent of Education OSSE
• Performed gap analysis current system and the intended version upgrade of SEDS.
• Creation and modification of a database application to mirror SEDS
• Migration of assessment data to proprietary system.
• Methodology: SQL Server 2008, MS Access, Quickbase, proprietary software. OmniGraffle, OmniPlan

SYSTEMS ANALYST

Confidential

• Systems Analysis of legacy systems and reports where sales data will be transferred to and then extracted from the Sales Reporting Warehouse SRW , a data warehouse.
• Liaised with Business team to ascertain their requirements of standard reports and ad-hoc querying functionality using Cognos.
• Updated report data elements using ERwin data modeler.
• Performed gap analysis of current reports and proposed reports for future release.
• Revised the Architecture document to reflect Marriott standards for ETL and ELT processes, ODS loading, the Netezza data warehouse environment and extraction via interfaces, reports and querying.
• Reviewed and updated Use Cases.
• Authored documentation pertaining to phases of SDLC i.e. Scope, Architecture, Design, etc
• Requirements Management for the data warehouse.
• Review Development of Use Cases.
• Performed source-to-target mapping STTM of report data.
• Methodology: Oracle, OLTP, Netezza, MS Project, Erwin, Visio, Trillium, UNIX, and Requirements gathering. Rational RequisitePro, Rational ClearCase, Rational ClearQuest

SENIOR SYSTEMS ANALYST

Confidential

• Analysis of the Department of Labor's DOL National Emergency Grants NEG system used for national responses to communities facing economic hardship e.g.. plant closings or military Base Closure and Realignment BRAC .
• Performed updates to NEG applications.
• Troubleshoot technical problems by checking the Oracle database PL/SQL via Toad
• Gathered Requirements and performed Gap Analysis for upgrades to the NEG system.
• Conducted tests prior to release of upgrade
• Analyzed various Grants Management systems Both COTS and institutionally developed systems
• Developed functional requirements and performed budget analysis as part of the Software Development Life Cycle SDLC for the implementation of a new electronic grants management system eGrants . Created MS Project Plans to reflect implementation of major upgrade of existing system and another plan to reflect the intended new electronic grants management system GEMS.
• Conducted and organized Focus Group session and subsequent subject area teams with nationwide users and branch chiefs to elicit responses to review and elicit their desired system functionalities.
• Methodology: Oracle 9i, Visio, MSProject, ColdFusion MX, Mercury Test Director

DATA ANALYST

Confidential

• Conducted analysis using Trillium software for data cleansing of the department's voter registration data
• Used MS SQL Server's Data Transaction Services DTS to format data for Trillium Processing and report generation.
• Established and executed formal data analysis procedures and data governance of voter
• registration data designed to detect instances of duplication, erroneous entries, and/or suspect data.
• Designed a series of standardized reports based on the findings of the data cleansing activities.
• District of Columbia Office of Chief Technology Officer OCTO
• Developed and performed similar data cleansing and governance using Trillium Software for the audit and cleansing of data for various DC governmental departments under the auspices of the District's Chief of Technology:
• District of Columbia Office of Chief Technology Officer OCTO
• Supplemental Educational Opportunity Grants SEOG
• District of Columbia Office of the Chief Financial Officer OCFO
• District of Columbia Department of Motor Vehicles DMV
• District Small Local Business Development DLSBD
• Other assignments for the District of Columbia performed under the auspices of the District's Chief of Technology:
• Conducted system analysis of legacy database District Small Local Business Development DLSBD
• Performed source-to-target mapping STTM from legacy database MS Access to a more robust relational database MS SQL Server
• Developed relational database stored procedures MS SQL Server for DLSBD
• Performed Quality Assurance testing of migrated data for launch of new website for DLSBD leveraging the new database