Marianna Petrovich, Developer in Auburn, CA, United States
Marianna is available for hire
Hire Marianna

Marianna Petrovich

Verified Expert  in Engineering

Bio

For the past two decades, Marianna has worked as a database developer and a full-stack .NET developer, primarily focusing on databases. Database development is her strongest suit, including tuning, programming, ETL processes, and more. Marianna has worked with well-known corporations such as CBS, Lifetime Television, Elsevier, and Universal Studios. She is looking for projects that deal with new reporting tools and different databases.

Portfolio

The NPD Group
Agile Software Development, Azure SQL, Oracle, Data Visualization...
Elsevier
.NET, Microsoft SQL Server, Red Gate, SQL Server Reporting Services (SSRS)...
SBSControl, LLC
Microsoft SQL Server, Microsoft Access, QuickBooks API, SQL Server DBA...

Experience

  • SQL - 20 years
  • Microsoft SQL Server - 15 years
  • Crystal Reports - 15 years
  • Visual Basic - 15 years
  • Oracle RDBMS - 15 years
  • Oracle Database - 15 years
  • C#.NET - 10 years
  • MySQL - 9 years

Availability

Part-time

Preferred Environment

Oracle, SQL, Reporting, Data Transformation

The most amazing...

...work I've done is the current project of converting Oracle on-premises multi-TB database to NextGen cloud platforms.

Work Experience

Principal Engineer

2019 - PRESENT
The NPD Group
  • Worked as a sole developer and engineer on a Subscription Video Track system that reports on title-level insights on TV content U.S. consumers are watching. It combines behavioral insights, household demographic data, and rich, title-level metadata.
  • Migrated MSSQL databases from AWS to Azure, .NET, ETL, and ELT of big data.
  • Added multiple features such as projections and Amazon Prime View data processing to this exciting developing product.
Technologies: Agile Software Development, Azure SQL, Oracle, Data Visualization, Data Analysis, Python, SQL Server DBA, Data Migration, T-SQL (Transact-SQL), ETL, JSON, Data Engineering, Microsoft Excel

Data Architect

2010 - PRESENT
Elsevier
  • Worked for Elsevier, which is held by Reed Elsevier and is the fourth largest data provider in the world and is a sister company to LexisNexis.
  • Worked in different departments on life-saving software used by 43% of the nurses in the US, concentrating on data modeling, performance tuning, and database development.
  • Built the database that products are hosted in the AWS cloud environment. We are the second largest AWS client on the East Coast).
  • Managed and designed multi-cloud, multi-availability zone environments.
  • Optimized the performances and tuned the servers, upgrades, and updates of the different database products.
  • Configured the settings adjustments and monitoring.
  • Developed the database and front-end code while being a member of the mindful Agile team.
  • Worked with bleeding-edge technologies, such as Amazon DynamoDB, Lambda, Bootstrap, .NET, Git, Octopus Deployment, Jenkins, and more.
Technologies: .NET, Microsoft SQL Server, Red Gate, SQL Server Reporting Services (SSRS), Microsoft Report Builder, Data Warehousing, JavaScript, SQL Server DBA, Data Migration, ETL, Data Engineering

Database SQL Developer

2022 - 2022
SBSControl, LLC
  • Wrote, tested, and deployed ETL service to transfer data between MS SQL and QuickBooks.
  • Developed SSRS reports delivering the status of each successful service run.
  • Made minor modifications to the MS front-end interface.
Technologies: Microsoft SQL Server, Microsoft Access, QuickBooks API, SQL Server DBA, Data Migration, ETL, Data Engineering

Database Administrator (Part-time)

2013 - 2017
CBS Radio
  • Maintained the database infrastructure—performing code reviews (.NET, PHP, Perl, and more) releases, reports, new databases designs, and bug fixes.
Technologies: MariaDB, Redshift, MongoDB, MySQL, Microsoft SQL Server, SQL Stored Procedures, SQL Server DBA, Data Migration, ETL, Data Engineering

SQL Server Database Administrator | Programmer | .NET Developer (Telecommute)

2006 - 2011
CBS Televistion Stations Digital Media Group
  • Led the creation of the architecture and data model for a new content management platform that was designed to be multi-tenant. The initial launch consisted of supporting 39 local websites and delivering over 150 million monthly page views.
  • Collaborated with the application development and engineering staff to support new features and functionalities.
  • Managed the data modeling and implementation, the data conversion from a legacy system, the development and implementation of the stored procedures, report writing, and database tuning.
  • Created KPI dashboards which allowed the research teams to analyze various attributes of member profiles linking user activity, newsletter distributions, and user-generated content activity.
  • Focused on the OOP in C# and ASP.NET development—building out the core platform and additional content modules.
  • Worked on ETL jobs in order to integrate the third-party content by leveraging SQL Server integration services.
  • Built a feed system and a highly scalable distributed feed processing system utilizing SQL Server Service Broker.
  • Maintained the database and constantly evaluated potential performance issues—collaborated with the development team on performance tuning and various caching strategies to ensure optimal database and application performance.
  • Built the SQL Server DMVs.
  • Implemented Nagios/Cacti reporting and internal queries to deliver weekly reports identifying high CPU, I/O, or memory intensive SQL.
Technologies: .NET, Microsoft SQL Server, SQL Server DBA, ETL

Oracle Programmer | Database Administrator (Telecommute)

2004 - 2010
Lifetime Television
  • Designed data models, created schemas, wrote stored procedures, maintained data, wrote reports, and fine-tuned the SQL for numerous web projects as the database administrator.
  • Converted parts of tables from MyISAM to InnoDB engine in order to avoid locking contention.
  • Helped migrate a legacy Perl-based content management system to Drupal 5/6.
  • Developed Drupal core modules, modified character sets, and modified the SQL to utilize indexes due to poor performance.
  • Contributed to several front-end and admin modules as a .NET developer (affiliates and public affair websites); utilizing Oracle 10g RAC, Microsoft Enterprise Library, ASP.NET/C#, and various third-party controls such as ComponentArt, Telerik, Dundas, and Swiff Chart.
  • Wrote numerous XML/RSS feeds to import data to third-party CMS systems.
  • Developed KPI dashboards for senior management to review registration system information.
  • Connected a third-party newsletter delivery system from LSoft to allow business users to analyze the impact of various marketing campaigns.
Technologies: MySQL, Oracle

Programmer | Analyst

1999 - 2004
Universal Studios
  • Developed a program acquisition and scheduling system on a .NET framework (VB.NET, Windows Forms controls, ASP.NET, ADO.NET, remoting with SQL Server 2000 on a back-end).
  • Built an inventory module that stores all the company assets used across different channels (movie titles, promos, tapes, images, etc). The scheduling module provides a user-friendly intelligent interface to schedule those assets.
  • Successfully designed, implemented, tested, and deployed a scheduling system for dual-monitor systems.
  • Contributed to the full lifecycle development of a cost-tracking system (budgeting system), using VB 5.0 (later converted to 6.0), Oracle, and Crystal Reports.
  • Managed all the minutiae (daily, weekly, monthly, etc.) for the data-loading jobs—building a reporting engine and over 35 complex reports using Crystal Reports 7.0, written stored procedures, the front-end used RDO data technology to connect to Oracle database and ran on HP Unix box.
  • Successfully managed in providing technical support and training to over 40 systems' users.
  • Performed database administration duties, weekly, and monthly UNIX jobs (data loading, data maintenance and data migration to other apps).
  • Handled all of the database administration (Oracle 8.0.5 on the NT platform) and report creation of the CJDS Paradigm implementation (VB 6.0).
  • Modified and converted a Research DataMart application written in Access 95 and Oracle, using Excel objects for Access 2000. The application was used to store and manipulate Nielsen TV ratings.
  • Was involved in multiple intranet projects: an application security module, a human resource job postings engine, converted old ASPs to JSPs.
  • Created a Program Grid web application written on JSP which pulled data from Paradox, converted it over to Oracle. and displayed it in a browser to end-users inside and outside of the company.
  • Implemented the database administration (Oracle 8.0.5 on NT platform) and development of an affiliate extranet site for USA Cable; it already came with 1,200 users (5,000 in nearest future). It widely used JSPs and JavaScript.
  • Created, developed, and maintained database modeling.
Technologies: Microsoft SQL Server, .NET, Oracle

Programmer | Analyst

1997 - 1999
Zhora Systems Inc.
  • Developed, deployed, and supported, as a member of a team, a sales-vs-stocks reporting system for the planning and replenishment department of a brokerage firm.
  • Created a canned query interface which allowed running the sales analysis reports. (VB 5.0 and Crystal Reports 6.0 were utilized on the front-end. Oracle tables, stored procedures, functions, and triggers were used on the back-end.).
  • Developed program specifications, has been involved in creating of the GUI design, testing, installation, and user training.
  • Translated business specifications into the program design.
  • Created quarterly, monthly, and weekly reports.
  • Worked closely with database administrator (DBA) on the design, coding, and testing of Oracle Server stored procedures and database designs.
  • Wrote technical documentation including test plans, project specs, and bug tracking reports.
Technologies: Crystal Reports, Visual Basic, Oracle

Programmer | Systems Integrator

1994 - 1997
Weekly Newspaper “Kurier”
  • Designed and built a company's advertiser database (MS Access 2.0/95) containing about 200,000 records—enabled the company to grow substantially. Prior to this, the company was operating on paper. Analyzed the specifications of advertiser's information stored, reviewed with the company business requirements for the database and created new database incorporation all the specifications: faster sales response time, relevant data capture, search queries, etc.
  • Developed an advertisers’ requests storage and confirmation system using VB 5.0. The system allows storage of advertisement requests, assigns the order number to the request, and gives a user an ability to print custom confirmations and reports.
  • Created relational data tables, designed forms, and various reports for management needs using Crystal Reports 6.0 and Access.
  • Supervised the technology projects and worked with vendors.
  • Provided technical support and troubleshooting and installed hardware and software.
Technologies: Microsoft Access, Visual Basic

Programmer | Teacher

1990 - 1994
St. Petersburg Computer Center
  • Taught computer science and math to the computer center’s students.
  • Developed online tutorials for other subjects (English, geography, history, and others), using Pascal and C.
Technologies: BASIC, C, Pascal

Continued Education Data Warehouse

https://www.elsevier.com/solutions/performance-manager
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.

CBS Television Stations CMS System

https://www.cbscorporation.com/business/cbs-television-stations/
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

https://www.cbsnews.com/radio/
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.

SQL Code File

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.
2022 - 2024

Master's Degree in Big Data

Arizona State University - Tempe, AZ, USA

2020 - 2022

Bachelor's Degree in Computer Science

California State University Monterey Bay - Monterey Bay, CA, USA

2018 - 2020

Associate's Degree in Computer Science

Sierra College - Rocklin, CA, USA

1996 - 1998

Bachelor's Degree in Computer Science

Brooklyn College - Brooklyn, NY, USA

1990 - 1993

Bachelor's Degree in Computer Science

Saint Petersburg State University of Economics and Finance - St. Petersburg, Russia

MAY 2022 - PRESENT

Azure Data Fundamentals

Microsoft

JANUARY 2019 - PRESENT

Python

Coursera

Libraries/APIs

Node.js, React, jQuery, QuickBooks API

Tools

Microsoft Access, Crystal Reports, Microsoft Report Builder, Tableau, Microsoft Excel

Languages

Java, SQL, T-SQL (Transact-SQL), Ruby, Stored Procedure, Pascal, C, BASIC, C#, C#.NET, Visual Basic, JavaScript, Python, Assembler

Frameworks

Ionic, Spring, .NET, .NET Core, Bootstrap, Angular

Paradigms

DevOps, ETL, Agile Software Development, Spatial Design

Platforms

WordPress, Azure, Oracle, Oracle Database

Storage

Microsoft SQL Server, SQL Stored Procedures, SQL Server Reporting Services (SSRS), Oracle RDBMS, SQL Server DBA, MongoDB, Redshift, MariaDB, SQL Server Integration Services (SSIS), PL/SQL, MySQL, PL/SQL Developer, Azure SQL, JSON

Other

QA Testing, Mobile App Development, SSRS Reports, Data Analysis, Data Science, Software Development, Full-stack, Front-end Development, Data Engineering, Data Warehousing, Data Visualization, Data Migration, Data Warehouse Design, Data Modeling, SSIS Custom Components, Reporting, Algorithms, Red Gate, Artificial Intelligence (AI), Machine Learning, Computer Science, Development, Data Transformation

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring