Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Jyosthna Mude

Hyderabad

Summary

Results-driven Database Analyst with over 9 Years of experienced in SQL,Python and Pyspark. Successfully led a database migration project, enhancing system performance by 20%. Expertise in data cleansing and modeling, fostering actionable insights. Strong collaborator, optimizing workflows and ensuring data integrity through rigorous validation processes. Committed to delivering high-quality data management solutions.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Database Analyst

TCS
04.2023 - Current

· 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.

Database Migration

Tata Consultancy Services
07.2020 - 06.2022
  • 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.

Database Developer

TCS
06.2018 - 10.2019

· 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.

Production Support Analyst

Tata Consultancy Services
04.2016 - 04.2018

· 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.

Education

Master of Technology - Electrical And Electronics Engineering

Jawaharlal Nehru Technological University
Anantapur, India
04-2015

Bachelor of Technology in - Electronics And Instrumentation Engineering

Sree Vidyanikethan Engineering College
Tirupati, India
04-2013

Skills

    Programming:

    SQL,Python

    ETL/ELT:

    Alteryx,Data Migration,Data Warehousing,Data Lake

    Cloud Platforms:

    AWS(Athena,Glue,S3,Redshift)

    Big Data Technologies:

    Snowflake,Pyspark

    Data Management:

    Data Ingestion,Data Quality,Data Validation,Batch Processing

Certification

AWS Certified Data Engineer - Associate 🔗

Timeline

Database Analyst

TCS
04.2023 - Current

Database Migration

Tata Consultancy Services
07.2020 - 06.2022

Database Developer

TCS
06.2018 - 10.2019

Production Support Analyst

Tata Consultancy Services
04.2016 - 04.2018

Master of Technology - Electrical And Electronics Engineering

Jawaharlal Nehru Technological University

Bachelor of Technology in - Electronics And Instrumentation Engineering

Sree Vidyanikethan Engineering College
Jyosthna Mude