SUMMARY:

• Around 6 years of experience in Information Technology as a PeopleSoft Technical Consultant from . Involved in Requirement gathering, Design, Develop applications like FSCM, HCM and NA payroll with oracle as a backend database, also worked as a SQL developer/Tester, implementing, Upgrading and testing of various applications in Client/Server 3 - tier environment.
• Oracle certified People tools developer expert.
• Proficient in using the various PeopleSoft tools like Application Designer, Application Engine, People Code and Process Scheduler.
• Worked Extensively on File Layout, Application Engine, Component Interface, and Excel to CI.
• Knowledge on PeopleSoft Internet Architecture.
• Proficient in using SQR.
• Good PeopleSoft Functional and hands on experience in PeopleSoft HCM 9.2, 8.9 - Core HR, Payroll, Base Benefits, AWE.
• Functional knowledge on Payroll for NA with experience in configuring Payroll tables, creating Pay groups, Pay calendars, Pay Run Ids and supporting Payroll processes like Creating Pay sheets, running Pay calculation, Pay Confirm.
• Played a techno functional role in the production support project for the entire PeopleSoft HRMS system which has users all across US.
• Worked on the enhancements projects in PeopleSoft HRMS.
• Expertise in analyzing business specifications and writing Test cases, develop Test Scripts and executing Regression, System integration, Performance and User Acceptance testing.
• Strong fundamental knowledge in developing tables, views, joins, indexes and sequences using SQL/PLSQL queries.
• Having a good knowledge and hands on experience in SQL Tuning.
• Having basic knowledge in Oracle performance tuning and Informatica testing.
• Created many custom processes in the project to ensure proper delivery to the customers.
• Expertise in creating all the relevant documents includes RTM and other metrics.
• Having Good interpersonal and excellent communication skills.
• Excellent Analytical, Critical thinking, and Creative Problem solving skills with ability to quickly master new applications, Team player and self-starter.
• Worked in software development/Testing life cycle (Requirement gathering, Design, Development, QA, UAT, Implementation and Production support) depend upon the requirement in waterfall and agile methodology.
• Having overview on data profiling, helps to map the source to target data mapping
• Ability to take self-initiatives and drive functional excellence, quality culture within team, bringing the best out of allocated resources.
• Enthusiastic, team player, goal-oriented, independent, abreast with latest technology and open to learn based on the business demand and the requirement.

TECHNICAL SKILLS:

ERP: Oracle PeopleSoft HRMS 8.9, 9.1, 9.2

Administration Tools: Configuration Manager, Process Scheduler

Reporting Tools: SQR, PS Query

Testing Tools: HP ALM/QC

Other Tools: SQL Developer, TOAD

Data Bases: Oracle 11g/10g/9i/8i, MS-Access, SQL Server 2005/2008

Scripting: SQL, PL/SQL, JavaScript

Operating Systems: Windows NT/98/XP/Vista/7/8

PLC Methodology: Agile, Waterfall

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

PeopleSoft HRMS Developer/Tester

Responsibilities:

• Understanding and analyzing the Business requirement document (BRD)
• Based on that preparing requirement documents and getting approval from the users.
• Preparing LLD, HLD and technical design document.
• Creating/modifying existing process as per the design which involves creating/modifying fields, updated the code logic.
• Involved in testing on/off pay cycles from creating Pay Run Id to GL interface.
• Finding Root Causes for the issues and fixing the issues as small enhancements or process changes.
• Worked efficiently with Application designer in creating tables, finding table structure, added/modified fields.
• Created the database objects including SQL Views, SQL stored procedures and Functions to provide data for reports.
• Created File layout for loading data from flat file into staging tables, used AE peoplecode for validating certain fields and loaded data into PS tables through Component Interface.
• Designed the database, tables and Procedures.
• Worked with functional team on various issues and product constraints to develop possible workarounds to meet the requirements.
• Working in parallel with oracle to get fixes for delivered bugs and applying that to the system.
• Worked in tuning lots of SQRs.
• Worked in modifying peoplecode as per the change requests.
• Creating Unit test plans and fixing issues in the user testing.
• Involved in migrating the object from development to testing environment.
• Maintained and tracked defects in the defect document for the team.

Confidential

PeopleSoft HRMS developer/ tester

Responsibilities:

• Understanding the requirements by studying functional document.
• Adding necessary changes to the product or system.
• Development activities based on the requirements.
• Developed and modified various interface SQR programs and reports in HR, Payroll and to meet the business requirements.
• Configuration of Pay group, Earning codes, deductions, Federal, State and local Tax tables.
• Created Pay Sheets, Pay calculation, Pay confirmation and Paycheck for the employees for off cycle and on cycle conditions.
• Extensively used People Tools for creation and modification of Process Definitions, Records, Pages, components to run Custom SQR/AE through People Soft environment.
• Involved in migrating the object from development to testing environment
• Test case preparation and Quality analysis.
• Worked on Quality center to write and execute the test script and tracked the defects during each run.
• Wrote test scripts for all possible scenarios and testing in 3-tier environment.
• Other deliverables documents and migration documents.

Confidential

PeopleSoft Production support

Responsibilities:

• Analyze and resolve the issues which came up after the go live.
• Understanding the client requirements by studying functional document.
• Daily discussion with the onsite team about the issues.
• Finding Root Causes for the issues in the new environment and suggesting the fixes as small enhancements or process changes.
• Knowledge transfer to the production support team about the new environment.
• Modified the delivered application engine programs to accommodate the vendor population.
• Extensively used application designer to create or modify new records, establish table edits, and add field/values to translate/prompt tables.
• Involved in performance testing and fine-tuning of the SQR programs.
• Analyzed payroll and tax procedures in order to recommend and implement changes leading to best practice operations.
• Involved in migrating the object from development to testing environment, and assisting the production support team during deployment activities.
• Development activities based on the requirements.
• Worked efficiently on NA payroll for pensioners.
• Fixing the defects brought during UAT process.

Confidential

PeopleSoft HRMS Developer

Responsibilities:

• Joined the team during SIT phase.
• Worked efficiently in Accounts Receivables and Billing Modules.
• Worked in SQR for customer rebate upload.
• Attended for Fit gap analysis meetings and documented according to the business Processes/requirements interacting with the business users, to gather functional requirements and document those functional requirements. Preparing the Technical Design documents.
• Developed Application Engine on the requirement Micro dynamics comroster, where a third party file is loaded into PeopleSoft tables.
• Developed new custom pages involving custom people code.
• Actively involved in DARWAR (Daily Accounts Reporting and Weekly Accounts Reporting) team and delivered the requirements on time.
• Worked with functional team on various issues & product constraints to develop possible workarounds to meet the requirements.
• Worked with testing team and tested all the developments efficiently with all possible scenarios.

Confidential

PeopleSoft HRMS Developer

Responsibilities:

• Understanding and analyzing the present business application and new requirement.
• Preparing functional (BRD) and technical design document.
• Implementation and Customization according to new business rules of the client, which includes creating new fields, Records/Sub records, Pages/Secondary Pages and menus for new developments as per the client requirement using Application Designer; People Tools.
• Developed SQR to generate multiple reports.
• Creating/modifying existing process as per the design which involves creating/modifying fields, records, pages, people code, application engine, SQR, Query and setup.
• Developed a new Application Engine programs to load the Data from flat file to Project Module to update the Project interfacing.
• Designed customized pages and People code as per the requirement and the functionality.
• Developed New Program to map the Business Units to the Client Business Unit.
• Developed a New Application Engine to process the Data from staging tables to the PS Tables.
• Developed SQR to move files from one directory to another and list out the file names, made them available in corresponding page as per the requirement.
• Creating Unit test plans and fixing issues in the user testing.
• Involved in migrating the object from development to testing environment, and assisting the DBAs during deployment activities

Confidential

Software Engineer

Responsibilities:

• Understanding and analyzing the present business application and new requirement.
• Preparing functional (BRD) and technical design document.
• According to new business rules of the client, created new fields, Records/Sub records, Pages/Secondary Pages and menus for new developments as per the client requirement using Application Designer; People Tools.
• Developed SQR to generate reports.
• Creating/modifying existing process as per the design which involves creating/modifying fields, records, pages, people code, application engine, SQR, Query and setup.
• Designed customized pages and People code as per the requirement and the functionality.
• Developed a New Application Engine to process the Data from staging tables to the PS Tables.
• Creating Unit test plans and fixing issues in the user testing.
• Involved in migrating the object from development to testing environment.
• Maintained document for Traceability Matrix.
• Maintained and tracked defects in the defect document for the team.
• Created reports for MOM.
• Involved in quality team in the project to maintain quality related documents.