Gathered the requirements and articulated them into deliverables business and technical-specific documents with the help of various diagrams, workflows, artifacts, etc.Involved in Architecting, Design, and developing complex Azure Analysis Services tabular databases and deploying the same in Microsoft Azure and scheduling the cube through Azure functionsInvolved in the design and development of multiple Power BI Dashboards and reports.Archicting, Designing, and developing data marts… Show more Gathered the requirements and articulated them into deliverables business and technical-specific documents with the help of various diagrams, workflows, artifacts, etc.Involved in Architecting, Design, and developing complex Azure Analysis Services tabular databases and deploying the same in Microsoft Azure and scheduling the cube through Azure functionsInvolved in the design and development of multiple Power BI Dashboards and reports.Archicting, Designing, and developing data marts and constantly monitoring the daily schedules and providing data to the ad-hoc requests from the business users.Extensively involved in designing and developing the power BI Data model using multiple DAX expressions to build calculated columns and calculated measures.Developed multiple Azure Data factory pipelines to fetch data from different source systems and push that to the Azure SQL. Show less

Utilize the Electric Vehicle (EV) bike telemetry data from various Electronic Control Units (ECUs) and Transmission Control Units (TCUs) to provide a comprehensive understanding of the bike's performance, efficiency, and operational status and gain valuable insights for proactive maintenance and continuous improvement of electric vehicle systems.Drive the requirement analysis phase to elicit the business requirements and articulate them into deliverables business and technical-specific… Show more Utilize the Electric Vehicle (EV) bike telemetry data from various Electronic Control Units (ECUs) and Transmission Control Units (TCUs) to provide a comprehensive understanding of the bike's performance, efficiency, and operational status and gain valuable insights for proactive maintenance and continuous improvement of electric vehicle systems.Drive the requirement analysis phase to elicit the business requirements and articulate them into deliverables business and technical-specific documents with the help of various diagrams, workflows, artifacts, POCs, etc.Involved in Architecting and developing the Azure data factory pipelines by creating the datasets and source and destination connections to move the data from the SQL database, Flat Files, and 3rd Party APIs to Azure Data Lake Store Raw Zone and Delta Lake.Formulated data models and resilient data pipelines alongside PySpark notebooks to ensure dependable data processing and mitigate data loss risks, thereby supporting both data warehousing and business intelligence objectives.Designed ETL Packages to transfer data from various sources like Text Files, SQL Server, Excel, and 3rd Party APIs to SQL Server, Delta Table, and Synapse.Designed and developed a Data reconciliation framework where data can be validated at different layers of transformation. Show less

Gathered the requirements and articulated them into deliverables business and technical-specific documents with the help of various diagrams, workflows, artifacts, etc.