Power Bi Data Analyst

Rishitha Reddy

E-mail: ********.******@*****.***

Mobile: 940-***-****

LinkedIn- linkedin.com/in/rishitha-reddy-muddasani-4b270b216/

PROFESSIONAL PROFILE

I am an IT professional with experience in BI, a proactive individual with a logical approach to challenges. I have 10+ years of experience in Business Intelligence reporting using PowerBI, Tableau, and SQL as Clinical and Healthcare Data Analyst and BI Developer. Good experience in designing and developing ETL processes using Informatica for data integration and transformation.

SUMMARY

Well-versed with the complete Software Development Life Cycle (SDLC) process including Requirement Analysis, Documentation, Development, Testing, Implementation, and Maintenance.

Involved in Requirement gathering & designing Power BI applications by using Agile Methodology.

Experience in making interactive plots and dashboards using Tableau, Python, and R.

Heavily used DAX functions and M Language within the query editor.

Involved in Extracting data from multiple data sources into the Power BI application.

Have a good understanding of Tableau architecture, design, development, and end-user experience.

Extensive experience in Tableau Prep, Tableau Desktop, Tableau Server, and in various versions of Tableau.

Have knowledge on PostgreSQL.

Created Unix Scripts.

Good at implementing LOD (Level of detail) expressions.

Worked on Heat maps, tree maps, bullet charts, control charts, Box and Whisker plots, scatter plots, area charts, line graphs, stacked bar graphs, combined charts, etc.

End-to-end experience in designing and deploying data visualizations using PowerBI and Tableau.

Having good experience in Claims, Billing, hospital, and Healthcare domains.

Proficient in using Electronic medical and health record systems (EHR) and (EMR)

Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing, and processing, and writing data extract scripts/programming of data conversion.

Led a team of MD staff in optimizing patient care protocols, resulting in a 20% decrease in patient wait times and a 15% increase in overall patient satisfaction scores.

Implemented a new electronic health record (EHR) system, training 50+ medical staff members on its functionalities, resulting in improved efficiency and accuracy in patient data management.

Spearheaded quality improvement initiatives for MD staff, conducting regular audits and assessments to ensure compliance with regulatory standards and best practices in patient care.

Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star-schema, and Snowflake schema using fact and dimension tables and relational databases.

Strong IT experience as a MS SQL Server 2005/2008 and BI tools SSIS, and SSRS

Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.

Defined and documented detailed ETL specifications for the Data Warehouse interface, extracts, staging areas, atomic areas, and mart database environments

Expert in Extraction, Transforming, and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities.

Expertise in Automated back-end retrieval, Data Manipulation, Curing, quality control, and Anomaly Detection using functional programming in Python & R.

Good SQL reporting skills with the ability to create SQL views and write SQL queries.

Good Team player working in groups as well as independently with excellent interpersonal skills.

EDUCATION and CERTIFICATION:

Master of Science in Business Analytics Kent State University-Kent, OH 2014

Bachelor of Technology in Electronics and Communication Engineering

Teegala Krishna Reddy Engineering College - JNTU, Hyderabad India 2012

HACKER RANK SQL

DATACAMP PYTHON

SKILLS

Analytical Tools: Power BI, Tableau, Advanced Excel (Pivot Tables, XLOOKUP), MS Word, PowerPoint.

Programming Languages: R, Python, SQL, JSON

Packages: NumPy, Pandas, Matplotlib, Seaborn, ggplot2, dplyr, Plotly

Database: MySQL, SQL Server, Oracle, MongoDB

Claims: EMR, EHR, EPIC, HIPAA, HL7, FHIR, FDA

Other tools: ETL, SAP, Informatica, Business Objects, MD Staff

Methodologies: SDLC, Agile

WORK EXPERIENCE:

Magellan Health Remote Aug 2023 – Current

BI Developer/Data Analyst

Collaborated with Epic application analysts and developers to streamline data integration processes and enhance interoperability between Epic modules and external reporting systems, ensuring seamless data flow and consistency across the healthcare ecosystem.

Develop and manage Power BI data models.

Analyse and transform raw data from various sources, including claims and MD staff data.

Integrate data from multiple sources including claims systems, MD staff databases, and other healthcare-related data sources.

Create interactive and user-friendly healthcare and medical Power BI reports and dashboards for clients covering all major departments.

Customize visualizations to meet the needs of different stakeholders.

Develop and maintain comprehensive reports to track healthcare metrics, performance, and outcomes.

Worked with IT teams to ensure data infrastructure supported reporting needs.

Optimize Power BI reports and dashboards for performance and ensure efficient data retrieval and processing.

Ensure all data handling and reporting practices comply with healthcare regulations (e.g., HIPAA).

Develop and generate regular and ad-hoc reports based on claims and MD staff data.

Interpret complex data sets and present findings to stakeholders in a comprehensible manner.

Collect, organize, and maintain healthcare data from claims and MD staff sources.

Ensure all data handling practices comply with healthcare regulations.

Akron Children Hospital OH Remote Nov 2022 – July 2023

Clinical Data Reporting Analyst

Designed and developed custom clinical data reports utilizing SQL Server Reporting Services (SSRS) and Crystal Reports, integrating seamlessly with the Epic Electronic Health Record (EHR) system to provide real-time insights into patient care metrics.

Collaborated with clinical stakeholders to gather requirements and translate them into actionable report specifications, ensuring alignment with regulatory standards and organizational goals.

Utilized SQL queries and stored procedures to extract and manipulate data from the Epic Clarity database, optimizing performance and ensuring data accuracy in generated reports.

Implemented advanced data visualization techniques in Crystal Reports to present complex clinical data clearly and intuitively, enhancing decision-making capabilities for healthcare providers and administrators.

Provide mentorship and training to team members to enhance their Power BI skills and overall productivity.

Leveraged EPIC's Clarity database for extracting detailed healthcare data to create 100’s of Power BI reports and dashboards.

Oversee the end-to-end lifecycle of Power BI projects for CHP from requirement gathering and design to development, deployment, and maintenance.

Design and develop interactive, user-friendly Power BI dashboards and reports that provide actionable insights for decision-makers

Implemented real-time tracking and reporting of KPIs through PowerBI.

Optimized data models and visualizations maximizing Power BI’s Speed of response.

Creating the data modelling in PowerBI desktop.

Utilize advanced Power BI features, such as DAX (Data Analysis Expressions), to create complex calculations and data transformations.

Developed automated report scheduling and distribution workflows, leveraging SSRS subscriptions and Crystal Reports Server, to deliver timely and relevant information to key stakeholders across the organization.

Conducted thorough testing and validation of report outputs to ensure data integrity and consistency, collaborating with IT and clinical teams to address any discrepancies or issues identified during the process.

Provided training and support to end-users on report usage and interpretation, empowering clinicians and administrators to leverage the reporting tools effectively in their daily workflows.

Worked on data reporting segment of a large-scale MD Staff implementation, ensuring high-quality report design and delivery throughout the multi-wave rollout process.

Spearheaded a project to integrate Crystal Reports with MD Staff, enhancing report visualization and user experience for the healthcare staff.

Maintained documentation of report specifications, data dictionaries, and technical design documents, facilitating knowledge sharing and ensuring continuity in report development and maintenance efforts.

Implemented enhancements and optimizations to existing reports based on user feedback and changing business requirements, continuously improving the usability and value of clinical data reporting solutions.

State of AZ- Department of Agriculture (REMOTE) May 2020 – Oct 2022

BI Developer/ Data Analyst

Domain- Animal Welfare, Agriculture

Developed a dashboard for a non-profit animal protection organization, utilizing historical data and data visualization techniques.

Monitored year-to-year donation fluctuations to gain insight into the efficacy of fundraising strategies, facilitating timely adjustments to maximize fundraising success.

Tracked crucial metrics such as pet intake, diagnosis, and mortality rates to ensure timely and appropriate medical care, prioritizing the well-being and health of animals.

Harnessed duration of stay data for pets to optimize resource allocation and enhance the efficiency of pet adoption processes.

Worked with Power BI, including dashboard and report development, data modelling, and DAX.

Implemented cost analysis PowerBI dashboards to track expenses related to agriculture, and pet’s equipment.

Conduct training sessions for internal teams to effectively use PowerBI dashboards and analytics.

Establish a feedback loop for ongoing improvement by gathering user feedback and monitoring the effectiveness of PowerBI solutions.

Create the standards in alignment with existing data policies for governing data in the USDA department, as well as implementation and enforcement procedures that are primarily carried out by the data stewards.

Utilizing historical crop data and environmental factors, to develop models to predict crop yields, helping farmers make informed planting decisions.

Monitor crop health through the analysis of remote sensing data, identifying early signs of disease, pest infestations, and nutrient deficiencies.

Studying weather patterns and climate data, data analysts provide forecasts and risk assessments, helping farmers mitigate the impacts of adverse weather conditions.

Worked on agricultural supply chains by analysing data on logistics, storage, and distribution, reducing waste and ensuring timely delivery of produce

Collaborating with software developers, data analysts contribute to the creation of farm management systems that integrate various data sources for comprehensive farm planning and decision-making.

Analyzing data from wearable devices on livestock, data analysts monitor animal health, behavior and productivity, leading to better herd management and improved animal welfare.

Worked with architecture and implementation of data warehouse, ETL solutions, and emerging design of new era of agriculture.

Design and Develop ETL workflows and datasets by the BI reporting tool

Designed and executed data mapping strategies to consolidate data from various systems into a unified data warehouse, improving data accessibility and reporting capabilities.

Work on data that was a combination of unstructured and structured data from multiple sources and automate the cleaning using Python scripts.

Implement data privacy controls, consent management, and data access restrictions.

Designed the architecture of STATE security using PowerBI by customizing the access levels and creating various user groups by assigning row and column level security at application level, folder level and user level.

Built ETL pipeline with AWS Glue and used AWS EC2 to clean and transform raw data into the canonical form

Resolved a 7-month state agriculture department data mapping issue using Python and conducted troubleshooting, articulating data requirements.

Used R to support the SQL analysis by implementing exploratory data analysis.

Collaborated with teams to wrote and optimized SQL queries to perform data extraction from SQL tables.

Designed SSRS reports from various data source and calculated result according to STATE needs.

Developed Calculated Columns and Measures using DAX in Power BI to satisfy the business requirements.

Published PowerBI dashboard on Server and embedded them into portal.

Developing and enforcing policies and procedures for data governance.

Collaborated with stakeholders to define data governance policies, standards, and processes for managing master data, ensuring alignment with business objectives and regulatory requirements.

Develops data quality checks and edits for data validation plans

OMADA Health SFO CA Aug 2018 – March 2020

Healthcare Data Analyst/BI Developer

Responsible for developing our portfolio of reports and data insights that communicate the value Omada brings across employer and payer populations.

Development and support of well-designed Healthcare Omada dashboards using PowerBI.

Design, develop, and implement scalable, secure, and efficient data solutions that meet the needs of the OMADA organization.

Utilize Epic Clarity, Business Object, SAP/Crystal, and other tools to complete daily tasks.

Developed various Key Performance Indicators (KPIs) at various stages of data pipelines to build End-user healthcare and medical dashboards.

Developing User Interactive PowerBI reports using various visualization Objects.

Optimized data models and visualizations maximizing Power BI’s Speed of response.

Integrate SharePoint with Power BI to provide seamless access to Power BI reports dashboards, and workspaces.

Ensure compliance with regulatory requirements by leveraging EPIC’s robust EHR system and Power BI’s reporting capabilities.

Perform Data transformation Using the Power Query editor.

Used Power BI Gateways to keep the dashboards and reports up to date.

Involved in Extracting data from multiple data sources into the Power BI application.

Analyzed, transformed, resolved, and assisted with the implementation and ongoing support of the Health Insurance Exchange (HIX) environments utilizing (Strategic planning, Business model analysis, Process design, and Systems analysis).

Extensively worked with EDI test files with implementation guides and gap analysis of EDI transactions.

Worked on troubleshooting of the entire claim processing issues with all the healthcare providers and hospitals.

Develops data quality checks and edits for data validation plans

Transactions focused on were 270,271, 834, 835, and 837 I/P

Worked on 837, 835, 276, and 277 Institutional and Professional, EDI Gateway.

Created healthcare reports to give a complete view of health and billing data

Created several EMR interactive reports and dashboards to put critical metrics at the fingertips

Embedding PowerBI workbooks from EPIC in a portal environment.

Designed and delivered training workshops and seminars for State of Arizona Department of Health staff members on SQL Server and Crystal Reports, equipping them with the skills and knowledge needed to independently generate and analyze public health reports.

Partnered with state and local public health agencies to enhance data interoperability and information exchange capabilities, leveraging standards-based data exchange protocols (e.g., HL7, FHIR) and web services to facilitate real-time data sharing and collaboration.

Create and maintain logical and physical data models to support business intelligence, analytics, and reporting requirements.

Developed and maintained a centralized data repository for public health surveillance data, integrating data from multiple sources including electronic health records (EHRs), laboratory systems, and vital statistics registries, to support epidemiological investigations and response efforts.

Design, build, and optimize ETL (Extract, Transform, Load) processes and data pipelines to ensure smooth and efficient data flow from various sources.

Monitor and optimize the performance of data systems and pipelines to ensure low latency and high throughput.

Ensure adherence to regulatory standards and guidelines (e.g., FDA, HIPAA) in all data-related activities.

Design and maintain healthcare-specific databases.

Aprecia Pharmaceuticals Blue Ash OH April 2017 – July 2018

BI Data Analyst II

Evaluate past sales data to identify trends, seasonality, and regional performance.

Designing and developing key metrics, reports, and dashboards to drive insights and business decisions to improve performance and reduce costs

Perform ad-hoc product data analysis to support product strategy development, corporate projects, due diligence, and synergy cases for new acquisitions.

Develop predictive models to forecast future sales and identify potential high-value customers.

Analyzing the requirements for Reporting needs.

Conduct EDA to uncover patterns, anomalies, and relationships within the data.

Creating interactive dashboards by extracting data from different sources.

Blended data from multiple databases into one report.

Created histograms, pie charts, box plots, scatter plots for inventory management, and background maps illustrating the potential revenue change.

Worked as tableau admin, maintaining users, groups and their permissions.

Clean and pre-process data using Python libraries (e.g., Pandas, NumPy) to ensure accuracy and consistency.

Perform exploratory data analysis (EDA) using Python and SQL to understand data distributions, identify trends, and spot anomalies.

Develop dashboards and reports using SQL-based visualization tools like Tableau

Developed visualizations and dashboards using Tableau Desktop and Web Intelligence

Developed Tableau workbooks from multiple data sources using Data Blending.

Developed Tableau Dashboards from scratch and published them on Tableau Online allowing the researchers and scientists to leverage the dashboards to get insights into the EHR data.

Use SQL to query and aggregate data from relational databases to extract meaningful insights.

Create visualizations using tools like Matplotlib, Seaborn, or Plotly in Python to present data in an understandable format.

Apply statistical methods and models using Python libraries (e.g., SciPy, Stats models) to analyze production data and identify areas for improvement.

Use SQL and Python to simulate different scenarios and assess the impact of potential changes on production performance.

Develop and maintain SQL databases and data pipelines to support ongoing analysis and reporting needs.

Kaiser Permanente Pleasanton CA May 2014 – March 2017

SQL Data Analyst

Played a critical role in managing data infrastructure, analyzing complex datasets, and providing insights to support our mission of delivering high-quality patient care.

Perform data extraction, transformation, and loading (ETL) processes.

Ensure compliance with healthcare regulations and data governance policies (e.g., HIPAA).

Collaborate with healthcare professionals to understand data needs.

Gained hands-on experience in developing ETL solutions using Informatica PowerCenter.

Monitor key performance indicators (KPIs) and metrics to evaluate the effectiveness of healthcare services.

Participated in requirement-gathering sessions and contributed to the design of data integration solutions.

Performed data analysis and validation to support data quality initiatives.

Prepared documentation and reports to track project progress and deliverables.

Demonstrated strong problem-solving skills by resolving issues efficiently, maintaining organization within complex ETL processes, and ensuring stability and reliable data flow. Consistently delivered detailed reporting to stakeholders, emphasizing my proficiency in solving technical challenges.

Improved processes, shrinking time spent gathering requirements by 50%, by converting business requirements into technical user stories in collaborative effort; applied Agile methodology.

Collaborated with customers to resolve complaints and warranty failures through systemic Problem-solving approaches

Acquire data from primary or secondary data sources and maintain databases/data systems.

Used Python and R to manipulate the data according to the requirement.

Proactively analyzed data using SQL, Python, R, and Microsoft Excel to answer key questions from clients to monitor product sales.

Provided business solutions to clients and increased total sales by up to 25%.

Used R to support the SQL analysis by implementing exploratory data analysis.

Used Python and R Markdown to present the reports with the ROC plots, graphs, and results of the models.

Created reports for users in Tableau by connecting to various data sources (MS SQL Server, Oracle, MS Excel, Netezza, .CSV).

Converted charts into Crosstabs for further underlying data analysis in MS Excel.

Contact this candidate