Data Analyst Power Bi

Pavani Gali

Springfield, IL +1-217-***-**** **********@*****.*** LinkedIn

SUMMARY

• Data Analyst & Business Intelligence Professional with around 5 years of experience across healthcare, government, and IT consulting, specializing in data wrangling, ETL, predictive analytics, BI dashboarding (Tableau, Power BI), and automation to drive decision-making and cost optimization.

• Proficient in SQL, Python, R, SAS, and cloud platforms (AWS, Azure, GCP) with strong expertise in data governance, compliance (HIPAA, FDA, CMS, ISO, ITIL), and advanced analytics (ML, NLP, Deep Learning) to deliver scalable, audit-ready solutions.

• Skilled in stakeholder management, requirements gathering, process reengineering, and Agile delivery, with a proven record of improving operational efficiency, client retention, and regulatory reporting while saving multimillion-dollar costs. EDUCATION

Master of Science in Computer Science University of Illinois Springfield, Springfield, Illinois (GPA: 4.0) Dec 2024 Bachelor of Technology in Computer Science Sri Venkateswara Engineering College, Tirupati, India (GPA: 3.9) May 2022 SKILLS

Methodologies: SDLC, Agile, Waterfall Programming

Languages: Python, R, SQL, SAS, MATLAB

IDEs: Visual Studio Code, PyCharm, Juypter Notebook Packages: NumPy, Pandas, Matplotlib, Seaborn, ggplot2, SciPy, Scikit Learn, TensorFlow Visualization Tools: Tableau, Power BI, Advance Excel ETL Tools: SSIS, SSRS, Informatica, Talend Data Analysis Tools: Excel (XLOOKUP, VLOOKUP, VBA, Macros, Pivot Tables), Tableau, Power BI, Jupyter Notebook ML & Deep Learning: Scikit-learn, TensorFlow, Keras, PyTorch, LSTM, MLP, NLP (NLTK, spaCy, Word2Vec) Databases & Warehousing: MySQL, Snowflake, Microsoft Fabric (Pyspark, SparkSQL), PostgreSQL Business skills: Market Research & Analysis, Presentation, Data Storytelling, Project Management, Consulting, Data Analysis, Data Visualization, Supervision, Leadership, Product Marketing and Training, Cost Benefit Analysis, Risk Analysis. Business Analysis & Strategy: Requirements Gathering, Process Mapping, Business Process Improvement, Data Analysis, Strategic Planning, Business Intelligence (BI), Market Research, Competitor Analysis, User Research, Stakeholder Management, KPI Monitoring, Process Documentation, Reporting

Cloud Technologies: AWS (S3, Redshift, EC2, Glue, EKS, Elastic Beanstalk), Azure (Data Lake, Data Bricks), GCP, Yahoo Finance API Data Visualization & Manipulation: Pandas, NumPy, Matplotlib, Seaborn, Plotly, Streamlit Databases: MySQL, PostgreSQL, SQL Server, Oracle

Version Control Tools: Git, GitHub, GitLab

Other Skills: Data Cleaning, Data Wrangling, Critical Thinking, Communication, Presentation Skills, Problem- Solving Operating Systems: Windows, Linux, Mac

EXPERIENCE

Syneos Health, USA Data Analyst Jan 2025 - Present

• Performed data wrangling, cleansing, and EDA on 10K+ weekly patient claims, provider, and clinical trial records, identifying anomalous billing patterns, risk concentration segments, and underutilized care programs to enable predictive risk modeling and improve healthcare cost optimization by 30%.

• Designed, developed, and deployed 12+ Tableau & Power BI dashboards visualizing clinical trial performance, patient enrollment trends, compliance KPIs, provider efficiency, and patient outcomes, accelerating data-driven healthcare decision-making by 40%.

• Conducted A/B testing, hypothesis testing, and patient behavior analytics to optimize trial recruitment, digital engagement, and retention strategies, driving a 25% increase in patient adherence and aligning with value-based care goals.

• Automated 50+ recurring healthcare and compliance reports using Python (Pandas, NumPy), SQL, and Excel to monitor KPIs such as readmission rates, medication adherence, and claims timelines, enhancing reporting efficiency by 30%.

• Collaborated with clinical operations, compliance, IT, and risk management teams to resolve 65+ monthly data integrity issues, manage schema updates, and optimize SLA adherence to 95%, reducing reporting delays by 25%.

• Developed and implemented SQL validation rules and ETL pipelines to ensure accuracy of 1M+ monthly claims, patient, and trial records, supporting compliance monitoring, patient safety, HIPAA/FDA/CMS regulatory reporting, and audit readiness. Illinois Secretary of State, Springfield, Illinois Modernization Technical Analyst Jan 2023 - Dec 2024

• Improved IT service scalability by 60% and supported digital modernization by analyzing user trends and system limitations, conducting market research, and documenting actionable recommendations for SharePoint migration using SQL, Excel, and stakeholder inputs.

• Delivered clear insights on platform usage and adoption by developing interactive Power BI dashboards and usage-based reports, enabling leadership to monitor key performance indicators and align decisions with modernization objectives.

• Supported financial planning efforts for 40 % by creating internal reporting documents and visual summaries in Power BI and Excel, helping executive teams understand spending patterns and make data-informed operational choices.

• Contributed to the SharePoint change management strategy by designing process documentation and creating visual workflows in Visio and Lucid chart, which enhanced training materials and supported user adoption across departments.

• Partnered with business stakeholders to define functional requirements and map workflows for digital attendance and leave tracking system in Microsoft Teams, ensuring data collection aligned with operational needs. Citus Infotech, India Business Intelligence Analyst Aug 2019 – Dec 2022

• Designed, developed, and maintained 10+ interactive dashboards in Power BI and Tableau, leveraging advanced DAX, KPI frameworks, and performance models to optimize IT service reporting, reduce client churn by 20%, and enhance operational efficiency by $750K.

• Consolidated, cleansed, and normalized multi-source IT and business datasets from CRM, ERP, cloud applications, and compliance platforms using SQL, Python, R, and SAS, improving client retention by 15% and reducing acquisition costs by $300K.

• Conducted process reengineering, GAP analysis, and workflow optimization across IT service delivery, client onboarding, and reporting operations, ensuring compliance with ISO, ITIL, and data governance frameworks, strengthening audit performance.

• Authored BRDs, FRDs, and Agile user stories, enhancing Jira-based sprint planning, backlog management, and stakeholder collaboration, reducing rework by 25% and improving issue resolution efficiency by 20%.

• Spearheaded document migration and governance initiatives, transferring 300K+ IT service and compliance records into Confluence, improving audit readiness by 40% and delivering $1M cost savings through effective document control and governance.

• Delivered enterprise-scale BI & analytics solutions by automating ETL pipelines and reporting workflows, enabling real-time decision- making across IT operations, compliance, and service delivery, increasing efficiency, client satisfaction, and regulatory adherence.

Contact this candidate