Close Close Preview

Your amazing online presence is right this way.

Create your profile
Capture who you are, what you do, and where you're going. All in one place.

Andrew Lorenz

Andrew Lorenz

Business Analyst, Medicare Information Management and Reporting

Capital Blue Cross

Carlisle, PA

Business Analyst at Capital BlueCross

Message
MENU ☰

Capital Blue Cross

Business Analyst, Medicare Information Management and Reporting

- Provides technical and logistical assistance to department managers and acts as a liaison between the Government Programs department and the IT department.
- Creates and implements creative and robust solutions for different business areas using a combination of Microsoft Access, VBA, Crystal Reporting, Data Modeling and SAS.
- Creates and processes reports and data requests from other departments and prepares them in an easy to read format as requested by the customer.

Career medium 02
Career
Career medium 03

Lorenz Technologies

Owner

- Leads technical meetings with both technical and non-technical clients dealing with their IT infrastructure and web design needs in a professional and confidential manner.
- Creates and executes business solutions ranging from IT consultation to website designs individually tailored for each client’s specific needs and goals.

Career

JFC Staffing Companies

Business Analyst

- I’ve held the following positions during my time with JFC Staffing and JFC Global:
--- October 2004 to December 2004: data entry specialist for Center for Schools and Communities.
--- December 2004 to June 2006: Help Desk Professional for Center for Schools and Communities.
--- October 2006 to September 2008: Business Analyst for Capital BlueCross.
- Provided computer help desk support by inbound & outbound telephone calls and emailed issues; issues ranged from password questions to Internet connectivity / networking issues to hardware and software failures.
- Troubleshot and repaired physical computer equipment (printers, routers, computer components) returned from sites.
- Kept detailed and accurate information on daily activities for monthly reporting which was provided to the state and parent company.
- Checked Enrollment and disenrollment requests for 100% accuracy that were received from new and current members.
- Designed, implemented, and maintained a Microsoft Access database which automated the quality control team’s daily activities and reduced the overall paperwork they used on a daily basis.
- Provided technical and logistical assistance to department managers and acted as a liaison between the Government Programs department and the IT department.
- Part of the management team and tasked to create on-demand reporting and database solutions for the Enrollment Unit using Access and Crystal Reports.

Career medium 02
Career
Career medium 05

IntelliMark Associates

Help Desk Professional

- Provided help desk support via the telephone for 38-40 clients in a call center environment.
- Provided technical support to issues ranging from hardware and software problems to network and server outages.
- Logged all contacts with customers into the Remedy tracking system for a written record of what has been done for them.
- Contacted outside vendors when needed to resolve a user’s issue that couldn’t be resolved via the phone.

Career

Penn National Gaming

Customer Service Rep

Customer Service Rep for PNRC's eBetUSA and Telebet.

EDS

Customer Service Rep / Backup Supervisor

CSR and Backup Supervisor in the Valley Green, Pa Call Center

Red Land High School

Diploma, General