# BQ
**Would you like to introduce yourself in 2 mins？**
基本信息(比如名字), Background（比如专业），your passion，擅长的技术，简单介绍最重要的一个实习经历
* Hello! My name is Lexi. Currently, I'm pursuing my Master's in Computer and Information Science at Cornell University.
* My tech journey started from Physics, especially when I played around with a microcontroller. That got me hooked on programming.
* I later decided to pursue degrees in related majors, which opened my eyes to the whole tech industry. During the past few months, I was interning at Famulei.us as a backend engineer where I've built APIs for their e-commerce platform using Java and Spring Boot and integrated various AWS services. I also introduced a ChatGPT-based Chatbot for them. Prior to this role, I was at Apexus Tech, where I helped shift some features from monolithic to a microservice setup.
* Based on my these experience, I am quite confident that I can fit into the team at your company and start to contribute my value quickly.
**Why Question?**
**Why Company?** + **Why Position?**
Research - 五个fact, align your experience。
**Why Location?**
除了New York 和 Houston的都不准备了。
# **Oracle HR Info Call**
**why company**
- (Oracle 很牛逼) Oracle is the game changer! Oracle was the pioneer to show that you can make money from software alone, without bundling it with hardware. So it's like Oracle **pave the way for morden software business model**. I really respect and admire the innovation spirit of your company.
- (我很喜欢Java) Besides, I am a huge fan of Java, for me, Java is both rigorous and elegant. It would be super cool and amazing if I got the chance to work in the parent company of my favorite programming language.
- (经验能align上) Apart from those, my tech stack is mainly Java-based. Plus, I also have exprience in data analytics and cloud computing, I feel that what I have been doing is quite similar to what Oracle is offering and I think being in a place that aligns with muy skills and passion would foster mutual growth.
**Role Preference** 考虑职业规划，技能和经验。
* Software Engineer Intern - Global Industry Unit
* I am very passionate about Cloud Computing. I trained an text abstract NLP model on GCP, the Google Cloud Platform, by which I was captivated by the transformative power of cloud computing. It is revolutionizing industries and I believed that the industry specific cloud applications is an important trend.
* Therefore, I think joining a cloud computing team and contributing to the cloud business solution would be an exciting opportunity for me.
* Software Engineer Intern - NetSuite
* Apart from software development, I've also been interested in data management and how it can drive key business decision from my undergrad studies. I think the NetSuite department is the intersection of data analysis and software development, feeling like the perfect opportunity to satisfy both my interests. Being able to help business streamline their data-driven operations through software development would be a dream come true for me.
**Last Internship/ most favorite project / walk me through a project**
* Internship 介绍版本
* My internship at Famulei.us was an meaningful journey into backend development in the E-Commerce space.
* My primary role was crafting RESTful APIs for using Java and Spring Boot and integrating them with various AWS services. I was mainly focusing on user management aspect.
* I also took a dive into optimizing our system, including transiting our user authentication from stateful to statless, and speeding up our SQL query. The response of our system became much faster and snappy. Who likes to wait, right?
* **One of the coolest thing I did was introducing a ChatGPT-based chatbot. I proposed it because at the Early 2023, the notion of ChatGPT was heat and I found the task of human customer service was repeated. This chatbot can handle the Q&A task of customer service which allows a dramatic cut of our cost. (The number given by our financial department is $180,000 per year.)**
* Last but not least, I collaborated with DevOps team as well, where I followed the whole CICD process and gained valuable experience in DevOps.
* Proud Project：
* 流程改一下，我先自己做一个demo --> 我老板非常感兴趣但还是有点hesitant --> 我的manager
* At Famulei.us, I had the opportunity to work on several interesting projects, but the one that stands out the most is the ChatGPT-based chatbot I proposed and implemented.
* At the early 2023, the notion of GPT was super heat and I found that our customer service department was facing a lot of repetitive queries. Therefore, I think a chatbot might be a good solution.
* Therefore, I made a demo and proposed it to my manager, he was quite interested in this. But he was still a little bit hesitant because our team made a chatbot before but that one was rigid and he worried that our customer would not buy it. To address this, my manager consulted the marketing department. Afterward, our team collaborated with the marketing team and they conducted an A/B test and the results were satisfactory. My idea was received and I was given a green light to further explore and refine the concept.
* (具体的实现) Then, we designed the architecture, trained the model by FQA data. collborated with other department for testing, and built the feedback loop. After launching our chatbot, it handled over 80% customer queries and save costs for our company.
* This project is my favorite one because I introduced my innovation to my team through my effort, and together with the team, we explored new territories and overcame many challenges together.
* ~~When I first propsed this idea to my manager, he was a bit hesitant and shared that they had tried it out before, but faced some roadblock. He told me that that not only the costs were a concern, but also the previous chatbot was rigid and he worried that our customer would not buy it.~~
* ~~Understanding his concerns, I turned to my colleages in our marketing team and demonstrated my wish of collaboration. Therefore, they ran an corresponding AB test and turn out we got overwhelming positive feedbacks. Meanwhile, I delved deeper into the capabilities of GPT4. From my research, it was clear that the GPT-4s performance was a cut above the test.~~
* ~~With the AB test results and my research report, I presented our findings to my manager. I explained how ChatGPT could not only be cost-effective solution but also enhanced the user experience. Then my manger gave this project the green light and we launched this project.~~
* ~~This project is my favorite because I introduced my innovation to my team through my effort, and together with the team, we explored new territories and overcame many challenges.~~
**why cs:**
* 如果再问就扩展成五六句话 -- 细说
* 我在几岁的时候接触到了编程，但是我做的是什么项目
* 然后当那个跑马灯亮起来的时候我超级有成就感，which也给了我的coding很大的信心。
--------
# A Typical Day of a Scrum Developer
* 早上开启工作日
* Daily Stand-up or Daily Scrum
* 每日站会
* 每个团队成员分享昨天他们做了什么，今天计划做什么，是否遇到任何障碍 roadblock
* 这不是解决问题的会议，而是一个状态更新会议。需要深入探讨的问题会在这个meeting后进行。
* 工作流程：
* Scrum developer, 每个feature都会有属于自己branch。
* Programming & Development: 根据在每日站会中确定的任务，开发者开始编写编码，进行unit test，并对代码进行自检。(这个在本地完成)
* 自检完后push上去，然后点击 pull request/ merge request
* Code Review: 如果有新的代码提交，就会需要进行code review。
* 审查人员可以在特定的代码行上发表评论，提出建议或提出问题。
* 就像是Google Doc一样
* 一旦你的request被approved了，你的changes deploy到测试环境, 让qa测试==> 代码会交给QA。
* 给QA前可能会自己进行集成测试
* QA Team在更广泛的testing environment里进行测试
* 文档：开发者通常需要编写代码文档，以帮助QA团队了解代码的功能和用法。
* Swagger可以帮助API文档 (具体细节看下面了)
* QA 团队完成了测试后，没发现重大问题且确定代码稳定可靠，项目负责人(Lead Engineer)会merge代码。也可以自己merge，但前提是要有两个code review
* 一旦被merge了，你可以删除掉你的feature branch
## Scrum Sprint
* 为了给QA留时间，一般来说SDE的代码得在第二个周的周三前完成
* Sprint planning 一般在上一个周期快结束的时候（第二周）就进行，明确下一个Sprint要做哪些任务
* Sprint retrospective meeting 一般在Sprint快结束的最后一天或者倒数第二天开。
* Sprint Review：向stakeholder展示，sprint结束后1-2天展示。
## 会用到的命令
* `git clone <repo_url>` 先clone代码到你的本地仓库
* `git checkout -b feature/your-feature-name`
* 一个Git命令，它的功能是创建一个新的分支并立即切换到这个新分支。
* 一旦你clone了代码仓库，你通常会为每个feature来创建一个独立的分支。按照一般的命名规范，当你为一个特定功能或特性创建一个分支时，你可以使用 feature/ 作为前缀，然后后面跟上描述这个特性的名称。如果你正在开发一个用户注册功能，你可能会命名这个分支为 feature/user-registration。
* `add, commit, push`
* `git push origin feature/your-feature-name`
* 远程仓库的存储通常是有限的，所以它不会无限地保留所有历史。然而，它通常会保留最近的 commit，以及一段时间内的历史记录，具体取决于远程仓库的设置和策略。
* commit 则让我们在本地存储了所有的version snapshot
* 你整完，并且push到了remote repo后，你可以在代码托管平台上发起一个Pull Request（或Merge Request）来请求将你的更改合并到主分支。这将启动**代码评审**过程。(通过鼠标点击)
* Merge过程
```plaintext
SDE A: A-new + BCD
SDE B: A + B-new + CD
合并结果：A + A-new + B-new + BCD + CD
```
这个合并操作会将两个分支的更改整合到一个新的提交中，保留了每个分支的更改。这是版本控制系统自动处理的一种情况，前提是没有合并冲突。Merge Conflict 指的是两个分支同时修改了同一个文件的相同部分，导致系统无法自动决定应该采用哪个更改。合并冲突需要手动解决，以确保合并后的代码是正确的。
* 删除feature branch
```zsh
git checkout main # 切换回主分支
git pull origin main # 更新主分支
git branch -d feature/your-feature-name # 删除特性分支
```
* **Swagger**
1. 自动化文档生成：Swagger可以自动生成API文档，包括端点、参数、示例请求和响应等信息。这使得文档的维护更容易，因为文档与实际代码保持同步。
2. 交互式测试：Swagger UI允许开发者和QA团队在文档中执行API请求，以验证API的行为和功能。
3. 协作：Swagger规范可以与团队共享，以便开发者、QA团队和其他团队成员了解API的工作方式。
4. 减少沟通成本：API文档中的详细信息可以帮助减少开发者和QA团队之间的沟通成本，因为所有人都可以查看和理解API的规范。
---------
# Top 20 Common BQ
1. What are your career aspirations for the next five and ten years, and how will this internship help you achieve your goals?
* For the next five years, I would like to be a senior Software Engineer, play a key role in the team. Ten years from now, I hope that I am able to lead a development team, architecting sophisticated solutions and being an expert in tackling complex technical challenges.
* This internship would provide me an opportunity to practice, which will enhance my software engineering ability and broaden my technical horizons.
2. Please share with us the biggest setback in your life
* One of the most significant setback in my life was during the ACM, a mathematical modeling competition. The competition requires us to build a model and submit a research paper.
* I thought that the model's quality was the most important, so I devoted too much time and effort on building model. As a result, I do not have enough time when drafting the paper, which eventually caused that our time didn't secure an award.
* I was frustrated because I reviewed the papers with award, and found that their model is not necessarily perfect, but their paper can demonstrate how they optimized their model pretty well. But from this experience, I learned the importance of balancing among different aspects of a project. It reminded me that while perfectionism can drive quality, it can also lead to narrow vision.
3. What are your biggest weaknesses
* overly humble
* fear of public speaking. I am confident on my technical skills and I can communicate among small groups, but I feel challenging to present in front of a large amount of audience. I just feel nervous. To solve this problem, I am trying to take advantage of the presentation opportunities in school. I believe that practice makes perfect and fake it until I become it. Everytime I present well, I can grasp that feeling and feel less nervous at the next presentation.
4. What is your greatest strength and how will that lend itself to succeeding in a role at XXX firm
* I am always curious and passionate on emerging techniques, and I also have the proficiency in quick learning and application. In my personal project YouTube Abstrator, I was inspired by the research paper of Google, and then swiftly adopted and applied technologies like TensorFlow and Google Pegasus model, which successfully automates video summarization from YouTube.
* Besides, I am also a problem solver. In my last internship, I optimized our query dramatically. I found that some of our searching are slow, it is bearable, but slow. I checked the code at repository layer and found that the query is using contains API of Spring Data JPA, whose source code were fuzzy search using double % marks. Therefore, I remove the left one, then the query can use B-tree index instead of scanning the whole table.
* Apart from that, I am a good team player. During my internship at Famulei.us, a teammate get stuck during a sprint and talked about the concerns during our daily stand-ups. Even though I have finshed my own features, I stepped up to assist to ensure our team met the Sprint objectives.
* In summary, I believe that my teamwork skill, my problem solving ability, and my ability of quick learning have made me a good candidate of Software Engineer intern.
5. Which one of your key accomplishments best illustrates your personal initiative and willingness to push beyond what is required?
* 应用chat宝的例子
* 组织我们newer intern的mutual learning group
* When I was interning at Famulei.us, our project was mainly using Java and AWS, and I noticed that some newer interns were struggled with Java as they are more familiar with languages like Python or Cpp, while some of them were struggled with AWS. Recognizing this challenge, I initiated and organized an "Peer Learning Group". Every Friday afternoon, we would gather for a focused session, diving into Java coding challenges or AWS hands-on tasks. This weekly ritual not only improved their technical proficiency but also fostered a collaborative spirit among us.
6. What is the best team you've ever worked with, and why do you define this as a great team？
* A great team for me means the whole is truly greater than the sum of its parts.
* Firstly, it is crucial that each member can work in the domain that they can handle and they can work efficiently.
* Besides, a collaborative environment is essential. When I thought a business logic is confusing, I value having teammates or leaders who are responsive and can either solve the puzzle or direct me to the right resources.
* Moreover, I believe the importance of continuous improvement. In my ideal team, we can do retrospections together and discuss about whether there are aspects for improvement.
new insight: team里的每个人都有ownership，乐意互相帮助fix issues。
7. What has been your most significant leadership role and what have you learned from it
* When I was interning at Famulei.us, our project was mainly using Java and AWS, and I noticed that some newer interns were struggled with Java as they are more familiar with languages like Python or Cpp, while some of them were struggled with AWS. Recognizing this challenge, I initiated and organized an "Peer Learning Group". Every Friday afternoon, we would gather for a focused session, diving into Java coding challenges or AWS hands-on tasks. This weekly ritual not only improved their technical proficiency but also fostered a collaborative spirit among us.
* Besdies, this experience allows me to realize the power of team and the power of proactive intervention.
这里讨论了下leadership是什么，我觉得leadership是要保证things proceed smoothly，这个过程包括 正确分配任务，take advantage of 别人的strength，保证组里沟通的transparent
8. Tell me about a time when you did an effective job of managing a conflict
* When I was interning at Famulei.us, I was developing a user profile deletion fuction with another intern. He was taking care of the front end and I was taking care of the backend. According to the initial business logic, we need to have double check. However, while integrating our work, I notice that he implemented a pop up confirmation window but I had design an email verification process.
* To address this problem, we discuss together. I supposed email verification is safer, but he believed that the popup window is better for user experience. Therefore, we decided to ask our mentors and we picked the email verification.
* This experience let me know that even with a clear business logic, the communication among team members are still important.
9. Tell me about a time where you have had to juggle multiple high pressure tasks. What strategies did you employ to successfully completed all, and what did you learn from this?
* As a student and a intern, it is common for me to have consistent deadline.
* Generally speaking, I would avoid putting myself into this situation by time management. I would start my week and my day with a to-do-list.
* If there is a fire drill, I would focus on the urgent request and then finish others.
* If I have to tackle multiple high pressure tasks at the same time, I would try my best. I will try to break the task into some smaller tasks, and take advantage of every time slots. For example, sometimes it takes 1 or 2 hours for model training, and I will try to finish other task while waiting for the model.
要和manager confirm expectation，要告诉他们有哪些可能会做不完的，然后跟团队synch up好。同时努力做。
10. Tell me about a time when you presented a new idea, but were met with resistance from others.
* ChatGPT那个project
* 我们组里有其他的engineer提出质疑，他觉得他之前用过的chatbot都都比较rigid。
* 但我觉得说GPT4 can handle it pretty well.
* 我的manager也很感兴趣，隔天我就给我的的manager展示了demo，他也觉得gpt4 has a pretty human-like performance, not as rigid as the chatbot before.
* 他觉得非常好，所以他consulted the marketing team and they conducted an AB test.
* positive feedbacks -- 所以我的manager give me a green light and we launch the project.
* **(学到什么)** From this experience I learn how to face the opposition and how to speak with data and facts.
11. Describe a time when you had to be particularly adaptable and flexible to complete a task or project
* During my internship at Apexus Tech, our frontend developer got covid and had to take a sudden leave, leaving the development of a critical module blank.
* Although I was focusing on the backend, my mentor wanted me to implement that part of front end functions given the tight project deadline. I was not super familiar with the front end techniques and the React framework, but I saw this as a valuable learning opportunity. I utilized the weekend to swiftly learn React through online tutorial and documentation, and succesfully built out the required features.
* 这个问题说实话跟没说似的。
* 这个问题是最好 -- 你得先说出你的methodology；
* how have you been adaptable.
*
12. Describe a situation which you were required to quicky learn a new process in order to perform effectively
* 就用上面那个react
13. Describe a time when you had to react quicky or make an immediate decision to solve a difficult problem. What approach did you take in this situation?
* During my final project for a course, I was working on an interpretable machine learning assignment using a package called "Interpret ML." One of the major aspects of my project was to leverage this package's visualization API to create compelling visualizations. My plan was to showcase these visuals directly within a Jupyter Notebook for my presentation.
* However, just an hour before I was scheduled to present, I decided to run through my entire codebase one more time. However, the visualizations didn't render this time around. I quickly identified that there was a dependency issue due to update of the third-party packages.
* Recognizing the time is limited, I had to think on my feet. I used a photoshop to mock up a demo of the expected visuals. This allowed me to proceed with the presentation smoothly and effectively communicate my project's results to the audience.
* 这里的methodology是 Stress Management -- Always Keep in Calm when things come
* This experience taught me the importance of resillience and agility in tech setting. Though expertise in technical knowledge is important, the ability to swiftly adapt and provide solutions in real-time, especially under pressure, is also quite essential. It make me realize that in the real world, **problem-sovling is often striking a balance between the ideal and the practical**.
这里的Approach就是
1- 先identify有哪些事情被影响了，然后去deal with哪些被影响的问题。
2- 采取plan b（比如说组员联系不上的时候，不要干等，而是马上准备他的part的presentation）
3- Stress Management -- Always Keep Calm when things come
14. Think about a recent situation which required you to make a difficult decision. Describe the situation, the options you had, and your decision.
* Manager要我优化data pipeline，然后我去看了下，这个是用pandas做的，pandas的优化空间已经很小了，这时候我在纠结要不要用spark重写，但重写的工作量很大。
* 因为之后这个pipeline可能会扩展，现在不改以后加新feature的时候可能还是要改写成PySpark，所以我决定现在就用PySpark去reconstruct这一部分
* 最后我重写了，优化挺好的，后面的scaling up 也benefit from this
15. What was the most valuable feedback you had received in the past 12 months? What was your reaction and action you had taken?
* During my last internship as a software developer, my team lead observed that while I was good at coding and problem solving, I often waited for instructions or approval before moving forward with decision. He advised me to take more initiative and to be more confident in proposing solution and improvement without waiting for direction.
* At first, I was a bit suprised as I believed that following instructions was the safer approach for an intern. However, after reflecting on his feedback, I realized that he was encouraging me to grow, to trust in my skills, and to become a more proactive contributor.
* Then, I began with small steps. When there is uncertainty, I would draft a solution and then seek feedback. This allowed me to both show initialtive and ensure I was on the right track. Besides, I attended more optional code reviews to collect insights into decision-making processes.
* By the end of this internship, I was not only able to contribute more meaning fully to our projects, but I became more confident on my ability.
16. Describe a time when you made a mistake or when you did not apply the necessary effort in a task or project. What feedback did you receive? How did you change your approach as a result of this feedback?
* Internship at Apexus Tech
* user profile deletion, 前后端不兼容。
**Conflict类问题**
* To be honest, I've been fortunate enough to not have experienced significant conflicts with my teammates. I believe this is largely due to my proactive approach to communication and my willingness to listen and understand different perspectives.
* However, in my school group projects, there is always disagreement while deciding the tech stack that we use. But **instead of letting this turn into a conflict**, I suggested we have a **structured brainstorming session** where everyone could present their viewpoints, supported by facts and data. This ensured that all voices were heard and that we made a decision based on objective criteria rather than personal preferences.
* I've found that open dialogue, combined with a genuine respect for each teammate's expertise, is the key to avoiding conflicts and ensuring a smooth collaboration By fostering a culture of understanding and mutual respect, we can address potential issues before they escalate.
17. Imagine that you are working on a project that is not going according to plan due to missing information and/or resources. What would you do in that scenario?
* assess the situation. figure out what i can address, and what I cannot.
* communicate the challenges to all the relevant stakeholders
* have a team brainstorm meeting to find all the possible solutions
* re-evaluate the situation, give a new deadline and document everything.
* summarize the lesson that we learned from this crisis and try to avoid this in the futher.
18. How to improve someting you see or do everyday in your daily life?
19. Think of a time in the past when u did someting which other people felt was wrong but you felt was justified in the circumsatnces - what was the situation and what did you do?
20. Tell me about a time when you had to use your analytical skills
-------
# Caterpillar
1. Do you know what the department does and how it fits into the business?
* Yes, Cat Digital is an important department of Caterpillar and it focus on digital solution and technologies. It is responsible for developing digital tools, applications, and solutions like the Cat App and the Cat Inspect which can facilitate remote tracking, management and optimization of the Caterpillar equipments.
2. Why are you interested in this role?
* I am passionate on using technology to solve the challenges in the real world, and working at the intersection of traditional industries and modern digital solution is facinating to me.
* Besides, Caterpillar, being a globally recognized leader, offers a platform where I can contribute to projects that have tangible impacts.
* Therefore, I am interested in working in the team that's driving digital transformation in such a crucial sector.
3. What skills can you bring to the role?
* I have a solid foundation in Java and python, coupled my experience in CICD and could computing platform. Besides, my internships allows me to have understanding on software development life cycles and agile development.
* Apart from technical skills, I am a fast learner and I am a quick adapter. Throughout my academic and professional journey, especially during my internships at Apexus Tech and Famulei.us, I've consistently been thrown into environments with novel technologies and methodologies. I can always pick them up within a short span.
* Therefore, based on my experience, I believe that I can fit into the team quickly and start to contribute my value.
4. Where does this role fit into your long-term plan?
* I think this internship can be a start point of my long-term goal of being a proficient software engineer who specializes in bridging the gap between traditional industries and digital innovation.
* Working in Cat Digital would provide me an opportunity in understanding how large-scale digital solutions are developed and deployed in read-world scenarios.
* Over the next few year, I aim to deepen my technical expertise and gain a broader understanding of industry-specific challenges.
-------
# **HP HR Phone Screen**
1. Tell me about yourself
* 基本信息(比如名字), Background（比如专业），your passion，擅长的技术，简单介绍最重要的一个实习经历
* Hello! My name is Lexi. Currently, I'm pursuing my Master's in Computer and Information Science at Cornell University.
* My tech journey started from Physics, especially when I played around with a microcontroller. That got me hooked on programming.
* I later decided to pursue degrees in related majors, which opened my eyes to the whole tech industry. During the past few months, I was interning at Famulei.us as a backend engineer where I've built APIs for their e-commerce platform using Java and Spring Boot and integrated various AWS services. I also introduced a ChatGPT-based Chatbot for them. Prior to this role, I was at Apexus Tech, where I helped shift some features from monolithic to a microservice setup.
* Based on my these experience, I am quite confident that I can fit into the team at your company and start to contribute my value quickly.
3. Discuss the projects you have done, and your understanding of the job opening.
* **Proud Project**：
* 流程改一下，我先自己做一个demo --> 我老板非常感兴趣但还是有点hesitant --> 我的manager
* At Famulei.us, I had the opportunity to work on several interesting projects, but the one that stands out the most is the ChatGPT-based chatbot I proposed and implemented.
* At the early 2023, the notion of GPT was super heat and I found that our customer service department was facing a lot of repetitive queries. Therefore, I think a chatbot might be a good solution.
* Therefore, I made a demo and proposed it to my manager, he was quite interested in this and he consulted the marketing department. Afterward, our team collaborated with the marketing team and they conducted an A/B test and the results were satisfactory. My idea was received and I was given a green light to further explore and refine the concept.
* (具体的实现) Then, we designed the architecture, trained the model by FQA data. collborated with other department for testing, and built the feedback loop. After launching our chatbot, it handled over 80% customer queries and save costs for our company.
* This project is my favorite one because I introduced my innovation to my team through my effort, and together with the team, we explored new territories and overcame many challenges together.
* develop the softwares for printing such as HP smart.
* Since I already learned a lot about computer science and software engineering, I hope that I can have a opportunity to apply what I have learned and solve some real world problems, especailly for the problems that is realted to a real electronic product.
4. Why HP?
* (HP很牛逼) I am a huge fan of HP printer and I am currently have one. When I tried hp instant ink and hp smart, I feel that's too amazing. So having firsthand experience of the company's commitment to innovation and customer experience make me my enthusiasted to be a part of the HP team.
5. Strengths and weaknesses./ What sets you apart from other applicants?
* **Strengths**
* I am always curious and passionate on emergin techniques, and I also have the proficiency inquick learning and application. In my personal project YouTube Abstrator, I was inspired by the research paper of Google, and then swiftly adopted and applied technologies like TensorFlow and Google Pegasus model, which successfully automates video summarization from YouTube.
* Besides, I am also a problem solver. In my last internship, I optimized our query dramatically. I found that some of our searching are slow, it is bearable, but slow. I checked the code at repository layer and found that the query is using contains API of Spring Data JPA, whose source code were fuzzy search using double % marks. Therefore, I remove the left one, then the query can use B-tree index instead of scanning the whole table.
* Apart from that, I am a good team player. During my internship at Famulei.us, a teammate get stuck during a sprint and talked about the concerns during our daily stand-ups. Even though I have finshed my own features, I stepped up to assist to ensure our team met the Sprint objectives.
* In summary, I believe that my teamwork skill, my problem solving ability, and my ability of quick learning have made me a good candidate of Software Engineer intern.
* **Weakness**
* I have had hard time learning to share a task with other teammates. Sometime, I tend to solve a problem on my own for too long without seeking for help from others. For example, when i encountered a bug, I was quick excited and I was like: "oh I have to conquer it!" Sometime I might spend too much time on it. Now I have already recognized the power of the team and learned when to consult others to speed up problem solving.
* 如果还要another one就说中国小孩容易overly humble这点
5. How do you think you can contribute as a member in a big team of more experienced individuals
* In a team full of experienced individuals at HP, I see my contribution manifesting in several distinct ways:
* Firstly, I am a fast learner and I am a quick adapter. Throughout my academic and professional journey, especially during my internships at Apexus Tech and Famulei.us, I've consistently been thrown into environments with novel technologies and methodologies. I can always pick them up within a short span. Therefore, I believe that I can adapt swiftly to new challenges and start to contribute my value by finishing the tasks assigned.
* Second, I believe that I can bring fresh perspectives and innovative solutions to the team. My passion for cutting-edge technologies often leads me to explore new horizons and apply them in practical ways. For example, after coming across Google's advanccements and research paper in NLP, I was deeply inspired to create my own tool. This led to the development of "YouTube Abstrator" which is an automated video summarization tool that leverages the Google Pegasus model for generating concise abstracts from YouTube subtitles.
* Therefore, based on my fast learning ability and my innovation, I believe that I can fit into the team of more experienced individuals quickly.
6. Give me an example of your leadership
* When I was interning at Famulei.us, our project was mainly using Java and AWS, and I noticed that some newer interns were struggled with Java as they are more familiar with languages like Python or Cpp, while some of them were struggled with AWS. Recognizing this challenge, I initiated and organized an "Peer Learning Group". Every Friday afternoon, we would gather for a focused session, diving into Java coding challenges or AWS hands-on tasks. This weekly ritual not only improved their technical proficiency but also fostered a collaborative spirit among us.
9. How would you describe HP to an elderly person
* HP is a renowned company that makes computers, printers, and other electronic devices. Their products are quite popular, and you might recognize them by their fashionable designs and the logo 'HP' you often see on laptops or printers at stores or offices.
12. Do you know development methodologies?
* Sure, I have worked in Scrum development team and I have experience in CICD.
# SiriusXM
Al视频面试6个问题 有3次录像机会 每个回答
1.5-2min
## Operation Engineer
1介绍你的名字专业学校毕业时间
Hi, my name is Lexi Yin. I am currently pursuing a Master of Science in Computer and Information Science at Cornell University. My expected graduation date is May 2025. Previously I completed my Bachelor of Science in Information Science at Syracuse University, specializing in Data Science.
2你是怎么知道SiriusxM的？为什么投递这个岗位
SiriusXM and Pandora are leading audio entertainment companies, with SiriusXM known for its satellite radio service offering a wide range of radio programming, and Pandora renowned for its personalized internet music streaming service.
I learned about SiriusXM through the career trek activity at Syracuse University. We went the New York Office of SiriusXM and serveral alumni introduced us to the innovative world of SiriusXM and Pandora. I still remember that the studios for recording programs are super cool. This visit make me know and sense SiriusXM's commitment to quality and creativity in audio entertainment. After that, I just list SiriusXM as my dream company.
Besides, my tech stack is mainly Java, Python, and AWS. Therefore, I feel that what I have been doing is quite similar to what SiriusXM is requiring and I think being in a place that aligns with my skills and passion would foster mutual growth.
Additionally, I really have passion on entertainment industry, I consume media content -- working on Sirius XM as a software double dream come true.
3你用过 AWS相关吗
Yes，I have hands-on experience with AWS. During my internship at Famulei.us, I work as backend developer and developed RESTful APIs using Spring Boot and integrated several AWS services such as S3, ECS, RDS and SQS. This experience helped me understand how to leverage cloud computing to enhance the scalability, stability, and performance in software solution.
Also, at Famulei.us -- CICD -- how to utilize cloud computing to automating and facilitating software engineering in terms of deployment.
4 你会写 python java javascript sql（还有几个忘了）吗
I am proficient in several programming languages and technologies. I have rich experience in Java, Python, SQL, and JavaScript. Additionally, I participated in the projects that are using the corresponding frameworks like Spring Boot, React, Flask, Bootstrap and so on.
5你觉得在tech公司的 media engineering 岗位怎么样
I think a media content engineering role at a tech company is both challenging and exciting. It's the intersection of technology and creativity. In today's digital age, media content isn't just about delivery; it's about how effectively we can engage and captivate the audience, and that's where the role of a media content engineer becomes crucial.
Consume media content every day. majority part of my life. -- work closely of my life
6 If you could fix one thing (technically) about any streaming service, what would it be?
If I could fix one technical aspect of streaming services, it would be to enhance searching algorithms. I notice that in this digital age, we can get tons of media-related information on a daily basis. However, we might be captivated and suprised by a song, but then we might feel quite difficult to find that specific content. Therefore, if i have the opportunity to enhanance streaming service, I would like to develop an intuitive, multimodal search serciec. For instance, users could find a song by humming its tune or locate a video by describing its content.
This approach might involve Spring Boot and Mongo DB as backend tech stack. Besides, I would like to integrate a corresponding algorithm for intelligent comparison. I might also be able to integrate Elastic Search improve the searching efficiency.
## Backend Engineer
3- Please share relevant engineering experiences through your schoolwork or prior internship that you will bring to this position.
At Famulei.us, I had the opportunity to work on several interesting projects, but the one that stands out the most is the ChatGPT-based chatbot I proposed and implemented.
At the early 2023, the notion of GPT was super heat and I found that our customer service department was facing a lot of repetitive queries. Therefore, I think a chatbot might be a good solution.
Therefore, I made a demo and proposed it to my manager, he was quite interested in this and he consulted the marketing department. Afterward, our team collaborated with the marketing team and they conducted an A/B test and the results were satisfactory. My idea was received and I was given a green light to further explore and refine the concept.
Then, we designed the architecture, trained the model by FQA data. collborated with other department for testing, and built the feedback loop. After launching our chatbot, it handled over 80% customer queries and save costs for our company.
This project is my favorite one because I introduced my innovation to my team through my effort, and together with the team, we explored new territories and overcame many challenges together.
4- Please share which programming and/or scripting language you prefer to work with and why.
I think both Java and Python are elegant language and I used them in my previous internships and built industrial project based on either of them.
Java, with its robustness and scalability, has always been my top language for building high-performing backend systems. My experience with frameworks like Spring Boot has allowed me to appreciate Java's efficiency in developing complex applications.
On the other hand, Python is concise and simple. I tend to use it while I am doing data-driven projects and whlile I am ramping up product prototypes because of its community support
In summary, althought I am comfortable working with a variety of languages and technologies, Java and Python stand out because their scalability and extensive community support.
My previous academic journey and ming
5- If you applied to more than one internship position, please rank the positions from most interested to least interested.
* 第一个（top choice）是 media engineering. I am drawn to this role because of my strong interest in the intersection of media and technology. Enjoying Media content, especially for listening to music and listening to podcast become an essential part of my life. It's my source of relaxation. I see working for media engineering as an opportunity to directly impact an area that is closely tied to my life.
* 第二个是Backend Engineering, tech stack 和 this position aligned closely. My previous internships and projects have prepared me well for the challenges this position might have.
* 第三个是Platform Engineering，I am captivated by the cloud computing，I think it's revolutionizing the whole technical industry. Although it's my third choice, 如果有机会dive deep， 我会非常excited的。
* 最后，I am willing to branch out
6- Please share a group project you worked on in school. What made it successful and what role did you play on the team? What were the biggest challenges you faced in a group situation
At one school project, I was the team leader of a project called Interpretable Machine Learning whose deliverables incoperated a final presentation. This project enable me to learn that adaptability and plan B is essential for the sucess of a project.
I make a plan for this project, divide big tasks into smaller ones, setting up milestone, and designate them to proper people, keep track of the progress.
The challenge happened right before the final presentation. We had all the code on hand and things seemed to be very smooth. But, just an hour before I was scheduled to present, we decided to run through our entire codebase one more time. Then, the visualizations didn’t render this time around. I quickly identified that there was a dependency issue due to update of the third-party packages.
Recognizing the time is limited, I had to think on my feet. One of our team member proposed that we can use the recording of our presentation rehearsal and I negotiated with our professor about that at once. Fortunately, professor agreed that we can play the video while the visualization was necessary.
This experience taught me valuable lessons about the importance of adaptability, teamwork, and effective communication in overcoming challenges. It reinforced that while technical skills are crucial, the ability to collaborate and think creatively as a team is equally important in achieving success in a tech-focused environment."
Sign in with Wallet
Connect another wallet