Prudvi Thoran –
Exploring the Digital world, one code at a time.

As an Information Systems student, I have gained a strong understanding of how technology and information can be leveraged to solve complex business problems. I have developed proficiency in various programming languages and database management systems, Power Bi, and Business strategies, as well as skills in project management, data analysis, and system design. My passion for learning and staying up-to-date with the latest industry trends has enabled me to effectively collaborate with cross-functional teams and contribute to the successful implementation of IT projects throughout my educational career. With a strong focus on innovation and problem-solving, I am eager to apply my skills to drive value for businesses and society as a whole.

Portfolio Preview

Quick link : protfolio projects page

MY SKILLS

Tools and Software

Power Bi, Python, DaVinci Resolve Studio, SIEM, Microsoft suite. SQL,GitHub

Operating Systems.

Windows, Mac and Linux

Programming Languages

C,C++,Java, Python, DAX, R langauge

Web Technologies

Cloud(aws) , HTML , JavaScript, CSS, WordPress ,

Visualisations

Power Bi, PowerPoint, Google Sheets, Microsoft Excel, Davinci Resolve Studio,Tableau

Other Skills

A brief idea on Network Topologies, OSI Models, and Software Development Life Cycle. Database, Data analysis, Data Modelling, Data Scraping.

MY EXPERIENCE

Data Analyst
Omni Healthcare | Injury Finance, Denver, CO

July,2023-Present

Efficiently resolved tickets by conducting detailed data validation and gathering critical information from databases, ensuring precise issue resolution.

• Developed interactive Power BI dashboards, tailored to meet diverse team requirements, enhancing data visualization and decision-making processes.

• Leveraged Power Automate to streamline manual tasks, significantly improving workflow efficiency and team productivity.

• Utilized DAX and SQL queries for creating sophisticated, custom calculations and features in Power BI dashboards, elevating data analysis capabilities.

• Employed Python scripting within Power BI, using libraries like PuLP, Matplotlib, and Pandas for intricate data analysis and optimization, contributing to effective problem-solving.

• Maintained active communication with cross-functional teams, ensuring consistent data gathering and adherence to evolving business rules, enhancing project collaboration.

• Employed ETL (Extract, Transform, Load) techniques to efficiently transform external data sources into insightful and actionable dashboards

• Utilized Power Apps within Power BI to facilitate data write-back to Excel files, enabling further manipulation and application of desired functions for enhanced data processing and analysis

• Collaborated effectively with team members on extensive dashboard projects, excelling in gathering clear business requirements to ensure alignment with organizational objectives and stakeholder needs

Data Analyst
DataOne

Jan 2019 - Jul 2021

 Maintained up-to-date documentation of database objects including table structure, column attributes, and relationships between tables, which improved the accuracy and efficiency of data processing

 Conducted unit testing of all changes made within the databases ensuring accuracy of data, which reduced the number of data errors by 75%.

 Created dashboards with interactive visualizations using Power BI Desktop tools, which improved the ability of stakeholders to analyze data and make informed decisions.

 Built cubes using Microsoft Analysis Services for faster reporting capabilities, which reduced the time it took to generate reports by 25%.

 Developed SQL stored procedures and triggers to automate data processing tasks, which improved the efficiency of data processing.

 Created reports using SSRS, Power BI, Tableau, and Excel, which provided stakeholders with a variety of options for viewing and analyzing data.

 Utilized advanced functions such as pivot tables, VBA Macros, and custom formulas in Excel spreadsheets to analyze data sets, which provided stakeholders with more insights into their data.

 Deployed complex queries on large datasets for business intelligence analysis, which helped the company to identify new market opportunities and improve operational efficiency.

 Resolved 95% of technical support tickets related to Business Intelligence applications and databases within 24 hours.

EDUCATION

Masters in Information Systems

University of Colorado , Denver 2021 - May 2023

Bachelor's Degree in Information Technology

Gokaraju Rangaraju Insititute of Engineering and Technology, Hyderabad 2018 - 2021

Diploma in Electronics and Communication Engineering

T.R.R College of Engineering and Technology, Meerpet, Hyderabad 2015-1018

Interested? Let’s get in touch.

Prudvi Thoran – Exploring the Digital world, one code at a time.