VIKRAM SALLAPURAM

I am a Master of Information Technology graduate from Victorian Institute of Technology, equipped with a strong foundation in MySQL, Data Visualization, MS Excel, Python, and R programming. Proficient in MS Excel, Power BI, SQL, Python, and R for developing comprehensive visualization reports and analytical solutions.

In a key project titled 'Patient Management System,' I successfully designed and implemented database tables such as Login, Register, and Doctor details. I established a seamless connection between middleware and the database using JDBC drivers, enabling crucial operations such as create, insert, update, and delete for all patients. The project also involved the development of Data Flow Diagrams, Entity Relationship Diagrams, and Data Structure Diagrams, showcasing my proficiency in system architecture and design.

Moreover, I bring a robust skill set in Python and R programming, enhancing my capabilities for data analysis, statistical modelling, and automation. This expanded skill set allows me to tackle diverse challenges and contribute to innovative solutions in the ever-evolving field of Information Technology.

• Python – Udemy, September 2023
• R Programming – Udemy, November 2023
• Complete MySQL Mastery – Code with Mosh, July 2022
• BPMN 2.0 – Udemy, September 2022
• Microsoft Excel Beginner to Advanced – Udemy, August 2022
• Microsoft Power BI – Udemy, September 2022
• Master of Information Technology – Victorian Institute of Technology, 2021
• Bachelor of Science in Computer Science and Engineering – NBKR Institute of Technology (India), 2019

Project: Patient Management System Project

Objective: Develop a web application portal for convenient appointment booking for doctors and patients.

Key Tasks: 

• Create and maintain a MySQL database on MySQL Server for efficient data storage and database management.
• Develop data flow diagrams to ensure program organization and aid decision-making.
• Perform essential database operations (create, insert, update, delete) to store and maintain comprehensive patient and doctor data.

Outcome: Successfully designed and developed the Patient Management System. The application underwent thorough testing and was deemed operational, enabling efficient appointment booking and secure storage of patients' and doctors' information.

Project: Adventure Works Report

Objective: Develop a report to help organizations assess product sales and returns, facilitating informed decision-making.

Key Tasks: 

• Import, clean, and transform data using Power Query, addressing issues like incorrect, corrupted, or duplicate data.
• Model data and establish relationships between tables using data modelling techniques.
• Create calculated columns and measures for effective data visualization in Power BI.
• Develop dashboards, KPIs, and visual interactive reports in Power BI.
• Utilize DAX queries and functions in Power BI to craft a comprehensive visualization report.

Outcome: Successfully developed a Power BI report showcasing key metrics such as revenue, sales, top customers, top-selling products, and highest-margin product. Additionally, detailed customer and product pages were created for a more granular view.