We provide IT Staff Augmentation Services!

Senior Systems Analyst Resume

5.00/5 (Submit Your Rating)

SUMMARY:

  • This candidate is an Information Technology professional and former Journalist.
  • 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.

EXPERTISE AREA:

  • BUSINESS ANALYSIS
  • OLTP DATABASES
  • BUSINESS PROCESS MODELING
  • PROJECT MANAGEMENT
  • DATA ANALYSIS
  • QUALITY ASSURANCE TESTING
  • DATA MODELING
  • REQUIREMENTS GATHERING
  • DATA STRATEGY AND GOVERNANCE
  • SOFTWARE DEVELOPMENT LIFE CYCLE
  • DATA WAREHOUSING
  • SYSTEMS ANALYSIS
  • DATABASE ADMINISTRATION
  • TECHNICAL WRITING AND EDITING
  • DEVELOPMENT
  • BUSINESS INTELLIGENCE
  • GEOPOLITICAL ANALYSIS & RESEARCH

PROFESSIONAL EXPERIENCE:

SENIOR SYSTEMS ANALYST

Confidential

Responsibilities:

  • SQL and Hadoop Querying
  • Scripting
  • Data analysis and Source to Target validation
  • Conducted meetings between Development and Business Stakeholders
  • Data Governance

Methodology: Apache (Hive), IBM Infosphere Information Server (IIS), Oracle 11g, SQL ServerVisio, Agile; MS Office, HUE environment; Netezza

BUSINESS ANALYST

Confidential, Reston, Va

Responsibilities:

  • 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.
  • Data analysis
  • Developed Recommendation Package (Taxonomy, Glossary, Data Dictionary
  • Conducted stakeholder meetings
  • Business Process Modeling
  • Usage of SQL Server and Oracle RDBMS
  • Data Governance
  • Project Managed of data analysis activities and deliverable of a recommendation package that is developed based on the analysis
  • Scheduled and facilitated Tiger Team meetings for Data sets
  • Provided analysis of and identified correlations among the data
  • Cleaned data for mater reference usage
  • Creation of a Data Dictionary, Taxonomy and Data Glossary

Methodology: SQL Server 2012, Oracle 11g, Visio, Project Management; MS Access; MS Office

BUSINESS ANALYST

Confidential

Responsibilities:

  • Analysis of datasets,
  • Examination of data being collected over time (36 hours to 30 days)
  • Analysis of network and storage mechanisms to be used
  • Developed database requirements using a hybrid “agile - waterfall approach”
  • Designed ETL of data from source system to conventional and Big Data environments
  • Configuration of the data to be used from a Mongo database (Big Data) to being shown on a business intelligence tool, Pentaho.
  • Provided strategy for design database recommendation, design and persistence
  • Provided impact estimates based database requirements.
  • Provided analysis of COTS and Open Source products for Business Intelligence functionalities
  • Enterprise Data Modeling

Methodology: Pentaho BI Suite- (Kettle, Data Integration ETL, CE, EE), MySQL, Visio, MongoDB, Pentaho, MS Access; MS Office Professional.

DATA ANALYST

Confidential, Reston, VA

Responsibilities:

  • Created a Data Dictionary for usage within an Enterprise Data Warehouse (EDW) and Data Portal. Interaction with Business Departments for Confidential, a global asset management / private equity concern.
  • Source-to-Target-Mapping (STTM) of source system data to be leveraged within the EDW.
  • Data modeling
  • 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).
  • Participated in a daily Agile scrub meeting to convey progress of deliverables for the current sprint
  • Participated in user story selection and prioritization for the upcoming sprint.

Methodology: SQL Server 2012, Visio, Agile Project Management best practices (SalesForce), SQL for relational database querying; OLTP, ERStudio Data Architect.

SENIOR INFORMATION ARCHITECT

Confidential

Responsibilities:

  • 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
  • Data Modeling
  • 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, Chantilly, VA

Responsibilities:

  • Elicitation of requirements for documentation of various implementations such as Windows Server 2008, Windows 7, MS Office 2010 and Virtualization in compliance to Confidential.

Methodology: Requirements gathering. Rational RequisitePro, Rational ClearCase, Rational ClearQuest

DATA ANALYST

Confidential, Vienna, VA

Responsibilities:

  • Data analysis of the Confidential Special Education system ( Confidential ) 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 Confidential .
  • Creation and modification of a database application to mirror Confidential
  • Migration of assessment data to proprietary system.

Methodology: SQL Server 2008, MS Access, Quickbase, proprietary software. OmniGraffle, OmniPlan

SYSTEMS ANALYST

Confidential, Bethesda, MD

Responsibilities:

  • 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, Springfield, VA

Responsibilities:

  • Performed updates to Confidential applications.
  • Troubleshoot technical problems by checking the Oracle database (PL/SQL via Toad)
  • Gathered Requirements and performed Gap Analysis for upgrades to the Confidential 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, MS Project, ColdFusion MX, Mercury Test Director

DATA ANALYST

Confidential, Alexandria, VA

Responsibilities:

  • 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.
  • 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

Methodology: MS Access, MS Excel, MS SQL Server and Trillium Software, Mercury Test Director, Data Cleansing, Data Governance

TECHNICAL WRITER, BUSINESS ANALYST AND DEVELOPER

Confidential, Baltimore, MD

Responsibilities:

  • Detailed Business Process modeling of the existing procedures (AS-IS) of the claims process and the proposed procedures (TO-BE) that the SUMS system would entail.
  • Wrote and performed validation methodology as part of the aforementioned SUMS SDLC via scripts for sample Quality Assurance testing of data prior to implementing data to a production environment.
  • Developed and administered a Visual Basic application used to track multiple projects for the Confidential SUMS project as well drafting project plans via MS Project.
  • Analyzed and documented a User Guide for the previously mentioned Project Management application as part of the training section for the SUM SDLC.
  • Wrote articles that were to be used as profiles in Lockheed’s competitive bidding effort for the Agency-wide Support Services contract at Confidential (RFP).
  • Developed Use Case documentation to depict the revised business process initiatives.
  • Assessed and documented proprietary systems and respective business processes that are used within Office of Hearings and Appeals and Disability Determination Services.
  • Wrote several Strategic Plans and Statements of Work for the Confidential in its effort to instill an Information Technology Infrastructure Library (ITIL).

Methodology: SDLC, Visual Basic, MS Project, MS Access Programming, CaliberRM, Mercury Test Director, Brio, Visio, Erwin, Oracle, OLTP, DB2 on UNIX OS, Lotus Notes, Macromedia Dreamweaver, MS Office, and MS Windows 2000 & XP

ASSISTANT DATABASE EDITOR

Confidential, Washington, DC

Responsibilities:

  • Developed and administered databases (SQL Server and MS Access) for production that accompanied several investigative news reports on topics such as Campaign Financing, The Business of War, Water Companies and Prosecutorial Misconduct. CPI is a non-profit, non-partisan journalistic research organization.

Methodology: MS Office, MS SQL Server 2000, MS Access and MS Excel and HTML, MS Windows 2000.

We'd love your feedback!