Cameron Grant: Data Analyst II

• 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

• 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

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

• 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

• 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