Menu
Data Driven Decisions

Ashwani Mittal

Data Analysis Machine Learning Storytelling & Dashboarding Financial Modeling

Learn more
About Me

Using data to discover the unknowns!

Profile Picture

I work on breaking complicated business problems into simple components and apply advanced analytics to generate actionable insights.
A graduate of the MS in Financial Technology & Analytics program from University of Texas - Dallas. I have undertaken projects in Dashboarding, Causal Analytics, Machine Learning, Root Cause Analysis, Statistical Analysis, Credit Risk Analytics, Data Validation and Database Management.

Tools:
SQL, Python, Tableau, PowerBI, Excel, AWS, PowerPoint

Techniques:
Predictive Modeling, Exploratory Analysis, Statistical Analysis, Time Series Forecasting, A/B testing, Data Visualization, Big Data, Deployment Testing,
Scrum & Agile methodologies, Credit Risk Modeling, Data Validation, Financial Modeling, Data Analysis

Profile

  • Full Name: Ashwani Anil Mittal
  • Job: Financial Analyst / Business Intelligence Analyst / Data Analyst
  • Email: ashwani2697@gmail.com

Skills

  • SQL
  • Python,Numpy, Pandas
  • Hadoop, Spark, AWS
  • Tableau, PowerBI
  • Data Modeling, Finance
  • Project Management
  • Financial Reporting
Additional Info


Services

What do I have to offer?

I optimize processes using data!

Experienced in analyzing large sets of data to design and develop data systems and reporting tools to ensure that the business and clients team members have the product, support, and operations data needed to make crucial business decisions. I have also had the opportunity to create coplex financial models to generate portfolio recommendations for clients to invest in the Equities and Derivatives Market.

10000

hours of education

12

Data Science Projects

19

Dashboards Created

15

Tool & Techniques known

4

Years of Experience

1000

Cups of Tea
Portfolio

What have I been up to lately?

Look here for a collection of my latests projects, articles, and more.

Img via Pixabay

SEC Filing Analysis

Created a comprehensive SQL database of firms that filed 10-Ks with the SEC in FY 2023 and analyzed the filings to extract data on Supplier finance program participation and obligations disclosed under ASU 2022-04.
Img via Pixabay

Advanced Machine Learning

Automated running of multiple Machine learning algorithms and compare their performance in predicting loan default.
Img via Pixabay

Storytelling and Visualizations

Have worked on making interactive visualisations for client.
Experienced in working on identifying patterns in data and use them to unearth the unknown unknowns of the data generation process.
Image via Pixabay

Find me on GitHub

My repositories
Resume

More of my credentials.

Download Resume

Work Experience

Financial Analyst Intern

June 2024 - August 2024

UTDSOM Investment Corporation

• Developed automated SEC filing parser using python to scrape and parse 10-K filings and metadata of over 5000 firms to create a database for FY2023
• Analyzed participation of firms in reverse factoring and details of their disclosed obligations under ASU 2022-04 using Natural Language Processing
• Created a SQL Database of over 5000 firms and identified 67 firms that disclosed their reverse factoring obligations as per ASU 2022-04

Financial Analyst

January 2021 - August 2022

ATM Capital - India

• Conducted comprehensive analysis of stock market data using Excel, Python, and SQL, resulting in optimized data pipelines and actionable insights for portfolio management
• Implemented data cleansing, transformation, and aggregation processes, improving data quality and enabling more accurate financial modeling
• Collaborated closely with investment teams to understand data requirements and develop scalable solutions for portfolio analysis and risk management
• Designed algorithms and automated processes to analyze market trends and forecast investment opportunities, contributing to enhanced portfolio performance and risk mitigation
• Developed and implemented financial models using Python and SQL to provide strategic investment recommendations, leading to over $1M in annual brokerage revenue
• Created and maintained interactive dashboards using Tableau and Power BI, enabling stakeholders to visualize and interpret complex financial data effectively

Financial Data Analyst

April 2015 - June 2018

Sonal Gems - India


• Implemented a centralized vendor information system, enhancing data accuracy and retrieval efficiency by 15% through effective data integration strategies and automation using SQL and ETL tools
• Developed automated invoicing processes using Excel and SQL, reducing errors by 20% and speeding up processing time by 30%, ensuring seamless data flow and integrity
• Captured, validated, and processed data for monthly financial reports (P&L statements, balance sheets, cash flow statements) using advanced Excel and SQL, leading to a 10% increase in financial reporting efficiency.
• Assisted with analysis, design, and testing of report enhancements, contributing to a 15% increase in forecast accuracy
• Conducted trend analysis and presented findings through dashboards, aiding strategic decision-making, resulting in a 12% improvement in cost management and a 10% increase in market share.
• Analyzed customer purchasing behavior with Python & SQL, provided insights for marketing campaigns & increased customer retention by 8%
• Designed interactive dashboards in Tableau and Power BI to track KPIs, sales performance, and inventory levels, improving inventory turnover by 25% and providing actionable insights for operational efficiency.
• Created ad-hoc reports and visualizations for management, facilitating quick decision-making and resulting in a 15% increase in operational efficiency.

Education

University of Texas at Dallas

August 2022 - August 2024

Master of Science in Financial Technology & Analytics

UTD's Master of Science in Financial Technology & Analytics (MS Ftech) teaches students how to extract insights with creative data analysis, and then apply the results in real business settings. Students graduate with a unique combination of data science skills and business acumen to lead in an increasingly data-driven world.

Data Science & Analytics Courses:
* Statistics for Data Scientists
* Exploratory Data Analytics and Visualization
* Predictive Analytics
* Advanced Issues in Business Analytics
* Machine Learning
* Asset Pricing & Management

Technical Courses:
* Programming for Data Science
* Data Management, Databases, and Data Warehousing
* Big Data Analytics
* Cloud Computing
* Blockchain Technology

Veer Narmad South Gujarat University

August 2018 - May 2021

Bachelors of Computer Applications

The course is specifically designed to develop the logical and technical skills of students interested in computer science or industrial computing. The course helps in developing professional competence in software designing and its implementation. The institution values the importance of substantial infrastructure requirements and qualified faculties to run this highly professional course.

Where to find me

Seattle, WA
98121 USA

Email Me At
 (ashwani2697@gmail.com)

Call Me At

Phone: (564) 202 - 3121