SUMMARY

• Total 13+ years of PeopleSoft Experience.
• Experience in leading Onsite/Offshore model.
• Post Production Support for PeopleSoft Applications.
• Experience in Analysis, Designing, Developing, Testing, and Integrating modules.
• Extensive experience with PeopleSoft Implementations and Upgrades.
• Working knowledge of PeopleSoft Portals, Java, C/C++, Visual Basic, XML, Web Services Unix/Linux, Object Oriented Design and Patterns.
• Excellent communication and presentation skills.
• Ability to be an effective team player, work under time constraints and easily adaptable to new environment.

TECHNICAL SKILLS

PeopleSoft Development Tools: PeopleTools 8.x, PeopleCode, Application Engine, Security,PS Query

Modules: GL, AP, AR, Billing, Asset Management, Purchasing, Order Management, Inventory, Expenses, Project Costing,eProcurement,Contracts, Budgeting, Payroll, Benefits, Time and Labor.

PeopleSoft Reporting Tools: SQR, Crystal Reports, BI Publisher, PS/Query & nVision.

PeopleSoft Integration Tools: Integration Broker, Component Interfaces, WorkFlow .

Other Programming Languages: HTML5,CSS,PL/SQL, SQL, Java, C/C++, COBOL, IBM Assembler 370, JCL, PASCAL, VB6, VB.net and Shell Scripting

Other Tools: Visio

RDBMS: Oracle 11.x/10.x/9.x and MSSQL Server 2000.

Operating Systems: UNIX, Windows NT/Win2K.

PROFESSIONAL EXPERIENCE

Confidential, Newyork

PeopleSoft Financials/SCM & HCM Techno Functional Consultant

Environment: PeopleSoft 9.2/PeopleTools 8.55,( NA Payroll, Benefits, Time and Labor,Absence Management, Performance Management, Taleo, Recruiting,Workforce Administration,Compensation), Application Designer, People Code, Application Engine, PS/Query, Crystal Reports, SQR, Component Interface, Oracle 11g,Unix.

Responsibilities:

• Worked in Onsite/Offshore Model and lead a team of 3 Developers in Offshore Location.
• Implemented security by creating User Profiles,Roles and Permission Lists.
• Interacted with Business Users and prepared the Functional Specification Documents.
• Worked as part of 24/7 Production Support Team.
• Have exposure to PeopleSoft HCM - Base Benefits, Benefits Administration.
• Extensively worked on the inbound/outbound interfaces between PeopleSoft and third party systems using Application Engines, File Layouts and CI.
• Extensively worked on the inbound/outbound interfaces between PeopleSoft and third party systems using Application Engines, File Layouts and CI.
• Modified custom Annual Enrollment statement program (BAS004) as per customer specification.
• Converted Job Data, Benefits Data which included Dependents, Health Benefits, Life Benefits, Disability Benefits,etc using SQR’s.
• Created multiple BI Reports and trained End Users to create their own reports.
• Updated CNTPAY01 Contract Projected Payment SQR Process to include the updated Business Logic in making the payments.
• Addressed production issues related to HR, Payroll, Benefits and Time and Labor. Developed a report to list labor, material and service costs in Project Costing.
• Extensively worked on performance tuning of SQL in SQR and Application Engines.
• Updated Pre Calculation Audit Report to get additional Employee Data.
• Modified PeopleCode in Integration Broker in PeopleSoft inventory while doing Express Issues.
• Performed extensive debugging and performance tuning of various processes. Well versed in utilizing tools and utilities PC Debugger, Application Engine trace for troubleshooting.
• Extensive experience in People Tools, Reporting Tools and integration methodologies.
• Developed an SQR to list the work order material to be dispersed in Inventory.
• Custom wrote an Application Engine to load data from a flat file into Interface tables in Project Costing.
• Extensively worked on performance tuning of SQL in SQR and Application Engines.
• Developed multiple Component Interfaces to use them in ExceltoCI for loading data into the tables.
• Designed and developed data conversion programs to convert and load legacy data into PeopleSoft.
• Extensive experience on STAT used for Project Migrations.

Confidential, Kansas City

PeopleSoft Financials/SCM Techno Functional Consultant

Environment: PeopleSoft FSCM 9.2/PeopleTools 8.54((GL, AR, AP, Inventory, Purchasing,eProcurement ), Application Designer, People Code, Application Engine, PS/Query, Crystal Reports, SQR, Component Interface, Oracle 10i, Unix.

Responsibilities:

• Interacted with the Business Users to understand the requirements and presented the Functional Specification Documents.
• Retrofitting of objects as part of FSCM 9.1 to 9.2 Upgrade.
• Performed Fit Gap Analysis as part of the Upgrade Process.
• Bug fixing and object migrations to the upgraded environments
• Analyzing compare reports and clean up the data and orphan objects.
• Transformed the business requirements in Inventory and Purchasing Modules to resources.
• Developed CIs and used ExceltoCI to load data from legacy systems to PSOFT.
• Prepared the interface strategy that also handled the ‘Region-code’ Sub-CST-Qualifier to send out notifications to users whenever a new ‘Region-code’ was added.
• Custom wrote an SQR to generate a flat file to be sent to the bank for garnishment vouchers.
• Custom developed an nVision Budget vs Actual Report along with Drilldown to check details at Account Level.
• Developed an SQR to get the Procurement Credit Card Transaction details.
• Developed an SQR to provide the PO’s where Items are Substituted.
• Customized the INS7000 as part of getting the Inventory Usage.
• Custom wrote an Application Engine to update the receipt quantity to Voucher Quantity for receipts older than 9 months as part of avoiding the receipts from not accruing.

Confidential, Hartford

PeopleSoft Financials/SCM Techno Functional Consultant

Environment: PeopleSoft FSCM 9.1/PeopleTools 8.52((GL, AR, AP, Grants, Inventory, Purchasing,eProcurement ), Application Designer, People Code, Application Engine, PS/Query, Crystal Reports, SQR, Component Interface, Oracle 10i, Unix.

Responsibilities:

• Interacted with the Business Users to understand the requirements and presented the Functional Specification Documents.
• Transformed the business requirements in Inventory and Purchasing Modules to resources.
• Set up the Advance Shipment Receipt process and trained the users on how to use it.
• Created multiple queries for the Business Users
• Custom wrote an SQR to get the usage of items by Department.
• Customized AP Match Exception Crystal Report to take out some of the exceptions from the report.
• Customized the Receipt Accrual Process in Accounts Payable.
• Worked on Integration with Project costing and Customer Contracts modules. Worked on performance issues CA BI INTFC.
• Developed Grants Vs Billing reports using Pivot charts in BI Publisher by Grants Bill by IDs on PROJ RESOURCE.
• Custom Developed an Application Engine to send a file for positive payments.
• Developed an Application Engine to load data from flat file into Procurement Tables.
• Customized the process with the new tax rates while creating Journal entries in Payroll.
• Customized the Process to provide the check details along with Pay sheet information in Payroll.

Confidential, Newyork

PeopleSoft Techno Techno Functional Consultant

Environment: PeopleSoft 9.1/PeopleTools 8.52, (GL, AR, AP, Inventory, Purchasing,Billing,Order Management,AM,eProcurement,Project Cost Management,Payroll, Benefits, Time and Labor ) Application Designer, People Code, Application Engine, PS/Query, Crystal Reports, SQR, Component Interface, Oracle 10i,Unix.

Responsibilities:

• Interacted with the Business Users to Understand the Requirements and took part in preparing the Business Requirements Documents.
• Interacted with the Business Users to understand the requirements and presented the Functional Specification Documents.
• Retrofitting of processes and objects as part of FSCM 9.0 to 9.1 and 9.1 to 9.2 Upgrades.
• Lead an onsite/offshore team and delivered the quarterly releases.
• Provided training to end users on how to use the Peoplesoft application
• Provided multiple Visio presentations for Senior Managers.
• Custom Developed Application Engine to upload Benefits Data.
• Custom wrote an SQR to provide the Payroll Summary by Country.
• Custom developed a Template in Excel using VB to validate Data and generate a clean file which should be loaded without any format errors.
• Created multiple nVision Reports for regulatory reporting.
• Developed shell scripts for file transfers between partner systems.
• Developed multiple Application Engines to send Data Feed to various other Groups within Citi.
• Extensively worked on Peoplecode as part of the Portfolio Maintenance Process.
• Developed multiple reports to check the Data Quality.
• Developed Pages to show the status of the Feeds being sent to other groups.
• Developed the Login screen as per Citi standards..
• Conducted Sessions to train the End Users to make them understand the system.
• Production Support team member to support users. Resolved issues like missing sellers, truncation of amounts, loan numbers, failure of interfaces, processes, reports, etc. Resolved issues on priority basis.
• Extensively worked on performance tuning of SQL in SQR and Application Engines.
• Developed multiple Component Interfaces to use them in ExceltoCI for loading data into the tables.
• Developed Workflow as part of the Data Signoff process.
• Designed and developed data conversion programs to convert and load legacy data into PeopleSoft.
• Upgraded GCBC from Solaris 8 to Solaris 10.Taken care of the changes to be done by Application Developer. Changed multiple files on the Web bank server as part of it. Used Hermes Tool for migrations.
• Compiling and clean up of SYSAUDIT, DDDAUDIT reports.
• Involved in Pre and post upgrade activities
• Bug fixing and object migrations to the upgraded environments
• Analyzing compare reports and clean up the data and orphan objects.
• Extensive experience on STAT used for Project Migrations.

Confidential, Kansas City, Kansas

PeopleSoft HCM,Financials, SCM & EPM Consultant

Environment: PeopleSoft Financials/SCM 8.4, PeopleTools 8.43 (GL, AR, AP,AM, Project Costing Billing, Inventory, Purchasing,Order Management, Payroll, Benefits, Time and Labor) Application Designer, People Code, Application Engine, PS/Query, Crystal Reports, SQR, Component Interface, Integration Broker, Work Flow, SQL, SQL Server 2000, Win 2000, nVision.

Responsibilities:

• Prepared Techno Functional documentation for various functions based on business requirements.
• Developed multiple monthly expense check and Income reports using nvision.
• Involved in Development and Testing of Interfaces, Online Customizations and Conversions using SQR’s.
• PeopleCode, Component Interfaces and Application Engine for PeopleSoft HR, Benefits and Payroll modules.
• Modified the OM BACKGRND Application Engine to resolve issues during Post Production.
• Developed an Application Engine to coordinate inter unit transfers to handle Inventory.
• Modified PeopleCode in Integration Broker in PeopleSoft inventory while doing Express Issues.
• Coordinated with end Users and modified the system as per their Usage.
• Extensively worked on performance tuning of SQL in SQR and Application Engines.
• Custom developed an SQR to list the daily transactions that effect inventory.
• Developed a report to get the Cancelled Requisitions in Inventory.
• Developed Application Engine to execute the DTS Packages and load the items from various vendor tables into staging tables.
• Custom wrote SQR Reports to print various Open Order Reports.

Confidential, Troy, Michigan

PeopleSoft HCM,Financials & SCM Techno Functional Consultant

Environment: PeopleSoft Financials/SCM 8.4, PeopleTools 8.43,(GL, AR, AP,AM, Project Costing, Inventory, Expenses, Order Management) Application Designer, PeopleCode, Application Engine, PS/Query, SQR 6.0/4.x/3.x, SQC, nVision, SQL, Oracle 9I, Crystal, HP-UNIX.

Responsibilities:

• Part of the upgrade team for upgrade of system from 7.5 to 8.4.
• Worked with DDDAUDIT and SYSAUDIT reports in analyzing the Orphaned data redundancy and identifying the inconsistencies and orphaned objects.
• Worked on TAM component interfaces that help you load data from your existing system into PeopleSoft Enterprise
• Talent Acquisition Manager Integration’s tables. Use the Excel to Component Interface utility with the component interfaces to populate the tables.
• Ran Compare Reports and identified the objects that had to be reapplied.
• Developed an Application Engine to coordinate with a third-party demand forecasting software application for Inventory Planning.
• Custom wrote an Application Engine and generated a flat file pulling out FSIs for a particular physical year in GL.
• Customized the OMBILL SQR process as per the business requirements.
• Reapplied PeopleCode, application engines, sections, actions, PeopleCode, SQL’s, Queries, Pages, Components, SQRs and Crystal Reports.
• Developed an Application engine to interface Asset management and General Ledger Module.
• Used Process Scheduler for creating SQR reports for the purpose of General Ledger reports.
• Created nVision, Crystal reports.
• Developed search capability on location based on certain criteria.
• Worked on the Depreciation calculation and accounting entry calculation using SQR.
• Automated the business processes using workflow by creating roles, rules and routings thereby sending the right information to the right person at the right time.
• In Asset Management involved in applying PeopleSoft patches.