Data Analyst Financial

BHAGYASHRI DUSTAKAR

FINANCIAL DATA ANALYST

LinkedIn *****************@*****.*** 201-***-**** West Haven, CT, USA PROFESSIONAL SUMMARY

Financial Data Analyst with around 4 years of experience blending financial analysis and data analytics to drive business insights and performance across diverse industries, including REITs, technology, renewable energy, and healthcare. Holds a Master’s in Finance and Financial Analytics, and possesses proficiency in key data analytics tools like Python, SQL, Power BI, and Excel. Experienced in data modeling, data cleaning, advanced statistical analysis, and data visualization to deliver actionable insights and optimize decision-making processes. Proven track record in financial modeling, forecasting, and automation of business processes to improve efficiency and accuracy. EMPLOYMENT HISTORY

Financial Data Analyst Liberty Mutual Insurance May 2024 – Present

● Developed and implemented automated ETL pipelines, significantly reducing manual data processing efforts and enabling the team to focus on higher-value tasks.

● Provide insights on budget forecasts, claims analysis, underwriting trends, and operational costs.

● Designed and deployed interactive dashboards that provided real-time data insights, supporting leadership in making data-driven decisions and improving forecasting accuracy.

● Optimized data processing and query performance by implementing partitioning and bucketing strategies, leading to faster data retrieval for real-time analysis.

● Streamlined data workflows, reducing manual data handling and improving overall operational efficiency, allowing more focus on strategic initiatives.

Financial Data Analyst Tata Consultancy Services Mar 2020 – Jul 2022

● Led data analytics efforts, cleaning and transforming raw financial data from sources (10-K, 10-Q, 8-K filings, earnings reports) to create structured data for analysis, resulting in an 80% improvement in the accuracy of investor insights.

● Developed advanced data models for over 100 companies across sectors, using statistical tools in Python and Excel to generate predictive insights and visualize complex data trends.

● Performed comprehensive data analysis on company financials, revenue projections, and cost structures, providing management with actionable insights that supported business decisions.

● Conceptualized SQL to extract data from databases and perform complex queries for segment analysis, ensuring seamless integration of datasets for financial forecasting.

● Optimized data entry and validation processes for over 100,000 financial records, ensuring accurate and timely updates to the bank’s financial database.

● Applied data quality assurance techniques to detect discrepancies, clean datasets, and improve the integrity of financial information used for reporting.

● Produced detailed reports on financial performance and customer metrics using Excel and specialized software, ensuring data was formatted for accurate analysis.

Data Analyst Independent Consultant Mar 2019 – Mar 2020

● Facilitated in streamlining data management processes for clients, including cleaning, validating, and migrating financial data to improve reporting accuracy.

● Implemented data-driven insights and reporting solutions for small businesses, enabling to make informed financial decisions.

● Designed ad-hoc data dashboards to visualize and monitor key performance indicators for client business operations. ACADEMIC PROJECTS

Capstone Project: Netflix Strategic Equity Analysis: A Strategic Analysis in Financial Evolution Jan 2024 – Apr 2024

● Performed advanced data analysis using Excel to clean and transform large datasets for valuation analysis, employing techniques like regression analysis, data sorting, and financial ratio analysis.

● Applied the Discounted Cash Flow (DCF) model and used Python for statistical analysis, determining stock valuation and identifying the primary drivers behind Netflix's market price.

● Visualized financial trends with stacked and clustered bar charts and pie charts in Excel, improving accuracy by 15% through rigorous data cleaning and validation.

● Prepared a financial forecasting model based on historical data trends and risk analysis EDUCATION

Master’s in Finance and Financial Analytics, University of New Haven Aug 2022 – May 2024 Bachelors in HR, Management Studies, University of Mumbai Aug 2016 – Mar 2019 TECHNICAL SKILLS

Programming & Data Analysis Tools: Python, SQL, R, Power BI, FactSet, Advanced Excel (VLOOKUP, PIVOT, XLOOKUP, Regression), Jupyter Notebooks

Data Management & Transformation: Data Cleansing, Data Validation, Data Migration, Data Modeling, Statistical Analysis, Data Wrangling Financial & Analytical Tools: Bloomberg Terminal, SAP Products, Microsoft Dynamics, Workday Financials, QuickBooks, Hyperion Project Management & Collaboration: JIRA, Microsoft Co-Pilot Data Visualization & Reporting: Power BI, Tableau, Excel, Data Dashboards, Report Automation Business & Financial Tools: Excel (Advanced), MS Office Suite (Excel, PowerPoint, Visio), SAP, MS Power BI

Contact this candidate