Summary
Overview
Work History
Education
Skills
Timeline
Generic

VARUN ALLURI

Irving,TX

Summary

Results-driven BI Solutions Engineer with deep expertise in Tableau and Power BI, recognized for building scalable, high-impact dashboards across diverse domains, including Pharmaceuticals, Manufacturing, Procurement, and Finance. Proven success in automating complex data pipelines using Python and SQL, boosting data reliability, and cutting reporting time by over 50%. Skilled in developing regulatory and performance analytics solutions, integrating data platforms (ADW, EBS, AWS), and architecting data models for both real-time and strategic decision-making. Adept at translating complex business requirements into actionable insights, with a track record of aligning analytics with stakeholder goals across varied industries.

Overview

5
5
years of professional experience

Work History

BI Solutions Engineer

Indus River Technologies Inc
Irving, TX
11.2024 - Current
  • Developed Tableau dashboards for regulatory compliance and Continued Process Verification across Drug Product, Drug Substance, and Cell Build manufacturing processes
  • Integrated Python with Tableau via TabPy to automate data validation, anomaly detection, and advanced data processing before visualization, ensuring accurate and reliable dashboard insights
  • Designed data models and fact/dimension tables in Oracle ADW to support structured reporting
  • Integrated data from OCI Object Storage, ODI, and APIs to enable real-time reporting
  • Created 35+ CPV Drug Product visuals, 40+ Drug Substance visuals, and 15+ Cell Build visuals to track production efficiency, quality control, and regulatory compliance
  • Implemented Tableau Bridge on OCI VM for seamless connectivity between ADW and Tableau Server
  • Conducted demo sessions and stakeholder meetings to gather requirements and refine reports

BI Developer

Federal Bank
11.2023 - 10.2024
  • Developed Power BI dashboards for risk assessment, fraud detection, and compliance reporting
  • Created loan default prediction models by analyzing historical financial data
  • Designed interactive financial performance dashboards for tracking revenue, expenses, and portfolio performance
  • Integrated SQL databases and APIs for real-time ATM transaction trend analysis

BI & Data Engineer

Globion India
03.2022 - 10.2023
  • Designed and implemented ETL pipelines to integrate data from Salesforce, HubSpot, and POS systems into a centralized data warehouse
  • Developed Power BI dashboards to track sales performance, customer segmentation, and revenue forecasting for regional and global markets
  • Built automated data refresh mechanisms using SQL and Power Query, reducing manual reporting workload by 50%
  • Created a real-time dynamic pricing model using historical sales data, improving discount optimization strategies
  • Integrated market basket analysis to identify customer buying patterns and cross-sell opportunities
  • Standardized sales pipeline reporting across multiple teams, ensuring consistency in KPI definitions and revenue tracking
  • Automated email marketing and sales campaign performance analysis, enabling targeted customer outreach

BI Developer

Royal Technology Services
08.2021 - 02.2022
  • Built Tableau dashboards to monitor inventory levels, order fulfillment, and supplier performance
  • Created real-time supply chain monitoring dashboards using live API data
  • Developed ETL processes to integrate supplier performance data, warehouse inventory, and shipment tracking into a unified reporting database
  • Developed reports for fleet & transportation efficiency, optimizing delivery routes and reducing delays
  • Implemented demand forecasting models using historical shipment data

Data Engineer/Business Intelligence Analyst

Shakti Hormann
08.2020 - 07.2021
  • Designed Power BI reports for production efficiency, downtime analysis, and predictive maintenance
  • Leveraged Python scripts within Power BI to automate data transformation, anomaly detection, and validation, enhancing data reliability and report accuracy
  • Created dashboards to track quality control KPIs and defect rates
  • Developed equipment utilization and OEE (Overall Equipment Effectiveness) dashboards
  • Integrated IoT sensor data for real-time asset tracking and maintenance planning

Report Developer

Elico
01.2020 - 07.2020
  • Developed Power BI dashboards to track sales performance, customer segmentation, and revenue trends
  • Created dynamic KPI reports for sales forecasting and territory analysis
  • Integrated Salesforce Data Cloud with Power BI for enhanced customer insights
  • Automated Excel-based reports into interactive dashboards, reducing manual reporting time by 50%

Education

Executive MBA - Business Analytics

Swiss School of Business Management
Geneva, Switzerland
07-2023

Bachelors - Computer Applications

Symbiosis Institute of Computer Studies and Research
India
01.2021

Skills

  • Atom
  • AWS
  • DAX
  • ETL
  • HubSpot
  • IoT
  • Microsoft Power BI
  • Oracle Apex
  • Code validation
  • POS systems
  • PostgreSQL
  • Power Query
  • Python
  • Salesforce
  • Snowflake
  • SQL
  • Tableau
  • Oracle Cloud

Timeline

BI Solutions Engineer

Indus River Technologies Inc
11.2024 - Current

BI Developer

Federal Bank
11.2023 - 10.2024

BI & Data Engineer

Globion India
03.2022 - 10.2023

BI Developer

Royal Technology Services
08.2021 - 02.2022

Data Engineer/Business Intelligence Analyst

Shakti Hormann
08.2020 - 07.2021

Report Developer

Elico
01.2020 - 07.2020

Executive MBA - Business Analytics

Swiss School of Business Management

Bachelors - Computer Applications

Symbiosis Institute of Computer Studies and Research

Similar Profiles

CREATE PROFILE
VARUN ALLURI