SUMMARY:

• Over 7+ years of experience as a Business analyst/Consultant in Treasury operations including banking, cash management and investments.
• experience as a FSCM/ Treasury consultant with lead consulting roles in SAP banking and Treasury projects across USA
• Experience in configuration and support of Cash Management (cash position, liquidity forecast, electronic bank statement, payment processing, account reconciliation, lockbox, and payments) as well as Transaction Manager (FX and Derivative Instruments) 
• Experienced in Bank Communications Management (Batching and Swift Integration). 
• Experience of Treasury management of an enterprise's holdings, with ultimate goal of managing firm's liquidity and mitigating its operational, financial and reputational risk and expertise in multiple modules within SAP Treasury. 
• Expanding responsibilities as a Treasury Service Officer and Manager in a large, metropolitan market.
• Co - lead numerous internal audit engagements (in Broker Dealer Treasury and Liquidity Risk Management) 
• Excellent working knowledge in People Tools (Application Designer, PeopleCode, Data Mover, Application Engine, Process Scheduler, Component Interface, SQR, Crystal Reports, XML Publisher, and PS Query).
• Expertise in developing multiple PeopleSoft FSCM interfaces - both outbound and inbound - with third party systems using SQR, Application Engine, Component Interfaces and File Layout.
• Strong RDBMS skills and hands on experience in Oracle database version 11.2 and SQL Server 2000, DB2 using tools like SQL Navigator, Toad for performing SQL and PL/SQL programming. 
• Excellent functional knowledge and project experience in the areas of PeopleSoft FSCM Core modules AP, AR, BI, PO and GL. 
• Expertise in planning, implementing and support in PeopleSoft Time and Labor Functional and support to payroll processing from pay sheet creation to sending PosPay file.
• Expertise in Providing support for FSCM/Financials 9.1, Portal 9.1 with PeopleTools 8.48.15, 2 Web Logic 9.2 multi-server using Oracle 10g databases on Linux 6.0 on ASM file system. 
• Expertise in providing consulting services to customers on their HCM, Benefits Administration, Absence Management and Time & Labor, and best utilization of product in their environment. 
• Extensive experience in database testing writing SQL commands for complex business criteria to retrieve data from databases (Oracle, SQL Server) used TOAD tool for interface in database testing. 
• Successful as team player to work in conjunction with DBA’s, testers, developers and other team members in validation and testing complex scenarios and projects and in maintenance of Quality Standards in Projects especially with Test Director.
• Extensive experience in Business Analysis with excellent knowledge of SDLC methodologies and processes. Experienced in managing requirements from project inception through release.
• Expertise in Requirement Analysis, preparing Test Plan, Test Strategy, Test Cases, Test Execution and Defect Management.

PROFESSIONAL EXPERIENCE:

Confidential, Dallas,TX

SAP Treasury Consultant

Responsibilities:

• Resolved issues with check printing, Crystal Reports, positive payment and Accounts Payable voucher matching functionality.
• Supported the Client to drive the activities related to Bank's system and SWIFT to ensure seamless integration
• Configured and optimized SAP Treasury solutions (Treasury Management, Cash & Liquidity Management, and bank Communication Management) to improve processing efficiency and reduce errors. 
• Responsible for daily Treasury cash management duties, review bank accounts, positive pay, investment logs and resolve transfer issues. 
• Testing, and support of In-House Cash, A/P and Treasury Automatic Payment Programs, IDOC creation/troubleshooting, Configuration of electronic bank statements, and testing of the IHC end of day process and development and maintenance of supporting detail documentation
• Supervisor responsibilities for financial reports & treasury services for Mutual Funds and ETF Trust entities with assets under management in range of $20B - $30B  
• Reviewed the company's Global bank entities & advice on plan and strategy on consolidation, implementing SAP In-house Cash for centralized payments across foreign entities 
• Calculated daily liquidity forecast, monitored payment transactions for vendors, cash pooling, loan interest/repayment and salaries, intercompany netting reconciliations, reconciliations of bank and clearing accounts, central bank reporting, processing of incoming checks, manual cash pooling, and month-end close activities.
• Worked closely with users and testers during UAT and helped resolve issues by giving detailed explanations of the problems and methods of remediation 
• Conduct meetings to discuss treasury analysis findings with Senior management 
• Gathering requirements and design specifications for data extraction interfaces and conversion from legacy to PeopleSoft applications
• Aligned business processes across international subsidiaries in the corresponding SAP system environments. 
• Tested delivered reports, custom reports and control reports, error reports and reconciliation reports.
• Active member in internal focus groups (Treasury Pitch Book Committee, Sales, Implementation and Service Responsibilities Deployment Group) for process improvement initiatives
• Primary contact for Treasury interactions with other departments, business units and third party administrators 
• Responsible for developing new treasury management business and expanding existing relationships 
• Met with internal training team to review functional changes for their preparation of web-based training for regular employees and managers approving timesheets
• Produced metrics which provide management insight into requirements process, to include, status, size, volatility, quality, effort, Visio, Rational Tools, Traceability Matrixes.

Confidential, Dallas, TX

Treasury Business Analyst

Responsibilities:

• Set up Integration Broker services (such as gateways, nodes, services and service Operations etc.) for automatic updates between FSCM and HCM applications. 
• Identify bank accounts with no visibility and coordinate with Treasury Administration to ensure connectivity via SWIFT 
• Performed bank reconciliations, control of ABS factoring process, intercompany netting, and cash pool interest calculations.
• Presented SAP Financial Supply Chain Management features, demonstrated and designed SAP In-house Cash solution for inter-company (I/C) Loans and bill settlement, including transaction manager for money market operations and portfolio management, Cash Position and Liquidity forecast for cash flow reporting to support a centralized Treasury operation. 
• Worked on the maintenance, support and tuning of the PeopleSoft FSCM for the project.
• Conducted user interviews, gathered requirements, analyzed requirements using RUP methodology and documented requirements using Rational Requisite Pro.
• Designed and configured Transaction Mgr (FX, Money Mkt, Securities and Derivatives), Cash Position/ Liquidity Forecast, AP and Treasury payments, Electronic Bank Statement, Lockbox, and Exchange Rates, Credit Risk Analyzer, Market Risk Analyzer. 
• Designed and blueprinted cash management for Cash position Reporting, Cash Forecast Reporting, Liquidity Planner and Transaction Manager for different borrowing and Investment processes 
• Write and run test scripts for accounts payable, general ledger and travel expenses production support in general ledger, accounts payable, asset management, project cost and expenses.
• Developed budget planning report and timelines of project by conducting walk-through sessions and meetings involving various leads from Development, QA and Technical Support teams
• Participated in Bug-Review meetings with software developers, QA engineers, managers, and suggested enhancements and solution to existing application problem from business perspectives.
• Online and phone support for Treasury Management clients, including delivery of difficult messages to customers by utilizing active listening skills and applying conflict resolution techniques where needed for a successful outcome. 
• Designed different SAP Query reports for account statements and aging reports.
• Configured PeopleSoft Absence Management: Created schedules for part time and full time employees, entitlements and accruals for vacations, absences types (Leave of absence, unjustified, vacations, PTO). Defined rules for each absence type, entry, approval, and absence elements
• Testing test pass- 8.4 to 9.0 and 9.0 to 9.1 Writing test cases using PTF (Peoplesoft Testing Framework) Training users on new features and preparing training documents Working on feature
• Design, and implement paperless employment profile environment for business workforce from applicant status to hired, performance review, to termination.
• PeopleSoft API was used to integrate pages within People HRMS and communication between PeopleSoft and non-PeopleSoft systems.
• Provide training and support for users of Oracle Discoverer Along with Design data conversion programs relating to Oracle Project Contracts and Oracle Work in Process.
• Created Business Requirement Document (BRD), Functional Requirement Specification (FRS) document, User Requirement Specification (URS) and Change Request (CR) document for system application development.
• Conducted joint requirements planning (JRP) sessions as facilitator to gather requirements from business area and to discuss different critical success factors of project like Operational Feasibility Analysis, Technical Feasibility Analysis, Cost Benefit Analysis & etc.
• Authored various Use Cases and Activity diagrams, Sequence diagrams using Rational Requisite Pro and used UML methodology to define Data Flow Diagrams (DFD).
• Performed GAP analysis for modules in production, conducted feasibility study and performed impact analysis for proposed enhancements

Confidential, Atlanta, GA 

Business Analyst

Responsibilities:

• Financial and Supply Chain Management 9.1 GL, AR, AP and PO People Tools 8.52. Customizing some of 9.1 features into 9.2 upgrade  
• Trained employees in Accounts Payable, Fixed Asset, Cash Management, Asset Management, voucher creation by testing various audit setup configuration scenarios. 
• Optimized internal treasury procedures by creating VBAs to increase the operational efficiency and increase productivity
• Led discussions for a global Treasury operation in eliminating foreign currency risks, optimize lending/borrowing process, streamline inter-company loans, sales/purchase transaction settlements, and liquidity forecast in cash planning. 
• Designed and blueprinted cash management for Cash position Reporting, Cash Forecast Reporting, Liquidity Planner and Transaction Manager for different borrowing and Investment processes 
• Prepared Business Object / Business Process Models that included modeling of all the activities of business from conceptual to procedural level and responsible for PeopleSoft architecture and technology on Implementation project for PeopleSoft HCM 9.0
• Responsible for resolving issues with check printing, Crystal Reports, positive payment and Accounts Payable voucher matching functionality.
• Facilitated JAD sessions and design meetings with the Stakeholders, SME’s and Leads of Interfaces.
• Worked on conversion interfaces to move legacy data to new PeopleSoft system.
• Excellent functional knowledge and project experience in the areas of PeopleSoft FSCM Core modules AP, AR, BI, PO and GL. 
• Working on installing PeopleSoft (understand the PeopleSoft Internet Architecture - PIA) and using Change Assistant, running upgrade scripts and debugging when issues occur. 
• Responsible for maintaining the HRIS data current, by updating and auditing all aspects of HR and Workforce Administration.
• Identified opportunities for business process improvement through various meetings with business users and developers and initiated efforts to make improvements. 
• Managed gap analysis & feasibility study, created interfaces between PeopleSoft, Oracle EBS and in-house applications to integrate the systems, schedules, and the entire implementation life cycle. 
• Analyzing configuration of EDI acknowledgement for Purchase Orders in PeopleSoft FSCM.
• Developed several PeopleSoft queries to match receiving with contract and Purchase order. 
• Loading data from external source to PeopleSoft using application engine and SQR, Design/Developed Hyperion feed for PeopleSoft chart fields and Ledger using store procedure and SQR. 
• To lead, facilitate the B2B implementation with client Purchasing ERP System through the HubSpan platform and Agilent SAP Order Management system. 
• Approval Framework AWE configuration for HCM MSS transactions and FSCM transactions like Purchase Order, General Ledger 
• Involved as PeopleSoft Consultant with sophisticated technical skills in the areas of Application Designer, Application Engine, Component Interface, Data Mover, PeopleCode, Application Packages, Integration Broker and WorkFlow developer tools. 
• Gathered product requirements in order to describe the business needs in terms of the main deliverables or products that are created 
• Worked on Legacy Systems Analysis to lead the review and quality control process related to the extraction of business rules from crucial legacy trade entry and processing applications.
• Created customized report using OLAP Tools such as Crystal Report for business used.
• Met with internal training team to review functional changes for their preparation of web-based training for regular employees and managers approving timesheets.
• Produced metrics, which provide management insight into the requirements process, to include, status, size, volatility, quality, effort, etc.- Visio, Rational Tools, Traceability Matrixes

Confidential, Atlanta, GA

Business Analyst

Responsibilities:

• Worked on interfaces automation for P Card and Corp (T&E) card as they are doing manually right from getting files from Scotia Bank folders to NV Energy folders. 
• Set up Integration Broker services (such as gateways, nodes, services and service Operations etc.) for automatic updates between FSCM and HCM applications. 
• Involved in Setting up the Journal generator for AR and Billing Tested the accounting information sent over to GL from AR and Billing. 
• Developed custom interface program to receive Material Service Request (MSR) in Inventory from Third party using integration broker. 
• Developed BI-Interface, which loads data from 3rd party system into PeopleSoft billing interface tables first, and then doing various data validations and then loading into billing main tables BI HDR and BI LINE. 
• Customized the Billing Invoice, added Client Logos and custom fields onto the Invoice report. 
• Wrote technical specifications for SQR's and interfaces in PeopleSoft OM, INV, ePro, AP, PO, Billing modules. 
• Accounting personnel support - troubleshooting included identification of root causes resolution of functional or client issues documentation of support issues and resolutions and working with application and database administrators for resolution. Conducted PeopleSoft query training for finance users. 
• Implemented application customizations based on fit-gap analysis and enhancements for Projects, Grants, Commitment Control Billing, Projects, AR, AP, AM, Travel & Expense, Contracts and GL modules. 
• Used Application Engine to perform background processing against the data 
• Created new reports using SQR, XML Publisher, and modified the existing ones as per the changes specified 
• Created and customized SQR reports as per the requirements and scheduled them using Process Scheduler 
• Worked on extracting Cardholder's data from database using PS Query and sent enrolment forms to Bank. 
• Developed application packages for handlers in integration broker for the purpose of data interchange with third party system. 
• Configured domestic workflow set up using AWE (Approval Workflow Engine) set up the criteria for self-approval, register transactions, user list definitions and e-mail notifications. 
• Worked on ACH payment process failure and suggested some functionality changes in terms of Vendor setup and mode of payment options.