Pavan Kumar
*********.***@*****.***
https:/www.linkedin.com/in/nagapavansn-
Experience Summary
AS a Sr BI Consultant I have 11+ years of experience in Gathering Analyzing Designing and Interpreting Enterprise data for Health insurance clients UHG, Transamerica with SQL, T SQL, SSRS, Python, R, Qlik, Tableau, Power BI, Advanced Excel.
Strong experience programing language skill Java, Python, R.
Created Tableau Dashboards for management to figure out which deals give more benefit by analyzing data.
Drawing insights from the reports and present to the management for decision making.
Created input forms with help of MS- Access for live production tracking and ticket status.
Expert in Excel with knowledge of V-lookup, H lookups, Pivots, Charts, Power Queries, Macros, and Scripting VBA.
Handling the reports through version control tools like GIT, Git Hub
Hands on experience with the ticket monitoring and assigning tools like JIRA and ServiceNow.
Strong experience with cloud technologies like AWS and Azure.
Experience in working with different operating systems windows, Mac, and Linux.
Managing the properties of client and delivering the projects in SLA’s.
Good experience with healthcare clients, worked with Optum, United Health, Transamerica, and Athena.
Aware of the security polices of HIPPA, GDPR, state and federal regulations.
Lead the risk and compliance audits for the project.
Taken care of revenue cycle management, crated billings for a project of 300 people.
Certified with Lean and Six Sigma.
Experience in doing Root cause analysis by using Lean and Six sigma techniques.
Conducted grooming and training sessions to team.
Good experience with healthcare plans Like A, B, D- Prescription Drug plans.
Worked on CMS data for Appeals and Grievance Projects
Good Knowledge of Payer side business of Health Insurance, and know CPT, ICD-10 coding systems.
Experience in improving the CSAT score by analyzing the data and finding the root cause for the low scores.
Experience in streamlining the projects, finding the scope of improving the automations and improving the revenue for the project.
Hands on experience of using HTML, CSS, JavaScript, jQuery, and React JS to create user.
Experience of Amazon Web Services' EC2 and S3 (AWS) lambda, IAM.
Skills:
Programming
SQL, Python, R, VBA, JAVA, PowerShell, T SQL
Version Control
GIT, GitHub
IDE
IntelliJ, VS Code, STS
Querying
Power Query, DAX,
Ticketing Tools
JIRA, Service Now
SDLC Methodologies
Waterfall, Agile, Scrum
Databases
Oracle, MySQL, MYSQL Server, PG(Postgres), MongoDB, SQL, Google sheets,
Teradata.
Cloud
AWS, Azure, AWS QuickSigh, snowflake
Data Visualization
Power BI, Tableau, Qlik, SSAS
Operating Systems
Windows, Linux, MS-DOS
Office Tools
Excel (Advanced), Word, PowerPoint, Access, Outlook, Power Automate
SEP-2024- PRESENT
Sr BI Consultant/CIGNA HEALTH INC, MORRIS PLAINS, NJ
Employer: Pyramid Consulting Inc
ROLES AND RESPONSIBILITIES:
Managing a portfolio of reporting and analytics to support our Employer Group Waiver Plan (EGWP) clients within Regulated Markets.
Assisting in improving the design, content, and timing of our suite of reporting to ensure the demanding expectations of clients are met along with the increasing requirements of external regulators.
I serve as a SME collaborating with various teams to assist with questions related to EGWP client financials and payments.
Migrated the Oracle database to AWS S3 and reporting done through QuickSight.
Worked on Settlement data and got 6 million as refund for the company.
Supporting client and external audits, update client pricing proposals, and create insurance policies and certificates in accordance approved state formats.
Managing related calls when needed, follow up with internal partners to ensure deadlines are met, and track issues to completion.
Analyzing large and complex healthcare data sets, including electronic health records (EHR), claims data, clinical data Policy and sales data, to extract meaningful insights with SQL and SSRS.
Utilize advanced analytics techniques and statistical methods to identify trends, patterns, and correlations in healthcare data.
Develop interactive dashboards and reports using business intelligence tools (e.g., Qlik, Tableau, Power BI) to visualize data and communicate findings to stakeholders.
Partner with business leaders and stakeholders to understand strategic objectives and business requirements related to healthcare analytics.
Do the Quality check on the data for the audit compliance and head the internal and external audit’s following the HIPAA and GDPR guidelines.
Having the Overall Health insurance knowledge claims, revenue cycle management and marketplace.
SEP-2023- AUG 2024
Sr Business Intelligence Data Analyst/ORIEN SOLUTIONS INC, EDISON, NJ
ROLES AND RESPONSIBILITIES:
Analyzing large and complex healthcare data sets, including electronic health records (EHR), claims data, clinical data Policy and sales data, to extract meaningful insights.
Utilize advanced analytics techniques and statistical methods to identify trends, patterns, and correlations in healthcare data.
Develop interactive dashboards and reports using business intelligence tools (e.g., Qlik, Tableau, Power BI) to visualize data and communicate findings to stakeholders.
Partner with business leaders and stakeholders to understand strategic objectives and business requirements related to healthcare analytics.
Designed and implemented robust to support data pipelines for extraction transformations and loading process considering the data integrity.
Provide data-driven recommendations and insights to support strategic planning, resource allocation, and decision-making processes within the organization.
Monitor key performance indicators (KPIs) and metrics related to healthcare operations, financial performance, and patient outcomes.
Created custom visuals and interactive dashboards in AWS QuickSight to track CMS Appeals and Grievance performance metrics, driving SLA adherence.
Identify opportunities for performance improvement and cost reduction through data analysis and benchmarking against industry standards and best practices.
Develop predictive models and forecasting algorithms to anticipate healthcare trends, patient demand, and resource utilization.
Forecast patient volumes, readmission rates, and other critical metrics to support capacity planning and resource allocation.
Designed and implemented AWS QuickSight dashboards to deliver actionable insights for complex health insurance datasets, improving decision-making efficiency.
Analyzed clinical quality measures and patient safety data to assess healthcare quality and identify areas for improvement.
Collaborate with clinical teams and quality improvement specialists to implement interventions and initiatives aimed at enhancing patient care and safety.
Ensure compliance with healthcare regulations and reporting requirements, such as CMS quality reporting programs (e.g., MIPS, PQRS).
Risk and compliance analysis following the State, Federal and HIPAA.
Collaborated with cross-functional teams to transform healthcare data into visually compelling dashboards, ensuring compliance with HIPAA standards.
Prepare and submit regulatory reports and documentation as required by federal, state, and local healthcare authorities.
Collaborate with cross-functional teams, including IT, clinical informatics, finance, and operations, to integrate data sources and streamline data workflows.
Serve as a subject matter expert on healthcare analytics and data-driven decision-making, providing Consultant g guidance and support to internal stakeholders.
JAN-2023- MAY 2023
Business Intelligence Analyst / Eniac Systems, Edison, NJ
ROLES AND RESPONSIBILITIES:
Collecting and extracting healthcare data from electronic health records (EHR), policy sales, and other relevant sources.
Ensure data integrity and accuracy by performing data validation and cleansing processes.
Analyzed healthcare data using statistical techniques and data visualization tools to identify trends, patterns, and correlations.
Assist in developing predictive models and algorithms to forecast healthcare outcomes and identify areas for improvement.
Managed the data pipelines and build for the new processes.
Prepare comprehensive reports and dashboards to present findings and insights to stakeholders, including healthcare providers, administrators, and policymakers.
Summarize key metrics and performance indicators to track progress and evaluate the effectiveness of healthcare initiatives.
Integrated Qlik Sense with multiple data sources, including SQL databases and cloud storage, to provide real-time insights.
Collaborate with healthcare professionals to identify opportunities for quality improvement based on data analysis findings.
Assist in developing and implementing interventions to address identified gaps in healthcare delivery and patient outcomes.
Ensure compliance with healthcare regulations and privacy laws, such as HIPAA, when handling and analyzing healthcare data.
Stay updated on changes in healthcare regulations and industry standards to ensure adherence to best practices.
Automated reporting workflows using AWS QuickSight and embedded analytics to streamline EGWP client financial reporting.
Participate in training sessions and workshops to enhance technical skills in data analysis, statistics, and healthcare informatics.
Seek mentorship and guidance from experienced data analysts and healthcare professionals to further develop analytical capabilities.
MAY-2018- FEB-2022
Assistant Manager / TATA Consultancy Services, India
Client: Transamerica.
ROLES AND RESPONSIBILITIES:
Define, analyze, and report standard hospital quality measures and use them for a variety of projects, including but not limited to, physicians’ incentives, pay for performance and meaningful use of Electronic Health Record.
Present quality dashboards to board members and provide insights related to improved quality of patient care.
Delivered services to a Healthcare client Transamerica for their health and annuity business.
Manage business intelligence team and projects focused on quality and data analytics.
Work closely with finance department for projects involving various billing, insurance, and payments related reports.
Monitored and managed AWS resources using CloudWatch to ensure optimal performance and uptime.
Monitor and present P&L Statements for various hospital departments to Board Quarterly.
Work closely with team members to ensure data being presented to internal and external leaders is audited and validated.
Expertise in US Healthcare Operations (Manual Adjudication of claims, pre and post processing, Rework, Audits and Automations) filling up the gap between customer service and Healthcare technology.
Proven track record of managing processes, streamlining workflow & creating teamwork environment to enhance productivity innovatively.
Worked on clinical data, medical durable equipment data for analysis to provide insights.
An effective communicator with strong analytical, interpersonal, and problem-solving skills. Ability to take ownership and multitask working against stiff timelines.
Analyze the project data suggest the improving scopes and automate the reports for the project.
Created the SOW and SOPs for the project keep all SLAs into consideration.
Transitioned new queue from pilot to BU which is now 100+ FTE strong team across 2 locations.
As a Risk management and compliance lead for the project lead the CMMI audits and external audit certification to the team.
Awarded star performer consecutive 4 months and process champion.
MAY 2012 – APRIL 2018
Assistant Manager / WIPRO Ltd, Chennai
CLIENT: UHG, OPTUM
ROLES AND RESPONSIBILITIES:
Leading a team of 80 associates for end-to-end servicing for the globally most complex high-end queue, which handles - Government business (M&R) of both first pass, Appeal & Grievances.
Delivered services to a Healthcare client UHG, Optum for their health and annuity business.
Certified in Value Engineered Performance systems program, performance management, Variation Management, New process transition.
Taken care of the revenue cycle management for the whole business.
Worked closely with CMS for improving the Appeals and Grievances scores and Star ratings for the policies.
Trained in Six Sigma Green belt, expert in Excel and well know about the data reporting tools Tableau and Minitab.
Managed the client communication and multiple locations for the smooth business flow and delivery.
Organized training workshops to improve the performance of the members who were lagging in terms of performance.
Analyzed the assigned projects and distributed tasks to the members as per their area of expertise.
Multi linguistic know Telugu, English, Hindi, Tamil, Kannada
Compliance SPOC – Assisting the RMAC team in all compliance related activities Pre-Joining Formalities, HIPAA Adherence, Quarterly Assessments, and Access related activities, Updating BCP document regularly.
SEED SPOC – Working with the TT Team to arrange coursed which employee needs to pursue.
Education
Masters in computer science / UCM, 2023
B. Tech-ECE / JNTU-2011