SUMMARY:

• Over 16 years of experience designing and developing customizations, interfaces, and reports for a wide range of clients. Extensive expertise in process automation that saves time and increases productivity of HRMS/HCM,ELM, Financials and CRM operations. Able to initiate cost - effective solutions to complex problems through creativity, analysis, and collaboration with numerous technical and business players. Highly effective communicator of technical information to Financials, Human Resources, Accounting professionals and senior management. In-depth experience in design, development and post-implementation support of HR, Payroll, Benefits, Time and Labor, GL,AP, AR, AM, PC, Time and Expenses
• CRM Sales, and HRMS/HCM and Financials e-modules like Employee Self Service, Manager Self Service, eProcurement etc.. Excellent knowledge of SQL,PL/SQL,SQR, PeopleCode, PeopleTools, Application Engine, PS Query, Application Messaging, Component Interfaces, Integration Tools, Workflow, Application Workflow Engine(AWE)/Approval Framework,XML Publisher and PS Security.

TECHNICAL SKILLS:

ERP: PeopleSoft HRMS/HCM v6.x/7.x/8.x/8.8.x/ 8.9/9.0/9.1. xPeopleSoft Financials v6.x/7.x/8.x/8.8.x/9.1.xPeopleSoft CRM 8.9/9.0, Peoplesoft ELM v 9.x,SAP.Workday,Cornerstone

GUI Tools: PeopleTools 6.x/7.x/8.x/8.4.x/8.5.x, Crystal Reports, Developer 2000, Designer 2000, PowerBuilder, Banner 2000 and Visual Basic.

Languages: Peoplecode, SQL, PL/SQL, SQR C, Fortran, Cobol, PRO*C, HTML, XML, Assembly Languages.

Databases: Oracle 8i/9i/10g/11g, Sybase, MS Access and DB2

O/S: UNIX, Windows, and DOS.

Other: Hyperion Essbase v10, MS Office, TIDAL, MQSeries, WordPerfect, Lotus 1-2-3, dBase III and AmiPro.

PROFESSIONAL EXPERIENCE:

Confidential, PA

Responsibilities:

• Strong technical and functional understanding of PeopleSoft Modules HCM,Financials/SCM and ELM v9.1
• Gathered requirements from the end users.
• Planned, designed, developed and implemented complex business processes and system custom modifications.
• Helped to Create complex test case scenarios for SAT,UAT and Performance testing.
• Customised the delivered functionality and developed new functionality based on the business requirements.
• Recommended different solutions/options to improve and support business activities. Improved the performance and streamlined different long running programs/reports.
• Resolved critical production issues in a timely manner.
• Used with Application Designer, PeopleCode, SQL, SQR, Query, nVision, Data Mover, Application Engine, Approval Workflow Engine, Integration Broker,
• Component Interface and XML Publisher.
• Enhanced the system functionality for company global needs.
• Helped different peoplesoft integrated teams to resolve the issues.
• Reviewing Installation Documentation, Upgrade Documentation, Release Notes, Peoplesoft Recommendations for Peoplesoft v9.2 and PeopleSoft v8.54 documentations.
• Worked on Workday and Cornerstone integrations
• Eager to learn new PeopleSoft modules, new technologies and new tools as required.

Environment: PeopleSoft HCM v9.1, People Toolsv8.5x, (HR, Payroll, Benefits, Profile Management, Succession Planning, Employee, Manager Self Service), PeopleSoft ELM v9.1, PeopleSoft Fin/SCM v9.1 SQR, Crystal Reports, UNIX and Oracle.

Confidential, Philadelphia, PA

Responsibilities:

• Gathered Requirements from the users
• Developed Specification Documents based on the business needs.
• Designed, Developed, Tested and Implemented new custom records, pages, components, and menus.
• Modified delivered records, pages, components, People Code and menus to fulfill the business needs.
• Resolved issues with version 8.9 HRMS, Employee, Manager Self Service Confidential Reports
• Upgraded/Developed Confidential Employee HR, Labor Earnings Distribution, Profile Management,Recruiting,,Compensation Reports to version 9.1
• Enhanced Confidential Custom Reports for GLOBAL parameters.
• Unit tested reports.
• Worked with the users for UAT.

Environment: PeopleSoft HRMS v8.9.x/v9.1, People Toolsv8.47.x/v8.49/v8.5x, (HR, Payroll, Benefits, Profile Management, Succession Planning, Employee, Manager Self Service), SQR, Crystal Reports, UNIX and Oracle.

Confidential, Wilmington, DE

Responsibilities:

• Gathered Requirements from the users
• Developed Specification Documents based on the business needs.
• Designed, Developed, Tested and Implemented new custom records, pages, components, and menus.
• Modified delivered records, pages, components, People Code and menus to fulfill the business needs.
• Worked on SQR, Peoplecode, People Tools, Application Engine, Query, PeopleSoft Messaging, Component Interfaces, PeopleSoft Security, Tree Manager, Report manager, Query Manager, Workflow and nVision.
• Enhanced the custom Financials and HCM Interfaces, Reports, and Processes for the new functionality.
• Worked on Self- Service Modules such as ESS, MSS, eProcurement etc..
• Enhanced the custom Crystal Reports.
• Designed and developed Interfaces to transmit data between PeopleSoft and ADP.
• Involved in Unit, System, Integration, Regression testing.
• Developed Test Plans.
• Helped the Users with UAT and Fixing the data issues.
• Designed and Developed Financials and HCM Processes, Interfaces, Queries and Reports according to the requirements.
• Designed and implemented functionality within PeopleSoft to provision report distribution and email notification driven by user’s Security roles.
• Designed and implemented custom functionality within PeopleSoft to automate scheduling and execution of batch processes within the Financials and HCM Systems; this innovative functionality helps CondeNast to ensure timely execution of the processes.
• Reviewed PeopleSoft Installation Documentation, Upgrade Documentation, Release Notes, Peoplesoft Recommendations.
• Upgraded PeopleSoft Financials from v8.8 SP1 to v9.1 and People Tools from v8.47.x to v8.5x
• Upgraded PeopleSoft HCM from v8.8 SP1 to v9.0 and People Tools from v8.45.x to v8.49.x
• Applied Fixes/Patches/Bundles/Tax Updates using Change/Upgrade Assistant tool to maintain the systems up to date.
• Involved in the Application Server, Web Server and Process Scheduler configurations.
• Tuned processes, reports Interfaces and queries for a Better Performance.
• Helped other developers to reach the Milestones.
• Resolved HCM Production issues.
• Resolved Financials Production issues.
• Resolved Payroll to GL interface issues.
• Used Integration Tools to integrate PeopleSoft and other systems.
• Helped other team members in Troubleshooting the issues.
• Helped with the Setup and Configuring the Systems.
• Helped the users to resolved the month end and year end issues.
• Documented the modifications according to the Change Control Procedures.

Environment: PeopleSoft HCM and Financials v8.8.x/v9.x People Toolsv8.47.x/v8.49/v8.5x, (HR, Payroll, Benefits, GL, AM, PC, AP, PO, AR, BI), CRM v8.9.x/v9.x,SQR, Crystal Reports, UNIX and Oracle.

Confidential, Frazer, PA

Responsibilities:

• Upgraded People Soft HCM/Financials from v8.x to v8.8 SP1 and People Tools from v8.18.x to v8.45.x.
• Applied Fixes/Patches/Bundles/Tax Updates using UA/CA tool to maintain the systems up to date.
• Enhanced HCM/Financials Interfaces, Reports, and Processes for the required functionality.
• Involved in Unit, System, Integration and Regression testing.
• Worked on eModules like Competencies, HR self Service (Employee, Manager), ePay, eComp, eRecruit.
• Worked on PeopleSoft tools like Application Designer, Security, AE, People Code, Tree Manager, Report manager, Query Manager, Integration Broker and nVision.
• Developed new records, pages, components, and menus.
• Modified Records, Pages, Components, People Code and Menus to fulfill the business needs.
• Involved in the Application Server, Web Server and Process Scheduler configurations.
• Reviewed Peoplesoft Applications and Tools Installation Documentation, Upgrade Documentation, Release Notes, Peoplesoft Recommendations.
• Tuned the PeopleSoft processes, reports Interfaces, queries for the Better Performance.
• Designed, Developed and Tested HCM Processes, Interfaces, Queries and Reports according to the requirements using SQR, PS Query, Crystal Reports, Component Interface and Application Engines.
• Resolved production issues.
• Used Integration Tools to integrate PeopleSoft and other systems.
• Helped other team members in Troubleshooting the issues.
• Helped with the Setup and Configuring the systems
• Documented the modifications according to the change control procedures.

Environment: PeopleSoft HCM/Financials v8.8.x/ People Tools v8.45.x, (HR, Payroll, Benefits, GL, AM, AP), SQR, Crystal Reports v9.0, UNIX and Oracle v9i.

Confidential, Malvern, PA

Responsibilities:

• Upgraded HRMS and Financial Systems from v7.x to v8.x
• Resolved issues with Application Engines, SQL Scripts and Data Mover Scripts.
• Gathered the requirements from the users.
• Enhanced the custom SQRs (Interfaces, Reports, Processes etc…) and Crystal Reports.
• Involved in Module Testing, Integration Testing, User Acceptance Testing and System Stress / Performance Testing.
• Designed, Developed Application Messaging between the systems.
• Created new Recurrence Definitions for batch programs and Report Node definitions.
• Worked on Maintain Security to develop Roles, Permission Lists and Users.
• Imported data using Import Manager.
• Developed Mass Changes Types, Templates and Definitions in AM and HR for Mass Changes.
• Worked on EDI Manager, Tree Manager, and Application Engine for development and enhancements for Siemens business needs.
• Designed, Developed People code, Queries, Reports and Interfaces in HR, Payroll, Benefits, AP, GL, PC, AR, BI and PO.
• Modified Payroll to GL, HR to AP Credit Card Interface and Departmental Synchronizations Interface Programs.
• Involved in the analysis of Setids, Business Units, Departments, and locations.
• Involved in the development of Custom Competencies (Employee Skills Inventory) Application to suit the company requirements.
• Involved in the Design and Development of the Workflow for Competencies, Employee Self Service, Purchasing.
• Applied Fixes/Bundles/Tax Updates to Financials and HRMS databases to maintain the systems up to date.
• Resolved the Performance related issues.
• Developed a Archiving Processes to increase the performance of the processes.
• Worked on Self-Service requirement Analysis like Employee, Manager, Project Manager, Project Team Member and Vendor.
• Developed programs for PeopleSoft to SAP conversions.
• Synchronized the User Profiles and Roles between HRMS and Financials.
• Used Integration Tools to integrate PeopleSoft and Other systems.
• Defined Security Views.
• Helped other team members in Troubleshooting the issues.
• Helped with the Setup and Configuring the systems.

Environment: People Soft HRMS and Financials v8.x (HR, Payroll, Benefits, Position Management, GL, AP, PO, AR, PC, BI), SQR, Crystal Reports and Oracle.

Confidential, Reston, VA

Responsibilities:

• Upgraded HRMS and Financials from v7.5x to v8.x SP1.
• Outlined the Hardware and Software requirements for PeopleSoft v8.x
• Identified the current business processes including online processing, reporting and interfaces.
• Managed configurations by documenting and using Change Control.
• Used Data Mover to export and import data.
• Used PS Upgrade Assistant.
• Involved in Unit, System Testing.
• Worked closely with functional resources.
• Worked on Row level Security.
• Documented the modifications.

Environment: PeopleSoft HRMS and FS v8.x (HR, Payroll, Benefits, GL, AP, PO, AM)SQR, Crystal Reports and Oracle.

Confidential, Reston, VA

Responsibilities:=

• Worked on Confidential HRMS and Financials projects as a Team Lead and received an Outstanding Work Recognition from Chief Technology Officer, Confidential .
• Worked on Departmental Security.
• Developed SQR to correct the Leave Accruals.
• Created new panels to allow managers & supervisors to approve/disapprove an employee.
• Resolved Financial and HRMS production issues.
• Developed a multi-process job to increase the performance of Payroll to GL Journal Generator Process.
• Developed new SQRs to view the Payroll to GL Information.
• Developed various SQR reports, Out of Office Time report, Aging Analysis report, Cost Transaction, Profit & Loss Trend report, Miscellaneous Cost Entry Audit Trial report etc.
• Designed and developed SQR process to create temp table and populate tree data so that queries can be created to summarize data at any tree level.
• Involved in modifying various Peoplesoft supplied Crystal Reports such as Project Estimate and Project Variance report. These reports were modified to include PS tree tables to be summarized at different tree levels.
• Created two panels for the entry of estimates. The first panel allows user to enter Labor and Material estimates and the second displays summary totals of the estimate amount.
• Developed People Code to calculate control hours for original time sheet entries.
• Modified PO print program as per user requirements.
• Developed Current Timesheet Edit Report by Department.
• Modified Time and Labor to General Ledger Interface Program to run by accounting date.
• Created New Operators and Operator Classes.
• Applied patches and recreated indexes to improve the Performance of Asset Management Depreciation Calculation Program.
• Applied Patches.
• Worked on the existing programs to improve the Performance.
• Involved in the User Interactions to Gathered the requirements.
• Designed Technical Documentation for the developers.
• Helped team members in solving the urgent issues.
• Analyzed, Designed, Developed Financials Records, Panels, Menus, Reports and Queries for the Business Needs.
• Written Test Scripts for the users.
• Documented the new functionality.
• Involved in Peer Review of the newly developed code.
• Helped other team members in Troubleshooting the issues.
• Worked on Workflow Processing and Portal Security
• Developed Manuals for the end users.

Environment: People Soft HRMS/FS v7.5x (HR, Payroll, Benefits, AP, PC, BI, PO, TLAR, GL), Crystal Reports, Oracle v8.0 and Unix

Confidential, Detroit, MI

Responsibilities:

• Developed the UNIX scripts.
• Developed and modified the PL/SQL Functions and Procedures.
• Granted the Privileges to other Schemas on Oracle
• Created Synonyms.
• Created Data Dictionary.
• Scheduled corn files to execute daily processes.
• Customized the Banner 2000 Application based on organizational needs and requirements.
• Converted data from the Legacy System to PS using SQR.
• Customized the interface programs
• Customized of existing panels/pages.
• Performed field level validations on panels/pages
• Developed Test Cases and Test Plans.
• Created the Test Requirements
• Performed analysis work to Debug the problems in programs
• Prepared the test data for testing.
• Performed Unit, Integration, Regression, System and UAT.

Environment: Oracle 7.3, Banner 2000, Developer 2000, TELNET V1.0, WS FTP95 LEMS-Access, Unix and SQR.

Confidential, Golden, CO

Responsibilities:

• Analyzed the People Soft Organizational Structure at Coors.
• Mapped the People Soft Organizational Structure to SAP.
• Designed, Developed and Unit Tested the PeopleSoft Extract Program used in the Initial HRMS Load.
• Designed, Developed and Unit Tested the PeopleSoft Extract Program used in the daily interface from People soft HRMS to SAP.
• Involved in the System Testing the initial data load of employees from People Soft HRMS to SAP.
• Involved in the System Testing the daily interface of employee data from People Soft HRMS to SAP.
• Developed an SQC procedure to compute Vacation hours.
• Developed an SQR to load Sick hours and Vacation hours once a year for all Coors hourly and salaried employees. This SQR also refreshes Leave Accrual and Leave Accrual Audit tables.
• Developed an SQR to eliminate Null values in Leave Accrual table.
• Created Coors Custom Fields and Records to fulfill business needs.
• Created Audit tables to monitor changes, data manipulated through PeopleSoft HRMS panels.
• Used Import Manager to insert Social Security numbers into a Coors custom table.
• Developed a program to Scramble Social Security numbers.
• Used Oracle Gateway and MQ Series to input messages to BDC.
• Used Dec scheduler to trigger Daily Interface Programs.
• Interacted with the end-users.
• Developed Documentation for the end user .

Environment: People Soft HRMS 7.5, SQR, Crystal Reports, Oracle 8, DB2, Oracle Gateway and MQ Series.

Confidential, CT

Responsibilities:

• Prepared documentation for hardware and software requirements.
• Discussed release notes functionally and technically.
• Created Upgrade procedures.
• Upgraded SQR, Interfaces, PS/Query, Crystal
• Made decisions on compare reports
• Developed and modified SQR reports to suit the needs of the company.
• Used Process Scheduler to make Crystal Reports, and SQRs available from within Peoplesoft and schedule various periodic reports.
• Created Run control panels.
• Involved in developing People Code according to client's requirements to satisfy business rules.
• Interface Development Profile:
• Analyzed, Designed, Developed the Interface programs to move data from People Soft HRMS to Peoplesoft Financials and other third party applications.

Environment: People Soft HRMS/Financials 7.0(HR, Payroll, Benefits, AP, PC, BI, PO, TL, AR, GL), SQR, Crystal Reports, Oracle and Windows NT 4.0.