Experience

APS

• France
• Newspaper Publishing
• 1 - 100 Employee

• Data Analyst

  • Jan 2023 - Present

  King of Prussia, Pennsylvania, United States



Keolis Commuter Services

• United States
• Truck Transportation
• 400 - 500 Employee

• Data Analyst

  • Aug 2022 - Dec 2022

  Boston, Massachusetts, United States Lead data analyst on a project to report on incidents for the Massachusetts commuter rail system. Cleaned and normalized data from the incident report system in order to build data visualizations. Create PowerPoint presentation for the executive team to present to key stakeholders on all crossing failures.



UniFirst Corporation

• United States
• Textile Manufacturing
• 700 & Above Employee

• Data Analyst

  • Jul 2021 - Oct 2022

  Wilmington, Massachusetts, United States Converted twenty-three existing reports from Tableau to SSRS to provide report access to a wider audience. Developed roughly twelve new reports in SSRS and Tableau for a variety of Finance teams to enhance efficiency by providing valuable information. Assisted with transition of laundry business solution software, which included integrating new database tables into existing reports and UAT testing. Integrated new dimension tables to thirty reports which provides consistent customer… Show more Converted twenty-three existing reports from Tableau to SSRS to provide report access to a wider audience. Developed roughly twelve new reports in SSRS and Tableau for a variety of Finance teams to enhance efficiency by providing valuable information. Assisted with transition of laundry business solution software, which included integrating new database tables into existing reports and UAT testing. Integrated new dimension tables to thirty reports which provides consistent customer information between two sets of fact tables. Developed a SharePoint site to store the most recent SQL queries and reports. Show less



Granite Telecommunications

• United States
• Telecommunications
• 700 & Above Employee

• Data Analyst

  • Jul 2019 - Jul 2021

  Created a report in Power BI to identify key customers that were affected by large rate increases which drove sales initiatives to introduce customers to cost saving solutions. Collaborate with the billing team to ensure projected rate changes are in line with monthly invoices and troubleshoot any discrepancies. Audit cost data that is not mapped to revenue data and work to resolve any issues. SQL power user that manages tables for teams within finance by inserting and updating data.… Show more Created a report in Power BI to identify key customers that were affected by large rate increases which drove sales initiatives to introduce customers to cost saving solutions. Collaborate with the billing team to ensure projected rate changes are in line with monthly invoices and troubleshoot any discrepancies. Audit cost data that is not mapped to revenue data and work to resolve any issues. SQL power user that manages tables for teams within finance by inserting and updating data. Pull and assign audits for the line verification team to identify telephone lines that have potentially ported to another carrier. Audit the product pricing team by reviewing rate changes that caused back bills and report if they could have been avoided so that supervisors can use these examples for training.

• Pricing Analyst

  • Feb 2017 - Jul 2019

  Quincy, Massachusetts Reviewed regularly published telecom tariff updates and maintained product pricing information. Assisted sales operations by researching cost and configuration information for complex telecommunication solutions. Developed audits designed to identify discrepancies within our product database. Calculated expected financial impacts on monthly rate changes by running a PowerPivot report that pulled data from SQL and excel and reported those results to management. Trained new… Show more Reviewed regularly published telecom tariff updates and maintained product pricing information. Assisted sales operations by researching cost and configuration information for complex telecommunication solutions. Developed audits designed to identify discrepancies within our product database. Calculated expected financial impacts on monthly rate changes by running a PowerPivot report that pulled data from SQL and excel and reported those results to management. Trained new analysts by teaching Excel, SQL, and Granite’s internal software systems.



PTC

• United States
• Software Development
• 700 & Above Employee

• Customer Operations Representative

  • Jul 2015 - Dec 2016

  Accurately processed software, training and consulting orders and verify that each order adheres to Sarbanes Oxley guidelines. After an acquisition, assisted in the transition of operational processes, including training on revenue recognition guidelines for publicly traded companies. Ran weekly report through salesforce to produce KPIs such as revenue and number of orders booked and for the customer operations team. Ensured customer account information in Salesforce.com and Oracle… Show more Accurately processed software, training and consulting orders and verify that each order adheres to Sarbanes Oxley guidelines. After an acquisition, assisted in the transition of operational processes, including training on revenue recognition guidelines for publicly traded companies. Ran weekly report through salesforce to produce KPIs such as revenue and number of orders booked and for the customer operations team. Ensured customer account information in Salesforce.com and Oracle were consistent. Answered customer calls regarding account or license information. Show less



EMC

• United States
• Biotechnology
• 1 - 100 Employee

• Maintenance Ops Analyst

  • Jul 2012 - Jul 2015

  Franklin MA Built quotes in excel that adhere to revenue recognition standards to ensure accuracy. Updated product configurations in Oracle according to customer account information. Served as a liaison to the renewal sales team, answering inquiries, updating quotes, and resolving customer needs. Created a presentation and led a training class on product configurations for new hires Processed maintenance renewal contracts and verified that each order adheres to revenue recognition… Show more Built quotes in excel that adhere to revenue recognition standards to ensure accuracy. Updated product configurations in Oracle according to customer account information. Served as a liaison to the renewal sales team, answering inquiries, updating quotes, and resolving customer needs. Created a presentation and led a training class on product configurations for new hires Processed maintenance renewal contracts and verified that each order adheres to revenue recognition policies. Collaborated with operations and renewal sales team to resolve service contracts issues. Maintained data integrity by updating service contracts when upgrades are purchased. Show less



Roche Brothers Supermarkets

• Meat Clerk

  • Jun 2009 - Aug 2012

  West Roxbury



Abt Associates

• United States
• Research Services
• 700 & Above Employee

• Temporary Research Assistant

  • Apr 2012 - Jun 2012

  Cambridge, MA