Business Analyst Resume Profile
SUMMARY
- Proficient in determining feasibility, identifying and recommending business process improvements and where appropriate, finding realistic solutions
- Analytical business analyst with more than five years of experience with knowledge of several subjects in Financial Domain. Topics include Corporate Finance, Banking, Mortgage, Underwriting, Equities, Accounting, General Ledger, Derivative, Loan Origination, Approval, Funding, Re-Finance, Payoffs, Revenue Management, and Budget Tracking.
- Knowledge of Basel II Credit Risk, Operational Risk, Assigning Risk Weights, Capital Adequacy, Internal Rating Based Approach
- Experience with technology vendor selection and process modeling
- Knowledge of best practices models like CMMI, PMI, Agile, RUP, UML and Six Sigma
- Experience in PMO activities, have created Project Plans and other key project management enablers such as change management process, RACI, RAID log, business case, financial modeling, process modeling, etc
- Software Development Life Cycle SDLC experience, including Analysis, Design and creation of Business Requirement Document, Testing documents
- Experience in Rational Unified Process RUP using Unified Modeling Language UML having analyzed and created Use Cases, Activity Diagrams and Sequence Diagrams
- Proficiency in business process flow diagrams, assessing As Is To Be scenarios and performing GAP Analysis
- Analyzed various To Be scenarios and created Impact Analysis and Cost Benefit Analysis documents
- Generated Reports and gave presentation to the management by using MS Excel, SQL, power point and MS Access.
- Data Warehouse knowledge of ETL concepts, creating ad-hoc reports, ER Modeling, performance tuning
- Proficiency in working with relational databases like SQL, Oracle. Used SQL queries for back end testing of applications.
- Quality Assurance conducted QA meetings, started various initiatives to improve the quality of the work, did root cause analysis for recurring defects
- Created test cases and test scripts, used Quality Center, interaction with the QA team to manage the process of Error Fixing, Configuration Management, Change Control, Integration and Functional Testing and User Acceptance Testing UAT
- Excellent communication skills and ability to work productively and efficiently with team members so as to meet deadlines and be accountable for the deliverables
SKILLS MATRIX
| Requirements Management Tools | Rational Requisite Pro, Rational DOORS, Rational Clear Case |
| Methodologies | RUP, JAD, UML, CMMi, Agile |
| Process Modeling | MS Visio, Rational Rose |
| Project Management Tools | MS Project, Sharepoint, Citrix |
| Application Software | MS Office suite, SQL Developer, IBM DU, LP, Hogan, Zippy |
| Databases | SQL Server, MS Access, Oracle, Excel |
| Languages | Java, J2EE, .NET, DHTML, HTML, XML |
| Testing Tools | Test director, Quality Center, Clear Quest |
| Operating Systems | Windows NT/98, XP, 2000 |
PROFESSIONAL EXPERIENCE
Confidential
Sr. Business Analyst
Responsibilities:
- Collaborated with Underwriting team members to identify the As-Is set of rules
- Gathered requirements to build a set of To Be rules based on the input from SME's within the Underwriting team and Risk Management team
- Assisted in maintenance of key project management enablers e.g. Communication Plan, Organization Charts etc.
- Managed and Tracked all project deliverables also managed approval process, obtaining approval signatures and closing the documents
- Trained and Mentored new business analyst team members in requirement gathering process, how to conduct JAD sessions, creating use cases.
- Studied and improved the internal business processes to reduce the turnaround time by defining new processes for using CLOSR internal document storage system
- Created GAP analysis and Process Flow diag. to assess AS IS and TO BE scenarios
- Utilized Agile Process to configure and develop processes, standards, and procedures.
- Made Business Requirement Document BRD after collecting requirements through conducting interviews, JAD sessions, group discussions from various department managers and SME's and users from the Risk Management Team, Underwriting Team and Customer Service area
- Segregated requirements into high level and low level Use Cases and accordingly created Activity Diagrams using MS Visio
- Created Wireframes web pages to explain to SME's and users the process flow for both the happy path and adverse action
- Liaison between the Project Manager, team members different departments to ensure smooth transitioning of the project
- Worked as an Underwriting User advocate and negotiated with user as well as with developers and management to resolve any requirement conflicts
- Implemented Mortgage Products and Pricing from all Business Channels on to a common Origination Platform
- Created Data Mapping document Data flow Modeling, ER Diagrams to migrate the Data from existing system to the New System.
- Incorporated financial analysis into business logic used to evaluate borrower's financial stability.
- Used the ETL methodology to create the new central repository
- Validated the database by applying business rules using SQL queries
- Used Rational DOORS for management of requirements, Clear Case for configurations management and Clear Quest for change management and bug reporting
- Conducted weekly QA meetings on how to improve current processes and reduce the turnaround time
- Worked with branch mortgage specialists to define application functionality and features.
- Created mortgage origination process workflow.
- Held weekly user meetings to gather user requirements to create functional and technical specifications.
- Built application prototype to aid users in visualizing software application.
- Executed test cases to ensure that the Business requirements have been delivered as per the Business's needs by using Integration Testing and System Testing.
- Bugs were reported to Developers using Quality Center and after rectification from developers regression testing was performed.
- Conducted User Acceptance Testing UAT and after interacting with the end users and collecting their feedback documented the changes/enhancements required
Environment: Agile, UML, Rational DOORS, Clear Case, Quality Center, SQL, SharePoint, MS Office, MS Project, MS Visio, Java, HTML and Windows
Confidential
Sr. Business Analyst
Responsibilities:
- Worked in a team to explore, evaluate, and identify multiple vendors in this space.
- Created and conducted proof of concepts and process flow diagrams in the selection process
- Interacted with management and SME's to gather requirement
- Created requirements schedule in MS Project, conducted weekly status review meetings, changed work schedules and kept track of the various deliverables making sure they get submitted on time
- Point of contact for escalating matters, liaison with users and developers to solve conflicts
- Mentored new business analysts in the project bringing them up to the speed
- Managed and tracked all project documents, and administered document storage area
- Involved in process modeling, prepared Business Process Models that includes modeling of all the activities of the business from the conceptual to procedural level.
- Created Process Flow to define current processes and How business processes are accomplished
- Reporting Generated reports on the Operational Risk being faced by the bank on the basis of new Basel II requirements
- Used both Basic Indicator Approach and Standardized Approach while calculating Operational Risk and if the bank has enough Capital Adequacy or not
- Created Traceability Matrix to map the requirements
- Developed functional requirement specifications and Use Case Diagrams UCD using UML to depict the system's functionality in accordance with Rational Unified Process RUP
- Created Wireframes web pages to explain to SME's and users the process flow
- Conducted joint application development JAD sessions by convening project sponsors, end-user representatives, subject-matter experts SME technical personnel documented the minutes of these meetings/sessions.
- Performed GAP Analysis for new functionality requirements FR prioritized them as per business needs of the organization/project.
- Created a Data Catalog to track data used on all reports and to ensure consistent mappings with systems of record. Conduct data analysis and financial modeling.
- Developed business cases and generated ROI model
- Worked on the functionality of Credit Risk, Operational risk and regulatory exposure that were all integrate to the accounting system to provide access to total exposure by customer for decision making, while using Loan documentation packages and performed functional testing on these.
- Created prototype of the website using HTML, JavaScript to explain the developers the flow of the web pages
- Created Test Plans, Test Cases and Test Scripts by analyzing Business Requirements, Functional Specification Documents.
- Performed back end testing by writing SQL queries on various databases like Oracle and SQL Server.
- Performed system testing for functionality and business logic and the test strategy involved documentation of test plans and creating test cases
- Classified and documented test plan change, documenting errors and incorporating software enhancements as well as software fixes into test plans and scripts
- Involved in User Acceptance Testing UAT and after interacting with the end users documented the changes/enhancements required
- Created test scenarios for disaster recovery, backup and restore, to ensure requirements met.
- Developed user training manuals and documentation to aid in knowledge transfer.
Environment: MS Office, Oracle 9i, DOORS, MS Project, Clear Case, MS Visio, Clear Quest
Confidential
Business Analyst
Responsibilities:
- Interacted with business heads to finalize the Scope document for the project
- Collaborated with audit role users to schedule and conduct the gathering documentation and analysis of the requirements.
- Worked with production staff to identify and map detailed current processes, identify gaps and failure points, perform root cause analysis and develop functional requirements that supported overall strategy, goals and objectives. Subsequently used these findings for updating the business rules for the underwriting application
- Documented the requirements assisting the Quality Control Department in meeting Regulatory requirements and mitigating risk as it relates to Mortgage lending.
- Performed risk analysis of the requirements to identify the key business risks areas for the project and prioritized the application development and testing.
- Followed a structured approach to organize requirements into logical groupings of essential business process, business rules, information needs and ensured that critical requirements are not missed. Obtained the final sign off from the Subject Matter Experts including Auditors, and Underwriters
- Actively involved in writing use cases in Requisite Pro and produced the visual models using Rational Rose state charts, sequence diagrams, deployment diagrams and activity diagrams.
- Conducted JAD sessions with management, SME, users and other stakeholders including the Compliance department
- Closely interacted with designers and software developers to understand application functionality and navigational flow and keep them updated about Business user's change of requirement.
- Assembled the Mortgage processes and enhanced the Products and Pricing application used by Mortgage Sales Platform.
- Produced documentation regarding the technical disaster recovery procedures and led exercises for the department.
- Worked closely with system auditors to capture the auditor requirements
- Conducted walkthroughs with the end users and stakeholders to gather the modification requests from the user to upgrade or change the business specifications for the product.
- Facilitated the weekly meetings with the review teams to continuously improve the QA process for the application development.
- Documented requirements for application used to connect banks and legal firms.
- Defined product functionality by working with lawyers, trustees and banks.
- Created test plan and test cases using Test Director after studying the BRD and Use Cases
- Developed and performed interactive walkthroughs of test scripts with developers and business users from the underwriters and product and pricing team
Environment: Rational Requisite Pro, Oracle, J2EE, MS Project, MS Visio, MS Office, Clear Case
