Jessica Cable Email & Phone Number

Maineville, Oh, Us

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 to get any in depth reporting they may need or want. • 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 with a preset time period then scheduled to automatically run and email as Excel. This gave the end user freedom to obtain what specific data they need when they need it for analyzation.Created SmartSearch accounts for newly hired Recruiters and Salesforce, then provided them with CareerBuilder and Monster accounts. Provided Tech Support to users with the SmartSearch Database and general computer issues.

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 the Planning Department with Sales Plan comparisons to Reproject Forecasts for upcoming months. Automated multiple reports utilizing MS Access, MS Excel and VBA to increase accuracy and decrease production time. Participate in testing of the new Business Objects Universe before being released Globally. Assisted other departments by creating easy to use interfaces to get various data, including: • 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 in MS Excel. Packaged the Database so it could be shipped then utilized in corresponding dept in Australia.• 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 the requested pictures into MS Excel.

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 tracking process.

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 collection support staff, created MS Excel templates and Visual Basic macros to track collector production. including payments and phone calls, and supported management and staff with training, use, and troubleshooting of the company databases. Created multiple user-friendly databases, utilizing MS Access, including:• 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 for ensuring the credit bureau file is sent to all three major bureaus accurately and promptly every month.

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 all returns via digital technology with hard copy backups. Created new templates and redesigned existing forms utilizing MS Excel, MS Access, and Visual Basic macros for easier data analysis on daily, weekly and monthly reports. Also trained employees on using these new programs.

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 for database.

Associate Degree, Computer Information Systems

Education record