Experience

• 

  Mitsuba corporation

  Nov 2014 - Dec 2015

  Graduate engineering trainee

  Served as a plant quality engineer in a self-starting motor production plant, responsiblefor defect monitoring and subsequent analysis at various stages, including line problems,pre-dispatch problems, and warranty claims.

• 

  Wilhelmsen group

  Sept 2016 - Jul 2019

  Pms data analyst

  I handled a large database of ships using SQL Server 2008 R2, with a focus on managing crews and assessing risks. I led projects involving big data on MSSQL Server and improved database performance by optimizing structures and queries. I standardized components for fifty ships in various countries and created specialized DataMarts for ten ships to automate weekly reports. I managed the Planned Maintenance System (PMS), Safety Management System, and other vessel modules to reduce downtime and expenses. I offered technical assistance and troubleshooting for crew and office staff to ensure smooth PMS operations. Show less

• 

  Solverminds solutions & technologies pvt ltd

  Apr 2021 - Apr 2023

  Data analyst

  I oversaw the entire process of developing SQL, from designing queries to testing and deploying them on Azure SQL Database for business intelligence reporting. I created KPI reports and Power BI dashboards tailored to the client's requirements, ensuring that the data was always up-to-date through automated refresh schedules. I fostered collaboration between different teams for data processing and analysis, while also keeping communication open with stakeholders. I documented the IT infrastructure and aided in the development of Snowflake objects, such as tables, file formats, and stages. Show less

• 

  Itvalues

  Sept 2023 - Jan 2024

  Data analyst

  I led the transition from Access to Azure SQL Database using SSMA, made sure the data shift was smooth and compatible. I examined and adjusted Access data structures to work well with SQL, ensuring data integrity. I conducted thorough testing and quickly resolved any issues for CEO approval. I set up and kept real-time data syncing between Access and Azure SQL. I wrote detailed documentation on the migration process, data mapping, and link configurations for future reference and auditing.