Data Analytics and Reporting

Paul Buckley

**** ****** **, *** #***, Santa Clara, CA 95051

Contact

Cell Phone: 479-***-****

E-mail: ********@*****.***

Summary of Qualifications

Analytical and strategic professional with over 7.5 years of work experience.

Expert in data analytics and reporting, utilizing tools ranging from Excel to Tableau.

High proficiency in VBA programming and SQL (Excel, Access, Teradata, SQL Server, DB2).

Advanced Excel and Access skillset.

Alteryx, Tableau, SharePoint, HTML, XML, and APT experience. Work Experience

Wal-Mart Stores, Inc., Bentonville, Arkansas 8/2009 – Present Senior Manager, Merchandising Systems (8/2016 – Present)

Specialized in developing advanced, automated reports including the front end and back end processes, utilizing VBA, SQL, XML, and HTML.

Optimized ETL processes that involved tens of millions of rows with up to 30 metrics across.

Provided exceptional customer service to our end users, taking their requirements and creating effective reporting that met or exceeded their needs.

Collaborated with fellow team members to share knowledge and expertise, leveraging the team’s talents to create the best product possible for our customers. Project Manager II, Frontend Innovation (10/2014 – 7/2016)

Led the Associate Training for Walmart Pay pilot program, the new app payment method using a mobile device. Provided training documentation and led in-store training of associates. Garnered feedback and reported back to executive leadership.

Conducted data analysis and reporting on front end metrics such as transactions, line length, ROP, etc.

Automated numerous excel reports utilizing VBA code.

Developed a process within Microsoft Access to calculate the number of registers needed opened per hour by store, by utilizing a predefined mathematical equation and VBA code.

Created informative Tableau dashboards for Supercenter and NHM pilot projects. Sr. Manager, Global People Analytics (5/2014 – 9/2014)

Conducted data analysis on project specific metrics and optimal test site selection.

Compiled qualitative data through in-store interviews and focus groups.

Created Leadership Scorecards for project performance tracking.

Developed clean, intuitive SharePoint site for team projects. Manager, Compensation (11/2012 – 4/2014)

Conducted data analysis/management, created dashboards, and drafted rewards communications.

Designed and led successful implementation of data application, greatly enhancing visibility and access to employee specific information. Enabled compensation teams to be more agile in decision making.

Coded, in VBA, a process that greatly improved incentive forecasting by automating the calculations of the sales and profit matrix, significantly reducing the amount of time needed.

Created dashboard reports featuring crucial compensation metrics for all areas of Walmart US Field and Home Office.

Manager, Data Analytics (12/2009 – 10/2012)

Owned over 22 recurring reports on a monthly, bi-weekly, and weekly basis.

Managed qualitative research for workforce strategy, organizing many focus groups across the country.

Created an HR scorecard which Field and HR leadership used for performance evaluations.

Programmed a web based calculator which automatically determines leave of absence eligibility for store employees, netting $2 million+ savings annually.

Programmed an automated process in Access and Excel for creating thousands of severance packets, legal agreements, and performance evaluations.

Prototyped web based data reporting utilizing HTML, ASP, and JavaScript programming.

Led a small team to develop web based data reporting.

Created SharePoint sites for reporting, collaboration, data repositories, and data collection. Data Analyst (8/2009 – 12/2009)

Supported various reporting and analytical functions for the HR Strategy department. Education

University of Arkansas, Fayetteville, Arkansas 8/2005 - 5/2009 Bachelor’s of Science, Information Systems, Minor in Enterprise Resource Planning

Contact this candidate