SUMMARY:

• Possess more than 8 years of experience in Development, Enhancement with PowerBuilder versions 5, 9, 10.5, 11.5, 12.5
• Experienced in PowerBuilder 12.5 11.5 with .Net features and Proficient in PB 10.5 which supports reading and writing to flat files larger than 2 GB, also in PB9.0 which supports the TRY CATCH FINALLY syntax of error handling.
• Expertise in PL/SQL, stored procedures/packages, triggers, constraints, cursors, views and indexes.
• Excellent skills in Designing and Development of applications using SQL, PL/SQL, Oracle Database8i/ 9i, SQL Server.
• Experienced in implementing Web services feature on a window level application with SOAP architecture.
• Experienced in analyzing COBOL programs
• Solid understanding of Systems life cycle SDLC , relational databases and software engineering discipline.
• Strong knowledge in using views, Materialized views, Export and Import Utilities.
• Planning and execution of unit/integration testing including documentation of test results.
• Experience in Dynamic SQL, Records, Arrays and Exception Handling.
• Experienced in Tuning SQL statements and procedures for enhancing the load performance in various schemas across databases.
• Experienced in using Oracle Utility programs like SQL LOADER, EXTERNAL TABLES
• Extensively involved in performance tuning for various oracle based application using various methods like EXPLAIN PLAN, TKPROF etc.
• Excellent expertise in Software Development Life Cycle SDLC including Physical and Logical design, code development, testing, implementing and maintenance.
• Involved in server side programming DB2 / MS SQL Server / Oracle / Sybase using various RDBMS versions.
• Industry experience includes Insurance, Retail and Health Care domains.

TECHNICAL SKILLS:

• PowerBuilder 12.5/11.5/10.5/9.0/6.5/5.0, PFC, PowerGen 10
• Oracle 9i/8.1.x, MS-SQL Server 2000/7.0/2008, DB2, Sybase 11.5
• PL/SQL, T-SQL
• Netwise v2.1, Z-Services
• MS Visual Source Safe VSS 6.0, Visual Basic 6.0, Rational ClearCase, StarTeam
• ERWIN, TOAD, Visio, Install Shield 5.1, Rational ClearQuest, ServiceObjects
• C, C , C , HTML
• Windows NT/2000/XP/7
• Web Services and Rest Services

PROFESSIONAL EXPERIENCE:

Role : PowerBuilder Developer

• Description: Kaig Suite is the collection of core business applications used at Kelly. There are more than 35 applications included in this project which were developed using PowerBuilder 9. All those applications were migrated into PowerBuilder 11.5 and then migrated into PowerBuilder 12.5.
• Kelly uses Microsoft SQL server 2008 2012 as back-end for all the applications it maintains. I was responsible for new Development, Enhancement and Bug fixes based on Business requirements.

Responsibilities:

• Migrating applications and providing fix for related issues.
• Collecting business requirements for new enhancements from Users
• Involved in Production Support for core applications
• Implemented Web Service Rest Service calls which was new in Kaig Suite project.
• Extensively used DW Linkage services and advanced DataWindow services
• Incorporated new enhancements, created and modified an existing Stored Procedures and Triggers.
• Used user objects extensively which improves productivity and reduces recursive coding.
• Posses sound knowledge on Business flow of each application.
• Always completed tasks/project well ahead of schedule and maintained Quality in deliverables.
• Helped team members to resolve technical and functional issues they have faced. My strong analytical and logical reasoning thinking helped my team to attain final result well ahead of deadlines.
• Released changes with Assured Quality
• Active participation on other customer facing issues discussion was very much appreciated by clients.
• Identified resolved few existing bugs in core business process which was highly appreciated by the client.
• Environment: Power Builder 12.5/11.5/9.0, MS SQL server 2008/2012, VSS, SVN, PBDelta, Visio, ServiceObjects, TestComplete 8, Ontime 2010

Confidential

Role : PowerBuilder Developer

• Description: This application is controlled and maintained by Delaware Health Social Services DHSS organization. This application is used calculate and manage benefits available for eligible family members who applied for several benefits like Food, Cash, etc,. This application was developed in PB 5.0 and migrated into PB 11.5.
• The application was using a Middleware called Netwise structures for accessing data between Mainframe and Client. We replaced the Netwise Middleware with Z-services which is using SOAP architecture. This application contains 16 Sub-Systems, 240 screens and more than 550 procedures.

Responsibilities:

• Converted more than 550 procedures in three phases
• Involved in Code review, Testing and preparing Unit test documents
• Involved in query fine-tuning
• Voluntarily gained functional flow of the application which helped me in creating new test data and testing successfully
• Defining the problem, developing a solution strategy and planning the Development process
• Single handedly converted group of procedures which are the heart of the major module Application Entry
• Incorporated new enhancements, created and modified an existing Stored Procedures and Triggers.
• Working closely with end users to both troubleshoot existing systems and develop new ones.
• Extensively used Foundation classes PFC - Inheritance, Information hiding, Function overloading and overriding concepts.
• Extensively used DW Linkage services
• Helped team members to resolve technical and functional issues they have faced. My analytical and logical reasoning skills helped to find out the root cause of the issue on time and provide a fix on time.
• Delivered the code with zero defect and before the timeline
• Active participation on other customer facing issues discussion was very much appreciated be the clients
• Environment: Power Builder 11.5, PFC, VSS, DB2, PBDelta, Visio, Netwise 2.1, Z-Services

Confidential

Role : Programmer Analyst

Description: ILINK is one of the downstream applications for Case Definition Facility application. This ILINK application feed inputs to other downstream systems. The ILINK application has 32,000 Questions. The validation of answers and enabling or disabling respective questions and maintaining respective tables are the functionality handled in this application.

Responsibilities:

• Wrote auditing triggers, complex procedures functions using PL/SQL to incorporate business rules and constraints.
• Worked in the on call production support to fix the errors.
• Provided maintenance and development using PowerBuilder software running in a Windows XP environment.
• Implementing various window Interfaces using Tab Controls and Treeviews. A Non-Visual Object NVO for the Treeview control was designed which included the object functions to populate, add, and delete items in the tree view object.
• Developed common application architecture by using PFC/PFE.
• Developed SQL stored procedures for data manipulation and querying data using PL/SQL.
• Experienced and managing development efforts using a configuration management tool, such as VSS.
• Responsible for analysis, documentation of functional/technical specifications, data mapping, development, deploying and testing.
• Involved in preparation of test plan and test cases and Unit test and Integration test.
• Created Standard Custom Visual User objects. Used Non Visual User Objects for implementing business rules.

Environment: Power Builder 10.5, PFC, VSS, Oracle 9i, SQL, PL/SQL, TOAD

Confidential

Role : Programmer Analyst

Description: The Case Definition Facility CDF is the one of the upstream system used to create a customer and assigning plans and plan rate details which is going to be feed into downstream system. This application was developed using PowerBuilder 9.0 and SQL Server 2000.

Responsibilities:

• Worked on gathering the information that is required for the full life cycle development of the system.
• Discussed on the requirements and rules with the client that support for each Major Releases
• Designed screens as per the client requirements with PowerBuilder being the front end and SQL Server 2000 as the database.
• Created complex procedures, functions and packages for the database to resolve complex database issues.
• Worked on fine tuning of the SQL statements during run time using Execution Plan.
• Extensively used Object Oriented Techniques of PowerBuilder like Inheritance, Polymorphism and Encapsulation.
• Responsible for bug fixing issues and functional changes of CDF application
• Had direct interaction with the manager for upcoming project events.
• Coordinated with the database developers and supported for resolving the database issues.
• Designed and created necessary documentation on the bug fix issues and trained the database developers on such recurring database issues.
• Participated in the bi-weekly meetings and made required changes as per the client requirements.
• Modified and enhancing the application by making appropriate code changes and testing the software as per the specifications, Data Conversion, Interfacing with other DBMS, Pilot testing.
• Environment: Power Builder 9.0 with PFC, StarTeam, SQL Server 2000, TOAD for SQL Server

Confidential

Role : Programmer Analyst

• Citrix Meta Frame is a system that is used to manage and support secured access to all the windows, Window and web based applications in Internet and Intranet environments.
• Involved in development of NVO and base classes which are used across multiple applications.
• Used SQL Loader to download the data into database from the text files and spread sheets.
• Develop debug PL/SQL, Created, executed and optimized queries while providing an interactive community to support the user experience by using TOAD.
• Created heavy Stored procedures for financial transaction by using procedural parameters working with packages, blocks exception handling.
• Designed and Developed Oracle database Tables, Views, Indexes, and Synonyms with proper privileges.
• Description: The MetLife Insurance Company uses this application to maintain and track absences taken and requested by employees of their customers. This application was developed to track and maintain absences taken by the employee as per Family Medical Leave Act
• Utilized StarTeam version control to keep track of version object development changes and to track migration changes and specification changes.
• Involved in migrating the application from PB 7.0 to PB 9.0.
• Involved in 16/5 production support.
• Involved in monitoring logs and analyzing customer facing issues on daily basis.
• Excellent expertise in analyzing customer facing issue and proposing short term and long term fixes within short period of time.

Environment: Power Builder 7.0/9.0 with PFC, StarTeam, Oracle 9i, TOAD, Citrix, Quality Center 9.0

Confidential

• Provided Tech Support through telephone and emails.
• Designed tables and implemented methodologies for database maintenance.
• Performed PowerBuilder development and provided support for the PowerBuilder portion of the application.
• Created different types of reports such as Master/Detail cross tab and graphic for trend analysis.
• Involved in creating front end GUI screens for data entry.
• Involved in developing procedures, triggers and packages.
• Attended user meetings, collected business requirements and designed specifications.
• Description: The Stores package is used to take control over the stock and related process like import and export of finished goods Reynolds pen or raw materials. There are several reports including Masters, Transactions. The material outgoing and incomings are calculated and the available stock is watched
• Designed standard framework as per PowerBuilder Foundation Class.
• Designed program logic and code in Power script language using company standards and techniques.
• Involved in collecting user requirements and designing prototypes and specifications.
• Involved in documentation and generation of reports and system analysis and modeling.
• Involved in creation of database tables and procedures, triggers.
• Created/changed business object Visual/Non-visual , windows, data windows, functions, menus.
• Created flow diagrams and class diagrams for the application being developed.
• Involved in visual development event driven programming, customizing based on environment's problems and resolved the issues
• Designed tables, created, and managed Server to hold sales, support, operations, and billing data.
• Performed troubleshooting and maintenance of applications and design, development and testing.

Environment: Power Builder 9.0 with PFC, StarTeam, Oracle 9i, TOAD, Citrix, Quality Center 9.0

Confidential

Description: Pharmacy Management System PMS is a Module, which consists of Masters, Transactions and several useful Reports, which can be customizable. It has been designed to serve all kinds of Hospitals. This product facilitates easier maintenance and updates of Pharmaceutical Products daily collections are maintained accurately

• Designed program logic and code in Power script language using company standards and techniques.
• Written classes to implement new business logic for validating Stocks in hand and requirement for next 2 months, managing expiry dates.
• Migrated Conversion the application from PB 5.0 to PB 6.5.
• Involved in collecting user requirements and designing prototypes, specs.
• Involved in documentation and generating reports and system analysis and modeling.
• Involved in creation of database tables and procedures, triggers.
• Created/changed Business object Visual/Non-visual , windows, data windows, functions, menus.
• Created flow diagrams and class diagrams for the application being developed.
• Involved in designing the user interface, aligning controls through IDE.
• Involved in visual development event driven programming, customizing the environment major problems and resolved the issues.

Environment: Power Builder 5.0/6.5 with PFC, Oracle 8i, TOAD