Driving business growth with advanced analytics, automation, and visualization.
Transforming raw data into actionable insights, I have led enterprise-wide Power BI implementations that drive efficiency and decision-making. At Farmers Insurance FCU, I designed and deployed a centralized SQL warehouse, data marts and automated Power BI dashboards, reducing manual data processing by 50% and increasing operational efficiency by 30%. By integrating real-time reporting and predictive analytics, I’ve empowered them to reduce costs and streamline business intelligence. Whether automating reports, tracking KPIs, or enhancing financial forecasting, my team leveraged Power BI to turn data into a strategic advantage.
Streamlining data workflows, I have built robust data pipelines using VBA and SQL stored procedures, automating high-volume processing and reducing manual effort. At QuickSort, PixelMagicPrinting, JP Business Solutions, and Sapphire Business Solutions, I developed automation that handled 300+ files daily—including Print Image, delimited, and Excel formats—ensuring seamless data integration across systems. Over time, I’ve encountered every file type imaginable and have never met data I didn’t like! By leveraging custom scripts and stored procedures, I eliminated bottlenecks, cut processing times in half, and saved organizations hundreds of labor hours per month. My expertise in data automation and ETL pipeline development ensures that businesses can focus on insights, not inefficiencies.
Turn any CSV into structured, query-ready data with automated table creation and transformation—no manual setup required!
Here's a VBA spec to import any CSV file into an automatically created table based on the folder name and file mask name. The script will:
Dynamically create a table (RAW_FolderName_FileMaskName).
Import the CSV file into the table (handling delimiters and headers).
Leave a section for custom transformations before final loading.
Finds the first CSV file in the given folderPath matching the fileMask (e.g., "C:\Data", "Report_*.csv").
Dynamically generates a table name using the folder and file mask name, formatted as:
"RAW_FolderName_FileMaskName" (e.g., "RAW_Data_Report_Wild")
Creates a table with columns matching the CSV headers (assumes first row as headers).
Imports the CSV file into the dynamically created table.
Leaves room for custom transformations before final data loading