WORK EXPERIENCE:

Confidential, New York City, NY

Responsibilities:

• Role on project as both Project manager and Lead consultant
• Held weekly meeting giving status to Confidential Treasury Director of payments project and listing out next steps and tasks
• Implemented ACH CCD+/Fed Wire payments for all JP Morgan and chase bank accounts
• Implemented ACH CCD+ payments for all PNC bank accounts

Confidential

Project Manager

Responsibilities:

• Held a managers meeting call every three weeks with the Treasurer to ensure Confidential was delivering a implementation to suite his needs
• Held weekly status call where I got updates on tasks from connectivity and functional consultant from Confidential and went through project planning and training dates
• Created Microsoft Project Plan to track status and completion dates of tasks such as Bank connectivity, Cash Integration and Core Setup
• Implemented Bank/Cash Modules of Confidential where client would be able to successfully view and position bank accounts from over 30 countries to understand country funding requirements

Confidential

Lead Consultant

Responsibilities:

• Gathered Treasury Accounting file requirement from client
• Configured GL Export file export to Oracle E - Business Suite
• Trained Treasury/Accounting users how to configure Kryiba’ GL Posting Module to create two line and multi-line accounting entries
• Gathered requirement on POS Pay file import
• Configured Confidential ’s Cash Module to import POS Pay file to create an un-cleared and cleared check report
• Trained Assistant Treasurer how to view cleared and un-cleared check reports

Confidential

Project Manager and Lead Consultant

Responsibilities:

• Held weekly status reporting the status of the project to QBE Inurance team members and discussed next steps to Go-Live of Payments/Cash/GL Posting/POS Pay
• Implemented Book MT202/Fedwire payments with JP Morgan and Chase
• Trained AP staff how to load the POS Pay file into Confidential and produce cleared and un-cleared check report
• Resolved issue of duplicate accounting entries by configuring the GL Export system to Mark entries and posted and notified Accounting staff of resolution and steps to get to that resolution

Confidential, Wilmington, DE

Functional Lead for PeopleSoft

Responsibilities:

• Conversed and scoped business requirements with Assistant Controller/Lead Accountant and other finance team members
• Implemented Cash Management with Funds Transfer templates setup for Book and Fedwire and ensured accounting entries were produced every time a funds transfer was issued
• Trained Treasury team how to issue funds transfers from PeopleSoft Cash Management and showed accountants how to review Treasury accounting entries before Posting to the GL
• Got Bank Reconciliation tested and confirmed in under 2 months, QA tested, UAT tested and going live on 06/01/2013
• Ensured Citizen’s Bank BAI2 Prior Day File could be loaded into PeopleSoft without issue and that the Balance/Transactions showed up properly in the Bank Statements page
• Created a custom Automatic Recon rule to force the reference ID coming from the bank statement for checks to have the same number of padded zeros as the AP Disbursement check
• Created a custom Automatic Recon rule to take wires initiated from PeopleSoft AP and force them to match with the BAI2 Prior Day Bank Statement wires that did not come back with a reference ID
• Gathered Cash Management requirement from Confidential Treasury Director and created Requirement/Design/Functional Specifications document for Settlements Workflow/Custom Bank Transfer Checkbox/Settlements Query
• Showed Treasury team how to set up Bank/EFT Transfer templates, Approve Settlements, Dispatch settlements via Financial Gateway, run Automated Accounting, adjust Treasury Accounting Entries and finally how to Post to GL
• Provided a PowerPoint Presentation solution to Assistant Controller presenting solution to ‘Re-routed PO Approval’ issue where it was accepted and implemented into Production
• Identified features flagged as customizations that could be accomplished with delivered functionality like using Approval FrameWork NEM to send out escalation emails instead of creating a custom job to do so
• Led a majority of the requirements meetings for the 75 enhancements tied to the ‘PeopleSoft 2.5 Enhancements Project’
• Worked with developers on understanding each enhancement and how to develop it
• Created Requirements Documents for enhancement coming out of PeopleSoft 2.5 Enhancements Project’
• Created Design Documents for enhancement coming out of PeopleSoft 2.5 Enhancements Project’
• Created Functional Specifications Documents for enhancement coming out of PeopleSoft 2.5 Enhancements Project’
• Facilitated Penny Test payment to a counterparty by using EDI 820 for North American Wires (BOFA) and SEPA CT03 for European payments to counterpartys (Royal Bank of Scotland or RBS)
• Tested in the new 9.1 Global Environment the North American Acknowledgement files which were EDI 997 for Bank Receipt and 824 for Bank Processed which were produced from live Penny Test payments and worked with Confidential technical team to fix any issues with the file loads
• Tested in new 9.1 Global Environment European Acknowledgement files which were EDI CNTRL for Bank Receipt and BANSTA for Bank Processed which were produced from live Penny Test payments and worked with Confidential technical team to fix any issues with the file loads
• Assisted Confidential Treasury Lead (Non-PeopleSoft Expert but Treasury Industry Expert) in facilitating weekly calls with Royal Bank of Scotland to implement Single Euro Payments Area (SEPA) file layout in the new 9.1 Global Environment where in 8.9 the Europe Treasury team uses PAYMUL file format for payments
• Facilitated Travelex ACH testing which was a customized process where the AP Department creates ACH Vouchers which would turn into a payment file and was sent to Travelex via Integration Broker then the North American Treasury team uses a Cash Position Tree to see how much funding is needed for the ACH Vouchers and produces Fed Wires from the Cash Sweep process driven off of the Travelex Cash Position Tree to fund those ACH payments (North America Treasury team does not produce ACH payments directly from PeopleSoft only through Travelex)
• Spawned the idea of how to customize the PeopleSoft Delivered Cash Sweep process for Travelex where we needed the sweep results to make the recommended EFT concentration transfers that would be overdrawing the sub-accounts Target Balance at times, basically to not take the External Bank Accounts Target Balance into account when processing a Cash Sweep for the Travelex Cash Position
• Confirmed that North America’s and Europe’s Cash Position Trees where working properly by loading Bank Statements (for beginning balances ) and having AP (for test disbursements) create payments then ensured that each position node that represented a Bank Accounts Position showed the expected the Balance amount after the proper Opening Balance/Receipts/Disbursements/Manual Adjustments were taken into account and worked with the Confidential Technical team when the tree nodes were not showing the right values
• Tested and ensured the delivered PeopleSoft Bank Statement Reconciliation process worked properly by loading European and North America Bank Statements then running Auto-Recon to automatically reconcile system side transactions that matched Reference ID/Date/Amount and then confirmed that I could use Semi-Manual Reconciliation to manually reconcile system side transactions that were missed by Auto-Recon
• Confirmed that the delivered Bank Statement Accounting process worked by running that program against a bank statement that had ‘NTF’ transactions un-reconciled where there were Statement Activity Types configured to auto-match and produce External Transactions which would in turn become Treasury Accounting Entries
• Assisted Treasury Lead in facilitating Europe/North America Treasury UAT testing by first running all the UAT test scripts in the UAT environment ensuring that they all were written correctly and requested the script writers to make adjustments if a script was written incorrectly and then helped the UAT testers run through the scripts during the UAT testing

Confidential, Newport Beach CA

Assisting Treasury Analyst .Assisting AP Analyst, Functional Unit Tester, Security Analyst

Responsibilities:

• Tested and ensured that the delivered Treasury Bank Statement Load process worked as delivered for Confidential BAI2 formatted statements and worked with the Confidential technical team to fix any format issues
• Confirmed that the delivered PeopleSoft Treasury Auto/Semi-Manual/Bank Statement Accounting recon process operated properly and worked with the Confidential Technical team to adjust the Auto-Recon rules to suit Pacifica Life’s reconciliation needs (reconciliation by addenda) as needed
• Created Functional Specification documents for Treasury such as a request for a program to load Bank Fee Codes and a request for Bank Settlement Instructions customized forms
• Configured Financial Gateway in the test environment and ensured that all the set up was correct working with the Treasury Lead, which included ensuring the Bank Integration Layouts were setup as designed and pointing to the right Integration Broker Bank Node
• Tested and confirmed from Financial Gateway that Payment Files were in the correct format to go the Bank once the Settlements were dispatched from PeopleSoft
• Assisted Treasury Lead in configuring the Cash Sweep Structure of different Cash Sweeps by setting up the Main Bank Account and all the Sub-Accounts and the Minimum/Maximum Transfer amount of each transfer and if the Sweep Structure was a Concentration/Funding/Bi-Directional sweep
• Configured Cash Position Trees to which would pull from Cash Position Sources to include the Current Day Opening Bank Balances and AP Vouchers that would be paid/disbursed from that Bank Account
• Functionally Unit Tested all the AP/GL/Treasury customizations in the test environment and confirmed that the customizations worked, if there were any discrepancies I worked with the Functional Leads and the Tech Team to resolve the issue
• Created Roles, Permissions Lists, and Users through PeopleSoft Security for the Model Office Demo of AP/GL/Treasury to the Pacific Life Executive Staff
• Presented GL/AP a fully configurable Approval Framework workflow demo to the business showing the functionality of sequential approval, parallel approval, and catered notifications to get a gauge of what the Approval of AP/GL workflow can look like
• Led Design sessions for the AP workflow deciding to go with a monetary tiered cost center approval and parallel approval for exception accounts along with a last approval by Corporate Treasury before paying the Vouchers
• Led Design sessions for the GL workflow deciding to go with a 3 level approach to approval first going to a reviewer for peer review then the supervisor and lastly to an out of close approver if the journal was submitted outside the designated close date
• Delivered Functional Design specification for GL Workflow detailing all the process flows for the workflow and also showing escalation and delegation procedures
• Delivered Functional Design specification for AP Workflow detailing all the process flows for the workflow including cost center approval and exceptions and also showing escalation and delegation procedures
• Worked with client to get the full invoice scanning requirement and helped lead a requirements acceptance meeting detailing all the requirements of what types of documents need to be scanned and sorted for invoices, then confirming the clients approval of the requirements
• Worked with Open Text sales team to decide which Open Text scanning products Pacific Life would need to fulfill their invoice scanning requirement
• Created all the functional specification documents for AP including Check Digit Calculation and Greying of payment option fields

Confidential, Philadelphia, PA

PeopleSoft 9.1 HR MSS Senior Approval Framework Workflow Developer

Responsibilities:

• Assisted in functional requirements gathering of the custom Employee Change Request page development and Workflow customization
• Developed a PeopleSoft Component with multiple pages where the first page had only radio buttons which let you select what kind of Employee Change Request the transaction was (Salary Change, Department Change, Location change etc.)
• Created a second page after the radio button page that displayed dynamically what fields would be used in the Employee Change request like “From and To Department” and “From and To Location”
• Built a custom Approval Framework Workflow for the custom Employee Change component where you could functionally configure the Approval Hierarchy of the Employee Change Request

Confidential

PeopleSoft 9.1 HR MSS Senior Approval Framework Workflow Developer

Responsibilities:

• Created from scratch a custom Approval Framework Workflow for the Confidential ’s own Bolt-On Change Form Transaction (Change Form groups together transactions like Salary Change, Position Change, Status Change and others into one )
• Developed a brand new Application Package consisting of PeopleCode to handle the Change Form Workflow Events such as OnHeaderApproval, OnStepApproval. OnHeaderDeny and other Workflow events
• Configured a Transaction Registry within the Approval Framework for the Change Form transaction so that the PeopleSoft HR system will enable users to configure the Workflow Hierarchy completely through functional configuration online versus through technical Application Designer
• Set up the Transaction Configuration within the Approval Framework to cater specific email notifications for workflow events like Route for approval, Final Approval and Final Denial
• Engineered through online configuration a nine level a Change Form approval hierarchy via the Approval Process setup page that displayed through the Approval Framework GUI whether the Change Form was submitted by the HR Admin, Delegate Initiator, or Employee Manager and triggered one to many levels of conditional approvals based on relevant transaction information pertaining to the employee in question
• Led a solution meeting to address the issue of Worklist sorting where approvers don’t have enough context information about transactions to sort their Worklist and decide which transaction to work on first
• Programmatically produced a workable solution to the Worklist sorting issue and demoed it to the business by saving the employee last name and the effective date of the transaction to the unused comments field of the delivered Worklist page where the client accepted and praised the solution
• Assisted and mentored Hospital for Children’s in-house Developers on best practice of developing custom Approval Framework Workflows showing them how to get ad-hoc approval working through code, ways to resolve normal bugs and how to juxtapose technical development and online configuration to produce a coherent workflow solution

Confidential, Newport Beach, CA

PeopleSoft 9.1 HR Core, HR Benefits, HR Payroll Func/Tech Workflow Analyst

Responsibilities:

• Performed a PeopleCode Trace on ESS Address Salary Change Workflow and figured out that there was a conditional coding for notifying or not notifying the Admin but the Employee would always be notified
• Modified in Application Designer the Approval Ruleset for Ad-Hoc Salary Change workflow and the accompanying PeopleCode to have a SVP and Division Head Level of Approval instead of just the Delivered Manager’s Manager/Admin levels and demoed it to the client as a solution
• Created SQL statements for MSS Transfer/Promote Workflow using the TRANSFER DAT and PROMOTE DAT tables tying them each to the POSITION table to get the Officer Status and Band of each employee being transferred/promoted which drives conditional approvals
• Performed Knowledge Transfer every week to my Pacific Life Counter Parts who were the Workflow Developer and the Workflow Lead, covering strict PeopleCode workflow in App Designer using TRIGGERBUSINESSEVENT, shared workflow PeopleCode Virtual Approver/Virtual Router, and Approval Framework concepts
• Presented the different technologies of PeopleSoft Workflow to the HR client in a 2 hour presentation covering: Strict PeopleCode, Virtual Approver, and the Approval Frame Work (AWE)
• Created a GAP presentation for MSS Ad-Hoc Salary, Transfer, and Promote Workflow listing all the GAPS identified, offering different solutions to each GAP, giving our Confidential Recommendation and then letting the client choose theirs
• Created a GAP a presentation for TL Timesheet Workflow listing all the GAPS identified, offering different solutions to each GAP, giving our Confidential Recommendation and then letting the client choose theirs
• Created a GAP a presentation for Benefits Workflow listing all the GAPS identified, offering different solutions to each GAP, giving our Confidential Recommendation and then letting the client choose theirs
• Designed Solution Workbook for MSS Ad-Hoc Salary Workflow explaining with diagrams and prose how the process would function in Future State PeopleSoft including the explanation of what PeopleSoft has delivered versus our Final PeopleSoft Design
• Designed Solution Workbook for MSS Transfer/Promote Workflow explaining with diagrams and prose how the process would function in Future State PeopleSoft including the explanation of what PeopleSoft has delivered versus our Final PeopleSoft Design
• Designed Solution Workbook for TL Timesheet Workflow explaining with diagrams and prose how the process would function in Future State PeopleSoft including the explanation of what PeopleSoft has delivered versus our Final PeopleSoft Design
• Designed Solution Workbook for Benefits (completely custom notifications and approvals) Workflow explaining with diagrams and prose how the process would function in Future State PeopleSoft including the explanation of what PeopleSoft has delivered versus our Final PeopleSoft Design
• Coordinated with the HR Functional Leads the best approach to overlay customized workflow on top of their transactions to best design the HR Workflow Processes

Confidential, New York, NY

PeopleSoft Application Manager/Tech Lead

Responsibilities:

• Tech Designed, Peer Reviewed and refined the Technical Designs of RICE items if needed
• Served as a Key Member of the leadership team for the Global project
• Tech Designed and Developed 8.9 GL Journal Workflow for the UK implementation by taking the delivered PeopleSoft Approval Rule Set f or Journal workflow and making only 1 level of approval required instead of 2
• Developed an Application Engine Program using a file layout to Load GL Journal Approvers by receiving a CSV file from the Business of GL Approvers to Load
• Led the GL Journal Workflow meetings to gain insight of what PeopleSoft could deliver in out the box with the Confidential functional team
• Tech Designed and Peer Reviewed a customization to change the current AP EDI File layout to include two new field that the Business wants to be populated on AP Vouchers that weren’t populated on the previous EDI file by instructing the developers what PeopleSoft objects to change and how to change them
• Created a custom Application Engine to load the LEDGER ADB table from a CSV flat file including Edits and Validations
• For Production created an Application Engine program that would Archive Travel & Expense approval data and move that data to Archive tables to help the performance on loading Travel & Expense approval pages
• Wrote a GL Query Report that retrieves Journal Data and changes the Accounting Period and Fiscal Year to India’s so that the India users could evaluate the Journal detail data in their Fiscal Year and Accounting Period
• Tech Designed and Developed PO Amount Workflow Approval for 3 Business having 1 level of approval being the PO Manager having the Purchase Order pre-approved if it was underneath a certain threshold amount set by the Business
• Wrote a Technical Design to have the OPRID selection on the User Profile component workflow tab ‘Alternate User ID:’ field to only show prompt values of users that were approvers and list the modules that they were approvers for and also assisted in Unit Testing and Bug Fixes of issues related to this task

Confidential, Aiken, SC

PeopleSoft Senior Technical/Workflow Developer

Responsibilities:

• Wrote an Application Engine interface program to take Peoplesoft General Ledger 9.1 Posted Journals to the Ledger and massage the data with a mapping table to be able to push down to the Mainframe Ledger tables so that a mainframe program can take and send those entries to the Confidential Headquarters in the DOE Headquarters format from the SRS format
• Met weekly with my SRS DOE technical counterpart that would be taking over my finished development when I leave, I would train that person in Peoplesoft development relating to the GL custom and delivered processes and got the person to the point where he was doing development on his own
• Held 2 hour Presentation of 9.1 GL Approval Framework workflow to the GL department informing them of its benefits receiving good praise on presentation delivery
• Built 2 Level 9.1 GL Approval Framework workflow that first went to the department’s manager and then to Accounting for final approval and configured paths to handle 7 types of Journals by Journal Source
• Wrote an Application Engine interface program to pull mainframe data from an external Asset Management system then massage the data to populate a custom Peoplesoft Accounting Entry Table so that delivered Journal Generator would pick up the entries to finally be put in the Peoplesoft General Ledger
• Coded SavePostChange Peoplecode to populate a shared Mainframe GL conrol data table from Peoplesoft so that existing mainframe programs that read the previous GL systems prior to Peoplesoft would not have to be rewritten to read from Peoplesoft in the first phase of the implementation
• Held FIT/GAP sessions with Confidential GL functional staff and management to get the requirements of the new GL Approval Framework Workflow
• Created functional and technical specification documents for the GL Journal Approval Framework workflow where I functioned as both the functional and technical resource which was approved by the GL department

Confidential, Chester County, PA

PeopleSoft Technical Lead/Workflow Developer

Responsibilities:

• Created a 3 Level workflow using Approval Rulesets for a custom EPM 9.0 Managing for Results module that required Department Heads, Performance Managers, and Executive Boards to approve before the Strategic Business Plan was approved
• Ensured with PeopleCode for EPM Strategic Business Plan workflow that if the Department Head was supposed to approve before any later approvers the later approvers can only see the transaction and not approve until it’s their turn
• Created a notification workflow for custom EPM Activity Data Collection page to send a worklist to the Activity Manager by using TriggerBusinessEvent Peoplecode once a Collector modified data and also a notification was sent to the Collector if the Activity Manager denied or approver the data collection
• Created a PeopleSoft Notifications and Escalations Manager job to escalate a Requisition if it was not approved in 4 hours to an escalation Manager
• Set up the Verity Search Engine as the main search engine for the eProcurement catalog search
• Demoed eProcurement 9.0 Requisition Workflow to Chester County to show the advantages of implementing eProcurement instead of using Core Purchasing for Requisitions
• Played key role in helping Chester County decide to go with eProcurement Requisitioning instead of Core Purchasing Requisitioning by offering guidance as a subject matter expert on eProcurement AWE workflow
• Developed a custom PeopleSoft Workflow Routing Page that configures Department Backup, Fiscal, Fiscal Backup, and Parent Department Approvers that the AWE Workflow SQL Userlist will use for Routing Workflow and Escalations
• Developed custom AWE eProcurement 8.9 Requisition Workflow with 3 levels (Activity, Department, Fiscal) having routing controlled by SQL on the UserList driven off a custom page being able to handle multiple distribution lines on one Requisition line Routing correctly to each different Department Approver on each distribution line
• Created PeopleSoft Escalation Procedures to route eProcurement Requisition workflow to a Backup Approver if the original designated approver did not act upon the Requisition within 4 hours determining who to route to by a Custom UserList SQL driven off a custom page
• Created a customization to force Requestors to finish Budget Checking before submitting an eProcurement Requisition to workflow
• Coded a custom Fix to delivered PeopleSoft AWE Escalation Bug of a line level approval not returning line level SQL bind variables to the Escalation SQL Userlist by modifying the delivered Application Package Peoplecode for AWE Workflow Escalation
• Configured new Custom PeopleSoft Security Permission lists for eProcurement Requesters and Approvers so that they only have access to Pages related to Creating and Approving eProcurement Requstions
• Wrote detailed test scripts for UAT/System testers testing eProcurement having step by step instructions to create, approve, and deny eProcurement Requisitions ensuring eProcurement works as designed
• Created PeopleSoft RICE Technical Specifications documenting the technical objects used to create the eProcurement AWE Workflow and also showed Reimplementation Procedures
• Created Knowledge Transfer documentation to transition knowledge of creating and configuring the custom Chester County eProcurement AWE Requisition Workflow from BTRG to the Chester County IT team

Confidential, Philadelphia, PA

PeopleSoft Financial Technical Consultant and Sole Owner

Responsibilities:

• Actively sought PeopleSoft Financial Technical Contracts on the market on a Confidential - Confidential basis
• Learning XML Publisher from Peoplebooks for PeopleTools 8.49 figuring out how to create a data source from a PS Query or Peoplecode then creating a Schema to map to and finally creating a Report Definition which could be an RTF, PDF, E-Text, or XLS
• Self taught myself Web Services which is just an addition to Integration Broker where I configured from Scratch to talk to PeopleSoft HR 8.8 and uses SOA architecture delivering Services on the backend with the help of Component Interfaces so that other ERP Systems such as SAP or Siebel can tap into and use for communication between the two Systems

Confidential, Philadelphia, PA

Systems Consultant specializing in Peoplesoft Development

Responsibilities:

• Working on Knowledge Transfer at current client to transition work from Confidential contractors to Confidential contractors due to Confidential taking over Application Development of the company
• Video recording SME sessions and uploading videos to RTS site so that offshore resources can watch the video’s and come up to speed on the client’s requirement
• Trained offshore resources on SQR development of clients custom and delivered PeopleSoft programs
• Used Windows Media Encoder to record video of the clients Peoplesoft Application Designer objects such as Peoplecode, Application Engine, Records, and other PeopleSoft Objects to know more about the clients development environment
• Took over development of PeopleSoft General Ledger, Account Payables, Travel & Expense, and Asset Management customizations at Client site until Offshore Technical Resources got up to speed on clients development environment

Confidential, Philadelphia, PA

Lead Systems Developer PeopleSoft Financials

Responsibilities:

• Wrote an Application Engine using Component Interface PeopleCode to pull voucher data from an Excel spreadsheet an create a Journal/Disbursement/Asset voucher in AP
• Wrote SQL to query and modify data working with Oracle 9i database tables
• Developed custom Pages, Crystal Reports, and Records to support completely custom Account Recon GL addition of the Account Detail Form
• Ran a training Class to teach Peoplesoft Query and Query Manager to user’s that were new to Peoplesoft
• Created whole new Internal Reinsurance General Ledger SQR module to create accounting entries for Pooling for ATR using page percentages to control how to create Federal Excise Taxes and Commission Override
• Facilitated Shared Pooled meeting, created Agenda and got information from each team member that was involved in getting the Shared Pooled memory better utilized
• For implementations of Asia Pac Countries to 8.0 Peoplesoft I handled all the Report creation, Page customization, and led AM Conversion
• Developed a new custom check writing program FT711CHK.SQR that called custom SQR payment file program from the Paycycle step rather than a Crystal Check due to the requirement of Asia Pac where a custom check file layout was needed versus a Crystal Check
• Created from scratch an AP Payment file for EFT using @’s as the separator supporting Asia Pac implementation by creating brand a new SQR payment file program
• Monitored ESSBASE Cubes every morning to ensure they were built on time and if they were still processing I told the appropriate staff about it and continued monitoring it till completion
• Created Automated tests scripts using QTP tool to load configurations such as EX employee’s being populated by an excel file saving functional staff hours by not having to have them configure by hand individually
• Got Delivered Journal/Voucher Approval Rulesets Workflow up and running in test environment and held a 2 hour lunch and learn to demo the product
• Monitored specific Server drives to be sure they had more than 10% free memory and if they didn’t I notified the appropriate staff