Business Analyst

Yin Liang

Business Analyst

*+ years served as a Business Analyst in the domain of finance and banking, supporting business process including research, analysis, review, development, implementation, testing, maintenance and monitoring, acting as a liaison between financial institutions and IT groups, and ensuring the completion of client requirements and objectives with strong understanding of sequential and Iterative approaches like waterfall, RUP, Agile project management methodology.

Professional Summary

Excellent in understanding client requirements, summarizing client needs, and translating into technical options and solutions that meet end user business needs.

Broad experience with SDLC requirement gathering and deployment using Agile Scrum, Rational Unified Process (RUP), Waterfall.

Proficient in creating UML diagrams like Use Case, Activity, Sequence, Collaboration, Class, State, Workflow, Process flow, Data flow and Deployment Diagrams using tools like Rational Rose, MS Visio.

Proficient in creating mapping spreadsheets, Source to Target mapping documents including transformation rules.

Ability to plan and coordinate all testing phases including making test plans, conducting User Acceptance Testing (UAT) and creating & executing Test Scripts/Test Cases and highly involved with Regression, system testing and integration testing.

Generated Traceability Matrix to ensure that all the requirements are covered by the test cases.

Developed and documented business requirements which includes wire frames, Mockup Screens, Prototyping and Business workflows.

Ability to develop high quality documents and presentations for multiple audiences including business and detailed requirements specifications.

Proficient in creating BRD (Business requirement Document), TRD (Technical Requirement Document), FRD (Functional Requirement Document) and UAT Documents, and Use Case Narrative.

Expert in partnering with all levels of managers, developers, QAs, stakeholders, business users and technology teams.

Experience in AML & Trade Surveillance tools such as Actimize and good understanding of related topics.

Broad knowledge of banking industry (Retail banking, Investment banking, Private banking, Portfolio management, Asset management) and financial services.

Expert in knowledge in various capital market instruments and securities including Equities, Fixed Income, Risk Management (Credit and Market Risk), Mutual Funds, Derivatives (OTC market, F&O), Hedge Funds, ETF’s, securitization, Mortgage backed securities, Asset backed securities.

Understanding of Corporate Finance, Quantitative analysis, P&L, Balance sheet analysis, accounting, financial market, derivatives, fixed income, equity, financial modeling, data forecast & sensitivity analysis.

Excellent knowledge of pricing capital market and money market securities such as fixed income securities, equities and derivatives how they are impacted by the Bank Secrecy Act, USA PATRIOT Act, Dodd Frank Act, Anti-Money Laundering, OFAC and Customer Identification Program (KYC/CIP), Basel III compliance using industry standards and regulatory guidance, etc.

Understanding of Treasury/Cash Management, fee refunds and CRA activities, Clear understanding of Accounting Controls, principles and procedures, generally accepted accounting principles (US GAAP), IFRS.

A seasoned professional with planning, execution, monitoring and resource balancing skills and with the ability to support multiple projects.

Good analytical, communication, problem solving, decision making, presentation and organization skills.

Education: MS in Economics

Technical Skills: Agile Scrum, Rational Unified Process (RUP), Waterfall, Rally, JIRA, Rational Requisite Pro, MS-Visio, Enterprise Architect, Rational Rose, MS Word, MS PowerPoint, MS Excel, MS Access, Rational Clear Quest, Rational Clear Case, Informatica, Just in Mind, Mercury Quality Center, UML (Use case diagram, Context diagram, Activity diagram, Sequence diagram etc), Oracle, PL-SQL, SQL Server, UNIX, Windows.

PROFESSIONAL EXPERIENCE:

Client: M&T Bank, Buffalo, NY

Duration: Mar 2014 - Present

Role: Business Analyst

The primary goal of the project was to fill the corporate compliance gaps within some of the current embedded security functions. These Security functions include provisioning user IDs (creating, deleting, and modifying entitlements), adding profiles, managing groups, & entitlement reviews. The project followed agile scrum methodology.

Responsibilities:

Selected and implemented agile development practices according to the application requirements for the project.

Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly.

Worked with the Remediation team to identify and analyze the ISA (Information Security Administration) functions to check for compliance for AML (Anti Money Laundering), Bond trading and Fraud prevention applications.

Analyzed the new regulatory requirements of Dodd Frank and Basel Accord III on Market Risk calculation, monitoring and reporting, and new implementation of Comprehensive Stress Testing.

Designed detailed FRD according to BRD and Basel regulatory requirements using Power Designer.

Documented use cases, workflows and sequence diagrams according to UML methodology thus defining the Data Process Models.

Reviewed development plans, quality assurance test plans and user documentation for Black Box testing and performed Regression Testing and created test scenarios for Beta testing to ensure correct interpretation of original specifications.

Conducted training sessions to make the users comfortable with the functionality.

Reconciled conflicts, and break-downed high-level information into details.

Tools & Technologies: MS Office (Excel, Word, PowerPoint, Project, Visio, Access, Outlook), Agile scrum, AML, Actimize, Basel III, UML, SQL Server

Client: Customers Bank, Yardley, PA

Duration: Jan 2013 - Feb 2014

Role: Business Analyst

The goal of this project is to ensure efficient identification and monitoring of suspicious activities and transaction in the bank and ensure timeous reporting of suspicious transactions to the Anti-Money Laundering (AML). This project followed RUP methodology.

Responsibilities:

Worked with AML Operation team to analyze monitoring patterns of clients with CDD profile.

Ensured the information obtained is consistent with BSA/AML Policy and Procedures and satisfies regulatory requirements.

Assisted in the administration and review of Client Risk Scoring, Client Identification and KYC documentation oversight/management requirements.

Communicated extensively with the clients and with different levels of management to identify requirements, use cases and to develop functional specifications.

Identified and documented business needs for new market risk and credit risk module or re-usability and an existing module by performing a GAP analysis.

Prepared Business Requirements Document (BRD) and used Rational Rose for Functional requirements Specification (FRS) as per the Business requirements and Post Trade MBA work flow.

Used Visio to create Use Cases, activity diagrams, class diagrams, workflow process diagrams and prepared Use Case Narratives.

Constantly interacted with stakeholders to develop Functional Requirement Documents into use case for the IT team.

Created timeline and managed the schedule and the stakeholders to complete the task in timely manner.

Interacted extensively and frequently with the Developers to ensure the realization of requirements.

Involved with the QA team to determine and develop test approaches and methods for unit testing, integration, functional testing, load and usability testing according to application complexity and test requirements.

Participated in User Acceptance Testing (UAT).

Tools & Technologies: MS Office, RUP, SQL Server, MS Visio, MS Project, Share point, RequisitePro, UML, RUP, J2EE, Windows

Client: Sun life financial, Windsor, CT

Duration: Oct 2011 - Dec 2012

Role: Business Analyst

This project was to upgrade the automation of Mortgage loan Process beginning with customer initiation to the title transfer. It involved developing a risk analysis and modeling system for the collateral pools that has been purchased and securitized. It was intended to help the business users to structure the securities based on mortgage pool characteristics. Credit Risk and Prepayment Risk could be assessed and the system could also determine loss provisions based on the expected range of loss estimated by foreclosure frequencies and loss severity of the mortgages. Implement the trade surveillance requirements. This project followed Agile Scrum methodology.

Responsibilities:

Worked with business users, mortgage agents and marketing teams to determine the target market and business needs and established excellent knowledge in Mortgage loan processing and good understanding of loan process originating.

Analyzed the AS-IS and TO-BE processes to understand the key findings, the short-term considerations, the long-term considerations and benefits.

Worked closely with project manager to prepare project plans, budgeting, scope creep and feature creep and analyzed the existing system and business process flow.

Facilitated and managed JAD sessions, Interviewed with SMEs from various areas and conducted surveys and brainstorming sessions while gathering requirements.

Worked on writing functional specification for reporting module that handled credit and consumer risk management services.

Created the project templates for BRD, FRD, Use case specification, Change request form and Defect Status Forms.

Involved extensively in designing the database with the design team and created data flow diagrams, data analysis, and Process flow diagrams using Erwin.

Designed security privileges and authentication features of the application for mortgage broker access.

Involved with the technical teams during implementation to verify right business requirements are being translated into the system.

Interacted extensively and frequently with the Developers to ensure the realization of requirements.

Worked closely with QA teams to define test cases and execute test plans.

Tools & Technologies: Agile, UML, Requisite Pro, Rational Rose, Clear Quest, SQL, Windows, MS Office Suite (Word, Excel, Access, Power Point, Outlook), PL/SQL, Oracle

Client: HSBC Bank Company Limited, Zhengzhou, China

Duration: Mar 2011 - Sep 2011

Role: Business Analyst

The goal of this project was to implement Fixed Income Securities Investment Application System (FISIAS). Some of the key functionalities of the system were online personal financial management portfolio, ordering and payment processing. It supported the database connection, data migration, data conversion, application development, transaction security and session management. The project involved risk compliance under Basel III standards. This project followed Agile Scrum methodology.

Responsibilities:

Facilitated and coordinated JAD sessions with business users to analyze the investment tracking system, application lifecycle, gather and define the key performance indicators, document and present the requirements specifications.

Carried out Requirement Traceability Matrix (RTM) and managed the data format.

Prepared Business Requirement Document (BRD) and functional requirement document (FRD) to use with the project.

Joined Sprint Planning and Sprint Estimation (SPSE) meeting to create backlogs with Rally.

Designed process diagrams to show the workflow and UML diagrams to clarify the entities and their relationships.

Conducted GAP analysis and participated in daily scrum meeting to make sure everything was on track.

Formulated test cases and test plans, and built data validation scripts (pre and post load) in SQL to check the results.

Involved in sprint review and sprint retrospective meetings to ensure the proper delivery of user requirements.

Conducted System Integration Testing (SIT) (includes functional and structural testing) with QA and user acceptance testing (UAT) with client to discover and document defects.

Performed Root Cause Analysis and Re-engineered business processes, and implemented performance measures, presented project presentations to the business users.

Combined Quality Center (QC) and other tools to create, maintain, and store the requirements, and conducted test sets.

Complied with Bank Secrecy Act (BSA) and Basel III to control the risks.

Tools & Technologies: MS Visio, Agile, MS Office, Windows Server, SQL 2005, Rational Requisite Pro, Rational Clear Case, Java/J2ee, Oracle 8i, HTML

Client: Industrial and Commercial Bank of China Limited, Zhengzhou, China

Duration: Jan 2010 - Feb 2011

Role: Business Analyst

The aim of the project was to develop a loan pre-qualification system to let prospective customers to compare rates, make quotes, perform assessments before trying to apply personal loans. The system would also allow customers to initiate the application process of appropriate loans. The project followed RUP methodology.

Responsibilities:

Defined the loan pre-qualification feature scope with stakeholders.

Assisted the project manager to develop and define goals and objectives of the project.

Conducted GAP analysis by using Rational Requisite Pro.

Bridged as a liaison between the technical team (developers, testers) and users (client) to ensure smooth communication between both parties.

Gathered business requirements and other requirements from the client and defined functional requirements.

Designed ER diagrams and models by using ERwin.

Developed use cases and used Rational Rose to draw process flow diagram, develop activity diagram, class diagram, and sequence diagram that can help validate different business process in the loan pre-qualification system.

Involved in data mapping activities to gather and file data in the process of development and implementation.

Analyzed the business structure of the loan pre-qualification system, integrated Dodd Frank Act and Customer Identification Program (CIP/KYC) with the development team and the compliance team.

Wrote how-to tutorials to train customers about the functionality of the system.

Tools & Technologies: MS Office (Excel, Word, PowerPoint, Project, Visio, Access, Publisher, FrontPage, Outlook), RUP, UML, SQL Server.

Client: Bank of China, Zhengzhou, China

Duration: Nov 2008 - Dec 2009

Role: Business Analyst / Junior Quantitative Risk Analyst

The goal of the project was to make enhancement to an existing credit risk assessment system for risk-adjusted performance management, managing concentration risk, meeting regulatory requirements and enhancing revenues. This system would allow the client to continuously evaluate transactions and portfolios against regulatory guidelines, balance the various trade-offs among client demands, regulatory capital requirements and risk-adjusted returns. This project followed Waterfall methodology.

Responsibilities:

Gathered, analyzed and documented the user stories for the need for new module or re-usability of an existing module by performing GAP analysis.

Constantly partnered with project leads to ensure the team is producing solutions that meet established standards, procedures and practices, address issues, risks and mitigation plans.

Involved with making appropriate commitments through story selection, sizing, and tasking.

Worked with Requirements Analysts to identify, understand, and document business needs for the data flow to create market risk and credit risk module.

Performed data analytics with emphasis on credit scoring, credit risk, behavioral models, loan loss and general purpose risk/profitability models.

Proactively identified and removed blockers, facilitated frequent retrospectives, sharing metrics to identify and implemented improvements.

Documented test plans and test cases, and performed functional and regression testing.

Facilitated UAT and recorded the user feedback for future changes.

Employed various statistical analysis methodologies including regression analysis and divergence.

Utilized statistical analysis tools (SAS, SPSS, R, and MS Excel) to develop accurate and concise analytical results to deliver strategic solutions and make decisions.

Tools & Technologies: Waterfall, .NET, MS Project, MS SharePoint, Excel, PowerPoint, MS Visio, SQL, Access, Word

References: Available upon request

Contact this candidate