SUMMARY

• Highly motivated Peoplesoft Developer with experience using SQL Server Management Studio and Visual Studio 2005.
• Considerable experience with ERP and Multi-Value systems.
• Demonstrated leadership abilities and team work skills, as well as the ability to accomplish tasks under minimal direction and supervision.
• Articulate and people oriented, relates well with others at all levels and from all backgrounds and who has a positive attitude and a strong desire to achieve and succeed, strives for top level performance.
• A creative professional with excellent written and interpersonal skills. The ability to learn quickly and apply new ideas.
• A willingness to accept responsibility and challenges both individually and as a team member.

Career Profile

• Programming Languages: SQR, Peoplecode, Application Engine, PS Query, Oracle SQL, Transact SQL, Pick Basic, UniBasic
• Microsoft Technologies:
• SQL Server 2005 Reporting Services SSRS , SQL Server 2005 Integration Services SSIS
• Databases: SQL SERVER 2005 / 2008, ORACLE 11g, INFORMIX, DB2, UNIDATA
• Operating Systems: Windows 2000/XP, UNIX, PICK
• Software: PeopleSoft HCM, SQL Server Management Studio, Microsoft Visio, Database Engine Tuning Advisor, SQL Server Profiler

Professional Experience

Confidential

Senior Developer

• Developed process to load Adecco supervisor data into MPS system
• Developed SQR interface to send HR data to ICMS HR Vendor
• Developed SQR interface to send employee anniversary data to MC Fina Awards Vendor
• Developed SQR interface to send employee benefits data to Sedgwick Disability Vendor
• Significantly modified SQR interface to Hartford Life Insurance Vendor
• Significantly modified SQR interface to Merrill Lynch 401K Vendor
• Significantly modified SQR interface to Wells Fargo 401K Vendor
• Developed programs to load Garnishment, Direct Deposit and Leave Accruals
• Performed several Tax Updates in multiple environments
• Modified Self-Service Pages and Peoplecode
• Modified SQR Interface to Delta Dental Dental Insurance Vendor
• Modified SQR Interface to Wage Works FSA Vendor
• Performed day-to-day HR and Payroll end-user support.

Confidential

T SQL Developer/Consultant

• Created numerous simple to complex queries involving self joins, correlated subqueries and XML techniques for diverse business requirements. Tuned and optimized queries by altering database design, analyzing different query options, and indexing strategies.
• As part of a team, analyzed the business requirements and systematically designed a database for an online-movie DVD/Blu- Ray rental company. Employed best practices in creating a complete schema including tables, relationships, stored procedures, views, clustered and non-clustered indexes and triggers, and implemented the importation and exportation of data using XML and SSIS.
• As part of a team, created various reports according to the business requirements for the movie rental company. Individually authored, installed, deployed and managed reports using SQL Server 2005 Reporting Services for a library database.
• Individually designed a bank application according to business requirements, and implemented robust stored procedures, functions, and triggers to implement required functionalities.
• Developed a backup and recovery plan based on the data availability requirements of the library and on the potential impact of data loss on the business after considering and analyzing the different backup and recovery strategies.
• Designed database maintenance plans to set up core maintenance tasks to make sure that the database performs well, is regularly backed up in case of system failure and is checked for inconsistencies.
• Employed the Database Engine Tuning Advisor to analyze the performance effects of workloads and implemented its recommendations wherever appropriate.
• Used the SQL Server Profiler tool to monitor the performance of SQL Server particularly to analyze the performance of the stored procedures.
• Analyzed different high availability solutions and implemented database mirroring and replication.
• As part of a team, established security policy using windows domain accounts and implemented a security strategy to protect against threats and attacks.

Confidential

Unidata Consultant

• Performed production support, troubleshooting, and issue resolution duties for company's HRPyramid System. Developed new interfaces and reports. Performed daily HR and Payroll end user support. Used UniBasic and System Builder for modification tasks.
• Provided efficient support to end users, and resolved Payroll, HR, Benefits, and Accounting issues in a timely manner.
• Assisted DBA in data modeling and planning for a SQL Server 2005 data warehouse initiative.

Confidential

Peoplesoft HCM Software Engineer/Consultant

• Technical Lead for 8.3 to 9.0 upgrade
• Troubleshot and fixed issues with Payroll Interface, SQR's , SQL Server 2005 Stored Procedures, Peoplecode, Security and LDAP
• Provided training and mentoring to both technical and functional staff
• Managed CRA technical team and consultants to insure that upgrade was on schedule and within budget
• Resolved post go-live issues with CRA custom policy application , Benefits Interfaces, Payroll Interface and PS Queries
• Provided support and resolved issues in the areas of Payroll, HR, Base Benefits, Benefits Administration
• Rewrote custom imputed income SQR to prorate employees that turned seventy in the current calendar year
• Developed project plan to convert Mainframe Cobol processes into SQR programs
• Resolved issue of with a number of employees having a Canadian direct deposit page in self service
• Provided support and resolved issues in the areas of Payroll, HR, Benefits and Pension

Confidential

Senior Peoplesoft Developer/Consultant

• Modified and customized Pages, Peoplecode, and App Engines during upgrade to version 8.9
• Modified multiple European interface and reporting sqr's during upgrade project
• Developed needed modifications and fixes as part of post-upgrade system stabilization
• Performed troubleshooting and fixes for all modules during post-upgrade i.e. Payroll, Base Benefits, HR, eRecruit Developed custom interface to feed HR data into a global Learning Management System
• Supported global business users in the areas of HR, Benefits, and Payroll on weekly basis. Support included troubleshooting any issues that arose with online or batch objects and any issues that occurred with payroll processing i.e. loads into Pay sheets and any problems during Calc and Confirm
• Provided daily support to business users, of Office Depot's Peoplesoft HCM system, in North America, France, United Kingdom and the Netherlands and Implemented first and second quarter tax updates for '07.

Confidential

Perot Systems Senior Applications Programmer/Analyst

• Developed new custom SQR interfaces to process Vanguard escheatment files.
• Developed and Modified custom SQR's to process inbound and outbound 401K and benefits to Merrill Lynch and SHPS.
• Developed custom SQR interface to send files to Cintas Uniform Vendor and PGI Stationary Vendor
• Significantly modified custom Time and Labor process including modification to associated ASP pages, VB Script , Java Script and HTML
• Significantly modified custom Census interface, custom Vets100 and EEO interfaces, custom SQR that loads data into pay-sheets and a custom pay register program.
• Performed production support duties on Peoplesoft HR/Payroll and Kronos Time and Labor. Tasks included troubleshooting problems in People Code, App Engine, SQR etc and creating SQL and PS Queries.
• Modified several custom applications and SQR's for 8.8 upgrade beginning in June '04
• System tested the 8.8 HR and Applicant Tracking Modules.
• Assisted other Developers with technical and functional issues during 8.8 upgrade and with production support and performed day-to-day HR and payroll end-user support
• Technical Lead for Enhancement of Batch Autosys Processes and Unix Scripts during upgrade of PeopleSoft 7.0 to PeopleSoft 8.0 on Oracle platform.
• Customized PeopleSoft Payroll system using People Tools and People Code.
• Developed and modified reports using SQR, Crystal, PS Query and SQL.

Confidential

Senior Programmer Analyst/Consultant

• Developer for Peoplesoft Distribution 7.5 implementation within HP-UX UNIX environment.
• Developed new applications for FedEx's implementation of PeopleSoft Distribution module.
• Performed all analysis, design and construction of interface from PeopleSoft Purchasing 7.5 into PeopleSoft GL 6.0.
• Worked with end users to develop specifications to meet their needs.
• Developed custom Run Control Panels. Records and any required PeopleCode and Process Definitions.
• Modified a delivered Application Engine process to build purchase orders for new Business Units.
• Developed Crystal and Query reports for users.

Confidential

Peoplesoft Systems Analyst

• Technical Project Lead for Peoplesoft upgrade.
• Led project team during upgrade of Peoplesoft 5.0 on SQL Base to PeopleSoft 7.0 on Informix. Then migrated to an Oracle platform.
• Customized PeopleSoft HRMS system using PeopleTools and PeopleCode.
• Developed and modified reports using SQR, Crystal and Query.
• Supported VAX/VMS system that transmitted HR data to headquarters.
• Unidata Developer for Infolease System
• Developed new applications in Unibasic for Caterpillar Inc.'s Financial Services Division
• Developed and modified applications for the company's remote document systems that enabled leasing documents to be processed quickly from any of our offices around the world.

Confidential

Universe Programmer/Pick Programmer/Consultant

• Developed new applications in Pick/Basic within AIX UNIX environment for fast growing health care organization.
• Developed applications that improved efficiency in all areas of a large health care facility including marketing, administration, diagnostic services, and imaging.
• Supported end-users and performed day-to-day system maintenance.
• Developed and tested new applications in Pick/Basic in a Honeywell Midrange environment for a rapidly expanding insurance company.
• Applications included accounting, agent commissions, and insurance policy issues.

Confidential

Software Developer

Participated in the requirements definition, design, development, implementation, testing, maintenance and enhancement of software, websites, mobile apps, computer-based training and internal systems. Application development in the .NET environment. Work with team lead to ensure that assigned work is completed efficiently, meets business requirements, stays within scope, and is delivered on time. Participated in scope estimation. Follows established software development processes. Actively participate in resolving technical issues. Help generate ideas for innovative applications to serve our client base.

Confidential

Program Manager, Rome Laboratory

• Responsible for planning, researching and testing hardware and software relating to space based laser communications system. Used C software run by SUN Solaris UNIX operating system on a SUN workstation that was used to operate a laser communication system evaluated various operating systems, hardware, software, ground terminals, lans and workstations in order to develop a mobile ground terminal for Strategic Defense Initiative reported directly to the Chief of Space Communications.
• Saved over one man year and millions of dollars by coordinating and focusing efforts of various groups and by avoiding duplication of work by the many agencies involved in SDI research.
• Introduced new project management procedures that lowered costs by 20 .

Confidential

• Responsible for the operation of a 500 million missile warning radar and support resources. Directed and supervised the activity of 22 personnel to perform missile warning and space surveillance missions.
• Led crew to a Highly Qualified rating during a higher headquarters evaluation.
• Led team during an operational readiness inspection that was rated outstanding by the Inspector General The best seen to date.

Satellite Operation Officer

Confidential

• Controlled all operations of a multi-billion dollar DOD satellite program. Conducted real-time telemetry and Subsystem of performance led investigations to isolate and identify anomalous conditions recommended solutions and generated corrective actions for anomalous conditions planned future support activities of satellite system and developed training/study guidelines aided in developing expert systems using ADA and Jovial software.
• Saved millions of dollars by identifying potential problems with a satellite early, accurately assessing the situation and developing corrective actions.
• Saved 60 man hours and thousands of dollars by aiding in the development of expert systems that enabled crews to reduce or eliminate some support personnel.
• Bachelor of Science, Physics/Information Systems