Summary
Overview
Work History
Education
Skills
Advanced Microsoft Excel Office Skills
Core Administrative Skills
Timeline
Generic

Bill B. Wilken

New Baden,IL

Summary

Administrative leader with extensive experience in optimizing business operations and financial processes. Adept at developing advanced Excel systems that streamline workflows and enhance accuracy. Committed to maintaining high standards of confidentiality and fostering positive vendor and customer relationships.

Overview

16
16
years of professional experience

Work History

Owner / Operations Manager

Southern Backroad, Inc.
New Baden, IL
02.2018 - Current

· Manage the day-to-day administrative and operational functions of a small business, with responsibility for financial administration, customer service, purchasing, inventory, payroll, invoicing, records, and business processes.

· Managed Net-30 accounts and processed weekly and bi-weekly payroll, ensuring timely payments.

· Prepare and process invoices while maintaining accurate financial and business records.

· Develop and maintain customized Excel workbooks for business operations, inventory, purchasing, payroll, invoicing, and financial calculations.

· Developed complex formulas to streamline data processing in Excel., logical systems, and automated processes to improve accuracy and reduce manual work.

· Identified operational problems and developed technology-based solutions, enhancing overall efficiency.

· Coordinated customer and vendor communications to foster strong professional relationships.

· Handle confidential and sensitive business information with discretion and accuracy.

Professional Pharmaceutical Driver

Southern
Belleville, Illinois
07.2010 - 04.2020

· Provided professional transportation and customer service while maintaining accurate documentation and strict compliance with company procedures.

· Safely transported pharmaceutical products and other high-value and sensitive materials.

· Maintained a high level of accuracy and attention to detail when handling sensitive products and documentation.

· Followed established procedures and compliance requirements consistently.

· Used handheld PDA/mobile technology to complete transactions, record information, and meet corporate compliance requirements.

· Communicated professionally with customers, receiving locations, and company personnel.

· Oversaw daily responsibilities independently, consistently meeting schedules and service requirements.

Education

Associate Degree - Accounting

Kaskaskia College
Centralia, IL
12-2014

Skills

  • Financial administration
  • Payroll management
  • Business operations
  • Inventory management
  • Vendor coordination
  • Advanced Microsoft Excel
  • Spreadsheet development
  • Data analysis
  • Process improvement
  • Documentation compliance
  • Records management
  • Information handling
  • Time management
  • Customer service

Advanced Microsoft Excel Office Skills

  • Advanced Microsoft Excel experience involving spreadsheet development, data organization, calculations, tracking systems, and process improvement.
  • Proficient with VLOOKUP, XLOOKUP, INDEX/MATCH, IF/IFS, SUMIF/SUMIFS, PivotTables, conditional formatting, and other advanced formulas and functions.
  • Develop customized Excel workbooks for inventory tracking, purchasing, invoicing, payroll, financial calculations, and business operations.
  • Create complex formulas, logical systems, calculations, and data relationships.
  • Experienced with specialized copy/paste techniques and data manipulation for organizing and transforming information.
  • Experienced with Excel worksheet and workbook protection, password protection, and security features.
  • Develop spreadsheet systems designed to reduce manual calculations and improve accuracy, consistency, and efficiency.
  • Strong working knowledge of Microsoft Office and computer-based business applications.

Core Administrative Skills

  • Administrative & Business Operations
  • Data Entry & Records Management
  • Accounting & Financial Administration
  • Payroll Administration
  • Invoicing & Accounts Receivable
  • Customer Service & Communication
  • Purchasing & Vendor Coordination
  • Inventory Management & Tracking
  • Microsoft Excel — Advanced
  • Microsoft Office
  • Spreadsheet Development
  • Data Organization & Analysis
  • Process Improvement
  • Documentation & Compliance
  • Handling Sensitive Information
  • Independent Work & Time Management
  • PDA / Computer-Based Business Systems

Timeline

Owner / Operations Manager

Southern Backroad, Inc.
02.2018 - Current

Professional Pharmaceutical Driver

Southern
07.2010 - 04.2020

Associate Degree - Accounting

Kaskaskia College
Bill B. Wilken