Anudeep Reddy
Summary
7+ years of experience in Data analysis, Data modeling,Reporting and Business Intelligence using SQL and Powerbi. Skilled in statistical analysis, predictive modeling, and data visualization techniques. Excel in problem-solving, critical thinking, and effective communication to interpret complex data insights into actionable strategies. Committed to leveraging analytical skills and collaborative approach to drive business decisions and outcomes.
Overview
8
8
years of professional experience
Work History
Sr. Data Analyst
Flagstar Bank
Troy, MI
07.2023 - Current
- As part of the DNA Merger team responsible for ensuring the correctness and completeness of data migration efforts from Flagstar to NYCB.
- Lead data migration efforts of the Fiserv DNA application, including both the transactional database (OLTP) and the analytical database (OLAP).
- Worked on analyzing and comparing over 400 OLTP tables and more than 50 LAP tables.
- Developed complex SQL queries to analyze large datasets for trends and insights.
- Regularly gather feedback from stakeholders, and make improvements to the reports.
- Conducted ad-hoc analysis using MySQL queries to guarantee data quality across various dimensions such as Accuracy, Completeness, Consistency, Orderliness, Timeliness, and Uniqueness.
- Carried out data quality checks and validation processes to ensure the integrity of the data stored in the warehouse.
- Monitored the performance of deployed reports, and troubleshot and resolved any issues that arose.
- Generated periodic reports based on statistical data analysis from various time frames and divisions using Power Pivot, Power Query, and Power View.
- Designed Power BI graphical and visualization solutions, with business requirement documents and plans for creating interactive dashboards.
- Detected data discrepancies, collaborated with internal teams to determine root causes, and formulated, executed, and automated general data quality regulations for new and existing data sources.
- Optimized test plans and cases by collaborating with the quality assurance team to prioritize testing efforts.
- Developed and implemented data cleansing and formatting processes to secure data accuracy and consistency.
- Skilled in creating and working with pivot tables in Excel to summarize and analyze large data sets.
- Maintained detailed documentation on all projects and requests to capture insights gained from data.
- Conducted regular reviews with the development team to prevent defects.
Data Analyst
Heal360
Frisco, USA
01.2022 - 05.2023
- Collected, organized, and cleaned healthcare data from various sources, ensuring accuracy, completeness, and consistency.
- Applied statistical and analytical techniques to identify trends, patterns, and relationships in healthcare data, providing insights for decision-making.
- Designed and implemented data models to support reporting needs.
- Maintained or updated business intelligence tools, databases or dashboards
- Extracted data from various sources, such as databases, spreadsheets, and external systems.
- Identified or monitored current and potential customers using business intelligence tools.
- Created data models, schemas, and relationships within the data warehouse.
- Familiar with healthcare trends, emerging issues, and future needs to inform strategic planning and resource allocation.
- Generated regular reports and summaries to communicate findings and insights to stakeholders, including recommendations for action.
- Analyzed data to identify root causes of problems, and recommend corrective actions.
- Supported initiatives for data integrity and normalization.
- Designed and developed data pipelines to acquire, clean, and process data.
- Uphold HIPAA regulations and standards for protecting patient information.
- Secured confidential patient information from unauthorized access.
Financial Data Analyst
Metrics4 Analytics
Hyderabad, India
05.2017 - 12.2021
- Performed research on public companies listed in the U.S.
- Ensure data quality by cleaning and transforming data as needed, using SQL or other ETL tools.
- Performed research on over 100 corporate events, including M&A, IPOs, earnings, Corporate Finance, Management Changes, and Corporate Governance.
- Utilized ETL/ELT processes, data analysis, and Power BI to ensure data accuracy and completeness, creating various chart types, including pie charts, bar charts, tree maps, circle views, line charts, area charts, scatter plots, and slicers.
- Ensured the accuracy of data entered in the proprietary data platform.
- Incorporate relevant market data into forecasting models.
- Conducted an in-depth analysis of alternative financial data, including Dividend, Guidance, Share Repurchase, Earnings Release reports, and Earnings Calendars, using various data sources and analytical techniques.
- Captured corporate action analysis and feed news for investors.
- Transformed raw data to ensure accuracy and consistency.
- Reviewed the financial statements analysis to group the data and analyze.
- Identified and categorized vital corporate and market events from unstructured company disclosures.
- Utilized financial analysis to prepare plans of action for investment.
- Researched economic indicators to understand their impact on investments decisions.
Education
Masters - Finance
Institute of Public Enterprise
Hyderabad, India01.2019
Bachelor of Business Management -
Loyola Academy
Hyderabad, India01.2017
Skills
- SQL
- DAX
- Dimensional data modeling
- Power BI
- ETL
- Microsoft 365
- Business Analysis
- Data Manipulation
- Data analysis
- Data Validation
- Agile
- Microsoft Visio
Timeline
Sr. Data Analyst
Flagstar Bank
07.2023 - Current
Data Analyst
Heal360
01.2022 - 05.2023
Financial Data Analyst
Metrics4 Analytics
05.2017 - 12.2021
Masters - Finance
Institute of Public Enterprise
Bachelor of Business Management -
Loyola Academy