Shubhra Awasthi

Senior Data Engineer with expertise in Tableau and data visualization. Developed impactful dashboards that optimize performance and enhance decision-making. Proficient in SQL and experienced in collaborating with cross-functional teams to deliver actionable insights. Focused on leveraging data to drive strategic growth and operational efficiency.

• Python, SQL and Tableau Integration
• SQL Advance

• Earned appreciation from global clients for consistently meeting project deadlines with exceptional quality.
• Given seminar on 'BUSINESS INTELLIGENCE' technology and 'DATA TRANSFER TECHNOLOGY USING HANDSHAKE' in university of Kota.
• Got appreciation and award for good project during BCA and internship.
• Attended multiple IT workshops like Robotics technology, hacking techniques.

• Business Analysis
• Travelling & Exploring Places
• Singing & listening music

• Onsemi is a semiconductor manufacturing company; in this project, I have migrated the NPD, QBR, sales, and HR dashboards from Qlik to Tableau
• Loreal - In this project, I created miscellaneous reports based on different datasets and business requirements, such as dashboards on their beauty quizzes data, using Tableau 2023.1 and Databricks
• AAMC (Association of American Medical Colleges) - In this project, I created HR dashboards using Tableau and Databricks.
• WOW MOMO's - Food and Beverages Industry-based project covered sales, purchase, production, and inventory dashboards using Tableau 2020.2, Microsoft Dynamics 365 ERP, and MS SQL Server
  
• SIPL- In this Project, created Miscellaneous Reports based on different modules like sale, Finance, leasing etc. using Tableau2020.1, SAP Bone ERP, MS SQL server.
  
• DRISHYAM- This Project is done at Minda Industries Limited. Project based on BI Data Analytics & Business Dashboards Using BI Tool- Tableau 2018.2, ERP-SAP, SAP BW, Database-HANA.

• Company: LTIMINDTREE PRIVATE LIMITED

      Client: ONSEMI

      Role: Senior Data Engineer

      Software/Tool: Tableau Desktop 2023.1, Snowflake, Tableau Online,

Project Brief: This is a migration project. In the first phase, PRB performance dashboards were migrated from Qlik to Tableau, and the PRB Finance Performance dashboard is designed to track the financial results of NPD projects in comparison to their PRB commitments. Projects that have passed the First Part Release (FPR) are shown in the first section of the report, while projects that have not yet been released appear on the last page The report provides detailed information about these projects, and includes a graph indicating which projects have met their commitments, and which have not. Users with margin access can also view margin performance at the project level In the second phase, 10 to 12 Qlik dashboards were migrated to Tableau These dashboards span various domains and cater to different stakeholders, incorporating enhancements related to areas such as NPD and NPD maturity Since Onsemi is a semiconductor and parts manufacturing company, many of the dashboards are focused on part releases, new manufacturing processes, and inventory-related reports.

• Company: LTIMINDTREE PRIVATE LIMITED
  Client: LOREAL
  Role: Senior Data Engineer
  Software/Tool: Tableau Desktop 2022.4, Databricks, Tableau Online
  Project Brief:
  This project involves extensive upgrade and development activities along with support for the existing system. As Loreal is a Cosmetic company and it organize different beauty quizzes. From Beauty Quizzes They want to Analyze their Rich data part (Which includes beauty attributes and their responses). Mainly I worked on Rich data Dashboard Development and supported other Tableau reports and Dashboard for USA(Loreal) region.
  This project started with modifications and change requests in the existing Tableau reports, and the development of a Rich Data Dashboard The rich data dashboard is designed to help clients understand what rich data they have, what types are more valuable, and how to acquire more It can be used in development and production segments, targeting and personalizing strategies for their campaigns.
• Company: LTIMINDTREE PRIVATE LIMITED
  Client: AAMC (Association of American Medical Colleges)
  Role: Senior Data Engineer
  Software/Tool: Tableau Desktop, Databricks, Tableau Online
  Project Brief:
  This project started with modifications and change requests in existing Tableau reports. These reports/dashboards provided a detailed insight and enabled them with key information on their compensations and relatable statistics. This project despite being an upgrade/migration project involved rigorous discussions and detailed analysis to be able to derive a structure for this complete project.
• Company: Uneecops business solution Pvt. Ltd.
  Client: WOW MOMO’s
  Role: Junior Consultant
  Software/Tool: Tableau Desktop 2020.2, ERP- Microsoft Dynamic 365, Tableau server 2020.2
  Project Brief:
  This is Food & beverages industry-based project. This project is focused on development and analysis of Sales, Inventory, Production and Finance related dashboards with meaningful insights, which will enable business to have a deeper and stronger analysis for smooth functioning based on data trends. This project is about providing different verticals and stakeholders, senior management with relevant information to take more accurate and precise decisions.
• Company: Uneecops business solution Pvt. Ltd.
  Client: Select City Walk (Upgrade and Migration Project)
  Role: Junior Consultant
  Software/Tool: Tableau Desktop 2018.2, ERP- SAP B-one, Tableau server 2108.2
  Project Brief:
  This project involves extensive upgrade and development activities along with support for the existing system. This project started with server upgrade to latest version, i.e., 2020.1. Post this activity several dashboards were developed on Marketing & Customer Care, Sales Analysis, Leasing and Finance in which direct and indirect stakeholders were not able to perform several day-to-day activities. These dashboards provided a detailed insight and enabled them with key information on their revenue and Business strategy. This project, despite being an upgrade/migration project involved rigorous discussions and detailed analysis to be able to derive a structure for this complete project.
• Company: Uneecops business solution Pvt. Ltd.
  Client: Uneecops (Internal Project-TSBO)
  Role: Junior Consultant
  Software/Tool: Tableau Desktop 2018.2, ERP- SAP B-one, Tableau server 2108.2
  Project Brief:
  This Project was a part of standard Tableau based package for clients having SAP B-one ERP for different modules like Sales, Purchase, Finance, Marketing and Project Management Dashboards with meaningful insights. This project is about ready to deploy package directly connected with SAP B-one ERP and used SQL Server to fetch data by integrating with tableau. This package includes dashboards for all essential verticals, stakeholders and senior management to enable them with correct and precise data real-time to make effective decisions, business strategy and business development.
• Company: Uneecops business solution Pvt. Ltd.
  Client: Jamna Auto Industries Ltd.
  Role: Junior Consultant
  Software/Tool: Tableau Desktop 2018.2, MS Excel, Tableau server 2108.2
  Project Brief:
  Jamna Auto Industries Limited was the largest manufacturer of Tapered Leaf and Parabolic Springs for Commercial Vehicles (CVs) in India. This project was focused on financial analysis of company. There were lots of KPIs base on which different MIS reports were developed for Commercial Vehicles. One of the KPI being comparison in expense value against estimated target amount. So helping them in figure out CAPEX, Value Added and Sales integrated analysis.
• Company: UNO MINDA Pvt. Ltd.
  Project Name: DRISHYAM
  Role: Intern
  Software/Tool: Tableau Desktop 2018.2, ERP- SAP BW, Database-SAP HANA, Tableau server 2108.2
  Project Brief:
  This was an internal project based on BI Data Analytics & Business Dashboards using Tableau (BI Tool), SAP BW (ERP), SAP HANA. As a part of this project, the main responsibility allocated were to develop dashboards for various objects based on business requirement, couple of them being supplier performance and energy consumption. These dashboards were required by varied department for analyzing consumption/performance patterns and to work towards better strategy and decision.