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 and implemented robust ETL pipelines in Databricks using Python and SQL, improving data accessibility and decision-making capabilities.● 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 support dynamic Power BI visualizations, empowering data-driven insights for agency teams.

● 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.