SUMMARY

• More than 11 years of experience in IT wif emphasis on Software Development involving wide areas of Software industry.
• Expertise in Oracle, Pro*C, Forms & Reports.
• Expertise in SQL Server & Reports.
• Excellent noledge of PL/SQL.
• Vast working experience in software development environment, wif focus on Backend Programming.
• Writing complex SQL for teh Back End Development requirements.
• Complex SQL scripting skills using advanced functions.
• Core noledge and experience on SQL for SQL* Reports, ETL.
• Top development skills include using Oracle PL/SQL to write Stored Procedures, Packages, and Triggers.
• Good noledge on Wrappers, Composite Data Types, Cursors and REF - Cursors.
• Writing complicated Oracle Forms and creation of customized Reports.
• Extensively used QUEST TOAD 7.6.
• Team player wif self driven analytical mind thriving on challenges and responsibilities
• Oracle SQL and PL/SQL package and procedure development (Oracle 9i/10g).
• Involved in teh full lifecycle from analysis and planning to development and deployment.
• Experience in technical support for teh testing and implementation effort.
• Experience designing and developing Oracle data models including performance tuning.
• Expertise in basic database administration skills/experience (procedures for change control, test and production release.
• Participated in customer definition and design meetings to gather requirements and functional specifications.
• Experience in Database modeling and design experience.
• Experience developing technical documentation.
• Knowledge of best practices in teh areas of application design, performance, scalability and maintainability.
• Expertise in Unix shell scripting to include Oracle SQL*LOADER.
• Knowledge of Financial-domain and Telecom-domain Workflow.

TECHNICAL SKILLS

Databases: ORACLE 10g/9i/8i

Tools: and Utilities: SQL*Loader, SQLNavigator, AutoSys, TOAD

Languages: SQL, PL/SQL, C, C++, UNIX shell scripts

Operating Systems: Windows NT/XP/200/2003, Linux, Sun-Solaris

Version Control: Visual Source Safe, Perforce, PVCS, CVS. Clear Case

Others: Object Oriented Designing Methodology and RDBMS concepts

PROFESSIONAL EXPERIENCE

Confidential, Tallahassee, FL

Senior PL/SQL Developer

Responsibilities:

• Writing code to extract teh data from production.
• Write, debug, diagram, create flowcharts, code, and document programs.
• Responsible for teh technical planning, design, programming, implementation, documentation, and maintenance of systems application software.
• Writing adhoc Queries
• Running UNIX Batch Jobs
• Extensively used TOAD and PLSQL Developer.
• Top development skills include using Oracle PL/SQL to write Stored Procedures, Packages, and Triggers.
• Usage of various Built-In PL/SQL packages based on requirements.
• Working on Enhancements using Oracle, Pl/SQL.
• Usage of various Built-In PL/SQL packages based on requirements.
• Environment: Oracle 10g, SQL Plus, SQL* Navigator, Embarcadero RAPID SQL, SQL*Loader, Oracle Utilities.

Confidential, Cleveland, OH

Senior PL/SQL Developer

Responsibilities:

• Writing code to extract teh data from production.
• Writing transformations based on teh required to load teh data to IWMS
• Write, debug, diagram, create flowcharts, code, and document programs.
• Responsible for teh technical planning, design, programming, implementation, documentation, and maintenance of systems application software.
• Writing adhoc Queries
• Loading flat files to SQL Server and writing transformations as per teh Business requirement and Loading data to csv files.
• Extensively used Embarcadero ORACLE SQL Developer and PLSQL Developer.
• Top development skills include using Oracle PL/SQL to write Stored Procedures, Packages, and Triggers.
• Usage of various Built-In PL/SQL packages based on requirements.
• Working on Enhancements using Oracle, Pl/SQL.
• Environment: Oracle 10g, SQL Plus, SQL* Navigator, Embarcadero RAPID SQL, SQL*Loader, Oracle Utilities.

Confidential, Winston Salem, NC

Senior PL/SQL Developer

Responsibilities:

• Developed teh time critical data loading layer, to load teh data to staging tables.
• Interacting wif Users to resolve teh issues related to SPS
• Write, debug, diagram, create flowcharts, code, and document programs.
• Responsible for teh technical planning, design, programming, implementation, documentation, and maintenance of systems application software.
• Writing adhoc Queries
• Production Support for SPS.
• Extensively used Embarcadero RAPID SQL.
• Top development skills include using Oracle PL/SQL to write Stored Procedures, Packages, and Triggers.
• Usage of various Built-In PL/SQL packages based on requirements. from scratch, based on User Requirement using C and KSH.
• Running UNIX Batch Jobs
• Working on Enhancements using Oracle, Pl/SQL.

Environment: Oracle 10g, SQL Plus, SQL* Navigator, Embarcadero RAPID SQL, SQL*Loader, Oracle Utilities.

Confidential, Boston, MA

Production Support Module Lead

Responsibilities:

• Handling all types of Production issues.
• Interacting wif Users
• Write, debug, diagram, create flowcharts, code, and document programs.
• Responsible for teh technical planning, design, programming, implementation, documentation, and maintenance of systems application software.
• Writing adhoc Queries
• Handling all types of Environmental issues.
• Administrating Changes made in Network, Mainframe, Winnt, Firewall etc are done by Zero Downtime plan, like having a backup or temporary resource to manage teh downtime as ZDT.
• Extensively used QUEST TOAD.
• Top development skills include using Oracle PL/SQL to write Stored Procedures, Packages, and Triggers.
• Prepared Test Cases based on Test Plan for Unit Testing, System Testing, End to End Testing and UAT support Testing.
• Usage of various Built-In PL/SQL packages based on requirements.
• Developing Unix Shell Scripts from scratch, based on User Requirement using C and KSH.
• Running UNIX Batch Jobs
• Working on Enhancements using Oracle, Pl/SQL, UNIX
• Working on Post Mortems.
• Coordinating wif Teams for teh patching events.
• Extensively worked on Event Plan creation,Event Notifications and followup,Environment Notifications,Project support,Incident management,change requests,Process improvements.
• Support Disaster Recovery testing.

Environment: Oracle 10g/9i, SQL+ Plus, SQL* Navigator, TOAD, SQL*Loader, Oracle Utilities, HP Unix

Confidential, Quincy, MA

Senior PL/SQL Developer

Responsibilities:

• Designed and developed teh time critical data loading layer, to read data from various flat files and load teh data into teh liquidity schema.
• Interacting wif Users
• Write, debug, diagram, create flowcharts, code, and document programs.
• Responsible for teh technical planning, design, programming, implementation, documentation, and maintenance of systems application software.
• Writing adhoc Queries
• Production Support for Charles River Development IMS.
• Loading and monitoring POC (proof of concepts) Loads.
• Extensively used QUEST TOAD.
• Top development skills include using Oracle PL/SQL to write Stored Procedures, Packages, and Triggers.
• Prepared Test Cases based on Test Plan for Unit Testing, System Testing, End to End Testing and UAT support Testing.
• Usage of various Built-In PL/SQL packages based on requirements.
• Developing Unix Shell Scripts from scratch, based on User Requirement using C and KSH.
• Running UNIX Batch Jobs
• Working on Enhancements using Oracle, Pl/SQL, UNIX
• Support Disaster Recovery testing.

Environment: Oracle 10g/9i, SQL+ Plus, SQL* Navigator, TOAD, SQL*Loader, Oracle Utilities, HP Unix

Confidential, Plano, TX

Senior PL/SQL Developer

Responsibilities:

• Writing complex SQL for teh Back End Development requirements.
• Complex SQL scripting skills using advanced functions.
• Core noledge and experience on SQL for SQL* Reports.
• Top development skills include using Oracle PL/SQL to write Stored Procedures, Packages, and Triggers.
• Usage of various Built-In PL/SQL packages based on requirements.
• Good noledge on Wrappers, Composite Data Types, Cursors and REF-Cursors.
• Writing complicated PRO*C Programs as per teh Requirement.
• Writing complicated Oracle Forms and creation of customized Reports.
• Prepared Test Cases based on Test Plan for Unit Testing, System Testing, End to End Testing and UAT support Testing.
• Developing Unix Shell Scripts from scratch, based on User Requirement using C and KSH.
• Running UNIX Batch Jobs

Environment: HP UNIX (Shell Scripting) wif Oracle 10G & PL/SQL, Oracle Reports, Clear Case, Quality Centre 9.0, Citrix Neighborhood, VBA (for Automatic Report Generation tool)

Confidential, Hartford, CT

Senior PL/SQL Developer

Responsibilities:

• Writing complex SQL for teh Back End Development requirements.
• Complex SQL scripting skills using advanced functions.
• Core noledge and experience on SQL for SQL* Reports.
• Top development skills include using Oracle PL/SQL to write Stored Procedures, Packages, and Triggers.
• Usage of various Built-In PL/SQL packages based on requirements.
• Good noledge on Wrappers, Composite Data Types, Cursors and REF-Cursors.
• Writing complicated PRO*C Programs as per teh Requirement.
• Writing complicated Oracle Forms and creation of customized Reports.
• Prepared Test Cases based on Test Plan for Unit Testing, System Testing, End to End Testing and UAT support Testing.
• Developing Unix Shell Scripts from scratch, based on User Requirement using C and KSH.
• Running UNIX Batch Jobs

Environment: HP UNIX (Shell Scripting) wif Oracle 10G & PL/SQL, Oracle Reports, Clear Case, Quality Centre 9.0, Citrix Neighborhood, ITG (In-house defect logging tool),Autos ( Job scheduling),VBA (for Automatic Report Generation tool for Insurance Agents)

Confidential, Dublin, OH

Senior PL/SQL Developer

Responsibilities:

• Writing complex SQL for teh Back End Development requirements.
• Complex SQL scripting skills using advanced functions.
• Core noledge and experience on SQL for SQL* Reports.
• Top development skills include using Oracle PL/SQL to write Stored Procedures, Packages, and Triggers.
• Usage of various Built-In PL/SQL packages based on requirements.
• Good noledge on Wrappers, Composite Data Types, Cursors and REF-Cursors.
• Developing Unix Shell Scripts based on User Requirement.
• Writing complicated Oracle Forms and creation of customized Reports.
• Unit Testing

Environment: Oracle 9I, Power Builder, UNIX, Win/NT, 2000, PL/SQL, Remote Desk Top, TOAD, PVCS Dimensions 9.0.

Confidential, Denver, CO

PL/SQL Developer

Responsibilities:

• Analyzing teh Requirement
• Writing complex SQL for teh Back End Development requirements.
• Complex SQL scripting skills using advanced functions.
• Core noledge and experience on SQL for SQL* Reports.
• Top development skills include using Oracle PL/SQL to write Stored Procedures, Packages, and Triggers.
• Usage of various Built-In PL/SQL packages based on requirements.
• Good noledge on Wrappers, Composite Data Types, Cursors and REF-Cursors.
• Writing complicated Oracle Forms and creation of customized Reports.
• Developing Unix Shell Scripts based on User Requirement.

Environment: Oracle 9I, Power Builder, UNIX, Win/NT, 2000, PL/SQL, Remote Desk Top, TOAD, PVCS Dimensions 9.0.

Confidential, Houston, TX

PL/SQL Developer

Responsibilities:

• Writing complex SQL for teh Back End Development requirements.
• Complex SQL scripting skills using advanced functions.
• Core noledge and experience on SQL for SQL* Reports.
• Top development skills include using Oracle PL/SQL to write Stored Procedures, Packages, and Triggers.
• Usage of various Built-In PL/SQL packages based on requirements.
• Good noledge on Wrappers, Composite Data Types, Cursors and REF-Cursors.
• Writing complicated Oracle Forms and creation of customized Reports.
• Developing Unix Shell Scripts based on User Requirement.
• Extensively used Oracle Forms and Reports.

Environment: Embedded Visual Basic 5.0, Oracle 7.3, Jini.

Confidential 

PL/SQL Developer

Responsibilities:

• Writing complex SQL for teh Back End Development requirements.
• Complex SQL scripting skills using advanced functions.
• Core noledge and experience on SQL for SQL* Reports.
• Top development skills include using Oracle PL/SQL to write Stored Procedures, Packages, and Triggers.
• Usage of various Built-In PL/SQL packages based on requirements.
• Good noledge on Wrappers, Composite Data Types, Cursors and REF-Cursors.
• Writing complicated Oracle Forms and creation of customized Reports.
• Extensively used Oracle Forms and Reports.
• Performed Manual Testing for multiple releases
• Performed Regression Testing of teh overall application to ensure end-to-end usability
• Performed System and Functional Testing for Control Data and Functional features
• Product Installation

Environment: Visual Basic, Oracle 7.2.3, Windows NT,

Confidential

PL/SQL Developer

Responsibilities:

• Writing complex SQL for teh Back End Development requirements.
• Complex SQL scripting skills using advanced functions.
• Core noledge and experience on SQL for SQL* Reports.
• Top development skills include using Oracle PL/SQL to write Stored Procedures, Packages, and Triggers.
• Extensively used Oracle Forms and Reports.
• Usage of various Built-In PL/SQL packages based on requirements.
• Good noledge on Wrappers, Composite Data Types, Cursors and REF-Cursors.
• Writing complicated Oracle Forms and creation of customized Reports.

Environment: Visual Basic, Oracle 7.2.3, UNIX, Manual Testing.