SOMYA DEWAN

Results-oriented Technology Professional with a unique blend of data analytics, development, and project management skills. Experienced in Power BI, Power Platform, and full-stack development with hands-on exposure in Agile environments. Skilled in translating business requirements into data-driven insights, building dashboards, automating processes, and collaborating with stakeholders to deliver measurable outcomes. Strong foundation in software development (Java, Spring Boot, Angular, SQL) combined with PMO and stakeholder engagement capabilities. Passionate about leveraging technology to solve business challenges, drive efficiency, and support strategic decision-making.

• Microsoft Power BI, Udemy
• Data Analytics Certification, Udemy
• Frontend Development, Udemy
• Software Testing Simple (QA) & Foundation of Agile Software Testing Code Camp
• Responsive Web Design, Udemy
• Two-Tier ERP with SAP S/4HANA Cloud, Code Camp
• Generative AI at SAP, OpenSAP
• SAP Debugging for Functional Consultants, OpenSAP
• SAP Material Management for Beginners, Udemy
• CCNA 7: Switching, Routing, and Wireless Essentials, Cisco Netacad

• Hindi
• English
• French

• Date of Birth: 07/24/2000
• Nationality: Indian

• Sales Performance Dashboard | Power BI

Concept: Built an end-to-end Power BI dashboard to track revenue, profit, and region-wise performance.

Objective: Used DAX to calculate YoY growth, running totals, and targets vs actuals.

Benefit: Improved decision-making speed by providing real-time insights.

• Vehicle Insurance Management System

Concept: Designed and implemented a comprehensive Vehicle Insurance Management System.

Objective: Enabled users to create, update, and view policies; implemented premium calculation based on vehicle type, age, and coverage; developed claim submission and approval module.

Benefit: Delivered a fully functional prototype that streamlined operations and improved data accuracy. Tech Stack: Java, Spring Boot, Angular, MySQL

• Music Recommendation System (ML Project)

Concept: Built a machine learning-based music recommendation system using user preferences.

Objective: Provided personalized music suggestions and enhanced user experience.

Benefit: Improved recommendation accuracy and user engagement.

• E-commerce Food Ordering Web App

Concept: Developed a full-stack food ordering platform.

Objective: Enabled users to browse, order, and track food online.

Benefit: Delivered a responsive, user-friendly platform ensuring smooth performance.

Project Team Lead,  Manipal University, Jaipur    Mar. 2023 to June 2023    

• Organize and lead project meetings, ensuring clear communication and alignment among team members.
• Created a personal portfolio website showcasing projects, skills, and resume using HTML/CSS and JavaScript, java and C++.
• Optimized the website for mobile responsiveness and cross-browser compatibility.

Managing and Organizing Head, Manipal University, Jaipur    Sept. 2022 to Oct. 2022    

• Coordinated and executed university cultural fest,collaborating closely with various event teams for seamless execution and successful outcomes.
• Successfully organized and managed 4-week inter-college tech-competitions, overseeing logistics and ensuring smooth execution of cultural fest.
• Raised a Significant Funding of INR 40,000 for the Successful Execution of fest, ensuring accuracy and compliance with established protocols.

 Head Girl, Delhi Public School, Karnal    Apr. 2017 to Mar. 2018    

• Distinguished service as Head Girl, exemplifying exceptional leadership qualities and fostering a positive school environment.
• Led team of 20 prefects, overseeing various responsibilities including addressing student concerns, coordinating school events, and maintaining discipline.

• Microsoft Engage Mentee '23 - Built a facial recognition prototype and chaired sessions.
• Participated in hackathons and coding competitions.
• Active participant in technical events and workshops.