Jessica Cable Email & Phone Number

Mason, OH

• Revolutionized reporting capabilities by working with SmartSearch to obtain access to the data tables via Microsoft Access and SQL Server allowing management to go from a few basic stock reports to having the ability.
• SQL Server - Retrieved Raw Data with SQL Server then created finished reports in Excel utilizing Microsoft Access and VBA code allowing management to gauge the effectiveness of business tools available.
• Report Writer – Working closely with the SmartSearch Report Writer expert, learned and mastered Report Writer to create polished reports that can be executed by the end user with a user-defined date range or programed.

Developed a user friendly Access Database to track Private Label Product Development and Special Promotions. Created easy to use User Interface for easy data entry and report exports.

Mason, OH

• Primarily responsible for updating the Sunglass Hut weekly, monthly, quarterly and annual retail sales reports that are utilized locally and internationally, by pulling data from Business Objects, SAP and RPAS. Assist.
• Product Development Database - Utilized VBA to mine data from various MS Excel reports then loaded it into MS Access, designed a GUI interface to allow users to easily maintain the records then export finished reports.
• Picture Database - Located and loaded pictures for most active skus for four different eyewear businesses into a central folder then created a lookup in MS Excel that will list the available pictures by brand and paste.

Accurately completed daily Quality Assurance reports then sent them to correct ABX and DHL executives. Utilized Visual Basic macros in MS Excel and VB Script in AS400 to automated existing reports; cutting the production of the reports by hours. Assisted in the process of designing and completing reports to monitor the implementation of the new shipment.

Mason, OH

• Responsible for updating, automating and maintaining company’s customer database of defaulted auto-loan contracts utilizing Microsoft Access. Created user-friendly report formats and report selection screens for fellow.
• Recovery Letters - initializes form letter to customers that have been charged-off due to nonpayment;
• ECC Database - used to contact new customers before their first payment is due;
• Credit Bureau Database - used to view the trade line sent to the credit bureau for each customer;
• Allotment and Draft Database - tracking system for Bank Draft and Military Allotment Authorizations sent to company’s financial institution. Also issues commission credit to the collecting employee. Also responsible.

Cincinnati, OH

Primarily responsible for documenting lease-end telephone equipment returns and generating reports of new inventory available for sales and accounting departments. This includes detailed reports of physical inventory and general condition of equipment and updating inventory program to produce serialized stocking labels. Responsible for fully documenting.

Cincinnati, OH

Responsible for accurately entering and filing data for telephone equipment as it is received. Promptly completing the Daily Activity Report, and then resolving any problems that arise, was hired permanent at CBS Technologies in May 2003.

Dayton, OH

Responsible for printing reports and forms, such as pre-numbered checks, fee bills and quarterly two-part mailers, utilizing Unix Easy Spooler. Graded student Scantron tests and printed necessary reports for professors. Created user-friendly Back-Up Tape database utilizing MS Access, and a System Down-Time Log with MS Excel. Created detailed documentation.

Associate Degree, Computer Information Systems

Education record