Pradipta Kumar Roy, Developer in Kolkata, West Bengal, India
Pradipta is available for hire
Hire Pradipta

Pradipta Kumar Roy

Verified Expert  in Engineering

Software Developer

Location
Kolkata, West Bengal, India
Toptal Member Since
January 18, 2022

Pradipta is an experienced and accomplished database architect and project manager with over thirteen years of experience leveraging extensive backgrounds in database management, project management, and technical consultancy in different organizations. He has completed the complex upgrade, migration, and implementation projects for reputable international clients like Elisa, HFM, and Dex Media.

LinuxDatabasesOracle DBAAmazon Web Services (AWS)DevOpsPythonPerlPostgreSQLMongoDBUiPathMySQLMariaDBDockerJenkinsAnsibleIT Service Management (ITSM)DialogflowKNIMEPeoplesoft

Availability

Part-time

Preferred Environment

Linux, Databases, Amazon Web Services (AWS), DevOps, Microsoft Azure

The most amazing...

...thing I've achieved is upgrading PeopleTools, Oracle DB, and OS from HP to AIX and migrating all the servers prod, UAT, and dev instances to different hardware.

Work Experience

Database Administrator, PeopleSoft Admin, Database Architect, and Project Manager

2004 - 2018
Tata Consultancy Services
  • Provided end-to-end database support for UCO bank branches running company's banking software under Mumbai region. Received a certificate of appreciation from UCO Bank Regional Office, Mumbai.
  • Upgraded PeopleSoft PeopleTools, Oracle DB from 10g to 11g, and operating system from HP to AIX while migrating all the servers prod, UAT, and dev instances of PS to different hardware without any issue. Received appreciation from HFMUS, New York.
  • Led the replication trigger bug fix discussions with MariaDB for Elisa Oyj. Upgraded all the instances of MariaDB to the latest version. Received a certificate of appreciation and CIO appreciation from Elisa Oyj, Helsinki, Finland.
Technologies: Databases

UCO Bank | India

• Provided project support for ISBS, banking software.
• Made code changes in Pro*C and installed Oracle 7 along with the ISBS software.
• Fixed implementation bugs.
• Provided run-time application support of ISBS at UCO Bank branches across India.
• Project management for the ISBS Implementation.

HFMUS | New York, US

• Provided PeopleSoft upgrade support and implementation support for Oracle 10g.
• Conducted data migration from PostgreSQL to MySQL and provided corresponding database support.

Successfully upgraded PeopleSoft PeopleTools, Oracle DB from 10g to 11g, and operating system from HP to AIX alongside migrating all the servers prod, UAT, and dev instances of PS to different hardware without any issue. Received appreciation from HFMUS, New York.

SuperMedia (Dex Media) | Dallas, US

• Provided extensive support for PeopleSoft and Oracle 10g and 11i database and upgraded complex production database environments.
• Project management and onsite and offshore coordination.
• Release management, change management, and appraisal management.
• Performed proof of concept installations for MongoDB and AWS installation and administration.

Elisa Oyj | Helsinki, Finland

• Database administration, upgrades, and production support for MariaDB. Planning and upgrading Oracle and Postgres databases.
• Complex legacy Perl and Python code changes along with timely migration-upgrade.
• Management of new service developments supporting master data management.
• DevOps activities using Jenkins, Ansible, OpenShift, Docker containerization, and ensuring GDPR compliance of applications, scripts, and demons.
• Project management and onsite and offshore coordination.
• Migration upgrade management and change management coordination.

Successfully upgraded all the instances of MariaDB to the latest version. Led the replication trigger bug fix discussions with MariaDB for Elisa Oyj and received a certificate of appreciation and CIO appreciation.

Academic Projects | Haaga-Helia University of Applied Sciences

• Developed a chatbot using Dialogflow and Microsoft Azure.
• Data analytics and forecasting projects using Microsoft Azure, Power BI, and SAP Lumira.
• Machine learning project handling Twitter feeds using the KNIME workflow.
• Developed different projects using UiPath robotic automation.
• Breakfast concept design for Delicatessen Restaurant in Finland.
• Written a master’s thesis on a framework for the selection of software-as-a-service products for small and medium-sized enterprises.
MAY 2020 - PRESENT

RPA Business Analyst Foundation

UiPath

MAY 2020 - PRESENT

RPA Developer Foundation

UiPath

APRIL 2020 - PRESENT

AWS Cloud Practitioner Essentials

AWS

AUGUST 2015 - PRESENT

Oracle Exadata Database Machine 2014 Certified Implementation Specialist

Oracle

MARCH 2015 - PRESENT

ITIL 2011 Foundation Certificate in IT Service Management

Exin

MARCH 2015 - PRESENT

M102: MongoDB for DBAs

MongoDB University

DECEMBER 2014 - PRESENT

Oracle Database 11g Administrator Certified Associate

Oracle

Platforms

Linux, Amazon Web Services (AWS), Docker, KNIME

Storage

Databases, Oracle DBA, Database Administration (DBA), MongoDB, MySQL, PostgreSQL, MariaDB

Other

IT Service Management (ITSM), Microsoft Azure, Robotic Process Automation (RPA), Service Design, PeopleSoft, Shell Scripting, SAP Lumira, UiPath

Languages

Python, Perl

Paradigms

DevOps

Tools

Jenkins, Ansible Tower, Ansible, Dialogflow, Microsoft Power BI

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring