SHASHANK SAI
London
Summary
Results-focused data professional equipped for impactful contributions. Expertise in designing, building, and optimizing complex data pipelines and ETL processes. Strong in SQL, Python, and cloud platforms, ensuring seamless data integration and robust data solutions. Known for excelling in collaborative environments, adapting swiftly to evolving needs, and driving team success.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Business Intelligence Analyst
Grosvenor
01.2024 - 12.2024
- Participated actively in stakeholder meetings, presenting data-driven insights and recommendations to support business growth initiatives.
- Designed and maintained scalable ETL/ELT pipelines using Azure Data Factory and Databricks, integrating data from multiple sources (databases, APIs, cloud storage) into a unified data warehouse
- Led end-to-end data pipelines, data architecture, data modeling & dimensional design in Azure Synapse using Spark Data Frames and PySpark SQL, enhancing team productivity by 25% and reducing deployment times by 40%
- Led SQL-based data solutions to optimize reporting accuracy and created interactive dashboards in Power BI and SQL Server Reporting Services (SSRS) to provide actionable insights into trading metrics, risk exposure, and market trends for upper management and Business users
- Developed and deployed interactive dashboards using graphs & charts, paginated reports, and data visualizations in Power BI, implementing Row-Level Security (RLS) and Object-Level Security (OLS) to safeguard sensitive data
- Designed and developed interactive Tableau dashboards using Advanced Table Calculations, Level of Detail (LOD) Expressions, and Dynamic Parameters to provide real-time insights for business leaders
- Optimized reusable data models and query performance in Power BI to reduce load times and enhance business intelligence efficiency by 30%, supporting dashboards with millions of rows of data
Power BI Developer
SA Marketing’s
09.2022 - 12.2023
- Managed data pipeline automation, ensuring seamless data integration from multiple sources while maintaining data accuracy and compliance (GDPR, CCPA)
- Designed and implemented an ETL workflow using Microsoft Power Automate, streamlining data processing from source system to dedicated database, reducing manual data handling time by 80% and improving data accuracy by 25%
- Designed, developed, and deployed SSIS packages in SSMS to automate ETL processes, ensuring efficient ETL between SQL databases and flat files, leading to a 30% improvement in data integration workflows
- Developed real-time event-driven solutions using Azure Event Hub and Python APIs, reducing data latency by 25%
- Conducted data modeling with SSAS Tabular using Azure DevOps for code management, facilitating the creation, testing, documentation, and publication of Power BI reports to meet business needs
- Developed sales performance dashboards integrating CRM data from Salesforce, tracking pipeline trends, conversion rates, and customer acquisition costs, leading to a 15% improvement in forecasting accuracy
- Built automated reports for sales teams using Power BI enabling real-time tracking of metrics with DAX and Power Query
BI and Data Engineer
Truist Financial Corp
10.2019 - 01.2021
- Collaborated with database architects, business analysts, stakeholders, and team members during modeling, design, and implementation stages to address business or industry requirements.
- Designed and developed Azure-based analytics solutions, integrating data from multiple sources into Azure SQL DB and Snowflake
- Collaborated on ETL (Extract, Transform, Load) tasks in Azure Data Factory and automating them using triggers
- Built and optimized reusable data models as centralized reporting sources, integrating Power BI Gateways to maintain up-to-date dashboards and minimizing data latency
- Led end-to-end implementation of Power BI reports, creating high-impacts including combination charts, scatter charts, waterfall charts, gauge visuals, and advanced DAX calculations for YTD, YOY, MTD, and MOM metrics, enhancing data storytelling and decision-making
- Automated sales and revenue tracking reports in Power BI, ensuring accuracy and timeliness of key business metrics
- Developed new customer experience KPI’s by analyzing customer interactions, retention trends, and Net Promoter Scores, influencing strategic decision-making
Junior Analyst
Verizon
08.2018 - 09.2019
- Designed KPI dashboards in Power BI, providing strategic insights for banking and investment divisions
- Conducted deep-dive analytics on customer transaction data, identifying trends that shaped new product offerings
- Designed and developed ETL/ELT control flow pipelines in Azure Data Factory, leveraging triggers and advanced transformations into mapping workflows, enhance data quality, and consolidate large & complicated datasets into Azure SQL databases
- Participated in data modelling, business process analysis using Star and Snowflake schemas, optimizing data structures to address both functional and non-functional business objectives while improving query performance
- Led an initiative to integrate Azure DevOps for better tracking of data engineering projects, improving sprint efficiency and automated financial reporting workflows using Power Query reducing manual workload by 60%
- Created complex T-SQL queries, stored procedures, User-defined Functions, Views, implementing Indexes and database triggers (DDL, DML) for efficient data processing, ensuring data integrity and enhancing operational reporting systems
- Streamlined financial reporting by extracting JSON data via Stripe API, reconciling payouts with transactions, and delivering actionable insights through dynamic Power BI visualizations
Education
MSc - advanced computer science
Cardiff Metropolitan University
Cardiff, CRF01.2023
Bachelor of Technology - Computer Science
Geethanjali University
Hyderabad01.2018
Skills
- Azure
- AWS
- GCP
- Apache Spark
- PySpark
- Kafka
- Databricks
- MS Data Gateway
- Power BI
- Tableau
- SSRS
- Salesforce
- Excel
- DAX calculations
- Power Query
- Paginated reporting
- Snowflake
- Python
- BambooLib
- Pandas
- Redshift
- BigQuery
- Azure Data Factory
- SSIS
- Active Batch
- APIs
- Apache Airflow
- SQL
- NoSQL
- T-SQL
- R
- Microsoft O365
- SSMS
- Power Automate
- Git
- GitHub
- Azure DevOps
- CI/CD
- Datadog
- Docker
- Kubernetes
- GDPR
- CCPA compliance frameworks
- Data-driven business solutions
Certification
- Microsoft Certified: Power BI Data Analyst Associate
- Microsoft Certified: Azure Data Engineer Associate
Technical Skills
Azure, AWS, GCP, Apache Spark, PySpark, Kafka, Databricks, MS Data Gateway, Power BI, Tableau, SSRS, Salesforce, Excel, DAX calculations, Power Query, paginated reporting, Databricks, Snowflake, Python (BambooLib, Pandas), Redshift, BigQuery, Azure Data Factory, SSIS, Active Batch, APIs, Apache Airflow, SQL, NoSQL, T-SQL, Python, R, PySpark, Microsoft O365, SSMS, Power Automate, Git, GitHub, Azure DevOps, CI/CD, Datadog, Docker, Kubernetes, GDPR, CCPA compliance frameworks, data-driven business solutions
Timeline
Business Intelligence Analyst
Grosvenor
01.2024 - 12.2024
Power BI Developer
SA Marketing’s
09.2022 - 12.2023
BI and Data Engineer
Truist Financial Corp
10.2019 - 01.2021
Junior Analyst
Verizon
08.2018 - 09.2019
- Microsoft Certified: Power BI Data Analyst Associate
- Microsoft Certified: Azure Data Engineer Associate
MSc - advanced computer science
Cardiff Metropolitan University
Bachelor of Technology - Computer Science
Geethanjali University
Similar Profiles
Leandro Santos De OliveiraLeandro Santos De Oliveira
General Operative at GrosvenorGeneral Operative at Grosvenor
Janae SuttonJanae Sutton
Housekeeper at GrosvenorHousekeeper at Grosvenor
Anurag SannidhanamAnurag Sannidhanam
Management Consultant at GrosvenorManagement Consultant at Grosvenor