SUMMARY:

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

SKILL:

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, 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: PeopleSoft Test Framework, Mercury tools, Test Tracker & Director, Win Runner, Load Runner, Clear Quest, Clear Case, Send master, PS Integration Testing Utilities & Tools, Snag-It.

Microsoft Tools: Visio, Projects, Access, Excel, Word, PowerPoint, Outlook, Publisher, Front Page.

PROFESSIONAL EXPERIENCE:

Confidential, Albany, NY

Sr. PeopleSoft Consultant

Responsibilities:

• Implemented Self Service registration IDM for state employees using Fluid Pages for use on mobild devices,
• Worked on PeopleSoft Project Costing, Inventory, eProcurement, Invoice, Billing, AR, AP, Purchasing, GL, Vendor management, Cash Management, Commitment control in FSCM modules .
• Implemented Web service integration between PeopleSoft & SalesForce, Worked as PeopleSoft Lead Developer and SalesForce Admin, Developed Packages in PeopleSoft 9.2 using PT 8.55 from scratch to consume & provide web services with SalesForce. Including SalesForce Login request as follows to get Session Id to be used in request.
• Worked on PeopleSoft Time & Labor, Absence Management HRMS modules
• Worked on Integrations & EIP between T&L, Expenses, Service Procurement, GL, Project Costing.
• Provided & Consumed XML SOAP based web Services for Identity proofing solution with LexisNexis.
• Developed Two Factor Authentication (2FA) with Secure Auth using PeopleSoft RestFul Web Service using JSON. To confirm a user's claimed identity by utilizing a combination of two different components.
• Implemented Google reCAPTCHA within PeopleSoft Self-Service registration by importing custom provided Java classes within Application Package PeopleCode for challenge-response test to determine whether or not the user is human.
• Created Technical Design documents and unit and Integration testing documents, Worked with Security team for development of IDM solution for PeopleSoft Self-Service for state customers, contractors, Vendors, Implemented using Fluid pages.
• Developed Approval workflow Engine for unsuccessful registrations thru self service and HR Self Service.
• Developed integration with CRM to create a case and add notes for Self service IDP solution flow in Portal.
• Implementation of IDM integration with PeopleSoft TAM Candidate Gateway for Job Applicant in is ready to hire, Once applicant status got hired personal & job record is created in workforce Admin thru customized IB Message.
• Developed SOAP based Web Service in PeopleSoft HCM and FSCM to integrate with SalesForce.com (CRM). Worked with SalesForce Developers to modify the WSDL2Apex code to match PeopleSoft WSDL requirement so to resolve issues related to parsing errors of the WSDL files.
• Developed custom RICE objects using Application Package, Application Engine, SQR, SQL scripts, Component Interface, Integration Broker, File Layout, Component, Fluid Pages, Pages, Menu, Records, HTML and other PeopleSoft definitions. Using Programming Languages such as Procedural PeopleCode, Application Package PeopleCode, JAVA, JavaScript, XML, JSON.
• Worked with Functional team to setup Business Units, Accounting rules & structure for Projects, Projects & Activity teams, and Budgets in Project costing modules. Good understanding of PeopleSoft Table Structure(ERD), Funds Distribution Process, Project Costing pricing process
• Provided Production support, Performed system analysis, data analysis to resolve reported issues.
• Worked with Functional, Testing, PS Administrators, PeopleSoft security, Change management teams during complete software development lifecycle using Waterfall methodology for new production support, and Agile methodology during development & implementation of custom functionality.

Environment: PT 8.55 Oracle 12c, Phire, Windows 7 Enterprise, SoapUI, ETL tools, Integration Tools, Mercury testing tools, Ultra-Edit, SQR, XML, Microsoft Office, Visio.

Confidential, Washington, DC

Sr. PeopleSoft Consultant

Responsibilities:

• Configured Work bench, Dashboard, Navigation Collection. Developed Custom Module as one place holder for various modules in FSCM & HRMS.
• Provided & Consumed XML SOAP based web Services for Identity proofing solution with LexisNexis.
• Created Technical Design documents and unit and Integration testing documents, Worked with Training coordinator to develop UPK based training materials.
• Gathered & documented Business requirements, Fit Gap analysis, create mockups, functional test scripts, Functional & Technical design document. Setup Finance and SCM tables. Interacted with Key Customer Focal, as a Scrum master conducted daily tag up meetings & report out. Worked with QA team and end users to timely resolve outstanding issues. Co-authored test plan, test scripts and led user acceptance testing.
• Development, customization and configuration for PeopleSoft FSCM 9.0. Worked with Functional team to setup Inventory, Purchasing, eProcurement, Strategic Sourcing, Supplier Contract Management, Leading test efforts through the software development following LEAN and Agile methodology.
• Work closely with operations and engineering team to analyze operational performance & trends, and identify opportunities for continuous improvement. Design and perform operational impact analysis.
• Worked on Various Peoplesoft EIP’s, Expert in Integration Broker, Customized Message, Setup Channel, Node definition, and Gateway properties.
• Work closely with operations and engineering team to analyze operational performance & trends, and identify opportunities for continuous improvement. Design and perform operational impact analysis.
• Developed various Inbound & Outbound EDI using File Layout, Application Engine, Component Interface and SQR program for Requisition, Purchase Order, Send PO to vendor and RTV (return to vendor) flat file.
• Developed various interfaces such as Deposit Interface, Cash Management, Billing Interface, Pending Item Interface, Deposit Validation in AR & Billing Procurement to Pay, Commitment control..
• Developed Procure to Pay, Treasury and Asset Management integration.
• Created and modified Reports using SQR program, Crystal report as per customer requirements. Tuned SQL queries to improve performance.
• Used File Layout, AE program, SQR program and DMS script, worked with data mart team to create outbound feed to Data-Mart.
• Developed & Customized peoplesoft objects such as Fluid Pages, pages, components, records, fields etc and wrote PeopleCode at various levels such as record level, page activate, component-record level.
• Developed Integration between FSCM and 3rd party system.
• Configured & Setup Gateway, Message Channel, Connectors, Node Definition, Messages using PIA and Application Designer
• Experience with Application Packages.
• .Worked with PeopleSoft security, portal registry, structure & contents, scheduling & maintaining process scheduler, App Server.
• Setup Transformation, Relationships, Full Data Publish & Batch Publish rules & worked on Data Exchange.
• Provided production support for issues in eProcurement, Order Management, Project, Grants, Project costing, Asset Management, Inventory, Billing, PO and other PeopleSoft FSCM modules.
• Worked as onsite technical coordinator, tracked maintained work progress of offshore team and reported milestones reached and issues to onsite project manager.
• Worked towards fixing Bugs, Production Support, Documentation, End-Users Training and Knowledge Transfer.
• Created Test Script for System & Integration Testing.
• Proficient in PeopleTools like PeopleCode, Application Designer, Application Engine, Integration Broker, Component Interface, Application Package, Process Scheduler, Upgrade Assistant, Tree Manager, Process Monitor, Import Manager, Operator Security, People Code, Data Mover and PS Query
• Provided SLA based production support, Resolved Data related issues by analyzing Ps Objects, PeopleCode, SQL queries, & Trace files for bug fixing & performance tuning of application.
• Developed Customization for Supplier Contract management and integration for Portal Solicitation postings.
• Implementation of IDM integration with PeopleSoft TAM Candidate Gateway for Job Applicant in is ready to hire, Once applicant status got hired personal & job record is created in workforce Admin, Building Key & badge request, Computer access and other onbording functionality is initiated thru customized IB Message (Web Services) with 3rd party systems.
• Developed custom smart survey for hiring managers, Approval workflow (AWE) for PeopleSoft HR Self Service and SRM modules.
• Developed SOAP based Web Service in PeopleSoft HCM and FSCM to integrate with SalesForce.com (CRM). Worked with SalesForce Developers to modify the WSDL2Apex code to match PeopleSoft WSDL requirement so to resolve issues related to parsing errors of the WSDL files.
• Developed custom RICE objects using Application Package, Application Engine, Component Interface, Integration Broker, File Layout, Component, Pages, Menu, Records, HTML and other PeopleSoft definitions. Using Programming Languages such as Procedural PeopleCode, Application Package PeopleCode, JAVA, JavaScript, XML, JSON.
• Worked with Functional, Testing, PS Administrators, PeopleSoft security, Change management teams during complete software development lifecycle using Waterfall methodology for new production support, and Agile methodology during development & implementation of custom functionality.

Environment: PT 8.54, Oracle 12c, Phire, Windows 7 Enterprise, SoapUI, ETL tools, Integration Tools, Mercury testing tools, Ultra-Edit, SQR, XML, Microsoft Office, Visio.

Confidential, TX

Sr. PeopleSoft Consultant

Responsibilities:

• Worked on Data conversion form PeopleSoft HRMS/HCM in to Workday HRMS for Workday Implementation. Developed PeopleSoft EIP using Integration broker, XML Files, CSV, Flat Files to Integrate PeopleSoft FSCM with Workday.
• Worked on Process scheduler, Portal registry, Query manager.
• Worked on Integration broker, XML Messages and Subscription PeopleCode, related custom messages to provide real time Inventory/stock update to sales representative.
• Customized Financial/SCM Order Management, eProcurement, Payable, Receivable, Inventory, Billing, Cash management, Contracts, GL, Purchasing and commitment control modules.
• Customized Order Capture module and Introduced new Holds like Credit card and E911 hold to meet business requirement. Modified Application Package for Pre-Order and Post Order process. Created Account Bolt on table.
• Implemented Peoplesoft EIP between CRM and Financials/SCM . Worked on Integration broker, created XML messages and wrote PeopleCode to process response. Customer Sync, Product Sync, Order and Order Status EIP Messages
• Implemented AWE and provided custom Approval Workflow by configuring & developing custom App Packages, PeopleCode at Component Post Build and Save Post change.
• Created custom Fluid Pages, Pages, Components, records, AE programs, Application Packages, CI, SQR, DMS scripts, File Layout, IB Messages, Batch Processes, Data Extraction, Transformation, SQL & PS Query, Approval workflow Engine (AWE)
• Worked on creating & testing interface including CSV, flat file & XML file
• Resolved Data related issues bug fixing & performance tuning of application.
• Mentored & provided technical assistance to junior developers.

Environment: PT 8.54 / 8.53 MS SQL Server 2012, STAT 5.6, Windows XP, ETL tools, Integration Tools, Mercury testing tools, Ultra-Edit, SQR, XML, Microsoft Office, Visio.

Confidential, NC

Sr. PeopleSoft Consultant

Responsibilities:

• Setup, Configure IB to implement Full Sync & Incremental sync messages for delivered EIP between HCM, Student Admin & Campus Solutions & Financials modules.
• Created custom Application package, Handler for inbound & outbound, Rowset & non Rowset based xml messages.
• Introduced new Holds in Order capture module to meet business requirements. Also added/Modified Translate values. Modified Application package to manage holds.
• Wrote SQL queries and used SQLEXEC in PeopleCode. Performed query tuning and created Index.
• Involved in meetings with functional experts to gather information for business requirements to write the technical specifications, develop design documents and help them in testing the data.
• Implemented Peoplesoft delivered EIP between Peoplesoft Financials/SCM and HRMS. Modified Customer Sync, Product Sync, Prod Item Sync, Pricing message by modifying XML.
• Worked on Process scheduler, Portal registry, Query manager. PeopleSoft Objects, PeopleCode, AE, AWF, FileLayout, Component, CI, SQR, PS Security, Permission & Roles.
• Worked on providing web services to third party external system related to Employee, student & associate data.
• Worked on testing Integration Broker xml messages, web services, SOAP messages, and other interface including CSV, flat file.
• Resolved Data related issues bug fixing & performance tuning of application.
• Mentored & provided technical assistance to junior developers.

Environment: PT 8.52 Oracle 11g, SoapUI, 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.

Confidential, IL

Sr. PeopleSoft Consultant

Responsibilities:

• Conversion & Production support for PeopleSoft Enterprise Learning Management, HCM & FSCM modules.
• Worked with Security team with security implementations.
• Guided design for interface, reports, component & integration implementation.
• Helped Testing team and SME during UAT phase.
• Resolved Data related issues bug fixing & performance tuning of application.

Environment: PT 8.52 Oracle 11g, PeopleSoft test frame work, SoapUI, 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.

Confidential, Dallas, TX

Sr. PeopleSoft Consultant

Responsibilities:

• Integrate PeopleSoft Student Admin & Campus solutions with 3rd party AVOW system by providing Web services for Student check & Transcript ordering using Soap xml messages.

Environment: PT 8.51 Oracle 11g, SoapUI, 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.

Confidential, AZ

Sr. PeopleSoft Consultant

Responsibilities:

• Integration of Workday with PeopleSoft Finance, HRMS, Portal & security using XML messages, Integration Broker, AE programs & Application Packages.

Environment: PT 8.51 Oracle 11.2.0.1.0 , SoapUI, 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.

Confidential, GA

Sr. PeopleSoft Consultant

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.

Confidential, CA

Sr. PeopleSoft Consultant

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.

Confidential, RI

Sr. PeopleSoft Consultant

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