SUMMARY:

• Over 7 years of experience in the Information Technology Industry. Strong experience in People soft HRMS having strong skills in Functional Analysis, Business analysis, Design, Testing, Test Plan, Development, Upgrading & Implementation of PeopleSoft in Multi - Tier Environment using PeopleSoft 9.1/9.0/8.8/8/9/8. x/7.5 HRMS (HR, COBRA, Payroll, Payroll Administration, Benefits Administration, Time & Labor, Base Benefits, e-recruit, e-pay, e-development, Self-Service)
• Excellent skills in generating Complex Reports using SQR, Crystal Reports, PS/Query.
• Strong RDBMS Skills, which includes SQL, PL/SQL.
• Excellent skills in understanding and analyzing People Tools, People Code, XML Publisher.
• Proficient in creating Use Cases, Sequence Diagrams, and Activity Diagrams.
• Proficient at coordinating various technical and managerial teams to develop process and verifying adherence using the Requirements Traceability Matrix (RTM).
• Extensive experience in User Acceptance Testing (UAT).
• Extensive knowledge and experience in preparation of reports and presentations.
• Software Testing Life Cycle (STLC) experiences include Test Planning, Test Analysis, Test Design, Test Planning, Project planning Construction & Verification, Testing Cycles, Test Reporting, Defect Tracking, Final Testing, Implementation and Post Implementation.
• Excellent Analytical, Organizational, Interpersonal and Communication skills.
• Excellent proven Leadership skills acquired being a senior member and handling multiple tasks at work. Worked extensively in Offshore Onsite model.

TECHNICAL SKILLS:

ERP Packages: PeopleSoft 7.5/8.x/8.9/9.0/9.1 HRMS (HR, Payroll, Benefits AdministrationTime & Labor, Payroll Administration, Self-Service, Edevelopement, e-app (e-compensation, e-recruit, e-pay, e-development, e-performance, e-benefits and e-profile), Workflow)

Software/Languages: People Code, SQR, JAVA, SQL, PL/SQL, C, C++, Composite Studio

RDBMS (Databases): Oracle 8i/9i/10g/11g, MS-SQL Server, SQL Base 4.5

Development /Administrative Tools: (PeopleSoft),Application Designer, Process Scheduler, Application Engine, Workflow,Import Manager, Data Mover, Object Security, Change Assistant/Management, Security Administrator, Query Manager Tree Manager, Process Monitor, Utilities, Mass Change, Workflow Administrator, and People Code (Object Based)

PeopleSoft Reporting Tools: SQR, PS Query, Crystal Reports, nVision

IDEs: Crystal Reports, Report Smith

Operating System: Windows 95/98 / NT/ 2000, UNIX (HP-UX, Sun Solaris)

Methodology: RUP, Agile SCRUM, Waterfall

Tools: Rational Suite (Requisite Pro, Rose, Clear Quest, Test Manager), MS Project, MS Visio, iRise, Business Objects, BOXI, MS Office Suite(Excel, Word, Visio), Cognos, ERWin, IBM DOORS, Erwin, Mercury Quality Center, SAS, Informatica, MS SharePoint.

PROFESSIONAL EXPERIENCE:

Confidential . (Jersey City, NJ)

Environment: PeopleSoft HRMS 9.0/9.1, People Tools8.49/8.51 (Process Schedule, Application Engine, SQR, PS Query, UNIX.

Responsibilities:

• Created Functional documents for HR customizations in 8.9/9.0/9.1.
• Involves developing unit-test cases for changes administered
• Was responsible for data comparison after Data migration
• Responsible for ongoing maintenances/troubleshooting of PS system.
• Works on Implementation of third party hiring tool Taleo to Peoplesoft.
• Testing of payroll data into GL tables using pages like GP GL GROUP, GP GL MAP etc.
• Participated in meetings and Involved in designing Functional specifications and User documentation requirement specifications for rules
• Played an instrumental role in requirement gathering and Quality assurance for internal HR application within the organization.
• Co-ordination with offshore development team and making them understand the functional requirement and technical approach to deal it.
• Gathered business requirements through interviews, surveys, and observing from area managers and UI (User Interface).
• Data analysis for Global HR System.
• End-to-end Benefits administration business processes and data (e.g., benefit programs/plans, eligibility, event processing rules definition, automated benefits enrollment setup, open enrollment and event maintenance preparation, execution, workflow, problem resolution and benefits reporting).
• Validating the benefit plans and family coverage and dependent information from their HR files and cross-validation with vendors for billing purposes.
• Worked on variable compensation within the stock admin module for the benefit pay out on an annual basis.
• Responsibilities include business analysis, the development of Reports, Interfaces, Workflows, Writing Functional, Technical documents
• Extensively used process scheduler for scheduling recurring process for conditional Scheduling of successive process for setting up the reports to run at specific time and implementation of batch processing.
• Being a senior member in the team, I have taken up the training of the rest of the technical developers in the functional areas as an effort to make the team techno-functional.
• Proven leadership qualities by providing continuous assistance to the team in both technical and functional aspects of development
• Involved in fit/gap analysis.
• Lead Analyst in designing a custom Personal Activity Process and Position Management to be used by the Hr department. Designs included process-flow, specs for Inbound, Outbound Interfaces, Reports, pages with online changes
• Involved in HR, Workflow, edevelopment, eprofile, eperformance process Walk-Thru’s.
• Designed Applications using Application engine to assist batch processing
• Developed and Implemented test methodologies, strategies, test specifications, test cases, test scripts, test matrices, test validation, test execution as per the requirement
• Involved in troubleshooting and fixing bugs and problems in the implementation of HR, Personal Activity, Edevelopment, Self-Service, eProfile, eRecruit
• Imparted Training to the rest of the Associates in my team in several functional areas.

Confidential ( NYC, NY)

Functional Analyst

Environment: PeopleSoft HRMS 7.6, 9.0, People Tools 7.63 and 8.49

Responsibilities:

• Working on HR Customizations including XML Publisher Reports
• Was responsible for making technical documents for HR customizations in 9.0.
• Involves developing unit-test cases for changes administered
• Worked on CI and SQRs to be used for Data Migration.
• Created Data Flow Diagrams and Process flow diagrams for various load components like FTP Load, SQL Loader Load, ETL process and various other processes that required transformation.
• Also involved in acquiring Specifications from the functional team and modifying the SQR’s as per the SPECS.
• Tested and optimized the mapping for better performance by determining bottlenecks at various points, e.g. targets, sources, mappings and sessions.
• Was responsible for data comparison after Data migration

Confidential (Newark, NJ)

Functional Analyst

Environment: PeopleSoft HRMS 8.3, 8.9, People Tools 8.19 and 8.49

Responsibilities:

• The SQR, Process, Interfaces & AE Retrofit Analysis.
• Involves developing unit-test cases for changes administered
• Update technical documents/in line code if available with changes in 8.9.
• Supervise staff to ensure security and server administration procedures are executed.
• Worked extensively on Data Level and Object level Security for 8.9.
• Worked on AE, CI and SQLs to be used for Data Migration.
• Worked on data mover tool for data migration.
• Was responsible for data comparison after data migration
• Worked on building a custom program which would synchronize the date on the Benefit enrollment tables in PeopleSoft.
• Helped taking requirements from various medical, Vision, and dental benefit under new plans for the open enrollment for year 2008 and pass it on to our IT department for necessary enhancements. These benefits were enrolled via e-benefit applications.
• Involved in Unit testing of people soft delivered and modified functionality & customized SQR programs using HR, Benefits and Payroll Modules.
• Conducted Black Box - Functional, Regression and Data Driven. White box - Unit and Integration Testing (positive and negative scenarios).
• Was security coordinator for the project; primary responsibilities include managing security related information like inventory of user access, software & hardware used, attending the audit, keeping the team aware about new security policies and changes.
• Assisted in conducting defect prevention meetings; activities include categorization of defects, participated in root cause analysis
• Defined the Scope for System and Integration Testing
• Involved in Uploading Master and Transactional data from flat files and preparation of Test cases, Sub System Testing.
• Preparation of various test documents for ETL process in ClearQuest.

Confidential (Denver, CO)

System Analyst.

Environment: Citrix, PeopleSoft HCM 9.0, People Tools 8.49

Responsibilities:

• Extensively worked with Application Designer to modify record definitions, pages, components, menus and giving access to them by providing appropriate security
• Customization of the SQR interfaces/reports & application engines as per the required Service Requests
• Created and maintained the Requirement Traceability Matrix (RTM) between the requirements and other products such as design documents and test plans.
• Creation of custom pages as per new requirements
• Continually monitor Benefits Administration processes for inconsistencies or undesirable results.
• Initiated Use Case using UML, which provided the framework for potential use case deliverables.
• Worked developing project plan, milestone and requirement document for PeopleSoft benefit administration open enrollment process and it various vendor interfaces project.
• Preparation of Project related documentations
• Administer patches, updates, and upgrades. Develop and implement plans for data migration.
• Automating employee benefits processes and a strong overall understanding of Standard Operating Procedures around Benefits Administration from a functional business perspective.
• Customized People Code for the new functionality desired by the client
• Prepared technical, design & test documents for all Service Requests handled

Confidential ( NYC, NY)

Jr/ Functional Analyst

Environment: PeopleSoft HRMS 7.5(HR, Payroll, Benefits), People Tools7.5, Crystal Reports, SQR, PeopleCode, Process Scheduler, Oracle, and Windows NT.

Responsiblities:

• Assisted in creating Project Plan. Requirement specification, detail design specification.
• Involved in data mapping/Conversion from current HRIS system to Peoplesoft.
• Involved in collecting reporting requirements.
• Involved In Creating Test Strategy, Test Plan, Test Cases and Testing.
• Involved In Customization of HRMS.
• Involved in developing various routines to transform the date to the Client database format by using SQRs and Application Engine programs.
• Designed, created, tested, implemented, and updated Various PeopleSoft reports.
• Modified existing report formats and added new reports using PS query as per the user requirements.
• Created/Customized Templates in Recruitment and Payroll.
• Assisted with PeopleSoft and third party reporting tools to create online queries that pull data from a reporting database.
• Wrote PS queries and SQR programs to extract the panel /menu information from PeopleSoft system tables.
• Modified check reconciliation process to include location and developed a query for HR user to look at the outstanding checks.
• Developed Crystal Reports for payroll, payroll summary by deptid, location to print history/current data. - Using Crystal Reports
• Created Run Control Panels, Records and defined process definitions.
• Developed Report for Head Count Turnover based on locations and detail listing by departments.
• Assisted with PeopleSoft reporting tools to create, test and document report programs.
• Coordinated report creation with corporate data administration staff to publish report availability to appropriate users.
• Custom Designed pages for EPay to deliver Pay check information, Direct Deposit information, W4 online
• Customized the component Interface GP PYE ERN DED ASGN to in-corporate the business logic in the process of assigning payee deductions
• Customized Payroll results register (using pages like GP GPSQR01 PNL, GP GPSQR03 PNL) to create a report containing individual results of a payroll calculation for earnings and deductions.
• Developed a load program and interface to load the people soft Time and labor attendance Information to update pay sheets for payroll processing.
• Involved in HR, Payroll and Benefits process Walk-Thru’s.