SUMMARY

• Seven+ years of experience as a business system analyst in various industry domains like healthcare, retail, finance and data technology.
• Worked in multiple types of projects such as business intelligence, process improvement and web development.
• Excellent understanding and extensive involvement in various methodologies such as waterfall, and AGILE in all stages of software development life cycle.
• Identifying and analyzing the project impacts to various systems including enterprise data systems, reporting systems, enterprise integration package and portals.
• Facilitating requirement and work product inspection meetings with business users and developers
• Conducting JAD/Collaboration/Decomposition Sessions with stakeholders including business users, the technical and testing teams
• Liaison between the business teams and technical teams for resolution of pending issues
• Adept at using various requirement management tools to keep track of requirement status, including entering, prioritizing and modifying as and when required.
• Skilled at building a strong team environment, and have the ability to acclimatize to new technologies, relevant knowledge, skills, conditions and situations with ease, excellent verbal, nonverbal and written communication skills.
• Have a good understanding of elicitation techniques such as interviewing, questionnaires, brainstorming, focus groups, prototyping, cost/benefit analysis and risk analysis.
• Providing support for multiple projects including user testing, creating bug, tracking defects and reviewing for new business requests or change requests.
• Creating, updating and maintaining High Level Requirements, Detailed/Functional Requirement Specifications including data mapping, gap analysis, design documents, process documentation and process flow diagrams.
• Expert in creating UML Diagrams including use case diagrams, context diagrams, activity diagrams.
• Hands on experience withSQLqueries and database objects.
• Extensively supported different types of Business Intelligence tools such as digital dashboards, data mining, data warehousing and different BI products.
• Successfully worked with different databases for example Oracle, DB2, Teradata, SQL server, etc.
• Created Test plans and acceptance criteria and did performance evaluation of test results, coordinate, monitor and support of implementations.
• Participated in the Quality Assurance (QA) process and maintained the traceability matrix to ensure requirements are consistent, comprehensible, traceable, feasible, and do conform to standards.
• Participated in Bug - Review meetings with software developers, QA engineers, managers and suggested enhancements to the existed application from business perspectives, provided solutions to existing bugs.
• Experience in training end users to the new systems and providing assistance for later maintenance as and when required.

TECHNICAL SKILLS

Web Tools: Adobe DreamweaverCS5

Programming Languages: SQL Server T-Sql, Oracle Pl Sql

Applications: MS Office, Visio, ERWin, TOAD, Team Foundation Server, Visual Studio 2010/2012, Balsamiq, Power view, .NET Framework 4,4.5, Access, Ad hoc, Tableau, ALM, etc

Team Collaboration Software tools: SharePoint, Team Foundation Server (TFS), etc

Databases: MS SQL Server 2008/2012, MS Access,DB2,Teradata, Oracle7/8i/9i/10g(also R2), etc

Requirement Management tool: Requisite Pro, Rational DOORS, Caliber, Rally, JIRA, VersionOne, ClearQuest, Confluence, LeanKit, etc

Operating System: Windows(32 & 64 bit)

PROFESSIONAL EXPERIENCE

Confidential

Business Analyst

Responsibilities:

• Handled multiple projects for international and USA based teams and coordinated for hurdle free application development lifecycle.
• Identified and established communication with all key stakeholders, contributors, business, operations and technical resources surrounding assigned projects.
• Performed Requirements Gathering and Analysis through interactions, meetings and periodic walkthroughs with potential users of the application along with the creation of Epics, Features, User stories, AS IS and TO BE processes, mockups, etc based on business requirements and business rules.
• Developed integration system process flows, BPMN diagram and AS IS/TO BE process flow as per stakeholders specifications through surveys and interviews.
• Participate in collaboration sessions with business users, technical team, DBAs, testing team to analyze, compile and validate the requirements like kickoff meeting, facilitation session, grooming sessions planning sessions, etc.
• Researched, identified and communicated with multiple teams on their dependencies for an end-to-end process enhancement and coordinated with these teams for features allocation, prioritization, decomposition, development and end to end testing.
• Developed and maintained leanKit cards and Jira issues for requirements, technical and QA task tracking purposes.
• Developed and maintained documents in SharePoint and Clarity documents repository for reference purposes.

Environment: Microsoft Office Suite (Word, Excel, Power Point, Visio), Confluence, Leankit, JIRA, SharePoint, Teradata, SMART (Walmart system), PFS (pay from scan), Agile (Scrum)

Confidential

Business Analyst

Responsibilities:

• Identified and established communication with all key stakeholders, contributors, business, operations and technical resources surrounding assigned projects.
• Performed Requirements Gathering and Analysis through interactions, meetings and periodic walkthroughs with potential users of the application along with the creation of User stories, Use Case Scenarios, wireframes and associated attributes tables, mockups, etc based on business requirements and Business Rules in Gherkin format.
• Developed system process flows and User Requirements Specifications through surveys and interviews.
• Participate in collaboration sessions with business users, technical team, DBAs, testing team to analyze and validate the requirements and application lifecycle.
• Created and managed project templates, use case project templates, requirement types and traceability relationships in Confluence and managed the concurrence of the parties involved with respect to the evaluation criterion.
• Maintained a data dictionary by identifying additional terms and definitions separately for Cognos reports and System database.
• Created and maintained Service level agreement for multiple system’s interfaces for business purpose.
• Helped QA team with UI regression testing as and when required.
• Designed BPMN diagrams and use case diagrams identifying high-level process and actors involved.

Environment: Oracle, Microsoft Office Suite (Word, Excel, Power Point, Visio), Confluence, Balsamiq, ALM, Waterfall methodology (Requirements gathering), Agile (Documentation format)

Confidential

Business Analyst

Responsibilities:

• Identified and established communication with all key stakeholders, contributors, business, operations and technical resources surrounding assigned projects.
• Performed Requirements Gathering and Analysis through interactions, meetings and periodic walkthroughs with potential users of the application along with the creation of Use Case Scenarios based on business requirements and Business Rules.
• Developed system process flows and User Requirements Specifications through surveys and interviews.
• Converted Business specification in Functional Specification documents.
• Conducted Use-Case reviews to identify the deficiencies of the current system and to identify the requirements for the proposed system.
• Participate in collaboration sessions with business users, technical team, DBAs, testing team to analyze and validate the requirements and application lifecycle.
• Utilized tableau for dashboard and user stories creation. Worked closely with the Tableau development team to make sure they understood the reporting requirements and that the Data Marts developed met those requirements.
• Performed UAT on the Data Marts and validated the models against the business requirements.
• Prepared the ETL mapping specifications to extract data from the existing source systems to the Data marts.
• Assisted ETL developers with the design and development of ETL workflows for extracting, cleansing, transforming, integrating, and loading data into different Data Marts.
• Maintained data consistency and database integrity and attended team meetings to identify requirements for data loading and reporting.
• Documented data sources and transformation rules required populating and maintaining data warehouse content.
• Created and managed project templates, use case project templates, requirement types and traceability relationships in Requisite Pro and managed the concurrence of the parties involved with respect to the evaluation criterion.
• Documented the Purpose of mapping so as to facilitate the personnel to understand the process and in corporate the changes as and when necessary.
• Developed strategies with Quality Assurance group to implement Test Cases in Quality Center for stress testing and UAT (User Acceptance Testing).
• Wrote Test Plan and created Test cases and scenarios for the various Reports and Dashboards in accordance with the business requirements. Was responsible for writing and updating test plan documents for every version update to the Data Mart.
• Prepared/Reviewed weekly testing status and reports. Presented program-level testing information at meetings as requested.

Environment: Tableau 8.x, Teradata, Oracle, SQL Server, MS Visio, RUP methodology, Rational Rose, Requisite Pro, Microsoft Office Suite ( Word, Excel, Power Point, Visio)

Confidential

Business Analyst

Responsibilities:

• Interacted with Subject Matter Experts (SME), Project Managers, Developers, QA Resources and Participated in collaboration session for managing requirements and to elicit Use Cases.
• Worked in transforming business requirements into user requirement specification, Functional Requirement Specifications Document (FRD).
• Worked with different business users to develop Business Requirement Specifications and gathered Business Rules, Functional & Non-Functional Requirements.
• Documented the AS-IS Business Work flow adhering to UML standards.
• Created Use Case Diagrams in order to show the interaction between the Actors and Use Cases as well as showing the relationship between the Use Cases.
• Presented information, analysis, ideas, and positions in a clear and convincing manner to both technical and nontechnical audiences.
• Coordinated with QA team to make sure they understood the testing requirement properly.
• Performed smoke, Functional and GUI Testing to ensure that the user acceptance criteria are met.
• Coordinated the UAT with the SME'S to make sure that all the Business Requirements are addressed in the application.
• Performed smoke testing for both canned and Ad-hoc reports.
• Managed and worked smoothly with geo-diversified team in different time zone (developers in India, Business and data vendors in EST/PST/CST USA and Canada)
• Performed data analysis to verify quality of data and escalate to data vendors if any discrepancy identified.
• Designed business rules for process flow for training purposes using MS Visio and Balsamiq.
• Researched and documented data dictionary, glossary via interviews.
• AGILE project management using TFS, including backlog management and maintaining status reports.
• Managed the product backlog of future development tasks and project timelines as part of the agile methodology for software development also providing project estimates and frequently performed gap analysis to reduce any discrepancies when required.
• Responsible for requirements gathering, identifying data set and data analysis of data for dashboards and reports utilizing software for its end users.
• Participate in post-production reviews as needed to re-test, reassess metadata, and update required documents when necessary.

Environment: UML, MS Office Suite,MS Visio, Balsamiq, scrum (pre-Agile) implementation, MS TFS, DW, Adhoc reporting, SharePoint, MS Access

Confidential

Business Analyst

Responsibilities:

• 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 specificationsfor Medical Record Review automation efforts.
• Responsible for gathering requirements from various stakeholders and documenting them by creating Product Backlog Items(PBI) using Team Foundation Server (TFS), to be implemented in the sprint and linking PBIs with the roadmap items.
• Performed inception and elaboration of project workflow and approval processes supporting project creation, activation, and shutdown; and data imports.
• Involved in design development and configuration of process flow for import process for site review support application.
• Developed flow diagrams for Business process of the company, UI Wireframes and Mockups using Microsoft Visio and Balsamiq and identifying Business Rules.
• Responsible for meetings with users and stakeholders to identify problems, resolve issues and improve the process to ensure a stable and accurate solution.
• Collaborate with product owners, subject matter experts, and it development and operations teams to develop process flows and data flow diagrams. Utilize TFS, VISIO, and Sharepointto formally document requirements and test cases for the PBIs implemented in a sprint.
• AGILE project management using TFS, including backlog management and maintaining status reports.
• Managed the product backlog of future development tasks and project timelines as part of the agile methodology for software development also providing project estimates and frequently performed gap analysis to reduce any discrepancies when required.
• Involved in functional testing of the product after every release.
• Participate in post-production reviews as needed to re-test, reassess metadata, and update required documents when necessary.

Environment: MS-Office 2010, Team Foundation Server 2010, SQL Server 2008, Balsamiq, Sharepoint 2010, .Net, Agile Scrum

Confidential

Business Analyst

Responsibilities:

• Gathered, analyzed and reviewed the Business Requirements for proposed implementations in the web based applications.
• Organized meetings with business owners and architects to develop a process flow and time line for project work flow and gather necessary analytical data requirements.
• Performed Data mapping and created class diagrams and ER diagrams for Prime Project.
• Data analysis of existing data base to understand the data flow and business rule applied to different data bases.
• Performed impact analysis on business processes, application, medical management, provider reimbursement and reporting.
• AGILE project management using TFS, including backlog management and maintaining status reports.
• Preparing Business Requirements and Functional Requirement Specifications
• Work with team in developing Business Requirement Documents for multiple system change requests and participate in system testing.
• Create UML Diagrams like Use Case and data flow diagrams using MS-Visio.
• Conducted UAT (User Acceptance testing) with client and getting signed off on testing.
• Create monthly/weekly status reports to update the project schedules & deliverable plan.
• Prepared Training Manual for better understanding of the application by its end users
• Work with both developers and QA’s to ensure proactive quality checks within timeline.
• Developed Test Cases, Test plans and strategies with Quality Assurance group to implement them.
• Logged defects into Quality Center/ Application Lifecycle Management while doing Functional Testing and followed through the process until the defects were closed.
• Interacted with the users and logged any defects, enhancements from the UAT.
• Managed the product backlog of future development tasks and project timelines as part of the agile methodology for software development also providing project estimates and frequently performed gap analysis to reduce any discrepancies when required.

Environment: Windows, AGILE, SDLC, UML,MS Office Suite, Teradata, XML, HP Quality center, Rational DOORS

Confidential

Business Analyst Intern

Responsibilities:

• Conducted and participated in collaboration/facilitation sessions with stakeholders and system users to collect the software requirement specifications (SRS) and used to maintain the requirements and Business Rules.
• Used UML notations and RUP methodology to analyze and translate business requirements into system specifications.
• Managed traceability matrix to trace business requirements, functional requirements, and use cases
• Performed in-depth gap analysis with different business groups to ensure that the system initiatives are met
• Extensively used SQL for data analysis.
• Create UML Diagrams like Use Case and data flow diagrams using MS-Visio. Also created Data mapping and class diagrams.
• Helped data modelers with their ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) to match with business requirements extensively through ERWin.
• Researched and documented data dictionary, glossary via interviews.
• Extensively helped ETL developers with mapping documents for better understanding of data flow.
• Developed Data Conversion Strategy for converting historical data into the new ORACLE data base including navigating, data scrubbing, conversion and manipulation.
• Conducted user acceptance testing (UAT) of the web based application with the QA team.
• Assisted in designing test plans, test scenarios and test cases for integration, regression and user acceptance testing using testing tool and defect management.
• Participated in the team meetings to discuss the issues arising out of testing.
• Successfully worked with Oracle database and related tools, for example TOAD, SQL/PL SQL etc.

Environment: MS office suite, Oracle, HP Quality Center, MS Access, UML, scrum (Pre Agile) implementation, SQL server 2010, Erwin, EDW, Teradata, DB2, HP Quality center