SUMMARY:

• More than 8yrs. of IT experience at various levels,I n a highly competitive and challenging environment that stimulated and encouraged constant learning on the job and at the same time demanding creative & innovative skills of the highest order.
• The range of responsibilities held, have demanded me to draw upon my interpersonal skills, objective thinking and ingenious approach and co - ordinate with various functions to accomplish the goals & grow from a Junior analyst to Techno-functional Lead.
• Excellent in establishing interface between HCM and downstream system using the SSIS (SQL Server Integration Services) packages
• The range of responsibilities held, have demanded me to draw upon my interpersonal skills, objective thinking and ingenious approach and co-ordinate with various functions to accomplish the goals & grow from a Junior Engineer to Sr. Consultant/Lead.
• Experienced working with flexible schedule to accommodate global business users across time zones and ability to provide leadership/support to both Offshore/Onshore Teams across different US/India state locations.
• Implementation of Workday modules such as Core HR, Advance Compensation, Performance, Benefits, NA Payroll, Absence Management, Time Tracking & Recruiting, CG,TAM.
• Hands on experience in NA Payroll & Tax updates related activities
• Possess excellent skills in Fit/Gap analysis, test cases, user requirement analysis, data modeling, project management and documentation of functional and technical specifications as well as excellent communication and presentation skills.
• Experienced as PeopleSoft HCM Technical/Functional on implementation, upgrading, and migration and testing projects.
• Experience in PeopleSoft HRMS (HR/ NA and Global Payroll/TAM/Benefit Administration/ Absence Management/Employee Self Service).
• Worked on multiple PeopleSoft upgrade projects for different modules: HCM 9.0 to 9.2,and Finance 9.0 to 9.1, Applied patches and bundles using PeopleSoft Update Manager PUM images .
• Proficient in People Tools - Application Designer, Application Engine, Upgrade Assistant, Maintain Security, File Layout, Component Interface, Process Scheduler, PS Query and Data Mover.
• Development and modification of Outbound and Inbound SQR interfaces.
• Proficient in writing complex database reports and customizing PeopleSoft Delivered SQR reports.
• Working Experiences in Databases like Oracle, SQL Server and DB2.
• Involved in documentation of technical specifications and developing test cases.
• Involved in full length Life-Cycle implementation of PeopleSoft modules.
• Leverage experience in Workday HCM Full Life Cycle Implementation.
• Worked individually, as well as in team environment, to achieve project goals.
• Good Conceptual understanding of various PeopleSoft Applications.
• Implementation of Workday modules such as Core HR, Advance Compensation, Performance, Benefits, Time Tracking & Recruiting, CRM
• Good communication, interpersonal, analytical and problem-solving skills.
• Effective Team Player and an individual contributor with steep learning curve.

TECHNICAL SKILLS:

ERP: PeopleSoft 9.2/9.1/9.0/8.9 , PeopleSoft HCM 9.2 PUM 18

People Tools: 8.54/8.55/8.56

Modules: HR, Payroll, Benefits, Benefits Administration,NA Payroll, Core HR, TAM

Development Tools: Application Designer, Application Engine, Core HR, People Code, Process Scheduler, Data Mover, Component Interface, Application Messaging, Integration Broker, STAT.

Reporting Tools: PS/ query, SQR, Crystal reports.

Languages: People Code, Java, C, C++, PL/SQL, HTML, XML Publisher

Operating System: Windows XP/2000/NT/95/98, UNIX.

RDBMS: Oracle 9i, 10g, Ms SQL Server, DB2.

Applications: Visio, MS Project, MS PowerPoint, MS Word, MS Excel, Adobe Photoshop, Test Director, HP Quality Center testing tool, Remedy.

FUNCTION SKILLS:

• Incident Management
• Team Management
• Support and Maintenance
• ITIL
• Application Development
• Production Support

PROFESSIONAL EXPERIENCE:

Confidential, SC

Peoplesoft Techno-Functional Consultant

Responsibilities:

• Working on PeopleSoft Asset Management, Inventory, eProcurement, Invoice, Billing, AR, AP, Purchasing, GL, Grants, NA Payroll, Benefit Admin, Core HR modules.
• Working on Integrations between Time &Labor, Expenses, Service Procurement, GL,Accounts Payable, Inventory, Purchasing, Grants.
• Working with Functional, Testing, PS Administrators, PeopleSoft security, Change management teams during complete software development lifecycle using Waterfall methodology for new production support, and Agile methodology during development & implementation of custom functionality.
• Transformation of how processes are efficiently managed in a new 9.2 environment. Work involved taking this implementation through proof of concept and then guide client until it is fully implemented.
• Working on requirements, fit gap, design and configuration of PeopleSoft CRM, GL, GM, AR, BI, AP, Grants Management, Inventory, eProcurement modules.
• Major work includes fit-gap analysis, designing functional and technical specification documents for various financials modules such as CM, Grants Management, AP, AR, BI, GL, AM
• Involved in the modification of pages/components and validating the data fields using People Code.
• Extensively used PS Query to develop various queries based on User requirements.

Environment: PeopleSoft HCM & FSCM 9.2/9.1, PeopleTools 8.54/8.56, TOAD, Oracle 10g/11i, SQL, PL/SQL, UNIX, Windows XP.

Confidential, Farmington, CT

Workday /Peoplesoft Business Analyst

Responsibilities:

• Hands on experience in full cycle of Workday Implementation - from the discovery phase to Project planning, Designing, Developing and Implementing interfaces (Workday Confidential, Recruitment, Payroll, Compensation, Time Tracking, Benefits) with other internal and external systems.
• Worked along internal HR and Business stakeholders to identify requirements, design enhancements and functionality to meet organization requirements.
• Unified with Human Capital Management, NA Payroll, Core HR, CG, TAM, Absence Management, and Project and Work Management.
• Defined business processes and Proposed new or improved processes by Functional analysis with validated new processes with the business process owners.
• Worked on complete cycle of Compensation (Compensation Criteria, Plans & Grades), Configuring Security to the employees in an organization.
• Analyzed change and update requests, Coordinated the execution of tests and integration within the module.
• Worked with internal HR in taking the requirements and doing the data entry for several scenarios.
• Worked on creating Workday Reporting writing for the compensation project like Budget Allocation, Bonus Allocation, Stock Allocation, Red Flag reports and complete compensation planning list reports.
• Participate in local and regional Workday module review session, requirement gathering session, facilitate requirements meetings, development walk through, and user acceptance testing sessions with the client.
• Analyzed the functionality of Time and attendance pages, components, records and menus. Tested the functionality of Time and attendance workflow related to payroll.

Environment: PeopleSoft HCM & FSCM 9.2/9.1, PeopleTools 8.54/8.56, TOAD, Oracle 10g/11i, SQL, PL/SQL, UNIX, Windows XP.

Confidential, Hopkins, MN

Peoplesoft Lead

Responsibilities:

• Involved in Resolving day-to-day production tickets in HR and Payroll/Absence management.
• Involved in fit-gap analysis, compare reports between Vanguard and Enterprise HR and payroll modules.
• Built custom functionality to produce the related content frame from HCM and show the under the ESA page using iScript. This functionality helps the user to apply the leave in HCM while associate entering the Timesheet in ESA.
• Upgraded SQR’s, People Code to 9.2 based on 9.0 customizations.
• Hands on experience in NA Payroll & Tax updates related activities
• Retrofitted HR and Payroll and Absence managementbased on new requirements and customizations.
• Created customized Application Engine programs based on user requirements.
• Wrote People Code to customize the delivered objects for HR records.
• Worked on several customs Table Audits and created Test scripts for functional test.
• Suggested and fixed the Payroll Interface COBOL time-out issues related to PI INRUN App Engine.
• Configured and maintained all the tables involved in Payroll processing, such as Pay calendar, Job Code, Deductions and Processes such as Pay sheet creation, PayCalc, Pay confirm, Tax Tables etc.
• Involved in running weekly and biweekly payroll with functional team and error solving.
• Involved in sending payroll deduction information to 3rd party vendors.
• Applied tax updates 08C to 09E and Retrofitted customizations after each tax update.
• Applied ADP patches to PeopleSoft.
• Involved in adding new pay groups to all the customizations.
• Involved and identified Uni-code problem in data, which crashes the COBOL procedure called by the Payroll Interface.
• Wrote custom error messages on Benefits records and pages to hide beneficiary information based on different Plan Types.
• Retrofitted several views to carry forward 8.8 customizations to 9.0.
• Worked on Data Mover Scripts (DMS Scripts) on HR and Benefits tables to validate in different environments
• Hands on experience in NA Payroll & Tax updates related activities.
• Design and development of new/modify existing integrations using EIB, Document Transformation, Core connector, Workday Studio for Workday HCM and Payroll modules
• Created Run Control Pages, Components and Records and attached them to required menus through Application Designer and made them available to various operators through Maintain Security to have the reports run under Process Scheduler.
• Created Unit test scripts to test the business functionality for the delivered code based on the requirements.
• Worked on PeopleSoft Security by creating and testing user roles and permission list.
• Involved in the testing phase of the Application by setting up the test cases.

Environment: PeopleSoft HCM 9.2/9.1, PeopleTools 8.54, Core HR, TOAD, Oracle 10g/11i, SQL, PL/SQL, STAT 5.2, UNIX, Windows XP.

Confidential, Detroit, MI

Peoplesoft Lead

Responsibilities:

• Performed Production Support, enhancements and customizations of PeopleSoft HRMS(NA Payroll, Benefits, Eperformance, Absence Management, TAM, CG, Time & Labor)9.2.
• Resolved issues with HR and benefits reports and interfaces, by correcting the logic and making necessary modifications as required to the SQR programs.
• Developed a new SQR to pull records of terminated employees and inserts into a table. Also created script and attached it to the batch process to run the SQR nightly.
• Created new Pages, Components, Records and Views to implement the functionality of Delegation in Manager Self Service.
• Created Roles for Delegate to access only delegate pages like Job Change Request, Approve and Status.
• Developed an interface between HCM and OCS (Office communicator system) to send the leave request to managers for approval and to get the approval status from OCS
• Modified People Code by displaying the Managers name and emplid for all the delegate Job change Request, Approve and Status pages.
• Created Workflows to send emails for both Delegation and Job Change Request sections in Manager Self Service.
• Modified Application Engine programs and processes (SQL and Application Engine People Code) based upon business requirements.

Environment: PeopleSoft HCM 9.1/9.2, People Tools 8.49, TOAD, Oracle 10g, SQL, PL/SQL, STAT 5.2, UNIX, Windows XP.

Confidential, Plano, TX

Techno-Functional Consultant (PeopleSoft)

Responsibilities:

• Involved in running the PS Delivered Application Engine process for data conversion from our current version to the newer version.
• Involved in maintenance of HR, Benefits, Payroll and eApps.
• Created new and customized existing Record definitions, Pages, Components for the client specific functionality.
• Configured and maintained all the tables involved in Payroll processing, such as Pay calendar, Job Code, Deductions and Processes such as Pay sheet creation, PayCalc, Pay confirm, Tax Tables etc.
• Customized and modified ePerformance, eCompensation, eRecruit pages upon user requests.
• Built custom configuration pages to the users to be able to add items that are used in ePerformance documents.
• Modified Custom 8.3 SQR's into PeopleSoft 8.9 standards as per field name and record name changes.
• As part of the leave accrual customization developed online page for vacation requests. Developed an App Engine program that sends vacation hours to Payroll and e-mail about the request to the manager. eProfile -Added workflow so that whenever a user changes his/her name or address, a work list is created for his/her supervisor’s approval and once approved, an email notification is sent to both, the user and the supervisor.
• Created new Application Engine & Component Interface program to move employees from some of the Job codes to another Job codes to make them qualify for new Pay Rate increase.
• Developed new Application Engine programs and also customized existing Application Engine programs for TIME REPORT CODE for TIME&LABOUR (PS TCD INTERFACE).
• Identified the new functionalities introduced in HCM 9.1 which has impact with the current functionalities used in HCM 8.9. Hence created new processes to in corporate the new functionalities into the old competency process without any data loss.
• Used STAT for all versions of your PeopleSoft objects (including non-application designer objects) AND flat files (including COBOL, SQR, SQL, nvision, Crystal, SQL scripts, etc.,) are versioned and stored indefinitely in the Stat repository.
• Involved in Data Conversion for payroll from external system using SQR and Application Engine.
• Fixed any inconsistencies among the database objects before initiating the upgrade process using the initial Audit Reports.
• Created SQR reports like Service Award Report, Special Income Reports, Applicant Data Flow Report, Audit for FSA Deduction Report for HR, Benefits and Payroll.
• Developed SQR programs to synchronize vendors between the PeopleSoft HRMS payroll system and the PeopleSoft AP system.
• Used Process Scheduler to schedule various SQR’s programs.
• Developed the Application message to be triggered to update the tables in HRMS, when there is a change made to Financials Business unit data.
• Designed and Developed Inbound Interfaces and processing procedures for processing and Loading Employee Benefits, Deferred Compensation, Loan and 401K Contributions and Vacation Buy and Health & Welfare information into PeopleSoft Tables.
• Involved in Unit Testing for all upgraded SQR programs and tuned them to resolve performance base issues related to them.

Environment: PeopleSoft HRMS 8.9/9.1, PeopleTools 8.42/8.48, SQR, PeopleSoft HCM 8.9, TOAD, ORACLE 10g,STAT 5.3, SQL PLUS 9.0.1

Confidential

Senior Analyst

Responsibilities:

• Performed functional analysis and gather business requirements
• Analyzed requirements to apply system solutions to business problems
• Created prototypes for new designs and walk through with business owners
• Developed functional specs for special projects, data flow diagrams flow charts and functional mapping for automated solutions in support of business process operations and functions
• Documented system enhancement proposals, outline issues, alternatives and provide recommendations detailing performance, costs, scheduling, time and benefits
• Reviewed functional specs with business sponsors for approval.
• Developed configuration design documents for all the special projects.
• Developed migration scripts for the configuration data.
• Spearheaded unit and system testing of special projects.
• Developed test plans for system and User Acceptance testing.
• Established test entrance/exit criteria.
• Executed system and integration testing of all the special projects.
• Prepared test completion report.
• Interfaced regularly with customers at various levels.
• Trained business users and provide go-live support.

Confidential

Functional Consultant(PeopleSoft)

Responsibilities:

• Captured prioritized business requirements from business process owners.
• Working sessions with business process owners to demonstrate application capabilities related to Talent Acquisition Manager and Candidate Gateway.
• Carried out fit-gap analysis based on the business requirements gathered
• Reviewed fit-gap document with business process owners.
• Developed functional specifications based on the gaps identified.
• Integrating Talent Acquisition Manager with Payroll for North America for Employee Referral Program.
• Analyzed impact of custom process for job opening and offer approval processes, new hire contract administration, absence recording & racking, car management among others.
• Prepared data conversion plans and developing data maps for conversion into 8.9 systems.
• Prepared the configuration design document and completing configuration of the systems.
• Lead testing efforts for all the systems being rolled out by developing comprehensive test plans, test scripts and test cases
• Carried out functional testing of all delivered and custom functionality
• Tracked defects and retesting following resolution.
• Prepared test completion report.
• Setting up user security profiles for the merged entity.
• Gathered functional requirements and prioritized for application enhancements.
• Acted as a liaison between the business community and PeopleSoft Support Team
• Study of different interfaces.
• Documented, tested, and oversee all business processes within the modules.
• Prepared and executed test scripts and sign off on changes to production environment.
• Interacted and assisted Tech Team to modify interfaces to convert legacy Asset data to PeopleSoft Asset Management.
• Designed Purchasing workflow process.
• Troubleshoot GL Journal Edit issues.
• Worked with Business unit, setup Ledger.