SUMMARY

• 11+ years of consistent experience as Sr. PeopleSoft Business Analyst in the following areas: ability to elicit, analyzes, gather, document and manage business requirements.
• Business Analyst with 10+ years of extensive and diversified experience in the financial industry. Expertise in feasibility requirements analysis, design, construction, BPMN, testing, implementation, and UML methodology.
• Experience in proven success in identifying process risks, control gaps, and deficiencies.
• Expertise in data analytics tools, control sampling, and testing to reduce risk and achieve company goals.
• Experience in PeopleSoft Financials (Order Management, Material Management, Cash Management / Treasury Accounting Accounts Payable, Asset Management, Receivable/Billing, E - Pro, EXP & PC) Purchasing, (Procure to Pay) Account Payable, Expenses and Project Costing.
• Experience with Identity and Access Management (IAM) to initiate, capture, record and manage user identities and their related access permissions in an automated fashion.
• Co-ordinates project kick-off meeting bi-weekly sprint planning, daily scrum stand up, sprint grooming, sprint review, and retrospective meetings and update the scrum team on status of upcoming User Stories.
• Knowledge of Order to Cash and Procure to Pay Cycle.
• Utilize in-depth knowledge of functional and Technical experience in ORMB and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer.
• The Agile Extension to the BABOK Guide.
• Extensively worked on PeopleSoft Treasury/Cash Management.
• Experience in analyzing the Assets Under Custody and understanding the growth in revenue and exposure in each market for all existing clients to effectively assist in re-pricings
• Extensive experience in conducting market research, requirements/change management, impact analysis, gap analysis, and risk analysis.
• Assist in implementation and support of new procure-to-pay Coupa platform.
• Extensive experience in complex query writing in SQL using MYSQL and Oracle databases.
• Strong experience in Agile-Scrum and Waterfall methodologies.
• Experience in envisioning, representing and translating the product vision from the business to the software development.
• Comprehensive knowledge in implementation of business systems including Procure to pay (P2P), Order to Cash (O2C), inventory management and financial modules.
• Strong knowledge in capital market products, Treasury, Asset Liability Management (ALM), Custodianship, Asset management, Derivatives, Futures, Swaps, Options, Alternative investment, Investment banking, Equity, bonds, Money market, settlements, profit and loss, balance sheet and cash flow statement analysis.
• Manage requirement elicitation through brain storming sessions, interviews, workshops, JAD sessions with clients.
• Extensive knowledge of multiple Agile framework; SAFe, Scrum, Kanban, Extreme Programming.
• Expertise in preparing and analyzing Business Requirement Document (BRD), Functional and Non-Functional Requirement Documents.
• Good understanding of process improvement techniques. • Perform AS-IS and TO-BE analysis, GAP analysis, Cause - Effect analysis using fishbone analysis techniques.
• Design business models using UML - Use Case diagram, Use Cases, Class, Sequence, Activity, Component diagrams in EA Sparx, MS Visio, Lucid Chart.
• Strong understanding of Service Oriented Architecture (SOA), Object Oriented Analysis (OOA), Object Oriented Design (OOD) techniques.
• Data Modeling Techniques - Star & Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling.
• Analytical, methodical and resourceful approach to Problem Solving, Root-Cause Analysis, Conflict Resolution, Negotiation Strategies and providing corrective actions to meet business requirements.
• Expertise in preparing artifacts like Project Charter, Requirement Traceability Matrix, Minutes of the Meeting.
• Knowledge in DML, DDL and usage of joins in SQL for querying data.
• Knowledge in Data Warehousing concepts including Meta data and Data Marts.

TECHNICAL SKILLS

Programming Languages and Web Technologies: C,C++, HTML, C#, ASP.NET, Java

Reporting: Crystal Reports, MS Excel

Testing Tools: Win Runner, Load Runner 9.1, QuickTest Pro (QTP) 8.2-10.0, Cucumber, Jasmine, IBM Rational Test Manager, HP ALM

Defect Tracking: IBM Rational Clear Quest, Bugzilla, HP Quality Center

SDLC Methods: Agile, RUP, Waterfall, Cost/Benefit Analysis, Gap Analysis, Feasibility Analysis (TDD, BDD)

Databases: Oracle 7.3-10g, IBM DB2, Sybase, SQL Server 2000/2005/2008

BI Tools: SSRS, Business Objects, COGNOS, SSIS, Informatica, SSAS

Operating Systems: MS Windows 95/98/NT/2000/XP/7, Mac OS, Unix, Linux

Other Tools: Microsoft Project, IAM, TOAD, MS Office, MS FrontPage, Microsoft tools, Dreamweaver, Photoshop CS, Aprimo Marketing Studio, Verite (Event Management System), Salesforce, Harte Hanks, First Logic, DNB, SAS, First Logic (SAP) SharePoint, Informatica, Load Runner, Win Runner, Crystal Ball, Expert Choice, Core, Caliber

PROFESSIONAL EXPERIENCE

Confidential

Sr. PeopleSoft Business Analyst

Responsibilities:

• Managed the projection, implementation, upload, support, and maintenance of Light Squared annual budget in Hyperion Planning System and Excel; coordinated field input and consolidation for the company.
• Worked for the Identity Access Management (IAM) group. Key Project: Launch Single Sign on (SSO) for all Treasury Management products across Confidential
• Worked in Oracle Revenue Management and Billing (ORMB) to help design technical solutions to implement business rules. Worked with Oracle E-Business Suite Revenue Accounting General Ledger and Accounts Payable using the Oracle Data Integrator tool.
• Frequent reforecasting of communities with large variances to budget
• Experience includes PeopleSoft Finance modules like GL, ELM, Treasury, AP, Purchase Order, e Procurement, Purchasing.
• Worked on Oracle Revenue Management and Billing (ORMB)
• Served as a business enabler via systems development support, clear planning and design documentation for properly-secured, policy-compliant, high-performance IAM integrations.
• Researched problems and recommended solutions to improve security and processes by providing security IAM options.
• Created and maintained test plans and scripts, MS project plans and reusable SQL data validation scripts
• Define standards for business analysis through the creation of a guide to the Business Analysis Body of Knowledge BABOK Guide, a summary of the knowledge within the BA profession, reflecting current accepted practices
• Analyzed departmental budget requests to prepare budgetary recommendations, documents, and reports.
• Involved in customizing the people code to replace the PeopleSoft delivered positive pay crystal process APY2055 with the AHFC customized SQR and default the process scheduler server to PSUNX.
• Perform operation deep dives at various communities to identify breakdowns
• Developed communities using community builder, data categories, knowledge, chatter and workspace
• Interacted and assisted Tech Team to modify interfaces to convert legacy Asset data to PeopleSoft Asset Management.
• Attended Lean Six Sigma and Rapid Improvement Events to identify optimal streamlines
• Oracle Revenue Management and Billing (ORMB) process improvement
• As a Scrum Master facilitated Sprint Ceremonies like Sprint Planning meetings, Daily Scrum Stand -up, Sprint Demo and Sprint Retrospective meetings based on the three pillars of Scrum
• Conducted quarterly forecasts with cash & GAAP basis planning and monthly forecast updates and support in the Hyperion Planning System; revised plans for operating and capital expenditures on a continual basis.
• Worked with Peoplesoft administrators to define the different security groups needed for distinct roles.
• Spearheaded full-cycle projects from conception through implementation; monitored budget, milestones, and payments; ensured prompt invoicing in collaboration with Accounts Payable.
• Guiding and Coaching the Scrum Team and organization on how to use Agile/Scrum practices and values to delight customers
• Scheduled meetings with developers, system analyst's (SA) and testers to identify resource allocation and project completion using MS Project.
• Used MS-Visio to document current work flows, manual processes and end-to-end processing of system interactions.
• Work on acquisitions and proformas of new potential communities
• Enabled Chatter for the Organization to effectively communicate with the users in the Organization
• Derived IAM solution requirements or development requirements by working closely with Systems Development group and Business stakeholders. Performed coarse and fine grain entitlement roles & groups definition and mapping within CA product suite. Improved IAM domain security architecture knowledge from CA product teams.
• Lead Process Improvement projects to analyze and optimize the current workflow processes, using Six-Sigma
• Provide strong business analysis for strategic direction on PeopleSoft Finance projects.
• Ensured program expenses were accurate and monthly expenses on target by effectively tracking program budgets; delivered project cost reporting to senior management and Project Managers.
• Led weekly project meetings and provided ad-hoc analysis and evaluation.
• Managed dependencies between other Scrum teams, third parties and other non-agile waterfall teams.
• Facilitated monthly accounting close through expense management, reconciliation, and re-classes.
• Identified risk and potential issues through G/L Expense Investigations.
• As a Scrum Master facilitates discussions, decision making, and conflict resolution, remove, self-organization and cross-functionality.
• Managed monthly financial reports including OpEx, CapEx, and project summaries and variance analysis.
• Used MS Visio to create Business Flow Diagrams and Work Flow Diagrams
• Collaborated with Infrastructure technical teams to resolve more complex IAM security related issues.
• Developed strategies using Lean & Six Sigma (DMAIC) methodologies to address the issues.
• Served as a Business Liaison between the Business Users and the Developers helping them in understanding the Functional behavior of the Internal Systems.
• Played the role of Scrum Master by executing multiple projects simultaneously with excellent and proven customer rating.
• Conducted Cross-functional meetings to discuss the impacts from cross functional systems.
• Helped the Business Users while performing the UAT testing and helping them resolve the defects in the environment
• Worked in PeopleSoft Finance modules like GL, AR, AP, Cash Management, SCM, Commitment Control, Allocations, Asset Management, Project Costing.
• Implemented Chatter, Chatter desktop, created public and private groups
• Created Testing Requirements Document (TRDs) and Test Case Scenarios to test functional changes to the system/application as per the project requirements
• Used XML to look up for the specific attributes and parameters needed for testing the web application in the QAT environment.
• Interacted with the testing team while developing the functional test cases and regression test cases
• Kept a track of all QAT and UAT bugs/defects and helped the testers to resolve the issues and made a report of all the defects which were resolved and which were not using MS EXCEL.
• Collaborated with internal stakeholders to build interfaces between applications and IAM tools.

Environment: /Tools - SQL, qKDB, Data mapping, Cyber Security, IAM, UNIX, Rally, MS Visio, UML, XML, Agile/Waterfall, Windows XP, Six Sigma, data analysis, UNIX, data mapping, Scrum, MS Office (MS Access, Word, MS Excel, MS PowerPoint),MS-SharePoint, SAS/Access, SAS/Bas, TDD.

Confidential

Sr. PeopleSoft Business Analyst

Responsibilities:

• Identify risks, control gaps and process breaks through sampling and testing for Process Controls assignments, complete with root cause analysis.
• Analyses incoming work and IAM metrics/measures to drive improvements to the IAM program
• Participated in daily scrum calls to discuss issues, plan of action and resolve subject queries raised by the technical team.
• Conduct Process Control Assessments inclusive to call monitoring and FDR documentation.
• Develop and monitor action plans in conjunction with Process Control findings and communicate to various levels of the business.
• Validated all Billing, Payments, Adjustments, Financial Transactions and Credit/Collections Testing artifacts.
• Developed several PeopleSoft queries to match receiving with contract and Purchase order.
• Supporting Accounting, Finance and Procurement user communities after implementation of new ERP system.
• Enhanced the existing screen include AHFC Inventory Exchange History.
• Provide Best Practice recommendations with alternatives and/or work-arounds to resolve issues with ORMB and/or Business procedures associated with the Finance Systems ORMB Open Item implementation. Root Cause analysis of issues to develop permanent fixes when a short term solution is employed for expediency.
• Performed System Integration Testing Oracle (ORMB & EBS) Rating and Billing application.
• Perform monthly audits and co-facilitate team meetings
• Research and filter data reports on weekly basis
• Assisted in Architecture/Operations for Security and Identity & access management (IAM) requirement review and final drafting
• Facilitated Scrum ceremonies (Daily Scrum, Grooming, Sprint reviews, Retrospectives, and Scrum Planning).
• Loading data from external source to PeopleSoft using application engine and SQR.
• Tableau, both data analysis and visualization; report creation and generation
• Create document walkthroughs in narrative form of processes for future testing or audits.
• Communicate weekly and monthly research findings to upper management.
• Evaluate Gift Registry application components that address business requirements for Identity and Access Management (IAM) portal using My Access.
• As a scrum master, work closely with the team and identify the risks/impediments if any and try to resolve them and also communicate the fact of risk to the Stake holders early
• Successfully compile a pitch for leadership to conduct monthly and quarterly team meeting across multiple sites.
• Gathered high-level financial information requirements for client (AHFC& HCFI) and translated these requirements into an appropriate SAP financial hierarchy (enterprise model). Supported all phases of a project life cycle including analysis, design, development, testing, and deployment of solutions, as well as documentation, and end-user training.
• Cross-Functional Teams experience when creating and testing new Processes Plan, lead and execute Process Control projects such as Customer 360, Work at Home and Skip Promise to Pay.
• Involved in implementing Six Sigma practices to systematically improve processes and standards and by eliminating defects
• Using SCRUM/AGILE, I worked with Scrum Masters (Agile), Product Owners, and Scrum team members to ensure success of Programs, Releases and Sprints.
• Gathering business requirement and understand the business communities needs
• Committed to excellence through highly effective planning, organizational and communication skills. Specific expertise includes: Data Analysis and Visualization.
• Creating, maintaining and distributing project plans, task lists, and tracking the delivery of tasks assigned to project team members.
• Facilitated daily scrum meetings and weekly backlog grooming meetings with the entire project team in Agile Scrum development methodology.
• Used Amazon IAM to grant fine access of AWS resources to users. Also managed roles and permissions of users to AWS account through IAM
• Involved in the analysis of compare reports from PeopleSoft upgrade labs and finalizing the upgrade script changes. Upgraded online Customizations. Added new pages and People code.
• Interfacing on a regular basis with customers, project teams and sales team.
• Deal with adversity and communicate challenging situations in a positive and productive manner, both with peers and internal organizations.
• Documents functional / technical requirements, use cases, current / future Visio process flows and specifications related to IAM efforts including integration projects, defects, bugs and general IAM service delivery
• Liaison with acquired companies for getting data relevant to PeopleSoft tables
• Uploading data using SFDC data loader providing solutions and best practices on Salesforce chatter
• Lead, document and distribute results of the lessons learned sessions after the completion of each project.
• Participated in different levels of the SDLC cycles - Analyze, Plan, Design, Develop, Test and Deploy in the waterfall model as not all the applications are Agile yet.
• Conducting transitioning of the Agile Technology across teams as “early Testing” / “shift left” is the next key to IT Industry.
• Responsible for gathering the requirements by coordinating with the business analysts, developers and project managers, in order to better customize, and utilize the full functionality of the Salesforce.com CRM solution.
• Coordinate with the Business partners, Value stream partners of different verticals and the Scrum team to analyze and estimate the velocity and capacity for each sprint in the said Program Increment (PI Planning).
• Performed daily backups of PeopleSoft Security using Data Mover scripts and performed daily profile and system audits to maintain clean environments.
• Setup and tested web-to-case forms, email-to-case, assignment rules, automation and queues, auto response rules, escalation rules, chatter groups, person accounts, cases and solutions, lookup relationships, approval process for consulting requests and status tracking and performed demos.
• Collaborate with IAM Architects in the application development process to ensure that functional requirements become incorporated into technical solutions
• Triage the issues with all the upstream and downstream applications in the E2E for each Sprint in the Agile Technology using the CA Agile Central - TDD Tool.
• Prepare analysis and information reports for management and present recommendations for changes and improvements, to fit in bank’s regulatory system and standards.
• Extracted data from different sources like MS Access, Excel, and text files using SAS/Access, SAS SQL procedures and created SAS required datasets.

Environment: /tools - SQL, JIRA, HTML, Agile/Waterfall, UNIX, IAM, Windows XP, data analysis, data mapping, Visual Basic, SOA,, Cyber Security, SOAP, HTML, MS Office (MS Access, Word, Scrum, MS Excel, MS PowerPoint),MS-SharePoint, SAS/Access, SAS/Base, Microsoft .Net, C++, Asp.Net, VB.Net and Storm Framework Project, Requisite Pro, UML, MS Visio, Six Sigma, MS Access, Rational Rose.