SUMMARY:

• With deep experience in PowerBuilder 4.0 to 12.0 and APPEON PowerBuilder 2017 R3 using various RDBMS (Oracle, Sybase, MS SQL Server, and DB2) that performs full Systems Development Life Cycle of client/server based applications and architecture
• With more than 5 years of experience in creating Packages, Functions, Stored Procedures, and Triggers using Oracle with complex PL/SQL
• Hands on experience on design, development, and modification of software systems solutions utilizing PowerBuilder, Microsoft SQL Server and Transactional SQL
• With experience on integrating Web Services to PowerBuilder codes using HTML, XML, WSDL, and MSSOAP
• With working knowledge in Web Development using IBM RAD for WebSphere Software Ver 8.5.0
• With good experience on maintenance and enhancements of Unix Shell Scripts
• Has a deep and practical knowledge of object oriented analysis, design, and programming
• Manages project development and supervises user training with Technical Lead responsibilities
• Has strong experience in the development of production related systems and high productivity systems like manufacturing, insurance, petroleum, telecommunication, airline, healthcare, and human services

TECHNICAL SKILLS:

Databases: Oracle: 7.3/8i/9i/11g/12C, Sybase System 10/11, ASE 11.9/12.5, Sybase Adaptive Server 6.0, MS SQL Server 2000, DB2 UDB, DB2 Connect, MS Access 97/2003

Operating Systems: Win2000, Windows 7, Windows 10, MS DOS 6.1, Red Hat Enterprise Linux Server 6.9

Languages: PowerBuilder 4 to 12.0:, APPEON PowerBuilder 2017 R3, Sybase Transact - SQL, PL/SQL, SQL*Plus, HTML, XML, WSDL, JavaScript 1.8, MSSOAP, MS SQL Server 6.5/7.0/2000 , SQL Server 2000 DTS, Tandem Non-Stop 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++

Applications: JIRA, Agile Rational Team Concert Ver. 4.0, PowerGen Professional Ver.8.5, PowerDesigner 6.1.4, SQL Navigator 6.7/7.1, Toad for Oracle 12.6, Oracle SQL Developer 3.2.20.09, UltraEdit Professional Text/HEX Editor Ver. 22.10, VMWare Horizon Client Ver. 3.5.2, IBM Host On-Demand Ver. 12.0, CA Software Change Manager Workbench Release 12.1, IBM Rational ClearQuest 8.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, SQL Conversion Workbench, Microsoft Office 2010, Camtasia Studio 3.1

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:

Confidential, Pittsburgh, PA

Sr. PowerBuilder Software Engineer

Software Used: PowerBuilder Classic 12.0, APPEON PowerBuilder 2017 R3, Oracle 11g/12C, SQL Navigator 6.7/7.1, PowerGen Ver 8.5, CA Software Change Manager Workbench Release 12.1, IBM Rational ClearQuest 8.0, VMWare Horizon Client Ver. 3.5.2, IBM Host On-Demand Ver. 12.0

Responsibilities:

• Migrated the IPAT system from PowerBuilder 12.0 to APPEON PowerBuilder 2017 R3
• Implemented system updates and modifications using CA Software Change Manager Workbench and Harvest PB
• Created change request documentation and workflow processes that include High Level Overview, Technical Design, and Test Plans for related projects through Sharepoint
• Owned the responsibility on migration of IPAT application's packages that include System Packet (EXE, PBRs, and PBDs), PL/SQL, Linux shell scripts, and letter templates from Build into different state such as Integration, Quality Assurance, and Production
• Coordinated with DBAs to execute tasks such as creating user roles, verifying user accesses, and altering tables
• Participated on Agile Scrum daily standup meeting to coordinate stories, tasks, and impediments
• Provided support to business and technical groups and interacted at various levels within client organization
• Provided estimates on projects, allocated hours on Clarity, and assigned tasks to team members
• Coordinated and managed the work of other onshore and offshore PowerBuilder contingent workers by directing members of the team to meet the project deliverables
• Performed code peer reviews to ensure applications compliance with best practices

Confidential, Fort Mill, SC

PowerBuilder Lead

Software Used: PowerBuilder Classic 12.0, Oracle 11g, Toad for Oracle v12.0

Responsibilities:

• Ensured a smooth production process and high availability of the system
• Collaborated with related dependency teams to support interfaces

Confidential, Concord, NH

Programmer Analyst

Software Used: PowerBuilder8.0, 12.0, PFC, PowerGen Ver 4.2, XML, WSDL, MSSOAP, JIRA

Responsibilities:

• Created screen mockups and prototypes for users’ approval
• 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)
• Handled the Quality Assurance Team to test and report defects of all converted Java screens
• Resolved Production issues for converted Java screens by fixing Java/JSF codes

Confidential

Software Consultant

Software Used: PowerBuilder9.0, 10.0, MS SQL Server 2000

Responsibilities:

• Utilized Object Oriented Programming techniques in developing user interfaces
• Owned the responsibilities on monitoring development, implementation and code review activities
• Involved in initiating workflows and processes to avoid operation difficulties in system’s implementation
• Created database objects that included triggers and stored procedures using MS SQL Server 2000 T-SQL
• Programmed DTS ActiveX scripts to migrate data from one database to another
• Performed database tuning by creating indexes to improve query performance and query optimization

Confidential

IT Consultant

Software Used: PowerBuilder 7.0/8.0/9.0, Sybase Adaptive Server 12.5

Responsibilities:

• Owned the responsibilities on collecting business requirements, creating prototypes, designing, coding, developing new modules, and enhancing existing modules
• Created executables, PBDs for unit and system testing and led the test case planning
• Performed Quality Assurance, bug fixing, testing, and implementation
• Implemented client-side caching techniques for frequently used reference data