SUMMARY:

• Highly Planned, Functionally Organized, robust industry standard analytical design & development, ERP Application audit & Sox compliance procedures, IT Security & Safe Harbor Report Procedures and self - motivated Professional along with 20+ years of Global experience, in the field of Information Technology with implementing Information Systems utilizing Enterprise Resource Planning, Client/Server applications, and Experience in Lead Managing the Functional Application Design, Technical Developments, quality testing and Implementations.
• As a SME of Functional, Technical Domain Expertise and Process knowledge of Finance, Planning, Budget Control, Human Capital Management, Supply Chain and Customer Resource Management Applications and associated Systems, and follow the Change management system procedures.
• Piloting the Project flow designs with tailored custom functionalities, demonstrating the sessions with multi-directional approach.
• Currently working with the ERP applications of PeopleSoft 9.2 HR / Payroll/ Benefits/ Finance, Kronos, Taleo and other cross functional Knowledge of SAP, Oracle EBS, Informatica/ OBIEE EDW and BI Analytics, DAC, Data Reporting and Presentation Model Tools & Applications.
• Experienced with multiple ERP application modules in diverse range of industries including Technology, manufacturing, Banking/Financial, Pharmaceuticals, Health Care & Insurance Operations, HR & Payroll professional services with business requirements, Interfaces Integration with 3rd Party Vendors/ Providers and Project/ Data Conversion. Global Client Faced/ Focused working model of On-Site/ Off-shore support.

EXPERTISE AREA:

• Team Leadership
• Business Process Modeling
• Project Management & Consulting
• Business Analysis, Design & Systems Quality Testing
• Fit/Gap Analysis, Upgrades and Application Functionality Extensions
• Functional Setup Configurations and Implementations
• Release Management, Confidential Schedule & Execution Planning
• Technical Architectural Plan, Design & Enhancements
• Applications Implementation and Development
• Diverse global Industry Experience
• Business Process Transformation & Data Analysis and Conversions
• Application Support, Application Training
• Sarbanes/Oxley (SOX) Compliance Audit Procedures

TECHNICAL SKILLS:

PeopleSoft HCM/ HRMS: HR, Payroll, Benefits, Confidential & Confidential / Global Payroll/ Absence Management, Recruitment (TAM & Candidate Gateway).

PeopleSoft Finance/SCM & CRM: GL, AP, AR, PO, Billing

Taleo Recruiting (ATS): Taleo TCC Connect Client

Talemetry/ Resume Mirror (ATS): TAM - Integration Sync

Kronos - Confidential Keeping: Workforce Central

ADP - Payroll: Workforcenow O/S & Data Base: Unix, Linux, IBM-DB2, Oracle & MS-SQL Server

PROFESSIONAL EXPERIENCE:

Confidential, Pleasanton, CA

PeopleSoft SME ( Functional/ Technical)

Responsibilities:

• Functional/ Technical Architecture Designing for the future state Project Road Maps of the PeopleSoft Financial - Pay to Bill (Payroll to Billing) and Pay to Cost, Master Tax Reporting System - Payroll Reconciliation Summary Reports & Payroll Tax Summary Reports.
• Implemented Client Customizations of Interface BI & GL Interface.
• Working with the EDW & Business Intelligence Teams for Payroll, Tax and Leave Accrual Reporting Systems.
• Worked with the Employee Level Payroll Tax Balance Conversions and Legacy Data Mergers, corrections, consolidations, yearend Balance Summary Reports and W2 Resolutions.
• Setting up the functional configurations of the Benefit Plans and Savings Plans, Leave Plans, Leave Accruals and Company Billing Parameters & Data Setups for the on boarding Clients.
• As a PeopleSoft SME responsible to provide Code developments in Agile methodology, testing and deployments and Release Cycle Management. Widely utilizing the Confidential tools for Release Management/ Code Migration like CAPI, STAT, JIRA, GIT/STASH, Bamboo, Service Now and Confluence.
• Participating in Agile Daily Scrum’s for the Payroll and the ongoing Project Planning’s, Enhancements, Developments & PROD Bug fixing.
• Actively working with the Data Consolidations, Data Integrations and Data Conversation & Reporting Projects.
• Day to day PROD support & Deployment Support of weekly, Monthly & off-cycle code Release.
• Working on the integration & implementation of the SOX Identity Access / SailPoint Integration.

Confidential, San Francisco, CA

PeopleSoft Practice Lead/ Solution Architect (Technical/ Functional)

Responsibilities:

• PeopleSoft HCM System 9.1 Implementations as well as upgrading to 9.2 with the modules involved- Core HR, Talent Acquisition/ Candidate Gateway (TAM Recruitment)/ Payroll Integrations with SaaS based and Could base third party Apps (Ascentis & ADP)/ Benefits Interfaces and third party Application Implementing the Integrations with Taleo (replacing Talemetry/Resume Mirror ATS Application) and Kronos Enterprise Confidential Keeping & Attendance System for Retail Employee Confidential and Scheduling module Implementation & Integrations - Kronos WIM, Kronos Workforce Central. And Oracle EBS Systems Projects between HR & Finance and HR Data Centric consolidations, conversions and Analytics.
• Responsible and participated in multiple Project Implementations in HR space with 3rd party Application Integrations and day to day Production Support, Issues and Service Request Escalation, Bug Fixes and Ticket Resolution
• Functional Business Analysis, Product Research and Developments/Enhancements/ Extensions
• Closely involved with the Business teams of TAM and HR, and participate in business reviews/ meting sessions to gathering the Business Requirements, work estimates and the User Specifications.
• Configuration Setups for the TAM/ Recruitment options and the Approval Workflow Process & email Notification Event Triggers
• HR and TAM related Customizations, Enhancements, Developments and UAT testing Support. And responsible for the Production migrations & post Production support model. And maintenance of the 3d party Interface related tasks and supporting of Batch Process Runs
• System Admin, Database level support and Servers maintenance.
• User Profile Admin and resolving the Security related issues for the user access levels within the PeopleSoft and the third-party Applications.
• Working with the Integrations of the Talemetry 3rd party ATS system (Applicant Tracking Systems and Job Broad Casting) and the Candidate Gateway
• Project Proposals, Project plans, work estimations and priority task allocations
• PeopleSoft Systems Solution Architect: Providing the Corporate, Retail and Global Application Solutions for the Human Capital Management, Recruitment Systems, Confidential Keeping Systems, Benefits Administration and Payroll Systems
• Implementing the Taleo seamless Integrations for the Advanced Solutions of the Global Recruiting capabilities with extended functionality and best service in the industry. And retiring the PeopleSoft TAM integrations with 3rd party Talemetry/Resume Mirror ATS Applications.
• Implementing Kronos Enterprise Confidential Keeping in a Phased design approach with multiyear budgeted project roll over from the Legacy Confidential system to the SaaS based Cloud Application. Define & Design the Pay Rules, PTO/ Sick Accrual Rules, Access Security and hierarchy rules for the Confidential Card approval process.
• Kronos Workforce Central and Kronos Workforce Integration Manager WIM Configurations and Day to day Administration and Production Support with the multiple teams of Confidential -Admin, Payroll, Benefits and Recruiting - New Hire Data Syncs.
• Architectural design plans, Business process flow diagrams and design the Database Admin to design Table Structures & Table Relationships.
• Functional and Technical Practice Lead: Business requirements gathering from the multiple teams coordinating with the Global regions, drafting the Functional Design specifications and documenting and leading towards to the Technical designs and developments.
• Project Managements: Project scoping, budgeting, Project estimations, tasks prioritization & allocations, Project Plans and Release scheduling and meet the deliverables.
• Developments, Test cycles support, Bug Fixes, Post Go-live validations and support.
• Day to day Production systems support (24/7 System Monitoring & Reporting): Maintaining & tracking the Production Case Management Systems for the Production Issues & Service Requests Resolutions and escalations.
• End to end Application life cycle developments, testing and Implementations. Systems Integrations and Interfaces.
• Monitoring daily Business Analytics and Decision Support Reporting systems, extract the Data grids using Queries, PS Queries publish to the Reporting dash boards of HR and Finance Audit teams.
• Cross Functional Application Research & Analysis metrics to capture and implement the new functionality and the Product enchantments with in the estimated scope & budgets.
• Working on Integrations and Maintenance with the Order Management (OM)/ Supply Chain (SCM) of Oracle EBS Release 12 Applications, Talent Technologies a 3rd party Applicant Tracking System for the Global Recruitment Process and Support.
• And closely associated with the Internal & External business partners and core peer teams for day to day application functionality & support. And Service Now CAB Approval member.

Confidential, Pleasanton/ Walnut Creek, CA

PeopleSoft Lead Consultant

Responsibilities:

• Develop and Maintain the Upgrade Plan, manage the upgrade activities, tasks and deliverables and sharing the skills on the cross Environments across the Board.
• Design the Functional and Technical documents based on the client business needs and fit- gaps out comes and requirements, Estimations, Budget proposals for the new project scoping and schedule planning.
• Design and Development Interfaces of the Custom Voucher/ Invoices and Voucher Build Component Interfaces and Application Engine Programs.
• Evaluation and determination of the People Tools Objects and Batch (SQR’s, Reports and Interfaces) of the client’s customizations retrofits and its functionality.
• Functionality Improvements GL and AP modules - Create setup data to pre-populate chart-filed values to speed up user date entry.
• Worked with the Hierarchical Approval Work Flow process (AWE) from Accounts Payables/ General Ledger JE approvals
• Working with the Configurations and setups for the Integration Broker - IB Asynchronous messages from FSCM to CRM integration.
• Managing and coordinating the On-site and Off-Shore Teams (size of 8- 10) on day to day s status calls, work progress and activity report updates.

Confidential, Modesto, CA

PeopleSoft HCM-Lead Consultant (Functional and Technical)

Responsibilities:

• Actively involved in multiple tasks of the Enhancements/ Design/ Developments, Production Issues Support and Upgrade, Project Scope, Release Planning, Assessments and fit-Gap sessions.
• Participated in Gap Sessions and business requirement gathering from Gallo’s Talent Acquisition Team.
• Analysis and build the initial Project Estimations, Budget Proposals, Project Plans, created UAT Test Plans/Test Scripts and Production Release Schedules and Approval docs for Migration Plans.
• Responsible to deliver all the Functional and Technical Design documents.
• Configuration Setup - Status Area, Status Code and Status Reason Codes
• 090- Hire Process and Applicant Status Changes
• Find Applicant - Applicant Activities On-line Page Enhancements (Development/ customizations of App Packages/ App Classes and PeopleCode.)
• Developed and Setting up the Configurations and rollover Business Changes with the combination of Country specific Company Code/ Status Code/ Status Reason/ and Template ID combination and with the specific changes of the Template reasons.
• Developed Recruitment/ TAM Solutions for Batch/ On-Demand Business Process Notifications of the Applicant Tracking and Status Changes- Using with App Engine Process, XML Publisher, PS Query, File Layout Output Report burst of .csv files for Business Users Review prospective.
• Enhancements at Integration part of the Manage Hire Process with Job Data Component
• End User Training and knowledge transfer.

Confidential, Phoenix, AZ

Principal Consultant- (PeopleSoft Techno Functional)

Responsibilities:

• Work Participation in Business Reviews, requirement gathering, gap-fits and exchanging / sharing the information with the end users from various Confidential Regions / Market Places
• Actively involved in the Initial Business reviews and Gap-fit Sessions with the teams of Benefits, Leave Accruals and Absence Management Systems and its Integrations with respect of existing Leave Accruals and the Absence Management Systems- Absence Entitlements, Absence Take, Absence Balances and Absence Rule Processing. Involved and worked with the Confidential & Confidential Team for Configuration Setups and rules.
• Fields and data point Mappings for the program Layout Designs
• Design and Developing Interfaces and conversion Programs in CI’s-Component Interfaces and AE’s-Application Engine Programs to process the Data Conversion and Data Transformations and CI Loads to PeopleSoft Environments
• Working on the French Market Place Required Configuration Setups and validations.
• Pre & Post Data Analysis, Data Comparisons, Data Validations and PS Query Reporting.
• Preparing and maintaining the Conversion Plans and Schedules
• Developing the Test Scripts, performing the end to end Unit Testing and Problem fixing
• Generating the required documentation and knowledge sharing across the Global Regions
• Working on the data integrations/ mappings between HCM to CRM of the related knowledge about Enterprise Portal, Support/Helpdesk, Self Service, and reporting structures based on different Market Places/ Business Units, using the tools of the Integration Broker (IB), File Layouts- App Engine and Component Interfaces.
• Working on customizations of the case page to update the status reason based on the selection of case status.
• Configuration Data Loading for the conversions in different environments using with excel to CI utility
• Involved in design and developing of the CRM required functional and technical documents and Project deliverables and Project Plans of scheduled migrations.

Confidential, Pleasanton, CA

Advanced PeopleSoft Lead Analyst

Responsibilities:

• Worked with the PeopleSoft Application Support and Product Developments for- MyHR Benefits/ Ben Admin / Leave Accruals and Testing Teams
• Implemented the National Agreement Implementation for Health Reimbursement Account (NAI - HRA) in multiple Phase roll outs for the multiple Regions based on the different Union and Savings plan combinations.
• NAI - HRA Projects Development Work Involved through the Waterfall - SDLC methodology for National Agreement Implementation - HRA Phase 1 and worked in HRA (Health Reimbursement Account) Phase 2 Development methodology through the Kaiser Hybrid model of the Agile & Waterfall-SDLC.
• Involved HRA Phase 2 - Implementations for June Release of Leave Accrual complete audit solution and working on the different.
• Developing new Interfaces (Inbound/Outbound), Conversions and Production Treatment of Sick Banks Process for the Benefits-HRA Business process (Health Reimbursement Account under new Plan Type ‘5S’ & ‘5R’)
• Day to day Benefits- Leave Accrual Production Support issues and Monthly Releases.
• Quality Center Supporting, Defect Management and bug/ problem fixes for the Project Release/ monthly release test cycles.
• Remedy Change Control process for the Project Releases, Monthly Releases & Production support and problem fixes.
• Working with the Business and Functional Teams for gathering the BRD / FD requirements.
• Analyzing, Developing, Testing and Implementing the PS Queries and Security process for the User Access Reports and UAT Test Cycles.
• Project Implementations through the STAT Archive process
• Developing & Following the KPIT Document Process for the Kaiser SOX Audit Approval Process in Release Cycles.

Environment: PeopleSoft HR 8.8, People Tools 8.46/8.45 on IBM DB2/Mainframes and Upgrading to Release 9.1.

Confidential, San Diego, CA

PeopleSoft HR/HCM - Functional/Technical Consultant

Responsibilities:

• Working with phase two of the Confidential & Confidential /Admin Team for Configurations/Setups in 9.0 upgrades analysis.
• Setting up Workgroups and Day Breaker Options, Defining TRC Programs and TRC Codes
• Setting up Scheduled Groups- Defining Work Days and Schedules, Creating Static/Dynamic Groups and Security setup.
• Confidential Admin Rules- Creating Value Lists, Defining Rule Elements, And Creating Table Relationship Definitions. Creating Rules with Actions and Conditions
• Confidential Reporting Process - Approving Reported Confidential / Confidential sheets, Approving of Absence Events and Payable Confidential .
• Defining Roles and Sections, Document Process and Structure
• Setting up Template for Results Writer and Document Templates
• Setting up Approvals, Reviews and Email Notifications
• Working with the HR/Payroll, Ben Admin/Benefits/Benefit Billing Teams for the Confidential ’s Benefit Open Enrollment Process 2008.
• Working with the Benefit Vendors for UHC/PacifiCare/VSP Vision Care/MetLife Home & Auto Loans.
• Working on the business fit/gaps and configurations of the Open Enrollment process 2008, with the integration of the third party on-line Benefit tools from Mercer.
• Analyzing the process flow back and forth and documenting the Technical Specs.
• Developing New and customizing the required SQR’s/App Engine Process for In-bound/Out-bound Interfaces.
• Developed a customized Application Engine Process for FLSA - OT/DT Calculations.
• Working with the Benefits process team for Designing Functional/Technical Specs and generating test scripts, test plans, bug tracking/conducting code reviews and fixing the issues with the output results analysis on the UAT testing and analyzing the different test cases in HRBEN environment.

Environment: PeopleSoft HR 8.8 and upgrading HCM 9.0, People Tools 8.48/8.49 on Oracle 10g/Windows NT/UNIX Servers

Confidential, Sunnyvale, CA

PeopleSoft HR/HCM - Technical Lead

Responsibilities:

• Worked with the core/upgrade teams of HRIT/Global HRIS/BenAdmin/Compensation/Payroll for providing the best solutions to the business on new Developments, Enhancements on change request and providing the problem fix of Day to day Business Support on Production Issues. Upgrade Compare Reports and Analysis.
• Configuring and setting up the JobCodes for e-Recruitment process
• Working with Oracle GL Interfaces for providing the HR Data in the process of Identity Management and GL Accounts/Projects Budgeting process and Data Migration Process.
• Gathering/Collecting the Functional Business Requirements/Specification on the new Projects Developments or on the Change Request and involved in business meetings with the status reports/project plans.
• Design and Developed a couple of new Application Engine Process for Employee Savings Plan of Fidelity 401 K Catch-Up Options.
• Patch apply and Fixing up the COBOL issues for 401K contribution deductions before Tax.
• Business Process Design and Analysis and involved in Development phase of several SQR Programs for Total Compensation Process.
• This process is an Out-Bound Interface running through PeopleSoft Run control page at Server location.
• Purpose of this process is to extract the Employee Data along with all the, Benefits Data of Medical, Health, Optional Life, LTD, VDI, FSA.
• Fit/Gap analysis with the third-party application in Design and Development structure of a complex In-Bound SQR Process with Several transactions for loading the Sales Focal Employee Data into PeopleSoft Job Base Tables.
• This is process phases are, the Confidential ’s Intra Network Web Application Provides the Changed Sales Focal Data outside PeopleSoft.
• The Process reads the input data and it validated with several conditions and divides the row of data into several transactions then inserts into Job Tables in Effective Sequential order.
• Enhanced several User Interfaces (SQR’s) for Automation phase, running from Process Scheduler.
• Processing the maintenance process of Bi-Weekly Employee Paid Confidential off Loads into PeopleSoft tables using through the Import Manager Process.
• Processing the maintenance process of Monthly Employee Stock Options Load into PeopleSoft.
• Created and developed several PeopleSoft Views and Queries for different Business Reporting/Analysis purposes.
• Involved in design and development of several SQR Reports for extracting data to 3rd party vendors of Employee Gift Matching, Managing Legally and Ethically Compliances, and for the Employees Enrolling into the 3rd parties Training Courses/Sessions.
• Cognos PowerPlay Cube Development, Cognos Impromptu Catalog Building for the Employee Confidential Recording data and Payable Confidential Analysis for the Business Intelligence Process involved in HR/Payroll Business Process and Salary Budget Planning.
• Cognos ReportNet Reporting and Administration using Cognos Connection, Cognos Query Studio, Report Studio.
• Utilized Cognos Visualizer VLDB of Oracle, SQL Server and Excel Data Sources
• Employee Non-Sales Focal Data Loads (Merit/Promotion/Bonus data) into PeopleSoft, Workflow Navigation Process in BenAdmin for New Hire/Terminated Employees, Integrating the 3rd party Applicant Tracing System with PeopleSoft.
• Design and developed Templates of Functional Requirement Analysis doc’s/Technical Design doc’s and Process/Work Flow Diagrams documents and deploying on Share Point server.

Environment: PeopleSoft HRMS 8.3 Global Implementation, Kronos Confidential & Attendance, Oracle Financials, upgrading to HCM 8.9, Payroll Interface, BenAdmin, People Tools 8.17, 8.49 PeopleCode, App Engine, SQR Process/Reports and integration with Oracle GL module and Java based Confidential ’s Intra-Network Application on Oracle 8i, 10g UNIX/NT Servers.

Confidential, Fremont/Milpitas, CA

Functional- Technical Consultant

Responsibilities:

• Managing Day to day Payroll issues and Production Batch/User support
• Configuration changes for the Payroll Element Earnings/Deductions, Accumulators and calculation elements
• Development, Enhancements, Customizations, test and migrating the Problem Fix/Case Managements to the multi client on multiple projects through the PeopleSoft CRM application case Management system.
• Developing and customizing the SQR Process with the staging tables and generate the Reports based on the staging data.
• Performing the Unit test of the SQR’s developed and migrating between the environments.
• Data uploads by using the Data Mover between the environments.
• Working with PeopleSoft Inbound and Outbound Interfaces for the Fidelity Savings Plan Data transfer/exchange thorough the Interface Layers/Adaptors.
• Page, Component and Menu level customizations.
• Customizing and Enhancing PeopleCode on Job Pages and eRecruit Component Peoplecode
• Developing and Customizations of Application Engine Programs.
• App Engine tracing and performance tuning for SQL fetch and inserts using in Confidential Admin Process
• Work involved with Upgrade team for the PeopleSoft Self-Service 8.8 for Confidential itself
• Functional Support and testing of the Administer Workforce, e-Recruitment, Process monitoring. Setting up the Security and maintaining the User Profiles/Permission List
• Using the Workflow routings through Business Event Triggers process, Approval Rule Set and Component Interface Customizations in e-Apps for Self-Services.
• Worked extensively with eRecruit and Employee Self Service (eProfile, eBenefits, and eCompensation) as well as the Manager Self Service pieces of PeopleSoft as part of the Customization/Modification.
• Creating JobReq Id’s, posting the Job descriptions and requirements.
• Recruitment Process provided to the applicants (Internal and External) to submit their resumes in Resume Bank online.
• Customizations of workflow notifications to Originators, Authorizers and Recruiters.
• Verifying the Employee Referral program, evaluate the applicant eligibility and scheduling the Interviews.
• Enabling the applicants verifies through their valid Email Id and Password for review and update resumes online process.
• Developed new Application Engine programs to identify the applicants who are eligible for a requisition by comparing requisition requirements against applicant’s skills and desired job requirements.
• Involved in using the Application Messaging for providing an asynchronous integration of General Ledger Account Table with Human Resources.
• Setting up foundation tables for HR, Payroll, Confidential and Confidential .
• Customized several PeopleSoft delivered processes and developed custom processes/reports using SQR. Confidential Reporting Codes (TRC), TRC programs.
• Define the Work Groups, Reporting Confidential Type (Exception Confidential Reporting/Positive Confidential Reporting).
• Involved in Create of Templates for Rapid Confidential Reporting & Confidential and Confidential Integration with Payroll for North America.
• Preparing and Loading the Confidential and Confidential Data.
• Map and Synchronize the TRCs to Payroll Earning Codes and setting up the Multiplication Factor, Rate Adjustment Factor and Flat Amount.
• Involved in Creation of Component Interfaces for loading the online data from PS tables to the third-party systems and vice versa.
• Executed Knowledge transfer sessions to ensure enough information is transmitted (and understood).

Environment: Multi Client App support environment/model of PeopleSoft HRMS - 8.3, 8.8, 8.9 Payroll for North America, Ben Admin, Confidential and Confidential, e-Recruit, PeopleTools 8.16/8.42, PeopleCode, Application Designer, Application Engine, SQR, Crystal Reports, Oacle8i, Windows 2K/Unix Server, Citrix Servers, Workforce, Develop Workforce, e-Recruitment, e-Applications

Confidential

PeopleSoft HRMS Functional/Tech consultant

Responsibilities:

• Involved in conversion, customization and implementation of the PeopleSoft HRMS 8.3 modules based on Confidential Human Resources needs and requirements by involving in the following activities.
• Involved in created E-Profile, Employee Personal Information Change and Employee Termination Module on the PeopleSoft Self-Service modules.
• As per the client requirements, created new/modified the fields’ records, pages, and components for the E-Profile Self- Service modules.
• Created an Application Engine Program to send out an Outbound Interface which will have all the Employee Paycheck Details, Deduction Balances, Earnings Balances, Fed Tax Data, Garnishment Balances, Pay Other Earnings, and State Tax Amounts after each Pay Period.
• Print Payroll Checks and Advices, create Interface File to Fleet Bank for Direct Deposits and created Interface File to Fleet Bank for Checks Issued.
• Setup Salary Administration Plan, salary grade and salary step tables.
• Administer salary plan and grade and step for business process.
• Plan Salaries - Created employee salary summary reports. Over view salary increase budgeting and planning business process.
• Created multiple custom payroll reports and interfaces for hourly and salaried employees (earnings and deductions) that integrate with Confidential and Confidential .
• Modified PeopleSoft delivered payroll and benefits register reports.
• Configured and maintained all the tables involved in Payroll processing, such a Pay calendar, Job Code, Tax tables, Deductions and processes such as Pay sheet creation, Pay calc, pay confirm, Tax Updates etc.
• Setup service leave accrual control tables, service parameters and flexible service track.
• Designed and developed custom interfaces for different providers with reference to their system data format using SQR.
• Worked on SQRs for updating Bonus module (Incentive Table), some instances used PL/SQL procedures also and developed and customized Record definitions, Pages, Components, ad-hoc SQRs & ad-hoc queries, inbound and Outbound interfaces.
• Developed Run Control Pages as per corporate requirements and attached to menu to run the SQRs online.
• Involved in online changes like adding customized translate values, modifying People Code, adding fields to pages and modifying Components and menus.
• Extensively worked on People code to validate workflow functionality in Self-Service module.

Environment: PeopleSoft 8.3 (HR, Payroll, Benefits, Self-Service Modules), PeopleTools 8.17, UNIX, W2K, Oracle8i, Windows 2k and Adv.Server, Oracle 8i, People Tools 8.17. PeopleSoft 8.3(HRMS) E-Profile, E-Recruit, E-Benefits, Employee Self-Service Modules, Benefits, Payroll Interface

Confidential

Functional - Technical Consultant

Responsibilities:

• Worked as a techno-functional consultant with Comm.
• Bank PeopleSoft Application Management Team Day to day Production Support of Problem Management and worked with the team of Informatica Power Center.
• SDLC on Change Request of Minor/Major Enhancements based on Customer Specifications. Problem analysis/Problem Replicate/Tech Design/Build and Test.
• Production Support on Global Payroll Australia: Analysis of Process for Payroll/Absence Run and Group List Run for CBA’s fortnight Calendar Pay cycles.
• Setting up the configurations of Global Payroll Rules like Accumulators/Elements and Retro Triggers, Formula, Variables, Streams.
• Design, Develop and Customize App Engine Programs, Using Peoplecode, SQR and working on Global Payroll SP1 Patch testing and upgrading/applying on PeopleTools 8.1x.
• Global Payroll Australia- Service Pack 1 (SP1) - Upgrade, Test Scripts for End User.
• Involved in the upgrade of People Soft HRMS, Payroll, and Confidential & Confidential and Benefits modules from version 8.3 to version 8.8. Responsible for modifying & upgrading several customized SQR reports, PS Integration Tools and SQR Scripts on UNIX systems.
• Worked with the upgrade team to migrate the customizations and new enhancements to HRMS 8.8.
• Involved in the Fit-Gap analysis and the Upgrade analyzed report sessions to sort out the new functionalities to be added to the existing system.
• Worked with 8.4 related tools like Internet Options, worked and created new pages, components and modified existing pages and components.
• Worked with Confidential Reporting Codes (TRC), TRC programs
• Developed the Application Engine programs to identify the PIN’s and Purging its unwanted data rows occupies huge volume of space in Global Payroll Process Result tables - GP Accum Results, GP Result Pin’s.
• Global Payroll business process and run GL Prepare/Final for publish the payroll data to GL module using with the integration tool of the Application Messaging.
• Employee Self Service (ESS) - (Update Personal Information and Registration, Compensation)
• Conducted detailed design sessions with the Functional team to define requirements and deliverables related to all Customizations and Modifications. Worked extensively with the Employee Self Service (eRecruitment, eProfile, eBenefits, and eCompensation) and Manager Self Service.
• Integrate the PS8.3 and HR Connection breadcrumbs to ensure intuitive and seamless navigation of the entire HR portal.
• Provided the detailed User Navigation Designs on Customizations and modifications to the End Users.
• Worked with the team of Informatica PowerCenter for the Day to day ETL process of the Combank Data warehouse operations in relation with PeopleSoft Hr/Fin Data, and Decision Support Business Intelligence Analysis.
• Design and Develop the ETL Mappings and Transformations for Loading the Data into DSS DataMarts in different levels.
• Deploying the Cognos Impromptu Reports on Impromptu Web Report Server.

Environment: PeopleSoft - HRMS 8.3, Global Payroll Australia, Confidential & Confidential Financials, GL/AP/AR/PO and People Tools 8.1 xs, IBM DB2, UNIX, WinNT

Confidential

Techno-Functional Lead

Responsibilities:

• Plan Salaries – Created employee salary summary reports and over view of salary budget increase and planning the business process of hierarchy buckets.
• Configured and maintained all the Oracle tables involved in Payroll processing, such as Pay Calendar, Job Code, Tax tables, Deductions and scheduling a process of Pay Identifications, Pay Calc and Pay Confirm.
• Set Services for Leave Accrual control tables.

Confidential

Technical Lead

Responsibilities:

• Customization of Reports, and Data Migration.
• Testing/User support and training to End Users.
• Responsible for Applications Support and Maintenance.
• Production support and customization on HRMS- Global payroll, Benefit Admin, Financials -GL, AP, AR and PO Modules, using PeopleTools, PeopleCode, SQR reports and worked with the technical team application developments and Database Administration Oracle 7.x/8i.
• Design, Developing, Customization, Configuration and Report Generation.
• Performed application analysis including data mapping by developing and modifying SQR applications for the department's PeopleSoft upgrade.
• Problem fixing any Daily/Weekly Interfaces to outside vendors and guiding the new users from exult with any production problems.
• Developed a Tax update SQR process thru the End of the Year Process.
• Built a customized application required by the business that allows supervisors to approve Confidential for other dept employees. Delivered application allows only one alternative supervisor. Custom application allows more than one alternate supervisor.
• Developed a process using App Engine that will archive leave accrual data and Leave Loading process for all the employees.
• Built a custom page that will show archived leave entries for employee based upon the search criteria.
• Developed app engine program that utilizes component interface along with workflow to systematically invoke emails to all the employees.

Environment: PeopleSoft 8.0 – HRMS, Financials/Oracle/WinNT/Unix

Confidential

Technical/Functional Consultant

Responsibilities:

• Personnel Management, Payroll Management, Recruitment System, Training Administration
• Set-up of Oracle Payroll (Grade Rate Tables, Payment Methods, Payroll Description, Element Description, Element Links)
• Element calculation rules using Oracle Fast Formula for 65 elements covering Earnings, Deductions, Statutory Elements like Bonus, Gratuity etc as per Indian legislation rules
• Payroll cycle with Pay Processing, Costing, Retro Pay
• Interface of the Payroll System with the Core Banking System
• Using Application Data Exchange for Salary Administration
• Actively involved in providing inputs to the Technical team towards the functional process clarifications in specific customizations in the areas of Payroll Reports, Interface and Data Migration etc.