Sheetal Golecha

• Currently working in the education sector for data profiling. My major role involves analyzing requirements, creating pipelines, and generating final reports for partners using Looker. The architecture comprises DBT, Airflow, Scala, and Databricks.
• Optimized the existing pipeline to calculate the daily users and monthly users on the coursera platform.
• Improved the partner dashboard by reducing the time to load the dashboard to milli second, and also changed visualisation and metric so that partner can understand the progress
• Cultivated interpersonal skills by building positive relationships with others.
• Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.

• Worked in the Maps content Processing team which is responsible for manual editing of Maps.
• DeltaLake:
• Worked on moving the data from the traditional databases to cloud technology. To do this we have used Azure platform and tools like Databricks, Azure Storage, DataFactory and Kafka Bridge.
• Set up a cataloging mechanism on the lake house architecture to make it easy to provide access and search to users.
• Working on Spatial Indexing to improve the search capability on geospatial data.
• Learned and adapted quickly to new technology and software applications.
• Cost Saving Task:
• Worked on reducing the cost on Databricks cluster by improving the Process:

- Worked with clusters to identify the best configuration of cluster to use for what purpose.

- Optimised the query and partition of tables to reduce processing time and cluster size

• Worked as Support Engineer for the product GLOSS (Global Settlement System) which played a key role in post trade processing.
• Wrote complex SQL Queries and created daily reports for users.
• Analyzed proposed technical solutions based on customer requirements.
• Coordinated with Singapore Exchange for BCP Testing and successfully completed the same.

• Developed a process to automate the testing phase for the product Gloss; created Jar files which helped in feeding the test trades in system.
• - Created Con files for the product to store data, which helped to remove all the unnecessary Data files and helped in smooth release; worked on Python Script during the project.

• Worked as Back-end Developer for the tool ITSME and developed the tool as per ITIL V3 Framework.
• Created and Maintained the Defect Tracker databased from scratch
• Certified as an Oracle SQL Database Expert.
• Participated in software field testing to verify performance of developed projects.
• Collaborated on stages of systems development lifecycle from requirement gathering to production releases.