SUMMARY

• 15 years of hands on experience in Oracle Database Development with Development DBA roles.
• Excellent leadership skills in driving the team with technical, functional and mentoring capabilities.
• Comprehensive experience on database programming with SQL and PL/SQL stored Procedures Functions, Packages, and Triggers etc with Advanced PL/SQL programming using Collections.
• Comprehensive experience on Developer6i (Forms and Reports) Application programming.
• Comprehensive experience on MS - SQLServer Database Development (TSQL)
• Good understanding of Cassandra NoSQL Architecture, CQL (Cassandra Query Lang) and Modeling. Migration of RDBMS Model to NoSQL Direct Query Model.
• Good understanding of MongoDB NoSQL Modeling.
• Considerable experience in System Analysis & Design and Development around Oracle Database systems.
• Deep understanding and experience in Product Development Life Cycle.
• Comprehensive experience on Physical modeling / database schema design for enterprise class software systems.
• Defining Security Features for Database and Application users using Privileges, Roles, Profiles, FGAC, Audit Trail, Session & Database Level Triggers etc.
• Hands-on experience using database tools / utilities including TOAD, SQL Developer, SQL*Plus, SQL Loader, Export / Import.
• Good knowledge on Informatica Power Center, ETL Development Framework.
• Comprehensive experience in Database & Data Migration Projects from Legacy systems to Oracle Database.
• Comprehensive experience in defining Best Database Development Practices, Database Architectural Standards, Coding Standards and Framework. Propagating knowledge on these areas to new team members.
• Experience of working on UNIX environments, writing shell scripts to accomplish various tasks.
• Comprehensive experience in Unit / Performance / Integration / Regression Testing.
• Excellent communication (verbal & written), interpersonal, collaboration, and problem solving skills
• Well experienced in understanding and gathering requirements in LLD / HLD documents.
• Good experience in Release Management, Patch Delivery and Release Documentation.
• Experience with Change management software CVS, Telelogic, Perforce.

TECHNICAL SKILLS

Oracle Database: Oracle 7 to 12c, Development DBA, Physical and Logical Database DesignSchema and Schema’s Editions designing, Capacity Planning

Oracle Development: SQL, PL/SQL, Program Units, Packages, Triggers

Oracle Advanced PLSQL: Object Types, Collections, Bulk Collect / FOR ALL Session / Database Level Triggers

Oracle OLAP: Dimension Hierarchies, Materialized Views Remote DB connectivity using DB Links, Query Rewrites

Oracle VLDB: Table / Index Partitioning, Partition Maintenance, Partition Pruning, Parallel Queries

Oracle Data Security & Auditing: System/ Object Privileges / Roles / User Profile Fine-grained Access Control / VPD, Trigger based auditing / Audit Trails

Oracle Performance Tuning: SQL Tuning using CBO capabilities, Explain Plan, Query Transformations Oracle Trace, HINTS, Query Parsing Mechanism

Oracle Data Load Tools: SQL Loader, EXP / IMP, DATAPUMP,Data Correction Scripting (DML), DDL Scripting.

NoSQL (Big Data): Cassandra Architecture, CQL Language, NoSQL Modelling, KeySpace, Tables, Partition Keys, Cluster Indexes, Secondary Indexes, Collections (Set, List & Map). MongoDB

GUI Tools: Oracle Developer 6i (Forms & Reports )

Database Migration: Oracle Migration Work Bench

Tools: SQL-Developer, TOAD for Oracle

ETL Tools: Informatica Power Center 9.0,Oracle Warehouse BuilderTraditional ETL coding using PLSQL, Direct Path Loads

Other Databases: Teradata 13 /14, SQL Server, DB2, HP Vertica

Job Schedulers: Oracle DBMS SCHEDULER, DBMS JOB, Autosys Job Scheduler Tool, JIL Scripting

Other: UNIX, PERL, Python

PROFESSIONAL EXPERIENCE

Confidential

Database & ETL Architect

Responsibilities:

• Involved in eProduct initiative from inception, played Data Architect and Technical Lead Roles. Extensively participated in all the phases of SDLC, from requirement analysis, design discussion, HLD and LLD preparation, work estimation and distribution to coding implementation and testing.
• Involved in Physical Schema Designing for Source and Targets.
• Involved in Development DBA activities like Preparing DDL Scripts, Deploying objects in Database Schemas, Writing Data Correct Scripts.
• Prepared Data Load Mapping Sheets.
• Prepared Coding and Change Management Standards
• Extensively participated in LLD / HLD meetings.
• Extensively involved SQL Performance Tuning, Developing Packages, Triggers.
• Extensively involved in Code Promotion for UAT, PROD environments.

Database Developer

Confidential

Responsibilities:

• Involved in writing ETL code for Relation Import for Moving data from Operations Systems to Sales Performance Management Repository.
• Involved in capturing data issues in logs during Relational Import.
• Involved in Performance Improvement of overall Relational Import Duration.
• Extensively involved in Writing Database Stored Procedures for Relation Import (ETL)
• Extensively involved in Bug Fix, Patch Scripting, Product Enhancements, Release Management and Change Management.
• Designed SaaS DB model using VPD for Callidus TrumComp product in order to operate in Cloud environment.

Database Migration

Confidential

Responsibilities:

• Understanding the differences between Sybase and Oracle Architecture.
• Learning and imparting knowledge to Teammates about Oracle Migration Work Bench Tool and its repository.
• Creating and managing Oracle Database.
• Migrating Data Structures like Tables, Indexes etc.
• Migrating Stored Program Units like Procedures and Triggers.
• Emulating Sybase System Objects into Oracle.
• Writing Scripts for DDL, Static Data and SQL*Loader

Database Developer

Confidential

Responsibilities:

• Database &ETL development for reading source files and moving into Research Data Respository using SQLLoader.
• Writing Data Return Packages using Ref Cursors for Java Team
• Helping Java team to refer Database Objects and Transaction Management

Database / Application Developer

Confidential

Responsibilities:

• Database & Application Developing and Framework using Developer / 2000
• Writing PL/SQL Packages, Triggers for Logistical Functionality.
• Application Performance Tuning
• Unit Testing.

Database / Application Developer

Confidential

Responsibilities:

• Database Development DBA and Developer
• Writing T-SQL Stored Procedures.