We provide IT Staff Augmentation Services!

Loan Origination System Analyst Resume

Los Angeles, CA

SUMMARY:

  • 8 plus years of experience as a Business Analyst with solid understanding of Business Requirement Gathering, Business Process Flow, Business Process Modeling.
  • Strong knowledge of Software Development Life Cycle (SDLC), Rational Unified Process (RUP) methodology, and Project Life Cycle.
  • Strong subject matter expertise in Fixed Income, Derivatives, Equities, Bond Pricing, Confidential Backed Securities, Annuity.
  • Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases.
  • Extensive experience in conducting Confidential sessions - participated in varied roles ranging from facilitator, preparing visual aids, setting goals and objectives, providing read-ahead materials to participants, etc.
  • Knowledge in Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures
  • Experience in writing SQL queries and optimizing the queries in Sybase, Oracle and SQL Server 2008.
  • Configured the Data mapping between Oracle and SQL Server 2008.
  • Well conversant with scripting languages like Java Script, VB Script, HTML, DHTML, and XML.
  • Written Use cases and have produced Use Case Models, creating Behavioral diagrams (use case diagram, Activity diagrams and Sequence diagrams) based on UML Methodology & Business process flow diagrams.
  • Proficient in the use of tools like Telelogic DOORS, Rational Rose, Requisite Pro, Rational ClearCase, Telelogic System Architect and MS Visio.
  • Extensive experience in documentation of business requirements and system functional specifications, including BRD, FRD, and FSD
  • Utilized a combination of business knowledge, technical skills, and strategic analysis to provide solutions and creative insights to critical business problems.
  • Effective in multitasking and effective management of assignments according to work schedules with strong project management orientation.
  • Capable of forming and maintaining positive and productive working relationships in internal, external, independent and team environment.

TECHNICAL SKILLS:

Business Modeling Tools: Rational Rose, Rational Enterprise Suite, MS Visio, Telelogic System Architect

Reqmts. Management Tools: Rational Requisite Pro, Telelogic DOORS

Change Management Tools: Rational ClearCase, Rational ClearQuest

Project Management Tool: MS Project

Analysis / Modeling tools: UML, Confidential, RUP, RAD

Testing Tools: Loadrunner, Test Director,Mercury Quality Centre

Operating Systems: MS Windows NT/98/95/2000, UNIX

Languages: SQL, UML, JAVA

Database: Oracle 8i/9i, SQL Server 2000, MS Access

Utility: MS Office Suite Word, Project, Excel, Visio, PowerPoint, Adobe Acrobat Suite

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

Loan Origination System Analyst

Responsibilities:

  • Worked with the business users to define business requirements and analyze the possible technical solutions.
  • Analyzed Business Requirements and segregated them into high level and low level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
  • Conducted user interviews, gathered requirements, analyzed, and documented Business requirements based on the analysis of the workflow model.
  • Conducted workflow, process diagram and gap analyses to derive requirements for existing systems enhancements.
  • Gathered and refined business requirements for a new auto loan origination implementation project.
  • Write Technical System specifications for Operational, Legal and Compliance enhancements or changes in Empower.
  • Gathered requirements and modeled the data warehouse and the underlying transactional database
  • Identify, evaluate, and address credit risk in the development, deployment, interpretation and maintenance of the Underwriting Guidelines in support of new Confidential products, performance issues or product enhancements
  • Facilitated and managed meeting sessions from business areas including Confidential Origination, Loan Processing.
  • Used MS Visio for Process modeling and Business Process flow diagrams.
  • Migrated Data from MS Excel to SQL Server Reporting Service Using DTS and SQL loader utilities.
  • Worked with multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Websphere and Cognos.
  • Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
  • Conducted interviews, meetings and Confidential sessions during the process of Requirement Gathering.
  • Facilitate Confidential sessions involving the management, development and user teams for clarifying requirements and facilitating better communication.
  • Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services (SSRS).
  • Review mortgages of informed borrowers/related parties for loans, marketing conditions, documents needed to close loan.
  • Process improvement to the enterprise application known as Empower
  • Responsible for numerous decisions in respect to business policies, procedures, methods for implementation. Confidential Pre-payment risk, Risk Analytics for Confidential, Loan Servicing, Loan Origination, Confidential, CMBS, and Secondary Confidential Market.
  • Execute effective Confidential marketing plans to meet and exceed Confidential production.
  • Provided documentation and report to Project Manager.
  • Loan origination and maintenance of credit files according to federal banking guidelines
  • Experience in Confidential conversion Testing and Reverse Confidential .
  • Worked extensively with MS Excel and MS Access to create Ad Hock reports
  • Analyzed the Business and System Requirements of the application.
  • Designed and developed project document templates based on SDLC methodology.
  • Co-author business requirements document with project teams. Extracted, discussed, and refined business requirements from business users and team members
  • Enhanced in office cultural competencies to empower employees to be their authentic selves and best serve their clients
  • Prepared Business Process Models that includes modeling of all the activities of business from conceptual to procedural level.
  • Interacting with the development and testing teams to improve overall quality of the software.
  • Developed Use case, Functional, Object diagrams using Rational Rose.
  • Analyzed user problems, including automated and manual business processes and identified, researched, investigated, defined and documented business processes
  • Act as a resource in understanding how IS systems carry out business functions and assists in ensuring the timely and effective implementation.
  • Responsible for the quality of all changes to Empower, the Confidential loan origination system for the Retail branches.
  • Worked under sprint Iteration model and gained expertise.
  • Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
  • Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.
  • Verified the Business Scenarios on new builds to allow extended testing by the QA team.

Environment: MS office 2003, Enterprise Architect, Visual Basic, SQL Server, Crystal reports MS Project, Rational Test Manager, Data Stage.

Confidential, Buffalo, NY

Loan Origination System Analyst

Responsibilities:

  • Gathered business requirements by conducting detailed interviews with business users, stakeholders and Subject Matter Experts (SME’s). Defined the scope of the project, financial projections and Cost/benefit analysis.
  • Used report mock-ups to establish the content and purpose of the reports
  • Implemented the entire Rational Unified Process (RUP) methodology of application development with its various workflows, artifacts and activities.
  • Conducted Confidential sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
  • Empower teams to self-organize and expand cross-functionality.
  • Created Web Layouts and Mockups
  • Constructed web layouts and GUI specifications using MS front page
  • Created new Loan and Serve application based on Life Cycle of the Loan Origination based on committee and risk approvals and reports using Microsoft Access/Excel/VBA/Dashboards.
  • Validated the various business processes with a committee of Subject Matter Experts (SME's) like Confidential Servicers, Underwriters, Credit Analyst etc, to ensure the rules and guidelines have been met.
  • Responsible for converting the business requirements into functional and non-Functional requirements.
  • Used UML and Confidential guidelines to document the existing and future process flows
  • Used mock-ups, user interaction list and additional documentation must provide enough information so that a developer can build the report.
  • Conducted GAP analysis to understand the shortcomings of the existing system and evaluated the benefits of the new system
  • Categorized report mockups
  • Responsible for the quality of all changes to Empower, the Confidential loan origination system for the branches.
  • Extensively used Rational Requisite Pro to gather and manage requirements. Created and managed project templates, use case templates, requirement types and tractability matrix in Requisite Pro.
  • Worked on report layouts and Mockups
  • Identified and developed Use Cases from the requirements. Followed the UML methodology to Create UML Diagrams including Use Cases Diagrams, Activity Diagrams, Sequence Diagrams, Collaboration Diagrams, Data Flow Diagrams (DFDs), ER Diagrams using Rational Rose and MS Visio and thus defining the Business Process Model and Data Process Model.
  • Structured submitted and completed loan application for processing. Confidential Reviewed Files for Accuracy
  • Extensively involved in RAD session to converge early toward a design acceptable to the customer and feasible for the developers.
  • Facilitated and managed meeting sessions from business areas including Confidential Origination, Loan Processing.
  • Validated report specifications and Mockups
  • Scheduled meetings with developers, system analyst and testers to collaborate resource allocation and project completion using MS Project.
  • Created Mock-up forms in MS Access for better visualization and understanding of the software solution.
  • Created QTP Vbscripts to automate testing. Tested Empower LOS functionality
  • Functioned as the primary liaison between the business line, operations and the technical areas throughout the project cycle.
  • Monitored version control and defect tracking activities using Rational ClearCase and Rational ClearQuest.
  • Extensively involved in writing test cases and test plans and reporting bugs using TestDirector.
  • Performed User Acceptance Testing (UAT).

Environment: Rational Rose, Rational Requisite Pro, UML, RUP, MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio), Visual Basic, WinRunner, TestDirector, Windows 2000, Java, J2EE, Oracle 9i, User Acceptance Testing (UAT), Confidential, GAP Analysis, Use Cases Diagrams, Activity Diagrams, Sequence Diagrams, Collaboration Diagrams, Data Flow Diagrams (DFDs), ER Diagrams

Confidential, Allentown, PA

Loan Origination System Analyst

Responsibilities:

  • Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) using Rational RequisitePro.
  • Reviewed Design Documents, Requirements Analysis Specifications with Project Lead, Business Owners and the Technical Lead.
  • Played key role in System Development Life Cycle Process consisting of: Design and Gap Analysis, Business Requirements, Systems Requirements, and Test Criteria
  • Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in RequisitePro.
  • Conversion of data from different database environments, while performing Back End Testing.
  • Involved in creating automated Test Scripts representing various Transactions, Documenting the Load Testing Process and Methodology. Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
  • Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle).
  • Involved in gathering Business Level Requirements and reviewed manual testing methods
  • Prepared Test plans which includes an introduction, various test strategies, test schedules, QA teams role, test deliverables, etc.
  • Coordinates with Information System programmers on all aspects of the loan origination systems change requests and maintain compliance with all regulations.
  • Responsible for writing Test cases to cover overall quality assurance using Test Director
  • Performed initial manual testing of the application as part of sanity testing
  • Performed various tests such as positive, negative to check business functionality manually
  • Performed Black Box testing and conducted Functionality and Regression testing on various phases of the Management software
  • The tests also included GUI testing: Testing for validation and display of screens
  • Developed and managed Project Plans and Schedules.
  • Managed resolution of Project issues and conflicts.
  • Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
  • Performed all necessary programming, testing and documentation for COBOL, DB2 batch programs and sub-routines.
  • Worked as a User/Customer advocate and negotiated with user as well as with developers and management staff to resolve any requirement conflict to bridge the Gaps between IT and Business.
  • Various versions of the documents generated during the project were maintained and managed using Rational ClearCase and performed defect tracking using Rational Clear Quest.
  • Tested the final application for Usability testing to verify whether all the User Requirements were catered to by the application.

Environment: RUP, UML, SDLC, MS Office, MS Project, MS Visio, DOORS, Project Management, SQL, DB2, COBOL

Confidential, Dresher, PA

Business Analyst

Responsibilities:

  • Drafted the project scope and vision and presented the same to the management committee.
  • Provided expertise in strategic planning, business process modeling, business process analysis, object-oriented analysis & design, use case modeling, use case analysis, component-based development, and quality assurance.
  • Identifying gaps and inefficiencies in the existing process and systems and gathering the user wish-list.
  • Involved in mapping and testing custodian data such as holdings, transactions and pending transactions. Worked with SWIFT securities reporting messages
  • Conducted Confidential sessions with SMEs and technological experts to gather data requirements such as securities pricing, corporate actions, trade and custodial data.
  • Prepared complex compliance reports and tests using in-house software applications while meeting deadlines and maintaining quality standards
  • Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
  • Design and developed Use Cases, Activity Diagram, Sequence Diagrams. OOD using UML.
  • Building a high level business case based on the above findings and suggest a transformation roadmap to the future.
  • Extensively used Aris Business Designer for building process maps, system maps and data flow maps.
  • Assisted in on-going process improvement efforts to ensure Test Planning, Execution, and Reporting is effective, efficient, standardized, coordinated, and integrated.

Environment: Microsoft Office Suite, MS Vision, SQL, Windows 2000/XP, Microsoft Office, Oracle Database, Rational Requisite Pro, MS Office, SQL Server, Agile, MS Project, MS Access.

Hire Now