SUMMARY:

• 9+ years of IT experience as a Power Builder developer, System Analysis/Design, Coding, Unit Testing, Testing, Implementation, Maintenance and enhancement of Software applications.
• Strong knowledge in Business Requirements Analysis, Application Design, Data Modeling and Database business systems in Various domains using PowerBuilder, Oracle, MS SQL Server, Sybase, Unified Modeling Language, Rational Rose, C on Windows 2000, XP, Windows NT, Windows98, Windows95, Unix, Vax/ Vms, OS/2 platforms.
• Extensive experience in designing and developing Client Server Applications.
• Good working knowledge on Power Builder, Oracle, Visual Basic, Sql Server.
• Strong Analytical and Technical Skills and thorough knowledge of Software Development Life Cycle (SDLC).
• Knowledge of standard languages, coding methods, operations requirements, company coding standards and quality requirements.
• Strong expertise in user interface, specification development and troubleshooting
• Strong in all aspects application development process.
• Strong abilities in Data Modeling, Views, Normalization, Stored Procedures, Triggers and Functions using Oracle 8.0/9i
• Knowledge in Application Migrations from PB 6.5 to PB 7.0, Data Migration.
• Experience in Application Testing, User Documentation and User Training, Production support.
• Experience in Test Scripts and Test Cases to perform Unit testing, System Testing and Load testing, Base line testing. Seamlessly migrated the Code from Development to Testing, UAT and Production.
• Knowledge of PowerBuilder foundation classes.
• Self - motivated, excellent written/verbal communication, leadership and team work skills.
• Ability to Mentor and desire to achieve the target.
• Excellent Documentation Skill and Knowledge Sharing among Team.
• Have worked on domains like Telecom, Financial, General Insurance, Child Welfare and Health care.

TECHNICAL SKILLS:

Operating Systems: Windows98/NT/2000 & XP, UNIX.

GUI: Power Builder 7/9/10.5/11.2, Visual Studio

Databases: Oracle 8x/ 9i/ 10g, Sybase, SQL Server 2000/ 2005, MS Access, IBM DB2

Languages: C, C++, Visual Basic 6.0, VB.NET, C#, SQL, PL/SQL, ASP.NET 1.1/2.0

Reporting Tools: Data Reports, Crystal Reports 11,10.

Version Control: Work bench, Harvest, PVCS

Tools: Documentation, Testing, Version Ctrl and Designs Documentum, Test Director, Microsoft Visio 2003, Rational Rose

PROFESSIONAL EXPERIENCE:

Confidential

Power Builder Developer/ System Analyst

Responsibilities:

• Provide technical guidance and solutions to client’s team on PowerBuilder 10.5/12.0 (with PFC), Oracle, and PL/SQL.
• Involved in the migration from PowerBuilder 10.5 to 12, new CCSP module design /development / implementation and support, support enhancements and resolve issues.
• Prepared the Functional Specification Document and the Technical Specification Document for the Enhancements.
• Worked extensively on Enhancement on CCSP module of the Project.
• Coding, unit testing, Preparing Mod specs and System test scripts document.
• Involved in client-specific modifications.
• Created complex Stored Procedures, Views, Triggers and Indexes, implementing performance driven queries with focus on asynchronous data access.

Environment: Power Builder 10.5/12.0, Oracle 10g and PL/SQL, Windows XP, XML, CVS Suite.

Confidential, New York

Sr. Power Builder Developer

Responsibilities:

• Responsible for Accounts, Purchase/Sales and Stores modules.
• Design and develop the applications for offline data import/export.
• Architecture and design of various reusable components to be plugged into every layers of enterprise architecture.
• Involved in the migration of PowerBuilder 9.0 to PowerBuilder 11.0
• Involved in maintenance, development using PowerBuilder, PFC Services, and Object oriented techniques using Inheritance, Polymorphism and Encapsulation.
• Creation and enhancements of design documents based on use case specifications
• Involved in analysis, design, development and support of application
• Involved in client-specific modifications.
• Creating SQL extended stored procedures.
• Coded the Transact SQL Queries needed by the application
• I was involved in all aspects of SDLC.
• Worked on Designing Screens and GUI.
• Developed the application using Object Oriented techniques (Encapsulation, Inheritance, and Polymorphism).
• Involved in development using PowerBuilder, OOPS Techniques using Inheritance, Polymorphism and Encapsulation.
• Unit Testing, Testing of the application.
• Involved in creating Unit Test Cases, Unit testing
• Build and release management
• Peer reviews.
• Member of project review board to analyze the future enhancements.
• Responsible for Communication and coordination with other departments such as DBA, Tech. Arch., Business users etc.
• Created complex Stored Procedures, Views, Triggers and Indexes, implementing performance driven queries with focus on asynchronous data access.

Environment: Power Builder 9.0/11.0, Windows XP, HTML, PHP, Test Director, Documentum, .Net C# 2.0, Oracle 8i/9i, PL/SQL, Adaptive Server Enterprise Version 12.0/15 .

Confidential, MD

Sr. Power Builder Developer

Responsibilities:

• Involved in the design and development of the user entry screens, menus and major reports in Power builder 10.5.
• Extensively involved in the migration of PowerBuilder 10.5 to PowerBuilder 11.0
• Understanding business requirements and preparing Business Requirement Design Document (DSD).
• Prepared the Functional Specification Document and the Technical Specification Document (Pseudo code).
• Preparing the SQL Queries for testing the Database change in the various tables in the database.
• Writing various Application scenarios for testing the functional part of the application.
• Unit testing and System Integration Testing (SIT) for the application, Base line testing.
• Coded the SQL Queries needed by the application.
• Coordinating team members in terms of functional, technical and logical assistance to resolve the issues reported from customer.
• Analyzing the nature of issues and giving the rapid and appropriate solutions for show stopper issues.
• Involved in Production support.
• Involved in the Designing, Migration, Analysis and Estimations of the requirements

Environment: Power Builder 10.5/11.2, IBM DB2 8.19, EA Server, PVCS, Test Director.

Confidential, Atlanta, GA

Sr. Power Builder Developer/ Functional Lead

Responsibilities:

• Developed the user entry screen, menus and reports in PowerBuilder 10.5 by using UML (OOAD) methods.
• Understanding business requirements and preparing Business Requirement Document.
• Prepared the Functional Specification Document and the Technical Specification Document.
• Unit testing and System Integration Testing (SIT) for the application, Base line testing.
• Coded the SQL Queries needed by the application.
• Worked as a team lead managing a team of 2 members.
• Worked extensively on Enhancement on finance module of the Project.
• Coordinating team members in terms of functional, technical and logical assistance to resolve the issues reported from customer.
• Analyzing the nature of issues and giving the rapid and appropriate solutions for show stopper issues.
• Have worked on PFC’s.
• Provide support for the production.
• Involved in the Designing, Migration, Analysis and Estimations of the requirements
• Involved in database design for Sallie Mae Project.
• Designed and Developed Win Forms for the application.
• Worked on HTML, Designing Screens and GUI.

Environment: Power Builder 9.0/10.5, Oracle 8i/9i, PL/SQL, Windows 2000/ Unix, Harvest, Test Director, Documentum, .Net C# 2.0, SQL Server 2000, Rational Rose, UML.

Confidential, NY

Sr. Power Builder Developer

Responsibilities:

• Understanding business requirements and preparing Business Requirement Document.
• Prepared the Functional Specification Document and the Technical Specification Document.
• Developed the business logic of the application.
• Working with the users, I modified and enhanced the system using PowerBuilder, SQL Server 2000 .
• Migrated DTS Packages from SQL Server 2000 to SQL Server 2005 and done the necessary changes to SSIS Packages which were not properly migrated.
• Developed the query builder for users to generate reports by their own.
• Use SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Monitor and troubleshoot SQL agent jobs.
• Coded the SQL Queries needed by the application.
• Created and maintained database, tables, views, indexes, and constraints to implement business rules by using Query Analyzer and SQL Server Management Studio.
• Implemented Disaster Recovery Plan by maintaining Backups and performing the Restoring of the system and user databases.
• Developed the local database using pipe object for faster performance.
• Developed the non-visual user objects instead of windows functions for faster performance.
• Unit testing and System Integration Testing (SIT) for the application.
• Coordinating team members in terms of functional, technical and logical assistance to resolve the issues reported from customer.
• Analyzing the nature of issues and giving the rapid and appropriate solutions for show stopper issues.
• Worked on PFC’s.
• Providing support to create executable application.

Environment: PowerBuilder, UNIX, C. SQL Server 2000/2005, Microsoft Business Intelligence Studio, Java, VB.Net Active-X script, T-SQL, SQL Reporting Services, SQL Server Integration services.

Confidential

Sr Developer/ Lead

Responsibilities:

• Design of the module using Rational Rose by creating Use Case document, Sequence diagrams, class diagrams and establish the relationship between the class diagrams. Involved in Forward and Reverse Engineering using Metex Rational Rose - PB plug-in.
• Involved in development using PowerBuilder, PFC Services, Object oriented techniques using Inheritance, Polymorphism and Encapsulation, non-visual user objects to implement the business logic and to store encapsulated data.
• Involved in creating Oracle PL/SQL Procedures/Packages and other database related development, Unit testing, testing, implementation and support.
• Interacting with Business Analyst and writing Requirements Documents.
• Writing Design documents.
• Estimating the requirements.
• Streamlining the old code and writing ancestor objects to accomplish the new functionality.
• Wrote, Altered, tested and analyzed the Oracle stored procedures.
• Developed & deployed components developed as Non-visual objects and data windows in PowerBuilder.
• Debugged and resolved production problems.
• Created various data windows with inheritance properties.
• Generating reports or data extracts for filing with the state agencies.

ENVIRONMENT: Power Builder 9, Oracle (8i) PLSQL, Documentum, Rational Rose

Confidential

Developer/ Team Leader

Responsibilities:

• Involved in hands on design, coding and debugging of new and existing Applications.
• Performance tuning of Oracle query.
• Analysis, Design, development and Enhancements to be HIPAA Compliant.
• Debugged and resolved production problems
• Extensively used Object Oriented Techniques of PowerBuilder like Inheritance, Polymorphism and Encapsulation.
• Created and altered tables, procedures, functions triggers and functions in ORACLE.
• Utilized Harvest to keep track of version object development changes.
• Created different types of reports such as Master/Detail cross tab for analysis. components generate data in XML format and interface with Java classes & servlet to generate reports in PDF format.
• EA Server Performance Tuning.
• Mentoring other developers in the team.
• Expertise in building complex PL/SQL scripts and packages, Performance tuning of various form and reports.
• Writing Stored procedures, Packages, Views, Cursors, Functions and triggers using SQL & PL/SQL.

ENVIRONMENT: Power Builder 8.0/ 9.0, Oracle (8i) PLSQL and Intel Pentium O/s: Windows NT

Confidential

Programmer Analyst

Responsibilities:

• My responsibilities included migrating the system from PB4.0 to PB5.0, making the system PB6.0 compatible, and carrying out maintenance of the system.
• Preparation of Functional Specification and Technical Specification Document.
• Coding and Testing of the application.
• Used Just in Time debugging skills to resolve complex and show stopper issues.
• Extensively used Object Oriented Techniques of PowerBuilder like Inheritance, Polymorphism and Encapsulation.
• Experience integrating third party tools, OCX’s or OLE objects into PowerBuilder applications.
• Expertise in User objects of PowerBuilder.
• Analyzing the nature of issues and giving the rapid and appropriate solutions for show stopper production issues.
• Created and altered tables, procedures, functions triggers and functions in ORACLE.
• Utilized Harvest to keep track of version object development changes.
• Performance tuning of various forms, reports and PL/SQL packages.
• Created tables/views, sequences, and synonyms.
• System Integration Testing for the application.
• Providing UAT (User Acceptance Testing) Support.

Environment: PowerBuilder 4.0/ 5.0/ 6.0, Sybase, UNIX.