Anthony McNichols
Orange,CA
Summary
Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy.
Overview
4
4
years of professional experience
Work History
Tableau Developer
Viant
06.2022 - Current
- Responsible for meeting with internal business users to understand objective, design, build, release, and support various initiatives ranging from creating front end visualizations to back-end alerts, monitoring, and reporting
- Restricted data for particular users using Row level security and User filters.
- Develop automated and ad-hoc reports by utilizing SQL statements and Workflow Automaton on Google Big Query to analyze pre, mid and post - advertising campaign deliverables
- Enhance advertising campaign performance with strategic recommendations based on data analysis and trends.
- Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
- Collaborated with stakeholders to identify business needs and data sources.
- Increased reporting usage by 30% from updating KPIs.
Operations Analyst
Pricespider
11.2020 - 05.2022
- Ultimately responsible for ensuring accuracy and availability of data that Pricespider customers rely on for every product line with skills developed through training and processes provided
- Create interactive visualizations through data interpretation and analysis integrating various reporting components from multiple data sources
- Write regex code in order to parse specified data from top retailers such as Amazon, Target and Walmart websites
- Test tickets using SQL ensure data is accurate and present in database
- Monitor and debug Where to Buy Widget code to make sure everything is present for consumer
- Collaborate with team leads and manager weekly to share ideas on how to improve processes.
Data Analyst
State Street
09.2019 - 11.2020
- Working with multiple teams on day to day trade processes to make sure it flows correctly
- Act as a resource within assigned business unit to resolve complex or non-routine process related questions/issues
- Interacts with internal and external parties to resolve various trade related issues
- Assists team with creating, updating and maintaining standard operating procedures
- Utilized Microsoft Excel to categorize previous day reports into detailed pivot table
- Revised excel formulas in existing sheets to add new clients and there specific reporting criteria.
Education
Bachelor of Science - Economics
Portland State University
Portland, ORSkills
- BigQuery
- Data Analysis
- Google Data Studio
- JIRA
- Microsoft Excel
- Google Big Query
- SQL
- Standard Operating Procedure
- Tableau Software
- Teamwork
Timeline
Tableau Developer
Viant
06.2022 - Current
Operations Analyst
Pricespider
11.2020 - 05.2022
Data Analyst
State Street
09.2019 - 11.2020
Bachelor of Science - Economics
Portland State University