We provide IT Staff Augmentation Services!

Data Modeler/data Analyst / Data Architect Resume

PROFESSIONAL EXPERIENCE

 

Confidential

Data Modeler/Data Analyst / Data Architect

Responsibilities:

  • Responsible for the analyzing data, creating and maintaining conceptual, logical, dimensional, relational, and physical data models for EDW schemas utilizing Oracle SQL Developer Data Modeler tool
  • Creating / modifying data models, normalizing and /de - normalizing schemas to ensure data integrity
  • Participating in data architecture discussions and database design decisions
  • Collaborating with USPTO EDW teams (contractors and government employees) in order to refine requirement, to develop and create complex DDL for structure and complex enterprise database. Implementing modification to EDW data architecture (Facts and Dimension tables)
  • Creating DDL/DML scripts and executing the scripts in Development, Test environments
  • Creating system and user’s documentation including data dictionaries, software design documentation, data architect standard, and data consumer documentation for several subject areas
  • Monitoring changes in backend and for continuity with physical and logical models
  • Creating/Updating Source-to-Target Mapping logics and business rules
  • Creating and updating EDW database table in lower environments
  • Performing data analysis/documenting finding for source system, EDW schema, Views, MViews utilizing SQL Developer
  • Participating in Testing Phases- performing data, security, system testing
  • Participating in the project process improvement group

Confidential

Data Architect

Responsibilities:

  • Highly skilled in data modeling and enterprise database design and implementation
  • Designed the US Courts EDW CM/ECF NG Bankruptcy and District logical/dimensional data models
  • Worked and collaborated with business owner, validated requirements, presented the proposed database architecture design for two business areas (Bankruptcy Schedule I&J) and obtained their feedback and approval
  • Collaborated and working closely with Business Owner to ensure meeting their expectation
  • Presented Business Object BI solution and ad-hoc functionality design and engaged the business owner in all aspect of the system development cycle
  • Created the system design documentation including data dictionaries for several business areas and software design documentation
  • Providing technical support and responsible for developing Logical, Physical/Dimensional data models using ERWin modeling tool for several business areas
  • Creating Source-to-Target Mapping logics and business rules, working closely with ETL team implementing logics
  • Creating database tables, data definition language (DDL) scripts, Sequences, Triggers etc.,
  • Participating in reports, data testing, validating source data using SQL to ensure data integrity
  • Supporting project management by providing weekly project status, creating weekly presentation deck, provided status to client on a weekly bases, creating project schedule

Confidential

Senior Solution Engineer/Quality Assurance

Responsibilities:

  • Led the Quality Assurance effort for New Electronic Payment Program (NEPP) activities
  • Provided a comprehensive quality assurance roadmap, focuses on the current pain-points observed across the program.
  • Reviewed all contractual deliverables and provided feedback
  • Established and satisfied highly challenging and complex system wide information systems requirements based upon the analysis of Gap analysis, policies and regulatory demands
  • Developed meaningful metrics for measurements
  • Provided expert on quality of performance against plan

Confidential

Sr. Data Analyst & Data Modeler

Responsibilities:

  • Led the data analysis and standardization efforts for the DoC BAS cross subject area data concepts in Agile environment
  • Responsible for determining standards and performed detail data analysis and released finding of the As-Is and To-Be data standards in 2 weeks scrums incrementally
  • Responsible for data validation, designing data models for conformed/common data concepts standard and data values
  • Created Canonical (conceptual) Logical and Physical Data models (relational and dimensional) for Core Financial, and cross concept such as Vendor, Location, Customer, Employee etc., using the Embarcadero ER/Studio Data Architect XE6 data model
  • Design Relational and dimensional databases models. defined source-to-target mapping, created taxonomy (data dictionary), defined input/output logic for Oracle ETL process
  • Created data model Table Index, Sequences and Triggers using SQL Scripts. Validated data using complex SQL, Utilizing Toad for Oracle 11.6 - Created/Dropped Oracle Database Tables, Imported/Exported data from various source systems/files, wrote several SQL scripts to analyze data or to send data call request to the DoC Bureaus
  • Managed project risks and issues, (identified, tracked and monitored) using risk/issues logs. Assisted in the project schedule creation and provided project status on a bi-weekly basis

Confidential

Sr. Data Architect/Modeler

Responsibilities:

  • Led the data analysis support for DoD and VA
  • Validated data for accuracy and consistency using SQL
  • Presented and communicated finding to management
  • Provided risk log and issue log reports

Hire Now