Designed and developed interactive Qlik Sense dashboards to visualize complex grant-related KPIs, improve cross-functional communication, and drive performance tracking across research departments and administrative functions. Optimized and automated SQL queries and backend data retrieval processes, resulting in a 30% reduction in overall data load times, thus enabling faster updates and a more seamless user experience for stakeholders. Built and maintained a comprehensive data dictionary for the PeopleSoft system, promoting consistent data definitions, enhancing query accuracy, and facilitating better collaboration between business users and technical teams. Translated dynamic business requirements into meaningful insights using SQL, Qlik Sense, and Power BI, creating robust visualizations that informed executive-level decisions and research fund allocation strategies. Developed custom queries in PeopleSoft Query Manager, allowing for efficient data pulls and real-time tracking of grant statuses, award deadlines, and financial transactions across multiple departments.

Novartis Healthcare Private Limited | Aug 2019 - Dec 2022

Data Analyst

• Conducted in-depth exploratory data analysis using Python libraries such as NumPy and Pandas, uncovering critical trends and patterns that directly influenced strategic decision-making. • Employed advanced statistical analysis to extract actionable insights from complex datasets. • Utilized Python libraries (NumPy, Pandas) for data cleaning and preprocessing. • Produced comprehensive reports and visualizations using Matplotlib, Seaborn and Plotly to effectively communicate findings to stakeholders. • Played a pivotal role in shaping strategic initiatives through data-driven recommendations. • Demonstrated strong analytical skills and attention to detail in data interpretation and problem-solving. • Developed predictive models using machine learning algorithms, including Linear Regression, Logistic Regression, and Random Forest, resulting in a 15% increase in customer behavior forecasting accuracy, leading to more informed decision-making. • Used cutting-edge machine learning techniques to create models with improved predicting precision. • Demonstrated proficiency in optimizing and evaluating models to promote ongoing development. • Promoted the use of predictive analytics in decision-making, which helped to create a culture that is data-driven. • Spearheaded the development of interactive dashboards using Qlik Sense, Tableau, Power Bi and Excel allowing stakeholders to monitor key performance indicators in real-time, leading to a 25% improvement in data accessibility and decision responsiveness. • Created dashboards, merging up to 10 different data sources and data from up to 40 different countries and hundreds of multiple brands into one single dashboard, which is used all across multiple regions. • Led the design and implementation of user-friendly dashboards that met stakeholder requirements. • Transformed complex data into actionable insights through intuitive visualization techniques. • Facilitated data-driven decision-making by empowering stakeholders with real-time data access. • Provided training and support to ensure stakeholders maximized the value of interactive dashboards. • Implemented access restrictions in dashboards, ensuring data security and compliance with privacy regulations. • Used complex charts in dashboards like sunburst chart etc., to provide valuable insights to the stakeholders. • Created complex web scrapping workflows using Python and Alteryx, achieving 50% efficiency in data downloading and data accessing. • Created multiple complex workflows in Alteryx, for data analysis, bringing about 40% improvement in data handling and analysis. • Leveraged SQL queries to efficiently extract, transform, and load data into databases, streamlining data processing workflows and reducing data integration time by 40%. • Wrote complex SQL queries for data extraction, transformation, and loading. • Used complex SQL functions and scripts for data transformation. • Automated data processing tasks using SQL scripts and scheduled jobs. • Ensured data integrity and security through optimized database management. • Designed and implemented optimized database structures, reducing query response times by 30%, enhancing analytics efficiency, and enabling faster decision-making. • Collaborated with stakeholders to gather requirements and design data models and reports, ensuring alignment with business goals and enhancing the usability of data-driven solutions. • Created multiple power point presentations for the leadership team.

My Education

Take a look at my formal education

Master of Science in Engineering Data ScienceUniversity of Houston | 2024

Bachelor of Technology in Mechanical EngineeringNational Institute of Technology Warangal | 2019

About Me

Master of Science in Engineering Data Science | Data Analyst @ Novartis | (Skillset: Advanced Python and Machine Learning, Advanced Database Managment, Advanced Data Visualization, Data Engineering, Automation)

Create Your Data Portfolio for Free

Venkata Sai Bharath Thoranala

Master Student

University of Houston | Houston, Texas

Supervised Learning with scikit-learn

Case Study: Analyzing Customer Churn in Power BI

Introduction to Python

Supervised Learning with scikit-learn

Data-driven magician, making the impossible possible.

My Work

Introduction to Data Engineering

Data Manipulation with pandas

Data Visualization in Power BI

Supervised Learning with scikit-learn

Project: Producing Soccer Insights for a Sports Media Agency

Introduction to Python

Intermediate Python

Project: Investigating Netflix Movies

Project: Exploring NYC Public School Test Result Scores

Introduction to Data Engineering

DataCamp Course Completion

Courses

Courses

Tracks

Projects

My Work Experience

University of Houston | May 2024 - Dec 2024

Data Analyst

Novartis Healthcare Private Limited | Aug 2019 - Dec 2022

Data Analyst

My Education

About Me