Sai Nadh Reddy

Worked as a Database Analyst at MouriTech, Hyderabad (April 2024 – September 2024) for client Stanley Black & Decker.

Database Analyst - MOURITECH - Hyderabad

(2024-04 - 2024-09)

Worked as a Database Analyst at MouriTech, Hyderabad (April 2024 – September 2024) for client Stanley Black & Decker.

• Involved in large-scale data migration from MySQL to PostgreSQL using the Solix tool.
• Extracted data from source MySQL databases and loaded it into target PostgreSQL environments.
• Performed schema validation and ensured proper mapping of tables, columns, constraints, and sequences.
• Validated migrated data by comparing row counts between source and target databases.
• Wrote complex SQL queries using joins, subqueries, group by, and aggregate functions to generate client reports.
• Optimized PostgreSQL queries by creating indexes and improving execution performance.
• Created and modified stored procedures, functions, views, and sequences based on business requirements.
• Performed DDL operations such as creating and altering tables and DML operations such as insert, update, and delete.
• Worked in a UNIX environment using commands like grep, sed, and chmod to search data patterns, modify files, and manage permissions.
• Prepared daily migration status reports and shared validation reports with stakeholders.
• Documented recurring issues and created knowledge documents to reduce resolution time.
• Attended regular meetings with business users and development teams to understand reporting and migration requirements.
• Analyzed large datasets to generate KPI-based reports and define performance metrics with stakeholders.
• Created Excel (Pivot Table) reports, presented insights to business teams, and improved reporting accuracy by resolving data inconsistencies.

Bachelor of Technology - IT - Sri Venkateswara College of Engineering and Technology (2019-08 - 2023-07)

High School Diploma - M.P.C - Sri Chaitanya Junior College (2017-07 - 2019-03)