Mayur Keshvala

Ambitious individual, pursuing a career in Data Analysis.

Projects:Data Modelling in Excel, 1 Week

• Building data models using the Power Pivot feature in Excel.
• Creating and managing relationships between tables in a data model.
• Defining calculated columns and measures to add context to the data model.
• Using DAX (Data Analysis Expressions) to create complex calculations and queries.
• Utilizing the Data Model view to manage tables, relationships, and calculations.
• Combining data from multiple sources to create a unified data model.
• Creating PivotTables and PivotCharts based on data models to generate interactive reports.
• Using Excel's data analysis tools to gain insights from the data model, including filtering, sorting, and summarizing data.

Excel, SQL and Power BI, 1 Week

• Creating a database in SQL Server Management Studio (SSMS).
• Creating tables, views, stored procedures, and other database objects in SQL using Data Definition Language (DDL) commands.
• Defining primary and foreign keys to establish relationships between tables in the database.
• Writing SQL queries to insert, update, and delete data in the tables.
• Using SQL Server Integration Services (SSIS) to import data from external sources into the database.
• Connecting to the database from Power BI Desktop and importing the data.
• Creating relationships between tables in Power BI to enable cross-filtering and drilling down capabilities.
• Creating visualizations such as charts, tables, and maps to represent the data in Power BI.
• Creating interactive dashboards that allow users to explore the data and gain insights from it.

Wedding Planner System, 7 Months

• Understanding of the Model-View-Controller (MVC) architecture and its components: models, views, and controllers.
• Ability to create models using Entity Framework or other Object-Relational Mapping (ORM) tools.
• Ability to create controllers to handle incoming requests and return responses to the client.
• Ability to create views using HTML, CSS, and JavaScript to display data from the controller to the client.
• Knowledge of Cascading Style Sheets (CSS) to create visually appealing and responsive user interfaces.
• Knowledge of HTML to create and structure web pages.
• Knowledge of JavaScript and its libraries such as jQuery for client-side scripting and user interaction.
• Ability to write SQL queries to retrieve data from the database and populate the model.
• Understanding of database design and normalization principles.
• Ability to handle form submissions, user authentication and authorization, and session management in a web application.

Professional Experience:

Shop Sales Assistant, Spar, July. 2017 – September. 2019                                                                                                                                                                                                                                                                                        

• Processing, organising, and receiving deliveries and shipments accordingly.
• Maintaining a meticulous knowledge about store items, so that recommendations and advice can be useful to the customer.
• Resolving and addressing customers complaints, professionally, ensuring that the resolution is satisfactory.
• Attending to the shelves, ensuring that products are suitably presented in allocated spots, whilst checking that the products are suitable for sale. Therefore, this includes checking the product for damage, or possible expiration.
• Responsibility of handling customers on a continuous basis, ensuring that they are satisfied with their experience. This includes handling payment, as well as answering queries.
•  

Caterer, Sharmilee, August. 2016 – April. 2017                                                                                              

• Ensuring that I follow mandatory procedures and regulations, such as wearing gloves for sanitary reasons, in order to avoid disasters. 
• Undertaking several roles, independently or cooperatively, such as serving, collecting, and emptying food. In some instances, this would be done simultaneously. 
• Instances of attending to multiple venues and having made arrangements for travel and meeting. 
• Assisting with catering supplies, such as loading and unloading tableware, food, catering supplies from the catering vehicle. 
• Responsibility of meeting tasks, with strong and clear communication to clients, peers and managers of delays and updates. 
• Answering guest’s queries, as well as handling complaints ensuring that the resolution reasonably matches their expectations.

Education

November. 2022 – April 2023            Skills Bootcamp: Data Analysis with SQL and Power BI

Purple Beard, Leicester, England

September. 2019 – June 2022           Bachelors in Computer Science: First-Class Honours

University of Leicester, Leicester, England

September. 2017 – June 2019           BTEC Level 3 Extended Diploma - ICT: D*D*D*

Gateway College, Leicester, England

September. 2011 – June 2016           GCSEs: 9 A-C, including B Maths and C English

Soar Valley College, Leicester, England