Clifford L. Clayman
SUMMARY
Accomplishments
Over sixteen years of experience within Sears Holdings Corporation at various positions including Transportation, Home Delivery, Home Services and Supply Chain Metrics.
Researched, developed and implemented dynamic online reporting tools for end users utilizing data from various sources using SQL Server 2012 and Microsoft Visual Studio 2010 and 2013.
Proficient in analyzing data and identifying root causes and executing corrective actions with minimal support.
Extracurricular Activities
Website Developer and Audio Editor – New Life Baptist Church, 2014 – Present
Softball Captain and Board member – SHC, 2001 – 2012
Little League Baseball Manager – Meadowdale Little League/Tri-Cities Little League, 2003 – 2010
AWANA leader – New Life Baptist Church, 2014 – Present
CERTIFICATIONS
Microsoft Office Specialist Expert certification
Microsoft Certified Technology Specialist – Microsoft SQL Server
EDUCATION
Business Programming and Web Development – The Chubb Institute, Villa Park, IL, 2001
TECHNICAL SKILLS
Microsoft Office XP/2010/2013, VBA, Microsoft Access, Excel, PowerPoint, SharePoint, Visio, Microsoft Word, SQL Server 2005/2008/2012, SQL, SSIS, SSRS, SSAS, Tableau, Business Objects, CSS, COGNOS, HTML, IIS, ASP.net, PHP, Java Script, Windows 7/8/10, Microsoft Visual Studio 2008/2010/2013
EXPERIENCE
Autocar Parts, LLC
Materials Manager/Business Analyst 01/2013 - 09/2015
Increased productivity and accuracy of purchasing department by 50% within a year.
Reduced overall inventory by $1M and increased sales over $4M by bringing in the correct inventory and reducing cost on slow moving inventory.
Managed a team of Product Managers and the purchasing and inventory control functions for over $9M.
Provided support to production scheduling on all material flow issues to meet production schedules and customer requirements.
Extracted data from the inventory system into Microsoft Access and created reports using VBA and Macros integrated with Excel reports that contained summary charts and graphs.
Created reports in Microsoft Excel using Pivot tables, Pivot charts and PowerPivot.
Developed and rolled out an automated reporting system within two months for Purchasing, Pricing, Customer Service and Operations using SQL Server 2012, SSRS and SSIS from various data sources including Microsoft Access and Excel at zero initial cost.
Meet with associates from Autocar and translated their requirements into actionable reports that were end-user friendly and easily available for ad-hoc downloads or scheduled releases.
Sears Holdings Corporation 07/1996 - 12/2012
Business Analyst/Data Analyst 06/2012 - 12/2012
Acted as the subject matter expert on gathering, interpreting, manipulating, structuring data and front-end development including web design, reporting systems and data reporting.
Developed a gift card reporting system that enabled customer service agents to reduce gift cards issued to customers by 10% through ease of collecting and analyzing data. Lowered the time spent entering data by 25% through simple interface.
Performed reviews of existing code for inefficiencies and implemented improvements.
Sr. Data Analyst, IM Systems & Support 04/2010 - 06/2012
Worked with end users to define their needs and requirements and translate them into actionable, repeatable processes and/or reports. Utilized understanding of available information and data to define the best solution for customers.
Created a Report Services website using SQL Server 2008, SSRS and SSIS that was used as a replacement for manual reporting. The site allowed for automation of reports and the end users were able to automatically obtain customized reports through subscriptions.
Documented team standard practices, helpful hints, best practices and created/maintained a library of examples and re-usable code, allowing for easier and consistent coding. Created documentation for processes that contained the information required for troubleshooting as well as for general purposes.
Monitored scheduled and unscheduled processes for running times and accuracy. Monitored environment for space issues and IT driven changes. Partnered with IT on software changes and hardware upgrades.
Product Quality Data Analyst 08/2006 - 04/2010
Contributed to 15% reduction in Cost of Quality and improved Customer Satisfaction of Serviceable and Deliverable products by providing data and analytic support and insight allowing the identification, measurement and tracking projects and programs including needed direct participation.
Analyzed data from multiple data sources to determine issues within the organization in regards to Product Quality. The data sources include AS400, DB2, Teradata, SQL, RS6000 and Microsoft Access.
Designed and implemented an automated reporting site using SQL Server 2008, SSRS and SSIS that was used by several different areas of the business such as Customer Care Network, Delivery Operations and Retail Operations.
Systems Support Consultant 06/2004 - 08/2006
Provided field support for our Home Delivery operations. The systems used included the enhanced home delivery system, the inventory system and all PC and laptop applications.
Provided support to the end user for laptop and PC hardware or software issues. Reduced repair time for the end user by 75% by implementing desktop sharing software.
Contributed to reduction in address corrections and increased delivery stops through system improvements and working directly with delivery associates.
Transportation Lead 10/2003 - 06/2004
Acted in a supervisory role to second shift associates by developing and delivering new trailer load reports quickly and effectively for the nation's largest appliance distribution system consisting of 11 distribution centers to 100+ local delivery centers.
Operational Support Administrator 07/1996 - 10/2003
Developed a more efficient method for cubing out trailers which resulted in a cost savings of $750k in a 9 month time frame utilizing VBA and Macros in Microsoft Access.
Created reports using Microsoft Access and Microsoft Excel in a fast paced environment for field associates to quickly and efficiently load trailers for on-time delivery to our customers.