PROFESSIONAL SUMMARY

• Over 10 years of overall IT experience wif more than 9 years in analysis, design, development and implementation of PeopleSoft Financials and HCM applications
• Excellent knowledge of PeopleSoft HCM modules (Payroll, Benefits Administration, Time & Labor, HR, Absence Management, Position Management and Talent Acquisition.)
• Excellent Knowledge of PeopleSoft Financials (GL, AP, AR, AM) PeopleSoft Distributions (Billing,
• Experience in working on PeopleSoft Financials/HCM applications releases 7.5 - 9.2.
• Performed roles responsible for all phases of teh software development cycle, which include: Design Specification, Development, Upgrades, and Implementation of teh PeopleSoft FSCM/HCM Solutions.
• Excellent knowledge of People Tools( Application Designer, Application Engine, People Code, Component Interface, Integration Broker, Workflow, EDI Manager, Change Assistant, PS Query, Process Scheduler and Tree Manager ).
• Good working knowledge in PeopleSoft Administration Tools Process Scheduler, Security, Application Server, Data Management, Configuration Manager, BEA Tuxedo.
• Involved in Debugging, Troubleshooting and Testing of SQR and PeopleSoft Applications.
• Experience wif Crystal, nVision and SQR reporting as part of Upgrade and Implementations.
• Experience in using teh Autosys Process scheduler to schedule Batch Jobs on UNIX, OS 390, SOLARIS, NT and LINUX environments.
• Performed End-User training and prepared training documents for teh end users.
• Implemented Security and performed Security testing in PeopleSoft 8.X/9.X environments.
• Experience wif web based applications like SOAP, XML.
• Experience in development of business specific reports using decision-supporting tools like SQR, Crystal, nVision, PS Query and MS Excel.
• Excellent ability to interact wif Technical, Functional and Business User groups at various levels.
• Performed End-User training and prepared training documents for teh end users including using UPK.
• Experience working wif tools like Microsoft Office, Visio, Projects and other decision supporting tools.
• Capable of working under high pressure and a good team player who can be flexible and work individually

TECHNICAL SKILLS

ERP: PeopleSoft Financials and HRMS releases 7.X/8.X/9.XModules

Financials: GL, AR, AP, Billing, Purchasing, AM, Inventory, OMBudgets, Contracts, Project Costing, Expenses, eProCommitment Control and Grants.

HCM: A Payroll, Benefits, Ben Admin, Time & Labor, Core HR, Leave Accruals, Global Payroll & Absence Management, ESS and MSS, eLearning, ePerformance, eCompensation Position Management and Talent Acquisition.

People Tools: Application Designer, Application Engine, Business Process Designer, PeopleSoft Query, Tree Manager, Security Administrator, Process Scheduler, Process Monitor, Change Assistant, Data Mover, Component Interface, Application Messaging, Application server, Report repository.

Reporting: SQR, nVision, Crystal Reports, MS Excel, Oracle Data Integrator.

Languages: People Code, COBOL, C, C++, Java, Visual Basic, PL/SQL, Perl, Shell scripting, SQR, XML.

Integration Tools: Component Interfaces, File Layout, Application Messaging, Integration Broker

Operating Systems: Windows 2003/2000/98/95/NT/XP/7, UNIX.

Databases: Oracle 8, 9i, 10 and 11g, MS SQL Server and DB2

PROFESSIONAL EXPERIENCE

Confidential, Washington DC

Sr. PS Technical Consultant

Responsibilities:

• Created custom dashboard to facilitate teh user wif a single screen for daily activities involving Workflow, Worklists and custom reports.
• Worked as an offshore/onshore model manager.
• Worked on supporting teh FACTS team as a liaison between teh users and teh offshore team.
• Involved in QA and making sure dat teh product is delivered in teh right time and wif teh right quality to teh business.
• Supported and created various requests, incidents and enhancements to teh systems based on teh new patches releases by Oracle.
• Worked on multiple Application Enhancement Requests (AER).
• Based on teh business logic and teh desirability by teh user made modifications to teh system.
• Worked on multiple modules like Purchasing, Travel & Expenses, AP, GL and Inventory.
• IMF T&E module is based onTIMSto maintain travel and expenses related information. TIMSis a custom bolt on application based onPeopleSoft 9.2 FIN/HCM.
• Participated in Fit-Gap sessions between PeopleSoftT&E and EFRMS/TIMS bolt onand assisted in creating Fit-Gap Document.
• Development of EFRMS/TIMS Bolt-ononline pages, batch process and Work flow.
• Setup PS BI Publisher to be used for AP/Payroll Check Printing process.
• Setup Email Alerts for requisitions dat are left in Open Status.

Environment: PeopleSoft FSCM /HCM 9.2, People Tools 8.54, People Code, Application Designer, Application Engine, CI, PS/Query, SQR, Oracle, SQL,PL/SQL, Windows 2003/XP/7, Win NT 4.0, UNIX, Java, Phire, Quality Center.

Confidential, Richardson, TX

Sr. PS Technical Consultant.

Responsibilities:

• Worked on VMS (Vendor Management System - FieldGlass) integration wif PeopleSoft FSCM v9.0.
• Designed and developed interfaces both outbound and inbound to FieldGlass from PS AP, GL modules using various People Tools like Integration Broker, Application Engine and PeopleCode
• Performed end to end Application Upgrade from v9.0 to v9.2.
• Involved in detailed analysis of identifying objects, compared between old and new model to retrofit.
• Created new and customized existing several PS objects and retrofitted several of them based on functionality.
• Worked on Data Mover Scripts (DMS) for several HR, Benefits and Time &Labor tables.
• Created Unit testscripts to test teh business functionality for teh delivered code based on teh requirements.
• Wrote custom error messages on Benefits records and pages to hide beneficiary information based on different Plan Types.
• Supported multiple bolt on to HCM suite like RPA (Request for Personal Action) which was used for JOB record.
• Wrote custom People Code on several T&L objects to support business requirement.
• Built custom configuration pages to teh users to be able to add items dat are used inePerformancedocuments.
• Created CI and used ExceltoCI to update several fields on Job table based on business requirement.
• Worked on creating a Strings Table which tan can be used in SQR processes so as to avoid hard coding values in programs.
• Moved several SQR processes into Mainframes using JCL.

Environment: PeopleSoft HR 9.2, People Tools 8.54, People Code, Application Designer, Application Engine, CI, PS/Query, SQR, DB2, SQL,PL/SQL, Windows 2003/XP/7, Win NT 4.0, UNIX, Java, Mainframes.

Confidential, Irving, TX

Sr. Technical Architect.

Responsibilities:

• Worked on consolidation of two different PS production systems (Wire line & Wireless) into one standard PeopleSoft system called OneHR.
• Involved in teh whole SDLC beginning wif requirement gathering till support for all teh customizations and enhancements.
• Designed and developed a Data Hub dat was used as a source to feed data to 350 downstream interfaces.
• Retrofitted several SQR’s, AE’s and other processes to support downstream based on teh new OneHR standards.
• Designed and developed several PLSQL functions, stored procedures and incorporated them to be call from several Application Engines.
• Solely responsible for maintaining Contractor & Employee data and their respective hierarchies.
• Supported tier zero interfaces from PeopleSoft like LDAP, CVCE, and Field Glass etc.
• Developed AE’s and PL/SQL stored procedures to update LDAP wif employee hierarchy data and also to populate Terminated employee Hierarchy.
• Created several programs for Data Conversion from different platforms to be loaded into teh new system using various People Tools depending on teh volume of data.
• Worked on Taleo integration wif PS for client’s applicant tracking system and internal job postings.
• Worked on PeopleSoft data archive manager to archive past payroll data.
• Setup Integration between Portal and PS HCM and CRM.
• Provided production support for teh following applications HCM9.1, CRM 9.1 on People Tools version 8.52.
• Involved in daily calls wif teh end users wif regards to their issues and fixing them based on teh tickets created by them in Quality Center.
• Created and supported several new enhancements to teh existing system.
• Worked on Oracle Data Integrator for creating financial reports.
• Responsible for data conversion from PeopleSoft both HCM and FSCM data into Oracle database.
• Wrote several on demand processes to load AP, PO, AR, GL and also HCM data from server bought from teh newly acquired company database.
• Worked wif users to extract teh required fields from PS dat is to be shown on teh user reports.
• Wrote several DMS and SQL scripts to move data from PeopleSoft to Oracle database.
• Worked on PO Rollover process to dispatch Purchase Orders from prior year.
• Fixed Issues in Delivered and customized SQR’s & App Engine programs for HCM and FSCM modules.
• Online support to teh users.
• Involved in customizations needed for teh users
• Involved in developing and customizing teh reports using teh tools PS Query and SQR.
• Done analysis and Retrofitted multiple SQR programs to enable table changes to chart field data and also retrofitted multiple SQR's in Payroll.
• Created several Run Control pages for teh developed and customized reports for SQR and Crystal reports.
• Created several reports using Oracle Application Express based on teh data from PeopleSoft HCM modules.

Environment: PeopleSoft FIN/HR 9.1(General Ledger, Payables, Expenses, ePro, Purchasing, Payroll, HR, Benefits), People Tools 8.51,PeopleCode, Application Designer, Application Engine, PS/Query, SQR, Oracle 10g,Oracle APEX, Windows 2003/XP/7, Win NT 4.0, UNIX, Java.

Confidential, Palm Beach County, FL

Systems Analyst

Responsibilities:

• Involved in support, development, enhancement and maintenance of teh existing PeopleSoft application 9.0 in both HR and Financial modules.
• Designed and developed several new enhancements to teh system based on teh County’s and Clerks specifications using various People Tools like Application Designer, Application Engine, SQR, PS Query, File Layouts and using People Code language.
• Created several Run Control pages for teh developed and customized reports using Crystal Reports.
• Built Crystal, nVision and SQR reports for GL, AP, AR, ePro, PO modules in SCM side and for Payroll, Ben Admin, Absence Management for HCM side.
• Developed and modified People Code to implement specific business rules and validations to enable teh system to perform teh business process.
• Worked on security creating various Roles, Permission Lists and assigning them to teh users as per their designation.
• Involved in rolling out teh necessary Bundles, Maintenance Packs (12, 13, 14) to teh Financials and Payroll Tax Updates to HCM sides of teh system using Change Assistant for all teh environments.
• Ran System Audit Reports to compare data structures defined in teh People Tools tables against teh underlying database to uncover inconsistencies.
• Involved in printing teh W2’s for teh employees of both County and Clerk.
• Involved in running Payroll for teh institutions employees on a bi-weekly basis.
• Involved in providing support for teh daily day to day processes necessary for a governmental institution.
• Mentored Production support team members to support teh users online in teh FSCM and HCM modules when a major issue arises.
• Developed different Speed Types dat flow from clients HCM to FMS through Integration Broker.
• Maintenance of Integration Broker services (such as gateways, nodes, services and service operations etc) for automatic updates between HR and FIN applications.
• Involved in design, planning and implementing teh upgrade process for both teh PeopleSoft application to 9.1 and People Tools to 8.51.
• Conducted meetings wif teh Users and involved in discussing their problems and helped them out in finding teh proper solutions for their requirements.

Environment: PeopleSoft FIN/HR 9.0(GL, AP, AR, Expenses, PO, ePro, Payroll, HR, Benefits, Leave Accruals, Absence Management), People Tools 8.49.11,PeopleCode, Application Designer, Application Engine, PS/Query, SQR, Oracle 10g,nVision, Windows 2003/XP/7, Win NT 4.0, UNIX, Java.

Confidential, ME

PeopleSoft Techno-Functional Consultant

Responsibilities:

• Developed Inbound and Outbound Interfaces required for DnBI, a credit risk analysis and scoring engine using Component Interfaces.
• Involved in data migration from legacy system (Tandem & Millenium) to teh new PeopleSoft environment.
• Used Application Designer to modify existing tables and create some new tables and views to meet teh application needs, created many panels/pages and controlled teh process flow wif People Code.
• Used Control M to create jobs to be run on a certain period of time depending on teh client’s needs.
• Wrote DMS scripts and was involved in moving of data wif in different environments.
• Wrote extensive People Code to implement teh new DNBi application, IVR and Credit Essentials process as per teh client’s needs.
• Modified PeopleSoft delivered records and their related PeopleCode to represent teh client’s business process.
• Developed a Financial Service Account Info for IVR (Interactive Voice Response) using Component Interface and Java stubs.
• Developed a custom SQR to show all teh open balances by state and created a run control for dis report to be initiated from Account Receivables analysis page.
• Built several custom SQR routines to correct out-of-balance conditions throughout budgets and expenses in PeopleSoft Financials, and specifically Commitment Control, Projects, and Grants
• Was a part of data conversion team implementing PeopleSoft Grants & Projects, as well as AR & Billing to supplement their existing PS Financials 9.0 implementation.
• Customized AR item load process to get all teh wrong payments into an external file based on teh project Id
• Worked wif teh DBA’s to get all teh PeopleSoft objects moved from development environment to Testing and tan to Production.
• Wrote documentation for teh development process like creating PS objects, SQL and also for migration of those into various testing and production environments.

Environment: PeopleSoft FIN 9.0(GL, AP,AR, INV,PC,PO, BI, ePro), People Tools 8.48.05,PeopleCode, Application Designer, Application Engine, PS/Query, SQR, Oracle 11g,nVision, Windows XP, Win NT 4.0, UNIX, Java.

Confidential, FL

PeopleSoft Techno-Functional Consultant

Responsibilities:

• Worked on PeopleSoft Financial modules like GL, AP, PO, AM, AR and Inventory.
• Involved in teh Setup and Configuration of PeopleSoft SCM modules like Inventory, Billing, Order Management and Purchasing.
• Designed data conversions programs to load legacy PO data into PeopleSoft based on teh business process needed at teh client side using Component Interfaces, SQR, and Data Mover.
• Developed various Application Engines and Component Interfaces to load different Requisitions from various vendors to teh client.
• Developed Component Interfaces to load legacy Purchase Order, Requisition and Receiver History.
• Customized teh PO Dispatch process (POPO005) to put teh client logo, business unit, address, vendor information related, added Tax Exempt Info, added code to get NT or UNIX path for signatures
• Developed an interface in order to update any Vendor information based on teh requisition made by teh same and as per client needs.
• Developed and modified all teh POY, PVY and APY Crystal reports in order to put teh client logo and change teh formulae behind it based on teh business process of client.
• Designed and developed data conversion programs to convert into PeopleSoft Grants, Contracts, Customers (Grant Sponsors), GL Journals, Purchase Orders, and Item Categories
• Developed Component Interface and Application Engine to load ITEMS in teh Inventory module based on different clients Business Units.
• Developed App. Engine and CI to load teh Default PutAway and Manually Stage PutAway for teh Items data conversion.
• Designed teh specifications for custom GL-Benefits, GL-Payroll interface to provide teh HR business wif teh monthly revenue for Bonus calculation
• Created Data mover scripts to facilitate ease in setting up various new environments.
• Worked wif PeopleSoft admin to analyze and apply PeopleSoft patches, updates and bundles.
• Provided Go Live and post-production support to insure a smooth transition wif a new product.

Environment: PeopleSoft FSCM 8.9 (GL,PO,AP,INV,AM,PC,BI), PeopleSoft HCM 8.9 (HR, Ben Admin, Payroll, Time& Labor) People Tools (Application Designer, People Code, Application Engine, SQR, nVision, SQL, Oracle 10g, Crystal Reports, Magic Service Desk, Win NT 4.0, UNIX, Informix.

Confidential, FL

PeopleSoft Techno-Functional Consultant

Responsibilities:

• Involved in Designing teh Development standards guide, Migration request form for object moving to several databases, technical work specification template to reflect functional requirements which included test scenario documentation.
• Involved in teh full Software development life cycle including Analysis, Design, Development and Testing along wif teh Application Support and Documentation.
• Developed SQR process to update earnings and list under paid, over paid earnings wif SQR multiple reports facility.
• Developed various SQR for retro pay related, to list Exceptional retro earns, Time & labor records for teh given period wif day to day earnings.
• Developed SQR‘s to perform Payroll conversions and interfaces to load data into PS Pay Earnings, Pay data and additional Pay data Tables from CSV, Excel files.
• Modified teh Payroll Interface customizations to enhance teh efficiency of teh process and considerably reduced teh processing time.
• HCM Data Conversions developed are Emergency Contacts, Time& Labor, Employee Education Data, Job Data, Personal Data, Benefits (Health, Dental, Vision), Special Detail Employees, Tax Balances, Earnings Balance.
• Developed App. Engine’s to load legacy system data into PeopleSoft delivered tables which included HR functionality like Emergency Contacts, Disability Benefits, and Leave Accruals.
• Created custom SQR Reports/Processes in teh areas of HR, Payroll and Benefits including Global Payroll to GL interface, Labor Distribution Reports, Outbound Benefits Interfaces to Providers.
• Maintain teh PeopleSoft Global Payroll system, setup earnings and deduction elements, new rules and formulae so dat teh payroll system performs in line wif teh existing rules.
• Worked on new Review leave accruals information page which to show all accrual information in terms of hours and days and to display more employee information according to functional requirements.
• Designed and developed Reconciliation Reports for HR, Benefits and Payroll modules.
• Analyzed and documented Benefit Plan codes in Peoplecode, SQR and SQC’s.
• Worked on Position data and Dependants information enhancements to meet business specific requirements.
• Helping change management team to document teh new customizations thus to produce training material.
• Performed Fit-Gap analysis and conducted interviews wif teh users to gather teh requirements for PeopleSoft Setup and Configuration.
• Developed and customized several complex SQRs including writing interfaces, using flat files to meet teh requirements of teh client.
• Designed and developed a SQR Program to populate all fields, which are not provided by client so dat end user reconciliation can process dat statement.
• Verified various factors dat could affect teh Performance like day/time, data volume, index, SQL’s, run location, databases, servers, Unix, parameters, code efficiency.
• Customized Application Engine programs for Asset Management, Project Costing and General Ledger modules
• Modified and added new People Code to accommodate new customizations and created Components.
• Provided solution by rescheduling and moving all teh reports to reporting server, which reduced contention issues and improved performance.
• Mentored teh Production issues for all teh major technical problems faced by teh production team to teh users.
• Assisted teh team administrator in teh AP archiving process.
• Modified teh GL Interface customizations to enhance teh efficiency of teh process and considerably reduced teh processing time.
• Modified several SQR reports and some Application Engine processes (such as teh AR Update).Also worked on teh archiving project and several transactions.
• Resolved several production issues.

Environment: PeopleSoft Financials 8.8, People Code, People Tools, SQL, Tuxedo, Crystal Reports, PS Query, Structured Query Report (SQR), nVision, Application Engine, Integration Broker, Workflow, DB2/Mainframe, Oracle Utilities (Toad, WinSql, UltraEdit), WindowsNT/ 2000 and MS SQL Server.

Confidential, OH

PeopleSoft Techno-Functional Consultant

Responsibilities:

• Modified Menus to reflect teh customized panel and process flow.
• Developed multiple and complex SQR reports including file updates, flat files and writing interface reports.
• Created a lot of customizations by creating components and added new people code.
• Responsible for Trouble Shooting of reports like nVision, Crystal Reports and SQR.
• Developed multiple and complex SQR reports including file updates, flat files and writing interface reports
• Customized Application Engine Program from GL to AP Interface.
• Designed and developed a SQR Program to populate all fields, which are not provided by bank so dat bank reconciliation can process dat bank statement.
• Worked on customizing Project Costing and Time and Expense modules along wif enhancements to Operator Security.
• Worked on resolving production issues in Expense module processes andinterfaces.
• Loaded a flat file by writing SQR to do these two SQRs was written. First one to convert it into teh required format for teh EDI process to run successfully and tan to load it from staging tables to PeopleSoft tables.
• Configuration and Customization of teh Approval Workflow Engine (AWE) wifin PeopleSoft Expenses
• Worked on teh PeopleSoft AR module which included customization of panels through Application Designer and teh writing SQR reports and processes. Oracle SQL and PL/SQL tools were used.
• Build Crystal, nVision and SQR reports for BI, AR, GL module.
• Involved in designing System flow & logic flow and documentation
• Involved in functionality and GUI testing.
• Involved in teh Analysis, Design, Development and Testing of teh whole Project
• Moving teh Data from teh old system to teh new system.
• Testing teh whole project
• Analyzing requirements and designing teh systems database designing, Implementation and maintenance.
• Involved in development of Public health and Income Tax modules
• Converted modules from Cobol to VB
• Converted data from rmcobol data files to Oracle database using SQL Loader.

Environment: Visual Basic, Oracle, Windows NT, Sco UNIX, Rm COBOL.