P. ABDULLA
Summary
Highly motivated and analytical professional with a passion for data analysis and visualization. Proven ability to transform raw data into actionable insights using Python, SQL, Power BI, and Excel. Experience in cloud infrastructure management and a strong desire to leverage data analysis skills to drive business growth.
Overview
1
1
year of professional experience
Work History
Cloud Engineer - Intern
Mentornix Consultancy PVT LTD
Mohali, India
08.2024 - Current
- Set up virtual machines, networks, and storage solutions.
- Managed cloud security and compliance.
- Learned about cloud-native tools like Docker and Kubernetes.
- Scripted and automated processes using Terraform, Ansible, and Python.
Data Analyst
Ai Variant
Bengaluru, India
08.2023 - 02.2024
- Analyzed and visualized data using advanced features of Microsoft Excel
- Created insightful and interactive data dashboards with Power BI and Tableau
- Gained hands-on experience in interpreting and presenting data.
Education
Bachelor of Computer Application - Big Data With Cloud Computing
BCA
01-2023
Skills
- Programming Languages: Python (Data Structures, Functions, NumPy, Pandas, Matplotlib, Dash, Scikit-learn, Seaborn)
- Databases: SQL (Reports, Merge, Group, Joins, Functions, Data Modeling, Query Optimization, Time Series Analysis)
- Data Visualization: Power BI (ETL, Data Modeling, DAX, Scheduled Refresh, RLS, Reports, Dashboards), Excel (Pivot Tables, Charts, Lookups, Forecasting, Power Query, Power Pivot, Automation, Macros, VBA)
- Cloud Technologies: AWS (EC2, S3, RDS, Lambda, VPC, Docker, Terraform, Kubernetes, CI/CD, Git, GitHub, IAM, Bash)
Certifications
- Data Analyst
- Data Visualization
- Statistics for Machine Learning
- Python Fundamentals for Beginners
- Database Management System
- Career Essentials in Generative AI
- Career Essentials in Data Analysis
Projects
Power BI: Online Sales Stores
- Developed a Power BI dashboard with tables, bar, and line charts to track performance across 50 counties and 200+ salespersons (2019-2021).
- Implemented dynamic filtering and DAX measures for total sales, profit, top 5 performer metrics, quarterly trends, and cost-sales-profit comparisons.
- Boosted decision-making with insights, increasing accuracy by 15%.
Power BI: Adidas Store Sales
- Visualized sales by retailers, regions, and monthly trends using bar charts, maps, and line charts.
- Key metrics: Sales (900M) and Profit (332M).
- Revealed online channels outperforming in-store by 30%.
- Uncovered an 8% MoM growth.
- Optimized DAX for calculations and filters for years and sales channels.
Excel: Hotel Booking Analysis Dashboard
- Evaluated booking patterns; cluster chart revealed a 25% increase in weekend stays.
- Compared bookings: City vs. Resort, showing 60% more cancellations in resorts.
- Displayed booking and cancellation data monthly via a column chart.
- Compared city and resort bookings and cancellations using a pie chart.
- Enhanced filtering with 3 slicers for customized views.
Excel: Analysis of the Online Store Annual Report
- Designed a dashboard from 10,000+ data entries.
- Reviewed sales reports, processing 1,000+ transactions.
- Found top 5 sales states, inspected orders by age group, and generated annual reports.
- Formed monthly sales charts and assessed trends by gender and channel.
- Key Insights: March-June sales peaked in Maharashtra, Karnataka, and UP. The 25-year-old age group preferred Amazon, Myntra, and Flipkart.
Timeline
Cloud Engineer - Intern
Mentornix Consultancy PVT LTD
08.2024 - Current
Data Analyst
Ai Variant
08.2023 - 02.2024
Bachelor of Computer Application - Big Data With Cloud Computing
BCA
Similar Profiles
Akhilesh BishtAkhilesh Bisht
Internship as a Frontend Developer at Mentornix Consultancy PVT LTDInternship as a Frontend Developer at Mentornix Consultancy PVT LTD
Mahati PonnadaMahati Ponnada
Business Analytics Intern at Mentornix Consultancy Pvt LtdBusiness Analytics Intern at Mentornix Consultancy Pvt Ltd
Mohammed Umer Mohammed Zafer DeshmukhMohammed Umer Mohammed Zafer Deshmukh
Intern at MentornixIntern at Mentornix