Data Analyst Business Intelligence

Aditya Chandolu DataAnalyst

******@***********.*** I 260-***-**** I USA I J.i edl.!l

Summary

Results-driven Data Analyst with 3+ years of eKpertise in data analysis, statistical modeling, and business intelligence. Skilled in Python, SQL, Power Bl, and Tableau to extract Insights and support data-drrven decision-making. Experienced In data preprocessing, visualization, and reporting to improve business processes and optimize performance. Adept at performing statistical analysis, SWOT analysis, and building automated dashboards to enhance operational efficiency. Strong focus on ensuring data accuracy and delivering actionable insights across various industries.

Technical Skills

Prosrammlna Lan111aps: Python (Pandas, NumPy, Matplotlib, SciPy, TextBlob, Gensim), SQL (Joins, Subqueries, Window Functions, CTE), R (dplyr, ggplot2), JavaScript (for data visualization) Data VlsuaHzatlon: Power Bl (Dynamic Slicers, Custom Visuals), Tableau (Filters, Parameters, Calculated Fields), Looker, Google Data Studio

• Statistical Anatysls: Hypothesis Testing, Correlation Anatysis, Regression Modeling, A/8 Testing, Time Series Analys.is Data Manapment a Ell: Data Preprocessing, Data Cleaning, Data Transformation, Ell Pipelines, Data Integration Data Warehousln1: AWS Redshift, Azure SQL Database, Google BigQuery, Snowflake Reportln& & Automation: Excel (Pivot Tables, VLOOKUP, Conditional Formatting, Macros), Google Sheets (Scripting, Advanced Functions)

• Compliance & Standards: HIPAA Compliance, GDPA, Data Governance Principles Professional Experience

Data Analyst, HSBC 01/2024 - Present I Remote, USA

• Collected and anatyzed market data using Python's TextBlob and Gensim libraries for sentiment analysis. Identified a 15% increase In stock volatility following negative sentiment In earnings reports, providing actionable Insights for market prediction.

• Conducted SWOT analysis using Python's Pandas and Matplotlib for data visualization. Analyzed financial metrics and identified a 20% improvement in ROI by leveraging internal strengths, leading to more focused investment strategies for key stakeholders. Utilized SQL's Window Functions and CTE (Common Table Expressions) to eKtract key metrics and generate financial reports, improving report generation speed by 30%. This approach streamlined financial reporting and allowed for deeper trend analysis. Performed SWOT analysis on business performance metrics, using its features to assess internal factors like financial stability and external factors like market competition. Identified a 25% opportunity for market expansion by capitalizing on underutilized assets.

• Conducted correlation analysis using Python's SciPy library, measuring relationships between financial variables like revenue and market share. Found a strong positive correlation of 80% between marketing spend and customer acquisition, enhancing predictive modeling accuracy.

Designed a Power Bl dashboard with dynamic slicers, custom visuals, and data validation techniques (such as distinct count checks). Validated data accuracy, reducing reporting errors by IS", and provided stakeholders with real•time financial insights. Data Analyst, Evernorth Health Services 01/2020 - 12/2022 I Hyderabad, India

• Gathered, preprocessed, and cleaned structured/unstructured healthcare EHR data using Python and SQL, improving data accuracy by 30%. Ensured data quality by handling missing values, duplicates, and inconsistencies for reliable analysis and decision--making.

• Wrote complex SQL queries using Joins, Subqueries, and Window Functions to anatyze patient readmission trends, reducing query execution time by 40% and optimizing healthcare reporting efficiency. Used Python libraries such as Pandas, NumPy, and Matplotlib to perform data manipulation, statistical analysis, and visualizattOn, increasing data processing efficiency by 35% and ensuring accurate insights into patient readmission rates.

• Conducted statistical analysis using hypothesis testinL correlation analysis, and regression modeling, identifying key factors contributing to 20% of patient readmissions and evaluating the effectiveness of treatment plans.

• Created automated Excel reports using Pivot Tables, VLOOKUP, and Conditional Formatting, reducing manual reporting efforts by 50% and improving hospital performance tracking.

Performed data validatton by cross·checking records, implementing integrity constraints, and ensuring compliance with HIPAA standards to maintain data accuracy and reliability in healthcare reporting. Designed interactive Tableau dashboards using Filters, Parameters. and Calculated Fields to visualize patient readmission patterns, leading to 25" faster decision•making for hospital administrators. Masttt of Sdfttce, Indiana Institute of Technology Information Systems

Education

Fort Wayne, IN, USA

01/2023 - 10/2024

Contact this candidate