Virat Raj Joshi

Record Disposal(Synchrony Finance)

• Worked on Record Disposal Process.
• Single Handedly developed automated process for Record Disposal.
• In Record Disposal we generally purge the account numbers every year which are 21 year old and inactive.
• We have been given those account numbers from DWH team as plain text file.
• To hold these account numbers we created a master table and loaded these account numbers in it.
• We have used mostly Pyspark and Shell scripting to develop automated process.

• Worked on MBM Dashboard project.
• Performing Data Profiling on data lake tables.
• Using Jupyter Notebook with Pyspark for profiling.
• Working on extracting data from data lake and performing transformations and load.
• Working on writing sql queries to fetch data from data lake tables as per business logic.
• Loading data to GraphDB that it TigerGraph.
• Written GSQL queries on GraphDB.
• Developed framework with Pytigergraph to push schema to Tigergraph.
• Created jenkins pipeline to trigger Schema change job in TigerGraph.
• Using kubectl tool for monitoring job.
• Working on performance tuning as required.