SUMMARY

• Business System Analyst with over Seven (7+) years in Software Development life cycle (SDLC), business and functional requirement gathering, analyzing requirements, business process design and software validation.
• Extensive experience as a Business System Analyst for Business Analysis with hands - on project management skills in user requirement gathering and transforming Business requirements into Software Requirement Specification (SRS) using MS Office Suite, Rational Rose Suite and proficient in project Management responsible for the software Development Plan.
• Ability to work cross-functionally with various stakeholders and team members and Identifying -Solving Business Problems and implementing appropriate technology solution.
• Strategic Competencies to support complex Business Analysis.
• Strong working knowledge in software development methodologies like Agile, Waterfall across the span of various projects.
• Expert in creating UML diagrams including Use cases, Activity/state chart diagrams, Flow charts, Sequence diagrams, Collaboration diagrams and Data flow diagrams using MS Visio.
• Experienced in conducting Joint Application Development (JAD) and Rapid Application Design (RAD) Sessions.
• Ability to analyze Request for Proposal, Progress Reports, Project Charter, and Business Case.
• Highly proficient in working with users and stakeholders to elicit, analyze, communicate and validate requirements using User interviews, Workshops, Observation and Existing systems documentation/procedures, JAD, JAR, and Brainstorming sessions, identify Functional, Non-Functional, and Business Rules, and then subsequently model them.
• Exposure to Software prototyping techniques like Incremental/ Evolutionary Prototyping
• Experienced in analyzing and preparing Project Deliverables such as Business Requirement Document (BRD) and Functional Requirement Document (FRD)/ SRS and proposed changes for process improvement using Rational Requisite Pro.
• Efficient in making Requirement traceability Matrix, Mockups.
• Good Knowledge in developing and designing reports through SSRS and EXCEL.
• Expert at managing multiple projects simultaneously with excellent time management skill and meeting deadlines.
• Excellent Team player with Result-oriented, Fast learner, excellent communication skills.
• Ability to gather requirement through Wish list and User Stories.
• Practical knowledge of Scrum Meetings, Business Model and Use Case Descriptive.
• Knowledge in Hyperion Financial Management Systems and POS.
• In depth knowledge of Property & Casualty (P&C) Insurance concepts.
• Worked for property and casualty insurance Business and processes in both personal and commercial lines of insurance.
• Have Experience in designing and developing Databases in SQL Server 2012/2008/2005/2000 , Oracle 11g/9i/10gwhich includes the development of functions, stored procedures and triggers using Transact SQL and PL/SQL.
• Project management experience includes Client management, Customer interaction, and Scope definition; Project planning, and Change control, Integration and Release management.
• Ability to write Test Scenarios and Test Cases.
• Involved in maintaining Test Matrix and Traceability Matrix.
• Worked as a SaaS (Software as a service) Business Analyst.

TECHNICAL SKILLS

Operating Systems: Windows 8, windows 7, Vista, Windows XP/2000/98/95, Linux

Databases & Tools: SQL Server, PL/SQL, MS Access, Oracle 10i/11g

Languages: C, C++, Java Script, HTML, CSS, PL/SQL, SQL and UML

Document Processing: MS PowerPoint, MS Project, MS Visio, MS Web, MS Excel

Testing tools: Test Director, Win/ Load Runner, Quick Test Pro

Multimedia: Adobe Photoshop, Dream Viewer, MS office suite

Methodologies/ Frame work: Rational Unified Process (Rational Rose, Requisite Pro, ClearCase, and ClearQuest), Waterfall, JAD, Data Modeling, Business Modeling, Use Case Diagrams, Sequence Diagrams, Activity Diagrams, and Class Diagrams, Agile/Scrum

PROFESSIONAL EXPERIENCE

Confidential - Minneapolis, MN

Sr. Business System Analyst

Responsibilities:

• Developed and managed the formal SDLC implementation using Agile Methodology.
• Worked with Project Manager for creating detailed Project Plan and assisting in developing, scheduling and tracking project timelines, which helps in the attainment of project goals, and implementing corrective actions.
• Gathered, analyzed detailed Requirements from Business Users and documented Use Cases, Business Rules, created and maintained Requirements/Test Traceability Matrices.
• Assisted in creating Project Plan, Project Tracking, Designed Requirements Planning and Management document, Project Reporting.
• Maintained Audit readiness and maintained accuracy of software during all scheduled upgrades.
• Prioritized the gathered requirements and managed the requirements using Rational Requisite Pro.
• Prepared Workflow diagrams to analyze AS IS and TO BE scenarios, designed new process flows using MS Visio and documented the business process and various business scenarios.
• Conducted GAP analysis to regulate the gaps in the requirements and conveyed to various modules of the project.
• Responsible for digital product development and execution of digital marketing programs for all digital self-servicing to expand digital capabilities.
• Liaison between business, technical teams and other stakeholders to identify business processes, systems, and product requirements to the 3rd party solution provider.
• Involved in Business Process improvement (BPI) to identify the operations that could be improved.
• Was involved in managing the Daily Standup meetings and also ensured that quality standards were enforced as per the build-release schedule.
• Managed software artifacts for the suite of investment products such as Online Banking and Brokerage, BIDS, Insurance etc.,
• Assessed the current environment and made recommendations to decrease vulnerabilities via risk mitigation as appropriate.
• Responsible for execution of all digital channel products to enable cardholders to better self-service online, deflect contacts into call centers, and increase retail partner sales and credit opportunities through closer digital integrations.
• Daily Matrix report creation based on application usage across the Organization, Create the project support related documents, Update and Maintain Project Cycle Management (PCM).
• Observe the standards and procedures established by the project office and Track business needs during development phases in Business Life cycle.
• Involved in the periodically held JAD sessions for the purpose of project updates as well as involved in the weekly meetings to discuss the current project status.
• Involved in Data base design, writing stored procedures, functions, views and triggers. (T-SQL) on SQL Server2012.
• Developed testing strategies and verification scenarios and assisted the Testing team to understand the Business process and the BRD (Business Requirements Document) and System Requirement specifications (SRS) and Data Requirements Document (DRD).
• Prepared test case document and came up with a testing strategy fortesting the Banking Application by analyzing the Business requirementsand theAccounting, Budget, and Procurement systems.
• Involved inmanual, functional, system and regression testing in an agile development environment, data using SQL Queries manually.
• Used TFS for source code control, project related document sharing and team collaboration.

Environment: Client servicing, User monitoring, Blueprint, MS project, User acceptance testing (UAT), Rational clear case, Clear quest, Use cases, UML, MS Office, Requisite Pro, Excel, SQL Server 2012, TFS.

Confidential - White Plains, NY

Sr. Business Analyst

Responsibilities:

• Wrote test plans and test cases based on the business requirements which involved market risk analysis, structured products, documentation, value at risk, risk and return optimization.
• Documented the Business Requirement Specifications and developed the requirement Traceability Matrix.
• Interface with the vendors for gathering requirements and development of application documents.
• Involved in handling the work flow between different departments such as accounts payable, procurement and audits.
• Link business processes to organizational objectives, perform critical path analysis, and identify opportunities for business process improvement.
• Detailed design of some of the key aspects of the accounting application.
• Developed requirement reports for day-to-day to reduce duplicity of work.
• Involved in documenting the requested changes and to ensure that no unnecessary changes are made (Change Management).
• Worked directly with the project managers, and internal security team to ensure clear communications on requirements and defect reports.
• Prioritize requirements and negotiate on deployment timeframes on behalf of the development team along with Data analysis.
• Prepared quarterly financial plans, monthly forecasts and actual reporting.
• Involved in writing complex SQL Statements to validate data and ensure system integrity and security in SQL Server 2012(T-SQL).
• Developed Stored Procedures, Functions, T-SQL Queries, Indexes and Triggers in SQL Server for fetching Transaction details, Customer Details, and Product Configuration data.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Implemented test procedures and testing methodologies, wrote Test Plans according to Business Specifications and design documents.
• Involved in manual, functional, system and regression testing in an agile development environment, data using SQL queries manually.
• Performed data validation, data integration, and database testing.
• Monitored progress against business functionality, requested objectives to ensure that projects meet the specific release criteria.
• Involved in Data feeding using SharePoint and custom creations for data analysis in Excel, Access and SAS.
• Used Microsoft team foundation server (TFS) for version control and file sharing

Environment: Client servicing, User monitoring, MS project, User acceptance testing (UAT), Rational clear case, Clear quest, Use cases, UML, MS Office, Requisite Pro, Excel, JD Edwards, SQL server 2012, TFS

Confidential, Armada, MI

Sr. Business Analyst

Responsibilities:

• Collected the requirements from business users and analyzed based on the requirements.
• Involved in implementation of the project using Agile Methodology.
• Created FRS (Functional Requirement Specification) accordingly.
• Planned and defined system requirements to Narrative use cases and Use Case Scenarios using the UML Methodologies.
• Created Use Case Diagrams and Activity Diagrams Using MS Visio.
• Created Wireframes to explain the requirements to the technical team.
• Conducted Interviews, to understand the client needs and gather and analyze the requirements as well as JAD sessions with stakeholders throughout SDLC to resolve open issues.
• Worked with Digital Operations and development to investigate new software and processes to standardize and automate reporting responsibilities and increase capabilities.
• Worked on ERP (Enterprise Resource Planning) software for taking customer orders and keeping inventory records.
• Performed database operations on SQL Server2008 to create and maintain customer’s information by creating SQL queries, stored procedures, functions, and views.
• Based on Business requirements extensively involved in developing Test plan and Test cases.
• Involved in Black box testing and user acceptance testing (UAT).
• Assisted the team by developing daily reports of defects and test case execution progress, and pro-actively helped analyze from systems and applications and contributed immensely in the development of User Acceptance Test plan including traceability, development of test scenarios and data, and execution of test cases.
• Program management experience, including cross team coordination, leading testing efforts and Enforcement of project deadlines.
• Developed functional specifications and system design specifications
• Generated prototype solutions and devise, build, test, and document end user computing by consulting with business partners concerning application and implementation of technology.
• Implemented Source control using TFS

Environment: Use cases, JAD, Interview, Clear Quest, Clear case, MS EXCEL, MS Access, MS power point, MS Visio, BPR (Business Process Reengineering), MS Project, UAT, TFS

Confidential, San Francisco, CA

Business Analyst

Responsibilities:

• Assisted PM in preparing project plan, time lines, scope document, stakeholders and resource identification.
• Created a project initiation document with project scope, goals, and execution methods.
• Focused on gathering and documenting business requirements, use cases and providing our sales and marketing teams support during software demonstrations.
• Worked with PM to prepare Project charter, Project plans, daily, weekly and monthly team deliverables for each phase, drafting WBS (Work breakdown structure) and RBS (Resource breakdown structure) systematically using MS Project.
• Participated in iteration reviews, retrospectives, sprint and release planning, demos and other Agile meetings.
• Conducted Joint Application Development (JAD) sessions with the development team to develop and understand the business requirements and created work flow diagrams using Visio.
• Articulated Business Requirements from user interviews then converted to Use Cases &technical specifications (SRS).
• Interacted with the customer and program team to evaluate and prioritize the stated user requirements and analyzed complex issues and provided comparative analysis of alternatives leading to a solution recommendation, action plan.
• As Subject Matter Experts (SME’s) of different divisions (Information Technology, Risk and Operations) and established a business analysis and design methodology around the RUP (Rational Unified Process).
• Created use case diagrams, activity and process/application work flow diagrams using Rational Rose to demonstrate the functional requirements.
• Utilized a variety of reporting tools such as SQL for querying underlying database tables and resolve data issues for Business Process Management.
• Involved in writing complex SQL Statements to validate data and ensure system integrity and security in SQL Server2008 (T-SQL).
• Performed User Acceptance Testing. Developed atraceability matrix to map where each Business Req. is mapped to Functional Req. and where each functional Req. is captured
• Involved in SDLC Process consisting of Design and Gap Analysis, Business Requirements, Systems Requirements, Test Criteria, and Implementation to have the outputs of project.
• Periodic Meeting and matrix tracking to update and status along with cost of project. Weekly project period tracing with report analysis
• Rational Clear Case was used to manage all the changes and change requests in the projects. Clear Quest was used for the bug tracking.
• Assisted in development of training materials for new technology and process improvements.
• Clarified QA (Quality Assurance) with Mercury Quality Center and Tester team to identify issues and Reviewed test plans to make sure that all requirements will be covered in scripts and tested
• Worked closely with developer for schema design, database design and development and created process development documentation
• Coordinated in performing Unit testing and Integration testing.
• After successful development and testing of the product, participated in product release and deployment to end-user.
• Used Tortoise Sub Version (SVN) a free/open-source version control system.

Environment: MS Office Suite, MS Visio, Windows XP, Win Runner, MS project, Excel, Dream Viewer, SQL Server 2008, SVN

Confidential

Business Analyst

Responsibilities:

• Worked closely with the business owners; conducted formal interviews, live Meetings and JAD sessions to identify requirements and functional specifications.
• Using waterfall model did implementation of SDLC.
• Responsible for meeting with Business Process Owners and SME (Subject Matter Experts) and gathered requirements for creating the system using prototypes and document analysis.
• Worked closely with business users and build up strategies to increase the client base profits.
• Created and maintained Requirements Traceability Matrix (RTM) and involved in system analysis and design.
• Involved in Data Mapping and Mining with ETL tools.
• Identified and defined actors, made use cases and grouped them and prepared data flow diagrams, activity diagrams, sequence diagrams, state transition diagrams in MS Visio.
• Worked with EHR (Electronic Health Records) to generate a complete record of patients.
• Performed database operations on SQL Server2005 to create and maintain customer’s information by creating SQL queries, stored procedures, functions, and views.
• Held walkthroughs with the developers and QA teams and communicated interface requirements, Manual testing knowledge with Query run.
• Used Rational Clear Quest to manage and track defects, prioritized defects with each build and made sure that they were communicated to the affected teams and make enhancement requests
• Described Business laws for the universal Compliance Engine, the Credit Suisse proprietary trade compliance engines.
• Maintained the requirements traceability matrix as linked to code in order to keep the clients and all the teams up-to-date with the current progress of the project.
• Worked closely with the QA - Quality Assurance team during the functionality testing and helped in the User Acceptance Testing.
• Validated the scripts to make sure they have been executed correctly and meets the scenario description.

Environment: Requisite Pro, UML, MS-Project, Share Point server, SQL Server 2005, Visio, Clear Case, Clear Quest