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.
• Strong knowledge of the procedures of Banking & Regulatory Compliance's especially in AML, KYC and Basel Accords
• Extensive experience in Finance industry, Credit Card, Investment Banking (GL, Personal Accounts, Check payment, ATM, Fraud - AML) and Mortgage industries.
• 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.
• Strong experience in Business Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services.
• Good knowledge of payment domain, Cash Management and Treasury Management services (AccountReconcilement Services, Positive Pay, ACH, Lockbox, SweepAccounts, etc.) and tools (Fiserv, Check Free, Fidelity Systems, etc.).
• Experienced in working with traditional and agile Software Development Life Cycle (SDLC) methodologies. Delivered technology projects in Waterfall, Waterfall - Scrum Hybrid, Agile-Scrum, Scaled Agile Framework (SAFe), Kanban Principles.
• Experience in reporting international and domestic assets with a large emphasis on portfolio investments in mortgage-backed securities.
• Experienced in developing UML Use Cases for the application using Rational Rose and prepared the detailed work flow diagram based on the proposed enhancement for the system and MS SharePoint for documentation control and have good experience with SQL queries.
• Strong knowledge in migrating the Commercial Lending Process from existing AFS Application to the new application platform Loan IQ, mainly focusing on the Commercial Lending Servicing process.
• Experience in Tableau server on AWS to protect the Tableau environment using Amazon VPC, security group, AWS IAM and
• AWS Direct Connect.
• Experience in Retail Banking business operations including Loan Origination and Servicing, Cash Management, Treasury, CRM, Business processes and Automated Financial Systems (AFS).
• Demonstrated experience and understanding of the methodology testing in a DevOps environment, which include experience in using Jenkins for auto deployment of a build.
• 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)
• Experience in storing CIP, AML and KYC client information in HUB and made available for reporting, audit purpose and all wealth management channels.
• 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.
• Strong knowledge in Data Mapping, Data Conversion, creation of the Data model and used SQL and Toad to extract, filter and validate data.
• 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.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• 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, Pasadena, CA

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.
• Documented technical compatibility by gathering adequate requirements to mimic client's platform requirements for Actimize AML.
• Gathered the requirement with the SMEs to get the maximum information about the work-stream including Mortgage Servicing, Loan Monitoring, and Asset Management.
• Worked with the Remediation team to identify and analyze the ISA (Information Security Administration) functions to check for compliance and open CAP (Corrective Action Plan), RA (Risk Acceptance) or RE (Risk Exception) for AML (Anti Money Laundering), Bond trading and Fraud prevention applications.
• Participate in knowledge transfer meetings and discussions with consumer management and BSA/AML Officer.
• Built relationships with AML Investigation units, effectively communicating and transferring information for case investigations.
• Conducted JAD JAR sessions to synchronize the different stakeholders on their objectives
• Assisted in using SAFe, such as time-boxing, continuous integration, continuous delivery, transparency, accountability, empowerment and velocity improvement.
• Responsible for the file analysis and data mapping of the ALS system and AFS system
• Interacted with teams in AFS, ACBS and Infolease to extract the information for the reports
• Documented the end-to-end data lineage for all the BASEL Key Business Elements KBEs and pushed it periodically to IBM IIS metadata repository to support data governance and enterprise wide Metadata management.
• Conducted JAD sessions with management, SME (Subject Matter Expertise), vendors, users and other stakeholders to develop specifications and work closely with DevOps teams.
• 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).
• Performed Design testing and QA testing for various transaction sets such as ACH transactions, ATM transactions, In-clearing transactions, and AFS Green Screen transactions.
• Worked with AWS services like EC2, S3, IAM and REDSHIFT.
• Involved in performing debt-sizing and due diligence underwriting of commercial mortgage loans.
• 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.
• Worked on Data modeling, Advanced SQL with Columnar Databases using AWS.
• 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.
• Wrote ReportingandAlert requirements for wires rejected by AML (Anti Money Laundering) system.
• 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, Chicago, IL

Business Systems Analyst

Responsibilities:

• Created AS-ISBusinessProcess 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.
• Worked extensively with Risk Management, Mortgage Loan Servicing, and Commercial and Residential mortgage, CMBS, MBS
• Created T-SQL objects such as tables, views, joins and store procedures to meet client requirements.
• Facilitated all aspects of the Scaled Agile Framework (SAFe), sprint planning sessions, backlog grooming sessions, daily scrums, product demos, sprint reviews and sprint retrospectives.
• Worked with AWS services like EC2, S3, IAM and REDSHIFT.
• 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.

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 ofbusinessprocess operations
• Provide gap analysis between business requirements and ACBS upgrade Release Note.
• Responsible for system testing the ALS to AFS automated file conversion programs.
• Involved in re-underwriting and evaluation of credit risk of pooled commercial mortgage loans to support CMBS B-piece acquisitions.
• GatheringBusinessand Functional requirements based on the project scope and SDLC methodology.
• Provided SAFe and guidance for the project management life cycle and other IT-related processes.
• Developed the Business Requirement Documents (BRD's), Designed Functional Requirement Documents (FRD's).
• Used AWS command line client and management console to interact with AWS resources and APIs.
• 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.
• Facilitated and managed meeting sessions with committee of SMEs from various business areas of Mortgage.
• Responsible for physical/logical data modeling metadata documentation user documentation and production specs.
• Involved closely users of UAT in conducting demo of application, creating user guide and user manuals and manual testing with the help of SQL queries
• 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
• Performed backend testing using SQL queries and analyzed the server performance on UNIX.
• 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, Las Vegas, NV

Business Systems Analyst

Responsibilities:

• Worked on data modeling and produced data mapping and data definition documentation.
• Performed Requirement Analysis and developed Use Cases, Activity Diagrams using Rational Rose Gathered user requirements for new reports through JAD JAR sessions, which eliminated duplicate and obsolete data and provided a uniform reporting environment across the multiple trading desks.
• Worked with the full SDLC, elicit, analyze and define requirements. 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.
• Facilitating JAR sessions for gathering requirements from the FLCLs and defining the user acceptance test standards
• Responsible for making data model, Use Case Diagrams and Class Diagrams using UML.
• Wrote SQL Queries, such as Joints, Sub Query, correlated sub query and nested queries to retrieve data from various tables in the database.
• Develop and review Business Requirement Documents (BRDs). Facilitate meetings with the appropriate subject matter experts for CRE, ABL, C&I & Trade Finance. Ensure that high-level business requirements (sections, sublimit) have been decomposed properly into useable functional requirements for ACBS.
• Testing numerous AutoSys jobs for Intraday, Nightly Batch, Weekly batch, Monthly batch including on-demand jobs
• Designed and Implemented interface conversion using Perl, Shell and AutoSys scripts.
• Worked with the developers to create Data Mapping Documents for Direct BAI, SWIFT, Non-BAI Controlled Disbursement and Shared Draft Products.
• Worked closely with Production Control team to schedule shell scripts, Informatica workflows and pl/sql code in Auto-sys.
• Suggested web security using encryption and authentication technologies for reporting and complaint filing procedures.
• Interacted with the users and logged any defects, enhancements from the UAT.
• Manually performed Functional testing and GUI Testing.
• Tested Middleware transactions including XML transactions from TIBCO and MQ series Evaluate development and maintenance of application documentation and source code management, along with participating in and supporting change management processes as required.
• Evaluated testing results for each potential release build using Test Director, Quality Center and Bugzilla reports, listing summarized bug information in priority sequence, recommended viability of release for production.
• Automated and executed regression test cases using Quick Test Pro (QTP)Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
• Created new and modified existing reports using the Actuate Developer Workbench and integrated it with Siebel.
• Facilitated the User Acceptance Testing (UAT) with Pega System Administrators and Business Users, documented any issues or defects and eventually got sign off from the right parties.
• Responsible writing Test Plans, Test Cases and Test Scripts using manual and automated testing tools from Rational and Mercury Interactive such as test Director, Winrunner.
• Managed workload, schedules and coordinated status review meetings with project managers, business managers and team members.
• Authored progress and completion reports which were then submitted to project management on a weekly basis in MS project.

Confidential, Pittsburgh, PA

Business Analyst

Responsibilities:

• Interacting with the stakeholders to get a better understanding of client business processes and gather business requirements.
• Documented requirements, associated change requests with requirements and connected requirements with Use cases.
• Creation of the functional requirements specification from the business requirements. Participate in JAR Session with the business users.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Project. Extensively used (inbuilt and custom) Check points for Testing GUI Applications
• Conducted business meetings to analyze and document enhanced business requirements in BRD.
• Conducted JAD JAR Sessions to develop an architectural solution that the application meets the business requirements, resolved open issues, and change requests.
• Wrote SQL queries to extract data from various source tables for creation of analysis dashboards.
• Involved in writing Test Cases in Mercury Quality center that would test various Test scenarios.
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Performed extensive black box testing after the technical team integrated two or more modules of the application. Conducted GUI testing, System testing and Regression Testing
• Meticulously assessed data from various sources and generated conceptual and logical database designs using ERwin data modeling tool.
• Prepared actuate reports design, developed, reviewed and tested in development environment
• Developed Murex custom reports using dynamic tables, datamart, and Actuate
• Created test plan and test cases for user acceptance testing (UAT). Used Rational testing tools. Conducted informal Sessions to develop an architectural solution that the application meets the business requirements, resolve open issues, and change requests.