Home

Chaitanya katuri - Business analyst

[email protected]

Location: Hartford, Connecticut, USA

Relocation: Yes

Visa:

Krishna chaitanya +1 (860) 479-2477 [email protected] Professional Summary Around 8 years of experience as a Business Analyst with adept at designing and implementing data-driven solutions to address key challenges in healthcare delivery, revenue cycle management, insurance and quality improvement. Ensured compliance with industry regulations to HIPAA safeguarding patient privacy and confidentiality. Strong knowledge of HITECH, Medicare and Medicaid Services, SNOMED-CT, LOINC, ICD 9and ICD 10. Stayed informed about industry trends and advancements in HL7 integration technologies, seeking to apply new knowledge and skills to improve integration processes. Experienced working on EDI transactions 271 (eligibility response), EDI 276 (claim status), and EDI 834 (enrollment). Utilized Databricks for advanced data analysis, processing large datasets efficiently. Applied knowledge of relational database principles including normalization and referential integrity to ensure data accuracy and consistency. Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from an Operational Data Store to an Enterprise Data Warehouse. Extensive experience in designing and developing data warehouses and marts, enabling comprehensive data analysis and reporting capabilities. Familiar with statistical analysis techniques and software's such as R and Python to derive meaningful insights from data to automate tasks and enhance data analysis capabilities. Implemented metadata standards, Collibra Data Governance, stewardship, master data management, ETL, ODS, data warehouse, reporting, dashboards, analytics, segmentation, and predictive modelling. Implemented Azure pipelines to automate the deployment of EDI integration. Effectively utilized JIRA for task management, including creating, prioritizing, and tracking tasks. Played a key role in translating business requirements gathered from JAD sessions into clear and concise technical specifications. Identified and addressed bottlenecks using Kanban, leading to streamlined processes and better resource utilization. Developed clear and concise Business Requirements Documents (BRDs) detailing functional requirements, use cases, and acceptance criteria. Tracked and managed steps from patient admission to discharge, ensuring smooth transitions and minimal delays using Kanban. Visualized and managed patient flow in emergency departments, reducing overcrowding and improving response times with Kanban. Used Kanban to continuously prioritize and reprioritize tasks, effectively adapting to changing patient needs and circumstances. Implemented automated data quality checks and monitoring processes to detect anomalies and discrepancies in Epic-External System data, proactively addressing data consistency issues. Experienced in creating data mapping documents, ERD diagrams, and specifications to outline the relationships and transformations between different data sets. I had extensive experience with DML (Data Manipulation Language), DDL (Data Definition Language), and DCL (Data Control Language) commands, and tackled complex SQL queries. Participated in data migration projects involving extraction, transformation, and loading (ETL) of data between databases using SQL scripts and tools. Identified potential risks and challenges associated with data migration, such as data security, compatibility issues, or system downtime, and developed mitigation strategies. Implemented advanced analytics techniques in Power BI, including predictive modeling, clustering, and time-series analysis, to uncover trends and patterns in the data. Blended and joined multiple datasets from disparate sources within Tableau to create comprehensive views and analyses. Skills SQL: Proficient in writing complex queries for data extraction, analysis, and reporting. Power BI: Experienced in creating interactive dashboards and data visualizations. Tableau: Skilled in designing and developing visual reports and dashboards. SAP BusinessObjects: Knowledgeable in creating reports and managing data. ETL Tools: Familiar with ETL processes and tools like Informatica, Talend, and SSIS (SQL Server Integration Services). Microsoft Azure: Experience with Azure Data Factory, Azure SQL, and Azure DevOps. Python/R: Basic scripting for data analysis and automation. Advanced Excel: Proficient in pivot tables, VLOOKUP, macros, and data analysis tools. Salesforce: Experience with Salesforce CRM for data management and reporting. Agile Tools: Proficient with tools like Confluence and Trello for project management and documentation. Data Modeling: Knowledge of creating entity-relationship diagrams (ERD) and data flow diagrams (DFD). API Testing: Experience with Postman or SoapUI for API testing and validation. BPM Tools: Proficiency in Business Process Model and Notation (BPMN) and tools like Bizagi or Lucid chart. Version Control: Understanding of Git/GitHub for version control. ERP Systems: Experience with SAP, Oracle, or similar enterprise resource planning systems Work History: Senior Business Analyst, 05/2022 to Current Aetna Hartford, CT Conducted regular audits and quality checks on EMR data migration processes to ensure data integrity and accuracy throughout the migration lifecycle. Led knowledge sharing and training sessions to teach stakeholders about EMR data migration processes, best practices, and possible effects on clinical workflows." Kept up with industry trends, regulations, and best practices related to EMR data migration and healthcare informatics through self-study, training programs, and professional development opportunities Utilized domain knowledge of EMR functionalities and workflows to interpret migration metrics and identify areas for optimization and process improvement. Conducted data quality assessments and audits to verify the accuracy and completeness of data dictionary entries, identifying gaps and inconsistencies for resolution. Documented detailed specifications and business rules in accordance with waterfall methodologies, ensuring alignment with project objectives and regulatory requirements. Utilized waterfall methodologies to document data profiling results and prioritize data cleansing and transformation tasks based on project timelines and resource constraints. Assisted in the development of migration plans and schedules based on waterfall methodologies, defining tasks, dependencies, and milestones for each phase of the project. Designed and developed Tableau dashboards to track the progress of EMR data migration activities, providing real-time visibility into migration status, completion rates, and data volumes. Assisted in the development and implementation of data governance policies, standards, and procedures related to data lineage management. Maintained detailed documentation of EMR data migration processes, including data mapping specifications, transformation rules, test cases, and validation results. Translated business needs into clear and concise business requirements documents (BRDs), outlining objectives, scope, and success criteria for the data migration initiative. Utilized SQL queries to extract data from legacy EMR systems and other source systems, ensuring completeness and accuracy of the migrated data. Implemented best practices and standards for data lineage management, ensuring consistency and alignment with industry standards and regulatory requirements. Collaborated with stakeholders, including clinicians, IT personnel, and administrators, to gather and document business requirements for EMR data migration projects. Supported data migration and integration efforts by mapping data sources to target systems and documenting data transformation requirements in the data dictionary. Developed functional requirements documents (FRDs)to specify the desired behavior and functionality of the EMR system during data migration activities. Identified and documented non-functional requirements (NFRs) related to performance, security, scalability, and reliability of the EMR data migration process. Transformed and standardized data formats and structures using SQL scripts and data manipulation techniques, resolving inconsistencies and preparing data for migration. Collaborated with data architects and modelers to ensure accuracy and completeness of data lineage diagrams, incorporating feedback and updates as needed. Generated regular reports and dashboards using SQL queries and reporting tools to provide stakeholders with insights into migration progress, data quality metrics, and key performance indicators. Developed Tableau dashboards to visualize data quality trends and identify areas of concern, such as missing data fields, duplicate records, and data mapping errors. Provided training and support to end-users on data access policies and procedures outlined in the data dictionary, promoting data security awareness and best practices. Utilized Tableau Prep Builder to perform data cleansing, validation, and transformation tasks, resolving data quality issues and inconsistencies prior to migration. Senior Business Analyst, 11/2019 to 03/2022 Highmark Health Pittsburgh, PA Mentored junior analysts on data analysis techniques and provided guidance on interpreting findings to support informed decision-making in claims conversion optimization efforts. Conducted comprehensive claims conversion gap analysis for, identifying discrepancies between incoming claims and processed claims, resulting in reduction in claim processing errors. Developed and executed validation scripts and queries to compare converted claims data against source systems, identify variances and anomalies for further investigation. Participated in post-implementation reviews and lessons learned sessions to identify opportunities for optimization and enhancement of claims conversion processes and methodologies. Leveraged Agile principles such as incremental delivery and frequent feedback loops to iteratively improve claims conversion processes and outcomes over time. Monitored and reported on the progress of claims conversion gap analysis tasks within Agile sprints, identifying risks, issues, and opportunities for course correction. Collaborated with cross-functional teams including data engineers, developers, and business analysts to ensure alignment of data mapping activities with project objectives. Defined and tracked key performance indicators (KPIs) related to claims conversion rates, turnaround times, and accuracy, using Agile project management tool like Jira. Optimized data mapping processes for performance and efficiency, leveraging indexing, partitioning, and other optimization techniques to minimize processing time and resource utilization. Identified recurring patterns and trends in conversion gaps through SQL-based data mining techniques, enabling proactive intervention and process improvement initiatives. Utilized data profiling techniques to analyze data distributions, patterns, and anomalies, identifying potential data quality issues. Engaged in iterative analysis cycles within agile sprints, reviewing and validating analysis results with stakeholders to gather feedback and refine requirements. Conducted interviews and workshops with business users and subject matter experts to refine user stories, ensuring clarity, completeness, and alignment with business objectives. Designed and maintained a comprehensive traceability matrix to map user stories to specific data elements, system functionalities, and business requirements related to claims conversion. Acted as a liaison between technical and non-technical stakeholders, translating business requirements into technical data mapping specifications. Engaged with stakeholders to gather feedback and insights on user stories, traceability matrix, and gap analysis findings, incorporating feedback into iterative improvement cycles. Collaborated with stakeholders to elicit and document user stories related to claims conversion processes, capturing requirements and expectations from end-users. Utilized SQL queries to segment claims data based on conversion status, identifying claims stuck in various stages of the conversion pipeline. Ensured compliance with data governance policies and regulations by conducting data profiling assessments against established standards and guidelines. Developed SQL queries to extract and aggregate claims conversion data into performance dashboards and reports, providing stakeholders with real-time visibility into conversion metrics. Utilized Power Query in Power BI to perform data cleansing, transformation, and merging operations, resolving inconsistencies and preparing the data for analysis. Leveraged Power BI's analytical capabilities to perform root cause analysis and identify underlying factors contributing to claims conversion delays and denials. Presented data profiling reports and insights to management and cross-functional teams, facilitating data-driven decision-making and prioritization of data improvement initiatives. Established automated reporting processes in Power BI to monitor claims conversion performance on an ongoing basis, providing timely insights to decision-makers. Business Analyst, 02/2018 to 09/2019 Oscar Health New York, NY Designed and developed Power BI dashboards to visualize key metrics and trends derived from ERA data, such as claim payments, adjustments, denials, and reconciliation status. Led the integration of HL7 data with Electronic Health Record (EHR) and Electronic Medical Record (EMR) systems to streamline data exchange and improve interoperability in healthcare settings. Establish seamless integration between HL7 data and EHR/EMR systems. Ensured compliance with regulatory requirements such as HIPAA, safeguarding patient privacy and confidentiality. Defined functional requirements for mapping HL7 message segments to corresponding data fields in health care systems, ensuring accurate data exchange and interoperability. Prepared comprehensive Business Requirements Documents (BRDs) outlining the scope, objectives, and functional requirements of HL7 integration projects. Utilized JIRA as part of Agile project management methodologies, including Scrum for sprint planning, backlog management, and sprint execution. Leveraged JIRA's Agile boards and workflows to facilitate collaboration, transparency, and continuous improvement throughout the project lifecycle. Facilitated and engaged in Joint Application Development (JAD) sessions alongside subject matter experts (SMEs) and project team. I've been involved in various HL7 message types such as Admit Discharge Transfer (ADT), Orders (ORM), and Results (ORU). Collaborated with senior analysts to document data migration requirements, including field mappings, data cleansing rules, and data validation criteria. Proposed and implemented improvements to data lineage documentation methodologies, tools, and systems to streamline data lineage tracking and analysis. Facilitated knowledge sharing sessions with team members, sharing insights and lessons learned from HL7 integration projects to foster continuous learning and improvement. Conducted data profiling and quality assessment using SQL queries to monitor data completeness, consistency, and adherence to HL7 standards and specifications. Integrated Tableau and Power BI for creating interactive dashboards and visualizations to monitor key healthcare metrics and trends. Created detailed dashboard reports that offered valuable insights for data integration, leading to a 20% boost in operational efficiency. Successfully integrated HL7 data with EHR/EMR systems, reducing manual data entry and minimizing errors. Business Analyst, 09/2015 to 11/2017 Accolade Health Plymouth, PA Developed comprehensive data mapping strategies to align data fields and attributes between Epic and external systems, facilitating efficient data exchange while maintaining consistency. Implemented performance optimization techniques to enhance data synchronization processes, optimizing data transfer speeds and reducing latency between Epic and external systems. Facilitated workshops and meetings to review and validate data mapping specifications, fostering consensus and alignment among stakeholders. Ensured compliance with industry regulations to HIPAA and organizational policies governing data privacy and security in all data integration initiatives involving Epic and external systems. Provided training and mentorship to junior analysts and end-users on best practices for maintaining data consistency between Epic and external systems, empowering teams to proactively address data-related challenges. Leveraged data management tools and technologies, such as Collibra, and Alation, to centralize and automate data dictionary management processes. Implemented data quality checks and validation procedures to ensure the accuracy, completeness, and consistency of data mappings throughout the data lifecycle. Employed Agile methodologies to manage and prioritize data consistency tasks effectively, resulting in accelerated delivery cycles and increased responsiveness to evolving business needs. Translated complex business requirements into actionable user stories, facilitating clear communication and alignment between cross-functional teams. Optimized SQL queries and procedures for efficient data retrieval and processing, minimizing latency and enhancing system performance. Developed data models and schemas within the data dictionary to standardize data structures and naming conventions, facilitating data integration and interoperability. Established data governance frameworks and standards for data mapping processes, ensuring consistency, accuracy, and compliance with organizational policies and regulations. Conducted basic data analysis using Tableau to identify trends and patterns within health care system data obtained through external data. Education Master of Science: Computer Science Keywords: business intelligence rlang information technology Connecticut New York Pennsylvania