SUMMARY

• He has over all 10+ years of progressive IT experience as a PeopleSoft Techno Functional Consultant in Upgrade, Production Support, Implementation, Conversion and Customization of the PeopleSoft HCM applications. Extensive work experience in PeopleSoft HCM modules of Core HR, Payroll for North America, Position Management, Benefits, Time & Labor and ePay.
• Proficient in all phases of the system development life cycle including requirement definition, data conversion, system implementation, system testing and acceptance testing.
• Extensive functional knowledge on the PeopleSoft HCM modules like Core HR, Payroll for North America, Time and Labor, Benefits, Position Management, ePay and the custom Bolton projects.
• Strong technical expertise in People Code, Application Package, SQRs, Component Interface, Application Engine, File Layout, PSQUERY and Workflow Engine.
• Expertise in Application Designer, Process Scheduler, PS - Query, Integration Broker, Excel to CI, Web Services, BI Publisher.
• Developed and modified Outbound and Inbound SQR interfaces.
• Proficient in writing complex database reports and customizing PeopleSoft Delivered SQR reports.
• Extensively worked with multiple systems and the integrations between different systems (Core HR, Payroll for North America, Benefits, Recruitment, Performance Management and Time & Labor).
• Performed extensive debugging and performance tuning of various processes. Well versed in utilizing tools and utilities PC Debugger, Application Engine trace for troubleshooting.
• Developed the Data Conversion Tool to convert the HCM data from PeopleSoft to Workday.
• Experience in Business Customer Interaction, Requirements gathering, Fit-GAP analysis and documenting the requirements / Functional Specifications.
• Expert in setting up the full HCM configurations in PeopleSoft (Set ID, Business Unit, Company, Department, Location, Job Code, Position, Pay Group, Pay Run ID, Balance ID, Pay Calendar, Earning & Deduction Codes, Benefit Plans and Tax Gross Components etc).
• Extensively worked and provided functional support on the whole payroll processes like Paysheet Creation, Pay Calculation, Pay Confirmation, Pay Distribution Processes, GL Interface, Monthly & Quarterly Tax Filing Processes and Year-end activities.
• Hands on experience in all the Core HR transactions like Hire, Rehire, Terminate and transfer etc.
• Extensively worked on PeopleSoft Time & Labor modules and developed template based and ser exit rules.
• Performed extensive debugging on Payable Time & other Time and Labor issues.
• Actively worked on the benefit enrollment and termination processes.
• Experience in Business Requirements gathering, Fit-GAP analysis and writing Functional and Technical Specifications.
• Extensively worked on ESS & MSS transactions and fluid user interfaces.
• Actively Performed the analysis on ePay (Fluid View Paycheck & PDF Federal & State W-4 Tax Withholding forms) and identified more than 60 defects during the upgrade from PeopleSoft 9.1 to 9.2. Worked on that to fix all the issues.
• Tremendous experience in the preparation of Test Plan, Test scripts, Test Data and Requirement Traceability Matrix. Also, the execution of test scripts, Reporting the bugs and preparation of Test Summary.
• Worked extensively in setting up Security Setups.
• Extensively worked on interfaces and conversions from Legacy/third party systems to PeopleSoft using SQR.
• Worked on applying, retrofitting and testing of tax update & HCM bundles.
• Hands on experience in HPQC, Maestro tool, HPSM, Test Link, Share Point, Lotus Notes and Stat.
• Implemented and upgraded the application by following the SDLC.
• Excellent Communication Skills
• Strong presentation and demonstrating skills; Confident, articulate and professional speaking abilities.
• Good team player and communicates effectively to enable execution of projects flawlessly.
• Experienced in full life-cycle implementations, application upgrades, application support and maintenance.
• Results-focused, quality-driven professional and dedication to organizational goals.

TECHNICAL SKILLS

ERP: PeopleSoft 8.0/9.0/9.1/9.2 People Tools 8.x, Application Designer, XML Publisher, Application Engine, Application Package, PeopleCode, File Layout, Data Mover, Tree Manager, Mass Change, Process Scheduler, Application Messaging, Component Interface.

Database: SQL SERVER, Oracle7.x/8.x/9.x/10g/11g/12g Toad. SQL developer, AQT

Operating System: Unix, Windows NT, Windows 2000, Windows 98, Windows XP, Windows 8

Reporting Tools: PS Query, SQR, Application Engine, Hadoop Impala, Hive

Programming Languages: PeopleCode

Functional Modules: Workforce Administration (Core HR), Payroll for North America, Position Management, Time and Labor, Benefits and ePay

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Senior Software Developer

Responsibilities:

• Worked with the Business analysts and the Work Brain team to get the full understanding about the requirements.
• Analyzed the existing programs for T&A load, T&A Validation, Rate calculation and Premium calculation processes and got the full understanding of the existing processes.
• Worked with the Business Analyst and provide the support for preparing the Functional Design Document.
• Developed the Technical Design Document based on the WAB changes and get it approved by the project team
• Customized the Application Engine, Component Interface, File Layout and SQR programs (T&A load, T&A Validation, Rate calculation and Premium calculation) to incorporate the requirements to process the WAB & Non-WAB scenarios and avoid the manual payline updates.
• Developed the unit test scripts and performed the unit testing.
• Worked with the SIT & UAT team and provided the support during the testing time frame.
• Finalized the objects and provided the support during the production implementation.
• Providing the post implementation support.

Environment: PeopleSoft 9.2, People Tools 8.56, People Code, SQR, Application Engine, Component Interface, File Layout, Oracle.

Confidential, Phoenix, AZ

Senior Software Developer

Responsibilities:

• Responsible for technical analysis, design, development and documentation of PeopleSoft applications.
• Developed custom/customized applications in Core HR, Payroll for North America and Absence Management modules.
• Coordinated with business/functional users to gain a good understanding of their requirements for the data conversion.
• Provided technical solutions, estimating development efforts, performing design and development.
• Coordinating with the IT team of the source systems (PeopleSoft, UltiPro and Paycom) and get the required PeopleSoft format.
• Developed the new data conversion programs and Customize the existing programs (Application Engine, Component Interface and File Layout) based on the business requirements.
• Converted the active data from different sources (PeopleSoft, UltiPro and Paycom) and loaded into PeopleSoft development instances.
• Conducted the unit testing for fixing all the issues and make sure the converted data is accurate.
• Finalized the coding and manage code migrations.
• Worked with the SIT and UAT team during the test time frame and parallel payroll processing.
• Provided post go live support to PeopleSoft Applications.
• Worked with source systems for converting the History data from PeopleSoft, UltiPro, Kronos, Taleo, VLM, Hover and Paycom to Hadoop.
• Worked with the Hadoop team to load the data into Hadoop system.
• Developed the reports in Hadoop system using the technologies like Impala and Hive.
• Worked in technical analysis, requirements gathering and help the team in conduct fit-gap analysis for PUM upgrade and PeopleSoft sensitive masking.
• Provided guidance to the team to identify feasible alternative solutions and assist in the scope of modifications.
• Created the interfaces using Application Engine, Component Interface, File Layout and SQRs to load the data from different sources into PeopleSoft HCM system.

Environment: PeopleSoft 9.2, People Tools 8.56, People Code, SQR, Application Engine, Component Interface, Application Package, PSQUERY, Oracle, Hadoop, Impala, Hive.

Confidential, Bloomington, IL

Senior PeopleSoft Techno Functional Consultant

Responsibilities:

• Closely worked with the Business Partners to understand the requirement, Performed the analysis on the requirement and convert them into functional design document.
• Developed the new pages for the State W-4 ESS transactions and the respective configurations.
• Worked on customizing Pages, Components, PeopleCode, SQR, Application Engine and Application packages, PSQUERY, Integration broker, File layout, Web services, XML to meet the business requirements.
• Worked on PUM upgrade, Tax Updates, Security Patch Upgrade defects / bug fixing.
• Created, reviewed and modified the technical design documents and Unit test documents.
• Worked in technical analysis, requirements gathering and help the team in conduct fit-gap analysis.
• Provide guidance to the team to identify feasible alternative solutions and assist in the scope of people code modifications.
• Developed complex SQL in DB2.
• Created the interfaces using Application Engine, Component Interface, File Layout and SQRs to load the data from the feeder area into PeopleSoft HCM system.
• Customized the classic and fluid pages based on the business needs.
• Developed new tiles to access the fluid pages in ESS & MSS applications.
• Worked on the integrations between Core HR & Recruitment system using Application Engine and Component Interface.
• Developed the interfaces to send the HR information to benefits, get the benefit enrollments for payroll processing and send the benefit confirmation details from Payroll to Benefit system.
• Customized the delivered SQR programs for quarterly filing and yearend processing based on the business needs.
• Good experience in using People Code Trace and other debug methods to identify the root cause of an issue.
• Created Component Interface to export data from Excel to CI.
• Developed the test plan and created the test scenarios.
• Performed the system testing and document the test results.
• Reported the Defects and worked with technical team (development or other infrastructure) to fix the defects.
• Worked with the Business Partners and the Operations Team for their day to day activities and provide functional support.
• Performed analysis on the production issues and provided the suitable solutions on time.
• Taken care of Production Tickets and Batch Jobs.
• Worked on HCM Bundles, Tax Update and Security Patches regression Testing.
• Worked with Business Partners on Monthly and Quarterly filing Processes
• Performed the Yearend activities based on yearend schedule.
• Worked with Business Partners for loading the pay merit and annual bonus.
• Provided the support for all the issues reporting in ESS/MSS panels.

Environment: PeopleSoft 9.2, People Tools 8.56, People Tools 8.55, People Code, SQR, Application Engine, Integration broker, Component Interface, Application Package, PSQUERY, DB2.

Confidential, Bloomington IL

Senior PeopleSoft Techno Functional Consultant

Responsibilities:

• Conducted fit gap analysis and prepared the Business Continuity Documents.
• Conducted the Business Continuity Document walkthrough with the Business Partners and drawn conclusion about the customizations and utilizing the delivered features.
• Developed the functional and technical specification documents for the retrofitting activities and the customization.
• Extensively worked on customizing and retrofitting of PeopleCode, SQR, Application Engine and Application packages, PSQUERY, Integration broker, File layout, Web services, XML to meet the business requirements for 9.2
• Worked on performance tune up in by modifying SQR’s.
• Created and modified Technical design documents and preparation of Unit testing.
• Developed complex SQL in DB2.
• Involved in verify the status of the schedule jobs using process scheduler and Control-M.
• Involved in defect/ bug fixing.
• Customized the PeopleCode, Application Package, Integration Broker and BI Publisher to meet the business requirement on the delivered PDF Federal & State W-4 Withholding forms.
• Worked on People Code Trace and other debug methods to identify the root cause of an issue.
• Created Component Interface to export data from Excel to CI.
• Worked in support by monitoring jobs in Control-M tool and few jobs in process Scheduler.
• Developed the test scripts for Developer Unit Testing.
• Performed Unit Testing and walkthrough the results with Business Analysts.
• Developed the test plan and test schedule for the Functional Integration and System Testing.
• Creating the test scripts/scenarios for the Functional Integration and system Testing.
• Performed Functional Integration, Parallel Payroll and system testing and walkthrough the results with Business Partners.
• Prepared the job aid document about the new features as the part of end user training.
• Worked with the Project Manager and Implementation Coordinator for the Dress Rehearsal.
• Worked with the technical teams (Migration, Server & Security) for the Roll to Production activities.
• Provided support during the implementation period.
• Taken care of the Production Tickets.
• Applied, Retrofitted and Tested Tax Update Patches.
• Worked on Quarterly filing and Yearend activities.

Environment: PeopleSoft 9.1, PeopleSoft 9.2, People Tools 8.55, People Code, Application Engine, Component Interface, Application Package, PSQUERY, BI Publisher, SQR, DB2.

Confidential, Bloomington IL

Senior PeopleSoft Techno Functional Consultant

Responsibilities:

• Worked with the Business Analyst and Partners and finalized the requirement.
• Created the new earnings code configuration for Double time & Meal Penalty.
• Modified the rules for double time and mapped the new earnings code.
• Created the new rule for Meal penalty in PeopleSoft Time & Labor.
• Developed the test scripts and performed the system and end to end testing.
• Documented the test results and get it approved by the Business Partners.
• Finalized the project & objects for deployment.
• Provided the support during production implementation and post-production issues.

Environment: PeopleSoft 9.1 HCM (Core HR, ESS, MSS, Time & Labor, NA Payroll), People Tools 8.55, Application Engine, BI Publisher, Mainframe People Code, SQR, PSQUERY, DB2, Lotus Notes.