SUMMARY:

• Proven background, streamlining daily or time consuming tasks, using MS Excel or MS Access based VBA (macros) to create automated, fully customized, parameter driven reports.
• Accomplished in creating tools in Excel and Access that build on and improve current team processes.
• Extensive experience in creating visually pleasing and functionally sound report user interfaces as well as implementing user interface improvements to fulfill the changing needs of the team.
• Proficient with Visual Basic for Applications (VBA) and advanced Excel worksheet functions.
• Excellent communication, analytical, and problem solving skills.

TECHNICAL SKILLS:

Applications: MS Excel, MS Access, Crystal Reports, GIMP, Prophet 21, Qlikview, Splunk, Tableau

Languages: VBA, SQL

Databases: Access, MS SQL Server

PROFESSIONAL EXPERIENCE:

Confidential, Triangle Park, NC

REPORT DEVELOPER

• Created ad - hoc reports and automated existing scheduled reports with the use of VBA, ActiveX controls, conditional formatting, pivot tables, and advanced Excel workbook functions.
• Created and maintained Splunk dashboards, utilized by company leadership.
• Created dashboards in Tableau, utilizing Excel workbooks as the main data source.
• Queried CUCM database with the use of SQL to pull detailed call information.
• Utilized Qlikview to collect and aggregate report data from multiple data sources / formats.
• Responsible for the creation and distribution of daily, weekly and monthly capacity reports.

Confidential, LLC

REPORT DEVELOPER / INVENTORY CONTROL ANALYST

• Created interactive Access databases and automated Excel reports aimed at increasing team productivity and efficiency.
• Package Replenishment Application (Automated Excel Report)
• Designed and created a central purchasing application in Excel for the companies 10 warehouses, with the use of VBA, ActiveX controls, and conditional formatting.
• Application is used daily by inventory analysts to build orders that meet the requirements of Exxon Mobil's ordering system (Pegmost) and for all non Mobil purchases.
• Has become an important resource in reaching the company's goals of lower average inventory value, decreased customer backorders, and higher inventory turns.
• The report utilized SQL to query the company's ERP system for real time data, was parameter driven, equipped with interactive user forms, and was updated with one button click.
• Custom Stock Database (Access Database)
• Designed and created a database that tracked customer custom stock agreements, agreements that assured a customer a certain level of stock on hand at all times.
• Provided users with the ability to enter, store, retrieve signed copies, and update customer agreements. Also provided on demand reports, outlining the status of each agreement including order history and sunset date.
• Made it possible to easily track customers with signed agreements and to collect payments for agreements that expired with product still stored in inventory.
• Responsible for maintaining appropriate inventory levels in order to increase inventory turns, keep customer backorders at a minimum, and decrease average inventory value.
• Researched and reconciled weekly warehouse counts for the companies 10 warehouse locations.
• Lead training sessions covering new team processes and applications.
• Served as lead inventory analyst during company audits.

Confidential

Website Creator / Desktop Publisher

• Created all business documentation including brochures, business cards, fliers, and member contracts.
• Created and maintained business website
• Set up all business email on location and for home office.
• Responsible for all site updates, including image editing.

Confidential, Cary, NC

PROJECT ACCOUNTANT

• Posted project manager’s daily progress quantities into accounting system, allowing for accurate monthly generation of customer invoices.
• Issued monthly customer invoices based on billable completed work.
• Held monthly project cost meetings with project managers and prepared reports detailing changes in individual project estimated costs.
• Prepared monthly journal entries.
• Automated accounting reports in Excel with the use of macros, increasing team efficiency.

Confidential, Wilmington, NC

ACCOUNTING SUPERVISOR

• Supervised the International Division's A/R, A/P, and inventory departments.
• Prepared monthly journal entries and income statements.
• Issued monthly income statements for the China joint-venture to track this endeavor’s progress.
• Served as A/R, A/P and Inventory control for company Further Processing Division.
• Worked with the sales manager to ensure proper valuation of product when determining commissions.
• Created a database that tracked daily inventory production and plant PO’s for sales department.
• Developed and maintained a database that tracked customer credit limits and outstanding balances.
• Allocated inventory to customer orders to ensure product was not oversold or stored pass expiry date.
• Reconciled differences between warehouse receipts and quantities invoiced from plant, correcting records when necessary and informing the plant of required corrections.
• Trained inventory and accounts receivable associates and interviewed potential employees.

Confidential, Wilmington, NC

INVENTORY SPECIALIST

• Created an inventory monitoring system in Excel to track 5 million to 20 million pounds of product.
• Developed macros in Excel to automate the processing of data in inventory monitoring system.
• Reconciled weekly inventory and researched any inconsistencies that may have existed.
• Worked with warehouses to ensure that any inconsistencies in inventory reports were corrected.
• Created reports that provided the sales department with weekly pricing data based on inventory value.
• Inputted inventory receipts, shipments, and adjustments into company accounting system, Protean.
• Traveled to China to convey the company’s accounting methods to our counterparts in China and to obtain an understanding of Chinese accounting practices.