Bharath Goriparthi

About Bharath Goriparthi

Data Analyst with 4+ years of experience possesses a strong foundation in Data…

Experience

1. Data Science Analyst

   Cigna Healthcare

   Jan 2024 — Present · US

   Wrote several complex SQL queries to extensively test the ETL process. Performing data analysis and maintenance on informationstored in MySQL database. Working on developing Python script for the whole data science project life cycle including data acquisition, datacleaning, data exploration, and data modeling. Collaborate with stakeholders to gather requirements and define project objectives. Working with NumPy, Pandas, Matplotlib, Seaborn, ggplot, Scikit-Learn libraries for developing various algorithms. Designing and deploying dashboards with Tableau and providing complex reports to the team and stakeholders. Successfully extracting data from multiple sources including flat files, MS Excel, and MS Access, employing data transformationtechniques to ensure data accuracy and consistency, facilitating efficient data processing and analysis. Write extract, transform, and load (ETL) code to automate routine data collection and reporting processes using a variety oflarge-scale distributed data systems. Designs and develops BI solutions using Snowflake as the backend data repository. Builds and maintains dashboards, reports, and visualizations using BI tools (e.g, Tableau, PowerBI) connected to Snowflake. Collecting and iteratively refining specifications from management to augment current pivot table reporting with high-qualitydashboard visualizations in Excel. Extensively used ERWIN and PowerDesigner to design Logical and Physical Data Models, and to forward and reverse engineering datamodels and publishing data models to acrobat PDF files. Using Denodo, Cloudera Hadoop, Alteryx, and Power Automate for effective analysis of data that is being used in visuals and to alsotest the joins and data against backend/database. Implemented navigation buttons, used parameters to change the axis and swap the sheets for better dashboarding. Participate in meetings and discussions to understand business problems and provide data-driven insights.