SUMMARY

• Over 7+ years of industry experience as a Business Analyst with solid understanding of Business Requirements Gathering, Business Process Flow, Use Case modeling using UML, System Development Methodologies Business Process Modeling and experience in Basel II, Basel III, AML, Excel Pivot, Unpivot, Look up and V look up.
• Experience working in domain like Banking, Healthcare and IT.
• Interacted and coordinated between end - users, expert team, development and QA team and suggesting key enhancements and changes to the business rules.
• Knowledge of Relational Database Management System (RDBMS).
• Wrote SQL Statements to extract Data from Tables to verify the output Data of the reports.
• Excellent understanding of System Development Life Cycle.
• Skilled in creating Use Cases, Entity Relationship diagrams, Work Flow Diagrams, Activity diagrams.
• Extensive experience in preparing Business & functional requirement documents.
• Experience in conducting Joint Application Development (JAD) sessions with Project sponsors and Development team.
• Performed lookup, V lookup, H lookup using excel sheet and generated reports using excel from SSRS.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of test Cases. Expertise in designing and developing test plans.
• Ability to organize, document and track changes and defects using the Rational Clear Quest and archive change request in Clear Case.
• Strong expertise in Client Relationship Management, worked as a liaison between businesses, technical and non-technical departments within IT organizations.
• Diverse expertise in analytical, conflict resolution and problem solving skills.

TECHNICAL SKILLS

Languages: C, C++, Java, SQL, PL\SQL, Visual Basic

Databases: Oracle, MS SQL Server, DB2, Excel, Access

Tools: Rational Suite, MS Visio, Quality Center, MS Project, ClarityCaliber RM, JIRA

SDLC Methodologies: Waterfall, Agile, RUP

Defect Tracking Tools: Test Director, Rational Clear Quest, Bugzilla, Win runner, Load runner

Web Development Tools: HTML, XML, Java Script, Perl Scripting, Dreamweaver, Balsamiq

Content Management Tools: Vignette, SharePoint, IBM ECM, Open text

PROFESSIONAL EXPERIENCE

Confidential, Richmond VA

Sr. Business Analyst

Responsibilities:

• Held several JAD sessions with SME’s from various domains across the multi - national space.
• Prepare Business Process Models that includes modeling of all the activities of the business from the conceptual to procedural level.
• Organized Joint Application Development (JAD) sessions as a facilitator and moderator to gather requirements.
• Facilitate business requirements gathering sessions with the client, and manage the creation of Use Cases/Activity Diagrams and Functional Specifications using Microsoft Visio.
• Involved in business analysis of the existing tools and configuring new feature set up. Produced the key deliverables by understanding the Application design.
• Created lookup and V lookup from excel and wrote functions to perform lookup on the table data.
• Created tabular and matrix report using Excel from ssrs and exported them to PDF file and HTML file.
• Jointly manage project resource allocations, planning and status updates to senior management Lead weekly Project team meetings to discuss project status and resolve issues.
• Initiate and manage cross training sessions between onsite and offsite team members for outsourced projects.
• Work together with the development team and the Project Coordination Team to ensure that clients' business needs have been met.
• Converted data into XML file to do the analysis of credit card and loan application data.
• Analyzed data in XML format and transformed to meet client requirement and load it into data warehouse.
• Helped enhance and convert existing Visio workflow diagrams
• Created reading material for better analysis and explanation of system flows.

Environment: Windows XP/2000, MS office suite, MS Visio, MS SQL Server, MS Project, JIRA, Agile,HPQC.

Confidential, Long Beach, CA

Sr. Business Analyst

Responsibilities:

• Accumulated customer requirements from various end users through surveys, interviews and JAD sessions and analyzed the requirements..
• Developed User Business Requirement Document (BRD), Technical Requirement Specification andFunctional Requirement Specification (FRS) using Requisite Pro, Rational Rose and MS Visio.
• Designed and developedUse Cases, Class Diagrams, Activity Diagrams, Sequence Diagrams and End to End Scenarios using UML.
• Prepared Work Breakdown Structures (WBS) to comply with the triple constraint: time, cost and scope
• Prepared a roadmap for a product that can exceed market and user expectations
• Responsible for meetings with users and stakeholders to identify problems, resolve issues and improve the process to ensure a stable and accurate solution.
• Created and implemented a Test Plan, UAT Plan and UAT Test Cases and thereby assisted Quality Analysts to test the product in a timely manner
• Coordinated and tracked project communications and also maintained project schedules and milestones.
• Interfaced with top management to ensure that IT initiatives and involvement are clearly communicated and understood
• Mitigated risks all the time; motivated all the team members to meet the deadlines since time was very limited

Environment: Rational Requisite Pro, MS Visio, MS Office, Java, MS SQL Server, QTP

Confidential, San Francisco CA

Business Analyst

Responsibilities:

• Interacted with the stakeholders by interviewing them, by preparing questionnaire and getting feedback.
• Communicated Project Requirements, Business Issues, Solution and made recommendation.
• Responsible for defining the scope of the project, gathering business requirements, doing gap analysis and documenting them textually or within models
• Analyzed and documented Business requirements and detail design of the software for full understanding of the business
• Supported the assigned project manager with creating detailed project plans and assisting in developing, scheduling and tracking project timelines.
• Identified KPI aligning with business rules.
• Create Use Case using UML tools and Process Analysis tool such as Fishbone Diagram, and business process flow chart using MS Visio.
• Performed V lookup using excel to perform the analysis of data.
• Created data mapping documents to map data from source to destination using transformation logic.
• Created reports using SSRS such as tabular, matrix, pie, bar, column and exported in excel and PDF file .
• Created use case scenarios and documented work flow and business process.
• Prepared the UML Use Cases using Rational Rose
• Used MS Visio for flow-charting, process model and architectural design of the application.
• Documented business workflows textually as well as in UML diagrams according to RUP for the stakeholder review.
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly.

Environment: RUP, Rational Requisite Pro, Rational Rose, Visio, SQL 2008, UML Diagrams, Quality Control, Test Director

Confidential, Warren, NJ

Business Analyst, Risk Management (Credit Risk)

Responsibilities:

• Detailed Study of BASEL II Credit Risk Approaches, Rules & Framework.
• Detailed study of AML laws and migrated those laws to credit rule engine.
• Conducted JAD sessions and F2F meeting with stakeholders and SMEs and prepared BRD document.
• Having strong knowledge in data mapping and created data mapping document for migrating data from Basel II to Basel III.
• Wrote SQL joins, views and stored procedures for reporting purpose and generated reports through excel and exported in PDF file.
• Engaging with business users to understand the detailed Business Requirements of the future state system and enhancements
• Gap Analysis and Requirements tracking
• Conducting workshops and constant interaction with technology teams to explain the technical impact of every requirement and participate in system design
• Management of teams across geographic locations for creation of BRD, FRD and Business Process Flows of current and to-be state systems
• Review and Sign Off of technical design documents from a business perspective
• Review of Code compliance to requirements and identification of Gaps
• Preparation of detailed User, SIT & UAT Test Packs in line with the BRD & FRD
• Detailed test execution of test packs and interaction with testing team to identify and resolve issues

Environment: Waterfall, MS Visio, MS Power Point, MS Word, MS Excel,MS SQL server 2008, Oracle 9i, Test Director.

Confidential, Menomonee, WI

Business Analyst

Responsibilities:

• Worked with the business users to define business requirements and analyze the possible technical solutions.
• Assisted in ROI, ROM and GAP analysis.
• Conducted user interviews, gathered requirements, analyzed, and documented Business requirements based on the analysis of loan processing workflow model.
• Modeled AS IS and TO BE processes using MS Visio
• Conducted workflow, process diagram and gap analyses to derive requirements for existing systems enhancements
• Build dashboard for decision making based on past sales trend and market research analysis.
• Analyzed the Business and System Requirements of the application as well as Provide ad-hoc reporting and analysis.
• Worked with Front-end and Back-end systems.
• Created Business process model by using BPMN as well as identify the customer choices and demand by using MS CRM
• Performed User Acceptance Testing (UAT) for various web based and database related applications.
• 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.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Assisted the PM in performing Risk Assessment, Management and Mitigation.
• Worked extensively with Mercury quality center
• 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: RUP, MS office 2003, MS Visio, MS Project, MS Share Point, Rational Test Manager, Data Stage, Mercury quality center, MS CRM.