Sahith

• Work with management, stakeholders for strategic planning & analysis staff, and end-users to create and manage complex workflow rules, data validation, and Data Management.
• Developed ADF pipelines performing data cleaning, event enrichment, data aggregation, de-normalization and data preparation needed for machine learning and reporting teams.
• Developing new data integration and supporting existing datasets for Data Science teams. Creating ADF and Synapse pipelines and scheduled pipelines using triggers.
• Used Azure Key vault to store all secure keys and passwords, Active Directory for User access.
• Formulated and documented ETL process design based on requirements and system specifications including source to target mappings, data dictionaries and formats.
• Involved in the logical and physical data models building, Star & Snowflake Schemas and prepared test cases for existing solution and new solutions to meet requirements.
• Implemented Complex business logic with User-Defined-Functions, Index Views and created User defined Data type, Clustered and Non-clustered Indexes.
• Implemented and developed new reporting solution to allow operations and financial users to have access to Power BI reports and dashboards, used DAX, Power Query.
• Research, analyze and leverage data from a wide range of internal and external sources to generate comprehensive reports using Power BI, Power Query, DAX.
Environment: ADF, Synapses, Azure SQL DB, Data Lake, DevOps, CI CD, SQL Server, Power BI

<p>Worked with management, stakeholders for strategic planning and analysis staff, and end-users to create and manage complex workflow rules, data validation, and data management.<br>
Developed ADF pipelines performing data cleaning, event enrichment, data aggregation, de-normalization, and data preparation needed for machine learning and reporting teams.<br>
Developed new data integration and supported existing datasets for Data Science teams.<br>
Created ADF and Synapse pipelines and scheduled pipelines using triggers.<br>
Used Azure Key Vault to store secure keys and passwords.<br>
Used Active Directory for user access.<br>
Formulated and documented ETL process design based on requirements and system specifications including source-to-target mappings, data dictionaries, and formats.<br>
Built logical and physical data models, Star and Snowflake schemas, and prepared test cases for existing and new solutions.<br>
Implemented complex business logic with User-Defined-Functions, Index Views, user-defined data type, clustered indexes, and non-clustered indexes.<br>
Implemented and developed a new reporting solution to allow operations and financial users to have access to Power BI reports and dashboards using DAX and Power Query.<br>
Researched, analyzed, and leveraged data from internal and external sources to generate comprehensive reports using Power BI, Power Query, and DAX.</p>

<p>Interacted with stakeholders and business users to gather and analyse requirements.<br>
Developed and maintained metadata-driven pipelines and built new integrations to support increasing data volume and complexity using ADF and Custom SQL.<br>
Improved data quality, reliability, and efficiency of the individual components and the complete database system using pipelines created with ADF.<br>
Implemented event handling to ensure data quality and set error handling and email notifications.<br>
Developed storytelling dashboards using Power BI and Tableau using DAX, Power Query, Parameters, Filters, Visuals, and Maps.<br>
Created and maintained data visualizations that educated, informed, and engaged business partners on key metrics and performance measures using Power BI.<br>
Analyzed data sets collected over time to identify relevant patterns and trends, producing Power BI visual reports for presentation to appropriate personnel.<br>
Worked on cleaning and reshaping the data through Power Query using merge queries, adding new column, and other transformations like text and number.<br>
Designed, developed, and maintained BI models to generate standard and ad-hoc reports using Power BI, DAX, Power Query, and Slicers.<br>
Published reports into services and created schedules and RLS to restrict users.</p>

<p>Gathered business requirements, definition and design of BI reports, data quality analysis, working with the data warehouse architect and functional users.<br>
Developed and maintained business intelligence models to generate standard and ad-hoc reports using Power BI, Tableau, and SSMS.<br>
Created storytelling dashboards in Power BI for data reporting.<br>
Extracted, interpreted, and analysed data to identify key metrics and provide actionable insights.<br>
Developed and maintained complex Power BI reports for stakeholder and functional users across various teams.<br>
Scheduled reports using gateways and maintained users and permissions in Power BI services.<br>
Implemented RLS and Incremental refresh.<br>
Provided training to users.<br>
Used Power BI features like DAX Studio, Power Query, M Language, Custom Invoke functions, DAX, Slicers, Bookmarks, Hierarchies, and Interactions to create self-service reporting reports.<br>
Migrated SSRS and Excel reports into Power BI using DAX, Power Query, MDX, Bookmarks, Actions, Slicers, and hierarchies.<br>
Assigned permissions to users to access Power BI reports within Power BI services.</p>