Data Integration Intern at AMPEL WINE CO. DISTRIBUTION

AMPEL WINE CO. DISTRIBUTION:

Ampel Wine is a local Distributor of Wine, Spirits, and Sake in the Philadelphia area. We work together with wholesalers throughout the country to position our portfolio with key restaurants and retailers. The wineries and distilleries we represent are carefully chosen not only for the quality but also for their people and passion for wine and spirit making. We are always searching for new products that are authentic and interesting, and that express their distinct regions.

My role:

Data Integration Intern

What I learned

1. WordPress
2. Excel
3. Quickbooks
4. ETL(Extract, Transform and Load)

What I did

1. Conducted product and transaction data analysis and reconciliation to facilitate data-driven decision making for a local distributor of wine and spirits.
2. Integrated accurate product data into PA Liquor Control Board system.
3. Contributed to company profit goals attainment by recommending optimum product prices through extensive price and market data analysis.
4. Standardized client and product data to match the QuickBooks system in order to track SKU inventory.
5. Edited company’s website by using WordPress.