Debidutta Mohanty

linkedin.com/in/debidutta-debi-mohanty-620144143

adtbbc@r.postjobfree.com

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

Milton, ON, CANADA

Data Architect

• Oracle certified professional with over all 14+ year of IT industry experience with hands-on experience in Data Modelling, Database Management, SQL, PL/SQL and ETL-Design.

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

• Have been working in Structured Query Language (SQL) to access databases to conduct research and use applications to retrieve and manipulate data from databases located on different platforms.

• Involved in complex data solutions, apply transformations logic and data profiling and data quality solutions

• Worked on conceptual, Logical, Physical data modelling in OLTP and OLAP using ERWIN and Power Designer Tool

• Worked on metadata management and data mapping and data lineage process.

• Involved in database schema optimization according to different business use case and in-depth knowledge on data profiling and data migration projects.

• Designed and developed analytical reporting in OLAP using Tableau Reporting Tool

• Involved in data validation and analysed data in source systems to identify data quality issues (e.g., missing values, duplicate meanings, and invalid data)

• for DB performance review

• 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.

• Involved in complex, high-volume data from structured, unstructured and semi-structured sources, and multi-dimensional datasets with a variety of tools like Tableau, reporting etc.

• 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 the data analysis for source and target systems.

• Built and maintained data pipeline jobs using python scripting

• 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, SAP Business Objects Data designer

Data stage 11.5, Oracle Change Data Capture (CDC). Cloud Practitioner- AWS (EC2, S3, Athena, IAM, KMS), Oracle Cloud (OCI) Programming Languages/Scripting- SQL, PL/SQL, Python, UNIX scripting Tools - PL/SQL Developer, TOAD, SQL developer JIRA Data Modelling - ERWIN, MicrosoftVisio2010, Power Designer,Alation Cloud Datawarehouse Snowflake

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

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

Other Technical Skills- KAFKA-KSQL

FUNCTIONAL COMPETENCIES

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

Capgemini Canada Inc. July 2021 – Present

Data Architect

• I’m associated with Enterprise Data Warehouse team to support BI/Analytics for the Unified Platform.

• As a Sr. Data Engineer using the latest Oracle technologies working on multiple data initiatives related to data platform.

• Working across the different stages of the data pipeline, integration, ODS, and Real Time data marts.

• Leveraged CDC and utilized data integration tools such as SAP Data Services, Oracle Golden Gate, to deliver real time data for the Ad Sales BI initiative.

• I partner with architects, engineers, QA, and the scrum team to deliver data through an Agile philosophy.

• Will be working with technology experts to build a highly scalable and extensible data platform which enables collection, storage, modelling, and analysis of massive data sets from numerous channels.

• Working on data migration from Oracle to Snowflake migration project and involved in data profiling.

• Levering AWS Cloud components (EC2, s3, Athena, IAM, KMS) and snowflake cloud DW. Cognizant Technology Solutions Limited [United States & Canada] Apr 2010 – July 2021 Technology Architect June 2016 – July 2021

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 using ERWIN and Power designer tool, perform Logical and Physical Database Design, and implement ETL strategy using IBM datastage.

• Designed a bulk load tool to update oracle JSON objects and multiple nodes 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.

• Moved the multi value check points to oracle pipelined functions and used PLSQL collections to fetch data for better performance.

• Created pipelined functions for better performance across all the OBIEE reports.

• Built and maintained data pipeline jobs using python scripting

• Designed data quality and profiling maintaining tools across multiple databases.

• Designed Oracle CDC and KAFKA Integration tool using Oracle Golden gate 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 April 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

• Optimization.

• Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions. Tata Consultancy Service Apr 2007-Apr-2008

Asst System Engineer

Motorola ECC Business – Chennai, India

• Worked on ERP Support resource pool Oracle Business Suite -11i- Account Receivable / General Ledger/Accounts Payable

• Worked on technology -Oracle Apps 11i-PO, SQL*Loader, Oracle Forms/Reports, Oracle Workflow, Oracle SQL, PL/SQL

• Involved in Root cause analysis and Critical Bug fixing on the tickets on interfaces from PO to MRP,SS and AP

• Involved in Registrations of Forms and Reports in Apps.

• Defined Executables and concurrent programs.

• Invoking Concurrent Programs in PL/SQL Programs.

• Involved in developing and testing Oracle Stored Procedures, Functions and Packages.

• Review of code changes, test procedure, test plans and other deliverables using Clear case.

• Implemented code changes in Production using Kintana. Cognizant Technology Solutions Limited Sep 2005 – Mar 2007 Technical Analyst

Aetna Insurance – Chennai, India

• Worked on Oracle Business Suite -11i- Account Receivable / General Ledger/Accounts Payable

• Developed downstream interfaces and up-stream interfaces.

• Registrations of Forms and Reports in Apps.

• Defined Executables and concurrent programs.

• Invoking Concurrent Programs in PL/SQL Programs

• Worked on technology- Oracle Pl/SQL, Oracle 11i-AR, shell scripts, Clear case & Clear Quest 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

• AWS Certified Cloud Practitioner

EDUCATION

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

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

Contact this candidate