SUMMARY

• 12 years of work experience in PeopleSoft technical domain like application engine, Data mover scripts, SQL Tuning, peoplecode, PS Query, Application designer, CI, integration broker, AWE/Workflow, Web services, BI Publisher, Process Scheduler, SQR and crystal reports.
• Expertise covers the spectrum of the System Development Lifecycle from planning and estimation, requirements gathering and analysis, documentation of functional and technical specifications, communication with key stakeholders including technical resources and users, the supervision of technical work, testing, change management, configuration, data conversion, implementation and post implementation maintenance and support as well enhancement projects.
• 5 years of Team lead including user training and hands - on sessions experience wherein managed a team of 10 developers and conducted numerous meetings and training presentations (using flow charts and graphs) to business users at many different levels i.e. from system and business coordinators to service manager and Vice presidents to make them understand the data flow, how to use the system, maintain security, provide business solution and cater to business needs and requirements.
• FSCM (Billing, Asset management, Accounts Payable, Account receivables, GL, Purchasing, Procurement)
• HCM (Core HR, Time & labor, Workforce administration)
• Campus Solution (Records and Enrollment, Basic architecture, academic advisement, Student Financials, financial aid and developed a new custom module as ‘Scholarship’)
• CRM (Sales, Marketing, Client management)
• Involved in Peoplesoft Upgrade project. PeopleTools upgrade from 8.49 to 8.52; Application Upgrade from Campus solution 9.0 to Campus Solution 9.0 with feature pack 4.
• Prepared business reports for user to organize and maintain data consistency and data validations using BI Publisher, crystal reports and PS Query. Hands on experience in modifying queries as per client requirement.
• Experience in successful large scale PeopleSoft implementations.
• Created Functional and technical specifications document, Test documents and ERD diagrams.
• Involved in Designing process and User training for extracting the data from PeopleSoft system to SAP system. A whole Data migration design was prepared and followed.
• Managing Data migration activity through onsite with team ranging from data collection, validation, filtration and actual data porting to real instance through PeopleSoft program and processes.
• Technical Expertise in Configuration, Customization and implementation of PeopleSoft FSCM, Campus solution and HCM application.
• Experience in Agile and Waterfall methodologies.
• Experience in using integration tools like component interfaces, Oracle data Integrator and Integration Broker for interacting within and outside PeopleSoft application.

TECHNICAL SKILLS

• Application engine, Data mover scripts, Change Assistant, SQL Tuning, Peoplecode, PS Query, Application designer
• CI, integration broker, AWE/Workflow, Web services, BI Publisher, Process Scheduler, SQR and crystal reports
• People Tools 8.45, 8.49 and 8.52, 8.54
• HCM 9.2, CRM 8.8, CRM 9.1, Campus solution 9.0,FSCM 8.9, 9.0
• Oracle sql developer 12c, SQL & PL/SQL. Tools Upgrade from 8.49 to 8.52
• FSCM (Billing, Asset management, AP, AR, GL Purchasing, Procurement)
• HCM (Time & labor, Benefits, Core HR)
• Campus Solution (Records and Enrollment, Basic architecture, academic advisement financial aid and developed a new custom module as ‘Scholarship’)
• CRM (Sales, Marketing, Client management)

PROFESSIONAL EXPERIENCE

Confidential

Senior PeopleSoft Consultant

Responsibilities:

• Analyze, develop and implement custom application solutions using PeopleToolsand related software for Campus Solutions and HRMS applications.
• Participate in the full Software Development Lifecycle (SDLC) including business process analysis, systems analysis, systems design, development, testing, deployment and knowledge transfer to production support.
• Planning and deployment including providing analysis andrecommending strategies to ensure smooth systems transitions
• Meet with business analysts and process owners and translate these functional requirements to technical specifications through hands-on analysis.
• Analyze, code, and test software from requirements specifications, and ensures that the finished product meets requirements.
• Ensure the finished product meets the objectives and any other appropriate criteria associated with the user/owner requirements
• Interact with database administrators, security analysts and business system users to complete assignments.
• Provide maintenance and support
• Working on Data Conversions from 3rd party/Legacy into peoplesoft system
• Provide technical and functional expertise and support for the PeopleSoft applications
• Develop and maintain PeopleSoft applications, including performance tuning, troubleshooting, ongoing maintenance, and the resolution of system issues
• Develop strong relationships with end users to effectively troubleshoot problems and recommend good solutions
• Work with end users to define scope of business needs and translate processes into detailed functional requirements or design specifications
• Identify developmental or design risks and action plans
• Assist with system upgrades and prepare data mapping for conversion requirements
• Conducted business meetings with user groups and legacy application owners to understand business requirements and data mapping.
• Experience in using integration tools like component interfaces, Oracle data Integrator and Integration Broker for interacting within and outside PeopleSoft application.

Confidential

Peoplesoft Architect

Responsibilities:

• Provide technical and functional expertise and support for the PeopleSoft FSCM applications
• Develop and maintain PeopleSoft applications, including performance tuning, troubleshooting, ongoing maintenance, and the resolution of system issues
• Develop strong relationships with end users to effectively troubleshoot problems and recommend good solutions
• Work with end users to define scope of business needs and translate processes into detailed functional requirements or design specifications
• Design, code, and unit test complex projects
• Develop and maintain integration between PeopleSoft FSCM and external applications
• Identify developmental or design risks and action plans
• Assist with system upgrades and prepare data mapping for conversion requirements
• Acquire new skills and knowledge to stay at the forefront of information systems tools for PeopleSoft and software quality assurance
• Conducted business meetings with user groups and legacy application owners to understand business requirements and data mapping.
• Experience in using integration tools like component interfaces, Oracle data Integrator and Integration Broker for interacting within and outside PeopleSoft application.
• Developed and modified complex people code program to ensure page validations.
• Configured the Approval Framework for Voucher, Vendors and journals Approvals
• Configured Modules.
• Implemented PeopleSoft Securities that includes Business unit Security, Object Definition Security, Chart field’s security and row level security.
• Created component interfaces program to load Asset and Vendor data in PeopleSoft system.
• Procure to Pay Setup and Integration, PeopleSoft Securities.
• Accounts Payable - Vendor, Bank, Voucher, Matching, Pay Cycle, Refunds.
• General Ledger - Journal, Ledger, Spreadsheet Upload, Reconciliation, Year End Closing.

Confidential

Functional and technical solution architect

Responsibilities:

• Worked as a member of Campus solution upgrade, implementation, Maintenance and Support Team with responsibilities ranging from managing all environments (Production, test, development etc.), managing service levels, and development of Data fixes using PL-SQL, managing workflow processes and reporting to client.
• Worked as a member of HCM Maintenance and Support Team with responsibilities ranging from managing all environments (Production, test, development etc.), managing service levels, and development of Data fixes using PL-SQL, managing workflow processes and reporting to client.
• Involved in Peoplesoft Upgrade project. Campus Solution application designer upgrade from 8.49 to 8.52; Application Upgrade from Campus solution 9.0 to Campus Solution 9.0 with feature pack 4.
• Conducted user training and hands-on sessions wherein conducted numerous meetings and training presentations to business users at many different levels i.e. from system and business coordinators to service manager and Vice presidents to make them understand the data flow, how to use the system, maintain security, provide business solution and cater to business needs and requirements.
• Created business and training manuals for every client level with their roles and responsibility. Clients were easily performing every business related task and fewer tickets were encountered.
• Used flow charts and graphs for illustration and Clients were easily performing every business related task and fewer tickets were encountered.
• Prepared business reports for user to organize and maintain data consistency and data validations
• Project management tasks wherein prepared project plan, tracking project deliverables, conducting BA activities to create and cater to business needs and requirements, providing business solutions, summary, UAT sessions, production go live, delivery dates, metrics data and maintaining time management (time sheets) of the team
• Directly coordinating with clients and business users over issues in functional as well as technical areas of application.
• Training business users and team over the new incorporated functionality.
• Managing Data migration activity through onsite with team ranging from data collection, validation, filtration and actual data porting to real instance through PeopleSoft program and processes.
• Creation and Customizations of Fields, Records, Pages, People Code and Application Packages according to the business requirements etc.
• Involved in doing the Configuration and Setup in the campus solution and HCM system.

Confidential

Developer/ Peoplesoft Onsite Coordinator

Responsibilities:

• Gathered client requirements.
• Resolved various batch job failures and made sure Jobs are running as per schedule.
• Have Good understanding of PeopleSoft PIA Architecture and have the ability to troubleshoot tier 2 and 3 issues.
• Created data Conversion program to load data in PeopleSoft Tables.
• Analyzed and troubleshoot various data issues, Application issues related to SQR, Peolecode, Application Engine, Workflow, security and configuration issues.
• Converted various crystal reports into XML reports by using Oracle BI Publisher.
• Worked on Performance tuning of SQR and Application Engine.
• Involved in determination and documentation of Fit Gaps.
• Performed application testing and created project documents.
• Wrote Complex SQL Queries using Joins, Unions and nested sub-queries.
• Provided post go-live support
• Prepared project plan, tracking project deliverables, conducting BA activities to create and cater to business needs and requirements, providing business solutions, summary, UAT sessions, production go live, delivery dates, metrics data and maintaining time management (time sheets) of the team
• Directly coordinating with clients and business users over issues in functional as well as technical areas of application.
• Training business users and team over the new incorporated functionality.
• Responding to work items (PRs and SRs) / emails from business as well as other system owners
• Allocation of work items based on priority and keeping a track of SLAs and delivery times which involves lowering of priority if needed
• Tracking SLAs and Deliverable dates. Root cause analysis in case of any failure.
• Coordinating the monthly point releases and half yearly major releases as a part of Managed services model
• Walkthroughs and coordination with the developers at offshore
• Weekly and monthly meetings with business users and application stakeholders.
• Communication with Business Users for clarification, details etc.
• Liaising with stakeholders, developers and test team throughout the lifecycle of the project
• Worked as a member of CRM Application Maintenance and Support Team with responsibilities ranging from managing all environments (Production, test, development etc.), managing service levels, and development of Data fixes using PL-SQL, managing workflow processes and reporting to client.
• Managing processes/interfaces, which produce messages for downstream systems via integration broker and app messaging. Created / customized interfaces for ORBIT (PS HR), GFS (SAP Finance) and Segmentation.
• Involved in Implementation and Customization of Components, Pages and Records related to Company, Private Client and Contacts. Involved in Design, Development and Customizations of regular CRM enhancements ranging from Application engine, Crystal reports, App Messaging etc.
• Involved in doing the Configuration and Setup in the CRM system.