Consultant
Gulf International Bank
مجموع سنوات الخبرة :17 years, 8 أشهر
o Powerbuilder code change or writing new code for Change Request/New Request for enhancement or bug fixing.
o Extract Transform & Load(ETL) from one system to another using PowerBuilder.
o Creation and modification of Sybase(12.5 and 15) stored procedures, views, & cursors.
o Creation and modification of Oracle(10g/11g) package, stored procedure, cursors, triggers & other database objects using SQL and PL/SQL
o Migration of Powerbuilder application developed in older version(below 7.0) to newer version(12.0 classic)
o Migration of Sybase database(below ASA 6) to newer ASA(11.0)
o Address IT issues raised by user from various departments of bank in different applications.
o Preparation of test scripts and test cases to perform unit testing and System Testing from development environment to testing environment, UAT and Production.
o Create new powerbuilder reconciliation application between two system (file based/database) and printing the report for summary, matching, un-matching and extra.
o Troubleshoot issues raised while reconciliation of various system and fix
o Build various applications, integrate them and further troubleshooting.
o Configure new Sybase server and setting up the database for new system.
o Created scripts to take backup of Sybase database on the sever and scheduling them every day.
o Loading Sybase database from production to development environment using database dump file to refresh database.
o Created many batch scripts which will check dependency before starting COB(Close of Business) process.
o Reporting issue and getting support from vendor for vendor based application and fixing them before COB(close of Business) for critical issues.
o Address issues raised by user on Eximbills/Acumen or Midas(IBM File system) and interface
o Powerbuilder code change or new code for Change Request/New Request for enhancement or bug fixing.
o Offer based ticketing rule and PowerBuilder code change based on new fare rule.
o Fine tuning/Enhancing the PowerBuilder code for newer device(HHU/TVM/DCU).
o Creation, modification of Oracle(10g) stored procedures, functions, database triggers, other database objects using SQL and PL/SQL.
o Troubleshoot issues raised by clients/System Test team in Powerbuilder and fix them in timely manner.
o Translate the fix in different language using Translation ToolKit available in PowerBuilder
o Fix issue faced by testing team or devices team in the flow of transaction or settlement issue for different type of fares(seasoned fare/student fare etc)
o Build various applications, integrate them and further troubleshooting.
o Maintain PowerBuilder code repository using PVCS.
Develop new functionalities and amend/modify according to new business requirements using PowerBuilder.
Change Request (New Functionality development) in PowerBuilder
Configure various servers and EOD build deployment
Preparation of test Scripts and Test Cases for unit testing and System Testing from Development to Testing, UAT and Production
Troubleshoot issues in various regions like SIT, UAT and Productions
Actively involved in Migration of application from Powerbuilder version 7.0 to 11.5
* B.Tech in Computer Science and Engineering from Cochin University of Science and Technology (CUSAT), Kochi, Kerala with 68% in 2006.
* Responsible for the coding/development of new systems and enhancements * Define technical specifications based on business requirements (SRS) * Assist in technical design of new changes or enhancements to the existing system based on business requirements * Fixing programming problems in different stage of development cycle * Analyzing and fixing defects in the application systems * Responsible for ensuring that the code development adheres to standards and guidelines * Responsible for configuration management and code release (SCM) * Create Test Scenarios and perform unit testing of own programming changes * Work within prescribed project implementation methodology and follow the applicable standards * Good working knowledge of source code control and versioning * To support production environment by developing new requirements, change requests and fixing bugs in a timely fashion and unit testing * Conceived and contributed to application design and development of unit test cases PROFESSIONAL ORGANIZATION: