PROFESSIONAL SUMMARY:

• Qualified Certified professional with over six years of experience in all stages of systems development life cycle including business requirements gathering, design, data conversions, system / integration / user acceptance testing, documentation and exclusive experience in PeopleSoft HRMS/HCM and expert level Skills in PeopleTools.
• 7+ years of experience in PeopleSoft Implementation, Customization, Integration, Upgrade and Production Support.
• Highly motivated peoplesoft Developer with experience using SQL Server Management Studio and Visual Studio 2005
• Created specifications and designed interfaces to and from PeopleSoft system to satisfy business requirements.
• Specialized in gathering the requirements and design specifications for data extraction interfaces and conversion from legacy to PeopleSoft applications.
• Hands on knowledge on Results - driven Quality Assurance Analyst and QA business professional with experience as QA Lead and QA coordinator, using both manual and automated testing tools: Quick-Test Pro, HP ALM (Test Director) Mercury suite on any Web Based applications as well as ERP (PeopleSoft) applications.
• Worked as QA Lead, gathering business requirements, reviewing requirements with SME.
• Extensive experience in database testing writing SQL commands for complex business criteria to retrieve data from databases (Oracle, SQL Server) used TOAD tool for interface in database testing.
• Work Experience on UNIX, Windows Servers, Shell Script, Batch Scheduling Application Control-M, Database Access Tools like TOAD, Query Analyzer, Quest, SQL Plus, Version Control Tool STAT and Defect Tracking Tools like HP Quality Center (ALM) and Test Director.
• Strong in analyzing Business specs and developing test plans, test scripts and test cases and executing.
• Drafted Technical/Functional Specifications & Created Test Scripts for various modules.
• Created Training/Job Aids for UAT testing, used UPK (User Productivity Kit), used PTF (PeopleSoft Test Framework) for creating test cases.
• Have good working knowledge of Software Development Life Cycle (SDLC), RUP Methodology, Agile Methodology, and Rapid Application Development Methodology.
• Expertise in developing Test Strategies, Test Scripts, Test Cases, Test Plans, Test requirements and Testing standards.
• Analyzed and Applied Tax Updates, HR Bundles & Patches extensively.
• Excellent Analytical, Organizational, Interpersonal and Communication Skills. Can handle competing and changing priorities, multi-tasking, make quick decisions and always willingness to learn new applications.

TECHNICAL SKILLS:

Programming Languages: SQR, Peoplecode, Application engine, Application Designer, PeopleSoft Test Framework, PS Query, MS Visio, Integration Broker, BI Publisher, PTF, Load Runner, Cobol

Databases: Oracle 12c/11g/10g/ 9i, MS SQL Server, DB/2

Applications: Workforce Admin, NA Payroll, Base Benefits, Ben Admin, Time & Labor, Talent Acquisition Manager (TAM), eProfile, Profile Management, Candidate Gateway

PROFESSIONAL EXPERIENCE:

Confidential, CA

PeopleSoft Technical/ Functional Consultant

Responsibilities:

• Worked on analysing conversion of data PPT2 and PPT 3 to IRMED (UCIMC).
• Provided technical support for Peoplesoft ELM Module.
• Tested all the tables involved in Payroll processing, such as Pay calendar, JobCode, Deductions and Processes such as Pay sheet creation, PayCalc, Payconfirm, Tax Tables etc.
• Resolved multiple payroll issues related to Earnings codes, Earnings programs, Garnishments, Deductions, as well as payroll processes like Pay Calc, Load to Time and Labor and Pay confirm.
• Involved in data validations to load the job HR personal DDP, TAXES and Payroll from TEMP table to Staging.
• Involved in Unit Testing for all upgraded SQR programs and tuned them to resolve performance base issues related to them.
• Worked on testing the Paycheck page Customizations to change the search keys for better page performance and comma formatting of the amount fields on the Pay Check Summary page.
• Worked on Payroll Tax update by comparing previous and current pay checks/retro pay process.
• Responsible for running weekly and semi-monthly Payroll Cycles during Parallel Test Phase.
• Tested whether Benefits retirement team access to update Employees Savings Plan, General Deductions and ABS 401(k) Loan Vendor ID.
• Validated 401K Roth Contributions whether all the pay group and companies Roth totals are correctly generated in SQR Report.
• Tested via MSS whether manager has ability to select rate when EE is moving from PT to FT or vice versa.
• Involved in payroll parallel testing of legacy system and new payroll system and compared the results.
• Set up Security for Payroll users based on Permission List. Automated the creation of user id by logic within scripts.
• Run the Payroll Interface process which include Deduction calculation, Additional Pay, Import and export application engine process and send the file to ADP
• Data keying and testing of various test scenarios in job data component for both regular hourly and salaried employees to impact payroll processing.
• Creating new test scripts and testing various customizations/enhancements with Benefits and payroll modules.
• Wrote and Executed test scripts with PeopleSoft Test Framework (PTF) and did the Regression testing.
• Tested and wrote scripts for application engine program to load the accounting entries data from legacy System into PeopleSoft.
• Modified existing Report Formats and added new Reports using PS/Query to generate reports of the customized application as per the user requirement.
• Updated status report to manager for critical issues communicated with the developer and business, and wrote test plan for the projects, trained the business on HP Quality Center.
• Wrote Test Scenarios, Test cases in excel sheet and imported them to ALM Quality Center, JIRA.
• Involved in running and testing various Inbounds & Post Confirm jobs, payroll reports against confirmed pay cycle.
• Tested interfaces to pull data from payroll paycheck tables and write them into flat files that will be sent to external units.
• Extremely involved in the methods of testing for each stage in North American Payroll process and documenting it. Performed Backend Testing to validate different interfaces using SQL Queries.

Confidential, Phoenix, AZ

Peoplesoft Functional Consultant / Data Analyst

Responsibilities:

• Started at Safeway by joining in AM audit team that audits all the AM process for ongoing conversion projects and already converted pay groups.
• Trained and mentored junior team members in technical and functional areas.
• Lead Core Tables analyst for implementation of Jewel, Shaw’s and ACME mergers.
• Lead Contract’s configuration analyst for NAI backstage, US-satellite-NAI Corp and Lancaster
• Responsible for defining the functional requirement documents for each source to target interface.
• Worked on the customized functionality to calculate the Payroll for employees who are working under Confidential by creating specific Labor Agreements and specific Job codes.
• Better understanding on SLIM and the Wage progression tables as per the business requirements.
• Documented, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team.
• Performing Peer reviews for technical design documents, code, test plans, test results, and documents to ensure standards are properly adhered.
• Collaborated with stakeholders to ensure clear understanding and documentation of functional requirements for each source to target interface.
• Develop thorough knowledge of assigned business area and system functions.
• Created spreadsheets and work sheets which is used to Audit the employee’s data based on the Master data provided for AM types for employees.
• Hands on experience in auditing all the AM types such as Vacation, Sick, Float, birthday, Anniversary, PTO, SLO, SLL etc.
• Created PS Queries to pull necessary data as per the business requirements.
• Validated the data using complex Excel formulas such as VLOOKUP, CONCATENATE, and IF conditions.
• Involved in assisting the SIT and UAT phases of all the projects till they are in production.

Confidential, NC

Senior Peoplesoft HCM Developer

Responsibilities:

• Executed unit test plans for medium complexity batch interface programs for Payroll, Human Resource modules.
• Performed many customizations and added new Fields, modify existing Fields, Tables and Pages as per the client’s requirement.
• Designed Programs to address issues like Negative T&L hours that resulted in a negative Gross Check, Close Rejected by Payroll transactions after off cycles are paid and Close Record only offset transactions.
• Modified existing SQR reports used for verification purposes in PS Time and Labor.
• Involved in modification and fine-tuning of delivered SQR report.
• Tested and modified PeopleSoft delivered Records, Pages, PeopleCode and SQR Processes.
• Performed an inventory of existing Time and Labor rules and identify and document the rules that need to be modified for Version 9.2.
• Performed System Admin, Developer and Analyst Roles
• Retrofitting of SQRs, SQCs and Application Engine programs using tools such as Process Scheduler and Autosys.

Confidential, AL

Graduate Student Assistant-SoC / Data analyst- SoC Department

Responsibilities:

• Involved in extraction, transformation and loading of data directly from different source systems
• Extensively read different forms of Input files like CSV and other formatted files using In-file, Proc Import and documented using SAS scripting to develop data cleaning operations
• Created Views and lookup tables in excel. Graphical Representation of the school activities
• Developed live reports in a drill down mode to facilitate usability and enhance user interaction.
• Extreme proficiency and hands on experience on MS Excel, MS Word 07 /10/13.
• Developed statistical reports with Charts, Bar Charts, Box plots, Line plots using PROC GPLOT.
• Involved in generating dual-axis bar-chart, pie chart and bubble chart with multiple measures and data blending in case of merging different sources.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Created reports using analysis output and exported them to the web to enable the customers to have access through Internet.
• Created Dashboards style of reports using Qlikview components like List Box, Slider, Buttons, Charts and Bookmarks

Confidential

Data Test Engineer

Responsibilities:

• Implemented and followed a Scrum Agile development methodology within the cross functional team and acted as a liaison between the business user group and the technical team.
• Create test plans for System and Integration testing, Regression Testing, User Acceptance Testing.
• Developed test plan and test cases for Allocating Compensation for direct and indirect reports for Equity, Merit and Bonus in Compensation module.
• Customized many rules such as overtime, exception, holiday work and also created custom rules to employees under specific Work Group.
• Tested real time integration and transaction updates using integration broker for adding applicants from third party external site to PeopleSoft application.
• Customized Application Engine Programs for various processes, created new reports using SQR’s and modified existing report formats as per requirement.
• Enroll employee in different Benefit program and Benefit plans, Enroll employee as a time reporter in Time and Labor Module.
• Involved in the performance tuning of App Engine programs and People Code.
• Involved in modification and fine-tuning of delivered SQR report.
• Tested and modified PeopleSoft delivered Records, Pages, PeopleCode and SQR Processes.
• Performing Peer reviews for technical design documents, code, test plans, test results, and documents to ensure standards are properly adhered.
• Tested PeopleCode customizations and to apply new functionalities for employee Base Benefits, HRMS and Self-Service modules.
• Use of quality center to create/track the defects and for creating reports on daily basis.
• Performing root cause analysis on data anomalies within the context of set business guidelines, documenting the analysis and providing updates to the ETL teams Involved in the Data Movement between Systems and validated the Business Requirements.

Confidential

Jr. Test Engineer

Responsibilities:

• Documented the complete process flow to describe program development, logic, testing, application integration, coding and implementation
• Analyzed and reviewed project documentation, business requirements to prepare detailed test schedules and plans.
• Extracting the data tables using custom generated queries from Excel files, Access / SQL database and providing exacted data as an input to Tableau.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 8.5
• Provide support in developing and maintaining ETL processes that extract data from multiple SOR's residing on various technology platforms then transport the data to various delivery points such as data marts or data warehouses.
• Involved in creating database objects like tables, views, procedures, triggers, functions using SQL to provide definition, structure and to maintain data efficiently. Involved in Data mapping specifications to create and execute detailed system.
• Validated the system End-to-End Testing to meet the Approved Functional Requirements
• Performed quality assurance reviews on all System Development Life Cycle.