Data Analyst Power Bi
Resume:
Alekhya Reddy
****************@*****.***
SUMMARY:
Results-oriented Data Analyst with extensive experience in designing, developing, and implementing data pipelines and visualization solutions across various industries, including Financial Services, Retail, Insurance, Technology. Proven ability to optimize SQL queries, develop impactful Power BI dashboards, and architect robust data pipelines. Expertise in leveraging AWS services to ensure efficient data processing, insightful reporting, and data-driven decision-making. Dedicated to automating validation processes, optimizing ETL workflows, and creating comprehensive business intelligence solutions that improve data quality and drive business impact.
EDUCATION:
Master of Science in Data Engineering Management, California State University-Northridge, Los Angeles, CA - 2024
Bachelor of Science in Computer Science, Osmania University, Hyderabad, India – 2020
TECHNICAL SKILLS:
Databases
SQL (Teradata, Oracle, MS SQL Server, PostgreSQL), PL/SQL, T-SQL, Query Optimization, Stored Procedures, AWS Redshift
BI & Visualization
Tableau (Dashboard Design, Server Administration, Data Modeling), Power BI, Looker, Qlik Sense, AWS Quick sight
Data Engineering
ETL Pipeline Design, Data Pipeline Optimization, Data Warehousing Architecture
Data Platforms
Snowflake, Google Big Query, Teradata, Azure Data Lake, Oracle
Workflow Tools
Airflow, AutoSys, SSIS, Informatica
Programming
Python (Pandas, NumPy), Shell Scripting
Analytics
Data Modeling, Data Profiling, Business Analytics, KPI Development
Cloud Technologies
AWS (AWS Glue S3, RDS, Lamda, Redshift), Azure
Other Tools & Environments
GitHub, CSS, Terraform, JIRA, Agile-Scrum
PROFESSIONAL EXPERIENCE:
USPS, Washington, D.C Apr 2024 – Mar2025
Sr. Data Analyst
I wrote several Teradata SQL Queries using Teradata SQL Assistant for Ad Hoc Data Pull request.
Build and optimize Power BI dashboards and reports to monitor data quality metrics, identify inconsistencies, and drive data-driven decisions
Designed and implemented data pipelines using AWS Glue to cleanse, transform, and load data into visualization tools, streamlining data processing by 20%
Wrote and optimized Teradata SQL queries using Teradata SQL Assistant for ad-hoc data pull requests, improving query performance by 10%
Automated repetitive tasks and streamlined data processing using Macros, reducing manual effort by 15%.
Collaborated with data engineering teams to optimize data pipelines and data models for visualization performance in AWS Quick Sight and other AWS services.
Designed interactive data visualizations using CSS to enhance the aesthetic appeal and functionality of dashboards and reports.
Designed, developed, and maintained data analysis workflows using SAS (Statistical Analysis System) to process large datasets efficiently.
Used SAS SQL (PROC SQL) to query, filter, and aggregate data from various sources for in-depth analysis.
Worked with AWS services to automate data flows and ensure real-time data availability for visualizations and analytics.
Created dynamic Macros in Excel, VBA, or other scripting tools to handle data entry, formatting, and calculations efficiently.
Designed and implemented efficient SQL queries in MySQL to extract, transform, and load (ETL) data for reporting purposes.
Strong in funnel conversion optimization, including A/B testing, multivariate testing, and experimentation frameworks.
Created and maintained SAS Macros to automate repetitive data processing tasks and improve workflow efficiency.
Developed and maintained interactive dashboards using AWS Quick Sight to visualize key business metrics and performance indicators.
Collaborated with UX/UI teams to ensure the visual components of data dashboards are aligned with best practices in CSS for smooth, user-centric interfaces.
Collected, cleaned, and transformed raw data into meaningful insights using Power BI tools like Power Query and DAX.
Wrote complex SQL queries in Snowflake to extract, clean, and transform data for analysis and reporting in Power BI and other BI tools
Created and managed data models in Power BI by integrating multiple MySQL tables using relationships and calculated columns/measures.
Optimized the visual design of dashboards by applying advanced CSS techniques, such as animations, transitions, and hover effects, to make data more engaging and intuitive.
Integrated and processed data from AWS data sources such as Amazon S3, AWS Redshift, and AWS RDS to create actionable insights and reports.
Analyzed complex datasets using Macros to generate reports, summaries, and insights for business decision-making. Collaborate with UX/UI teams to ensure the visual components of data dashboards are aligned with best practices in CSS for smooth, user-centric interfaces.
Collect, clean, and transform raw data into meaningful insights using Power BI tools like Power Query and DAX.
Write complex SQL queries in Snowflake to extract, clean, and transform data for analysis and reporting in Power BI and other BI tools
Create and manage data models in Power BI by integrating multiple MySQL tables using relationships and calculated columns/measures.
Environment: SSIS, SSRS, SSAS, Python, SQL, Teradata SQL Assistant 7.0, Snowflake, Spark, Airflow, Looker, Tableau, Power BI, Google Cloud Platform (GCP), SSIS, Azure Data Lake, GitHub, Terraform
FM Global, Rhode Island, United States Nov 2022 – Mar 2024
Sr. Data Analyst
Connect Power BI to various data sources, including SQL databases, Excel, cloud platforms, and APIs.
Experienced in customer segmentation, churn analysis, and journey mapping for enhanced product experience.
Wrote complex SQL queries, including joints, unions, and sub-queries, to extract, manipulate, and validate large datasets across multiple relational databases such as SQL Server, Oracle, Teradata, and DB2.
Train and mentor team members on using Python for effective data quality management
Collaborate on Power BI model development by working closely with data teams to refine LookML models and ensure consistent and accurate data representation
Create stored procedures, triggers, and functions in Oracle to automate data quality checks and business rule enforcement
Develop and generate complex reports using SAS PROC REPORT and SAS PROC TABULATE, providing stakeholders with actionable insights.
Collaborated with cross-functional teams to understand business requirements and design AWS-based solutions for effective data representation.
Designed and optimized Power BI data models to improve performance and efficiency in data analysis.
Troubleshooted and debugged Macros to ensure accurate and error-free automation processes.
Implemented data reconciliation processes in Python to compare and validate data across multiple sources.
Collaborated with data engineers and analysts to refine Python scripts and workflows for efficient data quality management.
Conducted time-series analysis and forecasting using SAS PROC ARIMA and PROC FORECAST for predictive analytics.
Implemented data quality monitoring solutions in Python using open-source libraries and frameworks.
Collaborated with cross-functional teams to gather data requirements and provide SQL-based solutions for ad-hoc analyses.
Ensured security and compliance by applying best practices in data handling, using AWS IAM for access control and AWS KMS for data encryption.
Analyzed trends and patterns in data using Power BI visualizations such as charts, tables, and KPIs.
Implemented advanced Macros to automate data validation, cleansing, and transformation tasks.
Environment: Looker6.x, 5.x, Erwin, Oracle, MySQL, SQL Server, SSIS, SSRS, SSAS (DAX and MDX), SQL Developer, Python, SQL (Oracle, MySQL, SQL Server), Looker, Spark, Airflow, Snowflake, Tableau, Erwin, JIRA, Agile-Scrum, Data Architecture
HSBC, Hyderabad, India Oct 2021 – Mar 2022
Sr Data Analyst
Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
Improved report delivery timelines by 15% by scheduling and automating data analysis tasks using SAS Enterprise Guide and SAS Batch Processing.
Optimized Power BI Performance for data quality by ensuring queries and dashboards run efficiently even on large datasets.
Collaborated with database administrators and backend teams to ensure MySQL data structures support reporting requirements.
Troubleshooted and resolved issues related to Power BI connectivity with MySQL and data refresh failures.
Collaborated with business stakeholders to gather requirements and build Power BI reports tailored to their needs.
Monitored and maintained performance of AWS-based visualizations and dashboards to ensure high availability and fast data processing.
Optimized existing SAS scripts for better performance, reducing runtime without affecting data accuracy.
Utilized CSS preprocessors like SASS or LESS to streamline and enhance the maintainability of styling for large-scale data visualization projects.
Optimized Power BI dashboards for performance, ensuring fast load times and smooth interactions.
Scheduled and managed data refresh processes in Power BI for reports connected to MySQL.
Documented all Power BI solutions, including MySQL query logic, report designs, and data transformation processes
Created and maintained Power BI documentation, including report structures, data sources, and transformation logic.
Optimized Tableau queries to enhance performance and ensure fast, reliable access to large datasets.
Troubleshooting of claims database related issues during upgrading migration process and solved backup, copy, restore job failure, space, network, latency issues related to Log Shipping
Designed and implemented Looker data models to ensure data integrity and consistency across various departments and reports.
Conducted root cause analysis using Oracle SQL to trace and resolve data quality issues.
Worked with AWS analytics services like AWS Lambda and AWS Step Functions to automate visualization processes and enhance data workflows.
Charts using Show Me functionality and publishing them to Tableau Server and Tableau Online.
Environment: MSSQL Server, MySQL, Lotus Notes, MS Access,, SQL Developer, Power Designer, Tableau, QlikView, Qlik Sense, Python, SQL, MS SQL Server, Oracle, SSIS, SSRS, SSAS, Tableau, Power BI, ETL, Informatica, PL/SQL, T-SQL, Alteryx, MS SharePoint
Contact this candidate