1) Build AWS Glue job to load data from RDS PostgresDB instance transform it and write it as Parquet files. Deploy it using Terraform scripts.2) Build AWS Glue job to load data from various Snowflake tables, transform the data and load it in RDS PostgreSQL instance using Pyspark.3) Build AWS step function to orchestrate multiple Glue and Lambda jobs and pass the status of each run as an event to downstream application.4) Developed ETL pipeline for ingesting data from API requests, parquet files in HDFS and SQL Database. Transforming and performance tuning the job using pyspark and saving the final file in AWS S3 bucket.5) Developed a Bi- Directional Integration pipeline for external system Salesforce to consume and supplement data. Developed Pyspark job to ingest data from DataLake, transform it and load into SQL database Developed HouseKeeping jobs using SQL stored procedures to switch the active and backup SQL tables for ensuring fresh loading of data on daily basis without interruption of API services

Managing data driven process to capture the essential metrics such as Delivery performance (Time to delivery), Returns ( First RTO, Last RTO). Embossing to dispatch TAT. Using the analytical skills to boost the performance and to detect and fix any process related issues.

Production• Manage end to end KYC validation process and production related activities• To meet the assigned productivity and accuracy target of 99%• To manage the inventory by following LIFO rule and ensuring TAT of P95 1 day• Stakeholder management: Resolving customer issues/escalations liaising with customer services and other units• Ensuring regular COE audits, discuss findings and passing feedback with team• To comply completely with the RBI guidelines and build controlsProduction RPA(Robotics Process Automation)• Stabilization of process by daily monitoring report and analyzing defects in process• Creation of MIS to monitor the process parameters• Liaison with IT development and support team for issue resolution• Conducting regular meetings for process update with stakeholdersAutomation• To create automated reports which help in improving accuracy and productivity• To identify re-work in existing RPA process and improve automation by identifying areas and fixing themPAN• Monthly report out of PAN validation for the income tax report.• Co-ordination with IT team to ensure data is accurate and complete• Provide daily resolution to all PAN related service requests

Agency Management• Onboarding of agencies by co-ordination with Sourcing, Legal, Infosec and Compliance• Billing data and resource management at the agencies• To manage the performance of the agencies by tracking fulfilment percentage, call volume, call conversion & quality of call• To conduct training session at agencies for skill development• Regular review of calling speech to make it effective• Roll – out of eKYC initiative and tracking the penetration of the same• To conduct audit across agencies and ensure agreement adherence

Process Improvement - Reducing rework in the credit card pre-acquisition phaseProved instrumental in driving project 'Knockout' across pan India locations for KYC fufilmentPrepared automated dashboards for analysing corporate spend patterns.