Senior Technical Consultant Resume
Charlotte, NC
PROFESSIONAL SUMMARY:
- More than Seventeen years of experience in PeopleSoft 7.5/8.0/8.4/8.8/8.9/9.0/9.1/9.2 in PS Admin, Development, Customization, Upgrade and Production Support.
- Experience in Financials, HCM, ELM, Portal, Campus Solutions with very strong technical expertise in Integration Broker, Workflow, Application Engine, Work Centers, Fluid, Change Assistance, PUM, SQR, PeopleTools, People Code, PS Query, PS/nVision and Crystal Reports. Over all Eighteen Years of Experience on various Technologies.
- Experience in PeopleSoft Financials (GL, AR, AM, AP, Exp, Project Costing and Budgets), PeopleSoft Distributions/SCM (Billing, Purchasing, eProcurement, OM, INVENTORY AND PRODUCT CONFIGURATIOR) PeopleSoft Manufacturing (COST MANAGEMENT), PeopleSoft HCM (Benefits Administration, Payroll, T&L, TAM (eRecruitment), eBenefits, ePay, eCompensation, Manager Self Service, Employee Self Service, Absence Management and eProfile), ELM, Portal and Campus Solutions.
- Proficient in all phases of the systems development lifecycle, including Requirements gathering, Data Conversion, System Implementation, Customization, System Testing and User Acceptance.
- Excellent working knowledge of PeopleTools (including Application Designer, Application Engine, Workflow, Integration Broker, XML Publisher, Security, Import Manager, Data Mover, Process scheduler, Work Centers, Fluid, Change Assistance, PUM, Tree Manger, Query and all other Peopletools)
- Very Good knowledge in Developing and Customizing Internet and Client/Server applications using ASP 2.0, Visual Basic 5.0/4.0, Active X, DAO/RDO/ADO, COM, Crystal Reports, Visual InterDev 5.0, Visual Source Safe 5.0, VBScript, JScript, HTML, IIS 4.0, MTS, SQL Server 7.0, Oracle 7.3, DB2 and Access.
- Good understanding and knowledge of the SOA Architecture.
- Excellent oral and written communication skills and a good team player.
TECHNICAL SKILLS:
Application: PeopleSoft Manufacturing (Cost Management), PeopleSoft Distribution (SCM) (BI, OM, Product Configurator, Purchasing and eProcurement), PeopleSoft Financials (AM, AR, GL, AP, AM, Expenses, Project Costing and Budgets), PeopleSoft ALM (MM, REM and AM), PeopleSoft HCM (Benefits Administration, Payroll, T&L, Position Management, TAM (eRecruitment), eBenefits, ePay, eCompensation, Manager Self Service, Employee Self Service, Absence Management and eProfile), 7.0/ 7.5/8.0/8.4/8.8/8.9/9.0/9.1/9.2
GUI Tools: People Tools, Developer 2000, and Visual Basic
Reporting Tools: SQR3.0/4.0, Ps - nVision, Crystal Reports and
Languages: Peoplecode, PL/SQL, SQL
Dataware Housing Tools: COGNOS POWERPLAY
RDBMS: Oracle 7.x/8.0/10/11G, SQL Server, DB2
Operating Systems: WINDOWS NT, WINDOWS 95, WIN2K, WIN XP, UNIX
Web Technologies: ASP, VBScript, JavaScript, Visual InterDev, IIS
PROFESSIONAL EXPERIENCE:
Confidential, Charlotte, NC
Senior Technical Consultant
Environment: PeopleSoft HCM 9.2 (T&L, Manager Self Service, Employee Self Service, Absence Management, TAM, Candidate Gateway, eRecruiting and eProfile), PeopleTools 8.55, SQR, Oracle 12G, NT and Unix Platform.
Responsibilities:
- Fixed several bugs in eRecruit, TAM and CG, helped the client cleaning lot off mess and made sure client goes live on time without big issues.
- Fixed all issues with Integration Broker and advised the client on the best practices.
- Combined 10’s of messages into one message which get kicked off when a candidate submits the application from Candidate Gateway to eRecruiment.
- Made sure all the updates happen properly on the CG side when the candidate get’s hired in eRecruit.
- Helped the client improve the time entry approval performance in Manger Self Service by changing the AWE approval process.
- Customized the candidate application screens to accommodate client specific business logic for Police and Fire recruitment in Candidate Gateway.
Confidential, Dallas, TX
Senior Techno-Functional Integration/Conversion Lead/Architect
Environment: PeopleSoft Financial (Project Costing, Account Payables, GL, Treasury, Cash Management, Cost Management and Travel and Expenses) 9.2, PeopleSoft SCM (Purchasing, ePro, eSupplier, Strategic Sourcing and eBill) PeopleTools 8.55 SQR, Oracle 11G, NT and Unix Platform.
Responsibilities:
- Lead the effort of integrating and Converting PeopleSoft Project Costing and Expenses from third party Java cloud based system to PeopleSoft.
- Developed 30 WSDL’s to support client’s efforts to create brand new cloud based Java User Interface for Project Costing module.
- Created Integration Broker Nodes, Messages, Services, Service Operations, Application Packages and Components as needed for the whole integration to work smoothly.
- Created Separate web services for creating/updating Project, Project Activity, Project Team Members and used component interfaces to update/insert/delete the data into PeopleSoft.
- Developed an integration using PeopleSoft Integration Broker web service/Component Interface technology to create/update Timesheet’s in PeopleSoft from the Java user Interface.
- Utilized Data Migration Workbench to migrate and compare the configuration.
- Customized Time entry screens in Travel & Expenses to accommodate various client custom Requirements.
- Made changes to FLUID UI for Time Entry to reflect the online customization for same.
Confidential, Spartanburg, SC
Senior Technical Consultant
Environment: PeopleSoft Financial (Account Payables, GL, Treasury, Cash Management, Cost Management and Travel and Expenses) 9.2, PeopleSoft SCM (Purchasing, ePro, eSupplier, Strategic Sourcing and eBill) PeopleTools 8.55 SQR, Oracle 11G, NT and Unix Platform.
Responsibilities:
- Worked on end to end integration between Peoplesoft and imaging software OnBase.
- Worked on modifying and configuring excel Voucher upload and Journal Template upload.
- Designed and developed full blown integration between Concur and Peoplesoft. Used
- Component interface to make sure the inbound data is adherence to PeopleSoft standards.
- Modified PeopleSoft XMLP AP check according client specific requirements.
- Used Data Migration Workbench to migrate and compare the configuration between environment.
- Involved in the integration between several banks and Peoplesoft Treasury/Cash Management.
- Developed Application Engine programs that generates custom bank payment files as well as positive pay files.
Confidential, Morristown, NJ
Senior Technical Lead Consultant
Environment: PeopleSoft Financial (AR, Billing, Account Payables, Financial Gateway, GL, Treasury, Cash Management, Cost Management and Travel and Expenses) 9.1/9.2, PeopleSoft SCM (Purchasing, ePro, eSupplier, Strategic Sourcing and eBill) and Asset Life Cycle Management(Maintenance Management, Real Estate Management and AM) 9.1/9.2 and PeopleSoft HCM 9.1 / Workday (Payroll, T&L, Manager Self Service, Employee Self Service, Absence Management, TAM, Candidate Gateway, eRecruiting and eProfile), PeopleSoft Portal/Interaction Hub 9.1/9.2, PeopleTools 8.53/8.54/8.55 SQR, Oracle 11G, NT and Unix Platform.
Responsibilities:
- Customized the PO Dispatch process so that vendor specific T&C’S will be automatically attached to PO email and dynamically generated appendixes will be sent as part of the PO.
- Developed an Application Engine program which enrolls all Vendors/Customers into eSupplier/eBill, creates Vendor/Customer user admins, create their user profile and sends an email with the credentials and “how to” help attachment.
- Developed self registration pages in eSupplier and eBill where in Customers and Vendors can create users to maintain their contacts, addresses, POA’s, ASN’s, Invoices etc.
- Configured eSupplier/eBill Portal/Interaction Hub for external users to come in and perform various actions in PeopleSoft.
- Developed/Modified/Configured SkipJack Credit Card payment integration in eBill.
- Configured/Customized Expenses/Journal Workflow/PO Workflow/Contract WF/Contract release WF which has some unique set of criteria using Approval Workflow Engine(AWE).
- Integrated Microsoft Active Directory with PeopleSoft so that PeopleSoft users are authenticated against the AD not PeopleSoft.
- Developed an interface to import the data from flat file into General Ledger Tables.
- Configured/Modified several WorkCenters in AP/PO and added custom pages/processes/ queries based on the user’s roles and daily activities to reduce the navigation time.
- Configured Mobile Approvals for various Financial transactions and Implemented Mobile Expenses and Mobile Inventory.
- Configured ExceltoCi tool so that users can mass upload Event lines in Strategic Sourcing.
- Fixed issues with Work Order Work Bench in Maintenance Management.
- Helped functional consultants and client personal fixing issues and figuring out the delivered functionality of the Real Estate Management module.
- Wrote several programs to extract the data from PeopleSoft to feed several third party software’s like Outlook, Transcepta, Maximo, SkipJack etc.
- Developed Integration broker messaging to receive the requisitions from Maximo into PeopleSoft which will be loaded into Requisitions Loader component.
- Implemented PM sequencing which will auto select the Task templates/Job templates when
- Work Orders are created using the PM schedules in the Maintenance Management.
- Customized the Parent child relation between work orders which were created based on the PM Lining in the PM schedules in Maintenance Management.
- Worked on Auto Project association mod in Maintenance Management which is based on the project creation/modification in the Project Costing.
- Was responsible for testing and making sure all Integration Broker messages work properly after the upgrade to 9.2.
- Integrated several banks with Financial gateway for sending and receiving payments using the Integration Broker/ftp.
- Trained Technical, Functional team and super users on PeopleSoft Test Framework and FLUID user interface.
- Worked on the Capex Distribution modification on the Work Order screen in Maintenance Management.
- Worked on many major customizations in AP, PO, AR, BI, GL, MM, Inventory, Cost Management, eBill, eSupplier and Strategic Sourcing.
- Integrated PeopleSoft AP with Transcepta (Just like ImageNow) Imaging system.
- Did lot of research on Affordable Care Act (ACA) and advised the client on how to proceed with the configuration and generating various files
- Developed conversion programs/web services to convert the HCM data to Workday.
- Developed/configured several interfaces between Peoplesoft HCM 9.1 and Workday using the PeopleSoft Integration Broker.
- Modified the Pcard recon page so that the users do not have to go to multiple pages to reconcile the pcard transactions.
Confidential, Dallas, TX
Senior Technical Consultant
Environment: PeopleSoft HCM 9.1 (Payroll, T&L, Manager Self Service, Employee Self Service, Absence Management, TAM, Candidate Gateway, eRecruiting and eProfile), PeopleSoft Financial (AR, Billing, Account Payables, GL, PO, eProcurement and Travel and Expenses) 9.1, PeopleSoft SCM (Purchasing and ePro) 9.1, PeopleSoft Enterprise Campus Solutions 9.0(Student Records, Student Financials, Financial Aid), PeopleSoft Portal/Interaction Hub 9.1, PeopleTools 8.52 SQR, Oracle 10G, NT and Unix Platform.
Responsibilities:
- Developed several Manager Self Service transactions from the Scratch which includes Termination, Retirement, Ad Hoc salary change, LOA, Transfers and Additional pay.
- Developed custom components where we assign the approvers for various workflow routings for the MSS custom transactions mentioned above.
- Configured and tuned around 80 different Integration Broker messages that take the data between FIN, HR and CS which includes the chart fields and combo edit integration.
- Integrated PeopleSoft Procure-to-pay modules with third party software called Maximo using DB Links and component interface.
- Performed a customization to auto enroll employees into Absence Management to process Leave entitlements and absence takes.
- Go Live support for SA modules, most specifically Student Records, Student Financials.
- Worked with records conversion, developed transfer credit conversion in Student Records.
- Fixed issues with Absence Management AE GP ABSLVDNP1 so that employees with multiple jobs will be processed correctly for Leave Transfer Donation and Sick Leave Pool.
- Fixed issues related to Kronos and PeopleSoft integration.
- Configured the AWE Workflow for all above MSS transactions and all financial transaction which include Cash Advance, Travel Auth, Expense Report, Journal Ledger, ePro Requisition, Voucher and Vendor approvals.
- Created new Student Late Drop Add Request AWE workflow added notifications on Grade changes in Campus Solutions.
- Integrated PeopleSoft with ImageNow to store the Invoice images and link them to the Peoplesoft Vouchers in Accounts Payables.
- Integrated PeopleSoft AP/PO and Billing with Vertex O Series On-Demand for sales and use tax calculation.
- Used Archive Data tool to Archive Vouchers, Purchases Order and Requisitions in AP/PO.
- Customized Applicant details and applicant activity pages in TAM modules as per the client custom needs.
- Wrote SQR to read the data from file and write the data into Quick voucher tables.
- Wrote Application Engine interface programs to extract and export the Positive pay info to various banks.
Confidential, Dallas, TX
Technical Lead Consultant
Environment: PeopleSoft HCM 9.1 (Payroll, T&L, Manager Self Service, Employee Self Service, Absence Management, TAM, Candidate Gateway, eRecruiting and eProfile), PeopleSoft Financial (Account Payables, PO, eProcurement, AR, Billing, MM, Inventory, GL and Travel and Expenses) 9.1, PeopleSoft SCM (Purchasing and ePro) 9.1, Peopesoft ELM 9.1, PeopleSoft Enterprise Campus Solutions 9.0(Student Records, Student Financials, Financial Aid), PeopleTools 8.52 SQR, Oracle 10G, NT and Unix Platform.
Responsibilities:
- Worked on designing and developing AE interfaces between legacy systems and PeopleSoft to load the data into PeopleSoft Job and Position components.
- Designed/Developed/Configured the synchronous and asynchronous messaging between HCM, Financials and ELM using the Integration Broker.
- Worked on several enhancements/fixes in the Campus Solutions.
- Worked on several fixes and customizations as needed in Campus solutions Student Records.
- Developed/configured AWE Workflow for ePro Requisition, GL Journals, Travel and Expenses and AP Voucher Approval which is based on the various chart fields and dollar amount.
- Integrated ImageNow with PeopleSoft using the web services. ImageNow used as document storing system for Invoices.
- Configured and customized multi level Billing Invoice approval workflow using Approval Workflow Engine.
- Integrated Travel and Expenses with various banks to import and export T&E data for Expenses reconciliation.
- Fixed issues with ePro and SyQuest integration.
- Developed interface/integration points between Maximo and PeopleSoft to sync the data between two systems for various chart fields, requisitions, PO's, receipts and payments.
- Did Troubleshoot and fixed several integration related issues with PeopleSoft Inventory and ther third party systems.
- Wrote several SQR reports which show the presidents office spending for entertainment, travel, housing, etc for each quarter.
- Configured the various integrations between FMS and HCM including chart fields and combo edit integration.
- Configured and customized AWE for all MSS transactions which include New Position, Position Change, Change Funding, Job opening, Transfer, Promotion, Reporting change, Pay Rate change etc.
- There are 13 different MSS transactions developed from the scratch to satisfy the clients Unique requirements and attached AWE, Real Time Budget checking, Component Interfaces to these transactions.
- Wrote an Application Engine program to identify the Vendors that needs to be Archived and then used the Archival tool to actually Archive Vendors.
- Configured and customized Approval Workflow for Absence Management which is based several different criteria which includes absence take, employee country, pay group etc.
- Designed and developed Integration between PeopleSoft and PeopleAnswers for candidate Assessment in TAM and Candidate Gateway.
- Involved in the integration between PeopleSoft Time and Labor and Kronos.
- Customized the find applicant pages to accommodate the PeopleAnswers integration with
Confidential, NV
Senior Systems Analyst
Environment: PeopleSoft HCM 9.0 (Payroll, T&L, Manager Self Service, Employee Self Service and eProfile), PeopleSoft Financial (Account Payables, GL and Expenses) 9.0 PeopleSoft SCM (Purchasing and ePro) 9.0, PeopleTools 8.49.13, SQR, Oracle 10G, NT and Unix Platform.
Responsibilities:
- Worked on setting up Direct connect, Approval Workflow for ePro requisition and tuning the procure-to-pay system.
- Designed and developing the Leave and Overtime bolt on application and building the Approval process using the Approval Workflow Engine (AWE).
- Modified the Timesheet page in Time and Labor to show some new fields based on TRC as well as put in place the multi level approval for some divisions.
- Created several custom T&L Rules to accommodate the client’s functionality.
- Developed/configured the interface to update the user information in LDAP using Directory Interface (not LDAP authentication).
Confidential, West Chester, PA
Tech Lead/ Approval Workflow Engine (AWE) Architect
Environment: PeopleSoft HCM 9.0 (Benefits Administration, Payroll, Health & Safety T&L, Position Management, eBenefits, ePay, eCompensation, Manager Self Service, Employee Self Service, TAM, Candidate Gateway and eProfile), PeopleSoft Financial (Account Payables, AM, GL, AR, Billing and Travel & Expenses) 9.0 PeopleSoft SCM (Purchasing and ePro) 9.0, PeopleTools 8.49, SQR, Oracle 10G, NT and Unix Platform.
Responsibilities:
- Worked on designing and configuring AWE for several HR transactions.
- Created the Approval Workflow for Termination, Hours change, Salary change, Job Requisition (Custom New Hire process to replace Smart Hire) from the scratch and customized the delivered Promotion and Transfer WF’s.
- Customized approval pages to accomplish the client specific needs.
- Created application packages to handle the approvals for the newly developed transactions for Approval.
- Modified the code so that approvers can add the ad hoc approvers.
- Setup/configured ExcelToCI to load the data into Health & Safety module for various transactions including Location hazard, shipto hazard and injuries component etc.
- Built customer match workbench and revenue recognition workbench in AR, Billing and Inventory.
- Configured/customized Credit Invoice Approval in Billing.
- Created, fixed and modified Component Interfaces which are used to save the data directly to DB as soon as the final approver approves a transaction.
- Gave demos, trained the super users and WF administrators on the new Approval Workflow Engine.
- Setup the delegation and escalations for all the above WF transactions.
- Involved in the Integration between PeopleSoft and Tibco using the Integration Broker.
- Developed XML based integration between the custom smart hire process to Kenexa.
- Involved in the PeopleSoft HRMS upgrade from 8.3 to 9.0.
Confidential, Boston, MA
Technical Lead/Architect Consultant
Environment: PeopleSoft Financial (Account Payables, AM, GL and Expenses) 9.0 PeopleSoft Supply Chain Management (Order Management, Purchasing and eProcurement) 9.0, PeopleSoft HCM(eBenefits, Payroll, eCompensation, eProfile and eRecruit etc.) 8.9, PeopleTools 8.49, SQR, Oracle 10G, NT and Unix Platform.
Responsibilities:
- Configured, modified and customized 18 different messages between HCM and Finance.
- Worked on setting up and modifying Direct Connect Punch out to Six different suppliers.
- Helped the client Moving away from Perfect Commerce as Market Place hub and saving Hundreds of thousands of dollars.
- Designing, developing and customizing the code to dispatch the Purchase Order in CXML format using Integration Broker.
- Designing, developing and customizing the code to receive the Invoices in CXML format using Integration Broker.
- Configured and customized the GL Journal Workflow which has multi level dollar amount criteria.
- Configured and customized the Purchase Order Workflow.
- Setting up the Requisition Workflow using the eProcurement Approval Workflow Engine (AWE).
Confidential, Overland Park, KS
Sr. Technical Consultant
Environment: PeopleSoft HCM 9.0 (Benefits Administration, Payroll, Position Management, eBenefits, ePay, eCompensation and eProfile), PeopleSoft Financial (AR, Billing, Account Payables, AM, GL and Expenses) 8.8 PeopleSoft SCM (Purchasing) 8.9, PeopleTools 8.49, SQR, Oracle 10G, NT and Unix Platform.
Responsibilities:
- Designed the conversion programs to receive the Benefits and Payroll data from IHOP Lawson system.
- Did setup the Workflow in various emodules using the AWE (Approval Workflow Engine).
- Designed and written several Interface programs which send the Benefits information to Confidential, Confidential, Confidential, Confidential and Confidential .
- Wrote function libraries to keep the coding in one central place for IHOP and Applebees integration.