Rishitha

Junior BI and Data Engineer with 3 years of experience in managing data repositories for effective visualization for a range of products, designing data-intensive pipelines using ADF, Power BI, SQL Server, DataLake, addressing challenging architecture and scalability concerns. Team player with the capacity to prioritise needs and risks and good analytical abilities. constantly looking for ways to make processes more efficient while experimenting with various optimization and evaluation techniques. Problem-solver who is inventive and enjoys challenges.

Coordinating with the BA and stakeholder for preparing and gathering business requirement and technical specifications for the requirements/change requests.
Implemented ADF Pipeline using activities like Copy, lookup, stored Procs, for each, IF, Data bricks, Get Meta data, Web, switch, wait, Validation, Execute SSIS Package in Azure and built robust pipelines and dataflows.
Debugging the pipelines errors and making sure pipeline runs successfully in development environment and create ARM templates to move from dev to test.
Managed the design, structuring, and maintenance of the targeted systems and support production project.
Worked on ADF pipelines and Power BI reports.
Reviewing and ensuring the data integrity, quality and monitoring the associated ADF and Synapse pipelines.
Ensured pipelines are not duplicating the data in DWH.
Worked on SQL Server to implement Stored Procedures, Functions, Indexes, Constraints, CTE's and Subqueries, Star and Snowflake schemas.
Developed a thorough understanding of business objectives and issues, interpret business needs into data and analytical requirements, deliver valuable insights to stakeholders using Power BI self-service dashboards and reports.
Conducted user training sessions to educate non-technical user to ensure make use of Power BI reports effectively for their data and business analysis.
Used Power BI Services to publish the reports, share the reports with users, and automated reports using Gateways, created incremental refresh on datasets.

Worked closely with team managers to ensure BI reporting requirements are developed with the most appropriate design of data structures, and Power BI.
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 process.
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.
Designed and develop effective dashboard wireframes, with utilisation of Power BI features slicers, bookmarks, hierarchies, to ensure optimal user experience.
Extensively used Alteryx and Power Query functions for data modelling and 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 users’ group to manage users in power bi services.
Created Row Level Security on reports.

Worked with nontechnical stakeholder to design, developed and implement a BI solution for various departments.
Ensured gathered requirement all users.
Collaborated with support team to assist client stakeholders with emergent technical issues and develop effective BI solutions using Power BI and Tableau.
Extensively involved in building the dashboards such as creating data connection, refreshing, layout designing, interaction, functions, dashboard, report formatting.
Created organized, customized analysis and visualized projects and dashboards to present to executive leadership and external stakeholders.
Created paginated reports and dashboards, created advanced charts and complex calculations using DAX to manipulate the data to derive the required metrics.
Scheduled refresh on daily basis using Parameters.
Created visual presentations of categories and relationships, using Power BI dashboards to highlight desired aspects of key financial performance.
Implemented Row Level Security.