Gopi Sriram

Designed and delivered advanced Power BI dashboards, KPIs, and executive reports, emphasizing performance optimization, interactivity, and data storytelling for decision-making. Built scalable ETL pipelines using SQL, Python (Pandas, NumPy), and cloud services (Azure Data Factory, AWS Glue, Lambda) to process structured and unstructured data. Developed and optimized data models (star/snowflake schemas, composite models, aggregations) to support high-performance analytics across large datasets. Implemented advanced DAX (time intelligence, rankings, dynamic measures, conditional logic) for complex calculations and real-time insights. Enhanced reporting usability through drill-throughs, bookmarks, tooltips, parameterized views, and incremental refresh strategies. Managed Power BI Service end-to-end, including workspace administration, automated refresh, security (RLS/OLS), subscriptions, and cloud integrations (Azure SQL, AWS RDS, S3, Data Lakes). Leveraged Python in cloud workflows (Azure Functions, AWS Lambda) for automation, EDA, and analytics-ready transformations. Authored optimized SQL queries, CTEs, window functions, views, and stored procedures to ensure consistency across BI and data pipelines. Created Python-based visualizations (Plotly, Matplotlib, Seaborn) to support advanced statistical and trend analysis alongside Power BI. Partnered with stakeholders to define KPIs, gather requirements, and deliver self-service BI solutions aligned with business objectives. Documented business processes, data flows, and system interactions, acting as a bridge between business users and technical teams. Identified and implemented process improvements and reporting automation, reducing manual effort and improving data reliability. Enforced data quality, validation, and governance across SQL, Power BI, and Python environments. Delivered training, documentation, and executive presentations, translating complex data into clear, actionable insights.

Automated ESG, sustainability, and academic data collection using Python (Beautiful Soup, Scrapy), including data cleaning and exploratory analysis. Built and optimized Python-based ETL pipelines to improve accuracy, efficiency, and reporting reliability. Gathered and translated business and academic requirements into technical specifications for dashboards and data workflows. Created standardized process documentation for data ingestion, transformation logic, and reporting pipelines. Developed interactive dashboards and visualizations using Power BI, Tableau, Plotly, Dash, and ArcGIS. Designed Power BI dashboards to track student performance, enrollment trends, and academic KPIs. Utilized SQL to query, manage, and validate datasets for accurate reporting and analysis. Analyzed ESG, sustainability, and clean energy datasets to support environmental compliance and policy insights. Implemented quantitative metrics and conducted data audits to assess program impact and identify data gaps. Produced stakeholder-ready reports and communicated insights in clear, non-technical language to academic and sustainability teams.

Delivered end-to-end Power BI solutions for banking and financial clients, including dashboards, reports, KPIs, and scorecards handling large-scale datasets. Gathered and translated business requirements into actionable dashboards and reports, converting complex needs into technical specifications and scalable BI solutions. Developed advanced DAX measures, calculated columns, and custom tables for analytics, trend analysis, forecasting, and anomaly detection. Built interactive dashboards with slicers, filters, bookmarks, drill-throughs, custom visuals, and dynamic titles to enable data-driven decision-making. Designed and optimized data models using Snowflake, SQL Server, and Databricks, applying incremental loading for faster refreshes and improved performance. Implemented Row-Level Security (RLS) and role-based access in Power BI Service, ensuring secure handling of sensitive banking data. Automated reporting workflows and notifications using Power Automate, streamlining daily, weekly, and monthly business processes. Migrated legacy reports from Cognos, Excel, and VBA macros to Power BI, improving accuracy, performance, and visualization. Managed ETL pipelines using Python, Databricks, and Snowflake, integrating data from multiple sources via JDBC, ODBC, APIs, REST, and live connections. Published, scheduled, and maintained dashboards in Power BI Service, managing workspaces, deployment pipelines, version control, and governance practices. Conducted unit testing, data validation, performance tuning, and metadata tagging to ensure quality, compliance, and audit readiness. Partnered with cross-functional teams to deliver functional documentation, workshops, and training sessions, enabling self-service analytics adoption. Integrated Power BI with AWS (S3, EC2, Redshift), Git, Jenkins, Elastic Beanstalk, and Denodo for secure, automated, and version-controlled BI deployments.