Abdel Pena Email & Phone Number

Provide technical expertise in PowerBuilder, MS SQL Server 2005, Transact SQL.Responsible for the design, implementation and maintenance of windows, datawindows, user object, etc for data entry, results and reports for the Clinical Trials Management System. Work closely with the DBA in the development of database objects, stored procedures, tables, and triggers in MS SQL Server 2005.Involved in all phases of software development – interaction with users, gather requirements, analysis and design of the solution needed, implementation, testing and maintenance. Provide production support to users’ requests related to the applications, including new functionality and the correction of bugs found in production.

Provided technical expertise in PowerBuilder, Visual Basic 6.0, VB Script, ORACLE, MS SQL Server 2000, Transact SQL, Visual Studio .NET, ASP pages, HTML and Web development using MS FrontPage. Responsible for the design of data entry and result screens. Developed stored procedures, tables, triggers, sequences, use of SQL Loader and DTS packages in ORACLE, Sybase, MS SQL Server 2000.Involved in all phases of software development process - user requirements, functional specifications, database and application design, implementation, testing and maintenance. Migrated processes in legacy MS Access into Sybase Stored Procedures.Provided Production Support for the main financial applications: GLS and SmartStream, including create or improve interfaces with other systems such as Capital Markets, Concur Expense, Paybase and Webseries. The functionality included but was not limited to General Ledger, Accounts Payable, Accounts Receivables, and Expenses.

Provided technical expertise in VB.NET technology under Windows XP Professional, ASP.NET pages, HTML, MS SQL Server 2000, Transact SQL and some JavaScript development. Responsible for the design of critical GUI/data entry screens and result screens. Developed stored procedures, tables, triggers in MS SQL Server 2000, and database administration.Involved in all phases of software development process - user requirements, functional specifications, database and application design, implementation, testing, installation and maintenance.

Provided technical expertise in PowerBuilder and Java development for the Enterprise Reagent Manager (ERM) product. Responsible for the design of objects using Powerbuilder (windows, user objects, functions, Datawindows). Developed functions, stored procedures, packages, sequences in PL/SQL (ORACLE). Also developed modules using SQL Loader.Developed dll files in C to establish communication with the Windows security APIs and some Unix shell scripting. XML was used as part of the Java development to transmit data through the different modules.Involved in user requirements, functional specifications, database and application design, implementation, testing, installation and maintenance of several systems. The development included the use of different technologies like scanners and thermal label printers. Involved in the test and defect management using Mercury Interactive’s Test Director and RTI’s Customer First.

M.S., Information Systems

Master Certificate, Business Analysis

B.S., Systems Engineering

Education record