SUMMARY

• Over 11 years of extensive Techno Functional experience in PeopleSoft HCM (7.x, 8.x, 9.1,9.2) & Financials (8.x, 9.0) in Implementation, Upgrade, Customization, Data Conversions and Production Support.
• Very Strong Technical Experience in PeopleSoft FSCM & HCM (PeopleTools, Peoplecode, Applications Engine, Component Interface, Integration Broker, XML publisher, Upgrade Assistant, Change Assistant, application messaging, Integration Broker, SQR, nVision, Crystal Reports and Hyperion financial 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.
• 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.
• Worked with client companies including CGEY, Confidential & Young, EDS, Accuent, PeopleSoft, and Confidential etc.
• Extensive Technical Experience working in HCM & FSCM Peoplesoft PIA architecture, Installation of peoplesoft 9.0 and configuring App server, Web server, Process scheduler, migrations, fixes and patches, data mover, in red hat Linux using Putty as well as windows with backend Oracle 11g as well as SQL server environments and Upgrade Assistant, Interface, Application messaging and Portal Technology etc.
• Strong documentation and Methodology skills with proven delivery of quality work on Customizations of code etc.
• Experience in applying Fixes/Patches, system upgrades and Tax updates to PeopleSoft Applications, SQR and COBOL Programs.
• 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

ERP: PeopleSoft HRMS (8.8, 8.9, 9.1) & Financials (8.4, 8.9, 9.1) People code, People Tools, Application Engine, SQR, Component Interface,Integration broker, messaging, Business Interlink, Upgrade Assistant, Crystal reports and nVision. Application Designer, Security Administrator, Workflow Administrator, Data Mover, XML publisher, nVision, Portal Technology and, TCP/IP, SOAP, WSDL, XSLT.

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

RDBMS/GUI: Power Builder (5.0, 6.0), 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, Informix and Essbase.

Operating Systems: Windows (XP, 2000, NT), UNIX.

PROFESSIONAL EXPERIENCE

Confidential, NY

Lead PeopleSoft Techno Functional Consultant

Responsibilities:

• As a Techno Functional resource worked on HCM 9.1 (Core HR, NA Payroll, Benefits, Time and Labor) Implementation, Data conversion and Production support for Confidential Clients.
• On Behalf of Confidential we support many clients from USA as well as CANADA like HSBC, Van Guard, Washington Post, Clear Channel and Masco etc with HR, NA Payroll, Taxes, Garnishments administration, Absence Management, Pension management,Time and labor and also support the clients with Rimini Street.
• Analyzing and understanding the Requirement document for each release, conducting the WEBEX sessions to finalize the requirements with in scope and out of scope for each release and the time lines for Functional, technical and testing phases etc.
• Creating the Functional design specs including main test scenarios and results prototype with screen shots sending for client approvals, Creating the Technical design Documents and impact analysis, coding, validations, creating the test scenarios, creating the Test plan with all the possible positive and negative test cases, unit testing, regression testing in PeopleSoft 9.1 and 9.0, 8.9 versions with DB2 as well as Oracle and SQL Server databases including comparisons of before and After screen shots, test results for each test case and sending test results to the User for their UA test, receiving the approvals from the user and sending the result XML extracts to Confidential SDM for approvals, Update the User Guide, Installation guide and Creating the Confidential Release notes for the particular release then creating the Package sending to Confidential and production support for the Release.
• Production support includes going through the SHARE Issue log acknowledge the issue to the client with details, creating test scenario and testing, finding the solution, if not able to replicate the problem then requesting the WebEx meeting to understand and analyze the Issue, finding the root cause of the particular Issue resolving the Issue or finding work around solution for temporary fix and also resolving setup issues depending on the particular Ticket.
• Reviewing, understanding and analyzing the Impact analysis of each Tax update release notes, documenting the Issues sending to Confidential for approvals / suggestions etc.
• Expertise on all the people tools including people code, SQRs, Data mover scripts, App Engine programs, Component Interfaces (converted all the JOB data, Personal data ), Excel to CI, XML publisher, Integration broker for HR to Finance.
• Expert level Functional skills in Core HR control & foundation tables related to Business units, table set sharing, establishments, locations, departments, compensation, Jobs and Pay groups.
• Worked extensively on Base Benefits including but not limited to setting up Leave plans, savings plans, pension plans, changing benefit programs and employee enrollments etc.
• Expert level functional skills in NA Payroll, thorough expertise on all the payroll related tables, flow of the payroll data, audit reports, resolving the payroll error messages, setting up data and creating test cases and testing for new tax classes including Tax Class 6, Tax class 7, Other wages, FUTA, PA ACT 32, all the Tax updates till 13 C and Garnishments, implementing the new garn rules delivered by tax updates, resolving the errors in garnishment calculations and Year ending processes etc.
• Creating Functional design documents, test cases, test scenarios in test and UA databases, validating the technical design documents according to the functional design specs, interacting with users, security setup for users in UA data base, creating the user manual for each new functionality with detailed navigation and testing procedures till the generating the reports.
• 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, Benefits, Time & Labor, Absence management, Pension Management and Payroll Issues etc.

Environment: HCM (9.1), People Tools (8.52), Database server DB2, Oracle, SQL Server, 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 (Project Analyst)

Responsibilities:

• As a Techno functional worked on HCM 9.0 (Core HR, Payroll, Benefits, Time and Labor) and PeopleSoft Financials 8.9 Development and Production support.
• Expert level skills in Application Engine, Component Interface, EXCEL to CI, SQR, People Tools, PeopleCode, Integration Broker, Data Mover, XML Publisher
• Peoplesoft HCM 9.0 -> IWAY -> AD -> CSP Integration.
• Worked as a Technical resource for Peoplesoft HCM 9.0 Security Implementation Project.
• Query by Link Project.
• Requirement Gathering from users and designed and developed many reports to support Users including Budget Report, Department Staffing Report, New OMERS Pension Eligibility extract, STD estimations Report, Pay line Audit Report, Employee Payroll Deduction Audit, Time entry Audit Reports, Special Accumulator (bank balances), Retirement projection Queries, inactivating the Job codes scripts and process, Employees on leave report, etc using SQR, Application Engine, Crystal reports and XML publisher.
• 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.
• 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 HTST database and test cases for the HUAT user Acceptance test and system testing and end to end testing.

Environment: HCM (9.0), People Tools (8.49.09), 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 - New York

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 Peaoplesoft 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.
• Also Responsible for Data Conversion Reconciliation from Infenium to Peoplesoft.
• 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, NY

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.
• 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 Developer Analyst

Responsibilities:

• Worked extensively on Peoplesoft CRM & EPM 8.9 Modules
• 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.

Environment: peoplesoft CRM, Financials (8.9), PeopleTools (8.44), Peoplecode, App engine, Data mover, Query, SQR, and Crystal reports, PL/SQL, Database Analysis, Performance & Tuning, SQA Robot, Oracle 8i,Oracle (Unicode), WinNT and UNIX server.

Confidential, NY

PeopleSoft Techno Functional Consultant

Responsibilities:

• Worked extensively in HRMS, PO, PC-Projects Costing Module, 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, Troy, MI

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.

Confidential, FL

Developer Analyst

Responsibilities:

• Involved in Fit Gap Analysis for Upgrade to PeopleSoft Financials 8.13
• Involved in PeopleSoft 7.5 to 8.4 Financials Upgrade Implementation and production support for AM, AP, PO, GL, Budgets and Projects modules.
• GL: Implementation, Creating different Journal templates for each module, Accrual definition, payments definition and PO definition for PO module etc. Setting up Inter unit Journal Offsets (Credit and Debit Chart keys). Setting up Journal Options, Currency Options for all Business Units etc. Balancing Ledger and AP Check register and Budgets/Actual Reconciliation.
• AM: Setting up Asset management tables, Defined Locations, Account types, Calendars, Unit of measure etc. Converted all the SQRS including AS, DP, CV, AE, RT related reports, Implemented all the Customizations in Upgraded version, testing, tuning and Production Support etc. Implemented all the Customizations in AM, AP, PO and GL modules. Converted all vendor data, PO and Budgets data from Legacy to PeopleSoft 7.5 tables etc.
• AP: Implemented Matching process. Modified, customized the matching rules and App engine statements. Customized the Receiver load process. Setup AP checks, solving the problems with check printing and new setup for new bank code etc. Reconciliation of AP check Register while Implementing the AP checked all the processes Like Voucher post, Matching (two - way) and Payment post and corrected the processes for missing the entries in Voucher Accounting line for Voucher amounts related to PO’s etc.
• PO: Debug the App Engine PO RECON and modified for customizations. Modified the PO Dispatch SQR, worked on PO ROLLOVER for the year 2001/2002. Resolved the Voucher post process Issues and Implemented data Cleanup strategies for Voucher accounting table, PO line accounting table and related Journal entries in GL.
• Budgets/projects: Customized the Budget related tables for the field EXP BUD IND and modified the related statements in App engines ‘JRNLBPST’ and ‘COMMON’ in GL. Converted and modified all the SQRS, Crystal reports (delivered as well as customized) from PeopleSoft 6.0 to PeopleSoft 7.5. Modified the existing Queries and created lot of new queries according to the Client’s requirement.
• HRMS: Worked on Pay roll fiscal year ends out-processing, Leave Accrual Rollover Processing and Updates & fixes.