Production Analyst, Revenue Assurance

YPONE PUBLISHING

(acquired by Yellowbook USA | Hibu)
 

SEP 2006 – MAR 2007 | Sugar Land, TX

Streamlined workflow; created process documentation; improved reporting procedures; saved $10,000s in consulting costs, time and resources. Promoted after only four months with the company.

  • Created and analyzed robust, intelligible and relevant reports utilizing MS Excel with SQL/ODBC queries, including complex array formulas, pivot tables, add-in functions, and macros for automation. Optimized and maintained MS Access databases.
     
  • Aggregated data, produced reports and prepared presentations on Advertising Competitor Leads, Sales Commissions and Kickers, Financial Performance and Trade Trends Analysis.
     
  • Analyzed and improved internal processes; created workflow charts, business operations guidelines and policy documentation on Trade, Leads Processing, and Client Care Operations.
     
  • Processed credit card and bank draft transactions (ACH/PAD). Provided ad hoc software support and training in DIAD and various Microsoft Office Suite products to associates.
TOOLS: DIAD by Polylogics (Integrated Directory Publishing System), Great Plains with FRx Reporting (MS Dynamics GP), Microsoft Office Suite (Access, Excel with MySQL Query, PowerPoint, Outlook with Forms Creation, Word), Nuance PDF Pro, Photoshop, J-Term Pro and Procomm Plus (Telnet clients / DIAD portal)
 

View Recommendations