Data Analyst User Acceptance

Swapna Ponduri

Email: *****************@*****.***, Contact: +1-317-***-****, LinkedIn: www.linkedin.com/in/swapna-ponduri

Summary:

Around 4 years of experience as a Data Analyst with strong expertise in requirement gathering, gap analysis, change management, user acceptance testing, data analysis, ETL testing, and BI testing in the healthcare sector, along with proven client-facing experience in implementation and technical support.

Very good understanding and experience in User Acceptance Testing, Smoke Testing, Regression Testing, Performance Testing, and Functional Testing.

Involved in Data Analytics, and Data Profiling tasks with business to make data more accurate and result oriented.

Understanding the internal technical needs of an organization and recommending solutions as per timelines.

Knowledge in HL7, FHIR, CDA, API, and EDI for seamless data exchange and integration.

Expertise in various types of software development life cycles like Waterfall and Agile.

Interact with clients for requirement gathering and prepare Functional Specifications.

Skilled in SNOMED, CPT, and LOINC for standardized healthcare data representation.

Excellent knowledge of Health Insurance Portability and Accountability Act (HIPAA) Standards and Compliance issues.

Proficient in ICD-9-CM and ICD-10-CM coding and claims processing.

Extensive experience in gathering business/functional user requirements, creating use Cases as per user requirements, developing/designing diagrams such as Activity, Class, or Sequence diagrams, and creating Business Requirements Documents (BRD).

Extensive experience in Prior Authorizations, Claims Processing, and Clinical Data Exchange workflows.

Expertise in Requirements Elicitation, Gap Analysis, User Acceptance Testing (UAT), and System Application Flows.

Proficiency in Oracle, Database, Informatica, and SQL Developer.

Involved in Facets system implementation, electronic claims and benefits configuration set-up testing, inbound/outbound interfaces and extensions, load and extraction programs involving HIPAA and proprietary format files and reports.

Act as a liaison between client and technical solutions/support groups, using advanced communication skills to elicit, document, analyze, and validate client requirements.

Strong analytical and problem-resolution skills with the ability to plan, prioritize, and work efficiently in a multi-tasking environment.

Experience in Risk Identification, Stakeholder Collaboration, Vendor Coordination, and maintaining Project Artifacts through Peer Reviews and audits.

Educational Background:

Indiana University Purdue University Indianapolis (IUPUI), Indianapolis, Indiana August 2022 –May 2024

Master’s in Health Informatics, GPA: 3.6/4.0

K.C Reddy Institute of Pharmaceutical Sciences, Andhra Pradesh, India September 2017– August 2021

Bachelor of Pharmacy, GPA: 3.4/4.0

Area

Skill Set

Languages

SQL, PL/SQL, T-SQL, Python, R, SAS

Databases

TSQL, PL/SQL, My SQL

Software

Design Tools - UML, Web UML Diagrams

GUI Tools - Visual Studio and Visual web developer

Database Tools - Microsoft SQL Server

Reporting and Visualization Tools

SSRS, Tableau, Power BI, Crystal Reports, Excel Dashboards

Software Process Model

Waterfall Model, Agile Development (Scrum)

Programming & Scripting

Python (Pandas, numpy, matplotlib), R (ggplot, dplyr), SAS

Technical Skills:

Professional Experience:

Client: IU Luddy School of Informatics, Computing, and Engineering at IUPUI, IN February 2023 – May 2024

Role: Research Assistant

Responsibilities:

Spearheaded the creation of the Townshend Index for West Virginia through comprehensive data analysis, focusing on demographics, economics, healthcare, and education data.

Developed and optimized SQL queries and stored procedures to streamline data processing and enhance reporting capabilities.

Designed and implemented Flow Diagrams and Process Flows using Unified Modeling Language (UML) for data-driven solutions.

Conducted Gap Analysis, User Acceptance Testing (UAT), and ensured Regulatory Compliance for data analytics and reporting projects

Managed data processes and tools on both Windows and Linux environments, ensuring compatibility for research workflows.

Proficient in Data Analysis and Data Analytics for actionable business insights.

Expertise in maintaining Data Quality and implementing robust Quality Assurance processes.

specialized in developing sophisticated data and analytics-driven solutions, focusing on the creation and implementation of scalable algorithms to advance business analytics towards predictive capabilities, leveraging big data tools and technologies for optimal results.

Applied descriptive, predictive, and prescriptive analytics techniques to gather and analyze data, leveraging tools for forecasting, A/B testing, and AI/ML models.

Developed and optimized complex SQL queries, stored procedures, and functions to streamline data retrieval and processing for large-scale applications.

Executed SCD Types 1, 2, and 3 to manage historical data retention and updates in a data warehousing solution.

Produced customized ad-hoc reports and visualizations in response to user inquiries, meticulously documenting processes and validating outcomes through rigorous testing.

Client: G Technologies Pty Ltd, New South Wales, Australia May 2023 – August 2023

Role: Data Analyst Intern

Responsibilities:

Utilized advanced data manipulation techniques and troubleshooting skills to clean, transform, and analyze large datasets, ensuring high data quality for business analysis tasks.

Leveraged a strong technology background to ensure data accuracy and integrity, writing queries and scripts, creating and managing dashboards, and conducting regular data audits to maintain compliance and reliability.

Worked with cloud-based data platforms like Snowflake and optimized data flow between storage solutions.

Gained extensive experience in BI, data warehousing, and data architecture, working with platforms like Snowflake and Cloud Data Platforms.

Developed BRDs and FRDs for Healthcare Interoperability solutions including HL7, FHIR, and EDI transactions.

Created Traceability Matrices and managed Version Control to track changes and maintain consistency throughout project lifecycles.

Developed advanced Excel models and proficiently used enterprise statistical and BI tools, including Tableau, Power BI, and QlikView, to create interactive dashboards and reports.

Demonstrated proficiency in SAS, SQL, R, and Python to analyze data, generate insights, and automate processes.

Transformed complex data into visually appealing and intuitive UX-driven visualizations, enabling actionable insights for decision-makers.

Contributed to ETL processes and data warehousing, ensuring efficient data flow and availability for business intelligence purposes.

Client: Devis Laboratories, Hyderabad, India June 2021 – July 2022

Role: Data Management and Reporting Analyst

Responsibilities:

Oversee data collection from multiple sources, examining data and creating metrics to drive clinical and operational performance improvement.

Built and maintained analytical and reporting solutions using SQL, R, and SAS to support strategic decision-making,monitor healthcare cost trends, and drive increased value for clients.

Performed quantitative analysis on healthcare costs, operational performance, and clinical outcomes using claims and

authorization data, delivering actionable insights and recommendations to internal and external stakeholders.

Created data visualizations, dashboards, and self-service tools using Tableau and PowerBI to communicate complex

findings, support client reporting, and inform stakeholders of solution performance.

Delivered data-driven insights and reports in a client-facing capacity, enhancing operational performance and supporting decision-making for healthcare stakeholders.

Designed Data Reporting dashboards and conducted Risk Identification to improve decision-making and compliance.

Utilizes analytics to enhance customer experience by delivering actionable insights to stakeholders through descriptive, predictive, and prescriptive analytics.

Developed and implemented robust data quality control processes to ensure data integrity for clinical and operational research

Performs requirements definition, development, testing, research, and ad-hoc reporting to address stakeholder needs.

Client: Sasank Clinic, Guntur, India August 2020 – September 2021

Role: Clinical Coordinator

Responsibilities:

Collaborated with primary care providers to document patient encounters in real time, ensuring accurate and timely clinical documentation in accordance with CPT and ICD-10 standards.

Assisted in daily planning huddles, joined providers in exam rooms, prepared After Visit Summaries and assisted in client communications, contributing to seamless operations and effective patient care

Experienced in defining and tracking Quality Metrics to improve operational performance.

Skilled in Computerized System Validation (CSV) to ensure regulatory compliance.

Provided administrative support by placing orders, managing referrals, and addressing tasks, contributing to the

efficiency of the care team.

Performed Peer Reviews and collaborated with Vendors and Stakeholders to ensure quality deliverables and compliance with regulatory standards.

Volunteer Experience:

Client: Bright Mind Enrichment and Schooling, San Francisco, California July 2024 – September 2024

Role: Data Analyst

Conducted Business Requirements Elicitation and prepared detailed Process Flows and Flow Diagrams to support data analytics and reporting.

Developed Data Reporting and Trending dashboards and validated results through User Acceptance Testing (UAT) and Gap Analysis.

Collaborated with Stakeholders to define Business Architecture, ensuring effective Version Control and documentation of Project Artifacts for audits.

Contact this candidate