Production Support Specialist

Uses MS Excel Pivot Tables to manipulated large data to perform data analysis.
Structure large data sets to find usable information for internal teams and external clients
Builds and maintains reports, dashboards, and creates presentations based on recommendations and findings
Reviews FHA, Conventional, Condo and Small Income Property appraisal reports with efficiency
Works an Appraisal Correction Inbox where escalated and urgent request are sent for prompt review
Completes Appraisal Re-Application process by reviewing appraisal associated with the prior loan number and making sure it confirms to PennyMac guidelines before transferring to the new loan number
Handles appraisal transfers from different lenders by reviewing appraisals making sure it conforms to PennyMac guidelines prior to transfer
Reviews and identifies errors on appraisal reports then sends suggested corrections back to AMC for review
Completes daily underwriting checklist appraisal reviews prior to loan going to funding.

Reviews FHA, Conventional, Condo and Small Income Property appraisal reports with efficiency
Complete reviews of appraisal reports based on a checklist of guidelines needed to meet PennyMac, Fannie/Freddie Mac and FHA requirements
Review up to 150 borrower loans in MERS to confirm if the loans are active or inactive in PennyMac’s system
Completed all tasks promptly and with minimal oversight.
Ensured bailee wire transfer information was accurate and complete
Proficient in Collateral Management System (CMS), Encompass, MERS, WestVM, Fannie and Freddie Look up
Automation of regular reports by using advanced excel formulas like VLOOKUP, pivot tables etc. to bring in efficiency and ensure accuracy of data

Handles all aspects of assigned stations(s) including placing bumped spots, rearranging spots on log in non-competitive slots, assigning cart numbers on production orders, making sure all copies are turned in, adding daily networks to logs, changing computer data when necessary
Manages commercial logs for 7 stations in 2 different markets in the United States (Sussex, NJ and Defiance, Ohio)
Maintains up to $450k in commercial and on-air inventory with less than 1% spoilage monthly
Injects orders and order revisions for multiple markets daily
Use graphs, infographics and other methods to visualize data for the purpose of presenting reports based on recommendations and findings
Established KPIs to measure the effectiveness of the business decisions

Manages flow of information and service inquiries in Salesforce/Viero systems
Coordinates with other departments to maintain commercial inventory and to provide billing information
Resolves problems among Sales, Continuity, Programming, Traffic, and Accounting
Collaborates with management, Account Executives and Sales Support to ensure commercial spots are executed in accordance with contract provision
Enters commercial advertising schedules and maintains database by reviewing and resolving error reports with the goal of optimizing revenue

Review and process options per change orders
Prepare monthly site condition reports for new job starts
Assist with performing plan takeoffs to new and existing communities
Interact with Suppliers/Trade Partners to resolve issues as needed
Interact with Construction Managers to resolve day to day issues
Used MS Access, MS Excel, MS PowerPoint, MS Outlook, MS Visio, MS Word, SharePoint, Pivot Tables, V-LookUps, data warehouse, Support Central and advanced reporting functions to develop and manage data reporting
Prepare quarterly corporate reports in order to obtain the New Plus Rebates
Maintain organization of Suppliers/Trade Partner files and contracts