Summary
Overview
Work History
Education
Skills
Websites
Certifications And Achievements
Technical Skills
Timeline
Generic

ASHWITA GAJARE

Mumbai

Summary

Results-driven Data Engineer with expertise in Snowflake and AWS at KFin Technologies Pvt. Ltd. Achieved 50% cost reduction through optimized data pipelines and enhanced transaction processing efficiency. Skilled in ETL development and data modeling, while fostering collaboration with stakeholders to deliver impactful analytics solutions.

Overview

4
4
years of professional experience

Work History

Data Engineer

KFin Technologies Pvt. Ltd.
02.2023 - Current
  • Snowflake Integration with AWS Data Lake (Client: 360 One WAM)
  • Designed and implemented data ingestion pipelines from AWS S3 to Snowflake, optimizing for minimal cost and high throughput.
  • Automated daily workflows using SnowSQL tasks and stored procedures, improving efficiency and reducing manual interventions.
  • Optimized Snowflake compute/storage usage, achieving 50% cost reduction by fine-tuning queries and warehouse sizing.
  • Improved transaction processing pipelines, delivering an 80% reduction in processing time for large datasets.
  • Contributed to data modeling and KPI design, enabling 10× faster portfolio analysis and real-time reporting.
  • ETL Pipeline for Master Data Management (MDM) using AWS
  • Migrated on-premise data to AWS using Change Data Capture (CDC) with DMS.
  • Developed incremental ETL logic in Glue/PySpark to build mirror datasets for MDM, reducing processing costs.
  • Built audit and reconciliation framework to validate mirrored data and implemented real-time alerts for discrepancies.
  • Orchestrated workflows with Step Functions, Lambda, EventBridge, and Secrets Manager for robust end-to-end automation.
  • Analytical Reporting & Data Mart Design
  • Designed data marts and KPIs in Snowflake to support wealth management analytics.
  • Wrote advanced SQL procedures/functions (e.g., XIRR, Benchmark Returns) that processed GBs of data with sub-second response times.
  • Structured data pipelines to enable real-time dashboarding and client-ready analytics reports.
  • Client Reporting & Power BI Dashboards on Audit Framework
  • Created Power BI dashboards directly on top of migrated data outputs and ETL Jobs to provide client-facing transparency into data quality and accuracy.
  • Designed validation reports highlighting discrepancies, ensuring quick resolution and building client trust.
  • Automated data refresh cycles (daily, weekly, monthly) with built-in validation layers, ensuring reporting accuracy across periods.
  • Empowered business stakeholders with self-service dashboards to track reconciliation, reducing dependency on manual reports.

Software Analyst Intern

Coffee Chat Pvt. Ltd.
12.2021 - 06.2022
  • Web Development & UI Enhancement
  • Developed and maintained responsive web pages using Bootstrap, improving page load speed and accessibility for internal users.
  • Designed interactive UI wireframes in Adobe XD, streamlining the design approval process and reducing rework.
  • Data Collection & Operational Analysis
  • Built and maintained data collection scripts for internal projects, ensuring accurate and timely data for analytics.
  • Collaborated with business teams to analyze operational workflows and propose improvements that led to smoother feature rollouts.

Education

Master of Computer Applications (MCA) -

Veermata Jijabai Technological Institute
Mumbai, Maharashtra
01.2023

Bachelor of Information Technology (B.Sc. IT) -

Sophia College (Autonomous)
Mumbai, Maharashtra
01.2019

Skills

  • Snowflake
  • AWS
  • Glue
  • Lambda
  • Step Functions
  • Athena
  • S3
  • DMS
  • Data Lakes
  • SQL
  • Oracle
  • PostgreSQL
  • MySQL
  • Python
  • PySpark
  • Scala
  • ETL Development
  • Data Modeling
  • Data Reconciliation
  • Query Optimization
  • Power BI
  • Figma
  • Git
  • Adobe XD

Websites

Certifications And Achievements

  • Certification, Data Analytics with Python (NPTEL)
  • Awards, Rookie Rockstar (KFin Technologies)
  • Awards, Silver Medal in Athletics & Carrom (Sophia College)

Technical Skills

Snowflake, AWS (Glue, Lambda, Step Functions, Athena, S3, DMS), Data Lakes, SQL (Oracle, PostgreSQL, MySQL), Python, PySpark, Scala, ETL Development, Data Modeling, Data Reconciliation, Query Optimization, Power BI, Figma, Git, Adobe XD

Timeline

Data Engineer

KFin Technologies Pvt. Ltd.
02.2023 - Current

Software Analyst Intern

Coffee Chat Pvt. Ltd.
12.2021 - 06.2022

Master of Computer Applications (MCA) -

Veermata Jijabai Technological Institute

Bachelor of Information Technology (B.Sc. IT) -

Sophia College (Autonomous)

Similar Profiles

CREATE PROFILE
ASHWITA GAJARE