Sai Kiran Yadav Email and Phone Number

• Architected and implemented a Google Cloud Function to automate daily data collection of file size and row count from the GCS bucket, augmenting operational efficiency by 10% through timely and accurate data for decision-making• Authored 15+ SQL Scripts to extract data from BigQuery on campaign performance and deal pipeline progression using (window functions, CTEs, joins) and achieved a 30% decrease in query runtime through proactive tuning and optimization strategies• Orchestrated a Year-to-Date (YTD) Customer Campaigns dashboard and Monthly Billing dashboard in Looker. Provided valuable insights to increase customer engagement and ensured 100% concise tracking of billing metrics.

• Engaged in requirement gathering sessions to comprehend expectations, collaborating with system analysts to understand the format and patterns of upstream source data.• Developed and maintained ETL pipelines for data ingestion using Azure Data Factory. Migrated data from client legacy applications or third-party applications (ECW, Cerner, NextGen) to Allscripts Practice Management. Process involved extracting, preparing, and transforming data using a staging database, then migrating it to the production database after validation.• Built complex ETL jobs visually transforming data using data flows or Azure Databricks and Azure SQL Database compute services.• Utilized various activities in Azure Data Factory, including data movement, transformations, and control activities such as Copy data, Data flow, Get Metadata, Lookup, Stored procedure, and Execute Pipeline.• Managed Storage services, including Data Lake Storage Gen 1 and Gen 2, and Storage Explorer for hosting CSV, JSON, and Parquet files, ensuring effective access management across storage accounts.• Wrote Databricks notebooks (Python) for handling large volumes of big data, processing, transforming, and analyzing. Maintained Azure Databricks jobs.• Implemented the full cycle of Power BI visualizations, including extracting and transforming data in Power Query, designing various visualizations in Power BI desktop, publishing reports into Power BI Services, and developing and managing dashboards.• Created complex T-SQL scripts involving multi-table joins, correlated subqueries, CTEs, Triggers, Stored Procedures, User Defined Functions, Window Functions, Indexes, Dynamic SQL Scripting Queries for automation tasks and reporting.• Developed data validation scripts to route invalid data to Validation tables.

• Developed ETL workflows and mappings for extracting, transforming, and loading data from diverse sources into target environments, aligning with current data loading architecture or on an ad-hoc basis.• Executed Extract, Transform, and Load processes from Source Systems to Azure Data Storage services, leveraging Azure Data Factory, T-SQL, Spark SQL, and Azure Data Lake Analytics.• Created Power BI reports and dashboards focusing on Patient's Demographics, Appointments, Claims analysis, KPIs, and YTD analysis sourced from Azure Analysis Services. Published reports to Power BI web service and implemented user security.• Designed and implemented SSIS Packages to pull data from heterogeneous sources into destinations like Azure SQL DB, Azure SQL Data Warehouse, and Flat Files.• Built efficient SSIS packages for processing dimension and fact tables with complex transformations, accommodating Type I, II, and III Slowly Changing Dimensions using Merge.• Designed and maintained cubes in SSAS with Star and Snowflake schemas.• Worked on creating, maintaining, and improving databases, schema objects, SQL queries, Generating Dynamic SQL Scripts, Stored procedures, Indexes, Functions, and views for data migration and ad-hoc reporting.

• Designed diverse reports (Table, Matrix, drill-down, drill-through, linked reports, parameterized reports, and sub-reports) using SSRS, facilitating data-driven decision-making for stakeholders.• Developed SSIS packages incorporating control flow tasks (Foreach Loop Container, Sequence Container, Execute SQL task) to efficiently source, extract, and transform data from multiple systems (Oracle, SQL Server, and Flat Files).• Implemented Event Handlers for various runtime events and created a Custom Log Provider in SQL Server, ensuring meticulous logging for audit purposes.• Utilized T-SQL to develop and maintain SQL tables, indexes, stored procedures, views, and triggers tailored for reporting requirements.