MD OSAMA ALI

Detail-oriented Finance Data Analyst with expertise in transforming complex financial data into actionable insights. Proficient in Python, SQL, and Power BI for building predictive models and automating reporting processes. Combines technical skills with a strong understanding of financial principles to address business challenges effectively. Experienced in developing full-stack web applications using Django to operationalize data models and analytics.

• Google Data Analytics Professional Certificate, Coursera, In Progress
• SQL for Data Science, University of California, Davis on Coursera
• Python for Data Science and Machine Learning, Kaggle Micro-Course

• Secured a top 10% ranking in a Kaggle competition for predicting customer sales.
• Recognized by faculty for excellence in a capstone project involving the development of a financial data analysis pipeline.

Financial Performance Dashboard | Power BI, SQL

• Developed an interactive Power BI dashboard to track company financial health, visualizing KPIs including ROI, Net Profit Margin, and Customer Acquisition Cost
• Automated data extraction and transformation using complex SQL queries, reducing manual reporting time by 40%
• Enabled identification of 15% cost-saving opportunities in underperforming product lines through dynamic filtering capabilities

Stock Market Trend Analysis & Portfolio Optimization | Python (Pandas, NumPy, Matplotlib)

• Analyzed 5+ years of historical data for 50+ NSE-listed stocks to identify sector performance and volatility patterns
• Engineered financial metrics including moving averages and Sharpe Ratios to quantify risk-adjusted returns
• Delivered data-backed recommendations for a model portfolio with 22% higher projected return versus benchmark

Financial Data Portal with Django | Django, Python, SQL, HTML/CSS

• Designed and developed full-stack web application to serve financial reports and analytical model results to stakeholders
• Built secure RESTful backend with Django to process and serve analytical data from SQL database
• Created dynamic front-end templates displaying interactive charts and KPIs for company-wide data accessibility

Predictive Sales Forecasting Model | Python, Excel

• Built and trained linear regression model to forecast quarterly sales using market and internal features
• Improved model forecast accuracy by 18% through comprehensive data cleaning and feature engineering
• Integrated results into Excel reporting for stakeholder use in inventory and budget planning