Candidates About

Debra Moore

Experienced professional with more than 20 years of hands-on database-related experience in a variety of different industries. Job responsibilities have covered all aspects of data development and analysis including determining corporate data strategy, collecting and documenting requirements, logical and physical data modeling, database creation/integration/migration, planning and scripting of ETLs,  complex SQL query development and tuning, data analysis and report/BI development.  “Tool agnostic,” having independently self-trained on various database development and analysis tools.  Main strength is working interactively with the ultimate end-users of the data to determine the problems they want to solve and jointly develop solutions that will integrate into the overall corporate model.

Database Tools include:

Medapoint is the developer of AdvanceClaim;  a cloud-based application for Emergency Medical Services (Ambulance) billing and dispatch.  Medapoint also provides medical billing consulting services to their clients.

Principle Accomplishments and Contributions:

As Data Architect, worked closely with internal and external customers to determine and document EMS finance, accounting, work flow, claim management and billing needs.  These requirements were used to design, construct and continually enhance a database used for internal application reporting, data warehousing and data analysis/analytics.  Also designed and developed various modeling/analytical programs to help business improve on processes such as cash forecasting and patient insurance eligibility.

·          Evaluated standard data elements used in the EMS billing industry (NEMSIS), reviewed existing financial reports and interviewed clients to design tables/fields/structure for AdvanceClaim internal and external reporting. 

·          Utilizing SQL Server and T-SQL, designed and created ETLs to consolidate/aggregate data, create derived fields and move data from the production server to the reporting server on a scheduled basis. 

·          Directed off-shore team in redesigning and moving existing application reports from production tables to the new ODS reporting database tables on a reporting server. This not only made the application reports run much faster, but took a significant load off of the application production server.

·          Developed a predicative modelling program using T-SQL (patent pending), AdvanceInsight, which helps clients to project revenue, cash flow and AR based on past insurance pay-outs, demographics and other variables.

·          Developed a T-SQL program (integrated into the AdvanceClaim application) that takes the demographics of a patient and determines the top 5 insurance providers where that patient is likely to have eligibility.  The results  were then fed into a proprietary API that checks patient insurance eligibility for each of these insurance providers.

·          Worked with EDI team extensively to help troubleshoot and streamline complex EDI claim payment process. Created set of database tables to assist and help report on the EDI claim statuses.

·          Developed data validation queries that automatically check for inconsistencies in the production data.  Based on the type of validation issue, the validation results automatically get assigned to the appropriate work group for resolution.

·          Developed Work Flow logic in the database tables which, based on variables within each claim, places each claim into a Work Flow “Bucket”.  This derived field helps clients distribute claims to the appropriate work group who will handle the next step in claim management.

·          Handled a variety of complex ad-hoc analytic requests daily for internal and external customers.

Double Line Partners is an education data technology and consulting firm focused on serving the public sector, with a special emphasis on working in K-12 education. 

Principle Accomplishments and Contributions:

Consultant for EdFacts Project.  EdFacts is a series of 100+ reports that State and Local Education Agencies are required to send to the U.S Department of Education each year.

·          Analyzed and documented data elements for over 100 standard EdFacts reports

·          Utilizing ER Studio, created new logical ER models for EdFacts report elements. Merged new models with Double Line’s existing Standard Education database models.

·          Created T-SQL scripts to merge new tables/fields to Double Line’s existing Standard Education database.

·          Due to financial issues, this project was cancelled before completion.  Fully documented project so that it can easily be picked up at a later date.

Rev Worldwide is a global payments network company that provides end-to-end payment solutions worldwide. 

Principle Accomplishments and Contributions:

As “hands-on” Director of Business Intelligence, led a team of database professionals in creating and maintaining the corporate ODS/data warehouse, ETLs, operational and strategic reports in a constantly changing, fast-paced environment.

·          Worked with all organizational departments to determine and document corporate-wide data and reporting requirements.

·          Worked with the IT development team to document underlying OLTP system.

·          Utilizing Oracle’s SQL*Modeler, modeled resulting requirements into a logical database model (ERD) and ultimately into physical Oracle 11g database.

·          Developed complex PL/SQL ETL packages to map data from the OLTP database into the data warehouse/ODS on a scheduled basis.

·          Developed, scheduled, implemented and maintained diverse internal and external operational and strategic reports for a variety of corporate programs.  

·          Proactively maintained and enhanced the data warehouse/ODS as the OLTP database evolved and new programs were deployed.

·          Hired and managed a team of developers and analysts to develop, document, maintain and enhance the ODS/data warehouse, ETL and strategic and operational reports.

·          Managed change by creating team from various areas of the business to meet regularly to prioritize all reporting and data warehouse requests company-wide.

·          Regularly performed complex data analysis on demand for internal and external customers.

·          Developed extensive knowledge about the global financial payment industry.  Daily challenges included scheduling and management of mandatory daily bank reports in many countries, complex regulatory issues, maintaining PCI and other payment industry compliance, currency conversions/FX, scheduling and reporting in multiple time zones, and managing fraud/risk.

·          Provided recommendations to executive team on enhancing profitability/processes through creative solutions.  Examples include documenting start-to-end data and process flows for each card program;  developing automated solutions to simplify financial reconciliation and settlement; creating standardized reports to shorten development time; decoding and mapping payment network data (i.e. Mastercard/Visa) into the ODS/data warehouse for use in marketing and risk analysis.

IE Discovery (now Deloitte Discovery) provides comprehensive litigation support services and information management products/services to the private sector and government entities.  Clients included the US Navy and several of the largest health care providers in the country.

Principle Accomplishments and Contributions:

·          Acted as a liaison between business project managers and technical analysts to plan and deliver the time-critical production of legal documents for e-discovery litigation.

·          Supported the complete e-discovery cycle, from collection to production, utilizing a Web-based system for searching, organizing, and producing discovery documents.

·          Utilized SQL Server (T-SQL) extensively to develop scripts to query, analyze and produce legal documents  in a variety of different formats.

Principle Accomplishments and Contributions:

·          Utilized SQL*Plus, MS Access, PL/SQL and SQL*Loader to extract, clean, manipulate, transform and load data from three different customer legacy systems into new SAP system.

·          Developed a web-based SAP help and training system, created course materials and conducted training classes for internal clients.

·          Helped design and populate the corporate Oracle data warehouse mapped from the new SAP system.

·          Created ad-hoc and scheduled reports for various business units using a variety of reporting tools.

·          Created and maintained PL/SQL and ABAP scripts for mass updates to internal SAP data on an ad-hoc and scheduled basis.

Principle Accomplishments and Contributions:

·          Staffed and managed teams of 5-10 employees and contractors to create and implement various internal IT projects using Oracle tools.  This included gathering system requirements, estimating budgets, creating time lines, staffing and coding for each project. Utilized data-modeling and joint application development (JAD) techniques to gather project requirements.

·          Developed course materials and taught mainframe, database, SAS and PC classes for programmers and business end-users in various parts of the country.

·          Regularly manned the IT help desk to research and answer end-users' questions