Data Analyst Power Bi

Reddy Lohith Vaka

Houston, Texas • ************@*****.*** • +1-832-***-**** • LinkedIn

Summary

Analytical Data Analyst with 2 years of experience in data architecture, dashboard, and cross-platform data integration. Proven ability to translate large-scale datasets into actionable insights using SQL, Python, Snowflake, and Power BI. Adept in building ETL pipelines, automating business reports, and enhancing data quality to improve operational efficiency, stakeholder visibility, and regulatory compliance. Education

Master Of Science in Information Systems Management Aug 2023 - May 2025 Lamar University - Beaumont, Texas

Bachelor’s In Civil Engineering Aug 2019 - May 2023 Rvr&Jc College of Engineering - Guntur, India

Skills

• Programming & Scripting: SQL (joins, CTEs, optimization), Python (pandas, NumPy), R

• Visualization & Reporting: Power BI, Tableau, Excel VBA, SSRS

• Databases & Warehousing: Snowflake, AWS Redshift, SQL Server, MySQL, PostgreSQL, Teradata

• ETL & Data Pipelines: SSIS, Informatica PowerCenter, Azure Data Factory

• Cloud Platforms: AWS (EC2, S3, Redshift), Microsoft Azure, Google Cloud Platform (GCP)

• Automation & Tools: Power Query, Excel Macros, Git, GitHub

• CRM/ERP Systems: Salesforce, SAP

• Methodologies: Agile, Waterfall, Data Governance, Data Profiling

• Certifications: Oracle Academy Database Programming with SQL Runner Certification Experience

Humana, TX Jan 2025 - Current

Data Analyst

• Developed and optimized complex SQL queries (nested CTEs, dynamic joins) to extract over 10 million healthcare records, reducing query latency by 20% using indexing and execution plan optimization.

• Performed data validation and profiling using Python (pandas, NumPy) and SQL, improving data quality by 25% through automated outlier detection, duplicate resolution, and type casting.

• Designed and deployed ETL workflows in Informatica PowerCenter and SSIS to integrate multi-source datasets (Oracle, SQL Server), ensuring end-to-end traceability and alignment with SAP-based data.

• Modeled fact-dimension relationships using star schema in Snowflake to support patient behavior analysis and operational efficiency reporting, increasing dashboard responsiveness by 30%.

• Automated KPI dashboards in Power BI with DAX-driven drill-downs and interactive slicers to monitor metrics like customer retention, claims turnaround time, and provider network performance.

• Migrated legacy Excel-based reporting tools into structured Excel VBA and Power Query frameworks, reducing manual effort by 25% and ensuring version control consistency.

• Supported Teradata data warehouse migration for enterprise reporting, reconciling historical and transactional data to ensure OLTP-OLAP consistency across care delivery systems. Mphasis, India Jan 2022 - Jul 2023

Data Analyst

• Automated SQL Server and Oracle data extraction processes via SSIS packages, aligning ETL logic with data governance rules and reducing manual ETL dependencies by 30%.

• Cleaned and standardized transactional datasets using SQL DML and Python-based anomaly detection scripts, resolving common issues such as null values, skewed distributions, and foreign key mismatches.

• Engineered AWS Redshift-based data marts using snowflake schema to consolidate multi-regional sales and customer data, improving dashboard query times and decision timelines for business users.

• Designed Tableau dashboards integrated with SSRS and Salesforce data connectors to track revenue trends and lead conversion metrics, enabling executives to filter performance by product line, region, and lifecycle stage.

• Enhanced financial reporting accuracy by optimizing Teradata SQL workloads—removing unnecessary nested subqueries, introducing indexed lookup tables, and reducing runtime by 35%.

• Built Excel analytics tools using PivotTables, Power Query, and VBA macros to automate reconciliation tasks, reducing manual reporting cycles by 50% and increasing audit accuracy.

• Facilitated legacy-to-cloud migration by mapping over 150 data fields to Redshift schema documentation, ensuring smooth audit trails, regulatory compliance, and scalability for future BI expansion.

Contact this candidate