Marianna Petrovich
Verified Expert in Engineering
Software Developer
Auburn, CA, United States
Toptal member since June 18, 2020
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
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
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
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.
Data Architect
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.
Database SQL Developer
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.
Database Administrator (Part-time)
CBS Radio
- Maintained the database infrastructure—performing code reviews (.NET, PHP, Perl, and more) releases, reports, new databases designs, and bug fixes.
SQL Server Database Administrator | Programmer | .NET Developer (Telecommute)
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.
Oracle Programmer | Database Administrator (Telecommute)
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.
Programmer | Analyst
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.
Programmer | Analyst
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.
Programmer | Systems Integrator
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.
Programmer | Teacher
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.
Experience
Continued Education Data Warehouse
https://www.elsevier.com/solutions/performance-managerElsevier'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/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/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
Education
Master's Degree in Big Data
Arizona State University - Tempe, AZ, USA
Bachelor's Degree in Computer Science
California State University Monterey Bay - Monterey Bay, CA, USA
Associate's Degree in Computer Science
Sierra College - Rocklin, CA, USA
Bachelor's Degree in Computer Science
Brooklyn College - Brooklyn, NY, USA
Bachelor's Degree in Computer Science
Saint Petersburg State University of Economics and Finance - St. Petersburg, Russia
Certifications
Azure Data Fundamentals
Microsoft
Python
Coursera
Skills
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
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring