Rakesh Singh

Current Location: Sunbury, PA

Email: ac4wc5@r.postjobfree.com

Cell: 815-***-****

PROFESSIONAL SUMMARY: Certified Techno-Functional Analyst and PeopleSoft Administrator with 7 years of experience in all stages of SDLC including business requirements gathering, design, data conversions, programming, security, system administration, system integration, user acceptance testing and documentation within PeopleSoft Human Capital Management. Technical Experience surrounding the upgrade and support of PeopleSoft Human Capital Management Modules including Core HR, Payroll, Time and labor, ELM, Work Force Administration (Version 9.2, 9.1, 8.x)

Experience in implementation, upgrade, security, writing interfaces and administration of PeopleSoft HCM.

Work collaboratively with cross-functional and project teams within HR and IT.

Lead, investigate, analyze and effectively solve problems.

Expert PeopleSoft Technical developer in Benefits, NA Payroll, T&L and core HR.

Extensive work experience with MS office suite like Word, Excel and Visio.

Experience in writing PL/SQL queries, Stored Procedures and Triggers and have exposure to different databases, includes SQL Server, Oracle, DB2.

In-depth knowledge of the PeopleSoft architectural environment

Experience using the PeopleSoft Application Packages.

Analysis, design, development, testing, installation, and maintenance of information. Works independently with limited work direction

Supported testing like unit testing, systems integration testing (SIT) and user acceptance testing (UAT)

Strong critical thinking, problem solving, negotiation and facilitation skills.

Worked with reporting and analyzing tools such as XML Publisher, Used PS/Query, Connected Query and Tree Manager for reporting purposes to fulfill company specific needs.

Specialized in data extraction interfaces and conversion from legacy to PeopleSoft applications.

Extensively worked with People Tools such as Application Designer, Approval Workflow Engine, Application Engine, Integration Broker, Application Messaging, SOA architecture, Component Interface, People Code, Security, Tree Manager, Process Scheduler, Data Mover and Query tools

Extensive knowledge of Elastic Search and AWE

A 60:40 mix of technical and functional expertise to be provided to the business.

Extensive experience in writing Interfaces between PeopleSoft HRMS and Financials.

Worked intensively with Security Administrator to implement Row Level Security, Single Sign on, and LDAP integration, Creating Roles, Permission Lists, User Profiles, Portal Security and Definition Security.

Extensive experience on PeopleSoft Internet Architecture (PIA), PeopleSoft implementation, upgrade, tax updates, conversion, customization, and new development.

Knowledge of HTML, CSS and XML

Proficient in gathering and analyzing requirements to successfully design applications based on user needs.

Possess excellent communication skills, zeal to adapt to new technologies and excellent Team Player.

TECHNICAL SKILLS:

ERP Module

PeopleSoft HCM (8.x/9.1/9.2), PS HCM (Core HR, Work Force Administration, Payroll, e-performance, Benefits, Time & labor)

People Tools

Application Designer, People Code, Application Engine, Component Interface, Security, Data Mover

ETL Tools

Oracle Data Integrator (ODI), Microsoft SQL Server Integration Services (SSIS)

Reporting Tools

SQR, Crystal Reports, vision, Business Objects, BI Publisher, OBIEE

Databases

Oracle, DB2 and MS SQL Server

Operating Systems

Windows Server 2008, UNIX (AIX, HP, Solaris).

Education/ Certification/Credentials

Bachelor of Technology in Information Technology, JNTU-Hyderabad, AP, India

Masters in Engineering Management (Major in Management of Information Systems) from Arkansas State University

Completed the PeopleSoft Development Certification Exam which was organized by the NTT DATA Company in 04-Oct-2014.

PROFESSIONAL EXPERIENCE:

Client : Weis Markets Inc. Sunbury, PA Nov-16 – Current

PeopleSoft HCM Techno Functional Analyst/Developer/PeopleSoft Administrator

Weis Markets, Inc. is a Mid-Atlantic food retailer based in Sunbury, Pennsylvania. It currently operates 204 stores and run’s business in 7 states New York, New Jersey, Virginia, West Virginia, Delaware, Maryland and Pennsylvania.

Working as a senior developer and PeopleSoft Administrator for the Weis Markets.

Worked on complex enhancements and automating the processes, ftp transfers.

Taking care of the application technically, functionally and administration standpoint.

Performing system administration tasks such database refresh, applying of tax updates and maintenance patches and bundles and security patches as and when released by Oracle

Identified opportunities in the system to improve the HR processes.

Aligns business and IT strategies with business goals.

Worked on both configuration and technical aspects of the PeopleSoft system.

Migrations of all changes to environments and system administration experience.

Documentation for most of the processes from zero to a stable environment.

Provide functional and technical support to the business users on a regular basis.

Lead requirement gathering sessions for projects.

Install and configure third-party applications for PeopleSoft such as WebLogic, Tuxedo, COBOL

Manages, maintains, and migrates file data on PeopleSoft server systems.

Work closely with payroll business manager to resolve urgent/time sensitive payroll issues.

Setting up new roles and permission lists based on changes in the organization.

In-depth knowledge of the PeopleSoft architectural environment

Creation of interfaces and programs for sending and receiving data files from vendors.

Created interfaces for new benefits vendor Unum.

Taking care of environment refresh and patches

Installed operating systems and support applications in the system.

A good understanding of the configurable aspects of North American Payroll.

Effective in requirements gathering and fit gap analysis

In depth knowledge of SQR and application engines.

Creating new permission lists and roles based on business requirements.

Strong experience with Linux/Unix commands.

Lead team and guided, mentored my junior team members.

Complete time sensitive tasks in time.

Provided data reporting support to business and executive managers.

Extensively used my oracle support website for creating Service requests. Searched and downloaded entire People Tools 8.52, 8.53, 8.54, 8.55 and 8.56 along with the application and documentation.

Worked with COBOLS and related issues especially during tax updates.

Evaluates and repairs PeopleSoft system errors and failures

Ability to multi-task between projects and applications and to manage

Worked on multiple priorities, while meeting deadlines

Provide ongoing assistance to PeopleSoft developers and testers to resolve defects during the testing process.

Extremely organized and worked on multiple initiatives simultaneously

Worked with security and quarterly access review for everybody.

Documented security and access in the system. Created security and audit reports for Payroll, benefits and core HR. module managers.

Created customizable audit reports for Payroll, HR and benefits departments separately.

Working and tuning SQL statements, tablespace maintenance, and schema maintenance.

UAT testing before migrating any project to Production.

Applying tax updates patches and upgrades to the environment in an aggressive timeframe.

Currently involved in leading charge with downloading all executables, PUM images from edelivery.oracle.com and my oracle support site since the client is running of support from oracle and they are moving towards Rimini Street.

Working with third party system, Kronos for getting timesheet data for payroll processing.

Extensive knowledge of Unix/Linux commands and operating system, client went from Oracle Enterprise Linux to Red Hat Enterprise Linux Server release 5.11 . This is complete only for Dev environment and other environments are in work in progress.

Work closely with customers, business analysts, and team members to understand business requirements

Detailed Understanding of development and testing methodologies.

As a PeopleSoft administrator responsible for maintaining the overall health of the environment.

Provide training to junior resources within the team and guide them with the Standard Operating Procedures(SOP’s)

Provide production support to the business related to PeopleSoft application.

Worked on tasks with no guidance learnt new technologies as per the demand of my role.

I have developed extensively in PeopleSoft and can handle anything in PeopleSoft.

Worked with PGP encryption from sending files to Equifax.

Developed interfaces for sending files to Equifax for Verification of Eligibility.

UNIX scripting, java scripts, css, AWE and html experience

Developed interfaces related for Wells Fargo when company moved from BB&T to Wells Fargo.

Environment: PeopleSoft 9.1, People Tools 8.52, SQR, Service Now, Position Management, Self Service,People Code, Change Assistant, Oracle 11g,

Client : MetLife Clarks Summit, PA Jan-16 – Oct-16

PeopleSoft Systems Analyst

MetLife, Inc. is the holding corporation for the Metropolitan Life Insurance Company (MLIC) better known as MetLife, and its affiliates. MetLife is among the largest global providers of insurance, annuities, financial services and employee benefit programs, with 90 million customers in over 60 countries

Working with functional team, end users, offshore and third party vendors for PeopleSoft projects related to ELM, core HR, Security and Benefits.

In depth understanding of development and testing methodologies.

Participates in systems analysis and design using development, quality assurance and integration methodologies

Ability to take on roles requiring co-ordination across multiple technologies and teams.

Interact with Business to understand the Functional requirements and deliverables and also provide suggestion towards design improvement.

Working knowledge of mainframe and program batch execution.

Involved in writing SQL procedures/queries

Tested and verified migration of security objects from the non-production environments to the production environment.

Knowledge of Position Management, Self Service, T&L, Payroll, Benefits and Compensation

Provide ongoing assistance to PeopleSoft developers and testers to resolve defects during the testing process.

Extensive work experience with Self-service modules.

Working with SOAP web services for sharing services with various vendors.

Used IB to send PERSON_DATA to FSCM systems.

Experience in systems analysis, including defining technical requirements and performing high level design for complex solutions

Created multiple AE and ExceltoCI for data conversions and AWE.

Used application packages for getting IB data sent to other systems.

Worked on effective extraction of data from PeopleSoft for the management.

MetLife uses PeopleSoft CRM to take care of the customer queries and involved in streamlining that.

Monitored and communicated all security issues related to business system administration.

Set up roles, permission lists and created user profiles to establish security for the system

Involved in cleaning up the copy of production based on the DDDAudit and SYSAudit reports

Prepare ELM functional documents to streamline with business requirements.

Performing fit gap analysis and generating reports.

Helping with conversion from PeopleSoft CRM to Salesforce.

Develop Requirements Traceability matrix for QA/testing, help in creation of test cases.

Responsible for analyzing scope, planning, tracking aspects of the project.

Mentored my juniors

Translate customer requirements into formal requirements and design documents, establish specific solutions and testing that culminate in client acceptance of the results.

Hands-on experience in scope study, requirements gathering, Functional Requirements, Fit-Gap Analysis, Design, Configuration, Change Management, Risk Assessment, End-User Acceptance Testing, Product Development, Quality Assurance and developing Functional and Tech. Specs.

Experience with writing ad hoc queries.

Proficient in analyzing and translating business requirements to technical requirements and architecture.

Create employee self-service portal for Expense and Time Entry.

Create the Technical design specifications based on the fit/gap session findings and Functional Design.

Deliver new and complex high quality solutions to clients in response to varying business requirements

Effective in requirement gathering, fit-gap analysis, process and system documentation, system implementations, upgrades, testing, training and end user knowledge transfer.

Environment: PeopleSoft 9.1, People Tools 8.53, SQR, Benefits and Compensation, Remedy, People Code, STAT, Oracle 11g, CA Service Desk, HP Quick Test Professional (QTP)

Client : SuperValu Inc. Eden Prairie, MN May-12 -Dec-14

Principle Techno Functional Consultant

Responsibilities:

SuperValu, Inc. is an American retailing company. The corporation, headquartered in the Minneapolis suburb of Eden Prairie, Minnesota, has been in business for nearly a century. It is the fifth-largest food retailing company in the United States (after Kroger and Albertsons), and ranks in the top 100 on the 2015 Fortune 500 list

Analyzing Pages, Components, and Menu Definitions for vulnerabilities ASM tickets. Develop policies, procedures, and strategies related to the use, rights, access, and work flow relevant to security and/or PeopleSoft Human Resources systems.

Advanced query skills. Working knowledge BenAdmin, MSS, ESS.

Worked with Java Preprocessor directly involved in managing the application.

Extensive work experience with Self-service modules like ESS and MSS.

PeopleSoft implementation from 8.9 to 9.2

Knowledge of Position Management, Self Service, T&L, Payroll, Benefits and Compensation

Worked with PeopleSoft CRM and aware of its functionality.

Served as PeopleSoft security liaison between IT and business, performed daily analysis.

Worked on complex NA Payroll designs and code changes.

Understanding of 360-degree view functionality of CRM

Extensive work experience with third party vendors and application providers.

Experience with ESP Scheduler and batch processing

Handled and wrote code for Java Pre-Processor used for hourly employee’s wage calculations.

SQR reports like zbncdta.sqr and ptax.sqr written from scratch.

Worked in security audits using a wide variety and range of sqls and sqrs.

Developing security test conditions/scripts and data.

Worked with iScripts for avoiding the PeopleSoft component buffer restriction.

Created and maintained requirements traceability matrix for the Supervalu requirements.

Extensively used audit records to provide security to the HCM system.

Monitored the technical performance related issues of the application.

Worked in PeopleSoft Security administration,

Used HP Quality Center to achieve Quality and defect management.

Provided second level support for escalation of ongoing PeopleSoft Production issues.

Explained the core technical concepts to the end users in layman terms.

Extensive experience in PeopleSoft Security administration

Analyze business requirements to identify process improvement opportunities and solutions utilizing PeopleSoft functionality.

Provide 24/7 on-call support using onshore/offshore model.

Worked with Integration Broker and PeopleSoft Web Services for integrating SIM and CRM to HCM module.

Solid understanding of HCM functionality including NA Payroll processing, W2, state, federal and FLSA reporting

Impact Analysis of issues and monitoring the progress made towards issue resolution

Testing/Fixing of Change Requests. Write system specifications for customizations, reports, queries or other needed specifications

Developed Payroll & Benefits related queries and interfaces for HCM modules.

Production support and monitor the jobs. Monitor and report on the status of project to the client.

Environment: PeopleSoft 9.2, People Tools 8.53, SQR, People Code, Application Engine, Benefits and Compensation, Oracle Financials, HP Quick Test Professional (QTP), HP ALM, Oracle 11g, CA Service Desk, UNIX.

Client: Punjab National Bank New Delhi, India Apr 11–Mar-12

PeopleSoft Technical Consultant

Responsibilities:

Located in New Delhi with 26 Zonal Offices which in turn supervise 47 Regional Offices with over 57000 employees.

Project Implementation of PeopleSoft 8.9 PeopleSoft HRMS & Global Payroll

Modules implemented by PNB were Workforce Administration, Benefits, Training, Recruiting, Manage Labor relations, and Global Payroll.

Worked with batch processing system.

Customized pages/menu/records/SQR reports to apply customizations as per client's requirements.

Developed role based workflows to meet business needs.

Understanding of batch processing systems like mainframes

Performed data loading using Import manager utility of PeopleSoft

Set up roles, permission lists and created user profiles to establish security for the system

Prepared development documentation and migration documents for the object migration.

Extensively executed SQL on DB2 tables to determine successful transaction of data from the application.

Involved in Documentation, Production Support and End User Training.

Environment: PeopleSoft 8.8/8.9 (HR, Global Payroll, T&L, HP QC Salary Plan, Oracle Financials, Benefits, Position Management, Self Service SQR.

Reflexis Systems India Private Limited Pune,India Apr-07- August-08

Technical Associate

Reflexis specializes in software configuration. It handles configurations for all Reflexis WFM products and can do them through partial or all-store rollouts. For organizations with previous versions of WFM software, we can both upgrade,these versions or implement the newest one.

Responsibilities:

Worked with Java and performed unit testing.

Troubleshoot technical issues

Worked with database SQL in oracle RDBMS.

Worked with Web development technologies such as HTML, JAVA, JSP and JAVA SCRIPT.

Multi tasked on multiple things at any given time.

Worked on creating technical documentation related to the developed code.

To test automation framework & integration testing /System Testing /Acceptance Testing.

Contact this candidate