HARI N

Healthcare Data Analyst

940-***-**** ad3mn7@r.postjobfree.com

PROFESSIONAL SUMMARY

Dedicated and results-driven Healthcare Data Analyst with 5+ years of experience gathering and interpreting data from a variety of sources, developing and implementing HL7FHIR-based applications, and analyzing data to assist in delivering quality health. Expertise in ensuring HIPPA and FDA compliance with healthcare regulations, coding using ICD-10 and CPT codes, and analyzing health data for BRD creation. Proficient in CDA data quality monitoring, ETL tools (Informatica), and SQL queries. Skilled in Agile methodologies, using tools like Confluence, scrum, Kanban, and JIRA. Excellent communication and interpersonal skills coupled with a strong experience in data profiling, optimizing ETL workflows, and designing Tableau visualizations. Technical skills include Data Analysis, HL7, FHIR, HIPAA, ICD 9/10, CDA, SQL, SAS, Python, AWS RDS, Teradata, Git, and Tableau.

PROFESSIONAL EXPERIENCE

HEALTHCARE DATA ANALYST Globe Life, McKinney, TX August 2022 – Present

Developing and implementing HL7 FHIR-based applications across various healthcare systems, showcasing expertise in healthcare data coding using ICD-10 and CPT codes

Collecting, analyzing, and organizing healthcare data to create comprehensive Business Requirement Documents (BRD), Functional Requirements (FR), and Non-Functional Requirements (NFR)

Reviewing complex claims, and determining appropriate reimbursement through a thorough understanding of benefit and contract configurations

Collaborating with cross-functional teams to ensure accurate and timely configuration of benefits and contracts, streamlining the contract configuration process while utilizing JIRA to attend sprint meetings and foster collaboration with team members

Demonstrating proficiency in data mapping, analyzing requirements and business rules for effective source-to-target mapping

Gathering business requirements and updates, creating test plans in collaboration with stakeholders, and writing detailed user stories and use cases following Agile methodology

Managing large data warehouses with Azure Data Bricks using HL7 FHIR standards, involving data transfer from SSIS to Azure Data Bricks, and performing data cleaning and transformation using Pyspark and SQL

Optimizing ETL workflows using Informatica and Informatica Cloud, enhancing data processing speed and efficiency through techniques like partitioning, indexing, and query optimization

Conducting complex analysis on large datasets, writing complex SQL queries, stored procedures, and subqueries in Azure SQL

Monitored and ensured data integrity and quality across multiple systems, including CRMs, ERPs, MDM, and databases, to provide accurate insights for sales teams.

Received, interpreted, and efficiently completed ad hoc data requests from various customer-facing teams, demonstrating adaptability and responsiveness.

Conducting comprehensive data analysis utilizing advanced analytical tools and methodologies to extract meaningful insights from intricate datasets.

Utilized intermediate Excel knowledge to manipulate and interpret large datasets, ensuring accuracy and reliability in reporting and analysis.

Collaborated with IT department to integrate SAP system with existing CRM platform, streamlining data flow and enhancing overall system efficiency.

Working closely with stakeholders, prioritizing requirements, and making changes to projects as necessary using Agile methodology.

Designed and maintained user-friendly databases using SQL, SSIS, and Alteryx, ensuring availability and accuracy of data for reporting needs.Proficient in Microsoft Excel, including creating spreadsheets and graphs

Experience with visual basic and crystal reports for customized reporting solutions.

Tracking user stories in Jira, analyzing priorities, ensuring timely completion within sprints, and communicating with development and QA teams to clarify requirements.

Developed and implemented automated queries and reports, reducing manual efforts and streamlining reporting processes

Performed UAT to align system functionality with user requirements, while developing and maintaining Power BI dashboards and reports, offering timely insights for data-driven decision-making.

expertise in Excel to perform in-depth data analysis and create dynamic reports for executive decision-making

Leading Data Governance and analysis initiatives using SQL in an Agile team dedicated to clinical data operations, spearheading the development and implementation of data quality standards and processes.

Created visually appealing and insightful reports using various visualization techniques like charts, graphs, maps, and KPIs.

Conducted A/B testing to evaluate the effectiveness of different pricing strategies and identify the optimal approach.

Developed interactive dashboards using Power BI and DAX, providing stakeholders with actionable insights into key metrics.

Developed complex calculations and measures using Data Analysis Expressions (DAX) to derive valuable insights from data.

Deployed Power BI reports and dashboards to Power BI Service for sharing and collaboration across the organization.

Environment: ICD 10, CPT, EMR, EHR, HIPAA, HL7, FHIR, SQL, UAT, Jira, Git Repository, Informatica, Informatica cloud, Azure Blob storage, Azure SQL, Power BI, SSIS, SQL, Agile

DATA ANALYST ITC Limited, Hyderabad, India June 2019– August 2021

Generated and oversaw Business Requirement Documents (BRDs), functional and non-functional requirements, collaborating closely with stakeholders to ensure a clear definition and understanding of their needs

Collaborated with teams to gather requirements, translating technical details into accessible documentation for business owners, ensuring perfect IT solutions alignment with business goals

Crafted User Stories and User Acceptance criteria in Confluence, capture stakeholder requirements and expectations effectively

Implemented data mapping processes to facilitate the seamless transfer of data between source and target systems, identifying data elements, and establishing data definitions.

Deployed Agile methodology to expedite the completion of data analysis and visualization projects, ensuring timely delivery

Developed and tested complex SQL queries in SQL Server, utilizing joins, subqueries, triggers, and views to ensure data accuracy and integrity

Established and utilized Jira for managing software development projects, monitoring progress, and ensuring efficient project management

Designed and executed comprehensive User Acceptance Testing (UAT) plans to identify areas for improvement and recommend solutions

Engaged with Data Governance and analysis using SQL stewards in data profiling activities, providing crucial support and insights for well-informed decision-making

Demonstrated expertise in designing and developing diverse dashboards and reports using Tableau visualizations, incorporating Dual Axis, Bar Graphs, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualizations, and other features tailored to meet end-user requirements

Environment: Medicare & Medicaid, HIPAA, EHR, Agile, SQL Server, UAT, Jira, Tableau, MS Access, MS Visio, MS Project, MS Office

CLINICAL DATA ANALYST Sun Pharma Laboratories, India June 2018-April 2019

Worked with diverse therapeutic areas such as oncology, immunology, endocrinology, and gastroenterology

Covered various clinical trial domains, including demographic data, adverse events (AE), serious adverse events (SAE), disposition, medical history (MH), ECG, exposure, concomitant medication (CM), vital signs (VS), and laboratory data

Conducted Joint Application Development (JAD) sessions to create Business Requirements Documents, updating them in sprint plans, and assigning stories in Jira

Designed user-friendly guides and training materials to clearly explain system features, assisting business owners and end users in comprehending and making appropriate use of them

Created detailed user requirements documents capturing business processes, resonating with both business owners and IT development teams

Maintained sizable patient data collections in well-organized Excel spreadsheets

Actively participated in analyzing, creating, and documenting data specifications and business requirements

Utilized SQL server tables with facts and dimensions for secure data storage

Leveraged Tableau's custom SQL feature for building complex and performance-optimized dashboards, including connections to SQL servers for remote patient monitoring system analysis

Demonstrated expertise in designing star and snowflake schemas, ETL data migration procedures, and performing reporting and performance analysis on complex patient data

Identified anomalies and irregularities in patient data to ensure data integrity, while recognizing patterns and trends to identify potential medical issues

Examined vital signs and medical history to issue necessary health warnings, collaborated with the QA team for UAT, evaluated outcomes, and identified areas for improvement

Utilized Tableau Desktop to integrate live datasets, reviewed and edited SQL queries, performed inner, left, and right joins, and created dashboards to monitor system usage and assess results

Collaborated with IT teams to ensure strict adherence to established data governance and analysis using SQL processes, ensuring consistent data integration across systems

Environment: MS Excel, MS PowerPoint, MS Access, MS Office, Agile, SQL server, Tableau

EDUCATION

Master’s in Health Informatics University of North Texas, Denton, TX, USA - 3.96 GPA

TECHNICAL SKILLS

Healthcare Expertise HL7, FHIR, HIPAA, ICD 9, ICD 10, CDA, EDI 835, 837C

Programming Languages SQL, SAS, Python

Databases SSIS, AWS RDS, SQL server, Teradata

Tools Git, JIRA, Confluence

Visualization Tools Tableau, Power BI

Cloud Services AWS, Azure

Contact this candidate