Palak Dhawan

Lead Developer in Oracle to AWS Migration:

• Led a cross-functional team to successfully migrate critical database infrastructure from Oracle to Snowflake, ensuring zero data loss and minimal downtime.
• Architected and managed the development of Python-based automation scripts to streamline data migration, optimizing workflow efficiency
• Directed the setup and configuration of Snowflake environments, guiding user onboarding and implementing best practices for security and access control.

Legacy System Migration & Decommission:

• Spearheaded the migration of legacy systems from Sybase to Oracle, coordinating efforts across multiple teams to ensure smooth transitions
• Provided strategic oversight during the decommissioning phase, ensuring all system dependencies were identified and addressed
• Led post-release support operations, orchestrating after-hours troubleshooting and validation sessions to confirm successful migrations and system stability

Data Warehouse Development:

• Led the development and design of a new Oracle-based data warehouse, overseeing a team responsible for automating data integration and building logging frameworks for monitoring
• Collaborated with stakeholders to understand business needs, designing a scalable data architecture to meet growing data demands.
• Mentored junior developers and provided technical guidance on complex issues related to data backfill, integration, and optimization, ensuring adherence to project timelines.

Union Bank of Switzerland (UBS) Project:

• Developed SCP, a web-based portal used for managing trading alerts and reporting in PL/SQL
• Collaborated with clients to gather requirements, implement system changes, and test new functionality
• Designed PL/SQL packages to generate alerts for trading activities

Commercial Investment Trust (CIT) Project:

• Maintained databases related to leasing and lending data for assets like aircraft and railway equipment
• Optimized SQL Server code for enhanced performance and collaborated with clients to meet regulatory and risk-related requirements
• Played a lead role in designing, developing, and tuning the system's functionality.