-
Essay / Report on my internship in banking
Table of contentsIntroductionJob descriptionDaily tasks, tasks and responsibilitiesSkills I used during the internshipChallenges during the internshipTips for future Isqs internsWorks citedIntroductionThroughout the summer semester 2019, I I had the opportunity to receive an Internship in Management Information System in one of the various well-known companies in Vietnam. The association I connected to is HongLeong Bank Vietnam (HLBVN). “The bank is technology-driven and focuses on developing financial capabilities to serve its customers in Singapore, Hong Kong, Vietnam, Cambodia and China. Hong Leong Bank Berhad is listed on Bursa Malaysia Berhad and is part of the Hong Leong Group. Headquartered in Kuala Lumpur, the bank has a strong Malaysian entrepreneurial heritage (HLB About Us). At first I didn't seem interested in the financial sector, but my internship somehow changed my thinking about banks and their work. It started from July 1 and continued until mid-August. However, in a short time, I learned a few things about the banking industry, met interesting people and experts, and acquired various technical skills, which will be covered in this internship reflection paper. Say no to plagiarism. Get a tailor-made essay on “Why Violent Video Games Should Not Be Banned”?Get the original essayJob DescriptionMy jobs and duties as a Management Information System Intern at HongLeong Bank were that of an assistant to help my supervisor take care of daily reports. I also had to process all the supporting documents associated with the sales division. For example, expense report forms, administrative tasks, market research, broker commissions, etc. Working hours will be 8:00 a.m. to 5:00 p.m. Monday to Friday (including 1 hour lunch). During my internship period, I was usually busier in the morning than in the afternoon, as most of the report has to be sent before noon.Daily Tasks, Duties and ResponsibilitiesDuring the first week in Hong Leong, I I mainly learned from my partner how to generate regular reports regarding bank sales and the company's work process. I became familiar with the SQL programming system used by the Bank. Later in the first week, I began completing and submitting daily reports, such as daily deposits, daily loans, and sales activity. These reports constituted my work routine at the start of the day to give the sales department their regular updates. The first task I had to complete was the “Daily Deposit” and “Daily Loan” reports. These reports expected me to download the financial data of disbursements and priority banking customers from the previous day. I also needed to run the existing SQL code to get the previous day's data and copy and paste the numbers we got into a quotation Excel record for all divisions. It usually took me about 30 minutes to complete these two reports. The second task I expected to complete was the “Daily Sales Performance” report. The report required me to run SQL code to find the average balance and used an updated Excel record from the boss that I received each morning. I also had to check if the report was correct by comparing the data with the “Daily Deposit” and “Daily Loan” reports. If the data is correct, I can quickly send it to direct sales and relationship management. If the datawere not accurate, I had to recognize the problems and report them to the manager to find a solution. Another task I had to complete was the “Broker Commission” report. The report required me to update it every time I received a commission form from a broker in the sales division. This report must be made and sent to the financial department twice a month for payment. In this report, I had to grab the financial data from SQL and copy and paste it into the existing Excel file. Then I had to look up the name of each broker client I received and update it in a financial sheet in Excel. The report took approximately 30-40 minutes depending on the number of broker forms received. In addition to producing reports, I also helped my team translate banking policies or guidelines from Vietnamese to English or from English to Vietnamese and helped create market research for banking rates . The task was to research the savings or deposit rates of other banks in the state and out of state, as well as the different administrations charged within a bank. Apart from that, I had tasks from the Finance and Direct Sales division. Often these divisions ask my manager for a transaction overview in a selected region of Vietnam to cross-check with their data. For example, direct sales needed to know how many new customers they had gained and their remaining funds spent throughout the month. I expected to create an Excel file responding to all their requests. But before starting my task, the manager often showed me what the finished work should look like and where to get the necessary data for the request. These advance reports regularly took me around 45 minutes and required manager approval before being submitted. Additionally, I also helped my manager create a PowerPoint for a training program called "Customer Onboarding Process" and helped create a new monthly sales recognition certificate using Adobe Photoshop.Skills I I used during the internshipNext, in this internship reflection, I will mention the skills useful during my internship. I found that ISQS 2340 and ISQS 3348 helped me a lot during my internship at HongLeong Bank. Through Introduction to Information Technology (ISQS 2340), I learned many Microsoft skills by obtaining the MOS Excel certificate and creating an Access database and its relationships between tables. I also learned by creating a presentation for a company and practicing Pixlr Editor or Adobe Photoshop for images. By taking the Database Management System course (ISQS 3348), I learned to design relational databases using Entity-Relationship (ER) models. Then, develop SQL allowing you to manipulate relational databases and their data. During my internship, I used Excel on a daily basis. This experience helped me work faster and learn different types of commands at work. The other programming I learned was SQL, and most of our financial data was copied from that. I think the knowledge I gained from the Database Management System course was helpful. Since it gave me a fundamental understanding of what the code is about and where its data comes from. Overall, I think my knowledge of the banking framework has improved significantly. Particularly in the Priority Banking office, I learned many things about monetary standards and cash flow management methods within the Bank. Thanks to this experience, my time management skillsalso improved a lot because of all the commitments I had to meet on time. Since I haven't taken many major courses in ISQS, but with all the upper division courses I would say the entire program has helped me a lot in the business. For example, Accounting 2301 gave me a general idea of how to get a credit and debit for each transaction. These essential skills came in handy when I was asked to compare raw data to net cash inflows from Direct Sales' official deposit account. Then I also learned how to write a memorandum and routine message through Business Communication 3373 course. Often I was asked to write a routine message for the group learning exercise meeting or write a memorandum requesting money to obtain vouchers for a customer survey.Challenges During InternshipIn this internship reflection essay, I will discuss the challenges I faced. One of the challenges for me was to adapt to the new condition and adapt to the associates. From the beginning, I was afraid that I wouldn't get used to working regularly with something very similar, but I understood that it was not exhausting, far from it, by any stretch of the imagination. This was a challenge for me because I only had a short internship time to learn, so I was hoping to do more than just manual labor, but I discovered that repetitive work could make you feel empowered. safety when writing reports. Often the financial data I got or the data I ran from SQL was not correct, and distinguishing which part was not correct from that raw data was a satisfying moment for me. Likewise, I was afraid that my associates would treat me differently since I was the youngest in my division and that I would not learn various things with such a short internship, unlike the other understudies I met at the Bank . Fortunately, everyone on the team was lovely to me, especially my manager, she was extremely attentive to me. She showed me loads of things and included loads of engagements from various offices as my task to learn. Things I liked/disliked/surprised about the internship I was surprised to see how welcoming the head of each department is towards the intern. They regularly planned to have lunch with us and give us accommodating advice in professional life. One thing I didn't like about the internship was the slow performance of the PC when updating files. This often led to the problem of losing unsaved data and required more time to redo the work. Likewise, I discovered that I wanted to work in the finance division because I was excited about the work they do. I think starting a career in the financial sector was a wise choice for me. But I would also prefer not to devote my entire youth to working in the banking field and try myself in various companies and positions. Advice for future Isqs interns The internship program is a great opportunity for students to improve themselves and better understand where they stand. I want to be after graduation. I think it would be easier if students could get an internship and apply for a full-time job after completing their internship. Nowadays, most organizations follow these approaches to reserve training time when hiring new workers. I would encourage other interns to join applied organizations in various companies and positions relevant to your specialization e.g. hotels, telecommunications, real estate, organizations.