Machine Learning Power Bi

PRASUNA SAI RIKKALA

Location: TX Phone: 972-***-**** Email: **************@*****.***

SUMMARY

Data professional with 3 years of experience in quantitative analysis, ETL development, business intelligence, and data visualization. Skilled in using SQL, Python, Power BI, and Tableau to transform complex datasets into clear insights that drive business strategy. Experienced in market research, risk analysis, forecasting, and KPI reporting across technology, insurance, and enterprise data environments. Adept at designing and optimizing ETL pipelines, partnering with cross-functional teams to answer business-critical questions, deliver executive-ready presentations, and support strategic decision-making with data-backed recommendations. TECHNICAL SKILLS

Analytics & Modeling: Statistical Analysis, Risk Analysis, Hypothesis Testing, Forecasting, Text Mining, Machine Learning Data Visualization & BI: Power BI, Tableau, Excel (Dashboards, Pivot Tables, DAX, Slicers) Programming & Databases: SQL, Python, R, Oracle, SQL Server, PostgreSQL, Snowflake, BigQuery Cloud Platforms: AWS (EC2, S3, Lambda, Athena), GCP, Azure DevOps Data Management: ETL processes, Data Warehousing, Data Wrangling, Data Quality & Governance Collaboration Tools: Jira, Confluence, Git, Agile & Waterfall Methodologies EDUCATION

The University of Texas at Dallas, TX

Master of Science in Business Analytics, Graduate Certificate in Machine Learning Mahindra Ecole Centrale Hyderabad, Telangana, India Bachelor of Technology in Electrical and Electronics Engineering PROFESSIONAL EXPERIENCE

XNODE.AI, US

Data Engineer Jul 2025 – Present

• Engineered backend services for the AI platform using Python, SQL, FastAPI, and LangGraph, creating reusable APIs and data workflows that power large-scale agentic applications.

• Designed and managed ETL pipelines to ingest and transform data from project management tools and uploaded documents (BRDs, specs, reports) into structured, query-ready formats, ensuring accuracy and scalability.

• Automated conversion of Teams transcripts and chats into BRDs and roadmaps (epics, features, story points) using LLMs, and integrated them with project management platforms, reducing manual effort by ~70% and accelerating project onboarding by 40%.

• Developed SQL queries for validation and profiling, ensuring accurate datasets for AI and analytics.

• Conducted exploratory data analysis (EDA) and generated automated summaries/dashboards, accelerating insight delivery by 50% and supporting faster decision-making for stakeholders.

• Applied prompt engineering techniques to optimize LLM outputs for clarity, accuracy, and alignment with business requirements.

• Developed testing and validation frameworks to safeguard data integrity, platform stability, and API performance across deployments.

AAA National, US

Data Engineer Jan 2025 – Jun 2025

• Engineered and streamlined ETL pipelines using Redpoint, SSMS, and Automate BPA, reducing manual intervention by 90% and significantly accelerating data processing.

• Automated end-to-end ingestion, cleansing, and transformation of over 200M records, delivering 99% data accuracy and seamless integration across Snowflake and SQL Server environments.

• Developed complex SQL queries and stored procedures in SQL Server to extract, transform, and analyze large-scale datasets.

• Built dynamic Tableau dashboards to monitor ETL processes, cutting issue resolution time by 50% and enhancing pipeline transparency for business stakeholders.

• Partnered with business teams, data analysts, and engineers to align data solutions, implementing quality assurance processes to improve reporting accuracy and system reliability.

• Maintained clear documentation of workflows in Confluence and tracked tasks via Jira, increasing team alignment and improving traceability of data models and distributions.

Sama Tek Inc, US

Data Analyst Jul 2024 – Dec 2024

• Developed and maintained complex SQL queries to extract, transform, and analyze large datasets from PostgreSQL databases, flat files, ensuring data accuracy and integrity for reporting and analysis.

• Automated the processing of complex datasets, implementing statistical models and advanced analytics in Python, resulting in an improvement in forecast accuracy and streamlined workflows.

• Utilized AWS services including CloudWatch for system monitoring, Athena for querying large datasets, and Glue for ETL processes, optimizing cloud-based data workflows and improving system efficiency.

• Created compelling data visualizations and interactive dashboards using Power BI, effectively communicating insights and trends to both technical and non-technical stakeholders, tracking over 30 key performance indicators (KPIs).

• Created dynamic dashboards in Excel using slicers and interactive charts, providing real-time insights and enabling stakeholders to drill down into specific data points.

• Applied text mining techniques to unstructured data sources, extracting valuable insights and patterns to support decision-making and assessment processes.

• Conducted detailed risk analysis, utilizing statistical techniques to identify potential risks and provide actionable insights to mitigate them, analyzing risk factors for various products and scenarios. Tata Consultancy Services, Hyderabad, Telangana, India Assistant System Engineer Feb 2021 – Jul 2022

• Conducted comprehensive data analysis using Python and SQL to identify trends, patterns, and insights from large datasets, which supported strategic decision-making and improved business outcomes.

• Developed and maintained detailed data visualizations and reports using Tableau and Microsoft Excel, effectively communicating analytical findings and actionable insights to stakeholders, which facilitated informed business decisions and strategic planning.

• Engineered and implemented SQL scripts in Big Query to detect and resolve data anomalies, ensuring data accuracy and reliability for critical business operations.

• Leveraged a combination of SQL in Big Query and the Apache Beam framework in Python to successfully ingest data from diverse sources. Designed robust ETL (Extraction, Transformation, Load) pipelines and efficiently deployed them in Google Cloud Dataflow, streamlining data processing and reducing time-to-insights.

• Designed and implemented complex workflows (DAGs) in Google Cloud Composer, effectively orchestrating data pipelines and managing data flow for multiple projects.

• Provided mentorship to 10 batches of new associates on Google Cloud Platform (GCP) and data engineering principles, enhancing their skills and knowledge in the field.

• Implemented optimized data storage solutions in Google Cloud Storage, improving data retrieval times and reducing storage costs.

• Developed and deployed automated data quality checks using Python and SQL, ensuring continuous monitoring and maintaining high data integrity standards.

PROJECTS

EY Data Challenge– Rice Crop Detection in Vietnam - Python Machine Learning

• Developed a machine learning model to map and monitor rice crops in Dong Anh Province, Vietnam, utilizing satellite imagery. Collected and preprocessed over 600 data points, applying data preprocessing techniques such as scaling and label encoding to prepare the data for analysis.

• Implemented Support Vector Machine (SVM) architecture for image classification, using K-fold cross-validation and random search for model training and hyperparameter tuning to enhance performance and accuracy.

• Achieved a final model accuracy of 87%, with high precision of 96% and recall of 93%. The model successfully monitored rice crops, providing actionable insights and supporting effective agricultural planning and management. Database Design Project - SQL Server RDBMS

• Developed a travel itinerary database management system that enabled authorized members to share and exchange travel information seamlessly.

• Designed and implemented database architecture using MS SQL Server, including EER diagrams, relational models, and efficient database structures such as tables, indexes, and relationships.

• Utilized DDL and DML operations in MS SQL Server to create, manage, and query the database, ensuring data integrity and efficient data manipulation for seamless user experience.

Power BI Case Study – Human Resources Data Analysis - Excel Power BI

• Conducted exploratory data analysis and visualizations using Power BI to gain insights into Human Resources data.

• Demonstrated expertise in DAX functions for custom measures, calculated columns, and analysis.

• Developed interactive and visually appealing Power BI reports presenting HR metrics such as headcount, gender distribution, departmental analysis.

Student Performance Prediction Model - Python Machine Learning

• Developed a student performance prediction model using various machine learning algorithms, including Linear Regression, KNN Regression, Support Vector Regression, and Ridge Regression

• Collaborated with team members to analyze the dataset, identify relevant features, and make informed decisions for feature selection and model evaluation based on cross-validation techniques Inflation Analysis: Before and After the Pandemic - Alteryx Excel Tableau

• Analyzed inflation and consumer pricing data provided by the Bureau of Labor Statistics to identify key trends and findings using Alteryx workflows

• Provided insights into the potential effects of inflation to Goldman Sachs on various industries, including healthcare, technology, and retail and created visualizations to provide an intuitive understanding of inflation and consumer pricing trends CERTIFICATIONS

Alteryx Foundational Micro-Credential

Google Cloud Certified Data Engineer

Contact this candidate