SUMMARY:

• Around 20 years of experience in Software Development mainly in the OLTP,OLAP areas and also as a applications DBA/core DBA . More than 20 years of experience in designing relational database design solutions using Oracle(8.x/9.x,10g,11g), Developer 2000(Forms6i/Reports6i,Developer suite 9i/10G), ORACLE Application server 10x, Pro*C, C, C++
• Experienced in performance tuning.
• Experienced in all phases of the Software Development Life cycle.
• Self Starter with excellent Analytical and Software Development skills, excellent written and verbal Communication skills, strong analytical and problem solving skills.
• AnalyzingReportingrequirements and translating them into data sourcing and modeling requirements including Dimensional & Normalized data models, Facts, Dimensions, Star Schemas, Snowflake Schemas, Operational Data Stores, etc.
• Good user liaison skills with experience in training and supporting end user and technical groups.
• Experience in maintaining large Data bases involving terabytes of data and hundreds of tables of containing millions of records
• Experience in providing Database Admin support both as Core DBA and application DBA such as backup, recovering and administering patches etc.

COMPUTER SKILLS:

OS: Windows 95,98, NT, 2000, XPUnix(HP/SCO),SUN EXADATA SOLARIS,Linux,,VAX/VMSRDBMS Oracle (Version 7.x, 8.x, 8i,9i,9i RAC,10G,11G,11G RAC)INGRES

FRONT END TOOLS: Developer 2000 (Version 1.2,2.1) Developer 6i,Developer 9i/10G suite

CASE TOOLS: Designer 2000 (Version 2.1) and Designer 6i

LANGUAGES: PL/SQL, Pro * C, C, C++, Shell scripting

TOOLS: /UTILITIES SQL*Navigator,PVCS,Toad,OAM .License ManagerRational Clear Quest, Rational Clear case, UTPsqlSubversion,Toad, Sql Developer, Microsoft TFS

APPLICATION SERVER: Oracle Application Server 10x

APPLICATIONS: Oracle E - Business Suite 11.5.10.2

PROFESSIONAL EXPERIENCE:

Senior DB Consultant

Confidential

Responsibilities:

• As a lead developer was involved in the Design and development of a Mortgage data exchange an Operational data store.
• Responsibilities includes profiling and analyzing the source hub datadata modeling activities, data mapping from source to target tables in the ODS and developing the necessary database such as Table,views,sequences and PL/SQL packages as a part of the ETL framework to extract, transform and load data.
• The development was done in Agile environment.
• Responsibilities included creating Packages,Stored procedures and Sql queries for data extraction and manipulation in a high volume transaction environment. Provided support for creation of new DB structures and implementing changes to existing Db structures such as tables and indexes.
• Was involved in trouble shooting performance related issues and regular maintenance related issues such as administering patches etc.
• The Environment included Oracle 11G, Toad,Pl/SQL,Windows XP,Unix

Senior DB Consultant

Confidential, San Francisco, CA

Responsibilities:

• Design and development of a web based Travel Tracking and Authorization system for Confidential .
• The objective of the application is for generating, maintaining and tracking Travel/Training related requests
• The application includes a work flow system to track a travel/training document at any given stage.
• The work flow process includes generating periodical email alerts and notifications .
• The web based application is built using Oracle forms 10G/Oracle Reports 10G and Oracle 10g IAS
• .Responsibilities included designing the various screen and report layouts, developing of the various forms based triggers,stored procedures,functions and db triggers

Team Lead

Confidential, Lewisville,TX

Responsibilities:

• As a senior developer/Team lead was involved in the design and development of Document generating engine for the various loan modification programs. Default IT services is typically involved in various loan modification programs for Home loans which reach the foreclosure stage.
• Under the Making home affordable programs these loan might qualify for one or more of the loan modification programs.
• The loans which are in this stage are modified and go through a Trail phase where the loan Recipients ability to repay the loan under the new program is studied before moving them to a final phase of the modification program.
• The various borrower details along with the payment details are extracted and sent to a servicing agency where they are processed further and sent to the individual clients
• The DOC Engine is a code generator which is fed by meta data for the various loan modification programs such as Agent Desktop 2 nd lien modification program etc. The code is generated in the form of PLSQL procedures which are the used to get the respective extracts and these extracts in the form of XML files are sender LLN the service agency who use these extracts to generate the respective loan documents and various followup letters which go along with each one of these programs. The development of the ENGINE was done in ORACLE 11G using Dynamic PLSQL and features such as Ref cursors,Collections, PLsql tables, Varrays etc
• As a senior database developer responsible for maintaining and enhancing the Central Texas Regional Mobility Authority Host software which handles the back office operations for Toll Collection and Account management. This includes modifications to the existing violation, revenue, and traffic reports, as well as performance fine tuning . In addition, was actively involved in the architecture of the MTA Bridges & Tunnels, Central Transaction Repository (CTR) project.
• As a lead reports architect was involved in the design, development and implementation of the Reports system as a part of Host application for the Rhode Island Toll Bridge Authority. The application was primarily developed using Flex Gui with Oracle DB stored procedures on the backend and Appache webserver as the middle tier. The development was using Eclipse IDE and within the Turbo Gears framework
• Working closely with the project management group in the preparation of schedule
• Project plans and deadlines.
• Preparation of conceptual, detailed and Technical Design documents
• Designing the Report layouts
• Designing the Flex interface for the reports
• Developing the stored procedures for the reports

Confidential, TX

Lead Consultant

Responsibilities:

• Designed ERD, creating entities and their relations using Designer 2000 V2.1.
• Transformed the entities and relations to table definitions with relations in the repository.
• Created constraints, sequences, synonyms, views, roles and users in the repository.
• Generated scripts for creating tables, constraints, synonyms, etc.
• Maintaining and monitoring table and index sizes and creation of additional extents for growth
• Data Migration and Conversion
• Created Oracle database objects (Triggers, Packages, and Tables).
• Created Database Stored procedures to validate and process data.
• Involved in performance tuning of queries using EXPLAIN PLAN and optimizing performance using indexes wherever appropriate
• Post development Maintenance
• DBA support

Environment: Windows NT, Digital/HP alpha server, VAX/VMS Oracle 7.x/8i, SQL,PL/SQL, SQL* NET, Oracle Designer 2000 V2.1, Oracle Developer 2000 V2.1 (Forms4.5, Reports 2.5, Visual C++), Autocad

Confidential, Portland, OR

Responsibilities:

• Designed ERD, creating entities and their relations using ORA*CASE Designer
• Maintenance /Support of the applications using ORACLE CASE TOOLS such as Designer, Generator
• Involved in transforming the entities and relations to table definitions with relations in the database
• Created constraints, sequences, synonyms, views, roles and users .
• Involved in assigning roles to users
• Generated scripts for creating tables, constraints, synonyms, etc.
• Created Oracle database objects (Triggers, Packages, and Tables).
• Created Database procedures to validate and process data
• Generated forms using and reports using ORACLE Case Generator
• DBA Support activities such as User Management, security management, performance fine tuning etc

Environment: Sun Solaris, Windows SQL,PL/SQL, Oracle case tools, forms3.0. report writter 1,1, PRO*C