• Analytical Ants provides systems (“Ants”) that systematically increase operational efficiencies and yields through dynamic data insights, data architecture, and processes.• We deliver these insights through a holistic approach encompassing a large portion of the data-pipeline, mainly through machine learning, warehousing, and reporting. • Example services for Machine Learning and Warehousing: supervised & unsupervised ML data analysis, ML server integration, server object scripting and scheduling.• Example services for Analysis Services & Reporting (PBI/Excel): (1) Architectural Planning: Server Selection (on-prem vs. premium), Load Balancing, Deployments Strategies, Monitoring Tabular Solutions, Security, (2) Data Modeling: Model Selection & Procurement, Partitioning Strategies, Model Optimizations, Ingestion Strategies, Relationship Design, and (3) Reporting: Visualizations, DAX optimizations, JSON configurations, Report Optimizations & Design.• More information can be found here: https://analyticalants.co/analytical-ants/the-value-we-provide/

SEE RESUME FOR FULL LIST• Project manager, scrum master, and tabular expert who progressed the business intelligence initiative for predominant AT&T business applications: MyResults (metrics/goals) & MyCoach (discipline/coaching)• Scrum master (agile) who managed ~240 monthly developmental hours (3 direct & 4 indirect reports) and hired five senior and junior Microsoft BI architects/report writers.• Managed full development life cycle for four production PBI workspaces/apps with roughly 25.3k monthly views and over 3.1k active monthly users (Dec 17th-Jan 17th, 2023). • Owned architecture, development, maintenance, and process improvement for seven (certified) enterprise cubes (on-prem SSAS & PBI datasets). Cubes ranged in variety (e.g., import, direct query, live connections (SSAS & PBI dataset), hybrid models) with multiple multi-billion imported fact-record cubes. Largest 45gb cube contained a 7.7B+ import fact table connected to a 6.5M imported dimension table (star-schema)2022 EOY ANONYMOUS FEEDBACK (5 reviewers)• William is our resident expert in all things PBI. Thank goodness. He brings unique skill set. William collaborates great on projects, customer needs and testing. Very well rounded and capable• True Subject matter expert in his field but still understands when the need arises to loop others in. Very appreciative, shows thanks to others any time they pitch in• Our team has to respond to the business’s needs, and to do that we have to be flexible. William does a great job adapting to changes and going with the flow. William also knows how to protect his time, yet respect requests for help by setting up meeting times. • William is an extremely effective communicator, and he takes the time to tackle large problems with aplomb. • William is easy to approach and work with and is good at communicating to everyone involved in an issue. He readily collaborates with others and seeks to implement their expertise into the solution.

Aided the Power BI initiative for the Mobility Marketing team. Deliverables include standardizing reports through templates, branding, visualization themes (JSON script), 'appizations' (dynamic bookmarks), custom DAX 'breadcrumbs', and pbix standardizations/best-practices (e.g., data modeling and turning off auto-time diminsions). Also assisted in the hiring of three senior architects, worked with business units to deliver operational analytics, and delivered enterprise BI enhancements.

• Constructed a centralized data repository servicing full corporate business intelligence and business application needs, streamlining analytics, and fostering 'central truth' (PBI Model – AS Engine). • Responsible for data architecture, governance, client consultations, ETL, model building, user interface aesthetics, product delivery, and life cycle management for 50+ dashboards & reports (PBI & Excel)• Created and automated “Managerial Packet” distributed bi-weekly to leadership and investors (Excel, VBA, PBI Dataset)• Collaborated with leadership and management for automation, visualizations, and analytics; deliverables frequently recaptured 8% of leaderships time (3-5 hours per week) from workflow/process improvement.

• Acted as interim Controller establishing and running the AP, Finance, and Accounting Departments for new ERP system; designed COAs and financial cost codes, processed $720K monthly in check productions and bank reconciliations, ran year end closings, developed manuals, and trained new employees.• Created reports assisting leadership in departmental management, insight, and analytics (PBI & Excel)

•Producing Strategic Analysis Report detailing most purchased amenities which translates into operational strategy; cooperative with Strategic Analyst to further integrate system into overall business level strategy•Produced the Down Payment Report detailing key critical metrics for different leaders into one esthetically pleasing report; databased and modeled the information in Excel’s PowerView add in; report sent monthly•Produced Productivity Analysis which detailed operations based on a variety of metrics; the report was sent to the IT department to be integrated into the Operations Management System•Simplified the CFO’s Production Overview Reporting system and modeled other investments and reports•Internship satisfying 'Signature Experience' for BBA 'Finance Honors Distinction'. Performed automation, analysis, and report generation for key leadership company wide. Directly reported to CFO; worked on projects for Purchasing & Estimating, Construction, Sales & Marketing, and Finance (PBI & Excel)

•Developed the Warranty Reporting Systems that organizes invoices and warranty items into reports detailing costs and historical product deficiencies to leadership (utilized same Analysis Services engine in PBI through Excel’s 2013 plugin). Procedures were established for continued integrity within the department. Reports linked through VPN for live feed and ease of use for leadership •Managed customer service items while upholding corporate policy (i.e managed vendors to satisfy outstanding claims after homes were closed; managed twenty outstanding homeowners requests per month)•Conducted quality inspections for completed homes and established official quality inspection standards

•Constructed residential homes ($450K-$750K) from the framing stage until completion•Managed vendors, handled material management and high involvement client relations, approved invoices, controlled quality management, and lead projects worth $3.6M and $2.25M

• Maintained properties