Anu S Email & Phone Number

United Kingdom

• Worked with all levels of business users and stakeholders to gather the requirements.• Design, develop, and maintain ADF, Synapses data pipelines, dataflows to efficiently extract, transform, and load (ETL) data from various sources into client data lake and data warehouse.• Create and manage data models that facilitate efficient storage and retrieval of data, ensuring data quality and consistency. Implemented data governance on user access to the data models.• Created intuitive ETL/ELT parameterized pipelines, Dataflows using ADF various activities.• Implemented Event and Error Handlings, and monitoring and performance of ADF, Synapse optimization strategies to ensure data pipelines, dataflows run smoothly and efficiently.• Create and maintain detailed documentation of data pipelines, models, and procedures for data engineering best practices including data dictionaries, technical & low-level design documents.• Develop MI and BI Reports predominantly for business functions, stakeholders, and SMEs, based on their requirements and expressed needs using Power BI which provides data insights.• Used various Power BI features to create self-service reports, such as Power Query for Data modeling, and DAX to create columns and derive measure values and variables.• Worked on Azure Key Vault to secure credentials and IAM to restrict user access and manage. • Used Azure Key Vault to store securities, and Azure Active Directory to create user groups, and assign permissions to Power BI users, restrict access using RLS, and automated Power BI reports,• Facilitate and enhancement of data sources that would assist organizational performance and guide in effort to optimize and automate processes to collect and utilize data for reporting.

India

• Extensively interacted with Business Users to understand their BI & Data Engineering needs and created requirements documents, conducted reviews of the requirements with Business Users• To address both functional and non-functional business objectives, used Data Factory and T-SQL Procedures to consolidate big, complicated datasets and copy them into Azure SQL databases.• ETL pipelines were automated, which significantly decreased Manual refresh and improved data quality and load efficiency. Used various triggers to automate ADF pipelines.• Designed and developed complex mappings by using various Azure Data Factory activities to transformations to implement complex logics while creating control flow pipelines.• Participated in data modelling, business process analysis and developed ADF ETL and ELT control flow pipelines, mapping dataflows in Data Factory and automated them using triggers.• Created T-SQL queries, complex Stored Procedures, User-defined Functions, designing andimplementing Database Triggers (DDL, DML), Views and designing and implementing Indexes.• Able to comprehend critical business information and numbers in the form of impactful slides using graphs and charts, paginated reports and dashboards using Power BI Desktop.• Scheduled, Deployed and maintained Power BI reports to cloud using Power BI Services, On premises Gateways, Implemented Row Level Security, Object Level Security.

India

• Worked closely with team managers to ensure BI reporting requirements are developed with the most appropriate design of data structures, and Power BI, Tableau.• Design, develop and deliver BI solutions from eliciting and defining stakeholder needs, to delivering solutions, ongoing support and maintenance using Power BI.• Managing and maintaining data sets from a variety of sources, to support all reporting and analysis activities, along with the upkeep of associated processes.• Input into the creation and methods of calculating KPI measures for delivery ensuring that the KPI is driving value back into delivery performance using DAX and MDX, Power Query.• Designed and developed effective dashboard wireframes, with utilization of Tableau, Power BI features slicers, bookmarks, hierarchies, to ensure optimal user experience.• Extensively used Power Query and Mashup functions for data modelling and SSIS for data extractions, used custom invoke functions to add dynamism to the reports.• Used on Power BI services, created workspaces to publish the reports, created content packs and apps to share development work and dataset with users.• Configured on premises gateways to schedule reports and created a user’s group to manage users in power bi services, Created Row Level Security on reports.

India

• Participated in project planning sessions with project managers, business analysts and team members to analyse business requirements and outline the proposed solution.• Generated functional and technical documentation including as-built documents, dashboard design specifications, operating manuals, release notes, and security requirements for reports.• Collects validate, analyses, and organizes data into meaningful reports for management decision making as well as designing, developing, testing, and deploying reports into services.• Debug report on production issues by analysing the data sources and providing quick resolutions and ensure datasets are refreshed up to date in Power BI, SSRS and Tableau.• Created DAX formulas to generate computed columns. Measures and variables in Power BI, also used M Language Functions to create and invoke custom functions.• Created multiple data models and used them as a common data source for reporting purposes. Used Power BI Gateways to keep the dashboards and reports up to date.• Created Insightful and effective BI dashboards, and interactive visuals and charts like bar charts, pie charts, tables and matrix, YTD, YOY, MTD, MOM calculations using DAX functions.• Create and customize simple visualizations, Combination charts, Slicers, Map visualizations, Matrixes and Tables, Scatter charts, Waterfall and funnel charts, Gauges and card visuals.

Bachelor Of Engineering - Be, Computer Science, First Class

Master'S Degree, Distinction