Business and Data Analytics

AMANDA BOHLMAN

Galveston, TX ***** ***********@*****.*** 281-***-****

Professional Profile

Experienced Business Analyst with 7+ years supporting data-driven decision-making across multiple industries. Adept at Power BI data modeling, generative AI-powered analytics, business intelligence, process optimization, and system integration. Demonstrated success in designing automated solutions, optimizing reporting, and fostering cross-functional collaboration. Strong technical background in SQL, Power BI, Microsoft Dynamics 365, and ETL tools.

Professional Experience

Freelance Business Analyst

Upwork – Remote May 2022 – Present

• Reduced manual data entry by 45% through workflow automation and system integrations across multiple systems.

• Designed and optimized complex Power BI data models for real-time reporting and analytics.

• Applied generative AI tools to automate report generation and enhance data analysis efficiency.

• Developed ETL workflows utilizing SSIS to efficiently process large datasets.

• Enhanced data governance policies, ensuring privacy and regulatory compliance.

• Supported procurement and finance teams by improving payment schedules for improved cash flow.

• Produced technical documentation and diagrams using Visio and Microsoft Office Suite.

Business Intelligence Developer

Carriage Services – Houston, TX Jul 2023 – Dec 2023

• Improved the monthly closing process by reducing reporting time from 10 days to 3 days using advanced Power BI data models.

• Automated financial reconciliation processes, reducing required effort by 50%.

• Created a PowerApps request system to manage ad hoc analysis requests, reducing turnaround time by 43%.

• Migrated legacy reports and systems to modern BI platforms, improving accessibility and performance.

• Developed complex data models using SQL, DAX, and Power Query M to enhance reporting accuracy and support generative AI-powered analytics.

• Configured customized workflows in Microsoft Dynamics 365 Business Central.

• Collaborated with data architects on scalable data warehouse design and Power BI model optimization.

Business Analyst

Brown & Root Industrial Services – Houston, TX May 2018 – May 2022

• Built interactive dashboards using Power BI and SQL Server to support cost analysis and operational decisions.

• Reviewed RFPs and RFIs to determine deliverables, compliance requirements, and evaluation criteria.

• Conducted win/loss analysis to support proposal strategy improvements.

• Implemented CRM enhancements to improve pipeline visibility and forecasting accuracy.

• Maintained comprehensive documentation, including business requirements documents, process flows, and specifications.

• Improved organization and version control systems within SharePoint. Technical Skills

• Power BI, Power Query M, SSIS, SSRS, SQL, DAX, Power Automate, Microsoft Power Apps

• Microsoft Dynamics 365, Workday, Salesforce, SAP (FICO), SharePoint, Active Directory, Oracle

• Git, Visual Studio, Python, Azure DevOps, AWS, ArcGIS

• Generative AI (prompt engineering, AI-powered analytics)

• Business Requirements Gathering, Process Mapping, Financial Analysis, Accrual Accounting, OSHA Reporting

Certifications

• Intuit QuickBooks Certified (Issued Mar 2016 – Present)

• Microsoft Business Analyst (In Progress)

Education

University of Arizona Global Campus – Chandler, AZ B.A. in Business Information Systems (Expected 2028)

Contact this candidate