Professional Experience

7/08-7/11 Analyst-Billing Support Austin, TX
Confidential,

• Responsible for auditing disconnection of services under a term for contract termination compliance, also responsible for auditing expired contracts for compliance of re-rate policies based on tariff regulations and individual case basis contracts.
• Prepare new data for new-month audit.
• Responsible for ensuring accuracy of data reported to the month-end process including consolidation of all audited data for department reporting.
• Generate month-end team metrics for upper management for the Southwest region using MS Excel and various AT&T systems.
• Responsible for identifying and explaining anomalies on month-end reports.
• Responsible for interpreting quarterly reports to explain why certain items appeared on a bill, including debits and credits.
• Responsible for preparing a quarterly bill versus paid report that identified the percentage of early termination fees that were paid by customers.
• Train new analysts and employees in methods and procedures
• Trained West region team on month-end reporting process.
• Respond to internal requests to facilitate customer contract termination issues via email and phone in limited time frame.
• Calculated early termination fees based on audit non-compliance determination.
• Researched, interpreted and prepared reference sheets based on Tariff policies for each product in each state.
• Managed project that converted early termination fee request system from MS Excel/MS Outlook to MS Access/MS Outlook.

12/07 – 5/08 Analyst Austin, TX
Confidential,

• Generated daily “Block CMR Report” using SAP, report used to locate accrual accounts in SAP.
• Processed rebate claims (issued credit and debit memos) for corporate customer accounts letters A-G, customers included Apple, Asustek, Acer, and more. Claim amounts ranged from $500.00 to $5,000,000.00.
• Processed billing errors (issued credit and debit memos) for corporate customer accounts letters A-G, customers included Apple, Asustek, Acer, and more. Billing error amounts ranged from $10.00 to $500,000.00.
• Updated accrual accounts once per week in SAP for chipset customers.
• Processed international wire payments for rebate claims.

6/07- 11/07 Confidential,

• Generated daily reports that determined if specific projects were generating profit using MS Excel.
• Generated hourly and daily status reports of the progress of specific projects for external customers using MS Excel & MS Access.
• Tracked and summed the daily hours of each employee for each specific ongoing project using MS Excel.
• Managed incoming and outgoing vehicles for specific projects using MS Excel and MS Access.
• Generated summary reports and project specific estimates for completed projects.
• Created weekly report evaluating the profitability of the Vehicle Services Department.
• Consulted with customers on specific project progress.

10/98-5/01 Analyst,Confidential, MI

• Evaluated the economic impact of conventions & visitors to metropolitan Detroit.
• Coordinated and tracked overall performance of DMCVB.
• Administrator for CVBreeze database. Developed month end, quarterly and year-end convention sales reporting system using Microsoft Excel and Crystal Reports.
• Developed various ad-hoc reports and queries.
• Trained new database users.

7/97-10/98 Confidential, MI

• Coordinated telemarketing blitzes.
• Processed leads, new, tentative, and repeat business bookings.
• Developed convention sales department month end and quarterly reports.
• Analyzed various convention sales department statistics.
• Member database conversion team.
• Key operator of database.

2/96-7/97Confidential,MI

• Developed potential accounts in sports market.
• Coordinated telemarketing blitzes.
• Evaluated leads, and Coordinated new, tentative, and repeat business bookings.

7/95-1/96 Confidential,MI

• Managed and promoted the 1995 NFL Air-IT-Out 4 on4 flag football tournament.
• Coordinated the 1995 DirecTV Great Eight College Basketball Festival Coaches Luncheon.
• Marketed sponsorship packages for 1995 DirecTV Great Eight College Basketball Festival.
• Coordinated and promoted of the 1995 Kmart Motor City Roundball Classic High School Basketball Tournament.
• Marketed sponsorship packages for the 1996 Senior Softball World Series.
• Coordinated the daily operations of the office, including bookkeeping.

9/94-9/95 Confidential,MI

• Assisted with associate membership fundraising campaign. Assisted with the daily operations of the office.

10/93-5/94 Confidential, MI

• Provided guidance and support for student athletes

Education

• Masters in Business Administration (MBA) Management Information Systems

Computer Experience Crystal Reports, SPSS, MS Access, Excel (Macro, Pivot Table, V-Look-Up), Outlook, PowerPoint, Word, Bureau 2000, Destination 3000, CVBreeze, SAP, CLSST-Sport, CLSSC-Boss, Cris Billing System, Cabs Billing System, DocViewer, ECATS, Web Toolbar, Net Meeting

Professional Courses FraklinCovey Writing Advantage Seminar,
FraklinCovey Presentation Advantage Seminar

Honors Outstanding Performance Award Detroit Metro Convention & Visitors Bureau 10/96

Activities Literacy Volunteers of America (2002-2004)