Power Bi Data Analyst

SRI SURYA GANESH YANAMADALA

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

A passionate Data Analyst with expertise in Python, R, SQL, Power BI and cloud platforms such as Azure. Skilled in Data Analytics, Reporting, Machine Learning, Data Visualization, and communicating actionable insights to both technical and non-technical audiences. Experienced in collaborating with cross-functional teams to implement data-driven strategies and achieve business objectives. TECHNICAL SKILLS

Data Integration & Visualization Power BI, Matplotlib, Plotly, Seaborn, Pandas, ArcGIS Pro, ArcGIS Online, QGIS Programming Language Python, SQL, R

Database Management MySQL, SQL Server, MongoDB, Microsoft Fabric Tools Jupyter Notebook, PyCharm, Anaconda, Microsoft Visual Studio, Microsoft Excel (Advanced functions including Macros, Pivot Tables, VLOOKUP) Microsoft Power Platform PowerApps, Power Automate, Dataverse. Cloud Azure, Azure DevOps, Azure Functions.

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. Geospatial Tools ArcGIS Pro, ArcGIS Online, GeoServer, Open Layers APIs & Integration

REST APIs, ArcGIS APIs, Swagger, Postman

EXPERIENCE

IT Generalist Florida International University Miami, FL Sep 2024 – Present

• Created interactive dashboards using Power BI to visualize spatial and temporal trends in buoy data, aiding in environmental monitoring and decision-making.

• Utilized SQL for querying and managing buoy data stored in databases, ensuring efficient data retrieval and manipulation.

• Generated comprehensive reports on buoy data analysis, showcasing key metrics and insights through visualizations and detailed narratives.

• Analyzed sales data related to buoy equipment and deployment, providing insights for optimizing sales strategies and improving revenue.

• Integrated buoy data from various APIs, ensuring seamless data flow and real-time updates for analysis and visualization.

• Incorporated data on fabric materials used in buoy construction, analyzing their impact on buoy performance and durability.

• Employed data mining techniques to uncover patterns and correlations in buoy data, informing environmental monitoring strategies.

• Developed data models to represent buoy data accurately, facilitating efficient analysis and visualization.

• Proficient in maintaining geospatial and analytical systems, including debugging and optimizing data pipelines and APIs.

• Automated the conversion of CSV data into point layers in ArcGIS Pro, reducing manual workload and streamlining data integration.

• Managed and stored geospatial datasets using cloud platforms like Azure and AWS, ensuring data accessibility and scalability.

• Leveraged Microsoft Dataverse to integrate and manage buoy data, enabling comprehensive analysis and visualization. Data Analyst Crypton Technosoft Miami Aug 2023 – Aug 2024

• Spearheaded the design and deployment of dynamic Power BI dashboards, transforming complex sales data into actionable insights, enhancing decision-making for non-technical stakeholders.

• Utilized Python (Pandas, NumPy) and R (caret) for data manipulation, exploratory analysis, and building dashboards using Powe BI for predictive analytics, improving forecasting accuracy by 20%.

• Presented analytical insights and sales performance findings to cross-functional teams and senior management, ensuring clarity and actionable outcomes through effective communication.

• Developed and optimized API integrations for seamless data exchange between Microsoft faric, Power BI, enhancing real-time analytics capabilities.

• Presented KPI metrics and operational insights through dynamic Power BI dashboards to stakeholders, enabling data-driven decision-making.

• Automated data update processes using SQL and Power Query, integrating fabric and Power BI for real-time synchronization, reducing data latency by 50%.

• Integrated Power BI dashboards into Power Apps, providing interactive and data-driven user experiences, and developed multiple Power Automate flows to streamline and automate regular business processes, enhancing operational efficiency.

• Developed a comprehensive data quality framework with SQL scripts, ensuring high data integrity and usability, increasing operational efficiency across business units.

• Designed and optimized data models (normalized and denormalized schemas) using ER/Studio and MySQL Workbench, supporting analytical reporting and improving query performance by 30%.

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

• Developed advanced visualizations and dashboards in Power BI to analyze healthcare data, monitoring patient satisfaction and care efficiency, and providing actionable insights to stakeholders, ensuring data insights are accessible and impactful.

• Implemented calculated columns, measures, and DAX in Power BI to optimize dynamic and interactive visualizations, catering to diverse business needs and improving analysis capabilities, which aligns with guiding product and strategic decisions through experimentation and analysis.

• Conducted customer segmentation using k-means clustering in R to forecast market trends and optimize marketing strategies, driving a 15% improvement in campaign efficiency.

• Collaborated with stakeholders to collect requirements and develop tailored data solutions, ensuring alignment with strategic business objectives, showcasing your capability to work with a wide range of stakeholders and functional teams.

• Automated reporting workflows using Excel Macros and advanced formulas, reducing manual effort by 30%, highlighting your proficiency in using data tools to improve efficiency.

• Queried and validated data from multiple sources using complex SQL, ensuring data accuracy, consistency, and reliability for reporting, matching the requirement to develop SQL queries in conjunction with Power BI.

• Optimized Power BI reports for performance by reducing data load times and streamlining data source connections, enhancing usability for business users, reflecting your ability to develop solutions for better data accessibility.

• Developed mobile-optimized dashboards with responsive designs in Power BI, ensuring seamless accessibility across devices and platforms, ensuring that data insights are accessible to all.

• Designed and maintained data systems and models, programming automated ETL pipelines to transform and integrate datasets across SQL databases, demonstrating your strength in data integration and processing.

• Managed and updated Tableau extracts on QA and development sites, monitoring schedules, and running unit tests to ensure data integrity, showcasing your ability to ensure the reliability and performance of data tools.

• Utilized Collibra to catalogue measurements and dimensions, organizing datasets for easy accessibility and management, ensuring data is well- organized for analysis.

• Researched and evaluated SQL query performance, restructuring and indexing to reduce query execution times and improve efficiency, highlighting your problem-solving skills and technical expertise. 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] 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

Contact this candidate