We provide IT Staff Augmentation Services!

Senior Pl/sql/powerbuilder Developer Resume

Troy, MI

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.

Hire Now