SUMMARY:
. Over ** years of IT experience in Design, Development,
Implementation, Upgrade and Conversion of Client/server based
Business Applications of which over 10 years in PeopleSoft
Financials (FSCM), Distribution, Manufacturing, CRM (Order
Capture), and HRMS modules.
. Extensively worked on Upgrade the system from 8.4 to 8.9
applications and primarily responsible for analyzing compare
reports, replicating customizations, Upgrading interfaces and
reports.
. PeopleSoft skills include PeopleCode, Application Engine,
Integration Broker, SQR, Data Mover, and Application of patches
and fixes by going to customer connection, debugging existing Page
PeopleCode, Application engine SQL's and PeopleCode and SQR
programs, Custom enhancements, modifications and Converting the
data from Legacy to PeopleSoft.
. Comparing, Upgrading projects and migrating objects from
development to test and to production databases using PeopleSoft
Migration process and also using STAT software, performance
testing/tuning, Installing PeopleSoft Clients, PeopleSoft Message
agent to call data from PeopleSoft to an external client
(Integration Broker), PS Query, Import Manager,
Interface/Conversion programs, PeopleSoft Security and Application
Engine.
. Provided documentation, specification, and training, writing shell
scripts, and scheduling tasks using PeopleSoft Process Scheduler.
. Extensively worked on Component interfaces for loading the data in
online system through Application engine.
. Extensively worked on Integration Broker for Integrate with third
party systems.
. Working with end users in various roles like to gather the
specifications, develop the application, Converting the legacy
data and unit testing before going to test and production,
production support for troubleshooting and performance tuning.
. Solid PeopleSoft lifecycle Implementation expertise with
successful delivery of over eight people soft projects by
executing various roles and management levels. Skilled in
Performance tuning and bottlenecks removal of people soft
applications.
COMPUTER SKILLS:
ERP PeopleSoft 9.0/8.9/8.8/8.4/7.5x/7.x (OM/INV/ Order Capture/ BORM/
Purchasing PO/ ePro/ sPro/ Project Costing PC/Commitment Control
KK/ BOM/GL/ AP/ AR/Billing BI/AM/ Help Desk/ Self-Service/
Call-Center/ HR and Benefits).
Reporting Tools SQR 3.0/4.x/6. x, PS Query
Languages PeopleCode, SQL, PL/SQL, C, C++, Java, COBOL, Shell Scripting
Database Oracle 10G/9i/8i/8.x/7.x, Sybase12.5, DB2, MSSQL 7.0 and MS Access
GUI PeopleSoft Application designer, Developer2000 (Forms 4.5, Reports
2.5).
App Servers BEA Tuxedo App Server 6.5, WebLogic 6.1
Operating Systems Windows VISTA/XP/2000/NT/9.X, MS-DOS, UNIX Sun Solaris and HP UNIX.
EDI Trusted Link
EAI ACB 3.0 and 2.5, PeopleSoft Message Agent (Integration Broker)
Data Management DataMover, Import and Export Manager, Application Engine
Tools
Integration Tools PeopleSoft Messaging Architecture, PeopleSoft Integration Broker,
Component Interface, File Layout and Business Interlink
EDUCATION:
BS Computers.
PG Diploma in Computer Applications.
PROFESSIONAL EXPERIENCE:
UHS-Pruitt Corporation (Norcross, GA)
Mar '09 to Present
Senior PeopleSoft Developer/Analyst.
Since 1969, UHS-Pruitt Corporation, through its affiliates, has been
providing professional healthcare services throughout the Southeast.
With our beginnings as the Toccoa Nursing Center in Toccoa, Georgia; we
have grown to over 130 affiliated locations in Georgia, North Carolina
and South Carolina. But through it all, the focus has always been and
will continue to be - quality. Quality care, quality programs, quality
services and quality people. The project involves the application
support of PeopleSoft FSCM 8.9.
Environment: PeopleSoft Financial SCM 8.9, PeopleTools 8.46, Windows
XP, SQL Server 2005. (Purchasing, Project Costing, Commitment Control,
Billing, AP, AR, GL, OM, IN and Interfaces)
. Worked as a Production support team member, involved in Bug
fixing, Maintenance and Enhancements of Purchasing, Project
Costing Accounts Payable, Billing and Account Receivables modules.
. Worked on issues coming from PC_AP_TO_PC and PC_GL_TO_PC
Application Engine Process.
. Worked with End Users to gather Information for billing issues
coming from production database and resolved the issues.
. Worked on Issues Coming from AP Voucher build process and AP-PO
matching process.
. Worked on EDI 810 AP Voucher Feed data analysis and provided the
solution and developed application Engine program to fix the data
issues.
. Designed and Developed an Application Engine Program to Mark the
lines for Billing in PeopleSoft.
. Worked on Issues coming from PO Matching Process Exceptions.
. Worked on UOM Conversion Issues coming from PO, AP and INV.
. Customized PC to AP Delivered Application Engine Process.
. Worked on EDI 850 application engine process to load the orders
coming from DSSI site.
. Worked on PO Dispatch Application engine process to DSSI site.
. Worked on the price changes issues from Vendors Actual and Extended
Price tolerance for Items, PO, Receipts, Vouchers, Purchase Price
Variance (PPV) and Matching.
. Worked on Different PS Quires to retrieve the data for in house
monitoring of PO's and Vouchers.
. Customized Pages, Components, Record Definitions, Views and Queries
as a part of upgrade.
. Developed and Customized Delivered AR Condition Monitor (AR_CNDMON)
Application engine process.
Quest Diagnostics (Norristown, PA & Lenexa, KS)
Dec '07 to Jan 2009
PeopleSoft Data Conversion, Integration and Implementation Consultant.
Quest Diagnostics Is the nation's leading provider of diagnostic
testing, information and services, serving approximately 151 million
patients each year. A workforce of approximately 41,000 dedicated
employees, including more than 500 M.D.s and Ph.D.s, More than 33
laboratories in key U.S. markets, plus the U.K., Puerto Rico and
Mexico, Two esoteric testing laboratories, one on each coast. First
laboratory in the U.S. to achieve ISO 9001 certification. The project
involves the application implementation of SCM modules 8.8 (Replacing
Oracle SCM Application which is Used by LabOne) and merging of LabOne
and Quest Diagnostics Financial, SCM Systems.
Environment: PeopleSoft Financial SCM 8.8, 9.0, HRMS 8.8, 9.0, SAS,
PeopleTools 8.46, Windows XP, HP UNIX, Oracle 10G. (Purchasing,
Billing, PC, AP, AR, OM, IN and Interfaces)
. Worked with End Users to gather Information for Data Conversion
from Oracle Applications to PeopleSoft Mappings and Conversion
Testing Faces.
. Designed and Developed an Application Engine Programs to Load
Items into PeopleSoft.
. Designed and Developed an Application Engine Program for Products,
Product Price List and Product Catalogs to populate the data into
PeopleSoft Tables.
. Designed and Developed a Customer Interface Application Engine
Program for New and Legacy Customers and Contacts to populate the
data into PeopleSoft Customer and Contact Tables.
. Worked on Inventory Balances, Moved data from Legacy System to
PeopleSoft. Extensively Used PeopleSoft Delivered COBOL Process
to loaded Data into Inventory tables.
. Converted Inventory Storage Locations from Oracle applications to
PeopleSoft.
. Designed and developed a SAS Interface Application engine program
for Orders that are coming from SAS. This process is going to
Insert the order information into EC tables (Electronic Commerce).
. Designed and Developed a ProShip Interface Application Engine
Program which runs every one hour after Pick Confirmation process
to update the Freight Charges, Handling charges and Tracking
information into Shipping Issues.
. Designed and developed a Manual Shipped Order Process application
engine program to update the Freight charges and Handling charges
into shipping issues.
. Modified the Pick Plan report to populate the Shipping address,
Order Notes and Order number as barcode.
. Designed and Developed a GBF Outbound Interface PO Dispatch
Application engine Program which runs Every Night to generate the
outbound file.
. Designed and Developed a GBF OM Inbound Interface Application
engine Program which runs Every Night to add Freight lines,
Shipping and Tracking information to the orders.
. Designed and Developed a GBF AP Inbound Interface Application
engine Program which runs Every Night to create the Flat file to
AP Voucher Build Process.
. Designed and Developed Auto Mark Lines for billing Application
Engine Interface application runs Every night For Mark the GBF
Freight line Charges before Billing Job application Starts.
. Designed and developed a third party billing interface Application
Engine Program which runs every 15 days and loads the data into
Billing interface tables.
. Designed and developed Inventory Item adjustment Application
Engine program to adjust the Item quantity based on storage
locations.
SprintNextel, Reston VA (Oracle Corp. Consultant)
Apr 07 to Sep 07
PeopleSoft Upgrade and Implementation Consultant.
Sprint Nextel enriches workplace communications with wireline/IP
solutions and extends the workplace with mobility solutions giving
businesses the power to make just about any place a workplace. The
project involves the application of bundles, patches and fixes to
Financials and SCM modules 8.9 and merging of Sprint and Nextel
Financial Systems.
Environment: PeopleSoft Financial SCM 8.4 SP1 to 8.9 Upgrade & Sprint
Nextel PeopleSoft Merging, PeopleTools 8.47, Windows XP, HP UNIX,
Oracle 10G. (Purchasing, Billing, GL, AP, AR, SPro, EPro and
Interfaces)
. Worked on PeopleSoft 8.4 SP1 to 8.9 upgrade and Sprint Nextel Merging
(Data Conversion from Nextel system to Sprint system)
. Worked on AP, AR, PO, SPro and EPro 8.9 Modules to reapply the
customizations made by the client in the Version 8.4.
. Handled the issues coming from Requisitions made by the requestor.
. Handled the issues coming from PO Calculation and PO Creation
Application Engine process.
. Handled the issues coming from AP Voucher Build Process and
Customized as per the requirements.
. Developed custom Application Engine process to load the data from
flat file to AP Voucher build staging tables.
. Checks if the PO and PO lines exist for corresponding Voucher.
. Checks if the Receiver ID and Receiver line exist or not.
. Handled the price changes from Vendors, PO, Receipts, AP Vouchers and
Matching.
. Handled the price changes from Vendors Actual and Extended Price
tolerance for Items, PO, Receipts, Vouchers, Purchase Price Variance
(PPV) and Exchange Rate Variance (ERV) and Matching.
. Worked on Different PS Quires to retrieve the data for in house
monitoring of PO's and Vouchers.
. Customized Pages, Components, Record Definitions, Views and Queries
as a part of upgrade.
. Developed and Customized Delivered AR Condition Monitor (AR_CNDMON)
Application engine process.
. Worked on AP Matching to rectify the errors coming from Converted
data.
. Developed and Customized Delivered PC_AP_TO_PC Application Engine
Process.
GTSI Inc. Chantilly, VA.
Oct '03 to Apr '07
PeopleSoft Data Conversion, Integration and Implementation Consultant.
GTSI Inc. is a recognized IT solutions leader, focusing exclusively on
federal, state, and local government customers worldwide. For 20 years,
GTSI has delivered maximum value to public sector customers by teaming
with global IT leaders like HP, Panasonic, Microsoft, IBM, Sun
Microsystems, and Cisco. GTSI is headquartered in Northern Virginia,
outside of Washington DC, and has offices throughout the United States,
including Hawaii, as well as overseas in Germany and Korea.
Environment: PeopleSoft HRMS 8.8, Financial SCM 8.4 SP1 and 8.9
Upgrade, PeopleTools 8.43 to 8.46, Windows 2000/XP, HP UNIX, Oracle
9i/10G, Trusted Link (EDI). (HR, Benefits, Payroll, Time and Labor,
Inventory, Order Management, Purchasing, Billing, GL, AP, AR,
Interfaces)
FSCM 8.4 to 8.9 Upgrade:
. Worked on Full Life Cycle of Supply Chain Management System.
. Designed and Developed Master Loader Application Engine Interface
(Items and Products Updater/Adder) Which Reads the data From
Staging table and Inserts/Updates Depends on the Criteria.
. Designed and Developed Product Kit Loader Application Engine
Interface (Products Kits Updater/Adder) Which Reads the data From
Staging table and Inserts/Updates Depends on the Criteria.
. Designed and developed Quote Uploader interface Application Engine
Program which reads the data from the file (file Comes from Pbody)
and Creates Quote in PeopleSoft Using Component Interface.
. Designed and Developed Web Interface Messaging for Sales Order
Creation from GTSI.com to SCM. From Web we used to get the XML
Message, Using Integration Broker We read the data from XML and
set the CI properties for Order Creation. While Replying we are
sending an XML Message with Order Number.
. Designed and Developed Web Interface Messaging For Sales Order
Status from SCM to GTSI.com.
. Designed and Developed Auto Mark Lines for billing Application
Engine Interface which runs Every night before Billing Job Starts.
. Designed and Developed GTSI MSelect PO Creation Application Engine
Process Which Reads MSelect line items from Orders that got
Created and in Open status. The Process Creates PO's Related to
MSelect Line Items.
. Designed and Developed EDI 810 Application Engine Process for Drop
Ship Orders, Users used to send EDI files to GTSI. This process
reads the data from EDI files and Marks the lines for Billing.
. Designed and Developed on PO Dispatch EDI 850 outbound Application
Engine.
. Designed and Developed EDI 810 AP Application Engine Process which
reads the data from staging tables and corrects the data populated
by delivered EDI 810 inbound SQR.
. Checks if the PO and PO lines exist for corresponding Voucher.
. Checks if the Receiver ID and Receiver line exist or not.
. Checks if the Voucher is drop ship or not.
. Sends an email directly to vendors and buyers if there are any
errors.
. Customized Delivered PO SQR Report (POPO0005).
. Designed and Developed GTSI Packing Slip.
. Designed and Developed Quote, Quote to excel and Order Reports.
FSM 8.4 SP1:
. Worked on Full Life Cycle of Supply Chain Management System.
Phase 1:
. Worked on data mappings from Legacy system to PeopleSoft like
Customers, Contacts, Items, Products, Billing, Contracts, Purchase
Orders, Inventory, Quotes and Sales Orders Mappings.
. Developed an SQR Which Runs Nightly basis to Load the data into
Billing Interface Tables from Legacy System.
. Designed and Developed New SQR programs for Billing Reports (After
Invoice reports).
Phase 2: Data Conversion
. Worked with End Users to gather Information for Data Conversion
Mappings and Testing Face.
. Extensively Used PeopleSoft Items Loader to Load Items into
PeopleSoft. Modified Existing Item loader Application Engine
Programs for Performance.
. Designed and Developed an Application Engine Programs for
Products, Using Product Component Interface PeopleCode to populate
the data into PeopleSoft Product Tables.
. Designed and Developed an Application Engine Programs for New and
Legacy Customers and Contacts, Using Customer and Contact
Component Interface PeopleCode to populate the data into
PeopleSoft Customer and Contact Tables.
. Designed and Developed an Application Engine Programs for Purchase
Orders, Using PeopleCode to populate the data into PeopleSoft
Purchasing Tables.
. Designed and Developed an Application Engine Programs for Quotes,
Using Quote Component Interface PeopleCode to populate the data
into PeopleSoft Quotes Tables.
. Designed and Developed an Application Engine Programs for Sales
Orders, Using Sales Order Component Interface PeopleCode to
populate the data into PeopleSoft Sales Order Tables.
. Worked on Inventory Balances, Moved data from Legacy System to
PeopleSoft. Extensively Used PeopleSoft Delivered COBOL Process
to loaded Data into Inventory tables.
Development:
. Designed and developed Master Loader Application Engine Interface
(Items and Products Updater/Adder) Which Reads the data From
Staging table and Inserts/Updates Depends on the Criteria.
. Designed and Developed Product Kit Loader Application Engine
Interface (Products Kits Updater/Adder) Which Reads the data From
Staging table and Inserts/Updates Depends on the Criteria.
. Designed and developed Quote Uploader interface Application Engine
Program which reads the data from the file (file Comes from Pbody)
and Creates Quote in PeopleSoft Using Component Interface.
. Designed and Developed Web Interface Messaging for Sales Order
Creation from GTSI.com to SCM. From Web we used to get the XML
Message, Using Integration Broker We read the data from XML and
set the CI properties for Order Creation. While Replying we are
sending an XML Message with Order Number.
. Designed and Developed Web Interface Messaging For Sales Order
Status from SCM to GTSI.com.
. Designed and Developed Quote, Quote to excel and Order Reports.
HRMS 8.8 Data Conversion:
. Designed and Developed Application engine process for HR data
Conversion (Position data, JobCode data and compensation).
. Designed and Developed Application Engine Process for data
Conversion for Benefits Module (401K, ESPP, Leave Accruals
(Vacation, Sick, and Personal), Geographic Code Locations, Health
Plans, Life benefits, Dependent benefits and Disable Benefits)
from Legacy system (ADP) and converted, populated in to the
appropriate PeopleSoft tables.
. Designed and Developed Application engine process, SQL procedures
for cleaning up of existing HR data (Position data, JobCode data
and compensation).
. Designed and Developed an Application engine process for Payroll
Information to Bank, Which reads the data from payroll tables and
generates the flat file.
. Designed and Developed an Application engine process for Health
care, which reads the data from PeopleSoft tables and generates
the flat file.
. Extensively worked on Interface programs Using PeopleSoft tools
like Application engine and Component Interface Reading the data
from Flat file, Tables and setting the Properties on Component
Interface.
Rain Bird Sprinkler Mfg. Co. Glendora, CA. June '03
to Sept '03
PeopleSoft Integration, Implementation and Data Conversion Consultant.
Rain Bird Sprinkler Mfg. Co. is one of the leading Sprinkler Systems
manufacturing company. Having grown since 1931 from a family-owned
Sprinkler Systems manufacturing company in AZUSA, NEGALES, Mexico,
Europe and ASIAN Countries.
Environment: PeopleSoft 8.18 (Sp3), PeopleTools 8.16, Windows 2000, SQL
Server, PeopleSoft Financial SCM and Distribution (GL, AP, AR, BI, PO,
Inv., OM, CM, PM, PP, BOM, Routing and Forecasting)
. Developed Application Engine Process for data Conversion to take
the Item Master information from Fourth Shift. This Process reads
the data from Flat file, data comes from Legacy System (The MRP
software currently used in the plants in Tucson and Nogales (Plant
41)). The Conversion of Item Master allows PeopleSoft to have all
the raw material information with the items in the appropriate
tables and the Bill of Materials that exist in Fourth Shift are
converted and populated in to the appropriate PeopleSoft tables.
. Developed Application Engine Process, which will be used monthly
for the recalculation of the monthly weighted average FIFO cost
for raw materials. The purpose of this customization is to gather
all costs incurred for a month and to recalculate Weighted Average
FIFO Cost. This data will be used in the delivered Cost Rollup
Process.
. Developed an Interface, which will use external web application as
its quality solution, In order to account for materials in
PeopleSoft. The web application will access an item's BOM related
data to prepare inventory adjustments or transfers for its
components.
. Developed Country of Origin Set up, Which Allow Rain Bird
International and Finance System to obtain country of origin
information and NAFTA information regarding products that are sold
by Rain Bird.
. Developed Application Engine Process for data conversion to take
the Routing information from Fourth Shift. This Process reads the
data from Flat file, the data comes from Legacy System and
converted and populated in to the appropriate PeopleSoft tables.
. Involved in Customization of Records, Pages, Components and Menus.
Customized and created record definitions designed new Summary
Pages to display additional information and used PeopleCode to
incorporate validation rules according to the specifications.
. Migrated projects from the Development to Test database and then
to staging database after running the compare reports and the end
users tested the panels in staging, which was a copy of the
production database.
. Involved in customization of Records, Pages, Components and Menus.
Customized and created Record definitions designed new Summary
Pages to display additional information and used PeopleCode to
incorporate validation rules according to the specifications.
. Enhanced existing SQR's to print invoices, purchase orders, price
confirmations, request for quotes, Receiving Vendor, Item, Receipt
Date and Receiving Log by Date and Item reports.
FedEx, Memphis, TN.
Dec '02 to May '03
PeopleSoft Integration/Implementation Consultant.
FedEx global story began with the growth of FedEx Express, which today
covers more than 210 countries with fast, reliable express
transportation. FedEx has long been a leader in the global economy,
offering customers more choices, more places. The FedEx family of
companies operates hubs all over the world.
Environment: People Tools 8.42, PeopleSoft Vantive 7.5, PeopleCode,
PeopleSoft Application Messaging, Sybase 12.5, Windows2000, HP UNIX
(9000/800), PeopleSoft Financial/Manufacturing/Distribution (Order
Management, Billing, Purchasing, Inventory, GL, AM, AP) And PeopleSoft
CRM (Help Desk, Self Service, Call Center and Routing).
. Developed an Application Engine process which creates the User
Profile as well as workers automatically Using the excel
spreadsheet. Application Engine process reads the data from excels
spreadsheet and inserts in to the appropriate PeopleSoft tables.
. Developed an interface programming between PeopleSoft Vantive7.5 to
PeopleSoft CRM8.8 on Help Desk module. Whenever the User Created or
Modified one CASE on either PeopleSoft CRM or Vantive, It will
Modify or insert the data on both sides of the tables at a time.
. Involved in setting up of Employee Self-Service, Customers,
Products, Workers, and Call Center setup.
. Applied Patches for PeopleTools database, which Updates and Inserts
in to some of the tables (PSMSGSETDEFN, PS_MAINTENANCE_LOG), that
are delivered by PeopleSoft Corp. Using PeopleSoft DataMover Tool.
. Developed Interface programs for Solutions, which is provided by
Third party (Right Now Technology's) for Vantive system. For this we
modified existing PeopleSoft tables, Pages, and also we modified the
PeopleCode behind the Pages.
. Customized PeopleSoft Main Page By deleting all the Languages tags,
replaced PeopleSoft logo with FedEx company Logo in the main page as
well as all pages and reports (Crystal, SQR) and also add tags like
Forgot Password
. Created Roles, Permission Lists using PeopleSoft Security for Self-
Services users and also Admin users.
. Created a daily batch process to check the total amount owed for on-
hold orders for PIA customers and compare it to the total amount of
credit the customer has available on his account. If the customer
has a credit account balance that is enough to cover the cost of the
order, the batch process removes the hold on the line items for the
order.
. Involved in Writing a new Publication and Subscription Messaging
Programs, which will communicate the CRM database tables and also
the financial tables. The messages come from CRM as a XML files.
Using the Message Subscription And also Component Interface
PeopleCode we retrieved the data from XML files and inserted in to
the appropriated tables.
. Involved in Creation on File Layout Definitions and Application
Engine programs, which will be used for publishing a XML Messages.
Ferrellgas, KS.
Dec '01 to Nov '02
PeopleSoft Integration/Implementation Consultant.
FerrellGas Having grown since 1939 from a family-owned propane company
in Atchison, Kansas, to a nationwide company with more than 600
locations in 45 states, Ferrellgas is nothing less than an American
success story. And with its nationwide supply network, and fleet of
more than 4,000 delivery and service vehicles, 230 transport trucks,
and 200 railcars, Ferrellgas is entrenched as the nation's leading
retail Propane Company. Americans have relied on Ferrellgas for their
residential, agricultural, and industrial/commercial propane needs.
Environment: People Tools 8.14, PeopleCode, PeopleSoft Application
Messaging, Oracle 8i, Windows2000, PeopleSoft Financial/Distribution
(Order Management, Billing, Purchasing, Inventory, GL, AM, AP, AR,
Billing) And PeopleSoft CRM (Demand Forecasting, Routing And Mobility,
Order Capture).
. Developed new Application Engine process, It will run in CRM on a
nightly basis. It will search for Service Orders in with a 'Complete'
status that has not been processed before. The process will insert the
Service Order data into new staging tables, in the Financials Supply
Chain database. Application Engine process will be scheduled to run on
a periodic basis to process the data on the staging tables and Created
Sales Orders using a Component Interface.
. Created new SQR reports for tracking the purchase orders, PO Listing
by Supplier, Category, Item / PO Receipt Details by PO ID, Item, Line
Nbr/PO Receipt details by Vendor, Item &Price.
. Written a Application Engine Process that will select TAS PO data
from custom interface tables, merges it with PO default information,
and loads the data into the PeopleSoft Purchase Order tables
. Developed new Application Engine Process to extract customer delivery
information for NDEA customers. This file will be saved to a shared
drive and transmitted to North Dakota using the North Dakota provided
software, Called Expedite.
. Developed new Application Engine Process to loads the Temperature
Data (Daily, 30-year average and History. Loading of daily temperature
will be a dependent process for the Demand Forecasting. The Demand
Forecasting will load each evening.
. Developed Application engine Process Based on information received
from the Order Management System (OM) at defined times, the Routing
System (RS) will generate planned routes for Bulk deliveries for the
specified planning horizon. Once generated, the planned routes will
be sent back to OM.
. OM sends demand and resource data to routing interface.
. Routing interface interprets the data and sends to Descartes system.
. Descartes system constructs bulk routes and sends back to routing
interface Routing interface interprets route data and sends to OM.
. Used Process Scheduler and Process Definitions extensively to define
Application Engine Batch processes and report programs to enable them
to run from PeopleSoft on-line panels. Developed documentation for the
users.
Honeywell Corp, AZ.
Jun '01 to Nov '01
PeopleSoft Implementation Consultant
Honeywell Aerospace Solutions headquartered in Phoenix, Arizona is the
world's largest supplier of aircraft engines, equipment, systems and
services for commercial transport, regional, general aviation and
military aircraft. Honeywell also provides repair and overhaul
services; aerospace consumable spare parts, hardware and logistics
support; and management and technical services for space and
communications facilities.
Environment: People Tools 8.12/7.58,Peoplecode, PS Message Agent, MS
SQL Server 7.0, Windows2000, PeopleSoft Financial/Distribution (Order
Management, Billing, Purchasing, eProcurement, GL, AP).
Developed new PeopleSoft8 Application engine programs to read
data from a file to staging tables and then to PeopleSoft tables.
Undergone training on Honeywell Control Broker 3.0, which
included basics of ACB, the Control Broker core and adapters connecting
to the core.
Developed an application to fetch Order management information
from Order Header and Order line panels from PeopleSoft 8 using the
PeopleSoft message agent tool using the standard PeopleSoft API.
Setting up of all eProcurement pages, including an easy-to-use
guide to direct step-by-step through the setup process.
Used the eProcurement role actions to restrict or grant user
access based on job function and also we applied LDAP security and
PeopleSoft Security.
Performing customization in eProcurement to transparently include
inventory items in search category only to prevent from purchasing
goods that is already in stock.
Developed eProcurement pages for users they can update their own
personal information, Using the My Profile page, a user can update his
or her email address, password, favorites list, and personal templates.
Involved in sending the eProcurement PO to the vendor
electronically, using XML. Once a purchase order has the status of
Dispatched, it is converted to XML and placed on the PeopleSoft
Gateway, where it is transmitted to the vendor's URL.
Developed a custom solution where PeopleSoft Billing information
can be sent to the Orbix Client based on the Clients request using ACB
3.0.
Upgraded projects using Application Upgrader to move objects
(panels, queries, records, fields, etc.) between databases and to
compare the base version with the version available currently. Then,
Upgrade the Application, based upon the upgrade report and copy the
latest version to the target database.
City Center, Dubai, UAE.
May '99 to Apr '01
PeopleSoft Consultant
City Center is an upscale promotional discount department store selling
a full range of national and owned-brand general merchandise that meets
the basic and discretionary needs of families. City Center is one of
the nation's largest discount store chains, located in UAE.
Environment: People Tools 7.01, People Code, SQR 3.0, and PeopleSoft
(OM, GL, AP, AR, and HR).
Used development tool application designer to design and customize the
application product.
Built new business navigator to access the new panels taking care of
operator security. Attached the new panels to the Menus and implemented
security using Security Administrator.
Used data audits for each and every modification made to the system.
Used Process Scheduler to run the reports from the new panel developed.
Converted data from legacy system to PeopleSoft HR as well as
Financials application tables such as Personal Data, Job, Job Code,
Department, Location, Pay earnings and Pay other earns using SQR.
Developed interface programs using SQR for populating benefits tables
with the information provided by the 3rd party vendors to load the list
of eligible participants.
Also developed interface programs from PeopleSoft system to 3rd party
vendors such as employee medical options, dependent information,
payroll deductions, and coverage status.
Modified report that displays leave accrual information by leaves plan
and employee. It includes information such as plan year eligibility
hours, carry over hours earned year-to-date, hours taken year-to-date,
and remaining leave balances.
Imported Base Benefits information that displays all billing account
activity for a specific period of time by employee, posting date,
activity type, plan type, benefit plan, coverage code and billing due.
Development work involved modification and maintenance of existing
database, SQR's, SQC's, and various processes. Maintained various
conversion processes by means of SQR's and Shell Scripts
Customized PeopleSoft delivered hr SQR's such as EEO reports, DDP
interface programs.
Developed several reports using SQR such as Head Count Report,
Anniversary Listing, Mailing Labels, Union Dues, Payroll Recap report
and Accrual Report.
Asian Paints Ltd.,
June '97 to April '99
Asian Paints is the one of the largest paint manufacturer in India and
is a market leader in Asian region, which is having headquarters' in
Baroda, India.
Environment: IBM-3090, DB2, MVS/VSAM, and JCL & VS-COBOL II.
Material Cost Control system is all about manufacturing & costing of
paints. The system had provisions to enter formulations, entering the
actual at every stage of production provisions for batches that undergo
reprocessing. The system gives reports of batches under production,
machines being used, costing etc. Inventory system had different
modules having specific functions. Some of the many functions were
taking into account the material coming into plant, daily receipts,
issues, loans, reports & stock taking modules. Freight system takes
into account the freight charges involved in the raw material/finished
goods transfers. The transfers could be interplant, loans taken etc.