Experience

HUMANOO

• Germany
• Wellness and Fitness Services
• 1 - 100 Employee

• Senior Data Engineer

  • Feb 2022 - Present

  Tech Stack: SQL, Python, DBT, Database Migration, Apache Airflow, AWS S3, Redshift, MWAA, Docker, Metabase, Tableau, Git, Google Bigquery, PostgreSQL, Soda, Linux •Monitor and maintain data pipelines. •Improved stability of existing ETLs (from 2-3 incidents per week, to 1-2 per month). •Datawarehouse management and migrations •Migrated all data pipelines from AWS EC2 to MWAA (Amazon Managed Workflows for Apache Airflow).Overall data sync stability improved drastically. •Data visualization with Tableau and Metabase •Data mining in Python •Data analysis and management using SQL •ETL using Airflow, DBT, SQL •Set up infrastructure and build pipelines in Airflow (initial data load, daily incremental updates, etc) + various custom plugins developed for Airflow. Show less



UBS

• Switzerland
• Financial Services
• 700 & Above Employee

• Senior Software Engineer

  • Jan 2019 - 2021

  Tech Stack: SQL, ETL, DB2, Python, AWS, Fintech Knowledge, GitSenior Data Engineer for Compliance & Operational Risk Control (C&ORC).• Develop and automate ETL Processes to Transform and Load the Data from different sources using SQL.• Optimized major parts of ETL process with the extensive usage of PL/SQL.• Complex SQL queries to transform data and generating outward files. • Facilitating input client data for KYC Reviews, Client Risk Rating and Transaction Monitoring for AML functions.• Exposure in Agile and SDLC methodologies and service management tools like JIRA and SNOW.• Data transformation• Data cleaning• Complex SQL Show less

• Senior Software Engineer

  • Jan 2016 - Dec 2018

  • Developing and handling the PL/SQL Packages, Procedures, Tables, Views, Indexes, Synonyms, Triggers, Functions, Materialized Views and Sequences, etc.• Performance tuning of Oracle database scripts in the project.• Create recursive CTEs (an alternative for subqueries which has better readability), temp tables, views to give better data manipulation and data consistency in SQL.• Work with stakeholders / architects / BA for requirements gathering, Design, Development, Unit Testing, Production Deployment.Payroll: Wipro Technologies Show less



Thames Water

• United Kingdom
• Utilities
• 700 & Above Employee

• Software Engineer

  • Jul 2015 - Dec 2015

  Tech Stack: SQL, PL SQL, MS SQL, SSRS, SSIS, Excel, ETL, Unix, Data Analysis•Consulting with clients on migration, project demonstrations, design and requirements gathering.•Worked on designing ETL Jobs.•Worked with clients from Banking and Audit firm involved in all the phases of Desktop Engineering (ITIL) Analysis, preparing SOWs, Application Packaging, Testing and Deployment of Desktop applications.•Worked as a Technical Module lead and guided the team on various technical issues. Show less

• Software Engineer

  • 2013 - Jun 2015

  •Developed application code and modules for business and technical requirements using Oracle SQL, PLSQL, and Unix Shell scripting.• Extracted data by exploring DW tables using SQL and, cleaned and transformed data for reporting and automation.•Analysed and monitored the daily batches suggested improvements and changes.•Migrating data set of Oracle 9i database to MS SQL database for Laboratory Information Management Systems.•Handling stakeholder requests and managing metering and data expectations to downstream services.Payroll: Wipro Technologies. Show less