Aashay Khabiya

PROJECT : INSIGHT

Client : Central Board of Direct Taxes (Incom Tax of India)

• Designed and implemented scalable ETL pipelines to automate data processing and improve data integration across multiple data source.
• Performed data validation, cleansing, and transformation using SQL, improving data accuracy and consistency for reporting and analytics.
• Developed custom scripts to extract and parse data from XML files, automating the transformation and loading data into teradata tables, reducing manual effort and improving data accuracy, which is used to create cases for tax compliance. Impact : 5000 STR Cases are made which are investigated by officers per month.
• Developed and optimized complex SQL queries for data extraction, transformation, and loading(ETL) processes, ensuring efficient data workflows and high-quality outputs.
• Developed and implemented data quality rules using ETL tool and queries to validate and ensure the accuracy of data related to the F61B form of government reporting portal improving compliance and reporting accuracy. Form61B data is later used to send data to OECD which is and internation data exchange platform
• Having 3 years of experience in dealing with a large amount of data (live Indian financial datasets with 67 crore PANs) to Export/Import using ETL pipelines and performing operations on data using queries and procedures.