Data Analyst Power Bi

Ram Swarup Bavikati

USA (Open to Relocation) *********.**********@*****.*** 812-***-**** linkedin.com/in/ramswarup-bavikati/ Decision Intelligence & Data Analyst SQL & ETL Developer ML Integrator PROFILE

Experience architecting end-to-end data pipelines, fine-tuning multi-step SQL workflows, and designing live BI dashboards that distill millions of data points into clear insights for senior executives. Recognized for the Best Employee Award in the TIBCO PSG in 2022. Known for developing automated ETL pipelines, ensuring data accuracy, and conducting customer insight analysis to optimize marketing performance and user engagement. TEDx organizer with exceptional communication, organization, and public speaking skills. Core Skills & Competencies

Requirement Analysis Model Deployment & Experiment Tracking (MLflow) Interactive BI & Geo-Visualization Cloud Data Warehousing

& Lakehouse Design Agile Collaboration & Technical Documentation Query Performance Tuning & Indexing CI/CD for Data Workflows KEY AREAS OF IMPACT

● Data Analysis for U.S. FDA Medical Devices: Processed 1.2M+ FDA device records by transforming data with Apache Spark SQL and advanced Joins/CTEs in PostgreSQL; created ESRI ArcGIS maps and Power BI dashboards for detailed geospatial trends, reducing compliance violations by 23% and saving $2.7B.

● Teaching Assistant for Scheduling Optimization System Kelley School of Business: Built Power BI dashboards using DAX and connected to SQL queries in MS SQL Server; analyzed historical enrollment data, applied time-slot clustering with Python, and automated schedule reports with Power Automate, resolving inefficiencies and boosting student engagement by 22%.

● Green Commute Optimizer: Developed an AI-powered route recommendation system using OpenStreetMap to suggest low-traffic, low-emission paths for student commutes. Applied K-Means clustering to segment travel patterns, integrated real-time bus occupancy feeds, and implemented Google OR-Tools constraint programming to generate optimal routes, cutting commute time by 20%. WORK EXPERIENCE

AI & Data Solutions Analyst Kelley School of Business May 2024 – June 2025

● Ingested raw student feedback data (10K+ records) from Salesforce CRM, Google Forms, and manual surveys using AWS Glue ETL pipelines; staged files in AWS S3 buckets, applied IAM role-based access controls, then loaded structured tables into Snowflake.

● Ensured data integrity by writing Python scripts with Pandas merge, building PyTest checks for nulls & mismatches, configuring AWS CloudWatch alarms to track Glue ETL step failures and trigger SNS alerts on row count mismatches, cutting bad data rows by 75%.

● Implemented Glue job bookmarks and S3 partitioning for incremental ETL runs, registered curated datasets in Glue Data Catalog to enable lineage tracking, and enabled ad-hoc audits with Athena queries, improving pipeline efficiency and traceability by 40%.

● Trained the CNN-LSTM sentiment classifier in Databricks (Python, TensorFlow) using tokenized student comments stored in Snowflake tuned hyperparameters and tracked runs with MLflow, stored final model artifacts in S3, and deployed batch predictions back to Snowflake tables to update Power BI dashboards for engagement analysis, boosting targeting precision by 21%

● Built model explainability reports using SHAP in Databricks to interpret CNN-LSTM sentiment predictions; analyzed feature contributions, identified potential sentiment bias by demographic segments, and documented findings to validate model fairness and technical performance.

Data Analytics Consultant TIBCO Software Jun 2021 – Jul 2023

● Led a team of four consultants to gather, analyze, and document over 100 client requirements; mapped workflows with Visio and Lucidchart, wrote detailed functional specifications in Confluence, and oversaw deployment of data integration solutions on Oracle Cloud using Terraform and TIBCO BusinessWorks.

● Delivered 40+ operational and executive KPIs by designing Oracle Data Warehouse star schemas and writing advanced PL/SQL stored procedures for data transformations; managed version control with SVN and published dashboards through TIBCO Spotfire.

● Enabled real-time operational visibility for global clients by integrating Oracle, SQL Server, and Salesforce SOAP APIs; consolidated multi-source data with Data Virtualization and rolled out 80+ Spotfire dashboards used across Americas and EMEA.

● Reduced manual data processing by 45% by developing ETL workflows using SQL Server Integration Services (SSIS) and PowerShell scripts; automated daily refresh schedules with SQL Server Agent and Spotfire Automation Services to ensure SLA compliance and exception alerts.

● Developed SQL validation queries and reconciliation scripts to test Oracle DW loads; supported client User Acceptance Testing (UAT) for Spotfire dashboards, resolved data mismatches, and ensured on-time signoff for production rollout. EDUCATION

Master of Science in Data Science Indiana University Bloomington – Bloomington, IN May 2025 BTech in Computer Science and Engineering Jawaharlal Nehru Technological University – Hyderabad, TS, India May 2021 CERTIFICATION

AWS Certified Solutions Architect Certified Technology Management Associate – Indian School of Business Microsoft Technology Associate – Python & SQL Associate Microsoft Power BI Certified TECHNICAL SKILLS

Programming and Scripting: Python, R, SQL, VBA (Excel Macros), DAX (Power BI) // Databases: Oracle, MySQL, MS SQL Server, Neo4j // Tools: AWS, ibi WebFocus, Looker, Advanced Excel, Google Data Studio, Spotfire, Power Automate // Data Visualization: Power BI, Tableau, D3.js, Qlik Analytics // AI/ML: Supervised and Unsupervised ML, Deep Learning, Scikit-Learn, OpenCV, Pandas, NumPy, Seaborn, NLP PUBLICATION

“Extraction of Recipes from Food Images by Using CNN Algorithm," 2021 Fifth International Conference on I-SMAC (IoT in Social, Mobile, Analytics and Cloud) – Engineered CNN-based image-to-recipe pipeline in Keras and trained on 1K images, achieving 96.05% accuracy. The project cut manual recipe curation time by 70%, improved menu development cycles by 50%, and increased click-through rates by 20%.

Contact this candidate