SUMMARY

• Over 11 years of experience as Developer Technical Lead including 10 years of experience in analysis, design, development, Customization, upgrade and Production support projects
• Expertise in PeopleSoft Financials and SCM experience in GL, AP, AM, PO, and eProcurement modules.
• Expertise in PeopleSoft technical skills such as People Tools Application Designer, People Code, Application Engine, Component Interface, File Layout, Process Scheduler, Workflow, Query, Data Mover and Security Administrator , SQR, nVision and Crystal Reports.
• Participated in all phases of ERP full-life cycle Implementation, Customization, Development, Production Support and Upgrade.
• Expertise with PeopleSoft Financials / HRMS/ Supply Chain, Enterprise Portal Technologies, Performance tuning, Windows UNIX administration.
• Experience in Documentation of Technical Specifications, technical designs and test cases.
• Sound leadership ability, excellent communications skills, versatile in the functional and technical and the ability to function productivity in team environments.
• Provide leadership and technical skills in building delivering system solutions with commitment to customer success.
• Involved in people tools upgrade, application upgrade and database upgrade projects.
• Created reports and interfaces using SQR, PS/Query, Crystal Reports and PS/nVision.
• Experience with Security Administrator to implement security in various levels such as Creating Roles, Permission Lists, User Profiles, Portal Security and Content References.
• Hands on experience in Conversion process - data extraction from legacy systems to PeopleSoft application database tables and Integration of PeopleSoft system with various third-party systems.
• Hands on experience in Security, Process scheduler, Control M and Remedy.
• Utilized tools and utilities PC Debugger, Application Engine trace for troubleshooting.
• Wrote UNIX shell scripts and batch scheduling using Control-M application.
• Excellent troubleshooting, problem-solving skills and good understanding of business procedures.
• Significant PeopleSoft functional implementation experience from project conception through roll-out which includes fit gap analysis, configuring application and setups, creating SOP's, BRD's and UAT Scripts and educating the functional users.
• Implementing of Business Card functionality, establishing Punch-out Vendors in procurement.
• Used delivered functionality in providing alternate solutions for different business problems and avoiding customizations to the maximum.
• Good understanding of PeopleSoft n-tier architecture and technology infrastructure.

SKILLS SUMMARY

• PeopleSoft Applications: Financials, SCM 9.1/9.0/8.8 : GL, AP, AR, PO, INV and HRMS: Base benefits, Payroll.
• PeopleSoft Development Tools: Tools 8.52/8.50/8.49/8.45 : Application Designer, People Code, Component Interface, Integration Broker/ Application Messaging, Application Engine, Workflow, File Layout, Data Mover, Import Manager
• Programming Languages: People Code, SQL, PL/SQL, C, Java
• Data Bases: Oracle 8i/9i/10g, SQL Server 6.5/7.0,2000, MS Access
• Operating Systems: Windows 98/2000/XP. UNIX
• Reporting Tools: SQR, PS-Query, XML Publisher, Crystal Reports PS/nVision
• Integration Tools: Component Interface, File Layout
• Administration Tools: Security, Mass Change, Process Scheduler, Work flow
• GUI Tools: Developer 2000 and Remedy

PROJECT EXPERIENCE

Confidential

Role Technical Lead

Environment PeopleSoft Financials 9.1 AP, AR, GL with Tools 8.51, Oracle 11i, SQL Server, Control-M

Project Description

• Project Lead and distributing the workload and Technical coordination and Validation of deliverables.
• Primarily involved in interacting with Business Users, Identifying the Business requirements and delivering the deliverable in time without scarifying the quality of Work.
• Worked closely with the Development team to get the issues resolved and the defects fixed for the RICE items.
• Worked with the interfacing departments of the Commonwealth of Virginia in identifying the distribution of reports, role mappings, and report standards.
• Supporting Technical members in executing customization in the application by performing coordination with technical team members and unit testing for proper delivery of developments.
• Customize and develop reports using SQR, Application Engine and n-Vision and create adhoc queries based on the client requirements
• Responsible for data fix for production issues and identify the right fix for repeating issues.
• Support for technical Issues encountered by user and adhoc requests.
• Providing knowledge transfer to client.
• Manage all project activities and tasks, monitor progress and technical issue resolution.
• Perform quality reviews of work products.
• Co-ordinate development activities with other technical groups and projects.
• Co-ordinate all the development, execution and deliverable activities of Conversions and Batch schedule.

Confidential

Role Technical Lead

Environment :PeopleSoft Financials 9.1 AR with Tools 8.51, Oracle 11i, SQL Server, Mainframes JCL, UNIX

Project Description

• Onsite Project Lead and provide onsite offshore coordination and distributing the workload and Technical coordination with offshore and Validation of offshore deliverables.
• Primarily involved in Interacting Business Users, Identifying the Business requirements and delivering the deliverable in time without scarifying the quality of Work.
• Worked closely with the Development team to get the Issues resolved and the defects fixed for the RICE items.
• Supporting Technical members in executing customization in the application by performing coordination with technical team members and unit testing for proper delivery of developments.
• Customize reports and create adhoc queries based on the client requirements
• Responsible for data fix for production issues and identify the right fix repeating issues.
• Support for technical Issues encountered by user and adhoc requests.
• Created XML-Publisher reports for various business requirements.
• Providing knowledge transfer to client.
• Developed Various Custom reports according to client requirements using SQR, Crystal Reports.
• Manage all project activities and tasks, monitor progress and technical issue resolution.
• Perform quality reviews of work products.
• Co-ordinate development activities with other technical groups and projects.

Confidential

Role Technical Lead

Environment: PeopleSoft Financials 9.1 SCM with Tools 8.51, Oracle 11i, SQL Server, Mainframes JCL, UNIX

Project Description

• Onsite Project Lead and provide onsite offshore coordination and ensure smooth functioning of the client business in PeopleSoft Finance during post go live phase by meeting all expectation of the client as per the Project scope defined.
• Responsible for root cause analysis for production failures and providing the solutions like code changes and data fixes.
• Supporting Technical members in executing customization in the application by performing coordination with technical team members and unit testing for proper delivery of developments.
• Manage all project activities and tasks, monitor progress and technical issue resolution.
• Lead and manage day-to-day technical activities including planning, requirements definition and technical components of functional specifications.
• Manage and report on support activities from offshore.
• Production support includes System testing, training in addition to the day to day functional support to the client. Responsibility includes coordination with client, functional analysis of issues reported, executing scripts, coordination with technical team for technical issues reported, arranging weekly meeting, providing feedback to the client.
• Work with team in preparing technical design and specification from functional/business specifications.
• Support for technical Issues encountered by user and adhoc requests.
• Created XML-Publisher reports for various business requirements.
• Ensure development adheres to established development standards. Work with client team leads to review, update and publish development standards.
• Responsible for presenting Daily status and maintaining logs of CR, defects raised.
• Mentoring the junior resources.

Confidential

Role PeopleSoft Consultant

Environment PeopleSoft Financials 9.1 AR, Billing with Tools 8.51, Oracle 10g, SQL Server and Quest Toad

Project Description

• Successfully and timely documented technical designs, test cases, status reports , built, tested and released major client requirements of project..
• Application engine for reading multi lingual data from xml file and updating respective tables in PeopleSoft database. Ultimately data gets populated in Custom product set up page.
• Worked on multi lingual RTF and XLF templates used by xml publisher.
• Coordinated with the team in understanding the requirements and in development.
• SQL People Code tuning to increase the performance of the conversion processes that handle huge volume of data from legacy system 10 years .

Confidential

Role PeopleSoft Consultant

Environment PeopleSoft 9.0 with Payroll Tools 8.49, Oracle 10g, SQL Server, Quest Toad

Project Description

• Customized SQR reports, developed new reports and run control pages as per the client's requirement.
• Developed PS Queries and Application engines, and used XML publisher for the report generation as per requirements.
• Created various Components, Records and Pages to include custom fields, translate values, multi level scrollbar, menu design, components and People Code as per the specifications
• Developed a Payroll GL Interface for the use of the 3rd party vendors.
• Prepared Unit Test Plans and System Integration Test plans
• Coordinated with the team in understanding the requirements and in the development.

Confidential

Role PeopleSoft Consultant

Environment PeopleSoft Financials 8.9 AR, GL, AP, AM, Billing, Procurement with Tools 8.49, Oracle 10g, SQL Server, Control-M, Quest Stat, UNIX

Project Description

• Production Support of Day to Day PeopleSoft Financial tasks
• Have fixed many Technical Issues raised in the production environment within a short period of time
• Reviewing interface log files and address Errors and Performance issues on production Instance.
• Customized SQR reports, developed new reports and run control pages as per the client's requirement.
• Developed and Modified PS Query Reports, developed Adhoc queries, ran the same to give the outputs to client as per user requirements.
• Involved in Data Base refreshment and tuning the App Server performance.
• Modified existing/Created various Records and Pages to include custom fields, translate values, multi level scrollbar, menu design, components and People code as per the specifications
• Used Quest STAT as a Change management and version control tool to lock objects while migrating projects/people tools objects among the different environments in the system.
• Customized Excel to CI program which helps the users for data entry, responsible for configuration of the system in certain areas.
• Monitor UNIX and NT Servers and resolve in case of issues like bouncing and administering.

Confidential

Role System Analyst

Environment PeopleSoft Financials 8.48 AR, AP and GL , SQL Server, UNIX

Project Description

• Responsible for Customization of People soft objects based on specifications using People Tools and People Code. Also customized Reports, search records and pages.
• Have used Component Interface apps engine for data upload thru Excel, Integration Broker for modifying message sync.
• Preparation and review of detailed design, Test plan and Test result documents

Confidential

Role System Analyst

Environment PeopleSoft Financials 8.48 HCM , SQL Server, UNIX

Project Description

• Customized SQR reports, developed new reports and run control pages as per the client's requirement.
• Developed Adhoc queries, ran the same to give the outputs to client as per user requirements.
• Have fixed many Technical Issues raised in the production environment within a short period of time.

Confidential

Role PeopleSoft Consultant

• Project Description
• , SQL Server, Autosys, Remedy, UNIX
• Environment PeopleSoft Financials 8.4 Reporting - GL, AP, AR, Procurement, Billing
• Designed and delivered five variations of Aging report using SQR, Queries in AP, AR and GL Using Query Manger.
• Customizing the existing nVision Layouts and upgraded to latest version.
• Created the run control record and Pages, as it is required to run the Reports.

Confidential

Role PeopleSoft Consultant

• Project Description
• Environment PeopleSoft Financials 7.05 GL, AP, AR, Procurement, Billing , SQL Server, Autosys, Remedy, UNIX
• Analyzed problems resolved issues and participated in root cause analysis.
• Administered Central knowledgebase and tracking Tool Remedy to capture, store and retrieve information and solutions for reuse, coordinated with Client and Offshore team for issue resolution.
• Have used UNIX, to extract data from 3rd party systems Odyssey Billing system , Tune-Up Ordering system , and Pyramid Claims System with AUTOSYS to schedule batch process.
• Have automated dunning letter process in AR using SQR.
• Developed check layouts using Crystal Reports in AP.
• Automated daily exchange rate feeds.
• Developed custom PS query reports.
• Developed new GL based Matrix type nVision reports using trees, Time spans, and scope variables and modified existing reports for automated distribution to users.
• Created a pay cycle for the new Bank Account key, to be picked up by nightly batch job for posting and payment creation.

Confidential

Role Team Member

• Project Description
• Environment PeopleSoft HRMS 8.8, SQL Server, UNIX
• Created new Records, Pages, Menus based on user specifications using Application Designer
• Customized Records, Pages, Menus based on user specifications using People Tools and People Code.
• Developed 3SQRs and 2 App Engines that upload data into PeopleSoft tables
• Developed several inbound and outbound SQR interfaces
• Prepared and reviewed compare reports identifying Custom SQR's, Application Engine, Trees and Queries and analyzed its impact with team
• Prepared a user-training document including all the screen shots and navigating process
• Customized the delivered SQR programs according to the user requirements
• Registered components with Portal registry. Provided Security through Portal Registry.
• Designed and developed interface programs to migrate data using SQR as the primary tool
• Configured Process Scheduler to run SQR reports and Application Engine.
• Used Process monitor to track the process run status.

Confidential

Role Team Member

• Project Description
• Environment PeopleSoft Financials 8.8 GL, AP , SQL Server, UNIX
• Involved in preparing initial design specifications.
• Developed new SQRs and modified existing SQRs for GL and AP modules by conducting design and impact analysis.
• Created new Records, pages, Menus based on user specifications using Application Designer and used people code for validations.
• Developed an interface SQR which pulls all of the values for each file and create separate outbound files such as GL Combo Edit File, GL Deptid File, and GL Account file in the specified path.
• Involved in debugging to identify the problem , modifying, tuning the SQR.
• Developed AP Balance Summary Report which generates a report that contains Details like Invoices closed, Invoices deleted, Total invoices deleted and added, Discount details, Net Payment and Net Activity etc.,
• Involved in regular peer review meetings.

Confidential

Role Team Member

• Project Description
• Environment PeopleSoft HRMS 8.4, SQL Server, UNIX
• Customizing Designing Pages, Components and Menus.
• Added new fields to the existing pages and modifying the field formats.
• HR Data Audit Report is being generated from custom SQR
• Responsible for developing and modifying SQR reports for Base benefits.
• Developed and modified several Reports for Payroll, Payroll summary by deptid, location and modified direct deposit report.
• Configured Process Scheduler to run SQR reports and Application Engine.
• Performed analysis and designing of the technical specifications.
• Modified several custom SQRs.
• Added full-time, part-time fields to the employee vacation balance report which is generated by an Interface SQR
• Used people code to hide unwanted fields for some pages.
• Developed Run Control Pages and attached to menu to run the SQR online.
• Responsible for debugging to identify the problem , modifying, tuning the SQR.
• Coordinated with developers, users and testing team in various purposes to improve the quality of the PeopleSoft application.