Bachelor of Science in Marketing & Supply Chain Management

Data Analyst II

• 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

• 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

• 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

Reports Specialist

• 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

Master Data Analyst

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

Business Planning & Strategy Consultant

• 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

Space Planning Database Analyst

• 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

Property Analyst

Find out detailed information about Cameron Grant, Data Analyst II 

Cameron Grant: Data Analyst II

Cameron Grant

Nationwide Marketing Group

Spectrum, Charter Communications

Community Health Systems

MetLife

Dollar General

The Kroger Inc

University of Memphis