Skills

Relational and dimensional methodologies logical, object and physical data modeling experience with Service Oriented Architecture and XML Schema design and creation database administration and development strong people skills strong analytical skills ability to lead and build strong technical teams, ability to collaborate in a team environment ability to work independently ability to handle multiple projects or issues concurrently.

Industry Experience

Medicare, Health Care, Food and Drug Administration, Financial Services, Benefits Management, Venture Capital, Retail Space Leasing, Energy, Spacecraft Communications and Spectrum Management.

Tools

• Hands-on manager responsible for day to day operations of Epic Clarity databases, custom data warehouse and analytic services.
• Installs upgrades and supports SQL Server, QlikView and Epic products.
• Manages team of data analysts, DBA, and report writers.
• Oracle, DB2, SQL Server, Erwin, Infomatica, DataStage, Business Objects, MicroStrategy, QlikView, Epic Clarity, Cogito Data Warehouse.
• Analyzing and restructuring the data stores that support all reporting across the organization.
• Analyzing and restructuring the ETL processes and SQL Server jobs that populate the organizations data stores.
• Documenting a completely undocumented data environment and architecture.
• Implementing QlikView applications for Infection Control, Operating Room Services and Enterprise Metrics.
• Create exports and reports using the Epic Clarity database and Cogito Data Warehouse for business users throughout the organization.

Created extract processes for National Healthcare Safety Network NHSN and National Database of Nursing Quality Indicators NDNQI data submissions.

Confidential

Contractor - Lead Data Architect

• Contractor providing data modeling support for the Centers for Medicare and Medicaid for the Quality Measures Assessment Tool QMAT contract:
• Contractor providing data modeling support for the Centers for Medicare and Medicaid Health Information Technology for Economic and Clinical Health HITECH Act contract:
• Designed and developed a database and reports to support the CMS Audit Strategy initiative. Database functionality included processes to load flat files received from external sources, processing of data to perform statistical analysis and reporting.
• Designed the data model for QMAT for support of the Centers for Medicare and Medicaid Accountable Care Organizations ACOs Pioneer project. Started with the enterprise logical data model ELDM to identify the entities pertinent to QMAT requirements and extended the ELDM out to include entities for quality measures and performance scoring. Followed strict standards and guidelines for the design.

Confidential

Contractor - Lead Data Architect

• Contractor providing data modeling support for the Centers for Medicare and Medicaid Enterprise Data Services Contract EDSC :
• Contractor providing data modeling support for the Centers for Medicare and Medicaid Development Effort Consolidation Contract DECC :
• Responsible for data modeling for the End Stage Renal Disease Quality Initiative Program ESRD QIP . This project required a new logical and physical data model using the CMS modeling standards, naming standards and metadata standards. The client was very satisfied with the models and deemed them the gold standard for the DECC program.
• Created the data conversion plan for loading incoming data into the End Stage Renal Disease Quality Initiative program database. Reviewed Informatica mapping and business logic for accuracy.
• Responsible for the completion of the logical and physical data models for the enterprise Measures Engine. Picked up the partial design, worked with the project team to quickly understand the requirements, redesign the models and work with the DBAs to get the database created.
• Responsible for the redesign of the logical and physical data models for the Physician Quality Reporting System Group Practice Reporting Option project PQRS GPRO . The previous model did not use modeling best practices or complied with the CMS standards. Completed the redesign in record time to allow the developers to meet their deliverables.
• Designed an XML schema for the PQRS GPRO project.
• Responsible for data modeling for Provider and Beneficiary information. This project required a new logical and physical data model using the CMS modeling standards, naming standards and metadata standards.
• Created mapping documents to detail data coming from the source systems to the conformed structures, Provider and Beneficiary profiles and Identity Resolution tables.

Confidential

Contractor - Data Architect/Database Developer

• Contractor who provided database design and development support on a federal contract for spectrum management:
• Created and configured Oracle Streams and Advanced Queuing to move data between locations of differing security levels.
• Performed analysis of three databases to determine inconsistencies in structures. Documented findings and presented them to the customer.
• Performed analysis of Data Integrator ETL code to document transformations and defaults.
• Performed review of Java code to confirm transformations and derivation of data loaded into a database.
• Created mapping documents tracing legacy data to XML schemas to staging tables to final data stores.
• Created Oracle stored procedures to accept an XML document, store it in XML DB, parse the document into specific nodes, extract data elements from the nodes and load the data into database tables.

Confidential

Contractor - Lead Data Architect

• Contractor who served as a database and architectural engineer for an enterprise infrastructure supporting a federal contract with the Department of the Treasury:
• Designed and implemented logical and physical data models for an operational data store, data marts, data warehouse and business analytics solutions. Performs relational and dimensional modeling.
• Designed and created XML schemas to support receipt of information from external entities and export of data to government agencies.
• Maintained data mappings relating the flow of data from the XML schemas to staging to operational data stores. This includes documentation of business rules and data transformations.
• Developed processes and procedures for the business intelligence and database teams to follow best practices for database design, implementation and administration.
• Participated in full software lifecycle development managing and tracking changes in a number of modeling and database environments which include development, integration, testing and production.
• Performed data analysis to validate data quality.
• Worked closely with the business users in deriving new data requirements and monitoring data usage.
• Managed the Oracle DBA team and created the Database SOP document for the team.
• Created work breakdown structures for new projects.
• Monitored project schedules and tasks. Did weekly status reporting of issues and risks.
• Participated in discussions with federal agencies, project managers and technical teams relating to project development and issues.

Confidential

Supervisor of Data Architecture

• Lead data architect who participated in strategic and tactical initiatives to support the data management needs at the enterprise level and within each business unit:
• Worked with the Business Intelligence team to design and build both dimensional and relational data stores to support reporting and analytic needs.
• Worked with business owners to design enterprise level logical data models to document business information.
• Created analysis and data mappings to migrate legacy data to new data stores.
• Designed object models and XML schemas to support Service Oriented Architecture needs.
• Developed best practices for data modeling for the organization.
• Worked on the Demand Management initiative with the responsibility to architect the points of engagement for the data architects.
• Worked on the startup of the Information Management initiative as it relates to data governance.
• Supervised the team of data architects. This included hiring and monitoring performance.

Confidential

Contractor - Information Architect

• Contractor who participated in strategic initiatives and support of business analysts and developers across all business units:
• Reviewed design of existing data warehouse to recommend new design for current business needs.
• Maintained dozens of logical and physical models.
• Worked with business analysts to gather requirements in order to model for current business needs.
• Ran Informatica imports to update sources and targets as data objects change.
• Coordinated DBAs in modifying databases according to approved data models.
• Maintained data dictionaries and data inventories.
• Participated in initiatives to implement data strategies across business lines.
• Participated on teams using Agile Software Development practices.

Confidential

Contractor - Data Modeler

• Contractor with the Centers for Medicare and Medicaid Services enterprise data analysts/modelers:
• Developed naming standards for the tables and columns of the enterprise data model.
• Participated in peer review of data models.
• Developed plan for the migration and validation of enterprise metadata from the AllFusion Repository to the Meta Integration Technology Repository.
• Participated in the redesign of the enterprise Medicaid data model.

Confidential

Contractor - Data Modeler

• Contractor with the financial reporting team:
• Conducted interviews with the business to gather requirements for data needs.
• Developed logical and physical data models for data marts.
• Designed and created an enterprise data warehouse for financials.
• Created the ETL to move a nightly file from the main frame and load the data warehouse.

Confidential

Manager of Data Systems

• Technical lead responsible for all data modeling and data administration in the organization:
• Performed DBA activities for ten servers with an average of eight databases per server.
• Supported application developers in database design and implementation.
• Designed and implemented security on all databases.
• Designed and implemented the GUI, queries and reports for an HR application.
• Performed data modeling and development for data marts in support of reporting.
• Setup transactional replication for real-time reporting.
• Did performance tuning of the servers and queries.

Confidential

Consultant - Senior Database Architect

• Senior architect responsible for the design and implementation of a venture capital information system:
• Wrote proposal for new system that included a functional specification, project pricing, project timeline and recommended hardware and software.
• Created logical and physical data models.
• Built the operational database and data warehouse.
• Transferred legacy data from assorted databases into the new database.
• Senior database consultant responsible for the design and implementation of a database for retail space leasing:
• Analyzed current business practices in order to identify data flow, data needs and redundant data stores.
• Created the physical data model and implemented associated Oracle database.
• Transferred data from legacy systems including several MS Access databases, Act and numerous spreadsheets.

Confidential

Senior Data Management Analyst

• Senior analyst responsible for development of a corporate information access infrastructure:
• Interviewed business analysts and senior executives to determine information needs.
• Lead the iterative design and implementation of databases and data marts.
• Implemented scripts for data loads and transformations from Oracle Financials General Ledger into data marts.
• Performed DBA tasks.

Confidential

Manager of Data Warehousing

• Project manager and technical leader responsible for the development of a corporate database and data warehouse used to store information relating to the company's credit card portfolio:
• Led the team in defining business requirements and overall architecture of the data warehouse.
• Created the logical and physical data models.
• Wrote scripts for extraction, transformation and loading of credit card data into the systems.
• Selected all hardware and software used to house the information system. Worked with vendors on pricing and leasing agreements.
• Performed Oracle DBA duties for the data warehouse, local databases and remote databases.
• Assisted business users with data analysis.

Confidential

Senior Database Architect

• Senior database architect responsible for management of data for a radiology network in a managed healthcare organization:
• Designed and implemented an application used by customer service for verification of individuals in various health plans.
• Designed and implemented a database to track primary care physicians and their use of medical procedures.
• Designed and implemented a system to collect utilization data and patient tracking in the radiology network.
• Performed duties of an AIX administrator and Oracle DBA.
• Provided support to medical administrators and physicians for data analysis.

Confidential

Senior Software Engineer

• Senior programmer and team lead responsible for software development for NASA related projects:
• Team leader involved in development of software modules used for satellite communications.
• Actively worked with full lifecycle development, following government policies and procedures.

Confidential

Senior Software Engineer

• Senior programmer and project manager responsible for design and development of a nuclear thermal performance advisor computer application system:
• Performed duties of budget tracking, task scheduling and supervised team members.
• Designed and implemented application database, GUI and expert system.
• Worked with beta test sites for the application testing.

Confidential

Research Technician

• Lab technician participating in cardiac research. Co-authored a number of papers for major medical journals.
• Computer support engineer and applications programmer responsible for computer-related duties ranging from maintaining PC equipment to programming and database management.