We provide IT Staff Augmentation Services!

Senior Principal Consultant (data Modeler/engagement Manager) Resume

Reston, VA

SUMMARY:

Over 20 years of experience in science and technology; engaged in all aspects of SDLC including research and analysis, design and development, test and quality assurance, implementation and maintenance of various systems for federal, public and commercial sector projects; excellent interpersonal, communication and problem solving skills

AREAS OF ENGAGEMENT:

  • Business/Requirements Analysis
  • Business Process Reengineering
  • Data Architecture
  • System Integration
  • Application Development
  • Testing/Quality Assurance
  • Documentation and Training
  • Project Management

TECHNICAL PROFICIENCIES:

Platforms: Windows, UNIX, Linux

Languages: C/C++, Java, Shell Scripting, SQL

Databases: Teradata, Oracle, SQL Server, MS Access

Tools: ERwin Data Modeler, Oracle Designer, Mercury Quality Center, Rational ClearQuest, Rational ClearCase, Microsoft Office Suite, Visio, MS Project, VersionOne

PROFESSIONAL EXPERIENCE:

Confidential, Reston, VA

Senior Principal Consultant (Data Modeler/Engagement Manager)

Responsibilities:

  • Designed Conceptual Data Model based on high level data requirements and data sources
  • Upon a detailed review of data requirements with Business Systems Analyst and profiling of data where possible, drafted Logical Data Model which after initial review by Lead Divisional Data Modeler was further reviewed by the project team consisting of Product Owner, Project Manager, Technical Lead, BSA, LDDM, DBA, developers, Data Analysts and business users; After review, feedback and model updates, data model was peer - reviewed by other modelers prior to final approval by LDDM; Due to prior experience and intimate knowledge of Bank Data Warehouse data structures and Capital One data modeling process and standards, was tasked to train and mentor new and junior modelers on existing models and modeling guidelines
  • As Agile team member, participated in backlog grooming sessions to prepare stories for future sprints; After sprint planning, defined tasks, assigned level of effort and tracked progress in VersionOne Agile Project Management tool
  • As Confidential Engagement Manager for Capital One Services contract, managed 5 resources on 3 projects, approving timesheets/invoices/leave requests and providing revenue forecasts in addition to other administrative tasks

Confidential, Reston, VA

Senior Principal Consultant (Data Modeler)

Responsibilities:

  • Delivered Logical Data Models based on data requirements provided by business customer; Subsequent to the review and approval of LDM by Data Architect, coordinated with Database Administrator in development of Physical Data Model, and participated in PDM review with Platform DBA to provide feedback and responses to obtain final approval
  • Continued collaboration with Business Systems Analyst in documentation of Source to Confidential Mappings, worked with ETL developers in correct implementation of transformation logic, and helped business with User Acceptance Testing
  • As one of the principal Bank Data Warehouse modelers, was invited by Enterprise Modeling Services to provide guidance in integration of BDW entities dealing with loans and deposit accounts information into Enterprise Logical Data Model which at the time was exclusively based on credit card business

Confidential, Fairfax, VA

Technical Manager (Business Analyst)

Responsibilities:

  • Joined development team, with express task of delivering the data model for a management system in support of Confidential ’s Trade Finance Facilitation Program to facilitate issuance of loans and credit guarantees for import/export transactions
  • Organized requirements gathering and review sessions with business users
  • Analyzed requirements and business process flows
  • Developed Logical Data Model including Entity Relationship Diagram and Entity/Attribute lists based on the requirements
  • Participated in Business Process Model and Screen review sessions and developed use cases based on process flows
  • Provided guidance in the development of database and produced guidelines for data preparation and migration
  • Reviewed test plan, test data and test cases, and participated in QA unit and integration testing

Confidential, Fairfax, VA

Senior Consultant (Systems Engineer/Analyst)

Responsibilities:

  • Reviewed user requirements with Census stakeholders, analyzed functional requirements, business processes and use cases; Enhanced the Logical Data Model (LDM) for Assignment and Time/Expense Management modules of hand-held computers used by field staff in Address Canvassing operation
  • As primary point of contact on the LDM team for Group Quarters, Census Coverage Measurement and Field Verification operations, organized meetings, conducted reviews and coordinated with other teams with stakes in LDM (including Mission/Mobile databases, Internal/External Interfaces and Business Intelligence)
  • Conducted an impact analysis of the new operations’ requirements on the existing data model and identified new data elements by studying the instrument specifications, user requirements and interface control documents (ICD); As a member of Data Validation team, developed validation rules for all external interfaces input/output data based on ICD’s and issued recommendations for modifications of ingest/extract codes after studying test results
  • Acted as on-site Project Manager for Confidential six-member team by delivering weekly and monthly status reports to Confidential COTR, producing revenue forecasts for Confidential and tending to the administrative tasks in support of project resources

Confidential, McLean, VA

Principal Information Systems Engineer/Analyst

Responsibilities:

  • Collected and analyzed requirements for enhancement of a maintenance management system (EMIS) in support of Operation Iraqi Freedom for Confidential Program Management Office
  • Prepared SOW and devised project plan by defining tasks, level of effort and work breakdown structure
  • Designed and developed the necessary database objects in support of the enhancement tasks
  • Developed test plans and test reports for Operation Safe Commerce demonstrations of Supply Chain Security sponsored by Confidential of Seattle/Tacoma and New York/New Jersey; Set up RFID lab for component testing of various technologies for asset identification and location tracking
  • Developed test cases/scripts for lab and field tests
  • Produced software design documents, designed and developed Actuate Reports of Personnel Action Tracking for HR and Accident/Ticket Reports for Fleet management systems on MAXIMO for Department of State

Confidential, McLean, VA

Lead Database Management Specialist

Responsibilities:

  • Designed and developed a database for tracking training and deployment of over 40,000 passenger screeners in over 400 airports participating in the Strategic Airport Security Rollout program of Transportation Security Administration
  • Provided training and helpdesk support with scheduling software (Schedule Source)
  • Implemented ETL process for the Maintenance Management Data Solution (MMDS), integration of over 150 Maintenance Activity sites data for the Confidential
  • Automated daily rollup process and notification of data transfer failures
  • Provided training and helpdesk support for BI analysis tool (Oracle Discoverer)
  • Conducted process model review of ILDSS, a web-based application designed to improve efficiency and effectiveness of Confidential ’s Integrated Materiel Management Center logistics personnel; Performed data mapping and data conversion tasks
  • Defined and implemented Command Performance Metrics in collaboration with functional domain analysts
  • Devised test plans for Network Response Test and stress tests; Produced user manual and training documents
  • Conducted user training sessions on ILDSS for Item Managers and administration training for DBA/SA

Confidential, McLean, VA

Senior Application Systems Analyst

Responsibilities:

  • Provided data management and application development support in the migration of Automated Supply Support Analysis Tool, an Access application, to an Oracle-based Web application at Confidential - Confidential AFB
  • Conducted data migration, developed Forms and Reports using Oracle Web-DB Portal and provided on-site training
  • Contributed to the configuration of a backup database sever for the Census application and conducted a series of validation tests of replication process to ensure data parity and synchronicity; Participated in development and testing of the closure module of the Census 2000 Tracking System;
  • Designed and developed various summary and detail status reports for different stages of office closure process

Confidential, McLean, VA

System Test/QA Engineer

Responsibilities:

  • Produced Software Requirements Specification, design documentation, test plans, user manuals, tutorials and training documents for several applications developed for Confidential ’s Integrated Sustainment Maintenance (ISM) program which integrated for the first time, supply, maintenance and transportation data of over 100 maintenance sites and helped reduce repair cycle time and cost of maintenance by over $25 million a year
  • Conducted Y2K system certification testing of the entire Executive Management Information System (EMIS) including front-end applications and back-end database management system by developing test plans in compliance with Confidential guidelines and coordinating with an Independent Verification and Validation (IV&V) test team in conducting the tests and produced the certification test report ahead of schedule

Hire Now