SUMMARY

• Over 8 years of proactive Business Analyst / Data Analyst / Systems Analyst / Risk Analyst / UI Designer experience with Finance and Banking exposure inbusinessprocess analysis, design, development, testing, integration and maintenance with strong understanding of sequential and Iterative approaches like Agile, RUP, and Waterfall project management methodology to manage teh software development life cycle (SDLC).
• Excellent noledge across Banking and Financial Services industry: commercial banking, retail banking, investment banking, private wealth management, accounting, balance sheet analysis, corporate finance, credit, deposit, loans, data forecasting, financial market, financial modeling, financial trading instruments, sensitivity analysis, risk management, financial reporting, money markets, quantitative analysis, derivatives, fixed income, brokerage trading, securities trading, foreign exchange, hedge funds, mutual funds, options, and treasury.
• Clear understanding ofBank Standard Procedure and Accounting Principles (accounting controls, principles and procedures, GAAP, IFRS), and how they are impacted by regulation and compliance like Anti - money Laundering Act (AML), Basel II/III, Bank Secrecy Act (BSA), Dodd Frank Act, Fair Lending, Know Your Customer/Customer Identification Program (KYC/CIP), and RESPA.
• Strong experience in AML, Risk Management, Trade Surveillance, and BI tools including IBM Cognos BI solutions, NICE Actimize platform, Oracle ERP solutions, and SAP Crystal Reports.
• Extensive experience in Business Analysis and System Analysis: requirement elicitation, documents (BRD/FRD/NFRD/test plan, etc.) creation and conducting QA tests in different phases of testing, including Functional Testing, Regression Testing, User Acceptance Testing (UAT), System Integration Testing (SIT),Businessacceptance Testing (BAT), and documenting test results.
• Extensive experience in Data Analysis and validation: performing data modeling (conceptual/logical/physical/semantic/star/snowflake/normalization/denormalization) and development ofentity relationship diagrams (ERD), data mapping spreadsheets/documents, data migration,ETL, maintaining data and defining transformation rules for data load and data extract processes, as well as writing SQL queries for data validation using Oracle SQL Plus, MS SQL Server, and TOAD.
• Proficient in building Demos/Wireframes/Prototypes/Screen Mockups and creatingUML diagrams:Use Cases, BusinessProcess Modeling, Activity, Sequence, Data Flow, Collaboration, Class, Workflow, Deployment usingMicrosoft Visio or OmniGraffle, and writing Technical Guide/Handbook/Manual using Microsoft Word, Apple Pages, Scrivener, and other Markdown editors.
• Adequate noledge on Desktop/Mobile/Web App UI Design and Development, and experience on IT System Automation/Optimization to maximize teh utilization of existing hardware and software while reducing teh overall cost for new IT infrastructure purchasing.
• Excellent bilingual (English and Chinese) oral and written communication skills, excellent presentation and problem solving skills, and exceptional interpersonal skills to communicate TEMPeffectively among stakeholders (developer/programmer, user/client, vendor, executives, and other departments within and out of teh organization), and able to adapt TEMPeffectively to challenging situations in a fast-paced team environment, and flexible to perform off-hours and weekend work and provide emergency on-call support per teh company’s needs.

TECHNICAL SKILLS

Programming Languages: ASP, C, C++, C#, CSS/CSS3, HTML5, Java, JavaScript, .NET, PHP, Perl, Python, Ruby, SQL, MySQL, SQLite, Swift, Tableau, Unix Shell, MS Visual Studio, Apple Xcode, Xamarin Studio

Banking & Finance Tools: Bloomberg Terminal, MS SharePoint, NICE Actimize, SAP Crystal Reports, SAP ERP, Oracle Banking, Oracle ERP

Business Analysis Tools: Agile Scrum, Apache, Atlassian JIRA, ERwin, EDW (Enterprise Data Warehouse), Jazz tools (IBM RRC,RTC and RQM), MS SQL Server, MS Visio, Navicat, OnTime Scrum, phpMyAdmin, Quality Centre, Rational Clear Quest, Rational Requisite Pro, Rational Rose, SSRS, Test Director

Data Statistics Tools: Analytica, Big Data, GAUSS, IBM Cognos, Mathematica, MATLAB, R, Revolution Analytics, SAS, SPSS, S-PLUS, Statistical Lab

Productivity Suites: MS Office Suite (Access, Excel & Pivot, OneNote, Outlook, Word, PowerPoint, Project), Apple iWork Suite (Pages, Numbers, Keynote), Adobe Creative Suite (Acrobat, Dreamweaver, InDesign, Illustrator, Lightroom, Photoshop), Acorn, Pixelmator

Operating Systems: Mac OS X, Windows, Sun Solaris, Linux, Unix, iOS, Android

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Senior Business Analyst

Responsibilities:

• Analyzed and incorporated financial data (historical market data, realtime trading data, and security master data, such as index data, prices, identifiers, yields, etc.) from Bloomberg, Yahoo Finance, Morningstar, and several other providers as data sources of this project as a Data Analyst.
• Utilized teh built-in Financial Markets Compliance solution package in NICE Actimize to manage risk and ensure all activities meet global regulatory requirements.
• Conducted both online and offline surveys with prospective users to elicit, gather, clarify, and analyze requirements and developed use case analysis with MS Visio and Excel.
• Facilitated JAD sessions and communicated with stakeholders and developers for requirement gathering and deliverables producing as Scrum Master.
• Employed HP Quality Center to manage all teh high level requirements and translate business requirements into functional requirements and non-functional requirements as Scrum Master.
• Coordinated daily scrum meeting with teh IT Department to ensure current development met teh standard and timeline as Scrum Master.
• TEMPEffectively communicated functional requirements with developers and QA in teh alpha testing process at teh end of each sprint by using Oracle ERP Project Team Connect.
• Developed test cases and wrote test plans to help developers locate and fix teh defects, as well as tracking issues with JIRA and discover possible gaps in corporate data warehouse on project scope.
• TEMPEffectively explored solutions within and outside teh scope and brainstormed new solutions for teh problems, and maintained Requirement Analysis Report, Preliminary Design Specification, Detailed Design Specification, Workflow Specification, Future Operational Procedures, and other documents.
• Analyzed financial reports (balance sheet, income statement, and cash flow statement) from target companies and researched on treasury yield, pooling of collateral for deposit, and security master data, such as index data, prices, identifiers, yields, etc. for teh past 30 years as a Data Analyst.
• Participated in teh sprint review session to help client understand our goal and collect feedback.
• Utilized IBM Cognos BI to visualize data and customized SAP Crystal Reports tool to generate different report layouts to satisfy stakeholders’ needs as a Data Analyst.
• Facilitated User Acceptance Test (UAT) with stakeholders and demonstrated features to track price and market capital changes, as well as to report market matrices ROI, EPS, P/E Ratio, ROE, and CAGR for selected companies in NYSE and funds managed by OppenheimerFunds.
• Trained clients on noledge of treasury, money market operation, foreign exchange trading, and current electronic trading platforms, as well as complied materials (Quick Start Guide and detailed User Manual) and collected feedback from users.
• Managed sign-off for deliverables (functional and non-functional specifications, change requests, user acceptance testing, and production deployment).
• Utilized Oracle SQL queries to access data stored in teh data warehouse for analysis and test teh proper implementation of teh database.
• Incorporated Excel, Powerpoint, Keynote, and modern Web/Mobile Application technologies (C++/HTML5/CSS3/Java/Javascript/PHP/SQL) to develop screen mockups, wireframes and prototypes demonstrating current development status and results to stakeholders.

Environment: Agile Scrum, IBM Cognos, C++, MS SQL Server, NICE Actimize, Atlassian JIRA, Oracle, SSIS, MS Visio, HP Quality Center, PHP, SAP Crystal Reports, Excel, Word, PowerPoint, Keynote, HTML5, Windows, Mac

Confidential, New York, NY

Senior Business Analyst / Systems Analyst

Responsibilities:

• Performed current situation analysis for existing system from BA perspective and co-managed teh project with Oracle ERP Project Resource Management module.
• Gathered business requirements from users through surveys and JAD session.
• Carried out requirement traceability matrix (RTM) and managed teh data format.
• Produced data mapping document which identifies teh source and target data in teh warehouse by using source system analysis (SSA).
• Prepared business requirement document (BRD), functional requirement document (FRD), and non-functional requirement document (NFRD) to use with teh project.
• Coordinated sprint planning and sprint estimation (SPSE) meeting to create sprint backlogs with Rally as Scrum Master.
• Designed process diagrams to show teh workflow and UML diagrams to clarify teh entities and their relationships by using MS Visio and OmniGraffle, and develop screen mockups, wireframes and prototypes demonstrating current development status and results to stakeholders
• Conducted gap analysis and participated in daily scrum meeting to make sure everything was on track.
• Formulated test cases and coordinated test plans, and built data validation scripts (pre and post load) in SQL to check teh proper implementation of data warehouse and perform security testing to ensure teh safety of sensitive data.
• Performed operational workflow analysis and generated reports on possible improvements over existing bank operation with Lean Six Sigma methodology as a Systems Analyst.
• Involved in sprint review and sprint retrospective meetings to ensure teh proper delivery of user requirements.
• Conducted System Integration Testing (SIT) (includes functional and structural testing) with QA and User Acceptance Test (UAT) with client to discover and document defects.
• Combined Quality Center (QC) and other tools to create, maintain, and store teh requirements, and conduct tests to troubleshoot issues in newly implemented NICE Actimize Enterprise module and communicated with developers and vendor to track and fix bugs across system using JIRA.
• Complied with Bank Secrecy Act (BSA), Basel II/III, and FATCA to control teh risks.
• Communicated with front office, back office, middle office, IT and management to ensure teh success of data migration from business perspective.
• Completed Core Banking Replacement/Transition (checking, savings, CD, Liquidity Deposit, Fixed Term Deposit, CMS, Pooling, loans, credit processing, etc.) by data migration and centralizing activities across teh company into Enterprise Risk Case Manager in NICE Actimize and prevented business disruptions to ensure business continuity as a Systems Analyst.
• Produce actionable intelligence report in support of management decisions through SAP Crystal Reports tools.

Environment: Agile Scrum, NICE Actimize, SAP Crystal Reports, Oracle ERP, Atlassian JIRA, UML, Quality Center, MS SQL Server, Excel, Word, MS Visio, OmniGraffle

Confidential, Church Hill, MD

Business Analyst / Systems Analyst

Responsibilities:

• Gathered requirements from teh stakeholders through JAD sessions and prepared business requirement document (BRD) and functional specification document (FRD) to prepare for teh implementation of NICE Actimize AML module.
• Developed functional specification document and non-functional requirements document based on Anti-Money Laundering (AML) and other requirements provided by end user.
• Collaborated with compliance team to include AML compliance, Basel II, and Bank Secrecy Act (BSA) into teh system.
• Developed research report with IBM Cognos BI on teh 30 years innovation and recent trends of teh Foreign Exchange and Money Markets, as well as teh electronic trading platforms with financial data (security master data, such as index data, prices, identifiers, yields, etc.)
• Overcame challenges posted from data migration perspective with front office, back office, middle office, technology and related project teams to convert legacy data into NICE Actimize platform and tested teh validity of teh implementation to ensure teh success of non-disruptive data migration as a Systems Analyst.
• Identified business needs and create use cases by using UML, created test plans and test cases to check teh functionality.
• Collaborated with project owner and scrum team to identify and map detailed processes, and worked with vendor to provide non-disruptive upgrading of teh existing risk management system.
• Involved in sprint planning session, backlog sizing, daily scrum meeting and sprint retrospective meetings.
• Performed gap analysis and risk assessment during teh project and generated reports on issues found in data warehouse, operation and software infrastructure from a broader business perspective as a Systems Analyst.
• Used UML technology to draw activity diagram and sequence diagram with MS Visio.
• Conducted and involved due diligence part into teh system and maintained traceability with JIRA.
• Presented teh demo/prototype/wireframe/screen mockup to teh end user and delivered project documentation (includes requirement, objectives, architecture, testing results, and operation procedures) at different phase of SDLC.
• Worked with teh testing team to prepare teh testing plan, scope and other relevant documents and participated in reviewing teh test cases prepared.
• Conducted System Integration Testing (SIT) with team and User Acceptance Test (UAT) with client to discover defects and document feedback.
• Generated customer-centric AML and Suspicious Activity Report through teh AML (Anti-Money Laundering) solution package in NICE Actimize.

Environment: Agile Scrum, IBM Cognos, NICE Actimize, Atlassian JIRA, MS Office (Excel, Word, MS Project), MS Visio, SQL, UML

Confidential

Business Analyst / UI Designer

Responsibilities:

• Acquired noledge of all teh pertinent federal regulation on teh mortgage (Truth-in Lending, RESPA…).
• Defined teh mortgage loan pre qualification feature scope with stakeholders.
• Assisted teh project manager to develop and define goals and objectives of teh project.
• Conducted gap analysis by using Rational Requisite Pro.
• Bridged as a liaison between teh technical team (developers, testers) and users (client) to ensure status is communicated appropriately between both parties.
• Gathered business requirements and other requirements from teh client through survey, JAD sessions and defined both functional and non-functional requirements.
• Acted as a UI Designer (Photoshop, Illustrator, ASP, C++, C#, HTML) to develop screen mockups, wireframes and prototypes to explore teh customer on-boarding experience and made improvements to existing web pages.
• Designed ER diagrams and models by using ERwin and MS Visio, and developed test cases and tracked bugs with Atlassian JIRA.
• Developed use cases and used Rational Rose to draw process flow diagram, develop activity diagram, class diagram, and sequence diagram that ca help validate different business process in teh loan pre qualification system.
• Involved in data mapping and data migration activities to gather and migrate data in teh process of development and implementation to meet teh standards across teh data warehouse.
• Analyzed teh business structure of teh loan pre qualification system, integrated Dodd Frank Act and Customer Identification Program (CIP/KYC) with teh development team and teh compliance team.
• Wrote how-to tutorials to train customers about teh functionality of teh system.
• Conducted System Integration Testing (SIT) with QA and User Acceptance Test (UAT) with stakeholders to ensure teh success of teh implementation for responsible track.

Environment: RUP, UML, Rational Rose, Rational Requisite Pro, ERwin, XML, Excel, Word, Powerpoint, MS Visio

Confidential

Business Analyst / Quantitative Risk Analyst

Responsibilities:

• Performed current situation analysis and delivered several possible solutions from data migration and Business as Usual (BAU) perspective for Core Banking Replacement/Transition (checking, savings, CD, Liquidity Deposit, Fixed Term Deposit, CMS, Pooling, loans, credit processing, etc.) in support of management decision.
• Gathered, analyzed and documented teh user stories for teh need for new Actimize Fraud Detection module or re-usability of an existing module by survey, JAD session, and performing fit and gap analysis.
• Constantly partnered with project leads to ensure teh team is producing solutions that meet established standards, procedures and practices, address issues, risks and mitigation plans, and developed business requirement document including improved future state requirements which provides possible solutions of existing pain points related to deposits and withdrawals.
• Incorporated NICE Actimize Fraud Detection and Prevention solution package into existing risk assessment system to increase security and reduce risk for teh client.
• Involved with making appropriate commitments through story selection, sizing, and tasking and visualize user stories with MS Visio, and develop screen mockups, wireframes and prototypes to demonstrate current development status to stakeholders.
• Worked with front office, back office, middle office, and related project teams to control and monitor teh progress of teh data migration and to verify data to ensure teh success of teh transition.
• Performed data analytics with emphasis on liquidity risk, credit scoring, credit risk, behavioral models, loan loss and general purposerisk/profitability models with IBM Cognos as a Quantitative Risk Analyst.
• Proactively identified and removed blockers, facilitate frequent retrospectives, sharing metrics to identify and implement improvements for teh data warehouse.
• Documented test plans and test cases, and performed functional and regression testing and tracked bugs with JIRA.
• Created Data Migration Plan and performed system integration test to evaluate teh successfulness of teh Non-Disruptive Data Migration Process and generated related reports.
• ConductedUAT (User Acceptance Testing),documented and reported user feedbacks to management team, and developed materials (Quick Start Guide and User Manual)for different end users and assisted inclient for teh new system.
• Employed various statistical analysis methodologies including regression analysis, Kolmogorov-Smirnov (KS) and divergence.
• Utilized statistical analysis tools (SAS, SPSS, R, and MS Excel) to develop accurate and concise analytical results to deliver strategic solutions as a Quantitative Risk Analyst.
• Researched on teh profitability matrix and monitored teh overall performance of teh project with Oracle ERP Project Performance Reporting module.

Environment: Waterfall, IBM Cognos, NICE Actimize, Atlassian JIRA, MS Project, Oracle ERP, Word, Excel, MS Visio, HTML, SQL

Confidential

Junior Business Analyst

Responsibilities:

• Collaborated with project manager to define projectscope,risksand determined appropriate methodologies to apply based onscope/vision documents, and developed project time lines by using SAP ERP Portfolio & Project Management module from Core System Replacement/Transition perspective.
• Followed guidance from NICE Actimize Trade Surveillance package to investigate and improve teh coverage of non-compliant activities.
• Cooperated with Data Analyst to generate reports on Money Markets and Foreign Exchange Markets and analyzed teh related risks of them.
• Facilitated discussions involving key stakeholders to elicithigh level requirementsand estimate projectfeasibility, designed and conductedsurveyamong differentend users, and documentedbusiness requirementsaccording to interviews and user surveys.
• Mediated users and stakeholdersconflicts on requirementsthroughJADsessions, and produced screen mockups, wireframes and prototypes to show to clients as well.
• Identified and documentedbusinessneeds and created detaileduse casesusingUML and MS Visio, and collaborated with production team to identify and map detailed existing processes and system gaps, and developedfunctional and non-functional requirements documentation (FRD and NFRD)that supported overall strategy, goals and objectives.
• Wrote SQL Queries extensively against different databases to perform tests on non-disruptive data migration to guarantee Business as Usual (BAU), generated related reports and analyzed them as per teh company and data warehouse requirement.
• Maintainedtraceability matrix using Rational Requisite Profor teh currentbusinessprocesses and proposed changes.
• Controlled, tracked and monitoredchange requestsusingRational ClearQuestto enable successful interactive development.
• Developedtest planswith QA team and helped to developtest scenariosforsystem testing,integration testingandperformance testing, and used JIRA for bug tracking.
• ConductedUAT (User Acceptance Test),documented and reported user feedbacks to management team, and developed materials (Quick Start Guide and detailed User Manual)for different end users and assisted inuser for teh new system.

Environment: NICE Actimize, RUP, UML, Atlassian JIRA, Rational Requisite Pro, Rational Rose, Rational ClearCase, Rational ClearQuest, Java, SAP ERP, SQL, HTML, Excel, Word, MS Project, MS Visio