Manoj techno functional by XM46j3gN

VIEWS: 45 PAGES: 6

									MANOJ K                                                                                kumar.m454@gmail.com
Sr. Techno Functional Consultant                                                             Ph: (618) 303 5318

Summary:

     Over 8 years experience in Information Technology that included gathering user requirements, Systems
      Analysis, Design, Development, Implementation, Upgrade, Testing and Production Support of various Client
      Server and ERP applications.
     8 years experience in wide range of PeopleSoft Financials/SCM modules including Accounts Payable,
      Accounts Receivable, Expense, Billing, General Ledger, Inventory, Project Costing & Procure to Pay.
     Strong PeopleSoft technical skills include PeopleTools (Application Designer, PeopleCode, Application
      Engine, Component Interface, Process Scheduler, Query, Data Mover, Security Administrator and
      Definition Security), SQR (Inbound and Outbound Interfaces), and Crystal Reports.
     Participated in all phases of ERP life cycle like Implementation, Customization, Development, Production
      Support and Upgrade. Applied PeopleSoft Patches, Bundles.
     Performed extensive debugging and performance tuning of various processes. Well versed in utilizing tools
      and utilities PC Debugger, Application Engine trace for troubleshooting.
     Strong database skills include data modeling, database design, Oracle server-side programming in PL/SQL and
      Oracle database administration.
     Knowledge on app server configuration, PIA, Process Scheduler, web server.
     Excellent troubleshooting and problem-solving skills.
     Team player with excellent interpersonal communication skills and technical documentation skills.

Technical Skills
        PeopleSoft Financials (9.1, 9.0, 8.9, 8.8, 8.4, 8.x 7.x)
        Application Designer         People Tools                     PeopleCode
        Application Engine           File Layout                      Component Interface
        Security Administrator       Object Security                  XML Publisher
        Tree Manager                 Process Scheduler                SQR
        PS Query                     Crystal Reports                  Production Support
        Performance Tuning           Integration Broker               BPEL
        Workflow                     PL/SQL                           AWE
        LDAP/OID                     Data Mover
        nVision

Operating Systems
        Windows 2000, NT                   UNIX

Databases
        Oracle 11g/10g/9i/8/7.x            MS SQL Server            DB/2

Applications
        General Ledger                     Accounts Payable         Accounts Receivable
        Purchasing                         Billing                  Inventory
        Asset Management                   Project Costing          Expenses
        Order Management

Education
Bachelors, OU, Hyderabad, India

Professional Experience:

Client: United Nations Development Programme, New York                                      Feb, 2011 – Present
Role: Sr. Techno Functional Consultant
Project: Development & Production Support of PeopleSoft Financials/SCM (e-procurement, AP, PO, AR,GL,
Inventory) v9.0/9.1

Responsibilities:

Page 1 of 6
MANOJ K                                                                                 kumar.m454@gmail.com
Sr. Techno Functional Consultant                                                             Ph: (618) 303 5318
       Designed and configured the workflow/AWE for Requisitions, PO and Vouchers for multiple organizations.
       Resolved issues based on e-procurement catalogue tree, Receipt Accruals, Account Payables, General Ledger
        and Asset management accounting templates & depreciation.
       Designed a custom catalogue page for e-procurement using tree manager to route the Requisition approvals
        using the catalogue page based on department level for different GL Business Units.
       Worked on Procure to Pay modules using App.Engiene, tree manager, CI, Application Package for complex
        issues.
       Generated various reports such as PO Category Expenditure, GL Expenes by COA, ChangeOrder PO’s, Pre-
        Payement’s, Prepaid Voucher Accounting entries, Receipts with AM information etc. using SQR,XML
        publisher.
       Migration is performed from one environment to other using Team Track tool to track the various RFC’s .
       Uploaded Items and Item categories using Excel to CI interface for various development organizations.
       Developed a Three Stage Workflow process based on amount and department/project level without conflicting
        the Email Approval process for different routing events to multiple process definition Id’s under same business
        unit and customized for Mass Approval process.
       Wrote Inbound & Outbound Interfaces for third-party organization and worked on Integration Broker.
       Worked on Conversion’s and also used Data Mover to Load the data from the legacy System to PeopleSoft.


Environment: PeopleSoft SCM 9.0/9.1, People Tools 8.50/8.51, Workflow/AWE, XML Publisher, SQR,
Application Package, Application Engine, Oracle 11g, Toad 11.0, PL/SQL, UNIX, Data Mover, Query Manager,
Peoplecode, Team Track, SQR, Component Interface, Excel to CI.

Client: NEC Corporation of America, Irving, Texas                                     October, 2010 – Feb,2011
Role: Sr. Techno Functional Consultant
Project: Development & Production Support of PeopleSoft Financials/SCM (GL, AP, PO, Order Management, Billing,
Customer Contracts, Project Costing, Travel & Expenses, Cash Management, Contract Audit and Treasury Control) v8.4
to v9.0/v9.1.

Responsibilities:
    Resolved Issues using Application Engine, SQR, Component Interface, Application Package and PS Query
       Manager for complex issues involved with Supply chain modules.
    Generated reports using XML publisher and Application Engine and triggering the report based on PS query.
    Setup, Configured and Troubleshooted the EIP’s between HRMS v9.1 and Financials v9.1.
    Designed and configured the workflow/AWE for e-pro.
    Resolved issues based on Order Management, Billing, Customer Contracts and Project Costing in a Quick
       environment.
    Designed a custom tree for Purchase Order approval chain based on buyers using tree manager to route the
       Purchase Order (PO) approvals using Approval Framework (AF).
    Designed a custom bolt on approval notification for Project Budget change control to route to budget approver.
       Worked with PeopleSoft Production team to resolve the issues involved in Application Engine, SQR, PS
       Query, Application Package and Component Interface.
    Worked on the Custom Import file loading to load any type of supported file formats into the PeopleSoft tables
       for Inventory Module.
    Wrote custom Messages, Application Engine and Component Interface in PeopleSoft FSCM modules using
       Integration Broker.
    Migration is performed from one environment to other using Phire Architect.
    Involved in PeopleSoft security, process scheduler, URL’s for development and production.

Environment: PeopleSoft FIN/HCM 8.4/9.0/9.1,BPM, People Tools 8.51, Workflow/AWE, XML Publisher,
Application Package, Application Engine, Oracle 11g, Toad 9.7.2.5, PL/SQL, SQR,UNIX, Data Mover, PS Query,
Windows NT 4.0,Peoplecode,Phire Architect, SQR, Component Interface.




Page 2 of 6
MANOJ K                                                                                kumar.m454@gmail.com
Sr. Techno Functional Consultant                                                            Ph: (618) 303 5318


Client: State of New York, Albany, NY                                         May, 2009 – Oct, 2010
Role: Sr. Techno Functional Consultant
Project: Upgrade of PeopleSoft Financials/EPM (GL, AP, PO, Procure to Pay, Travel & Expenses, Cash
Management, Contract Audit and Treasury Control) v8.4 to v9.0/v9.1.

Responsibilities:
    Developed Reports using SQR, PS Query Manager for complex queries using Page, Component, and Menu.
    Generated reports using XML publisher and Application Engine and triggering the report based on PS query.
    Established the connection between PeopleSoft and JAVA based Third-Party systems for bi-directional data
       flow using PeopleSoft Component Interface Framework and PeopleSoft Application Messaging (SOAP-XML).
       Design involved coding SOAP Envelope/XMLDoc messages in peoplecode.
    Created Travel & Expense reports by delivered Expense Workflow process and picked up the Expense reports
       in the Audit pick list/Audit documentation by Audit filters.
    Worked on the PeopleSoft bulkload testing.
    Worked with Peoplesoft reporting& development team to resolve the issues in XML publisher & peoplecode.
    Developed an Application Engine to Update the Expense Bank account and layout such that the Expenses are
       picked up by the pay cycle job when we run the PayCycle Manager.
    Resolved defects/scope changes in Application engine peoplecode .
    Wrote custom Messages, Application Engine and Component Interface in Peoplesoft Inventory modules using
       Integration Broker.
    Worked on the Extracts for different Investment lifecycle for sending daily information to particular
       Agency/Bank from PeopleSoft Deal Management System.
    Developed reports by writing people code behind the Push/generate button such that report is in printable PDF
       format using the XML.
    Involved in PeopleSoft security, process scheduler and portal technology while working in technical
       reporting and support in development.
    Worked on single sign-on control for easy user access such that user logs in once and gains access to all systems
       without being prompted to log in again to multiple systems.

Environment: PeopleSoft FIN/EPM 8.4/9.0/9.1,BPM, People Tools 8.51, Workflow, XML Publisher, Application
Package, Application Engine, Oracle 11g, Toad 9.7.2.5, Sql developer, PL/SQL, SQR, UNIX server, Data Mover,
PS Query, Windows NT 4.0,Peoplecode,STAT,Component Interface.


Client: Citigroup, Tampa, FL                                                      May, 2008 –April, 2009
Role: Sr. Techno Functional Consultant
Project: Upgrade of PeopleSoft Financials/SCM (GL, AP, PO, Expenses and Project Costing) v8.4 to v9.0/v9.1.

Responsibilities:
    Responsible for the Upgrade, Fit gap analysis & customization of tasks related to GL, AP, PO, INV, Expenses,
       Grants, Procure to Pay and Project Costing modules of PeopleSoft Financials/SCM.
    Created and modified the Application Packages to validate and move the applicant data from Product
       configurator to OM module.
    Wrote custom Messages, Application Engine and Component Interface in integrating High Jump and
       PeopleSoft Inventory modules using Integration Broker.
    Worked on EDI810 process to generate a PO and sent it via EDI to Microsoft.
    Prepared Conversion Strategy and used Application Engine, Component Interface, Application Package and
       Data Mover to Load the data from the legacy System to PeopleSoft.
    Involved in Design, development and customization of PeopleSoft delivered PO Approval Workflow process
       to provide multiple levels of approval based on Amounts and Purchase.
    Wrote custom Messages, Application Engine and Component Interface in integrating High Jump and
       PeopleSoft Inventory modules using Integration Broker and also familiar with LDAP integration.
    Created APEX application for managing security groups and users in the LDAP-OID in APEX workspace using
       the Security Packages.
Page 3 of 6
MANOJ K                                                                                kumar.m454@gmail.com
Sr. Techno Functional Consultant                                                            Ph: (618) 303 5318

       Customized the PO Dispatch and Print SQR (POPO005) to print the Ship To comments at the Ship To label,
        which is used for printing the address. This change is made specifically for customized Ship To’s with just
        single Ship To address. Also made changes to accommodate the standard Ship To comments for customized
        single Ship To’s at the Ship To label.
       Developed reconciliation reports to reconcile the data sent to GL from AR, AP, BI, Procure to pay and PO.
       Designed the custom approval process using AWE in expenses module to replace the client’s paper based
        approval process.
       Setup, configure and troubleshoot PeopleSoft Enterprise Integration Points (EIP’s) between FIN v9.0 and
        HRMS v9.0 PeopleSoft systems.
       Developed Component interface for Journal Entry Component for data input data from Third party systems of
        different file formats using file layouts and file objects.
       Worked with ExcelToCI utility to import GL, PO, INV and OM configuration data.
       Designed client specific reports (C-2 form, C-11 form, Provisional report, Board report) using XML Publisher
        and application engine process.
       Worked with PeopleSoft Global Support team to resolve the issues in XML Publisher.

Environment: PeopleSoft FIN/SCM 9.0/9.1,BPM/SOA, People Tools 8.50/8.51, Workflow, XML Publisher,
Integration Broker, Application Package, Application Engine, UPK, BPEL, Clear Quest, Oracle 11g.


Client: ENTERGY, New Orleans, LA                                                    Nov, 2007 – Apr, 2008
Role: Sr. Techno Functional Consultant
Project: Upgrade and Production Support of PeopleSoft FIN/SCM (OM, Procure to Pay, INV, PO and CM) v8.8
to v9.0.

Responsibilities:
    Involved in the PeopleSoft Upgrade Project for OM, INV, CM, BI, PO, AR & GL Modules.
    Involved in fit/gap analysis, analyze customization of online objects after reviewing the compare reports, detail
       design, development, testing. Troubleshoot/debug, performance tuning and Production Support. Developed and
       tuned scripts for data conversion using SQL/SQR, Application Engine and Data Mover.
    Enhanced the core requisition workflow, which includes the approve/deny requisition activity and the
       chartfield/amount approval rule set to meet the requirements of the E&P business segment.
    Developed two stage requisition workflow, Project approval and immediate Supervisor approval based on
       requisition approval limits to meet the requirement of PIPE business segment using virtual approver.
    Designed and developed a three stage Approval for creating requisitions in eProcurement module using AWE
       based on Corp IT approval, Project approval and Supervisor approval until the proper dollar amount approval is
       reached.
    Modified the Picking Plan INS6000.SQR to print the Orders in the sort of Business Unit, Demand Source,
       Source Business Unit, Order Number, Item ID, Storage Area, Storage levels.
    Knowledge of single sign-on which involves property of access control of multiple related, but independent
       software systems
    Developed Payment Interfaces to load bank recon data into PeopleSoft Payables from bank transaction files.

Environment: PeopleSoft FIN/SCM 9.0/8.8, People Tools 8.49, AWE, XML Publisher, Workflow, Oracle10g, SQR


Client: Time Warner Cable, Charlotte, NC                                               Apr, 2006 – Oct, 2007
Role: Sr. Technical Consultant
Project: Implementation and Production Support for various financial / SCM (INV, PO and CM) 8.8.

Responsibilities:
    Involved in the PeopleSoft Implementation Project for OM, Procure to Pay, INV, PO, BI, CM, Product
       Configurator and Manufacturing Modules.
    Conducted Fit/Gap, Pre-Design, Detail Design, Suggested and Implemented approaches on various business
       process of the client.
Page 4 of 6
MANOJ K                                                                                  kumar.m454@gmail.com
Sr. Techno Functional Consultant                                                              Ph: (618) 303 5318
       Involved in development and review of High-level and detailed Technical specification documents based on the
        Functional specification documents.
       Modified the functionality in Order Management to return multiple order lines in order entry page based on the
        product configurator specification.
       Developed an Application Engine program to increase the demand line for an order based on the overrun in
        product configurator.
       Developed an Application Engine program to automate the billing of non-inventory product charges based on
        the shipping of the finished goods.
       Involved in customization of peoplesoft delivered Potential Production Variance Report Workflow process
        to add additional role users.
       Involved in tuning a few SQL’s in Billing Interface process (BIIF0001).
       Troubleshooted the Cost Accounting Transaction (CM_CSTACCTG) Application Engine process, which is
        not creating the accounting lines. Resolved the SF_OP_HIST rows pending calculation error.
       Developed an nVision report for cost of goods sold (COGS) breakdown by cost element.
       Developed an Application Engine program to pass the order notes from the sales order to the PID.
       Worked on Data Conversion team to get data from all the manufacturing units and uploading them into
        Peoplesoft database. Ran SQL scripts to validate the data before entering them into Inventory/OM database.
       Worked on Billing Interface programs both External and from OM Module (OM_BILL and BIIF0001
        Application Engine Programs).
       Modified the peoplesoft delivered production document SQR report (SFS2003).
       Developed an on time shipping report in SQR to track the on time shipping data based on the shipping dates.

Environment : PeopleSoft financial/SCM 8.8 (GL, AP, OM, INV, Procure to Pay, Product Configurator,
Manufacturing, Billing), People Tools 8.46, Oracle 10g, Application Engine, SQR, PeopleCode, Component
Interface, Data Mover, PS Query, Windows NT 4.0

Client: Hitachi Global Storage Technologies, San Jose, CA                             Apr, 2005 – Mar, 2006
Role: Sr. Technical Consultant
Project: Upgrade and Production Support of various PeopleSoft Financial/SCM Applications Version 8.4 to 8.9.

Responsibilities:
    Involved in the PeopleSoft Upgrade Project for AP, AR, Procure to Pay, PC, BI, PO, AM & GL Modules.
       Involved in fit/gap analysis, analyze customization of online objects after reviewing the compare reports, detail
       design, development, testing. Troubleshoot/debug, performance tuning and Production Support. Developed and
       tuned scripts for data conversion using SQL/SQR, Application Engine and Data Mover.
    Developed Payment Interfaces to load bank recon data into PeopleSoft Payables from bank transaction files.
    Mass change process failed with large volume of data, fixed by breaking the data based on capitalization switch
       in AM.
    Developed GL Conversion that loads data from PeopleSoft v8.4 into PeopleSoft v8.9 General Ledger using
       SQR, which includes implementing complex business rules like Combo Rules, subtotals on Business Unit level,
       grand totals, error handling procedures, printing multiple output reports, maintenance report and processed file
       report. Used various SQR functions, Arrays, Tress, Views, Load Lookups & SQC (which handles various
       Invalid Chartfield Combinations).
    Customized payments to have a Magnetic Ink Character Recognition (MICR ID) & customer ID to match
       payments to customers.
    Developed Purchasing Interface using File Layout, Application Engine, and Component Interface, which
       loads data from flat file into staging tables while doing various data validations using AE PeopleCode and
       finally loads into PeopleSoft tables through Component Interface.
    Wrote several SQR Reports for vendor activity information with dynamic SQL and dynamic sort and criteria
       options.
    Created Complex Enquiry page for Payable vouchers, age wise analysis, having flexible criteria selection
       options.
    Modified the functionality in Order Management to disallow change or cancellation on orders if the item on
       the order is on allocation, reservation or confirmed status.

Page 5 of 6
MANOJ K                                                                                 kumar.m454@gmail.com
Sr. Techno Functional Consultant                                                             Ph: (618) 303 5318
       Designed additional tables to hold billing data received in PeopleSoft from the 2 additional source systems and
        enhanced the Staging Process (SQR program) and Billing Interface (BIIF0001) accordingly.

Environment : PeopleSoft Financials 8.4/ 8.9, People Tools 8.48, Oracle 9i, Workflow, Application Engine, SQR,
PeopleCode, Component Interface, PS Query, Crystal Reports, Unix and Windows NT 4.0

Client: North Dakota State University, Fargo, ND                                              Feb, 2004 – Mar, 2005
Role: PeopleSoft Consultant
Project: Implementation and Upgrade PeopleSoft Applications from Version 7.5 to 8.4

Responsibilities:
    Corrected the calc_depr_status for Non-Depreciable Assets by customizing the AMDPCALC process.
    Fixed the issue, transaction ID (TRANS ID) not generating after running the Transaction Loader (AMIF1000)
       monthly process. Resolved by removing the bad data for one intfc_id.
    Developed Component Interface and App Engine programs to convert Vendor information from oracle
       financials to peoplesoft financials.
    Wrote conversion programs to convert the Customers, Items and Products from Oracle Financials into
       peoplesoft Financials 8.4.
    Modified Journal Edit (FS_JEDIT) application engine process to avoid anchor concept. Added new AE
       Sections/Steps/Actions to implement Fund Balancing concept while generating offsets as a part of Journal Edit
       Process.
    Developed a custom inbound interface to load the Bank journals into the custom Journal Generator accounting
       table which are picked by the custom JGEN process.
    Designed and Developed workflow approval rules in AP for voucher matching exceptions.
    Worked in Trouble shooting PO Encumbrances when dealing with PO’s funded by multiple organizations.
       Developed programs using File Layout, Application Engine and PeopleCode extensively for the Import and
       Export of flat files and XML files.
    Involved in Design, development and customization of PeopleSoft delivered PO Approval Workflow process
       to provide multiple levels of approval based on Amounts and Purchase.
    Order Types like Capital, Expense and Inventory, to be used throughout the organization. Created various Route
       Control Types, Route Control Profiles, Roles, and Approver Rule Sets as per University’s business needs.
    Designed, Developed various crystal reports across various modules for specific client requirements.
    Maintained development, test and production database instances for PeopleSoft related issues.

    Environment: PeopleSoft Financials 7.5, 8.4, PeopleTools, PeopleCode, SQR, DB2, Process scheduler, Tree
    Manger, Unix Scripts, Security, Query Manager and UNIX AIX.




Page 6 of 6

								
To top