Statistical Analyst Resume
LOG IN OR REGISTER TO CONTACT ME
This button will open the login/register page in a new tab. After logging in, come back to this page and refresh your browser.
Resume:
Lisa-Gay Johnson
Lincoln St. Apt • Oak Park, Michigan • Home: • Cell: •
SKILLS:
Microsoft Office Master Certified Microsoft Office Specialist – Certified Expert in Excel and Word, as well as Core level certification in Access, PowerPoint and Outlook.
Perform database queries for daily, weekly, monthly and Ad-hoc reporting requirements.
Exported reports from the billing system into Excel to perform detailed analysis on subscriber data.
Analyzed data to determine if trouble calls were due to poor installations and initiate charge back to contractors.
Created Excel macros to improve efficiency, simplify management reporting and enable users to complete more detailed subscriber analyses.
Processed Commissions for Customer Service and Telemarketing representatives.
Managed the billing system for Michigan’s largest single-franchise communications.
Responsible for all facets of system support, including creation of User profiles, setup of new rate codes and billing parameters, as well as management of the Quota Maintenance system.
Promoted to Operations Trainer after seven months in the Customer Service Department. Trained Customer Service, Repair, Check-In and Dispatch Representative on the CableData system.
Eleven years experience facilitating corporate training.
Developed first comprehensive new hire Customer Service company training manual.
Developed first comprehensive Collections company training manual.
Developed handouts to introduce new software releases and billing procedures.
Seven years experience maintaining the Siemens telephone system by performing moves, adds and changes, ACD routing, Call Processing and trunk routing.
Established PhoneMail for employees, providing training as needed.
Maintained a database of telecommunications lines and equipment.
Worked closely with various department management staff regarding their requests for soft skills training and implemented ongoing programs for veteran staff..
Worked with carriers to order new service and to resolve service related or repair issues.
Analyzed and audited vendor invoices to verify appropriateness of amounts billed.
Resolved invoicing discrepancies, including past due amounts and overcharges with the finance and accounts payables area.
Instrumental in the development of the Employers Comp Advocate database.
Developed the training manual for the Employers Comp Advocate database.
Perform statistical analysis for the Detroit Public Schools Office of Risk Management.
Responsible for check generation for the Workers’ Compensation unit of the Detroit Public Schools.
Process voids, stop payment, refund and reimbursement requests for the Workers’ Compensation Unit of the Detroit Public Schools.
Perform monthly check reconciliation of the Workers’ Compensation account and the Trust statement.
Developed the training manual for the Check Module of the Detroit Public Schools Claims Management system.
Maintained a database of Workers’ Compensation claims of the Detroit Public Schools.
Creating Excel macros to enhance reports generated through the Detroit Public Schools Claims Management system.
Maintained a database of Workers’ Compensation claims for various clients of Employers Comp Advocate.
EXPERIENCE:
Independent Contractor, Detroit Public Schools Office of Risk Management, Detroit, MI / - Present
Long Insurance Services, Client: Detroit Public Schools Office of Risk Management, Detroit, MI /-/
Employers Comp Advocate, Primary Client: Detroit Public Schools Office of Risk Management, Troy, MI /-/
Snelling Personnel, Madison Heights, Primary Client: Detroit Public Schools Office of Risk Management, MI /-/ (temp-to-hire)
Comcast Cablevision, Detroit, MI /-/
Michigan State University, East Lansing MI, /-/
EDUCATION:
Graduate, Michigan State University, East Lansing. Degree: Telecommunication
