• Designed efficient knowledge graph data ingestion using Neptune, resulting in over 50% annual cost savings.• Utilized Terraform for infrastructure provisioning and implemented an LLM for continuous interaction with the Knowledge Graph as a Q&A service.• Leveraged Kubernetes and Docker for infrastructure enhancements, enabling ML model deployment across clouds and on-prem environments.• Revitalized Airflow-based projects, optimized data volume through MySQL and Elasticsearch queries, and streamlined deployments via Gitlab and Jenkins CI.• Collaborated on Python code development, achieving functional modularity and a 32% increase in efficiency.• Enhanced ETL pipelines for business use, achieving a 30% increase in ingestion and transformation capability with a 70% cost reduction.• Led scoping and development for project sprints, creating Functional Specifications.• Conducted code reviews and E2E testing using GitHub version control, resulting in a 26% increase in code efficiency.• Boosted project delivery and code quality through Engineering documentation.• Mentored Senior Engineers for quick adaptation to the firm’s culture and processes.

• Elevated data ingestion efficiency in databases by 47% through refining T-SQL procedures, functions, and cursors.• Optimized the retrieval process for funnel data from Oracle, utilizing functions with open query to streamline ETL jobs.• Developed ETL jobs via SSIS for data cleansing, loading over 700 GB of funnel data into the Snowflake data warehouse.• Guided data migration to a Cloudera Hadoop cluster via Hive and Sqoop, resulting in a 30% increase in execution speed.

• Amplified data warehouse productivity by 42% through dimensional modeling and effective data management in Snowflake.• Integrated slowly changing dimensions and fine-tuned data warehouse performance for 57 million rows.• Collaborated with cross-functional teams to design/update 200+ database schemas as per business requirements.• Automated weekly reports with T-SQL and Unix shell scripting, reducing delivery time by 70%.• Optimized procedures, functions, and triggers in SQL Server to reduce person-hours by 67%