Financial Analyst Reporting
Resume:
KENNETH GRAY
**********@*****.***
PROFESSIONAL SUMMARY:
Pricing professional with over fifteen years of deal pricing and proposals experience to include working with medium to large datasets, data visualization and Salesforce.com. Core strengths include leveraging historical pricing and market data, standard costs, and terms of service for pricing quotes & contract negotiations.
PROFESSIONAL EXPERIENCE:
Kingspan Insulation, N.A. -- Senior Financial Analyst - Atlanta Aug, 2023 – Oct, 2023
Prepared, analyzed and translated company data into comprehensive reports via Power BI
Provided finance support for Sales Team to include ad hoc analyses, reporting & visualizations
Participated in Month end close tasks and procedures
Special Projects included consignment inventory reconciliation for major big box customer
Project Consulting Sep, 2014 – Feb, 2023
Robert Half International – Finance Professional (Remote) 2022 – 2023
Financial Analysis, Revenue Cycle Management with emphasis on revenue reporting
Customer Usage reporting, partnered with billing teams to ensure billing/pricing accuracy
Financial reporting, data cleansing, KPI Reporting and Review
Daily calls with Senior Management, Sales and A/R teams
RGP – Pricing Analyst, SOX Internal Controls – PayPal Inc. (Remote) Aug, 2021 – Aug, 2022
Developed a strong understanding of pricing structures and processes for financial services
Conducted reviews of pricing to execute SOX Internal Controls over Financial Reporting (ICFR).
Ad-hoc reporting of E-Commerce transaction revenue, including data analysis & cleanup
Developed & executed manual & semi-automated SOX controls to ensure pricing compliance.
Review pricing for contract compliance, analyze processes to assess & mitigate key business risks
Experis Consultants – Atlanta, Georgia Mar, 2020 – May, 2020
Marketing Analyst – Global Freight Forwarding – UPS Supply Chain Solutions
Assisted Ocean Pricing Team in collection and analysis of competitor and market data
Analyzed rate/routing options for cost efficient price quotes
Collaborated with Sales, Operations and Trade Lane groups to ensure timely and accurate requests for proposals in Ocean Pricing, Rail and Trucking services globally.
Rangam Consultants – Project Consultant Jan, 2017 – May, 2019
Contract Marketing, Strategic Pricing – Abbott Labs, Inc., Atlanta, Georgia
Utilized Pricing Data Model to determine Revenue and Profit margin potential.
Creation of RFP/RFQ Pricing proposals and contract writing for competitive bids.
Provided Deal Pricing and Business Intelligence analytics for 6 regional sales teams.
Pricing strategy, contract negotiation, redlining terms & conditions for legal, business risk mitigation
Ad hoc Financial Reporting, Deal analysis, Comparative customer analyses
Robert Half Management Resources Sep, 2014 – Oct, 2016
Strategic Pricing, E-commerce – The Home Depot Corp HQ, Atlanta, Georgia
Implementation of Strategic Pricing rules for Online/ E-Commerce business portfolio.
SQL a key part of working with large data sets to monitor historical pricing trends.
Added or Modified pricing rule configurations (Competitor, Line Structure, Initial Markup rules) in pricing engine according to changing market demands. Developed Pricing Strategies.
Discussed competitive challenges and the impacts of changing market dynamics.
Data Quality Maintenance & Cleanup Strong understand of pricing data dumps
NCR Corporation Sep, 2013 – May, 2014
Sr. Financial / Pricing Analyst, Deal desk, Atlanta, Georgia
Creation of RFP/RFQ Pricing proposals for Competitive bids to new & existing customer contracts
Worked closely with Solutions Architects, Sales teams to negotiate pricing & vendor costs for new deals.
Constructed Sales P&Ls for major bids, RFPs in US & Canada Retail Services markets.
Served as key business partner with emphasis on assessing and mitigating business risks.
Provided financial analyses on historical bid trends, strategic pricing, margin / price erosion.
CSM Bakery Products Jan, 2009 – Sep, 2013
Costing Analyst, Supply Chain Finance, Tucker, Georgia (2012 – 2013)
Assisted Supply Chain Bakery & Ingredients plant teams with reporting and month-end.
Updated Raw Material, Packaging and Conversion costs in OLX
Assisted Costing team with ad hoc cost analysis efforts & special projects as needed,
CSM Senior Financial Analyst – Team Lead (2010 – 2012)
As a Lead (Senior) Analyst was responsible for hiring, training & development of analysts
Provided financial & margin analysis support to Senior Management, and 3 Sales VPs
Managed Customer P&Ls to include Business and Margin analysis for $400+ Million portfolio
Finance Support for 3 Lines of Business: (Food Service, Distribution & Industrial, Starbucks)
CSM Deal Pricing Analyst (2009 – 2010)
Created RFP/RFQ pricing & deal proposals for competitive bids
Determined pricing for new and existing products utilizing pre-established margin guidelines
Worked with Supply Chain team & Procurement to negotiate vendor pricing & vendor management
EDUCATION:
Georgia State University – Master of International Business, Finance Minor
Georgia State University – Bachelor of Arts, French
TECHNICAL SUMMARY:
DBMS: Oracle, Teradata, SQL Server Management Studio
Financial Reporting Tools: SAP, IBM Cognos Analytics, Salesforce.
Data Visualization, Business Intelligence Tools: Power BI (Beginner / Intermediate)
Excel: Pivot Tables, Formulas, Power Query, Power Pivot, Data Modeling.
Key Accomplishments:
The Home Depot – Piloted and Launched a semi-automated process that expedited the time from deep-dive analytics to final pricing changes to thousands of stores in multiple markets nationwide for product categories totaling $2B in Sales (Lumber, Metal Products, Salt).Wrote SQL code to extract and merge data from various data sources to recommend pricing strategies based on historical trends, local market conditions, real-time competitor pricing data and consumer price sensitivity/ price-elasticity scores by market.
Paypal Inc. – Managed SOX Internal Controls reporting requirements within pricing organization for Paypal, Zettle, and Braintree businesses operating in US, European Union, Brazil and Mexico. Responsible for reviewing billions in domestic and cross-border banking & financial services transactions for merchants globally to ensure financial reporting and pricing accuracy. Also responsible for process review & oversight and error reporting of financial / banking transactions.
Contact this candidate