We provide IT Staff Augmentation Services!

Sr. Technical Consultant Resume

4.00/5 (Submit Your Rating)

SUMMARY:

  • Over 6 years of impressive experience in developing PeopleSoft HCM and Campus Solutions software applications for implementation, upgrade, conversion, support, maintenance and retrofit projects.
  • Worked extensively on platforms ranging from PeopleTools 8.49 to 8.55 with applications being on PeopleSoft 8.x to 9.2.
  • Extensively worked on HRMS/HCM modules, specifically the Core HR, NA Payroll, Base Benefits, Time & Labor (T&L), Employee and Manager Self Service (ESS & MSS), Pension, Workforce Administration and Position Management.
  • Strong experience working in Campus Solutions modules like Campus Community, Admissions, Student Records, Academic Advisement and Financial Aid.
  • Rich experience working closely with customers, business analysts and functional SMEs, Developing business requirements and functional designs into a technical design documents.
  • Experienced in various stages of project development life cycles like Requirement Gathering, Analysis, Design, Configuration, Development, Implementation, Fit - Gap, Data mapping and Conversions.
  • Worked on the People tools 8.54 & 8.55 and developed new pages, components using the Fluid functionality . Created Dashboards, Work Centers and used Pivot Grids to create reports.
  • Having strong knowledge and experience in developing and customizing PeopleSoft applications using Application Designer, Application Engine, PeopleCode, Component Interface, File Layout, Application Packages, Approval Workflow Engine (AWE), Integration Broker, Fluid Pages, Web Services, SQL, Process Scheduler, Data Mover etc.
  • Expertise in the creation of complex reports using Connected Queries, SQR and PS Query.
  • Experience in Data Conversions between PeopleSoft and legacy systems including conversion of JOB data, Personal Data and Payroll Data (Earnings, Deductions, and Taxes) and Base Benefits.
  • Performed extensive debugging and performance tuning of various processes. Well versed in utilizing tools and utilities like People Code Debugger, Application Engine Trace for troubleshooting.
  • Worked on file based inbound & outbound interfaces using Application Engine and SQR.
  • Reviewed functional specifications, performed configuration, design, build and unit testing. Coordinated on user acceptance testing and documented migrations/releases.
  • Good exposure to Task Management like estimation, planning, tracking, monitoring and communicating Task progress etc.
  • Strong presentation, documentation skills and developed various technical specs with Test Plans and Procedures.

TECHNICAL SKILLS:

PeopleSoft HRMS Modules: PeopleSoft HCM (HRMS) v 9.2/9.1/9.0/8.9/8.8/8.3, Core HR, NA Payroll, Base Benefits, Benefits Administration, Pension, Workforce Administration, Position Management, Compensation, Employee Self Service, Manager Self Service and Time & Labor.

PeopleSoft Campus Solutions: PeopleSoft Campus Solutions v 9.0

Modules: Campus Community, Admissions, Student Records, Academic Advisement and Financial Aid.

People Tools/ Utilities: PeopleTools v 8.55/8.54/8.53/8.50/8.48/8.45/8.43, Application Designer, People Code, Application Engine, AWE - Approval workflow engine, Component Interface, File Layout, Application Messaging, Integration Broker, Process Scheduler, PS Query, Data Mover, Workflow, Excel to CI, STAT and Security.

Reporting Tools: BI/XML Publisher, SQR and PS Query

Operating Systems: Windows 2000/NT and UNIX

Languages: C, C++, HTML, XML and SQLRDBMS: Oracle 8.x/9i/10g/11g, SQL Server and DB2

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Technical Consultant

Responsibilities:

  • Identified required PeopleSoft tables and prepared mapping documents for data conversions from legacy to PeopleSoft (PeopleSoft HR, Payroll, Benefits, and Time & labor, Absence Management).
  • Principle Developer for upgrade project - from PeopleSoft 9.1 to PeopleSoft 9.2 and People Tools 8.54/8.55.
  • Used the Application Engine for writing the Component Interfaces in Payroll and Base HR modules for reapplying the business logic associated with PeopleSoft delivered components using the existing PeopleSoft Component APIs.
  • Developed the SQR program to read the STD data from MetLife file and load into AMTS and ARC tables and processed.
  • Developed application engine program for loading ARC data from Flat Filed to PeopleSoft Payroll tables using component interfaces.
  • Developed number of validation edit to make sure the data is clean before loading the data into the application tables.
  • Developed custom fluid classes Self Service component with enroll, drop, swap, and waitlist functionality
  • Worked on mapping the data from legacy to the new system and involved in setting up the configuration data.
  • Created/modified new Records, fields, pages, components and menus according to business requirements. Developed fluid pages and components as part of online customization.
  • Prepared the technical design documents and detailed test plan for unit, system integration testing.
  • Managed change requests in relation to the project plans to ensure agreed deadlines are met
  • Worked on Application Designer, People Code, Application Engine, Component Interface, File Layout, Data Mover, Integration Broker, Interface, Work Flow, Security etc.
  • Resolved post go-live issues.
  • Actively participated in the team meetings for understanding the client needs and does established strong and successful delivery.

Environment: PeopleSoft HRMS/HCM 9.2, People Tools 8.55, Oracle 11g.

Confidential, PA

Technical Consultant

Responsibilities:

  • Gathered and analyzed the requirements, created Specifications, and designed and developed CI based web services & user-defined methods for delivered & customized components.
  • Developed online customizations as per business needs to provide an end-to-end integration.
  • Worked on Application package and record People Code, Integration Broker and message People Code.
  • Created Excel-to-CI templates and Application Engine Programs for data conversion.
  • Monitored and guided the team members in completing and delivering their assigned tasks.
  • Involved in migration of the projects to qualification environment and delivering the final packages to be installed in client environment.
  • Performed code reviews, specifications reviews, updated related logs & sent regular weekly updates to client as part of quality process.
  • Provided demo to the client about the finished developments before user testing.
  • Involved in System and Integration testing of the application. Supporting the users during UAT in resolving functional queries related to upgraded application.
  • Discussed and provided support during the system testing and UAT to solve any functional/technical issues that arise and finish them within SLA time lines.
  • Worked on application designer, people code, application engine, component interface, file layout, data mover, integration broker, work flow and security.
  • Involved in setting up security using roles, permission lists, and campus objects security through setup SACR.
  • Reviewed the work products of the peers before delivery.
  • Resolved post go-live issues. Handled critical defects during go-live, provided postproduction support facilitated the client with all the required documentation for keeping the on-going application support comfortable.

Environment: PeopleSoft Campus Solutions 9.1, People Tools 8.54, Oracle 10g.

Confidential

Sr. Techno Functional Consultant

Responsibilities:

  • Did compare objects analysis for PeopleSoft HCM and identified list of objects for retrofit and removals.
  • Created Fit Gap, Functional Design Documents and technical design documents.
  • Developed online custom objects including records, pages, components, application engines, component interfaces as per functionality
  • Involved in retrofits and conversions as part of the upgrade project.
  • Developed Application Engine/Component Interface Programs for Data Conversion, Enroll Time reporters.
  • Worked on the Payroll interface to send the file to SAO using Application Engine.
  • Involved in analysing the compare reports as part of upgrade project.
  • Developed custom Application Engine process to load the pay sheet data to the push up table using file which will pull later by pay sheet load process.
  • Customized Incident Details page under Health and Safety by adding Preventable flag to verify whether an incident is preventable when recoding an incident.
  • Customized on Payroll Certification Report MAXAMSR1 to be sent to the State Auditor's Office for the PS to AMS Interface File Creation.
  • Worked on AMS to PeopleSoft Payroll Interface Audit Report (MAXHR01A.SQR) to make sure it gives appropriate results in the output. For example valid earnings and deductions for the employee from the input file should not error out, if earnings are not setup in PeopleSoft and it should be printed in ERROR/AUDIT report.
  • Created employee, manager and delinquent CDL standard letters/reports by using XML Publisher.
  • Worked on the SQR and Crystal retrofits as a part of upgrade from 8.8 to 9.2.
  • Worked on Time Sheet Report online to populate the Task elements based on the Task group and Task profiles.
  • Modified and Retired some of the T& L rules SQL’s as part of retrofits in upgrade and tested by executing time admin process to verify whether the rules applied to the timesheet.
  • Worked on Application Designer, People Code, Application Engine, Component Interface, File Layout, XML Publisher, Data Mover, SQR, UNIX Scripting, Crystal, Work Flow, Security etc.
  • Created Unit test and Migration documents for retrofit/customized objects.
  • Provided support for end-user testing and defect resolution.

Environment: PeopleSoft HRMS/HCM 9.1, People Tools 8.53, Oracle SQL Developer 4.0

Confidential

Technical Consultant

Responsibilities:

  • Acquired the applications knowledge from the client.
  • Prepared the business technical unit testing document (BTUD) and PeopleSoft Hand Book (PHB) documents for the applications.
  • Given the playback presentations to clients for the applications.
  • Analyzed the tickets and categorized whether it has a bug fix, enhancement or Business As Usual (BAU) and also provided reliable solutions to the customer.
  • Developed custom conversion programs (AE/CI and SQRs) for converting the data from core tables.
  • Involved in the setup of the foundation data for Human Resources and Payroll modules.
  • Understand business requirements and functional specifications and translate to technical solutions.
  • Converted complex SQR programs into Application Engine programs to make use of Component Interface and People Code.
  • Involved in requirements gathering for new enhancements while implementing change requests.
  • Worked in creating workgroup population engine for employees in time and labor module.
  • Data uploads using application engine and component interface to load data into the job data component.
  • Prepared impact analysis, technical design document and test case document for Bug fix and Enhancement requests.
  • Enhancement of Benefit Interface SQR’s.
  • Prepared Test cases for Tax update based on the Release Notes.
  • Performed Tax update tasks before submitting to User.
  • Created Service Request, Change Request and Incidents using Maximo Tool.
  • Created base line and modified archive sets for project/object migration using STAT Tool.

Environment: PeopleSoft HCM 9.0, People Tools 8.51, Oracle SQL Developer 3.0.

Confidential

Developer

Responsibilities:

  • Prepared technical specifications documents based on the functional design
  • Client Provide Data in CSV Format. Developed Application Engine with Component Interface (CI) Programs, read data from CSV and store into a staging table. From staging table to PS tables using CI.
  • Worked on Excel to CI template to load data into components.
  • Collaborated with onsite and offshore functional teams in completing technical design
  • Performed peer reviews for specifications, code, test plan, test results, and documents to ensure standards are properly adhered during document or code preparation.
  • Created and Executed Unit Test Plan, Scenarios and scripts
  • Created knowledge acquisition documents (KAD) and presented playback sessions to the client.
  • Shared the application knowledge to the team members.
  • Coordinate with team members and make sure that the KAD document should be updated if any enhancement happens to one of the applications in HR module.

Environment: PeopleSoft HRMS 8.9, People Tools 8.22/8.47/8.48/8.49, Oracle 9i, Windows XP.

We'd love your feedback!