Sign in

Database Architect

Toronto, ON, Canada
December 28, 2020

Contact this candidate


Debidutta Mohanty

Phone: +1-647-***-****

Milton, ON, CANADA


Oracle certified professional with 11+ years of hands-on experience in Oracle PL/SQL, Data Modelling and ETL-Design.

Worked as Data modeler, technical Lead and Data architect and design data solutions for insurance, healthcare industries.

Strong Customer interaction skills and excellent expertise in Requirements gathering, Analysis, Estimation and Resource Planning.

Pretty good exposure in database design and extensive hands-on in handling Oracle packages, Functions, procedures, collections, dynamic SQL, cursors, DB links, Materialized view etc.

Highly proficient in Oracle SQL Query Performance maintenance - tuning and PL/SQL optimization using SQL Trace, Explain Plan, Indexing and Hints.

Presently working as the Database Lead and coordinating the work with multiple offshore developers.

Highly skilled and shown eminence in all phases of a Software Lifecycle – Requirements, Analysis, Documentation, Design, Build, Testing/ Support and Comprehensive Deployment Planning.

Sound Techno-Functional expertise in dealing a variety of Reporting Tools, Database Solutions and Business Problems.

Participated in database administration activities like creation of database and database objects, users, privileges, data files,table spaces, storage allocation of various DB objects using TOAD, SQL*Plus etc.

Involved in Data modelling activities like Generating Logical Design Model & Physical Design Model and ER Diagram using Microsoft Visio Tools.

Involved in the data analysis for source and target systems.

Involved in Oracle DB migration to Oracle 19c and Oracle Integration to MongoDB

Enthusiast and open to learn experience with new tools, technologies and platforms across many technology stacks.

Experience working in agile delivery methodology. TECHNICAL SKILLS

Databases - Oracle 11g/12c/19c (SQL, PL/SQL and Other Data Base Objects), Oracle Golden Gate, Oracle Cloud, MongoDB

ETL Tools - Oracle External Directory, UTL, SQL Loader Data stage 11.5, Oracle Change Data Capture (CDC). Programming Languages/Scripting- SQL, PL/SQL, Python, UNIX scripting Tools - PL/SQL Developer, TOAD, JIRA

Data Modelling - Erwin, MicrosoftVisio2010

Version Control/DevOps - GitHub, Jenkins, Serena/Nolio, Electric Flow Pipeline, SPLUNK Scheduling &Service Management- Auto Sys (Job Scheduling Tools), CA Workload Automation Desktop Client 12,

BMC Remedy, Autosys, Service Now, ALM, Marketplace Reporting Tools- Tableau 20202.2.0

Other Technical Skills- KAFKA-KSQL

Cloud Practitioner- AWS, Oracle Cloud (OCI)


Domain - Insurance Domain (Personal Lines, Group Benefits) Retirement Annuities, Retirement Plans, Mutual Funds Modules- Retirement Plan Annuities, IRA, Market/ Investment Product Product- Institutional client onboarding, Plan center, Enterprise Data management CAREER ACCOMPLISHMENTS & ACHIEVEMENTS

Cognizant Technology Solutions Limited [United States & Canada] Apr 2010 – Present Database Architect June 2016 – Present

Retirement Solutions / TIAA-CREFF - Charlotte, USA and Toronto, Canada

Designed and Developed Data Mart to develop scalable Customer-centric data-hub across segments across the enterprise.

Involved in Oracle DB migration to Oracle 19c and Oracle Integration to MongoDB

Involved in Oracle SQL Query Performance maintenance - tuning and PL/SQL optimization using SQL Trace,

Explain Plan, Indexing and Hints.

Designed Data Model, perform Logical and Physical Database Design, and implement ETL strategy.

Designed a bulk load tool to update oracle JSON objects and multiple node with a single click

On boarded Oracle DB deployment to CI-CD pipeline using Jenkin, GitHub, Serena/Nolio

Designed and developed and published multiple Tableau reports involving multiple data source (i.e. Oracle, Teradata)

Extensively used SQL*Loader and EXP/IMP utility to load huge volume of data between databases and schemas.

Designed and Implemented Automated Email monitoring tool to monitor Oracle Golden gate replication process using UTL package across Data Sources.

Designed data quality and profiling maintaining tools across multiple databases.

Designed Oracle CDC and KAFKA Integration tool using Oracle Goldengate KAFKA connector. Technical Lead Oct 2011– May 2016

Group Benefit Lines / The Hartford Insurance – Hartford, CT, USA

Manage Services Layer project team of 20+ developers delivering over multiple insurance services, supporting multiple UI clients and connecting to multiple back-end systems.

Managed team responsible for development, maintenance and ongoing enhancement of enterprise-wide Agent Front End web application.

Delivery-focused with proven success implementing new products and enhancements; highly Performance tune and optimize SQLs using explain tables, TKPROF utility, by setting database parameters, by using optimizer hints and using Analyze to compute statistics on tables.

Acted as “Technical Functional Consultant” to Client and provided expert Advice to insurance Technology team.

Coordinate recruitment and selection of project personnel and identify need for resources

Manage the packaging and release of applications to the training, UAT and Production Environments.

Managed E2E for all complex business functionality and provided System Integration Testing (SIT), User Acceptance Testing (UAT).

Manage Project Execution to ensure adherence to budget, schedule, and scope.

Involved in Design and Develop Oracle, PL/SQL batch and real time batch processes for business functionality and for loading data from Internal and External Systems using SQL Loader and External Tables.

Create Oracle data base objects based on Oracle JSON data. Technology Lead and Offshore Lead Sep 2010– Oct 2011 Group Benefit Lines / The Hartford Insurance – Chennai, Kolkata, India

Served as a Technical Lead and offshore lead for an Onsite & Offshore team for design of a new Data management system.

Mentored team and provided internal training to the project team on Oracle, PL/SQL and Advanced Oracle Architecture

Worked on design, upgrade 9i database to 10g and set up secure distributed database environment.

Importing/Exporting Oracle Data Dump into new schema and bringing up the Core banking product.

Deployed more than 100 tables, Packages, procedures, functions and bring the environment up and running.

Execute End-of-Day (EOD) batch processes, resolve EOD (Set of programs to reconcile the transactions of the day)

Maintain the quality standards and review overall coding activities

Provide Production support for important issues/ items.

Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.

Worked on XML along with PL/SQL to develop and modify web forms.

Designed Data Modeling, Design Specifications and to analyze Dependencies.

Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.

Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based


Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions. CERTIFICATIONS

Oracle Certified Professional ( Advanced PL/SQL)

Oracle Cloud Infrastructure Foundations 2020 Associate

Oracle Cloud Infrastructure Developer 2020 Associate

Oracle Autonomous Database Cloud 2019 Specialist

Oracle Cloud Infrastructure 2019 Architect Professional EDUCATION

Master in Computer Application (MCA), BPUT, Rourkela, Orissa

Bachelor of Arts (Mathematics), Academy of Business Administration, F.M University, Orissa

Contact this candidate