SUMMARY

• Expertise in Data Modeling, Data Analysis, GAP Analysis, Business Modeling, Data Migration, Data profiling, and Dimensional Modeling.
• Expertise in creating various artifacts related to phases like Requirements, Analysis/Design, Development and Testing Functional Requirements Specification FRS and Business Requirements Document BRD .
• Strong Business Analysis Skills including In depth knowledge of Software Development Life Cycle Waterfall, agile SCRUM,RUP
• Strong project management skills including planning, scheduling, monitoring and budgeting with experience in requirement gathering, risk analysis, cost benefit analysis and effort estimation.
• Functional experience with concentration on Use Case modeling using UML, Business Process Modeling, Data Modeling, Change Management, Systems Testing of client server and web-based systems.
• A resourceful and dynamic business system analyst with 8 years of extensive experience as a Business Analyst in business and functional requirements gathering, analyzing requirements, data analysis, data mapping, business process
• Performed analysis, develop and evaluate data mining in a data warehouse environment which includes data design, database architecture, metadata and repository creation.
• Possesses knowledge of Relational Database Management Systems RDBMS and data warehouse front-end tools.
• Extensive knowledge of data warehouse and data mart concepts.
• Excellent knowledge in Corporate Finance, Investment Banking, Credit tracking, Asset Management, Wealth Management, Derivative, Fixed Income securities, Trade Life Cycle, Mortgage, Insurance, FASB, and GAAP.
• Significant experience in UAT user acceptance testing , Functionality Testing, Unit testing, System Testing, Integration Testing and Regression Testing and Requirements Tractability Matrix RTM
• Experience in preparing Preliminary Investigation Report, System Requirements document, Systems Design Specification and System Requirement Change Request.
• Efficient in power point presentations, maintaining performance metrics, revising training documentation communicating them to the users.
• Strong understanding of information technology capabilities and dependencies, including platforms, content management and process mapping.
• Proficient at creating and transforming business requirements into software requirement specification SRS using Rational Requisite Pro and designing business models using UML diagrams such as use case model, Class Diagrams, Activity Diagrams, Sequence Diagrams and Collaboration Diagrams in Rational Rose and MS Visio.
• Experience in conducting Joint Application Development JAD , RAD sessions with end-users, expert team, development and QA team for project meetings, walkthroughs and customer interviews.
• Experience in conducting GAP analysis, Impact analysis SWOT analysis, cost benefit analysis.
• Self-motivated, diligent, ability to adapt to new environments and situations quickly, good grasping ability, capable of forming and maintaining positive and productive working relationships.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills with strong analytical skills

SKILLSET

PROFESSIONAL EXPERIENCE:

Confidential

Senior Business System Analyst

Responsibilities:

• Analyzed the business needs of clients and stakeholders to help identify business problems and propose solutions.
• Extensively did GAP analysis in the project as there were 'As-Is' and 'To-Be' conditions.
• Prepared the Functional Requirements Specification FRS and Business Requirements Document BRD
• Created Workflow scenarios, designed new process flows documented the business process of the business from the conceptual to procedural level using MS Visio.
• Facilitated JAD Sessions with users, developers, and database design team to further breakdown the requirements
• Conducted interview workshops, focus groups, Conducted feasibility analysis and product backlog planning with Project Manager, created work break down structure using MS Project.
• Created Use-Case Models to depict Actors and Use-Cases in various Business Processes. Expressed the requirements through business rules, future state mapping and process flow diagrams.
• Acted as a Scrum master by creating sprint backlogs, organizing and conducting sprint planning meetings, daily scrum meetings.
• Determined the velocity of each sprint and created the Sprint burn down chart, storyboards and Product Backlog and managed Requirements churn
• Utilized data mining and data analysis tools.
• Validated the data loaded into the data warehouse for accuracy.
• Created the product backlog with help of user stories collected through requirements gathering and sprint burn down charts.
• Used SharePoint 2013 for content management, and to share the information with the groups involved during the project
• Assisted in creating enterprise banking data model, created SQL stored procedures to access customer information and implementing corresponding data access objects. Helped in creating test cases for the system.
• Worked with SQL queries to extract application data to perform application validations
• Logged and tracked the defects using HP Quality center. Created an error repository and managed the testing process with the QA team

Environment: HPQC,UML,SCRUM,MS ACCESS,MS OFFICE,ASP,SQL SERVER SSIS,SSRS,SSAS ,Visual Studio, SDLC, MS Visio, BPMN, VSM, SharePoint 2013

Confidential

Senior Business System Analyst

Responsibilities

• Elicited requirements by conducting JAD sessions with key stakeholders from the Capital Markets IT Group, Business Area and Application Development team for the portfolio, forecast and reporting module of the portfolio management system.
• Coordinated with the PM for project planning using MS-Project and to discuss project technologies and methodologies, Cost-benefit analysis, Impact analysis, SWOT analysis, WBS and project milestones, budget allocations, scheduling, CPM, and risk analysis mitigation.
• Performed Gap analysis and conducted business modeling by reviewing the existing business artifacts.
• Authored the Functional Requirements Specification FRS and Business Requirements Document BRD and System Requirements Specification SRS for the project.
• Utilized UML for process modeling and created Use Cases, Activity diagrams and Sequence diagrams using Rational Rose and MS Visio.
• Created static and dynamic prototypes using HTML and CSS for better visualization and understanding of the software solution.
• Created validation rules and provided verbiage to developers for client-side validation, server-side validation and database validation.
• Maintained project documents to be used for collaboration with developers, QA, project manager, etc. on SharePoint 2013.
• Implemented Agile Scrum methodology of application development and set the velocity for each sprint cycle.
• Acted as a Scrum master by organizing and conducting sprint planning meetings, daily scrum meetings and creating sprint backlogs
• Conducted daily Scrum meeting, planning meeting, review meeting, retrospect meeting
• Collaborated with DBAs to perform data mapping using MS Excel and executed complex SQL queries to filter data from the MS SQL database.
• Performed analysis and evaluation of data mining in a data warehouse environment which included data design, database architecture, metadata.
• Participated in creating the design and technical specification for the ETL process of the project and provided the data mapping document to the ETL team.
• Provided test data, monitored UAT and created the Requirements Traceability Matrix RTM using MS Excel.
• Performed Risk Analysis and Impact Analysis in order to be prepared for potential business and technical risks to the system.
• Used HP Quality Center for loading the test scripts and logging defects.
• Collaborated with the production team by facilitating the implementation of the application, prepared production certification scripts and performed production certification.

Environment: AGILE Scrum methodology, OLAP, SOAP, WSDL, XML, JIRA, HP-QC, BPMN, SharePoint 2013, Oracle, SQL Server, MS Access, MS Excel, MS Project, and Test Director

Confidential

Business System Analyst

Responsibilities:

• Gathered business requirements and developed BRD FSD
• Prepared project deliverables: Business Workflow analysis, process analysis, user requirement documents Use Cases Use case diagrams and managed the requirements using Rational Requisite Pro.
• Followed the RUP methodology and was extensively involved in developing the iteration plans.
• Actively contributed throughout the entire Hybrid methodology scrum and waterfall
• Used UML methodology to prepare Use Cases from the gathered requirements and created diagrams using MS Visio.
• Involved in gathering the Data requirements, data analysis and defining the Data Mapping.
• Effectively implemented the change control processes and also updated the impacted business process documentations.
• Conducted JAD Sessions with various stakeholders and project team
• Used MS Project to manage schedules, deadlines, resources and the project tasks.
• Extensively used SQL and Excel for Data Analysis.
• Planned implemented the Testing cycle schedules, timelines, test plan, Test cases test data sets for system testing.
• Independently prepared UAT test plans, test conditions, test cases and developed user training manuals.
• Conducted User Acceptance Tests and maintained all defects in test director.
• Developed the training schedules, documents and trained the users.

Environment: MS Office Suite Word, PowerPoint, Access, Excel, Outlook ,MS Project, MS Project, MS SharePoint 2013, MS Visio, SCRUM, MS SQL, SSIS, SSAS, SSRS, Business Objects, Quality Center

Confidential

Senior Business Analyst

Responsibilities

• Defined scope, objects, goals, risks and produced business requirements and policy-writing solutions to Property/Casualty/Personal and Commercial Lines.
• Analyzed business needs/requirements, incorporating regulatory changes, ratings, re-engineering processes.
• Studied system feasibility and provided information to the stakeholders with benefits, cost savings and risks.
• Analyzed, designed and improved procedures and conceptualized various strategies to achieve business goals for sales and aim towards the growth in business volumes as well as profitability in order to achieve the set targets.
• Conducted Joint Application Development JAD sessions with business user subject matter experts SME's to collect requirements.
• Analyzed the existing Conventional system and proposed SOA Service-oriented architecture approach for flexibility, quick response to changes in the business environment.
• Developed new business process flow for profitable business partners by analyzing latest marketing trends, tracking competitor's activities and provided valuable inputs for fine tuning of sales and marketing strategies.
• Prepared AS-IS and To-BE business process flow diagrams using MS Visio.
• Documented requirements, technical, help documents for the end user across the application stakeholders.
• Created new notification process to retained customers by providing best possible service in terms of immediate response to enquiries, quick execution of orders and kept the customers updated.
• Prepared improved data collection and reporting procedures for competitive business development and sales strategy, uncovered/ created new opportunities, identified dynamic and flexible solutions for managing account activity.
• Ensured quality of system changes through the development and execution of system test plans built and executed test plans.
• Assisted in formulating testing documents like Test Plans, Test Cases and Test summary report.
• Communicated directly with Clients to understand their business needs and to resolve business issues.
• Analyzed cross-functional applications and met requirements for MIS reporting of cancellations, corrections and amendments performed on the existing systems.
• Addressed all aspects of the claim processing lifecycle, starting from identifying a claim right up to closure.
• Performed analysis and design of product enhancements for rollout of the new application and established a business analysis methodology around the Rational Unified Process.
• Researched the various steps in the lifecycle and then constructed the system in such a way that the riskier claims could be easily identified and monitored.
• Participated in the development of controls and workflows to meet new business requirements, productivity enhancements and regulatory changes.
• Prepared data integration requirement document to help developer data conversion.
• Played a key role in the planning, User Acceptance Testing and implementation of system enhancements and conversions.
• Wrote and executed clear and concise support documentation such as Test Plans and Test Cases.
• Functioned as the primary liaison between the business line, operations and the technical areas throughout the project cycle.
• This application was developed using Visual Studio.NET and Visual Studio.NET, VB.NET and ASP.NET.
• Worked with SQL queries to extract application data to perform application validations.

Environment: Visual Studio.NET, VB.NET, ASP.NET, Oracle 11g, SQL, PL/SQL, Windows, MS Visio, MS Project, MS Office Suite MS Word, MS Excel, PowerPoint , and Test Director

Confidential

Business Analyst

Responsibilities:

• Worked as an Interface between the users and the different teams involved in the application development for the better understanding of the business and IT processes.
• Analysis of business requirements and system requirements of the client and also for Property and casualty modules
• Maintained user interface screens for personal lines, property casualty automated policy issuance system, including making updates including rate changes and statistical reporting elements to underlying data tables.
• Helped in migrating from the legacy system to the proposed new process systems
• Conducted user interviews, gathered requirements, analyzed the requirements using Agile methodology and documented the requirements using Rational Requisite Pro
• Utilized Requisite Pro for preparing the Requirements Document
• Prepared Use Cases based on BRD used Visio for UML/BPMN: state, activity, status charts, sequence diagrams, data flow diagrams DFD .
• Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
• Reviewed and analyzed the business requirements document to derive the functional specifications document and assisted in the preparation of System Requirement Specifications.
• Facilitated business requirements gathering sessions with the client, and overlooked the creation of Use Cases/Activity Diagrams, Functional Specifications using UML/Visio
• Designed and developed Use Cases and UML models using Rational and developed Sequence Diagrams, OOD using UML.
• Participated and facilitated different levels of discussions through JAD sessions, conference calls and business workshops held to plan business strategy.
• Attend weekly change request meetings to document changes and implement procedures to test changes upon completion.
• Prepared Business Process Models that includes modeling of all the activities of the business from the conceptual to procedural level. Involved in creating various documents such as Use case, Business Requirements and Functional requirement specifications.
• Used MS Office suite Word, Excel, Access, Visio, Power Point, Outlook, Project for project tracking, documentation, and presentation to senior management
• Conducted UAT User Acceptance Testing . Provide end user training and extensive go-live assistance. Provide solutions to users via phone/email by providing them with screen shots of the different screens, which helped them in understanding the process at a much faster pace.
• Wrote various SQL queries in Oracle for data manipulations.

Environment: UML, RUP, SDLC, Rational Requisite Pro, Rational Rose, Windows 2000, MS Office, MS Project, MS Visio

Confidential

Business Analyst

Responsibilities:

• Facilitated collection of requirements from system users and preparation of Business/Functional requirement documents utilizing UML RUP methodology to provide appropriate scope of work for technical team to develop prototype and overall system.
• Analyze and prioritize requirements and use them to outline timeline for completion of goals.
• Performed GAP Analysis with system functionality and existing Business Processes.
• UML and RUP do it process for productivity in communicating specifications to design development team. Analyzed and designed Use Case Diagrams using UML/Visio.
• Managed scope and requirements throughout the project life cycle.
• Discuss and propose conversion / interface solutions with the clients and users.
• Performed Functional Testing, Integration Testing, System testing and Regression testing.
• Wrote Test cases, test scripts and test plans for UAT.

Environment: Windows, MS Visio, MS Project, MS Office Suite MS Word, MS Excel, PowerPoint , and Testing and SDLC