Business Analyst Data

SKILLS

Excel

SQL

Google Sheets

Looker Studio

Tableau: Profile - victor.williams6038

Tableau Public

Python: Victor-908/Projects

(github.com)

PROJECTS

Customer Sales Analysis – Personal Project

o Utilized SQL to extract data from multiple related tables from customer sales databases using JOIN and VIEW.

o Transform and filter relevant data to create an interactive dashboard in Tableau to display sales trends, track revenue, and display categories by revenue.

Housing Market Availability Dashboard – Personal Project o Created an interactive dashboard using Tableau to display housing market options in Seattle 2014-2015.

o Perform data cleaning on the Excel dataset and aggregate the csv into Tableau. o Ensured questions of common home buyers would be answered through concise visualization of data.

ACCOMPLISHMENTS

Established new protocols for intake and distribution of confidential files, ultimately raising department KPI’s by 40% - leading to being recognized as the most proficient associate of the year.

Increased daily individual KPI’s by 33% by collaborating across departments to launch and implement a new validation role.

RELEVANT EXPERIENCE

Lexitas Legal Wayne, PA (Remote)

Operations Specialist

September 2020 Present

Create dashboards displaying accurate depiction of workflow per region/date/sales representative.

Query reports extracted from Salesforce in Excel to gain insights as to reporter availability using Lookup statements.

Create tables/graphs to display quantity of jobs taken and their respective urgency level. Data/Business Analyst

VICTOR WILLIAMS JR

678-***-**** ********.*********@*****.***

https://www.linkedin.com/in/williams-victor-jr/

Douglasville, GA 30135

Iteratively build and prototype dashboards to provide insights at scale, solving for analytical needs.

Recommend improvement to work processes to increase efficiency while maintaining quality of work.

Remain up to date and install new software as needed to remain trusted point of contact for newly acquired businesses.

Access shared databases and filter for necessary data and validating information for pertinent cases.

Collaborate with cross-functional partners, discussing their needs and ensuring workable solutions are implemented appropriately to satisfy all requirements.

Query reports in Salesforce to organize workflow, ensuring deadlines for expedited jobs are met.

Esquire Deposition Solutions Atlanta, GA (Hybrid) Coordinator

January 2015 September 2020

Analyze current processes and identify patterns to improve systems and increase daily output.

Present complex information in a clear and concise manner to a variety of audiences, including executive levels in the company.

Collaborate with stakeholders and subject matter experts to better understand their issues and deliver favorable outcomes.

Lead virtual presentations with service partners and internal staff, presenting new processes and programs.

Install, test, and configure software remotely, ensuring client can use our platform seamlessly.

Open and close help desk tickets, requesting senior technical support for high level issues. EDUCATION

Certificates

Introduction to Data Analysis using Microsoft Excel

SQL: A Practical Introduction for Querying Databases

How to Use Lookup Reference Math and Text Functions in Excel

Introduction to Business Analysis Using Spreadsheets

Create Custom Marketing Analytics Dashboard in Google Looker Studio Georgia Southern University – Statesboro, Ga

August 2011 December 2013

Completed 50 Credit Hours towards a Business Management Degree

Contact this candidate