Suman Panigrahi

• Led end-to-end delivery of application development across multiple technologies, ensuring seamless execution.
• Collaborated with Business Analysts to review, finalize, and freeze requirements for future releases.
• Managed release planning, ensuring timely delivery of key milestones and deliverables.
• Oversaw code quality reviews, ensuring adherence to best practices and development standards.
• Supervised SIT, integration, and UAT testing, ensuring the quality and functionality of new modules.
• Led production deployments, handling implementation and post-release support for new functionalities.
• Oversaw people management for a large team and vendor management enhancing team performance and collaboration across three vendors and two locations, optimizing collaboration and efficiency.

• Increased data processing efficiency by (25%) by designing scalable data pipelines and implementing optimized data storage solutions.
• Functional programming approach: To develop code and maintain data for static reference purpose for end-users with non-sharing approach
• Data privacy concept: Maintaining and creating database objects for data projection with approach of creating independent and private objects based on specific user roles
• Worked in DevOps culture handling production incidents and maintenance activities for the developed application
• Expertise in performance tuning and optimization of SQL queries
• Used analytical functions like LISTAGG, RANK, DENSE_RANK, ROW_NUMBER, LEAD, LAG

• Used oracle external tables to consume delta data from csv files and merging into main tables
• Used interval range partitioning for log history tables
• Learning: Used pragma autonomous transaction

• Client – Equifax: US (Media and Information domain)
• Data migration: DB script creation and execution for very large volume of Data migration
• Used cursors, BULK COLLECT, FORALL, exchange partition
• Rebuild indexes for production database instances for the indexes whose size is greater than that of table
• Converting non-partitioned table to partitioned table using dbms redefinition
• Used package dbms_datapump to migrate tables with BLOB data

• Client: Hartford (Insurance domain)
• Project Description: To migrate all the Personal lines data from existing Oracle 10 g Database to Oracle 11g Exadata
• Developed and enhanced PL/SQL stored procedures
• Created UNIX shell scripts containing the transformation logic for migration
• Involved in Data migration using Informatica Power Center