Shivangi Gupta

Project: Healthcare Reporting System Built ETL pipelines using Azure Data Factory & PySpark Developed Power BI dashboards with DAX & M for real-time KPIs Reduced report latency by 40% through optimized SQL transformations Project: ML in KPI Analysis Applied regression models using scikit-learn to uncover performance patterns Used Pandas and Seaborn for feature exploration and trend visualization Currently exploring LangChain and LLM-based AI use cases

Designed interactive Power BI dashboards for senior stakeholders across finance and risk teams, enabling faster decision-making Optimized complex SQL queries and stored procedures, improving report performance by 60% Built modular ETL workflows using SSIS and Azure Data Factory to streamline data ingestion and processing Improved pipeline reliability and reduced manual intervention through automation and reusability

Performed ETL using PySpark DataFrames in Azure Databricks to process and transform large-scale datasets Developed complex SQL logic and implemented it via SSIS packages in an enterprise data warehouse environment for analytics and reporting Built and managed data pipelines from on-premise SQL Server to Power BI dashboards using modern ETL techniques Designed and executed Azure Data Factory pipelines and Synapse workflows for seamless cloud-based data orchestration Deployed and monitored SSIS pack

Managed the setup and maintenance of 600+ standalone and clustered SQL Servers across production, UAT, development, and test environments Deployed T-SQL scripts, XMLA scripts, batch files, and SSIS packages to production and non-production servers Monitored and resolved SQL Server performance bottlenecks, implementing both preventive and corrective measures Evaluated security risks and enforced robust database access controls and permission structures Provided comprehensive backup and recovery sol