Home

Surya - Business Intelligence / Power BI / Tableau

[email protected]

Location: Greenville, South Carolina, USA

Relocation: Open to Relocate any where in USA

Visa: H1B

RAGHURA Greenville, SC 29605 Tel: +1 248-254-4755 SUMMARY Results-driven Business Intelligence Professional with 14+ years of experience in data visualization, reporting, and analytics, specializing in Tableau, Power BI and AWS Quick Sight. Expert in developing high-performance dashboards and translating complex business needs into actionable insights. Skilled in transforming complex datasets into clear, actionable insights through interactive dashboards, optimized data models, and automated reporting. Adept at collaborating with stakeholders and cross-functional teams to deliver scalable BI solutions. Strong analytical mindset with a consistent focus on data-driven decision-making and performance optimization. EDUCATION Master of Computer Application (MCA)- Dravidian University- 2008 Bachelors Science in Mathematics, Sri Venkateshwara university- 2005 CERTIFICATIONS Tableau Desktop Specialist Tableau Certified Data Analyst CORE COMPETENCIES Tableau Development Dashboard design, calculated fields, LOD expressions, data blending, performance tuning Power BI Development Data modeling, DAX, Power Query (M), report optimization, RLS implementation Data Visualization & Storytelling Designing intuitive, user centric dashboards and KPI driven analytics ETL & Data Preparation Dataflows, SQL transformations, data cleansing, and integration across multiple sources SQL Expertise Complex queries, joins, aggregations, stored procedures, and performance tuning Data Warehousing Concepts Dimensional modeling, fact/dimension design, SCD handling Microsoft Fabric Lakehouse, Data Warehouse, Pipelines, and Semantic Models Cross Functional Collaboration Working with business stakeholders, data engineers, and product teams Performance Optimization Improving model efficiency, query performance, and dashboard load times PROFESSIONAL EXPERIENCE BMW, Greenville - SC Feb 2022- Till Date Sr. BI/Viz Engineer Project: Motorrad BSC May 2025-Present Collaborated with cross-functional business stakeholders to gather and define application development requirements aligned with strategic goals. Spearheaded the end-to-end development of dynamic Tableau dashboards for the BMW Motorrad Dealer Performance Scorecard (BSC), replacing manual reporting processes and enabling real-time strategic planning. Developed highly interactive Tableau reports using multiple data sources and custom SQL queries. Implemented RLS (Row Level Security) for Dealer face dashboards Designed and developed interactive Tableau dashboards to track BMW dealer sales performance, including KPIs such as monthly sales, model mix, inventory turnover, and regional trends. Built dealer level scorecards to compare performance across regions, dealerships, and sales teams, enabling leadership to identify high performing and underperforming locations. Developed advanced Tableau calculations, including LOD expressions, custom KPIs, and dynamic parameters to support flexible dealer analysis. Involved in troubleshooting and performance tuning of Tableau dashboards Implemented data source optimization techniques to improve dashboard responsiveness. Reduced workbook size and improved rendering speed by leveraging context filters, parameter controls, and calculated fields efficiently. Conducted code and solution reviews, recommending enhancements to improve performance, scalability, and reduce support costs. Project: Rolls-Royce SSOT Nov 2024 - Apr 2025 Designed and developed interactive dashboards and visualizations using AWS QuickSight to support business intelligence and reporting needs. Integrated QuickSight with Amazon Redshift, S3, RDS, Athena, and other AWS data sources for real-time analytics. Created calculated fields, filters, parameters, and custom visuals to deliver actionable insights to stakeholders. Implemented SPICE (Super-fast, Parallel, In-memory Calculation Engine) for optimized performance and faster data refreshes. Managed user access and permissions using AWS IAM roles and groups to ensure secure and scalable dashboard sharing. Automated data refresh schedules and report distribution using QuickSight APIs and AWS Lambda functions. Migrated existing BI reports from traditional tools to QuickSight, improving performance and reducing infrastructure costs. Collaborated with cross-functional teams to gather requirements and translate them into cloud-native BI solutions. Monitored and optimized dashboard performance, ensuring low latency and high availability across regions Project: MRL (Material Readiness Level) Dec 2023 - Oct 2024 Developed interactive Power BI dashboards to track Material Readiness Levels (MRL) across BMW plants, suppliers, and production lines, enabling proactive monitoring of part availability. Built robust data models integrating ERP, supply chain, procurement, and logistics data to provide a unified view of material status and readiness KPIs. Designed visualizations to highlight critical shortages, delayed shipments, supplier bottlenecks, and high risk components, supporting timely decision making for production planning teams. Implemented DAX measures to calculate readiness scores, lead time variances, fill rates, and supplier performance metrics. Created drill down and drill through reports for analyzing material readiness at plant, line, supplier, and part number levels. Automated data refresh pipelines and optimized model performance using incremental refresh, query folding, and efficient relationships. Collaborated with supply chain managers, planners, and procurement teams to translate operational requirements into actionable Power BI insights. Integrated RLS (Row Level Security) to ensure sensitive supplier and plant level data was accessible only to authorized users. Conducted data validation and reconciliation to ensure accuracy of MRL calculations and alignment with BMW s supply chain standards. Delivered KPI scorecards for leadership to monitor material availability risks, production impact, and supplier readiness trends over time. Project: BMW/MINI Balance Score Card Feb 2022 Nov 2023 Involved in the full project lifecycle of SDLC and coordinated with all project teams. Worked closely with business and development teams to design and document dashboards, alerts, and reports that support decision-making. Designed and developed interactive Tableau dashboards to track BMW dealer sales performance, including KPIs such as monthly sales, model mix, inventory turnover, and regional trends. Built dealer level scorecards to compare performance across regions, dealerships, and sales teams, enabling leadership to identify high performing and underperforming locations. Integrated data from CRM, DMS, and inventory systems to create a unified view of vehicle sales, test drives, leads, and conversion rates. Developed advanced Tableau calculations, including LOD expressions, custom KPIs, and dynamic parameters to support flexible dealer analysis. Created visualizations to analyze model popularity, trim level performance, and customer buying patterns across BMW s product lineup. Implemented data quality checks and validation processes to ensure accuracy of sales and inventory data before publishing dashboards. Collaborated with sales managers, regional directors, and marketing teams to translate business requirements into actionable Tableau insights. Optimized dashboard performance through data extracts, efficient joins, and aggregation strategies, improving load times for large dealer datasets. Led the planning, analysis, functional design, testing, and implementation of solutions following Agile delivery methodologies. Conducted code and solution reviews, recommending enhancements to improve performance, scalability, and reduce support costs. Using Tableau Desktop, created multiple rich dashboards visually telling stories of the business status, strength & weakness, potentials etc. for the client briefly, and also interacting with data as necessary. Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop. Generated guided navigation links for Interactive dashboards in Tableau. Oversee the performance of Design to develop technical solutions from Analysis documents. Provided post implementation production support. Elevance Health, Atlanta - GA Sep 2018 - Jan 2022 Tableau Consultant/ Sr. Data Analyst Project: Client Information Insights Analyzed the large sets of data using various techniques such as quantitative analysis, advanced analytics and statistical modeling to find solutions. Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop. Working with various business stakeholders on requirements gathering for application development. Experience in creation of Data visualizations, Dashboards, Reports and score cards. Created parameters to give ability to users to dynamically change the filters and see resulting numbers. Involved in generating dual-axis, Bar chart, with multiple measures and data blending in case of merging different sources. Created action filters in worksheets and dashboards. Performed Tableau type conversion functions when connected to relational data source. Good knowledge in Data warehouse concepts, Star Schema / Snow Flake Schemas. Knowledge in various reporting objects like Actions, Calculated fields, Hierarchies, Sets, Groups, Filters, Parameters in Tableau. Expertise in Joins, Data Blending and Dual Axis in Tableau. Expertise in Aggregations, Forecasting, Trend lines, formatting in Tableau. Designed and deployed reports with Drill up and Drop down menu option and Parameterized and Linked reports using Tableau. Elevance Health, Hyderabad Jan 2012 - Aug 2018 Data Analyst/BI Developer Project: IHM Ops Reporting Worked with end users to gain an understanding of information and core data concepts behind their business. Assisted in defining business requirements for the IT team and created BRD and functional specifications documents along with mapping documents to assist the developers in their coding. Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific task Written SQL scripts to test the mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update. Designed and implemented scalable data models to support enterprise reporting and analytics, optimizing performance across SQL Server environments. Built end to end ETL pipelines using SSIS to extract, transform, and load data from diverse sources into centralized data warehouses. Developed interactive dashboards and analytical reports using SSRS, Excel, and Tableau to support business decision making. Wrote complex T SQL queries, stored procedures, and functions to fulfill ad hoc data requests and deliver accurate insights to stakeholders. Improved data quality and consistency by implementing validation rules, transformation logic, and automated data workflows. Collaborated with cross functional teams to gather reporting requirements and translate them into actionable BI solutions. Optimized SQL queries and ETL processes to reduce execution time and enhance system performance. Supported ongoing maintenance, troubleshooting, and enhancement of BI solutions within the Microsoft SQL Server BI stack (SSRS /SSIS). TECHNICAL SKILLS BI Tools: Tableau (Desktop/Server), Power BI (Desktop/Service), AWS QuickSight, SSRS ETL & Data Prep: Informatica, Tableau Prep Builder,SSIS Databases: Athena, AWS Redshift, Teradata, Oracle, SQL Server, PostgreSQL, Snowfalke, Flat Files Cloud & Integration: AWS (Redshift, S3), Microsoft Fabric (Lakehouse, Data Warehouse, Pipelines, Semantic Models) Project Management: JIRA, Confluence, Agile/Scrum tools Scripting Languages: SQL, PL/SQL, T-SQL, DAX, M (Power Query) Data modeling: Erwin, Star Schema, Snowflake Schema Version Control: Git, Bitbucket Keywords: business intelligence sthree active directory information technology procedural language Georgia South Carolina