Garrett Thomas Email & Phone Number

Hilliard, Oh, Us

Hilliard, Oh, Us

Columbus, Oh, Us

• Develop Financial models, reports and visualizationso Create financial reports using IBM Cognos for various requestso Introduce Microsoft PowerBI reports and dashboards for senior leadership audienceso Representative for my team on our finance org’s Process Improvement and Automation Team• Prepare and Monitor Capital Investment Projectso Prepare and develop capital requisitions for senior leadership approvalo Deliver monthly reports to ensure projects are staying within their authorized amounto Review monthly financial data for variance explanations and investigations• Create and lead process improvement needso Design and maintain a new process for approval requests using Microsoft PowerAppso Reduced time in capital improvement reviews by consolidating query runs and automating the excel templateo Managing the utilization Microsoft Sharepoint to assist in collaboration with regional teams for project tracking and transparency

Columbus, Oh, Us

•Report financial health of programso Review and track forecasts of programs using Ecosys data dump to project future spendo Run actuals from Business Objects to examine the current position of our programso Track month to month variance of program’s financial health to ensure forecast accuracy•Aid with project advancemento Create projects and work orders for projects that are moving forward using PeopleSoft and Maximoo Provide program financial situations to see opportunity of additional projectso Collaborate on the development of programs for future rebuild and rehabilitation programs•Perform Ad-hoc reporting and recommendationso Work cross platform to ensure product is clear, concise and effective for all stakeholderso Assist in program revisions to protect program financial risk when neededo Aid in spares and failure programs to ensure the needs identified are credible and capable to be funded

Glen Allen, Va, Us

•Report financial health of programso Review and track forecasts of programs using Ecosys data dump to project future spendo Run actuals from Business Objects to examine the current position of our programso Track month to month variance of program’s financial health to ensure forecast accuracy•Aid with project advancemento Create projects and work orders for projects that are moving forward using PeopleSoft and Maximoo Provide program financial situations to see opportunity of additional projectso Collaborate on the development of programs for future rebuild and rehabilitation programs•Perform Ad-hoc reporting and recommendationso Work cross platform to ensure product is clear, concise and effective for all stakeholderso Assist in program revisions to protect program financial risk when neededo Aid in spares and failure programs to ensure the needs identified are credible and capable to be funded

Menlo Park, Ca, Us

•Reviewed and audited transactionso Investigated fraud claims to ensure transactions were legitimateo Accessed accounts to verify actions were made by authorized personnelo Investigated recipient of dollars to ensure that the beneficiaries were legitimate and reputable individuals or companieso Analyzed and discovered patterns of banking activity to track suspicious and unusual behavior•Wrote and Filed Reports on investigationo Internally wrote reports to document the findings of investigations. o Tracked accounts and names to identify later claims that came through the financial institution o Identified and listed potential abusers and victims in each reported case o Recommended the closure of accounts to reduce the risk for the financial institution•Filed Suspicious Activity Reports to national database o Reported suspicious activity report based on specific requirements o Flagged filings with identical suspects and accounts to be tracked in a national database o Reported determinations of findings with multiple examples and details to confirm a complete story

Columbus, Oh, Us

•Consolidated global sales for weekly distributiono Compiled the current stores data and distributed the information to a report via excelo Reviewed numbers to ensure accuracy and provided description explaining weekly findingso Improved data gathering process using excel•Adjusted current Income Statement to be fully burdenedo Each week pulled the forecasts from SAP to the income statement excel sheeto Tasked with going in and re-calculating various e-commerce costs that were being applied to the Canadian Channel (Duty differential, Freight schedules, cancels, etc.) o Created an excel report to show the impact that the now correct income statements had and presented this process and report to multiple managers and directors.•Aided in the Fall Budget Decko Tied all the seasonal numbers back to the correct numbers in excel and SAPo Found and pointed out any discrepancies in the wording or data in the decko Printed and put together binders that went to C-suite level personnel

Lima, Oh, Us

•Created a formula to calculate cost for the micro-labo Observed and accounted for all the material used for testing and how much was being used in each testo Executed a cost analysis of materials and lab equipment by contacting a variety of suppliers and manufacturers o Developed an algorithm to show the cost effectiveness of the micro lab and its benefit to the company•Reported Daily torques and helped bring parts per million down from 30,000 to 100o Pulled daily torque data from SAP and put them into an excel fileo Calculated how many defects we would have if we processed one million bottles (30,000)o Determined which shift or people were reporting higher than the acceptable number of defectso Worked with my manager and the line workers to ensure we were testing our torque through the correct processes by retraining and working with the lineo Helped implement an automatic torque tester to solve the problem of human error, ensuring a lower impact on defect numbers going forward•Attended meetings and audits ran by P&Go Weekly calls with P&G personnel to help understand any issue or questions about the upcoming weeko Sat in with P&G personnel during an audit after freight accidents to review and learn their problem resolution processo Visited a P&G site to see what processes we needed to work on or could be implemented to ensure that there would be no furthering issues.