KENNETH GRAY
ad382r@r.postjobfree.com
PROFESSIONAL SUMMARY:
Pricing and Marketing professional with Power BI experience. Experienced working with datasets. Core strengths include leveraging historical data, market intelligence and competitor insights to create customized financial reporting and analyses to businesses across multiple industries.
PROFESSIONAL EXPERIENCE:
Kingspan Insulation, N.A. -- Senior Financial Analyst 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
Robert Half International – Project Consultant Oct, 2022 – Feb, 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 – Project Consultant Aug, 2021 – Aug, 2022
Pricing Revenue Compliance, SOX Internal Controls – PayPal Corporation
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.
Documented policies, process flows & helped to develop new procedures to minimize errors
Experis Consultants – Project Consultant 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 Sales Operations
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 writing & redlining for legal compliance
Ad hoc Financial Reporting, Deal analysis, Comparative customer analyses
Robert Half International – Project Consultant Sep, 2014 – Oct, 2016
Strategic Pricing, E-commerce – The Home Depot
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.
Back-end Data Quality Maintenance & Cleanup (Scaling Factors, data integrity). Strong understand of pricing recommendation data dump to correct data quality errors.
NCR Corporation Sep, 2013 – May, 2014
Sr. Financial / Pricing Analyst
Creation of RFP/RFQ Pricing proposals for Competitive bids to new & existing customers
Worked closely with Solutions Architects, Sales teams, and Finance to secure deal approval.
Constructed Sales P&Ls for major bids, RFPs in US & Canada Retail Services markets.
Served as key business partner providing pricing recommendations to Sales leaders.
Provided financial analyses on historical bid trends, strategic pricing, margin / price erosion.
CSM Bakery Products Jan, 2009 – Sep, 2013
Pricing, Sales Finance, Supply Chain Finance – Tucker, GA
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 / Cost Accounting team on activity-based costing model.
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
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 – 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.