APARAJITA RAO
Frisco,USA
Summary
Results-driven Junior Business Analyst experienced in requirements gathering and documentation, healthcare data system integration (Oracle MPI, HDW), and AWS/Azure cloud services for data migration and automation. Proficient in data analysis and visualization using Power BI, SQL, and R. Strong understanding of HIPAA, FHIR, and HL7 standards.
Overview
3
3
years of professional experience
Work History
Junior Business Analyst
Neeli's Genetics
Hyderabad, Telangana
12.2020 - 12.2022
- Collaborated with stakeholders to gather and document requirements for an advanced patient data management system, integrating Oracle Healthcare Master Person Index (MPI) and Oracle Healthcare Data Warehouse (HDW) for systems to streamline the storage, retrieval, and analysis of genetic data for personalized patient care.
- Utilized Power BI to create interactive dashboards that provided real-time insights into patient genetic information, as well as these dashboards enhanced clinicians' ability to track patient health trends and outcomes over time.
- Developed ETL processes using AWS Analytics to integrate patient data from various sources, including EHR systems like EPIC and Cerner, to facilitate seamless data flow across systems while ensuring compliance with HIPAA standards.
- Employed SQL and MongoDB to design and optimize queries for faster retrieval of large patient datasets. This improved the efficiency of clinical data analysis, enabling healthcare professionals to make timely, data-driven decisions.
- Designed automated reporting workflows using SAS Miner to generate daily and weekly reports on patient health metrics, improving accuracy and reducing manual effort.
- Organized cross-functional workshops with data scientists and healthcare teams to define requirements for predictive analytics models. Leveraged AWS SageMaker to support the development of machine learning models that predicted patient risk factors based on genetic data.
- Documented and tested APIs using Postman and Swagger to ensure interoperability between different healthcare systems, adhering to FHIR and HL7 standards. Eventually, this integration improved the accuracy and consistency of patient data exchange.
- Developed and enforced data governance frameworks to ensure compliance with privacy regulations, protecting sensitive patient information throughout the data lifecycle. This included implementing role-based access controls and audit trails for data access.
- Leveraged AWS HealthLake to ingest, store, and analyze large-scale patient genetic datasets, improving the organization's ability to manage population health and predict treatment outcomes for rare genetic conditions.
Junior Business Analyst
CYIENT, Infotech Enterprises
Hyderabad , Telangana
12.2019 - 11.2020
- Led the design and deployment of Azure-based cloud solutions using services like Azure Virtual Machines (VMs), Azure SQL Database, and Blob Storage to enhance the scalability and performance of enterprise applications. Deployed serverless architectures using Azure Functions and API Management to optimize resource utilization and reduce operational costs for microservices-based systems.
- Facilitated requirements gathering workshops with cross-functional teams to capture business needs and collaborated with DevOps engineers to set up CI/CD pipelines using Azure DevOps. Implemented automated build and deployment processes that enhanced the development lifecycle, reduced manual errors, and accelerated the project timeline.
- Assisted in seamless data migration to the Azure cloud, using Azure Database Migration Service to minimize downtime and ensure data integrity. Implemented robust security measures such as Azure Active Directory (AAD), Virtual Networks (VNet), and Key Vault to secure sensitive data, ensuring compliance with industry standards.
- Collaborated with data analysts to conduct data analysis and created detailed dashboards in Power BI, providing insights into operational performance. Utilized R programming for statistical analysis, which helped in understanding business trends and guiding strategic decision-making for the client.
- Engaged with stakeholders through feedback sessions to gather insights and refine system features. Authored technical documentation and process flow diagrams using Visio to visually represent system architectures. Additionally, developed detailed user manuals and training materials to support the smooth adoption of new system functionalities by end-users.
Education
Master of Science - Health Informatics And Analytics
University of North Carolina At Charlotte
Charlotte, NC05.2024
Bachelor of Science - Dental Surgery
GITAM Dental College And Hospital
Visakhapatnam, AP07.2020
Skills
- KPI Tracking
- Stakeholder collaboration,
- requirements elicitation,
- Quality Assurance
- ETL (Extract, Transform, Load)
- SQL
- MongoDB
- Oracle Healthcare Master Person Index (MPI)
- Oracle Healthcare Data Warehouse (HDW)
- Power BI
- R programming
- SAS Miner
- AWS HealthLake, AWS SageMaker,
- Azure Functions, Azure Virtual Machines (VMs), Azure SQL Database, Blob Storage, DevOps, CI/CD pipelines
- API Management
- Predictive Analytics
- HIPAA compliance s
- Audit trails
- Postman
- Swagger
- API documentation
- FHIR
- HL7 standards
Projects
- Hospital Readmission Reduction, Achieved a 15% decrease in readmissions by using SAS Miner and R for clustering and decision tree analysis.
- Mental health Analysis, Behavioral Risk Factor Surveillance System data were analyzed using SAS to pinpoint important mental health indicators and create prediction models, improving data-driven public health choices.
- IBM Telco Customer Churn, I have experience with SWOT, exploratory data analysis(EDA), statistical analysis, and logistic regression, achieving an accuracy of 91.99% in my results.
- Healthcare Cost Optimization, Identified and cut unnecessary spending by 15% via exploratory data analysis (EDA) and data visualization.
- Automated HIV/AIDS Testing, Enhanced testing kit accuracy and efficiency by 20% with Python, MongoDB, and SAS analytics.
Timeline
Junior Business Analyst
Neeli's Genetics
12.2020 - 12.2022
Junior Business Analyst
CYIENT, Infotech Enterprises
12.2019 - 11.2020
Master of Science - Health Informatics And Analytics
University of North Carolina At Charlotte
Bachelor of Science - Dental Surgery
GITAM Dental College And Hospital