Customer Login


Set your Country:

Project Team Summary:


Consultant ID: 1598


Availability: In stock


* Required Fields


Work Experience:
Private Company, Merchandise Pricing Analyst
Accomplishments: -Manage pricing strategy for the 40 top selling product categories for the entire chain of Pep Boys stores
-Analyze skus to find the best items for margin opportunities; Using a combination of historical data (queried with SQL) for trend analysis and R to find correlations for different brands or product quality levels
-Responsible for management of entire price test life cycle: from determining which skus to test pricing, selecting test vs control stores, performing the post-mortem analysis, presenting to directors, and adjusting tests based on the results. Successful tests are rolled-out nationwide
-Calculate break-even quanitites for directors when they're considering price decreases; Additonally, inform te directors when total QOH is sufficient to meet break-even quanitites or whether further inventory investment would be necessary
-Ad-Hoc analysis to find root cause of large margin, sales, or discount variances
-Analyze time-series to determine best time to address pricing for specific categories, i.e use seasonal fluctuations to price products adequately
-Manage markdown process for discontinued and non-performing products
-Analyze scrap values to determine pricing for stores scheduled to close operations
-Perform cost analysis for product directors
-Create Pricing PowerPoint deck to explain to directors the current pricing strategy, positioning, and tests being performed on a product category basis
-Maintain MAP pricing in order to fulfill vendor MAP compliance
-Teach colleagues how to perform break-even analysis or find product and price correlation when doing pricing analysis for their assigned product categories

Bloomberg LP, Jr. Financial Analyst
Accomplishments: -Manage team of 4-5 Analyst to complete projects assigned by upper management
-Delegate project workload to analyst
-Track analyst progress to ensure deliverables are ready by the planned due date
-Train analysts on the current project to help them navigate the Terminal efficiently
-Assist analyst with research to keep deliverables on schedule
-Create Excel workbooks to help reduce processing time of data
-Utilize Bloomberg Terminal to navigate public compmany filings
-Analyze financial filings to find relevant company info
-Upload relevant financials to the Bloomberg Terminal

Companies/Brands Worked on:
Pep Boys
Bloomberg LP

BA, Economics, Rutgers University, Honors: Deans List 2012, 2013

Special Skills:
Skilled with Excel, SQL, R, PowerPoint, Word, data analysis, statistical analysis, deriving insights from data