Soumyajit Tarafdar

Experience

• 

  Tata Consultancy Services

  Dec 2008 - Jan 2014

  • Upgrade of Existing database from 10g to 11.2.0.3 – Upgrade database from 10g to 11g for Oracle BI, E-Business Suite, IDM, SOA and custom databases. Tune and resolve performance related issues after upgrade.• Upgrade of existing database version from 10g to 11g and implementation of OAM 11g - Upgrade of Existing database from 10g to 11.2.0.3 for E-Business Suite. Upgrade Portal 10g to 11g Access manager. Migrate 10g database from Linux X86-64 to SUSE 11 and database 11.2.0.3. Integrate 11g Access manager with Oracle E-Business Suite R12.• Maintaining Maximum availability environment using Oracle RAC, Data Guard, 10g/11g Grid, ASM,OCFS2,ACFS,ASMLIB.• Supported Oracle E-Business Suite R12 environment with High Availability Architecture (RAC, PCP, Load balancing Internal and External web tiers) supporting Oracle Financials/HRMS/Payroll modules and custom applications. • Implementation of OEM 12c - Installation of Oracle Enterprise manager cloud control 12c on SUSE Linux operating system. Mass deployment of agents for monitoring across servers through OEM 12c.• Single Global Instance (Gemstone) project - Convergence of UK’s R12 and US’s 11i instances to a Single Global R12 instance with Maximum Availability Architecture. (MAA).• R12 upgrade with shared APPL TOP implementation /run TUMS report/ install tech stack/ Configured INST top.• R12 (12.0.4) upgrade from 11i (11.5.10.2) with database in RAC architecture. • Oracle Production Support - 24X7 support of production systems as L3 support at Nottingham(UK) client location. Show less

  • Oracle Applications DBA

    Dec 2008 - Jan 2014

  • Oracle Apps DBA

    Dec 2008 - Jan 2014
• 

  Experian

  Feb 2014 - Dec 2017

  • Implement Exadata X6-2 Engineered systems along with Oracle Big Data Appliance. Upgrade database from 11g to 12c.Upgrade of database from 11.2.0.4 to 12.1.0.2 with E-Business Suite 12.1.3, SOA 11.1.0.7, OBIEE 11g, IDM Suite 11.1.0.6.• Upgrade of E-Business Suite Applications form 12.1.3 to 12.2.5.• Implementation of AMS on E-Business Suite - integrate E-Business Suite with OEM12c (12.1.0.3) and integrate with AMS for better change controls.• V-Block Migration and implementation of OID OAM and EBS Access Gate 11g - Install 11g Access manager and integrate with EBS Access gate and Microsoft active directory. Integrate 11g Access manager with Oracle E-Business Suite R12.• V-Block Migration and upgrade database to 11.2.0.4 - Migrate existing OBIEE, HYPERION and Custom databases to V-Block Servers and Upgrade to 11.2.0.4• V-Block Migration and SOA 11g HA Implementation - Migrate the existing Oracle E-Business Suite (12.0.6) to V-Block Servers and upgrade to 12.1.3. Install 11g SOA and integrate with E-Business Suite.• Created J2EE based DevOps Applications for ease of adhoc requests file running ad utilities FNDLOAD, FILE Version Check, Download file etc. Interface for automated cloning of E-Business Suite. • Created DevOps Tool having integration with Bitbucket for automation of code deployments.• Oracle Production Support - 24X7 support of production systems as L3 support at Kuala Lumpur location.• Experience installing and maintaining Standby Database (Data Guard) setup and configuration.• Strong skills in backup and recovery procedures using RMAN. • SQL, Database and Applications performance tuning. Show less

  • Oracle database expert

    Feb 2014 - Dec 2017

  • Senior Database Architect

    Feb 2014 - Dec 2017
• 

  Children, Community and Social Services | Services à l’enfance et Services sociaux et communautaires

  Mar 2018 - Nov 2018

  Senior Applications Database Administrator

  Providing Solutions on Oracle ERP platform integration solutions.Involving in Migration Activities and planning for Database and Applications Upgrade/Migration.Performance tuning for High available systems for both OLAP and OLTP database implementations./ ETL LoadsCapacity Planning, Technical architecture and solution providing.Providing Devops solutions for process automation

• 

  Scotiabank

  Nov 2018 - Mar 2022

  • Senior Solutions Architect

    Feb 2020 - Mar 2022

  • Solutions Architect

    Nov 2018 - Mar 2022

  • Application Specialist

    Nov 2018 - Feb 2020
• 

  TD

  Mar 2022 - now

  Senior Manager Technology Delivery

  On a journey to tranform how TD Bank change end user experience with technology and cloud transformation to reimagine the art of possible. We want to bring innovation and value to the Bank and our customers with confidence and reliability.I was responsible for driving innovation in Finance and Risk technologies for their journey of transformation into Oracle Cloud technologies integrating it different parts and components in the machinary.In this role, I partnered with executives across technology and various business lines to identify key strategic opportunities to optimize and modernize the platform and leverage technologies within the bank to bring about the transformation.Me and My teams focus areas were:• Engage with Business stakeholders and partners to determine Key Data points and help them transform the same from their legacy systems to modernized Data Platform• Engage ITS infrastructure Architects and Managers to transform Manual Business process to automation on Modern Architecture• Work with Business partners, Integration Partners to align with Banks vision for Technology Transformation and drive key transformation projects • Review Key Design Decisions for FRP Transformation into Oracle Cloud• Review and determine Authoritative sources for data working with Business and work with Source Systems to bring it to Enterprise Data Platform• Work with Business partners and integrators to challenge solutions and provide key design decisions specific to Banks requirement and policies• Architect tooling and methodologies like DevOps pipelines for Oracle systems like OFSAA and ERPCS• Review solutions provided by integrators and contractors Show less