Data Analyst Power Bi

Arun reddy seelam

Irving, Tx

+1-469-***-**** ************@*****.***

Professional Summary

Data Analyst with 3 years of experience leveraging customer data insights to drive business decisions. Skilled in Python, SQL, AWS, and Power BI, with deep knowledge of ETL automation, Redshift modeling, and KPI analytics. Proven track record of improving data workflows, reducing processing time by 30%, and enabling data-driven decisions across business units. Strong communicator with a passion for translating data into strategic insights

Education

University of North Texas, Denton, TX

Dec 2024

Master of Science, Information Science

• Coursework: Data Visualization, Data Modeling, Information and Knowledge Professions, SWOT Analysis

Malla Reddy College of Engineering, India

2022

Bachelor of Technology, Electronics and Communication Engineering

• Achievements: Graduated with honors, completed a final project focused on database management systems

Professional Experience

Vastika Inc Feb 2025 - Present

Data Analyst/Engineer - Irving, Texas

•Built and optimized ETL pipelines using AWS Glue, Lambda, and Python to ingest and process multi-terabyte datasets into Redshift with star schema modeling.

•Automated data quality checks and monitoring workflows using Lambda, Step Functions, and CloudWatch, improving pipeline reliability and alerting efficiency.

•Created Power BI and QuickSight dashboards to track business KPIs, including product usage, conversion, and customer behavior, enhancing visibility for stakeholders.

•Reduced report generation time by 30% by streamlining data aggregation with optimized SQL queries and Python scripts.

•Leveraged Athena and EMR with PySpark to perform distributed querying and transformation over semi-structured log data.

•Collaborated with cross-functional teams to define data requirements, resulting in improved data governance and analytics workflows.

•Worked with Hadoop ecosystem tools for large-scale data ingestion and transformation tasks.

•Integrated Informatica and SSIS into legacy systems to support hybrid data warehouse transitions.

Accenture Sep 2021 - Dec 2022

Data Analyst - Hyderabad, TS

•Developed interactive dashboards to visualize metrics such as claim cycle time, provider efficiency, and common rejection reasons.

•Conducted root cause analysis on rejected claims, recommending process improvements that saved over $100K annually.

•Utilized Python, SQL, Tableau, and Power BI to analyze over 10 million rows of healthcare claims data, uncovering key trends and patterns.

•Automated data preparation workflows using Python and Power Query, reducing processing time by 50% to support timely deci- decision-making.

•Constructed and optimized SQL queries and stored procedures for effective KPI tracking and automated reporting.

•Built forecasting models using time series analysis and linear regression to predict monthly claims volume and cost trends.

•Implemented row-level security in Power BI to ensure HIPAA compliance and protect sensitive data.

•Presented data-driven insights and recommendations to clients and stakeholders, aiding in comprehensive quarterly business reviews.

Accenture Jun 2021 - Aug 2021

Software Engineer Intern - Hyderabad, India

•Built robust ETL pipelines using AWS Glue and Python (PySpark) to process sales and product data from Amazon S3, RDS, and third-party APIs.

•Stored raw and transformed data in Amazon S3, and designed scalable Redshift tables using star schema for downstream reporting.

•Wrote Athena SQL queries for on-demand data analysis, contributing to faster stakeholder response times.

•Developed interactive visualizations using Amazon QuickSight and Python libraries (Matplotlib, Seaborn) for trend analysis.

•Automated data validation checks using Lambda functions and Python scripts, maintaining 99% data accuracy across datasets.

•Used Step Functions and CloudWatch to orchestrate and monitor workflows, ensuring end-to-end pipeline reliability.

•Supported version control and CI/CD deployments with AWS CodePipeline and Git.

•Delivered insights on product performance and regional sales patterns, helping stakeholders drive a 12% increase in revenue.

Panya Computech Jun 2020 - Aug 2020

Machine Learning Intern - Hyderabad, TS

•Assisted in developing machine learning models for predictive analytics and data classification.

•Worked with Python, TensorFlow, and Scikit-Learn to preprocess and analyze large datasets.

•Pre-processed and analysed large datasets using Pandas, and NumPy, implementing feature engineering, data augmentation, and normalization techniques to enhance model accuracy.

•Conducted A/B testing and model performance evaluations by utilizing Cross-Validation, and Hyperparameter Tuning (Grid Search, Random Search) to optimize predictive accuracy.

•Developed and deployed ML models such as KNN and Decision Trees for predictive analytics.

•Optimized model performance by implementing pre-trained CNN architectures.

•Built a serverless image processing pipeline for real-time object detection using OpenCV and implemented real-time model inference and monitoring using FastAPI, Flask, and MLflow.

•Worked in Agile teams, documenting findings, and best practices in Confluence, and created interactive dashboards in Tableau and Power BI.

Projects

Airbnb Market Analysis Using Tableau

•Analyzed the Boston Airbnb market using Tableau to uncover trends and patterns within large datasets.

•Utilized advanced data visualization techniques to identify key market trends, helping stakeholders understand the dynamics of the Airbnb economy.

•Insights provided contributed to understanding supply-demand shifts and pricing strategies.

Role of Social Media in Information Sharing Among Emergency Responders

• Investigated how social media aids disaster response communication among emergency responders.

• Explored trust-building strategies and communication challenges to improve the speed and reliability of shared information.

• Highlighted the implications for information specialists in terms of skills development and professional growth.

Inventory Database Management System (DBMS)

• Designed and implemented an inventory management system for a company.

• Developed an automated system that reduced manual work and enhanced data accuracy, tracking sales, purchases, and stock levels.

• Generated detailed reports to optimize decision-making for inventory control and procurement.

Enhancing Clinical Decision Support Systems (CDSS) with NLP

•Collaborated with a team to integrate Natural Language Processing (NLP) into CDSS to interpret multimodal healthcare data.

•Improved clinical decision-making by developing a system capable of understanding both structured and unstructured data from healthcare records.

Comprehensive Data Analysis Using RapidMiner

•Conducted extensive data analysis, including cleaning, transformation, and visualization using RapidMiner.

•Extracted meaningful insights that informed strategic decisions, showcasing the application of data analysis in solving real-world problems.

Technical Skills

• Programming Languages: Python, R, SQL

•Data Analysis & Visualization: Excel, Tableau, Power BI, Matplotlib, Seaborn, RapidMiner, Amazon QuickSight

•Statistical & ML Libraries: Pandas, NumPy, Scikit-Learn, TensorFlow, OpenCV

•Database Management: MySQL, SQLAlchemy, Amazon Redshift, Database Schema Design, Inventory Management Systems

•Cloud & Big Data Tools: AWS (Glue, S3, Redshift, Lambda, Athena, Step Functions, CloudWatch), PySpark

•Data Engineering: Data Cleaning, Data Preprocessing,AWS Glue, Lambda, Redshift, S3, Athena, Step Functions, EMR, PySpark, Informatica, SSIS.

•Machine Learning: Supervised Learning, Unsupervised Learning, Model Deployment, Cross-Validation, Hyperparameter Tuning (Grid/Random Search), KNN, Decision Trees, CNN

•Deployment & Monitoring: FastAPI, Flask, MLflow

•DevOps & Workflow Tools: Git, CI/CD, AWS CodePipeline, Confluence, Agile Methodologies

•Professional Skills & Industry Experience: SWOT Analysis, Project Management, Research, Critical Thinking, Team Collaboration, Fintech Experience

Contact this candidate