CG

Cameron Grant

Data Analyst II · Nationwide Marketing Group


In My Own Words

• Data Analyst experienced in developing reports and dashboards
• Manage databases by means of data manipulation and data cleansing

• Advanced SQL querying knowledge

• Proficient with SQL Databases, SQL Server Reporting Service (SSRS), Google Data Studio, MicroStrategy, Lawson ERP, SharePoint Designer and Microsoft Office applications such as Excel, Word, PowerPoint, Access, Visio, & Outlook

Work Experience

Data Analyst II

Nationwide Marketing Group

2020 – Present

• Transform & interpret data to create analyses & insights relevant to business process, performance, questions, initiatives, and objectives • Collaborate with analytics team & business partners to assist in developing & testing data sets, analytic models, reports, & analyses using technology such as Google Big Query (SQL) & Google Data Studio (Business Intelligence Reporting) • Collaborate on an agile team, assisting in full lifecycle analysis to include requirements, planning, design, development, testing & support • Develop analyses & reports supporting proactive projects & ad hoc requests

Reports Specialist

Spectrum, Charter Communications

2019 – 2020

• Develop and maintain reporting and application solutions using SQL queries, SSRS, & Excel to provide increased efficiency and consistency for call center, higher employee and stakeholder satisfaction, and reduced costs • Analyze data exported from MicroStrategy and Tableau reports.

• Utilized data housed in multiple databases/systems to produce summary and detailed reporting solutions for key performance indicators

• Produce ad hoc reports to answer business questions quickly and thoroughly

• Developed technology documentation to support ongoing maintenance of reporting and application solutions • Developed communication documentation to support deployment of reporting and application solutions to end users

Master Data Analyst

Community Health Systems

2017 – 2018

• Served as a point of contact for the organization for the submission of supplier requests, supplier updates and contract data. • Identified areas for data quality improvements to resolve quality issues through error detection, correction, process control, improvement and/or process re-design strategies

• Conducted data cleansing to rid the system of old, unused, inaccurate or duplicative data.

• Develop queries in Oracle SQL Developer to join tables from Lawson database to audit item maintenance and automate lookup tasks from Lawson and vendor websites

• Utilized Microsoft Excel and lookup functions when confirming pricing on contracted items • Worked request from hospitals out of Service Now to resolve any item maintenance issues

Business Planning & Strategy Consultant

MetLife

2016 – 2016

Collected, compiled, reconciled, and analyze financial operational and transactional data

• Generated and formatted reports for Global Operations leadership and internal stakeholder groups, including trend and variance analysis

• Participated in end-user testing and training as needed

• Reconciled various reporting sources and create summary of key differences • Assisted in preparing executive summaries for senior management • Exported reports from Cognos and QlikView environment and input into SharePoint

Space Planning Database Analyst

Dollar General

2015 – 2016

• Audited product categories to make certain that stores follow regional and state guidelines • Analyzed test projects in order to find the most efficient method of setting a store's product

• Used Microsoft Excel to create reports to send to buyers using lookup functions, Pivot Tables, chart formatting, and formulas • Worked with Store Operations to ensure each store is set, in terms of product, to provide the highest profit margins

Property Analyst

The Kroger Inc

2009 – 2015

• Responsible for ensuring all assets are properly reviewed and processed in a timely and efficient manner • Uploaded assets purchased for construction projects in accordance with the Kroger Accounting Policy to Property Accounting System

• Completed reports each period for division controllers' review

Education

Bachelor of Science in Marketing & Supply Chain Management

University of Memphis

2015

Bachelor of Science in Marketing & Supply Chain Management