Shreyas Goyal

Software Engineer

Tata Consultancy Services Ltd•  November 2020 - Present•  Indore

❖ Translating business requirements into technical specifications by effectively identifying and understanding business processes & transforming them into actionable data models and visuals. ❖ Developing, publishing, and scheduling refresh in Power BI reports across various phases of the project lifecycle, including analysis, design, testing, and implementation. ❖ Utilizing both Power BI desktop and Power BI Service to schedule daily/weekly report refreshes and efficiently sharing reports and dashboards. ❖ Ensuring optimization of reports for performance and scalability, enhancing overall efficiency. ❖ Designing and building efficient data models using Power BI Desktop, including establishing relationships, hierarchies, calculated columns and measures. ❖ Implementing ETL processes using Power Query to extract, transform, load data from sources. ❖ Writing and optimizing complex DAX queries to ensure efficient data retrieval and analysis. ❖ Publishing Power BI reports to the Power BI Service, implementing features like Row Level Security and Incremental Refresh, using bookmarks and navigation. ❖ Implementing drill-down functionalities and user interactions to enable deep data exploration, enhancing user experience. ❖ Leading the specification, design, and implementation of analytics projects, ensuring alignment with team objectives and strategic goals. ❖ Collaborating with data analysts and business users to understand requirements, translating them into technical specifications, and reviewing outputs for accuracy and validity. ❖ Designing automated workflows with triggers, actions, and conditions in Power Automate, automating data refreshes, report generation, and distribution using Power Automate. ❖ Automating data refreshes for Power BI datasets, setting up alerts in Power BI based on data-driven conditions, exporting data from Power BI automatically using Power Automate.