We provide IT Staff Augmentation Services!

Techno Functional Consultant Resume

Cincinnati, OH


  • Over 8 years of Techno Functional experience in PeopleSoft Confidential - Core HR, Benefits Administration, Self Service (ESS & MSS), Talent Acquisition Manager, North American Payroll and People tools
  • Extensive experience in Implementation, Upgrade, Development and Production Support of PeopleSoft Confidential
  • Full life cycle implementation of Peoplesoft Confidential projects
  • Subject Matter Expert in Data conversions,Inbound/Outbound Interfaces and Reporting
  • Excellent knowledge in developing fluid user interface in Peoplesoft 9.2
  • Worked in Application upgrade from PeopleSoft 9.1 to 9.2
  • Experience in participating in all phases of the SDLC encompassing requirement analysis, change management, architectural design, technical design, implementation, impact analysis, refactoring, and deployment
  • Strong background in PeopleTools (Application Designer, People Code, Application Engine, Application Package, Component Interface, ExceltoCI, Integration Broker, Pages & Records development, Process Scheduler, Data Mover, Security Administration and PS Query), Unix scripts and Reporting Tools (SQR and XML/BI Publisher)
  • Hands on experience in creating Dashboard and Fluid user interface
  • Good experience in Peoplesoft Testing framework
  • Worked in Banking, Health Care, Telecom and industry clients ( Confidential, Confidential group, Confidential, Canadian Imperial Bank of Commerce, Confidential, Confidential health)
  • Good understanding of PeopleSoft Confidential / HRMS process throughout lifecycle, including design, configuration, development, integration, testing, and deployment
  • Developed custom BI Publisher PDF forms to display real-time data that is captured upon acknowledgment (including new PDF mapping tool)
  • Developed conversions, interfaces, extensions, customizations and reports to address client requirement in accordance with the industry best practices
  • Have good experience in tuning performance of SQLs and programs
  • Expertise in large data conversions using Application Engine, Component Interfaces and File Layouts
  • Part of year end maintenance team and have good knowledge on Advanced SQL (Partitions, Hints etc.)
  • Good understanding about Roles, Permission List and PeopleSoft Row Level security
  • Experience in managing team where responsibilities included setting priorities for design & development and guide them on Prod Support on a day-to-day basis. Manage testing services group
  • Experience in People tools upgrade, PeopleSoft Enhancement, Support & Maintenance, Interfacing / Reporting, Troubleshooting and Production support
  • Worked on solutions outside of PeopleTools using CSS, JavaScript, JQuery, HTML5 and other web development tools
  • Strong technical expertise in module interfacing, data conversion, data migration, data archiving, reporting and writing/debugging People Code
  • Skilled in mapping client’s business requirements and translating these requirements into functional specifications, services, implementations and customized solutions
  • Responsibilities include requirement management , design and development of architectural enhancements, Product Implementation / Integration, Formulating test strategy for the product and testing the same under stress conditions to optimize query related time, onsite coordination, planning and managing day to day activities and interaction with client to facilitate smooth implementation.
  • Extensively worked with Security Administrator to implement security in various levels. Creating Roles, Permission Lists, User Profiles, Portal Security, folders, Content References and Definition Security
  • Excellent troubleshooting and problem-solving skills


ERP: Peoplesoft Confidential /HRMS - Core HR, ESS & MSS, Benefits Administration, Talent Management,Time & Labor, NA Payroll, FSCM 9.1- Asset Management

People Tools: Application Designer, Application Engine, PS/Query, Component Interface, Excel to CI, File Layout, SQR, Data mover and People code

Architecture: PeopleSoft Internet Architecture

Database: Sybase IQ 15.4, Oracle 11g,12c and DB2

Reporting Tools: Crystal reports and BI publisher

Testing Tools: PeopleSoft Testing Framework, HP Quality Center

Job Scheduling tools: Control M, Autosys

Migration Tools: STAT

Project tracking Tool: Service now, JIRA

Languages: HTML5, JavaScript, JQuery, CSS



Techno Functional Consultant, Cincinnati, OH


  • Gathered requirements from the Client, Performed analysis and prepared Functional and Technical Design Documents
  • Developed conversions, interfaces, customizations and reports to address client requirement in accordance with the industry best practices
  • Worked on Pages, Components, Application Engine, and Application Packages, SQRs and used PeopleCode extensively
  • Extensively worked on SQR outbound interfaces (Employee Payroll data)
  • Prepared Unit test cases for the conversion

Environment: PeopleTools 8.54.02, PeopleSoft Confidential 9.1 - Core HR, NA Payroll Oracle Database 11g, Application Designer, SQL, Application Engine, Application package, People code, SQR, BI Publisher, Data mover, TOAD, STAT, Unix


Techno Functional Consultant, Basking Ridge, NJ


  • Gathered requirements from the Business (Vz Wireless and Wireline), Performed analysis and prepared Functional Design Document
  • Creating standard documents - Technical Design, Unit Test, Migrations
  • Created reports using BI(XML) publisher (Including new PDF mapping tool in Peopletools 8.55) using RTF and PDF template and developed People code to send the reports through email using the Confidential branding template
  • Developed people code to send emails using generic templates for voluntary termination
  • Developed PS query reports as per the business requirement
  • Involved in Conversions, Interfaces, Enhancements and Reports
  • Involved in new enhancements or fixing issues related People code, Component Interface, Application Engine, DMS scripts and XML publishers
  • Handled huge volume of data load with complex business rules associated with it. Archived data using custom data backup utility
  • Implemented parallel SQL processing for tuning the performance of the SQLs
  • Fixed SQR report issues
  • Developed HTML and JQuery,CSS code for mobile pages and manager dashboards
  • Designed/Developed PeopleSoft fluid pages for mobile devices by using fluid user interface
  • Involved in data analysis for performance improvements in the upgrade process
  • Performed POC (proof of concept) and prototype for mapping and verify if delivered process/workaround can be used to map with existing legacy process.
  • Designed and developed data archival process using application engine program
  • Extensively used process scheduler for scheduling recurring process for conditional Scheduling of successive process for setting up the reports to run at specific time and implementation of batch processing
  • Created of Partitions for the custom tables and worked on fast refresh feature of materialized views as part of year-end activities
  • Created Application Engine programs, File Layouts to load the CSV files into staging tables and from staging tables to various PeopleSoft tables
  • Developed fluid dashboard for tracking pending courses in Peoplesoft ELM
  • Developed Dashboard to manage team learning activity and send reminder emails
  • Created PDF templates using Adobe acrobat Pro for BI reports
  • Worked on integration between PeopleSoft and Java based application using Integration broker
  • Configured PeopleSoft security for providing page access
  • Extensively worked on debugging and fixing runtime errors during testing
  • Developed unit test scripts in Peoplesoft Testing Framework
  • Responsible for quality assurance testing of all system development and enhancements prior to production implementation
  • Migrating the database objects from one environment to other through data mover scripts and STAT tool
  • Attended the Daily Scrum calls and Worked on Estimates during the Sprint planning calls
  • Maintained Sharepoint documentation
  • Conducted meetings with the users and the testing team and involved in discussing their problems and helped them out in finding the proper solutions for their requirements

Environment: PeopleTools 8.55.02,PeopleSoft Confidential 9.2 / 9.1 - Core HR,TAM Oracle Database 12c and 11g, Application Designer,SQL, Application Engine, Application package, Integration Broker,People code, SQR, BI Publisher,Data mover,TOAD, JIRA, STAT,Unix


Techno Functional consultant


  • Peoplesoft Techno functional consultant for Confidential HRMS project
  • Configuration of Core HR tables and loaded data into the Peoplesoft system
  • HRMS Outbound integration to send employee's overall rating information to GDW(Global Data Warehouse) through incremental feeds
  • Utilized XML / BI publisher to generate reports to meet the requirements
  • Administered established benefit plans and programs, specializing in leave of absence determination and enrollment
  • Developed Fluid dashboard for mobile devices
  • Created audit records for various component records
  • Prioritize tasks and meet deadlines in a fast-paced environment
  • Involved in Customizations for Online Objects like Pages, Menus and Components, which involves coding in People code
  • Mapped client’s requirements and changes to customize the SQR reports accordingly
  • Independently managed a huge volume of data load with complex business rules associated with it; accomplished data using custom data backup utility
  • Led the development of application engines, file layouts and custom run control pages right from conceptualization to effectuation
  • Planned Oracle database refresh process for SIT and UAT environment
  • Coordinating with other internal departments including Quality Assurance, Operations Team and Production Support
  • Setting up test data, performing unit testing and fixing of defects during UAT
  • Provided Support for Autosys Job scheduling process
  • Ensured System Development Life Cycle and change management procedures are followed and documented to support development efforts.
  • Extended support for migrating the database objects from one environment to other through data mover scripts and STAT tool
  • Managed the database tablespaces size threshold issues and creation of partitions for the custom tables for year-end activities

Environment: PeopleTools 8.52/8.53, PeopleSoft Confidential 9.1 - Core HR,ESS,MSS, Oracle Database 11g, Application Designer,Sql, Application Engine, People code, SQR, Application package,BI Publisher, Service Now, STAT,Unix


Technical Developer


  • Worked extensively on technical design documents by using BRD’s
  • Performance tuning of complex and long running processes
  • Involved in design and implementation of standard heading SQC's customized to suit client requirements for SQR reports
  • Conversion of DB2 SQLs to Oracle compatible SQL
  • Evaluated and allocated jobs scheduling sequence in Control M Job scheduler
  • Customized pages as per the requirements specified
  • Developed BI publisher reports to meet client’s requirement
  • Extensively worked on Application Designer, Application Engine and People code
  • Performed problem analysis and requirement analysis to get the feasible solution
  • Understood and implemented client’s specifications while developing SQR reports
  • Run Periodic security jobs to refresh SJT tables and run portal security Sync when required prepared SQR programs for crystal reports
  • Tuned application engine programs to increase performance
  • Created Run Control pages, Run Control records, Components, Process Definitions
  • Retrofit and modifying the HR reports as per PS 9.1 Data structure, bringing forward all the reports from 8.9 to 9.1
  • Created unit test plans, test scripts, test scenarios and test data
  • Created Peoplesoft Testing Framework automation scripts and migrated them to SIT instance
  • STAT tool to migrate the projects and fixes from one environment to another environment

Environment: Peopletools 8.51, Peoplesoft Confidential 8.9 to 9.1, DB2 to Oracle Database, Application Designer, Application Engine, SQL, Application package, People code, SQR,Unix, BI Publisher, Control M


Technical Developer, Quality Coordinator


  • Data conversion between Confidential TBA(Total benefits Administration) and Peoplesoft
  • Customized Direct Deposit page to store the Wired information
  • Created custom SQR process to generate Wires outbound flat file
  • Involved in Payroll Processing Pay Calendar, Paysheet Creation, Pay Calculation, and Pay Confirmation
  • Worked on payroll tables like PS PAY CALENDAR, PS PAY CHECK,PS PAY EARNINGS, and PS PAY DEDUCTIONS etc
  • Involved in design and implementation of standard heading SQC's customized to suit client requirements for all the payroll-related reports
  • Customized SSN match page and Pay109 SQR process to meet client requirent
  • Tuning the performance of the SQR reports and inbound/outbound interfaces
  • Extended major assistance in developing and modifying outbound and inbound SQR interfaces
  • Developed AE to CI inbound interface program to load the Personal data, Job data and Position data
  • Hands on experience in running the payroll cycle
  • Worked on Pay015a check paid inbound and Pay015b check reconciliation SQR process
  • Created reporting queries using Query manager
  • Ran several off-cycle and on-cycle payrolls as a part of testing
  • Developed a dynamic run control page for custom SQR reports
  • Developed and modified components, file layouts, pages, records, fields, process definitions and registered components in portal, menu and permission lists
  • Supported the online changes to the delivered pages, components, menus and translate values
  • Designed the process scheduling sequence and timeline for Control M process scheduler
  • Performed Code Review and Unit Testing and wrote test scenarios in preparation for migration to Test environment for Functional User Testing

Environment: Peopletools 8.51, Peoplesoft Confidential 9.1,Core HR, Benefits, NA Payroll and Oracle Database, Application Designer,SQL, Application package, Application Engine, People code, SQR,Unix, BI Publisher, Application Engine to Component Interface


Associate Consultant


  • Transformed data from IBM Maximo to meet PeopleSoft specifications
  • Responsible for delivery of Data Conversion, Mapping Specs, Functional Specs, Design Documents, Test Scripts and Security Matrix
  • Created:
  • Business units, Asset Profiles, Asset Classes, Asset books and Asset categories in FSCM
  • Permission lists, users, roles and assigned roles to users
  • Configuration file for AM implementation
  • DMS scripts for database tables migration
  • Training manuals
  • Technical Helpdesk training manuals
  • Supported data analysis, data mapping and data conversion from legacy system to PeopleSoft application database tables using SQR, File layout and Excel to CI
  • Enabled auditing records and fields as per client’s requirement
  • Loaded data from interface tables into AM tables
  • Calculated Depreciation for loaded data
  • Planned on Process Scheduling
  • Developed custom Pages using Application designer
  • Worked on various modifications involving the changes to components and People Code
  • Migrated:
  • Tree’s using Tree Manager
  • Objects through Application designer
  • Addressed & resolved data and configuration issues in DEV/TST and migrating to TST/PRD
  • Participated in WebEx Technical helpdesk training session
  • Assisted the Confidential project to handle Technical issues
  • Participated in the after-hours/on-call support rotation to ensure applications and systems have a high degree of reliability on a 24/7 basis

Environment: Peopletools 8.49.12, Peoplesoft FSCM 9.1 and Oracle 11g Database, Unix, Application Designer,SQL, Application package, Application Engine, People code, SQR, Excel to CI


Technical Consultant


  • Reviewed Functional Design Documents and converted into Technical Design Document
  • Tracked tasks using RICEFW ID and developed Peoplesoft definitions as per the client’s requirement
  • Developed People code to implement business rules and to validate data entry
  • Generated sample flat files using Crystal reports
  • Served as a part of conversion team engaged in uploading data from flat files into database
  • Created new custom pages & people code as per the client business requirement
  • Developed new queries using PS query reporting Tool to generate reports
  • Prepared SQR code for uploading high volume of data into database after performing necessary validations according to client requirement
  • Written SQR's from scratch to generate Reports in PDF format
  • Worked on Excel to CI and File layout to load data into Peoplesoft setup data
  • Developed use cases, as well as unit/system/UAT test scripts
  • Developed & written DMS scripts for migrating data from one environment to another
  • Resolved Production support issues

Environment: Peopletools 8.49.12, Peoplesoft Confidential 9.1,Core HR, Benefits, NA payroll and Oracle 11g Database,Unix,SQL, Application package,People code,SQR,PS query manager,DMS script

Hire Now