Jyosthna Mude

· Led a database migration project , where data of 14 million records from ICDW(Teradata) to Snowflake, ensuring data integrity. and Optimized system performance by achieving a 20% improvement.

· Performed data cleansing, analysis, and modeling to generate actionable insights that improved decision-making processes.

·Developed Python scripts for data validation to ensure high data integrity.

·Collaborated across functions to document workflows and refine processes, resulting in improved team efficiency and effective knowledge sharing.

·Actively participated in script reviews and provided support to the team as needed.

• Successfully migrated MsAccess database to the SQL server database.
• Analyzed data in the MS Access database, identified discrepancies, and corrected them to ensure data accuracy.
• Created new tables in the SQL Server Database.
• Migrated data successfully by using SQL Server Migration Assistant (SSMA).
• Implemented database authentication to support backend–frontend communication, granting user entitlements aligned with role-based access control.
• Performed comprehensive testing on the migrated database to ensure data consistency and integrity.

· Effectively converted Alteryx,SSRS reports generated from one data model to another data mart, ensuring accuracy and performance.

. successfully converted the complex SQL queries to the new data model by changing the table and column names provided.

· Optimized SQL queries through performance tuning, achieving a 75% reduction in execution time.

· Ensured 100% accuracy in outputs generated from the new data model when compared with the legacy data model.

.Effectively updated Alteryx reports to align with new data mart requirements, executed workflows, and validated outputs to ensure 100% accuracy.

· Handled client’s Internal application very effectively by managing day to day activities.

· Automated several functionalities to reduce manual effort.

· Effectively handled jobs execution by using Autosys.

· Successfully deployed new changes to the application in the production environment, by collaborating with Dev teams.

· Handled Daily tickets on priority basis without breaching SLA’s.

· Handled several Outages by collaborating with Dev Teams and DBA Teams.