Marianna Petrovich

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

我是唯一的架构师，也是DW的开发人员之一,将100个数据库集成到一个仓库存储中，方便生产CE报告和认证. I also built a nice UI that contained numerous reports. This was a crucial aspect for the CE team; otherwise, they'd have to run it manually for every client.

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

PROJECT
该系统是作为一个多租户平台构建的，支持美国各地的39个网站，每月提供超过1.5亿的页面浏览量.

I performed all of the back-end work (design, development, reporting, and tuning) as part of a very small team. It was completed in an amazingly short period of time. Unfortunately, 我们的系统只运行了短短三年，就在新的管理团队到来的时候，所有的东西都被无聊的WordPress网站取代了.

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, but nobody left at the company knew how to do them.

I was brought on board, and in a week's time, 我能够建立一个SSRS流程，运行所有必要的报告，并在月初自动将其提交给第三方.

During my work, 我们面临着管理大量Microsoft SQL Server数据库的挑战, with each client having their own dedicated database. We encountered over 2,000 individual databases, one for each client, as our product was developed decades ago. To generate comprehensive reports, 我们设计了一个解决方案，循环遍历所有这些数据库，并在我们的仓库数据库中填充staging表. 这使我们能够有效地整合和组合来自所有客户数据库的数据. 这个解决方案展示了我们必须在遗留产品环境中处理的复杂性.