Power Bi Business Intelligence

Tím Cavalíerè

Greater Charlotte, NC

C: 828-***-****

************@*****.***

PROFESSIONAL EXPERIENCE

Curo Health Services Jun 2022-Present

Power BI Developer Senior

Power BI, VBA, SQL, Excel

Business Intelligence Management, Power BI Dashboard Development: Ensure that our SQL server/Power BI data is up to date and accurate. Manage Report Requests and build out new reports for key stakeholders.

Report Creation: Using SQL, Power Query and the Power Platform to ensure stakeholder requests are met in a timely fashion. Building reports to suit user needs.

Management: Overseeing a small team of BI Analysts that I create project timelines for. Ensuring timely completion of tasks, delegated to subordinates appropriately.

Curo Health Services Jun 2020-Jun 2022

Senior Strategy Analyst (Promotion)

Power BI, VBA, SQL, Excel

Business Intelligence, Power BI Dashboard Development: Worked with Team as main developer for an implemented Power BI Dashboard that is used to communicate field KPIs efficiently.

Strategic Development & Workforce Management: Ensuring the accurate processing of data on a daily basis to update staffing models for two divisions of the company, responsible for decision making on approximately 13,000 possible positions, the creation of salary ranges and approval of salaries offered for field-employees.

Programming & Process Improvement: Revisiting Processes that are not efficient, building programs in the preferred method of department and rolling out simplified processes.

Small Business Owner Sep 2019-Jan 2024

Transportation & Logistics Scheduling Rides & licensed black car limo transport.

IT, Marketing Built a functioning website with marketing, connected to a payment processing terminal.

Curo Health Services Feb 2019-Jun 2020

Financial Modeling & WFM Analyst (Promotion)

VBA, SQL, Excel

Development & Workforce Management: Developed two staffing models from scratch for two divisions, along with source code that automates the data-refreshing & loading process (ETL). The staffing models cover two divisions of the company (Home Health and Hospice). Excel’s VBA & SQL are used. HTTP Post, SAP data mining, HCHB extraction and Unity extraction techniques are also used.

Financial Analysis & Reporting: Building Reports that show the current attained, period attained vs target schedules. These projects use principles of financial analysis. The total potential/target savings based upon financial analyses amount to substantial totals, much of which has been actualized as of today. Redacted samples & methodology are available upon request.

Curo Health Services Jun 2018-Feb 2019

HR PR Analyst

VBA, Excel, PowerShell, SQL

Development & Process Improvement: Utilization of Visual Basic for Excel’s coding language to create an automated ticketing system to a server named Manage Engine. This has reduced processing time from 3 hours per processor to less than 5 minutes in 5 major Audit Categories. I utilize VBA to create audit reports, sourced with SQL data, that have further reduced processing time and increase transparency. These are used for metrics. The communication portion of the system creates a table from 150,000+ lines and sends/creates a ticket in our ticketing system Manage engine based upon the filtered criteria in HTML format. This uses the OLE Automation, Microsoft Excel and Outlook Libraries. As I developed the code, samples and demos are available upon request.

Analysis & Project Management: Assisted in the transition of over 6500 new employees into our current time keeping system. This involves testing data and 3-way comparisons. The line total for each 3 sources totals in the hundreds of thousands. Creation of audit reports for human resources using analysis techniques based upon data stored in various locations ranging from SQL Server to .csv & .txt files exported from the company’s time management system.

Coca-Cola Bottle Consolidated Feb 2017-Jun 2018

Cashless Systems Analyst (Promotion)

Access Queries/Database Management, Excel, SAP

Analysis and Accounting: Managing the general ledgers, reconciliations and data of approximately 50 accounts and their sub-accounts pertaining to Coca-Cola’s cashless/credit-card vending systems. This requires maintaining several access databases and SAP-based general-ledgers that go across department. This gives me sufficient experience in testing/developing queries to validate data within a database.

Project Management: General troubleshooting and execution of several thousand readers swapped from one SAP system into another, more expedient SAP system. Ad-hoc troubleshooting with branch-communications and accounts that meet objective criteria determined upon receipt of issue.

AccruePartners October 2016-February 2017

Analyst Contractor

Access, Excel, SAP

Analysis and Accounting: Maintaining General ledgers, reconciliations, and data thereof of approximately 50 accounts

Project Management: Credit Card/Debit Card reader maintenance and ensuring the data is accurately and meticulously held in our databases. Data validation tests and techniques are used here.

PLM Trailer Leasing at Montvale, New Jersey July 2015-August 2016

Business Support Analyst

Excel, RMI, VBA

Process Improvement: Worked with AR, AP and Billing/Collections departments to streamline the processes that were currently in place. Data-extraction and centralization were the focus of these process improvements. Created an organized, shared system for branches to streamline the credit authorization process for customers. Leveraged Sharepoint to increase visibility with branches across the United States to ensure transparency and improve communication with regional managers and the corporate-HQ.

Project Management: Ad-hoc projects and communication with Inside Sales and Branch managers. Worked directly with the Vice President of the company’s Customer Services to improve the credit-granting process for lower level customers. Helped evaluate the cost-benefit of a decision to switch credit-ranking companies. Leveraged competitive nature of their services to shift the credit-review data used for the company to a more centralized, simple version for lower-level customers.

EDUCATION

Master’s Degree – Business Administration

PMP Certified

Western Carolina University

Asheville, NC

2023-2025

Certification – Data Analytics

Cornell University

Ithica, NY

Certification

2018-2019

Bachelor’s Degree –Economics

Minor- Psychology

Rowan University

Glassboro, New Jersey

2011-2015

**Currently Enrolled in CPCC, taking Computer Science, Engineering, IT and Mathematics classes**

Collegiate Leadership

Rowan Intramural Soccer Co-Captain 2012-2015

Economics Club Active Member 2012-2015

Rowan University Club Golf Active Member 2012-2015

TECHNICAL & OTHER SKILLS

VBA, SAP, TSQL, Database-creation/management, RMI, C++, Java, Public Speaking, Negotiating, Quickbooks, Microsoft Office: Excel (VLOOKUP’s, PIVOTTABLES and intermediate level VBA macros/jet report pulls from linked/requested databases), Word, PowerPoint, Access, Outlook, Basic Computer Troubleshooting, basic working HTML knowledge, research analysis, econometrics.

Contact this candidate