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

Professional Experience

Confidential

Business Systems Analyst

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

Confidential

Business Systems Analyst

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

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

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.