SUMMARY

• 6 years of hands - on experience as Data analyst with excellent skills in analyzing healthcare data by using SQL server, power BI, Tableau and Microsoft excel.
• Worked on Cerner applications Citrix Workspace, Relay and Health quest for claims processing and medical billing in uniform billing (UB04) and CMS (1500).
• Worked in Epic clinical applications and handled EMR, EHR and Epic ambulatory services.
• Worked with 12 different insurance companies and Proficient in Medicare billing and confidential billing.
• Experienced working on EDI Transactions (835,837,270,271,820,277,278).
• Experienced in EDI testing with good understanding of quality assurance and methodologies.
• Knowledge and experience in EDI data mapping and migration.
• Experienced organizing and attending JAD sessions with SME’s, project manager, developers and end users to elicit and analyze the business requirements, functional and non-functional requirements.
• Worked on MS office and created Use cases, Use cases diagrams, sequence diagrams, Activity Diagrams and class diagrams.
• Expertise in various types of SDLC (software development life cycle) like waterfall and Agile methodologies.
• Created and maintained data dictionary, data mapping, data requirement documents.
• Used ETL tools for data migration from cloud database such as AWS, GCP, Azure cloud to traditional database.
• Worked with variety of tools (ex; SQL Server, My SQL, oracle SQL, Access, Excel, Tableau, Power BI, Visio, etc.) to access data and write queries, run reports, manipulate and analyze large datasets.
• Applied knowledge of SQL table joins, DDL, DML, PIVOTS views, constraints and functions to SQL server.
• Worked on Data bricks for data extraction, transformation and analyzing the data.
• Worked with Azure data bricks to speed up the preparation of high-quality data.
• Created different data bricks clusters needed for batch and continuous streaming data processing.
• Worked on Migrating Teradata elements into snowflake environment.
• Created database, schema, tables using snowflake schema and migrated multistate level data from SQL server to snowflake.
• Maintained knowledge in designing star schema and snowflake schema for data modeling and created user stories using JIRA tool.
• Developed tableau visualizations using the Confidential t data to create reports and dashboards using tableau.
• Experience in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.
• Extensive experience in creating Calculations (Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Marks Card Changes, Rich Text Formatting,) using Tableau Desktop.

TECHNICAL SKILLS

Computer Skills: Data visualization, Data Cleaning, Data Mining, Data Warehouse, Microsoft. Office (Access, Word, Excel, Power point, Visio), Cerner Applications such as Citrix workspace, Health Quest, Relay, Microsoft teams, problem solving and analytical abilities.

Analysis Tools: My SQL, SQL server, Oracle, Tableau Desktop, MS-Excel, Power BI, R Studio, Spreadsheets, Microsoft Azure, Visio.

Languages: SQL, R, SAS, Oracle SQL, XML.

Cloud services skills: AWS, Google Cloud Platform (GCP), Microsoft Azure and Data Bricks.

Tools: Git, JIRA, Informatica.

Databases: Oracle, MS Access, SQL.

Operating systems: Windows, LINUX, Mac OS, UNIX and DB2.

Expertise: Strategic application of IT in healthcare, Advanced Healthcare Data Analytics, Electronic healthcare records, Information Analysis and System Design, Database Design and oracle, Evidence based Practice, Clinical and Business intelligence, Healthcare Operations, Population Health, Convergence of Healthcare and information technology and legal aspects of healthcare IT.

PROFESSIONAL EXPERIENCE

Confidential, NJ

Data Analyst

Responsibilities:

• Collected and organized large amounts of pharmaceutical data and healthcare data from various sources.
• Cleaned the processing pharmaceutical data to check accuracy and completeness.
• Analyzed the data using statistical techniques and created meaningful insights and visualizations.
• Worked on trends, patterns, and relationships in the data to support decision-making by healthcare providers and administrators.
• Ensured compliance with healthcare data standards and regulations, including HIPAA and HITECH.
• Developed predictive models and algorithms to support personalized Confidential t care.
• Worked with healthcare professionals, IT teams, and other stakeholders in a clear and concise manner.
• Worked on data security to ensure the privacy relevant to regulations and standards.
• Designed reports and dashboards for use by program managers and external stakeholders by using tableau.
• Maintained excel workbooks, such as development of pivot tables exporting data from external SQL database, producing reports and updating spreadsheet information.
• Segregated the data in tableau by creating calculated fields for more accurate creation of dashboards and reports.
• Merged data from SQL server into tableau to create reports for presentation.
• Experienced agile methodologies, development models and process and wrote Business required documents (BRD).
• Experienced creating star schema and snowflake schema and ETL processes.
• Implemented snowflake schema to ensure no redundancy in the database.
• Worked closely with technical teams to assess data migration requirements from Oracle DB to Google cloud platform (GCP) following ETL process.
• Created power BI dashboards for data visualizations and reports.
• Worked on project by using API interface and understood business required documents for API and used programming language such as Python, Java and Java script and developed custom scripts.
• Used SQL joins and sub-queries to simplify complex queries involving multiple tables.
• Monitored and maintained API integrations for any issues or errors and worked to resolve them.
• Extracted the data from API interface and made it secure and compliant with relevant regulations.
• Experienced in creating and maintaining data dictionaries for multiple data sources, ensuring that data.
• Calculated and analyzed digital health data for provider incentive and supplemental benefit analysis using Microsoft Access and Oracle SQL.

Environment: SQL, GCP CLOUD, ORACLE DB, POWER BI, MS ACCESS, TABLEAU.

Confidential

Data Analyst

Responsibilities:

• Analyzed healthcare claims data and identified trends and patterns, such as high-cost medical procedures and recommended for cost saving measures.
• Conducted Ad-hoc analysis and provided recommendations to support business requirements.
• Developed and implemented data management process that improved data quality and data security.
• Created dashboards and reports that allows to track key metrics and performance indicators.
• Worked on industry trends, regulations and best practices in data analysis and data management.
• Worked closely with interpretation of large data sets that improved business operations.
• Analyzed claim appeals, approvals, denials and reimbursement guidelines.
• Created dashboards and reports for Co-payment, deductible and Co-insurance by using Tableau.
• Worked on Cerner Applications such as Citrix workspace, health quest, relay to access claims account server and claim processing.
• Involved in development of new insurance products and services to meet changing customer needs and market trends.
• Evaluated insurance policies and ensured that its appropriate and effective.
• Validated data according to HIPAA, EDI, PHI and HITECH regulatory standards.
• Collected and analyzed the insurance policy records, financial reports by using MS- Access.
• Extensively worked on appeal filing limit and timely filing limit for insurance billing.
• Verified EDI X12 271(eligibility response), EDI 276 (claim status) and EDI 834 (enrollment) for claims processing.
• Worked with providers to validate EDI transaction sets.
• Created EDI documents for EDI maps to generate requirement documents.
• Reviewed SQL queries to create tables, trend, pivots, and list reports.
• Worked on API integration and have good knowledge about data formats such as RESTful APIs, JSON and XML.
• Performed source to target data mapping by using SQL.
• Developed tableau visualizations using the Confidential t data to create reports and dashboards using tableau.
• Designed several business intelligence dashboards reports using power BI.

Environment: MS-excel, MS- access, MY SQL, Cerner Applications, Tableau.

Confidential

Data Analyst

Responsibilities:

• Conducted in depth analysis of healthcare data to identify trends, patterns, and relationships that used for decision making.
• Worked with cross-functional team including healthcare providers, administrators, and IT professionals to ensure that data is used effectively.
• Collected and analyzed health data from various sources, including Confidential t surveys, and wearable devices.
• Conducted cost analysis to determine the financial impact of various healthcare and cost saving measures.
• Used spreadsheets to organize and manage the data, including creating pivot tables, charts, and graphs to summarize the data and identify trends.
• Used Tableau to visualize the data and present findings in an interactive and engaging format. Created dashboards, maps, and other interactive visualizations that help stakeholders understand the insights and predictions generated from the data. developed predictive models that can forecast Confidential t outcomes based on demographic and clinical data by using tableau. perform statistical analysis, including regression analysis, hypothesis testing, and time-series analysis by using MS-excel and spreadsheets.
• Worked on statistical and machine learning techniques that used for analyzing the data and identify the patterns.

Environment: MS-excel, MS- access, MY SQL, Tableau, spreadsheets.

Confidential

Healthcare Data Analyst

Responsibilities:

• Collected and cleaned Confidential t satisfaction data from various sources, such as surveys, interviews, and focus groups.
• Analyzed the data using statistical methods and data visualization techniques to identify patterns and trends in Confidential t satisfaction. Identifying areas for improvement in the hospital's services and Confidential t experience based on the data analysis.
• Presented findings and recommendations to relevant stakeholders, such as hospital administrators, physicians, and staff, to inform decision-making.
• Assisted with the implementation of recommendations, including the development of action plans and monitoring progress over time.
• Continuously monitored and evaluated Confidential t satisfaction data to ensure that the hospital is making progress towards enhancing Confidential t satisfaction.
• Collaborated with other team members, including hospital administrators, physicians, and staff, to ensure that Confidential t satisfaction data is collected and analyzed effectively.
• Collected and organized Confidential t organized data to create forms or surveys that can be distributed to Confidential ts by using spreadsheets.
• By using MS- word Created reports and presentations to share the findings and recommendations from the Confidential t Satisfaction Analysis project.
• Using Excel to clean and organize Confidential t data and performed statistical data and created charts and graphs to visualize data.

Environment: MS-Excel, Spreadsheets, MS-word.