Marianna Petrovich, Software Developer in Auburn, CA, United States
Marianna Petrovich

Software Developer in Auburn, CA, United States

Member since June 18, 2020
For over 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.
Marianna is now available for hire

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

Experience

Location

Auburn, CA, United States

Availability

Part-time

Preferred Environment

Oracle, SQL, Reporting

The most amazing...

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

Employment

  • 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
  • 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
  • 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
  • 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 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
  • 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

Experience

  • 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 mln monthly page views.

    I performed all of the back-end work (design, development, reporting, and tuning) as part of a very small team and 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.

Skills

  • Languages

    Java, SQL, T-SQL, Transact-SQL, Ruby, Pascal, C, BASIC, C#, C#.NET, Visual Basic, JavaScript, Python
  • Frameworks

    Ionic, Spring, .NET, .NET Core, Bootstrap, Angular
  • Libraries/APIs

    Node.js, React, jQuery, QuickBooks API
  • Paradigms

    Data Science, DevOps, Agile Software Development
  • Platforms

    WordPress, 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
  • Other

    QA Testing, Algorithm Development, Mobile App Development, SSRS Reports, Data Analysis, Software Development, Full-stack, Front-end Development, Data Warehousing, Data Visualization, Data Warehouse Design, Data Modeling, SSIS Custom Components, Reporting, Algorithms, Red Gate
  • Tools

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

Education

  • Master's Degree in Big Data
    2022 - 2022
    Arizona State University - Tempe, AZ
  • Bachelor's Degree in Computer Science
    2020 - 2022
    California State University Monterey Bay - Monterey Bay, CA
  • Associate's Degree in Computer Science
    2018 - 2020
    Sierra College - Rocklin, CA
  • Bachelor's Degree in Computer Science
    1996 - 1998
    Brooklyn College - Brooklyn, NY, USA
  • Bachelor's Degree in Computer Science
    1990 - 1993
    Saint Petersburg University of Economic and Finance - St. Petersburg, Russia

Certifications

  • Azure Data Fundamentals
    MAY 2022 - PRESENT
    Microsoft
  • Python
    JANUARY 2019 - PRESENT
    Coursera

To view more profiles

Join Toptal
Share it with others