Your Name
St Johns,FL
Summary
Williams, Erick M. Highly motivated data analyst and visualization expert with strong business analytic solution delivery skills
14+ year experience working with clients and different businesses with data analytic and business requirement gathering and Tableau.
14+ year relational database in SQL server, MS Access and MS EXCEL
Known for my dedicated teamwork, high-energy, excellent work ethic, and committed to business beneficial and all around success
14+ years Tableau Developer.
Overview
5
5
years of professional experience
Work History
Free Lancer, Help Desk
03.2017 - 09.2021
- Tableau Cascading Search/Filter
- Tableau & Power BI, Salesforce Opportunity & Account KPI Analysis
- Reading Data from Salesforce & AWS Redshift
- Create marketing KPI based on Opportunity, Account & Products
- Trend and Risk analysis on contracts
- Identify successful campaigns and markets
- Funnel chart analysis for Opportunities and accounts
- Denver Crime Analysis During Covid 2020
- A Tableau crime analyst model for Denver CO for 2020 Covid impact
- Measures include crime and traffic incident counts, Year Over Year comparison
- Dimensions include Zones, Incident Type, City and Category,, dill down and drill thru actions etc
- On-Line Retail Sales vs Profit Analysis
- A sales vs Profit model for an on-line retail store
- Measures include Sales, Profits, Orders and Quantities
- Dimensions include Customer, Product, Region, Country, Category, Segments…etc, Ticket System Analysis
- A company internal ticket system outsourcing analysis
- Measures include Ticket Count, Duration and Aging Days
- Dimensions include Region, Cluster, Agent, Customer, Source, Priority, Business Units and Work Groups
- Ground On time Delivery Analysis
- An oversea trucking company On-time Delivery Analysis
- Measures include Trip Count, Stop Count, Duration and Late vs Early Minutes
- Dimensions include Driver, Stop Name, Route, Priority, City, State, Country …etc.
Education
Administration
Florida State College OF Jacksonville
Skills
Tableau Desktop 20223Tableau Prep 2021AlteryxData DiscoveryReporting SolutionsDashboard Performance TuningMicrosoft EXCELEXCEL Power PivotPower BI & DAXSQL Server T-SQL Analytic QueriesPostgreSQL SQL QueriesSalesforce, Amazon Redshift, Google SheetsData Warehouse, Star Schema and Denormalized Dimensional Data ModelExperiencePrinciple Software Developer AnalystNorthrup GunmanSept 2021 – PresentTableau DevelopmentTableau Prep EngineeringSQL DevelopmentSAP Financial Data ConnectionSpace Occupancy ProjectSAP MVP Enterprise DashboardData EngineeringData Warehouse ETL ProcessingDynamic Slicer/Filter DesignDrill-Down/Drill Thru Action DesignAnimation ChartsTableau Server Workbook and Extract DeploymentCross Plant Inventory ProjectDashboard Mock up
Accomplishments
- CONSTRUCTION INSPECTION PROJECT MANAGEMENT
- Functional Analysis, JEA
- December 1999 – March 2017
- Tableau Analysis/Developer
- Construction Project Management
- Project Time-Line Analysis
- Project Budget vs Actual Analysis
- Microsoft Power Point
- Microsoft EXCEL
- Microsoft Access 2012
- Microsoft SQL Server TSQL Queries
- Tableau Public https://public.tableau.com/profile/erick.williams#!/
- YouTube https://www.youtube.com/channel/UCwocSvVuv_OwsAL-tcbNWeQ
Timeline
Free Lancer, Help Desk
03.2017 - 09.2021
Administration
Florida State College OF Jacksonville