PROFESSIONAL SUMMARY:

• 7+ years of experience as a Business Analyst in domains such as IT, Property Tax, Finance domain.
• Experienced in interacting with business users and executives to identify their needs, gathering requirements and authoring Business Requirement Documents (BRD), Functional Requirement Document (FRD), Software/Technical Requirement Specification (SRS), Use Case Diagrams, Activity Diagrams, Sequence Diagrams etc. Developed Project plan, scope documents.
• Proved ability to function exceptionally and advanced with various Software Development Life Cycle (SDLC), including: Waterfall, Agile, Scrum, Spiral and Rational Unified Process (RUP).
• Managed Business Analyst team for facilitating and conducting Joint Application Development (JAD) and Joint Requirement Planning (JRP) sessions, interviews, workshops and requirement elicitation sessions with end - users, clients, stakeholders, and development team.
• Involved in creating Dashboards, reports as needed using Tableau Desktop and Tableau Server.
• Experience in BI Development and Deployment of DTS, SSIS packages from MS-SQL, MS-Access, Excel.
• Experience converting and mapping legacy data into a large complex relational database
• Knowledge of Data Warehouse, Project Planning and Data Warehouse Deployment.
• Experienced in using SQL queries to validate data in Oracle and SQL Server.
• Involvement in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure dat all aspects of project are compliance with the project requirements.
• Expertise in creating UAT test plans and test cases.
• Extensive experience with User Interface, UX design, Screen design and conducting Gap Analysis.
• Experience in coordinating system test activities and implementing the change management process.
• Demonstrated ability to work both in independent and team-oriented environments with well-developed organizational skills and excellent interpersonal skills.
• Experience on Managing, Scheduling and Monitoring of Informatica workflows.
• Experience in generated Test Plans, stored test cases in Quality Center & Conducted Regression and UAT testing.

TECHNICAL SKILLS:

Environment: C, Asp.Net 3.0, Java, HTML

Framework/Methodologies: SDLC, Waterfall, Agile Modeling, Prototype Modeling, Scrum

Operating Systems: Windows 2000, NT, XP, Mac and UNIX

Databases: Oracle, SQL Server, MySQL

Data warehousing Tools: Business Objects, Informatic

Bug Tracking Tools: JIRA, TFS, MTM, Visual Studio, Rally

Utility Tools: MS Office Suite, MS Project, Adobe Photoshop

Reporting Tools: Crystal Reports, SQL Server Reports (SSRS)

Data Analytics: MS Excel, MS Access, Pivot Tables, V-Look Ups, Tableau

PROFESSIONAL EXPERIENCE:

Confidential, CA

Sr. Business System Analyst

Responsibilities:

• Conducted JAD (Joint Application Development) Sessions and RAD (Rapid Application Development) Sessions with stakeholders.
• Designed the business requirement collection approach based on the project scope and SDLC methodology.
• Incorporated Agile Methodology and SCRUM techniques to manage requirements.
• Identified internal and external system requirements, design, and configuration set-up, also created User Documentation, and conducted classes.
• Collected requirements for the AS-IS change management process and designed mockups and UML’s for the TO-BE change management process
• Used to extract and analyze the data using SQL queries from both SQL and Oracle Databases and performed Data Analysis for deploying reports.
• Conducted different elicitation sessions with key business users to collect requirement and business process information. Conducted extensive requirement analysis sessions and facilitated sign off from stake holder, project sponsors and users along with perseverance to ensure Technical Leads understand the business requirements through BRD reviews
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams using UML.
• Participated in requirements analysis using a Use case driven approach and produced detailed use cases and functional specifications for all the interfaces.
• Conducted Sprint planning sessions based on the priorly groomed and ready status user stories using JIRA tool to avail the estimation of the projected work based on the complexities involved for technical tasks. 
• Developed business process models document existing and future business processes.
• Developed business requirement specification documents as well as high-level project plan.
• Designed and implemented basic SQL queries for QA testing and report / data validation.
• Aligning with all the stakeholders over their requirements for the successful implementation.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created Ad hoc reports to users in Tableau by connecting various data sources.
• Prepared E2E SDLC deliverables like project charts, product backlogs, release plan etc.., and getting requirements signed- off.
• Involved in Production Support and Maintenance for MAINFRAME based applications.
• Conducted and coordinated team retrospective meetings at the end of each sprint to review and improve team collaboration, communication, team building and Note any action items to implement for scrum team to manage and successfully deliver the expectation.
• Created meeting minutes in SharePoint and Confluence for Sprint Planning sessions.
• Partnered with business, architecture - infrastructure (systems team), QA - manual and automation, offshore teams (legato Systems and Anthem resources) with all service levels to ensure business area satisfaction.

Environment: Agile (Scrum), Confluence, CI/CD, MS Visio, MS Project, Jira, MS Office, Tableau, Mainframe, Microsoft Access, MS SQL Server, HP Quality Center, .Net, UML, MS SharePoint.

Confidential, NY

Sr. Business Analyst

Responsibilities:

• Performed Business analyst role in Agile way in Conducting user interviews, gathering requirements, analyzing the requirements & further groom product backlog
• Created EPICS, Themes, Features, User stories, Tasks, subtasks, and acceptance criterion.
• Performed extensive GAP Analysis to understand the As-Is and To-Be conditions and determine the feasibility of the new project with the existing system.
• Educate and reinforce scrum methodology and agile framework to team members and key stakeholders
• Derived functional specifications document based on the User Requirement Specification and used Rally for documenting requirements. Involved in Rally workflows for bug tracking and project management.
• Verified and tested the functional aspect as per the business process and validated the interfaces with the other systems and data conversion from the legacy systems.
• Conducted highly interactive JAD sessions with project stakeholders and the project management team to identify and resolve issues.
• Supported IT unit creating functional specification documents for the design, development, and implementation of strategic projects.
• Involved in defining the source to target data mappings, business rules and data definitions, System rules/validation, user interface requirement type, output requirement type.
• Worked with the data analysts and DB team for data mappings and data discrepancies. Created queries in Access.
• Expertly respond to requests for data analysis and research. Identify and extract critical indicators from large and complex data sets and interpret in a business context.
• Provide qualitative and quantitative analysis for detection of errors and abnormalities using data mining tool. Generate and present customized reports from the analyzed data to client.
• Communicated Project Requirements, Business Issues, Solution and made recommendation.
• Conducted the User Acceptance Testing, System Acceptance, and End-to-End testing.
• Created customized reports using various types like text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and Tableau. Created proactive delivery reports using Tableau Desktop with both events-based and time-based subscriptions.
• Responsible for risk assessment & maintaining risk log along with planning for contingencies.
• Conducted Back End Testing on the database using SQL.
• Monitored Client Expectations through client involvement and communication throughout the lifecycle of the project, educate clients and stakeholders on the benefits and risks associated with the project
• Writing SQL queries for data validation of the reports and dashboards, as necessary.
• Defined requirements through the Use Case and detailed supplementary specifications.
• Develop, maintain and create functional test scripts within HP Quality Center.
• Organized the information between the team members about the project with the help of MS SharePoint and for efficient collaboration across different user groups.
• Coordinated deployment releases into various environments including TEST, UAT, DEMO, and Production.

Environment: MS Visio, MS Project, Rally, Agile, MS Office, Tableau, Microsoft Access, SQL, HP Quality Center, Java, UML, MS Team Foundation Server (TFS), MS SharePoint.

Confidential, AZ

Business Analyst

Responsibilities:

• Coordinated and conducted requirements gathering session with senior stakeholders and project managers, reviewed quantitative and qualitative results, and provided recommendations for better use of systems across the agency.
• Created and updated Software Development Life Cycle (SDLC) documentation, such as a Business Requirement Document (BRD) and Functional Requirements Document (FRD) and Software Requirements Specifications (SRS).
• Interacted with users, developers, project manager and process analysts to understand the business process, identify enhancements and gather business requirements.
• Captured meeting minutes from requirement gathering sessions and additional client meetings and documented the high-level discussion points, decisions and action items.
• Actively involved in walk-throughs and meetings with development team to discuss related issues.
• Conducted working sessions to discuss and prioritize requirements and resolve project related issues. Actively involved in meetings with development team to discuss process flow and other development issues.
• Document all data mapping and transformation processes in the Functional Design documents based on the business requirements.
• Developed Use Cases, Activity diagrams and Sequence diagrams from the requirements based on the UML methodologies using MS-Visio.
• Developed source to target mapping documents for multiple subject area.
• Wrote User Stories fulfilling INVEST criteria, assisted the Product Owner in prioritizing the Product Backlog Items (PBIs) using techniques like Kano Model and estimated Story Points using Planning Poker.
• Managed changes to base-lined requirements through TEMPeffective application of change control processes, peer review processes as well as managing versions using SharePoint.
• Preparing of RFP for the project by submitting business proposals.
• Co-ordinate client meetings facilitate JAD sessions and workgroup sessions to gather and get final approval on business requirements.
• Unified Process (RUP) to configure and develop process, standards, and procedures and create a Business Requirement Document.
• Worked closely with customer designated representatives, technical support personnel, end users.
• Identified various business processes and developed process flow diagrams for the business processes and validated the same with SMEs.
• Involved in Jira workflows for bug tracking and project management.
• Developed test cases from functional requirements documents from the software development team.
• TEMPEffectively managed Documentation of business requirements for regulatory changes to the system as well as those initiated by business units such as loan service, REO and Short Sale.
• Utilized Rational the requirements and requirement change requests during various phases of project life cycle.
• Participated in risk management to help determine best use of testing resources and trained the team members to understand the strategies involved in testing the application
• Experience working with huge volumes of data, analyzing record sets for Data Quality, Data Validation and Metrics using SQL and / or PL/SQL.
• Co-Managed the Change Control process for the entire project as whole by facilitating group meetings, one-on-one interview sessions and email correspondence with work stream owners to discuss the impact of Change Request on the project.
• Successfully used Agile/Scrum Method for gathering requirements and facilitated user stories workshop.
• Documented User Stories and facilitated Story Point discussions to analyze the level of effort on project specifications.
• Performed project planning, project scheduling, cost & time estimation (GANTT Chart) using MS Project.
• Participate in Daily Agile Scrum "Stand-up", Biweekly Sprint Planning and Retrospective Sessions and update the team on status of upcoming User Stories.
• Documented and communicated defects, fix success, failures, and status updates in QC.
• Perform RTM (Requirement Traceability Matrix) at the end of each sprint to ensure the requirement is met.

Environment: MS Visio, MS Office, SQL, HP Quality Centre, MS Project, MS Access, MS Excel, MS SharePoint, Jira.

Confidential

Business System Analyst

Responsibilities:

• Participated as a Business Analyst and Subject Matter Expert on a project dat involved the creation of a comprehensive application to manage the Human Resource function within the organization.
• Worked with different business groups to document the Current and Future business process flows using Microsoft Visio. Identified the gaps and made recommendations to fill in the gaps.
• Conducted meetings/working sessions to focus on analyzing and obtaining requirements from all target user groups, SME’s.
• Responsible for gathering and documenting Business Requirements and Functional Requirements in BRD and FRD.
• Involved in Jira workflows for bug tracking and project management.
• Collaborated with developers and architects to create several user-friendly and full functional mobile applications for Android and iOS platforms.
• Conducted the GAP, risk analysis and presented the issues and concerns at the JAD sessions to all the stakeholders. Documented the proceedings of the JAD session.
• Utilized the Requirements Traceability Matrix to ensure dat all teams are using the right and appropriate requirements and sub-requirements for the ultimate satisfaction of customer needs.
• Performed UAT, White Box testing, Black Box testing for quality assurance purposes.
• Involved in data analytics from complex source data.
• Performing daily system checks, Data entry, creating data reports & monitoring all data for accuracy.
• Participated in the Bug Review Meeting to discuss outstanding issues with QA team and developers.
• Participated in peer reviews and walkthroughs on the Preliminary Test Approach, which contains high-level test conditions for verifying the software solution.
• Development of Test Strategies, Test Plans, and execution of Test Cases.
• Migration of the automated regression and smoke scripts from Rational Robot to Quick Test Pro.
• Involved in Migration of Databases from SQL Server 2005 to SQL Server 2008 using SSIS.
• Prepared and consolidated all mock-up/UI design, logical and business flow modelling, and requirements gathering activities.
• Improved the performance of SSRS reports by tuning the Stored Procedures and TSQL queries using various join conditions. Generate experience in converting Actuate reports into SSRS. Created XML, PDF, EXCEL files using SSRS.
• Organized, keyed and maintained project plan and milestones into MS Project to prioritize the multiple tasks.

Environment: Microsoft Visio, MS office, Quick Test Professional, Android/iOS, UML, Jira, SQL, Rational Requisite Pro, MS Project, MS PowerPoint, MS Excel, XML, .NET