Nicholas Campanale

Experience

• 

  Daifuku North America

  May 2015 - Aug 2015

  Software Implementation Intern

  Working on site, along side computer engineers to test WMS (Warehouse Management) software, Graphical representations of the Distribution Center, and provide on site software support for the client.

• 

  Granite Telecommunications

  May 2016 - Aug 2016

  BroadBand Cost and Savings Analyst Intern

  Worked alongside the Premier Billing department to validate locations in order to provide accurate assessments of what products are available to the client.After validation, A cost estimation based on what products are available is created to support the sales team.

• 

  Kronos Incorporated

  Jan 2017 - Jan 2019

  Business System Analyst

  Working directly with leadership through all stages of the data life cycle to automate existing processes and build the next generation of reports using BI tools, SQL, and Alteryx.Whitespace Automation – Using a mix of Internal customer data and Duns and Bradstreet data to validate employee count and industry. I was able to estimate the total number of product licenses remaining to be sold if 1 license per employee was achieved. Incorporating cost per license by module the remaining contract value was calculated.Sales Rep quota predictor – Leveraging Historical Sales data, I calculated average time to close by opportunity stage, and average win rate. Using these two figures and the remaining time in the current sales period. I was able to forecast the number of Closed Won deals, Dollars, and quota attainment with a high degree of accuracy. Legend Makers Program – Using Alteryx to combine activity and sales data, a single source of truth by employee was built. This data was then used during employee performance reviews and was critical to the Legend Makers Program. The Legend Makers Program provided presales representatives with significant financial incentive to overachieve on their quotas. The Subsequent dataset from this automated Alteryx report was imported into tableau. Providing a weekly in-depth analysis of employee performance to all managers and directors of presales. Show less

• 

  Kraft Analytics Group

  Aug 2018 - Jan 2019

  Business Analyst

  High producing analyst, meeting the demands of an agile environment while helping train team members to boost overall team efficiency.• Worked in a fast paced Start up environment meeting strict client deadlines. • Performed QA testing in an agile development environment.• Collaborated with members of the Data engineering team to aid database efficiency and eliminate redundancies.• Drafted BRDs and QA plans ensuring all deliverables met user acceptance criteria. • Leveraged SQL to execute QA plans and validate data feeding Tableau Dashboards. Show less

• 

  UKG

  Jan 2019 - Mar 2022

  Serving as an in-house IT / automation specialist. Aiding in the automation and Optimization of numerous finance processes cross functionally. Salesforce CPQ Implementation – My commitment to excellence and the team during this project was recognized at the highest level of Finance, resulting in my attainment of a Finance Excellence Spot award. My work performing QA and UAT testing to ensure all required functionalities are working as specified in the BRD during the implementation of the new CPQ solution. As bugs or inaccurate data was found, I would work cross functionally to translate the business needs and issues into actionable IT tickets. UKG Bookings – During the merger of Kronos and the Ultimate Software group, leveraging my database and Alteryx skills I provided a solution to executives that consolidated booked deals. This workflow would combine deals booked on legacy K and Legacy U paper, providing UKG with its first look into how the newly formed company was performing. The workflow was built adaptively to accommodate the needs of a quickly changing finance department.Install Base Automation – Performing a complete process overhaul the time savings resulted in the highest award possible in Finance, a CFO Award. This deliverable used to take an individual a week to build manually. I leveraged my knowledge of Alteryx to produce the consolidated report in 30 minutes, merging the Customer database with the product contract database. The final deliverable was used company wide as a single source of truth for customer data, Software, License counts, and contract values. Accompanying the data set I built a series of Power Bi reports to facilitate efficient self-serve access company wide. Show less

  • Data Aanlyst

    Sept 2021 - Mar 2022

  • Financial Analyst

    Jan 2019 - Sept 2021
• 

  Credit One Bank

  Jul 2022 - Feb 2023

  Product Analyst

  Through the development of a new marketing reporting suite, a budget increase of 20% was won for the marketing team.Wander Rewards Points Tracking – While learning SAS, I developed a query to track and validate all accrued and redeemed wander reward points. The query collected, classified, and calculated points for all transactions associated wander card customers. Facilitating Product analysis and tracking of: Product total spend, Total Accrued points, Total Redeemed points, and Top earned / redeemed by category. Marketing Efficiency report – Working closely with Credit One’s external marketing partner (TRG) to obtain marketing performance raw data for all channels. Using SAS for ETL to create a single source of truth containing executive level metrics. Prior to this internal report, existing marketing data was scattered and held externally by TRG. By developing this report in house, the bank was able to visualize marketing efficiency and subsequently increase their marketing budget by 20% for fiscal 23. The development of this report had me nominated for the C1B One to watch award.Professional Partnership rating tool – This was an Ad-Hoc analysis. The question from executives was why is one professional partnership better than another? After Identifying key variables and testing for statistical significance. A scale was created to score each variable using their Z score value. The Cumulative score for each of the variables was then used by the marketing team and executives alike to assess the potential partnership opportunity. Show less

• 

  UKG

  Feb 2023 - Aug 2023

  Senior Service Operations Analyst

  Partnering with the Director and Project Managers to Support the Manufacturing and Public Sector Delivery teams.Automation and standardization of Bi-Weekly and Monthly Deliverables – Rebuilt existing deliverables in excel for all eight team members, resulting in a unified approach to performance across all verticals and reducing time needed from 4 hours on average to 1 hour per team member.Presenting Bi-weekly and Monthly team performance – Showcasing KPIs to Director level leaders. Noting overall team performance trends and forecasts. Accompanied with deep dives for individual teams calling out both goal adherence and areas of concern.Held Monthly 1-1s with Project Managers – During these meetings I would go over KPIs, Project health, and overall data quality. Setting all managers up for success, ensuring they had the most up to date and accurate data available. Show less

• 

  Caesars Entertainment

  May 2024 - now

  Hospitality and Charter Analyst