Data Modeler Resume Format in Word Free Download

Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

Maya Bohigian

maya@yahoo.com

Education: B.S, MBA 

Security Clearances: DoD Top Secret, DHS/ICE T2  

                                                             

Summary: Experienced data architect, modeler, and 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, data warehouse design and development, metadata, data administration, data analysis and profiling, data quality, conceptual, logical and physical database design, database implementation (Oracle), modeling tools (ERwin, Oracle Designer, ER Studio, Visio), and data administration.  Experienced in requirements engineering to include requirements elicitation and analysis, JAD, Use Case development, conceptual data modeling, business process modeling (BPM), data mapping and data requirements.

Highlight Technologies, 2009 - present

Data Modeler / Data Architect  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.

Inscope Solutions, 2008 - 2009

Sr Data Architect / Data Analyst at Army National Guard

¨       Worked with subject matter experts and other analysts to create business activity and workflow diagrams, perform data modeling, and support the development of DoD Architecture Framework (DoDAF) products using Embarcadero ER Studio and Metastorm Provision.

¨       Performed data analysis in support of a data migration process from a SQL Server database to an Oracle database. Extracted data and relationships from the SQL Server database and mapped data elements to the new Oracle database. 

¨       Performed data analysis on multiple applications and oracle databases to identify data patterns for use in the metadata repository.

¨       Created a metadata repository consisting of both technical and business metadata. Participated in the development of the repository meta-model.

¨       Standardized database and ETL documentation for development teams.

SRA, 2007 - 2008

Business Analyst / Business Process Modeler, 2008

¨       Met with customers to elicit functional requirements for an application designed to maintain Army budgets and manpower.

¨       Developed functional use cases, process models, and storyboards, along with documenting business rules.

Sr Data Architect, Business Analyst, 2007 - 2008

¨       Technical lead on a DFAS (Defense Finance and Accounting Services) data mining data warehouse project designed to detect and prevent fraudulent payments.

¨       Responsible for designing the dimensional data model, as well as creating the overall data and ETL architectures of the application including determining business rules, specifying source to target data mappings, developing load strategies and execution schedules, and creating auditing procedures.

¨       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 gather, analyze, and document business and data requirements.

¨       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

¨       Perform data mapping between various IT systems.

CGI Federal, Sr Data Architect, 2006 - 2007

¨       Defined and developed complex data architecture solutions for a (CMS) Medicare claims data warehouse and a transactional auditing application.

¨       Developed and maintained the dimensional and normalized data models in an Oracle 10g database environment.

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

Nextel Communications Inc., Sr Data Architect, Business Analyst, 1999 - 2006

¨       Supported multiple OLTP / transactional and data warehousing development projects.

¨       Analyzed and reviewed functional specifications and requirements to determine best data design approach and translate business requirements into data models.

¨       Defined and documented logical and physical relational database design using Oracle Designer.

¨       Led requirements gathering activities and JAD sessions to determine, analyze, and document business processes and fundamentals, and strategic data needs.

¨       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 Sarbannes-Oxley audits.

¨       Worked closely with clients to capture and analyze business objectives and strategic analytic requirements.

¨       Created UML use cases and activity diagrams to support the requirements and BPM (Business Process Modeling).

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

International Research Institute (INRI), Lead Data Warehouse Analyst, 1997 - 1999

¨       Evaluated the capabilities of several BI reporting tools. This evaluation led to the selection of a Decision Support tool for long-term use by the customer. Responsible for designing and creating user reports (Brio). In this capacity, also determined reporting requirements and helped the customer to interpret reports and analyze data. 

¨       Ran benchmark studies / prototyping on Oracle and Red Brick database servers.

¨       Responsible for the date warehouse architecture (ODS, data warehouse, data marts), dimensional design of the date mart tables (using ERwin) and defining the ETL processing

¨       Responsible for defining and maintaining the metadata repository

TASC, Inc., Sr. Database Modeler / Analyst, 1995 - 1997 

¨       Responsible for the design and development of a database to store digital terrain data requirements for modeling systems and simulators. Participated in the requirements analysis and the data definition for the Oracle based system. Worked with business users to translate requirements, process flows, and business rules into data models and GUI designs.

¨       Used ERwin CASE tool to produce the data model and generate scripts to create the database environments

¨       Responsible for the implementation all Oracle database objects including the implementation of appropriate access and security measures.

Skills

Data/ETL Architecture, ER normalized models and Dimensional Modeling

Data Modeling tools: Erwin, Oracle Designer, Embarcadero ER Studio

Enterprise architecture: Metastorm Provision, Visio

Data analysis / data profiling: SQL, SQL Developer, Rule-Based data cleansing

DBMS: ORACLE 10g, SQL Developer, Toad

Data visualization: Many Eyes, Excel, Provision

JAD / Requirements analysis, use cases

Business Process Modeling

Operating systems: UNIX, Windows

Version control/defect tracking: PVCS, Visual SourceSafe

Project Management: MS Project

Strong analytical skills

CLASSES

Dimensional Modeling in Depth by Ralph Kimball and Margy Ross

Download Resume Format