SQL Developer Resume Profile

Major Strengths:

Strong technical experience in Client/Server PowerBuilder/PL/SQL, Oracle 11g/10g/9i and Sybase 12.5/11.
Extensive experience in User Requirements Analysis and Functional Specifications preparation.
Good in Design and Development of System using AGILE Software Development.
Team-Lead, Project Planning and Tracking full SDLC experience.
Architecting Solutions adhering to high quality standards SEI-CMM 5.
Familiar with Testing Methods and Estimation techniques.
Good Client Interfacing and Communication Skills.

Technical Summary:

Development Tools: PowerBuilder 12.5/Classic/.NET/11.5/10.5/9, PL/SQL Developer 9.0
Internet: .Net, HTML, XML, J2EE
Application Servers: EAServer 5.2, Oracle Application Server 10g
Class Libraries: PFC 10.5/ 7.0
Operating Systems: DOS, Windows 95/98/NT/2000, UNIX
Languages: Java, C, C , COBOL , C
RDBMS: ORACLE 11g/10g/9i, Sybase ASE 15/12, SQLServer 2005,DB2
Middleware: Netwise
Version Control: PVCS, Serena, Continuus, Starteam, Harvest, Clearcase
Case tools: Clearquest, Erwin 3.5, UML, Rapid SQL 7.5, TOAD 11.5, MS-Visio 2003

Professional Experience:

Confidential

Responsibilities:

Enhancements to the ADVANTAGE Revenue System by developing new windows/menus and user objects.
Resolving of defects related to various aspects of tax-returns filing like Penalty, Interest, Refund etc..
User training and support in various modules of Advantage Revenue System

Environment Oracle 11g, PowerBuilder 12.5, PL/SQL, Oracle SQL, PVCS, Lotus Notes 6.5

Confidential

Responsibilities:

Coordination with Business and Design teams for User Requirements Specifications.
Design of PowerBuilder Programs Specifications for Development team.
Development of new PowerBuilder Tabpages, NVOs to support new functionality.
Co-ordination with software team for timely and quality deliverables.

Environment: Oracle 11g, PowerBuilder 12.5, PowerScript, Oracle SQL Developer v3.1, Clearcase v7.1, MS-Visio 2010

Confidential

Responsibilities:

Modifications of PowerBuilder windows/menus and user objects related to enhancements.
Maintenance of Stored Procedures in Sybase to support applications like Fixed Income Pricing, Fixed Income Settlement and Enrichment, Fixed Income Broker Manager.
Production support of above applications with respect to issues and bug-fixes.

Environment: PowerBuilder 12.5/.NET Sybase ASE 15, T-SQL, Oracle 11g, PL/SQL, TOAD 11.5

Confidential

Responsibilities:

Working with BAs for User Requirements and Tech Analysts for MMIS Functional Specifications.
Enhancements to the Omnicaid System by developing new tabpages and user objects on various windows to support the complex requirements of changing business rules.
Maintenance of Stored Procedures and Database Triggers to support the ever changing user needs.
Production Support for bug fixes to Omnicaid system..

Environment: PB Classic/.NET/11.5, SQL, Oracle 11g, PL/SQL, DB2, J2EE

Confidential

Responsibilities:

Preparation of Detailed Functional Specifications from User Requirements.
Enhancements to the Resort Solutions System by adding new features on the Windows/ UserObjects/ Tabpages to support new functionality
Adding new Stored Procedures and Database Triggers to support the ever-changing business rules for the enhanced Resort Solutions package.

Environment: PB 12.01, PFC 10.5, SQL, Oracle 11g, PL/SQL, TOAD 11.5

Confidential

Responsibilities:

Worked on a migration project to migrate a Consolidated Information System from DB2 database to SQL Server 2005 database. Changing the PowerBuilder DataWindow SQL and Embedded SQL from DB2 to SQL Server.
Enhancements to the Product Data Management System by modifying the PL/SQL Packages , Stored Procedures to add new functionality and extend interfaces in XML maintained on back-end of Data Integration Server to other applications
Maintain existing systems like Consolidated Information System which handles all kinds of Access Requests of organization by enhancing PowerBuilder code, Laboratory Information Management System which takes care of Quality Assurance and R D by adding new functions in the proprietary software.

Environment: PB 11.5, SQL, Oracle 11g, PL/SQL, SQL SERVER 2005, DB2, Embarcadero Rapid SQL 7.3.2, Visual Studio 2005, .NET

Confidential

Responsibilities:

Development of PowerBuilder windows and related functionality for the Convert/Combine of items added to EMPRV Material Management module. The new software module developed in PB/Sybase helped in maintaining optimum inventory levels across all depots resulting in huge savings.
Production Support of incidents related to EMPRV like user access to specific screens or application crash errors or inability to perform certain functions on materials.
Co-ordination with QA team for successful implementation of new modules by creating test cases, user training documents and maintaining the QA database.

Environment: PB 11.5/10.0, PFC 8.0, SQL, Sybase 12.5, Cast SQL Builder 6.3, SQL SERVER 2005.