Skills

• Requirements Management and Requirements Traceability: Team Foundation Server TFS , Rational Requisite Pro, Requirements Traceability Matrix RTM , Rally Software
• Business Process modeling / UML Diagramming: activity diagrams and process flows using Provision and Visio
• Data Modeling tools: CA ERwin, Embarcadero ER Studio, and Oracle-SQL Developer Data Modeler, Rational InfoSphere Data Architect IDA
• Data Management: Data Dictionary creation, Data element standardization, data governance.
• CM: Team Foundation Server TFS , Rational Clear Case
• Requirements Analysis: JAD, use cases, user stories, traditional declarative analysis, conceptual data modeling, and requirements traceability. Technical documentation.
• DBMS: ORACLE 11g
• Data Analysis / Data Profiling: SQL Developer, Reverse engineering of existing databases, Rule-Based data cleansing, metadata analysis, data migration and integration
• Data Architecture: Conceptual, logical, and physical data models for ER Normalized relational models and Dimensional Models / Star Schemas for data warehousing.
• Technical Writing: Design documentation, user guides

Summary: Experienced data architect, data and process modeler, and business analyst with exceptional analytical and problem solving skills. An eager, fast learner with the business acumen to understand complex business issues. Proficient in data management concepts with comprehensive knowledge of data engineering to include expertise in entity relationship modeling / transactional database applications, dimensional data modeling / star schemas, data warehouse design and development, metadata, data administration, data analysis and profiling, data quality, conceptual, logical and physical data models, database implementation Oracle , data modeling tools, and data administration. Experienced in requirements engineering to include requirements elicitation and analysis, JAD, use case / user story development, conceptual data modeling, business process modeling BPM , data mapping, and data requirements. Experienced in Agile and waterfall SDLC development methods.

Confidential

Sr. Business Analyst

• Supported governance activities in the Enterprise Data Branch by performing business requirements analysis and data modeling, conducting database design reviews and process improvement activities, and educating development teams on standards and the proper usage of data structures.

Sr. Technical Analyst for multiple EPA database applications

• Worked with customers to establish consistent data definitions and reference data domains to ensure quality standards were maintained during the data migration.
• Mapped data from multiple legacy applications to new data model. Created data standards and requirements for migration of data from legacy systems.
• Defined data requirements. Identified data dependencies and relationships. Updated physical data model for each sprint.
• Participated in development and analysis of high level functional requirements. Consulted with customers to determine system and functional requirements for future releases.
• DWH project: Created the conceptual, logical, and physical data models for a normalized ODS Operational Data Store based on requirements contained in XML schemas. Refined requirements by conducting interviews and facilitating data modeling sessions with business clients. Reviewed models at all levels with customer groups to discuss design issues and finalize business rules.

Sr. Data Architect for DHS ICE Integrated Decision Support System Data Warehouse

• Maintained the stage and production conceptual, logical, and physical data models along with related documentation for a large data warehouse project. This included confirming migration of data models from Oracle Designer to ERwin and updating the data models to correspond to the existing database structures.
• Investigated data sources to identify new data elements needed for data integration.
• Performed data analysis using SQL queries on source systems to identify data discrepancies and determine data quality.
• Updated or created new data models for each release. Generated database scripts from Erwin.
• Used ERwin to create report templates. Maintained and changed the report templates as needed to generate varying data dictionary formats as contract deliverables.
• Worked with the DBAs on maintaining existing, and creating new, database environments.
• Worked with test team members to help them understand data changes and write test cases.
• Maintained source to target mappings for data elements
• Designed data migration strategies and wrote business rule requirements for extracting data from sources.
• Supported enterprise data efforts to improve data accuracy, data quality, data security, data integrity, and data standards for the client.
• Prepared Data Management Plan DMP for each release.

Confidential

Sr. Data Architect

• Worked with subject matter experts to create business activity and workflow diagrams, perform data modeling, and support the development of DoD Architecture Framework DoDAF products: OV-7 Logical Data Models, SV-11 Physical Schemas using Embarcadero ER Studio , and OV-5 Operational Activity Models using Provision .
• Created an enterprise metadata repository consisting of both technical and business metadata. Participated in the development of the repository meta-model and of populating of data enterprise repository.
• Performed data analysis on multiple applications and oracle databases to identify data patterns for use in the metadata repository.

Sr. Business Analyst

• Met with customers to elicit functional requirements for an application designed to maintain Army budgets and manpower.
• Wrote requirements in the form of use cases, decomposing high-level requirements into processes and business rules.

Sr. Data Architect

• Technical lead on a DFAS Defense Finance and Accounting Services data mining data warehouse project designed to detect and prevent fraudulent payments.
• Conducted or participated in requirement gathering workshops and design sessions necessary to capture the business needs and develop models.
• Interfaced with business and technology stakeholders to clarify, analyze, and document business and data requirements. Performed data and functional analysis to support the elucidation of data requirements.
• Responsible for designing the dimensional data model, as well as creating the overall data and ETL architectures of the application including identifying business rules, specifying source to target data mappings, developing load strategies and execution schedules, and creating auditing procedures.
• Conducted data profiling to insure that the available data could support business needs.
• Clarified technical specifications from customer representative to developers.
• Designed and developed target dimensional data structures for the data warehouse and staging structures required to support the ETL and data integrity processes.
• Created the data dictionary and documented business and data transformations and data quality issues
• Developed reusable architectural data components and identified opportunities for shared data and integration components.
• Provided detailed impact analysis assessments for data architecture and infrastructure components.

CGI Federal, Sr. Data Architect

• Developed and maintained the dimensional and normalized data models in an Oracle 10g database environment for a CMS Medicare claims data warehouse and a transactional auditing application.
• Managed the metadata repository containing data elements, semantics and business rules.
• Developed plans for transitioning of the physical data models to database implementation. Prepared the database security and access strategy.
• Created sizing estimates and scaling approaches for the production data warehouse.
• Interacted with business and technical resources and served as primary liaison to customer DBAs.
• Responsible for maintaining customer deliverables: ERDs, Data Dictionary, Data Mappings, and Database Implementation Plans.

Business Analyst

• Led requirements gathering activities and JAD sessions to determine, analyze, and document business processes, fundamentals, and strategic data needs.
• Performed business data flow analysis. Created UML use cases and activity diagrams to support the functional requirements and document the Business Process Modeling activities.
• Supported multiple OLTP / transactional and data warehousing development projects.
• Defined and documented logical and physical relational database design using Oracle Designer.
• Supported data conversion activities and coordinated the resolution of conversion and data migration issues.
• Created database development environments, and collaborated with the DBA team to ensure proper deployment of data structures into test and production environments.
• Coordinated the implementation of security measures across multiple database applications to comply with IT Security initiatives and financial audits.
• Participated in and led requirements gathering sessions to determine data and reporting requirements for a 50 TB data warehousing project consisting of 4 data marts.
• Documented the requirements for ad-hoc queries to be run against the CDR data warehouse. Coordinated the completion of these queries between the requesting and developing organizations.
• Wrote test cases and tested application upgrades for UAT and System Tests.