Techno-functional Consultant Resume Profile
NJ
PROFESSIONAL SUMMARY
- An IT professional with 8 years of experience in PeopleSoft FSCM Solutions with varied expertise in various HRMS modules as well as exposure on PeopleSoft CRM-OTC Sales.
- Functional knowledge of Accounts Payable ,Order Management, Billing, Products, Pricing
- Worked on various Production Support, Implementation and PeopleSoft Upgrade projects.
- Worked on Requirement Gathering, Designing and Development of Business solutions to the problem or change.
- Experience in Conversions, Migrations, Interfaces and Reporting.
- Provide effective systems development using: PeopleTools, PeopleCode, Application Designer, Application Engine, Component Interfaces, Integration broker, Application Messaging, PeopleSoft Security, Process Scheduler, Data Mover, PS Query, Crystal, and SQR.
- Hands on experience on working with Oracle and SQL Server databases
- N.A Payroll, Accounts Payable, Billing, Order management, GL.
- Expertise in performing Fit-Gap Analysis, functional and technical designs and business process flow in a PeopleSoft version upgrade projects for upgrade projects to 8.8.
- Expertise in Application development in using PeopleTools 7.5 to 8.4 xs .
- Worked on various testing phases on full cycle project unit testing, functional testing, regression testing performance testing, integration testing, UAT testing in PeopleSoft mainly technical .
- Good communication verbal/listening and presentation skills. Hands on experience on handling client business calls and meetings.
- Excellent skills and in presenting workshops and at team meetings.
- Worked with technical and functional team and User community. Able to work independently as well as in a team.
- Experience in Customization, Support and Maintenance of PeopleSoft FSCM modules for FSCM implementation.
- Developed Multilanguage crystal reports. Generating crystal reports from scratch and customization of existing crystal reports.
- Have worked extensively on customization of delivered PeopleSoft FSCM modules, integration of PeopleSoft application with third party system.
- Have functional understanding of Sales, Marketing, Account Planning, Active Analytics Framework, General Ledger, Accounts Payable etc
- Strongly conversant with ISO 9001 quality procedures, CMM standards and have strictly adhered to the procedures while executing my project.
- Six Sigma Green Belt Certified.
- Developed pricing calculator tool in excel using VB in order to capture the sales information offline which can be merged in sales application later.
TECHNICAL SKILLS
ERP Technology :PeopleSoft: PeopleSoft 8.0, SQR, SQL database, PeopleCode, Crystal Reports ,Application Engine, CI, oracle PL/SQL programming etc
Application Area :FSCM: Accounts Payable ,Order Management, Billing , Products, Pricing
HRMS: Maintain Workforce, Personal Profile, Employee Self Service, Manager Self Service, Global Payroll, N.A Payroll
CRM : Sales ,Order Capture Helpdesk
People Tools : People Tools 8.0, 8.43, 8.44, 8.45, 8.46.
RDBMS : Oracle 11g, MS SQL Server
App/Web Server :BEA Weblogic
Reporting Tools :SQR, Crystal Reports, PS/Query
Operating Systems : Windows NT, Windows 95/98/ME/XP, UNIX, MS-DOS etc.
Version Control
Migration Tools :VSS Microsoft , Visual Studio Microsoft , STAT Quest
Database Tools :TOAD, PL/SQL Developer, Query Analyzer etc.
Professional EXPERIENCE
Confidential
Techno-Functional Consultant
Responsibilities
- Customized the app engine, peoplecode, Component Interfaces, pages, components, menus, SQR, PS Query, Crystal reports, custom scheduling of processes etc.
- Did Unit Testing, Functional and Integration testing for custom/customized objects. Also helped the users in the functional and UAT testing.
- Provided training to developers and users on PS Query Manager, Peoplecode/App Engine/SQR/Component Interface to developers and Person Model to the IT team
- Worked on tuning PeopleSoft Queries used by the users. Increasing the performance of the queries used in various SQR's and Application Engine programs.
- Providing the initial production support after going live on 9.0 versions to attain the full stability in the new version as well.
- Training users on PS Query Manager, and worked on various Queries on tuning and changes.
- Taking a backup using Data Mover by creating DMS scripts for the various records before making mass changes.
- Provided the initial production support after going live for a month till the system is stable.
- Weekly call with clients for status update and task allocation within the team. Tracking the status of all the work done by the team mate and update he client.
- Prioritizing the work. Creating the FDD and TDD based on the requirements and getting sign off from client.
- Coordinated the disaster recovery test for Peoplesoft applications. Followed all the procedures and managed coordination with various teams for the test
- Worked on Production issues raised by user ,monitoring logs and processes based on the run time.
- Developed alert mechanism for critical jobs if they don't run as per the schedule or if the jobs are running beyond the scheduled run time.
- Created user profiles for new users and provided required security and permissions.
- User deletion from the system and activation and deactivation of the users in the system.
- Helping the users in case creation and updation.
- Resolving production issues related to case creation, visibility of cases to business and multiple case Id's etc.
Confidential
Tech Lead and Developer
Responsibilities
- Was involved in creation of interfaces to match the upgraded and current version of the environment.
- Application upgrade from PS 9.0 to 9.1 of FSCM module.
- Developed interface to migrate the roles, permission and security.
- Design develop build test and migrate the pages appengine programs as per the requirement using STAT.
- Develop and perform unit testing and UAT testing.
- Creation of TDD and Test plan for the interfaces.
- Migrated the project using STAT tool.
- Used data mover to migrate the data from one environment to other environment,
- Generate files from Application engine and pick it up from other location to process data within the application.
- Migrate the security objects from PS tree from one application to other.
- To keep a track and updating Testing Scenarios excel document while Functional/UAT Testing.
- Given the training on new security model to the Security users.
- Taking a backup using Data Mover by creating DMS scripts for the various records before making mass changes.
- Worked on PS Query Manager, tuning and support of various queries.
- Provided training to the new developments to users.
- Organizing meeting with client understanding the requirement working on the feasibility of requirement and development of the changes.
- Managing the entire cycle from requirement gathering to migration to Prod till UAT.
- Created user manuals for the changes to help user to understand the functionality change usage.
Confidential
Technical Consultant
Roles Responsibilities
- Worked on any new requirement/changes in the project online and SQR development.
- Collected the requirements from the business.
- Did the analysis of the new change for the support.
- Worked on the Unit Testing and Functional Testing of the changes done.
- Reviewed the time frame and period required for any new change or new requirement coming.
- Work allocation managing incidents on Virtual tech and Service now.
- Worked on tuning Peoplesoft Queries used by the users. Increasing the performance of the queries used in various SQR's and Application Engine programs.
- Managing user communication regular update of the issue to user and client.
- Work assignment with in the team based on the work load of the incidents.
- Monitoring all the jobs and log files on server, server load and certificate renewals.
Environment Version: Peoplesoft HRMS module, Peopletools 8.44, peoplesoft HRMS 8.8.
Confidential
Senior Consultant Developer
Responsibilities
- Worked as a senior business analyst / People Soft technical Consultant.
- Carry out functional and technical analysis of enhancements or bug-fixing requests raised by the client.
- Development of the enhancements using PeopleTools, PeopleCode, App engine, App package etc and unit testing.
- Internal QA Code / Peer Review of enhancements / bug fixes done by offshore team.
- Mentor and induct new resources into the project.
- Interact with the Business users and Client team on daily basis for requirements and clarifications.
- Prepare BRDs and other requirements documents for enhancements and new developments.
- Customized the peoplecode, pages, components, menus, Workflow, SQR, PS Query based on the custom/customized objects version 8.8, during the development of the project.
- To keep a track and updating Testing Scenarios excel document while Functional/UAT Testing.
- Project migration from various environments from DEV to UAT to Prod.
- Worked on tuning Peoplesoft Queries used by the users. Increasing the performance of the queries used in various SQR's and Application Engine programs.
- Created and updated the crystal reports as per the requirements. Modified the pricing calculation for the crystal reports as per the new billing rate.
- Update the rates and cost calculation SQR and crystal reports with new rate changes.
- Updating the appengine programs responsible for cost calculation and rates.
- Addition of new pages and new field on existing pages with the change in business requirement.
Confidential
Senior Software Engineer
Responsibilities
- Conduct requirement gathering sessions with stakeholders and document the same.
- Generate new crystal reports on CRM and FSCM module for different language and currency UK and Italian .
- Modification to the billing process as per the requirement.
- Tuning and automations for better customer experience.
- Tuned OM BILL process in FSCM from 28 mins to less than 2 min.
- Hands on Experience on App Package, Application Engine, People Code.
- Created Application Engine Program used for the Auto Renewal Process in Thomson.
- Creation of new Application Classes for the Hold Codes in Order Capture.
- Worked on C Project Customer plus :- This project provides customers with the pending renewals for products on the My Account Self Service Application. The customers can now renew pending orders from this Self Service application.
- Created Application Engine Programs and FTP the file to My Account server.
- Implemented a new pricing model cascade pricing for OTC cycle from CRM to FSCM. Modified the Pricing in CRM to Billing in FSCM
- Unit testing of the developed process. Handling small projects solely from requirement gathering to UAT. Work allocation client meetings, status update client walkthrough for the changes implemented. Taking sign off on the requirements and creating FDD based on the discussions.
- Updating the products and pricing calculation for products on FSCM module.
- Addition/deletion of new products and Installed products.
- Generating reports product wise and business unit wise using crystal reports and SQR.
Confidential
Peoplesoft FSCM CRM
Responsibilities
- Sales cheaper and have a more consistent sales process.
- Executing and managing Quality Audits, PPM's QMR's.
- Planning Monitoring Project using C-Projects.
- Technical and functional analysis of the business requirements from Customers.
- Customization of the delivered CRM modules according to business requirement.
- Creating notification workflows to intimate the concerned users about any business transaction/event.
- Integrating xSell Proxima with various home grown application using Integration Broker, Web Services and Component Interface.
- SPOC for tool up gradation from PS ver 8.9 to 9.0.
- Maintaining Project folder and documentation control using VSS 6.0.
Confidential
Peoplesoft FSCM
- xSELL Genie is an online proposal making tool enabling the Pre sales teams to respond to an RFP in quicker, better and steadier way. xSell Proxima is integrated with Genie using web services and populates the data whenever a deal is finalized and win.
- Requirement analysis and generating the process flow.
- Involved in making the FDD, TDD and URD for the same.
- Customized the app engine, peoplecode, Component Interfaces, pages, components, menus, SQR, PS Query, Crystal reports, custom scheduling of processes etc.
- Did Unit Testing, Functional and Integration testing for custom/customized objects. Also helped the users in the functional and UAT testing.
- Responsible for writing the query to send the particular data.
- Developing web services and making call to web services to get the data.
- Developed pages for populating the data from the source and update PS table with the data from third party.
Confidential
Peoplesoft FSCM
- SHINE is the database of Satyam on SAP platform. It acts as a central database for the associates of satyam. All the employees of Satyam should be workers of xSell Proxima .So, we integrated SHINE with xSell Proxima using File Layout, Component Interface AE.
- Requirement gathering analysis.
- Preparing the Functional and Technical Documents to map the process flow and implementing the same.
- Development using Application Designer
- Testing Deployment
Confidential
Integration of xSell proxima with MPOWER
- Doing technical specs analysis for the customization or requirement from the user. Including providing the template technical spec documentation.
- Doing the impact analysis of the change request.
- Customized the peoplecode, pages, components, menus, Workflow, SQR, PS Query based on the custom/customized objects version 8.8, during the development of the project.
- Mpower is a reporting tool of Satyam Computers. Integrated xSell Proxima with MPower where in all the 27 measures required by MPower has been sent to the MPower team on daily basis .Integration is done using Component Interface and access to the relevant view has been provided to the MPower team to fetch the incremental data.
- Requirement gathering analysis.
- Preparing the Functional and Technical Documents to map the process flow and implementing the same.
- Worked on tuning Peoplesoft Queries used by the users. Increasing the performance of the queries used in various SQR's and Application Engine programs.
- Development using Application Designer, view creation and providing relevant access.
- Testing Deployment
Confidential
Integration of xSell proxima
- Startrac is a tool to capture FLCL's records and performance. For sales actual values are captured in Proxima which are sent to startrac for verification. This is webservice based integration where in the source system can capture the information as when required by pinging the webservice and providing the required authentication.
- Requirement gathering analysis.
- Doing technical specs analysis for the customization or requirement from the user. Including providing the template technical spec documentation.
- Doing the impact analysis of the change request.
- Customized the peoplecode, pages, components, menus, Workflow, SQR, PS Query based on the custom/customized objects version 8.8, during the development of the project.
- Worked on tuning Peoplesoft Queries used by the users. Increasing the performance of the queries used in various SQR's and Application Engine programs.
- Preparing the Functional and Technical Documents to map the process flow and implementing the same.
- Creation of webservices and nodes for exposing them to the source system.
- Testing Deployment