Power Bi Data Science

SRI SURYA GANESH YANAMADALA

*****.***********@*****.*** +1-786-***-**** linkedin.com/in/sri-surya-ganesh-yanamadala https://github.com/suryayanamadala

SUMMARY

As a graduate student at Florida International University With a passion for data analysis, I have acquired skills and certifications in tools such as Big Query, SQL, and Tableau, Power BI using them to interpret, visualize, and communicate analytical results effectively. My project experience spans customer segmentation, sentiment analysis, and market research, demonstrating my commitment to enhancing data-driven decision-making and implementing innovative solutions.

EDUCATION

Master’s in Computer Science Jan 2022 – Dec 2023

Florida International University Miami, Florida.

Relevant Coursework: Data Mining, DSA, Cyber Security, Digital Forensics using AI/ML, Advanced Software Engineering, DBMS

Bachelor’s in Computer Science Aug 2017 – May 2021

Vel Tech University Chennai, India.

Relevant Coursework: Programming in Java, C, Python, Cloud Computing, Operating Systems, OOSE, Big Data, Machine learning, Business Intelligence, Data Science, Statistics for Data Analytics

TECHNICAL SKILLS

Data Integration & Visualization

Power BI, Tableau, Matplotlib, Plotly, Seaborn, Pandas

Programming Language

Python, SQL, C

Database Management

MySQL, SQL Server, MongoDB

Tools

Jupyter Notebook, PyCharm, Anaconda, Microsoft Visual Studio, Excel

Cloud

Azure, Azure DevOps, AWS.

Collaboration Tools

GIT, Azure Boards, Agile Methodologies.

Data Science Skills

BIG Data, Data Processing, Feature Engineering, ETL, Data Mining, Model Selection and Evaluation, Exploratory Data Analytics, Statistics, Hypothesis testing, Regression, Classification, Time Series Analysis, NLP, Clustering, Dimensionality Reduction.

EXPERIENCE

Data Analyst Crypton Technosoft Miami Jun 2023 – Aug 2024

•Spearheaded the design and deployment of dynamic PowerBI dashboards, transforming complex datasets into visual stories. This initiative empowered non-technical stakeholders to leverage data insights, significantly enhancing strategic decision-making.

•Pioneered the development of comprehensive performance reporting mechanisms, integrating monthly, quarterly, and annual data analyses with advanced visualizations. This directly contributed to improvements in operational efficiency and decision accuracy for senior management.

•Executed Data Extraction, Data Management, Data Cleansing, Data Profiling, Data Consolidation, and Data Quality processes for various business data feeds. Conducted thorough data cleaning processes, including removing duplicates, correcting errors, and standardizing data formats to ensure high-quality datasets.

•Designed and developed data models to support analytical reporting, ensuring efficient data storage, retrieval, and integrity. Utilized tools like ER/Studio or MySQL Workbench for visual data modeling. Created normalized and denormalized database schemas to optimize performance and support complex query requirements.

•Used Python libraries such as Pandas and NumPy for data manipulation, including filtering, aggregating, and transforming data sets to prepare them for analysis. Implemented data cleaning scripts to handle missing values, outliers, and inconsistencies in large data sets, ensuring data quality and integrity.

•Wrote complex SQL queries to extract, join, and aggregate data from multiple tables and databases, ensuring efficient and accurate data retrieval for reporting and analysis. Enhanced SQL queries for performance improvements, indexing, query restructuring and tuning.

•Managed and maintained SQL databases, including tasks such as data migration, backup, and recovery processes to ensure data integrity and availability. Developed interactive dashboards and reports in PowerBI to provide real-time insights into key business metrics, facilitating data-driven decision-making.

•Developed an automated bird detection system using image processing techniques to analyze aerial images captured from helicopters.

•Pre-processed and annotated aerial images to train a machine learning model for the accurate detection of birds, reducing the need for manual identification.

•Utilized computer vision techniques such as object detection, segmentation, and feature extraction to enhance the accuracy of bird identification in complex aerial environments.

•Collaborated with cross-functional teams to optimize model performance and improve detection accuracy across varied image conditions.

•Applied deep learning models to automate the detection process, improving efficiency and accuracy in wildlife monitoring efforts.

•Conducted testing and validation to ensure high precision and recall rates in detecting birds, adapting the model to handle different environmental conditions and image qualities.

•Enhanced model's capability to distinguish birds from other objects in the environment, minimizing false positives during detection.

•Utilized Power Query for data transformation tasks, creating calculated columns, measures, and visualizations to enhance report functionality.

•Led a strategic initiative to automate the data update process, shifting from manual entry to real-time synchronization across SQL databases and PowerBI dashboards, reducing data latency by 50% and enhancing report accuracy for critical business decisions.

•Innovated a data quality framework using SQL scripts, significantly improving the integrity and usability of business intelligence data, which increased operational efficiency across the business. Integrated data from various sources such as SQL databases, Excel files, and web APIs into Power BI, ensuring a unified and comprehensive view of business data.

Junior Data Analyst Datanet Techno Solutions Bangalure, India Aug 2020 – Dec 2021

Created advanced visualizations and dashboards in Power BI to represent data trends, patterns, and insights effectively. Used various chart types, maps, and filters to enhance user experience.

Implemented calculated columns, measures, and DAX in Power BI to create dynamic and interactive visualizations that cater to diverse business needs. Performed data blending in Power BI to combine data from multiple sources, enabling comprehensive analysis across different datasets.

Used Power BI’s blending capabilities to create unified views of disparate data, enhancing insights. Created advanced calculated fields and table calculations to perform complex data analysis in Power BI.

Optimized Power BI reports for performance by reducing data load times, minimizing extract sizes, and optimizing data source connections.

Designed mobile-optimized dashboards in Power BI, ensuring accessibility and usability on various devices. Implemented responsive design principles in Power BI to enhance the user experience on mobile platforms.

Built and enhanced data systems and models, demonstrating technical proficiency by independently exporting, transforming, and loading data tables into multiple databases. Created and improved data visualization tools using Power BI, maintaining, and enhancing existing dashboards and reports to meet business needs.

Verified data accuracy and consistency by collaborating with data engineers and analysts, ensuring reliable data for reporting and analysis.

Worked closely with business stakeholders to understand their data requirements, offering tailored solutions to meet their needs.

Diagnosed and resolved issues related to data, dashboards, and reports, ensuring smooth and efficient data operations.

Developed technical designs, test cases, and user guides for Power BI reports and dashboards, attaching them to Development and Quality Assurance sites.

Created advanced visualizations and dashboards in Tableau to represent data trends, patterns, and insights effectively. Used various chart types, maps, and filters to enhance user experience.

Implemented calculated fields, parameters, and sets in Tableau to create dynamic and interactive visualizations that cater to diverse business needs. Performed data blending in Tableau to combine data from multiple sources, enabling comprehensive analysis across different datasets.

Used Tableau’s blending capabilities to create unified views of disparate data, enhancing insights. Created advanced calculated fields and table calculations to perform complex data analysis in Tableau.

Managed and updated data extracts on QA and development sites, monitoring schedules and running unit tests to ensure data integrity.

Utilized Collibra to catalogue measurements and dimensions, maintaining an organized and accessible data repository for business users.

Created complex SQL queries to support data analysis and reporting needs, focusing on efficient data extraction, joining, and aggregation from multiple databases.

Enhanced SQL query performance through indexing, query restructuring, and optimization techniques, ensuring fast and reliable data retrieval.

Managed SQL databases, performing data migration, backup, and recovery tasks to maintain data integrity and availability.

PROJECTS

Cricket Data Analytics: [Github]

Conducted an in-depth analysis of the cricket T20 World Cup (2022) data to optimize a best 11 players team using advanced Bright Data web scraping techniques and comprehensive datasets from ESPNcricinfo. Ensured data accuracy and completeness through extensive data cleaning and transformation using the Pandas library in Python.

Applied advanced analytical techniques, including statistical analysis, data modeling, and machine learning algorithms, to extract meaningful insights and identify patterns. Implemented machine learning algorithms to optimize team composition based on player performance metrics, enhancing decision-making processes.

Leveraged Power BI for data visualization to create interactive dashboards, providing granular insights into player performance, team composition, and comparative analysis. Enabled stakeholders to make informed, data-driven decisions by delivering clear, visual representations of analysis results, improving engagement and understanding.

Emergency Room Visits Dashboard: [Tableau]

Engineered an interactive Tableau dashboard to analyze and visualize emergency room (ER) visits data, leveraging advanced data visualization techniques.

Generated comprehensive insights into patient demographics, wait times, satisfaction scores, and departmental referrals through data aggregation and visualization.

Enabled healthcare administrators to identify trends, optimize resource allocation, and enhance patient care strategies by applying advanced analytical methodologies.

Transformed complex datasets into accessible visual formats, facilitating informed decision-making and policy development.

Improved healthcare operations by enabling data-driven strategies and optimizing patient care delivery through actionable visual analytics.

Netflix Content Dashboard: [Tableau]

Engineered an interactive Tableau dashboard for the analysis and visualization of Netflix's movie and TV show datasets, utilizing advanced data visualization techniques.

Delivered comprehensive insights into content distribution, ratings, genres geographical availability through robust data analysis and visualization.

Empowered data-driven decision-making for content strategy and development by leveraging in-depth data analysis and visualization.

Enhanced stakeholders' ability to identify popular genres and high-performing content across different regions through detailed data segmentation and performance metrics.

Helping hands Website: [Report]

Designed and implemented a comprehensive platform for aid and support connections, ensuring a seamless user experience with a dynamic front-end.

Utilized HTML5, CSS3, AngularJS, Bootstrap, and JavaScript to create a responsive and interactive user interface, enhancing user engagement and accessibility.

Developed a robust back-end using Node.js, Express.js, Django, and Python, optimizing performance and ensuring secure data handling and storage with MongoDB.

Employed Git for version control, facilitating efficient team collaboration and maintaining code integrity throughout the development process.

CERTIFICATIONS

Google Data Analytics Professional Certificate [Coursera]

Contact this candidate