Summary
Work History
Education
Skills
Accomplishments
LEARNING & PROFESSIONAL DEVELOPMENT
Websites
3d
OMKAR SAWANT

OMKAR SAWANT

Pune

Summary

Aspiring Data Analyst with hands-on experience in Python, SQL, and Power BI seeking to leverage analytical skills, self-learning ability, and practical project experience in a data-driven organization.

Work History

Private Investor

Self-employeed
07.2023 - Current
  • Analyzed historical NIFTY 50 stock data to identify trends, patterns, and price movements
  • Designed and back tested trading strategies using technical indicators on historical datasets
  • Tracked portfolio performance and developed strong analytical thinking, pattern recognition, and data-driven decision-making skills

Sales Consultant

Honda Motors
08.2022 - 06.2023
  • Company Overview: (Dealership closed due to code expiry - all employees laid off)
  • Achieved excellent sales performance with consistently positive customer feedback and ratings
  • Maintained comprehensive customer databases and analyzed buying patterns for strategic insights
  • Advised clients on appropriate product selections based on their unique needs, ensuring optimal satisfaction levels upon purchase.
  • Utilized customer data analytics to improve sales strategies and customer satisfaction

Education

Bachelor of Arts - Political Science

Modern College of Arts, Science & Commerce
Pune
07.2017 - 07.2019

Skills

Programming Languages: Python (Pandas, NumPy, Matplotlib, Seaborn) & SQL (Queries, Joins, Window Functions)

Data Visualization: Power BI, Microsoft Excel (Pivot Tables, Power Query, Charts, Formulas)

Data Analytics Techniques: Data Cleaning, Data Wrangling, ETL Processes, Statistical Analysis

Soft Skills: Analytical Thinking, Problem-Solving, Critical Thinking, Research, Self-Learning

Accomplishments

1. Stock Price Analysis Dashboard (Power BI)
  • Analyzed comprehensive 5-year historical data for 10 Nifty 50 stocks using Python and Power BI
  • Implemented advanced technical indicators including RSI, Annualized Volatility, and CAGR calculations
  • Demonstrated investment strategies achieving returns above 50% over 5-year investment period
  • Created interactive dashboard showcasing optimal entry points and long-term investment benefits
  • Developed scenario analysis models showing potential returns for ₹1 lakh initial investment


2. HR Analytics Dashboard (Power BI)
  • Developed comprehensive HR analytics dashboard tracking key performance indicators and metrics
  • Analyzed employee attrition rates across different salary slabs, tenure, and demographic segments
  • Created detailed visualizations for gender-based role distribution across various departments
  • Implemented advanced Power BI features for interactive data exploration and drill-down analysis.

LEARNING & PROFESSIONAL DEVELOPMENT

  • Self-taught data analysis and programming through comprehensive online resources and practical application
  • Completed multiple free courses in data analytics, statistical analysis, and data visualization
  • Planning to complete Google Data Analytics Professional Certificate for advanced certification
  • Continuous learning in Python programming, SQL database management, and statistical analysis methods


Websites

Similar Profiles

CREATE PROFILE
OMKAR SAWANT