Special Data Forms Developer Resume Profile Spartanburg SC - Hire IT People

CAREER PROFILE

Advanced Excel skills - formulas, macros, pivot tables. Excellent at data mining and cleaning up databases. Working knowledge of VBA and SQL. Experienced user of Access, Word, PowerPoint. Crystal Reports coursework completed.
Strong office administrative background: Merchandising Asst, Legal Admin, Admin Asst, Cust Service Rep, Materials Planner.
Innovative report/form developer: designed an automated sales order form and timecard template which greatly increased process efficiency. Created and established process for duty refund project.
Research/analytical experience: researched/analyzed Grocery market trends. Forecast promotional product needs. Reconciled vendor billing discrepancies.
Professional presentation skills: Bachelors Degree in Graphic Art, broad spectrum of computer graphic capabilities.
Organizational skills: managed 22 vendor accounts. Responsible for establishing and maintaining records system for promotions, contracts, business plans, and all other communications.

WORK HISTORY

Confidential

Special Data Forms Developer

Increased efficiency and automation through creation of single sales order form generated from on-line multi-tab order catalog. Utilized advanced Excel formulas, macros, VBA. Automated sales order upload to Quickbooks.
Designed Excel timecard template which automated tabulation of employee hours. Process required compliance with Paxton Net2 timesheet application.

Confidential

Special Projects Developer

Developed process for import/export duty refund project for tool distribution company.
Researched, designed, implemented the process, and documented for future execution. Finished report required to meet auditing standards. Incorporated advanced Excel formulas. Collaborated with Controller and Duty Refund lawyer.

Confidential

Merchandising Assistant

Handled 22 vendor accounts for Enhancers and Specialty Desks.
Using DemandTech, reviewed and verified contract integrity. Resolved issues relating to contract compliance.
Reviewed Weekly Close Access report to guarantee invoice integrity. Researched and resolved discrepancies. Converted results to Excel spreadsheet for record keeping.
Based on the Weekly Close, tracked Specialty Desk discontinued product using Vlookup. Presented results in Excel report to Accounting for invoice purposes.
Proofread weekly ads to ensure accuracy of pricepoint, size, artwork. Consulted with vendor regarding questions on promotional material.
Performed extensive data entry into Access of all promotions.
Ran queries in EDW Microstrategy to extract scan data trends to aid in formulation of business plans. Created Excel reports to present results to manager and vendor.
Analyzed sales trends according to Access data reports to determine allocation needs and to assign top-selling product to store end cap displays.
Responsible for recording new and discontinued items on Excel spreadsheet. Included verifying decreasing scan activity and checking on inventory amounts of pending discontinued products.

Confidential

Project Assistant

Processed Provider Website registrations. Instructed Providers as to the benefits of the program and resolved issues of fallout cases.
Developed and maintained Excel tracking spreadsheets.

Confidential

Legal Assistant , Admin. Assistant - Legal Dept., Internet Communication Service Dept., Communication

Performed routine Administrative tasks.
Designed Org charts and flow charts in Visio. Edited PowerPoint presentations.
Proofread legal documents, transcribed legal letters, composed legal correspondences, tracked lawsuits.

Confidential

Customer Service Representative

Handled agent change requests. Verified by phone integrity of applications.
Evaluated and implemented improvements that increased higher success rate of data verification.
our Guide in historical home for five summers - Dukes County Historical Society, Martha's Vineyard MA.