Management Process
Resume:
Jeyaseelan Mariappan E-Mail:
*********@*****.***
(PeopleSoft Techno-Functional Consultant) Mobile:
Office: 001-678-***-****
Experience Summary
. Over 7 years of IT experience including 6 Years 4 months of extensive
experience in Production Support, Implementation & maintenance of
PeopleSoft Financials, CRM and SCM applications 8.4x/8.8/9.0
. Extensive experience in Peoplesoft Financial modules Billing, Account
Receivable, Purchasing, eProcurement, Accounts Payables, Asset
Management and General Ledger.
. Experience in Production Support, implementations (design, build,
Configuration, test, implement), Rollout, Providing Technical and
Functional Post Implementation and troubleshooting support to renowned
PeopleSoft clients - Thomson Financials, LexisNexis, Intercontinental
Hotels Group (IHG).
. Focused mainly on PeopleTools, PeopleCode, Application Engine,
Application Package, SQR, Component Interface, File Layouts, ExcelToCI,
Crystal Reports and PS Security.
. Extensive experience in Configuration, setup & PS Security
Administration
. Knowledge in Peoplesoft EPM
. Worked extensively on design and integrating Third-party Applications,
EDI Vendors, Automated schedule data feed Processes
. Played Defect prevention analysis (DPA) role - Analyzed and Fixed Most
of the Frequent Failure - Improved Case/ticket Matrix.
. Experienced in Automated Billing interface Load Process Design and
development
. Expertise in Banking interface (Positive payment with RBC, Wachovia,
Simone First Bank, NBC Bank, EFT Payment Interface with StandarCharted
Bank Singapore & Manila and SunTrust), Daily Disbursement Audit Report
with RBC Bank
. Developed Lockbox Payment interface with RBC, Wachovia and Bank Of
Montreal
. Experienced in Collection Management configuration and setup(condition
monitor, Collection rules, Dunning Rules, eBill User Classification &
Setup, Invoice notification and email setup)
. Involved in PeopleSoft Data migration, Project migration, People Tools
upgrade, Bundle upgrade and applying patches
. A keen communicator with abilities in analyzing customer needs and
assisting development teams for addressing issues during project
development stages.
. Strong collaboration & team building skills with proficiency at
grasping new technical concepts quickly and utilize the same in a
productive manner.
. Having Good experience on Quality Process adhere to the Quality
standards
. Having 2.6 Years Level 1 Support experience at client Site Thomson
Financials- Boston, MA, LexisNexis - Dayton, OH and IHG - Atlanta, GA
Professional Experience
. Jun 2005- Till date working as a Senior Consultant in HCL
Technologies Ltd., Noida.
. Nov 2003- May 2005 worked as a software Engineer in Hexaware
Technologies Ltd. Bangalore
. May 2003- Oct 2003 Worked as a Programmer in Innovators India Digital
Technologies (IIDT) P. Ltd, Chennai.
PeopleSoft Experience
. PeopleSoft Financials 8.4x/8.9/9.0 and PeopleSoft CRM 8.9
PeopleSoft Technical skills
. PeopleTools 8.42/8.47/8.49 (Application Designer, Application Engine,
Data Mover, Process Scheduler, PS Query, Security), PeopleCode,
Component Interface, ExcelToCI, File Layouts, Workflow, SQR, Crystal
Reports, XML Publisher, Integration Broker, PIA. Application Package
. Tree Manager, PS Security, Process Scheduling
PeopleSoft Financial Functional:
. Accounts Payables, Accounts Receivables, Billing, Franchisee Billing,
eBill, Asset Management, Purchasing, eProcurement, Order Management,
Cash Management, and General Ledger.
Third-party & Custom Application Supported:
Wildcat, GetPaid, Secure 32, Vertex, Kofax, Oracle IPM, DRS (Daily
Revenue Management System), PMS Property Management system), POM
(customized Purchase Order module), TLE, Clarity and Treasury
Workstation, TSO/JCL Job Scheduling & monitoring
Education
Bachelor of Engineering (Information Technology) from Madurai Kamaraj
University in India
Other Skills
Languages
. SQL, PL/SQL, Visual Basic, Visual FoxPro
Tools
. STAT, XML, JSP, Servlet, ASP, TSO/JCL and Zeke, PVCS, PVCS Tracker,
Team Tracker, WebStar, Toad
Operating Systems
. Windows-NT 4.0, Windows- 9x/XP/Vista, UNIX
Database
. Oracle 8i/9i/10g, SQL Server 2000/2005
Professional Experience:
HCL Technology Ltd,
Since Jun. 2005
1. Intercontinental Hotels Group (IHG), Atlanta, GA
Aug 2008 to Till Date
Production Support and maintenance PS Finance 9.0 and PS CRM 8.9
In Aug 2007, HCL Technologies was awarded the contract from the IHG, GA,
for Implementation and support for Peoplesoft CRM and Financials. IHG is
the world's largest hotel group by number of rooms. IHG owns, manages,
leases or franchises, through various subsidiaries, over 3,650 hotels and
540,000 guest rooms in nearly 100 countries and territories around the
world. The Group owns a portfolio of well recognized and respected hotel
brands including InterContinental Hotels & Resorts, Crown Plaza Hotels &
Resorts, Holiday Inn Hotels and Resorts, Holiday Inn Express, Stay bridge
Suites, Candlewood Suites and Hotel Indigo, and also manages the world's
largest hotel loyalty programmer, Priority Club Rewards with over 28
million members world wide
Jeyaseelan Providing the Techno-Functional support for PeopleSoft
Financials & CRM Applications (PeopleSoft Financials 9.0 & PeopleSoft CRM
8.9).
. Performing the daily routine support work (Issues Reported by the
Customers) for PeopleSoft Financials & PeopleSoft CRM
. Involved in meetings with Business Users to gather information for
business requirements to write functional and technical specifications.
. Have implemented Application Security based on User Business Unit and
User Table Set Controls.
. 24 * 7 On-Call Support (Handling Mainframe Jobs Abends/ Interface
failure/ L1 tickets raised by business Users) and escalating calls to
corresponding process owners.
. Coordinating with End User/Offshore/Onsite team to analyze the root
causes of the various
. Customized various IHG Specific Process as per the new business
requirements - Invoice Extract, Growth Agreement Load, Customer updates,
FactBook invoice load, FactBook Statement load, Automated Monthly open
period and Run Control updates (AP, AM and AR), IHG invoice notification
process, Invoice status change.
. Experience in Automated Billing Interface Load Process development from
Various Bill Source ( Guest Relation, Terminal Maintenance, Priority club
Bills, Travel Agent Commission Bills, Terminal Maintenance Bills, LMS
Billing)
o Custom Billing interface (Application Engine) Process ( File Layouts,
Customized Billing Transaction Setup, distribution code) will Load the
bills into Peoplesoft
. Misc Bills Upload through (Excel Spreadsheet )
. Developed AR_ERROR nVision Report to validate during Month-end - Billing
error, Misc Upload Errors, Inv not completed, AR Errors, Any AR Group not
Complete, Deposits Not Posted, Maintenance Work Sheets Not Posted,
Transferred Work Sheets Not Posted, BI Not Jrnl Gen, AR Item not Jrnl
Gen... etc)
. Worked on eBill Payment (Direct Deposit) interface with Wachovia Bank
. Involved in Collection Management configuration and setups -Condition
Monitor
. Mexico Accounts Payables implementation
o Implemented the vendor load through Excel component interface to
load vendors
o EFT - bank was very responsive and helpful - worked well to talk
directly with the bank rather than going through the employee
liaison (Created 2 EFT layouts, Crystal check and Created Two pay
cycles)
o Vendor Maintenance Report
The vendor master needs cleaning up to assist in meeting
regulatory requirement deadlines and ensure accurate and time
payment processing.
. Automated EFT and Positive payment file process Transmission - Sun Trust,
Simone first Bank, Simone First Bank, NBC Bank
o Customized the PayCycle processing steps
o Developed Positive payment process and EFT Payment Process
o Automated file transmission through UNIX - Mainframe - IHG Relay
Server.
. AP Data Archival completed successfully in Production -
Vendor/Payment/voucher Data Archival Done for EMEA/ASIA/AMER Region
. Worked on IHG Customized Purchase order Module (POM) - Retrofitting
various issue with Multicurrency PO's, budget Calculation, Change Order
and workflow Routing issue
. Developed and customized the Lockbox Load Payment Interface Wachovia and
Bank Of Montreal (BOM)
1. Receive the Lockbox Payments from the Bank to our IHG Relay Server
and then it will be Transmitted the file to the
Mainframe system
2. Daily lockbox load process will format and transmit the file from
Mainframe to UNIX file server
3. Developed the custom program to split the lockbox file (HHAR0020)
4. experience in Payment Predictor Setup
. Major Customization and Development & support Activities performed
o Activities performed During the Month End to achieve the Milestone
. Running and scheduling the list of Batch processes at various
time zone.
. Address the issues raised during the Cash application (
Lockbox Payment, Manual Direct Journal Payment/ Cash
clearing) and running various validation reports
. Handling Adjustment/ Revenue Reconciliation and GL Allocation
issues
o Coordinate with the Data center/ Banks/EDI Vendors/ ETL
Team/Franchisee Admin and schedule the job to load the
vouchers/Payment files/ Travel Agent commission /check image
o Rescue Data Archival completed Successfully
o Rescue Administration Activities performed (New Quick code/Case
Classification Setups/Email Template/ERMS Structured and
unstructured mail setup/ Support and Helpdesk module secured cases)
o Error Handling of the ERMS systems and routing to emails to
corresponding Group worklist.
o Prepared the Template for the Asset Spreadsheet upload/ Mass Asset
Transaction and calculate the depreciation and NBV.
o Fixing the Journal errors either loaded from Sub module or external
journal upload.
o Book to Bank Reconciliation Performance issue
o Excel Spreadsheet upload (Journal / Sales/ Bills/ Adjustment )
. Broadcasting Outages/Cutover/Maintenance Schedule timing to the business
users, application
. Retrofitting 9.0 Upgrade defects & issues
2. Lexis Nexis, Dayton, OH
Jan. 2008 to July 2008
PeopleSoft 8.9 e-Pro Implementation - FULL SYNCHRONIZATION BETWEEN LNG84
AND LNP89
LexisNexis has their main PS Application in PeopleSoft V8.4 running
currently in Production except the ePro/Purchasing applications.
eProcurement and Purchasing modules needs to be developed in PeopleSoft v
8.9 while all other LN PS applications will remain same on the PeopleSoft
version v 8.4. Inherent in the user requirements for procurement is the
ability to maintain database synchronization between PeopleSoft v 8.4 and v
8.9. This will require the use of the Integration Broker Messaging utility
Jeyaseelan has involved in development of Synchronization Processes
(LN_FULLSYNC) between PeopleSoft 8.4 to PeopleSoft 8.9 as a part of Lexis
Nexis ePro module implementation
. Categorization of the setup tables and transaction tables into Setup
Codes, Business Units updates, Setup Account, Setup Procurement, Tax
Data, Misc Data, Vendor Setup, User Setup, Item Data, and Transaction
Tables.
. Created an App Engine Program (LN_FULLSYNC) and few PLSQL scripts to
update the tables having long data type fields
. Involved in Integration Broker Configuration Setup
o Setup Node definition
o Synchronize the Message and Message Channel with the same
structure on both source and Target system
o Involved in Testing of Successful Publish or Subscribe
. Go-Live Major Issues support from Onsite (Dayton)
o Implemented Combo Rule in e-Pro to sync both LNG84 and LNP89
Environments
o Cancelled PO and Reserved PO not sync
o Item Category Inactive and update new UNSPSC code.
o Applied Existing LN specific customization Non-PO Receipts and PO
Receipts to ePro
o Buyer Approval customization
o Handled Data issues reported by business users
3. Thomson Financials Outsourcing Project, Boston, MA
Jun. 2005 to Dec 2007
Production Support and maintenance PS Finance 8.4 and PS CRM 8.8
Thomson Financial have operations across the globe to leverage their
clients to acclaimed financial intelligence, integrated into unique and
customized technology solutions, to make smarter decisions, attain higher
productivity, and ultimately achieve superior results. Thomson Financials
has Operations in 22 countries. Thomson Financials has PeopleSoft Financial
system upgraded to version 8.4 from 7.5. Currently they have PeopleSoft OM,
BI, AR, PO, AP, GL, AM modules to support their day to day Transaction. The
project is primarily Application Management Support Services including
periodic client specific customization and enhancements.
As a Consultant Jeyaseelan responsible for:
. Various support issues resolution mainly raised by business users. The
issues are related with the various modules and different technical
domains. Issues also included security issues, Fast Security record,
Optimization issues, Issues/Discrepancies found in modules
functionalities etc.
. Gathering the detail requirements from the Users and preparing the BRD &
TDD, development and testing.
. Coordinating with End User/Offshore/Onsite team to analyze the root
causes of the various problems and then fixing the cause of the problem.
. Involved the development of Interfaces and Integrated with the Third
party Applications
o Uploading the Usage Information on the Sales Orders through
interface process after every month extending the schedule
o Designed and developed Customized billing interface process to add
the usage in existing customer bills.
o Upload the daily transaction done on the PeopleSoft into the third-
party GETPAID System
o WildCat Interface - Developed the process of automating the monthly
Wildcat revenue entries feed into the PeopleSoft GL
. Automated Scheduled Process Transfer the revenue Journal
Files from Wildcat System FTP site to PS fileserver and then
kick-off the GL Import Process to upload the Journals to
Peoplesoft
o Electronic Invoice- Based on the TF Business requirement
Implemented Provision to Email the Invoice PDF files to Customer
Once Invoice Finalized from Peoplesoft. (For those customers the
Invoicing option and & emailing configuration will maintained
separately)
o Item Loader Interface- To load Item information from an Excel
Spreadsheet into PeopleSoft Item Tables.
o Vouchers & Payment details upload through EDI and Customized
Interface (AMEX Credit Card, Adecco, FedEx and Extensity Vouchers)
o Extracted 1099 Data from PeopleSoft and send those data to the
Third-Party system eComply and it was processed outside of the
PeopleSoft
. Major Customization and Setup done with respect to Thomson Business
Process
o Bank Reconciliation and Positive payment Interfaces for Royal Bank
of Canada (RBC)
. Implemented the Positive payment method to prevent fraudulent
Check
o EFT/CHK Payment interface for Standard charted bank (Hong Kong,
Singapore and Manila)
o Foreign Currency Payment Bank Setup for Standard charted bank Hong
Kong.
o GST/VAT Setup for Canadian voucher payments
o Lockbox file Upload interface ( RBC Bank)
. The Bank will transmit the daily transaction through FTP and
those lockbox files will processed through Automated Daemon
Process (This Process will automatically kick-off the Lockbox
load, Payload & AR Update Process)
o Payment Predictor, Write-Off Setups to Handle the Under Payment &
smaller Dollar Amounts
o TradeSuite Billing Interface (TFOMGBLL)- Modified TF Custom
Interface load process to fix the frequent failure during Bill
Close
o Omgeo Billing - Price Protected Order (TFORDSCHD) Customization and
Price tire setup for Tiring & Non-Tire Products
o Customized Various Invoice layout format & changes based Business
Group request
o New Business Unit Setup (GL/AR/AP/AM) and inter/Intra unit
Accounting Setup
o Load the asset through Interfaces and Handled Issues related to
Bulk Asset Inter/Intra Unit Transfer and Retirements related.
o Handled Issues/Discrepancies found between the Base module and GL (
Base Module Accounting Entry/Trail Balance/Leger)
. Audit Related Activities Handled
o Played the Version Control Administrator (PVCS), PQA role for TF
Project
o SOX/PWC Audit Related Activities Handled
Hexaware Technology. Ltd Bangalore
Nov. 2003 - Jun 2005
Financial Management System
The PeopleSoft Financial Management Support (FMS) GSC team in Hexaware
Technologies is to maintain and support the whole PeopleSoft Financial
Module which consists of Billing (BI), Accounts Receivables (AR), Accounts
Payables (AP), Asset Management (AM) and General Ledger (GL) Modules along
with its infrastructure. Jeyaseelan was Team member for Asset Management
Module and usually worked for AP/AM Modules.
As a team member Jeyaseelan was responsible for:
. Analysis of the reported problem and replicating the same with the
existing environment, Functional and Technical analysis of the issue and
taking development decisions in AP/AM.
. Involved in Bug fixing and customizing PeopleSoft Objects ( Fields,
Record, Pages, Components and PeopleCode)
. Troubleshooting Delivered and customized process (App Engine, SQR
reports) like Asset Transaction Loader (AMIF1000), Depreciation Calc
(AMDPCALC) and Accounting Entry Creation process( AMAEDIST)
. Preparation of Unit Test Plans, providing software fix for reported
problem, conducting Unit Test, documentation (Installation Doc, Code-
Changes Doc, Pre-Requisite Doc etc.) and packaging the fix as per
PeopleSoft standards.
. Testing before/after migration.
. Performed impact analysis to determine any adverse effects on other
modules.
. Developed test cases, test plans and usability plans.
Innovators India Digital Technology Pvt. Ltd Chennai, India
May 2003 - Oct. 2003
Export Management System (Expo)
Client: M/s. Electromags, Perungudi, Chennai.
Tools: Visual Basic 6.0, Oracle 8.0, Crystal Report 8.0
Export Management Systems; automate every stage from customers order
till payment to exporter invoice. It maintains Enquiry Form, it enquires
the consignee, country code, shipment date, mode to transport and item
details with quantity and rate. According the enquiry, order is placed.
This System configures country with currency, customer address, material
code and name, exporter. In addition to this Bank details and other details
are entered. Report module manages invoice, order, customer and pending
order, total order, customer wise, and order wise.
As a Team Member involved in Development of Crystal Reports and Forms like.
Goods Inward Note Preparation
. Material Receipt and Inspection Report (MRIR)
. Material Rejection Note ( This is for material returned to the
supplier)
. Stock Ledger
. Material Issues ( to the departments or production floor or to sub
contractor)
. FIFO (First in first out) by maintaining batching of material where
ever necessary.
Truck Monitoring System
Client: M/s. Rajashree Cement, Malkhed road, Karanataka
Tools: Visual FoxPro 6.0, SQL Server 2000, Crystal report 8.0
The Truck Monitoring System is capable of monitoring the movement of trucks
coming to the factory. The software can be used to monitor and maintain
details about the Truck Gate In time, Gate out time,Packing plant in
Time, Packing plant out time,type of materials,Transport, loading and
unloading details. The software interfaces two weighbridges, 8 proximity
readers and keeps track of more than 200 trucks every day.
As a Team Member involved in Maintenance of Card Reader Interface and
Crystal Report Design
. Fine tune Proximity Card Reader Interface coding
. Database Access fine Tunings
. Migrating data from Sybase Database to SQL Server Database
. Truck Turn around Time Report and CMO Report, Pending Truck Reports
. Truck waiting at Security In/out, Packing Plant and Weigh Bridge
Report
www.carbonblock2003.com
Client: M/s. Hi-Tech carbon, Gummudipoondi, (Unit of India Rayon, Birla
Group), Tamil Nadu
Tools: ASP 3.0, IIS 5.0, Flash 5.0 and MS Access 2000
This Website is designed for Carbon black 2003 6th Conference (The
emerging market in Agra pacific). This is an International Conference and
6th by Carbon Black Asia Pacific forum aim to bring together the producers
of Carbon Black along with Feedstock suppliers, processors and equipment
suppliers for an examination of the materials current status and to discuss
future strategies for growth and profitability.
As a Team member involved in
. Designing an Interactive pages and Navigations
. Designed Sponsorship benefits, About Conference, Reasons to Attend,
Organizing Committee program profile, Online Registration, Hotel
Reservation, Exhibitors
Training Program Attended/Conducted
. Peoplesoft Functional Training Conducted in HCL (AP, AR and AM)
. Attended training in SQL Server 2000 and Certified in Visual Basic 6.0
. OCA Certified (IZ0-007, IZ0-147)
. Certified in Banking Basic module
. Crystal Report & XML Training conducted in HCL.
. Attended the Oracle Fusion Middleware Training in HCL (Jdev & BPEL)
. Attended the Level 1 Retail Training Program in HCL (SCM, Logistics &
Warehousing and Retail)
. Effective Business Communications, Presentations Skills and Strategic
for Success
. CMMI, PQA and PVCS Training
Contact this candidate