SUMMARY:

• Over 8 years of extensive Techno Functional experience in PeopleSoft HCM ( 8.x, 9.1) & FSCM (8.x, 9.0) in Implementation, Upgrade, Customization, Testing and Production Support experience in PeopleSoft modules like Core HRMS, Work Force Administration, NA Payroll, Benefits Administration in HCM application AR, AP, PO, GL, BI and EPROC in FSCM application.
• Expert level experience with tools like (Application Designer, PeopleTools, Peoplecode, Applications Engine, Component Interface, Integration Broker, XML publisher, Upgrade Assistant, AWE, Process Scheduler, SQR and Crystal Reports.
• Strong Functional, Extensive knowledge of Table structures of all the Control tables as well as transactional tables of all the different PeopleSoft modules in HCM & FSCM.
• Strong Expertise in Implementation, Upgrade, Data Conversion from Legacy to PeopleSoft Applications including data mapping, File Layout, Data mover, SQR, SQL, development & support of Interfaces from module to module and legacy to PeopleSoft Modules.
• My experience spans all phases of software development life cycle (SDLC) development in projects.
• Worked in a very large complex systems in every phase of project management (Requirement analysis, design, Technical & functional specifications, Coding, Implementation, testing (unit testing, system testing & Integration testing), Production support & Help desk for issues log and maintenance.
• Experience in automated testing tools like Mercury suite of Tools (QTP, HP Quality Center).
• Expert in documentation of quality based process approach like preparing Design Documents, Presentations using PPT, Weekly Reports, Traceability Matrix, Code Review Documents, Unit Test Plan and System Test Plan etc.
• Expert in PeopleSoft Testing which involved development of test cases, test scripts and User Acceptance Testing(UAT).
• Well versed with Debugging tools like PC debugger and AE trace for troubleshooting and good experience in SQL queries.
• Strong documentation and Methodology skills with proven delivery of quality work on Customizations of code etc.
• Extensive experience in preparing User manuals & demos with excellent oral / written communication and interpersonal skills.
• Highly developed organization skills with the ability to prioritize and multitask.

TECHNICAL SKILLS:

Applications: PeopleSoft HRMS (8.8, 8.9, 9.1) & Financials (8.4, 8.9, 9.1)Development Tools: People code, People Tools, Application Engine, Application DesignerReporting Tools: SQR, Crystal Reports, PS Query and Tree Manager

Third Party Tools: Kronos, Remedy

Testing Tools: QTP (Quick Test Professional), HP Quality Center, Load Runner

Languages:: C, C++, COBOL and SQL.

Integration Tools: Component Interface, File LayoutRDBMS/GUI: Visual Basic (5.0, 6.0), Oracle7/8.x, PL/SQL, DB2/OS390MS SQL Server (6.5), JDBC, ODBC and MS - Access

Databases:: Oracle, DB2, MS-SQL Server

Operating Systems: Windows (XP, 2000, NT)

EXPERIENCE:

Confidential, Bentonville, AR

PeopleSoft Techno-Functional Consultant

Responsibilities:

• Handling all severity tickets on the PeopleSoft application to run the business.
• As a Techno functional worked on FSCM (AR, AP, GL, BI) and PeopleSoft Financials 8.9 Development and Production support.
• As a Techno functional worked on HCM (Core HRMS, North American Payroll and Benefits) Development and Production support.
• Handling the PeopleSoft application technical issues, data issues, interface related issues.
• Monitoring the daily, weekly, monthly, quarterly and yearly PeopleSoft job runs and fixing it if any issues occurred.
• The requirements gathering, Co-ordination with offshore, clarifications for the offshore queries is the basic responsibilities of onsite. The basic commitment from offshore is to handle the BNR’s (Business Need Requirements) actively and estimation of the work and coding, Implementation and migration.
• The Applications was upgraded from 9.0 to latest version.
• Also there are many interfaces with other applications Remedy and Kronos for people management.
• Mostly working on the Application Engines, SQRs, PeopleCode, Component Interface, AWE, Integration Broker and Process Scheduler.
• Taking care of all Tax updates and doing fit gap analysis if any customizations involved.
• Supporting Business user team for testing Payroll run and other interface for scheduling the Jobs.
• Organizing meeting with business user for discussing about Tax update and Working closely with business user for finalizing customizations for each Tax updates.
• Studying the entire application management process, procedures, identifying areas for improvements and implementing the same.
• Ensure implementation of quality processes on all change requests implemented.
• Work Assignment and Review, Holding status and staff meetings.
• Design, development and code walk through of all code delivered from my technical team, Coordinating system, integration and user acceptance testing.
• Defining standard and guidelines, Training and Mentoring.
• Leverage my experience in HRMS and Financial domains to add more value to the project & customer through innovative ideas
• Appraising the performance of the subordinates and recommending pay hikes and promotions
• Risk identification associated with each release implementation and preparing Risk mitigation plan
• Compiling monthly production metrics and statistics (like batch failures, application outages, service interruptions, Business impact, defect tracking etc.)
• Identify the training needs, facilitate the training sessions - Training and Knowledge Management

Environment: PeopleSoft HCM v9.1,FSCM 91, People Tools v8.50, People Code, Application Engine, SQR 6.0 and SQL Server 2008 database.

Tools: People Tools, Application Designer, Kronos Applications and SQL Server 2008

Confidential, St. Louis, MO

PeopleSoft Techno Functional Consultant

Responsibilities:

• As a Techno functional worked on HCM (Core HR, NA Payroll, Benefits) Development and Production support.
• As a Techno functional worked on FSCM (AR, AP, GL, BI) and PeopleSoft Financials 8.9 Development and Production support.
• As a Techno functional worked on HCM (North American Payroll) Development and Production support.
• Create project plan for all the projects and provide effort estimations on the technical components
• The primary responsibilities are to requirements gathering, estimation, design, development and code walk through of the deliverables in People Tools like Application Engine, SQR, Data Mover, File Layout, People Code, Component Interface, Integration Broker and Workflow.
• Also Coordinating system, integration and user acceptance testing.
• Performance tuning of the SQRs and Application engines.
• Studying the entire application management process, procedures, identifying areas for improvements and implementing the same.
• Co-ordinate with the offshore project team on project tasks and resource planning.
• Identify the training needs, facilitate the training sessions - Training and Knowledge Management
• Identifying priorities in consultation with the client and changing the schedule
• Ensure implementation of quality processes during all the stages
• Conduct weekly status meeting with client Management team
• Conduct Team Meetings on the project issues, manage issues and resolve issues
• Organize and Participate in strategy meetings with Client Executive management team
• Leverage my experience in HRMS and Financial domains to add more value to the project & customer through innovative ideas
• Appraising the performance of the subordinates and recommending pay hikes and promotions
• Compiling monthly production metrics and statistics (like batch failures, application outages, service interruptions, Business impact, defect tracking etc.)
• Identify the training needs, facilitate the training sessions - Training and Knowledge Management
• Expert level skills in Application Engine, Component Interface, EXCEL to CI, SQR, People Tools, PeopleCode, Integration Broker, Data Mover, XML Publisher
• Worked as a Technical resource for Peoplesoft HCM 9.0 Implementation Project.
• Extensive Experience in XML publisher generated many reports including Internal / External Positions, Job applicant forms and Job code/ Position Descriptions for Union as well as non Union Employees.
• Full Sync of Personal /Job data to PeopleSoft Financials.
• Query Training to Users.
• I worked on Reporting tools like nVision, PS Query and XML Publisher.
• Involved in Unit test, system test and end to end test and created test cases, trained the users at several stages of the data and solved several HR payroll Issues etc.
• Production support for HCM and Financial modules, receiving the Issues from the ITSM Issue Log system, analyzing the requirement providing the details along with the screen shots to the users. Customizations, design, coding and unit testing, migrations to the database and test cases for the UAT user Acceptance test and system testing and end to end testing.

Environment: HRMS(9.1), FSCM(9.1), People Tools (8.49.09), Database server Oracle 11g, Application Server Bea Tuxedo 9.1, web server Oracle Application Server 10GR3, Red, People code, App engine, workflow, Component Interface, Xml Publisher, Query, SQR, and Crystal reports, Performance & Tuning

Confidential

PeopleSoft Techno Functional Consultant

Responsibilities:

• Worked on HCM 9.0 (HR, Benefits, Payroll, Time & Labor ) and Peoplesoft Financials 9.0
• Involved as a Techno Functional Consultant in Peoplesoft 9.0 People tools 8.48.09 HR, PAYROLL,BENEFITS and Time & Labor Modules end to end Implementation.
• As a Techno functional Consultant involved in all the Fit/Gap analysis sessions with SME users in all the modules, documented the Gaps along with available peoplesoft functionality created functional specifications for the customizations in HR, BENEFITS, Payroll & Time &Labor modules, Peoplesoft Financials.
• Data Conversion from Infenium to Peoplesoft 8.9 HCM Modules
• Involved in fit/Gap analysis for Peoplesoft HCM 9.0 and Financials 9.0 versus Banner Financials etc.
• Data Conversion from Infenium HR systems and Banner Financials system to Peoplesoft 9.0 HCM Modules and Financial modules AP, PO, AR and GL.
• Worked on several IN bound and OUT bound Interfaces including Ben Admin vendor Interfaces with med, dental providers.
• Involved in Fit/Gap analysis sessions with the Super users and SME of each module, finding the gaps in the reports and support the development and testing of the reports and report roll-ups.
• Created many Application Engine programs and Component Interfaces CI, Flat files, SQRS for various data validations and loading the data into staging tables.
• Worked Extensively on various functional area of within the scope of the project including Workforce administration, Template based Hire, Partial position Management, Temporary Assignments, salary administration, pension able earnings, non calendar year Leave accruals, Bolt on, Time &Labor rules, pension adjustment calculations, Deemed hours calculation and changes in employee self service TAM, epay, eprofile, eperformance etc.
• Infenium data validations, data mappings, Translate values, Prompt values, developed many SQRs, SQLs, scripts for data validation purpose and end to end testing.
• As a techno Functional consultant created and modified lot of people code programs, Component Interfaces, Application Engine programs, File layouts, crystal reports, SQR reports and many ad hoc Query reports.
• Worked on peoplesoft security from the scratch and also supported as a backup for system admin to take care of DEV and TEST environments including administering App server, web server and Process scheduler and setting up nodes in Integration broker for reports distribution, data mover scripts etc.
• Worked on several IN bound and OUT bound Interfaces including Direct Deposits, Parking extract, Active Directory extract, Kronos extract and Time & Labor spread sheet upload interfaces.
• Involved in Unit test, system test and end to end test and created test cases, trained the users at several stages of the data and solved several HR payroll Issues etc.
• Production support for HCM and Financial modules, receiving the Issues from the Issue Log system, analyzing the requirement providing the details along with the screen shots to the users. Customizations, design, coding and unit testing, migrations to the HRTEST database and test cases for the HRUAT user Acceptance test and system testing and end to end testing.
• Creation and maintenance of technical documentation relating to Data conversion, Customizations, Reports, Interface development including Design documents, Operation Manuals and Presentations.
• Involved in Peoplesoft back up for Security Admin for HRDEV, HRTEST and HRUAT and parallel data bases databases and including row level security SJT refreshing etc.

Environment: HCM (9.0), People Tools (8.49), Database server Oracle 11g, Application Server Bea Tuxedo 9.1, web server Oracle Application Server 10GR3, Red hat Linux, People code, App engine, workflow, Component Interface, Xml Publisher, Query, SQR, and Crystal reports, Performance & Tuning.

Confidential

PeopleSoft Techno Functional Consultant

Responsibilities:

• Worked on HR, PAYROLL, BENEFITS, Accounts Payables (AP), Requisitions and eProcurement modules.
• Worked on Performance Tuning and Indexes on customized and related SQRs, App engine programs, Payroll to AP and GL interfaces and SQLS etc.
• Created and modified Existing App Engine Programs, used set processing, Temp tables for Parallel Processing for better performance etc.
• Worked extensively on Peoplecode, Peopletools, SQRs, Query tool, Crystal Reports, App Engine SQLs, Batch Jobs, Scripting, Application Designer, Tree manager and Security etc.
• As a Techno functional Resource worked on many Productions support Issues in Benefits and Payroll and Related Interfaces and worked extensively on VCNY customizations to resolve many functional Issues etc.
• Worked on security related Issues and Roles and work list errors related to workflow etc.
• Created many SQRs reports, crystal reports and Queries in Payroll, administer benefits and HR according to the user requests and requirement.
• Worked extensively on Technical related Issues in SQRs, Peoplecode, Crystal Reports, Applications Engine and Data mover.
• Involved as Techno Functional Resource Implementing the Customizations and documentation.
• Implemented Multi Currency, VAT and Unicode Functionality depending on the Region and BU
• Involved in QA Testing including Unit Test, Preparing and modifying Test cases for customizations, System Integration test, User Acceptance Tests and Documentation etc.
• Involved in Upgrade from PeopleSoft HRMS 8.8 to 8.9, integration testing and user acceptance testing.
• Involved in Debugging, troubleshooting and production support for all the Issues after upgrade.
• Created training Documents for HRMS, Payroll, Benefits modules for the users and given demo to users and security.
• Created a training document for each HRMS process and given demo and solved many issues on those processes.
• Solved the Issues related to eprocurement, billing Interface and Legacy data SQRs, flat files and BI, CA Xref tables data related problems etc.
• Solved the Requisitions maintenance Issues related to Kit and Ship to Id and INS6500 and related SQRs etc.

Environment: Financials (8.9), PeopleTools (8.44), Peoplecode, App engine, Query, SQR, Application messaging, component Interface, workflow, Crystal reports, Performance & Tuning, Oracle8i Enterprise Edition Release 8.1.7.1.0 - 64 bit Production, Windows XP and UNIX server.

Confidential

PeopleSoft Techno Functional Consultant

Responsibilities:

• Worked extensively in HRMS, PO, AP, AR and GL. Projects Structural and Transactional data Conversion from Legacy to PeopleSoft for Different countries (USA, CANADA, UK).
• Prepared Projects Structural and Transactional Technical Design Specifications and File Layouts for GFIS data Conversion.
• GL Conversion from Legacy from various Finance and Accounting systems for each GLBU.
• Involved in Functional Design Specification and Configuration for GFIS data Conversion.
• Customization of Peoplecode, SQRs, Existing Applications Engine Processes and Reports etc.
• Analysis, Design, Prepared layouts and Coding to handle different Transactions sent by each country and by GLBU including LAB rows, Expense rows, Revenue expenses, Admin surcharges
• (Hours, Fees, Expenses and Taxes), FEE adjustments and ERP reserves for ETD and YTD by Engagement and by person.
• Worked on Peoplecode, Peopletools, SQRs, and Query tool, Crystal Reports, App Engine SQLs, Batch Jobs, Scripting, Application Designer, portal Technology, Tree manager and Security etc.
• Receiving Lockbox Deposits modified the AR25001 according to the received files and worked extensively on Payment Interface ARPAYLOAD, Deposits and error corrections etc.
• Generating AR Reserves for different GLBU by AR to PC Interface for different GLBU etc.
• Involved in Peoplesoft Upgrade from version and patches, Customizations etc.
• Worked extensively on Upgrade Issues, production supports Issues and Customizations.
• Unicode Conversion, Customized all the Interfaces and GL, Hyperion Essbase Reports etc.
• Employee data Conversion, HR repository and STDHR creation for each country etc.
• Developed different SQR programs for Projects Module like Format checker to check for correct format of Projects Conversion data sent by Countries, Unload programs to unload the Conversion data into Temp tables and Load validate Program which validates all the Business rules and Xlats, Customizations and Population rules of Projects Module etc.
• Calculating Direct Costs, Overhead Costs and generating Revenue Recognition rows for ERP (Estimated Realization Percentage) rows and Revenue Calculation for all the Projects for Each country.
• Generated different Reports for the Projects Module for Data conversion Reconciliation purpose.
• Converted Legacy data into PeopleSoft for HRMS Modules from DELTEKs, PRISM to PeopleSoft.
• Budget processing - GL and the Planning system (Hyperion Essbase) interface in both directions.
• System Testing and performance tuning etc.

Environment: PeopleSoft HRMS (8.13) Financials (8.4), PeopleTools (8.40.07), Peoplecode, App engine, Data mover, Query, SQR, and Crystal reports, PL/SQL, Database Analysis, Performance & Tuning, SQA Robot, DB2/OS390 Server agent, Oracle 8i,Oracle (Unicode), WinNT and UNIX server.

Confidential

Developer Analyst

Responsibilities:

• Involved in Peoplesoft Financials Upgrade from version 7.5 to 8.12
• Involved in General Ledger, Accounts Payables, Purchasing, AR, Billing and Projects modules Upgrade, customization and Production Support.
• Worked extensively in Test and make Adjustments Phase, SQRs, Peoplecode, Applications Engine etc.
• Setting up GL tables, Calendars, Ledgers, Creating Journal templates for each Company and for each Business Unit (About 20 BUs), Supporting Muticurrency and Defining Business rules.
• Performed People Tools upgrade from version 7.5 to 8.42 and also Converted SQR's and Crystal reports.
• Involved in testing the application after upgrade from 7.5 to 8.4, customized AppEngine, pages, Peoplecode etc.
• Performance Tuning and Trouble shooting of different SQRS related to AP, PO, AR, GL, BILLING and PROJECTS Modules.
• Production Support and modified AP, PO, BI, PC & GL reports to handle Multi Currency.
• Data cleanup, Solving Upgrade Issues, Coordinating with users on different production Issues, Analysis, and data scripts etc.
• Modified the Interfaces to GL for customizations, AP Drill down Nvision, Modified related GL Reports, Trouble shooting, night production Support for nightly batch jobs like Matching, Voucher post, payment post, PO, PORECON, AR and BI processes etc.
• System Testing, Integration testing for new Business units and performance tuning etc.