CAREER OBJECTIVE:

To work in an environment that provides continual intellectual challenge and to apply & enhance my expertise in current technology that can help to improve my efficiency and competitiveness of the organization. To constantly challenge myself in technical and functional content of a project to the satisfaction of the client or customer or the stake holders. To support and grow along with the organization in a stable and progressive manner.

PROFESSIONAL SUMMARY:

• Around 6 years of experience in PeopleSoft Design, Development, Upgrade and Implementation of PeopleSoft ERP applications. This includes around 5 years of PeopleSoft FSCM experience in Analysis, Implementation, Production Support, Upgrade and System Administrator activities.
• Extensively worked on RICE ( Reports, Interfaces, Customizations, Enhancements ) and the latest in PeopleSoft Technical areas like AWE (Approval Workflow Engine), Application Packages, Integration Broker in addition to the other technical areas like Peoplecode, Component Interfaces(CI), Interfaces (both SQR and AE), XMLP (XML publisher).
• Experience in performing requirement analysis, project planning from functional requirements, including Technical Fit Gap Analysis, design, development, implementation based on system specifications.
• Good understanding (PeopleSoft test Framework Scripts) Recording, Executing Most of the PeopleSoft Financial PTF Scripts, and a very good experience in Extracting the Test Maintenance Compare Report and Test Maintenance Coverage Report.
• Good understanding of PIA Architecture such as Web Server, Application Server, Process Scheduler Configuration Setups.
• Involved in various stages of life cycle development in multiple projects and gained extensive knowledge in quality management, project management, communication, presentation skills and also experience working with clients and end users.
• Experience in managing teams both Confidential Onsite/Offshore and worked as onsite coordinator.
• Excellent analytical, programming skills and Good communication, inter - personal skills with a positive attitude.
• Expertise Peoplecode, Application Packages, CI(Component Interfaces ), AE (Application Engine ), SQR.
• Experience in PeopleSoft online Development and Customization
• Trained in Peoplesoft Upgrade 9.1 and 9.2 ( Amazon Cloud )
• Expertise in PeopleSoft SQR Development and Customization
• Knowledge in PS Installation and Configuration
• Knowledge in Project Migration, Patch application, Applying tax updates and PeopleSoft Administration

TECHNICAL SKILLS:

ERP: PeopleSoft FSCM 9.2/9.1/9.0/8.9/8.4 /8.0 (Finance), People Tools 8.53/8.52/8.50/8.49/8.48/8.44/8.17 (Application Package, Integration Broker, XMLP, Application Designer, Application Engine, People Code, Component Interface, AWE ( Approval Workflow Engine ), Data Mover, PS-Query)

Reporting Tools: XML Publisher, SQR, Crystal

GUI Tools: Adobe Flex and Visual Basic 6.0

Languages: People Code, Java, SQL and PL/SQL

RDBMS: Oracle 11g/10g/9i/8i, SQL Server

Operating Systems: WINDOWS NT/98/2000/XP, UNIX

FUNCTIONAL SKILLS PeopleSoft FSCM: Supply Chain Management (SCM)- Procure to Pay(P2P) ( EProcurement (Epro), Purchasing (PO), Inventory (INV), Accounts Payable (AP) ), General Ledger (GL), Billing(BI), Account Receivables (AR), Order Management(OM), Contracts (CA), Strategic Sourcing (SS), Travel & Expenses (T&E), Treasury ( Deal, Risk and Cash Management )

PROFESSIONAL EXPERIENCE:

Confidential, San Jose

Techno Functional Consultant

Responsibilities:

• Gathered all the Technical Specifications from the Confidential Instance.
• Designed, Map data for conversion, developed the scripts for conversion, Executed and Verified Converted data (Supply Chain Management & Financial Scripts) in our new Spectralink environment.
• Completely involved in Creating the PTF(PeopleSoft Test FrameWork) Scripts for Users .
• Completely Involved in end to end Development for Cost Copying in Cost Accounting ( which Involved in 3 major processes Outbound and Inbound SQR followed by an AE which invokes a PS JOB for every business unit - which user can copy upto 54 BU’s Confidential a time ).
• Involved in Configuring the Workflows (AWE) for a Custom Confidential Application which requires Business and CIO’s Approaval. (Worked on customized module contract audits to setup workflows, build transactional pages, inquiry pages and reports).
• Completely Involved in end to end Development for Confidential will get Orders from Siebel, Extracted the Bundle Orders and Process it into Staging Tables and find the Chart fields for it and Process it into Billing Line Distribution and Billing Line Deferred Tables based on requirements gathered)
• Involved in writing Unit test plans and system test plans to test our customization in all PeopleSoft Components, tracking and listing down the errors for various financial applications.
• Day to day production support for all the Change Requests that include analyze the data issues in the Order Management and Billing modules.

Confidential, San Jose

Techno Functional Consultant

Responsibilities:

• Gathered all the Technical Specifications from the Confidential Instance. Designed, Map data for conversion, developed the scripts for conversion, Executed and Verified Converted data (Supply Chain Management & Financial Scripts) in our new Spectralink environment.
• Integrated Sibel applications to our PeopleSoft System, transfer ‘service orders’ to Order Management through Integration Broker and our customized batch process Picks the orders and process into our Billing Module. Involved in Integration with our PeopleSoft System to Tax ware System
• Took the lead in writing all the General ledger Scripts for the Data Conversion from Confidential System to Spectralink.
• Involved in writing Unit test plans and system test plans to test our customization in all PeopleSoft Components, tracking and listing down the errors for various financial applications.
• Involved in Gathering Technical Requirements, Design, Plan and Develop detailed SQR reports like ‘Aging’, ‘Repair’, ‘Usage Reports’ for Spectralink Customers AVAYA and Involved in Tuning the SQL’s for better performance in our Customized Application Engine Programs
• Designed, Developed, and Tested a SQR report which monitors all the Long Running Processes and how long it ran which are in Processing, No Success and Error Status. Adding, the same report monitors the Status in Integration Brokers for Developing and Testing Data Archiving and Purging for all the EC (used for EDI), BCT and Integration Broker (IB) Tables ( All the tables from appmsgpurgeall DMS Script )
• Day to day production support for all the Change Requests that include analyze the data issues in the Order Management and Billing modules.
• Provided system testing and UAT support troubleshoot security issues.
• Built Application Engine for preprocessing of GL reports to fetch data from account, department trees and budget attribute tables
• Built Customized outbound, customized inbound interfaces to Accounts Payable, Order Management Modules.
• Involved in Designing, Trouble shoot all the requests (issues) raise by Users and prepare documentation for all the solved Change request.
• Built new Queries and modified existing ones using PS Query for Accounts Receivables.
• Streamlined and tuned performance of some Crystal Reports using indexing and modifying the SQL.

Confidential, Pleasanton

Techno Functional Consultant

Responsibilities:

• Setting up the business units in PeopleSoft Strategic Sourcing.
• Understanding PeopleSoft Strategic Sourcing Implementation (Setting up Bidder group, Standard Comments, Terms and Conditions, Discussion forum and Implementation Order).
• Setting Up Instant Messaging by Using Multichannel Framework (MCF).
• Setting up Setting Up File Attachment Servers, URL Location for Notification.
• Good understanding the Workflows and Roles & Permissions (Security), Users in PeopleSoft Strategic Sourcing.
• Good understanding in Creating and Using Bid Factors setup and Bid Factors Group setup.

Confidential, San Francisco

Techno Functional Consultant

Responsibilities:

• Involved in day-to-day support in the Implementation of PeopleSoft Financials, Procurement Modules
• Involved in conducting the walk through meetings with functional analyst to understand the requirements.
• Good understanding in Sci Quest third party system (procurement) and the flow to PeopleSoft system through Integration Broker (Asynchronous One Way).
• Gathering the requirements for new business processes Reports for the organization and writing the business requirement documents.
• Extensively worked on wiring the queries for the managing director’s reports on adoption (high spend and low spend) which extracts all the high spending departments, dept codes, Amount and funds allocated to them.
• Extensively worked on writing Complex SQL’s in the backend and reducing the cost (Time complexity) for it.
• Involved in writing the Reports for the self-approval, Central buyer approval for export from Sci Quest Integration to PeopleSoft.
• The Project involves designing of requirements,, Interfaces & Reports PSQuery, SQR, Application Engine, File Layout, Component Interface related to Inv, PO, AP, and GL.
• Good understanding in Integration Broker and the connectivity between PeopleSoft system and SCI QUEST third party application, which runs over night and our batch process stage them into our Custom Sci Quest tables .
• Work with users to help understand any issues in production and open tickets for development team and then test after the fix is made.
• Worked with Tree Manager and PeopleSoft Query for analyzing and reporting in Accounts Payable.

Confidential, Redwood City, California

PeopleSoft Developer

Responsibilities:

• Planning, Designing, Developing, Reporting, Testing, Production Support Tickets and Documentation.
• Worked on PeopleSoft Financials Modules Contract, Offerings, Quotes, AP, GL, Supply Chain Modules PO..
• Work with users to help understand any issues in production and open tickets for development team and then test after the fix is made.
• Worked on Power Center Integrations from Workday Tables to PeopleSoft System tables.
• Responsible for running the Contract Interfaces, Workday Integrations, Power Center Jobs which holds PeopleSoft data .
• Pretty good experience working with File layouts. Worked on Ipayroll and Ipillar Interfaces which generates a CSV file and used in importing( GL HRNL IMP) into Journal Header and line tables.
• Customized Vendor Load interface (Load staged employees into Vendor tables.)
• Worked on Archiving the Data from JRNL HEADER,JRNL LN, JRNL VAT tables to the 9.1 history tables.
• Developed Many Custom Reports(SQR) for the Egencia and ISonar Agencies .
• Hands on experience in Net New Developments in the PeopleSoft 9.1 Newer Version.
• Good understanding of Requisition sourcing to a PO
• Good understanding in writing the SQR’s for Reporting and for the Process.
• Customized various components and pages using Application Designer and People Code.
• Mapped data and SQLs development for Reports developments.
• Designed customized SQRs and PeopleSoft delivered pages to cater to client-specific requirements.
• Worked on EDI configurations and tested for 850,855,810,856,180, 820 and 822
• Involved in system requirement gathering sessions.
• Hands on Experience in writing the Application Engine’s, SQR’s and in writing SQL’s.
• Hands on Experience in Reports enhancement like Crystal and XMLP reports.
• Met aggressive deadlines for the First patch of the Upgrade 9.1
• Worked on the critical issue - Some vendors sends ASN with PO ID and Line Number on the behalf of the Original Vendors (Bargain Vendor) by creating some Audit Tables and backed up the data instead of deleting the bad file / bad data.
• Hands on experiences in writing reports like crystal reports, XMLP - Worked on Reprinting invoices for the countries Russian, Germany, Great Brittan

Confidential

PeopleSoft Techno Functional Consultant

Responsibilities:

• Providing Technical Solution Design and strategy for various and work with the technical team for Specification and development of Technical Design Document and implementing the same.
• Constantly interacting with the process owners to understand any possible gap between the Business Requirement and Design or Development to mitigate impact on the schedule and cost of the project.
• Reviewing the Design documents from the Technical team to make sure they adhere to the requirements, standards and comply with the requirements.
• Successfully completed the project without deviation from the broad scope in the required timeframe.
• Worked with the Solution Architects and Oracle partners to identify Portal options.
• Maintain, Trouble shoot and fix errors in existing application systems (All Severity Tickets).
• Ensures Projects, Objects affecting the environments are moved through software development life cycle (SDLC)
• Reported to Development and Deployment Managers on the weekly basis on the project progress reports.
• Proposed changes in the Inbound and Outbound File layouts to fit the business need of both the Legacy and PeopleSoft Systems.
• Involved in meetings with all Teams during Solutions, Development and testing phases.
• Performed inbound and outbound interface configuration Parameter settings as per the subsystems specific requirements.
• Worked with Legacy Remediation Team in processing the inbound files and transmit the outbound files.
• Raised defects in the systems and integration testing and coordinated with the Solutions and Development teams for the resolutions.
• Worked with Functional and LR teams in testing adhoc test scenarios with data mock ups.
• Performed post go-live production support and documenting and identifying new changes needed to optimize the systems.
• Handled the change management process for the new requirements and changes proposed.
• Monitored daily production activities and various interface process.
• Day to day support work for AP, AM and GL modules and PeopleSoft batch support .
• New developments and Customization as per client requirement to fix existing issues.
• Help Users in Functional testing and replication of issues.
• Handling and creating Technical Design Documents.
• Creating New Pages and other development in Accounts Payable module for upcoming go Lives.
• Creating reports through SQR & Crystal for various modules as per client’s requirements.
• Testing, debugging and fixing Batch Issues.
• Managing Batch Windows /Tivoli
• Managing Web Services and Third party Integrations with TIMS and other interfaces.
• Involving Oracle for all Delivered Bugs /Issues.

Confidential

PeopleSoft RICE Developer

Responsibilities:

• Understanding Requirements from the business Recruiters, Hiring Managers so as to enhance the Recruiting Solutions to make it completely electronic from application through Offer and hire even for all applicants.
• Developed one of the most challenging requirements from the Business to create a new customized and developed fields, pages, record definition and People Code for the E-procurement, purchase order and Account Payable modules
• Involved in user-documentation of the created processes.
• Involved in adding permission lists to the roles in order to further restrict access to the users and administrators
• Designed and developed Conversion program using application engine and component interface to convert Credit card information in Legacy system in to the Custom application in Expenses.
• Involved in setting of Payment Notifications for Expenses.
• Customized XML publisher reports to cater to the additional Pfizer specific fields.

Environment: PeopleSoft Financial/SCM V9.0 (E-pro, PO, BI, AP, GL) People Tools 8.48/8.49, People Code, SQR, Application Engine, Application Messaging (Integration Broker), Process Scheduler, Workflow, Administration and Oracle.

Confidential, Maryland

PeopleSoft Technical Consultant

Responsibilities:

• Involved in Design, Development and Testing phases of implementing PeopleSoft FSCM 8.9 on various modules. Participated in fit-gap analysis.
• Developed a Application Engine which sends EDI 503(customized) outbound files to our preferred vendors.
• Developed a SQR interfaces (Inbound) to Peoplesoft FSCM 8.9 from three of our preferred vendor.
• Familiar with application packaging people code used in Approval workflow engine (AWE).
• Raised defects in the systems and integration testing and coordinated with the Solutions and Development teams for the resolutions.
• Performed post go-live production support and documenting and identifying new changes needed to optimize the systems.
• Monitored daily production activities and various interface process.
• Day to day support work for Epro, PO, AP and GL modules.
• Day to Day PeopleSoft batch support.
• New developments and Customization as per client requirement to fix existing issues. f requirements through client calls

Environment: PeopleSoft Financial/SCM V8.9 (E-pro, PO, BI, AP, GL) People Tools 8.48, People Code, SQR, Application Engine, Application Messaging (Integration Broker), Process Scheduler, Workflow, Administration and Oracle