Data Analyst Power Bi

GUDURU SAIKARAN

DATA ANALYST

Denton, Texas Mobile: +1-945-***-**** Email: **************@*****.*** Linkedin

PROFESSIONAL SUMMARY

Results-driven Data Analyst with 4+ years of experience leveraging SQL, Python, Tableau, Power BI, and ETL pipelines to transform high-volume, complex datasets into actionable insights. Proven track record of reducing reporting cycles by 75%, increasing data accuracy by 20%, and automating workflows to save 8+ hours per week. Adept at designing predictive models that lower error rates by 15%, creating interactive dashboards adopted by 12+ business units, and implementing robust data governance to ensure regulatory compliance. Skilled collaborator with a history of delivering measurable business improvements in fast-paced, cross-functional environments.

TECHNICAL SKILLS

Data Analysis & Modeling: SQL, Python (Pandas, NumPy), R, SAS, Predictive Analytics, Statistical Analysis, Machine Learning (scikit-learn), Data Cleaning, Data Transformation, Exploratory Data Analysis (EDA)

Visualization & BI: Tableau, Power BI, Microsoft BI Suite, SAP BusinessObjects, Excel Dashboards, Dashboard Metrics, Data Storytelling

Data Management & ETL: ETL Pipelines, SSIS, SSRS, PySpark, Alteryx, Data Warehousing (Snowflake, Hadoop, Teradata), Data Governance, Metadata Documentation, Data Lineage

Testing & QA: ETL Testing, Data Validation, Source-to-Target Testing, Regression Testing, A/B Testing, Data Quality Assurance, Automated Testing Scripts

Databases & Tools: Oracle (9i–19c), Apache Cassandra, MySQL, SQL Server, Microsoft SQL Server Management Studio, Snowflake Cloud, Apache Spark, IBM SPSS

Soft Skills & Methods: Agile Collaboration, Stakeholder Engagement, Problem Solving, Strategic Analysis, Mentoring

WORK EXPERIENCE

BCBS Jul 2025– Current

Data Analyst United States

Analyzed large-scale healthcare claims and patient datasets using SQL and Python, identifying bottlenecks that reduced claims processing time by 15% and improved patient care workflows.

Built automated ETL pipelines with HIPAA-compliant validations, increasing report accuracy by 20% and saving 8 hours of manual work weekly.

Created interactive Power BI dashboards for clinical operations and compliance, enabling faster, evidence-based decisions.

Performed A/B testing on dashboards, applying statistical methods to enhance visualization effectiveness and stakeholder engagement.

Partnered with business, IT, and clinical teams to gather requirements, optimize data models, and ensure regulatory compliance in analytics solutions.

Dell Technologies Jan 2023 – Jul 2023

Data Analyst India

Extracted, cleansed, and transformed over 500,000 complex data records weekly from Oracle and Cassandra systems using advanced SQL and Python (Pandas, NumPy), enabling accurate SLA tracking, high-quality operational performance analytics, and timely executive-level reporting.

Designed, deployed, and maintained highly interactive Tableau dashboards used across 12+ business units, greatly enhancing real-time KPI monitoring and improving organizational agility in decision-making.

Automated intricate ETL workflows with SSIS and Python scripting, reducing repetitive manual work, saving over 5 analyst hours weekly, and tripling the frequency of report refresh cycles.

Developed predictive analytics models and statistical algorithms (Scikit-learn, R) to forecast potential system incidents, enabling early detection of failures and reducing downtime risks across IT operations.

Improved data quality by correcting 1,200+ duplicate or inconsistent records and implementing automated validation scripts to ensure strict compliance with data governance and audit requirements.

Partnered with IT and business teams in Agile settings to refine dashboard features, gather evolving requirements, and ensure high user adoption through intuitive, accurate, and relevant analytics tools.

Created comprehensive documentation for data lineage, key business metrics, and metadata standards, strengthening governance transparency and cross-team knowledge sharing.

Mentored and coached three junior analysts on SQL query optimization, dashboard best practices, and effective data storytelling, raising overall team output and delivery standards.

Integrated multi-source BI reporting frameworks using Microsoft BI Suite and SAP BusinessObjects, consolidating previously siloed reports into a centralized executive decision-making platform.

Executed ETL and reporting accuracy testing using SQL-based validation scripts and automated QA procedures, achieving a 99.9% defect-free rate across Tableau and Power BI deliverables.

Presented in-depth analytical findings during monthly leadership briefings, influencing operational strategy and supporting the rollout of automated alert mechanisms for critical KPIs.

Implemented feedback-driven improvements to reporting pipelines using stakeholder surveys and usage analytics, increasing the relevance and timeliness of delivered insights.

HCL Technologies Ltd Oct 2019 – Dec 2022

Database Analyst India

Managed and ensured continuous availability of high-quality data across Oracle, MySQL, SQL Server, and Cassandra databases to support analytics workflows, enterprise reporting, and mission-critical global operations.

Engineered and automated robust ETL pipelines alongside advanced data cleaning routines using Python, R, and Alteryx, which reduced human intervention, minimized errors, and improved overall data pipeline efficiency.

Designed, developed, and deployed over 20 advanced Power BI dashboards, providing leadership with real-time visibility into SLA performance, operational health, and business growth metrics.

Produced enterprise-scale BI reports using SSIS, SSRS, and SAP BusinessObjects for projects totaling over $8M in business value, improving leadership decision-making with timely and accurate analytics.

Applied advanced statistical methods such as regression modeling, cluster analysis, and forecasting to refine sales projections, better align supply chains, and optimize operational cost control measures.

Spearheaded migration of legacy data platforms to Snowflake and Hadoop, enhancing scalability, storage efficiency, and the ability to integrate with next-generation BI tools.

Developed and enforced data governance protocols including metadata documentation, data quality rules, and audit trail mechanisms to meet ISO certification and compliance standards.

Created optimized logical and physical data models tailored to changing business needs, ensuring adaptability and scalability for future analytics initiatives.

Streamlined processing workflows for clinical, financial, and operational datasets using PySpark, SAS, and SQL, reducing monthly reporting cycles from four days to just one.

Delivered visually compelling analytics incorporating time series forecasting, NLP sentiment analysis, and customer segmentation models to guide targeted marketing and operational strategies.

Designed and executed rigorous data pipeline and ETL testing processes—covering source-to-target mapping, regression checks, and data quality assurance—to ensure early identification and resolution of discrepancies.

Coordinated with cross-functional global teams to deliver innovative, high-impact analytics solutions on time, even under tight deadlines and shifting project priorities.

PROJECTS

Engineering Firm Database Design and implementation:

Designed a normalized RDBMS to manage data for 1,000+ employees, integrating project, department, and vendor transactions for centralized reporting.

Optimized SQL queries to reduce execution time by 30%, enabling faster reporting and improving operational efficiency by 25%.

Customer Behavior Insights for Loan Default Prediction:

Created an interactive Tableau dashboard with 10+ advanced visualizations to monitor customer behaviors and predict loan default risk.

Applied predictive modeling techniques to reduce loan default prediction error rates by 15%, improving data-driven lending decisions

Customer Citi ICG Technology Software Development Job Simulation on Forage - August 2025

Designed a UML state diagram to optimize Citi’s loan management process and researched machine learning approaches for credit risk assessment, recommending high-impact implementation strategies.

Developed a Java-based internal tool for real-time visualization of stock market risk, enhancing monitoring and reporting capabilities.

EDUCATION

University of North Texas, USA May 2025

Master of Science in Information Technology

Qis College of Engineering and Technology, India Aug 2019 Bachelor of Technology in Mechanical Engineering

CERTIFICATIONS

Technology Software Development Job Simulation

Contact this candidate