Data Manager

Derrick R. Hickman

Dear Human Resources,

I graduated in May of 2013 from the University of Louisville with a Bachelor of Science in Business Administration majoring in finance with a minor in international business. I currently work for Restaurant Supply Chain Solutions as a manager of commodity risk and procurement analytics.

Prior to working at Restaurant Supply Chain Solutions, I worked at 5/3 Bancorp as a Risk Analyst II. In this role, I developed automated solutions using Microsoft excel and access to reduce operating risks and increase revenue on commercial banking products.

During my time with Restaurant Supply Chain Solutions I have become more proficient with Microsoft excel and access building business applications for users that increase efficiency and reducing data inaccuracies. I have also worked with other data querying software systems such as Oracle to better prepare data for more concise and efficient presentation to management.

Enclosed you will find my resume to further explain my experiences and qualifications. I hope to be in your consideration to become a part of your company and I look forward to speaking with you.

Sincerely,

Derrick R. Hickman

Derrick Hickman ***************@*****.*** 502-***-****

Data/Risk Manager

PROFESSIONAL EXPERIENCE

Restaurant Supply Chain Solutions, Louisville, KY. Jun. 2018 -- Present

Yum brand’s co-operative providing purchasing and supply chain management for Pizza Hut, Taco Bell, and KFC

Commodity Risk Manager (February 2019 – Present)

Managing over $300 million in spend for KFCs frying oil and YUM brands wheat products through hedging commodity futures by using business intelligence tools.

Automated a series of manual processes for capturing commodity futures trades thereby allowing more accurate historical records, having instantaneous and constant reporting capabilities, and modeling past trading successes and detriments using Power BI.

Creating category strategies with executives to prepare for risks associated with economic influences and market volatility.

Developing relationships with suppliers to establish more efficient processes for recording transaction data through Microsoft excel and Microsoft Power BI.

Procurement Analytics Manager (June 2018 – Present)

Creating solutions to supply chain inefficiencies through collecting, cleaning, and analyzing data through Microsoft excel, Microsoft Access, and Power BI, running RFP events, and creating dashboards and business information tools for use throughout organization.

Managing RFP events for the entire supply chain network and finding the most efficient shipping options with the least cost suppliers.

Automated data gathering and cleaning through Microsoft Excel and VBA, Microsoft Access, and Power BI to create automatically updated dashboards.

Created process to merge data of several departments to give a standardized, holistic view of spend information across different reporting areas.

5/3 Bank, Cincinnati, OH Dec. 2016 – Jun. 2018

Regional bank headquartered in Cincinnati, Ohio providing consumer and commercial financial services.

Operations Analyst II

Providing risk analysis and consultation to multiple stakeholders in operations and providing data analysis for management decisions using Microsoft Excel, Microsoft Access, VBA, and Business Objects.

Improved data integrity by creating unique IDs assigned to customers used by both the bank and its vendors to allow for data uniformity.

Created dashboards formatted for HTML to better visualize large data sets and provide executive management with easy access to monthly metrics, revenue totals by customer, and vendor performance.

Insured the bank’s vendors adhere to agreements by comparing invoice data to contract language.

Member of the bank’s Database Committee ensuring data integrity, data efficiency, and data security across the banks operations.

NTT Data, Louisville, KY June 2016 – Dec. 2016

IT firm providing consulting, project management, and cloud-based data management solutions.

Business/Remediation Analyst

Providing analysis and consultation to financial institutions on handling risk and fraud by evaluating data from financial statements and industry analysis.

Utilizing Microsoft Excel, Microsoft Access, and Oracle products to summarize data and present to senior management.

Assisting management in process and efficiency improvements for project management.

Pharmerica, Louisville, KY August 2013 – May 2016 Long-term care pharmacy management service provider for institutional care facilities.

Purchasing Analyst (July 2015 – May 2016)

Promoted to the Trade Relations department monitoring purchases each day. Identified and analyzed off-contract purchases and recommended resolutions. Analyzed purchasing contracts, invoices, and historical pricing using Microsoft Excel and Microsoft Access to identify cost-saving opportunities.

Slashed off-contract purchases by 60% through diligent analysis and savings recommendations.

Reviewed customer contracts and purchase orders to determine pharmaceuticals purchased off-contract and analyzed their financial impact.

Completed a research project for review by the CEO that projected a significant savings opportunity for moving high-use products to contracts.

Plan Analyst (August 2013 – July 2015)

Performed daily checks of medication prices in a national drug database. Resolved issues and errors in the pricing software. Constructed financial models for invoicing customers.

Took initiative to build Microsoft Excel tool with VBA that enabled a team of 6 analysts to process and correct errors in several databases encompassing 7 years of customer data in a shortened timeframe.

Maintained an accurate and current pharmaceutical database in accordance with Federal and state upper limits, complying with all Federal and state laws.

Selected to create monthly Sarbanes-Oxley audit reports for review at the highest corporate level.

Developed a more concise way to monitor and record weekly database checks for pricing accuracy.

Citibank, Louisville, KY October 2009 – July 2013

Consumer division of financial services multinational Citigroup.

Customer Service/Sales

Resolved customer issues and performed account resolution for accounts with a high probability of moving into litigation. Renegotiated credit card terms and assisted customers with fraudulent account usage.

Resolved over $2 MM in past-due accounts.

Part of the bank’s first work at home team in Louisville, KY for 3 years.

EDUCATION

University of Louisville, Louisville, KY

BSBA in Finance and International Business 2013

TECHNICAL SKILLS

Microsoft Excel, Access, PowerPoint, and Word

VBA

Power BI

DAX

SQL

Data Analysis

Forecasting

Multiple project management

Contact this candidate