Experience Summary

• Over 8.5 Years of experience in ERP Consulting primarily as People Soft Techno-Functional Consultant with prudent expertise in PeopleSoft Financials, Fusion Accounting, PeopleSoft SCM and HRMS domains.
• Experience in Implementation, Design, Development and unit testing, Production Support, Enhancement and Migration of various software projects using PeopleSoft and Oracle.
• proficient with functional areas of PeopleSoft FSCM modules like General Ledger , Accounts Payable, Vendor Management, Asset Management, eProcurement, Supplier Contracts and HR modules like Global Payroll, Time and Labor and Core HR, Employee Self Service, Manager Self Service, Variable Compensation modules.
• Extensive technical experience in People Tools, People Code, App Engine, SQR, XML Publisher, Application Designer, Component Interface, Integration Broker, File Layouts, PS Query, Oracle 9i, 10g etc.
• Experience in Data Mapping and data Migrations from Source to Target Systems.
• Carried out fit gap analysis for various projects.
• Experienced in building and implementing PeopleSoft security.
• Experience in conducting CRP Conference Room Pilot sessions.
• Worked on PeopleSoft Security administration configuring roles and setting up permission sets for organisation and good knowledge in administering and handling PeopleSoft DB activities.
• Proficient with RDBMS concepts, SQL, PL/SQL and Shell Scripting and good expertise is Database performance tuning analysis.
• Extensive experience in Data Mapping, Data Migration and Data Conversion using PeopleSoft Tools.
• Involved in developing use cases, preparing unit test strategy and test cases.
• Worked in all phases of software development life cycle from requirements gathering to the production and successfully implemented several projects in both in waterfall and agile methodologies.
• Worked on version management tools like Phire Architect, VSS, RTC.
• Involved in project pre-project kick off activities Due Diligence Exercises, Proposal writing, Project Planning, Effort Estimation, Resourcing etc. for different RFPs.
• Good experience in leading teams.
• Experience across other technologies like Sales force setup and configurations, ETL Data stage.
• Good experience in Application maintenance, troubleshooting and support for PeopleSoft systems.
• Proficient in Microsoft tools like Excel, power point, SharePoint.
• Possess strong interpersonal and leadership skills with good experience in managing and planning project activities as well.
• Customer oriented with excellent problem solving skills.
• Adherence to On time delivery of customer deliverables builds, releases and milestones . and have been appreciated by Client many times.
• Strong ability in mentoring teams and preparing training materials.
• Sound technical decision-making capabilities.
• Possess strong logical, analytical and problem solving skills with positive attitude.
• Possess good ability to learn and use new systems and paradigms in considerably less time, solid communicator with exceptional team-building skills.

Technical Expertise

• ERP: PeopleSoft Financials 9.0, HCM/HRMS 9.1/9.0/8.4 , People Tools 8.51/8.50/8.49 ,Siebel CRM, Sales force
• Development Tools: Application Designer, App Packages, Application Engine, People Code, Approval Rule Set, Approval Workflow Engine AWE,SQR, Putty
• Integration Tools: Component Interface, Application Messaging, Integration Broker, File Layout
• Reporting Tools: XML Publisher, SQR, PS Query, Data Stage ETL, BI Publisher
• Admin Tools: PeopleSoft Security, CONTROLM, SharePoint server, RTC
• Packages: MS-Office Word, Excel, Power Point, Project
• Operating Systems: Windows, Mac, UNIX, Linux.
• Languages: People Code, SQL, PL/SQL, Shell Scripting, SQR
• RDBMS: Oracle 11 and 10g
• Version control Tools: Phire, Rational Team Concert and VSS.
• Domain Expertise
• Domains : Banking Finance, Investment Managements, Retail
• FSCM : General Ledger, Accounts Payable, Vendor Management, Contract Management, eProcurement,
• HRMS : Time and Labor, Workforce admin, Core HR, ESS
• CRM : 360 Degree View, Customer contracts, Call Centre.

Professional Experience

Confidential

Tech Lead PeopleSoft Consultant

• Project 1: Implementation of Fusion Accounting Hub
• Working on PeopleSoft to Fusion Accounting Hub Integration.
• Carry out As IS analysis of PeopleSoft GL Booking rules.
• Transform PeopleSoft GL Rules to Fusion Business rules.
• Perform Systems Analysis for sub ledger details and GL closing of the books.
• Develop context diagrams and involved in designing To Be Architecture using Fusion systems.
• Map and Migrate Ledger details, Master Chart of Accounts and Chart field Validations.
• Design Ledgers and Ledger groups for Fusion Accounting Hub.
• Project 2: 3rd Party Distribution Solutions
• Design inbound and outbound interfaces for USAA GL AP systems.
• Integrate USAA Financial systems like Accounts Payable General Ledger with Vendor applications
• Maintain GL Calendars and open period for the Ledgers involved in interfaces.
• Develop interfaces to create Journals for expenses received from Vendor.
• Document Data Mapping, chart field rules and Domain values for new GL interfaces
• Setup new vendors and payment methods between USAA and Vendor.
• Define new locations for USAA Vendors in Vendor Management module.
• Setup State Tax withholding and VAT setup in Accounts Payables.
• Coordinate chart field combos between USAA and Vendor Systems.
• Manage team and plan tasks.
• Design and establish FTP/SFTP connections between systems.
• Enhance data flow to downstream systems of USAA GL Systems.
• Develop ETL jobs to reconcile integrated systems to ensure that the ledgers are balanced.
• Build a Sales Force application that serves as centralized repository for USAA external vendors that support Investments area.

Tools Solution Environment:

PeopleSoft Financials 9.1, People Tools 8.50, Phire, RTC, Sales force, Oracle 10g, UNIX shell scripting, Control M.

Confidential

PeopleSoft Consultant Module Lead

• Plan manage support activities for Europe region Time Labor.
• Work on enhancing Agilent systems.
• Setup calendars and monitor jobs supporting T L.
• Monitor daily data flow between HRMS application and Time Labor application.
• Coordinate with third party payroll vendors like ADP.
• Plan, assign and coordinate offshore team tasks.
• Address production issues faced by Business users.
• Manage and Monitor support service calls.
• Carry out RCA for major problems common special .
• Preparation of the estimates time lines of the deliverables and project execution plan for all enhancements and Change Requests.

Tools Solution Environments:

PeopleSoft HRMS 8.9 8.3, People Tools 8.45/8.17,UNIX, Oracle 10g, Control M Scheduler

Confidential

PeopleSoft Consultant Project lead

• Analysis of Business Requirements.
• Plan, assign and coordinate offshore team tasks.
• Carried out fit gap analysis with PeopleSoft delivered functionality.
• Design and Implement Supplier contracts and Document Configurator modules of FSCM for USAA catering to their procurement needs.
• Developed application packages to customise Import document Page.
• Developed application engines to mass update the existing documents Contracts Amendments
• Prepare and validate product architecture and design model
• Review design with Technical architects.
• Developed SQR reports that help USAA CXO teams of USAA to manage and plan on vendors expansions.
• Preparation of the estimates, time lines of the deliverables and project execution plan.
• Project timelines management.
• Team orchestration to effectively carry out all project activities such as analysis design, coding, integration and testing.
• Resolved roadblocks for team and planed code reviews.

Tools Solution Environment:

PeopleSoft FSCM 9.0, People Tools 8.49,Application Package, Application Engine, Component Interface, SQR, People Code, Smart Bear, Oracle 10g, UNIX, Control M.

Confidential

Business Analyst

• Analysed Business Requirements.
• Understanding current customer system, current requirements and analyse the fit gap with PeopleSoft and Siebel delivered CRM functionality.
• Coordinating with on-site team to understand the requirements and prepare BRDs.
• Understanding current customer system, current requirements and analyse the fit gap with PeopleSoft and Siebel delivered CRM functionality.
• Preparation of the estimates, time lines of the deliverables and project execution plan.
• Preparation of functional and technical specifications.
• Set up target audience, marketing campaigns set up triggers for marketing campaign.
• Deploy the integration between Siebel and PeopleSoft applications.
• Develop reports using PS Query to monitor campaign efficiency and responses

Tools Solution Environment:

PeopleSoft CRM 9.0, Siebel CRM, People Tools 8.49, PS Query, BI Publisher, Component Interface, SQR, Oracle 10g, UNIX.

Confidential

PeopleSoft Consultant

• Integrated web systems with PeopleSoft Financials using XML and Integration Broker.
• Review and Improve Performance of the code written by developers in Sales Modules.
• Tune SQL queries by analysing the query and checking explain plan.
• Worked on Integration Broker, Develop App Messages, XML and App Engines.
• Worked on People Code and Interfaces extensively.
• Plan technical activities for the project.
• Analyse of the current customer system to plug-in new requirements.

Tools Solution Environment:

PeopleSoft CRM 8.4, People Tools 8.49, MAC Server, App Messaging, Integration Broker, Component Interface, XML, Application Engine, People Code, Oracle 10g, UNIX.

Confidential

PeopleSoft Consultant

• Project 1: Canon PeopleSoft 9.0 reimplementation Assessment Project
• Assessed existing Canon application to upgrade/Re-implement in PeopleSoft 9.0 Version.
• Study and collate current business requirements and concerns in Customer Contracts and RMA modules.
• Carried out fit gap analysis between customised Canon PeopleSoft 8.4 application and PeopleSoft 9.0
• Prepared recommendation Report considering level of customisations.
• Propose value-added processes, interfaces, architecture and solutions to meet the requirements.
• Project 2: Canon PeopleSoft CRM9.0 Reimplementation
• Re-implement Canon PeopleSoft CRM application from 8.4 to 9.0.
• Design Data Model for Customer Contracts module.
• Define high level PeopleSoft 9.0 re-implementation project phases, time lines and high level cost estimates.
• Develop new pages for exception handling in Customer Contracts.
• Create Prompt tables and Develop people code for Validations.
• Develop new application packages to automate agreements creation.
• Configure Branch Scripts and tokens required for scripts.
• Constructed reusable components people tools for customisation identification.
• Provide estimates, time lines of the deliverables and execution plan.
• Plan Coordinate competency building plan of the team.
• Monitor and control quality of the project.
• Involved in peer reviews for coding standards being followed.

Tools Solution Environment:

PeopleSoft CRM 8.4 9.0, People Tools 8.49, Application Packages, Application Engine, People Code, File Layout, SQL, Component Interface, Oracle 10g, UNIX.

Confidential

PeopleSoft Consultant

• Carried out Data Mapping between Legacy Systems and PeopleSoft Accounts Payable Tables.
• Developed Data Migration scripts to validate and load the data in to the PeopleSoft system from the legacy systems.
• Conducted Conference Room Pilots.
• Worked with Application Engines, File Layout, Component Interface and People Code for loading the data in to PeopleSoft system.
• Worked on reporting tools like PS Query, XML Publisher to develop different kinds of letters and reports as per the client requirement.
• Worked as a Security Administrator in defining the PeopleSoft security roles, permission lists and user profiles as per the requirement for all the modules.
• Involved in resolving the technical issues during Unit testing, SIT and UAT.

Tools Solution Environment:

PeopleSoft Financials 9.0, People Tools 8.49, Application Packages, Application Engine, People Code, Security, File Layout, SQL, Component Interface, XML Publisher, PS Query, Oracle 10g.