Vikash Kumar

Developed PySpark scripts to create new tables and transfer data in JSON format between databases. Created multiple stored procedures for data analysis and reporting. Designed and implemented data models to improve performance and scalability. Worked with the data science team to optimize queries and develop stored procedures for analytical needs. Ensured data integrity with validation checks and error handling. Utilized Postman for testing and validating Python scripts. Designed and implemented an SCD Type 2 stored procedure for historical data tracking. Structured and optimized database tables for Jira migration. Developed ETL processes to extract, transform, and load Jira data. Implemented data validation and reconciliation checks to ensure accuracy. Automated error logging for debugging and monitoring. Collaborated with cross-functional teams to ensure a seamless migration process. Used Python and SQL scripts to clean, transform, and enrich Jira data before migration. Designed and implemented an SCD Type 2 stored procedure for tracking historical changes. Optimized database schema for storing Snowflake data in a normalized format. Developed ETL processes to extract, transform, and load data while ensuring integrity. Conducted data validation and reconciliation to verify migrated data accuracy. Automated workflows and enhanced performance using SQL and Python scripts.

Updated user details in SAP database. Validated user data using SQL queries. Created weekly and monthly reports through SQL queries.

Maintained and updated user details in SQL Server database. Validated user data through SQL queries. Generated weekly and monthly reports using SQL.