HIGHLIGHTS

• Experienced PeopleSoft Consultant with strong Technical and good Functional knowledge.
• Instrumental in PeopleSoft functional and Technical solution, scope, fit gap analysis, requirements gathering, quality management, performance improvement, process reengineering, change management, installation, integration, troubleshooting and support.
• Two successful implementations from requirement gathering through roll out including development, major customization, testing, user and developer training and leading technical team.
• Two successful PeopleSoft Upgrades in PeopleSoft Financials.
• Multiple enhancement and support experience.
• Extremely proficient in the use of PeopleSoft Online development tools, BI XML Publisher, nVision, PeopleCode, Application Engine, Integration Broker and SQL/SQR Languages.
• Driven to provide excellent customer and innovative user experience.
• Collaborates with the Team Members to augment individual strengths and deliver quality solutions.

Technical PROFICIENCIES

Project Experience

Confidential

Role: PeopleSoft Technical Consultant

Responsibilities:

• Actively involved in the project staring from building the Demo Environment for Initial Pass to various phases of the project life cycle.
• Identify changes that are Partial Fit and retrofit the customizations and interfaces due to this upgrade. Wrote several Technical Design Documents for the same.
• Provide development support for changes in application engine programs, application packages, SQRs, PeopleCode, file layout, integration broker messages and portal structure.
• Perform troubleshooting, debug application errors and performance tuning of various SQLs that were run during upgrade using Change Assistant.
• Customized Trial Balance Detail Report and developed various other reports using PS Query and XML / BI Publisher XMLP .
• Worked extensively with configuring Integration Broker between PeopleSoft FSCM and HCM.

Environment: PeopleSoft FSCM 9.1/9.2, PeopleTools 8.5/8.54, Oracle 11g, SLES11.

Confidential

Role: PeopleSoft Technical Consultant

Responsibilities:

• Developed new interface for benefits vendor Standard per the requirements, populating data dynamically to respective file fields in File Layout.
• Customized existing interfaces to extract large data sets.
• Developed CI based program to mass upload Pension data while updating enrollments information on Job Table.
• Developed Data Mover scripts for migration of configuration specific to Open Enrollment across environments.
• Customized existing functionality of Template Based Hire per new requirements.
• Designed and Developed functionality to automate Canada OSI Payroll information update to drastically reduce manual efforts.
• Supported Production Environment by resolving Tickets.

Environment: PeopleSoft HR 9.1, PeopleTools 8.52, Oracle 11g, Sun Solaris.

Confidential

Role: PeopleSoft Technical Consultant

Responsibilities:

• Understand the requirement wireframe Functional Design and propose a solution through Technical Design document.
• Leverage portions of existing Web application and identify and / or develop reusable components for future enhancements / support.
• Develop iScripts to read the requests coming as Query strings and multiple language codes.
• Generate output that comply JSON standards and respond to the requests received by iScripts.
• Create Unit Test document, manually test the developed objects from different users point of view in multiple geography's and capture the results to facilitate User Acceptance Testing.
• Assist Mobile App Development team with understanding and testing of iScripts.

Environment: PeopleSoft HR Portal 9.0, PeopleTools 8.49, Oracle 11g, Sun Solaris, SSO, STAT.

Confidential

Role: PeopleSoft Technical Consultant

Responsibilities:

• Understanding System Requirements Document SRD and Propose solution by means of High Level Design HLD .
• Develop a Synchronous Web Service built using Document Technology and publish it using WSDL so as to be consumed by Mobile Apps and Oracle Fusion Middleware applications.
• Develop flexible and efficient code using Application Packages and Libraries considering high volume transactions.
• Design the staging record structures to comply Golden Gate solution.
• Unit testing the Web Service using third part tool SoapUI and performance testing the same using JMeter.
• Documenting all custom objects in Application Design Document ADD and tracing individual items back to SRD.
• Preparing knowledge sharing document and provide training to sustainment group.
• Coordinating with other team members and come up with unified Project and Migration document.
• Assist PeopleSoft Admins in migrations and SME's to carry out Functional Testing.

Confidential

Role: PeopleSoft Techno-Functional Consultant

Responsibilities:

• According to Enhancements changing the Application by adding and customizing the objects like pages, Records, components and menus.
• Developed programs in SQR like Capex report which prints the data of detailed Purchasing Orders.
• Customized GL Activity SQR report according to Business requirements.
• Developed the interfaces between Taleo System into PeopleSoft to upload the data into PeopleSoft application tables from flat file Application Engine and Component Interface in Account Payable module .
• By using SQR purged data from staging tables once data is uploaded into main tables
• The ORDER GRP field has been added to the LN RO HEADER sibling record as specified in the OrderDetails AnalysisReport.
• A new user interface has been designed to allow the user to enter/define and maintain the shipping charges for a particular carrier under a particular postal code, zone and packing weight.
• Created JCLs for running the job Processes .
• Customized GL activity report with opening balances and closing balances on basis of date range and business unit wise.
• Used People Code to control the program flow and logic and for validations to meet the current business requirement.
• Developed a component interface to be used in an Application Engine to load the Financial Reps Data from a flat file to ensure the component level validations are carried out while loading the file.
• Created URLs in Application like in vendors module if user wants to upload a file in a specific path..
• Resolving the production issues.
• Maintaining User Security and User Preferences.
• Done peer reviews of few SQR and Application Engine programs
• Prepared Technical specification Design documents for technical work
• Prepared Unit test cases.

Confidential

Role: PeopleSoft Technical Consultant

Responsibilities:

• Extensively worked on SQR in Account Payables module, generated reports according to the Technical Specs.
• Customized the SQR programs like Open Item aging report which prints the data according to aging buckets .
• By Using PeopleCode, Used send mail function when project information like project start date, end date mail should be sent to Account manager and project manager.
• By Using Application Designer created new Run Control Pages, Run Control Records for SQR like for Time sheet report in Project costing modules.
• Involved in customizing the peoplecode to replace the PeopleSoft delivered positive pay crystal process APY2055 with the AHFC customized SQR and default the process scheduler server to PSUNX.
• Customized Application Engines PO ITMLOAD and IN ITMLOAD during this item load Process.
• Wrote a Custom SQR FLTREOUT.DAT an Outbound interface process to extract information on reconciled Payroll and Retirement warrants from ASPIRE and send it to Central FLAIR. The file has reconciliation of Payroll and Warrants.
• Developed SQR interface Program, which loads Project data into PROJECT, PROJECT DESCR, PROJECT STATUS, PROJ LOCATION, PROJECT MGR, PROJ ACTIVITY, PROJ ACT LOC, PROJ ACT DESCR, PROJ ACT STATUS tables.
• Customized various Records, Pages and Component according to the client's requirements using Application Designer.
• According to User requirements built many PS/Query reports and tested it.
• By using Application Engine program
• By Using File Layout and Application Engine data has been uploaded from Flat file.
• Data Uploaded by Using Application Engine Programs from Flat files.
• Prepared Technical design documents, after completing customizations.
• Written Unit test cases for SQRs.

Confidential

Role: PeopleSoft Technical Consultant

Responsibilities:

• Developed many Application Engine Programs to load data in to PeopleSoft application like Voucher and invoices data into PeopleSoft system.
• According to Enhancements changing the Application by created new pages and Records, and components.
• Developed programs to upload the data into PeopleSoft application tables from flat file using SQR.
• Extensively worked on Order Management/Billing Interface OM BILL Process, used SQL to analyze the interface staging tables to correct the errors.
• Worked extensively in debugging, tracing and compiling various Application Engine, SQR programs of PO, INV, AP and OM. Developed new SQRs according to requirements.
• Used People Code to validate address fields in personnel page according to client's requirements.
• Resolving the production issues.
• Maintaining User Security and User Preferences and permission lists
• Done peer reviews and performed unit test cases and prepared Technical specifications.
• Interacting and coordinating with different teams to resolve tickets.
• Gather, analyze and report different matrices to the management on Weekly basis.

Confidential

Role: PeopleSoft Technical Consultant

Responsibilities:

• Responsible for development and implementation of PeopleSoft applications, using People Tools, People Code, Query, Crystal and SQR programs.
• Used application designer to modify existing tables and create some new tables and views to meet the application needs, created many pages and modified the existing menus to reflect the customized pages and controlling the program flow with People Code.
• Developed programs to upload the data into PeopleSoft application tables from flat file using SQR and Application Engine.
• Used People Code to control the program flow and logic and for validations to meet the current business requirement.
• Performed several online customizations for PeopleSoft Project Costing module.
• Performed Unit Testing on the customized SQR reports
• Extensively worked on SQR in Account Payables module, generated reports according to the Technical Specs.
• Prepared Technical specification Documents, according to task.

Confidential

Role: PeopleSoft Technical Consultant

Responsibilities:

• Involved in conversion from legacy system to PeopleSoft FSCM Solutions using Application Engine, Component Interface and parallel processing.
• Developed multiple File Layouts and Application Engines to export and import data from and to PeopleSoft Application.
• Developed and customized multiple components per the requirement specifications.
• Involved in Technical discussion, brainstorming and evaluation of available tools to develop new functionality that is scalable and easy to configure in future.
• Developed various nVision reports to help users carry out their analysis.
• Developed SQR's to populate reporting tables that are used in various nVision reports.

Confidential

Role: PeopleSoft Technical Consultant

Responsibilities:

• Develop Inbound and Outbound Interface programs using Application Engine and File Layout.
• Design and Develop Data Conversion program using SQR.
• Unit Test developed module. Report Errors and Issues using Test Director.
• Understanding Functional Design Document and prepare Technical Design Document and Unit Test document.
• Run and monitor jobs scheduled on CA7 as part of Integration and Parallel testing.
• Use STAT for Change Management and NIKU / Clarity for document management.
• Receive training in NA Payroll, Benefits and Benefits Administration.
• Prepare weekly reports and presentations and demonstrate the same to higher management.

Confidential

Role: Sr. Software Developer

Responsibilities:

• Web Development in C and ASP.NET
• Develop various web pages to capture Employee KSA, roles, policies, SOP's and SLA's.
• Develop Role Security Tree majorly using Java Script.
• Develop Recursive Stored Procedure in Oracle DB to retrieve Employee Supervisor.

Confidential

Role: Software Developer

Responsibilities:

• Web Development in HTML, DHTML and ASP.
• Develop components to capture data per business processes.
• Develop and Dashboards showing Department wise Expense at Real Time.
• Develop various reports using Crystal Reports.

Confidential

Role: Associate Software Developer

Responsibilities:

• Web Development in HTML, DHTML and ASP.
• Develop Windows Explorer like structure on Web page using DHTML and Java Script.
• Develop a DLL in VC to extract text from PDF files and store it in DB so that these files are searchable.
• Develop pages to upload Book cover images and store them on File Server.