Summary

• 7+ years of experience as a Business Analyst/Data Analyst with extensive knowledge and understanding of Financial/Mortgage Industry with discrete understanding of data and process flow modeling using Software Development Life Cycle (SDLC) that includes Analysis, Design, Coding and Testing phases.
• Strong concepts and understanding of Financing Structures, Financial Markets, Portfolio Management, Project Financing, Securities and their valuation, risks and returns.
• Expert understanding of derivatives i.e. Forwards, Futures, Call and Put options, Swaps and Fixed Income Securities with Very good understanding of Present values, Future Values, Annuities, Simple and Compound Interest Rates.
• High level acquaintance with all banking Practices and Electronic Banking Systems with the understanding of the Accounting Laws and Practices.
• Good knowledge of SQL queries and PL/SQL procedures functions and packages.
• Exposure in creating and analyzing Data flow diagrams and Entity Relationship diagrams.
• Involved in maintaining Test Matrix and Traceability Matrix and performing GAP analysis.
• Experience as business intelligence analyst/expert researching and analyzing data, creating reports and presentations; preparing recommendations based on data summaries.
• Experienced in preparing the Business Requirement Documents, Functional Requirement Documents, Test Cases and User Training documents.
• Excellent working experience in drawing Use Case diagrams, Sequence diagrams, State Chart diagrams and Class diagrams with Unified Modeling Language (UML) tools.
• Practical Experience with different software development Methodologies like waterfall, Agile and Rational Unified Process (RUP) methodology.
• Excellent Management skills in facilitating the JAD (Joint Application Development) sessions for gathering Functional and Non-Functional requirements with deep understanding of business systems functionality and technicality.
• Capable to co-ordinate and work within a team and able to perform under tight schedule without sacrificing the quality of work.
• Use of excellent Communication, interpersonal and coordinating skills in meetings with subject matter experts (SME’s), Stakeholders and business End users.

Technical Skills:

Project Methodologies : Rational Unified Process (RUP), Waterfall, Agile
Business Modeling Tools: Rational Rose, MS Visio
Requirement Management Tools: Rational RequisitePro, WireFrame, MS Visio
Defect Tracking Tools: Rational ClearQuest, Quality Center, Test Director
ETL/Reporting Tools: Cognos, Informatica, SSIS, DTS, Business Objects, BI
Operating Systems: Windows Vista, NT/XP/2000, UNIX
RDBMS: MS Access, MS Excel, SyBase, Teradata, Data Warehouse, Oracle, SQL Server, DB2
Languages: C, C++, C#, Visual Basic, COBOL, Java, Korn Shell, Perl, HTML, XML

Education
Bachelor of Engineering in Information

Professional Experience
Confidential,
Minneapolis, MN January 2009 to Present
Business Systems Analyst

Minneapolis-based U.S. Bancorp (NYSE: USB), with $353 billion in assets, is the parent company of U.S. Bank National Association, the 5th largest commercial bank in the United States. The company operates 3,080 banking offices, 5,085 ATMs in 25 states, and provides a comprehensive line of Banking, Brokerage, Insurance, Investment, Mortgage, Trust and Payment services products to consumers, businesses and institutions.
I was responsible for constructing RIS FDW a Data warehousing Project that provides RIS (Retirement and Investor Services) with the information it needs to satisfy all the financial reporting necessary to support day to day operations and the financial analytics that enables market segment and product management to maximize the performance of their respective domains. I also worked as a business analyst for the Electronic Fund Transfer (EFT) project to connect vendor’s EFT site to the company’s imaging system.

Responsibilities:

• Involved in business analysis and project management, coordinating between the team members, addressing budget issues and creating test plans according to the business requirements.
• Worked as a business analyst on multiple EFT projects.
• Defined and documented the vision and scope of the project.
• Created business requirements and managed implementation of an innovating project connecting vendor’s EFT site to the company’s imaging system.
• Prepared Business Requirement Document and Functional Requirement Document.
• Worked on Business Intelligence scripts to reflect changing business data requirements
• EFT/Remit Funding processes and set up of Transactions in Omni and Mainframe.
• Used AGILE Software Development Methodology throughout the project lifecycle
• Worked with the project manager for planning and organizing the project activities and in communicating with other business center managers and stakeholders of the project.
• Performed Gap Analysis of client requirements, generated workflow process, flow charts and relevant artifacts.
• Performed Data Mappings based on the specified business requirements.
• Met with various groups, including business owners, SMEs (subject matter experts) and marketing team, for requirements gathering in definition Stage.
• Designed Use Cases using UML and managed the entire functional requirements life cycle using RUP.
• Created Use Case Diagrams, Activity Diagrams and Sequence Diagrams using MS Project.
• Worked with the project manager to estimate best/worst case scenarios, track progress with weekly estimates of remaining work to do, conducting informal meetings ad hoc and as needed.
• Wrote simple to complex SQL queries against different databases to verify the quality of data and preparing/analyzing reports.
• Involved in writing and implementation of the test plan, and various test cases.
• Involved in project planning, coordination and implemented QA methodology.
• Provided overall project management to multiple modules and successfully completed them on-schedule and on-budget.
• Validated EFT and Banking Transactions, End to end Testing.
• Worked with the clients on the final signing process in the User Acceptance stages.

Environment: Windows Vista, Mainframe, DB2, MS SQL Server, MS Visio, Oracle, Web Logic, MS Project, IIS, Java, Rational RequisitePro, UML

Project 2:
Confidential,
Business Systems Analyst

MetLife, Inc. is a leading global provider of insurance, annuities and employee benefit programs, serving 90 million customers. Through its subsidiaries and affiliates, MetLife holds leading market positions in the United States, Japan, Latin America, Asia, Europe, the Middle East and Africa.
In the beginning, I was assigned for the project where the company was developing New Web based online application to replace the existing application. The company was also trying to get rid of Mainframe legacy system and implementing Microsoft Web-Based Database. I worked as a Business Analyst in both projects.

Responsibilities:

• Responsible for defining the scope and business rules of the project, gathering business requirements and document them textually or using models. Interacted with cross functional teams to facilitate gathering of business requirements.
• Responsible for writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS).
• Gathered user requirements to redesign mortgage processing into its modular and fundamental components to comply with companies’ requirements.
• Worked on SOA (Service Oriented Architectures)
• Coordinated JAD sessions with business stakeholders.
• Developed business process flow with UML and RUP methodologies/tools for work flow and case diagrams.
• Managed requirements, test cases and test scripts using Quality center.
• Base-lined the requirements in DOORS.
• Analyzed set behavior and contribution to business performance, critical business metrics & tracking underlying business trends using Business Objects.
• Worked with different IT & Business groups to understand and determine the Impacts to the Data Warehouse and/or Data Marts for different projects
• Involved in Change Management Configuration using DOORS.
• Partnered with Project Managers and Technical Designers to assess and document the impact of managing current project requirements.
• Interacted with all the system owners to collect data elements and functional process flow to redesign mortgage processing to comply with the reporting requirements as per the stake holders.
• Defined functional specifications for breaking down the mortgage into core cash flow components using Use Cases, Activity diagrams and Sequence diagrams.
• Obtained sign off from Businesses / Stake holders.
• Conducted pilots, tested strategies, reviewed the test cases using test director and signoffs, improvised processes and incorporated user feedbacks to ensure a smooth scalable rollout.
• Documented processes for resolving technical and tool usage issues, handling customer requests, change requests etc.
• Monitored Project Life Cycle (PLC) using MS Project and Visio.
• Served as a liaison between Clients and Technical Staff to resolve any conflicts.
• Used Quality Center for bug tracking, reporting and report generation for the test cases
• Analyzed Business Requirements, performed gap analysis and segregated them into high level and low level Use Cases, Activity Diagrams/State Chart Diagrams using Rational Rose.
• Understand and articulate business requirements from user interviews and workshops and then convert requirements into technical specifications.
• Involved in writing the Test Plan, numerous Test Cases and Test Scripts using Quality Center.
• Worked with the Business Users through interviews and (Joint Application Development) JAD sessions.
• Performed GAP analysis during the conversion process.
• Performed backend testing to check the system data integrity for insert, update, delete and retrieve transactions by writing complex SQL queries including joins, group by, having clause etc.
• Responsible for planning and conducting the UAT phase.
• Involved in preparing flow diagrams for the decision logic using Visio tool.
• Involved with regular walkthroughs and meeting to discuss bottlenecks in the system and possible solutions with the development team.

Environment : Rational Unified Process (RUP), Rational Suite (RequistePro, ClearQuest, Clearcase), MS Office Suite, MS Visio, MS Project, Oracle 9i, Mercury Test Director, MS SQL Server 2005,Rational Rose, MS Access, MS SharePoint , Business Objects.

Confidential,
Business Analyst

The project was a web based application upgrade to the existing web products used by M&T Bank customers to integrate various features that would give the customers consolidated view for e-portfolio management online collaboration system. Also I worked on the implementation of the e-portfolio/Finance reporting system which was migrated from the legacy system. I performed both Business Analysis and Data Analysis for the e-portfolio consolidation project on the web interface and the reporting interfaces.

Responsibilities:

• Involved in requirement gathering, analysis of the requirements from the business owners and users.
• Interacted with users for verifying user requirements, managing change control process, updating existing documentation
• Responsible for writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS).
• Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives.
• Created RTM (Requirements traceability matrix) mapping Requirements to Design Artifacts of SIT Cases to UAT Cases.
• Created vender agreement document to document the 3rd party deliverables.
• Analyzed Business Requirements, performed gap analysis and segregated them into high level and low level Use Cases, Activity Diagrams/State Diagrams and Class Diagram.
• Documented and maintained requirements traceability matrix to ensure that all requirements are traceable from top to bottom and to provide a basis for test plan
• Assisted in design review meetings making sure all the requirements are covered in the development project scope.
• Designed, developed, maintained and tested universes in Business Objects for supporting ad hoc queries and canned reports according to the business requirements.
• Performed System and Integration Testing using Quick Test Pro.
• Extensive interactions with the client and the management teams to understand the requirements and report the status of the testing efforts on their applications
• Created Activity Diagrams, Sequence Diagrams and ER Diagrams in MS VISIO.
• Conducted JAD Sessions with the subject matter experts, stakeholders and other management teams in the finalization of the User Requirement Documentation.
• Responsible for Designing and analyzing classes and objects by using the Business Object Designer.
• Involved in Configuration Management, Requirement management and analysis.
• Created and executed Test Plan and Test Cases based on Design document and User Requirement document for testing purposes reports in Business Objects. Involved in User Acceptance Testing and training of end users.
• Resolved issues related to requirements during system testing and UAT.
• Participated in the planning and execution of the User Acceptance testing effort.

Environment : Rational Unified Process (RUP), Rational Suite (RequisitePro, ClearQuest, Clearcase),MS Visio, MS Project, Oracle 9i, Mercury Test Director MS SQL Server 2005, Rational Rose, iRise, TOAD, Cognos 8 BI Studio.

Confidential,
Business Systems Analyst

Worked on its Home Loan Management System This application is an online workflow system developed in JAVA and Oracle to book and monitor the loan portfolios. The business of this division is to process loan application from potential clients/customers, evaluate their eligibility, approve them and maintain the loans till their closed. This includes client, debtor, invoice, pricing and account information. Invoices are funded and payments are processed with accounts being managed accordingly. Reports are generated for internal and external use. The loan is repaid and removed from the system. The five primary stages in the life cycle of a loan are the request, processing, booking, maintenance and closure stages. I joined the project when it was in the design & development stage.

Responsibilities:

• Prepared Business Requirement Document (BRD) and Functional Requirement Document (FRD).
• Performed UAT testing for various reports created from the data marts.
• Gained Formal acceptance of the Project in the Project Closing Phase.
• Assured all artifacts/signoffs were in compliance with corporate policies and guidelines and archived.
• Updated Lessons Learned Knowledge database.
• Designed and developed Use Cases, Activity Diagrams and Sequence Diagrams in MS Visio.
• Provided high level of data analysis and insights using Business Intelligence tools such as Cognos and Business Objects.
• Contracted and managed a single vendor for the design and implementation of the enterprise Data Warehouse
• Identified and validated process controls affecting multiple and interacting project streams
• Interacted with work stream’s Business and IT Restatement managers ensuring production support
• Requirements were being met and evenly enforced across all projects within a companywide initiative.
• Worked as Integrator to integrate code from different streams and participated in all end-end deployment processes in compliance with the Sarbanes-Oxley (SOX) act.
• Techniques – Initiation, Planning, Execution, Control and Monitoring and Closing.
• Developed project schedules, timelines, status, system schematics and process work flows.
• Responsible for requirements generation and analysis using Requisite Pro
• Involved in scheduling the session\'s tasks comprising of different mappings in order to load data into different databases.
• Collected processes, procedures & historical information.
• Documented business need, assumptions & constraints
• Conducted individual and group (JAD) sessions with business and technical units.
• Ran risk assessment and mitigation strategies for contracts.

Environment: Rational Unified Process (RUP), Rational Suite (RequisitePro, ClearQuest, ClearCase), MS Visio, MS Project, Oracle, Mercury Test Director MS SQL Server, Rational Rose, MS Access, iRise, Business Objects.