Swathi Garudasu

Senior Lead Analytics Engineer

Senior Analytics Engineer

• ● Developed Power Apps utilizing Azure SQL Server as the backend, seamlessly integrated into Power BI Reports to facilitate CRUD operations. ● Conducted in-depth Data Analysis using Google Analytics 4, generating comprehensive Power BI reports with GA4 as the backend, encompassing various metrics related to user web activity. ● Implemented data transformation queries to refine and structure raw data for enhanced insights and reporting accuracy.

Software Engineer II

• ● Enhanced Customer experience by leading projects which involved migrating Power BI Reports from Import Model to Live Connection and implementing Row Level Security ● Built Complex DAX measures to show Inventory Burn down, Moving Average, forecast forward which will help business make informed decisions. ● Optimized transformations and data quality rules based on the rhythm of business and telemetry to enable the faster and accessible data assets for analytics and data science to build models for producing predictions. ● Developed CI-CD Release Pipelines for AAS to publish from Repo. This has helped eliminate Ad-hoc manual deployments by Developers. ● Orchestrated Azure Data Factory (ADF) pipelines to automate the seamless flow of data, ensuring efficient and reliable ETL (Extract, Transform, and Load) processes.

Software Engineer

• ● Created complex reports in SSRS & Power BI with data from OLTP & OLAP databases ● Experience in writing MDX queries & Measures in DAX ● Create pipelines and schedule activities using Azure Data Factory. ● Design and maintain OLTP Databases, write queries using T-SQL, create and manage various database objects like Stored Procedures, Views, Functions, Indexes, Logins, and Triggers etc. ● Expertise in setting up ETL packages using SSIS & Azure Data Factory which fetches data from various sources like OLAP/ODS/SQL to SQL server/Excel/Access/Text file destination using various transformations, for database maintenance Plans. ● Write Kusto (KQL) and Cosmos Queries (SCOPE) and publish the data into Power BI

Technical Lead Engineer

• • Experience in designing database, creating the logical and physical Design of database using tools Erwin data Modeler and Microsoft Visio • Experience in writing queries using T-SQL , create and manage various database objects like Stored Procedures, Views, Functions, Indexes, Logins, Triggers etc. • Experience in Migrating the Database objects , Databases from SQL Server 2000/2005 to 2005/2008 • Experience in Database Administration Activities like Backup and Restore, implementing security, Change data Capture and setting up Linked Server • Experience in scheduling the Rebuilding & Reorganizing of Indexes based on the Index fragmentation percentage. • Experience in using SQL Server Profiler for identifying slow running queries and tuning • Expertise in setting up ETL packages which fetches data from various sources like OLAP/ODS/SQL to SQL server/Excel/Access/Text file destination using various transformations. • Experience in providing Logging, Error handling by using Event Handler and Custom Logging for SSIS Packages. • Experience in Designing and Developing OLAP Cube, Facts & dimensions using Snow flake Schema , Star Schema and scheduling the SSAS Cube Processing using SSIS • Experience in writing and Submitting Scope Scripts to COSMOS Virtual Clusters for data loading which are later transformed, loaded into Database for use in Reports.

SQL Developer

• I have worked for P&G and Internal Projects at Vertex. The Work includes Core Activities like Designing Database Using Erwin Data Modeller Tool/ Viso by reading the Business Requirement Document, Generate Schema and prepare various database objects , Create Technical Specification document,closing the bugs raised by QA, Maintain the database, ensure for data availability, prepare reports using SSRS, and involved in timely release of the application.