* Developed resilient data pipelines using Python to ingest data into data lake from different sources like Hive, MySQL, APIs (Salesforce, Workday), etc.

* Managed workflows and monitor them via Apache Airflow.

* Built and maintained the data warehouse in PostgreSQL and Snowflake.

* Designed dimensional data models for Sales strategy.

* Designed and built continuous integration and delivery pipelines using Jenkins.

Built ETL data pipeline to load members, providers and claims data from different data sources into the data warehouse in SQL Server.

Designed data models and data schemas for analysis and reporting.

Maintained data warehouse to fit constantly changing business requirements.

Coordinated with analysts to develop and automate reports using SSRS.

Improved report generation speed by 10% via creating periodic snapshot fact table.

 Designed a model to identify the frequent behavior pattern in a bank’s transaction data based on Apriori algorithm. Implemented this model via SPARK.

 Clustered customers based on their behavior pattern and compared with traditional RFM Framework

Collect and collate data of clients.

Help customer manager and provide information he need.