Business Intelligence Data Analytics
Resume:
Columbia, MO *****
Cell: 573-***-****
LinkedIn: linkedin.com/in/Rebecca-day-b83337bb
E-mail: **********@*****.***
Professional Summary
Highly skilled IT and data professional with extensive experience in data analytics, business intelligence, database management, and business analysis. Adept at leveraging data to drive strategic decision-making, improve operational efficiencies, and optimize business processes. Strong background in SQL, Power BI, Informatica, and data warehousing. Proven ability to work cross-functionally to analyze business requirements, develop data-driven solutions, and implement process improvements. Self-motivated leader with a passion for innovation and data-driven decision-making. Core Competencies
Business Analysis & Process Optimization
Data Analytics & Visualization
Database Development & Management
SQL, SSIS, SSRS, SSMS, Power BI
Data Warehousing & ETL Development
Predictive Analytics & Reporting
Workflow Automation & Business Intelligence
Stakeholder Collaboration & Requirements Gathering
Risk Assessment & Compliance
Professional Experience
Data Architect / Project Analyst
City of Columbia Columbia, MO 02/2025 – Present
Establish data standards, policies, and procedures to ensure data quality, integrity, and compliance with regulations.
Design detailed data models that serve as the blueprint for managing data within the organization, including defining relationships between entities and attributes.
Establish data standards, policies, and procedures to ensure data quality, integrity, and compliance with regulations.
Collaborate with business teams to understand their data needs and translate them into technical specifications for the data architecture.
Implement security measures to protect sensitive data, including access controls and encryption protocols.
Design data warehouse architectures for storing and analyzing large volumes of data.
Assess database performance and identifying areas for improvement to ensure data is readily accessible.
Work with data engineers, developers, and business analysts to implement the data architecture and ensure alignment with business objectives. Data Application Specialist / Business Analyst
Environmental Health and Safety Columbia, MO 09/2024 – 02/2025
Analyze and maintain workers' records within the EHSA application system.
Gather and document business requirements for system enhancements and process improvements.
Develop data-driven insights to optimize training and permit processes. Rebecca Day
Work cross-functionally with OnSite, HSI, and MU DoIT to troubleshoot system issues.
Manage MySQL databases and generate reports in Power BI to track key performance metrics.
Ensure data integrity by cleaning and optimizing tables for improved system performance.
Data Engineer / Business Analyst
Veterans United Home Loans Columbia, MO 04/2021 – 09/2024
Collaborated with business stakeholders to identify data needs and create strategic solutions.
Designed and developed ETL workflows in SSIS using Visual Studio to automate data processing.
Conducted business analysis to identify trends, optimize workflows, and improve data accuracy.
Created and managed databases, stored procedures, and SQL scripts to enhance business intelligence.
Utilized TFS/GIT for version control and project management.
Analyzed customer and loan data to support business decision-making.
Software used: Informatica, SQL Server, SSRS, SSIS, SSMS, Visual Studio, TFS, Jira, Python, Spark.
Senior BI Developer / Business Analyst
MFA Oil, Inc. Columbia, MO 02/2016 – 04/2021
Led business intelligence initiatives to support executive decision-making.
Gathered and analyzed business requirements to develop data reporting and analytics solutions.
Administered Power BI Report Server and built reports using Power BI Desktop and Report Builder.
Developed and maintained enterprise data warehouses (EDW, UAT, Dev, Data Mart, ODS).
Implemented Microsoft Master Data Management and Data Services for data integrity.
Created ETL processes to integrate data from Oracle and other external sources.
Software used: Power BI, SSIS, SSMS, SSRS, SSAS, Visual Studio, Informatica, SQL Server 2014 & 2016.
Data Warehouse Engineer / Business Analyst
Veterans United Home Loans Columbia, MO 12/2012 – 02/2016
Worked with business teams to define reporting needs and develop actionable insights.
Created ETL workflows in Informatica and SSIS for data processing and integration.
Designed and managed SQL Server databases to support data warehousing initiatives.
Developed Tableau reports to provide real-time insights for business operations.
Managed SharePoint repositories for business-critical reports and analytics.
Software used: Informatica, SQL Server 2012 & 2016, SSIS, SSMS, SSRS, SSAS, Tableau, SharePoint.
Database Administrator
MidwayUSA, Inc. Columbia, MO 06/2011 – 12/2012
Designed and optimized SQL databases to support e-commerce and operational processes.
Created stored procedures, views, and functions to improve business reporting.
Conducted performance monitoring and troubleshooting of database systems.
Software used: SSIS, SSMS, TFS.
Education & Certifications
Educational Background
Bachelor’s Degree: Information Technology, Communication & Management – University of Missouri (2001-2005)
Master’s Degree: Learning Systems Design & Development – University of Missouri (2005-2006)
Educational Specialist: Learning Systems Design & Development – University of Missouri (2006-2008)
Additional Training & Certifications
Microsoft SQL Server (2000, 2005, 2008)
Crystal Reports Training
Informatica Administration/Developer Training
R, Python, PySpark, Power BI, Tableau
References
Rich Wyble 314-402-767 ******@**.***
Lea Allen 573-***-**** ******@**.***
Craig Swank 573-***-**** ******@**.***
Contact this candidate