SUMMARY

• 9 years of experience as a Business System Analyst in industry domains including Mortgage, Retail Banking and Insurance .
• Proficient in Anti Money Laundering (AML), Bank Secrecy Act (BSA), Comprehensive Capital Analysis and Review (CCAR), AML - KYC, BASEL II and III, and Dodd-Frank Act. In-depth knowledge of NICE Actimize Suite.
• Knowledge of Reverse Mortgag e, Mortgage Loan Origination, Servicing, Closing, Mortgage Backed Securities (MBS), Loss Mitigation, Loan Modification, Appraisal, Credit, Income and Title functionalities
• Experience in CCAR - Credit, Operational and Market Risk and FR Y 14 M/Q/A reporting.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services.
• Good experience in Data Modeling with expertise in creating Star & Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin.
• Strong Data Quality Management background performing analysis, monitoring and tuning to maintain data integrity.
• Experience in SQL; experience in creating database tables, writing stored triggers, select statements, JOINS, views.
• Ability to collaborate with peers in both business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities.
• Good understanding at Data Warehousing concepts including Extract, Transform, Load (ETL), Meta Data, Data Marts, Fact/Dimension Tables, and Dimensional Modeling.
• Organized and facilitated project planning, daily stand-up meetings, reviews, retrospectives, sprint, release planning, demos, and other Scrum-related meetings.
• Extensive experience in project management best practices, processes, & SDLC methodologies including Waterfall and Agile (Scrum).
• Ability to understand current business processes and implement efficient business process.
• Expertise in defining scope of projects based on gathered Business Requirements including documentation of constraints, assumptions, business impacts & project risks.
• Interviewing Subject Matter Experts, asking detailed questions and carefully recording the requirements in a format that can be reviewed and understood by both business and technical people.
• Worked in various technologies such as XSLT, XPATH, CSS, XML, and HTML.
• Knowledge of Test Plans, providing Test Data, conducting unit test, documenting test cases and in Manual Testing - Functional, Database, Black Box, Positive-Negative, and Regression testing .
• Experience in writing User manual, conducting functional walkthroughs, and in performing extensive User Acceptance Testing (UAT).
• Articulate, confident, and able to communicate comfortably with all levels of the company

TECHNICAL SKILLS

Business Analysis Skills: Scope Initiation, Business Proposals, Requirements Definition, Problem Resolution, Structured Walkthrough, Workflow Analysis, Gap Analysis, Design Review, Business Process Management, Product Management, Business Impact and Risk Analysis, Gate Review, Confirmations, Post-Implementation Review, Defect Management, Data Analysis, Data Reconciliation, Data Governance and Data Management.

Project Management Skills: Change Management, Client Relationship building, Risk Management, Strategic Planning and Reporting, Technical Writing, Budget Planning & Cost control, Vendor Management, Strategic Change Management, Onsite-Offshore Management, Virtual team Management.

Testing Tools (QA): HP ALM, HP Quality Center/Test Director, HP Performance Center/Load Runner

Business Process Modeling: UML/ Use Case Diagrams, Class Diagrams, Object Diagrams, Package Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Communication Diagrams, Component Diagrams, Deployment Diagrams, Process Flow, ER Diagrams and Data Flow Diagrams (DFD)

Database: SQL Server, Mongo DB, Oracle 11g, 10g, Oracle 9i, Oracle 8i

Oracle Applications: Oracle 11i &R12 - GL (SLA ), AP, AR, FA, CE, OM, PO

Languages: SQL, PL/SQL, UML, C# ASP.Net

Operating Systems: MS-Windows

MS Office: Word, Excel, Outlook, PowerPoint, Visio, Project

Methodologies: Project Life Cycle (PLC), Agile Project Management (SCRUM), Release Management, Change Management, Systems Development Life Cycle (SDLC), IBM Rational Unified Process (RUP), Prototyping, Test Methodologies (Equivalence partitioning, Boundary value analysis and error guessing)

Collaboration Tools: Microsoft Live meeting, WebEx Products, SharePoint

Other Tools: IBM Blueworks, Sketch, Tableau, Informatica, Cognos, Guidewire 6.0, Actimize (AML), Axiom SL, Encompass, Axure, JIRA, IBM Rational Rose, Smart Draw 2008

PROFESSIONAL EXPERIENCE

Confidential - Irving, TX

Business System Analyst

Responsibilities:

• Performed Project Reconnaissance and acquired understanding on the project and it’s scope.
• Worked with Project Manager, Development Team Lead to understand the scope of the project.
• Acquired knowledge on business model for Reverse Mortgage and studied Business Process Flows to recreate them in relation to the project.
• Interviewed business users to gather business requirements and created user stories.
• Interacted with Business Users to get better understanding on the business and clarify business requirements.
• Investigated Due and Payable Events for both cases: Death & Non-Death and created Happy Paths followed by documenting the exceptional cases
• Created Mockup Screens for the DI Tool using Sketch.
• Created Business Process Flows, DI Tool Functional Frameworks initially using Microsoft Visio and later on IBM Blueworks.
• Worked in Scrum methodology and attended scrum meeetings: Sprint Planning, Daily Standups, Sprint Review, Sprint Retrospective, and Product Backlog Grooming Sessions
• Attended Product Baclog Grooming Sessions to refine the PBIs to granular level.
• Wrote user stories for DI Tool User Interface and to expose various databases to the DI tool.
• Worked with ETL Developer to integrate and call data from multiple sources to the DI tool whenever they are updated in the source systems.
• Created and refined user stories for usage of exposed data from various databases in the DI Tool.
• Created document to create triggers to the DI Tool and document how these triggers will inititate and populate corresponding fields in DI Tool in any event for a loan file.
• Examined the data available in an existing data source and analyzed the content, structure and relationships within data.
• Gathered data from source system for analyzing & reporting and identified the data quality issues in source, transformation process & business rules.
• Involved in database validation framework in order to develop the functional solution for the exceptions.
• Liaised with other region BAs to understand the business rules in the data mapping to analyze
• Analyzed Stored Procedures used to create Master Table for Debenture Interest to validate data and improve the existing model.
• Worked with Development team to translate the business requirements into code.
• Conducted meetings for Data Extraction and Data Utilization with Business Users and Dev Team.
• Worked on VSTS as Project Management Tool to keep track of Product Backlog and progress of the project.
• Performed Data Validation using SQL
• Executed SQL Queries and performed review of ETL Job in Microsoft SQL Server Management Studio.
• Performed Data Analysis on source systems in regard to data integrity issues.
• Performed Data Mappings between two different source systems needed for the execution of the Tool.

Confidential - Plano, TX

Sr. Business System Analyst

Responsibilities:

• Examining the data available in an existing data source and analyzed the content, structure and relationships within data.
• Gathering data from source system for analyzing & reporting and identifying the data quality issues in source, transformation process & business rules.
• Involved in database validation framework in order to develop the functional solution for the exceptions.
• Involved in project plan, captured high level plans and SIT(System Integration Test) plan in Microsoft Project Standard (MPP) as per client’s requirement.
• Liaised with other region BAs to understand the business rules in the data mapping to analyze and build similar one for other regions.
• Validating functional specifications and creating flowchart for each scenario.
• Analyzed and mapped the original source data to case management tool (Actimize) & rule engine (Mantas) on a field by field basis.
• Well versed in conducting comparative study/analysis from BRD, FRD right through TDD.
• Ability to write basic SQL queries to validate data.
• Reviewed and analyzed the deposits/withdrawals made in the Confidential accounts within AMER region to identify the money laundering & terrorist financing activities for Corporate & Individual clients.
• Performing analysis on customer’s Basic Information, KYC records & CDD/EDD information.
• Investigated the transactions to identify the source of funds (SOF) and purpose of funds (POF).
• Screening customer’s name/entity for any negative news on customer regarding money laundering or terrorist financing using NESS and World Check.
• Raised additional information requests to branches to clarify the purpose of transactions and written reports to disposition the suspicious transactions in order to escalate further.
• Strong understanding of common money laundering schemes as well as AML legal and regulatory environment, laws, regulations, and guidance under the BSA and the USA PATRIOT Act.
• Recommended compliance team to file Suspicious Activity Reports (SARs) for potential money laundering cases.
• Ensured the implementation of anti-money laundering (AML) and know your customer (KYC) procedural check; carried out sanctions screening on the entire transactions of every business day.
• Manage Anti-Money Laundering/Know Your Customer (KYC) data remediation initiative by validating business rules across multiple applications according to customer role, reporting on missing data and clean data updates across multiple systems-of-record.
• Analyze the existing Fraud detection rules that are documented in Actimize - Policy Manager
• Examine and research accounts in internal and external databases (i.e., Lexus Nexus) to identify which information is complete, missing, inaccurate, etc. Perform data entry and database maintenance for this information.

Confidential - Foothill Ranch, CA

Scrum Master / Business Analyst

Responsibilities:

• Generated a streamline process to understand the various steps in the Loan Lifecycle and desired functionality of the new system by interacting with users, management, SME, stakeholders, Lenders and underwriters.
• Facilitated and managed meeting sessions with committee of SMEs from various business areas including Mortgage Servicing, Loan Monitoring, and Asset Management.
• Facilitated all 4 ceremonies Sprint Planning, the "Daily Stand-up", Sprint Retrospective and Sprint Review / demonstrations.
• Worked with Product owner on artifacts such as Product Backlog, Sprint Backlog, Sprint Burn down and Release Burn down.
• Encouraged team to actively participate during story time and break down the stories as granular as possible
• Performed Cost Benefit Analysis and also researched impact of integrating Calyx instead of Encompass as the new LOS.
• Gathered requirements from business users and analyzed them using Rational RequisitePro.
• Prepared and analyzed AS IS and TO BE in the existing architecture and performed Gap Analysis.
• Documented functional specifications to automate the loan approval process for home Mortgage (online application, workflow - for the credit department, upon approval the system routes the application to the underwriters for review).
• Worked closely with Legal Department to implement any required changes due to root cause analysis findings of laws related to loan origination processes, including TILA, RESPA, HELOC etc.
• Gathered business requirements through interviews, surveys, and observing from account managers and UI (User Interface) of the existing Brokerage Portal system.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams, Object-oriented Design (OOD) using Rational Rose according to the UML methodology.
• Implemented the entire Agile Methodology of application development with its various workflows, artifacts and activities.
• Acted as a liaison between business users and system development team during development process.
• Implemented a suitable Change Management process and supported the existing banking solution upgrade by coordinating multiple projects.
• Conducted user interviews, gathered requirements, analyzed the requirements by using Rational Rose, Visio and Requisite pro.
• Supported IT & Risk Management in Business Continuity Planning for Item Processing department.
• Developed and maintained the project plan using MS Project.
• Conducted interviews with clients for the purpose of gathering product requirements and understanding the client workflow.
• Created a RACI matrix based on the organization standards for ongoing operations and issue resolution procedures.
• Worked with the Quality Assurance team to create Test Plan and Test Cases and conduct unit integration, and system testing.
• Participated in developing of Training Materials for the new technology and User Training.

Confidential - Pittsburgh, PA

Business Analyst

Responsibilities:

• Interviewed business users to gather business requirements and created Business Requirements document (BRD).
• Participated in knowledge transfer meetings and discussions with consumer management and BSA/AML Officer.
• Translated the business requirements into functional specification document (FSD).
• Ensured that the business need as defined by the Product Owner are met by the Agile team.
• Conducted several user interviews and/or facilitate group sessions to identify business requirements including decision process needs, information sources, access privileges, and company standards. Also, conducted user story sessions, discuss user stories, capture story points and acceptance criteria
• Analyzed financial transaction data from multiple data sources including Databases, CRM, flat files to be mapped to the application database.
• Created clear, complete and accurate documentation of user requirements and business process workflows.
• Conducted data analysis in excel using Pivot Tables and created data mapping from multiple sources such as Excel file, CRM and Relational Databases.
• Created complex SQL query to extract transaction related data from multiple source for data validation.
• Monitored suspicious transactions and compiling and reporting associated currency transaction reports (CTRs) and monetary instrument logs (MILs) generated by Actimize AML.
• Worked with technical team to help them in creation of databases based on different red flags.
• Identified and understood relationships among internal systems problems, issues and data.
• Served as a liaison between business users and development teams to compile, analyze and interpret information related to complex business and systems processing.
• Conducted Gap Analysis by creating Swim lane diagrams and highlighted the differences between the Current (AS IS) environments versus the Target (TO BE) environment .
• Worked with a team of 5 quality analyst/testers within Agile Methodology.
• Defined and delivered test strategy, plans, and systems scripts.
• Validated different data sources to ensure alignment with the business requirements.
• Conducted through testing to make sure the application is developed as per the business requirements.
• Create UAT test plans and test scenarios & cases.

Confidential

Business System Analyst

Responsibilities:

• Gather requirements through users interviews, teleconferences, document analyses, use case analyses and UML diagrams for user stories creation and obtain timely sign-off by all respective parties.
• Help prepare for CCAR reporting schedules (ex. FRY 14A/Q/M & 9C).
• Meet with financial analysis team and financial reporting team to gather their requirements on data.
• Participate in data modeling, data analysis and requirement documentation.
• Lead Sprint Planning & Estimation sessions, Sprint Retrospectives and Reviews.
• Develop detailed level process maps to facilitate requirements gathering for projects and trainings.
• Conduct data verification on projection data warehouse.
• Design logical models using Star schema. Constructed a credit Fact which could be sliced and diced by various dimensions like Product, GL, Asset Class, Geography.
• Define, documented and translated high level business requirements into detail system specifications.
• Identify and analyze business problems and defined the scope of activities required to address issues, including requirement definition, process review, impact assessment and operational streamlining where necessary.
• Prepare FRDs that help drive the design of the infrastructure necessary for the organization to meet new CCAR reporting requirements.
• Help with the remediation and mapping of data going into reporting systems.
• Conduct data verification on reporting data warehouse.
• Extensively involved in Data Governance process. Assisted in data grouping and defined relationship among the different tables.
• Participate in configuration of IHC Reporting System and other in-house reporting software /systems.
• Support the Project manager in planning, executing, controlling and closing phases of projects.
• Work with the development team to define system specifications based on the business requirements gathered by Prototyping and JAD sessions.
• Design and implement basic SQL JOIN queries for QA testing and validate reports generated in Axiom.
• Performed System Integration testing, User Acceptance Testing and created test cases and test scripts.
• Use SharePoint to store, organize, share, and access information from almost any device.