SUMMARY:

• 18 yrs of IT experience in developing and maintenance of database using PowerBuilder, VB.Net, Sybase and Oracle applications.
• Successfully completed several Full Life cycle implementations using PowerBuilder versions 11/10.5/9.0/8.0 and earliest.
• Experienced using PowerBuilder features such as PFC, Dynamic DataWindows, MDI, User Objects, User Defined Functions, and DataStores.
• Expertise in writing complex PL/SQL Stored procedures, Functions, Triggers, Query optimization and Performance Tuning.
• Experienced in using OOPS Inheritance, Encapsulation, and Polymorphism with PFC PowerBuilder Foundation Classes .
• Extensively worked GUI applications and screens, designed the GUI and coded the GUI. Also involved in project GUI specifications, design and prototypes.
• Generated PowerBuilder Reports 11/10.5/9.0/8.0 and Crystal Reports 12/11/10.
• Wrote Technical Documents on Reports developed.
• Extensively used QUEST Tools TOAD, Navigator , and SQL PLUS.
• Strong Knowledge on Software Models, Software Analysis, Design, Requirements and networks.
• Converted several PowerBuilder applications/modules to VB.Net.
• Ability to interact effectively with clients, Understanding their requirements and providing optimum solution and support.
• Excellent Analytical, interpersonal and communication skills.
• Quick learner with ability to develop proficiency and adapt to new technologies and methods in a short period of time.
• Experienced in working in a team environment. I especially enjoy mentoring other programmers who use PowerBuilder.
• Highly skilled in using the PowerBuilder object: the DataWindow control.
• Have a very good knowledge in development and supporting UNIX Shell scripting.
• Efficient in using debugging tools.

PROFESSIONAL EXPERIENCE:

Confidential

Consultant/ PowerBuilder/ Oracle Developer

• Maintained software and provided production support for POS Paperless Office System to insure business continuity and exceptional uptime.
• Created, enhanced and supported different modules: NCPA, Shelter, Medical, Income, Shelter Arrears and other modules for POS Interview section.
• Created and supported OCSE Child Support Case Information window in POS Application Interview and Recertification Interview.
• Created and supported HDUA Information window for the Department of Homeless Services that works in FIA Job Centers/Model Offices that helps cash assistance clients maintain their permanent housing and prevent eviction.

Other responsibilities include:

• Ongoing modification of the current POS system
• Enhancements to a Food Stamps modules
• Enhancements to a PA modules
• Enhancements to an Alien modules
• Designing of custom functions
• Coding and development
• Enhancements of an existing modules
• Development of new modules
• Writing Stored Procedures and SQL Statements.

Confidential

Consultant/ PowerBuilder/ Oracle Developer

Responsibilities include:

• Modifications of the existing PowerBuilder applications such as: CARS Contract Amendment Repository System , SOS Sales Orders System and TR Talent Royalty system .
• Embedding an email functionality UNIX cron jobs/MAPI calls
• Creation of triggers and stored procedures
• Designing of custom functions
• Custom tables creation
• Multiple Reports writing
• Loading Excel files to DB tables
• Creation of the Datawindows that can be saved to CSV file, which can be uploaded to the People Soft system.
• Developing of the new Screens/Windows/DataWindows/Custom user objects
• Produce of technical documentation FDS, TDS and Unit Testing scripts using standard Documentation formats and content requirements.

Confidential

Sr. Programmer Analyst/ PowerBuilder Developer/ Oracle/ Sybase

Responsibilities include:

Development using PowerBuilder programming language, maintenance and support of the information and tracking systems, such as:

All systems shown below developed using POWERBUILDER development tool:

• ARCOS-2 Reporting. This system was developed using PowerBuilder 7.0 and later migrated to version 9.0. This application is used for periodic reporting of ARCOS transactions to DEA via diskette. The entered data is automatically compiled into correct reporting format.
• Application supports error prevention, identification and correction in many
• data fields before the records are send to DEA.
• EXPDATE 'Expiration Dating System'. This system was developed using PowerBuilder 8.0. The purpose of the Expiration Dating application is to efficiently calculate the expiration dates for finished good products. The main benefit of the automation of calculation that it removed the manual calculation of expiration dates and reduces the possibility of human error. System supports full audit trail on entering values into the database with e-signatures.
• POMS Calculation Factor System PCFS . This system was developed using PowerBuilder 6.5 development tool in preparation for POMS implementation for proper dispensing of raw materials. It allowed Quality Control Dept users to input Calculation Factor Assay Value into the required filed of the BPCS database, which is used to calculate the dispensing for the raw materials. System supports full audit trail on entering values into the database with e-signatures.
• POMS Reporting. System reports dispensing activities and related data from POMS database.
• All developed systems listed above are part 11 compliant, following current ISQA requirements. These requirements must include electronic signatures for data entry and approval with unique passwords, audit trail with user name/date and time stamp/comment field to enter reasons for changes and application, and application security with different levels of access.

PITNEY BOWES ACSENT .

Wrote and maintained documentation for system development including System Features Descriptions, Requirements Specifications, Installation Qualifications/ Operations Qualification/Process Qualification IQ/OQ/PQ Protocols and Validation Summaries and Change Control documentation.

SAP ABAP, SAP Script developer.

Responsibilities include:

• Development using ABAP programming language. Creation of the reports interfaces and function modules for LES, SD and FI modules.
• Development using SAP Script. Designed, build and configure a various number of user defined forms. Modified and customized predesigned forms to feet the need of the business.
• Solid experience in User Exits, Dialog Programming, Reporting, Workflow and Data Republications. Support all phases of a project life cycle including analysis, design, development, testing, and deployment of solutions, as well as documentation, and end-user training. Analyze and correct problems as they occur in the Production SAP system. Participated in system upgrade activities. Able to develop functional specifications for development activities including interfaces, enhancements, reports and conversions.

Confidential

Consultant / PowerBuilder Developer

Support data architecture responsibility for an Internet movie and TV Database. This database, published on the Internet, keeps track of movies, box office results, TV show, Nielsen ratings and Hollywood 'insider' information, including all actors, actresses and off camera talents.

Responsibilities included:

• Creating Stored Procedures for Insert, Update, Delete and Truncate tables, etc. Creating Stored Procedure Generator to ease working on writing SP.
• Working under development of dynamic, tab-based wizard class. The wizard class generated tabs and their tab pages dynamically from a custom data model used to support the application architecture.

Confidential

PowerBuilder Developer/ Sybase

• Development and maintenance of Competitive Municipal Market Bidding and Underwriting Application on Windows NT operating system.
• Design, coding and development of financial securities data entry, processing, reporting and analysis system.
• Design, coding and implementation of various GIU online modules such Maturity and Exception screens, Reporting Windows, etc.
• System was designed and developed using PowerBuilder 5 and 6 and Oracle 8.

Confidential

PowerBuilder Developer/ Sybase

Development and maintenance of information systems for Securities Insurance application using Windows 3.1 and 95 operating systems.

Responsibilities included:

• Gathering of system requirements from client, analyses of the data and structural design of the application.
• Design, coding and implementation of various online modules such as Municipal and Asset Backed Online Transaction Tracking System.
• Using Stored Procedures as data sources of numerous Data Window objects and back-end data processing.
• System was designed using PowerBuilder 5.0 development tool and Sybase 11.

Confidential

Designed developed and implemented programs for inventory control and tracking for automotive plant Basic . Coded, tested and debugged programs. Developed programming and implementation business applications for Shipment and Delivery that was designed to schedule point to point delivery of freight and documents.

TECHNICAL EXPERTISE:

• Computer System Programming Languages.
• Hardware Compaq 64, HCL XX Series, IBM-300GL.
• Operating System Windows NT, Windows2000/XP, Unix.
• Programming Languages VB.Net, C .Net, C, C , PowerBuilder 11, Visual Basic 6.0, Java2.0, Unix.
• Databases Tools Oracle 8i, Sybase System 10, SQLServer 6.5/7.0, MS-Access 2000.
• Internet Skills HTML, VBScript, JavaScript, ASP.Net.