Saman Sai Prakash Mallick
Management Student
Jharsuguda,Odisha
Summary
- Proactive learner and hands-on intern, passionate about staying ahead in the digital landscape and gaining practical experience through internships.
- Experienced in international business projects, including a business analyst project with Canon Middle East in Dubai, where I conducted a digital marketing analysis to assess customer awareness of their products beyond cameras.
- Proficient in data visualization and business intelligence, with demonstrated expertise in using tools like Power BI and Tableau for insightful analysis and visualization of data.
- Skilled in process optimization and automation, streamlining workflows and implementing automation techniques for efficient operations.
- A data collection, query, and pattern recognition wizard, capable of gathering precise insights, extracting valuable information, and identifying trends for strategic decision-making.
- Familiar with SQL and proficient in data queries, capable of handling complex data queries and extracting valuable information using SQL.
- Currently pursuing an MBA with a specialization in business analytics, conducting research on customer purchasing intention towards electric two-wheelers in India, Taiwan, and Indonesia, leveraging skills in business intelligence tools, data query, and ETL techniques to analyze real-time data and derive customer-centric solutions.
Overview
1
1
year of professional experience
4
4
Certifications
Work History
Finance Intern
Mahanadi Coalfield Limited (MCL)
6 2022 - 7 2022
- Acquired foundational knowledge in finance
- Implemented finance skills in SAP and Excel, gaining hands-on experience in financial analysis and management.
Internship
My captain
05.2023 - 07.2023
- Engaged in marketing, business development, and HR tasks from home
- Learned to forge connections, gather data, and analyze it for strategic decision making
- Actively promoted organization courses and services to target audiences, fostering growth and engagement.
Business Analyst - Intern
Skill Academy by Textbook
09.2023 - 10.2023
- Handling and processing datasets for analysis using various tools
- Applying diverse analytical techniques to extract insights
- Creating visually appealing and informative dashboards to present analytical findings
- Applying learned skills and techniques to real-world datasets for actionable insights.
Research intern
National Formosa University
03.2024 - Current
- Investigating customer behavior in electric two-wheeler purchases
- Designing surveys to gather insights from potential buyers
- Gathering information from respondents and sources
- Implementing automation and ETL techniques for efficient data handling and analysis
- Developing visual representation of data to facilitate easy understanding and decision making.
Education
MBA - Business Management
Chandigarh University
04.2001 -
BBA - Business Management
Siksha 'O' Anusandhan(IBCS)
Bhubaneswar 04.2001 -
Skills
Power BI
MS Excel
Tableau
SQL
Data queries
Automation
ETL(Extract, Transform, Load)
Pattern recognition
KPI Tracking
Requirements Gathering
SWOT Analysis
Intelligence Analysis
Certification
Business Analytics Course by Textbook - Certified in Power BI, Excel, SQL, Agile Methodology, Tableau, and Python.
Projects
E-Commerce database Analyzes:
- Analyzing the E-commerce sales of a company.
- Finding the sales, a sum of the amount by state, profit by sub-category, profit by month, and quantity by payment mode.
- https://drive.google.com/file/d/18OPtVbXx9pWETPEYH7hssgN1ca189kQe/view?usp=drive_link
Covide19 Dashboard:
- Analyzing the COVID-19 data.
- Finding the active cases, death cases, recovery cases, and weekly cases percentage.
- https://drive.google.com/file/d/1vdcphvh7RLDpdn7oBGeKceHPiSLRNvYx/view?usp=drive_link
Business Analytics project with Heriot Watt University (Dubai):
- Digital marketing and analytics skills learning.
- Doing a business analysis project for Canon and learning various marketing and analytics skills.
- Got a chance to pitch that report in front of Canon executives.
- https://docs.google.com/presentation/d/1nEZDz9v9Z6Yx8aGASs0wzcjpOyC7um8k/edit?usp=drive_link&ouid=111973666552271232185&rtpof=true&sd=true
Timeline
Research intern
National Formosa University
03.2024 - Current
Business Analyst - Intern
Skill Academy by Textbook
09.2023 - 10.2023
Internship
My captain
05.2023 - 07.2023
MBA - Business Management
Chandigarh University
04.2001 -
BBA - Business Management
Siksha 'O' Anusandhan(IBCS)
04.2001 -
Finance Intern
Mahanadi Coalfield Limited (MCL)
6 2022 - 7 2022