We provide IT Staff Augmentation Services!

Peoplesoft Technical Consultant Resume

Arlington, VA

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 interpersonal skills, as well as the ability to accomplish tasks under minimal direction and supervision.
  • Articulate, people oriented, relates well with others at all levels and from all backgrounds, has a positive attitude and a strong desire to achieve and succeed. Always strives for top level performance.
  • A creative professional with excellent written and interpersonal skills and who has the ability to learn quickly and apply new ideas.
  • A willingness to accept responsibility and challenges both individually and as a team member.

TECHNICAL SKILLS:

Programming Languages: SQR, Peoplecode, Application Engine, PS Query, XML Publisher, Integration Broker, 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 11i, INFORMIX, DB2, UNIDATA

WORK EXPERIENCE:

Peoplesoft Technical Consultant

Confidential, Arlington, VA

Responsibilities:

  • Developed custom Restrictions Framework
  • Modified custom Department Load Application Engine
  • Created initial Promotions Framework
  • Fixed large numbers of defects as identified by testers.
  • Supported multiple PUM Updates
  • Modified Branding to distinguish Institutional and Operational Environments
  • Provided technical support for Peoplesoft ELM module.

Lead Peoplesoft Functional/ Technical Consultant

Confidential, Miami, FL

Responsibilities:

  • Modified delivered PDF Check and Advice Print programs.
  • Performed day - to-day end-user support for HR, Payroll, Benefits, Tax and Time & Labor.
  • Modified custom 401K Inbound and Outbound Interfaces.
  • Performed several quarterly Tax Updates.
  • Developer DMS Scripts for a mass Data Purge Process.
  • Modified custom CCC Verify Interface.
  • Modified termination notification logic in Workflow Peoplecode.
  • Mentored and trained junior team members in technical and functional areas.

Senior Peoplesoft Functional/ Technical Consultant

Confidential, Charleston, SC

Responsibilities:

  • Developed new custom SQR to process missing time for DOS employees.
  • Modified delivered government Retirement Insurance Transfer System (RITS) to OPM.
  • Modified delivered government Head Count Report (SF1523) for OPM.
  • Developed custom Application Engine programs to import Full Time Employee Accounting data from DOS FSNPAY (Foreign Service Nationals) system.
  • Developed custom Application Engine, Component Interface and File Layout to import new FEHB (Federal Employee Health Benefit) Rates into Peoplesoft Benefit Tables.

Senior Peoplesoft HCM Consultant

Confidential, Philadelphia, PA

Responsibilities:

  • Modified custom Medicare Info Page and Component Peoplecode.
  • Modified delivered Benefits Summary Page.
  • Significantly modified custom Appeals Page and Component Peoplecode.

Senior Peoplesoft HCM Developer

Confidential, Jacksonville, FL

Responsibilities:

  • 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 (s 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.
  • Developed SQR Interface to send Employee's Payroll Data to TALX.
  • Modified custom Leave Accrual SQR.
  • Created new Leave Balance Reporting SQR for San Francisco.

T-SQL Developer/ Consultant

Confidential, Parsippany, NJ

Responsibilities:

  • 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.

Peoplesoft HCM Software Engineer/ Consultant

Confidential, Boston, MA

Responsibilities:

  • 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 and mentoring to both technical and functional staff.
  • Managed Confidential technical team and consultants to insure that upgrade was on schedule and within budget.
  • Resolved post go - live issues with Confidential custom policy application, Benefits Interfaces, Payroll Interface and PS Queries.

Peoplesoft HCM Consultant

Confidential, Raleigh, NC

Responsibilities:

  • 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.
  • 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.

Hire Now