Chris DiTroia

Experience

• 

  LUZERNE COUNTY TRANSPORTATION AUTHORITY

  Jan 2014 - Jun 2014

  IT Specialist

  * Provided assistance to the IT Director. * Built computer system for customer service, enabling acceptance of credit card sales* Assisted in the development and maintenance of website project, making ADA compliant* Participated on RFID project team to enhance employees’ security* Project managed the tracking of buses and routes through GPS. Installed new routes and stops in AVL software system. Project met deadline on time and within budget.* Responsible for troubleshooting computer issues and training employees on software Show less

• 

  Mondelēz International

  Jun 2014 - Jul 2018

  * Building and automating revenue reports for improved operating efficiency* Querying Microsoft Server using Structured Query Language and creates workflows in Alteryx * Analyzing and maintaining large volumes of data* Developing ad-hoc reports as needed by stakeholders * Working closely with executive leadership team to provide financial, incentive, waste/forecasting * Developing and presenting project updates to leadership and key stakeholders* Assimilating junior analysts into team* Creating standard operating procedures on customized reports* Special International Project, transferring work from US to India Show less * Led Edge system rollout for Canada* Provided hyper care for the new users including Customer Category Managers (CCM), District Managers and users in the field* Taught users’ proper ways to use the system* Fixed technical issues* Worked with Four Box to help keep projects on target. Met all task deadlines within area of responsibility* Created “how to” training decks and conducted team training workshops for new Edge Team members, aiding in their on boarding process while cutting training man hours by 50%* Automated manual processes using VBA programming to improve efficiencies in job functions for Edge Associates * Provided technical Edge system assistance to key stakeholders and peers * Subject matter expert within the software* Utilized SAP daily for setting up new users and stores * Built HTML code and embedded links for ‘theSource’* Formatted and loaded weekly reports into the Edge system for Customer Category Managers to view Show less * Achieved a high level of proficiency with “Stay in Front” program * Continuously improved job efficiency and streamlined Edge daily tasks by building programs in Visual Basic attached to Excel sheets. These automated the following:* Building Authorization lists & Assets* Constructing Shelf codes* Creating Messages using store lists* Successfully communicated with Key Account Managers to ensure their requests were completed in a professional and timely manner as well as solved their technical problems and acted as the intermediary between them and the Information Systems Team. Show less

  • Business Reporting Analyst

    Apr 2017 - Jul 2018

  • International Edge Specialist

    Jun 2015 - Apr 2017

  • Edge Support Associate USA

    Jun 2014 - Jun 2015
• 

  Luzerne County Community College

  Sept 2014 - Dec 2017

  Adjunct professor teaching the Microsoft Office Suite

  * Instructed students on Microsoft Excel, Microsoft Word, Microsoft Power Point, Microsoft Access* Created assignments to enhance student understanding of Office applications* Worked in MyItlab (Pearson)

• 

  PNC Business Banking

  Jul 2018 - now

  Business Analytics and Reporting

  *Using SQL, creates procedures that allows the Vault team to find data on vendors *Partners with the AML team, building and publishing High-Risk Customer Reports*Consults with stakeholders from various functional groups to determine the best method for collecting and disseminating required data for business needs*Provides SharePoint site management oversite for team dashboards and cash services control testing *Appropriately manages time commitments to handle multiple initiatives with competing priorities, consistently beating SLA on deliverables*Within two months of joining team, proactively automated reports to reduce man hours from a 2-hour process to a 20-minute process Show less