Architect Data

Oracle Certified Professional

Brainbench Certified

Sun Certified

R Vasdev Database Architect & Oracle Technical Architect Page 1 of 4 Rishideep Vasdev

E-Mail : *******@*****.***

Mobile : 942-***-****

Summary

20+ years of hands on experience on various software architectures - client server, layered, component based, data centric, service oriented, and cloud.

20+ years of affluent experience across multiple domains such as banking, payment, trading, logistics, back office, product lifecycle management, transaction lifecycle management, personnel, payroll, inventory, despatch, order processing, quality control, etc. as Oracle Technical Architect & Database Architect.

My capabilities lie in decisive analytical skills; designing Oracle, SQL Server, PostgreSQL, and MongoDB databases; architecting RDBMS & NoSQL based solutions; data modelling; high availability designs; building scalable applications; and performance tuning.

Expertise in analysing, conceptualising, and creating data models for variety of applications. And, expertise in analysing and conceptualising database design patterns across applications.

Have been accountable for PL/SQL developers and database administrators. Hands-on with various RDBMS Development, Management, Administration.

Designed and implemented business logic within databases and implemented inter & intra application data flow process. As ETL lead designed reporting databases from transactional databases. Have also augmented as SQL Server & PostgreSQL Database Architect.

Prolong technical exposure and critical persuasive skills have furthered me to execute, retain, and manage projects successfully. I have donned business development role as well. Roles & Responsibilities Pursued

Cloud Architect

Oracle DaaS, OEM Cloud Control, Oracle 18c

Database Architect

Conceptual, Logical, Physical, Dimensional, & Temporal Data Modelling; PL/SQL & T-SQL Architect; Database Refactoring, Data Strategy, Data Governance, Data Masking, Data Security, Data Sub-setting Oracle Architect

Database Design – OLTP, Operational Data Stores, Data Warehouse, Multi-tenancy Data Warehousing – External Tables, Partitioning, Parallelism, Transporting Tablespace, ETL, Data Quality, Metadata, Materialized Views, Data Migration OLAP – Cubes, Slicing/Dicing, Drill Up/Drill Down, Dimension, Aggregation, Hierarchies, Analytical and Modelling Queries, Advanced BI, Data Mining, Data Scrubbing, Data Profiling HA Solution – RAC, Data Guard, Distributed Databases, GoldenGate, Streams, Shared Server, Data Cache Performance Tuning – Optimize Data Model, Optimize SQL & PL/SQL, Optimize Memory, OS & Hardware Usage, Performance Forecasting, Trace Analysis, Optimizer Statistics Management, Alert Log Analysis Database Objects – Tables, Indexes, IOT, Clusters, Types Database Management – Tablespace Definition & Sizing, File Layouts, ASM, Cloning, Redo Log Sizing, Undo Management, Database Templates, DBCA

Backup & Recovery Solutions – Scripts Based, Data Pump, RMAN, Flashback, Log Miner Troubleshooting – Dump Analysis, Trace Files, Alert Files, Session Trace, Instance Trace Oracle Setup – Installation, Upgrade, Configuration, OPatch Localisation – Character Set Migration and Multilingual Support Security – Virtual Private Databases (FGAC), Auditing, Encryption, Oracle Wallet, Data Masking Other Features – Oracle Advanced Queuing, Alerts, Scheduler, XML, PL/SQL, Java, XDB, Workspace Manager, Ultra Search, Oracle Text, Diagnostic Pack, Tuning Pack, Configuration Pack Oracle Certified Professional

Brainbench Certified

Sun Certified

R Vasdev Database Architect & Oracle Technical Architect Page 2 of 4 PostgreSQL Architect

Database Design, Database Development (SQL, PL/pgSQL), Performance Tuning, Data Warehousing, Database Management, Installation & Configuration

SQL Server Architect

Development, Performance Tuning, Upgrade Rundowns, SQL Server Migration, Database Migration, Database Mail, Data Compression, Import, Export Data, Bulk Copy, Extended Stored Procedures / CLR, JSON, Database Design, T-SQL Lead, High Availability, Machine Learning Services (PoC) Systems Analysis & Design

SDLC - Requirement Analysis & Design, Code Estimation, Agile Methodology, UML, ORM, ERD, EERD Database Programming

JSON; SODA; R; SQL - Queries & Views; PL/SQL - Procedures, Functions, Triggers, Packages, Type Body, External Procedures, Data Pump API, Metadata API; RMAN – Scripts Business Development, Project Management & Competency Development Resource - Allocation, Scheduling, Acquisition, Mentoring; Competency Development; Project Management, Effort Estimation, Cost Estimation, Delivery Management; Account Relationship Manager; Proof of Concept Lead; RFP & Work Order

No SQL

Oracle NOSQL, MongoDB

Data Analytics

Python (2.x,3.x), R (2.n, 3.n); Experiment Design & Analysis; Probability, Statistics, Mathematics; Data Quality, Data Governance, Data Mining; Pattern & Trend Analysis; Structured & Unstructured Data; Quantitative Methods; Regression Analysis, Segmentation Technical Expertise

RDBMS Oracle 19c, Oracle 18c, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle8i, Oracle 8, Oracle 7, & Oracle 6, SQL Server 2014, SQL Server 2017, SQL Server 2016, SQL Server 2008, SQL Server 2005, SQL Server 2000, SQL Server 7, SQL Server 6.5, Interbase, Firebird, MariaDB, MySQL

ORDBMS PostgreSQL, EDB Postgres Advanced Server

ISAM Databases Paradox 7, BTrieve, MS Access, dBase, Foxpro In Memory Database Oracle TimesTen 11g Rel 2

Time Series

Database

InfluxDB

Embedded Database SQLite

NoSQL MongoDB, Oracle NoSQL

Programming SQL, PL/SQL, T-SQL, PL/pgSQL, Object Pascal, Java, Pro*C, C, COBOL, UML, HTML, IDL, BASIC, Pro-Talk, Python

Tools SQL*Forms 3.1, SQL*Reports 1.1, SQL*Plus, Developer 2000, Delphi 1, Delphi 2, Delphi 3, Delphi 4, Delphi 5, VB, Kappa 3.1, BI Publisher, SQL Developer, TOAD CASE Tools Erwin, Visio, Designer 2000, Oracle SQL Developer Data Modeler Operating System Solaris, AIX, HP, UNIX, Windows NT, Linux Statistical Analysis R

Other Install Shield, Power Builder 3.0, Jam 7.0, Install Anywhere Scripting PERL, Python, JavaScript, BASH, SH, KSH, CSH Oracle Certified Professional

Brainbench Certified

Sun Certified

R Vasdev Database Architect & Oracle Technical Architect Page 3 of 4 Certifications

Oracle Certified Expert – Oracle 10g: Real Applications Cluster Administrator

Oracle Certified DBA (OCP) – Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i, Oracle 8

Sun Certifications – Java 2 Platform, Solaris Administrator

Brain Bench Certifications – Data Warehousing Concepts, RDBMS Concepts, Oracle 8 DBA, Oracle 7 DBA, Oracle Programmer, Delphi 5 Developer, Delphi 3 Developer

Brain Bench Certifications Master’s Level – Oracle 11g DBA, Data Modelling Concepts, SQL (ANSI) Fundamentals

RankSheet Certified Professional – My SQL Level 1, Oracle 9i SQL Level 1

E-Certifications - Oracle 8 DBA

Tools / Utilities Designed & Developed

Test Data Generation

Port Oracle DDL to SQL Server (Basic)

Data Archiving, Data Compression, Data Masking, Data Cleansing, Data Profiling

Code Enhancer, Code Review (Basic), Code Generator (Basic), DDL Generator, DML Generator

Schema Comparison, Database Capacity Planner (Forecast, Estimation, & Sizing)

ETL Tools, Object Table Mapping, Data Migration

Migration: Oracle to PostgreSQL, Oracle to MongoDB, Oracle to SQL Server, SQL Server to Oracle

Test Automation

Corporate Trainings/Seminar/Consultancy Conducted

Oracle 8/8i/9i/10g/11g/12c/18c/19c – Performance Tuning, Architecture, Backup & Recovery, Administration, Data Guard, Import / Export, Security, PL/SQL, SQL, New Features, Streams

PostgreSQL – Database Design, Database Development, PL/pgSQL, SQL, Performance Tuning

Oracle TimesTen – Architecture, Management, Replication, IMDB Cache

SQL Server – Performance Tuning, T-SQL, Architecture

Data Modelling / Advanced Data Modelling – Conceptual, Logical, Physical, Dimensional, Temporal

Unified Modelling Language – Object Diagram, Class Diagram, Use Case Diagram, Activity Diagram

Programming Languages – C, Java, Python, R

Qualification

B. Sc., First Class, University of Pune, 1992

Master of Computer Management, Distinction, University of Pune, 1994 Work History

Independent Database Architect, Database Consultant, Database Advisor, & Technical Consultant Since Oct 2013 Role Database Architect, Database Administration, Performance Specialist, Development Architect, Corporate Trainer, Database Forecasting, Database Management & Planning, Proof of Concept, Competency Building, Development Lead, Data Modelling Technology Oracle, PostgreSQL, MS SQL Server, MongoDB, Python, R Programming Clients JPMC, Syntel, Wipro, MMIT, Willis Tower Watson, DSS IPL, VolksWagen, SoftCell, Volante Tech, Atherti, Dell, Sigma Optima, iTriangle Pvt Ltd, BMC, Kulsoft Technology, Androizen, DSM, Seventh Contact, Veritas, Incotec, Sigma Optima

Responsibilities Development (SQL, SODA, JSON, XML), Archiving, HA Solution, Data Modelling, Administration, Performance Tuning, Replication, Training, Automation & Scheduling Oracle Certified Professional

Brainbench Certified

Sun Certified

R Vasdev Database Architect & Oracle Technical Architect Page 4 of 4 Senior Architect (Databases) Technology at Cognizant Technology Solutions from Dec 2011 until Sep 2013 Role Manage and Lead Database Aspects of Projects

Account ACE Insurance, Bank of New York & Mellon, and Other Financial Institutions Responsibilities Database Architect, PoC & RFP, Work Order Review, Account Relationship Management Advisory Database Architect at IBM India Pvt Ltd from March 2011 until Dec 2011 Role Accountable for PL/SQL Development, Deliverables, & EXADATA Migration Account Deutsche Bank, eSPEAR EXADATA

Responsibilities Build EXADATA & PL/SQL Competency, EXADATA Migration, Data Strategy, Assisting Data Analysts, Database Performance, Database Architect, Data Governance & Data Strategy Technical Consultant (Databases) at PTC Software India Pvt. Ltd. from Nov 2008 until March 2011 Role Product Performance Tuning Specialist

Products Wind Chill, Pro Intra Link

Responsibilities Oracle & SQL Server Competency Development, Database Architect, Oracle / SQL Server Migration

Consultant at i-flex solutions ltd from Aug 2001 until Nov 2008 Role Lead Database Architect & Lead Development DBA Accounts Citibank NA (US & Singapore), Barclays Bank, Shinsei Bank Ltd, SAAB, Deutsche Bank (Germany), ALIASWIRE

Responsibilities SQL Server & Oracle Database Architect, Set-up Database Deliverables Quality Assurance Practice, Database Availability, Globalisation & Localisation, Escalations Resolution, Data Archive, ETL, 10g Migration, Database Sizing & Partitioning Projects Corporate Prepaid Card Payment, Faster Payments, FLEXCUBE SWIFTNET Services Integration, CRM – Seibel, Trading Application, FLEXCUBE Corporate Migration, Phone Based Payment System, PRISMA – Bulk Payment System, SWIFTNET, CITI Fund Transfer, CITI Expert, CITI Online Report Generation, and FLEXCUBE Retail

Project Manager at INCOTEC Software from Jan 2001 until Aug 2001 Role Lead Database Architect & Delphi Development Lead Responsibilities Creation of Delphi Components Library, Data Modelling, Implement FGAC Project TECHDATA, Delphi Components Library, Time Entry System Assistant Project Manager at DSS InfoTech from Sep 1994 until Nov 2000 Role Oracle & Delphi Development Lead, Oracle DBA

Account National Heavy Engineering (TALEGAON), PGP (Belgium), ICON (UK), Watson Wyatt World Wide

(UK), Pinnacle Systems (UK)

Responsibilities Database Architect, Oracle Configuration, Infrastructure Recommendation Applications Solutions, Inventory and Purchase, Payroll, Despatch, Order Processing, Personnel, Quality Control, Software Maintenance, Voucher Maintenance, Logistics, Pension Management, Laboratory Product Management, Money Purchase, Product Builder Trainee Analyst at National Institute of Bank Management from Jul 1993 until Dec 1993 Responsibilities Design, Develop, Test and Implement Project Credit Information System

Contact this candidate