Data Analyst/ Dba Resume
3.00/5 (Submit Your Rating)
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