SUMMARY

• Database architect and administrator.
• 14 years of experience including onsite in planning, developing and implementing state of the art information solutions primarily in Telecom BSS and OSS , Manufacturing, Healthcare and Banking domain
• A dynamic leader and mentor and able to build team cohesion and inspire individuals to strive towards ever higher levels of achievements
• Exceptional client relationship and management skills. Adept at consensus building, crisis management, problem resolution and negotiations
• Strong capabilities of Application design/ development, Oracle 11g/10g/9i/8i, SQL, PL/SQL, Data Modeling, PL/SQL Design and Development
• Have extensive experience in developing, implementing and maintaining application systems under Windows/Unix operating systems using SQL, PL/SQL, Oracle/DB2 Database and many other features such as Import/Export, Oracle External Tables, SQL Loader and SQL Plus, Java Stored Procedure, DBMS Packages, UTIL Packages
• In depth knowledge of Oracle technologies like XMLDB, RLS/FGA, XML Support and relevant features like XQuery, Flashback query etc.
• Handling large oracle systems and performance tuning/enhancement
• Mastered various database/SQL tuning techniques like AWR reports, Query Plan, Optimizer tuning, Stored Profiles, Hints, Storage optimization, CPU usage analysis, etc.
• DB2 9x Development and administration
• Experience in interacting with Business/Technology groups and analyzing business needs.
• Good understanding of OOA and OOD concepts and UML
• Excellent communication, interpersonal, analytical skills and strong ability to lead developer team as well as to be part of development team
• Excellent experience of Task Management and release/delivery management
• Experienced DBA with experience on RAC setup on Linux, AIX and Solaris.
• Implemented RMAN solution on various projects.
• Exposure to Linux administration and maintenance
• Writing complex Shell, Perl Script and automate routine database activities through CRONTAB
• Experience in PowerBuilder Ver. 6,7, 8, 9,10 with PFC

TECHNICAL SKILLS

Operating Systems Windows 9x/2000/NT/XP, UNIX, Solaris, Linux

Languages SQL, PL/SQL, Java, Advance Java C, C , Ruby, Shell Scripting. VC With MFC , SDK Win32 , Pro C , Pro COBOL

Databases Oracle 11gR1- R2, 10g/9x/8x/7x, MS SQL Server 2000/7.0/6.5, MS Access, MySQL, Sybase, Informics, HSQL, IBM-DB2 9.7

GUI Tools PowerBuilder 6, 7, 9, 10, VB 6, 7, Developer 2000, Crystal Reports 10.x, InfoMaker, Data Vision, Jasper Report.

Other Tools TOAD, SQL Loader, Schema Builder, PL/SQL Developer, Eclipse, Win CVS, ERWIN, PowerDesigner 15, Infomaker, App Modular, MS Project, Visio 2000, Together, Putty, MS Team Foundation Server, NaviCat, iReport, SQL Power Architect, JDeveloper, SQL Developer

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle DBA Developer

Responsibilities:

• Business analysis and preparing Requirement Specification
• Database Modeling and Designing. Create program specification for development team.
• Design and Development of various data manipulation packages for AFE module.
• Custom ETL scripts and operation using PL/SQL
• PL/SQL design and development
• Development DBA

Environment: Oracle 10g,Oracle 11g, Linux/AIX with TSM , Windows Vista, MS SQL Server, Jasper Reports, J2EE, Erwin 7.3

Confidential

Responsibilities:

• Provide guidelines on Database strategies and technical decision making
• Define the scope of development and use cases
• Define the database structure and database deployment policies
• Data Modeling and design using Aqua Studio.
• Oracle 11g RAC setup for 2 nodes for Ministry of Finance.

Environment: Oracle 11GR1, 11GR2, DB2 9.7, DB2 10, J2EE, MS SQL Server, MySQL, Aqua Studio.

Confidential

Sr. Data Architect / DBA

Responsibilities:

• Oracle RAC setup for multi-node, multi-location environment.
• Migrate Banking product databases to Oracle from DB2
• Set a methodology to migrate a DB2 database structure to any database using Power Designer Data Modeling tool.
• Written tool to generate very high volume of data for Performance test.
• Database performance tuning.
• Data Modeling and design
• Customization of Products as per individual client banks and implement/support them through set process.
• PL/SQL , design and write up of High level, Low level design documents
• ETL using Talend Open Studio
• Product deployment platform for database agnostic scripts.
• Development and Production DBA capabilities.
• Database Backup strategy definition and configuration using RMAN and DATA PUMP.
• Release management using JIRA, SVN and Proprietary Deployment tool S1 Deployment Manager.

Environment: Oracle 11GR1, 11GR2, DB2 9.7, DB2 10, J2EE, Actuate Reports, Erwin 5.

Confidential

Software Consultant

Responsibilities:

• Define the scope of development and use cases
• Write Requirement Specification and technical text specs
• Define the database structure and database deployment policies
• Data Modeling and design
• Oracle 11G Installation on Linux and AIX.
• Setup and Configuration of Oracle Golden Gate
• PL/SQL , design and write up of High level, Low level design documents

Environment: Oracle 11GR1, SQL Plus, PL/SQL, SQL Developer, J2EE. MySQl, HSQL, Berkeley Oracle Database

Confidential

Database Architect

Responsibilities:

• Translate business requirements into detailed specifications System requirement study and BRD preparation
• Design data models to solve complex data access and storage needs
• Participate in design reviews, while guiding the development staff in the development and implementation of the database Model and Data Architecture definition
• Writing HLD and LLD for PL/SQL, Java utility programs
• PL/SQL , design and write up of High level, Low level design documents
• Writing generic Database scripts for data loading / conversion
• Development co-ordination and resource management

Environment: Oracle 10G, SQL Plus, PL/SQL, J2EE with Ajax open source ZK framework

Confidential

Responsibilities

• Remodeling of Existing module to Oracle Platform from SQL Server 2000.
• Database programing using T-SQL and PL-SQL
• Leading team of Database and Front End Developers.

Environment: Oracle 10G, SQL Plus, PL/SQL,,SQL Reports, Java, SQL Server 2000, T-SQL.

Confidential

Team Leader

Responsibilities

• System study and product conceptualization
• Oracle Server Side programing in PL/SQL, Java Stored procedures and testing
• Billing Engine enhancement, new modules development using Pro C
• Front End Development as per the customization requirement from client
• Static and dynamic reports using PowerBuilder dynamic data window
• Onsite-Offshore development and delivery management
• Design and development utilities like Oracle dashboard Data Analyzer and data auditing framework
• WEBCARE WEB Based customer care and Invoice generation module. Summary and Detail invoice created using Jasper Report

Environment: Oracle 9i/10G, SQL Plus, PL/SQL, Pro-Cobol, mySQL, Pro C , Data Vision, Data Pipelining. SQL Reports. Sytrix Server

Confidential

Team Leader

Responsibilities

• Business Analysis and Use case definition Onsite at Toronto Canada
• Data Modeling, Database design Using Erwin 3.5.
• Product Prototyping
• Generic Framework definition J2EE
• XML parser based Database manipulation framework designed and developed
• PL/SQL technical specification creation and writing/ administrating the development
• Audit Framework using FLASHBACK QUERY and RLS based framework designed for role based data access control
• Database Administration
• Single point contact person for Product development
• Development, Program change, Delivery management
• Task estimation and delegation
• Usability Engineering
• Project Planning and development co-ordination
• Training to sub-ordinates
• 'Ireport' Jasper report

Environment: Oracle 10g/9i, SQL, PL/SQL, SQL Plus, Java, J2EE- Struts, Jasper Reports 10.x, Windows XP, Unix, Solaris, Linux, DRUL Rule Engine , jBoss Server, Apache Server. Dynamic JSP

Confidential

Team Leader

Responsibilities

• Oracle Back End Server Side design and development in form of PL/SQL
• PL/SQL tuning and creating various Database objects
• Team Management and release management. Used Visual Studio and TFS for version control and release management.
• Onsite-Offshore development and delivery management
• Database Administration
• Customization of product to parameterize the use cases
• Design and development utilities like Oracle dashboard Data Analyzer and data auditing framework
• Oracle Policies and Policy group definition. Implementation of row/column level access control

Environment: Oracle 9i/10G, SQL Plus, PL/SQL, Pro-Cobol, mySQL, Pro C , Data Vision, Data Pipelining. SQL Reports. Sytrix Server