SUMMARY:

• Over 17 years of experience in PowerBuilder (experience on versions 4 to 10 and knowledge on version 11) using various RDBMS (Oracle, Sybase, MSSQL Server, DB2)
• Over 10 years performed full Systems Development Life Cycle of client/server based applications and architecture
• Over 2 years of experience in writing stored procedures and triggers using PL/SQL (Oracle 7.3/8i/9i)
• With 6 months of experience in Web Development using IBM RAD for WebSphere Software Ver 8.5.0
• Certified in PowerBuilder 8.0/9.0, MS SQL Server 2000 Programming, and Project Management (2008)
• A deep and practical knowledge of object oriented analysis, design and programming
• Developed applications in a client/server environment using PowerBuilder 4.0 to 10.0, Sybase System 10 & 11, Oracle 8i, MSSQL Server 6.5/2000, HTML, XML, WSDL, and MSSOAP
• Extensive experience migrating applications in PB from version 6.5/7.0 to 10.0 and knowledge on version 11.0
• Managed project development and supervised user training with Technical Lead responsibilities
• Strong experience in the development of production related systems and high productivity systems like manufacturing, insurance, petroleum, telecommunication, airline, healthcare, and human services
• Good experience on maintenance and enhancements of Unix Scripts
• Knowledge of web technologies and web application design
• Excellent analytical and problem solving skills; ability to work with minimal guidance and direction; ability to meet deadlines and handle conflicting priorities

TECHNICAL SKILLS:

Databases: Oracle 7.3/8i/9i, Sybase System 10/11, Adaptive Server Enterprise 11.9/12.5, Sybase Adaptive Server 6.0, SQL Anywhere 5/8/9, DB2 UDB, DB2 Connect, MS Access 97/2003, MS SQL Server 2000

Operating Systems: Win95, Win98, WinNT, Win2000, Win ME, Win XP, Vista, Windows 7, MS DOS, UNIX 5.6

Languages: PowerBuilder Ver 4: 11, HTML, XML, WSDL, JavaScript 1.8, MSSOAP, Sybase Transact - SQL, MS SQL Server 6.5/7.0/2000 , SQL Server 2000 DTS, MS Visual InterDev, Active Server Pages, VBScript, SQL*Plus, PL/SQL, Tandem NonStop ODBC, SQL/DB2, Digital Unix v4.0D, Unix Shell Scripts, HP-UX Release 10.20/11i, COBOL for Z/OS Ver 3 Rel 3, C/C++, Clipper 5.01, Visual Basic 5.0/6.0, VBA, MS Access 97 - 2003, FOXPRO 2.5/2.6, Turbo PASCAL

Applications: JIRA, PowerGen Ver 4.2, PB API, PowerDesigner 6.1.4, Lotus Notes 6.5/7.0, Tera Term Pro 2.3, Telnet, FTP Explorer, Reflection FTP Client ver. 8.0.2, VI-editor, DBArtisan 4.02/7.0, Cognos/PowerPlay, DameWare MRC Ver 5.0, NetWise MiddleWare/CICS TS, NetWise Depot Access Ver 1.01, Application/Integrator Workbench Ver 2.1, Accu Studio, Camtasia Studio 3.1, SQL Conversion Workbench, MS Office

Web Development: HTML 4.01, HTML5, XHTML, XML, CSS, Javascript, Jquery, AJAX, JSON, JSP 2.0, JSF 2.2, IBM RAD for WebSphere Software Ver 8.5.0

PROFESSIONAL EXPERIENCE:

Confidentia

Software Used: PowerBuilder 8.0, PFC 8.0, PowerGen Ver 4.2, XML, WSDL, MSSOAP, JIRA, COBOL for Z/OS Ver.3 Rel.3, NetWise Depot Access Ver 1.01, Application/Integrator Workbench Ver 2.1

Responsibilities:

• Analyzed and gathered user requirements.
• Created screen mockups and prototypes for users approval.
• Developed scripts based on PowerBuilder Foundation Classes Frameworks.
• Created program structures supported by DB2 back-end using Netwise MiddleWare.
• Prepared user test scripts and customer view maps to support migration from Unit to Regression regions.
• Supervised activities for check-in/check-out of objects from different libraries.
• Managed migration of all objects and creation of executable application from Unit to Regression regions.
• Tested the migrated application in lower regions such as Unit, Integration, and System.
• Provided production supports and resolved problems on systems encountered by users.
• Wrote program specifications for Incremental Renewal Project (PowerBuilder conversion to Java).
• Led the Quality Assurance and Testing of all converted Java screens.
• Resolved Production issues for converted Java screens by fixing Java/JSF codes.

Confidential

Software Used:PowerBuilder 9.0, 10.0, SQL Server 2000

Responsibilities:

• Utilized Object Oriented Programming techniques in developing user interfaces.
• Developed Custom Class User Objects in PowerBuilder.
• Responsible in Monitoring Development, Implementation and Review activities.
• Involved in initiating workflows and processes in order to avoid operation difficulties in system’s implementation.
• Developed PowerBuilder reports according to client requirements.
• Create triggers and stored procedures using SQL Server 2000.
• Programmed DTS ActiveX scripts to migrate data from one database to another.
• Performed index tuning for query performance and query optimization.

Confidential

Software Used: PowerBuilder 7.0/8.0/9.0, MSSQL Server 7.0

Responsibilities:

• Responsible for collecting business requirements, creating prototypes, designing, coding, developing new modules, and enhancing existing modules.
• Designed user interface screens, coding, testing, implementation and maintenance.
• Created executables, PBDs and DLLs deployed at client’s locations.
• Modified and created database objects like Tables, Views, Triggers, Stored Procedures, and Functions according to new business requirements.
• Performed Quality Assurance, bug fixing, and testing.
• Responsible for writing technical specifications, design, development, and modifications of the database and front-end screens.
• Implemented client side caching techniques for frequently used reference data.
• Prepared documentation for the enhanced modules.

Confidential

Software Used: Sybase Adaptive Server 12.5, Reflection FTP Client ver. 8.0.2, HP-UX Release 10.20/11i, PowerBuilder 7.0

Responsibilities:

• Created user interfaces to enter customer information and created these interfaces using PowerBuilder 7.0
• Created stored procedures for datawindows to retrieve complicated reports.
• Created other PowerBuilder objects using inheritance in PFC.
• Created non-visual user object and customized the service objects provided in the PowerBuilder Foundation Class.
• Created codes and objects to save these reports in different format such as PSR and Excel.
• Used Sybase Adaptive Server 12.5 to create stored procedures and triggers to send mail at various stages of customer.

Confidential

Software Used: PowerBuilder 7.0, Oracle v7.3, SQL*Plus, PL/SQL, Tandem Nonstop ODBC, Telnet, FTP

Responsibilities:

• I have identified, analyzed, and developed systems requirements for Confidential .
• I have defined and reviewed the design of the proposed system, tested, implemented and performed documentation.
• I have developed scripts such as pin generation using a stored key and encryption algorithm.
• I have performed data extraction specifically for card embossing.
• I have created module for generation of different Billing and Invoicing Reports.

Confidential

Software Used: PowerBuilder 6.5, Sybase Adaptive Server 6.0

Analyst Programmer

Responsibilities:

• I was responsible for data gathering, prototyping, program coding, and designing of database structure.
• I have developed application's data entry for the customers, data transfer from different branches to head office, policy issuance, and approval of insurance application.
• I have also created letters and reports’ templates for the approved and declined applications.