SUMMARY

• 9 years of diverse experience in Information Technology in Design, Development and Maintenance of Banking and Government Software Application needs.
• Excellent conceptual and working knowledge of PowerBuilder, Oracle, Sybase, PowerBuilder Foundation Classes, SQL Servers.
• Expertise in design and development of application in relational database and client server environment using PowerBuilder 7.0/8.0/9.0/10.0 ,10.5,11.0/12.5 Oracle 8.x/9i, 10g SQL, PL/SQL,MS SQL*PLUS, Toad.
• Developed the application using Object Oriented techniques (Encapsulation, Inheritance, and Polymorphism).
• Experience integrating third party tools, OCX’s or OLE objects into PowerBuilder applications.
• Strong programming experience in creating User Objects in PowerBuilder.
• Experienced in database connection using .ini file.
• Strong programming skills in DataWindow and use of DataWindow.
• Expertise in debugging skills using PB Trace file and Just in time debug.
• Used procedures, cursors, functions in PB scripts.
• Good Knowledge in Sybase
• Strong programming experience in .Net technologies
• Expertise in applying security using PFC objects.
• Strong programming experience in creating stored procedures, functions, packages, database triggers and other database objects using SQL and PL/SQL.
• Used Power Designer to develop physical database model.
• Knowledge in Test Scripts and Test Cases to perform Unit testing, System Testing and Load testing. Seamlessly migrating Code from Development to Testing, UAT and Production.
• Excellent analytical and communication skills required to effectively work in the field of applications development and maintenance.
• Very Good at Understanding Integration Technologies and Domains and work flow.

TECHNICAL SKILLS

Tools: PowerBuilder 7/8/9/10/11/12, PowerBuilder Foundation Classes Visual Basic

Languages: C, C#, .Net, SQL, SQL*PLUS, PL/SQL, Shell Scripts

Tools: /Editors: Toad, SQL developer, UNIX, Edit plus, Documentum

Servers: UNIX servers

RDBMS: Oracle 10g/9i/8.x/7.x,Sybase,M,MSSQL

Operating System: Windows XP/2000/NT/98, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Troy, MI

Senior PL/SQL/PowerBuilder developer

Responsibilities:

• Engaged with clients in North America and Latin America to gather the requirements for Accounts Management, Instrument data, Common Data and Client due diligence systems
• Prepared Functional Specification Document and Technical Specification Document for the requirements
• Expertise in data modeling, designed and developed conceptual, logical and physical design, ER diagram and Normalized the tables structures for the new applications
• Co - ordinated with various stakeholders and developed Accounts management system using PowerBuilder, MS SQL that were running in Winodows servers
• Used PowerBuilder, Oracle and Unix in Common data and instrument data systems that loads data from Bloomberg, Reuters, s&p and various external systems and centralize critical trading data
• Expertise in using various Power builder foundation classes and standards
• Used various types of data windows such as freeform, tabular, grid, Label and Crosstab to capture data in various screens and generate reports
• Used multiple transaction objects to connect with various data sources to pull the data and used it in enterprise system.
• Effectively used ASP.NET intrinsic state management functionality to store application-specific, session-specific, page-specific and user-specific information between page requests.
• Effectively used ASP.NET security infrastructure for authenticating and authorizing user access as well as performing other security related tasks using C#.NET.
• Managed authentication using ASP.NET forms authentication.
• Managed authorization using windows groups and using ASP.NET roles.
• Led the Oracle migration of IB core systems and ensured the seamless migration of more than 20 applications and 100+ sub-systems that involved multiple teams and 500+ users
• Developed the local database using Power builder data pipe object to transfer data to downstream systems located in Hong Kong, Latin America
• Expertise in using Data Windows, Windows, User objects and transaction objects and developed applications in PowerBuilder.
• Developed test plans, and various test cases for the applications developed
• Performed Unit, Integration and System testing for all the application deliverables and delivered high quality products
• Co-ordinated User Acceptance testing for the applications and ensured successful delivery
• Writing Stored procedures, Packages, Views, Cursors, Functions and triggers using MSSQL
• Designed table structure and coded scripts to create tables, indexes, views, sequence, synonyms and database triggers.
• Maintained the version and source control for various applications using VSS
• Improved IT systems stability to 100% by collaborating with operations and business users to identify root cause for recurring issues and providing effective solutions
• Coordinated with stakeholders across businesses and analyzed and optimized production release process and that improved release efficiency by 25%
• Co-ordinated with clients for the onsite implementation for the applications and trained the users on the new system

Environment: PowerBuilder 9.0/10.0/11/12.5 , MS SQL, Sybase, UNIX.

Confidential, Troy, MI

Senior PL/SQL PowerBuilder Developer

Responsibilities:

• Engaged with clients to gather the requirements for Inventory and Warehouse management system, and shipping systems, Integrated demand management system
• Worked on the end to end development and implementation of PowerBuilder applications provided post implementation support as well
• Involved in all aspects of SDLC such as requirement gathering and business analysis, development, testing
• Prepared Functional Specification and Technical Specification Document for the requirements
• Designed and developed conceptual, logical and physical design, ER diagram and Normalized the tables structures for the new applications
• Expertise in using DataWindows, Windows, User objects and transaction objects and developed applications in PowerBuilder.
• Developed test plans, and various test cases for the applications developed
• Performed Unit, Integration and System testing for all the application deliverables and delivered high quality products
• Co-ordinated with users and conducted User Acceptance testing for the applications
• Ensured the seamless operation for the clients and managed the support for applications
• Written Stored procedures, Packages, Views, Cursors, Functions and triggers using SQL & PL/SQL
• Designed table structure and coded scripts to create tables, indexes, views, sequence, synonyms and database triggers.
• Maintained the version and source control for various applications using VSS
• Supported the critical production issues with in the systems and provided quick and effective solutions
• Co-ordinated with clients for the onsite implementation for the applications and trained the users on the new functionalities
• Conducted code reviews, Internal and External quality audit for the deliveries from offshore team

Environment: PowerBuilder 8.0, 9.0, 11.0, PL/SQL, Oracle 9i, 10g, UNIX.

Confidential

SeniorPL/SQL Application developer

Responsibilities:

• Led the team of 5 in managing and maintaining the applications for Underwriting, Risk management, Claims Systems and provided end to end support
• Developed apps using PowerBuilder, Oracle and UNIX scripts to schedule the weekly and daily jobs and process the files from various systems and feed into centralized CLAIMS database
• Developed data feed applications for clients information system using PowerBuilder, Sybase and UNIX that fed the data into the centralized Enterprise system in United states
• Used multiple transaction objects in a single application and effective developed application seamless transfer of data from systems in UK to systems in USA.
• Developed a reconciliation tool using PowerBuilder, Oracle that reduced the processing time for requests by 80%
• Effectively used PowerBuilder objects and coding standards to develop application
• Developed applications that using PowerBuilder Rich Text Edit control and generate various formats of reports for the customers
• Involved in all aspects of SDLC such as requirement gathering and business analysis, development, testing
• Prepared Functional Specification Document and Technical Specification Document for various requirements.
• Expertise in using DataWindows, Windows, User objects and transaction objects and developed applications in PowerBuilder.
• Developed test plans, and various test cases for the applications developed
• Performed Unit, Integration and System testing for all the application deliverables and delivered high quality products
• Co-ordinated with users and conducted User Acceptance testing for the applications
• Ensured the seamless operation for the clients and managed the support for four application
• Written Stored procedures, Packages, Views, Cursors, Functions and triggers using SQL & PL/SQL that for generating various types of reports and data feeds and weekly jobs
• Designed table structure and coded scripts to create tables, indexes, views, sequence, synonyms and database triggers.
• Used explain plan and other stats to improve the performance database queries and procedures and created constraints as per outcomes
• Maintained the version and source control for various applications using VSS
• Coordinated with customers, operations and various team members to provide support and effective resolved all the issues
• Planned and implemented the applications and provided training for the end users of the system and provided post implementation support
• Conducted code reviews, Internal and External quality audit and ensured effective use of quality assurance in the project

Environment: PowerBuilder 6.5/7.0/8.0/9.0/11.0 , Oracle 9i/10g, Sybase, UNIX, Windows2000/XP.