Pedro Rivera Email & Phone Number

Lake Mary, Florida, United States

Lake Mary, Florida, United States

Lake Mary, Florida

Knoxville, Tennessee Area

As an IBM iSeries DBA, I worked closely with programming staff and managers in recommending best coding practices such as enforcing DDL coding standards, recommending SQL optimizations in code, and proper design of tables and other iSeries/DB2 related objects. I was also the lead on encrypting data at rest such as social security numbers, account numbers, etc. I was also responsible for the development and implementation of consuming and providing web services on the iSeries using native RPG and SQL (no third party libraries) and deploying web services using IBM Integrated Web Server (IWS).

Maryville, Tn

Transferred from Clayton Homes Vanderbilt division to work with Corporate IT data team.Projects and Responsibilities:-------------------------------------------• Assist in enforcing DDL, DML, and embedded SQL coding practices.• DDS to DML conversions.• Monitor DB2 SQL performance and optimize using tools such as index advisor, SQL cache plan, etc. available in Client Access.• Implement Field Level Encryption to secure data on IBM iSeries V7.1. Responsible for developing and writing FieldProc RPGLE program to be attached to various tables. • Designed, programmed and implemented social security tokenization, encryption and user level security via column level security (FieldProcs)• Designed, programmed and implemented column level encryption and user level security to other data columns such as bank accounts, routing numbers, etc.• Assist in application remediation to avoid "data stomping" and other potential pitfalls before attaching FieldProcs to tables.• Create and configure Integrated Web Services application server (IWS) to enable IBM iSeries as a web services provider.• Create SQLRPGLE programs and deploy as web services on IBM iSeries.

Technologies used:----------------------------• IBM Rational Business Developer for iSeries• Eclipse 3.5+ to develop Java and C/C++ applications• IBM SQLRPGLE, RPGLE, CLLE, DDS, and DML for IBM i5/OS environment.• DB2 and MSSQL• JAVA 1.5, 1.6• JDBC on i5/OS using JNI (Java Native Interface)• Develop Win32 Apps using MinGW/GCC to invoke Java using JNI• Develop Win32 DLL's to invoke WINAPI's from Java• Develop Java applets for IBM HATS/Websphere environment

Write applications for IBM iSeries in RPGLE, CL and Java. I specialize in modernizing legacy green screen applications making them available over the web. I reuse existing business logic thus preserving clients investment. I use an M-V-C model approach in modernizing legacy applications.Technologies Used:==============• RPGLE, CLLE, DDS, DDL, DML, SQL • Java 1.4, 1.5, 1.6• Wesbpere Application Server Express 6.1• JSF, iText, icePDF, Swing, MuPDF• Eclipse 3.5+ to develop Java and C/C++ applications

During this time I worked for Clayton Homes, Vanderbilt Division as a contractor on a 12 month contract to hire.Technologies used:----------------------------• IBM Rational Business Developer for iSeries• Eclipse 3.5+ to develop Java and C/C++ applications• IBM SQLRPGLE, RPGLE, CLLE, DDS, and DML for IBM i5/OS environment.• DB2 and MSSQL• JAVA 1.5, 1.6• JDBC on i5/OS using JNI (Java Native Interface)• Develop Win32 Apps using MinGW/GCC to invoke Java using JNI• Develop Win32 DLL's to invoke WINAPI's from Java• Develop Java applets for IBM HATS/Websphere environment

Responsible for the development of new products and modernization of existing legacy applications.Technologies used:----------------------------• IBM Websphere Development Studio v7.0• Websphere Application Server 6.1• Java Server Faces Web Application Development• IBM RPGLE, CLLE, DDS, and DML for IBM i5/OS environment.• DB2 and MSSQL• JAVA 1.5, JDBC on i5/OS • Crystal Reports XI and 12 for server side and web delivery on i5/OS• iTextPdf, ICEpdf for PDF and TIF file creation, manipulation, etc.

Responsible for creating Web applications to replace and/or enhance legacy AS/400 applications. Designed and created client server applications using the MVC pattern using Java technology. Also responsible for maintaining RPGLE code on the iSeries platform.Technologies used:---------------------------- • IBM Websphere Development Studio v7.0 • Websphere Application Server 6.1 • Java Server Faces Web Application Development • IBM SQLRPGLE, RPGLE, CLLE, DDS, and DML for IBM i5/OS environment. • DB2 and MSSQL • JAVA 1.5, JDBC on i5/OS • Crystal Reports XI and 12 for server side and web delivery on i5/OS • iTextPdf, ICEpdf for PDF and TIF file creation, manipulation, etc.

Supported existing applications for the Public Safety and Justice department of the organization. My responsibilities include technical support for existing applications, debugging of programs, changes to existing programs based on client needs and the creation of new programs based on client specifications.Technologies used: ---------------------------- • Languages: RPG III, RPG IV and ILE for IBM iSeries, SQL. • Databases: DB2 • IBM Client Access

I was assigned to a project team developing a client / server application for their credit department at Hughes Supply in Orlando. Technologies used: ---------------------------- • Languages: MS Visual Basis 6.0, SQL, Stored Procedures • Source Code Control: Visual Source Safe • Databases: MS SQL Server 7.0 • Report Writers: Crystal Reports 8.5

Responsible for company wide PC development and network administration. This included the gathering of business requirements, development of software prototypes, create technical and user documentation, assist in user training, create custom interfaces for the JD Edwards accounting and manufacturing software.Technologies used: ---------------------------- • Languages: Visual Basic, RPG III, RPG IV, Java, Clipper, SQL • Databases: DB2, MSSQL, MS Access, BTreive, FoxPro, DBase • Designed client server applications using Clipper 5+ • Designed client server applications using MS Visual Basis 6.0. • Crystal Reports 8.5 • Programmed Telxon hand held scanning devices. • Programmed Arlan radio frequency antennas. • IBM Client Access 95/NT • JD Edwards financial software on IBM iSeriesMajor Accomplishments: ------------------------------------ • Designed and programmed client server applications. Some of the major systems designed are standard costing, inventory control, shipping and handling, invoicing and production modules. • Designed and programmed hand held radio frequency bar-coding system that interfaces with the inventory control and shipping and storage systems. • Coordinated the installation of the new local area network and connection to corporate wide area network. This enabled access to email system and internet/intranet services. • Project Manager for the JD Edwards implementation. • Project Manager for the Y2K effort.

Responsible for manufacturing software, LAN operations, supervision of small staff, and yearly maintenance of IT budget.Technologies used: ----------------------------• Languages: Visual Basic, Clipper,• Databases: MS Access, BTreive, FoxPro, DBase• Designed client server applications using Clipper 5+• Novell Netware• MS DOS, Windows 3.1

I was assigned to various projects to develop software for Pharmaceutical companies in Puerto Rico. Software primarily focused on inventory control and shipping. Technologies used: ----------------------------• Languages: Visual Basic, Clipper, DBaseIII+, RPG III • Databases: FoxPro, DBase, DB2• MSDOS, Windows 3• IBM AS/400

Bachelor Of Science - Bs, Information Technology

Jd Edwards Manufaturing And Accounting

Activities and Societies: Obtained training in JD Edwards Common Foundations, Address Book and General Accounting.

Advanced Local Area Networks

Computer Programming

Theology And Philosophy