SQL
Nijith Frank
Rasipuram
Summary
To have a growth oriented and challenging career where I can contribute my knowledge and skills to an organization and
enhance my experience through continuous learning and teamwork
I am Nijith Frank completed B sc Nautical science and switched my career to analytics
Overview
3
3
years of post-secondary education
3
3
Certifications
2
2
Languages
Work History
Virtual Internship
KPMG
11.2022 - 11.2022
- I have created a number of dashboards that will help the KPMG client Sprocket Central Limited in analyzing the trends in their existing customers data and determining which customer segments is responsible for the majority of their business's revenue
- It was an exceptionally good learning experience in Handling Data, analyzing the data and giving inferences
- It was a great experience to work on a problem from Data Quality Assessment Stage to the Data Insight stage and finally the Data Presentation.
Education
Bachelor of Science - Nautical Science
Coimbatore Marine College
Coimbatore 08.2016 - 07.2019
Skills
Data cleaning and preparation
Data analysis and exploration
Creating data visualizations
Creating dashboards and reports
Domain knowledge
Accomplishments
- Used Power query to clean the data in the dataset.
- Used Power BI to calculate monthly and yearly sales
- Calculated the top five customers and top five product using filter
- Calculated the total amount of sales
- Calculated total amount of sales by region
Software
Advance excel
Power BI
Unemployment trends in India using SQL
Analyzing and Understanding Unemployment trends in India during 2016-2020 period. We shall also see the states that have unemployment rates at the higher end and where unemployment levels have lowered. This shall be a state wise comparison.
Certification
Data Analytics
Timeline
Virtual Internship
KPMG
11.2022 - 11.2022
Excel Power query
11-2022
Data Analytics
10-2022
Power BI crash course
10-2022
Bachelor of Science - Nautical Science
Coimbatore Marine College
08.2016 - 07.2019