We provide IT Staff Augmentation Services!

Technical Consultant Resume Profile

NY

Summary:

  • Having 7 years of experience in Implementation, Customization, Development, Testing and Production Support of Oracle PeopleSoft HRMS in Core-HRMS, Employee Self Service, Payroll, benefits and Time and Labor modules and PeopleSoft Financials in AR, Project Costing, Asset Management, Purchasing and General Ledger.
  • Having Oracle Certified Core HRMS functional training.
  • Good working knowledge of PeopleSoft HRMS modules Core HRMS, Recruiting, Campus Solutions, Time and Labor, Global Payroll, North American Payroll.
  • Gained good knowledge of PeopleSoft HRMS tables/structures technically and good knowledge of setting up the Core-HRMS tables.
  • Good working knowledge of PeopleSoft Financials modules Project Costing, Asset Management, Purchasing, Account Payables, Account Receivables and General Ledger.
  • Worked extensively on People Tools such as Application Designer, People Code, Application Engine, Component Interface, File Layout, Application Packages, Integration Broker, Process Scheduler, Data Mover and Reporting tools like XML Publisher, SQR, Crystal Reports, PS Query.
  • Proficient with PeopleSoft HCM/FSCM database and PIA. Very sound RDBMS concepts and good database programming experience using Oracle 9i/8i, MS SQL Server 7.0/6.5, SQL, PL/SQL and SQL Loader.
  • Extensive experience in transferring existing data from legacy system to PeopleSoft application database tables using SQR, Application Engine, People Code, File layout and Component Interface.
  • Worked extensively on the inbound and outbound interfaces using Application Engine and File Layout.
  • Designed and implemented various conversion programs for populating the PeopleSoft set up tables from the Input file sent by client using Excel to CI, SQR, Application Engine, File Layout and Component Interfaces.
  • Excellent Documentation skills in the creation of Technical Design Documents, Test Scripts and Detailed Design Documents.
  • Organizational PeopleSoft Support to end-users as well as development team during and after the implementation of the project. Solid working knowledge of reporting tools like SQR, Crystal Reports, PS Query and XML Publisher.
  • Significant PeopleSoft implementation experience from project conception through roll-out which includes fit gap analysis, development, major customization, testing, and training.
  • Good working knowledge of the PeopleSoft Internet Architecture, People Tools 8.51, Web logic and Tuxedo.
  • Knowledge of app server configuration, PIA, Process Scheduler, web server.
  • Experience in Debugging and Tracing People Code, SQL, Application Engine and SQRs.
  • Team player with excellent interpersonal communication skills and technical documentation skills.
  • Excellent in problem solving, logical and analytical abilities and self-learning attitude.
  • Strong analytical skills to convert Functional design specifications into Technical Design specifications.
  • Excellent oral and written communication skills.

Skills Summary :

PeopleSoft Application

HCM/HRMS 9.1/9.0/ 8.9/8.8/8.3/8.0 Core HR, Payroll, Base Benefits, Benefits Administration, Benefits, Self Services

Financials AR, Project Costing, Asset management, Purchasing, Treasury and General Ledger

People Tools

Application Engine, File Layout, Component Interface, Application Package, People Code, Application Messaging, Integration Broker and Data Mover.

Reporting Tools

SQR, PS Query, Crystal Reports, XML Publisher.

Operating systems

Windows-95/98/NT/2000/XP, MS-DOS, UNIX

Languages

C, SQL-PL/SQL, XML.

Databases

SQL Server, Oracle 9i/8i, Oracle 10g/11g, DB2

Database Tools

Toad, SQL Tools, SQL Developer, Teradata SQL assistant

Work Experience

Confidential

Role: Technical Consultant

Responsibilities:

  • Created Interface to read the XML doc file from third party and load data for External/Internal Applicants.
  • Created Interfaces to process Internal Hires to handle Demotions, Promotions and laterals.
  • Created the component to hold exception data for Internal Applicant, to show any exception generated by the custom interface.
  • Created Workflow to route the on-boarding emails and Worklists to HR Administrator and specific roles.
  • Modified the SQR programs, Wage Works Transit Interface to generate a file and report of employees with pre-tax and post-tax transit deductions for the current run id's and Annual Load of ICT Data MER and API to be used by the Integrated Compensation Tool.
  • Modified the heavily customized Integrated Compensation Tool to correct the Salary Amounts and their layout.
  • Created the Integration Broker from scratch Messages, Services, Service Operations, Application Packages for Hiring Managers and Employees on boarding in Third Party system Red Carpet.
  • Worked extensively on the online modifications of pages using Application Designer, People Code and SQL based on the client's requirement.
  • Created the mainframe JCL's for executing SQR jobs and making any database changes.

Confidential

Responsibilities:

  • Monitoring the Incident reporting tool on daily basis and resolving issues within SLA based on the priority.
  • Developing the technical design documents for new Change Request.
  • Analyzing, designing the RFC Request for change documents and fixing the bugs reported by the customer after requirement gathering.
  • Fix, Test, deliver the bugs and keeping tract till it's closed.
  • Involved in development and customization of financial reports using SQR and XML as reporting tools.
  • Involved in the preparing DMS scripts to export and import data in production environments.
  • Involved in the peer review of development.
  • Worked extensively on the online modifications of pages using Application Designer, People Code and SQL based on the client's requirement.
  • I am involved in contributing learning and Knowledge management documents to the common repository, which can be further used by the entire team.
  • I have done the server related tasks like bring the Application Server, process Scheduler and Web server up whenever it is down using Putty.
  • Closely Monitoring the scheduled batch jobs in Control-M and Linux server for any performance and job abend issues
  • Created the mainframe JCL's for executing jobs. Have working experience in Linux.

Confidential

Responsibilities:

  • Monitoring the client's HRMS mail box on daily basis and moving the items in the corresponding folders.
  • Setting up the Department, Department Trees based on the client's requirement.
  • Created conversion programs to populate the various set up tables like Department table, Salary Plan, Grade and Step, Company table, location table etc. using Application Engine, File Layout, Component Interfaces, Excel to CI, Peoplecode and SQL.
  • Identifying the People Leader designation forms from the client's HRMS mail box and making the employees as people leader in JOB Data/ removing them as the people leader/ replacing employees existing department with a new one.
  • Providing third party tool access to the employees based on the online compensation forms received on day to day basis.
  • Have worked in creating the user profiles of employees based on the client's request.
  • Conducted unit testing and resolving any identified issues

Confidential

Role: PeopleSoft Technical Consultant

Responsibilities:

  • Development of the allocated gaps according to the client's requirement.
  • Development and running of Unit testing after the development.
  • Involved in the writing and reviewing of different Technical Specs for the new customizations and developments.
  • Developed various complex reports using XML Publisher reporting tools, Application Engine, File Layout, XML file and PS Query such as:
  • Banking report to list the details of cheques taken for a particular business date by cashiering office drawer, BSB and amount . The report also displays the total of the cash receipted, and be in a format that can be presented to the bank.
  • Generated the report for Invoices generated by the delivered COBOL process and display in the Invoice details in the format suggested by the Client.
  • To generate a receipt to be presented to the customer when a payment is received from a student or Organisation through the University Cashering office
  • The requirement is to use the data that the delivered process generates and display it in an invoice format that meets the University of Ballarat's requirements.
  • Have done page and component customizations for student financials module. Written and modified the People Code and SQL as per the client's requirement.
  • I have worked extensively on the new reporting tool: XML publisher reports.
  • Participated in weekly project status meetings for offshore.

Achievements: -- University of Ballarat was the first implementation of Campus Solutions v9.0 in the world. This project has got lots of appreciation from the Australian client for the successful completion of all the customizations ensuring deadlines and the deliverable dates.

Confidential

Role: Peoplesoft Technical Consultant

Responsibilities:

  • Creating the data excel sheets for masters data on daily basis.
  • Migration of the scripts from one instance to another and setting forth the methodology for the same.
  • Monitoring and review of the masters on weekly basis.
  • Testing and customizing the scripts using the PSScripts automated testing tool to run the entire business flow for full factoring.

Confidential

Role: Oracle PeopleSoft Trainee

Responsibilities:

  • Attended In-house SQL and PL/SQL training.
  • Have been a part of Communication and ethics training.
  • Attended various team-building trainings.
  • Attended very basic Java training.
  • Attended the basic XML Publisher training.
  • Involved in the development of shadow project during the general Oracle training.
  • Have attended the basics training on People Tools and PeopleSoft Application.

Hire Now