Data Analyst Power Bi

PREETAM SHANKAR MALLA

Coppell, TX Email: ***********@*****.*** Phone: +1-469-***-**** LinkedIn SUMMARY

• Data Analyst with 4+ years of experience in healthcare and enterprise technology sectors, delivering data-driven insights and supporting strategic decision-making.

• Skilled in building and optimizing ELT pipelines using tools such as Apache Airflow, dbt, Talend, and Informatica, improving data ingestion and workflow efficiency.

• Proficient in SQL, Python, and R for data analysis, statistical modelling, and automation of regulatory and compliance reporting.

• Hands-on experience with large-scale data processing using PostgreSQL, SQL Server, MySQL, and Google BigQuery.

• Strong background in statistical techniques including A/B testing, time-series analysis, and clustering, applied to real- world business problems.

• Expertise in data visualization and reporting using Power BI, Tableau, and Advanced Excel to deliver interactive dashboards and KPI tracking tools.

• Collaborated with cross-functional teams in Agile/Scrum environments, translating business requirements into technical solutions and measurable outcomes.

• Supported AI and ML initiatives by integrating data pipelines and analytics for experimentation platforms, EMR systems, and predictive modelling.

• Effective communicator with a proven ability to present complex data insights to technical and non-technical stakeholders.

SKILLS

• Programming Languages: Python, SQL, R

• Data Analysis & Statistical Techniques: Data Mining, Data Cleansing, Data Wrangling, Statistical Analysis, A/B Testing, Time Series Analysis, Text Mining

• Data Visualization & Reporting: Power BI, Tableau, Advanced Excel, Report Automation, KPI Tracking, Financial Reporting

• Data Engineering & ETL Tools: Alteryx, Talend, Informatica, Apache Airflow, dbt

• Databases & Data Warehouses: PostgreSQL, SQL Server, MySQL, BigQuery

• Business & Collaboration Skills: Stakeholder Communication, Cross-Functional Collaboration, Compliance Reporting

• Project Management Tools: Jira, Trello

• Methodologies: Agile, Scrum

WORK EXPERIENCE

Kaiser Permanente July 2024 – Present

Data Analyst

• Designed real-time analytics pipelines and embedded dashboards for the AI-Driven EMR Decision Support project, enabling clinicians to access predictive insights directly within electronic medical records.

• Developed modular ELT workflows using Apache Airflow and dbt, improving data ingestion efficiency by over 35% and aligning with modern DataOps principles and continuous delivery cycles.

• Leveraged Google BigQuery to process high-volume patient-care datasets, powering ML models for triage support and ensuring performance across serverless, cloud-native infrastructure.

• Supported AutoML and NLP-driven models to extract insights from unstructured clinical notes, increasing diagnosis recommendation accuracy by 18% in early-stage deployments.

• Integrated Power BI dashboards into clinician portals, delivering contextual KPI tracking and treatment suggestions without workflow disruptions.

• Automated regulatory and compliance reporting by developing Python-based scripts, improving reporting accuracy while reducing manual effort and turnaround time.

Dell Technologies January 2019 – August 2022

Data Analyst

• Spearheaded data analytics initiatives on the Machine Learning Experimentation Platform, enhancing experimentation cycles by streamlining data pipelines and integrating OLAP-based insights to support rapid model iteration and performance monitoring.

• Developed and optimized financial and operational data marts using SQL Server and PostgreSQL, reducing reporting latency by 35% and improving cross-team data accessibility.

• Built and maintained ETL workflows in Informatica and Talend, enabling the integration of large-scale ERP data with over 99% pipeline reliability, supporting downstream ML and BI use cases.

• Designed OLAP cubes and star/snowflake schemas to support dimensional modelling for deep-dive analytics and performance benchmarking of ML experiments.

• Created interactive dashboards in Tableau and Power BI for tracking key ML metrics, improving decision turnaround time by 28% for the experimentation team.

• Executed time-series analysis and A/B testing frameworks to evaluate model stability and forecast financial KPIs impacted by automation and predictive workflows.

• Leveraged Advanced Excel with pivot tables and macros to prototype reporting templates and automate repetitive data preparation tasks across experimentation sprints.

• Explored graph database concepts to model complex relationships in experimentation metadata—such as feature dependencies and lineage tracking enhancing interpretability and audit readiness.

• Partnered with data scientists, ML engineers, and product teams in agile sprints, translating analytical insights into model improvements and aligning reporting with experimentation objectives. PROJECTS

Retail Customer Segmentation

• Applied K-means clustering on customer transaction and behavioural data to uncover distinct customer segments, enabling targeted marketing strategies and improved customer retention.

• Developed dynamic Power BI dashboards with interactive filters for region, age group, and lifetime value, providing business teams with actionable insights into each segment’s purchasing behaviour. Patient Appointment No-Show Prediction

• Built a predictive model using Python and XGBoost to identify patients likely to miss appointments, based on historical scheduling, demographics, and seasonal trends.

• Visualized model outputs and feature importance using Plotly and Dash, enabling interactive scenario analysis for operational staff.

EDUCATION

• Master of Science in Data Science September 2022 – May 2024 University of Massachusetts Dartmouth GPA: 3.76

• Bachelor of Technology in Computer Science June 2016 – April 2020 Andhra University College of Engineering GPA: 6.7

Contact this candidate