THARUN POWDURI
Overview
4
4
years of professional experience
Work History
Data Analyst
BAYER HEALTH CARE
03.2023 - Current
- Strong understanding of the business functionalities like Medicare, Medicaid, Workers Comp, Commercial Claims, Bulk Billing, Denial Analysis and Insurance specific trends
- Extensively use ETL process to address Data cleansing
- Create new security reports and maintained other security reports within MMIS system
- Use various customer data to create dynamic BI presentations in Tableau and PowerPoint
- Involve in creating role-based matrix, decision tables when required as per the requirements through the project
- Work on HCM setup for company information, location, department, salary grades, job codes, benefit programs, plan types, pay groups and other payroll related issues
- Maintain configuration tables in the case management system
- Implement the Agile Software Development Life Cycle throughout the Project
- Perform data analysis, created data mapping and data interface documents and kept the documents updated with changes in requirements and functional specifications
- Mentor five Lean Six Sigma Greenbelts and coaches them through project completion
- Develop Procedures, Functions, packages and triggers in PL/SQL
- Successfully interpret data to draw conclusions for managerial action and strategy
- Optimize data collection procedures and generated reports on a weekly, monthly and quarterly basis
- Write PL/SQL statement and stored procedures in Oracle for extracting as well as writing data
- Verify the data extracted and record counts in the database with SQL Queries using AWS Athena
- Analyze massive and highly complex data sets, performing ad-hoc analysis and data manipulation.
Clinical Data Analyst
CRC Pharma
06.2020 - 05.2021
- Used SQL, PL/SQL and scripting to create UMT tables, Aggregate tables and using them to create Trend reports, Pivot reports, List reports
- Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, LOD (Level of Detail), row-level security, R integration, joins, data blending and dashboard actions
- Utilized Tableau visual analytics and best practices like performance improvement, dashboard structure, view orientation, sizing and layouts, data emphasis, highlighting, color, fonts and complex dashboards
- Built stories in Tableau Desktop with various data points to narrate the data to the end-users
- Developed and maintained all clinical databases (e.g., Utilization Management, Specialty/Non-Specialty Pipeline, Generic Pipeline, Drug List Management databases)
- Created and maintained project documentation relevant to data management activities
- Continuously looked for ways to streamline and improve the quality of the formulary management process
- Contributed to internal process development and improvement
- Analyzed clinical trial data for completeness and accuracy by using electronic data checks and manual review where required
- Issued data clarification forms to study sites to correct erroneous, incomplete, or implausible data
- Reviewed responses to data queries and update the database when the response appropriately addresses the data issue
- Created and modified interactive dashboards and created guided navigation links within interactive dashboards.
Education
Master of Science in Health Informatics -
University of North Texas
12.2022
Bachelor of Pharmaceutical Science and Technology -
Krishna University
04.2020
Skills
- Tableau
- Power BI
- Git
- Jira
- Linux
- Windows
- MS Word
- MS Excel
- MS PowerPoint
- SQL
- Python
- PL/SQL
- R programming
- Pandas
- Html
Accomplishments
- Participated in general elections of Graduate school committee senator and elected for it with majority.
- Applauded for National Pharmacy Week Project on Pharmaceutical Analysis Project and awarded for it.
Timeline
Data Analyst
BAYER HEALTH CARE
03.2023 - Current
Clinical Data Analyst
CRC Pharma
06.2020 - 05.2021
Master of Science in Health Informatics -
University of North Texas
Bachelor of Pharmaceutical Science and Technology -
Krishna University
Similar Profiles
SNEHAL NANAVATYSNEHAL NANAVATY
IT Senior Consultant/SAP Lead at BAYER HEALTH CARE - TRIRX PHARMACEUTICALSIT Senior Consultant/SAP Lead at BAYER HEALTH CARE - TRIRX PHARMACEUTICALS
Priscilla PrariztaPriscilla Prarizta
Asia/ANZ Integrated Product Supply Lead at Bayer Consumer CareAsia/ANZ Integrated Product Supply Lead at Bayer Consumer Care
Sava TrajkovićSava Trajković
Stručni Medicinski Saradnik at Bayer Consumer CareStručni Medicinski Saradnik at Bayer Consumer Care
Manoj Singh RawatManoj Singh Rawat
Data Analyst/Data Migration Analyst at Sopra SteriaData Analyst/Data Migration Analyst at Sopra Steria
Lenina MirzaLenina Mirza
Data Analyst (Customer Support Data Analyst) at Mazda Australia Pty LtdData Analyst (Customer Support Data Analyst) at Mazda Australia Pty Ltd