Summary
Overview
Work History
Education
Skills
Timeline
Generic
Manisha Kodimela

Manisha Kodimela

Edwardsville,IL

Summary

Healthcare Business Analyst with 3+ years of experience in interpreting and analyzing healthcare data to drive successful solutions. Proficient in statistics, mathematics, and analytics. Seeking to leverage expertise in business operations and analytics tools for effective data analysis. Skilled in Excel, MS Access with VBA coding, and data mapping best practices. Experienced in implementing data validation procedures to enhance data quality and accuracy. Proficient in SQL for extracting data from various healthcare databases. Familiar with HIPAA regulations and adept at managing multiple projects using Agile methodology. Innovative Business Data Analyst with experience in leveraging data-driven insights to drive business improvement and optimize overall performance. Strengths include strong analytical skills, ability to interpret complex data, and proficiency in tools such as SQL, Python, and Tableau. Demonstrated success in managing large datasets, creating detailed reports that inform strategic decision making. Proven record of collaborating with cross-functional teams to deliver valuable solutions for business growth.

Overview

3
3
years of professional experience

Work History

Business/Junior Data Analyst

Cognizant
Hyderabad, India
06.2021 - 05.2022
  • Reviewing Medicare transmittals for cost report changes and managing the annual instructional cost Report (ICR) audits
  • Writing analytical queries to extract data from cost reports using DBeaver and Oracle MySQL
  • Working with MDW Warehouse to extract encounter data, cost reports and analyze the future rate setting for the plans
  • Analyzed business requirements and provided support to the technical team in developing MS Access databases and related system using VBA and SQL programming as per established standards and procedures
  • Designing and executing efficient VBA code for developing new Access applications and modified access tables, database templates, SQL queries
  • Designing solutions, gathering department/bureau requirements, and performing analysis on Medicare data along with generating reports
  • Understanding various Medicaid reimbursement methodologies and assisting with rate appeals for new programs
  • Demonstrated new cost saving fiscal models for the upcoming programs
  • Responsible for analyzing and evaluating the criticality of issues and making decisions as to the appropriate level of escalation
  • Organized Functional Design Documents (FDD) handoff meetings with the Business and technical team, explaining them the requirements, review the Functional Designs and getting a formal signoff
  • Assured standardization of policies, procedures, workflows, in accordance with the organization's approved EHR practices
  • Knowledge of medical terminology, and procedure codes, pricing, and provider contracts
  • Experience working with transactional Databases and Data warehouse.
  • Provided technical support to users of analytical tools such as Excel, Tableau, Power BI, SAS.

Business Analyst

Mountpoint Technologies Private Limited
Bangalore, India
03.2019 - 05.2021
  • Used Epic and Meditech to review patient Electronic Medical Records (EMR) by analyzing documents pertaining admission and to determine patient stay in hospital
  • Analyzed and processed complex data sets using MySQL and Excel
  • Facilitate in-depth business discussions with senior management as needed
  • Executed quality control checks in the form of SQL queries to ensure data integrity and enforce business rules
  • Involved in data validation of the results in Tableau by validating the numbers against the data in the database tables by querying on the database
  • Created dashboards for analyzing POS data using Tableau 8.0
  • Performed ad-hoc requests for clients using Excel and customized SQL queries to extract and format requested information
  • Interacted with different business groups and end user to gather requirements, prepare and update Business Requirement Documents (BRD) and Functional Requirement Documents (FRD)
  • Extracted, analyzed, and presented data in a Graphical format using Microsoft Excel, such a way data helped project manager to make Business Decisions
  • Proficient in importing/exporting large amount of data from Excel files to Teradata and vice versa
  • Utilized Tableau server to publish and share the reports with the business users
  • Converted existing BO reports to tableau dashboards
  • Collaborated with clinical trial teams to develop and maintain databases for clinical study data collection and analysis
  • Developed stored procedures using PL/SQL statements for extracting as well as writing data
  • Expertise in generating graphs using MS Excel Pivot tables
  • Extracted data from existing data source, developing and executing departmental reports for performance and response purposes by using SQL, MS Excel
  • Worked on maintaining electronic medical records.

Education

Master of Science - Management Information Systems (Business Analyst)

Southern Illinois University Edwardsville
Edwardsville, IL
05-2024

Skills

  • Microsoft Excel
  • Microsoft Access
  • Power BI
  • Tableau
  • Windows
  • Mac OS
  • Tableau Desktop 9x/8x/7x
  • Tableau Server
  • Tableau Reader
  • Power Query
  • DAX (Data Analysis Expressions)
  • SQL
  • R
  • Python
  • SAS
  • Oracle SQL
  • XML
  • C
  • AWS
  • Microsoft Azure
  • Data Bricks
  • Teradata
  • MySQL Server
  • Electronic Health Records (EHR)
  • Claims databases
  • Jira
  • Trello
  • Agile/Scrum Methodology
  • Data Management
  • Data warehousing

Timeline

Business/Junior Data Analyst

Cognizant
06.2021 - 05.2022

Business Analyst

Mountpoint Technologies Private Limited
03.2019 - 05.2021

Master of Science - Management Information Systems (Business Analyst)

Southern Illinois University Edwardsville

Similar Profiles

CREATE PROFILE
Manisha Kodimela