Sharon M. Dugan

Laguna Beach, CA *****

Independent Systems Consultant for

Database Architecture and IT Systems Planning

System Updates, IT planning and support for Pick Your Polish Card website Oct 2023-present

Dynamic Healthcare Systems (acquired by Reveleer Aug 22) Nov 21 – Sep 23

Database Specialist – Data Performance and Compliance (Nov 21 – Sep 23)

Support for the VOYAGER healthcare risk management applications and Medicare enrollment databases: SQL Server database development and production support, including emergency database repairs for customers. Use of RedGate tools to monitor servers and prepare for deployments.

Developed audit triggers, performance tuning and management of SQL Service Analysis services for the data sciences team.

Assist Dev team with web and database security for customer production, UAT, Dev and Sales demos for each of the sales business segments.

Manage UAT and production customer deployments of new SSRS websites, BI Dashboards, SSRS dashboard menus and report definition language files by application module.

Infrastructure configuration and remediation for critical Centers for Medicare Services (CMS) customer reporting, database network interfaces, analysis of reporting report definition language files logic for the data sciences team, analysis of the logic in the SQL stored procedures used for the associated Enrollment dashboard graphs and reports.

Manage related data warehouse dimension tables needed for Medicare enrollment reporting.

Configure AWS command line interface server replication for the database servers to migrate the on-premises servers to the AWS cloud.

Setup new AWS servers for SQL databases, Analysis Services databases, analysis services cubes and data warehouses, while continuing to manage the premises customers’ applications on native Microsoft servers.

Migrate security groups and service account permissions from the premises servers to the AWS RDS model.

Database Architect – Business platform for Vendor Pick Your Polish Gift Card (Nov 19 – Nov 21)

Assist developers that perform development tasks offshore; coordinate financial database resources and ecommerce plugins/workflows for gift card businesses and sales websites. Design and applications to complete the API implementation with Discover card.

Areas of development included payment card interface, website re-design and ecommerce systems, B2B plugins, domains/hosting, database integration with website components, overall code design for Restful API used for shopping cart, data security for credit card intermediary, order reports and tracking dashboards. BI systems analyst for database content and data driven applications. The first business card system www.pickyourpolishcard.com is operating and available online for mani-pedi gift card orders.

Black Knight Financial Services Jan 09 – Oct 19

Database Analyst, replication lead analyst

Data and Analytics: Analyst for filesystems/SQL Databases containing public records and real estate data for Black Knight, Division of Data & Analytics.

Migration for application databases and related data to/from open-source database Postgres

Application integration with Mortgage Web Services (MWS) for Property Tax Direct using SQL server databases for data ingest and matching.

Ingest, validation and output of SQL data using Microsoft Office drivers for Excel, SharePoint, and MS Access databases for quality inspection departments for customer data

Integration with reporting, analysis services (Snowflake star schema) interactive charting tools and visualization software such as Tableau and new mobile apps using SQL server geometry data types.

Publication and updates for SQL server integration services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS).

Created/managed website data sources and the replication host used to manage and update the US Property Public Record System (130 million data rows).

Publishing configuration for property data updates to be applied to data cubes, HADOOP sources, SQL reference instances, secure file shares and application-based cloud data file system presence for Azure and AWS services.

Microsoft Corporation – Microsoft Consulting Services

Database and Server Consulting Services Jan 00 – Jan 09

SQL server design and data modeling for application development for medical systems. Custom client database design and database server cluster builds. Travel to Microsoft customer sites for project completion. Data center design for security, file systems and databases.

Deliverables were to envision, document, design and implement software solutions using Microsoft SQL server and .Net Platforms.

Integration of Postgres data with SQL server processes

Updates for embedded Postgres application databases

Use of the scrum and Agile process to achieve client project success in the desired timeline.

Disaster Recovery Design and Planning for large enterprises using Microsoft servers and SQL databases. Hardware, server storage and file storage planning for production applications

Data migration and integration with electronic health records for open-source database Postgres and Oracle server clinical databases used in healthcare applications

EDUCATION

University of Louisville – Associate of Arts and Sciences in Computer Science - Applied Technology, with Highest Honors, 1981

Microsoft Certified Professional (MCP)

oID 2304838 (2000-2009) SQL server database, Windows platform, SharePoint server, infrastructure, and networking protocols

Azure, AWS training “on-the-job”

Contact this candidate