SUMMARY

• Sr. Business Systems Analyst with 8+ years industry experience in business data modeling, software requirement analysis, process modeling, process flow and quality assurance skills using different methodologies, mainly OOA, OOAD and UML
• Successful in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) using Rational Rose MS Visio.
• Experience in Capital Markets, Derivatives, Commodities, FX, Equities and Fixed Income, Front - office, Treasury, Finance and Operations, and trading.
• Strong knowledge of Core Banking System, Retail and Commercial banking business, products, policies and procedures.
• Excellent knowledge in Asset Management, Wealth Management, Investment Banking, Derivative products such as Options and Futures, Credit Card, Insurance and Bonds.
• Knowledge of Commercial Lending Systems like Loan IQ. Familiarity with Consumer Lending Processes.
• Understanding of different Money Market Investment Tools including Fixed Income. Treasury Bills, Bonds, Notes, CDs, and Commercial Papers.
• Good knowledge of payment domain, Cash Management and Treasury Management services (Account Reconcilement Services, Positive Pay, ACH, Lockbox, Sweep Accounts, etc.) and tools (Fiserv, Check Free, Fidelity Systems, etc.).
• Strong knowledge activities involving corporate actions data integration, Entitlement calculation, notification and reconciliations with custodian through SWIFT, management of Tax Market claims to be paid or redeemed.
• Expertise in using Rational tools for creating use cases, version control, and defect tracking and monitoring and used the Rational Unified Process (RUP) methodology in all areas of the software development life cycle (SDLC)
• Expertise in using Microsoft Visual Studio Team System for requirement management and work item tracking.
• Having excellent understanding of Financial Accounting. Comprehensive knowledge of Balance Sheets, General Ledger, Trial Balance, Income Statement.
• Excellent Business writing skills in writing Business requirements document BRD, Use Case Specifications, Functional Requirement Specifications FRS, Software Design Specification SDS, Software Requirements Specification (SRS), Software External Specifications SES, Software Requirement Document (SRD), Data Dictionary, Business Continuity Plan (BCP), Workflows and Unified Modeling Language (UML) diagrams such as Activity diagrams, Class diagrams and Sequence diagrams.
• Experience with TFS (Team Foundation Server) for documenting the requirements.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Proficient in developing all types of technical diagrams including Behavior Diagrams (Use Case Diagrams, Sequence diagrams, Collaboration diagrams, State chart diagrams and Activity diagrams), and Structure Diagrams (Class Diagrams) based on UML methodology using Rational Rose and MS Visio
• Extensively uploaded test cases from MS Excel, MS Word to Test Director Quality Center.
• Excellent facilitation skills in conducting JAD and JAR sessions.
• Ability to gather business and Technical Requirements from both formal and informal sessions utilizing a variety of software methodologies including, Use Cases and the Rational Unified Process.
• Proficient in the implementation of production change management techniques and service delivery disciplines
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Familiarity with Lean principles and Six Sigma methodologies.
• Extensive knowledge of IBM and Tandem Mainframe, AS400, and ASP Client Server
• Working knowledge of implementing software development projects using methodologies such as Waterfall, Rational Unified Process, Agile Scrum.
• Expertise in data driven testing and setting parameters with the Performance Session Scripts.
• Expertise in Database Administration of Test Environment Databases, Data Pools and identifying the performance issues due to inefficient Database Administration.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Business Systems Analyst

Responsibilities:

• Developed Traceability Outline and Traceability Matrix in CaliberRM based on requirements specifications for all systems
• Wrote Business Requirements Document (BRD) by conducting detailed interviews with business users, stakeholders & SME's to determine, write, communicate & prioritize clear & well-defined business and functional requirements for software enhancements specifically related to the ACBS (Advanced Commercial Banking Platform).
• Used SQL queries for organizing and abstracting data from MS access data bases, created reports, forms on Ms Access.
• Captured Data flow diagrams and formatting of the data flowing through interfaces.
• Dealt with the Society for Worldwide Interbank Financial Telecommunication (SWIFT) in creating the criteria for the auditing of the TQR and Q-Gate review processes.
• Conducted JAD JAR sessions to synchronize the different stakeholders on their objectives
• Interacted with teams in AFS, ACBS and Infolease to extract the information for the reports
• Responsible for Identifying and reporting incidences of non-compliance within regulatory control on various commercial Investment Bank loan systems (Loan IQ, ARC, Deal Works, I-Vault, Exposure Now and Integrated Credit Risk Desktop).
• Interacted with Business owners to understand the current process and to provide suggestions to optimize using Autosys and Datastage.
• Prepare Loan to value and DSCR calculation test cases, test scenarios and execute in ACBS and other satellites systems.
• Analyzed SWIFT and MQ Series data volumes to derive data mapping. Operating SWIFT messaging service for financial messages, such as letters of credits, payments, and securities transactions, between member banks worldwide.
• Successfully transitioned the Operation Information Systems department to ISCM (Information System Change Management) tool by streamlining change processing.
• Managing overall testing process and project to production change management life-cycle.
• Developed the Use Cases, Sequence Diagrams, Activity Diagrams and Class Diagrams using Rational Rose
• Prepared UAT Materials, including the UAT Process, UAT Test document which would include step-by step process for UAT as well as all the tests that would cover all requirements.
• Analyzed requirements recommend strategic initiatives for OTC derivatives protocols and practices around DTCC, CDS, SWIFT for treasury and asset management documentation.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Conducted user interviews and documented business and functional requirements.
• Used Test Director and Mercury Quality Center for updating the status of all the Test Cases Test Scripts that are executed during testing process.
• Participated in UAT and worked with Mercury Quality Center for bug and defect tracking.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio. Reports were displayed and derived through the use of .NET technology (ASP and VB), Crystal Reports, AS 400, SQL, and Excel spreadsheets.
• Created exceptions report which were then submitted to project lead and stakeholders on a regular basis.
• Doing quality Assurance using Swift MT/MX, ISO20022, TWIST & doing Normalization & Renormalization of tables.
• Performed manual front-end testing to check all functionalities of different modules. Installing, patching and administering Oracle 10g database server.
• Wrote Triggers and Stored Procedures using PL SQL for Incremental updates
• Generated XML documents using the XML Output Stage.
• Conducted user interviews, gathered Requirements, analyzed the Requirements and managed changes using Rational Suite.

Confidential

Business Systems Analyst

Responsibilities:

• Worked Closely with Portfolio management and analysis, fixed income trading.
• Extensive experience in Conducting Market Research, Feasibility Studies, Data Analyses, System Analyses, Gap Analyses, and Risks Analyses.
• Analyzed FX rates for monitoring currency movements across the market for business development and management purposes.
• Implemented partial termination of FX trades and supported the team for complete testing of related changes.
• Developed functional specifications, data flow diagrams, data mapping, flow charts, data dictionaries, and functional mapping for automated solutions in support of business process operations
• Provide gap analysis between business requirements and ACBS upgrade Release Note.
• Gathering Business and Functional requirements based on the project scope and SDLC methodology. .
• Developed the Business Requirement Documents (BRD's), Designed Functional Requirement Documents (FRD's).
• Gathering market data including real time and historical price data, financial data, and trading news using financial data source named Bloomberg.
• Operating SWIFT messaging service for financial messages, such as letters of credits, payments, and securities transactions, between member banks worldwide.
• Worked on Risk analysis, Securities (Stocks and corporate bonds) and their valuation, Portfolio Management (risks and returns) and analysis, Asset Allocations Bond pricing, Financial Derivatives, Cash flows, financing structure, Capital Management, Stock Valuation, Amortization, etc
• Responsible for gathering requirements from users in operations group and performing data mapping for the application, confirm and vacillating the requirement at time of BA testing.
• Establish documentation for Agile methodology for implementation with a very water-fall-centric development team.
• Implemented and Used SWIFT messaging system to test the flow of messages from and into the new system and was also involved in ETL process
• Deep understanding the Business Flow of Investment Banking, and extensively involved in Portfolio management and analyses, Mutual Funds, Securities trading.
• Efficient in MS Project for planning and status reporting.
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• Assisted Project Management in developing Scope/ Vision Documentation and Project Plan, tracking project process, and developed Risk Mitigation Plan
• Set up market data including zero curves, correlation matrices, dividend curves, etc., and the underlying financial instruments and then set up derivatives pricing parameters and trade capture options that drive the valuation of trades based on the market data to configure and test the system
• Extensively involved with the trading activities of Credit Derivatives, Interest Rate Derivatives, FX Derivatives, Equity Derivatives and Commodity Derivatives; and Futures including Commodity Futures Contracts and Financial Futures
• Extensive work experience with Portfolio Managers, Experienced Traders, and Compliance Manager to configure the rule-based scenarios for capturing market and credit risk, general multi-factor sensitivity analyses, and PnL.
• Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Expertise in development of High level design, Conceptual design, Logical and Physical design for Database, Data warehousing and many Distributed IT systems integration testing and performance testing.
• Conducted UAT to confirm that all derivative products can successfully processed during the trade life cycle
• Created various UML models like Use Case diagrams, Activity Diagrams and State Diagrams in MS Visio.
• Responsible for obtaining requirement and UAT sign-offs
• Engage functional testing of the applications through use of SQL tools such as TOAD to mine data for investigations
• Performed extensive requirement analysis including data analysis and GAP.
• Design detailed Use Cases to then derive Functional requirements from detailed Use Cases.

Confidential

Business Systems Analyst

Responsibilities:

• Created AS-IS Business Process Model and Project Definition Document (PDD) for Mobilizing ACH Payment Service.
• Collaborated with the Wholesale UI Design (RAPD) team to create Mobile/iPad wireframes and to develop new UI standards for the redesign of existing CEO Mobile applications.
• Maintaining and keeping track of the fields and preparing a proposed file layout (Field Name, data type, Details) that needs to find a house or transferred in ACBS and documenting it.
• Making Process flows in Microsoft Visio of the ACBS processes in different BRDs to make the business Users better understanding of the new system.
• Making test scripts and test scenarios to be input in ACBS for prototype testing and for conversion scoping.
• Created Traceability Matrix; conducted Requirement Walkthroughs, functional/device testing and led Bug Triage activities with QA and Development team.
• Products covered included FX, Rates, Swaps, Fixed Income, Equities, Commodities and Derivatives.
• Responsible for creating User Guides, Demos and Tutorial documents for internal stakeholders and wholesale customers; conducting training sessions for pilot/end user team.
• Performed Stakeholder Analysis to identify the key players for project success.
• Worked with development team on Microsoft .Net platform, which provided robustness, and flexibility that was really needed to various dealers.
• Identified and involved all key stakeholders, contributors, business owners, operations staff and technical resources through JAD sessions.
• Scheduled meetings with developers, Functional Architects and testers in collaborating resource allocation and project management using MS Project.
• Identified, evaluated, and proposed Agile Methodology for solution delivery.
• Created Use Cases using UML and managed the entire functional requirements life cycle using Rational Unified Process.
• Created and managed project templates, Use Case project templates, requirement types and trace-ability relationships in Rational Requisite Pro.
• Involved in Data Migration from Legacy Systems to SQL Server.
• Designed and implemented simple workflows using SharePoint modules and email notification.
• Facilitated highly interactive JAD sessions with project stakeholders, subject matter experts (SME), end-users, Developers, Testers and project management team for identifying and resolving issues.
• Identified, researched, analyzed and documented business Process Work flows.
• Prepared Gap Analysis for the Consumer Website.
• Worked with defect tracking and reporting tools like Rational Clear quest.
• Created and managed Service Centre tickets to initiate System Change Request process.
• Reviewed test strategy and test plans to ensure that test cases reflects user needs for the functional, user interface (UI), usability and security requirements.
• Developed test cases for User acceptance testing and performed User Acceptance Testing.
• Developed XML schema design for a web services solutions platform that delivers marketing services information to internal and external client applications.
• Conducted extensive user interviews to evaluate the process flow and recommended alternate flows for business process improvement.
• Assisted Project Manager in managing requirements by coordinating and facilitating requirement tracking using Requirement Traceability Matrix (RTM).
• Actively monitored client expectations during all phases of SDLC and was responsible for initiating and managing change request from the client by filling Change Control document.