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.
