Rishabh Jaiswal Email & Phone Number

Navi Mumbai, Maharashtra, India

• Led design and implementation of KPI dashboards using Power BI, Microsoft Fabric, SQL (Query, SSRS, SSIS), Tableau, and Excel, integrating data from Snowflake, AWS, Azure Data Lake, and Redshift to generate actionable insights and enhance team performance.• Engineered and optimized data architectures, ETL pipelines, and complex queries to transform intricate datasets into dynamic dashboards, improving reporting efficiency and supporting informed decision making.•… Show more • Led design and implementation of KPI dashboards using Power BI, Microsoft Fabric, SQL (Query, SSRS, SSIS), Tableau, and Excel, integrating data from Snowflake, AWS, Azure Data Lake, and Redshift to generate actionable insights and enhance team performance.• Engineered and optimized data architectures, ETL pipelines, and complex queries to transform intricate datasets into dynamic dashboards, improving reporting efficiency and supporting informed decision making.• Collaborated with cross-functional stakeholders to translate business requirements into strategic insights, enhancing reporting solutions and dashboards through advanced Data Architecture methodologies.• Developed customized reporting solutions to meet evolving business needs, ensuring dashboards deliver accurate, real-time insights aligned with organizational objectives.• Ensured data integrity and security by managing data refresh schedules, implementing Row-Level Security (RLS), and using GitLab for version control and Asana for project management, while integrating AWS S3 for data storage and utilizing CI/CD pipelines for efficient deployments. Show less

Mumbai, Maharashtra, India

• Spearheaded DTDC's GPS project for 1,400 vehicles, managing vendor relationships and regional requirements. Leveraged Power BI, Microsoft Fabric, Tableau, SQL (Query, SSRS, SSIS), and Azure Synapse to create dynamic dashboards and insightful reports.• Monitored performance using GPS portal and trip sheet data for accurate tracking of repair metrics. Implemented ETL processes, Data Modeling, and CI/CD pipelines using Azure Data Lake, Snowflake, AWS, and Redshift to derive… Show more • Spearheaded DTDC's GPS project for 1,400 vehicles, managing vendor relationships and regional requirements. Leveraged Power BI, Microsoft Fabric, Tableau, SQL (Query, SSRS, SSIS), and Azure Synapse to create dynamic dashboards and insightful reports.• Monitored performance using GPS portal and trip sheet data for accurate tracking of repair metrics. Implemented ETL processes, Data Modeling, and CI/CD pipelines using Azure Data Lake, Snowflake, AWS, and Redshift to derive actionable insights from complex datasets.• Collaborated with cross-functional stakeholders to enhance dashboards, translating raw data into strategic insights through advanced Data Architecture methodologies with PostgreSQL and DBT.• Analyzed route failures and turnaround times (TAT) to identify operational issues and support Accounts, Operations, and Fleet teams in optimizing performance.• Ensured data integrity and security by managing data refresh schedules, implementing Row-Level Security (RLS), and utilizing GitLab for version control, while applying advanced analytics with Python and Advanced Excel to enhance data-driven insights and organizational agility. Show less

Mumbai, Maharashtra, India

• Enhanced outlet operations by utilizing Power BI, SQL, and Excel to analyze data, driving improvements in customer satisfaction and operational efficiency through strategic initiatives.• Achieved cost savings and met service-level agreements (SLAs) by leveraging historical sales data for effective demand planning and dynamic forecasting.• Managed inventory through rigorous audits and root cause analyses, developing precise raw material forecasts by applying ETL processes… Show more • Enhanced outlet operations by utilizing Power BI, SQL, and Excel to analyze data, driving improvements in customer satisfaction and operational efficiency through strategic initiatives.• Achieved cost savings and met service-level agreements (SLAs) by leveraging historical sales data for effective demand planning and dynamic forecasting.• Managed inventory through rigorous audits and root cause analyses, developing precise raw material forecasts by applying ETL processes and advanced data manipulation techniques.• Generated operational insights using Power BI, SQL, and Google Sheets, creating interactive dashboards and customer-centric procedures to optimize overall efficiency.• Collaborated with stakeholders to refine dashboards, translating complex data into actionable insights that enhance decision-making and boost operational performance. Show less

Aurangabad, Maharashtra, India

• Optimized procurement processes using SAP (MM) for material administration and demand planning, creating real-time dashboards in Power BI and Excel to enhance data accessibility and responsiveness.• Developed comprehensive dashboards for tracking inventory, purchase orders, and supply chain metrics, improving data visibility and facilitating informed decision-making.• Generated packing lists to efficiently reconcile material dispatch and ensure accurate project closures… Show more • Optimized procurement processes using SAP (MM) for material administration and demand planning, creating real-time dashboards in Power BI and Excel to enhance data accessibility and responsiveness.• Developed comprehensive dashboards for tracking inventory, purchase orders, and supply chain metrics, improving data visibility and facilitating informed decision-making.• Generated packing lists to efficiently reconcile material dispatch and ensure accurate project closures, contributing to streamlined operations.• Streamlined inventory management by scheduling raw materials and conducting precise inbound and outbound checks, enhancing overall operational efficiency.• Collaborated with cross-functional stakeholders to gather data and refine dashboards, translating complex data into actionable insights that improve procurement efficiency and drive strategic initiatives. Show less

Aurangabad, Maharashtra, India