Bhagath Manan
Phone: 518-***-**** Email: *******.*****@*****.***
PeopleSoft Techno-Functional Consultant
. A Highly Motivated and Team-Oriented Professional with Ten years
experience in Information Technology.
. With over Nine years of experience as PeopleSoft Technical Consultant.
. Extensive Experience in PeopleSoft Financials, HR & SCM modules like
GL, AP, AR, Billing, Purchasing, ePro, AM, Expenses, Payroll, Time and
Labor, HR, Benefits, OM, and Inventory.
. Worked Extensively with People Tools, SQR, PeopleCode, Work Flow,
Application Engine, Component Interface, Integration Broker, File
Layout, PS Query, Oracle, and SQL Server environment.
. Participated in all phases of ERP life cycle like Implementation,
Customization, Development, Production Support and Upgrade.
. Extensive knowledge in report writing using SQR, PS Query, XML
Publisher and Crystal reports.
. Very good experience in developing new SQR's for various business
process implementations.
. Good understanding of Peoplesoft Internet Architecture, Process
Scheduler, web server.
. Worked with Security Administrator to implement security in various
levels. Creating Roles, Permission Lists, User Profiles, Portal
Security, folders, Content References and Definition Security.
. Experience with documentation, end user training, Troubleshooting, and
post-production support.
. Excellent working knowledge in Developing, Debugging, Troubleshooting
and Testing of SQR's, App Engines, and other PeopleSoft Applications
. Excellent oral and written communication skills, short learning curve
and strong team work spirit with excellent leadership qualities.
Technical Skills
PeopleSoft : PeopleSoft Financials, HR &SCM
Applications
PeopleSoft : 8.0, 8.4, 8.8,8.9,9.0,9.1
Versions
People Tools : Application Designer, Page Definition, Components,
Security Administration, People Tools, PeopleCode,
Workflow, Application Engine, Component Interface,
File Layout, Process Scheduler, Tree Manager, Data
Mover, PeopleCode Debugger.
Reporting Tools : SQR, PS Query, Crystal Reports
RDBMS : Oracle, SQL Server, DB2
RDBMS Tools : SQL Talk, SQL*PLUS, Query Analyzer
Languages : C, C++ and SQL
Front Ends : PeopleSoft Portal
Database : TOAD, SQL Navigator
maintenance &
Performance Tuning
Professional Experience
Randstad, Atlanta, GA
May'12-Current
(Randstad is a global provider of HR services. Randstad is the third
largest staffing organization in the U.S. With its 5,324 employment
experts, Randstad puts an average of approximately 100,000 people to work
in the U.S. each week, through its network of nearly 1,000 branches and
client-dedicated locations)
Role: PeopleSoft Technical Consultant
Project :PeopleSoft Production support,Enhancements and upgrade 9.2.
Responsibilities:
. Day to day production support activities.
. Develop a bolt-on tool in PeopleSoft, which would integrate with a
third party software convertxls to create xls reports.
. Developed reports on the bolt-on dataware house system for users.
. Developed a new interface to load the time into PeopleSoft Bolt-on
time entry system.
. Developed the processes, interfaces and reports to support PeopleNet
integration for the PeopleSoft.
. Developed data load interface, which would load vendor data from JD
Edwards into PeopleSoft.
. Updating the messaging(Contacts, User profile) from Front office.
Environment: PeopleSoft Finance(Billing, Receivables, Bolt-on time entry
system, Bolt-on data warehouse, Bolt- on ebilling system), People Tools
8.43 (Application Designer, PS Query, SQR, App Packages),Messaging.
Navy Federal Credit Union, Vienna, VA
Sep'11-Apr'12
(Navy Federal is an armed forces bank. Serving the Navy, Army, Marine
Corps, Air Force, Veterans, and DOD. Navy Federal is the largest natural
member (or retail) credit union in the world, both in asset size and in
membership. As of September 2011, Navy Federal had over $45.5 billion USD
in assets, and over 3.8 million members.)
Role: PeopleSoft Techno-Functional Consultant
Project : PeopleSoft Finance Implementation 9.1
Responsibilities:
. Developed a New Voucher Interface to Bring the Invoice Information
into PeopleSoft and Create Vouchers for the same.
. Developed a New Workflow Using the Virtual Approver to help Processing
of Vouchers.
. Setup a Voucher Workflow Using the Delivered AWE Components,Client
Approval Rules and Route Controls.
. Developed Reports to Assist Users with their day-to-day Processing.
. Created web services to expose PeopleSoft Component Functionality to
Third Party.
. Created Webservices to Process Real time Interface Between a .net
Application and PeopleSoft Using Messaging and App Packages.
. Assisted the Functional Team In loading the Setup Data by Using Excel
to CI.
Environment: PeopleSoft Finance(Accounts Payable, Purchasing, GL,
Inventory, People Tools 8.51 (Application Designer, PS Query, SQR, App
Packages),Messaging.
DOW Chemicals, Midland, MI
Mar'10-Sep'11
(The Dow Chemical Company (NYSE: DOW) is an American Multi National
chemical corporation.Dow Chemical is a provider of plastics, chemicals, and
agricultural products with a presence in about 160 countries and employing
about 52,000 people worldwide with annual sales of $60 billion.)
Role: PeopleSoft Techno-Functional Consultant
Project : PeopleSoft HR Implementation 9.1
Responsibilities:
. Developed New Self Services Servlets for ESS & MSS.
. Developed New Approval Rules for Approving Vacations, Dept Change and
Salary Change MSS Servlets.
. Developed Reports for Users as Part of Cross Checking the Payroll and
Benefit Calculations.
. Created Benefits and Payroll Interfaces from PeopleSoft to Third Party
Using AE's and SQR's.
. Developed Real time Sync Operations between PeopleSoft HR and Third
Party by Consuming the Webservices.
. Mimicked the Delivered Cobol Process (PSHUP) and built an New APP
Engine to Replicate the Functionality of Cobol and also added new
Functionality to it.
. Assisted the Security Team in Creating DMS scripts for the Data
Transfers.
. Assisted the Functional Team In loading the Setup Data by Using Excel
to CI and AE's.
Environment: PeopleSoft HR(HR, TL, NA Payroll, Global Payroll, Benefits,
Self Services (ESS & MSS), People Tools 8.51 (Application Designer, PS
Query, SQR, App Packages, XML Publisher),Messaging.
Radiant Systems, Atlanta, GA
Oct'09-Mar'10
(Radiant Systems, Inc. is a global provider of innovative technology to the
hospitality and retail industries. For more than two decades, Radiant's
point of sale hardware and software solutions have helped to redefine the
consumer experience in more than 100,000 restaurants, retail stores,
stadiums, parks, arenas, cinemas, convenience stores, fuel centers and
other customer-service venues. Radiant has offices in North America,
Europe, Asia and Australia as well as reseller partners around the world.)
Role: PeopleSoft Techno-Functional Consultant
Project : PeopleSoft Financials and SCM Upgrade 8.0 to 9.0
Responsibilities:
. Prepare the Road Map to pull their Reports from 8.0 to 9.0.
. Brought Forward the SQR Reports, PS Queries, Crystal Reports and
nVision Reports to 9.0.
. Brought around 65 Exception Reports which were written in MS-SQL
Server Stored Procedures into SQL Server 2005 Environment.
. Assisted in Report, Query and Work Flow Security.
Environment: PeopleSoft Financials/SCM 9.0(GL, AP, BI, AR, OM, Inventory,
Mfg, Cost Management,
AM, Purchasing), People Tools 8.49 .21(Application Designer, PS Query,
Crystal, nVision, SQR), Stored Procedures,
SQL, Microsoft SQL Server 2005.
Surgical Care Affiliates, Birmingham, AL
Mar'09-Aug'09
(Surgical Care Affiliates is one of the largest providers of specialty
surgical services. SCA operates more than 130 ambulatory surgery
centers/surgical hospitals across the country with more than 2,000
physician partners to deliver quality surgical services.)
Role: Sr.PeopleSoft Technical Consultant
Project: PeopleSoft Financials 9.0 Implementation.
Responsibilities:
. Prepared the Conversion Documents for Vendors and GL Journals, Ledger
data to pull the Data from PeopleSoft 6.0 to PeopleSoft 9.0.
. Developed SQR's to Load Vendors, Journals and Ledgers Data from
Version 6.0 to Version 9.0.
. Modifications to the Existing SQR's, Crystal Reports in PO, AP, AM
Modules and nVision Reports.
. Design and Develop a Customized Workflow for Requisition Approvals.
. Customization to Voucher Component to attach Invoices (Images)to
Voucher Page.
. Design and Develop a Customized Workflow for AP Voucher Approvals.
. Worked on enhancements to Journal Workflow.
. Design and Develop a Component Interface and Application Engine to
Initiate Journal Approval
. Process for Journals in Batch
. Design and Develop a Bolt-on Module (to Mimic the Receivables
Functionality) Which would track down the Payments Made by
the Corporate for its Departments and then on behalf of
Corporate send the Invoices requesting the Payments from the
Departments, Facility to Track those Payments, Facility to
Adjustments.
. Developed Crystal Reports for the Bolt on Module to track Payments, to
track Delayed Payments.
. Developed New Voucher Interfaces like One time Payments and Modified
Existing Interfaces.
. Created Specifications and Using Excel to CI Functionality Loaded User
Profiles.
. Used delivered Item loader to load Items from the legacy system - File
Layout and Application Engine.
. Modifications to POPO005 SQR
Environment: PeopleSoft Financials/SCM 9.0(GL, AP, AM, Purchasing), People
Tools
8.49.14(Application Designer, PS Query, Crystal), SQR, SQL, People Code,
Oracle 10g,
ING Americas, Atlanta, GA
Jun'08-Feb'09
(ING Insurance Americas is a vital part of worldwide ING Group, one of the
largest diversified financial services organizations in the world with
operations in more than 50 countries and 112,000 employees. Leading
provider of financial products and services for individuals and businesses,
including life insurance, annuities, mutual funds, retirement plans and
employee benefits.)
Role: Sr.PeopleSoft Technical Consultant
Project: PeopleSoft Financials and HCM 8.8 Production Support and
Enhancements
Responsibilities:
. Handle the Production Support Calls (24/7) and Resolve the Tickets
Logged by the Business Users and Business Analysts.
. Developed the Custom One time Interface to Load the Employee Data as
Part of Client's CitiStreet
acquisition Activities
. Created Processes which would load the Employee Data and Manager Data
from Various Tables to a Central Table which would be used by Users
for their queries.
. Tune the Performance of the Online Applications to minimize the
Processing times.
. A new Component Interface to Load the Additional Pay Data for the
Employees as Part of Client's CitiStreet Acquisition Activities
. Made Customization to the Job component to Facilitate HR's Request to
add a Date field of when the Manager has become a Manager for the
First time.
. Customized the EDS edit Process Customized AE program to eliminate the
Inbound Files with Special Characters and Report the same to the EDS
Group to Correct the Errors in the Data.
. Involved In All Phases of Testing.
. Developed PeopleSoft Integration with Oracle Identity Manager using
PeopleCode and Messaging.
. Developed Hierchial Reports Using XML Publisher.
. Modified the Crystal Reports PVY2000 AND PVY4000 in e-Procurement as
per the client requirement.
Environment: PeopleSoft Financials/SCM 8.8(GL, AP, AM, ePro, Purchasing,
Expenses, Budgeting, Cash Management), HCM (HR,
Payroll, Employee/Manager Self Service, Benefits) People Tools
8.48(Application Designer, PS Query, Crystal), SQR, SQL,
People Code,
Oracle 10g, Control-M, UNIX.
Idearc Media, Dallas, TX
Jul'07-May'08
(Idearc is a media company that manages and delivers print, online and
wireless publishing and advertising services on multiple platforms. These
include yellow pages, white pages, online directory and search services,
web site design and hosting services, magazines, direct mail and directory
and information services for wireless subscribers.)
Role: PeopleSoft Techno-Functional Consultant
Project: PeopleSoft Financials 8.8 Implementation.
Responsibilities:
. Developed data conversion documents and mapped fields from Peoplesoft
8.0 to PeopleSoft.8.9.
. Customized the PeopleSoft Payables Voucher Entry page to add more
asset Information in the Voucher (Physical Information of the Asset)
so that Asset Management gets more asset information.
. Modified INTFAPAM - Load Asset Request App Engine program to move the
Additional Asset Information from Payables to Asset Management.
. Developed a New App Engine program which would consolidate the Assets
with the same serial Number into a single asset.
. Customized the Preview AP/PO Page to allow the users to change the
asset profile field after the asset has been loaded into AM.
. Customization to Expenses and Voucher Components to Integrate Image
Now to Bring Images of Invoices and Expenses Receipts.
. Modified the Voucher Approval Workflow and Expense sheet Workflow to
allow Users to select from the List of Approvers to send the Vouchers
and Expenses for Approvals.
. Created Technical and Functional Design Documents for Interfaces of
Payables and Expenses.
. Created new File Layouts for Standard AP Flow which will be used for
all new AP Batch interfaces into PS AP.
. Developed an SQR to support the Load of the Credit Card Information
into Expenses using Delivered Messaging.
. Created Functional & Technical Specs for Batch Scheduling Using the
Autosys Scheduler.
. Developed SQR to Transform the Bank statements for Bank Reconciliation
Process.
. Worked on the application message using the Integration Broker to sync
the accounts and chartfields.
Environment: PeopleSoft Financials/SCM 8.8(GL, AP, PO, ePro, AM, Expenses),
People Tools 8.48(Application
Designer, PS Query), SQR, SQL, People Code, Image Now, Oracle 10g,
Autosys, UNIX.
Visteon, Plymouth, MI
Jan'07-Jun'07
(Visteon is one of the world's largest suppliers of automotive parts. The
company operates in 27 countries. Visteon provides a full supply chain,
that is to say it designs, develops and manufactures automotive parts from
the needs of its customers. Visteon is to the Ford Motor Company as Delphi
is to General Motors.)
Role: PeopleSoft Techno-Functional Consultant
Project: PeopleSoft Financials 8.4 Development & Production Support.
Responsibilities:
. Prepared Design Documents for PSGL and PSAR to support Visteon with
its plan to divest plants to New Buyers (Automotive Components
Holdings).
. Provide Buyer and Visteon with sufficient financial account
information to close their own books by establishing separate
functioning unit for each sale plant and buyer.
. Involved in the AR Configuration Set-up for new plants.
. Created the Detailed Functional and Technical specification documents
For the Account Conversion process based on the Client's sell-Side
requirements.
. Developed a custom Process in PS-GL as per the Client's Sell-side
Requirements. This Account Conversion process will ensure that the
Accounting entries for all plants sold to external buyers are mapped
to the proper ledger account/affiliate code for sales, cost of sales,
FCA, receivables and payables.
. Developed an Application to Maintain the Account Conversion Rules.
Based on these rules the converter will process all inbound feeder
system entries and perform the conversions before the data arrives
into the ledger.
. Provide new reports Like Summary and Detail List of GL Account
Conversion updates on Journal Records, Account and Business Unit based
Transaction Amount Reports.
. Modified security settings after gathering requirements from user
groups to determine security structure.
. Involved in identifying, developing test scripts and testing for the
receivable process starting from Entering Receivables, Entering
Payments, and Applying Payments to generating accounting entries for
the AR application.
. Resolved issues with Receivables Interface and also issues with
AR_UPDATE process.
. Involved in modifying the Picking plan - INS6000 to print all the back
orders.
. Modified the Packing slip - INS6500.SQR to print grouping all the Ship
to location address together to print on one Packing slip.
Environment: PeopleSoft Financials/SCM 8.4(GL, BI, AR, Commitment
Control/Budgeting, Inventory), People Tools
8.4(Application Designer, PS Query), SQR, SQL, People
Code, Oracle 9i, Autosys, UNIX.
MLT Vacations, Minneapolis, MN
Feb'06-Nov'06
(MLT Vacations, a wholly owned subsidiary of Delta Air Lines, is one of the
largest providers of vacation packages in the United States, managing
multiple package vacation brands.)
Role: PeopleSoft Techno-Functional Consultant
Project: PeopleSoft Financials 8.0 Enhancements and Production support
Responsibilities:
. Developed Enhancements to Support the Customized Invoicing Process for
the Foreign Currency Vouchers.
. Made changes to the Customized Voucher Build Process to facilitate for
the Foreign Currency Vouchers.
. Developed custom Crystal Check (APY2021) per client's business
requirements.
. Supported the Issues Related to loading the Bank Statement files into
PeopleSoft Bank Statement tables, to enable the Electronic Entry of
Bank Reconciliation data to support Automatic Reconciliation of Bank
Transactions.
. Worked on enhancing the performance of the applications and the
reports (SQL Tuning).
. Supported in troubleshooting AP and GL issues like offset balance
between the AP and GL.
. Handling of Web Servers and App Servers.
. Modified the delivered Report APY 3200 (Transaction by Vendors).
. Developed SQR report from Accounts Receivable that will be used to
generate the flat file with details of all checks for payment and
cancellation the Client used this for the Bank Reconciliation.
. Developed new reports like AR Cash Receipts, Check Summary Log and
Customer Summary Information.
. Worked on the Asset Depreciation issue, there are some Assets which
are not depreciated correctly. I have corrected in the application
table with scripts.
Environment: PeopleSoft FSCM 8.0 (Purchasing, AP, AM, AR, Billing, GL,
Budgeting), People Tools 8.17, Application
Designer, Application Engine, PS/Query, SQR, Oracle 9i,
Crystal Reports, Win NT, UNIX
United Systems Integrated, INDIA
Jan'03 - Jul'03
Internship
Project: This Project includes overall hospital activities management.
Generating various reports on daily
Outpatients report, inpatients report, employees report,
income report, wards report.
Responsibilities:
. Did front-end validations using Java Script. Used VBScript for server
side validations.
. Used ADO for connecting remote Database with main database.
Established database connectivity using ODBC
compliant drivers.
. Designed and developed modular Business components as COM components
using object oriented methodologies.
. Used MS SQL Server 7.0 as a backend database. Used Crystal Reports
6.0.
Environment: Visual Basic 6.0, VBScript, COM, Visual Interdev 6.0, ADO,
ODBC, SQL Server.
Education
Undergraduate degree (Computer Science Engineering)
April-2003
Osmania University, Hyderabad, India
Master's degree (Computer Science Engineering)
December-2005
University of Louisville, Louisville, KY