Business Analyst

SHIVANI TANDON

Business Analyst/Project Coordinator

(973) 979 – 1037 / *******.**@*****.***

Summary of Qualifications:

• Over Six years of comprehensive experience as Business Analyst, Project Coordinator and Quality Analyst in business domains such as Automobile, Loan Processing, Finance and Healthcare.

• Extensive experience in the field of Project management, Business process design, streamlining, Quality Assurance and software verification and validation.

• Experience in Rational Unified Processing (RUP), Unified Modeling Language (UML), Flow charts, Use Case Diagrams, Sequence diagrams, Activity diagrams and Use Cases.

• Experience with Data Warehousing concepts, designs, and project implementations.

• Expertise in project scope definition based on gathered Business Requirements including documentation of constraints, assumptions, business impacts, project risks and scope exclusions.

• Adept in business process improvement, re-engineering, change request management, review process, and reporting escalation.

• Experience in conducting Joint Application Development (JAD) & Rapid Application Development (RAD) sessions and deep understanding of SDLC and PMLC.

• Proficient in developing and executing Test cases, test plans, performing functional, usability, stress testing and UAT.

• Excellent analytical & problem solving skills. A team player with strong interpersonal and communication proficiency.

Technical Knowledge:

Data Bases: Microsoft Access, MS-SQL Server

Testing Tools: Quick Test Pro, Test Director, Rational Robot

Languages: SQL, UML, C, C++, HTML, Core Java

Packages: Rational Suite (Requisite Pro, Rational Rose, Clear Case, Clear Quest) MS Visio, MS Project, Erwin, MS Office

Methodologies: RUP, Spiral Model, Waterfall model, RAD

Professional Experience:

Client: Hyundai Motor America, Fountain Valley, CA Sep 2008 - Present

Role: Business Analyst/Project Coordinator

Project Scope: Hyundai Motor Finance Company (HMFC) developed an Enterprise level Data Warehouse to consolidate databases of individual departments including Collections, Risk, Tax, Audit, Commercial Credit, Customer Service, Accounting and Treasury. This structure assisted specific departments to contribute their inputs as plug-ins to a highly consolidated and synchronized database to streamline deliverables and queries.

Role & Responsibilities for Hyundai Motor Finance Company:

• Conducted interviews with stakeholders, engineers and analysts covering multiple departments for gathering and defining business goals and objectives.

• Adopted Project Management Life Cycle methodology.

• Performed GAP analysis, Feasibility studies, Risk and Cost-benefit analysis.

• Created RFP documents, Budget documents and Data mapping documents.

• Conducted Project Management activities including project planning, project scheduling, and status reporting, cost & time estimation using MS Project and acted as a technical resource from a system requirement standpoint, to both business users and the technical team.

• Authored and structured Business Requirement Document (BRD) after conducting JAD/JAR sessions, user interviews, brainstorming session to come up with alternate solutions and refining requirements.

• Prepared requirement issue log and maintained project workbook.

• Responsible for maintaining the minutes of all the requirement gathering sessions.

• Handled multiple issues and converging conflicts between different domains and resolved each in step-wise manner to avoid stalling of projects.

Role & Responsibilities for Kia Motor America:

• Created and optimized source-to-target mappings.

• Prepared detailed reporting requirement document and Data mapping documents.

• Performed gap analysis on reporting needs.

• Involved in unit testing, integration testing and system Testing.

• Helped in generating ad-hoc reports.

Client: Regions Bank, Hoover, AL Oct 2006 – May 2008

Role: Senior Business Analyst

Project Scope: Regions Bank developed a loan information reporting system supported across all its branches that allowed the bank executives to communicate with customers about length of approval-time. The system was an electronic scorecard that tracked current status of loan applications and its entire history, including any related attached electronic documents, approvals, denials and any issues that may arise during its approval cycle.

Role & Responsibilities:

• Identified business stakeholders and gathered, discussed and refined business requirements with clients/end-user/stakeholders.

• Adopted AGILE software development methodology to adapt to rapidly changing requirement environment.

• Authored and structured Business Requirement Document (BRD) after conducting JAD/JAR sessions, user interviews, brainstorming session.

• Developed a prototype version and presented in the JAD session for feedback.

• Prepared test data for positive and negative test scenarios as per the system specifications. Participated in both manual and automated test plans and test cases.

• Performed unit, integration, functional, stress and performance testing under UAT environment for approval of system.

• Created user manual, trained the end-user group & distributed manual containing user guidelines to the user.

Client: Nationwide, Dublin, OH Jan 2006 – Sep 2006

Role: Business/Quality Analyst

Project Scope: The project involved enhancing the current loan quotation system to allow it to provide a quote or support purchase new business through Web. The users were given access to a wide range of options relating to insurance discounts and coverage on auto and property, subject to availability, qualifications, situation and State of residence. The premium was calculated based on various inputs by user and an option for purchase was also offered which supported online transfer of funds.

Role & Responsibilities:

• Interacted with Business Users from the Homeowners, Condominiums, Rentals and Automobile Insurance Groups to gather Business Specification Requirements and translated them into functional and non-functional requirements.

• Studied the existing functions and problems to arrive at cost-effective, sound solution that could be implemented quickly.

• Authored the Business Requirement Document (BRD).

• Analysed, prioritized and propagated the Business Process and User Interface (UI) requirements to the design team for development.

• Maintained a requirements traceability matrix across all deliverables of the project.

• Scheduled and conducted JRP sessions with client/user work group (Subject Matter Experts) members to identify requirements, documented them in System Requirement Specification Documents and Identified Priorities

Client: Premier Inc, Charlotte, NC Apr 2005 – Dec 2005

Role: Business Analyst/Quality Analyst

Project Scope: The project task was to create a complete solution for reporting and tracking Productivity at the corporate, region, facility and department level to support the needs of Hospital Administration, Clinical Managers, Data Coordinators and Management Engineers in a structured and integrated environment. The scope of the project was to have a web based user-interface to import, maintain and submit finalized data for reporting. The process was to keep track of departments performing poorly through the feature of watch list and action plan.

Role & Responsibilities:

• Worked through the entire life system development life cycle starting from the proposal to the implementation of the system using agile process.

• Studied the impact on exiting system and worked with Business Analysts to define business needs, delivered the comprehensive Functional Specifications and System Requirement Specification (SRS).

• Conducted JRP sessions with business users and conducted JAD sessions with IT group.

• Participated in Bug-Review meetings with software developers, QA Analyst, managers, suggested enhancements from business perspectives and provided solutions to existing bugs.

• Conducted UAT and collaborated with the QA team to develop the test plans, test scenarios, test cases to be used in testing.

• Developed user manuals, presentations & training manuals as per project specifications and timelines.

Client: Prudential Financials, Newark, (NJ) Oct 2004 – Mar 2005

Role: Business Analyst

Project Scope: Worked in Prudential financials as a business analyst for their annuity system Virtual Personal Assistant Solution (VPAS). The project involved the integration of American Scandia’s products into VPAS. The implementation was done in three quarterly releases and I was involved in gathering user requirements and documenting them and ensure that the project is on track as per the business needs.

Role & Responsibilities:

• Followed the RUP framework of iterative software development life cycle.

• Analyzed and documented information system requirements and the corresponding impact on business processes.

• Assisted in preparing BRD, working as a team with other Business Analysts.

• Maintained a requirements traceability matrix across all deliverables of the project.

• Performed GAP Analysis for new functionality requirements and prioritized them based on the business needs.

• Coordinated with the test and QA team to check the weekly status to report to the project manager.

• Formulate comprehensive test plan based on requirements & develop test scenarios based on use cases.

Client: HDFC, Delhi, India Jan 2003 – Aug 2004

Role: Business Analyst/Quality Analyst

Project Scope: The banks large mortgage asset was increasing at a fast pace and the client used an MS-Excel spread sheet based system for risk analysis, disbursement and managing its loan portfolio. It wanted to move from this manual labor-intensive process to an automated and integrated system for its real estate portfolio, which could encompass entire lifecycle of the loan.

Role & Responsibilities:

• Provided support to the re-design group of the Mortgage Asset Management System.

• Assisted in gathering, documenting and analyzing the business needs.

• Designed and developed Use Cases and Use Case Diagrams.

• Involved in writing test scenarios, test plans & test cases using Test Director.

• Acted as UAT coordinator; monitored testing and interfaced with the development team regarding defect status and fixes on a daily basis.

EDUCATION:

• B.E in Computer Technology, India

Contact this candidate