Layanu Hazarika Email and Phone Number

• Leading Competitive Intelligence team – Leading Competitive Intelligence team responsible for the crawling of data from competitor websites, generating multiple price and lead time trackers for daily insights and preparing base files for various LOBs which are further used for calculating WAPPs.• Migration of reports from MS Excel to Power BI - Convert Excel reports into dashboards using PowerBI by connecting to databases and create auto refresh schedules, provide easy access to partners. Created calculated columns and measures using power query editor and DAX functions.• Building web crawlers using python - Develop and monitor web crawlers to capture specifications, prices, lead times from competitor websites monthly.• Calculate WAPP (Weighted Average Promo Price) based on competitor price vs Dell price - Clean theweb crawled raw data from competitor sites, convert them into meaningful reports by adding prices to competitor products, mapping Dell Order Codes (OCs) to each competitor MPN and calculating Promo WAPPs and Street WAPPs.• Creating scripts for Data modification – Build python scripts to automate clean reports, combining multiple files or converting big data file into an easily accessible one.• Scraping web prices to calculate price changes – Work on creating price trends reports calculating the price delta and displaying PIVOT table representation for analysis.• SSIS package creation - Create SSIS packages for huge data loads thereby reducing manual import of data in less time for daily reports.• SKU price updates - Work on ad-hoc requests to price numbers for SKUs on Domino and Harmony Composer for USA and Canada.

• Cost Analysis: Calculating the average cost of various medical procedures and treatments. Evaluating the financial impact of different healthcare services on the insurance company.• Trend Analysis: Identifying trends in healthcare services utilization and costs over time. Recognizing shifts in medical treatment preferences, such as an increase in specific procedures or therapies.• Geographical Analysis: Analyzing claims data based on geographical regions to understand regional healthcare trends and demands. Identifying areas with higher healthcare costs or specific healthcare needs.• Provider Performance Evaluation: Assessing the efficiency and effectiveness of different healthcare providers in terms of claims submission and reimbursement. Comparing claim approval rates, turnaround times, and appeal rates among providers.

• Billing Patterns Analysis: Identifying common billing patterns and trends among doctors and medical facilities. Recognizing variations in billing practices for specific treatments, procedures, or medical conditions.• Claim Rejection Analysis and Denial Management: Identifying common reasons for claim rejections and denials. Addressing issues that lead to claim rejection, such as incorrect coding or missing documentation.• Checking for HIPAA compliance: Assigning of medical codes for each condition and checking if it is adhering to HIPAA compliance before submission of claims to insurance on behalf of individual or group of providers.• Process Efficiency Improvement: Identifying bottlenecks or inefficiencies in the claim submission process. Streamlining administrative tasks and improving overall workflow.