Jayanth Pilla

Data Analyst @Optum

MN, US

Designed dynamic dashboards using Tableau, Power BI, and Python (Pandas, Matplotlib) to deliver actionable insights.• Utilized SQL for database management and Python/R for statistical analysis and data wrangling.• Built and optimized ETL pipelines with tools like Apache Kafka and Talend for seamless data integration.• Developed KPI dashboards and predictive models using Excel Power Query, VBA and Tableau Prep to support strategic decisions.• Managed and analyzed cloud-based datasets using AWS (Redshift, Athena, S3), Google BigQuery, and Microsoft Azure.• Processed large-scale datasets with Hadoop, Spark, and Hive to enable data-driven decision-making.• Queried and managed healthcare datasets in Oracle and IBM Db2, ensuring secure storage and accessibility for analytics projects.• Conducted disease surveillance and population health analysis using Minitab and JMP to identify risk factors and improve public health interventions.• Automated regulatory and compliance reporting using Perl scripting and Apache Pig, reducing manual errors and ensuring timely submissions.• Applied Agile methodologies and tools like JIRA and Confluence for project management and collaboration.• Delivered executive-level reports and dashboards to present insights clearly to stakeholders.