SUMMARY:

• Having 10.5 years of experience in PeopleSoft FSCM as a Technical and Techno - Functional Consultant.
• Having experience in PeopleSoft FSCM I mplementation, upgrade, production support and maintenance of application including analysis, design, development, testing, customization and documentation.
• Hands on experience in FSCM/Finance modules such as Accounts Payables, Accounts Receivables, General Ledger, Asset Management, Billing, Time and Expenses, e-Procurement, and Purchasing.
• Expertise in people tools like Application Designer, Application Engine, Component Interfaces, PeopleCode, File layout, Excel to CI Utility, Spreadsheet upload, Integration Broker, SQR, Crystal Reports, n-Vision, XML publisher (BI Publisher), PS Query, Security, Data Mover, Process Scheduler, Workflow (AWE), PeopleSoft Test Framework and Data Migration Workbench.
• Experience in coordinating and scheduling the meetings with Business, Risk Architecture, testing and development teams where and when required to manage and track the priorities and making sure the team meets the deadlines in specified time.
• Strong SQL skills and SQL Tuning, scheduling jobs through Control-M Scheduler.
• Good hands on with PSADMIN activities like compare reports, project migrations and App & Web Server maintenance, debugging and the performance tuning skills.
• Proficient in using Process scheduler for running reports & processes and monitoring them using Process Monitor.
• Experience in interacting with users to analyze and create design documents for the implementation of new functionalities and Change Enhancement Requests as per business requirements.
• HP Quality Center, Cisco VPN, Citrix, Putty, WinSCP, WebEx, Tidal, PHIRE.
• Extensively involved in FIT/GAP Analysis and preparation of Test Cases and Test Scripts and planning and execution of test cases resulting in test reports.
• Worked on Design Process flows and technical solution documents.
• Ability to implement the business requirements as functionalities in the software product.
• Strong Interpersonal and Communication skills.

TECHNICAL SKILLS:

Application Development Tools: App Designer, People code, Application Engine, Component Interface, PS Query, SQR, Crystal Report, nVision and BIPublisher reports.

Application Package: PeopleSoft FSCM, HCM & CRM

Databases / DB Tools: Oracle, SQL Server and DB2

Network Software / Communications: WinSCP

Operating Systems: Unix and Windows

Programming Languages: C, People code, Core Java

Testing Tools: Manual Testing, PTF

Enterprise Manager Tools: Control-M (Version 6.4.01.200 ), PHIRE

Utilities / Command Languages: HTML, XML

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Senior PeopleSoft Techno-Functional Consultant

Responsibilities:

• Understand business requirements and functional specifications and translate to technical solutions.
• Resolved day to day issues and implemented solution for various change requests as a part of support activities.
• Wrote technical specifications for SQR’s and interfaces in PeopleSoft Application engine.
• Exported matched invoices to A/P system and created custom categories for tracking invoice data
• Performed a Security Clean-up of all the Production and Development Databases
• Involved in the design, coding, and unit testing for all customization carried out as per the business rules.
• Involved in requirement analysis & design for change request.
• Interacting with business and IT users to obtain the system details and to prepare the requirement specification document and for some critical CR’s develop approach document.
• Deliver technical expertise by troubleshooting and resolving technical issues, writing and modifying code, creating reports and queries, developing new applications, scheduling batch processes, and assisting end users.
• Worked extensively on Consolidated and non-consolidated Invoice reports using BI Publisher(XML)
• Tested modifications to ensure they meet customer’s specifications. Provided on-call support to the end-user.
• Worked extensively on Application Designer, People Code, Application Engine, Component Interface, File Layout, Data Mover, SQR, Integration Broker, Workflow, PS Query, Security, Process Scheduler, Spread sheet Upload, PeopleSoft Test Framework.
• High level Quality review updates to management in Senior Review meetings.
• Designed and developed inbound and outbound interface using App engine.
• Used HIRE TOOL to Schedule the process at a specific time and run recursively on the server periodically.
• Extensively used People Code for customization of pages and validating the data.
• Review of the deliverables i.e. designs, unit test cases and technical documents of other team members.
• Responsible for conducting Quality meetings.

Technology/Tools: PeopleSoft FSCM 9.0, People Tools8.49, SQL Server.

Confidential, Louisville, KY

Senior Application Developer

Responsibilities:

• Worked as a techno functional consultant in PeopleSoft FSCM Application Upgrade project from version 9.0 to PeopleSoft 9.2 and People Tools version from 8.49 to 8.53
• PeopleSoft HCM Application Upgrade project from version 8.8 to PeopleSoft 9.2 and People Tools version from 8.48 to 8.54
• Gather Requirements from business users related to their business functionality and understand their current system
• Perform Fit Gap Analysis based on the current and new PeopleSoft System for all the modules including GL, AP, eProcurement, and Security in Financials using agile methodology. Review the fit gap documents with business before finalizing
• Prepare High level functional and technical designs based on the fit gap document and provide the design to the business users
• Used Application upgrader to migrate objects from Demo to Target instance.
• Gather the workflow requirements from a business users and prepare a requirement document
• Prepare the high-level design to implement Approval Workflow Framework (AWE) using UML
• Finalize the reporting requirements with users & provide specifications for the same to the technical team.
• Analysis of compare report between 9.1 and 9.2
• Analyse and gather requirements from Security administrator related to current security design and prepare High level design using Agile methodology
• Assist the users in designing the system using PeopleSoft Set Ups for Financials
• Develop enhancements and customizations for FSCM/HCM modules include AWE using People Tools Components, Pages, Records, Menus, Folders and Nodes according to technical specifications.
• Ran System Audit Reports to compare data structures defined in the People Tools tables against the underlying database to uncover inconsistencies.
• Worked in Retrofitting of several customized objects as SQR’s, views, queries, Pages, Components and Application Engines in the process of Upgrade and had documented the changes made in specific templates.
• Provided technical analysis, feasibility study and estimate efforts for the new requirements.
• Responsible for reading compare reports and creating inventory of objects to retrofit.
• Worked closely with functional lead and client during fit gap and provided technical inputs to retire and retain customizations.
• Recognized the mappings of records and fields that had changed, renamed, added and deleted in HCM 9.0 by comparing it with 8.3 vanilla version.
• Retrofitted several SQRs, Crystals, Pages and Components and was accountable to its proper functionality.
• Developed various conversion programs using AE and CI with threads to load the data in JOB and other HR and payroll setup tables like LOCATION TBL, JOBCODE TBL and TAX LOCATION.
• Created numerous conversion programs using Application Engine to load the data in to the custom tables with multi threads.
• Recognized the mappings of records and fields that had changed, renamed, added and deleted in HCM 9.1 by comparing it with 8.9 vanilla versions.
• Provide technical to facilitate the transfer of data from PeopleSoft HCM 8.8 version to PeopleSoft HCM 9.2 version using Component Interface, SQR, Application Engine, and Integration broker, File Layout. Support in design, development, testing, and deployment of HR applications issues.
• Developed a dashboard to show employee’s job and demographic data.
• Created inbound and outbound interfaces to load and export the data to other systems.
• Worked on PeopleSoft Security by creating and testing user roles and permission list.
• Provide production support for HR applications.
• Analyze and resolve problem tickets in a timely manner.
• Resolve all issues related Time admin process on a day-to-day basis.
• 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.
• Migrate developed code from development to testing environments and provide assistance to the users in User Acceptance Testing.
• Convert Crystals to BI Publisher and develop new BI Publisher reports.

Technology/Tools: PeopleSoft CRM 8.9/9.2, PeopleSoft FSCM 9.0/9.2,PeopleSoft HCM 8.8/9.2People Tools 8.49/8.53, DB2 9.7, ORACLE 11g

Confidential, New York

Senior PeopleSoft FSCM Application Developer

Responsibilities:

• Responsible for HR, Benefits, NA Payroll, MSS, ESS - Re-Implementation and Production Support as a Senior PeopleSoft Lead Consultant
• Work with the users to understand their business requirements and support day-to-day activities for the PeopleSoft System re-implemented by the client.
• Involved in writing Technical Specification documents to facilitate writing codes as per requirement.
• Lead the Data Conversion team to implement the conversion project by co-ordination with all the stakeholders as and when required.
• Involved in daily status calls regarding the progress of the conversion programs and discuss any issues raised and get clarified by immediate follow up, then and there if necessary.
• Extensive experience in Implementing interfaces, batch programs, data conversion reports.
• Responsible for developing Interfaces for AR, Billing and Vendors from PeopleSoft
• Involved in the functional design gathering for new enhancements.
• Created BI Publisher Reports for Monthly, Quarterly & Yearly using PS Query.
• Worked on testing the Integration Broker that sends file to third Party Vendor.
• Learned the functional concepts of Recruiting and created job openings hosted in online for job seekers.
• Involved in debugging the complex Application package codes and resolved most of the issues.
• Development and Unit test plan creation.
• Interacted and provided my expertise with peers on their issues whenever required.
• Involved in design and development of GL interfaces from 3rd party system to PeopleSoft
• Supported Cash Management and Purchasing & Accounts payable issues
• Developed Interface to create Purchase Orders with in PeopleSoft from the user requirement
• Developed an application engine program in General Ledger to load flat file accounting entries from FTP folders into journal staging tables.

Technology/Tools: PeopleSoft FSCM 9.1, People Tools 8.52, ORACLE11g.

Confidential

PeopleSoft FSCM Technical Consultant

Responsibilities:

• This engagement is a Level 2 support.
• Monitor the Scout PeopleSoft daily, weekly and monthly processes, applying fix for process failures.
• Developed ad-hoc queries based on data request from business users.
• Fix Scout live issue (In/Out bound Interface Process failure, Customer data issue).
• Worked on Scout data migration tasks.
• Create/update Scout PeopleSoft codes.
• Apply new enhancements or changes to Scout PeopleSoft CRM application using Change Assistant.
• Performed PeopleSoft admin activities (Application and Web server maintenance, PeopleSoft application maintenance).

Technology/Tools: People Soft 8.9 People Tool 8.48 Oracle 10g, TOAD.

Confidential

Oracle Consulting, Application Developer

Responsibilities:

• As a PeopleSoft Application Developer involved in Analysis, Coding, Testing of PeopleSoft FSCM Applications.
• Applied HCM bundle 3 and 4 for Confidential client.
• Applied HCM bundle 3, 4, 5 and 6 for Lonestar client and UAT is in progress.
• Customized BI interface spreadsheet to include the table BI LINE DST DFR.
• Fixed the Buyer Setup issues for Confidential and Involved in with-holding report control information and Vendor 1099 Withholding setup.
• Involved in Ticket analysis, solving crucial tickets and production support issues.
• Involved in Ticket resolving & Root cause analysis.
• Developed Queries using Query Manager depending on the Functional and Business analyst’s requirements.
• Took up the role of Primary on Call, dealing with Production issue failures (Batch Process failures, rollback errors, script Failures, etc. and its resolution.
• Developed custom AE program in GL to load journals from external interfaces into JRNL HEADER and JRNL LN tables. Created validation and Load reports
• Involved in designing the Interfaces, Reports and customization of the reports for the AR, AP, and GL Modules

Technology/Tools: People Soft 9.1/9.0, People Tool 8.48/8.50, Oracle10g.

Confidential

PeopleSoft Application Developer

Responsibilities:

• Involved in the System study and creating High level Technical Design Document and Detail technical design document based on the Functional design document and getting approval from the client.
• Creating test cases for unit testing and System test and regression testing.
• Responsible for interacting with the customers for clarifications and share the information with the responsible person.
• Developed Queries using Query Manager depending on the Functional and Business analyst’s requirements.
• Responsible for all the reviews and involved in the walk-through to get understand by client and get the sign-off.
• As per the migration checklist migrate the object to another Environment.
• Providing the pre-production support for the Phase-1email addresses from common library scripts.

Technology/Tools: People Soft 9.1, People Tool 8.5, Oracle 10g.

Confidential

PeopleSoft Application Support Engineer

Responsibilities:

• As a PeopleSoft Application Support Engineer, involved in system study and Impact analysis based on the maintenance Requirement document.
• Creating High-level Technical Design Document and Detail technical design document and getting approval from the client.
• Creating test cases for unit testing and System test and regression testing.
• Responsible for interacting with AXA users from Australia and Regional users for all the day-to-day problems along with the batches in Regional Accounts Payable and Regional General Ledger internal modules.
• Providing the Level-1 and Level-2 Support
• Involved in a Triage as part of production support, assign the tickets and provide the support to the team.
• Involved in Ticket analysis, solving crucial tickets and production support issues.
• Involved in Ticket resolving & Root cause analysis.
• Developed SQR, Crystal reports and Queries using Query Manager depending on the Functional and Business analyst’s requirements.
• Took up the role of Primary on Call, dealing with Production issue failures (Batch Process failures, rollback errors, script Failures, etc. and its resolution.
• Involved in creating the checklist Document which reflects the day to day status of the Control-M jobs (Night batch jobs)
• Performed Unit Testing on Various modules and prepared suitable test cases.
• Developed Crystal reports depending on the Functional and business analyst’s requirements.
• Coding/Designing/Testing as per change request.

Technology/Tools: People Soft 8.4 SP2, People Tool 8.45, Oracle9.2, TOAD.

Confidential, St. Louis, MO

PeopleSoft Application Developer

Responsibilities:

• Having the walk through with the client for document specifications.
• Developed fields, records, pages, components and menu definition objects related to this project based on the Technical design document.
• Prepare the Detail technical design document and walk-through with client.
• Creating test cases for unit testing and System test and regression testing.
• Involved into Development of online screens and inquiry screens.
• Move all the objects from One Environment to another Environment.
• Developed the reports Using PS Query and Crystal reports.
• Carrying out page design, Interfaces, Data migrations, Coding and testing of Application Engine, Reports. Importing data into PeopleSoft systems from Flat files using File Layout and App. Engine.

Technology/Tools: People Soft 9.0, People Tool 8.5, Oracle9i.