Data Administrator

THOMAS

PETERS

818-***-****

*****.*.******@*****.***

linkedin.com/in/tp3

• Database Administration

• High Excel proficiency with large data sets

• SQL Queries and Subqueries

• Data format conversion

• Sales Reporting and Analytics

• E-commerce project management

• E-commerce data onboarding

• Search Engine Optimization

• Retail Financial Management

• Purchase/Sales Order Tracking

• Microsoft Office Suite / IOS

• Inventory & Consignment Accounting

• POS SDLC/updates/upgrades

• EOM / EOFY Reporting

• Crystal Reports administration

• Amazon Vendor & Seller Central

• Mobile POS solutions

• POS Hardware/Software Installation

• POS Technology Administration

• Constant Contact email marketing

• Remote Access Software

• IT Operational trainer

• Vendor Management

EXPERIENCE

Customer Experience Specialist Riboli Family Wines 2020 – PRESENT

• Implementation of MICROS Point of Sale (POS) system o Hardware, Software installation and training

o Report, monitor, resolve and retest software components o Inventory database management – Yellow Dog database software

• Oversee and host private VIP tastings and tours

IT Systems Administrator Cathedral of Our Lady of the Angels 2002 – 2021

Operational Management:

• Building and managing multi sales channel order processes

• Receiving, Sales, Orders, Inventory Reporting (End of Month, Fiscal Year, and ad hoc)

• Delivered sales and inventory analysis

• Oversaw accounts payable for retail operation

• Developed daily retail operational financial procedures

SKILLS

• Vendor account management-reconciliations, invoice analysis, etc

• Streamlined consignment account reconciliation

• Trained managers and cashiers in software and operational procedures

• Supervised retail receiving and fulfillment logistics IT Project Management:

• Spearheaded proposals for upgrades to retail software and website

• Coordinated and directed the software development life cycle (SDLC) for software upgrade project involving a complete data conversion from Microsoft SQL to an Oracle SQL based retail database

• Oversaw development of a new Magento (open source content management) platform retail website o Replaced a website of roughly 400 items with new website went live with over 10,000 items o Analyzed, installed, updated plugins for UI, shipping rates, & product pages o Manipulation and onboarding of large data sets of skus from vendors to new site

• Optimized website experience and increased conversion rates using Google Analytics

• Initiated SDLC for implementation of a software bridge between retail software and e-commerce to reflect live inventory levels

• Directed yearly physical inventories of over 25,000 SKUs

• Coordinated high traffic, remote retail events. Handled all mobile point of sale solutions and logistics. Utilized the latest technology to capture sales most efficiently (tablets, mobile software solutions, and remote access software)

Technology Management:

• Modified software and document designs for efficient daily operation

• Clarified and restructured database in both Excel and Oracle databases

• Crystal Reports - report creation and modification

• Delivered cost/pricing analysis for website and store

• Expedited regular accounting & consignment audits (monthly, yearly, and special events)

• Administration of the store’s Windows 2008 server, virtual server, network stations

• Expedited regular software, hardware, and data maintenance to ensure smooth daily operation EDUCATION

B.S.B.A - Management University of Denver

Minor : Leadership

Database MicroBachelors Program Certificate New York University - edX SQL Database Courses (DBMS1, 2, 3)

• Intro to Database Queries

• Advanced Database Queries

• Advanced Database Administration

WSET 2 Certification WSET

Wine and Spirit Education Trust Level 2 in Wine

Contact this candidate