Professional Summary
Senior Business Analyst with 7 years of extensive technical/functional experience analyzing business and technical processes, documenting business requirements, defining changes tobusiness processes and working with the business in modifying them, configuring, testing and implementing enterprise-wide business systems.
Experience includes PeopleSoft Finance modules like GL, Treasury, AP, Purchase Order, eProcurement, Purchasing.
Experience in SQR, Crystal Reports and n vision.
Extensive Functional experience in Configuration and Customization in FI-GL, AR, AP, Bank Accounting, BCM, Treasury, Cash Management and experience.
Experience in managing people and projects in various phases of the Software Development Life Cycle (SDLC), especially object Oriented Software Design and Development.
Authored multiple Business Requirement Documents (BRD), Functional Requirement Documents (FRD), Project Requirement Documents (PRD), Functional Specification Documents (FSD) and Use Cases.
Extensive knowledge of Object Oriented Analysis and UML Design using Rational Rose, MS Visio and created Use Case Diagrams, Activity Diagrams, Swim Lane Diagrams, Sequence Diagrams, Process Flow Diagrams, Data Flow Diagrams, Wireframe Diagrams, and Entity Relationship Diagrams.
Experience in People Tools like People Code, Application Designer, Application Engine, Component Interface, PS Security, Process Scheduler, PS/Query, Data Mover, Import Manager, Integration Broker, Process Monitor, Application Package, Workflow and Utilities (SQL Trace and People Code trace).
Strong Techno-Functional experience in PeopleSoft Financials 9.2, 9.1/9.0/8.9, 8.8, 8.4, 8.3, 8.0, 7.5, 7.0 and Experience in analysis, design, and development and testing of various Peoplesoft modules such as GL, Order to Cash process, Purchase Order.
Experience in Upgrades and new Implementations, Conversions, Migrations, Interfaces and Reporting.
Trained State employees in Accounts Payable, Fixed Asset, Cash Management, Job Cost, Procure-to-Pay, Absence Management, voucher creation by testing various audit setup configuration scenarios.
Resolved functional issues.
Multi-currency, multi-book, VAT, international Business Units, international regulatory reporting for correct system configuration.
Prototype demonstration of the Travel and Expense delivered via live meeting to key stake holders and various team and groups, take their feedback on any additional/cosmetic changes required to the Product.
Experience Installation, administration and upgrades of PeopleSoft environments on an Oracle/Solaris, PeopleSoft application architecture including the table structure, delivered objects, design standards, protocols and Involved in various PeopleSoft Applications Upgradation using Upgrade/Change Assistant.
TECHNICAL SKILLS
Operating Systems
Windows and Unix
Languages
C/C++, HTML, DHTML, VB script, Java, XML, SQL, .NET Platform
Tools
Rational Rose, Rational Requisite Pro, Caliber RM, MS SharePoint, Rally
ERP
PeopleSoft FSCM, Supply Chain and HRMS/HCM
Financial
GL, AP, AR, IN, OM, Billing, Travel and Expense, Budget, Asset, Project, Purchasing, eProcurement and Contracts
HRMS
HR, Candidate Gateway, Talent Acquisition Management, eBenefits, eCompensation, ePay, ePerformance, eProfile, eProfile Manager, Payroll, Ben administration and Time and Labor
People Tools
People Code, Application Messaging, Application Package, Application Class, Application Engine, AWE, Workflow, Component Interface, F5 Load balancer, File Layout, EDI Manager, Security, Process Scheduler, Portal, Tree Manager, and Data Mover
Reports
SQL/SQR, nVision, Crystal, BI Publisher (XML publisher) and PS/Query
Database
MS SQL Server, MS Access, Oracle
Testing Software
HP Quality Center and HP LM
Software Packages
MS Office – Word, Excel, PowerPoint, Outlook, Visio, Project, Access, Lotus Notes
Professional Experience
CB Richard Ellis February 2016 – January 2017
Memphis, TN
PeopleSoft Business Analyst
Served as PeopleSoft Finance and SCM 9.2 business analyst and drafted functional design documents for documenting change request specifications and proposed resolution.
Gathered Business Requirements, interacted with the stakeholders, developers, Project Manager and SME's and facilitated JAD sessions to formulate Business Processes.
Coordinated with Accounting Transition team and new clients to define parameters for BRD and FDDs
Designed functional and technical specifications and development of reporting for new clients
Responsible for GL configuration for onboarding new clients to Intrepid platform/PeopleSoft Financials 9.2
Developing queries to meet Account Manager’s reporting requirements
Ran Funding Request test for several existing and new clients to make sure the desired outcome is as defined in the BRDs and Functional documents
Tested the GL transmission reports along with the Accounting Transition team so that can submit GL transmission details from Intrepid/PeopleSoft to client’s SAP system
Developed and automated Data Templates that can be used as standard templates for client data exchange between Accounts and Intrepid team
Worked on multi-currency, multi-book, international Business Units, Trees, reporting.
Worked on General Ledger and Involved on data and application integration components into an end-end interface solution and Requirements gathering for new Enhancements, Design and Unit Testing and Preparing Technical Design documents for enhancements in different modules
Designed training documents for Accounting transition team. Trained Accounts manager on building Queries to meet their reporting requirements
Resolved Service Desk requests to resolve issues with PeopleSoft
Investigated issues related to incorrect reporting. Devised method to update the Building Attributes such that Facility Managers at site have better information while dealing with the troubleshooting issues
Participated in project to correct all redundant and inaccurate existing Business Unit data at Property Asset level
Designed the database for effective retrieval and data storage
Mapped data conversion, formatting
Adhered to policies and procedures by developing SOP's, facilitating data standards, writing functional and technical specs.
Assisted the development team with design and development of the application, provided usability metrics collected from user surveys
Designed the User Interface prototype for the customer information system based on the Business and Functional Requirements.
Facilitated Business process models and use case diagrams.
Extensive database experience using Relational Database Management Systems (RDBMS) Oracle,PeopleSoft, MS Access and SQL with solid understanding of primary, foreign key constraints, strong and weak entities and attributes.
Northern Trust Corporation, November2012 – January 2016
Chicago, IL
PeopleSoft Business Analyst
Worked on Techno-functional areas with AP, GL, epro, Purchasing order modules and Performed detail and impact analysis of the requirements.
Wrote SQR reports to fetch expense reports based on epro, Purchasing order, AP and different customizations according to the users requirements.
Solely responsible for all the tax updates, patches for the FINANCIAL system.
Supervised, trained and worked as a subject expert on various treasury-related topics to treasury and accounting staff, reviewed/evaluated treasury cash movements functions.
Assigned general ledger coding to support all Cash entries in Treasury Services.
Developed interactive report for all the purchase orders per vendor with corresponding material and vendor details etc.
Utilized HP Quality Center for traceability of project requirements against test case creation(Test Plan) to test case execution(Test Lab).
Createdsql scripts to validate and compare data between 9.0 and new 9.2 environments.
Analyzed and Prepared financial statements and reports (income and inventory statements, balance sheets and statements of financial position/ overall objective business financial analysis.
Experienced in understanding business rules, technical specifications and effectively implementing them into a Business process flow, thus transforming user requirements into business requirements.
Expertise in using main components of HP Quality Center (QC) - Management, Requirements, Test Plan, Test Lab and Defects.
Developed Use Cases and Use Case Scenarios and visualized those using UML diagrams in MS Visio.
Proficient in PeopleSoft FSCM 8.9-9.2(General Ledger, Project Costing, Billing, Receivables), PeopleTools 8.52, PeopleTools 8.4X, Application Designer, PeopleCode, Application Engine, Workflow Technology, Component Interface, Data Mover, Structured Query Reporting (SQR), oracle 9i/10g etc.
Serve as alternate for Treasury Analyst II during extended absence.
Developed interactive report for all the purchase orders per vendor with corresponding material and vendor details etc.
Provided support for FSCM/Financials 9.1, Portal 9.1 with PeopleTools 8.48.15, 2 WebLogic 9.2 multi-server using Oracle 10g databases on Linux 6.0 on ASM file system.
Reviewed, designed Allocation processing for VAT, SUT, as well as payroll taxes for period close for national, international use.
Designed international intercompany transaction processing, multi-currency, multi-book.
Experienced with MS Visio and Rational Rose for business process modeling, business process automation and writing business requirements documents, such as use cases, project definitions and requirements, test cases.
Designed, built, and maintained Business Objects universes.
Expertised in applying Oracle database security updates as per business requirement.
Exposed to OBIEE environments using Oracle 11g databases on Linux 6.1 64 bit servers.
Installed and configured PeopleSoft EPM delivered maps with developers.
New Jersey Dept of Banking and Insurance, NJ August2011 – October 2012
Business Analyst
Responsible for Analyzing defects or enhancements and assigning tasks to team members at offshore.
Analyzed the Business Requirement Document and converting into Functional Specific Document and Technical Requirement document.
Interacted with Business Owners and IT, Identifying gaps in requirement and get clarification.
Documented cross functional system requirement.
Worked on Core AP, eProcurement, Purchasing order, General Ledger modules and Monitoring of the inbound/outbound processes to and from the system.
Provided and supported cash posting information as liaison between Treasury and business units.
Worked on PeopleSoft Financials upgrade support and Provide Production support.
Provided systems support in Treasury- access to systems, setup, evaluations, and upgrading software.
Short term contract as a Business Analyst role on 9.2 PeopleSoft Upgrade for HR/CRM team to get the team up to speed and make the tight deadline
Worked on PeopleSoft AP/epro with Credit Card Functionality include E-Bill and Fixing Defects for Core AP, eProcurement,Purchasing order, Account Receivables, General Ledger.
Successfully completed/restored all FTP FSCM 9.1/PT 8.50.07 implementation in Demo, Development, Test, QA and production environments using Oracle 11g databases.
Researched the release notes for FSCM8.8/8.9/9.0/9.1 to identify the changes and enhancements done in AP, PO, e-Procurement, AR and Billing modules.
Provided support for FSCM/Financials 9.1, Portal 9.1 with PeopleTools 8.48.15, 2 WebLogic 9.2 multi-server using Oracle 10g databases on Linux 6.0 on ASM file system.
Designed interfaces, VAT, multi-currency, multi-book, international Business Units, Trees, reporting. Architected MDM (Master Data Management) for Customer, Inventory Items, automated Sales Orders, Invoices, AR aging, for 20+ external interfaced systems.
Worked on Account Payable (AP), eProcurement, Purchasing order, General Ledger and Involved on data and application integration components into an end-end interface solution and Requirements gathering for new Enhancements, Design and Unit Testing and Preparing Technical Design documents for enhancements in different modules.
Actively participated in running the On Demand Event Maintenance Process.
Facilitated JAD sessions and design meetings with the Stakeholders, SME’s and Leads of Interfaces.
Added much efficiency to the delivered upgrade scripts and steps.
These conversions involved multiple software applications (General Ledger, Accounts Payable, Accounts Receivable, Purchasing, Inventory, and Fixed Assets) across many databases.
Managed changes to requirements through change control -clear case, MQC, Documentum.
Gathered requirements to upgrade the Time and Attendance system from a client server to a web-based application with three methods of time entry; Time Clocks, Web and Teletime IVR.
Customized Accounts Payable (A/P) pay-cycle process to create a lights out pay-cycle.
Modifications required the integration of PeopleSoft Accounts Payable with Control-M scheduler.
Resolved issues with check printing, Crystal Reports, positive payment and Accounts Payable voucher matching functionality.
Designed new Business Intelligence (BI) system using Oracle Discoverer 10g to provide reporting under Oracle Applications.
Prepared Business Object/Business Process Models that included modeling of all the activities of business from conceptual to procedural level.
Gathered requirements to build an interface that loads employee demographic and Peoplesoft specific data directly from the HR system.
Employee data appears in the Workforce Timekeeper application within 20 minutes.
Produced metrics which provide management insight into the requirements process, to include, status, size, volatility, quality, effort, etc.- Visio, Rational Tools, Traceability Matrixes.
Performed after Action/Post Milestone Reviews and quality reviews to ensure that developed software products met the business needs and are in compliance with RUP and CMMi 3.
CGFNS, Philadelphia, PA February2009 – June2011
Business Analyst
Implemented application customizations based on fit-gap analysis and enhancements for Projects, Grants, Commitment Control Billing, Projects, AR, AP, AM, Travel and Expense, Contracts and GL modules.
Converted Business Requirements to the Functional Specifications.
Gap analysis of processes within the organization for implementation on Rational Unified Process (RUP).
Analyzed and resolved complex and challenging SAP HCM payroll related issues effecting employee's pay.
Developed Process Model, detailed workflow diagrams and prepared the Business Workflow using MS-Visio.
Planned and conducted JAD sessions and finalized Business Requirements and prepared Functional Specifications.
Involved in the preparation of test data.
Identified test requirement and check if the test cases are complete to test the business functionality.
Reviewed the Scripts and suggest modification in the scripts.
Executed the scripts and reporting the bugs.
Communicated with business users to gather requirements, prepared and updated BusinessRequirements Document (BRD) and Functional Required Document (FRD).
Negotiated customer priorities and workload with many internal customers and team members.
Identified opportunities to use data to improve business performance.
Provided support, training and guidance for all of FSCM.
Prototype demonstration of the Travel and Expense delivered via live meeting to key stake holders and various team and groups, take their feedback on any additional/cosmetic changes required to the Product.
Multi-currency, multi-book, VAT, international Business Units, subsidiary budgets (child budgets), international regulatory reporting were all reviewed and audited for correct system configuration.
Handled taxation matters, statutory compliances like VAT, etc.
Completed review of Purchasing/Accounts Payable process, Travel Expense reconciliation and Inter-agency reconciliation.
Responsible for fitting Business Objects into the Information Architecture of the company as well as creating users and privileges with supervisor and developing and maintaining Universes.
Requirement gathering.
Conducted Delta review sessions.
Conducted Fit gap sessions.
Conducted sessions with end users on new features.
Wrote functional specification documents for external interfaces to GL Functional, integration and UAT testing.
Responsible for PeopleSoft security administration for HCM and FSCM environments.