Business Systems Analyst Resume
San Antonio, TX
SUMMARY
- 7+ Years of Professional Experience as Sr. Business Systems Analyst with strong experience of Mortgage, Banking and Financial industry.
- Knowledge in Mortgage Loan Servicing, including accounting, escrow (taxes and insurance), collections, foreclosures and real estate owned.
- Experience in analyzing and requirements gathering and writing system functional specifications including use cases.
- Excellent in Developing and evaluating business process Models. Proven success as a business analyst through the years, providing a well - balanced understanding of business relationships, business requirements, and technical solutions. Strong experience in RUP Business Modeling process.
- Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
- Solid understanding of Business Process definition, Risk Analysis and SDLC methodologies.
- Excellent in Developing and evaluating business process Models. Design and review of various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents.
- Excellent Analytical, methodical, and resourceful approach to problem solving, identifying and documenting root causes and corrective actions to meet short and long term business and system requirements.
AREAS OF EXPERTISE
- Project Artifacts Modeling
- Systems Merger and Integration
- Business Process Modeling & Re-engineering
- General Ledger Accounting Systems
- Documenting Business Requirements
- Release Management
- Use Case Development and Process Flows
- Regulator & Compliance
- Reconciliation and back office support
- Cash Management
- Data Analysis and Data Mapping
- Customer Relationship Management
- Full Life-Cycle Applications Management
- Financial Data Warehouse
TECHNICAL SKILLS
Business Analysis: Requirement Analysis, detail design, Business Rules, data flow diagrams, data definition table, data modeling, system integration, and team building
Processes/Technologies: Rational Unified Process (RUP), Clear case, Use Cases, Workflow and UML
Rational Suite and Tools: RUP, UML with Rational Software Modeler, Rational RequisitePro, ClearQuestClearCase, UML, MS Visio, MS Project, Quality Center tool for test management
Application Servers: Oracle8i, 9i, IIS
Databases: MS SQL Microsoft Access & Oracle, Java Script, XML
Operating Systems: Microsoft Windows XP, NT, 95, 2000, 98, Vista & UNIX
Software Utilized: Rational Rose, Microsoft Office Suite (Word, Excel, Access, PowerPoint, and Outlook), MS Project, Visio
PROFESSIONAL EXPERIENCE
Confidential, San Francisco, CA
Sr.Business Systems Analyst
Responsibilities:
- Worked as a business analyst to build enterprise reporting system to support Risk Analysis, Securities and their Valuation, Asset Management, risks and returns, Bond Pricing, MBS, ABS, Derivatives (repos, interest rate swaps), Money Market Instruments and used strong knowledge of financial statements, cash flow, Financing Structures, Capital Management, Portfolio Analysis, Budgeting, trade capture application, risk management, and Investment Accounting.
- Analysed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).
- Created custom temporary and working tables, procedure to update working tables, and table view for external data fields and reports.
- Good working knowledge of products like Private Equity - Fund Administration, Fund of Hedge Fund administration, Global Custody, Exchange-Traded Funds, and various other products.
- Identify options for potential solutions and assessing them for both technical and business suitability.
- Developed configuration changes to a separate Trackwise instance related to new phases types for third party suppliers by creating new data fields, activity types, and updating data on configuration forms (records) and reports.
- Created business reports by joining multiple tables from multiples database using complex SQL queries.
- Converted multiple financial institutions onto the ADP banking processing system.
- Participate in monthly forums to discuss Conflicts Management concerns and business unit's compliance with Anti-Money Laundering/Economic Sanctions policy.
- Generated requirements for Capital Markets - Fixed Income Investment Management Business, Portfolio Management, Hedge funds, corporate actions, Brokerage and Trading Model within the scope of both the Front and Middle Office.
- Responsible for assisting in the business review of the loss allowance valuations, including the comparison of valuation results to expected results and to current market and business conditions.
- Performed compliance reviews for, and assisted in the development of, 400 collection and subrogation form letters mailed to consumers and businesses. Integral team member within letter strategy and marketing initiatives.
- Coordinated ISG efforts to adhere to outstanding enterprise application software policies for security, audit and compliance reasons
- Gathered all the right requirements to determine key issues and foresee potential show-stoppers that might arise later and in-depth understanding of OTC derivatives operations.
- Responsible for providing support to senior QA integration tester in the development and execution of integration test cases.
- Represented the business requirements in various alternative views such as analysis models, process flow diagrams and user stories.
- Using Shared Containers and creating reusable components for local and shared use in the ETL process.
- Conducted market research and analysis in Capital Markets consisting of Stock Market and Bond Market
- Served as legal liaison between clients and the corporation for matters involving compliance and litigation.
- Creation and maintenance of user-friendly internal Compliance Policy and Procedure Manual that was proven to ensure the corporation was compliant via multiple investigations from federal and state regulators, as well as state attorneys general.
- Products covered included FX, Rates, Swaps, Fixed Income, Equities, Commodities and Derivatives.
- Prepared for GAP Analysis; identified and documented improving areas to meet capital requirement regulations.
- Used the guidelines and artifacts of the Rational Unified Process (RUP) to strategize the Implementation of RUP effort in different iterations and phases of the Software Development Life Cycle.
- Responsible for wealth management portal project governance documents, project direction, conflict resolution, project metrics, daily Scrum meetings and product delivery
- Translated business requirements into functional requirements and prepared an extensive project plan to reduce inter-company transactions in equity derivatives and foreign exchange trades.
- Coordinated various kinds of User Acceptance Testing (UAT) including regression testing, system testing, integration testing, functional testing, alpha & beta testing.
- Used Agile Software Development process viz. Scrum, as this was a time bound project.
- Efficiently communicated to offshore/remote development teams to ensure timely delivery.
- Check the data flow through the front end to backend and use SQL queries to extract the data from the database.
- Worked with the SME, Tech Lead and 3rd party vendors in gathering requirements and data transaction information related to Capital Markets - Online Brokerage, IVR trading, Conventional Brokerage, Orders, Trades Executed and SPS Orders for reinvestment agreement to write global specs.
- Developed and support collaboration portal for data governance data stewards to share and exchange ideas.
- Discussed with SMEs across different businesses units to gain solid knowledge of the existing Credit Risk Calculation System and assisted in preparing an advanced Risk Assessment and ROI Management.
- Developed multiple Functional Requirements defiantion (FRD) documents using the Microsoft standard structure and format (business sections only)
- Scoped and participated on new projects that impact mortgage banking strategic data environments.
- Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart
- Verified the Business Scenarios on new builds to allow extended testing by the QA team.
Confidential, San Antonio, TX
Business Systems Analyst
Responsibilities:
- Responsible for defining the scope and implementing business rules of the project, gathering business requirements and documentation.
- Responsible for developing and supporting requirements for service flow of Corporate Actions, Corporate actions response, Currency, Free movement, Mutual Fund Order and execution, Non financial transactions and trading operational processing in Comerica’s global wealth management platform.
- Used MS Visio to carry out the data modeling, and object modeling efforts to develop the business architecture for rapid and controlled application development.
- Assisted in creating FRDS and Activity Diagrams to identify user business and functional needs based on inputs received. Designed system architecture using UML in MS Visio, As-Is and To-Be scenarios created.
- Prepared Use Case which provided the Trading Customer with the options to buy or sell securities at market price, for their accounts. The use case generated a trade confirmation when the trade is completed that contains the transaction id and the trade results.
- Partner with vendor management team to ensure company policies were being met, according to risk management guidelines.
- Created project documents like BRDs, FSDS, Use cases, Use case scenarios and screen mocks for each app of bankruptcy and foreclosure bids process.
- Performed trouble-shooting relating to client- queries relating to valuation of Interest rate, FX, Equity, derivatives (primarily for OTC instruments) done by Vendor system by performing these valuations on Bloomberg or alternative systems or in a spreadsheet.
- Studied the operations in the front office, middle office and back office of hedge funds as well as the current hedge fund administration processes.
- Created metrics and included them in the dashboards in WebI by using predefined analytic templates.
- Prepared Logical Process and Data Models that contained set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions.
- Performed analysis, planning, establishment of requirements, functional modeling, development of procedures, development of functional architectures, and other related management and technical duties.
- Developed Business Process documentation including Business Process flow diagrams (Visio).
- Responsible for business system analysis of customizing the BPS Risk Management product with involvement through the whole SDLC
- Responsible for gathering and aanalyzing business requirements, analysing the securities trading and order execution functional business processes, writing functional specifications, defining process /data flows.
- Strong understanding of data warehousing, database structures and business intelligence concepts.
- Assist business users community, understand their business needs and develop business intelligence solutions (BI reports, dashboard reports).
- Coordinate annual audit Funds with custodian, independent auditors and Fund Administration associates.
- Packaged requirements sets for delivery to offshore/remote development teams, and maintained ongoing communication with the teams to ensure they were on track.
- Worked extensively with Risk Management, Mortgage Loan Servicing, and Commercial and Residential mortgage, CMBS, MBS, Created business process workflow diagrams (Activity diagrams) in Rational Rose.
- Analyzed the system to be implemented for production to ensure that it handles incomplete and accurate data and performs default method of calculations for various mortgage products like Mortgage Backed Securities, Asset Backed Securities, and Megas & Tranches & Extensively involved in Data Modeling, Sequence diagrams, SQL Scripting and Reporting
- Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
- Created UAT plans with several test cases for each project to ensure that the system runs smoothly after the proposed enhancements or changes have been made.
- Directly worked with Product Management and Scrum Master to set release plans and prioritize product feature scope.
- 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
- Re-design and optimize business processes. Assisted the creation and management of product roadmaps, risks and issues
- Have valued FX options of different types-Shout options, barrier options etc. Involved in development and maintenance of workflow plans and artifacts.
- Audited the departments' financial transactions to ensure compliance to the university's policies and procedures.
- Worked on brokerage applications for trading, risk management and processing. Wrote BRD & FRD by gathering requirements from SME's using Murex Mx Asset Manager, to build up.
- Expert skills in gathering and documenting business requirements, business process flows, use cases using different business techniques such as interviewing customer & stakeholders, workshop facilitation, conducting seminars, presentations, storyboards, JAD sessions using RUP, UML technologies.
- Provide company-wide notifications in regards to change management, risk management and production support issues.
- Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD using UML. Developed business requirement specification documents as well as high-level project plan.
- Performed SQL queries to interface with external database.
- Performed task decomposition, delegated tasks and monitored project milestones using MS Project.
Confidential, McLean, VA
Business Analyst / Systems Analyst
Responsibilities:
- Met with stakeholders and users to review / manage expectations and identify opportunities to improve ROI.
- Work jointly with the communication team to inform Sr. Management, the regions, the countries, and the regulators about the definition and implementation progress of the Global AML CitiKYC project and its impact at all levels.
- Assisted in building a Business Analysis Process Model using Rational Rose and Visio. Used Castor to create objects from XML documents. Involved in Logical & Physical Data Modelling.
- Serve as a liaison between Designated Counsel and servicers on foreclosure and bankruptcy postponement process.
- Work with region and country AML Compliance leads to support start-up of compliance-led projects at regional and country levels. Including defining the subsequent phases training, UAT, staff to perform test scripts, data migration and the uplift strategy (updating of customer information to bring them to the new KYC standards) review of customer documentation.
- Reviewed compensation payments for interim servicers, terminated servicers and servicers in bankruptcy and resolved outstanding checks.
- Perform loss forecast analysis and reporting; perform ongoing ad hoc model development and analysis for specific clients needing high level quantitative analysis of credit risk, product valuation, asset analysis, and the like.
- Developed project artifacts like Requirement List, Process Models, Wireframes, Use Cases, Data Journal, and the Business Rules Catalog using MS-Visio and Rational Rose.
- Assist in the coordination of the particular businesses (ICG, GCB) specific needs for the Global AML CitiKYC project supported by fully documented plans, vetted with global business owners (ICG, GCB), regional and country AMLCO representatives.
- Developed business requirements to build a web-based financial system for bankruptcy administrators to reorganize and/or liquidate companies in a more efficient and transparent manner.
- Strong usage of Subject Matter expertise in Fixed Income, Equities, Equity Swaps, Equity Finance, Stocks Trading Cycle, Portfolio Analysis, Asset management, Bonds and Bond Trading Cycle, Bond Pricing, Derivatives (Options-Including Vanilla and Exotic and Futures/Forwards), Credit Derivatives, Interest Derivatives, Alternative investment, Portfolio Management, Sales and Marketing.
- In depth involvement with the design for the strategic template for the CI system in features like Mutual Funds, Investment Portfolios including Equities and Fixed Income(Options, Futures, Bonds) Fees Distribution, Educational Services. SWOT Analysis, Product Features and strategic decisions.
- Prepared Business Context Diagram, Use Case diagrams and corresponding Activity Diagrams using Rational Rose to depict the workflows to be incorporated into the development of Pega Business Process Management (BPM) tool.
- Worked on identifying critical parameters for credit risk using regression based modeling for a financial client, built models to predict bad rate, Deliquency rates and Bankruptcy rates.
- Conduct Brainstorming and JAD Session to gather Business Requirements from Market Risk Group, Risk Reporting Team and other stakeholders (PMEs, Compliance, etc)
- Facilitate risk management workshops, recording risk and assigning risk for mitigation. Research and resolve system issues and perform application testing as necessary. Produce metrics reports from data derived from database as necessary for the project.
- Facilitated JAD sessions with end users, development and QA teams.
- Authored Business Requirements Document BRD with project teams. Extracted, discussed, and refined business requirements from business users and SME’s.
- Conducted review sessions on regular basis with QA and development teams for preparing status, delivery report and client reporting.
- Analyzed and documented the data mapping requirements for several commodities data feeds (e.g., securities, trades, options, swaps, futures, cash activity etc.) following Agile & RUP methodologies.
- Consolidated the analysis of multiple business lines after the COTS evaluation.
- Prepared Use cases and Activity flow diagrams and Work flow diagrams, considering the scope of the project with MS VISIO.
- Interacted with fixed income business heads to finalize the Business Requirements for the Risk Management process.
- Identified business process models for International Business in Asset Management, fixed income, and mutual funds
- Responsible for improved service, reduce coding errors, improve consistency, improve profitability, improve cash flow and reduce facultative placement errors through a front-end reinsurance system.
- Involved in Managing Data modelling project from Logical design and implementation of Sybase Database
- Assisted in creating wireframes for web interface with the GUI design team.
- Moreover, I also authored functional requirements documents FRD by interacting with development team for improving client’s legacy system.
- Used CSS, HTML and Javascript for GUI front end designing and validations.
- Performed the client reporting and updating of the project on a regular basis
- Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
- Conducted status report meetings with the business and the IT team on a weekly basis, as the most important aspect of the project was Data Mapping.
- Prepared Business Object / Business Process Models that included modeling of all the activities of business from conceptual to procedural level.
- Assisted the development team in preparation of the CRUD Matrix.
- Exposed to SQL queries while churning out relevant information from company’s database.
- Assisted in system and user acceptance testing (UAT), free-trial demos, performed client presentations.
- Submitted change requests and worked with change request records in ClearQuest.
- Participated in entering and tracking system defects in Rational ClearQuest.
Confidential, Oklahoma, OK
Business Analyst
Responsibilities:
- Worked with Fixed Income, Bonds and Bond Trading Cycle, Bond Pricing, Equities, Trade Cycle, Derivatives (Options and Futures), Portfolio Management, Sales and Marketing.
- Collaborated in building a business analysis process model using Rational Rose, RequisitePro, and Visio.
- Responsible for business system analysis of customizing the BPS Risk Management product with involvement through the whole SDLC
- OMS provides constantly updated inventory information, a database of vendors, a database of customers, a record of customer returns and refunds, information on billing and payments, order processing records, and general ledger information.
- Experienced in Workflow Analysis, Gap Analysis for implementing trading system
- Created mock up diagrams using MS VISIO and provided the screenshots replicating the changes to the User Interface (UI) as per the requirements.
- Responsible for selecting vendors and integration of check clearance solution with applications from different vendors like Integration with Core Banking system and scanning solutions.
- Understood Fixed Income Modeling, Bonds and Bond Trading Cycle, Equities and Equity Trade Cycle, Derivatives (Options and Futures), Portfolio Management, Wealth Management, and Sales and Marketing.
- Trade reporting Subject Matter Expert, act as central IT point of contact for all matters related to TRACE, OATS, Bluesheets, LOPR, TRF and other trade reporting initiatives
- Track all regulatory changes as they impact Trade Reporting. Collaborate
- Worked with Operations Risk Management division to assess operational risk, determine impact of FX trade transactions on incident reporting.
- Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
- Experience in conducting GAP analysis, User Acceptance Testing (UAT). SWOT analysis, Cost benefit analysis and ROI analysis
- In-depth understanding of Investment/portfolio management in multicurrency securities, equities, Fixed Income, portfol0io accounting and related back office processing, lifecycle of a trade, Lifecycle of an account, Security setup, Account setup, Reconciliation.
- Primarily involved in the Mutual Fund trading activities of Domestic and International Equity, Fixed Income, Money Market, and Cash Investment.
- Worked directly with Risk Analytics/Users to establish Business Requirements, defined and documented core business process information, business rules, business entities and other relevant information
- Prepared for GAP Analysis; identified and documented improving areas to meet capital requirement regulations
- Acquired extensive knowledge of financial products and services, such as Fixed Income investments, Equities, Derivatives, Mutual Funds, Brokerage, portfolio management, Cash Management & Asset management.
- Evaluate and modify benefits policies to ensure that programs are current, competitive and in compliance with legal requirements.
- Involved in gathering the requirement with the SMEs to get the maximum information about the work-stream including Mortgage Servicing, Loan Monitoring, and Asset Management.
- Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
- Interacted with Cash Management Division and Compliance Office to review the AML (Anti Money Laundering) requirements and provide Positive Pay service to reduce check fraud
- Interact with SME's to elicit business goals and define goal-level requirements
- Provided inputs in the strategic development of detailed project plans, work assignments, target dates etc.
- Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
- Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
- Provided clear and concise technical documentation regarding requirements management plans, Technical Requirements, supplemental Requirements, Test Plans and Test Cases.
- Develop, generate and analyze weekly SEO campaign performance reports used for site traffic analysis
Confidential, Chicago, IL
Business Analyst
Responsibilities:
- Strong knowledge on pre-qualification, pre-approval and final loan approval processes within mortgage business.
- Involved in all phases of SDLC including Requirement Gathering, Process Mapping, Analysis & Design, Development and Testing.
- Analyze financial data and extract and define relevant information; interpret data for the purpose of determining past financial performance and to project a financial probability.
- Involved in creating project roadmap and enforced project milestones, timelines and schedules.
- Work with the ASP.NET development team on assigned specifications for Quality Assurance needs & Coordinate & Manage All phases of Testing for each stage of Application development.
- Used DocExpress to edit the documents generated from DOORS.
- Assisted in the automation of the mortgage portal with the Loan IQ system for the conditional approval.
- Extensively used Ms SharePoint a content management platform, for managing content across the organization within a shared repository
- Compiled the collection of financial data ensuring the input meets the client’s data quality standards.
- Followed a structural approach to organize requirements into logical groupings of essential business processes, business rules covering information needs and ensured that critical requirements are not missed.
- Worked as an interface between the users and the different teams involved in the application development for the better understanding of the Business and IT processes.
- Used DOORS for requirement management to capture, link, trace, and analyze and manage.
- Focused on .Net development of applications integrating Oracle and SQL server databases.
- Coordinated with client groups to determine User Requirements and Goals.
- Developed daily reports using Microsoft Query, Excel and Crystal Reports.
- Using MS Project to manage schedules, deadlines, and resources.
- Prepared Business Requirement Documents (BRD) and Functional Requirement Documents (FRD).
- Developed and illustrated Use Case Diagram, Process Flow Diagram, Cross-Functional Diagram, Context Diagram, Activity Diagrams and Sequence Diagrams using MS Visio.
- Designed and presented prototype to the end users of new information processing application.
- Reviewed Test Cases to comply with Use Cases and Requirements using Traceability Matrix.
- Coordinated between all IT and QA departments to gather the status and updates for the releases.
- Resolved testing environment defects in HP/Mercury Quality Center and assigned to appropriate development team leads.