Rafeek
Jodhpur
Summary
Eager to apply my data analysis skills in a dynamic environment. Skilled in SQL, Python, and data visualization. Aspiring to contribute to data-driven decision-making processes and eager to develop further in data analytics.
Overview
1
1
Certification
Work History
Data Analyst
- Produced monthly reports using advanced Excel spreadsheet functions.
- Utilized data visualization tools to effectively communicate business insights.
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
- Improved decision-making processes with accurate data analysis and visualization techniques.
Education
Bachelor of Technology in Mechanical Engineering -
Lovely Professional University
Skills
- SQL
- Python
- Data Visualization
- Microsoft Excel
- Business Intelligence
- Data Analysis
- Report Generation
- Data Management
- Power BI
- Data Modeling
- Data analyzing
- Analytical Thinking
- Effective Communication
- Data Cleaning
- SQL Databases
- Data Validation
- ETL processes
- Team Collaboration
Certification
- Advanced SQL for Data Analysis
- Power BI Hands-On Power BI Training
- Data analysis with python
- Data Visualization with Python
- Microsoft Excel Business Intelligence w Power Query & DAX
Languages
Hindi
English
Passions
- Data-Driven Storytelling
- Continuous Learning
Projects
Hotels Booking Cancellations
- Conducted a data-driven exploration(EDA),proposing revenue-boosting strategies by analyzing cancellation influences.
- Executed data cleaning and transformation techniques, ensuring insight reliability ,addressing null and missing values and optimizing usages for a 30% improvement in data quality.
- Generate actionable insights and Generate actionable insights and recommendations to support strategic decision - making and business growth.
Music Store Data Analysis
- Utilize SQL and other query languages to retrieve data from various databases ,data warehouses and data sources.
- Implemented data validation techniques and null values handling strategies to ensure dataset accuracy and integrity.
- Applied advanced table joins ,leading to the extraction of valuable insights and showcasing a deep understanding of database structure and relationships.
Credit Card Financial Dashboard
- Analyzed Credit card data to identify trends and patterns to improve data accessibility and understanding creating above KPIs for analysis. Creating Key Performance Indicator such as Total Revenue 55M,Total Interest(7.84M,Total transaction amount(45M),Customer satisfaction score 3.19 etc. which has impact and resulted in a remarkable improvement in the over all standard of financial report.
- Crafting a customize Dashboard to leveraging insightful data analysis to optimize transaction and customer behavior.
Timeline
Data Analyst
Bachelor of Technology in Mechanical Engineering -
Lovely Professional University