Peoplesoft Techno Functional Consultant Resume
SUMMARY
- Techno - Functional Consultant with 14+ years of experience in developing, implementing multiyear projects in PeopleSoft Financial solutions across multiple domains including Finance, Education, Service, Technology, Federal and Energy domains
- Experience in implementing large scale upgrade, implementation, development and support projects in PeopleSoft ERP applications including Cloud solutions (SaaS), PeopleSoft Finance and HCM solutions
- Collaborate with Project Manager, Platform Owners, Product Owners, Solution Architects, Enterprise Architects, Security Groups and Business Analysts to design, analyze, develop, deliver, test and support PeopleSoft solutions in DevOps, Agile and Waterfall models
- Highly Experienced in coding and implementing PeopleSoft solutions using PeopleSoft’s technical tools which include PeopleCode, PeopleSoft Fluid, Application Engine, Component Interfaces, Webservices, Crystal Reports, XML BI Publisher, nVision, SQR Programming, Integration Broker, Application Package, Approval Workflow Engine (AWE), Workflow and PS queries
- Extremely competent in developing complex IT solutions, systems engineering and software development using new tools and technologies including PeopleSoft Fluid, Integration Broker, Application packages in latest PeopleTools 8.58; Proven knowledge on automated testing, stored procedures, scheduling, maintenance and technology trends
- Strong knowledge in Software Development Life Cycle (SDLC), Agile methodology, Dev Ops, Project management, development of cross product family solutions and business processes including Reporting (Business Intelligence and Data Analytics)
- Excellent demonstration of domain knowledge, analytical, quantitative and presentation skills, Architecture diagrams using swim lane diagrams, construction of logical/physical data models, process flows and status reports
- Possess excellent communication skills, maintain healthy relationships with stakeholders and collaboration with users/vendors across all business levels integrating virtual workspace and remote interpretation solutions including WebEx, MS Teams and Zoom Video
TECHNICAL SKILLS
PeopleSoft Financials 8.8/8.9/9.1//9.2 : General Ledger (GL), Accounts Payable (AP), Purchasing, Project Costing, Commitment Control, Asset Management, eProcurment(ePro), AR/Billing, Contracts, Grants, Travel & Expenses, Security Administration
Tools: People Tools 8.48 to 8.58 - PeopleSoft Fluid technology, PeopleSoft Update Manager, People Code, Application Engine, Integration Broker, File Layout, Application Package, Web Services, Advanced XML, XSLT and REST Services, Micro services, Distributed Systems and Cloud, SQR, Crystal Reports, BI Publisher, nVision Reports, Component Interfaces, Workflow, AWE, Web Services, HTML, Java, Python, JavaScript, Unix, Linux,, Shell Scripts, Oracle 12c,SQL Server, PL/SQL, Oracle SQL Plus, SQL Server, Ultra Edit, Toad, MS Office
Qualitative: Self-Driven, Strong ability to collaborate, Creative, Self-motivated, Passionate, Innovative, Minimal supervision, Proficiency in systems
PROFESSIONAL EXPERIENCE
Confidential
Peoplesoft Techno Functional Consultant
Responsibilities:
- Implemented Multiyear Financial solutions for CD Departments to facilitate Budget planning and review process for Fund’s external donors, working with various key stake holders (Division Chiefs, TA Officers, Budget officers, IT Officers) across multiple departments
- Developed custom Bolton applications using PeopleSoft Financials 9.2 and tools 8.56, including Fluid designs, Complex page designs, AWE, Integrations with other downstream legacy systems, Workflow rules, Reporting using complex PS queries, SQL packages, Dashboards in Cognos, Tabluea and PowerBI
- Automated and developed lot of custom PeopleSoft Integrations with various Cloud/SaaS solutions (Workday/Clarizen/Adobe AEM) using Peoplesoft CI, webservices, .net Integrations, Advanced XML, XSLT and REST Services, Micro services and REST/SOAP methodology
- Co-Led Architecture review sessions with Procurement, ISG and EA in assessing solution and project risks, architectural components, systems, integrations and processes, developed risk control measures to mitigate both technological and program risks.
- Played a key role in implementing Time Reporting and Cost Allocations report changes to integrate and automate solutions between HR, time reporting system and Peoplesoft finance systems
- Brainstormed design and solutions, Developed design specifications and data models for end user/data consumers
- Developed and Designed Financial Allocation steps and developing custom process to perform allocations within financials between various chart of accounts
- Worked on Partners Connect Implementation along with ICDGP, to provide better reporting structure for donors, streamlining existing reports along with business stakeholders, replacing old Donor portal products and services
- Worked with Multimedia, Media Hub, iLab, Brightcove, Social media platforms to integrate with PeopleSoft applications
- Led automation effort, with ICDGP in financial transition of Project Budgets, Activities from EFRMS to CDPORT; Developed an automated solution to allocate budgets to CDPORT structures, based on past drawdowns, expenses and financial commitments
- Designed and developed various automated process in Financials, easing the manual budget roll overs up to 20M USD per year and reduced the user’s effort in budget conversion process by more than 70% (converted 200 project budgets within 2 months)
- Developed control and monitoring queries and reports to facilitate efficient reporting needs for CD Departments, to monitor budgets and avoid budget errors
- Implemented Dashboards including Project Manager and Portfolio Dashboard, collaborating with ICDSE, CD Departments, RCDC and IT; Worked with ICDGP to develop various donor and external funded budget reports in Cognos, Tableau
Confidential
Techno Functional Consultant, PeopleSoft Financials
Responsibilities:
- Worked in PeopleSoft Financials Upgrade project from 8.8 to 9.2 and PeopleTools from 8.48 to 8.53, business analysis, retrofitting and developing new processes involving accounting, travel and expenses, General Ledger, Account Payables, Procurement, Asset Management and Billing
- Designed and implemented various PeopleSoft GL reports using nVision and Business Intelligence (BI) Publisher reports replacing the excel worksheets; Performed fit gap analysis, prepared functional and technical design documents, develop data flows, develop/retrofit solutions
- Involved in Heavy RetroFitting and analyze current customizations in v9.1 and remove these in v9.2 so that delivered functionality is used as much as possible
- Involved in understanding of the Functional table structure, rules, and workflow of PeopleSoft Financials, specifically AR/BI, Contracts, eProcurement and AP.
- Worked on Interfaces between various modules including AR - Billing, Projects to Billing, Contracts - Billing, Project Costing - Expenses/GL
- Setting up Business Unit GL and Project Costing BU which includes setting up Ledgers, Ledger Groups, Set ID, Table Set Control, Combo Edits, Subsystem Journal Generator, Chartfield Values
- Involved in setting up Java class path and developing interfaces to initiate JAVA program
- Hands-on development on 9.1 / 9.2 using PeopleCode, PeopleTools, Integration Broker, App Engine, App Designer, XML Publisher, SQR, SQL
- Designing of Application Widgets, File Layouts and nVision Reports to meet the Functional requirements
- Developing Web services, Integration Broker Services Operations, Component Interfaces, Application Packages, Crystal to BI Publisher to integrate the legacy systems with PeopleSoft GL
- Designing Allocation steps and developing custom process to perform allocations
- Working on Conversion mapping to convert the Legacy system data to PeopleSoft 9.1 CoA
- Designing Accounting Entry and Journal Generator Templates for Journal Entry creation
- Developed multiple interfaces to import external data files into General Ledger and Account Payables system
- Designed and implemented custom voucher workflow using latest Approval Workflow Framework (AWE) and Crystal to BI publisher report conversions
- Develop conversion routines, interfaces with CI, Application Engine processes from existing systems. Interact with Stakeholders and in documenting change requests for the Financials modules
- Develop enhancements and customizations for FSCM modules include AWE using PeopleTools Components, Pages, Records
- Review the new enhancements/modifications to ensure quality product and making sure the requirements are met.
- Migrate developed code from development to testing environments and provide assistance to the users in User Acceptance Testing
Confidential
PeopleSoft Techno Functional Consultant
Responsibilities:
- Developed Expert Management solutions involving Short Term, Long Term experts, Expert Portal, automating Proforma logic and platform integrations with financials; Developed and implemented numerous logging, monitoring, and email modules to track messaging and flow of transactions between HR and Financial Systems key to minimizing errors and business disruptions.
- Worked on numerous customized bolt-on applications that interfaced with PeopleSoft’s Purchasing, Account Payables, General Ledger, Project Costing, Commitment Control and Travel and Expenses, using PeopleTools, PeopleCode, Application Engine, SQRs, Component Interface, Workflows and Application Packages
- Established functional design for setting up General Ledger templates for various integration with PeopleSoft Subsystems including Account Payables, Project Costing, Commitment Control and Travel and Expenses
- Formulated and spearheaded a system design to automate year end accrual activity for the Fund using Peoplesoft Account Payables and Travel and Expenses
- Led various business requirements, technical requirements, identified gaps, made recommendations to strengthen controls and documented technical specification and technical solutions
- Led support team including offshore responsible for various customizations, development of enhancements, integrations and support of financial systems; worked extensively in handling high volume of PeopleSoft Financials production help desk incidents, technical problems, enhancements and supported various year end activities including Accrual process, W2 reporting.
- Worked as lead handling Fund’s Travel Information management system, involving processing missions, RAP, automating trip creation process, processing expense reports and handling budget errors