SUMMARY

• Over 12 years of Comprehensive experience in PeopleSoft HCM,  Information Technology space spanning Enterprise Applications, Client Server and Internet technologies in designing and delivering business solutions to the clients across multiple industries.
• Functional lead experience in full life cycle including requirement gathering, business process analysis, design, development, Configuration, Testing, upgrade, implementation and maintenance of various applications using PeopleSoft,Oracle8.x/9.x/10.x, Client Server and Web Based applications. Involved in CMM Level 5 Quality processes.
• Having 3 Payroll implementation and 2 Upgrade project experience end - to-end and 7 years experience in PeopleSoft ASM practice.
• Extensive experience in lead roles managing teams of various sizes in deploying Oracle PeopleSoft projects both at onsite and offshore.
• Expertise in business processes of Human Resources, NA Payroll, Global Payroll, Benefits, Workforce Admin, Ben Admin, Benefits Billing, ESS modules (eProfile, eCompensation, ePay and eBenefits), MSS, Recruitment and Security.
• Good knowledge in TAM, Time and Labor; Very good hold on MS Technologies - SQL Server; PS Technologies - PeopleTools and related technologies such as Application Designer, Peoplecode, Application Engine, Data Mover, Process Scheduler, Component Interface, Workflow, Data Archiving, Security, SQR and PS Queries. Miscellaneous such as Mainframe, TWS (Tivoli Workload Scheduler), Auto Sys, HP Service Manager, JIRA, PVCS, PPM (Project and Portfolio Management Centre), Inovis BizManager Bizlink for Transmission, BMC (Foot Print), Kronos TimeOnline and Application Suite (Mobius) for report repository.
• Highly Versatile Lead with ability to perform under stress and volume.
• Excellent Interpersonal, Organizational and Communication skills. Have good analytical reasoning, creative skills, and technical & domain knowledge.

TECHNICAL SKILLS:

ERP: PeopleSoft HRMS 8.x/9.x North American Payroll. PeopleSoft HRMS 8.x/9.x Benefits, Benefits Billing and Ben Admin, PeopleSoft HRMS 8.x/9.x Global Payroll, PeopleSoft HRMS 8.9/9.x Self Service eProfile, eCompensation, ePay, eBenefits and MSS, PeopleSoft HRMS 8.9/9.0 Workforce administration, PeopleSoft HRMS 8.9/9.x Talent Acquisition Manager.

PeopleTools: Application Designer, Application Engine, PeopleCode, Component Interface, Data Archiving, XML Publisher, Integration Broker and Workflow.

Data Migration Tool: Data Mover.

Reporting Tools: SQR and PS Query.

Administration Tools: PeopleSoft Security, Process Scheduler.

Database: SQL Server, Oracle 9x/10x.

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

MS Technologies: ASP, HTML, JAVA SCRIPT.

Miscellaneous: Time2Work, Kronos Time Online, Mainframe, Shell Script, TWS (Tivoli Workload Scheduler), Auto Sys, BMC, HP Service Manager, PVCS, PPM (Project and Portfolio Management Centre), JIRA, Inovis BizManager Bizlink for Transmission and Application Suite (Mobius for report repository).

PROFESSIONAL EXPERIENCE:

Confidential, Austin, TX

PeopleSoft Lead

Responsibilities:

• Served as the PeopleSoft Lead, Functional Lead and Key decision maker for any PeopleSoft HCM related issues and enhancements.
• Provided support and recommendations on Payroll Processing, Leave Accruals, Benefit Plans, integration with various applications, Complex Interfaces and Processes, reconciliation of data, HR Reports and Time off Requests.
• Reviewed new business processes and solution designs to ensure that cross-functional teams fully understand the impact of decisions made during a system configuration.
• Served as subject matter expert on the use of HR systems, keep apprised of new functionality, and make enhancement recommendations.
• Managed day to day activities of project team members, planning, organizing and assigning work to technical and functional team.
• Collaborated with project team members to solve business and technical problems
• Managed and prioritized project activities with HR, Payroll, Benefit leads
• Facilitated communications among various stakeholder and internal client groups
• Collaborated with testing team lead in the use of Rational tool to log and track testing defects
• Mentor users in system use, monitor move to production and tandem operations
• Work with end users on new business processes stemming from best practice
• Sustain production support by documenting bugs and assist with bug resolution
• Document initial performance metrics and on-going monitoring process and participate in project closure.
• Provide post-production support across all deployed modules.
• Designed the MDM Integration between Finance and HCM.
• Prepared functional documents and designed various complex interfaces such as Time2Work, General and Garnishment deductions for Company Transfer, Leave Accruals for company Transfer, Terminate the Direct deposit, Liazon Inbound and Outbound, Success factor, Newport Group 401K inbound, Wage Works Outbound, EZSystem employee feed and Egencia Interface.
• Prepared the Functional Specification for EDS Delegated security, Forgot Password for Self-Service & Production and coordinated with Technical team on development.
• Participated SSO (Single Sign on) in PeopleSoft which allows users to sign in PeopleSoft with their Active Directory credentials.
• Replaced third party custom process Cloud Mills with PeopleSoft delivered Smart Hire Functionality.
• Automated the Bonus and Commission data upload into Payroll.
• Designed the Canada Holiday Calculation Process which automated the Holiday Calculation for Canada employees.
• Fully responsible for PeopleSoft HCM Cloud Implementation.
• Extensively handled the Tax updates, Open Enrollment, EEO Reporting, W2 Processing and T4 Processing.
• Implemented the Total Reward Statements for Current and Fiscal Year, Company Directory and Direct Reportee.
• Automated the FFL (Federal Fire Alarm) request process.

Environment: PeopleTools 8.53, HCM 9.2, Core HR, NA Payroll, Benefits, TAM, Self-Service, Time2Work, PS Query, Oracle 11g, Windows 7, Share Point and BMC.

Confidential, Charlotte, NC

Functional Lead

Responsibilities:

• Key role of Functional Lead for NA Payroll and Benefits Modules.
• Provided PeopleSoft functional consulting services by acting as subject matter expert and leading clients through the entire systems development lifecycle.
• Gathering business requirements on all the applications under scope and base-lining them.
• Conducting fit-gap analysis workshops with the business owners and Organizing design sessions based on base-lined business requirements.
• Responsible for translating high-level business requirements into detailed function design specifications, as well as managing requests for changes to the specifications.
• Prepared the Keep drop Analysis document, Functional Fit Gap Specification, Configuration, As Is documents for Payroll/Benefit module.
• Worked extensively on Benefits, Benefit Billing and NA Payroll Setup and provided solutions to replace the existing customizations for more flexible and efficient business process.
• Redesigned the existing Payroll Processing configuration and Implemented a fully owned, custom designed Payroll Parallel Processing solution to overcome the problem of slower payroll timings that brought down the Pay calculation time to max 20 min and Pay Confirmation to 15 min from 5 hours.
• Provides accurate timeline estimates for proposed solutions and takes ownership of those estimates.
• Identify gaps in established processes and re-engineer, where appropriate, to maximize efficiency and effectiveness of the existing operating model.
• Perform detailed functional activities based on project cut over plan schedule.
• Provided user support for needs analysis functional design of solutions process improvements and upgrades. Performed system testing training and data reporting support as well as system troubleshooting assistance.
• Responsible for the trainer program and training materials development and training various stakeholders on the use of the system.
• Coordinated areas of all phases of application testing, including preparation, execution and installation support to assure quality system changes.
• Extensively worked on Benefits Life Events and configured custom Life events as per business requirements.
• Extensively worked on Benefit Billing Module and configured Parameters, creating calendars and enroll into Billing, Calculation and Creating statements.

Environment: PeopleTools 8.53, HCM 9.2, Recruiting, CoreHR, NA Payroll, Absence Management (FMLA and Non-FMLA Leave), Benefits/Ben Admin, Self-Service, Reflexis, Timera, PS Query, Oracle 11g, Windows 7/Unix, Share Point and Lotus Notes.

Confidential, Washington, DC

Principal Consultant

Responsibilities:

• Key role of Functional & Technical Lead for HR and Global Payroll Modules.
• Mapping Payroll processes to elaborate a GAP Analysis and identifying the customizations required to fulfill the business processes.
• Elaborating Fit-Gap Analysis, proposing possible solutions to develop new functionality and some workarounds.
• Facilitated all meetings with SMEs, business sponsors, end users, developers and offshore team.
• Wrote requirements and functional design specs for 25 Global Payroll Gaps and 160 custom reports to accommodate the standardization of multiple US and global office procedures.
• Configuring payroll elements such as Pay Entity, Eligible Group, Element Group, Earnings/Deductions, Formulas, Arrays, Variables, Accumulators, Brackets, and Writable Array etc. according to client’s payroll processes.
• Wrote complex rules as per business requirements.
• Extensively worked on Payee Data, Pay Calculation, Banking information, Confirm and Banking Process etc.
• Assigning task and responsibilities to members of the team, including functional and technical activities.
• Coordinated all phases of testing, including test plan creation, data conditioning, script creation, execution and re-testing.

Environment: PeopleTools 8.52, HCM 9.1, Global Payroll, NA Payroll, Benefit Administration, Workforce Admin, Personnel Admin, Pension Admin, Custom ESS, MSS, Bolt on Modules (SRS, TAX, eGive, My Job World etc. ), PS Query, Oracle 11g, Windows XP/Unix,, Lotus Notes.

Confidential, Cleveland, Ohio

Sr. Associate

Responsibilities:

• Key role of Team Lead and Senior Techno Functional Consultant.
• Report the daily progress to the Management that includes information like Project status, issues, improvements and expected risks.
• Make the effective use of Standard Process and Tools for Managing, Maintaining and taking the expansion.
• Manage and drive Teams located in different Geographies from a stand point.
• Track the issues related SIT, UAT and Production environment using service Manager.
• Implement other processes like system testing, revision control, versioning, documentation and code review.
• Create and analyze a high level view of applications and determine the goals.
• Cost benefit analysis, risk management planning, fitgap analysis and economical, operational and technical feasibility study of the system and make it available for detailed technical analysis.
• Extensively worked on Oracle bundle/Tax updates implementation plan, retrofit activities, EEO Compliance, UAT, SIT and Pre/Post-production tasks.
• Worked with Confidential Human resources users to define requirements and developed the implementation plans pertaining modules such as NA Payroll, Benefits, Work Admin, Ben Admin and ESS.
• Worked on the Key Bank’s PeopleSoft Suite applications portfolio to determine the daily and weekly strategy for extracting the data from various data resources.
• Creations and validation of the project planning, feasibility analysis and impact analysis documents.
• Analyze PeopleSoft, Oracle 8.x/9.x/10.x setup at key and develop implementation and support process to help the support model.
• Production rollout planning and implementation of Mainframe components.
• Validate the deployment code successfully and ensure that the latest data available for the business users.
• Assist the business users for on acceptance testing along with the managing test cycles to ensure the deliverables are in line with committed in the respective statements of work.
• HR Suite have various internal/external vendors like ADP - Probusiness Division, ADP Commuter, ADP Tax, ADP Tax Credit, Cigna, Eye Med, Fidelity Investments, Hewitt HRS, Learn, Lexis Nexis, Mbenefits, Medco Health Solutions, Next Jump, Ohio New Hires, Talx, UHC Cobra, UHC FSA, United HRS, Wage Works AND World Travel, CE Desktop, TIPS and ARIBA.
• Created functional specifications documents by interacting with the clients and understanding their business requirements.
• Created High-level, detailed technical design document to determine fields from various data sources, business rules, process workflows and entity relationship diagrams.
• Design and document solutions by creating production run book for fixing critical issues and pointing out future enhancements.
• Design and Perform development/support activities using People Tools, Application Designer, People code, Application Engine, Data Mover, Process scheduler, Component Interface, Workflow, Security, SQR and PS Queries.
• Performed root cause analysis on incident and plan for fixes.
• Fine tuning program along with performance parameter.
• Create and execute queries to validate data transformation rules and to verify the output data in the database.
• Created test bed, strategy to test the production ready component for integrity, operability and to make sure the data originating from source is making into target database.
• Extensively worked in Year End and Open Enrollment activities.
• Developed JCL, PARM and Unix Shell Scripts to execute Jobs in TWS.

Environment: PeopleTools 8.49, HRMS 9.0, NA Payroll, Benefit Administration, Workforce Admin, TAM, ESS, MSS, Resume Processing, Employee Portal and HRMS Portal Pack, PS Query, Kronos TimeOnline, Mainframe, Oracle 10g, Windows XP/Unix, TWS for Scheduling, HP Service Manager, PVCS, PPM (Project and Portfolio Management Centre),Bizlink for Transmission, Application Suite (Mobius for report repository),Lotus Notes and HR Technology Workbench.

Confidential, NewYork

System Analyst & Onsite Lead

Responsibilities:

• Key role of System Analyst and Onsite Lead.
• Extensively worked on Tax Updates & developed new process to calculate the MTA retro tax for all eligible employees.
• Co-ordained with users and existing team for knowledge Transfer and prepared KADs (knowledge Acquisition Document).
• 24/7 support for resolving the issues/CRs reported through PHIRE on HR, Payroll, Benefits and Ben Admin modules.
• Co-ordinated with business users to make them understand the benefit Stream process, DR feed, IVR (PEL) interface (Enrollment data from my benefit system) & FLS (federal Liaison Service) interfaces.
• Analyzed the existing processes and provided better solutions & modification to improve the system efficiency.
• Collected the requirements from Infinium, JDE systems and Prepared Functional/technical documents & Coordinated with team to develop the processes.
• Confidential has a business need to record paid time off (PTO) for its Exempt employees. Currently MTVN HR does not systematically track PTO for its Exempt employees. With this customization Exempt employees will input exception time (vacation, sick, optional days taken). Also allows all current users to enter corrections for previous periods (restricted to x periods (setup initial value to 2 in configuration table)). Created Custom Page, Application Engine and SQRs.
• Modified the salary band Process and LTD ABBR Process for new enhancements.
• Analyzed the KRONOS Feed, Intuition - Tuition Reimbursement, STOCK OPTION EXERCISE (Restricted and Non-Restricted Stock options), Bonus (STIP) and commission load process, AFLAC - (American Family Life Assurance Company), GLTC (Group long term Care, GUL Supplemental Process (Group Universal Life), GVUL (Group Variable Universal Life insurance) billing interface and Executive LTD billing Process (Winged Heel) & redesigned few of them for better performance.

Environment: PeopleSoft HCM 8.9, PeopleTools 8.48, Oracle 9i, SQR 6x, Windows NT/UNIX.

Confidential, Boston/Florida

TechnoFunctional Consultant, Track Lead

Responsibilities:

• Key role of Senior TechnoFunctional Consultant, Track Lead.
• Planning & Work Load Management for Operations, Batch Support, Tax Updates Analysis, Retrofit and issues reported thru ITSM (ASM Ticketing System) & RFC (Request For Change System).
• Expertise in analyzing tax updates - Deploying & compiling Cobols and Copybooks, Go-No Go decision with custom objects, Planning and executing tax updates testing by interacting with Payroll/Finance Manager, Tax Specialists. Obtaining sign-off and moving to Production.
• Analyzing change requirements for Payroll/Benefits setups, configuring, testing and interacting with payroll & Benefits to obtain sign-offs.
• Regular Support Activities - Monitor Payroll Errors/Warnings each cycle and take corrective measures. Coordinating with Business Units on resolving data errors.
• Daily Support Activities - Resolving issues reported through mails/calls/fax. Granting/Changing approved Security Requests, Correction Request, Hire/Rehire requests.
• Extensive knowledge in Batch Job Support. Defining Schedule of Jobs, Setting dependency and conditional execution setups.
• Extensively worked on refresh benefit snap shot BEN100A & Snap shot premium calculation BEN110 processes.
• Payroll Special Processing - Planning and designing of schedule adjustment, obtaining approval, execution of special schedules.
• Involved in Open Enrollment, Quarterly & Year End Processing - System Configuration, Technical & Functional Support for Balance Adjustments, W-2 Adjustments, Tax Reporting to ADP, YE Forms generation W-2, W-2c etc.
• Took the tremendous responsibilities to complete all the issues and make the Process more efficient within short span of time.
• Payroll/Benefits/HR Process Checklists, Issue Tracking and Status Reporting.
• Developed queries on need basis.
• Developed Automation Process for User Profile using CI and AE.

Environment: PeopleSoft HCM 9.0, PeopleTools 8.48, Oracle 9i, SQR 6x, Windows NT/UNIX.

Confidential, Florida

Onsite Coordinator, Project Lead

Responsibilities:

• Key role of Onsite Co-Ordinator, Project Lead.
• Involved in implementation of Global/NA payroll/Global Payroll/Base Benefits/ESS and HR Modules.
• Involved in requirements gathering, Fit Gap analysis and customizations.
• System Configuration, Go-Live Plan, Production checklist and Migration.
• Prepared FitGap, Configuration document, user manual preparation and given training to end users.
• Co-ordinated with functional team to setup Elements, Payroll rules, Payroll processing, Absence processing, Segmentation and Retroactivity.
• Involved in setup the element groups, eligibility groups, pay entity, calendars, calendar Groups, brackets, formulas, proration rules, banking information and elements (duration, variable, date, formula, message, rounding rule and count elements).
• Collected the requirements and prepared Functional/Technical design specifications for internal/external interfaces/processes like timesaver, Merrill Lynch, Cigna and general ledger etc.
• Voluntary taken up the responsibility to do UAT/SIT/Parallel & integration testing, Go Live activities and Pre/Post Production support.
• Proficient knowledge on Leave accruals and worked on sick and vacation leaves.
• Designed the Garnishment Payroll Process for Garnishment Vendors & Produced Vendor checks.
• Analyzed the JDE Finance GL Process and replicated/redesigned in PeopleSoft.
• Expertise in Chart fields, GL Business Units, GL/HR Business Unit Mapping, Activity Groups, Expense Mapping, GL/HR Business Unit Mapping, Valid combo table & Combination codes. Customized the PAYGL01 and also developed new Process send the details to JDE specific Format.
• Worked on Currency Exchange rates, Wire transfer for the other currency Paid Employees.
• Involved data migration & validating the data migrated (Earnings/Deduction/taxes, garnishment balances and Check YTD & Employee Payroll/benefits/HR data etc) from JDE system.
• Created Common online pages and SQC libraries for File Path setup, parameter table setup and process specific setup which served and reduced the work on other interfaces.
• Developed Workflow to distinguish between the Internal and External Applicants and send a more personal note to the internal applicants and further to send a Worklist notification to the Recruiters for the pre approval of applicants.
• Setup User Profiles, Roles and Permission Lists and created Access Groups.
• SetUp the audit records to track the changes.
• User Training and Managed on-going maintenance and support in enhancing and optimizing the on-line Human Resource Management System (Post-Implementation).

Environment: PeopleSoft HCM 9.0, PeopleTools 8.48, Oracle 9i, SQR 6x, Windows NT/UNIX.

Confidential, Memphis

Functional Consultant

Responsibilities:

• Played a key role of Functional consultant and collected functional requirements and created functional specifications for strategic to upgrade the current system PeopleSoft 8.3 to PeopleSoft 9.0.
• Participated in the Fit/Gap Analysis and identified PeopleSoft customizations, Interfaces to meet the business requirements.
• Collected the requirements on the existing PeopleSoft, the external system like Mainframes, Lotus Notes and its data, and made recommendation for a business process reengineering (which was implemented) for compatibility after executing the Fit-Gap Analysis.
• Prepared the Keep drop Analysis document, Functional Fit Gap Specification, Configuration, As Is documents for Payroll/Benefit module.
• Worked extensively on Benefits, Payroll Setup and provided solutions to replace the existing customizations for more flexible and efficient business process.
• Analyzed the existing COBOL Processes, Unix Shell Scripts on interfaces, Processes and reports and provided the impact analysis.
• Redesigned the existing General Ledger Process and given detailed analysis for required customizations for better performance.
• Given the Presentation to end users on Benefits/Payroll for North America 9.0 enhancements.
• Performed analyses of upgrade compare reports. Apply enhancements to custom SQR programs, Queries, Menus, Tables and Panels.

Environment: Windows NT, PeopleSoft HRMS 8.3/9.0, PeopleTools 8.46, Oracle 10i, SQR 6.x.

Confidential, NJ

Technical Team Lead, Onsite Co-Coordinator, Sr.TechnoFunctional Consultant

Responsibilities:

• Lead the team of NA payroll customizations & Interfaces.
• Involved in implementation of NA payroll and HR Modules.
• Requirement Gathering, Analysis, Study legacy to identify the gaps.
• Efforts estimation on enhancements and Change Requests during Implementation/ASM.
• Review of design documents for the requirements, UAT/SIT/Parallel & Integration Testing and Post implementation support activities.
• Enforced procedures and guidelines during all phases of the development lifecycle.
• Co-ordination with Offshore team for Knowledge Transfer and Reviews.
• Co-ordination with external applications team for resolving integration issues.
• Analysis of Defects, Preparing PoC, Solving Issues and track the issues thru MQC System.
• Coordinated with Technical team and successfully developed 20 Payroll and 25 benefits external/Internal vendor Interfaces like GFS, Positive file, BOA/Citibank Recon Plus, PWC Main 1/Main 2, Garnishment, Corporate Bill Outbound/Inbound, Talx Unemployment, CCAP, BCBS and NY Differential Calculation.
• Performance Tuning of major interface - GFS which contains the core result of the payroll and the backbone of the payroll accounting. Tuned and brought down the execution time to max 30 min from 8 hours.
• Prepared the functional/Technical specifications for the staging table load Process, which interfaces PeopleSoft with customized/internal application/external vendor’s applications such as Payroll, Benefits, and Stock options etc and load the data into PSHUP TXN and will be used to create Paysheets through PeopleSoft Load Paysheet Transactions COBOL process.
• Profound knowledge on COBOL Paysheet creation Process analyzed and prepared document the way it works for each pu source. And suggested alternative solutions for client requirements.
• Handled critical and most complex payroll interfaces. In the Merrill Lynch process, decoded the core US payroll taxation process and prepared the design deliverables with exceptional quality.
• Involved in Analysis of PeopleSoft Load Paysheet Process and created an Equivalent Process for Paysheet creation and loading through Application Engine Process. Also prepared requirements/UTP/Technical design documents.
• Troubleshoot and resolved system maintenance issues.

Environment: PeopleSoft HRMS 8.8, PeopleTools 8.46, Peoplecode, SQR 6.0, PS Query, Oracle 9.x, Windows NT.

Confidential

TechnoFunctional Consultant

Responsibilities:

• Performed Gap Analysis and was responsible for finding the gaps between the legacy systems and PeopleSoft Applications.
• Wrote the functional requirements and technical specifications.
• Involved in developing data conversion strategy to bring the data from legacy system to PeopleSoft application tables incorporating validations and data transformations.
• Developed number of Conversion SQR for Data Conversion and Migration.
• Created many batch programs using SQR reports and Application Engine, few to run manually and used Process Scheduler to schedule others.
• Developed new Records, Online Pages, and Run Control Pages using People Tools for the specific needs of the company. Implemented People Code for online validations and user interface.
• Done performance tuning of various AEs, SQR and records (created Indexes).
• Developed number of Out/inbound interfaces, reports using SQR to read the data from file and load it into PeopleSoft tables, and send data from PeopleSoft to other interfaces.
• Involved in doing code reviews of PeopleSoft objects as per checklist before delivering the projects to the client.
• Implemented Complex business logic using Peoplecode.
• Created custom records and wrote Peoplecode to keep track of Employee information changes.
• Developed Workflow to distinguish between the Internal and External Applicants and send a more personal note to the internal applicants and further to send a Worklist notification to the Recruiters for the pre approval of applicants.
• Customized paycheck interfaces & yearly earning statement reports.
• Created custom SQR Reports/Processes in the areas of HR, Payroll and Benefits including Payroll to GL interface, Labor Distribution Reports, Outbound Benefits Interfaces to Providers, Pay Update Program to create Pay sheets from Time Entry data.
• Actively involved in the testing and issue resolution during the parallel run period of the implementation and the postproduction support.
• Worked with HR on the annual pay rate change business process.
• Responsible for Defect and Issue prevention by analyzing, preventing and eliminating the defects.
• Responsible for conducting Defect Prevention meeting which involve the discussion on common causes, defects that have been detected during that period which could be a possible cause of defect in the future.
• Educated the team members on the importance of review effectiveness, thereby reducing the testing defects.
• Prepared the Defect Prevention report which gives a snap shot of the major, minor and fatal defects and causes of the defects and the actions to be taken to prevent such defects in future.

Environment: PeopleSoft 8.8, PeopleTools 8.4, Window2000, Windows NT 4.0, Oracle 8i, Peoplecode, PS/Query, Application Designer, SQL, SQR, Process Scheduler, Application Engine.