We provide IT Staff Augmentation Services!

Data Architect / Data Modeler Resume

Falls Church, VA

SUMMARY:

  • Over 15 years of highly technical experience in Information Technology and telecommunications areas for private, government, and non - profit clients in the US and overseas.
  • Extensive experience in financial, telecommunications, service, and health industries.
  • Specialized in Logical/Physical Database Design of OLTP systems, Operational Data Stores, Data Warehouses, and Data Marts, Data Conversion and Migration
  • Excellent oral and written communication/presentation skills to both technical and non-technical people.

PROFICIENCIES:

  • Develop transactional and dimensional data models using E-R studio and Erwin.
  • Define data requirements and designing databases to satisfy client business objectives.
  • Participate in analysis, design reviews, and assisting with developing functionality to specific system components.
  • Develop DDLs and work with DBAs to deploy in multiple Environment.
  • Develop Data Modeling Design standards and guide lines, Data Dictionaries, and Naming Standard/SOPs
  • Develop and lead the effort to collect, compile and analyze data, from various structured and unstructured sources, to perform statistical and usage analyses.
  • Conduct Business Analysis sessions with the client to understand Legacy system, Conversion rules & objectives.
  • Conduct detailed Data Profiling tests to check data consistency & quality.
  • Perform accurate comparison of data between columns of source and target.
  • Develop dashboards, scorecards, story, Trending charts using QuickSight and Tableau.

TECHNICAL SKILLS:

Data Architecture: Data Modeling / Data Architect / Data Warehouse / Data Analyst / Data Integration / Master Data Management / Data Strategy

Case Tools: Erwin, ER Studio, IBM Data Architect

Methodology: Hoberman, Ralph Kimball, Inmon

Databases: Redshift - AWS, Oracle11g, SQL Server, Sybase, MySQL, Netezza, MS Access

Languages: PostgreSQL, SQL

Other Tools: Visio, MS Project, Microsoft suite, QuickSight, Tableau

PROFESSIONAL QUALIFICATIONS:

Confidential, Falls Church, VA

Data Architect / Data Modeler

Responsibilities:

  • Conducted Business Analysis sessions with the client to develop Business Requirements, Data lineage, and objectives.
  • Developed logical, and Physical models using Embarcadero modeling tool.
  • Performed multiple data migration strategies based on integration strategies.
  • Managed and maintained data dictionary and data lineage for all entities in the models.
  • Developed user datatype, domains, and managed users in Embarcadero modeling tool.
  • Performed Data Profiling, Data Quality and data tests working team of developers.
  • Developed Star Schema by denormalization - Mapping Document, Audit Dimensions, including Aggregation.
  • Developed Optimized Data Models for presentation layer for Amazon QuickSight and Tableau.
  • Developed Story, Visuals, and Dashboards for both QuickSight and Tableau.
  • Developed SQL scripts, and oversee deployment of databases.
  • Developed naming Standards, Enterprise Data Dictionary, Abbreviations in the Embarcadero repository environment.

Confidential, Alexandria, VA

Senior Data Modeler/Analyst

Responsibilities:

  • Performed requirement for new projects. Developed Conceptual, logical, and Physical models using Embarcadero modeling tool.
  • Develop models on 3NF, Supertypes, Subtypes, and Abstraction.
  • Managed and maintained data dictionary and data lineage for all entities in the models.
  • Developed user datatype, domains, and managed users in Embarcadero modeling tool.
  • Performed multiple data migration strategies based on integration strategies.
  • Performed data tests working team of developers.
  • Performed enhancement on existing models/Databases based on new requirement - developed enhanced models and DDLs.
  • Developed SQL scripts, and performed numerous DBA functions in multiple environments.
  • Developed naming Standards, Enterprise Data Dictionary, Abbreviations in the Embarcadero repository environment.
  • Coordinated with Data Warehouse team with enhancement and new incentives.

Confidential, Fairfax, VA

Data Analyst

Responsibilities:

  • Analyze business plans and strategies. Performed data analysis, analytics, and market research for various instruments.
  • Analyzed the Historical data in the Legacy system to define architecture and strategy.
  • Develop, update, and apply data models to generate reports and analysis.
  • Retrieve, validate, format, and organize a variety of data from many sources.
  • Conduct data analysis to answer standard or recurring inquiries and identify trends, correlation, and other relationships in data sets.
  • As part of my technical improvement, attended numerous on-line sessions for Data Modeling and Data Architecture.

Confidential, Alexandria, VA

Senior Data Modeler/Architect

Responsibilities:

  • Performed Database model reviews based on enhancement of existing models. Reversed engineered existing models to add new entities and relationship.
  • Supported development team with implementation issues. Worked with developers to ensure requirement and objectives were met.
  • Performed analysis, user requirement for new projects. Developed Logical and Physical Models for new projects.
  • Developed EDW Data Modeling Design standards and guide lines, Data Dictionaries, Source Mapping.
  • Developed several star schemas for Confidential reporting group. Performed data model conversion from IBM Data Architect to ER Studio.

Confidential, Fairfax, VA

Data Analyst

Responsibilities:

  • Analyzed business plan, marketing plan, marketing strategies and operational procedures Strategic Trader.
  • Performed market research in the securities field. Performed data analysis, analytics, and market research for various instruments.

Confidential, Washington, DC

Data Architect/ Data Analyst/Data Modeler and Business Process Analyst

Responsibilities:

  • Developed Business requirement document for multiple projects.
  • Performed data analysis, data profiling and data quality tasks.
  • Developed Conceptual, Logical, and Physical Models for multiple projects.
  • Designed Physical Models including EDW as well as Multi-Dimensional models with SCD and CDC concepts.
  • Modeling Developed naming standard and Data Mapping document from source to Data marts.
  • Developed strategy for MDM and Data Governance. The Environment is Embarcadero ER Studio and SQL Server.

Confidential, Washington, DC

Data Architect and Business Process Analyst/ Project Lead

Responsibilities:

  • Developed Conceptual, Logical, and Physical Data Models Enterprise-wide for all Confidential functional areas.
  • Performed JAD sessions to identify all Processes/System/Data Entities.
  • Reverse engineered and developed migration strategy for all manual forms, reports and other data sources into data models for automation.
  • Identified areas for process Improvement and performed data quality profiling.
  • Developed data strategies for Data Governance. Implemented Master Data Management for key entities to provide foundation for Enterprise-wide reporting.
  • As part of the implementation, developed a scope/high level Project Plan to identify tasks and deliverables for implementation for Finance and Operations.
  • Developed all reporting requirement and functional requirement for all reports.
  • Developed multi-Dimensional schema for reporting purposes with Source-to-Target mapping. Developed all Queries for reporting.
  • Developed test Plan, procedures, and test cases for end-to-end of data transformations to reports.
  • The Environment is Embarcadero ER Studio, Netezza and Oracle.

Confidential, Falls Church, VA

Business and Data Analyst / Project Lead

Responsibilities:

  • Developed reports to integrate hospital and private physician data based on services provided to patients at various locations for day-to-day analysis, and projection of new facilities and services.
  • Demographic data was also captured for growth potential.
  • Developed business requirement.
  • Developed the conceptual, logical, and physical models based on Data Integration across multi-sources.
  • Performed data profiling, data quality and data mapping (Source-to-Target).
  • Developed functional requirement for reports. Managed the development and production of BI reports.

Confidential, Falls Church, VA

Senior Data Warehouse Architect/Analyst/Lead

Responsibilities:

  • Developed requirement for large historical dataset for the Confidential ’s Confidential division.
  • Performed data quality profiling for data completeness, integrity, duplication, validity in Oracle tables.
  • Developed SQL, test procedures and generated reports concerning the above tests. Worked with ETL team to develop Data Dictionary and other data relevance information.
  • Developed the data architecture, data models, Data mapping for Star Schema, and migration strategies to meet reporting requirement.

Confidential, Falls Church, VA

Senior Data Architect

Responsibilities:

  • Developed the Charter, Project plan, Roadmap, and Methodology for Computing Services Directorate (CSD) Data Management strategy project.
  • Developed Functional - Process - System - Data map for an enterprise-wide Metadata.
  • Analyze function - process map that enables CSD to improve its business processes.
  • Developed the Conceptual, Logical, and Physical models.
  • Developed Data Map and lineage, data interaction to manage data redundancy and data dependency that helped to develop a data impact analysis for an Enterprise Data warehouse.
  • Initiated Enablers for Process Improvement, Configuration management, Data integration, and Data governance, and MDM.

Confidential, Centreville, VA

Technical Lead / Senior Business Analyst

Responsibilities:

  • Managed the Production / Analysis / Design and enhancement of management reports for Confidential LLC.
  • Developed requirements and preformed Analysis/Design and Implementation of Financial reports.
  • Developed user requirement, functional requirement, Multi-Dimensional models, ETL data mapping, and design in the Multi-Dimensional logical and OLAP schema.
  • Managed the pre and post deployment of reports.

Confidential, Chantilly, VA

Technical Lead / Senior Business Analyst

Responsibilities:

  • Provided project management support and developed business requirement for data warehouse projects using JAD sessions and interviews.
  • Developed the Functional Specifications document to capture all business descriptions and business logic.
  • Developed process flows and data flows.
  • Developed Conceptual, Logical, and physical Data Models.
  • Performed the Profiling, Data Quality, Mapping for the Logical and Physical data model to support applications using Multi-Dimensional logical and OLAP schema.
  • Managed the development of the ETL logic (Informatica).
  • Developed test plan and test scripts for end-to-end testing of application. Managed a team of 12.

Confidential, Reston, VA

Business Lead / Financial Analyst

Responsibilities:

  • Developed the business plan, marketing plan, marketing strategies and operational procedures for a start-up US securities trading company.
  • Performed market research in the securities field. Assisted in the development of a portfolio of trading products.
  • Managed the requirements definition and product development. Performed fundamental and technical analysis techniques. Skilled in the use and interpretation of a variety of investments tools.
  • As part of a Business Process Outsourcing (BPO) project, managed the establishment of an overseas business unit.
  • Developed, including the development of all requirements, evaluation/selection of technology platforms and implementation of systems and processes to allow real time trading on US exchanges.
  • Recruited, trained and directed a team of market analysts to perform technical analysis and fundamental analysis of securities investment instruments.

Confidential, Arlington, VA

Project Lead/Business Analyst

Responsibilities:

  • Managed the development of Data Warehouse in the Finance industry. Full-life cycle experience, including Requirement gathering, analysis, Extract-Transformation-Load (ETL), Data Warehouse Data modeling, and architecture.
  • Developed the vision statement for strategy and architecture as well as provided solutions on all aspects of Data Warehouse for Ad-hoc query, OLAP and data mining tools.
  • Performed Business Requirement, Project Management, Analyst and Design for Confidential
  • Managed the development team responsible for web services and production as well as the development and websites for various businesses.
  • Customers include maurinet.com, srm-consulting.com, a-sportsupplements.com, etc.
  • The requirement was performed using RUP/Use Case methodology and development was mostly based on the Agile system development approach.
  • Managed all the Web site planning, development, administration, and information content and administrative procedures to ensure integrity of website contents.
  • Managed the development of internet and intranet system technologies.
  • Managed the setup and implementation of new trouble desk reporting with a team of 5 staff in providing timely telephone, e-mails, system administration, and applications.
  • Provided senior level support to Confidential Y2K project office in the areas of biomedical devices and consolidated mail-out pharmacy.
  • Managed the entire Year 2000 life cycle in the Assessment, Renovation, Validation, and Implementation phases. Developed Access Databases for entire project management.
  • Wrote briefing materials on a regular basis to present status, progress, and plans for congressional hearings and Government Audit Office, for issues with respect to Confidential Y2K.

Hire Now