Home

Sathish Bhaskar rao - Data Enigineer

[email protected]

Location: Puyallup, Washington, USA

Relocation:

Visa: H1B

Resume file: Sathish Baskar Rao - Resume (4)_1761248182825.docx Please check the file(s) for viruses. Files are checked manually and then made available for download.

SATHISH BASKAR RAO Puyallup, Washington 98372 | (425) 208-6258 | [email protected] | http://www.linkedin.com/in/sathish-baskar-rao/ SUMMARY Results-driven Data & BI Engineer Lead with 15+ years of experience delivering enterprise-scale data solutions across healthcare, retail, and tech industries. Expert in designing robust ETL pipelines, scalable data platforms, and advanced BI solutions using Azure, Power BI, Snowflake, and MSBI. Skilled in end-to-end pipeline development with ADF, Databricks, Spark, and SQL. Specialized in star/snowflake modeling, data normalization, and performance tuning. Proven ability to lead global teams, implement data governance, and drive platform migrations. Strong in Power BI dashboards, DAX, embedded analytics, and DevOps (CI/CD, Git, Kubernetes/Docker). Experienced in financial/regulatory reporting, KPI dashboards, and cloud-native environments including Azure Synapse and Data Lake. TECHNICAL SKILLS Data Engineering: Data lakes, ETL Cloud Platforms: Azure SQL, Azure Synapse Analytics, Azure Data Factory, Azure Databricks, Azure Data Explorer, Azure Data Studio, Snowflake, Power BI, Power BI Report Builder, 1010data Business Intelligence and Analytics: SSIS, SSAS, SSRS, Power BI, Power Apps Data Modeling and Analytics: Star Schema, Snowflake Schema, DAX Data Governance and Security: Data Quality, GDPR Compliance, Encryption Programming Languages: SQL, Python, and Kusto EXPERIENCE WELLTOWER Data Platform Analyst & Engineer Lead, Dallas, TX May 2024 Till now Designed, developed, and maintained ETL required to populate dimensional data models. Led key initiatives to enhance scalability and efficiency of technology stack. Contributed to shaping and building non-production environment (NPE) infrastructure. Developed and implemented dimensional data models to optimally deliver on needs of business stakeholders. Created ETL pipelines in and out of data warehouse. Developed major regulatory and financial reports using advanced SQL queries in snowflake. Design, build, and optimize data warehouses, data models, and efficient SQL queries within Snowflake. Develop and maintain ETL (Extract, Transform, Load) or ELT (Extract, Load, Transform) pipelines to ingest, transform, and load data into Snowflake Innovated efficient methods to process large-scale data seamlessly 24/7. Integrated Purview with Power BI to enhance data transparency and ensure consistent use of certified datasets across dashboards. Automated data discovery and classification across structured and unstructured sources using Purview s built-in scanning and labeling capabilities. Ensure data governance aligns with company policies and guidelines. Collaborate with Data Analytics and Product leadership to establish best practices and standards for building robust, production-ready analytic pipelines. Delivered robust, always-available data platform supporting entire team. Experience in Azure Fabric Services and Azure container service. Designed and deployed architecture for Azure Service fabric. Designed, Developed, Tested, Published and maintained Power BI Functional reports, Dashboards for the management teams Familiarity with Azure DevOps methodologies, Git version control workflows, and the development of CI/CD pipelines to streamline automation and deployment processes. Performed comprehensive data discovery and profiling across diverse datasets to assess data quality, relevance, and completeness prior to ETL processing. Used a combination of Python and Spark and Spark SQL context to transform Semi-Structured data and to create aggregate level tables. Strong expertise designing star and snowflake schemas and performing data normalization and denormalization. Innovated efficient methods to process large-scale data seamlessly 24/7. Delivered robust, always-available data platform supporting the entire King team. Dollar General Data Analyst & Engineer Lead, Goodlettsville, TN July 2022 Apr 2024 Lead Power BI and embedded reports development. Managed risk, project communication, and client interactions. Provided on-call support for production job failures, collaborating across teams to resolve issues. Utilized Docker container clusters and Kubernetes for managing infrastructure. Offered on-call support for production job failures and lead collaborations with teams to resolve issues. Created reports using SQL, MS Excel, UNIX, Shell scripting and Perl Develop and maintain ETL pipelines to ingest, transform, and load data into Snowflake Data reconciliation using snowflake Designed and developed Real Time Stream Processing Application using Spark, Kafka, Scala and Hive to perform Streaming ETL and apply Machine Learning. Pushing the data to GCP using snowflake Provided indefinite support to team members in building pipelines, developing PySpark /Scala code in Databricks, creating Power BI reports, creating database stored procedures/triggers/views etc. Used a combination of Python and Spark and Spark SQL context to transform Semi-Structured data and to create aggregate level tables. Publix Senior Power BI Developer, Nashville, TN Dec 2021 July 2022 Imported data from Azure DataBrick to Power BI to generate reports for weekly and monthly reports. Developed Dax Queries to generate computed columns in Power BI. Generated computed tables in Power BI by using Dax. Built comprehensive reports with Power BI Report Builder to support business insights. Used various source to pull data into Power BI such as SQL Server, Azure SQL, Snowflake, 1010data Strong expertise designing star and snowflake schemas and performing data normalization and denormalization. Hands-on experience in diagnosing, troubleshooting various Linux server's services issues and performing preventive maintenance. Design, build and manage the ELK (Elasticsearch, Logstash, and Kibana) cluster for centralized logging and search functionalities for the App. Build visualization and Dashboards using Kibana. Microsoft Azure Data Engineer, Puyallup Apr 2021 Dec 2021 Extracted transform and load data from sources systems to Azure data storage services using combination of Azure data factory, T-SQL, Spark SQL and U-SQL Azure data lake analytics. Oversaw data ingestion to one or more Azure services, such as Azure data lake, Azure storage, Azure SQL, and Azure DW and processing data in In Azure Databricks. Created pipelines in ADF using linked services, datasets, pipeline, to extract, transform and load data from different sources, like Azure SQL, Blob storage, Azure SQL Data warehouse, write-back tool and backwards. Estimated cluster size. Monitored and troubleshot Spark databrick cluster. Created build and release for multiple projects (modules) in production environment using Visual Studio Team Services (VSTS). Gained hands-on experience on developing SQL scripts for automation purposes. Developed Spark applications using Pyspark and Spark-SQL for data extraction, transformation, and aggregation from multiple file formats for analyzing and transforming data to uncover insights into customer usage patterns. Utilized Power BI and Power BI embedded reports. Develop Databricks Python notebooks to Join, filter, pre-aggregate, and process the files stored in Azure data lake storage. Developed ETL workflows in Azure Data Factory (ADF) to extract, transform, and load data from diverse sources into a data warehouse, ensuring efficient data processing and integration. Developed scalable querying frameworks using KQL to optimize data exploration and reporting within Azure Data Explorer. Utilized Azure Data Explorer and Kusto Query Language (KQL) to efficiently retrieve and analyze data. Developed, optimized, and documented complex KQL queries for data transformation, aggregation, and reporting. Built interactive Power BI dashboards connected to ADX, leveraging DAX for advanced calculations Implemented and continually improved Denodo 9 features, identifying refactoring and code optimization opportunities. Led review and implementation of Denodo row/column-level entitlements and data classification strategies. Design and manage data pipelines to efficiently extract, transform, and load (ETL) data from various sources into a centralized storage solution like a data warehouse or data lake. Familiarity with Azure DevOps methodologies, Git version control workflows, and the development of CI/CD pipelines to streamline automation and deployment processes. Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in In Azure Databricks. Supported implementation of Unity Catalog, Delta Lake, and Lakehouse architecture features in Databricks environments. Contributed to workflow orchestration and monitoring solutions for scalable data platforms using Azure-native tools. Set up Microsoft Flow (Power Automate) to provide auto-approval and status update features based on predefined criteria. Built application in PowerApps using Common Data Service, Flow, Excel, and SharePoint. Hands-on experience with Microsoft Purview (Data Governance, Catalog Management) Used Power Automate to create flow to find correct template and created Azure DevOps Work items, and ICMs for required task and tickets. Provided indefinite support to team members in building pipelines, developing PySpark /Scala code in Databricks, creating Power BI reports, creating database stored procedures/triggers/views etc. Developed comprehensive data solutions using Azure Synapse Analytics and Azure Databricks Created KPI Power BI report for Azure DevOps tasks and developed Azure DevOps dashboard using ADO queries. Developed Power BI solutions integrated with Azure services Essex Property Trust Lead BI Data Engineer, Bellevue, Washington Sep 2017 Apr 2021 Served as BI engineer lead and built solutions using MSBI technologies, big data, Power BI Desktop, power apps, and complex DAX solutions. Involved to planning and designing MSBI Technologies, onboarding to Azure, building complex Power BI models using DAX. Developed data models and optimized complex DAX calculations for efficient data analysis. Managed the migration of cubes from legacy servers to a new server, ensuring seamless transition and system integrity. Developed platform assets with long term focus on performance and data growth. Design and implement monitoring solutions, alerts, and automated error-handling processes to maintain data accuracy and ensure system stability. Contributed to all types of transformations that were available in Power BI query editor. Implemented Power BI gateway different source to match analysis criteria and further modeling for Power pivot and Power view. Optimized SQL Server performance through continuous monitoring and tuning. Provided end-user support for Power BI Desktop installation, configured Personal and On-Premises gateways for seamless data connectivity, and managed user access permissions. Used various source to pull data into Power BI such as SQL Server, Azure SQL. Provided technical leadership in data governance and cataloging initiatives, leveraging Microsoft Purview to ensure compliance, data classification, and effective glossary management across the organization. Familiarity with Azure DevOps methodologies, Git version control workflows, and the development of CI/CD pipelines to streamline automation and deployment processes. Managed teams within US and India, tracked work activities, and collaborated directly with customers. Oversaw project risks and communicated with clients or customers. Ensure data governance aligns with company policies and guidelines. Collaborate with Data Analytics and Product leadership to establish best practices and standards for building robust, production-ready analytic pipelines. Implemented copy activity and custom Azure data factory pipeline activities. Introduced Power BI gateway different source to match analysis criteria and further modeling for Power pivot and Power view. Microsoft Lead BI Engineer, Redmond, Washington, Aug 2014 Aug 2017 Involved in planning and designing SSAS tabular cubes. Designed data warehouse and collaborated on building facts and dimensions. Collaborated on Star Schema. Assessed risks and recommended or installed service packs and hot fixes. Implemented copy activity and custom Azure data factory pipeline activities for on-cloud ETL processing. Monitored full, incremental, and daily loads and supported all scheduled ETL jobs for batch processing. Monitored performance of memory, processor, disk I/O, and fine-tuning. Performed security tasks like Grant and Revoke permissions for security tasks. Designed ETL Packages using SSIS (SQL Server Integration Service) technology using data sources and transformation for loading data warehouse. Loaded data pulled from web trends. Created processing job package for cubes which was deployed on to server and scheduling job on monthly and daily basis. Oversaw data ingestion to one or more Azure services, such as Azure data lake, Azure storage, Azure SQL, and Azure DW and processing data in In Azure Databricks. Built and maintained scalable Power BI solutions integrated with ADX/RTI, replicating and enhancing complex reporting functionality. Integrated Power BI with Azure RTI/ADX for real-time visualization and reporting Development, and Azure DevOps, mentoring global teams on best practices for KQL, ADX, RTI, and Power BI Conducted reviews of data source certifications, password management, and API bundling/hosting strategies outside Denodo. Created cubes with star and snowflake schema according to analysis and requirements and mapping dimensions accordingly using SSAS (SQL Server Analysis Service) technology and to create reports in using cubes as source using analysis services according to requirements. Wrote MDX (Multi-Dimensional Expression). Utilized MSSALES hierarchies in terms of geographies, pricing levels, rev sum, product, organization and revenue models. Understood relationship between top parent and tenant mappings. Collaborated on rollover and segmentation changes for reporting needs. Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL and U-SQL Azure Data Lake Analytics. Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in In Azure Databricks. Ensure data governance aligns with company policies and guidelines. Collaborate with Data Analytics and Product leadership to establish best practices and standards for building robust, production-ready analytic pipelines. Conformed dimensions for business needs. Imported data from SQL Server DB and Azure SQL DB to Power BI desktop to generate reports. Extracted transform and load data from sources systems to Azure data storage services using combination of Azure data factory. ALSUM INFOTECH PVT. LTD Business Intelligence Developer, Bangalore, India. Jul 2012 Aug 2014 Interacted with business analysts and stakeholders to gather business requirements. Designed ETL packages using SSIS (SQL Server Integration Service) technology using data sources and transformation for loading data warehouses. Loaded data pulled from web trends. Created processing job packages for cubes, which were deployed to servers and scheduled monthly and daily. Assessed risks and recommended installing service packs or hot fixes. Monitored full, incremental, and daily loads and support scheduled ETL jobs for batch processing. CYBER SPHERE LLC Business Intelligence Developer, Chennai, India. Jun 2010 Jul 2012 Created SSIS packages to import data from different sources into data warehouse. Conducted performance tuning of existing stored procedures. Scheduled packages. Created store procedures and views for reporting purposes. Developed reports using SSRS and Excel services. Wrote reports using SSRS (SQL Server Reporting Service) technology. Developed ETL jobs like data transformation using Microsoft SQL Server Integration services. Contributed to knowledge transfer and documentation of jobs developed and deployed into production. DOTSOLVED INDIA PVT. LTD. System Administrator, Internal Infrastructure Maintenance, Chennai, India. Apr 2007 Jun 2010 Maintained company network, loaded new software, installed new hardware, and maintained network. Installed, configured, managed, and supported Windows XP and 2003 server and Red Hat Linux server and workstation. Implemented Samba services to share files and printing between Linux and Windows system. Configured domain controller, child domain, forest tree and stand-alone server. Provided data backup and data recovery services. Configured NATTING SYSTEM in Windows 2003 server. EDUCATION Bachelor of Computer Science (2007) - ANNAMALAI UNIVERSITY, Tamil Nadu, India. Keywords: continuous integration continuous deployment business intelligence database trade national microsoft mississippi Tennessee Texas