Ms Swathi Garudasu

Swathi Garudasu is a highly experienced Data Engineer and Analytics professional with extensive expertise in big data analytics, ETL solutions, and cloud-based data platforms. Currently serving as a Senior Lead Analytics Engineer at ADP, she has a strong background in data engineering, business intelligence, and cloud technologies. Swathi has worked extensively with Azure Data Bricks, Azure Data Lake, Azure Blob Storage, and Azure SQL, utilizing tools like Spark SQL, Python, Scala, and R for data processing and predictive modeling. She has a proven track record of developing robust ETL solutions for OLTP, OLAP, and ODS systems, optimizing data transformation processes, and enhancing data accessibility for analytics and reporting. Before joining ADP, she held senior positions at Charles River Laboratories and Microsoft, where she played a critical role in migrating Power BI reports to live connections, implementing row-level security, building complex DAX measures, optimizing data quality rules, and orchestrating Azure Data Factory (ADF) pipelines to automate ETL processes. Swathi also has deep experience with Microsoft SQL Server, business intelligence tools like Power BI, and various reporting solutions, having developed complex reports using SSRS and Power BI with OLTP and OLAP databases. Her tenure at People Tech Group and HCL Technologies further solidified her expertise in database design, T-SQL, stored procedures, performance tuning, database migration, and ETL package development using SSIS and Azure Data Factory. With a strong foundation in data modeling and administration, she has worked on designing and developing OLAP cubes, implementing data governance strategies, and leveraging SQL Server Profiler for query optimization. Additionally, she has experience with Google Analytics 4 for web activity analysis, Power Apps integration with Power BI, and developing CI/CD pipelines for analytics solutions. She holds a Bachelor of Science in Computer Science from St. Francis College for Women and has further honed her technical skills through certifications, including Tableau Essential Training. Swathi has been recognized as a judge for the Globee Awards for Women in Business, showcasing her leadership and contributions to the tech industry. Her expertise in cloud computing, big data, and analytics, combined with her hands-on experience in database management and business intelligence, makes her a highly skilled professional in the field of data engineering. Experience in handling Development projects and Production Support Projects & working in Agile Environment Experience working with Azure Data Bricks to pull data from different sources like Azure Blob storage, Azure Data Lake using Scala, Processed data using Spark SQL, Python, R (Predictive models) and load it to Azure SQL/Azure Datawarehouse/Azure Data Lake/Azure Storage. Worked with Microsoft SQL, Business Intelligence and dealt with various development and administrative activities. Experience in Developing Robust ETL Solutions which are used for developing/maintenance of OLTP, OLAP and ODS Data Solutions. Experience in Writing Scope Scripts for loading the data from COSMOS Server to Relational Database for use in Reporting Experience in working with PowerBI for creating PowerBI reports and dashboards which present data from Relational or Tabular Models

• python
• SPARK SQL
• Cosmos DB
• Power BI
• SSIS
• Big Data Analytics
• Microsoft SQL Server
• Business Intelligence
• Predictive Modeling
• Data modeling
• R language
• Scala
• Relational Databases
• Performance Tuning
• Database Migration
• cloud technologies
• SQL Server Analysis Services (SSAS)
• Azure Data Lake
• Data engineering
• ETL solutions
• Azure Data Bricks
• Azure Blob Storage
• Azure SQL
• Predictive modeling
• OLTP systems
• OLAP systems
• ODS systems
• Data transformation
• Data accessibility
• Row-level security
• DAX measures
• Data quality rules
• Azure Data Factory
• SSRS reports
• T-SQL
• Stored procedures
• OLAP cubes
• Data governance
• SQL Server Profiler
• Google Analytics 4
• Power Apps integration
• CI/CD pipelines
• Agile environment
• Reporting dashboards
View More >>