Marianna Petrovich

PROJECT
Elsevier's data store for an LMS system that is used by 43% of US nurses. Every client is stored in an individual SQL Server database.

I worked as the sole architect and as one of the developers of the DW effort to combine 2,100 databases into a single warehouse store for the easy production of CE reports and certification. 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
It has saved and continues to save the company many hours and manual work daily.

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.

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

I was brought on board, 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, we faced the challenge of managing a large number of Microsoft SQL Server databases, 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, we have devised a solution where we loop through all these databases and populate staging tables in our warehouse database. This allows us to consolidate and combine data from all client databases effectively. This solution showcases the complexities we must navigate in our legacy product environment.