SUMMARY

• Senior Business Analyst with more than 7+ years of in - depth experience inPeopleSoft design, implementation and team management. Played key technical and functional roles in the implementation ofPeopleSoftCampusSolutions (8x, 9x), HCM, CRM, and Financials.
• Experience in PeopleSoftCampusSolutions,PeopleSoftHCM,PeopleSoftPortal applications and People Tools.
• Responsible for all phases of PeopleSoft implementations and upgrades, including project planning, fit/gap analysis, design, construction, deployment and maintenance.
• Strong implementation/upgrade skills and high level of business process knowledge starting with version PeopleSoft 8.x, 9.x. The most recent experience includes 9.2 on Peopletool 8.54.
• Extensively worked with People Tools such as Application Designer, Application Engine, Process Scheduler, Data Mover, Maintain security, People code, Workflow, Component Interface, File Layout, XL to CI, Approval Workflow Engine, Application Packages, Integration Broker, PeopleSoft security, HTML, project migrations, Update Manager and Unix Scripts.
• Extensive experience in writing People Code, SQR and SQL, Crystal Reports, PS query
• Proficient in analyzing Business Requirements Document (BRD), Functional Design Documents and FRD (Functional Requirement Document) to formulate Test Plans, Test Scenarios and Test Cases.
• Experience of deploying SSIS packages toSQLserver and scheduling jobs withSQL Server Agent on daily or monthly basis.
• Expertise in techno-functional aspects ofPeopleSoftfinancials modules: P2P, Contract Management system(CA), Billing (BI), Account Payable (AP), Travel& Expense, General Ledger(GL), Project Costing, Commitment Control, Account Receivable (AR)PeopleSoftHRMS, Workforce Admin, Manager and employee self-service modules and Time and Labor, vacation leave tracker.
• Proficient in requirements gathering, performing fit gap analysis (current and future state), creating functional specification documents, and developing business process flows and charts.
• Strong PeopleSoft analytical experience in Payroll Interface, Absence, Employee Self-Services and Manager Self-Services.
• Expertise in PeopleSoft applications, Oracle databases, SQL
• Provided quality assurance using best practice policies, analyzed and tested processes for the implementation ofPeopleSoft HCM 9
• Knowledge of variousCampussolutionmodules such asCampusCommunity, Recruiting and Admissions, Student Records, Curriculum Management. Worked on various data conversion like Financial Aid data, course catalog, schedule of classes, service indicator, test credits, test scores, student groups, academic standing and student program plan to load data from third party system toPeopleSoftsystem.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, Micro Strategy Data Warehouse Data Modeling and Design.
• Extensive experience inPeopleSoftHCMsolutions, Higher education product (PeopleSoftCampusSolution) andPeopleSoftCRM suites.
• Strong in SQL. Extensively worked with SQR, PeopleSoft Query, Connected Query in creation and generation of organizational reports.
• Involved in developing and customizing the reports using the tools PS Query and SQR.
• Worked extensively on PeopleSoft tools like SQRs and Application Engines for reporting, Mass uploads,Outbound and Inbound Interfaces, Email messaging and Data Processing programs.
• Expertise in application software development in usingPeopleSoftwith progressive technical experience in Customization, Implementation and Development ofPeopleSoftCRM Field Service, Sales, Support andCampusSolutionsStudent Administration.
• Strong business analysis skills and a sound understanding of Software Development Life Cycle (SDLC) utilizing Rational Unified Process (RUP) methodology.
• Worked with Waterfall and Agile SCRUM Methodologies using Version One, Behavior driven development (BDD) and Test-driven development (TDD).
• Strong communication and team-oriented skills with strong attitude/ interpersonal skills toward learning new technology/ concepts quickly supporting project requirement.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.

PROFESSIONAL EXPERIENCE

Confidential, Trenton, NJ

Sr. PeopleSoft Campus Solution Consultant

Responsibilities:

• Understanding the functional design documents received from Confidential for the HCM and Campus Solutions.
• Defined thebusinessprocesses in PeopleSoft, conducted extensive gap analysis, reviewed extensive customizations, led data conversion efforts, led reports development, conducted user training, implementation and post implementation support.
• Provided software development, maintenance and analysis for PeopleSoft Campus Solution 9.2.
• Involved in developing and customizing the reports using the tools PS Query and SQR. Creating complex SQL to retrieve the data from PS.
• Worked with Integration Broker to send a XML document across databases and schemas to synchronize data for members such as personal information, contract data, and dependency data.
• Requirement gathering, gap analysis, preparation of use case, activity flow diagrams, BRD/FRD.
• Guided the upgrade of a highly customized Financial Aid module from 8.0 to 9.0. Since the original implementation was hastily done and largely unusable, the upgrade required a virtual redesign of many customizations, and reconfiguration of several delivered components. Additionally, analyzed the client's existing business processes and provided a roadmap recommending post upgrade implementation of both delivered and customized functionality to truly meet the needs.
• Worked on reporting and data migration solutions withPeopleTools 8.54 using SQR, Application Engine and Component Interface.
• Worked on Report generation usingSQLServer Reporting Services SSRS that could be used to send information to Client.
• Tuned the performance of the SQR reports using SQL, Stored Procedures and Temp Tables.
• Involved in Test planning, developing and writing Test Plans, Test Scripts, and execution of Test Scripts and deployment of java-based Oracle web center operations board and PeopleSoft FSCM and HCM v9.1 (implementation project) Implementing Oracle EPM Financials, Supply Chain andCampusSolutions applications ofPeopleSoft EPM using IBM Ascential and OBIEESoftware.
• Supported GlobalPeopleSoftcustomer base for HCM andCampusSolutions product lines for all supported product versions
• Worked on SQR interface programs to export data from PeopleSoft tables to flat files.
• Led Student Financials delta sessions to identify new and changed functionality. Researched options to eliminate or modify existing modifications using delivered functionality.

Sr. Peoplesoft Consultant

Confidential, Phoenix, Arizona

Responsibilities:

• Responsible for the set-up, data-mapping and configuration in support of out of the box functionality of the Academic Advisement, Campus Self-Service, Financial Aid, Gradebook, Recruiting and Admissions, Student Administration, Student Financials, Student Records and Campus Community modules within the Campus Solutions application suite.
• Evaluated college transcripts for transfer hours throughPeopleSoftCampusSolutionsAdmission & Student Records module.
• Provided production support services primarily to users of thePeopleSoftCampusSolutions Student Financials module.
• Involved in Milestones conversion from legacy system to PeopleSoftCampusSolutions using App Engine, Component Interface and Parallel processing.
• UsedSQLProfiler for troubleshooting, monitoring, and optimization ofSQLServer and non-production database code as well as T-SQLcode from developers and QA.
• Responsible for BRD walk through sessions with various business customer, Contacts unit leaders, IT QualityAssurance teams and coordinated the system testing and UAT of the various projects delivered as part of the various Sprints.
• Design and developed the technical specification for any modification to the existing PeopleSoft object (SQR report, People code, application engine etc.) or to create any new object in PeopleSoft for any customization.
• Responsible for the daily support and maintenance of thePeopleSoftHCM 9.2 software system.
• Assisted technical staff with their People Tools 8.53.05 upgrade to theirCampusSolutions 9.2 environments. Worked with Portal team on re-implementingPeopleSoftInteraction Hub on tools 8.53.05. Performed load testing of upgradedPeopleSoftsystems using Apache JMeter.
• Solved bugs on a process that generated extra cost on tuitions for new students on acampussolutionclient.
• Responsible for the maintenance, support and tuning of thePeopleSoftCampusSolution, Portal application environments including Demo, Development, QA, Training, and Production
• Created multiple interfaces for the StudentCampusSolutionModules including (Student Records, Financial Aid, Admissions and Student Finance).

Peoplesoft Business Analyst

Confidential

Responsibilities:

• Utilize PS Query to build and run complex queries to support Student Financials business processes.
• Performed data mapping and technical analysis of available processing options to create a near real-time integration/synchronization process to update student data stored in financial aid system with relevant changes made to student data in thePeopleSoft9.0CampusSolutions system.
• Responsible for doing the Impact and Fit/Gap analysis for the modification, enhancements and customizations of HR, Benefits Administration and Payroll modules.
• Involved in design and development of conversion programs usingSQRfor transferring of data from legacy system to PeopleSoft.
• Involved in Creating Integration to Sync up of, Diversity Info, Visa Data and Emergency Contact, Person betweenCampusSolutionsand HCM.
• Worked on data conversion programs forcampussolutionapplication suite on Program plan stack, Degree data, Course credits, and Service Indicators and Class information.
• Design, Development, Customization, support and maintenance of PeopleSoft campus solution applications usingPeopleSoftDevelopment, Reporting and Integrations tools.
• Supported team in resolvingSQLReporting services,SQLIntegration services and T-SQLrelated issues.

PeopleSoft Functional Consultant

Confidential

Responsibilities:

• Concentrated on Campus Solution Modules Financial Aid, Student Administration, Campus Self Service, Student Financials, Academic Advising, Student Records, Contributor Relations, and Gradebook.
• Coordinated with the financial aid staff about the implementation of upgrades, patches, testing, and all functional issues related to Power aids and Peoplesoft software systems.
• Involved in Conversion of Entire PeopleSoft Core HR, ePerformance, Payroll, Talent and Absent Data into Workday compatible format by the help of PeopleSoft SQR's.
• Modified People Code and made online modifications to pages, components etc. in Academic Structure, Campus Community, Student Records and Academic Advisement modules.
• Worked with a team of technical and functional consultants to design, test and implement enhancements toPeopleSoft’s Payroll, Human Resources, and Benefits modules for various clients.
• Involved in writing SQL procedures/queries
• Involved in Test planning, developing and writing Test Plans, Test Scripts, and execution of Test Scripts and deployment of java-based Oracle web center operations board andPeopleSoftFSCM and HCM v9.1 (implementation project) HR, Benefit, Time and Labor, Payroll, Setup HRMS modules.
• IntegratedPeopleSoftwith Internet-based Lead Sources and PeopleSoft Campus Solution.
• Provided the template documentation (Issue Log) to keep the track of the issues faced during the Functional Testing and UAT testing in different 9.0 environments by Users, which helped in tracking of the issues from the time of the report till resolved. Daily updated the Issue Log based on the development and progress of the issues.
• Performs unit testing prior to moving code/configuration to the QA process and supports QA activities as needed.
• Assists in the development and definition of test plans and scripts for performance, regression and user acceptance testing.