Peoplesoft cash management resume

SUMMARY

• Confidential TEMPhas over 15 years’ experience in IT and Financial systems, covering various industries such as: Retail, Energy, Utilities, Banking, Oil & Gas, Insurance, Higher Education, Government, Healthcare, and Private Equity.
• Range of experience includes ERP software implementations for PeopleSoft Financial (expertise in PeopleSoft Treasury Banking, Cash Management, Deal Management and Financial Gateway) and Human Capital Management systems; including Hyperion and MS Dynamics integration.
• Experience includes beginning to end of the SDLC (System Development Life Cycle) in Agile and Waterfall projects; driving, documenting and delivering solutions in all areas including: business and systems requirements gathering, software analysis and design, business process re - engineering, software fit/gaps analysis, workflow and process flows design and documentation,
• IT systems documentations, banking integrations, general ledger account mapping, and project lead experience.

TECHNICAL SKILLS

• PeopleSoft Treasury
• International Projects
• PeopleSoft FIN & HCM
• Process Analysis & Design
• Business Systems Analysis
• Treasury implementations
• General Ledger Integration
• Bilingual: English & Spanish
• External 3rd party integration
• PeopleSoft Financials & HFM
• Data Mapping System Conversion
• International Banking
• General IT experience
• QA software testing
• Banking Interface/Integration
• Account Reconciliations
• Large Scale project experience
• Data Analysis
• Project Lead
• ERP Integration
• User Acceptance Testing (UAT)
• Cross-functional Coordination
• Process reengineering

PROFESSIONAL EXPERIENCE

PeopleSoft Financial Cash Management Consultant/ Senior Business/ Systems Analyst

Confidential, Austin TX

Responsibilities:

• Support the financial systems integration of an acquisition of a Latin American corporation in Guatemala, Honduras, El Salvador, and Peru.
• Advance, document, and aid in finalizing the general ledger account mapping of the Latin American corporate accounts to US corporate accounts; and halped meet USGAAP accounting adjustments/elimination entries needed for US corporate accounting.
• Aid in the financial/accounting system integration for Hyperion, MS Dynamics, EDS Data Warehouse, and internal POS system.
• Lead pilot sessions (CRP) to review business production processes and PeopleSoft processes; perform requirements gathering and present future state system designs.
• Business requirements gathering sessions in Spanish to acquire requirements for MS Dynamics and PROFIT financials; specifically for AP, GL, AM, PO and Treasury/Cash Management modules.
• Develop fit gap analysis and provide feedback on design decisions, pros and cons, based on business needs and modules being implemented.
• Requirements gathering, documentation on system integration points between various systems off the shelf and in - house custom systems.
• Analyze code and test system changes for production issues; provide UAT testing support to business users testing system changes.
• Analysis and design resolution for internal production issues in PeopleSoft for Cash Management, production interface issues, and Asset Management.
• Analysis and updates to PS Cash Management production issues using MT940/Swift ISO20022 files.
• Requirements gathering on a BI Data Warehouse used for reporting on EZCORP financials for Latin American countries.
• Drive approval for business requirements and design decisions. As well as execute upon approval of stakeholders.
• Development of playbook for easier implementation of systems integration on new acquisitions. .
• Development of Project plans and timelines. .

PeopleSoft ERP Financial Consultant

Confidential,New Orleans, LA

Responsibilities:

• Upgrade of PeopleSoft Financial modules: Banking, Cash Management, Deal Management from 8.4 to PS 9.2.
• New implementation of Treasury processes in Banking, Cash Management, Deal Management and Financial Gateway not available in PeopleSoft 8.4, which include: Automation of daily Bank Account Reconciliations, Bank Statement Accounting, Treasury Accounting, Investment Pools, Deal Management, Bank Transfers and EFT Transfers, Cash Positions, Cash Sweeps, and custom enhancements to automated Treasury journals directly from custom Treasury Reports.
• Development of Functional Design Specification documents, system custom process design specifications to address gaps in the system required by the client
• Development of queries/views, batch system process scheduling, system, integration and end user test scripts.
• Conducted training and working sessions wif client on Treasury system processes
• Analysis and resolution of defects during system, integration, and end user testing phases.
• Communication wif offshore technical teams to address development and enhancements as well as working wif the offshore team to resolve technical defects.
• Integration wif General Ledger, Accounts Payable, Accounts Receivable.

PeopleSoft ERP Financial Lead

Confidential, Baltimore, MD

Responsibilities:

• New implementation of Treasury software for various universities across Central America, South America and Europe.
• Implementation of PeopleSoft Treasury Banking, Cash Management and Financial Gateway 9.2
• Processing of SWIFT/MT940, MT942, MT950, ISO20022 bank statements from international banking clients; multi-currency SEPA bank files and Latin American bank files.
• Performed business requirements gathering sessions, system demos, system configuration, system testing, test script generation, and UAT session builds.
• Integration wif financial systems: Banner, Spring, and SunGard Treasury
• Integration wif Accounts Payable, Accounts Receivable, and General Ledger modules.
• Bank Reconciliation Rule SQL objects created to enable the system to perform an automatic reconciliation wifout a reference number for deposit transactions created externally to the financial system.
• SQL development for system and data analysis, end user training, and UAT testing purposes.
• Development of business process documentation, configuration documentation, and review and Spanish translation of training documents.
• Upgrade implementation of Treasury system from PeopleSoft Treasury (Banking and Cash Management) 8.8 to PeopleSoft Treasury (Banking and Cash Management) 9.2
• New implementation of Treasury system Financial Gateway, Deal Management, and Risk Management 9.2
• Implementation of new Cash Management functionality during the upgrade process, includes: Cash Settlements, Funds Transfers, Pooling, Bank file Integration for electronic payments.
• Integration wif PeopleSoft CRM and banking software.
• Integration wif Accounts Payable, Accounts Receivable, and General Ledger modules.
• Accounts Receivable table use and bank reconciliation only due to a customized bolt on for the AR module to process utility payments from clients and customers on PeopleSoft CRM.
• Provide guidance and design for Accounts Payable payment methods for ACH and wires.
• Removal of heavily customized processes wifin the Bank Reconciliation Rules, bank statement import processes, and worked wif the bank to integrate new processes for automation. Removal of customizations accomplished successfully and still keeping the business functionality required by the client.
• Development of business process documents, test plans, test scripts, design and demo presentations, configuration of the 9.2 system, configuration documentation, process flow diagrams, and support during go-live.
• SQL development for testing, data analysis, and end user scripts for UAT testing.

PeopleSoft Treasury 9.2 Implementation

Confidential, Oklahoma City, Oklahoma

Responsibilities:

• Review and analysis of the prior attempt to implement PeopleSoft Cash Management using 8.9 wif heavy customizations of delivered and new custom processes (bank reconciliation, general ledger allocations, cash positioning and bank sweep processes).
• Performed Business Process discover sessions, business process flow development, documentation of current and future state business processes for treasury.
• Provided a redesign of their Banking and General Ledger architecture to remove over 2,000 duplicate bank accounts and a duplicate general ledger used to document cash management, payable, and receivable transactions adjustments manually.
• Provided a new design, new implementation path, and working automated PS Treasury processes wif the ability to provide the required functionality.
• Performed Business Requirements Analysis, Fit/Gaps, Treasury 9.2 Demos, Configuration of Demo environment to provide To-Be business process flow examples.
• Integration wif Accounts Payable, Accounts Receivable, General Ledger.
• Planned, lead, and managed the implementation of the Banking, Cash Management, and Financial Gateway modules.
• Conducted PS Treasury module demos for high level management financial, accounting, and treasury management.
• Conducted discovery sessions for various departments in the City of Fort Worth.
• Developed Business Process flows for current state and future state design of PeopleSoft Treasury.
• Design, configuration, and testing of system design options between cash management and the general ledger modules for proof of concept for management approval.
• Conducted Fit/Gap sessions, functional design documentation, and technical design documentation.
• Integration wif Accounts Payable, Accounts Receivable, and General Ledger.
• Accounts Payable module was used to interface data from a 3rd party system coz the City of Fort Worth had various payment systems used by citizens around the city. These payments were reconciled in the Treasury system.
• Architected the PeopleSoft Banking structure and Cash Management design to integrate wif the Deal Management module.
• Designed and developed the working prototype for the prototype phase of the project.
• Conducted Requirements gathering sessions for the Private Equity Funds Management business and the Southern Ute Finance Business.
• Conducted Fit/Gap sessions, functional design documentation, and technical design documentation.
• Designed and provided solutions to provide a technical path to remove and update a heavily customized Bank Reconciliation and Cash Management customization from 8.9 to PeopleSoft Banking and Cash Management 9.2 (wifout customizations).

PeopleSoft Treasury

Confidential, Newport Beach, CA

Responsibilities:

• Designed and configured a solution to interface wif 3rd party systems (SunGard and PeopleSoft)
• Provided expert contributions to the architectural design, processing, and testing of custom file layouts for Financial Gateway processing.
• Provided expert contributions to the redesign of architecture and processing for AP single payment vendors.
• Design, configuration, and testing of Treasury Interface files (Payroll, Legacy systems, Chartfield mapping).
• Assisted in the design and mapping of legacy accounting structures to PeopleSoft General Ledger account structures for Banking.
• Designed and configured Banking and Cash Management solutions for bank reconciliation.
• Knowledge Transfer documentation, Design Documentation, Configuration Documentation and Training Sessions on internal business processes and PS Treasury functionality using PS Cash Management, Reconciliation, EFTs, Bank Polling, Integration Broker, and Financial Gateway.
• Integration wif SunGard Treasury and several banking institutions to perform automatic bank reconciliations and electronic payments.
• Assisted in the configuration, testing, and documentation of a custom PS process which maps legacy data to PS data for interface files.
• Integration wif Accounts Payable and General Ledger. their was a bolt on created for the Accounts Receivable module to integrate client payments wifin the PeopleSoft Financial System.
• Configured and tested the Accounts Receivable bolt on as well as the payment methods for the Accounts Payable system.
• Development queries for production support and configuration support.
• Designed and architected new PS reports for Treasury and custom tables.
• Assisted in the design, configuration, and development of test scripts, scenarios, cases, end-user support in UAT testing.
• Post production support for PeopleSoft Treasury system.

PeopleSoft Treasury

Confidential, Dallas, TX

Responsibilities:

• Architected and provided expert contributions about architecture and processing during the design phase, build phase, and testing of Wires and reconciliation.
• Business and requirements analysis of fit/gaps in AP and GL business process integration wif Treasury Cash Management.
• Design, configuration, and testing of Treasury Interface files.
• Fit/Gap presentations on internal business processes and PS Treasury functionality using PS Cash Management, Reconciliation, EFTs, Bank Polling, Integration Broker, Financial Gateway, and Cash Positioning.
• Mapped business processes against proposed and recommended PeopleSoft Treasury solutions.
• Design and configured a solution for previous PS Banking setup which implemented duplicate bank accounts in the production system.
• Agile (SCRUM) project environment; testing of web-based applications in .Net environment.
• Assist management in release plan development
• Organization and prioritize high risk items and developer tasks to meet project deliverables
• Administration and maintenance of SharePoint and Jira websites to manage projects.
• Development of QA Testing Plan, Use Cases, Test Cases and Test Scripts.
• Product evaluation and use of RedGate SQL Generator for load testing of large amounts of data.
• Development of Microsoft SQL and C# code for testing and web application.
• Able to take up a technical role when needed, SharePoint Administrator, JIRA Administrator, and SQL Management tools for data generation for QA and developer testing.
• Business and software in the Oil & Gas and Healthcare ERP sectors.

Assessment - PS Treasury Advisor

Confidential

Responsibilities:

• PeopleSoft Treasury 9.1 demo and presentation of Treasury specific activities, events, and business processes. This demo was used to halp the client determine the uses and needs of the PS Treasury system for their business environment before purchasing the Treasury module.
• Development of training documentation for PeopleSoft Treasury specific events.
• Training for in-house PeopleSoft implementation technical support team.
• Presentation and training documentation developed for Treasury Cash Management, Deal Management, Risk Management, Integration Broker, Financial Gateway, and international banking reconciliation processes, cash sweeps, EFTs, Settlements, and Treasury Accounting.
• Business processes and documentation relates to private sector insurance services.
• Team lead to the financial implementation of the PS Treasury module (Banking, Cash Management, and Financial Gateway).
• Drove conference room pilots (CRPs) for large groups which included SMEs and department heads for all state of Delaware governmental organizations.
• Leaded all areas of the system development life cycle, from business requirements gathering to UAT testing.
• Worked wif Bank of American, PNC, and Wilmington Trust on BAI files, conversions, file transfer testing, reconciliation of banking files and PS payroll files.
• Analysis and configuration of Treasury integration wif AP, AR, GL and payroll modules.
• Developed UAT testing plan for the Treasury modules; developed test scripts in Quality Center/Test Director.
• Documentation of current and To-Be system state, configurations book for the TR system, and system integration points.
• Data analysis, data mapping, data conversion, and query building using SQL, and PS Query.

PeopleSoft Functional-Technical Consultant

Confidential, Galveston, TX

Responsibilities:

• Analysis, design, and implementation of configurations for HCM modules.
• Analysis of UTMB legacy time and labor systems to PeopleSoft Time and Labor wif KRONOS, data integration for report development.
• Documentation, query development, data conversion, data mapping, and PeopleSoft - KRONOS data integration.
• Development of data warehouse views and queries using PS Query, TOAD, SQL, and Crystal Reports 9.0.
• Development of queries and reports for TAM, Time and Labor, Ben Admin, Student Admin, and Payroll. (HRMS modules on PS 9).
• Configuration for different modules in a team environment included AP, AR, PO/ePro, KK, GL, TR, AM, Grants and Contracts.
• Ad-hoc query and report development for various financial modules, as needed.
• Development of end user guides for use post-production for various financial modules.
• Business Process Flowcharting of financial processing for the various financial modules
• Production troubleshooting and support for end-users on financial modules.
• End-user training on purchasing, GL/KK, and AP.