College Help – Personal Lines
United States Liability Insurance (USLI) is an A++ rated company that is a member of the Berkshire Hathaway family. USLI specializes in writing low premium, low hazard specialty insurance products. USLI’s main campus is located in Wayne, PA and employs 1,135 people with over 100 college interns. The specific team that I work for is Personal Lines Underwriting. My role as a College Help student was to assist in analyzing monthly and yearly trends for different regions, states, and products. I mainly worked with large Excel files by filtering out data and creating pivot tables as well as adding customers into our system.
One of the specific projects that I worked on involved sorting through data for our recent insurance claims and dwellings and created pivot tables to summarize the information that can be presented to senior leaders. In each spreadsheet, I created numerous tabs that summarized the action taken, the location, the specifics of the claim, and several other characteristics. Another project I completed was with the IT team in order to complete service requests. This was a daily, as-needed task when a contact from a customer needed to be added, deleted, or edited in our contact system. I went into USLI’s intranet and requested that a new user’s login information to be accessed. This allowed the users to be given read/write access.
As far as relating my internship experience to my classes at Temple, I applied things I learned from a couple classes, more specifically Data Analytics and Enterprise IT Architecture. Similar to Data Analytics, I had to analyze data and learn how to present insights from business data. This was present when I had to sort through large data sets and apply data visualization to present it in a way that generates business intelligence. I also applied the skills I learned in Enterprise IT Architecture when adding and removing contacts into the company system. I learned about the process that USLI goes through for their computer systems change requests as well as the different roles and responsibilities that can be assigned to new users. Exploring these technologies and business models relates back to what I learned in IT Architecture.