Marianna Petrovich

PROJECT
爱思唯尔的LMS系统数据存储，43%的美国护士使用该系统. 每个客户端都存储在单独的SQL Server数据库中.

我是唯一的架构师，也是DW的开发人员之一,100 databases into a single warehouse store for the easy production of CE reports and certification. 我还构建了一个包含大量报告的漂亮UI. This was a crucial aspect for the CE team; otherwise, 他们必须为每个客户手动运行.

RESULT
它已经并将继续每天为公司节省大量的时间和手工工作.

PROJECT
This system was built as a multi-tenant platform that supports 39 websites across the United States and delivers over 150 million monthly page views.

我完成了所有的后端工作(设计), development, reporting, 作为一个非常小的团队的一部分. 它在极短的时间内完成. Unfortunately, our system was live for only three short years when the new management came on board and replaced everything with boring WordPress sites.

CBS Radio came to me out of the blue when they suddenly lost their database administrator (DBA) who had been manually generating ANDO reports essential to their business and royalty payments to artists; these absolutely had to be done, 但公司里没人知道怎么做.

我被说服了, and in a week's time, I was able to put an SSRS process in place that ran all the necessary reports and submitted them to a third party automatically at the beginning of the month.

During my work, 我们面临着管理大量Microsoft SQL Server数据库的挑战, 每个客户端都有自己的专用数据库. We encountered over 2,000个独立数据库, one for each client, 因为我们的产品是几十年前开发的. 生成全面的报告, we have devised a solution where we loop through all these databases and populate staging tables in our warehouse database. 这使我们能够有效地整合和组合来自所有客户数据库的数据. This solution showcases the complexities we must navigate in our legacy product environment.