Sarmistha Dutta

1. Led and managed end-to-end migration projects from Oracle to Snowflake/Oracle 11g to Oracle 19c, overseeing all stages from planning, analysis, design, development, testing, and deployment in an Agile Scrum environment.
2. Developed and implemented comprehensive migration strategies, considering factors such as data volume, complexity, downtime constraints, and business continuity requirements, while adhering to Agile principles.
3. Facilitated Scrum ceremonies including sprint planning, daily stand-ups, sprint reviews, and retrospectives.
4. Coordinated with stakeholders across multiple geographies to define project scope, objectives, and detailed technical requirement.
5. Directed a team of engineers in utilizing technical expertise in Snowflake, including database and object creation, data loading and querying, integrating data sources using Snow SQL and Snowflake UI, Time Travel, Data Sharing, Data Cloning, Secure Views, and Multi-cluster Shared Data Architecture for performance optimization and security
6. Responsible for Project planning, roadmap creation and backlog maintenance.
7. Sound knowledge in Oracle SQL, PLSQL, LINUX shell scripting.
8. Supervised extensive testing and validation of migrated data to ensure accuracy, completeness, and performance in the Snowflake environment.
9. Optimized migration processes and SQL queries to minimize downtime and maximize performance during migration windows, following Agile principles for continuous improvement.
10. Responsible for post-migration support, addressing issues, troubleshooting errors, and assisting stakeholders in adapting to the new Snowflake environment.
Managed resource allocation, project timelines, and risk mitigation strategies to ensure successful project delivery, using Agile Scrum methodologies for project management.
11. Proficient in JIRA and CONFLUENCE. Leverage JQL to create custom filters and dashboards in Jira, improving project visibility and tracking.

1. SQL\PL\SQL Developer. Experienced in Unix\Shell and Python Scripting.

2. Worked on Database Migration.
3. Involved in Code Review and Performance Tuning.
4. Involved in Oracle Data Migration
5. Upgraded Oracle RMS 9 to RMS 14
6. Rich knowledge in Oracle Retail

• Supported and Mainlined Backend Financial system.
• Worked on Change Requests, Report Changes using extensive Oracle PL\SQL, SQL coding.
• Developed small application for service Improvement with SQL coding, UNIX(Basic) commands.
• Handled Incident and Problem Ticket using Remedy.
• Provided production Technical support ensuring high degree of customer satisfaction through SLA & Process Compliance.
• Application maintenance, support, development and testing.