PROFESSIONAL SUMMARY:

• Over Ten years of experience in IT Services industry with diversified fields of Database Design, Development, Maintenance, Migration, Process & Performance Improvement and Testing using various Large Scale Data Base Application Technologies like Oracle 9i/10g/11g, SQL, PL/SQL (Methods, Packages & Triggers) & SQL Performance tuning (Trace & TKPROF).
• Got Good hands on experience in DW ETL, Advanced PL/SQL, Developer 9i/10g/11g and UNIX Shell scripting and Familiar with DW ETL tool Informatica, BI Tool Microstratergy and Oracle Applications 11i Technical RICE components.
• Experience in Requirement Analysis of functional and business requirements understanding meetings with clients & documents. Implement client revisions and comments to the application design.
• Experience on Development DBA activities like logical and development aspects of database administration such as data model design and maintenance, DDL (data definition language) generation, SQL writing and tuning, coding stored procedures, collaborating with developers to help choose the most appropriate Oracle 10g/11g Features/functionality and other pre - production activities.
• Strong knowledge in Database Architecture and Data Model and proficient with Tools and Client in configuration & customization of Siebel Objects at multiple levels.
• Experience in Team management activities
• Participating in project start-up and coordinate with necessary personnel to assure successful project completion.
• Develop and implement processes to improve and increase project efficiency.
• Taking responsibility and accountable for delivering of client database solutions on time and within budget.
• Utilizing existing products and services where available and design custom processes and software where necessary by setting priorities, assure data integrity, and communicate project deadlines and status.
• Certificates:

SKILL:

Primary Skill category: Oracle: Core Tech, PL/SQL, Informatica & UNIX shell

Sub Skills: SQL\PLSQL, Forms, Reports

Secondary Skill category 1: Process Optimization, DB objects and SQL Performance Tuning

Secondary Skill 2: Web Services, Data Base Designing and DW - ETL concepts

Sub skills: Oracle Project Management

Project Acquired skills: Oracle SQL PLSQL D2K Forms Reports Oracle Apps Tech Unix Shell Scripting

Primary Domain Skill: IT, LIMS, Manufacturing, Technology, Refurbished marketing., Finance & Banking.

Trained Skills: Oracle9i SQL PLSQL Forms Reports Online App Dev

PROFESSIONAL EXPERIENCE:

Confidential, Raleigh, NC

Database Developer

Environment

Languages: SQL PL/SQL ADV PL/SQL SQL Performance Tuning, Informatica 9.1, Web services, Shell

Database: Oracle 10G, Confidential

Tools: TKPROF, PVCS, AWR and TOAD, Project Management, CVS

O/s: Windows 7 and UNIX

Responsibilities:

• Requirement Analysis of functional and business requirements understanding meetings with clients & documents.
• Creating the Technical Design Document based on the Functional Specs provided by Customer. Requirement Gathering, Solution Designing and development of functional requirements. Application post production support and bug fixing.
• Designing and Developing DB objects (procedures, functions, packages etc).
• Part of DB code review team to validate optimal design and code approach.
• Provided suggestions to team in designing complex tables and packages using Advanced PLSQL and Oracle 10g features.

Confidential

Systems Engineer

Environment

Languages: SQL PL/SQL ADV PL/SQL SQL Performance Tuning

Database: Oracle 10G

Tools: TKPROF, PVCS, Kintana and TOAD

O/s: Windows 7 and UNIX

Responsibilities:

• Requirement Analysis of functional and business requirements understanding meetings with clients & documents. Implement client revisions and comments to the application design. Onsite - Offshore Coordination/Status Review and meetings with the offshore Team.
• Creating the Technical Design Document based on the Functional Specs provided by Customer.
• Requirement Gathering, Solution Designing and development of functional requirements.
• Application post production support and bug fixing.
• Designing and Developing DB objects (procedures, functions, packages etc).
• Ensured that all team members adheres to the tech specific and client specific coding standards by reviewing the code to ensure better performance of project deliverables.
• Part of DB code review team to validate optimal design and code approach.
• Provided suggestions to team in designing complex tables and packages using Advanced PLSQL and Oracle 10g features.

Confidential

Project Lead

Environment

Languages: SQL PL/SQL SQL performance tuning and ADV PL/SQL

Database: Oracle 10G

Tools: TOAD, PVCS, KINTANA, TKPROF, QC

O/s: windows xp

Responsibilities:

• Identifying performance issues, Optimizing complex Queries and analyzing execution plans and TKPROF.
• Creating the Technical Design Document based on the Functional Specs provided by Customer for new enhancements.
• Designing and Developing DB objects (procedures, functions, packages etc).
• Database enhancements, Peer Reviews & Unit testing.

Confidential

Team Lead

Environment

Languages: SQL PL/SQL Adv PL/SQL SQL Performance Tuning

Database: Oracle

Tools: TOAD TKPROF PVCS

O/s: Windows 2K Professional

Responsibilities:

• Worked as Offshore lead for application developments like Phase 1A Core, Phase 1B RTA and Performance optimization, RTA is Core component of Phase 1B with complex business, in Core BE re-designed few programs to improvise the performance of VSOE programs. Lead a team of 3-4 members with proper guidance, allocated work to team members and monitored their work on regular basis and peer reviewing.
• Extensively worked on Performance Tuning of few critical oracle objects using TKPROF and Explain Plan.
• Planned delivery schedule for my track deliverables. Actively Participated in Transition activities for code deployment during the test cycles and Confidential .
• Regularly monitored test cycle defects and resolved them Provide Post Production Support after Confidential .
• Database objects design for the enhancement (change requests) and new requirements.
• Creating complex views in SQL and PL/SQL optimized programs. Creating the Technical Design Document based on the Functional Specs provided by Customer.

Confidential

Team Member

Environment

Languages: PL/SQL, SQL Perl

Database: Oracle, Myna DB(SAGE)

Tools: TOAD, SQL developer, CVS, Siebal, Bugzila

O/s: Windows NT LINUX

Responsibilities:

• Identifying performance issues, optimizing several ETL jobs (PL/SQL Packages) by analyzing execution plans and Defect fixing. Guided all the team members in their customizations, help them complete the deliverables within the given time lines and Peer Reviewing. Monitoring the SLA and non - SLA jobs. Requirement Gathering from users, Solution Designing and developing new Reports and Enhancing existing reports. Modifying the existing and creating new PL/SQL ETL packages for hourly, daily & weekly jobs to highly used EDWARD DW. Handle Ad-hoc requests and provide large data to the requester.
• Involved in Data Model design of enhancements, worked on ER diagram, generated table scripts generation.

Confidential

Team Member

Environment

Languages: PL/SQL, SQL

Database: Oracle 9i 10g

Tools: Forms 10g Reports 10g SQL developer Fiorano 6.0 TOAD

O/s: windows 2003 server,

Responsibilities:

• Extensively worked on Stock and Instrument module of SQL * LIMS Involved in Requirement analysis and preparing Solution Design for SP6. Bug Fixing and Identifying performance issues as a Team member of Enhancements team from off shore Activities done were coding and unit testing. Design and developing and customizing oracle forms & reports

Confidential

Team Member

Environment

Languages: SQL PL/SQL

Database: ORacle

Tools: SQL developer, Putty, APPWORX6.1, SQL Loader, Louts notes, UNIX server and Remedy.

O/s: Unix Windows NT

Responsibilities:

• Production support and Enhancements from off shore.
• Involved in Requirement analysis and preparing Solution Design Document.
• Created the Test plans for the reports which I have created.
• Other activities done were coding (oracle and shell scripting) and testing.
• Data Loading from IMS flat file to oracle data base using SQL Loader.
• Schedule the jobs using the APPWORX 6.1. Creating Forms and Discoverer reports.

Confidential

Team Member

Environment

Languages: PL/SQL, SQL

Database: ORacle

Tools: SQL developer, Putty, Crontab, SQL Loader, UNIX server and Remedy

O/s: Unix Windows NT

Responsibilities:

• Involved in Requirement analysis and preparing Solution Design Document.
• Created the Test plans for the reports which I have created.
• Other activities done were and testing.
• Data Loading from IMS flat file to oracle data base using SQL Loader.
• Creating Forms and Discoverer reports &Schedule the jobs using the CRONTAB.

Confidential

Team Member

Environment

Languages: SQL PL/SQL

Database: Oracle 9i

Tools: Putty, UNIX server, Remedy, TOAD

O/s: Windows NT Unix

Responsibilities:

• Requirement analysis and Prepared the solution design document.
• Design New Process flow (Diagram) and alter data base design
• Review and Pear changes to the solution design document and Test Plans
• Developed the Oracle scripts (Package) and UNIX shell scripts.

Confidential

Team Member

Environment

Languages: SQL PL/SQL

Database: ORacle

Tools: SQL developer, Putty, APPWORX Server, UNIX server and Remedy

O/s: Unix & Windows NT

Responsibilities:

• Involved in Requirement analysis and prepared Solution Design Document. Review and Pear changes to the solution design document and prepared Test Plans. Small Changes in database design and create DB links. Developed the Oracle scripts (Package) and UNIX shell scripts. Schedule the job using the APPWORX.