Victoria Rice Email & Phone Number

Atlanta, Georgia, United States

• Notable projects include
• eCommerce Data Warehouse Modernization: Led the migration of four legacy databases to a medallion architecture in an Azure data warehouse, enabling scalable, near real-time reporting for executive dashboards. Designed.
• Agency Product Data Mart: Developed a data mart for product analysis by modeling and integrating data from multiple source systems into a streamlined Google BigQuery schema. Implemented optimized ETL pipelines to.

• Led the design and development of scalable data pipelines and enterprise data strategies, ensuring efficient ETL processes using SQL and Python.
• Managed analytics as a product, driving profit and optimizing database performance, resulting in a 25% reduction in software costs.

• Modeled, developed, and maintained a dynamic AWS Redshift database using ETL pipelines to centralize data from MongoDB, PostgreSQL, and third-party applications.
• Enhanced metadata usage through MongoDB triggers and Python, resulting in more efficient data management and storage processes.
• Developed a suite of twelve customer facing dashboards that visualized data that was previously inaccessible, including financial and budgeting, resourcing, project planning, and project management data.

• Designed and implemented data models in MySQL and PostgreSQL, adhering to best practices for snowflake and star schemas in a data warehouse environment.
• Managed and optimized SQL- and Python-based ETL pipelines for several Fortune 500 companies, ensuring data integrity and performance.
• Developed custom dashboards in QlikView and Tableau and later migrated them to Sisense to provide real-time insights for stakeholders.