Peter Feenan Email & Phone Number

Newark, N.J.

• Project lead to correct data security issue with the ODBC data connection. Built a process in collaboration with the data security group that converted the data connection from SQL authentication to Windows authentication. This change replaced a static login and password with the network login and password. Each stakeholder was given instructions on their role and responsibilities. The project was completed successfully after thorough UAT testing.• Technical subject matter expert for the executive share ownership process. This process produced share ownership statements that were sent to the top executive within the company. The process required coordination with several employees within the company.• Administration and operational support of Human Resource Compensation and Tracking Web Server. Coordinated the UAT testing and implementation of the Web Server enhancements. Coordinated the security testing of the Web Server.• Played key role in the Year End Annual Compensation Process. Bulk imported Bonus, Salary Increase and Long Term Grant recommendations into the Compensation Tracking Database. Verified the accuracy of these imports. Completed the audit of the final Bonus, Salary Increase and Long Term data feeds to Payroll.• Project management and technical support of the Human Resource Microsoft Access databases that provided decision support reporting and Long Term Cash Plan tracking.• Represented Corporate Compensation for software and hardware updates in the department. Coordinated the Windows XP to Windows 7 upgrade, and the Virtual laptop upgrade.• Managed the VBA consultants working in Corporate Compensation, and performed VBA programming on several Microsoft Access Databases.

Newark, N.J.

• Enhanced several Human Resource Compensation Access databases. Obtained change specifications from primary business personnel. Created Access tables, queries, reports, forms and VBA modules as needed. The databases supported business decision-making on employee compensation.• Documented several Access databases with Microsoft Visio.• UAT testing and production conversion from Microsoft Office 2000 to Microsoft Office 2007.

Park Ridge, Nj

• Project Lead responsible for the migration of several Sybase databases from a Windows Server platform to IBM AIX platform. Responsibilities ranged from programming, stored procedure testing and optimization, and scheduling database loads. Conversion of Windows Server batch files to Unix Kornshell scripts. Transact SQL modification and testing. Authored several technical documents in Excel and VBA.• Automated the forecast and budget system using PowerBuilder 6.5 /Oracle. This allowed real time data on forecasted product sales that increased overall efficiency in budgeting product quantity to the end customers. Utilizing knowledge of PL/SQL to build packages, stored procedures, functions and triggers.• Responsible for overall maintenance and enhancements of: • The returns analysis system utilizing PowerBuilder 6.5 on the front end and Sybase as the database back end. This allowed the tracking of customer return requests against actual returns and saved the company valuable resources. Created and modified numerous Stored Procedures and triggers. Responsible for designing database backup using database dump files loaded onto a backup database server. Insured database integrity by running database consistency checks. • Sony’s promotional card database and application in PowerBuilder/Sybase environment. Used Erwin to improve database design. Designed stored procedures, triggers, tables, constraints and rules to extend PowerBuilder application functionality.• Enhanced and improved the equipment tracking system with email feeds and data extracted from the central ETS database. Created stored procedures to build extract table and used BCP to download data to UNIX operating system. Programmed AWK script to generate email notifications based on time-triggered deadlines.

Weehawken, Nj

• Planned, developed, tested and documented PaineWebber’s Human Resource bonus application applying knowledge of Sybase SQL and Power Builder.• Configured, installed and supported company PC’s with Token Ring and configured employee network accounts.

Bachelor'S Degree, Computer Science

Microsoft .Net