Surat, Gujarat, India
Data Engineer focused on dimensional modeling (primarily Kimball), translating business needs into production-grade data models for enterprise reporting and analysis. Domain: Pet Health and Wellness Enterprise models for veterinarian services and prescriptions across 300+ hospitals, 2000+ mobile clinics, brick-and-mortar, and online. Background: Previously taught mechanical engineering, grateful for the experience. GATE ME 2011: AIR 298, GATE XE 2020: AIR 33. Tech Stack: SQL, Python, Snowflake, dbt, Airflow, GitLab, Mathematics, Pen and Paper.
Projects Vet Services: Built reporting fact and dimension tables while protecting downstream dependencies. Rx: Build data models to power prescription performance and compliance dashboards. Responsibilities ●.Collaboration: Partnered with stakeholders to translate business goals and product logic into data models. ● Pipelines: Developed custom Python extraction scripts and managed dbt ELT workflows. ● Modeling: Designed raw tables, fact/dimension tables, and database views based on business needs.
Roles and Responsibilities: ● Teaching and preparing learning materials for machine dynamics, solid mechanics, two-dimensional theory of elasticity, and engineering mathematics. ● Created a simple semi-automatic process in spreadsheets to calculate course outcomes and program outcomes.
Roles and Responsibilities: ● Teaching and preparing learning materials for machine dynamics, engineering mathematics, optimization techniques, and one-dimensional finite element methods. ● Assisting students in preparing for the GATE Mechanical Engineering exam.
Roles and Responsibilities: ● Teaching and developing educational resources for gas dynamics. ● Building connections with students and creating a welcoming learning environment.
Roles and Responsibilities: ● Conducting black box testing for data warehousing applications, including merchant point, dashboard, and business object reports. ● Performing white box testing for SQL Server and DB2 stored procedures. ● Testing and debugging ETL SQL Server job chains and data movement processes. ● Developing and maintaining the test environment, including data preparation for build scripts, SQL Server and DB2 objects, data movement, and front-end applications.