SUMMARY

• 8 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 Mortgage Loan Origination, Servicing, Closing, Mortgage Backed Securities (MBS), Fannie Mae, Freddie Mac, 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 gatheird 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 dat 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: 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: Tableau, Informatica, Cognos, Guidewire 6.0, Actimize (AML), Axiom SL, Encompass, Axure, JIRA, IBM Rational Rose, Smart Draw 2008

PROFESSIONAL EXPERIENCE

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 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 the each scenarios.
• 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 dat are documented in Actimize - Policy Manager
• Examine and research accounts in internal and external databases (me.e., Lexus Nexus) to identify which information is complete, missing, inaccurate, etc. Perform data entry and database maintenance for dis information.

Confidential - Foothill Ranch, CA

Scrum Master

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 areasincluding 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.
• Gatheird 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.
• Acquired in-depth knowledge of the Mortgage industry and understanding of the Fannie Mae and Freddie Mac underwriting guidelines.
• Gatheird 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, gatheird 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 dat 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 - Providence, RI

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 dat 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 gatheird 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.

Confidential - Quincy, MA

Business Analyst (Guidewire)

Responsibilities:

• Worked extensively on Guidewire Policy Center & Guidewire Claim Center.
• Used GuideWire to track the claims of the policyholders.
• Guidewire was specifically used by the team to implement the enhancement to expedite the claim process for unregistered users.
• Used GuideWire to upgrade the current Claim system to track the claim of the policyholders and third party applications.
• Interacted with business team to demo the out of the box features of Guidewire Policy Center PAS.
• Collaborated with Business Partners to identify and solicit business requirements for projects using various requirement gathering processes like JAD, Interviews, Brainstorming and questionnaire.
• Interacted with Business group and provide valuable suggestions on System functionality in finalizing the requirements for the project.
• Worked on GW Policy Center configuration with Business stakeholders to understand the existing flow of PAS.
• Prepared story cards based on different tabs/screen such as Summary Page, Insured Information, Driver, Vehicle, Property, Underwriting and Bind/Issue etc.
• Performed GAP analysis to compare the existing system with the proposed system and documented new requirements and features.
• Facilitated numerous Joint Application Development (JAD) sessions utilized for the creation of design documents and system specifications for applications.
• During development sprint, documented user stories around Integration of Policy Center with Billing Center.
• Retrieved Data using PL/SQL queries and did Data Mapping and Data analysis.
• Worked to create Data Mapping Documents and worked with business to write transformation rules through PL/SQL.
• Played a key role in the planning, testing, and implementation of system enhancements and conversions.
• Performed Data Analysis and data manipulation of source data from Oracle Server and other data structures to support the business organization.
• Domain-focused testing with a test case repository to accelerate test planning and design, and reduce dependency.
• Custom-built functionality around process areas such as new business and underwriting, billing, claims and policy administration.
• Well developed knowledge of Insurance principles such as various types of ratings, underwriting and renewals.
• Rules engine deployment for improved underwriting performance.
• Domain-focused testing with a test case repository to accelerate test planning and design, and reduce dependency.