EXPERIENCE SUMMARY:

• Over 14 years of experience in IT industry with around 8 years of solid expertise with PeopleSoft implementations.
• Functional experience in PeopleSoft Billing, Accounts Receivables, Accounts Payables, General ledger, Project Costing, Contracts and SCM Modules.
• Experience in Batch Processing, Upgrade, Migration and Interfaces Development.
• Experience in Design, Development, Coding, Testing, Bug Fixing and Applying the Patches.
• Extensive experience in reporting using various reporting tools such as SQRs, Crystal Reports and PS/nVision.
• Extensive experience in testing the applications at various stages.
• Extensive experience in Integration and Integration tools.
• Training experience and end user training experience.
• Acquired in - depth knowledge of PeopleSoft modules working on production support.
• Highly developed analytical and organizational skills with the ability to multi-task and prioritize responsibilities in a dynamic work environment
• Gathering requirements and worked closely with the business team to define requirements and process flow.
• Developing business requirements and functional designs into a technical design documents.
• Providing a subject matter expertise for the team on such topics as process flows, data models, content requirements, integration with the other functional areas (e.g. conversion, interfaces and reporting), processing procedures, and application on business objectives, client-specific topics, and alternatives for service delivery.
• Providing consistent delivery of PeopleSoft solutions throughout the product suite by following design, development standards and architecture standards.

TECHNICAL ENVIRONMENT:

ERP App. Packages: PeopleSoft: 7.5/8.0/8.4/8.8/8.9/9.0/9.1/9.2 FSCM

ERP PeopleTools: PeopleTools 8.1x, 8.2x, 8.4x, 8.52 (Application Designer, SQR, XML Publisher, BI-Publisher, Application Engine, People Code, Process Scheduler, Data Mover, Crystal Reports, Security Admin, Tree Manager, Workflow, Data Archive Manager, PS Query, Query Manager, Application Messaging, nVision, Component Interface, Fluid)

RDBMS: DB2, Oracle 11/10g/ 9i/8i/7, SQL Server 2008, MS-Access

Operating Systems: Windows, NT, UNIX, MS-DOS

Languages: SQL, COBOL, PL/SQL

Application Modules: Financials/SCM (AR, BI, INV, PO, OM, AP, PC, GL, CM, AM, T&E, eProcurement, CA, GM and Commitment Control)

Reporting Tools: SQR, XML-Publisher, BI-Publisher, nVision, Crystal Reports, PS-Query

Advanced Tools: Integration Broker, Workflow, Approval Workflow Engine (AWE), XML Publisher

PROFESSIONAL EXPERIENCE:

Confidential, TX

PeopleSoft Lead Consultant

Responsibilities:

• Worked on Gathering Requirements, Design Business Processes and Technical Specifications for Data Conversion, Interfaces and bolt on applications.
• Designed and developed several custom interfaces to integrate data to and from the Confidential System with Third Party Time entry systems Modules.
• Developed several custom interfaces using Web Services. Involved in configuring the Integration Gateway and developing custom messages as per the Business requirement.
• Designed and developed custom bolt on File Transfer Utility module to enhance the control of transfer of files between the FIM system and various other applications.
• Designed and developed custom interfaces to synchronize Chart field Meta data between Confidential and EFH Systems.
• Extensively worked with the DBA to help tune Several Long running Batch Jobs to reduce the total runtime.
• Setup new fluid homepages with new tiles as per the business requirement to accommodate custom fluid applications.
• Converted existing Custom Application to fluid as part of Mobile initiative.
• Developed custom CSS Style sheets to make the fluid page responsive on different form factors.
• Enhanced existing SQRs to print invoices, purchase orders, price confirmations and request for quotes. Receiving Vendor, Item, Receipt Date and Receiving Log by Date, Item reports
• Converted Custom Crystal report to BI Publisher as per requirement.
• Performed matching validation between receipts, purchase orders, and invoices.
• Used Maintain Security for giving access to the menus for different Users for different Menu Items.
• Used Process Scheduler for running different Processes (single/multiple), Reports and also scheduling these Processes at different times either on Client or Server.
• Involved in modifying the reports like Invoice Register, Voucher Register, confirmation register, deal approval register, settlement instructions Developed several Custom billing invoice forms based on the Clint requirements.
• Worked Extensively with the Offshore team to coordinate tasks and provide assistance as required
• Coordinated with the other development teams to keep track of various objects to be migrated to FSUAT, FSTST, and Production environments using STAT.

Environment: PeopleSoft FSCM 9.2 (CA,PC,AR,BI,LA), People Tools 8.55, PS/n Vision, SQR, Crystal Reports 8.5, UNIX, Windows NT, Web Logic 5.1.0,Oracle 11i

Confidential, TX

PeopleSoft Lead Consultant

Responsibilities:

• Worked on Gathering Requirements, Design Business Processes and Technical Specifications for Data Conversion, Interfaces and bolt on applications.
• Worked as the Lead resource in design and development of the Custom Labor Allocations Module.
• Designed and developed several custom interfaces to integrate data to and from the Custom Labor Allocations module with people soft Time and Labor and Project Costing Modules.
• Extensively used and developed data conversion programs and scripts using, SQR’s, Application Engines, People soft Excel to CI utilities for data conversion from Legacy system to people soft 9.1 FSCM system. Developed custom data mover scripts to facilitate setup data migration between different people soft environments.
• Customized the ACTUAL TIME ADD and the ACTUAL TIME BATCH ADD application messages to stage the actual time from people soft HR to the custom LA module.
• Designed and developed a custom interfaces to load Employee Direct Labor cost from the Labor Allocation Module to Projects and GL based on the Employee Labor Allocations.
• Worked on Inter Unit Processing Setup, Designed and developed the custom GL interface to utilize the delivered Inter unit Processor.
• Worked with the business Analyst to configure the AWE workflow engine for the custom LA module.
• Generated Various Reports through XML Publisher by using different Custom Report Templates based on the Clint Requirements.
• Worked on Production Support issues after post go live, coordinated with the offshore resources and the Clint business users. Created design specifications for post go live customizations based on the Clint requirements.
• Worked extensively to improve the system performance, tuned several major interfaces and programs worked on the PC PRICING, PC TL TO PC.
• Developed several Custom billing invoice forms based on the Clint requirements.
• Coordinated with the other development teams to keep track of various objects to be migrated to FSUAT, FSTST, and Production environments using STAT.

Environment: PeopleSoft FSCM 9.1 (CA,PC,AR,BI,LA), People Tools 8.5, PS/n Vision, SQR, Crystal Reports 8.5, UNIX, Windows NT, Web Logic 5.1.0,Oracle 11i

Confidential

PeopleSoft Lead Consultant

Responsibilities:

• Worked on Gathering Requirements, Design Business Processes and Technical Specifications for Data Conversion, Interfaces and bolt on applications.
• Worked along with the business resource and functional analyst to map the legacy data to the core people soft projects and contract tables.
• Extensively used and developed data conversion programs and scripts using, SQR’s, Application Engines, People soft Excel to CI utilities for data conversion from Legacy system to people soft CNB system. Developed custom data mover scripts to facilitate setup data migration between different people soft environments.
• Designed and developed a custom Interface to load inbound resource time data from third party systems into the CNB projects costing tables. The process edits the inbound data for validity and stages the data into the INTFC PROJ RES staging table.
• Designed and developed a custom interface to load Employee Direct Labor cost from HR. The process interfaces employee labor rates from HR and re-prices the effected resource transactions to calculate profitability at the project level.
• Designed and developed the Labor summary by Employee and Contract Summary by Employee reports. Created several Queries on the people soft core tables based on user requests.
• Responsible for the design and worked along with the development team on the custom OLT program which process the OLT rows prior to the Pricing Engine to improve the overall performance of PC PRICING.
• Generated Various Reports through XML Publisher by using different Custom Report Templates based on the Clint Requirements.
• Developed several Custom billing invoice forms based on the Clint requirements.
• Coordinated with the other development teams to keep track of various objects to be migrated to IST, UAT, and Production environments using STAT.

Environment: PeopleSoft FSCM 9.1 (CA,PC,AR,BI), People Tools 8.5, PS/nVison, SQR, Crystal Reports 8.5, UNIX, Windows NT, Web Logic 5.1.0,SQL Server 2008

Confidential, OR

PeopleSoft Techno/Functional Consultant

Responsibilities:

• Worked on enhancements and InterfacesExtensively worked on AR AGING Program to Customize the Days of the Age Bucket and also the AR FOLLOW UP program.
• Customized AR Payment Predictor Process (AR PREDICT2) by Creating New Algorithm Group to handle specific Payment situations like Partial Payments by Customer, which is not supported by PeopleSoft System
• Worked extensively in Setting-Up FTP, Flat File Import and Customized accordingly the Budget Import Application Engine Process KK JRNL IMP in General Ledger
• Worked on the fixing the problem for the Integration Broker that is setup for Syncing the Payroll Data between PeopleSoft HR and PeopleSoft General Ledger Module
• Developed a custom SQR program to load Billing Data from External Application System into PeopleSoft Billing Interface Tables.
• Worked on Integration Broker to create XML files to integrate data between PeopleSoft Modules and Third Party Systems
• Customized the Delivered SQR Interface program to generate GL Accounting Entries (BILDGL01) and generate the Summary Report for each Invoice in Billing Module
• Responsible for developing Templates for Requisition Goods and Services in Purchasing, Journal entries in General Ledger, Customer Details in Accounts Receivables Modules
• Customized GL JRNL IMP (Flat File Journal Import), GL EXCL JRNL (Spreadsheet Journal Import) Application Engine Process to default the Chart-Field values according to the User requirements.
• Worked on Issues of AR DUNNING Program, extensively worked with PS AR33000 TMP Table where the Program Extracts all the Data of the Customer.
• Customized the Custom Program added a new Chart-Field and Rewrote the Interface between the Project Costing Module and the Asset Management Module
• Designed and Developed SQR Interfaces to transmit external EFT Bank Transactions and Pass Journals from Legacy System into PeopleSoft GL Module
• Worked extensively in troubleshooting Billing Interface Application Engine Process (BIIF0001) and extensively used SQL to analyze the Interface Staging Tables to correct the Errors.
• Validated the process designs, developed the business requirements and used both functional and use cases while developing interfaces and doing the data conversion.
• Conducted the User Acceptance testing and has given guidance to the users.

Environment: PeopleSoft FSCM8.4/9.0 (BI/AR/AP/GL/CA/PC), PeopleTools 8.49, PeopleCode, Workflow, Application Engine, Application Designer, Component Interface, File Layout, Integration Broker, SQR, Security, SQL, nVision, Crystal Report, Oracle10g

Confidential, GA

PeopleSoft Techno/Functional Consultant

Responsibilities:

• Worked as a Functional Analyst for and Billing Account Receivables and Accounts Payable modules for Project Interfaces & Integration Team.
• I am responsible for the following tasks: deriving testable requirements from functional requirements specifications documentation; design system, provide interpretive analyses, prepare flowcharts and associates diagrams/enhancement plans; preparing system and integration test plans, conducts tests and confirms and documents results
• Creating test scenarios, test scripts to verify testable requirements. I am also responsible for performing users’ workshop, instructing, directing and monitoring the work of assigned functional personnel.
• I was responsible for assisting the technical team with data mapping for AP Interface from Legacy system.
• I designed, tested and documented the Automatic Bank Reconciliation process for both Bank of America and Wachovia Bank. I also setup, tested and documented the Positive Payment file process.
• Collaborate with development team to create functional designs and technical designs; identify issues during design reviews.
• Responsible for setting up Accounting for Projects, also known as the “Services Accounting Model”, which translates rate-based transactions into accounting entries based on an established set of Accounting Rules.
• Responsible for updating the accounting distributions for year end department changes
• Designed custom SQR’s to update the department and the corresponding accounting information for the effected projects at the voucher Line level.
• Designed custom SQR’s to sync up the customer department changes between the One View (custom CRM system) and the projects module.
• Was responsible for setting up contracts, milestones in contracts and security, configured the Billing module to interact with Projects and Contracts.
• Configured the Billing module along with the client and worked on Invoice formatting according to the client’s specification.
• Explained the process of billing and its functionalities, worked on setting up the values and schedules for Recurring and Installment billing.
• Worked on setting up the rate based pricing for contracts and also setting up the revenue recognization plans for contracts.
• Setting up Billing Plans and processing contracts line bills set for billing, amending contracts and setting up the same.
• Worked on the production support team and was responsible for solving day to day production issues on the projects, contracts, billing and Accounts receivables modules
• Developed configuration documents for all the three modules Projects, Contracts and Billing.
• Developing and maintaining the Invoice Audit Tables (Work flow Audit and the Invoice Header Audit Tables).
• Responsible for designing and developing the custom Reports.
• Extensively worked on procure-to-pay and order-to-cash process and assisted Business Analysts in identifying process issues and replication procedures.
• Worked with PeopleSoft Tree Manager to define the roll-up structure of chart field values that will help PS/nVision to define the structure and scope of financial reports.
• Designed and developed numerous Nvision report layouts, report requests and scope definitions as per the business needs of the client. Developed most of the financial analysis and consolidation reports and departmental utilization reports.
• Developed daily, month to date, year to date and inception to date Profit and Loss Statement and Balance Sheet reports for Operations.

Environment: Financials/SCM 9.0/8.4.10.000 , People Tools 8.4.04, PS/nVison, SQR, Crystal Reports 8.5, PVCS, UNIX, Windows NT, Web Logic 5.1.0

Confidential, CO

PeopleSoft Techno/Functional Consultant

Responsibilities:

• Lead Developer in gathering requirements, designing, and development of interfaces between the 8.4 FDM system and the 9.0 FSCM system.
• Team lead responsible for managing technical resources for the design and the internal conversion of the Customer, Contacts and Product data in the 8.4 FDM system. Developed custom process to transfer the data to the 9.0 FSCM systems.
• Involved in the design and developed a custom program to convert all the Open Contract to the 9.0 FSCM system.
• Involved in creating New Accounting Rules, New Distribution Types, Distribution Codes and Distribution sets and facilitated in processing the accounting entries in 9.0 FSCM system so as to reflect the 8.4 FDM system
• Responsible for Setup/Mapping Order Groups, Product Groups, Division, Price Sets and Customers as appropriate to support the integration between the 8.4 FDM system and 9.0 FSCM systems.
• Customized the delivered Third party Inventory Message (RMA LOAD). To load the data into the Customer Return Component .
• Involved in mapping the XML message structure for all interfaces between the 9.0 FSCM systems and the 8.4 FDM system.
• Performed performance tuning for various order management pages.
• Developed the test cases, test plans, and documented the results after the Unit testing of all the processes.

Environment: Financials/SCM 9.0/8.4,People Tools 8.4.11, PS/nVison, SQR, Crystal Reports 8.5, PVCS, UNIX, Windows NT, Web Logic 5.1.0

Confidential, Fl

PeopleSoft Functional Consultant

Responsibilities:

• As the Functional Analyst for PeopleSoft 8.8 Revenue Management, Accounts Payable and General Ledger modules for Project Interfaces & Integration Team.
• I am responsible for the following tasks: deriving testable requirements from functional requirements specifications documentation; design system, provide interpretive analyses, prepare flowcharts and associates diagrams/enhancement plans; preparing system and integration test plans, conducts tests and confirms and documents results
• Responsible for updating the accounting distributions for year end department changes
• Designed custom SQR’s to update the department and the corresponding accounting information for the effected projects at the voucher Line level.
• Designed custom SQR’s to sync up the customer department changes between the One View (custom CRM system) and the projects module.
• Was responsible for setting up contracts, milestones in contracts and security, configured the Billing module to interact with Projects and Contracts.
• Configured the Billing module along with the client and worked on Invoice formatting according to the client’s specification.
• Explained the process of billing and its functionalities, worked on setting up the values and schedules for Recurring and Installment billing.
• Worked on setting up the rate based pricing for contracts and also setting up the revenue recognization plans for contracts.
• Setting up Billing Plans and processing contracts line bills set for billing, amending contracts and setting up the same.
• Worked on the production support team and was responsible for solving day to day production issues on the projects, contracts, billing and Accounts receivables modules
• Developed configuration documents for all the three modules Projects, Contracts and Billing.
• Developing and maintaining the Invoice Audit Tables (Work flow Audit and the Invoice Header Audit Tables).
• Responsible for designing and developing the custom Reports.

Environment: Financials/SCM 8.8/8.4.03.000 , People Tools 8.4.04, PS/nVison, SQR, Crystal Reports 8.5, PVCS, UNIX, Windows NT, Web Logic 5.1.0