Dillip K. Email & Phone Number

Bengaluru, Ka, In

Bangalore Urban, Karnataka, India

Expertise on pyspark/dbt/snowflake/SQL/plsql/airflow/aibyte/databricks/power bimanaging production and dev environment (hybrid) :GCP:Led the design and implementation of a Data Lake using Google Cloud Storage.Architected and deployed a Cloud SQL database with GCP Secrets management for secure configuration.Managed the setup and scaling of a Data Warehouse on Google BigQuery.Supervised Big Data processing using GCP Dataproc and developed ETL/ELT pipelines via Dataproc Jobs and Workflows.Directed Databricks integration on GCP, leveraging Databricks Jobs and Workflows for advanced data pipelines.Integrated Spark applications on GCP Dataproc with Google BigQuery for seamless data flow.Developed PySpark applications with BigQuery Connector to enhance pipeline performance.Implemented automated ELT pipelines with GCP Cloud Composer (Airflow) to streamline workflows.Collaborated with cross-functional teams to ensure data quality, optimize infrastructure, and enhance scalability.

Bengaluru, Karnataka, India

Wells Fargo on MDSS(Marketing decision support system): Managing an agile team (kanban) as product owner of BI/Data/Statistical Analyst responsible for analyzing and reporting critical aspects of Wells Fargo Cards portfolio. Developed and implemented product roadmap and strategies for improving the performance of reports and business intelligence applications.Designing and built robust, highly scalable data warehouse (EDL) from OLTP and Hadoop based data sources to cater to elastic demand of the business.Leading the model development, validation and implementation of Customer Diminishment model(in Python) using Gradient Boosting Machine with Decision Trees algorithm and Logistic Regression techniques, for Credit Card Customers Mixers, Transactors, Revolvers segments.Leading the design and build of robust, highly scalable data warehouse ( Enterprise Data Lake) from OLTP and Hadoop based data sources to cater to elastic demand of the business.Leading the development of Marketing Data Ecosystem for Enterprise Marketing organization, migrating data from DB2, Oracle, Teradata to Aster ( Teradatas Big Data Platform).Performing capacity planning for the Development, Test and Production Hadoop environments.Determining data sources and transformation rules required for populating & maintaining data warehouse.Determining technical feasibility of requirements, created design documents.Working on performance tuning of various reports / SQL queries to provide seamless reporting experience to Executive managementHelping strategic marketing organization in identifying diminishing customers (86% accuracy) and created focused retention campaigns for individual customers / segments..Building Out of Box BI Reports for various Customer Segments focusing on Churn/Diminishment Rate.Determining technical feasibility of requirements, created design document.

Hyderabad Area, India

Worked on internal project with technology (Bigdata/Teradata/ETL/Data modeling/Reporting-tableau)

Bangalore

Worked on data modeling, master data management with technology (Tableau,(Bigdata)Hadoop,Informatica, Teradata, Data warehouse,MDM web,ssis ) worked on Project : BRINKER(Chili's and maggianos) USA

Gurugram, Haryana, India

Worked For DU telecom(DUBAI) .Responsible on Data analyzing using data warehouse (informatica and teradata,HAdoop,data modeling)

Bengaluru, Karnataka, India

Worked as etl developer with sql/plsql/informatica with client The Hartford USA