Experience

Potpourri Group

• United States
• Retail
• 100 - 200 Employee

• Director Business Analysis

  • Jun 2021 - Present

• Manager Business Analysis

  • Dec 2014 - Jun 2021

  N Billerica, MA My job entails working with analysts and senior management to provide ad-hoc and automated reporting using MS Access, Microsoft Excel, MS SQL Server (2005/2008 R2/2012), SSIS, VBScript, PuTTY [pscp], and VBA. I also train and delegate work to business analysts in my group to provide these reports throughout PGI. At my time at PGI I have coded the business logic for a forecasting and purchase ordering program (AIM - MS SQL Server 2005), a merchandise reporting tool used to plan out future… Show more My job entails working with analysts and senior management to provide ad-hoc and automated reporting using MS Access, Microsoft Excel, MS SQL Server (2005/2008 R2/2012), SSIS, VBScript, PuTTY [pscp], and VBA. I also train and delegate work to business analysts in my group to provide these reports throughout PGI. At my time at PGI I have coded the business logic for a forecasting and purchase ordering program (AIM - MS SQL Server 2005), a merchandise reporting tool used to plan out future catalog seasons as well as historical performance and trends (KNOWLEDGE4 - MS SQL Server 2008 R2/MS Access 2014/SSIS/VBA), created a data flow for transferring order/shipping/inquiry/invoice/FTC/return data to a 3rd party for email contact with customers (SSIS/MS SQL Server 2008 R2/VBScript/Windows CMD/ PuTTY [pscp]).

• Sr Business Analyst

  • Jan 2013 - Dec 2014

  N. Billerica

• Database Analyst

  • Jan 2011 - Jan 2013

  N. Billerica My roles include the development and design of database strategies, monitoring and improving database performance and capacity, and planning for future expansion requirements. I also help develop and implement a forecasting system to purchase items from Vendors anywhere from a month to 6 months prior to our sale of these items to our Customers whether it is from one of our catalogs or one of our websites.



Highland Liquors

• Assistant Manager and Cashier

  • May 2008 - Jan 2011

  Train new employees, open store, and manage and replenish inventory.



C&S Wholesale Grocers

• United States
• Wholesale
• 700 & Above Employee

• PL/SQL Developer Intern

  • May 2010 - Aug 2010

  I tested and optimized T-SQL queries for an in-house forecasting system.



NH Department for Juvenile Justice Services

• Data Quality Analyst Intern

  • Jan 2010 - May 2010

  I am building and implementing a data mart to extract cleaned data from an old legacy system that the Data Quality Analysts currently use. This will cut down their query time from hours to minutes or even seconds. I am also creating hundreds of set queries for them to use for common data requests that my bosses are asked to provied.



Naswa Resort

• Barback/Beach Maintenance

  • May 2004 - Aug 2007