We provide IT Staff Augmentation Services!

Sr. Peoplesoft Consultant Resume

PROFESSIONAL SUMMARY

  • Provided 13+ years IT-Consulting expertise for complete ERP Software development lifecycle (SDLC) in AGILE & Waterfall methodologies. Lean Software Development process involving business & system analysis, design development, customization, configuration, setup, integration, upgrade & enhancement, functional testing & Service Level Agreement (SLA) based Production Support in multiple industries such as Banking & Financial institution, Aviation, Communication, Media & Publication, Government, Education, Utility, Energy, Manufacturing, Textile, Petrochemical, Retail, Consulting & Information services.
  • Experience in Procedural & Object-oriented programming (OOP) in Web-based environment distributed n-tier & Client/Server PeopleSoft Internet Architecture (PIA), Relational database (RDBMS) & BORM.
  • Perform requirements analysis, planning, management & communication, Solution assessment & validation, business process improvement, FIT-GAP, Conduct JAD Session, daily standup meetings and prioritization, Create Business requirement (BRD), Functional (FDD) & Technical design documents (TDD), Test/QA strategy scripts-case, UML diagram, use case, UI guide/training material.
  • Create Reports, I/O Interfaces, Enterprise integration points(EIP), Web services, 3rd party & legacy system Integration, User Interfaces, Extraction transformation loading(ETL), Data Mart & Migration, Job scheduling, batch processing, PS-Security, Workflow, Portal, PeopleSoft Objects, PeopleCode Events, DMS script, stored procedures, functions & triggers, PeopleCode events, develop & performance tuned application.
  • Experience in various Programming languages. Modeling, management & Testing tools, PeopleTools, Reporting Tools, Workflow Technology, Security, System & Server administration, Software, Patches & Bundles, Business Object Management, Automation & Configuration Tools, Data Management.
  • Proactive with a strong bias for action. Inquisitive with desire to continuously. Highly motivated with effective time management, interpersonal skills. Ability to work both independently as well as in a team. Immediate availability and willing to relocate.

PROFESSIONAL SKILLS

Programming Languages: PeopleCode, SQL / PLSQL, Java, HTML, XML, Visual Basic, C++, Java / VB Script, ASP, COBOL.
ERP: PeopleSoft 8.X/9.X HCM/ HRMS, ELM, CRM, Financials, SCM, EPM, EPM, Student Admin modules.
PeopleTools(PT): Application Designer, PeopleCode API, Application Package, Application Engine(AE), Component Interface(CI), Integration Broker(IB), Application Messaging, Business Interlink, Web Services, File Layout(FL), Portal Pack , Tree Manager, Workflow Technology, SQL Editor, Cube Manager, Change Packer, Upgrade Assistant, Analytic Calculation Engine.
Reporting Tools: PS-Query, SQR, XML Reporting, BI Publisher, Crystal Reports, nVision, Tree Manager.
Administration Tools: Process Scheduler, Configuration Manager, Compare reports, STAT 5.1, Security Administration, System & Server, Setup & Cube Manager, Software Updates, Upgrade Assistant, Import Manager, Data Mover, Resource Scheduling Tools, Performance Monitor, Business Object Management, PS Global & Internet technology, Analytic Calculation Engine, MultiChannel Framework, Mobile Agent.
Database Technologies: Oracle 11/9i/8/7.x, SQL Server 2000/7, MySql, DB2 8, MS Access, TOAD, Golden, PL-SQL, Putty, PS Data Management tools, Data Mover, BORM model.
Operating Systems: Windows 95/98/2000/NT/XP/Vista, UNIX.
Application / Web Servers: Weblogic, Tuxedo, Jolt, Apache 2.0, Microsoft IIS.
Web Technologies: WebEx, SOAP, Pagelets, Servlets, Cognos, Adobe Photoshop, Flash.
Modeling & Management: Data Modeling, Enterprise Architect, Rational Requisite Pro, Rational Modeler.
Testing Tools: Mercury tools, Test Tracker & Director, Win Runner, Load Runner, ClearQuest, ClearCase, Send master, PS Integration Testing Utilities & Tools, Snag-It.
Microsoft Tools: Visio, Projects, Access, Excel, Word, PowerPoint, Outlook, Publisher, Front Page.

PROFESSIONAL EXPERIENCE

Client: Confidential, GA Dec 2010 to Till Date
Title: Sr. PeopleSoft Consultant.
PeopleSoft 8.9 to 9.1 Upgrade & Production Support.
Modules (FIN, SCM,HCM, CRM, EDI, Portal)
Responsibilities:

  • Worked on TAM setup & customizations for job openings, job postings, applications, questionnaires, applicant screening, interview evaluations, job offers and hiring process & templates & Recruiting statuses.
  • Customized PeopleSoft TAM application for complete hiring process from Applicant in Draft status to integrating with Workforce Admin once the applicant status is hired as per business requirement.
  • Integrated TAM with 3rd party for resume processing, background checks & Job openings with various job boards.
  • Developed & Setup EDI transactions between PeopleSoft & Biz Manager using Integration broker, Created custom handlers for inbound / outbound transactions.
  • Designed & developed integration between PeopleSoft CRM & FSCM as per business requirements.
  • Developing custom PeopleSoft Object definitions to implement GUI business requirements.
  • Worked on various scheduled & batch processes using AE program & SQR.
  • Perform setup, configuration, security to implement required functionality.
  • Performance tuned SQL, SQR & PeopleSoft programs using Application packages.

Environment: PT 8.51.11, Oracle 11.2.0.1.0, Soap2UI, XML Spy, Windows XP, UNIX, Reporting Tools, ETL tools, Integration Tools, Java SE Development Kit , Mercury testing tools, Golden, Oracle Sql, Ultra-Edit, WebEx, SQR, XML, HTML, Java Script, Visio, MS Projects, Microsoft Office, Visio, Snag-It.

Client: Confidential, CA May 2010 to Dec 2010
Title: Sr. PeopleSoft Consultant.
PeopleSoft 8.8 to 9.1 Upgrade & Production Support.
Modules(CRM Web Services,)
Responsibilities:

  • Designing & Developing Application Packages, to provide & consume web services using PeopleSoft Integration Broker, Soap2UI, XMLSpy for developing, Testing XML & SOAP messages.
  • Developing custom PeopleSoft Object definitions to implement GUI business requirements.
  • Providing support for Change control & implemented PeopleSoft Security. Also working on Data Masking & Data Encryption. Performed setup configuration to implement security.
  • Created various batch & Ad-Hoc processes, scheduled Job to implement reporting, data conversion requirements using Application Engine & SQR programs.

Environment: PT 8.50, Oracle 10g, Soap2UI, XML Spy, Windows XP, UNIX, Reporting Tools, ETL tools, Integration Tools, Java SE Development Kit , Mercury testing tools, Golden, TOAD, Ultra-Edit, WebEx, SQR, XML, HTML, Java Script, Visio, MS Projects, Microsoft Office, Visio, Snag-It.

Client:Confidential, RI November 2008 to March 2010
Title: Sr. PeopleSoft Consultant.
PeopleSoft 8.8 to 9.1 Upgrade & Production Support.
Modules(HRMS, Core HCM modules, Benefits, Pension, Compensation & Budgeting, Workforce Admin, Time & Labor, Payroll & Interface, Competencies, Positions, Variable Compensation, Stock, Absence Management, Recruiting, Admissions & Talent Acquisition Manager (TAM), Learning & Training, ePerformance, Manager/Employee & other Self Service modules.)
Responsibilities:

  • Provided Functional setup, configuration, customization & SLA based Production Support for PeopleSoft TAM Upgrade & enhancements. Prioritized multiple tasks thru Triage process while maintaining deadlines for implementing Global Operating Model involving 16 countries.
  • Designed, developed & customized I/O Interfaces & batch processes using SQR, AE, CI, FL & Application Packages, schedule jobs & ETL, Data Conversion for PeopleSoft TAM & 3rdparty system.
  • Analyzed, Developed & Customized PS Objects & Definitions such as Components, Pages, Menu, PeopleCode events, SQL queries, Application Package, Java classes, SQR, DMS Scripts, Triggers, Stored procedures and modified table structures & bolt-on's to increase the functionality, usability & performance of application for PeopleSoft TAM & Recruiting.
  • Worked on Business Interlink, PS Synchronous &, Asynchronous Integration technology Batch publishing & executing table loading sequence for Full data publish. Created integration using internet standards such as HTTP, HTML & Web services such as Extensible Markup Language (XML), Simple Object Access Protocol (SOAP) & Web Services Description Language (WSDL). Worked on Structured & Non-Structured messages using IB, CI, App packages, AE transformations to addressing integration requirements. Configured & maintained Gateway properties, Listening & Target Connectors, Nodes, Transactions, Relationships. Used Integration Point Wizard & tuned system performance.
  • Used Workflow Technology development tools to extend workflow capabilities by building Workflow maps, Defining roles & Users, Work list records, Event triggers, Approval processes, Designed activity guides & navigator maps, Added events & routings. Administered & Scheduled Workflow Processes, Setup Workflow Defaults & Notification Options, Defined Worklist messages, Monitored Worklist Volumes & Checked for Worklist Timeouts, online work items & Ran Workflow reports.
  • Created & customized Reports from various data sources using SQR, PS-Query, Crystal reports, XML Publisher, nVision & SQL Server Reporting Services (SSRS). Created complex Queries & Performance Tuned SQL query, sub queries, physical indexes, materialized views, Filtering clause etc based on the requirement optimized for better performance.
  • Worked on Security design, implementation, maintenance & Testing roles, permissions, portal administration, definition security, data security (Encryption & Masking), Create, copy &, delete Permission Lists, Roles, Define User Profile Types & Profile Data, Configured Distributed User Profile & Dynamic Role Assignment, Process Definitions and Groups, Used Report Manager & Compare reports. Implemented & communicating Change Control. Administered Query Security, Audit Security Tables & Experience with security audit, compliance, prevention & procedures.
  • Performed Functional, System, Integration, UAT, Regression, and Load/Performance & Security testing for internal/external components. Created Test plan, Managed Testing/QA activities, defects & resolution. Developed, executed test scripts & validate results. Identified test environment requirements for end to end data & system validation and ensured quality of test data.
  • Worked closely with business owners, Architects, SME, Functional & Technical resources and service delivery. Created & maintained Traceability matrix to implement business rules, requirements to fulfill organizations strategic needs, policies & market business approaches. Business process modeling for performance, scalability & quality of service (QoS), security & usability. Created BRD, FDD, TDD & Training material. Developed User productivity kit (UPK).

Environment: PT 8.50, Oracle 11g, SQL Server, Windows XP, UNIX, Reporting Tools, ETL tools, Integration Tools, Send master, Java SE Development Kit , Mercury testing tools, Golden, TOAD, Ultra-Edit, WebEx, SQR, XML, HTML, Java Script, Visio, MS Projects, Microsoft Office, Visio, Snag-It, STAT 5.X

Client: Confidential, MO January 2008 to November 2008
Title: Sr. PeopleSoft Consultant / Contractor.
PeopleSoft 9.0 Implementation, Upgrade & Support.
Modules(ELM, HRMS, Core HCM, Workforce Admin, MSS & ESS, Learning Management, Training, ePerformance, Benefits, Pension, Compensation, Budgeting, Time & Labor, Payroll, Interface, Competencies, Positions, Absence Management, Recruiting & TAM)
Responsibilities:

  • Experience of Lean & Agile SDLC with scrums, extreme programming, feature driven development & continuous Integration in behavior driven pair programming environment for 15 days sprint. Implemented object oriented architecture for robust, durable & reusable application functionalities. Provided post production support to timely resolve reported issues within the SLA.
  • Worked on integration PeopleSoft ELM & HCM using integration broker.
  • Performed Setup & Configuration for PS HCM & Self-Service modules. Performed foundation Table loading sequence, setup country specific tables, Absence Data. Events, Eligibility, Rate, T&L, Rules & Benefit Programs, Templates, Statuses, Referral Programs, Flexible Spending Account & Credits , Competencies & Accomplishments , Approvals process& Integration with PeopleSoft and 3rd party systems.
  • Developed custom functionality for various Self-service modules & developed delegate self service module.
  • Worked on application packages, created new packages to extend functionality of delivered packages.
  • Worked on business process maps, HCM Data models & Person model. Performed analysis, business process reengineering, data mapping and data modeling.
  • Developed, Customized, Debugged & Tested Applications using App-Designer, PeopleTools. Worked on SQR, PeopleCode, DMS, UNIX scripts & batch processing tools & Web Services. Developed Reports, Interfaces, GUI Pages, Components, Menu, Web Libraries, SQL Queries & cursors using App-Packages, IB, CI, AE, FL & provided PS Security, portal registry & contents. Worked on HCM inter-module Integration & integrating HCM with other PeopleSoft applications such as ELM, CRM, FSCM & 3rd party systems such as Resume Mirror, Choice Point, I-Grasp, Active Directory (MOSS 2007), ADP etc for payable hours, Deductions, Job & Personal Data, Disability, Demographics, New Hires, POI, Job Postings data etc. Used Excel-to-CI utility.
  • Proficient in PeopleTools, PeopleCode, Application Designer, Application Package, Application Engine, Integration Broker, XML Reporting, Component Interface, Process Scheduler, Upgrade Assistant, Tree Manager, Process Monitor, Import Manager, Operator Security, People Code, Data Mover, PS Query, object oriented programming, SQL, SQR, HTML and Java script.

Environment: PT 8.49, Oracle 10g, Windows XP, UNIX, Reporting Tools, ETL tools, Integration Tools, Send Master utility, Java SE Development Kit , Mercury testing tools, Golden, Ultra-Edit, WebEx, SQR, XML, HTML, Java Script, Visio, MS Projects, Microsoft Office, Visio, Snag-It.

Client: Confidential, MA April 2007 to January 2008
Title: Sr. PeopleSoft Consultant
PeopleSoft 8.4/9.0 Upgrade, Customization & Production Support.
Modules(HRMS, Core HCM, Benefits Compensation, Workforce Admin, T&L, Payroll Interface, MSS, ESS, Competencies, Positions, Stock, Absence, Recruiting & TAM, Learning, ePerformance, Pension)
Responsibilities:

  • Expert in Lean & Agile Software Development process. Re-used, created custom Application Packages, Methods, PeopleCode & JAVA classes to implement business process logic.
  • Lead development & testing efforts following Onsite/Offshore (Hybrid) Delivery Model & acted as onsite point of contact for offshore team, interacted with client, business users, SME & reported project status to delivery manager. Gathered & documented business requirements, performed FIT-GAP analysis, identified GAP. Prioritized, developed and tested business critical functionality to deliver quality product in scheduled rollouts.
  • Report, follow up bugs with PeopleSoft customer connection (GSC / Metalink). Applied Patches and Bundles.
  • Designed & Develop various reports, conversions, interfaces & integration based on the functional requirements in accordance with the design & build standards. Extensively used PeopleTools, App-Packages, CI, AE, IB, FL, SQR, Crystal & N-vision reports. Setup Jobs & Batch processes, worked on Portal registry, security, structure & contents. People Code events, SQL, XML, SOAP, HTML JavaScript & Java methods. Worked on Components, Menu, Pages, Records, Views & other PS definitions. Used Compare Reports to moved Projects & objects to target environments.
  • Experience of HCM data modeling, Person model & other PeopleSoft data models. Used data modeling techniques for managing data, integrating systems & designed databases/data warehouses needed to support the business processes.
  • Implemented, Customized & Setup for Benefits, Rules, Benefits Billing, Events & Actions, Specifying Event Classes, Trigger, Processing Events for COBRA, Multiple & Concurrent Open Seasons, Flexible Spending Account, Compensation, Workforce Admin, T&L, Payroll Interface, MSS, ESS, Competencies, Positions, Stock, Absence, Recruiting & TAM, Learning, ePerformance, Pension, Approval & workflow engine. Identified GAP & provided solution for recommended business processes.

Environment: PT 8.48, Oracle 10g, SQL Server 9.0, Windows, Linux and UNIX, Mac OS X, Reporting Tools, STAT 5.X, Toad, Ultra-Edit, Putty, Citrix, Java SE/J2SE, Microsoft products, Visio, Mercury tools, ETL tools, Integration tools, Send Master utility.

Client: Confidential, GA January 2007 to March 2007
Title: PeopleSoft Consultant / Contractor.
PeopleSoft 8.0 to 8.9 Upgrade, Customization & Production Support.
Modules(CRM, FSCM )
Responsibilities:

  • Provided technical support, solution options & estimates to application enhancements requests. Resolved issues by debugging analyzed, troubleshooting application. Researched & recommend vendor delivered solutions, patches. Developed technical design documents, test plans, release notes. Used compare reports, project migration tools to process changes according to Change Management policies & procedures. Created user interface guide, training material.
  • Excellent understanding of CRM Data Model, Created & tuned complex SQL Queries record joins, filtering criteria & Effective Dated Active status rows.
  • Setup integration between CRM & FSCM using delivered EIP. Performed full data load as well as incremental sync.
  • Worked on setting up & testing business interlinks such as Product availability etc.
  • Provided support & enhance for CRM modules. Scheduled Jobs & control parameters for process .
  • Analyzed compare reports & migrated projects, Objects & data using DMS between various environments.

Environment: PT 8.47, Oracle 9i, SQL Server, MS-Access, SQL, PL/SQL, Windows XP, UNIX, Toad, Ultra-Edit, SQR, nVision, XML, Visio, MS Office, Eclipse UML2 Tools, Mercury Tools, Send Master.

Client: Confidential, MN January 2006 to December 2006
Title: Sr. PeopleSoft Consultant.
PeopleSoft 8.0 to 8.8 Upgrade, Implementation & Production Support.
Modules (HRMS / HCM, Workforce Admin, Benefits, T&L, MSS, ESS, Absence, Recruiting & TAM, Learning, ePerformance, CRM-HR Help Desk )
Responsibilities:

  • Developed Application Packages using Inheritance, Encapsulation, Polymorphism to implement required logic.
  • Developed Application Engine,Component Interface,SQR, SQC for Reports, Batch processes & interfices as per requirements.
  • Worked on Core HCM & Self Service modules applied Patches & Bundles, Performed setups, configuration & customizations to various functionalities such as Workforce Admin, Benefits, T&L Rules, Absence, Recruiting & TAM, Learning, ePerformance. Developed Custom integration & GUI interface for processes like New-Hires, Person of Interest, FMLA, FSA, HR Case, support & solutions, provided production Support as per SAL for reported issues & performed data cleanup.
  • Worked on Process Scheduler and PeopleTools.
  • Worked on HCM & CRM HR Help Desk integration, resume processing, Background check, ADP, Legacy & External Benefits systems. Integrated ELM & HCM & customizations to employee/learner data. Absence Management & 3rd party payrolls. Customized Notes & Attachments.

Environment: PT 8.45, Oracle9i, MS SQL Server, Windows XP, UNIX, Toad, STAT, SQL- Plus, Test Director, Ultra-Edit, Crystal Report, SQR, nVision, PS-Query, Microsoft Office, Visio, Projects.

Client: Confidential, FL January 2005 to December 2005
Title: PeopleSoft Consultant / Contractor.
PeopleSoft 8.0 to 8.4 Upgrade, Implementation & Production Support.
Modules(HRMS & HCM modules, Benefits, T&L, Manager / Employee Self-Service eProfile, Recruiting & TAM, Learning, Performance, CRM, Financials, Absence & Risk Management)
Responsibilities:

  • Provided SLA based production support for PeopleSoft modules.
  • Customized Work Flow & Notifications.
  • Worked on Absence management: payee data & retrieval, calculation, processing, earning & deduction element information, accumulators. Defined Risk management processing, position limits, hedges & deals. Performance monitor, document types, rating models, performance & evaluation criteria, participant roles, job profiles & postings, Advisor tools, Ben-admin process, FSA, event & eligibility rules & open enrollment & event maintenance, New & re-Hiring process.
  • Developed Pages, Grid, Scroll, SQLEXEC, Menu, Component, Records, Views and other PeopleSoft definitions to implement GUI application.
  • Used various PeopleCode API Class such as Page, Record, Rowset, Field, Grid, Array, SQL, Query, Java, AESection, CI, IB & Web Service, XmlDoc, SOAPDoc, Business Interlink, Portal Registry, iScript, Notification, Mail, Message, File, Chart & Application classes.

Environment: PT 8.4/8.41, Oracle9i, Windows XP, UNIX, Toad, SQL- Plus, Test Director, Crystal Report, SQR, NVision, Visio, Send Master, XML, SOAP, Integration Tools.

Client:Confidential, WI January 2003 to November 2004
Title: PeopleSoft Consultant.
PeopleSoft 8.0 to 8.4 Upgrade, Implementation & Production Support.
Modules (HRMS & HCM, Financials &, Supply Chain management, CRM, Benefits, T&L Self-Service, ELM)
Responsibilities:

  • Worked on setting up foundation tables & configured PS modules using online setup, Created & Performance tuned complex nested SQL queries & SQR reports. Performed Security Administration for permissions, roles & profiles.
  • Worked with the Interface & Conversion team from Oracle to PeopleSoft, Served as project-wide expert on PeopleSoft architecture. Created & modified Process scheduler job definitions, created SQR, PS Query reports & enhancement of PS reporting using the online & batch reporting tools.
  • Worked as a PeopleSoft RICE developer.
  • Worked on Foundation Tables, Common Definitions, Product Related, System Administration, T&L rules, PS security, organizational relationships, Template-Based Hires, compensation packages for core HCM & Self-Service modules including integration setup between FSCM, CRM & ELM.

Environment: PT 8.12, Oracle 8i, Windows, UNIX, Toad, Mercury testing tools, reporting tools.

Organization: Confidential, OH August 2001 to November 2002
Title: System Analyst.
PeopleSoft upgrade and support from 7.5 to 8.0
Modules (HRMS & HCM, Financials &, Supply Chain management, CRM, Self-Service modules)
Responsibilities:

  • Worked as PeopleSoft RICE Developer (Reports-Interface-Conversion-Extension). Performed analysis of functional & business requirements. Prepared code stubs. Completed PeopleCode to implement solutions. Contributed to design activities and design solutions. Lead/Participated in code reviews code reviews. Designed, prepared & executes Unit tests. Applies in-depth technical knowledge to maintain PeopleSoft application. Performed solution design. Provided time / resource estimates for assigned tasks & projects.
  • Designed, Customized & Tuned Records, Fields, Pages, Menu, Component, Menu, IB, SQL Queries, DMS scripts, PS Integration, PeopleCode events, Grids & Scrolls, Cursors & SQLEXEC. Worked on UI, Integration, Security, Scheduled jobs using Process scheduler, created batch processes & Ad-hoc processes using AE, FL, CI, and SQR. Created Triggers & stored procedures.
  • Good understanding of Data Model & ERD diagrams, Performance tuned Applications.
  • Created BRD, FDD, TDD & Training materials. Provided Knowledge transfer.

Environment: PT 8.12, UNIX, Windows, SQL, Oracle 8i, SQR, Crystal Reports, nVision, Microsoft Office, Mercury Testing tools, Import Manager, Data Mover, Configuration Manager.

Company: Confidential, India. July 1997 to June 2001
Title: IT Engineer & Programmer.
Modules (PeopleSoft HRMS, FSCM)
Responsibilities:

  • Worked as PeopleSoft a Developer, demonstrated PeopleSoft programming technical skills. Designed technical solutions for PeopleSoft applications using an Oracle RDBMS & support other web applications, interfaces and related custom & packaged code.
  • Designed & troubleshot updates for Y2K compliance utilizing multiple languages (Java, C++). Developed, tested & implemented application to bring multiple clients into standard database.
  • Enhanced reporting system reducing time of delay by 30%

Environment: PeopleTools, SQR, PS Query, Crystal Reports, Windows, Oracle data base, UNIX, JAVA, ETL tools, Mercury testing tools, JAVA, C++, PeopleCode.

EDUCATION

Perusing Professional/Part Time MBA program
Master’s of Science (Electrical & Computer Engineering)
Bachelors of Engineering (Electronics & Computer engineering)

Hire Now