Yajith Vishwa

Built and automated over 30+ ELT SCD Type 1, 2, 3 data pipeline to transfer data from OLTP Databases (SQL Server, MySQL and Postgres) to OLAP Databases (Snowflake, Databricks Delta Tables and Google Big Query), utilizing medallion architecture to incrementally cleanse, enrich, and aggregate data. Delivered high-quality, business-ready SQL view for critical reporting, ensuring accuracy and reliability for stakeholders. Collaborated with business users to align data outputs with reporting and analytics needs. Developed Snowpark based Snowflake Store Procedure to transform and curate data to further layers. Developed a Python custom module for performing CRUD operations using the Microsoft Web REST API Client to automate Dynamics CRM Databricks ETL jobs, replacing Kingswaysoft SSIS components previously hosted on Azure Data Factory. Successfully migrated these ADF ETL Pipeline to Databricks, achieving a cost savings of $2,000 per month. Automated the CI/CD-based deployment of Databricks IPython Notebooks through Databricks REST APIs, enabling zero manual efforts on deploying over 500+ ETL jobs and boosting operational efficiency in Azure Devops. Also Created JAMS Scheduling Workflow F

Collaborated on the development of a REST API for Web and Mobile Applications, enabling seamless communication with MongoDB using Python Flask Library. Implemented robust features such as error handling and logging mechanisms across all endpoints. Successfully delivered a comprehensive Web (Staff Admin Portal) and Mobile (Students Exam App) Application tailored for visually challenged students, facilitating exam attendance through innovative features like Text-to-Speech and Speech-to-Text functionalities.

Office Bearer: General Secretary (IOT & Alumni Club)

Achievement: 2nd Place in Zero Power Computing Presentation National level