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 Group2020 – 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 Communications2019 – 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 Systems2017 – 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
MetLife2016 – 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 General2015 – 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 Inc2009 – 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 Memphis2015
Bachelor of Science in Marketing & Supply Chain Management