Objective:

Senior Data/Information/Database Architect, managing guiding Information/Database Architecture teams

Summary:

Data/Information/Database Architect with 10 years of experience in Logical/Physical Data Model Design, Oracle Performance Tuning, Implementing DB Best Practices, Standardizing Enterprise Data Architecture Processes, Preparing DB Based Project Proposals , Database Schema/Instance Analysis, and Application Development using SQL PL/SQL. Trained Certified in Information Management:- Data Quality DQ , Data Profiling, Information Lifecycle Management ILM , Metadata Management, Master Data Management MDM , Data Migration , Big Data Exadata

• OPERATING SYSTEMS: UNIX, Linux, Solaris, Windows NT/2000
• LANGUAGES : PL/SQL, C, C , Core Java
• DATABASE : Oracle 9i/10g/11g, Mysql, Teradata, DB2
• TOOLS : Precise i3 Tool, HPSD, CA All Fusion Erwin Modeler, Oracle Enterprise Manager, SQL Plus, SQL Developer, PLSQL Developer, Toad,
• DB2 Infosphere Data Architect
• Architect Trainings attended and given, Case Studies, Documentations and Artifacts:
• Prepared case studies presented on Authentication Online Help for Architecture Requirements, 3 Tier Architecture for Online Retail Application Online Movie Ticket Booking System for Architect Estimation
• Prepared Artifacts on Oracle Database 11gr2 Automatic SQL Tuning, SQL/PLSQL Function Result Cache, Oracle Automatic Parallelism, Oracle Database 11g SQL Plan Management Adaptive Cursor Caching for Wipro Knowledge Management Repository
• Oracle Exadata: Have knowledge and attended presentations in Exadata Architecture, Exadata Features: Smart Scan, Smart Flash Cache, Hybrid Columnar Compression, Infiniband Network Storage Indexes
• Have undergone training from Wipro Architect Academy on MDM benefits/drivers, MDM architecture styles, Data Governance MDM life cycle prepared case studies for MDM implementation in large Information Management Pharmatectual Companies
• Conducted Training Sessions on DB Model Design Performance Tuning on following topics:
• Normalization, Dimensional Modeling
• Erwin Reverse Engineering Complete Compare operations
• SQL Tuning strategies. Oracle DB Parameter tuning
• DB Performance Reports ADDM,ASH,AWR,SQL Tuning Advisor, Segment Advisor
• Prepared standard process documentations for Schema Placement Schema Creation Processes
• Prepared standard process documentation for executing 3rd Party and Performance Tuning Projects
• Prepared Logical Physical Data Modeling Guides
• Coded PLSQL Package for performing DDL activities like disabling constraints, materialized view refreshes, statistics gathering , truncating tables from Functional User Accounts used by Scheduling/ETL Tools
• Prepared standard documentation for use of Private/Public DB Links
• Analyzed privileges required for User-Id to be used by Data Modelers/Data Architects for viewing Dictionary/Dynamic Performance Views and performing Erwin-DB operations like Complete Compare and Reverse Engineering

Professional Experience:

Confidential

Oracle Database Architect/Project Manager

Confidenntial is a corporate action processing application for Custody business built using Java Swing as UI, Core Java for middle/service layer. Backend is Oracle and the application hosted on VisiBroker CORBA Server. GCAS is a workflow, state transition system driven by rules engine configuration. Corporate actions of different type are received from various sources. Based on the rule once all the required information is obtained through several message, DRU tool Data Reforming Unit will read the message, parse it and creates the new message in GCAS. Based on the rules Consolidation will happen, and a final corporate action notification will be sent out to the impacted clients/holders. On receipt of these messages, client sends response through various sources like SWIFT, CAPTAIN, FAX etc. Those responses are then processed through matching rules. Currently GCAS caters the needs of Custody clients only. GCAS is highly integrated with several systems like upstream and downstream systems like GRS, RSM, Record keeping systems, Mainframe applications through CTG, MQ, DRU. The project is executed to enhance the application to add Middle Office business line to the application. The project is executed in 4 Phases which address the different modules of Message, Notification, Response, Instruction and Reporting

Responsibilities:

• Mentored development team reviewed SQL Code for 71 GCAS/CCMS Reports by understanding the data column mapping and reporting requirements
• Created column/filter metadata for message, notification response search screens and added metadata to screen element/screen filter tables
• Designed ten Stored Procedures with 50 ref cursors for displaying corporate action/ response data, processing response update/verification, enhancing ADMIN screen for granting access to users at account/fund level
• Standardized PL/SQL Packages by formatting, adding of comments, DB logging and exception handling
• Performance Optimization of SQLs by using scalar sub query caching, case statements, Oracle Hints and by eliminating Cartesian joins
• Performance Optimization of PLSQL code by using bulk merge, FOR loop optimization, NOCOPY clause and function based result cache
• Prepared Deployment of DB scripts DDL/DML into UAT Prod. DB
• Architected SP changes and metadata changes for fixing UAT Prod. bugs
• Managed onsite and offshore team through delegation/coordination of changes related to Java Flex
• Fixed Prod. SQL Performance issues by adding hints and gathering statistics with auto sample size

Environment: Oracle 11g/10g, SQL, PL/SQL, TOAD, SQL Developer, PLSQL Developer, Solaris

Confidential

Oracle Database Architect/Oracle Application DBA

Reconciliation at BNYM aims at reconciling ledger and statement side of the data and making sure transactions are exactly matching at both ledger and statement sides. Scope of the project involves in optimizing the existing PLSQL Procedures that are used for reporting various reconciliation activities like Write-offs, Daily Matches, Exceptions Daily Reconciliations support/debug Database Performance issues

Responsibilities:

• Analyzed PLSQL Procedure codes and SQLs
• Fine tuned SQLs by eliminating multi-passes, inline sqls, hints
• Recoding of PLSQL procedures by implementing SQL tuning methods and bind variables
• Analyzed new Index creation based on table access paths
• Recommending collection of histograms and analyzing the existing init.ora parameter settings
• Recommendation of DB best practices like Function Based result cache, partitioning Materialized Views
• Fix production performance issues by implementing SQL profiles, Indexes, gathering statistics and dynamic sampling hint

Environment: Oracle 11g/10g, SQL, PL/SQL, SQL Developer, Solaris

Confidential

DB2 UDB Application DBA

The implementation of the Business Intelligence project at Videocon Telecom is to enable easy access to cross-functional data for effective business decision-making. Based on an IBM DB2 data warehouse, the solution will enable business users to self-service their information requirements through the Cognos portal. The key benefits to business from this project include flexibility in analyzing subscriber usage analysis, roaming usage analysis, prepaid revenue analysis and prepaid product analysis including VAS. Scope of work involved maintaining the Data Models already developed, adding DB2 performance features formulating DB2 Backup Strategy

Responsibilities:

• Performed Data Model changes in LDM and PDM, implementing the DB Changes in DB2 UDB
• Implemented Database Partitioning, Table Partitioning and Multidimensional Clustering Features for performance scalability in Prod. DB2 ISAS Environment
• Tuned SQL Queries using Visual Explain and db2advis tools. Monitored data load utility jobs using db2top utility
• Analyzed on the requirements for implementing Multi Temperature Data Management and Query Patroller for restricting Query processing
• Devised/Planned Backup Strategy Backup Solution for DB2 ISAS 5600

Environment: DB2 UDB 9.2, ISAS, Infosphere Data Architect, SUSE Linux

Confidential

Oracle Data Architect

• Objective of this project is provide Data Architect design services to various projects under
• GE Aviation/Energy/Transportation/Power Water.

Responsibilities:

• Gathering detailed requirements from Functional and Business specifications and analyzing the requirements for designing Logical/Physical Data Models
• Designing Logical Physical Data Models using Erwin Tool for OLTP, DW ODS Systems per Enterprise Modeling Standards best practices
• Designed OLTP data models for projects:- Engine Change Submittal ECS having 20 Entities in LDM 15 Tables in PDM, Design Practice for GE Energy DPE having 70 Tables in LDM/PDM, Integrated Ground Systems IGS having 20 Entities in LDM 15 Tables in PDM, Activity Based Management ABM having 15 Entitles in LDM 10 Tables in PDM
• Designed DW data models containing Staging, Enterprise Normalized Reporting Areas for projects:- IT Data warehouse Redesign/ HPSD to SNC Migration Program having 70 Entities in LDM 10 Tables in Staging Schema 35 Tables in Reporting Schema, Part Comparison Tool PCT having 40 Entities in LDM Staging 10 Tables , Normalized 25 Tables Reporting 20 Tables including Facts, Dimensions and Normalized tables Data Models, Intelligent Diagnostics Repair IDR having 40 Entities in LDM Staging 5 Tables , Normalized 10 Tables Reporting 25 Tables including Facts Dimensions Data Models
• Performed Complete Compare, Forward Engineering Reverse Engineering Operations between Erwin Model Databases
• Performed Volumetrics and generated Complete Compare and Model Validation Reports using Erwin
• Generated Schema object Creation script from Erwin to Create DB Objects in Schema
• Prepared Documentations for Organization Standards in Logical/Physical Data Modeling, Performance Tuning, 3rd Party Tool DB Deployment, Schema Placement Schema Creation Process
• Designed/Developed 25 PLSQL Packages for projects:- Part Comparison Tool PCT Intelligent Diagnostics Repair IDR
• Analyzed 3rd Party DB Installation Manuals for deploying the Schemas/DB Instances. Scope also involves fine tuning DB Instance Parameters. Supported DB implementation for following 3rd Party products:- Kronos 6.0 Upgrade, Enterprise Security Manager ESM , Network Correlation Analytics COR Documentum
• Completed DB Placement Forms for building new DB Instances and placing Schemas in DB Instances
• Completed Schema Request Forms for creating new Schemas
• Performed Schema Quality Checks Post Schema Creation Validation Checks for error free Schemas
• Oracle Schema capacity planning like sizing Table spaces Undo Segments
• Coding PL/SQL Scripts Oracle schedulers for DB Objects statistics gathering, Partitioning, Index Rebuilding, Materialized View Refreshes
• Oracle Security Administration implementation of Oracle Security and Access Hardening across 100 GE Aviation GE Energy DB Instances, Oracle Row Level Security Oracle Encryption
• Oracle Performance Tuning fine tuning SQL Queries using Explain Plans, SQL Tuning and Access Advisors PLSQL Tuning DB Instance Tuning analyzing performance reports like i3, ADDM, AWR,ASH Segment Advisor
• Fine tuned Bulk Load process from 1 Day to 6 Hrs through use of DIRECT PATH load and NOLOGGING option
• Coded SQL script for implementing DBMS REDEFINITION Package for re-organizing a fragmented table
• Implemented ATOMIC REFRESH for faster Materialized View Refreshes
• Tuned MV queries from 15 mins to 2 mins through use of PARALLELISM
• Implemented Oracle 11g AUTO PARALLELISM RESULT QUERY CACHE
• Analyzed Performance of Hierarchical based a query that's doing UNIQUE operations on 200 Million records. Recommended 32 KB Block Size use of TEMPORARY TABLESPACE GROUPS for Parallel sorting
• RAC Performance Tuning using ADDM Report
• Support Application Teams in writing Optimized Code fine tuning of existing Code
• Use of HPSD Tool for promoting SQL Scripts to QA PROD Environments
• Effort Estimation and Strategy Buildup of Databases
• Developing DB Development/Architect based Project Proposals in reference to Statement of Work
• Analysis of Oracle 10g, Oracle 11g Oracle Exadata features implementation in DB Instances

Environment: Oracle 11g/10g/9i, Mysql, SQL, PL/SQL, Erwin Data Modeler, PLSQL Developer, Toad

Confidential

Data Center Administrator

Objective of this project is to monitor Rolta Corporate Data Center support Data Modeling activities

Responsibilities:

• Routine health checks of Data Center Servers
• Install Linux Operating System Redhat/Suse on servers used for Security, Authentication Billing of Rolta Net Customers
• Installation of Sybase, Mysql Oracle Databases on Linux servers
• Requirement Gathering for designing Logical/Physical Data Models through functional business specifications
• Designed Logical/Physical Data Models
• Deployment of DB Objects in Database

Environment: Oracle 9i, Suse/Red Hat Linux, Network Monitoring Tools