Sarah J Duran Email & Phone Number

Stafford, Tx, Us

Houston, Tx, Us

Houston, Tx, Us

- Certified EPIC 2015 - Clarity Data Model ASAP (Emergency Department) Module- Responsibilities include development and analysis of data models, capturing and cataloging of business and technical metadata, development and enforcement of Data Governance standards, policies and procedures. - Participates in the gathering, review, interpretation of functional requirements and translates these into IT requirements by utilizing SDLC techniques. - Develops and manages relationships with the business users to ensure strategic use of the institution’s data assets. - Assists in confirming, assessing and modeling the current state of patient data repositories, including disease registries and other sources. - Contributes with development of business naming standards, consistent data definitions, data aliases and documenting the business rules of the enterprise. - Ensures the business metadata definition of all data attributes and entities are electronically catalogued in the metadata repository and that the data asset metadata is accurate and available to those who need it. - Actively participates in the identification of data and solution patterns as well as taxonomies.- Along with the Data Modeling Team, participates in modeling patient data for reuse in clinical data warehouse and reporting.- Assists in the development of policies and procedures for the creation of an Enterprise Data Management Framework and systems interoperability including mapping artifacts to a data architecture framework and managing data / message requirements in an Enterprise Application Integration environment. - Participates in the enforcement of Data Governance standards, policies and procedures.- Skilled with: Data Modeling, Data Dictionary, Data Mapping, Data Merging, Data Migration, Data Profiling, ETL, ODS, DW, Data Quality Assurance.- Databases/Tools: SQLServer, Oracle, ACCESS, REDCap, SQL, SQL*Plus, PL/SQL.

Houston, Texas, Us

- Responsible for managing/maintaining data for multiple projects or research efforts.- Assists in the design, development, testing and implementation of interface maps and logic to translate data from source systems to application system.- Creates, supports, and troubleshoots tools or software used to manage data.- Develops and maintains quality controls for all research databases.- Performs quality assurance functions consistent with standard software development methodology during pre and post-production.- Designs database queries and compiles, analyzes, and reports statistical data related to data quality for research projects.- Interfaces with vendors and offsite researchers and coordinators.- Skilled with: Data Dictionary, Data Mapping, Data Merging, Data Migration, ETL, Data Quality Assurance.- Databases/Tools: SQLServer, Oracle, ACCESS, REDCap, SQL, SQL*Plus, PL/SQL.

- Managed medium project from inception to execution for Serious Adverse Event reporting. Developed and supervised resources and ensured appropriate management, and customer involvement for life of project utilizing various tools including iRise simulations. Translated customer business objectives into tactical plans and strategy and ensured approval through appropriate information systems governance structure. Ensured documentation was maintained as the project was changed or refined over time and communicated project status to customer and governance office. Ensured all internal and external standards and regulatory requirements were met.- Planned, executed, and managed large project consisting of twelve contractors and employees for analysis and planning that addressed the operational need of the institution for a Clinical Research application.

Brookfield, Wisc., Us

SDLC; Data Modeling; ETL; Data Mapping; Data Merging; Data Warehouse; Requirements Gathering; Data Flow Diagrams; Data Quality / Management; Database Management; PL/SQL Programming; SOX Compliance.

- Performed data mapping between diverse systems, developing a Data Dictionary (DD), and creating Extract/Transform/Load (ETL) processes to move data from a transactional data store to a Data Warehouse (DW).- Documented system workflows using automated visual tools and narratives. - Defined system functional requirements using workflow analysis, regulatory and standards review, standards of professional practice, and other relevant sources.- Prepared and executed test scripts and test plans. Documented results and provided feedback to responsible parties.- Performed analysis and documentation of an existing application and data mappings. Migrated and validated data from obsolete system to existing system utilizing SQL, SQL*Plus, and PL/SQL.

Sugar Land, Tx, Us

Managed team of 30 Oracle application developers and testers; Project Management; Task Assignment; Requirements Gathering; Project Scoping / Planning; Software Productization;

- Managed a group of thirty Oracle application developers and testers located across the US. Responsibilities include user interaction, requirement gathering, project management, task assignment, and developing and leading a mentoring program for all developers and testers. Assures adherence to client-specified standards for all developers and testers. Conducts QA reviews of development and testing work products. Monitors and improves quality of development and testing work products. Developed, tested, and implemented data models, packaged procedures, triggers, forms, and reports for a Laboratory Information System (LIMS).

Houston, Texas, Us

- Verified/approved database structures and data quality. Member of Oracle Designer Steering Committee to assure all data warehousing projects were properly utilizing Oracle Designer. Served as WRAP administrator for the application, and implemented productization methodologies.- Utilized Oracle Designer (CASE), PowerDesigner, and ErWin for process modeling and entity relationship diagrams (ERD).

Austin, Texas, Us

Mscis, Computer Information Systems

Bs, Computer Science

As, Computer Science

Bachelor Of Science (Bs), Computer Science, Statistics