Ried A. Hancock
The Colony, Texas
Cell: 419-***-****
E-mail Address: adbv79@r.postjobfree.com
Professional Summary:
Talented Analyst with exceptional background utilizing data from diverse financial and information systems to build tools and forecasting models that remarkably improve organizational decision-making capabilities resulting in increased profitability. Demonstrated track record providing comprehensive financial forecasting, budgeting, and analysis to senior management at Fortune 500 organizations. Possess keen understanding of financial planning, and analytics.
Professional Work Experiences:
Toyota Motor North America, Plano TX April 2015 – Current
Labor Cost Analyst, Workforce Planning
Lead for 1.0/2.0 reporting and process. Coaching the HRBA’s/Comp Team on process flow/timelines along communication on reporting updates to the EVP’s prior to NAEC mtgs. Target Achievement ~$64M
Lead for Mfg. Headcount Reporting. Process improvement of the RHRI process time from 3.5 weeks down to >30 Min. while networking with other HR team members on TMNA headcount. ~42K FTE across NA.
Scrum Master for the WFP teams that reports up to the Senior Mgr. Monitor sprints through data visualization tools via Salesforce dashboards. Compare historical sprints to current to understand trends, velocity, based on work to complete customer demands.
Analyzing and complete the yearly first annual forecast and budget for labor costs by NAMC, Job Class, and business function while partnering with Compensation/Benefits to understand any gaps when comparing Actual vs. Budget. (Rate/OT/Bonus/Medical/Dental/Vision/401K/Pension/Employee contributions) via Hyperion.
Built and maintain financial models to showcase fluctuation amongst all aspects of labor cost by NAMC. These metrics point out the gaps from a YOY/MOM basis based on Base Wages, Overtime, bonus, and fringe.
Updating several excel databases including Hyperion Planning and PeopleSoft Software for Ad hoc analysis, thus meeting business partner needs in a timely manner
Complete the GHRI and MTBP for TMC annually along with feedback given any variances between BvA.
Coaching NAMC’s on headcount targets/rates while reconciling with these NAMC’s to make sure headcount ties out. This in turn will allow executive teams to truly understand where we currently are and where we need to go in order to align with future goals as a company.
Vantiv, Mason Ohio (Contract) April 2014 – March 2015
Senior Financial Analyst
Solely managed the Debit/Credit Campaigns – building, analyzing, promotional reporting, and retention reporting each month for all financial institutions involved in our marketing campaigns
Report owner responsible for the distribution of reports to Senior Management; these reports include key metrics proving how favorable/unfavorable each promotion is compared to historic and controlled data
Updated several excel databases for Ad hoc analysis, proving how Vantiv Analytics will help grow a financial institutions overall portfolio in Spend/card, TXN/card, and Interchange/Card
Continuously initiating additional responsibilities to my work load, thus becoming essential to the departments functionality
Hollywood Casino, Lawrenceburg, IN Oct 2012- Feb 2014
Senior Financial Analyst
Analyzed and completed the DOR (Daily Operating Reports) and send to Executives/Corporate
Managed monthly reports that need to be completed in a timely manner for Executives
Provided the marketing team with all analysis for promotions ran to improve the bottom dollar forward for all promotions, thus continuing to maintain and improve market share.
Omnicare, Covington, KY July 2010-April 2012
Internal Audit Pricing Analyst
Analyzed and complete the pricing for all files assigned by upper management
Advanced Access/Excel to complete files with 20-60K lines and discrepancies ranging from $100K-$1MM
Price prescription drugs with various rates and factors according to contract and their NDC
Assisted others when files become a priority due to various deadlines
Worked diligently with a team of analysts or by myself in order to meet deadlines given by management.
Fifth Third Bank, Cincinnati, OH May 2007-July 2010
Senior Financial Controls Analyst
Managed the Pre-Paid card account and mitigating over $8MM in the first few months of taking over the account
Reconciled the account from 10K outstanding items down to roughly 120 after 8 months of work
Reported numbers on a weekly basis to upper management via conference calls to report improvements/issues
Traveled to Atlanta, GA to meet with INCOMM, to improve the overall function of the account. Discussed the inconsistencies the company was providing thus leading to balanced files being sent over to Fifth Third.
Became the “go-to” analyst whenever there was an issue, answering emails/phone calls to resolve all issues
Managed to eliminate monthly write-offs and turned a net profit of $0.90 per card into $2.35 per card
Aided in recovering delinquent and outstanding items on cash and coin accounts; $25-$50 million annually
Spearheaded conversions of manual accounts to automated reconciling systems to increase efficiency
Education:
University of Toledo; Bachelors in Finance