SUMMARY:

• 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 Confidential
• Familiar with Testing Methods and Estimation techniques.
• Good Client Interfacing and Communication Skills.

TECHNICAL SUMMARY:

Development Tools: Appeon PowerBuilder 2019, 12.5/Classic/.NET, PL/SQL Developer 9.0, T-SQL

Internet: .Net, HTML, XML, WSDL, HTTP,SOAP, UDDI, JSP

Application Servers: EAServer 5.2, Oracle Application Server 10g

Class Libraries: PFC 10.5/ 7.0

Operating Systems: DOS, Windows 7/NT/2000, UNIX

Languages: Java, C, C++, COBOL, C#

RDBMS: ORACLE 15/11g/10g/9i, Sybase ASE 15/12, SQLServer2008,,DB2

Middleware: Netwise

Version Control: TFS, PVCS,Serena, Continuus, Starteam, Harvest, Clearcase, SVN

Case tools: Clearquest, Erwin 3.5, UML, Rapid SQL 7.5, TOAD 11.5, MS-Visio 2003

PROFESSIONAL EXPERIENCE:

Confidential

PowerBuilder Analyst/Programmer - Lead

Responsibilities:

• Production Support fixing defects In PowerBuilder Windows, Tab Controls and User Objects.
• Enhancements to the windows and PL/SQL packages.
• Development of Reports like UOCAVA, Absentee and Mail-In Voters,
• Migration of PB 12.5 application to Appeon PB 2019.

Environment: Appeon PB 2019, PowerBuilder 12.5, NET ORACLE 15, PL/SQL Developer 9.0, SVN

Confidential

PowerBuilder Analyst/Programmer - Lead

Responsibilities:

• Design and Development of TFL Forms related to Workers’ Compensation Board using TFL framework
• Consuming Web Services (WSDLs) using SOAP, XML from PB TFL framework.
• Fixing of defects related to the above new forms development.
• User training and Support of TFL Forms in QA.

Environment: PowerBuilder 12.5 Classic, PB.NET Sybase ASE 15, T-SQL, Rapid SQL 8.6

Confidential, Boston MA

PowerBuilder Analyst/Programmer - Lead

Responsibilities:

• Maintenance/Enhancements of Client Reinsurance Systems - Clientnem, ClientB&S and Client Treaty.
• Fixing of defects related to the above Client Reinsurance Systems in PB12.5 / SQL SERVER 2008.
• Working with Off Shore team for batch jobs scheduling and resolution of users issues
• User training and support of Client Reinsurance Systems
• Assisted in Various Upgrade Projects like Enterprise SVN, Batch Server and PPM.

Environment: PowerBuilder 12.5, SQL SERVER 2008/2012, Web Services, Enterprise SVN, PPM.

Confidential, Richmond, VA

PowerBuilder Consultant

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, Newark, DE

PowerBuilder Consultant

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, Boston, MA

PowerBuilder Consultant

Responsibilities:

• Modifications of Java /JSP 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: Java / JSP/ ASP/ PowerBuilder 12.5/.NET Sybase ASE 15, T-SQL, Oracle 11g, PL/SQL, TOAD 11.5

Confidential

PowerBuilder Developer - Lead

Responsibilities:

• Working with BAs for User Requirements and Tech Analysts for MMIS Functional Specifications.
• Enhancements to the OmnicaidSystem 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 Omnicaidsystem..

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

Confidential, Miami, FL

PowerBuilder Developer

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, Winston Salem, NC

PowerBuilder Developer

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, St Louis, MO

PowerBuilder Developer

Responsibilities:

• Development of PowerBuilder windows and related functionality for the Convert/Combine of items added to Confidential 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 Confidential 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.

Confidential, Pittsburgh, PA

PowerBuilder Developer

Responsibilities:

• Development of new PowerBuilder Tabpages like Customer Summary, Credibility, Claims, Retention and Trend incorporating Risk Rating for the enhanced Confidential
• Development of Stored Procedures and Functions in PL/SQL Packages to support the constantly changing business rules of Healthcare industry
• Production Support of the existing Confidential by resolving user issues, adding/modifying existing screens to add value to user experience.

Environment: PB 10.5, PFC, SQL, PL/SQL, Oracle 9i/10g Clearcase, Clearquest, Harvest, DomDoc, Oracle Application Server 10g

Confidential, Scranton, PA

PowerBuilder Developer

Responsibilities:

• Supporting the FiServPowerComp suite of products for Confidential by adding new windows/menus and all related functionality for insurance business.
• Working on a variety of Change Requests for Confidential . This product was customized for PA State by adding screens specific to state requirements.
• User Requirements Analysis and Preparation of Detailed FuncSpecs for Confidential Interfaces by meeting with users and studying other state systems which required interfacing with Confidential .

Environment: PB 10.5, PFC 6.0, SQL, PL/SQL, Starteam, Oracle 9i

Confidential, White Plains, NY

PowerBuilder Developer

Responsibilities:

• Analysis of the Broker Dealer business processes by studying existing system on mainframe and development of the functional specs from the business documents
• Enumeration and grouping of the various categories of accounts like Prime Broker, Principal Officers, Foreign Currency, Hedge Funds and development of the Erwin data model to represent the business process with referential integrity constraints.
• Encapsulation of all business rules in Stored Procedures and Database triggers on the Sybase back-end and development of the PowerBuilder windows with related functionality.

Environment: PB 10.0, PFC 6.0, SQL, Sybase 11, Rapid SQL, Erwin

Confidential, Woodbury, MN

PowerBuilder Developer

Responsibilities:

• Development of new PowerBuilder windows/menus and user objects related to enhancements required in the various modules of application with business logic in stored procedures and database triggers using Transact-SQL
• Development of EaServer components for business rules for having centralized business logic for ease of maintenance.
• Extensive use of PFC based framework objects by building a corporate layer of enhanced PFC objects for a rapid and rich development environment.

Environment: PB 9.0, PFC 6.0, SQL, EAServer 5.2, SQL SERVER 2005

Confidential, Los Angeles, CA

PowerBuilder Developer

Responsibilities:

• Working on a variety of maintenance and enhancements assignments like adding new windows/menus for change in state welfare rules
• Extensive use of PFC based framework and encapsulation of business rules in NVOs for application wide ease of use for extensibility and maintenance
• Coding of Remote Procedure Calls Programs on Unisys 2200 in COBOL for the heart of business logic was resident in COBOL programs
• Design of Data Windows linked with RPCs for Unisys database access

Environment: PB 5, PFC, SQL, PVCS, Unisys 2200, COBOL

Confidential, Lansing, MI

PowerBuilder Developer

Responsibilities:

• Migration of existing applications in PB 7 to PB 9 (and fine-tuning them using tools like Rapid SQL and DB Expert) and make them network deployable.
• Enhancements to existing systems like QuickQuote (a Quote provider program used by agents), Claims Review, Check Write and others.
• Adding new reports like Customer Enquiry, Agency Planning.
• Documenting the systems using MS-Visio tool.

Environment: PB 9.0, PFC 6.0, SQL, PL/SQL, PVCS 7.5, EAServer 5.2, ORACLE 9i, .Net, C#

Confidential, Elkridge, MD

PowerBuilder Developer

Responsibilities:

• Development of User Interface with TreeView, TabControl and DataWindow objects for Chessie using OO methodology
• Development of EaServer components for business rules
• Resolving Incidents related to testing of Statewide Chessie

Environment: PB 10.0, PFC 6.0, SQL, DB2, PL/SQL, Netwise, EAServer 5.2, ORACLE 9i, .Net