TECHNICAL SKILLS:

• Word, Excel, PowerPoint, Access
• Teradata Business Objects, QuickBooks AS400
• Windows XP, Windows 7, Office 2007/2010, Siebel
• Salesforce, Avaya Phone System, Kronos, Connect Plus

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Data Analyst/ DBA

Responsibilities:

• Created customized financial reports for large scale customers
• Maintained client databases for shortfalls and performance tracking
• Mass data imports into database systems
• Created matrices of monthly employee productivity and distributed the report to Senior Management
• Provided ad hoc report preparation assistance
• Identified and corrected Telco tariff and contract billing inaccuracies
• Provided direction as well as advice on corporate customer contractual agreements
• Trained new employees on system usage and work process and audited their reports
• Read, interpreted and provided an outline of contractual agreement and possible inconsistencies
• Managed inbound Outlook account for Contract Revenue Compliance unit
• Reviewed, interpreted and relayed unclear contractual clauses as relating to customer liabilities
• Reviewed accounts for valid or expired contracts and corrected the rates accordingly
• Tracked, compiled and proactively submitted performance reports to external departments
• Used object oriented software to modify, run, compose and prepare detailed reports that are used to validate and confirm customers’ contractual agreements
• Process and apply billing of validated customer shortfalls
• Managed the monthly web based Usage report of itemizing 12,000+ customer attainment accounts
• Utilized ECATS, multiple databases and Excel Pivots to complete weekly as well as monthly production as well as financial reports
• Provided assistance to the team to balance workload, when necessary.
• Drafted procedural documents and SOPs and made updates when processes changed
• Modified, deleted and created new records to database systems

Confidential, Justice, IL

Office Assistant

Responsibilities:

• Assisted clients with loss reports (auto and/or home);
• Implemented policy changes and with all other insurance based needs
• Identified past due accounts and pursued collection actions
• End of day bank reconciliation/deposits of payments in Office Manager’s absence
• Provided insurance quotes to existing and potential customers for various products offered by company

Confidential, Skokie, IL

Office Manager

Responsibilities:

• Monitored large projects for cost control/budget targets
• Compiled, computed and tracked commission payments for California based salesmen
• Purchased, tracked and maintained inventory via Timberline software program
• Tracked and recorded payments and investigated billing shortages
• Billed customer if deemed appropriate after researching data
• Utilized database system to create, update and maintain files
• Remotely managed offices located in California