SUMMARY:

• 7+ year of experience working as Peoplesoft Consultant / Business Analyst with versatile vertical proficiency.
• Experience working on Oracle Peoplesoft Financials/FSCM (AP, AR, GL, AM, TA & Exp., Project, Contracts) and HCM (HR, Payroll, TA, CG, Benefits, T&L, KK) applications.
• Involved in 2 Full lifecycle Implementation and 2 Upgrades of Peoplesoft for version includes v8.9, v9.0, v9.1, v9.2 and proficient in Integration, Migration, Customization, Configuration, Troubleshooting and Trainings.
• Extensive experience in shared services model, delivering services using both SDLC and Agile models and leveraging globally distributed business, functional and technical teams.
• Extensive experience in Application Design, Fit/ Gap Analysis, Reporting, Production Support, Security Design, Tools and Data Management Tools etc.
• Good knowledge on Application Engine, Component Interface, file layouts, People Tools, People Code, Integration Broker (Application Messaging), PeopleSoft COBOL, Reporting Tools like PS Query, nVision, SQR, XML Publisher, Crystal Reports and Security Administration.
• Hands - on experience in Requirements Gathering, Data Modelling (logical and physical design of databases), Data Analysis, Business Gap Analysis, Unit/Integration Testing, Data Migration, User Training, and System Maintenance.
• Assisted in Testing strategies, Test plans, test cases, UAT, tracking issues over HPQC, Jira etc.
• Strong Client facing skills and have good experience in interacting with various MIS Teams, Stakeholders, Business/Functional Users, QA team during project life cycles via Interviewing or JAD sessions.
• Worked closely with Business users in capturing requirements and creating Functional Design documents BRD, FRD, Use Cases, User and designing Technical Documents based on FRD.
• Experienced in Batch Processes scheduling, Customization, Conversion and Migration.
• Experience in writing PL/SQL queries, Stored Procedures and Triggers and have exposure to different databases, includes SQL Server, Oracle, DB2.
• Experience working with Tableau, Power BI to bring out meaningful data analysis, dashboard and reporting using FSCM and HCM customer data.
• Experience working on Process engineering, re-engineering, Functional Documentation, Workflows, Blueprints etc.
• Highly energetic, self-driven, results-oriented, empowering leader who possesses passion for business and technology solutions.
• Involved in prioritizes, multi-tasks and maintains flexibility in a fast-paced, service-oriented changing environment.

TECHNICAL SKILLS:

Tools: PeopleSoft HCM, Peoplesoft FSCM, General Ledger, Account Payable, Account Receivable, Billing, Project Costing, Core HR, Workforce Admin, Position Management, Benefits (Base Benefits, Ben Admin, eBenefits) and North American Payroll modules. Good exposure to Profile Management, Employee Self Service, Manager Self Service, TAM&CG, Absence Management, Track Global Assignments and ePerformance modules, Exposure to Workday HCM, kronos v7.0.

Version: PeopleSoft FSCM 9.2 GL, AP, AR and HCM 9.1, 9.2v modules.

PeopleTools: PeopleCode, SQR, Application Engine, Component Interface, Excel to CI, Data Mover, File Layout, PS Query, PS Security, Crystal Reports, Application Classes, App Messaging, Integration Broker and exposure to AWE and XML Publisher.

Languages: PeopleCode, SQR, SQL, PL/SQL, C, C++, HTML, Java, VB 6

RDBMS: ORACLE 11g, SQL Server, MS Access, Toad.

Operating System: DOS, Windows, UNIX

Others: Miscellaneous Dreamweaver, MS Word, MS Excel, MS PowerPoint, MS FrontPage etc.

WORK EXPERIENCE:

Confidential, Dallas, Tx

Sr. Peoplesoft Consultant

Responsibilities:

• Utilized MS SharePoint to manage risks issues, and provide project deliverable/task updates critical to meet project deadlines.
• Elicited and documented requirements and specifications from functional end-users and subject matter experts .
• Created new ETL process to extract, transform and load data from different sources to data ware house.
• Translated customer requirements into a best fit within the Oracle PeopleSoft 9.2 system, and developed processes and documentation that supported the standard SDLC .
• Developed and maintained standard Oracle PeopleSoft 9.2 requirement documents including but not limited to: business process workflows, Functional Requirements Documents, Requirement Traceability Matrix, and use cases.
• Participated in Data Mapping, Data Conversion, creation of the Data model and used SQL and Toad to extract, filter and validate data.
• Supported Oracle PeopleSoft 9.2 Core HR, Base Benefits, Benefits Administration, N.A. Payroll, Time and Labor, Talent Acquisition Manager (TAM), and Self Service configuration and security setup as needed.
• Actively participated in change control process, involved along with QA team during User Acceptance Testing (UAT).
• Prepare Wireframes, Prototypes and Mock up screens for different web pages.
• Implemented complex Oracle PeopleSoft 9.2 system configurations and end to end development design.
• Worked in blended Waterfall and Agile environments. Until requirements were gathered and signed off, the project was handled in Waterfall and the rest of the SDLC phases are done using AGILE.
• Created business process models and identified business process improvements for the PeopleSoft 9.2 Core HR, Base Benefits, Benefits Administration, N.A. Payroll, Time and Labor, Talent Acquisition Manager (TAM), and Self Service modules.
• Reviewed and commented on proposed functional/capability configuration for the Oracle PeopleSoft 9.2 Core HR, Base Benefits, Benefits Administration, N.A. Payroll, Time and Labor, Talent Acquisition Manager (TAM), and Self Service Modules.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of Reports.
• Created new ETL process to extract, transform and load data from different sources to data ware house.
• Evaluated and provided feedback on system and functional design documents, test plans and scenarios, and other associated artifacts
• Defined test scenarios based on requirements; created test scripts to prove each scenario through system and user acceptance testing.
• Ability to meet deadlines and manage multiple, dynamic priorities.
• Effective communication skills and demonstrated experience working in a team-oriented environment
• Apply HCM knowledge and industry best practices in developing the to-be business processes and procedures.

Confidential, Nyc, NY

Peoplesoft Consultant

Responsibilities:

• Worked on Peoplesoft version 9.2 General ledger, Account Payable, Account receivable, Project Costing, Billing, Asset Management etc.
• The scope of work is to upgrade existing PeopleSoft Finance 8.8 to 9.2 application
• Involved in Upgrading PeopleSoft Accounts Payable and Asset Management and Fit Gap for both.
• Explained new features available in PeopleSoft Finance 9.2 for AP and AM
• Cleaned/Corrected Asset Management data and Knowledge issues .
• Worked with the product owners to work product backlog and ensure user stories are in place and ranked/ groomed to the appropriate level to start and continue development iterations.
• Responsible for creating and maintaining the project schedule using MS Project.
• Involved in Manual Testing of Accounts Payable and Asset Management and also by using PeopleSoft Test Framework.
• Worked on the interfaces, legacy systems, cash ledger, inbound and out bound transactions through ODI (oracle data integrator).
• Established a GL business unit and ledger, GL calendar, journal sources, and accounting entry templates to transfer journals from Asset Management to GL.
• Configured Accounting templates, Processing options, and Payable Options Payment terms for AP and GL.
• Created and Managed User Stories in Epics, Themes and Sprints; also calculated velocity and Story-points in TFS. (I was also part of the team that assessed and analyzed TFS, HP Agile Manager and Green Hopper as Agile ALM tool)
• As part of MDM implementation, involved with validating and testing user accounts; validating the suspect and collapsed data; created dummy accounts to validate against the back-end and the front-end data.
• Coordinated with legacy system consultants to comprehend the data volumes in AP, AR, GL modules and decide cut-off date for data migration.
• Involved in Client Meetings for testing GL data loads based on various sources.
• Worked on fresh interface for Multi-Currency transactions in AP and GL for customers on the Canadian side of the border.
• Developed Multidimensional Models in Power-Play Transformer and generated Power Cubes for OLAP comprising of dimensions, hierarchies, levels, categories, and measures in Cognos.
• Involved in testing customizations in Application engine to extract data and create flat files using File layout.
• Worked on PeopleSoft Fluid user interface and Elastic Search delivered in latest tools release.
• Involved in planning and executing PeopleSoft EPM upgrade from 8.8 to 9.1.
• Involved on Project RICE (Reporting, interfaces, customizations and enchantments).
• Involved in converting and testing Employee Data and balance data from Kronos HRMS into Financials using Integration Broker.
• Configured the GL Journal Approval Workflow, Testing AR, Pay cycle process and creating checks in Accounts Payable modules.
• Involved in analyze and retrofitting of customization in financial modules while FMS bundle application.
• Tested lot of SQRs and validation procedures to upload data into PeopleSoft system.

Confidential, Chesapeake, VA

Peoplesoft Business Analyst

Responsibilities:

• Responsible for developing Interfaces for AR, Billing and Vendors from PeopleSoft
• As a Techno-Functional Consultant involved in the analysis of Core HR & Payroll modules Presented Technical Design walkthrough for NA Payroll to the Functional users.
• Involved in the functional design gathering for new enhancements.
• Involved in retrofitting the customize objects of NA Payroll and benefits as per PeopleSoft 9.1.Also, found the bugs in existing PeopleSoft 9.1 system and report to Oracle.
• Created BI Publisher Reports for Monthly, Quarterly & Yearly using PS Query.
• Worked on testing the Integration Broker that sends file to third Party Vendor.
• Developed use case documents, activity diagrams, workflows and process maps.
• Learned the functional concepts of NA Payroll and resolved the issues which we faced while running the payroll jobs and NA Payroll
• Involved in debugging the complex Application package codes and resolved most of the issues.
• Development and Unit test plan creation.
• Modified the reports used by the client to XMLP format. Setup the HCM to ELM Full synch, and Workforce Full Synch for the client.
• Interacting with the onsite coordinator for issues and queries in the data conversion.
• Coding and Unit testing at offshore as per the requirements and coding standards.
• Interacted and provided my expertise with peers on their issues whenever required.
• Involved in design and development of GL interfaces from 3rd party system to PeopleSoft Customized XMLP check printing Supported Cash Management and Purchasing & Accounts payable issues .
• Worked closely with System Architect to implement Service Oriented Architecture (SOA), Client side Validations, Server side Validations, Web Method definitions and data modeling.
• Developed Interface to create Purchase Orders with in PeopleSoft from the user requirement
• Developed an application engine program in General Ledger to load flat file accounting entries from FTP folders into journal staging tables.
• Developed custom AE program in GL to load journals from external interfaces into JRNL HEADER and JRNL LN tables. Created validation and Load reports
• Involved in designing the Interfaces, Reports and customization of the reports for the AR, AP, and GL Modules.

Confidential, Fortworth, TX

Business Analyst

Responsibilities:

• Facilitate interactive sessions with the Business Users, Subject Matter Experts and Functional Architects to gather and document business requirements.
• Conducted Gap Analysis for gathering requirements based on the existing Legacy System
• Created supporting artifacts that include business rules, data elements and wire frames.
• Developed and maintained the traceability matrix of the entire system, conduct walkthroughs with offshore development team. .
• Develop Use Case diagrams, Use case Narratives and User Stories.
• Administered Identity and Access Management (IAM), (including password management) controls for staff and vendors assigned to department-level projects.
• Created different Dashboards in report studio using combination of List, Crosstab, and Graph and Map reports.
• Discuss and resolve issues related to use case documents, provided status reports to the Project Manager.
• Created and maintained the hand off documents between different teams on the project.
• Worked closely with the Project Manager and Sponsor assessing the progress, dependencies and risk aspects of the project.
• Used AGILE methodology for 2nd Mortgage Loan product project, and was responsible for organizing, facilitating and planning Agile related meetings such as daily stand-ups, sprint planning, release planning, demo's, retrospectives and other development related activities.
• Developed Business Continuity Plan for recovering from a disaster, used MS Project for tracking the progress.
• Conducted the risk analysis for different issues concerning the project and creating contingency plans.
• Developed training material of the complete system for the assistance of the business users.
• Conducted JAD Sessions for Requirements discussions involving the different Business, Technology and Executive stakeholders
• Perform system and document analysis to understand the current systems
• Develop Process Model and detailed Business Policies and documenting the same in Business Requirement Document (BRD) .
• Prepare High Level Process Flow Diagrams and Business Process Flow diagrams for Great West Client Portal functionalities in Visio
• Participate in User Acceptance Testing (UAT) and developed Training Manuals