Designing and developing multiple WhatsApp pipelines to send the reminder message and collect feedback from customers about their vehicle performance and service.Helping business stakeholder to run ad hoc campaigns to get the customer sentiments and recover the lost customers.Building master tables in delta lake using history data from transactional systems SQL Server/SAP/SharePoint...etc. to maintain the latest information about vehicles, customers and dealers.Designing and… Show more Designing and developing multiple WhatsApp pipelines to send the reminder message and collect feedback from customers about their vehicle performance and service.Helping business stakeholder to run ad hoc campaigns to get the customer sentiments and recover the lost customers.Building master tables in delta lake using history data from transactional systems SQL Server/SAP/SharePoint...etc. to maintain the latest information about vehicles, customers and dealers.Designing and building scalable data pipelines to collect, process, and store data from various sources, including manufacturing equipment, vehicles, and customer interactions.Managing and maintaining data infrastructure, such as data warehouses, data lakes, and data marts.Ensuring data quality by implementing data cleaning, validation, and standardization processes.Supporting data-driven decision-making by providing actionable insights.Integrating machine learning models into data pipelines and applications.Leveraging data to inform product design and development by analyzing customer feedback, market trends, and performance metrics.Supporting the development of connected vehicles by designing and implementing data-driven features. Show less

Handled data transformation, business logic application, and managed data workflowsManaged the import of historical data into the CDW system using SqoopAnalyzed data in both VDW and CDW systems using SQL and HiveQLUtilized PySpark Core APIs for data transformation into the required formatImported data from AWS S3 into Spark RDD and executed transformationsScheduled Spark and Hive scripts using Qubole workflow schedulerApplied business logic to healthcare datasets for… Show more Handled data transformation, business logic application, and managed data workflowsManaged the import of historical data into the CDW system using SqoopAnalyzed data in both VDW and CDW systems using SQL and HiveQLUtilized PySpark Core APIs for data transformation into the required formatImported data from AWS S3 into Spark RDD and executed transformationsScheduled Spark and Hive scripts using Qubole workflow schedulerApplied business logic to healthcare datasets for historical data managementDeveloped standardized PL/SQL scripts for data integrity and documented processesConducted unit testing, code migration, and created job flows for data extraction and FTP transfer Show less

• Used Spark API over Cloudera to perform analytics on data in Hive.• Implemented extensive Hive queries and creating views for ad hoc and business processing.• Optimized Hive scripts to use HDFS efficiently by using various compression mechanisms.• Developed Spark code using Python and Spark-SQL for faster processing of data.• Developed the oracle packages and procedures to load the data into data warehouse. • Wrote database triggers to execute specific action on table/view… Show more • Used Spark API over Cloudera to perform analytics on data in Hive.• Implemented extensive Hive queries and creating views for ad hoc and business processing.• Optimized Hive scripts to use HDFS efficiently by using various compression mechanisms.• Developed Spark code using Python and Spark-SQL for faster processing of data.• Developed the oracle packages and procedures to load the data into data warehouse. • Wrote database triggers to execute specific action on table/view objects.• Wrote PLSQL scripts to generate Dynamic Trigger script based on objects passed into parameters.• Developed PLSQL script to apply the required business rules on the application in different modules.• Create / review the procedures, functions, triggers, tables, views, indexes, sequences for the various module of project.• Major involvement in generating enhanced reports for client using oracle bi publisher. Show less

• Managing and solving ADHOC requests as per requirements and SLA.• Writing and modify existing Procedures, Functions, and Triggers and other database objects as per requirements.• Involved in database development by creating Oracle PL/SQL Functions, Stored Procedures, Triggers and Packages.• Handling Exceptions using particular exception handlers.• Created various PL/SQL Scripts involving Insert, Sequences, Constraint and Index scripts.