Data Analyst Power Bi

AVANTIKA SINGH

Data Analyst SQL Python Power BI Excel 1 Year Experience

India *************@*****.*** 990-***-**** LinkedIn GitHub Professional Summary:

Detail-oriented Data Analyst with 1+ year of experience designing, automating, and optimizing data solutions that support business intelligence, reporting, and decision-making. Proficient in SQL, Python, Power BI, and Excel, with a strong understanding of data pipelines, ETL automation, statistical analysis, and dashboard development. Proven ability to translate complex datasets into meaningful insights for business stakeholders. Experienced in cross-functional collaboration, KPI development, and delivering real-time analytics for operational and strategic needs. Seeking to leverage technical expertise and business acumen to drive data-driven decisions in a fast-paced environment.

Technical Skills

• Languages & Databases: SQL (MS SQL Server), Python (Pandas, NumPy, SciPy), SQLite

• BI & Reporting Tools: Power BI (DAX, dashboards), Excel (Pivot Tables, VLOOKUP), Power Query, Seaborn, Matplotlib

• Data Analysis & Statistics: Hypothesis Testing, Regression, Confidence Intervals, Outlier Detection, Sampling, Descriptive Analytics

• Development & Automation: ETL Automation, Stored Procedures, BULK INSERT, Scripting

• Testing & QA: Data Validation, Unit Testing, Issue Debugging (SQL Profiler)

• Version Control & Tools: Git, GitHub, JIRA, Agile Sprint Planning Work Experience

INDIMINDS TECHNOLOGY LLP May 2024 – Present

Data Analyst Kolkata, India

• Implemented and managed high-volume SQL Server databases to support business data operations, improving data retrieval performance by 35% using advanced indexing and query optimization.

• Developed automated ETL pipelines using Python and BULK INSERT for data extraction, processing, and transformation of daily trading files; reduced manual effort by 60% and ensured data accuracy in ingestion workflows.

• Created advanced reporting logic using SQL (CTEs, window functions, subqueries) for operational KPI tracking and cross- functional business analysis.

• Developed FIFO-based SQL procedures to support financial reporting and profitability insights across departments.

• Utilized SQL Server Profiler to identify and fix query issues affecting data integrity and dashboard accuracy across reporting systems.

• Built and deployed interactive Power BI dashboards for stakeholder reporting, client segmentation, and performance analytics; applied data storytelling techniques to visualize trends and insights, resulting in a 45% improvement in KPI visibility and stakeholder understanding.

• Configured and maintained SQL Server environments to support large-scale analytics operations; performed data cleaning using SQL functions to ensure data consistency and accuracy, and implemented BULK INSERT operations to efficiently extract and load structured data into reporting tables for downstream analysis.

• Automated database backup and maintenance plans using SQL Server Maintenance Plans, reducing storage usage by 30% and ensuring continuous system health monitoring.

Projects

Taxi Data Analysis – Fare vs Payment https://github.com/avantikaaa2001/fare-vs-payment-analysis.git

• Conducted statistical data analysis using Python (Pandas, NumPy, SciPy) on NYC Taxi Trip data to assess the impact of payment methods on fare amounts; implemented hypothesis testing (T-test) and regression analysis, uncovering a 12% higher average fare with card payments.

• Designed interactive data visualizations and presented key business insights using Matplotlib and Seaborn; provided actionable recommendations to increase driver revenue by promoting card payments, supported by data trends and hypothesis test results. Vendor Profitability Analysis https://github.com/avantikaaa2001/vendor-performance-analysis.git

• Engineered a full data pipeline using Python (Pandas) and SQLite to automate data ingestion and transformation from CSV files; performed SQL-based modeling, hypothesis testing, and profitability segmentation, identifying that top vendors contribute ~66% of purchases but have lower margins, leading to strategic vendor diversification insights.

• Designed and deployed an interactive Power BI dashboard to analyze vendor performance, inventory turnover, and profit margins using retail datasets; implemented Power Query (M) and DAX to build dynamic KPIs and visuals, uncovering $2.71M in unsold inventory and reducing insight delivery time by 40%. Education

Masters of Computer Applications– Amity University Noida (2024) (CGPA-8.25)

Contact this candidate