Experience

• 

  Tessco Technologies

  • Pricing & Market Volatility Analyst

• 

  Tessco Technologies

  • Hunt Valley, Maryland, United States

  • Pricing & Market Volatility Analyst

    • Sep 2018 - Present
    • Hunt Valley, Maryland, United States

    • Research & articulate actionable data reporting solutions for various KPIs specific to market & customer• Investigate market conditions & sensitivity in relevance to target-marketed campaign & product initiatives• Analyze data trends within the marketplace to quantify both opportunity & volatility• Examine customer performance YOY/QOQ – (i.e. assigned/unassigned, drop-off & growth accounts)• Apply raw data into an automated & actionable format via VBA to invoke sales leads & opportunities- Measure relevant metrics to analyze market as well as customer productivity & profitability- Identify key regional segmentation of product sales by brand & hierarchical categorization - Target potential contingencies for growth on a regional, categorical, brand, & sku baseline• Monitor/Adjust pricing algorithms & outputs based on historical data, market sensitivity, & competition• Review the pricing model ~3 months to gauge any shortcomings/weaknesses as the market fluctuates• Create & deploy sales/product manager end user tools to make real time pricing API calls via VBA• Build & present executive reporting within both Einstein Analytics in Salesforce as well as Tableau• Architect dynamic interfaces to manage large sets of data to report on company efficiency & profitability• Consult on large integration projects such as open source database creation & ERD architecture• Train Mid-Level & Junior Analysts on numerous internal technology packages specific to criteria & role – (i.e. Google Analytics, Tableau, Einstein Analytics, SQL, and Visual Basic for Applications)

• 

  Stoli® Group

  • Baltimore, Maryland

  • Operations Analyst

    • Aug 2016 - Sep 2018
    • Baltimore, Maryland

    • Lead Analyst & Executive Reporting Architect concerning market segment analysis & sales projections• Integrated historical financials from numerous acquisitions into SGUSA’s ERP on an SAP platform• Created custom reports via SQL in SAP to implement more efficient reporting specific to parameters• Designed macro-based reports via Excel VBA to automate & translate raw data into useful business metrics• Conducted cost-benefit analysis reporting to identify viable substitutes to operational & logistical costs• Managed $60M+ in Mkt/LPF budgets on Stoli’s P&L across 12 brands under the SGUSA umbrella• Primary analyst in providing audit samples to KPMG, PWC, & Wells Fargo adhering to GAAP parameters• Worked closely with contracted marketing entities to ensure specific SOW requirements were being met/executed such as signed-off agreements, proof of service, and program duration

• 

  ConnectYourCare

  • Hunt Valley, Maryland

  • Associate Analyst

    • Jul 2014 - Aug 2016
    • Hunt Valley, Maryland

    • Analyzed and translated client financials into actionable business metrics via SQL on an Oracle platform• Deployed operational controls/security parameters through scheduled SQL routines on an Oracle platform• Communicated directly with Fortune 500 clients concerning weekly/monthly reporting of financial assets• Part of a special team that reconciled over $700,000 in revolving line of credit discrepancies and applied funds to the appropriate claims/accounts through First Data Corporation & Bank of New York Mellon