MAHALAKSHMI GANESH
DUBLIN,OHIO
Summary
Passionate and analytical data enthusiast with a solid interest in data analysis techniques. Committed to elevating informed business decision-making by leveraging expertise in collecting, cleaning, and interpreting diverse datasets. Proficient in creating compelling reports and visualizations to proficiently convey valuable insights.
Overview
8
8
years of professional experience
Work History
Data Analyst
Numpy Ninja
03.2023 - Current
- SEPSIS Analysis
- I conducted a comprehensive analysis of a vast dataset, comprising 1.5 million rows, utilizing both Tableau and Excel to assess Sepsis incidence
- This involved in-depth exploratory data analysis, data cleansing, and addressing issues related to data missingness, particularly when faced with data containing over 50% missing values
- In addition to this conducted demographic analysis revealing higher susceptibility of males aged 65+ to sepsis, evidenced by extended length of stay, providing valuable insights for patient care strategies
- Furthermore, employed advanced Tableau techniques including Dual
- Axis, Control Charts, and Correlation Charts to identify crucial biomarkers (WBC, Platelets, base Excess, and lactate) affecting Sepsis incidence
- This insight underscores the need for clinicians' consistent monitoring and intervention
- My role extended to presenting critical business insights extracted from the data to a diverse audience, exceeding 100 individuals, which included stakeholders
- Additionally, I leveraged Tableau to derive key performance metrics for patients admitted to the ICU, facilitated by calculated fields
- These metrics have the potential to enhance ICU operational efficiency by a substantial 30%
- Lastly, I identified patients in the process of transitioning to the SIRS (Systemic Inflammatory Response Syndrome) stage of Sepsis, implementing an alert system that could promptly notify doctors via email for timely intervention
- Diabetes & Cerebrovascular Analysis
- My role in diabetes project illuminated my ability to derive critical insights from complex healthcare data, enhancing the understanding of
- Diabetes's intersection with Cerebrovascular health in elderly patients
- 43016 magikaish@gmail.com
- Linkedin | Tableau |Github Conducted data cleansing, summarizing, filtering, preprocessing, imputation, and consolidation for diverse clinical test results (MRI markers, lab tests, cognitive tests) using Power Query
- Crafted compelling Power BI visualizations for stakeholders, effectively communicating insights from demographic and health data
- Performed in-depth descriptive and statistical analysis, unveiling a significant 38% increase in Dementia risk among individuals with diabetes
- Discovered that 96% of long-term diabetic patients develop
- Hypertension
- Proficiently employed Python's pandas and numpy libraries for thorou data cleaning, wrangling, and missing data analysis
- Skilled in using matplotlib and seaborn for impactful exploratory data analysis and visualization
- Designed and implemented data access and transformation procedures, leveraging SQL expertise in Joins, Aggregate Functions
- SubQueries, Views, Stored Procedures, and Triggers
- Contributed to Agile Methodology implementation through
- Scrum framework and Trello, fostering streamlined project management practices.
Coordinator
Dublin Metro Dental Hospital
08.2021 - 04.2022
- Assumed accountability for verifying patient insurance eligibility and devising tailored payment arrangements
- Translated patient eligibility into insurance codes for treatment planning
- Managed daily income reporting via ERS reports and generated monthly ARA reports to analyze payment gaps
- Initiated consistent communication with patients and insurance companies to ensure resolution of outstanding balances.
Senior Associate
City Union Bank
05.2015 - 06.2019
- Validated and debugged tax-related issues to ensure compliance and accuracy, utilizing advanced querying skills to analyze data
- Developed and executed SQL queries in platform to identify discrepancies and inconsistencies and collaborated with business and vendor teams to resolve issues and maintain compliance with federal and state tax regulations
- Participated in the integrated data testing process for a new operating platform, "Bancs," to validate on various dimensions such as Deposits, Loans and Advances, and
- Clearing Operations
- Created business views from the semantic layer on customer, account from relational datamart
- Applied deep domain knowledge and process expertise to train junior associates and ensure high-quality work across the organization.
Education
B.Tech - Computer Science Engineering
SASTRA
UNIVERSITY
Skills
- Statistical Data Analysis
- Documentation
- Requirements Gathering
- Query Writing
- Problem
- Solving
- Analytical Skills
- Databases
- Data Visualization
- SQL
- Dashboard
- Presentations
Analytics
- Data Analytics
- Data Validation
- Visualization
- Jira
- Trello
- GitHub
- Microsoft Power BI
- Python
- (Programming Language)
- Tableau
- PostgreSQL
- Jupyter
- Panda
Additional Information
- Awards: , Python Hackathon conducted by Numpy Ninja Team on July 2023 Winner.
Timeline
Data Analyst
Numpy Ninja
03.2023 - Current
Coordinator
Dublin Metro Dental Hospital
08.2021 - 04.2022
Senior Associate
City Union Bank
05.2015 - 06.2019
B.Tech - Computer Science Engineering
SASTRA
UNIVERSITY
Similar Profiles
Padmini ElangovanPadmini Elangovan
SDET at Numpy NinjaSDET at Numpy Ninja
Gomathi RajaGomathi Raja
Data Analyst at Numpy ninjaData Analyst at Numpy ninja
SHEILA STEPHENSHEILA STEPHEN
Data Analyst at Numpy NinjaData Analyst at Numpy Ninja
Manasa VennaManasa Venna
Software Development Engineer in Test at Numpy NinjaSoftware Development Engineer in Test at Numpy Ninja
Fawzie KurdiFawzie Kurdi
ContactUs Communications at Communications CompanyContactUs Communications at Communications Company