Brian Lofton Email & Phone Number

Fayetteville, Ar, Us

Falls Church, Virginia, Us

GDIT / Department of Veteran Affairs

Bentonville, Arkansas, Us

• Define and implement architecture and standards for Power BI solutions with PBI premium capacity-- Deployment Pipelines, Computed Entities, Datalake• Created a datalake environment for data analytics workloads using Power BI dataflows to source/refresh data from a variety of on-prem and cloud sources-- SQL Server, D365, SharePoint, CosmosDB• Automate complex business requirements using PBI Dataflows, Excel Power query, and Excel reports• Migrate reports from legacy systems to PBI cloud and datalake-- SSRS, Excel, bespoke software• Security — PBI Workspaces, SharePoint reports, AD groups• Datalake architecture — Power BI dataflows (Datalake: Stage/Integration/DW)• ETL design — naming conventions, field• ETL orchestration — PowerAutomate (refresh triggers) to enable timely and stable analytics data source for analytics

Oklahoma City, Ok, Us

• Craft and execute queries, present information through reports and visualizations, and implement quality analytics using Power BI • Manage workspaces, users/groups/licenses, Troubleshoot data access and other issues, Subscriptions, Report glossary, User access across test/production, PowerShell and API’s, PBI tenant admin settings • PR Data Model checklist and templates implemented to guarantee reporting data quality, enabling accurate analysis and iterative improvements (BI Documenter, BI Cleaner, Measures, Calendar, model documentation) • Draft BI strategy with goals to increase reliability, accuracy, and adoption • Research new PBI features, assess use cases and organizational fit, and suggest recommendations Special Projects: • Collaborated with data engineers to revamp and merge history/current application data structures for meter volumes data, resulting in accurate historical reporting with rich analytic insights that were frequently used by executives • Installed and connected Dynamics BC 365 PBI apps, for analyzing financial data in PBI from the DBC365 instance

Hanover, Md, Us

• Access data content, curated by data engineers, and create analytic reports using Power BI • Establish requirements forms and documents for gathering BI project requirements (Confluence, Google Forms), creating seamless experience, and improving project success rates Special Projects: • Created PBI Workspace Analysis automated report capturing audit history records and displaying analysis for: Test/Prod deployments, Viewership trends, Licensing utilization and cost, and other analysis • Re-organize and simplify workspace environment to remove duplicate and unused artifacts, simplifying access administration and improving discoverability of reports, dashboards, and datasets

Springdale, Arkansas, Us

• BI Developer using Microsoft SQL Server to deliver solutions for ETL, DW, SSRS, and SSAS cubes• Support BI tools via upgrades, configurations, documentation, issues resolution, security, and user training • Design standards and procedures for the structure and attributes of the business intelligence tools Special Projects: • SSRS upgrade from 2008 to 2016, and successfully implemented standards for multiple developer contributors • Converted 400 reports from Crystal BI Objects to SSRS reporting platform for departments across the organization, modernizing legacy reports and saving $1500 yearly licensing cost • Developed “PPM” data mart solution in SQL Server/Power Pivot to replace Excel workbook calculations for planned orders, forecasted orders, inventory, and inventory level projections • Improved DW execution time by 2 hours (30%) by leveraging DWA ETL performance tuning and regression testing SQL stored procedure changes • Developed SSIS package solution to convert 1 excel file to 30 different text file formats for EDI transfer

Springdale, Arkansas, Us

• Analyze corporate business processes to facilitate customized solutions • Author SQL queries for ad hoc reporting needs, requirements analysis, and software testing• Design and develop customized reporting solutions via SSAS, SSRS, PowerBI, and Excel• Draft and maintain software requirements for ERP system functionality, integrations, reports, and data warehouse projects. Conduct stakeholder interview, document business process and business rules, and ensure alignment with development team.

Lewisville, Texas, Us

• Maintained databases and data models for tracking major KPIs: event sales, revenues, field reporting, and operational metrics• P&L weekly forecasts, monthly budget variance and MBRs• Troubleshooting support for A/R and analytics• Conducted data mining analytics/ models, and assisted with deployment of Excel & Tableau dashboard reports

Lewisville, Texas, Us

• Revenue accounting: Weekly A/R invoice processing, product reimbursement, accrual reporting, aging/claims reconciliation, CrDr memos• Overhauled A/R invoicing SOPs, saving 26 hours of weekly labor and standardizing formats• Provided Microsoft Excel instructional courses and tutoring

Plano, Texas, Us

• Worked directly with customers, securing sales for the store by understanding shoppers' needs and connecting them with store merchandise• Set up plan-o-gram merchandise displays and maintained floor stock levels• Consistently awarded monthly "Referral Associate" by averaging five referral orders a week

Us

• Pitched story ideas for the news section, located sources, and authored contemporary articles• Interviewed authority figures and community members to attain quality source material• Covered topics range from local business, campus news, to national events

• Studied, interpreted and administered youth soccer state guidelines to referee matches• Re-certified annually to demonstrate a full understanding of game rules, and rule changes.