SUMMARY:

• Senior developer having 14 plus years of experience in analysis, architecture, design, development, testing and production support in web and windows application using Microsoft Technologies. L1 Support activities like product demo troubleshooting, Co - ordinate with team for technical supports.
• Total 14+ Years of experience in IT industry and including 8+ Years of experience in PowerBuilder Designing, Coding, Testing and Maintenance.Excellence in POWERBUILDER12.5, 10.0, 9.0/7.0, UNIX and ORACLE9i, SYBASE12.5 with proficiency in Client/Server architecture.
• 3+ year of experience in performance testing using tools like HP Load Runner and Apache JMeter.
• In depth knowledge in Database Application Programming.
• Experienced in Load testing, Scenario creation and execution, Measured Throughput, Hits per second, Response time, and Transaction Time Performance Center.
• Thorough knowledge of ORACLE 9i and Stored Procedures, Triggers.
• Experienced in all the phases of Software Development Life Cycle including analysis, design, programming, testing and maintenance.
• Experienced in High Level Design documents and test documents.
• Certified Scrum Master (CSM)
• Good working knowledge on Power Builder, Oracle, Visual Basic, Sql Server.
• Involved in development using PowerBuilder, Object Oriented Programming Systems(OOPS) Techniques using Inheritance
• Strong Analytical and Technical Skills and thorough knowledge of Full Software Development Life Cycle (SDLC).
• Experienced in leading Product Development on Agile methodology.
• 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, & PB 9 to PB 11 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, and Base line testing. Seamlessly migrated the Code from Development to Testing, UAT and Production.
• Knowledge of PowerBuilder foundation classes.
• Generating multiple reports with the tools embedded in PowerBuilder.
• 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:

Databases: Sybase ASE 15.0/12.5/12 , Sybase ASE, Oracle 10g, Microsoft Access 2000/97, SQL Server 20012/2008/2005/2000.

Database Tools: Rapid SQL, SQL Browser, Sybase Central, SQL-Advantage, Query Analyzer.

Languages: Sybase PowerBuilder V6.5-12.5, T-SQL, PL/SQL, HTML/XML, Node JS

Operating Systems: HP-UX 11.0/10.0

SCM: CVS, PVCS, Tortoise SVN

Other Tools: Power Designer, Autosys, Batch Scripting,HP Advanced LoadRunner, Artillery.io, SiteSpeed.io, Mountebank

PROFESSIONAL EXPERIENCE:

Confidential, Deerfield

Sr. Test Analyst

Responsibilities:

• Gathered non-functional requirements, created test strategy documents for all P1 flows for various customers for multiple releases.
• Expansively driven LoadRunner Vugen to create scripts and, develop the scripts by adding correlation, parameter and debugging the script.
• Analyzed and prepared test results, analysis summary reports and identified the bottlenecks in the system and suggested technical recommendations to project teams.
• Level 1 support activities like product specimen troubleshooting, daily call with team for product improvement and so on.
• Prepare the Functional Specification Document and the Technical Specification Document.
• Develop the business logic of the application.
• Enhancing the system by working along with the users using PowerBuilder and Sybase
• Defect Management and Ongoing enhancements.
• Generating multiple reports with the tools embedded in PowerBuilder. The representation in the reports includes the following formats: Composite, Crosstab, Richtext, Tabular, Graph, Grid, Group, Ole, N-up.
• Taking responsibility of Unit, Integration and System Testing.
• Coordinating between Offshore and Onsite as and when needed for couple of modules
• Test Strategy, Test Plan and Test Case creation and execution from Onsite for the modules that are being developed.

Environment: PowerBuilder12.5, UNIX, DB2/Sybase Stored Procedures, HP Quality Center.

Confidential

Sr. PowerBuilder Developer

Responsibilities:

• Understanding business requirements and preparing Business Requirement Document.
• Prepare the Functional Specification Document and the Technical Specification Document.
• Develop the business logic of the application.
• Troubleshooting activities for L1 Support and also co - ordinate with team for technical assistance.
• Enhancing the system by working along with the users using PowerBuilder and Sybase
• Coding offew DB2/SQL queries as needed by the application.
• Defect Management and Ongoing enhancements.
• Taking responsibility of Unit, Integration and System Testing.
• Coordinating between Offshore and Onsite as and when needed for couple of modules
• Test Strategy, Test Plan and Test Case creation and execution from Onsite for the modules that are being developed.
• Assisting PRODUCTION Install and warranty support for the same.

Environment: PowerBuilder12.5, UNIX, DB2/Sybase Stored Procedures, HP Quality Center.

Confidential

Sr. PowerBuilder Developer/Testing Analyst

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 ServerManagement 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: PowerBuilder12.5, 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

Responsibilities:

• Central ticketing applications are developed on PowerBuilder and deployed in production server. These applications will run on the timely manner triggered by Tivoli scheduler to do the tasks mentioned below:
• Transferring the group PNRs information from SAAS database to Central Ticketing Database.
• Updating the PNR information on daily basis regarding the PNR flow.
• Sending remainder emails to the customers such as deposit remainder, balance due remainder and name template emails for getting the passes list from customer.
• Generating the ticket numbers for the group PNRs which are done with the final payment. Email the tickets to customers.
• Creating the XML file with credit card information for the PNRs which are generated ticket numbers.
• Loading the updated southwest employee details into central ticketing database.
• Loading the gust pass PNRs into central ticketing database.
• List the callback PNRs which are not done with the payment and loading the details into database from SAAS and purging the PNR data if it is crossed with payment due date.

Environment: OS (Windows XP) Power Builder 12.5, ORACLE9i and SYBASE12.5