Internship Trainee at Motorola Solutions

After completing the elective course provided by Motorola Solutions, I was selected as an Internship Trainee for 1 year. So, I will be working as an intern in my 4th year along with managing exams and assignments in the 7th Semester.

Summer Internship

I started my internship in the summer and it included a summer internship of four weeks. As I had joined for a one-year internship, the first month was going to be training for sure.

The first week included an orientation session, a meeting with my manager, setting up my account, and other onboarding processes.

In the second week, I was provided with Knowledge Transfer videos to get insights into the project. I also received my work laptop this week and after receiving it, I needed to clone the project on my laptop and make the local project run. It included node js, angular setup, python setup, and tools which are used by our team on a day-to-day basis.

The third week included going through the KT videos, and understanding the code flow of the main repositories. I also explored Angular best practices that are being used in our project and learn python flask as a backend service.

In the starting phase of the fourth week, I was exploring the KT videos, and source code, understanding the functionalities of the UGWP portal, etc. I also started attending the daily scrum meetings this week. I went through the in-depth functionalities of our application and the flow of the application, and I got KT sessions from my seniors on the team.

Post Summer Internship

After the initial month, my training almost got completed and now the team is assigned me UI enhancements and bugs that I started fixing with the help of other senior engineers.

I also get a chance to work on one of the API's changes on the backend side in which I optimized the API response time by optimizing and improving the code.

So far I have been working on UI Enhancements on the Front end side, API creation and optimization on the back end side, and helped other team members to complete their tasks.

UI Automation Project

One portal is a new project that I assigned to our team and our team is working on its UI enhancements and new functionality addition, so after each new feature that got added we need to make sure that old functionalities are working fine. so I along with other interns are doing sanity testing whenever a new build is generated to make sure that all the existing functionalities are working fine along with new features that are added freshly.

So this manual testing is a bit tricky task so our manager suggests we create a new project or environment where we can run the suites and that will test the whole application automatically.

So we implemented UI Automation using cypress and tools.

What is Cypress?

Cypress is a purely JavaScript-based front-end testing tool built for the modern web. It aims to address the pain points developers or QA engineers face while testing an application. Cypress is a more developer-friendly tool that uses a unique DOM manipulation technique and operates directly in the browser.

So along with other interns, we implemented UI automation functionalities based on UI flows that we were testing day to day basis. so we have implemented suites under the guidance of two senior members of our team.

Code for UI Automation: https://github.com/veetmoradiya3628/Management-Portal-Automation

Development for the Enhancements

We almost implemented all the core UI flows and functionalities that are needed to be tested as part of Sanity testing.

Some of the other flows are yet implemented that we are working on.

Next Task

I will be working on UI Enhancements, Backend API Tasks and database query optimization-related works, and Automation tasks I will be working on as per our manager's assigned work.

Learnings

It has been around 4 months since I started my internship and the learning curve has been very high which is required at the start of the career. The scale of the projects and the impact it creates can be cannot be experienced generally at the university that is what the internships are for.

For personally, I had not worked as part of an Agile development team so learned how we can work in agile methodology and learned how the industry is building software projects.

Also working on a big project for the first time brings its own challenges because understanding the code flow can be challenging.

For the remaining part of the internship, I will be trying how other projects are being developed along with the tasks assigned to me so that I can improve my understanding of how the whole team works and helps me develop better software.

Covid-19 Dashboard Using Power BI

Project Outline

This project is all about Data visualized Web-based dashboard to get information on Covid-19. This dashboard is showing information in form of Graphs and Charts so it will be easy to get information and it is easy to do Analysis.

The goal of Data Visualization

The primary Goad of Data Visualization is to communicate information clearly and effectively to users via the statistical graphics, plots, information graphics, tables, and charts selected. 

Effective visualization helps users analyze and reason about data and evidence. It makes complex data more accessible, understandable, and usable.

There are lots of Data Visualization tools are available in the market like Tableau, Looker, Microsoft Power BI, Plotly, Fusion Charts, etc. Here in this project, we will be using Microsoft Power BI.

What is Power BI?

Microsoft Power BI is a business intelligence platform that provides non-technical business users with tools for aggregating, analyzing, visualizing, and sharing data. we can get data from multiple Data Sources like SQL, Excel, CSV File, etc. Provides Personalized Data boards, Simple and Performance Oriented, Secure reports.

It uses Power Query which is a similar kind of SQL Language to do mathematical and other operations on Data.

Our Dashboard Functionalities

                                                    Global

India

 

To make this dashboard we have used a CSV file which is there in our Github repository in that file we are having columns as confirmed, confirmed daily, Deaths, Deaths daily, State/Union Territories, Time, Recovered, Recovered daily, and other fields.

So we have performed the below query operations and got the required information which we want to show on the dashboard,

Queries

Active Cases Query

Active cases1 = SUM('India'[Confirmed Daily])-SUM('India'[Deaths Daily])-SUM('India'[Recovered Daily])

Average Confirm Daily

Average Confirm daily1 = SUM('India'[Confirmed Daily]) / DISTINCTCOUNT('India'[Date])

Average Death Daily

Average death daily1 = SUM('India'[Deaths Daily]) / DISTINCTCOUNT('India'[Date])

Average Recovery Daily

Average Recoveries daily1 = SUM('India'[Recovered Daily]) / DISTINCTCOUNT('India'[Date])

Total Cases

total cases = SUM('India'[Confirmed Daily])

Total Active Cases

total active cases = SUM('India'[Active Cases1])

Total Deaths

total deaths = SUM('India'[Deaths Daily])

Total Recovered

total recovered = SUM('India'[Recovered Daily])

So we have used the above queries to build various graphs and tables shown in our dashboard.

Future Improvements

We will be trying to make UI better and add more graphs and charts as part of our dashboard so Users can get more information from our dashboard.

We will be Integrating its report from the dashboard to the Web page and at this time it is static means we are using a CSV file in which data is already cleaned and directly used in the backend to make these charts but we will be making it Dynamic. also these dashboard is only for INDIA related information but we will be making it available from whole Glob.

Thank you for reading 

Prepared By: 19IT069 Veet Moradiya

                       19IT070 Dhruv Nagar

Mentored By : Mrudang Pandya

My Summer Internship Experience

             My name is Veet Moradiya . I am from Surat and currently pursuing B.Tech IT (3rd Year) at CHARUSAT University. Here I am sharing my first internship experience.

Overview

            This past summer, I have worked as a backed development Intern at Weengs Software Company which is located in Surat. I have worked on a project of a Blog Post related Website that allows users to post blogs or some content in blog format and they can read others' blogs and search for specific topics posts that they want to learn or read. There is an admin side is also there which manages users' activity and their posts. It was an amazing experience for me to work on this project.

About the Company

            Weengs is a software development company which is building Mobile and Web Applications according to Clients need. 

Work Done By Me

Week 1:

Firstly, the company gave us information about the project briefly and gave information about what to do in the project. They told us to study different job websites and take the important thing which is needed in the websites. The company has told us to make two teams for Front-end and Back-end. I got selected for the back-end of the website. I was given a task in the first week is that I have to design a database for our website and implement it using MySQL.

Week 2: 

In this week firstly I have made tables in the database for User and Admin. After that, I have to write PHP code for Login and Registration and integrate it with our database for Users.
After that same login and registration functionality for Admin Login and Registration. Also, make logout functionality and Session Functions.

Week 3:

In this week firstly I have made tables in the database for saving Post data and its relevant data. After that, I have to write PHP code for adding new post pages and I have also integrated it with our database. After that, I have made changes to our home page and make it dynamic means I have listed posts from the database according to Views number and all. Algo makes pages to edit existing posts and to delete posts on the user side.

Week 4:

In this week firstly I have written PHP code for views update functionality in our site. After that, I have to write PHP code for profile setting means to update profile details of users and for recovery of passwords from the database.
After that, I have made changes to our profile page and make it dynamic for different users and according to who is logged in, its data will be shown on that profile page. 

Week 5:

In this week I have worked on the admin side means functionalities related to user management means the admin can able to delete posts that are not relevant to our website that has been published by some user. 
Admin can able to delete that user also.
Admin can see all user’s activity.
I have written PHP code for the management of users activity by Admin.