We provide IT Staff Augmentation Services!

Data Analyst/ Dba Resume

Chicago, IL

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

Hire Now