Pratham Yadav

Data Analyst

Tata Consultancy Services•  February 2021 - August 2023

● Communicating with clients to understand the business requirements and present possible business solutions. ● Responsible for creating dashboards using technologies like Azure Data Factory, Azure Databricks, Azure SQL, Power BI, and QlikView. ● Developed interactive data visualizations and dashboards in Power BI and QlikView to track Key Performance Indicators (KPI). ● 2 years and 7 months of experience in Analysis, Design, Development, Testing, and Implementation of Business Intelligence Applications using QlikView and Power BI using agile methodology. ● Knowledge in designing and developing QlikView Dashboards and Power BI Dashboards by extracting data from different sources like SAP, SQL, Infor EAM, and Excel Files. ● Trained peers to develop and use Power BI and QlikView Applications. ● Extensive use of DAX for reports in Power BI Applications. ● Generated Ad hoc reports in Excel and shared them with decision-makers for strategic planning. ● Hands-on experience on MS SQL for generating ad hoc reports and extracting data for BI Dashboards. ● Developed database tables for displaying relevant information using Azure Databricks. ● Increased the efficiency of day-to-day supply chain operations by 10% through the implementation of data-driven insights. ● Delivered Data Analytics Solutions to GlaxoSmithKline (GSK), a global pharmaceutical company, for their Pharma Supply Chain division