Customer Service Representative – Data Control Coordinator

LOCATION:

Hagerstown MD – Hybrid, 8 days a month in the office

OVERVIEW Our Customer Service Representatives (Data Control Coordinators) are the 'keepers' of all data and are vital to the success of the business. In this role, you would effectively provide internal users and external customers with timely and accurate business information and analysis and assist in the ongoing operational maintenance of the fulfillment system, in the form of system interpretation, table set-ups, microsites, onboarding new publications, reports, mailing documents, invoices, audited publications, renewals, promotions, and other various data output.

This role requires advanced technical expertise with Advantage, SQL, file manipulation, and the Microsoft Office Suite.

• Coordinate all aspects of the cycle end distribution process for all periodical products from scheduling through electronic transfer of distribution files, ensuring timeliness and accuracy of the process.
• Coordinate periodical class postal audits with USPS and Periodical Operations.

• Maintain the periodical renewal process, including but not limited to, monitoring pull schedules, setting up system select criteria, scheduling and generating auto-renewal process, creating specialized renewal efforts, and interfacing with renewal vendor for receipt of output and resolution of rejects.

• Coordinate and monitor the automated upload of periodical subscription orders. This includes subscription agent electronic files, pharmaceutically sponsored subscriptions, and society membership accounts.

• Facilitate all aspects of the data transfer of new or discontinued titles.
• Coordinate system set up, reconciliation of financial reports and upload of new subscription records.
• Generate transfer files and provide new publisher file layout and table definitions.
• Ensure complete closure of all system issues regarding discontinued titles.

• Coordinate online access for subscribers not maintained on our existing fulfillment system, such as, end users of bulk or freight forwarded subscription orders, member lists maintained by the society, and Sponsored subscriptions.

• Coordinate and monitor the automated upload of product sales information, (Plymbridge, Australia, EDS) and product orders including EDI from wholesale / retail customers.

• Oversee salesmen and convention processing including salesmen inventory, convention order processing, returns processing, and ancillary warehouse maintenance.
• Coordination and reconciliation of annual physical inventory for the ancillary warehouses.
• There are approximately 30 salesmen warehouse accounts and 150 convention warehouse accounts which must be reconciled on an annual basis.

• Support and maintain the set up and updates for all microsites (discounted product packages created by ed sales reps specific to each school/university) in the Advantage Fulfillment System to allow order/sales for this special product offers.
• Maintaining a 95% or higher service level by answering all requests for set ups and/or updates within 24 business hours.

• Assist finance and warehouse with inventory maintenance on the fulfillment system. This includes, but is not limited to, processing donations and destruction orders, upload of inventory adjustments and coordination of physical inventory in our main warehouse.
• Assist finance and the warehouse with the reconciliation of inventory between three systems, the fulfillment system, the accounting system, and the warehouse management system.

• Maintain up to date knowledge of all operational aspects of the fulfillment system, including maintenance and update of all system driven tables and codes that govern the running of the business.
• Set up and maintain promotion code data and interface with marketing department and customer service to ensure timely and accurate system handling of mail plans and sample pieces. There are hundreds of mail plans per year, which equate to several hundred promotion codes.

• In conjunction with I.S. and other business units, coordinate the testing and implementation of upgrades or modifications to the current fulfillment system.
• Support and generate system batch processes to facilitate update to customer records, such as Mass Cancellation, Auto Renewals, Inventory Uploads, etc.

• Verify and reconcile the nightly edit reports, which monitor the posting processes of circulation orders, product orders, inventory, and accounts receivable.

• Run and analyze user defined reports from the fulfillment system; set up and run mail lists and file extracts, providing accurate and timely information to the user community.
• Complete file comparisons utilizing various software packages and report to the…