Data Analyst Power Bi

Venkata Patibandla Data Analyst

**************************@*****.*** 786-***-**** Davie,FL

SUMMARY

Data Analyst with 3+ years of experience leveraging modern technologies such as Python (Pandas, NumPy), SQL, and data visualization tools like Power BI, Tableau, and QlikView to deliver impactful insights. Skilled in designing scalable database systems and building robust, cloud-based ETL pipelines using Apache NiFi, SSIS, SSRS, and Informatica across on-premise and AWS environments. Experienced in developing and integrating machine learning models using TensorFlow to enable predictive analytics and enhance business intelligence workflows. A proven ability to drive real-time reporting, automation, and cross-functional collaboration that improves decision-making and operational efficiency.

SKILLS

•Programming Languages: Python, Java, C, R, SQL, Scala, JavaScript, PySpark

•Databases & Tools: SQL Server, PostgreSQL, MySQL, Snowflake, BigQuery, T-SQL

•Cloud Platforms: AWS (EC2, S3, RDS, Lambda, Glue), Azure (ADF, Synapse, Blob), GCP (BigQuery, Cloud Functions)

•Data Engineering: Spark, Hadoop, Databricks, NiFi, SSIS, Glue

•ML & AI: TensorFlow, Scikit-learn, Keras, MLlib, SpaCy, NLTK, Streamlit

•Visualization: Power BI, Tableau, Qlik, QuickSight, Excel, Looker

•ETL & Orchestration: Airflow, ADF, Informatica, Talend, Step Functions

•APIs & DevOps: REST, GraphQL, Postman, Git, Jenkins, Docker, K8s, CI/CD

•Governance & Modeling: Collibra, MDM, Data Catalogs, DBT, PowerDesigner

•Tools: Jira, Trello, Slack, Agile/Scrum

PROFESSIONAL EXPERIENCE

Data Analyst, community rightful center Feb 2024 – Present FL, USA

•Implemented ETL processes in Alteryx to extract, transform, and load data from diverse sources (SQL Server, XML, Excel, CSV), automating and scheduling workflows that increased processing efficiency and reduced manual errors by 35%

•Built and optimized scalable ETL pipelines using Apache Spark and Hive, reducing data processing time by 30%

•Developed automated data validation workflows with Informatica Data Quality, enhancing governance and accuracy.

•Translated complex datasets into clear, actionable insights through concise executive reports and visual dashboards.

•Conducted data quality audits and deduplication on HMIS using SQL and Excel, increasing data accuracy.

•Used Salesforce Einstein Analytics to predict patient no-show risk and prioritize outreach.

•Built custom ServiceNow data queries and APIs to support ETL pipelines for reporting on request resolution times, user satisfaction, and recurring issues.

•Built and maintained complex SQL procedures and MongoDB schemas for efficient data access.

Data Analyst, Lumeris Jan 2023 – Jan 2024 MO,USA

•Managed XML and JSON data formats to improve system interoperability, resulting in a 30% reduction in data integration issues across platforms.

•Implemented data cleansing processes using Informatica, ensuring high-quality data for analytics and compliance reporting.

•Integrated NLP models for sentiment analysis, driving a 15% improvement in customer service insights.

•Designed and developed data visualizations and dashboards using Tableau, Power BI, and Alteryx, driving a 15% improvement in stakeholder dec

•Developed SAS macros and procedures (PROC SQL, PROC MEANS, PROC FREQ) to clean, transform, and summarize large EMR and claims datasets.

•Automated the extraction and transformation of ServiceNow ticketing data using Python and SQL, enabling real-time dashboard reporting in Power BI.

•Automated monthly healthcare KPI reports using SAS and Excel, reducing manual reporting effort by 40% and improving delivery timeliness.

•Customized Crystal Reports, improving report relevance and user satisfaction by 30%.

•Created and optimized DAX queries in Power BI, reducing dashboard load times by 35%.

•Performed detailed data analysis using Microsoft Fabric, SQL, uncovering trends to enhance operational decisions.

Data Analyst, synechron,INC Jan 2020 – Jul 2021 INDIA

•Designed and deployed ETL pipelines to extract data from Salesforce using Informatica, Talend, and Apache NiFi, enabling efficient data integration across systems.

•Implemented data cleansing processes using Informatica Data Quality, ensuring high-quality, compliant data for analytics.

•Conducted detailed data profiling and resolved quality issues to support accurate migrations.

•Developed machine learning models in Python 3.x (Scikit-learn, Keras, Pandas), improving predictive accuracy in key business cases.

•Integrated Tableau dashboards with multiple sources (SQL Server, Excel, cloud databases) enabling real-time KPI monitoring and better operational oversight.

•Built complex SQL queries for validation in SSIS, enhancing pipeline reliability and business compliance.

PROJECTS

Healthcare Patient No-Show & High-Risk Prediction Dashboard

•Developed a Patient No-Show and High-Risk Prediction Dashboard using SAS, Python and SQL with 80%+ accuracy. Visualized insights in Power BI to optimize clinic scheduling and target patient outreach. Automated data updates enabled real-time decision-making and improved operational efficiency.

Sales Forecasting Dashboard Analysis

•Developed a Sales Forecasting Dashboard using Python (with Pandas, Scikit-learn) and SQL for data extraction and storage, leveraging time series models to predict future sales trends and support strategic planning. Implemented ARIMA and linear regression models to forecast sales with 85%+ accuracy, and visualized results using Matplotlib and Seaborn to communicate insights effectively to stakeholders.

Grouping Similar images by extracting metadata

•Developed a machine learning model using Python, OpenCV, and Scikit-learn to group similar images by extracting metadata and visual features, leveraging clustering algorithms (e.g., K-Means) to improve image organization and searchability.

EDUCATION

Master of Science in Computer Science Aug 2021 – May 2023

Southern Illinois University Edwardsville, IL,USA

CERTIFICATES

•AWS Data Engineer Certified.

•Certified by APSSDC in cyber security and PHP & MySQL

•Certified by Intern Shala with web development.

•NPTEL certification in the concepts of Data Mining.

•Microsoft Fabric for Power BI certification by Udemy

Contact this candidate