Data Analyst Power Bi

SUMMARY

ARUNA GADDAM

DATA ANALYST

Location: Denton, Texas Email: *************@*****.*** Contact: 940-***-**** LinkedIn Data Analyst with over 3+ years of experience in leveraging data analytics to drive strategic decision-making. Proficient in SQL, Python

(Pandas, NumPy), Power BI, and Tableau for data visualization and reporting. Expertise in developing ETL pipelines, performing statistical modelling, and conducting predictive analytics to enhance operational efficiency. Strong background in cloud-based data integration (AWS) and data governance. Proven track record of automating processes to improve data accuracy and reporting speed, delivering actionable insights that optimize business performance and reduce costs.

SKILLS

Methodologies: SDLC, Agile, Waterfall

Data Analysis & Reporting: SQL, Python (Pandas, NumPy, Scikit-learn), Excel VBA

Data Visualization: Power BI, Tableau, DAX, Power Query

ETL & Data Pipelines: Talend, Apache Airflow, Shell Scripting

Databases: SQL Server, Oracle, PostgreSQL, MySQL

Cloud Platforms: AWS (Lambda, S3)

Predictive Analytics & Machine Learning: ARIMA, Prophet, Scikit-learn

Automation: ETL Automation, SQL Automation, Excel Macros

Data Governance & Validation: Data quality assurance, data normalization, data governance compliance

System Performance Monitoring: KPI Dashboards, Time Series Forecasting, A/B Testing EXPERIENCE

Bristol Myers Squibb May 2024 - Current

Data Analyst

Developed interactive Power BI dashboards with advanced DAX functions and Power Query for real-time monitoring of cloud infrastructure performance, enhancing operational visibility and reducing system downtime by 20%.

Automated the extraction, transformation, and loading (ETL) of log data from SQL Server using Talend and optimized SQL scripts, enhancing data pipeline efficiency and reducing manual processing by 35%.

Conducted root cause analysis on system outages through comprehensive analysis of log files and performance metrics using Python (Pandas, NumPy) and SQL, accelerating incident resolution by 25%.

Created predictive time series forecasting models in Python (using ARIMA and Prophet) to optimize resource allocation in cloud infrastructure, achieving a 15% reduction in operational costs.

Managed robust ETL pipelines with Apache Airflow to integrate data from multiple sources, significantly improving data availability for critical system monitoring.

Automated complex SQL query executions for operational reporting, improving data accuracy by 30% and enabling quicker decision-making processes.

Implemented comprehensive data validation and data governance frameworks to ensure data integrity and compliance with industry standards, resulting in high-quality datasets for analytical purposes.

Developed custom KPI dashboards in Tableau for tracking system uptime, application performance, and network latency, facilitating proactive management of operational health.

Utilized AWS Lambda and AWS S3 to automate cloud-based data processing workflows, significantly enhancing efficiency and reducing manual intervention by 40%.

Conducted A/B testing and statistical analysis on server configurations to identify optimal performance settings, leading to an 18% improvement in system reliability.

Hexaware Technologies, India Feb 2020 - Dec 2022

Data Analyst

Built automated SQL queries for extracting, transforming, and loading (ETL) system performance data from Oracle databases, delivering critical insights into server utilization and application health.

Designed and deployed interactive Tableau dashboards featuring advanced calculated fields and parameter controls to visualize system uptime, application performance, and resource utilization, enhancing responsiveness to operational issues by 20%.

Performed data cleansing and data normalization on operational datasets using Python (Pandas) and SQL, ensuring high-quality inputs for performance analysis and reporting.

Led the migration of legacy data from MySQL to PostgreSQL, optimizing query performance and reducing response times for real-time monitoring by 25%.

Automated daily ETL processes for extracting system logs and monitoring data via Shell scripting and SQL, streamlining workflows and decreasing manual data handling by 30%.

Developed predictive analytics models using Python (Scikit-learn) to forecast potential server failures based on historical trends, enabling proactive maintenance and reducing downtime by 12%.

Generated custom KPI reports utilizing SQL and Excel macros to monitor operational health and application uptime, enhancing reporting workflows and decision-making capabilities.

Conducted in-depth root cause analysis on network outages using log data and SQL queries, identifying performance bottlenecks and improving incident resolution times by 15%.

Established data governance policies for operational data management, ensuring compliance with internal protocols and enhancing the accuracy of performance dashboards.

Developed and deployed real-time monitoring dashboards in Power BI, providing comprehensive insights into server load and network activity, contributing to improved infrastructure management efficiency by 10%. EDUCATION

Master of Science in Advanced Data Analytics Jan 2023 - Jul 2024 University of North Texas, Denton, Texas

Bachelor of Science in Electronics and Communication Engineering Jun 2017 –Aug 2020 Jawaharlal Nehru Technological University, Hyderabad (JNTUH)

Contact this candidate