Mansi M

Associate Consultant at Oracle with experience in SQL, database management, and data migration. Worked on database consolidation and cloud migration with focus on data validation and quality. Familiar with Linux and troubleshooting. Interested in Data Engineering and ETL roles.

Associate Consultant at Oracle (2025-08 – Present)

• Consolidated 8 on-prem databases into a single unified database.
• Developed SQL-based data workflows using PIF.
• Created a Postman collection to validate the data consistency.
• Developed reconciliation reports to verify the accuracy of data consolidation and record counts.
• Handled data block corruption issues by restoring databases from VM backups and validating data consistency across related tables.
• Developed scripts to monitor datafile usage and automatically manage storage by adding new datafiles upon threshold limits.
• Scheduled database statistics gathering after ETL operations to ensure query performance and maintain dashboard consistency.
• Maintained and optimized Oracle databases through security patching, performance tuning, and system monitoring.
• Provisioned target databases for data import, upgraded schemas to the latest Primavera P6 version, and performed data validation by identifying and resolving orphan records.
• Generated database export dumps using expdp and transferred them securely to cloud storage using PAR URLs.
• Initiating a Python-based automation tool to execute multiple SQL validation scripts.
• Reducing manual effort in identifying data inconsistencies.

Project Intern at Oracle (2025-01 – 2025-07)

• Contributed to a document migration project using SQL-based data integration workflows.
• Worked on a metadata creation tool that automates structuring of document data for migration.

B.E in Information Science and Engineering – Dayananda Sagar College Of Engineering (2021-12 – 2025-12)