SUMMARY

• 18 years of IT industry experience of which 15 years as a PeopleSoft HRMS/FSCM Techno - functional Consultant.
• Good Level understanding of Salesforce.com CRM and its Development Life Cycle
• Hands-on experience with apex programming language, apex triggers, apex scheduler, batch apex, apex classes apex web service and Partner WSDL Enterprise WSDL
• Experience in customizing the user interface of Salesforce CRM using apex programming, visual force
• Experience in customizing Data model of Salesforce.com CRM using workflows, triggers, validation rules, and approval processes
• Experience in designing of custom objects, custom fields, Pick-list, Page layouts, Workflows, custom Tabs, reports, design of Salesforce Force Pages, Dashboards, and Email generation according to application requirements
• Proficiency in administrative tasks like creating profiles, roles, users, page layouts, email services, approvals, reports, dashboards, tasks and actions.
• Experience in complete security model by using profiles, permission sets, organization wide settings, owner based sharing rules, criteria based sharing rules, manual sharing, account teams, opportunity teams
• Implemented security and sharing rules at object, field, and record level for different users at different levels of organization. Also created various profiles and configured the permissions based on the organizational hierarchy
• Very good understanding and knowledge in Workday.
• Experienced in different roles as Project Lead, Technical lead, Business Analyst, Systems Analyst and Developer.
• Experienced in upgrade from PeopleSoft HCM/ELM from 9.1 to 9.2.
• Experienced in PeopleSoft 8.x and 9.x PeopleSoft Portal Solutions and Interaction Hub.
• Strong functional, technical and project management skills with requirements gathering fit/gap analysis, reporting, proven ability to work and manage projects independently. Background installing and upgrading, PeopleSoft Portal Solutions, Interaction Hub, 8.x, 9.1, 9.2 and PeopleTools 8.54 and 8.55, including Fluid User Interface, SES, HTML5, CSS, JavaScript, JQuery, Fluid User Interface, Branding, XML, PeopleCode, iScript, Application Packages, Application Engine, Application Designer, SQL, applying maintenance packs and patches using Change Assistant and PUM change packages.
• PeopleSoft 9.2/9.1 Financials experience in modules GL, Asset Management, Account Payables, Expenses.
• PeopleSoft 8.x/9.x HCMS experience in the modules of HR, Payroll, Benefits, Ben Admin, Pension Admin, Position Management, Absence Management, ELM, Time &Labor, self-service (ESS, MSS).
• 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.
• Expertise in People Tools, Application Designer, Workflow, Component Interface, Application Engine, Integration Broker, Application Messaging, web services, Data Mover, Tree Manager, People Code, SQR, PS Query and Security Admin.
• Delivered end to end process/systems including business and user requirement analysis, process studies and constant improvement of the systems, functional documentations, managing consistency in quality and improvement in the process, production database updates, testing and validation.
• Mentored IT teams by orienting, training, assigning, scheduling, and coaching individuals for peak performance.
• Applying Maintenance Packs, Tax Updates, Patches, Bundles.
• Experienced in various stages of project development life cycle - Project Planning, Estimation, Requirement gathering, estimation, Analysis, Design, Implementation, Unit Testing, SIT, Acceptance Testing, preparing FDD/TDD, Training, Data Migration, Production Cutover, Incident & Problem Management, Transition Management and Configuration/Quality Management.
• Excellent communication, analytical, presentation, interpersonal, interaction and organizational skills, vibrant Team player/leader who loves taking additional individual responsibilities.
• Has 10 years onsite experience in customer facing, relationship development, proactive demand generation and account mining roles.
• Extensive experience in leading and managing teams in both onsite/offshore models.

TECHNICAL SKILLS

PeopleSoft Modules: PeopleSoft HCM (HRMS) v 9.x/ 8.9/8.8/8.3/8.0/7.5 Core HR, North American Payroll, Payroll Interfaces, Compensation, Base Benefits, Benefits Administration, Time & Labor, Employee Self Service, Manager Self Service, Absence Management, Talent Acquisition Manager, Candidate Gateway, ePerformance, eCompensation, eBenefits, ePay, eProfile and ELMS.PeopleSoft FSCM 9.1/9.2 GL, Asset Management, Account Payables, Expenses.

People Tools/ Utilities: PeopleTools 8.1x, 8.2x, 8.4x, 8.5x, PeopleCode, Application Designer, Application Engine, AWE - Approval workflow engine, Component Interface, File Layout, Application Messaging, Integration Broker, Web Services, Process Scheduler, PS Query, Data Mover, Import Manager, Workflow, Excel to CI, STAT Peoplesoft Security and PeopleSoft Portal Solutions/Interaction Hub.

Reporting Tools: SQR, Pro*C, Oracle Forms, nVision, XML/BI Publisher and Crystal Reports

Operating Systems: Windows NT/XP/95, MS DOS and UNIX

Languages: C, C++, HTML, XML, COBOL, SQL, and PL/SQL

RDBMS: Oracle 7.x/8.x/9i/10g/11g, SQL Server

PROFESSIONAL EXPERIENCE

Confidential, Oakland, CA

PeopleSoft Consultant

Responsibilities:

• Manage analysis of system design in coordination with developers and business analysts.
• Work with senior managers to identify and solve functional area issues, design solutions, develop conceptual models, translate functional area requirements into technical requirements, and support design.
• Analyze information system baseline and perform a "gap analysis" between the baseline, user operational requirements, and the operating capability of products. Supports technical design reviews, enterprise approach validations, and work product assessments.
• Utilized MS SharePoint to manage risks issues, and provide project deliverable/task updates critical to meet project deadlines.
• Documented requirements and specifications from functional end-users and subject matter experts
• Translated customer requirements functional and technical documents, and developed processes and documentation that supported the standard SDLC
• Supported Oracle PeopleSoft 9.2 HCM and Finance.
• Designed PeopleSoft security automation and developed functional and technical documents.
• Created business process models and identified business process improvements.
• Evaluated and provided feedback on system and functional design documents, test plans and scenarios, and other associated artifacts
• Defined test scenarios based on requirements; created test scripts to prove each scenario through system and user acceptance testing.
• Ability to meet deadlines and manage multiple, dynamic priorities.
• Effective communication skills and demonstrated experience working in a team-oriented environment
• Performed and completed Unit and System Testing on custom and delivered processes, and User Acceptance testing with the agencies.
• Reviewed project team's approach to all aspects of the project to verify best practices were being implemented for the success of the project and client's use of the system
• Working extensively on Configure, Design, development and testing of PeopleSoft test framework (PTF) tool for PeopleSoft HCM/Finance Modules.
• Created a PTF framework for PeopleSoft end to end test scenarios.

Environment: Salesforce Lighting, PS HCM 9.2 Core HR, Benefits, Payroll, PeopleSoft FSCM AP, GLPeople Tools 8.55, Application Designer, Oracle, SQL, PS Query, SQR, Application Engine, PeopleCode, XML/BI Publisher and AWE.

Confidential, Seattle, WA

PeopleSoft Analyst

Responsibilities:

• Analyzed current state of security configuration and recommended redesign based on Industry best practice standards.
• Designed, develop, integrate, test and implement PeopleSoft security for different modules.
• Assess current Security configuration and recommend process improvements to role and row-level security.
• Designed all technical roles and permission lists.
• Worked with functional lead to design and developed roles and Permission lists for Project Costing, Asset Management, Accounts Payable, Accounts Receivable, Billing, General ledger and Commitment Control.
• Developed custom portal for Suppliers.
• Created security matrix for modules PCA/AM/AP/ARBI/GLKK.
• Provided guidance and training on PeopleSoft security to end-users.
• Maintains query security, tree security, process groups, tools security.
• Design and developed prototype for definition security configuration.
• Configured LDAP for both SSL and non SSL.
• Researches and resolves technical and functional issues.
• Design and develop security audit reports.
• Developed Data Conversion programs to convert Projects and Asset from PeopleSoft 8.9 system to PeopleSoft FCM 9.2 System using Component Interface and Application Engine.
• Wrote Queries and SQLs
• Involved in design and developing security reports using PS Query, XML Publisher and BI publisher.

Environment: PS Finance 9.2 - Accounts Payable, Accounts Receivable, Billing, General Ledger, eProcurement, Grants, Asset Management

Confidential, Oakland, CA

PeopleSoft Reporting/Data Conversion Analyst

Responsibilities:

• Identified existing legacy reports and converted into PeopleSoft BI publisher reports. I designed and developed the FDD’s, built queries, SQL’s and XML data for BI Publisher report
• Requirements gathering.
• Understand the existing legacy system.
• Conducting sessions with business.
• Design and develop the FDD’s for BI publisher reports.
• Build queries, SQL’s and XML data for BI publisher reports.
• Unit testing, systems testing.
• Helping business in testing.
• Post production support.
• Developed process to convert legacy payroll data into PeopleSoft.
• Design and developed conversion programs using Application engine and SQR for transferring of data from legacy system to PeopleSoft HRMS.
• Developed process to convert legacy HR data into PeopleSoft.
• Developed process to convert legacy data into PeopleSoft.
• Responsibilities included data conversion, implementation of all business practices and business logic, providing technical assistance to the implementation process.
• Involved in Fine Tuning of Database Tables, which are used in Data Conversion.

Environment: PS HCM 9.2 - Workforce Administration, Benefits, Payroll, Absence Management, NA Payroll People Tools 8.54, Application Designer, Oracle, SQL, PS Query, SQR, Application Engine, PeopleCode, XML/BI Publisher.

Confidential, Melville, NY

PeopleSoft HCM/ELM Consultant

Responsibilities:

• Implement Confidential Academy/Learning zone, one for Confidential Employees globally and one for Confidential Dealers/Retailers by converting the legacy systems & data to PeopleSoft ELM 9.2 and Security Administration.
• Besides the implementation, conduct day to day operational production support & sub-initiatives activities. Some of them as below:
• Design and Develop security for around 40 learning environments.
• Creating new roles/permission lists and providing the access to users according to above 40 environments.
• Design and develop the security solutions for above LE’s
• Create Roles, Permission list and provided appropriate access in both CA and LZ
• Convert data from Plateau for Programs, Catalogs, Courses, classes, facilities, etc using Application engine and SQR’s and SQL’s.
• Bug fixing.
• Enhancements
• Developed application engine processes for learning history data conversion from legacy system to PeopleSoft ELM.
• Implemented PeopleSoft Portal Solutions including deployment of Interaction Hub 9.2, configuring Single Sign On with PeopleSoft ELM and HCM environments.
• Good knowledge in PeopleTools 8.54/8.55 Fluid User Interface in the areas of Fluid Homepage/Dashboard, Fluid Master/Detail pages, Master-Detail components, PeopleCode, XML, iScript, Application Packages, utilize a framework to deliver guided processes in the PeopleSoft Fluid User Interface with different templates.
• Designed and developed Data Conversion programs to convert Learning history, User profiles from a legacy system to PeopleSoft ELM System using Component Interface and Application Engine.
• Designed and developed new BI reports for security and for management.

Environment: PS ELM 9.2,People Tools 8.54, Application Designer, SQL server, PeopleCode, XML/BI Publisher, AWE, Workflow, Integration Broker.

Confidential, Mountlake Terrace, WA

Sr. PeopleSoft Consultant

Responsibilities:

• Principle Developer for upgrade project - from PeopleSoft 9.1 to PeopleSoft 9.2 and People Tools 8.54
• Participating in Fit/Gap analysis & defining the organizational process related customizations to new functionality under 9.2
• Identifying the level of effort for retrofitting customization to 9.2
• Assisting in the initial tools upgrade and patch levels agreed upon by the project team.
• Besides the upgrade project assistance, conduct day to day operational production support & sub-initiatives activities. Some of them as below:
• Assisted in developing the compliance & reporting needs for Affordability Care Act and developed the process for 1095C using web services.
• Assisted and designed Open enrollment process improvements and UI improvements so that user clicks will be reduced during the OE.
• Developed Batch Maintenance application.
• Helped in designing Strategies for Archiving to improve performance and organizational compliance.
• Implemented PCARD Process.
• Improved the functionality of Employee Self Services(ESS)
• Worked on Open Enrollment changes, Tax updates.
• Worked on the Customizations of Recruitment/TAM, Core HR, ELM, T&L, Absence Management and Payroll Module.
• Developed and customized various BI publisher reports.
• Automate the manual payroll process and reduce the payroll manual process
• Developed 401K loan deductions process for both inbound and outbound interfaces.
• Developed Holiday hours load process.
• Resolved the Payroll issues.
• Conducted meetings with the Users and the involved in discussing their pain points and assisted with developing solutions/resolutions.
• Implemented PTF and used extensively for PeopleSoft HCM projects.
• Hands on experience in PTF to reduce overall system testing and addressing future patch related system testing.
• Developed custom portal for Suppliers.
• Developed Password challenge application to maintain the employee password challenge questions and answers and all these answers encrypted in database.
• Customized TL timesheets approval system so that anyone in the payroll team and higher managers can approve the time sheets instead of only manager.
• Good knowledge in PeopleTools 8.54/8.55 Fluid User Interface in the areas of Fluid Homepage/Dashboard, Fluid Master/Detail pages, Master-Detail components, PeopleCode, XML, iScript, Application Packages, utilize a framework to deliver guided processes in the PeopleSoft Fluid User Interface with different templates.
• Assisted and developed dynamic distribution list application to maintain the company wide email distribution lists.
• Assisted and developed VISA notification application to inform HR managers and vendors about VISA expiry of employees and vendors.
• Involved in design and development and implementation of BenefitsFocus for Premera. Developed interfaces for demographic details and Payroll deductions.
• Customized HIPAA 834 process to produce the benefit enrollment and maintenance details file according to PREMERA.
• Improved the Manage Self Services (MSS) functionality
• Designed, Configured and developed Absence Management Formula for the Leave Accruals.
• Configured the Absence Management Entitlements, Takes and supporting elements as per the requirements.
• Modified auto enrollment of employees into absence management.
• Customized leave forecasting rules.
• Modified absence load process..
• Developed and build new queries and reports.

Environment: PS HRMS 9.x HR, Payroll, Benefits, Benefits Administration, Absence Management, Compensation, TAM, Time and Labor, ELM, PTF,People Tools 8.53, Application Designer, SQL server, PeopleCode, XML/BI Publisher, AWE, Workflow, Integration Broker and Web Services.

Confidential, Houston, TX

PeopleSoft Consultant

Responsibilities:

• Monitor nightly jobs, analyze the failed jobs and report to the process owners.
• Troubleshoot high priority issues during development.
• BI Publisher Report changes for SACS roster report and other reports.
• Modification/Creation of Interfaces.
• Troubleshoot issues in technical/functional area in Production Support or the enhancement issues.
• Worked on the Customizations of Recruitment/TAM Module.
• Created application package to post GENL deductions online based on JOB data changes.
• Customer interaction and understand the business requirement, analyzing and preparing.
• Created new CI for JOB Data Salary changes and data loaded using ExceltoCI tool.
• Extensively involved in creating PS Queries for day to day operations.
• Worked on interface programs for migrating data from other systems to People Soft.
• Involved in trouble shooting Integration broker issues and solved data sync issues between HCM and CS & ELM.
• Involved in AWE changes for ESS/MSS transactions.

Environment: PS HRMS 9.1 HR, Payroll, Benefits, TAM, Time and Attendance

Environment: PS HCM 9.2 - Workforce Administration, Benefits, Payroll, Absence Management, NA Payroll, Time and Labor People Tools 8.50, Application Designer, Oracle 11g, SQL, PL/SQL, SQR, PeopleCode, XML/BI Publisher, AWE, Workflow, Integration Broker & Shell scripting.

Confidential, Seattle, WA

PeopleSoft Analyst

Responsibilities:

• Analyze the application.
• Applying maintenance packs and bundles.
• Managing the project.
• Monitor nightly jobs, analyze the failed jobs and report to the process owners.
• AWE customization.
• Troubleshoot high priority issues during development.
• Modified processes and corresponding Linux scripts based on the requirements.
• Troubleshoot issues in technical/functional area in Production Support or the enhancement tickets.
• Customer interaction and understand the business requirement, analyzing and preparing Functional/Technical Design documents, giving the estimation and working on client deliverables.
• Oversaw and coordinated efforts of the functional team, technical team, testing team, application security and Responsible for successful delivery of technical development with quality.

Environment: Peoplesoft SCM 9.1 (Procurement and Purchasing)People Tools 8.50.21, Application Designer, Oracle 11g, SQL, PL/SQL, SQR, PeopleCode, AWE, Linux scripting.

Confidential, San Antonio, TX

Senior PeopleSoft Consultant

Responsibilities:

• Monitor nightly jobs, analyze the failed jobs and report to the process owners.
• Troubleshoot high priority issues during development.
• Modifications to Benefits enrollment form changes.
• PeopleSoft AWE customization.
• Modified processes and corresponding Linux scripts based on the requirements.
• Accept and resolve tickets from clients for ESS and MSS modules.
• Troubleshoot issues in technical/functional area in Production Support or the enhancement tickets.
• Customer interaction and understand the business requirement, analyzing and preparing Functional/Technical Design documents, giving the estimation and working on client deliverables.
• Oversaw and coordinated efforts of the functional team, technical team, testing team, application security and Responsible for successful delivery of technical development with quality.
• Designed and developed integration from third party system to PeopleSoft for Vouchers, Budgets using integration broker.
• Wrote database triggers using SQL/PL-SQL.

Environment: PS HRMS 8.9 (HR, Payroll, Benefits, Time and Attendance, GL and AP) People Tools 8.49.30, Application Designer, Oracle 11g, SQL, PL/SQL, SQR, PeopleCode, Workflow, Linux scripting.

Confidential, Maumee, OH

Team lead

Responsibilities:

• Facilitated meetings with HRMS team members to identify business requirements.
• Customer interaction and understand the business requirement, analyzing the FDD, preparing Technical Design, giving the estimation and working on client deliverables.
• Lead for all infrastructure related items with People Soft.
• Manage daily, weekly review of the team.
• Oversaw and coordinated efforts of the technical team, testing team, application security and
• Responsible for successful delivery of technical development from offshore, with quality.
• Deliverables meeting the business requirements, on time and on budget. Managed day to day activities project team members
• PeopleSoft HCM Application Security.
• Managing the customer & Vendor relationship.
• Applying Maintenance Packs, Tax Updates, Patches, Bundles.
• Coordinated development and testing efforts between functional, technical and user groups. Managed issue tracking and creating project documentation. Provided production support and functionality enhancements to improve HR and Payroll efficiencies.
• Created and managed Project Charter, Project Plan, Risk log, Issues log, Status reports, project team meetings and other project related project office activities and strategy documents in collaboration with the HCM Program manager
• Responsible for Design, development, implementation, testing and support of assigned software Projects and applications from offshore.
• Manage the New change request or development in the existing system.
• Managing Resource Allocation, Effort Estimation & project planning.
• Involved in Gathering and Analyzing requirements for HR Initiatives project to Outsource Health & Welfare Benefits to ACS.
• Prepared Functional Specification for Interfaces from ACS to Confidential to bring in General Deduction Data.
• Designed, Configured and developed Absence Management Formula for the Leave Accruals.
• Configured the Absence Management Entitlements, Takes and supporting elements as per the requirements.
• AWE customization. Worked on the Customizations of Recruitment/TAM Module.
• Worked extensively with eRecruit, Talent Acquisition, Candidate Gateway.
• Worked on the Recruiting Process of eRecruit, Talent Acquisition, Candidate Gateway.
• Worked on setting up the Integration broker to run the sync between HCM and ELM for all the HR related data.
• Performed system study of current Base Benefits and Benefits Administration setup as part of Application support transition project.
• Providing Production Support, User Support and Enhancements in Payroll (8000 Hourly employee, 3000 Salaried Employee), Ben Admin, and Base Benefits modules.
• Monitored project deliverables and execution(Change Management, Implementation, production Support and Security) to meet Sarbanes-Oxley requirements
• Participated in External vendor management, including gathering 3rd party vendor requirements and communicating the same to the business, providing IT solutions to business as per need. Prepared functional technical design documents for respective PeopleSoft solutions
• Developed solutions based on specifications including application customizations, custom reports, and interfaces.(Using SQR, People Code, Application Engine, Component Interfaces, File layouts etc.)
• Worked in Taleo and TCC
• Modified the AM rules according to business rules.
• Wrote database triggers using SQL/PL-SQL.

Environment: PS HRMS 9.1 (HR, Payroll, Benefits, Pension Admin, Time and Attendance, Absence Management, GL and AP) and TCC People Tools 8.50, Application Designer, Oracle 10g, SQL, PL/SQL, SQR, Peoplecode, Workflow Unix.