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

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.
Developed ADF pipelines performing data cleaning, event enrichment, data aggregation, de-normalization, and data preparation needed for machine learning and reporting teams.
Developed new data integration and supported existing datasets for Data Science teams.
Created ADF and Synapse pipelines and scheduled pipelines using triggers.
Used Azure Key Vault to store secure keys and passwords.
Used 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.
Built logical and physical data models, Star and Snowflake schemas, and prepared test cases for existing and new solutions.
Implemented complex business logic with User-Defined-Functions, Index Views, user-defined data type, clustered indexes, and non-clustered indexes.
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.
Researched, analyzed, and leveraged data from internal and external sources to generate comprehensive reports using Power BI, Power Query, and DAX.

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

Gathered business requirements, definition and design of BI reports, data quality analysis, working with the data warehouse architect and functional users.
Developed and maintained business intelligence models to generate standard and ad-hoc reports using Power BI, Tableau, and SSMS.
Created storytelling dashboards in Power BI for data reporting.
Extracted, interpreted, and analysed data to identify key metrics and provide actionable insights.
Developed and maintained complex Power BI reports for stakeholder and functional users across various teams.
Scheduled reports using gateways and maintained users and permissions in Power BI services.
Implemented RLS and Incremental refresh.
Provided training to users.
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.
Migrated SSRS and Excel reports into Power BI using DAX, Power Query, MDX, Bookmarks, Actions, Slicers, and hierarchies.
Assigned permissions to users to access Power BI reports within Power BI services.