Skills: SQL (SQL Server, MySQL), Python (Pandas, NumPy, MatPlotLib), Advanced Excel (VLOOKUP, Conditional Formatting, Pivot Tables), Microsoft Power BI, Data Analysis, Data Visualization, Statistical Analysis, Problem-solving, Communication.
Certifications & Badges: Advance SQL (Kaggle), Python (Kaggle), Business Analytics (Simplilearn), Data Science (Internshala Trainings – Analytics Vidhya), Passed Linkedin Assessment Tests (MySQL, Python, Excel, Power Bi, Power Point).
Portfolio Samples:
1. SALES INSIGHTS – BRICK & MORTAR BUSINESS – [POWER BI | SQL] April 2023: Designed a Power BI dashboard to understand AtliQ hardware goods sales trend. The dashboard effectively displayed the sales trend of AtliQ hardware, enabling users to make informed decisions. It has the potential to increase revenue by at least 7% in the next quarter.
2. DATA PROFESSIONAL SURVEY BREAKDOWN – SURVEY INSIGHTS – [POWER BI] April 2023: Developed a Microsoft Power BI dashboard that analyzed survey data related to data professionals. Created interactive and insightful features, including Average Salary by Job Title and Average Age of Survey Takers.
3. KEY MATRICES FOR FINANCIAL SUCCESS – Personal Project – [POWER BI] March 2023: Developed a Power BI dashboard providing insights on financial performance metrics for sample business data. Analyzed financial data to evaluate business health and identified areas for improvement.
4. DYNAMICS OF BIKE SALES MARKET – Automobile Business – [Excel] March 2023: Created various metrics to analyze customer behavior in an automobile business. Developed an Excel dashboard providing insights on customer demographics and purchasing behavior.
Education: BACHELOR OF SCIENCE IN MATHEMATICS | June 2021 - 2024 Majors: Probability Theory, Statistical Inference
As a skilled Data Analyst/Business Analyst, I bring expertise in SQL, Python, Advanced Excel, and Microsoft Power BI. With a proven track record in data analysis, visualization, and problem-solving, I am well-equipped to derive valuable insights from complex datasets. I have successfully completed relevant certifications and have a portfolio showcasing my projects and their impact. I am ready to demonstrate my skills and provide work samples to highlight my capabilities. Please feel free to reach out to discuss how I can contribute to your organization's data-driven success.
Subjects
Python Beginner-Expert
SQL Beginner-Expert
Data Science Beginner-Expert
MS Excel Beginner-Expert
Power BI dashboard Beginner-Expert
Experience
No experience mentioned.
Education
Bachelor of Science (Jul, 2021–now) from Brahmanand PG College Kanpur