SUMMARY

• I Have 8 years industry experience of as a Business Analyst identifying business needs and determining solutions to business problems for Lending and finance domains.
• Knowledge in Developing and designing visualizations for management and clients covering a variety of performance indicators using Tableau or Excel.
• In - depth knowledge of Rational Unified Process (RUP) risk engineering; data modelling and mapping; and design using UML, Rational Rose, Visio and other related tools.
• Adept at creating and compiling reports, stories and dashboards in Tableau and knowledge on Quick View, Data Warehouse, ETL.
• Create SQL statements to identify specific loan population and other key data points for drill-down analysis.
• Elicited & documented capabilities and process requirements for the end-to-end loan life cycle (LOS) on Loan Sphere Lending space LOS tool in compliance with the recent regulatory Changes.
• Administered Identity and Access Management, includingpassword managementcontrols for staff and vendors assigned to department-level projects.
• Demonstrated ability to work actively in different phases of SDLC, Agile/Scrum in teams, fostered cooperation and collaboration among individuals in the work unit and helped team resolve conflicts constructively.
• Effectively facilitates gathering, analysis, prioritization and categorization of complex business requirements & Business Rules for Encompass360, Loan Sphere Empower, Configurations, Customization and Enterprise-wide setup.
• Worked on the mock-up diagrams using MS VISIO and provided the screenshots replicating the changes to the User Interface (UI) as per the requirements.
• Excellent in SQL and Tableau with extensive experience on analysing large datasets, business intelligence, data mining, predictive modelling, data visualization and data governance.
• Experience in interacting with SMEs to collect Business process requirements, documented them in Business Requirement Document (BRD) and performed Business Process Re-engineering, product support.
• Expertise in MS Office, MS SharePoint, MS Visio, JIRA, with hands on experience in Data Analysis and Reporting using Advanced MS Excel, SQL. Hands-on experience in Database Management Systems such as SQL Server and Oracle.
• Proficient in creating BRD (Business Requirement Document), TRD (Technical Requirement Document), FSD (Functional Specification Document) and UAT Documents, Use Case Narrative & Use Case Diagram.
• Expert at Risk Management by Risk Identification, Impact Assessment, Prioritization Analysis, Risk Tracking and Mitigation with monitoring of whole.
• Comprehensive understanding and experience of SDLC and project life cycle methodologies such as Waterfall, Agile, Rapid Application Development (RAD), and Rational Unified Process (RUP).
• Expertise in Database Administration of Test Environment Databases, Data Pools and identifying performance issues due to inefficient Database Administration.
• Excellent writing skills in generating, Project Charter, Project Plan, Business Requirements documents, Use Case Specifications Test Plan, Credit Risk Management Plan Liquidity risk assessment, and Publishing Regular Reports with status and metrics.
• Vast experience in performing SDLC tasks - Requirement gathering, Analysis and Feasibility, Creating Business Requirement Document (BRD), Transforming BRD to Functional Specification Documents (FSD), High Level and Low-Level Design documents etc.
• Conducted GAP analysis in order to capture functionalities of existing systems and analysis requirements of the proposed system followed various SDLC methodologies which include AGILE Scrum, AGILE Extreme.
• Manage testing and create comprehensive testing scripts for a project involving the addition of new enhancements in Loan IQ. In addition, create general regression scripts in Loan IQ for use in major software upgrades. Assisted in coordinating the consolidation of global testing across multiple projects.
• Experience in conducting Gap analysis, User Acceptance Testing (UAT), SWOT analysis, Cost benefit analysis and ROI analysis.
• Experienced in working with Testing team, participated in writing Test Plan, Test Cases, Test Scenarios, RTM, Test Reports, and conducting various forms of testing, which include Integration Testing, Smoke Testing, Regression Testing.

PROFESSIONAL EXPERIENCE

Sr Business Analyst

Confidential, Pleasanton, VA

Responsibilities:

• Helped with Data Mapping between the data mart and the Source Systems. Performed data mapping by executed SQL scripts at the backend database level to ensure the correctness of the test results.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction.
• Analysed relational data with SQL to quickly understand existing data stores and to validate source/target mappings and transformation logic.
• Extensively used Excel, SQL programming and Tableau for data mining, predictive & quantitative analysis, designing, reporting and visualization.
• Involved in building the ETL pipelines using a combination of python, oracle scripts and the Tableau dashboards for reporting.
• Involved in Analysis of gathered requirements data, verification of requirements and creation of business requirement specifications (BRS). Extensive Knowledge of Loan IQ Data Model.
• Support Loan Operations by reviewing critical issues and breaks, utilizing Subject Matter Expertise in Loan IQ functionality to determine appropriate solutions based on current business practices. When appropriate, work with development and IT to coordinate challenges that require a more complex solution.
• Worked with the Database team to assist in implementing all stages of development processes including extraction, transformation, and loading (ETL) data from various sources into Data warehouse and Data Marts using Informatica Power Center Designer.
• Hands on Loan origination for secured and unsecured products, Retail credit risk assessment models, Mortgages, Asset Based Lending, International Payment Systems
• Assisted in using Tableau as data visualization tool to communicate information clearly and efficiently via statistical graphics and to create executive dashboards, weekly/monthly reports on the status of key business measurements.
• Involved in various types of data conditioning to verify if Loan IQ sent the valid data to different interfaces such as ACH, Web OD.
• Responsible for the quality of all changes to Empower, the Confidential loan origination system for the Retail branches.
• Hands on well-known Commercial Lending product Misys Loan IQ on all modules with expertise on accounting.
• Responsible for analysing and translating business requirements for the development of business rules and system rules for Retail banking. Performed in-depth analysis and gathered business requirements for client’s website redesign project.
• Responsible for defining and designing commercial lending loan approval process which resulted in data collection and analysis compliance. Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market.
• Captured UML diagrams like Process Flow Diagrams, Sequence Diagrams to complete the migration process on Trading platform.
• Involved in Walk-through sessions with developers and gave presentations to help them understand the end user needs.
• Manage testing and create comprehensive testing scripts for a project involving the addition of new enhancements in Loan IQ. In addition, create general regression scripts in Loan IQ for use in major software upgrades. Assisted in coordinating the consolidation of global testing across multiple projects.
• Maintaining a Requirement Traceability Matrix (RTM) to ensure that all Functional Requirements are addressed at the Use Case Level and matched with the Business Requirements.
• Worked on managing bugs using Defect Tracking Tool JIRA, reviewed each defect and assigned development team to resolve problems.
• Worked on Preparing the SDD (Story Definition Document) for the Loan Origination System. Analysed business requirements for testing phase during execution of loan origination system (LOS).
• Collaborating with QA team to create and implement test plan and test cases for User Acceptance Testing (UAT). Involved with the whole UAT to ensure the performance of the system and application.

Business System Analyst

Confidential, Westlake Village, CA

Responsibilities:

• Worked as a Business Analyst, leveraging the knowledge gained for migrating the Commercial Lending Process from existing AFS Application to the new application platform Loan IQ, mainly focusing on the Commercial Lending Servicing process.
• Involved in creating Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Creating Business Requirement document (BRD) and Functional document (FSD) for all credit risk initiatives for retail and commercial TD business like Home Loan, Home Equity Line of Credit, Mortgage, Deposits, TD Cards, Auto, Credit Cards.
• Involved in Writing SQL Queries for Business applications to validate data using Teradata, SQL.
• Involved in created various Tableau visualization using Tableau Desktop applying the best practices of report design. Used a range of Tableau features such as: Bullet Charts, Maps, Filters, Actions, Data Blending, Parameters etc. Ensured the data accuracy by comparing data checks at source data, database and on the reports.
• Involved in categorizing Mortgage Pre-payment risk, Risk Analytics for MBS, Loan Origination, Loan Servicing, MBS, CMBS, Secondary Mortgage Market, Non-Escrow Loans Collateral Inspection and Monitoring, Property Inspection, Income and Expense Statement Review, and Inspection Report.
• Involved in developing mock-ups and wireframes of dashboards and reports for Tableau Desktop.
• Involved in designing and developing Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML and Business Process Modeling.
• Worked on gathering requirements through user's interviews, teleconferences, document analyses, use case analyses and UML diagrams for BRD and user stories creation.
• Collaborated closely with other Financial Institutions to monitor customer transaction histories.
• Involved in conducting several Joint Application Development (JAD) sessions for gaining detailed requirements and finalizing Business Requirement Document (BRD).
• Worked on managing complete resolution cycles of data feed issues including analysis of the issue and identifying fix, implementing and testing the changes, updating functional specifications and releasing changes into production.
• Involved in Inception Phase and prepared Logical Data Models that contains set of diagrams and BRD's (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyse and document business data requirements.
• Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modelling Language) methodologies.
• Manage testing and create comprehensive testing scripts for a project involving the addition of new enhancements in Loan IQ. In addition, create general regression scripts in Loan IQ for use in major software upgrades. Assisted in coordinating the consolidation of global testing across multiple projects.
• Worked on the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
• Attended User Acceptance Testing, gathered and documented User Manuals and Business Rules.

Business Analyst

Confidential, Coppell, TX

Responsibilities:

• Great interpersonal skills and the ability to deal with all levels of business users and management.
• Collaborative skills working across teams and lines of business in the Front Office trading floor, Middle Office and Back Office environments.
• Built interactive Tableau dashboards and published Tableau reports utilizing parameters, calculated fields and table calculations, user filters, action filters and sets to handle views more efficiently.
• Worked collaboratively with Business Intelligence and ETL resources to design and develop effective solution.
• Worked on Business Intelligence reports development by working closely with MicroStrategy, Teradata, and ETL teams.
• Generated a streamline process to understand the various steps in the loan lifecycle and desired functionality of the new system by interacting with users, mortgage consultants, brokers, stakeholders and subject matter experts.
• Strong experience in credit on the condition that it shall be returned on payment of the debt within a certain period. Involved in (LOS) Loan origination System originating a loan vary by loan type, various kinds of loan risk and regulator, lender policy and other factors.
• Involved in developing Tableau visualizations to support Data Summary, Analytical Reports.
• Involved in d developing and maintaining sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting.
• Involved in preparing vision document, in/out list, and goal- actor lists for defining the scope of the project and the various functional and non- functional requirements involved in it.
• Worked on configuring the Data mapping between Oracle and SQL Server 2005.
• Involved in designing and implementing basic SQL queries for testing and report/data validation.
• Participated in discussing the defects created during the exception phase and its implementation in the Mortgage RX application before conducting the meeting with stakeholders for solution of the defect on scenario and sharing the solution based on experience as well.
• Interviewed the domain experts and carefully recorded the requirements in the format that can be reviewed and understood by both businesspeople and technical people.
• Framed a detailed agenda and conducted JAD sessions with different stakeholders and development team as and when necessary to create use cases.
• Understood and articulated business requirements from user interviews and then convert requirements into technical specifications using Agile methodology.
• Participated in sprint planning meeting to prioritize and determine level of work for PBIs in line with Agile Scrum methodology.
• Actively involved in requirements gathering and requirement management. Analysed requirements and segregated them into high level and low-level use cases.
• Involved in creating full life cycle documentation from product requirements in the developmental stage to functional specifications for the completed modules of application components.
• Worked on creating workflow diagrams such as Use-Case diagrams and Activity Diagrams to demonstrate software architecture and interaction of system components before prototyping using Enterprise Architect.
• Worked with developers and QA Analyst to clarify the System Requirement Specifications (SRS).
• Worked on developing requirement traceability matrix and attribute traceability matrix to manage changing requirements.
• Participated in enhancement meetings to make the product more effective in real time.
• Set up definitions and process for test phases including Product test, integration test, system test and user acceptance test (UAT) using Mortgage RX application.

Business Analyst

Confidential -Detroit, MI

Responsibilities:

• Performed acquisitions due diligence including credit valuation, site inspection, capital improvement, redevelopment, & asset management on a portfolio of commercial loans, commercial real estate loans, & real estate assets.
• Reviewed loan applications and analysed data required to process loan documents and performed validation to ensure loan documents are transmitted to appropriate departments.
• Provided leadership and directional management expertise to Business Analyst and Development teams including developers, programmers, architects, business analysts, quality analysts and quality control staff.
• Validate requests for modifications of IT asset data attributes which have been discovered in production environment.
• Prepare, compile, and analyse (data mining) client monthly deliverables and ad-hoc reports to include summary and loan level information.
• Hands in Developing and designing visualizations for management and clients covering a variety of performance indicators using Tableau or Excel.
• Involved in creating SQL statements to identify specific loan population and other key data points for drill-down analysis.
• Involved in maintaining meeting minutes, meeting agenda and communicated them with the SMEs and the stakeholders on timely manner using MS Word, MS PowerPoint and created reports using MS Excel.
• Involved in Data Analysis, Data Validation, Data Modelling, Data Profiling, Data Verification, Data Mapping, Data Loading, and Data Warehousing/ETL testing.
• Involved in testing UAT environment (creating/executing test cases and logging defect in JIRA).
• Maintained and created strong trustworthy business relationships with internal business units and vendors trade marking my strong analytical and project management skills.
• Worked with technical as well as business teams to create a project plan, tracking the schedule, managing the risks & change management.
• Involved in gathering requirements from the Subject Matter Experts (SMEs) and Stakeholders using various elicitation techniques and documented Business Requirements Document (BRD).
• Analysed the Business logic involved in calculations of the Risk event values against the LOBs.
• Involved in designing the User Interface prototype using wireframes, screen mock-ups during the process of requirements gathering.
• Identify monitoring gaps or failures during real time transmissions and proactively challenging business units for resolutions and enhancements.
• Analysed the various financial reports in General Ledger using Financial Statement Generator (FSG) so as to provide information in most relevant form to improve the process.
• Creative communication skills in working with business leaders, executive management, business process owners, user communities and IT solution providers.
• Engaging leadership skills to unite teams, implement change and transform organizations and make them a valued partner to the business.
• Strong experience in credit on the condition that it shall be returned on payment of the debt within a certain period. Involved in (LOS) Loan origination System originating a loan vary by loan type, various kinds of loan risk and regulator, lender policy and other factors.
• Closely worked with QA team in delivering detailed Test Plan, Test Cases and Scripts. Highly involved with unit testing, system testing and integration testing.
• Coordinated User Acceptance Testing (UAT), developed and maintained quality procedures and ensured that appropriate documentation was in place.

Business Analyst

Confidential -Reston, VA

Responsibilities:

• Involved in gathering Business & Technical Requirements, Source System Analysis, Gap Analysis, Data Profiling, Requirements Documentation for ETL development and report development.
• Worked on various statistical data analysis reports for corporate clients, provided ad-hoc updates and modified report templates as required.
• Reviewed loan applications and analysed data required to process loan documents and performed validation to ensure loan documents are transmitted to appropriate departments.
• Worked on business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping.
• Worked on business requirements, user requirements, design, technical specification documents.
• Worked with various business groups to understand their data analysis requirements and provided appropriate support to reduce the number of reports.
• Involved in implementation of Document Management System meeting requirement deadlines.
• Interacted with the SMEs and Stakeholders to get a better understanding of client's business processes.
• Interacted with business heads to define and finalize the Business Requirements for the application using Agile Methodology.
• Involved in SQL Scripting, Transactional Data Analysis and Reporting on MS SQL database.
• Perform comprehensive SIT and User Acceptance Testing to test the requirement and ensure User agreement.
• Involved in developing ad-hoc queries and reports and provide analytical support and recommendation as necessary. Successfully achieved complete cycle of ETL process by applying Data Migration best practices to ETL data from My SQL Cloud.
• Analysed relational data with SQL to quickly understand existing data stores and to validate source/target mappings and transformation logic.
• Involved in walkthroughs and validations on logical model and created physical data model using forward engineering.
• Involved in conducting JAD sessions for communicating with Stakeholders and Project directors.
• Involved in developing and maintaining sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting.
• Worked on Back End Testing by extensively using SQL queries to verify the integrity of the database.
• Closely worked with QA team in delivering detailed Test Plan, Test Cases and Scripts. Highly involved with unit testing, system testing and integration testing.
• Coordinated User Acceptance Testing (UAT), developed and maintained quality procedures and ensured that appropriate documentation was in place.