Data Analyst - Power BI, SQL, Python
Resume:
ABHINAY KANAPARTHI
️ **********.*********@*****.***
Fredericksburg, VA
PROFESSIONAL SUMMARY
Data Analyst with 6+ years of experience in data analysis, business intelligence, dashboard development, and reporting across healthcare, retail, and enterprise environments.
Strong expertise in SQL, Power BI, Python, Excel, Tableau, and ETL processes for analyzing large datasets and delivering actionable business insights.
Experienced in designing interactive dashboards, developing KPI reports, and automating reporting workflows that improve operational efficiency.
Proficient in data extraction, transformation, validation, cleansing, and performance optimization using SQL and Python.
Skilled in creating data models, writing advanced DAX calculations, and developing meaningful visualizations for executive leadership.
Hands-on experience performing Exploratory Data Analysis (EDA), trend analysis, forecasting, and business performance reporting.
Strong understanding of relational databases including SQL Server, PostgreSQL, Snowflake, and cloud platforms such as AWS.
Experienced in collaborating with cross-functional teams to gather business requirements and translate them into analytical solutions.
Adept at identifying business opportunities through data-driven decision-making and delivering measurable improvements.
Passionate about leveraging analytics and business intelligence tools to solve complex business problems and improve organizational performance.
PROFESSIONAL EXPERIENCE
Integrated Technology Strategies, USA
Data Analyst
Oct 2024 – Present
Developed interactive Power BI dashboards to monitor business KPIs, operational metrics, and executive reports.
Extracted, cleaned, and transformed large datasets using SQL and Python for accurate business reporting.
Automated recurring reports using Python and SQL, reducing manual effort by over 30%.
Designed ETL workflows to integrate data from multiple business systems.
Created advanced DAX measures, calculated columns, and KPIs for business reporting.
Performed data validation, cleansing, and quality checks to ensure reporting accuracy.
Conducted trend analysis and identified business performance improvements through data insights.
Collaborated with stakeholders to gather reporting requirements and convert them into dashboard solutions.
Optimized SQL queries, reducing report execution and dashboard refresh time.
Supported business decision-making by delivering weekly, monthly, and quarterly analytical reports.
Environment
2 Sisters Food Group, UK
Data Analyst / Power BI Developer
Jan 2023 – Sep 2024
Developed enterprise Power BI dashboards for business operations and executive reporting.
Built reusable Power BI data models and star schema structures for reporting consistency.
Created SQL queries, views, and stored procedures for data extraction and reporting.
Performed data cleansing, transformation, and integration from multiple business sources.
Automated KPI reporting using Power BI and SQL Server.
Worked with business users to define reporting requirements and dashboard layouts.
Conducted variance analysis, trend analysis, and business performance monitoring.
Optimized SQL scripts to improve dashboard performance and refresh times.
Generated weekly and monthly executive reports supporting strategic business decisions.
Maintained documentation for dashboards, KPIs, ETL processes, and reporting standards.
Environment
Power BI SQL Server Snowflake Excel Python Tableau DAX AWS ETL
Oeson, UK
Data Analyst
Dec 2020 – Nov 2022
Collected, cleaned, and analyzed structured and unstructured data from multiple business systems.
Developed Power BI dashboards to monitor sales performance, customer behavior, and operational KPIs.
Designed SQL queries for extracting and validating business data.
Built automated ETL pipelines using SQL and Python.
Created executive dashboards for management reporting and business reviews.
Performed exploratory data analysis to identify business trends and opportunities.
Developed KPI scorecards for business performance measurement.
Improved reporting accuracy by implementing standardized data validation procedures.
Worked closely with business teams to understand analytical requirements.
Supported ad hoc reporting requests and data analysis projects across departments.
Environment
Power BI SQL PostgreSQL Python Excel Tableau DAX AWS Snowflake
Verzeo Edutech Pvt. Ltd., India
Junior Data Analyst
Mar 2020 – Sep 2020
Collected, cleaned, and prepared datasets for business analysis and reporting.
Developed Power BI dashboards to monitor project performance and student engagement.
Performed data analysis using SQL, Python, and Excel.
Conducted exploratory data analysis to identify patterns and trends.
Assisted in designing interactive dashboards for management reporting.
Created SQL queries to extract data from relational databases.
Prepared weekly and monthly KPI reports for stakeholders.
Automated repetitive reporting tasks using Python.
Validated data quality and ensured reporting accuracy across multiple datasets.
Supported senior analysts in preparing analytical reports and presentations.
Environment
BI & Visualization
Databases
Programming
Cloud
Data Analytics
Power BI
SQL Server
SQL
AWS S3
Data Cleaning
Tableau
PostgreSQL
Python
AWS Athena
Data Validation
Microsoft Excel
Snowflake
Pandas
Data Wrangling
Power Query
ETL
Exploratory Data Analysis
KPI Reporting
Dashboard Development
Data Modeling
Business Intelligence
PROJECTS
Sales Performance Dashboard
Developed Power BI dashboards tracking sales, revenue, customer acquisition, and profitability.
Automated reporting using SQL and Power BI, reducing manual reporting efforts.
Designed KPI scorecards for executive management.
Healthcare Analytics Dashboard
Built interactive dashboards to analyze patient outcomes, claims, and operational metrics.
Developed SQL queries for healthcare data reporting.
Improved report refresh performance by optimizing SQL queries.
Twitter Data Analytics
Collected and analyzed over 50,000 tweets using Python and SQL.
Developed Power BI dashboards showing sentiment trends and user engagement.
Performed trend analysis for social media reporting.
Stock Market Data Analysis
Analyzed historical stock market data using Python, SQL, and Excel.
Built dashboards showing volatility, growth trends, and investment performance.
Generated analytical reports for business insights.
EDUCATION
Indiana Wesleyan University, USA
M.S. – Artificial Intelligence / Information Technology (Expected May 2028)
University of South Wales, UK
M.S. – Data Science (2020–2021)
Malla Reddy College of Engineering & Technology, Hyderabad, India
B.Tech – Electronics and Communication Engineering (2016–2020)
Contact this candidate