SUMMARY:

• A competent, results - driven Business Systems Analyst with 7+ years of experience in Banking, Mortgage and Healthcare Industries. Expertise in Business Analysis, Business Requirement Gathering, Business Process Modeling, Business Flow Diagrams, Business Requirement Documents across diverse teams in various Software Development Lifecycle (SDLC) methodologies. A motivated self-starter with excellent organizational, analytical, communication and interpersonal skills. Detail and goal-oriented analyst with proven leadership skills. Hands on working with the QA teams and leading UAT efforts.
• Diverse experience in banking domain with strong knowledge of the business models and processes.
• Designed and reviewed various documents including Business Requirements Document (BRD), Functional Specifications Documents (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents.
• Expert in developing Use Cases, Sequence diagrams, Activity diagrams, Collaboration diagrams, Class diagrams development and UML modeling using modeling tools like Rational Rose and MS Visio.
• Experience in conducting Joint Application Development (JAD) sessions with stakeholders and other project team members for requirements gathering, analysis and design.
• Interacted extensively with Under Writers on them and getting their requirements.
• Requirements were gathered through interactions and meetings and periodic walkthroughs with loan analysts, credit analysts, Under Writers and other potential users of the application.
• Knowledge in AML investigations, Alert Operations, KYC, Due Diligence and sanctions.
• Understanding of different mortgage instruments like Mortgage Backed Securities MBS, Collateralized Mortgage Obligations CMO, Asset Backed Securities ABS, including the tranche structuring and credit enhancement processes to manage prepayment and credit risk.
• Extensive experience in using MS Office (Word, Excel, Visio, Power Point, Outlook, and Project) for calculations, graphs, analysis, presentation and documentation throughout the project.
• Expert in coordinating work plan between Project Manager and the client with Microsoft Project.
• Experience in Agile and Agile/Hybrid methodology by providing extensive support to Product Owner and Scrum Master during Sprint Releases, Sprint Planning Meeting and Sprint Retrospective Meetings.
• Experience in Waterfall and Rational Unified Process (RUP) Methodologies in various phases of Project Lifecycle (PLC) and Software Development Lifecycle (SDLC).

PROFESSIONAL EXPERIENCE:

Business Analyst

Confidential, San Ramon, CA

Responsibilities:

• Documented business specifications from the client, users, developers, designers and Subject Matter Experts.
• Assisted in preparation and maintenance of the LAR for HELOC and Mortgage loans while ensuring all HMDA reporting requirements are met.
• Conducted JAD sessions with various stakeholders to develop the design and architecture of the application based on the business requirements, discuss and resolve open issues, discuss and document change requests.
• Developed and documented Functional Requirement Specifications (FRS) and User Requirement Specifications (URS).
• Documented and transformed business process and application requirements into technical specifications and functional specifications
• Analyzed business requirements and segregated them into high level and low-level Use Cases and Activity Diagrams.
• Documented the specifications for reporting needs and validated the data and evaluated reports using SQL queries.
• Incorporated the best practice methodologies to develop a structured approach during the overall Software Development Life Cycle
• Gathered requirements and assisted in creating epics and user stories for the product backlog.
• Collaborated with the Product Owner to create and prioritize Product backlog and worked with developers during evaluation of user stories during Sprint planning meetings.
• Participate in daily scrum meetings to assess the product status.
• Presented Weekly/Monthly Project Status reports, wireframes, mockups and demos describing the status to date, impact of issues and changes in requirements necessary to the clients and getting sign off from them for the same.
• Interacted and worked with Developers to resolve the functionalities, features, technical and implementing issues.
• Involved in the end-to-end User Acceptance Testing to validate the overall output of the system with the business requirements.
• Monitor stakeholder expectations through involvement and communication throughout the lifecycle of the project, educate clients and stakeholders on the benefits and risks associated with the project
• Responsible for creating UAT test plan, identifying UAT in scope and out of scope testing, risk and mitigation and test procedures.
• Created UAT test cases and reviewed with team to ensure all the requirements are addressed
• Conducted UAT workshop in coordination with business user and ensured sign off by them
• Identified UAT defects and assigned to developers.
• Facilitated UAT defect call and made sure all the defects are tracked and closed properly

Business System Analyst

Confidential, Dallas, TX

Responsibilities:

• Liaison between Business Teams of SHAW Loans, SHAW Lease, and Bluestem and IT team to elicit Data Migration requirements and optimize current workflows.
• Responsible for coordinating and consolidating with Business Partners from various Lines of Businesses, Senior Managers, and other team members to analyze and determine the structure of various relational database systems.
• Conducted Gap Analysis for current source systems to effectively define the requirements for the target systems and created Source to Target Mapping documents and provided detailed effort estimation analysis to managers, developers, QAs, and other cross functional teams.
• Documented, refined, and managed Functional (Technical) and Non-functional requirements and also trace them back in each phase of the project for potential system changes and enhancements.
• Performed rigorous data analysis by developing and implementing complex SQL Queries to check Data Quality, and to define the Profile of Data for future applications of data in Business efficiency.
• Applied required transformation logics on data sets to clean, slice and dice the data by executing SQL Query. Also performed data validation to prepare the data to load into the Enterprise Data warehouse.
• Leveraged ETL tools such as Informatica to automate the data flow for various data elements within the ecosystem of Operational Systems and Enterprise Data Warehouse. Also created system catalogues for all the elements within the physical model of the Enterprise Data Warehouse for all portfolios.
• Reviewed already sourced systems such as AFS (Automated Financial Services), Data Scan, Corporate Credit Cards, McCracken, and Infolease in the USA (Universal Staging Area) layer and came up with technical requirements for other source systems to be implemented in the Integration Layer.
• Recognized exceptions, issues and performed Root Cause Analysis to provide best course of action to improve data quality across SHAW Loans, SHAW Lease, and Bluestem systems under Santander Consumer USA.
• Profiled data, monitored data quality, and generated the metadata libraries which capture the business meaning of all data introduced in the Data Warehouse as part of each project.
• Actively involved in complete process of ETL (Extract Transform and Load) and performed ETL testing after the data has been loaded to Data repository (Data warehouse) and provided inputs and support to Data Architect, Developers and QA Teams to ensure end to end functionality implementation.
• Conducted data profiling and performed data quality analysis by using SQL Developer, Dreamweaver, and Excel Pivot Tables & Macros.
• Facilitated the UAT (User Acceptance Testing) effort for accounting team and other end users of the system to make sure the overall functionalities of the system and generated UAT Report for senior management.

Business Systems Analyst/UAT Analyst

Confidential

Responsibilities:

• Maintained a big picture view of the overall MSP work stream by working with the MSP Team and COE leaders to understand their ongoing and new project/initiatives/artifacts.
• Coordinated meetings/communications with stakeholders that engage with the MSP Team as well as captured of action items, parking lot items, or follow-up actions.
• Assisting in managing team's daily work volume and manage workflow to ensure deadlines are met in accordance with existing SLAs and maintaining up to date reporting metrics.
• Supporting Confidential partners with research, follow-up and resolve escalated issues and problems through effective interaction with bankers, Industry Risk Officers, Compliance, QC/QA Teams, Audit, and other staff in a timely and professional manner.
• Developed business Use Cases using UML for new product functionality after conducting requirements elaboration sessions with SME’s.
• Identified and documented issues, risks and Gaps, their descriptions, their impact and provided recommendation and alternatives to develop the application to meet the user requirements.
• Validated functional specification documents at the workshops and gained sign-off from the users.
• Used MS Visio for flow-charting, process model and architectural design of the application.
• Worked in hybrid environment with waterfall implemented in initial phase and Agile for development phase.
• Used tools such as MS SharePoint and JIRA to track sprints, allocate resources and generate reports.
• Developed the systems implementation project management plan with milestones and steps from procurement of vendors to project implementation and maintenance.
• Involved with QA team to determine & develop test approaches & methods for unit, integration, functional, load & performance testing according to application complexity & test requirement.
• Coordinated User Acceptance Testing (UAT) with users to created test scenarios, test plan, test case and to provide appropriate .
• Created UAT test plan and documented testing scope for UAT Testing team
• Created UAT test scenario and UAT test cases and provided direction on what to test and how to test
• Provided UAT Status reports to Upper Management which provided UAT test execution status and any roadblocks.
• Created RTM (Requirement Traceability Matrix) for all UAT Test cases to make sure there is complete Test Coverage
• Led UAT efforts by staging UAT environment and scheduling UAT execution.
• Identified and opened UAT defects and assigned it to development team.
• Tracked progress of UAT defects and ensured fixes.