PROFESSIONAL SUMMARY:

• An innovative and dynamic Business System Analyst with over 6+ years of corporate experience and successful background in Business Analysis, Business Modeling
• Requirement Gathering, Data Analysis. Certified Scrum Master with a proven track record of working in self - organizing and cross-functional team.
• Thorough understanding of Software Development Lifecycle (SDLC) and implementing projects in Banking, E-Commerce/Retail, Mortgage and Inventory sector.
• Lead and manage all aspects of a project from Business Analysis to project planning, engaging, business process improvement (BPR) and modeling, driving IT system design and implementation.
• Expertise in conducting Gap analysis, Risk Analysis, Impact Analysis, Cost-Benefit Analysis, ROI analysis and SWOT analysis to check the compatibility of the existing system infrastructure with new Business Requirements.
• Extensive knowledge, expertise and experience in gathering, managing and documenting business requirements, communicating effectively with Stakeholders including: Business users SMEs and Tech Leads.
• Possess the managerial skills to be task and relationship oriented and to coach the team to work in an effective collaborative environment and be more productivity at enterprise level.
• Work closely with the PM to schedule the project plan and WBS so that project works smoothly throughout.
• Excellent facilitation skills and experienced in conducting joint application development (JAD), Focus groups, interviews, survey/questionnaires, brainstorming sessions, document analysis and requirement workshops to elicited requirements involving vast set of interactions with various stakeholders.
• Worked in Test driven development(TDD) with agile framework as a scrum master and business analyst.
• Set priorities, develop a work schedule, monitor progress towards goals and track the data/details/information.
• Excellent writing and documentation skills in creating, modifying and analyzing Process Maps, Business rules, Business Process Reengineering (BPR), Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, User stories/flows, Functional Specifications (FSD).
• Adept at creating and transforming business requirements into system requirements and designing business models using UML diagrams - Use Case, Sequence and Activity diagrams in MS Visio and Rational Rose as well as creating mock-up screens and prototyping with HTML component tools like Balsamiq and MS Visio.
• Comprehensive knowledge and effective experience of SDLC methodologies including AGILE methodologies and traditional methodology like WATERFALL as well as Waterfall-Scrum hybrid.
• Through understanding and working experience of domains like E-commerce/Retail, Banking and Mortgage.
• Experienced in designing the dimensional modeling, Star and Snow Flake schemas, Fact and dimension tables, Physical and logical data modelling using Erwin modelling tool.
• Good Knowledge of creating SQL Queries to create Data Mapping and Data Warehousing.
• Used SharePoint for the document management system and is various components for content management and maintaining the data.
• Understanding of various database concepts like Data warehousing, OLTP, OLAP, data marts and data mining.
• Efficient in using SharePoint for content management and maintain all the documents for the project.
• Implemented stages of development processes including extraction, transformation and loading (ETL) data from various sources into Data warehouse and Data Marts using Informatica Power Center.
• Skilled as a liaison between technical team and management, change agent with an ability to communicate technical information to non-technical stakeholders and translate requirements into system concepts.
• Well versed in different management scenarios like Change Control, Quality Assurance, Solution Assesment, System Integration, Scheduling/Time Box Management and Conflict Management.
• Experience of mentoring the team and providing business value oriented conflict resolution.
• Highly skilled as Scrum Master, facilitating different scrum ceremonies and conducting Planning poker, MoSCoW, T-shirt sizing and other estimation techniques in Scrum Process.
• Strong understanding of Software Testing Techniques especially those performed or assisted by BA including Black Box testing, Regression testing, and User Acceptance Testing.
• Expertise in preparing Test Plan, Test Scenarios, Test Documentation, Test Scripts and Test Cases; coordinating User Acceptance Testing (UAT), and various need based testing.

TECHNICAL SKILLS:

METHODOLOGIES: SDLC; Waterfall, Agile, Waterfall Scrum Hybrid, Spiral

PLATFORM: Windows XP/7/8/2000, Java, .net

BUSINESS MANAGEMENT TOOLS: COST-BENEFIT & IMPACT Analysis, Process Modeling, Change Management, GAP Analysis, SWOT Analysis, Risk Analysis, JAD Sessions, Project Scheduling, Project Budgeting

DATABASES: Oracle 10g/9i, MS Access, SQL Server 2012/2008/2005 , MYSQL

DOCUMENTATION TOOLS: SharePoint 2013,2010,2007, MS Office (Word/Excel/PowerPoint/Visio)

MODELING TOOLS: Mock up Screens, Balsamiq, MS Visio, Rational Enterprise Suite, UML, E-R diagrams.

TESTING TOOLS: HP QC v10.0, HP ALM v11.5, TFS, JIRA, Rally

ETL TOOLS: Informatica Power Center v9.x, SSAS, SSIS, SSRS

REPORTING TOOLS: Tableau Desktop, IBM Cognos v10, MS Office Suite

DATA WAREHOUSING: Data Marts, OLTP, OLAP, Multidimensional Analysis, Data Mining, Slicing/Dicing, Drill Down/Roll Up, STATISTICA

FRAMEWORKS: Web services (SOAP, RESTFUL), SOA, WSDL, UDDI, JavaScript, jQuery, JSON

PROFESSIONAL EXPERIENCE:

Confidential, HILLSBORO-OREGON

LEAD BUSINESS SYSTEMS ANALYST

Responsibilities:

• Worked with the Product Owner, SME’s and project stake holders to better understand the project scope and business value. Performed document analysis to derive business rules from legacy system and validated them.
• Helped PO and PM in ROI Analysis, Cost-Benefit Analysis and root cause analysis in order to be prepared for potential business and technical risks to the system and to check the compatibility.
• Worked in SaFe environment at an enterprise level to implement agile throughout the organization.
• Gathered, analyzed, and documented high level business requirements from the business owners and stakeholders by using different elicitation techniques like JAD Sessions, Interviews, Job-Shadowing and Brainstorming Sessions.
• Created artifacts like Business Requirements Document (BRD), Functional Requirements Document (FRD/LLD).
• Helped in preparation of System Requirements Specification (SRS) to enable the development team to have a better understanding of the requirements and business needs.
• Documented data mapping specifications from source to target and defining transformation, business and logical rules by using store procedures and views in sql server.
• Involved in the Business Process Modelling (BPM) and designed business models using UML diagrams - Use Case, Sequence diagrams and Activity diagrams and Data Flow diagrams in MS Visio.
• Analyzed requirements wrote User Stories and managed Agile Lifecycle in TFS from planning to sprint deployment. Tracked and communicated team velocity and sprint/release progress.
• Worked in TFS to defect tracking and monitoring the status of the issues, closing defects etc.
• Used techniques like Planning Poker, T-shirt Sizing for estimating the size of user stories in terms of story points.
• Facilitated and time-boxed the SCRUM ceremonies (Sprint Planning Meeting, Daily Stand-ups, Sprint Review Meeting, Sprint Retrospective Meeting and Grooming Sessions)
• Follow up on Sprint backlog and effectively communicate both externally and internally within the team to keep posting progress to management and seek out approval or assistance whenever bottle neck issues prevail.
• Reviewed and assisted the team in functional testing of the application prior to demo in the sprint review meeting and maintained the Sprint and Release Burn Down chart charts to keep track of the Sprint.
• Effectively manage change by deploying change management techniques such as Change Assessment and Impact Analysis and establish Change Control procedures using RationalClearQuest. Wrote test cases, test plans, and test scenarios and traceability matrices used by the Quality team; User Acceptance Testing issue log for tracking the defects in TFS and collaborated with system users to conduct UAT.
• Led the User Acceptance Testing (UAT) efforts, and opened/closed defects on QC.
• Extensively assisted in designing the database schema as well as scripted complex SQL queries using DDL and DML commands for database operations and generated Data Mapping documents writing ad-hoc SQL queries using joins to fetch data from the MS SQL Server Management Studio.
• Involved in preparing data mapping specifications from source to target and defining transformation, business and logical rules by using SSMS.
• Assisted in modeling data-mart using Erwin data modelling tool for the further OLAP analysis and in Extraction, Transformation and Loading (ETL) using SSIS.
• Logged and tracked the defects in TFS by creating an error repository and managing it.
• Active part in the testing of the system during Unit testing, Black Box testing, Regression Testing, System Testing.
• Used SharePoint as Content Management System for maintaining documents and records.
• Created Requirement traceability matrix (RTM) in excel and then use that in JIRA to map all the Task ID of a particular requirement for tracing the test cases back to the requirements.

Environment: Scrum, SQL Server Management Studio, MS SharePoint 2016, TFS, SSIS, SSAS, Tableau, MS Office suite, MS Visio, Rational ClearQuest, XML, ASP.net, visual studi

Confidential, BOSTON-MA

SR. BUSINESS SYSTEMS ANALYST/SCRUM MASTER

Responsibilities:

• Created GAP analysis to understand the shortcomings of the existing systems and in the identification of business rules, business system process flows, creating AS-IS/TO BE model.
• Assisted project manager in conducting Cost-benefit analysis, Root cause analysis and Risk analysis.
• Conducted JAD sessions (with all the business owners, Project stakeholders including Tech Leads and SME’s), direct interview sessions, Surveys/Questionnaires to gather business requirements.
• Gathered, analyzed, documented high level business requirements and produced corresponding technical requirement artifacts such as Business Requirement Documents (BRD), System Requirement Specification (SRS).
• Assisted the project manager in determining the goals and the Work Breakdown Structure (WBS) of the project.
• Used MS Visio to create Use case diagrams, Activity diagrams and Sequence diagrams as well as designed Mock-ups and wireframes using mock up screens to get feedback from UI/UX team about the web form designed.
• Was responsible for identifying and documenting business rules and creating detailed diagrams including Business Flow diagram, Creating process models and Data flow diagrams.
• Assisted the Product Owner in prioritizing the Product Backlog Items and created User Stories from EPICS using the INVEST (Independent, Negotiable, Valuable, Estimable, Small, Testable) format in Rally.
• Facilitated Sprint ceremonies (Sprint Planning, Daily Scrum, Sprint Review, Sprint Retrospective and Backlog Grooming) for each sprint in Agile Scrum Methodology as Scrum Master.
• Created and maintained the Sprint Burndown chart and Release Burndown chart to know the progress of sprint in Rally.
• Resolved the external/internal impediments to shield the SCRUM Development team.
• Managed and tracked requirements using HP ALM through Application Life-Cycle.
• Assisted the developers in performing unit testing by writing down test cases, test plans, test scenarios and mapping them with the requirements to meet the expectations.
• Assisted in Data modelling, Data Staging and Data Integration process. Helped in performing ETL from current OLTP to the target data warehouse.
• Generated ad hoc SQL queries using joins and transformation rules to fetch data from the SQL Serverdatabase and to create Data Mapping documents.
• Assisted with the data analyst in performing Data Mining to find correlation and pattern and trends in the existing historical data by using Classification, Regression and Clustering applications of mining.
• Was involved in using Informatica Power Center Designer for the mapping data from the source database to the target database.
• Used MS SharePoint for writing/tracking and maintain the different documentations of the team
• Used Cognos dashboard to generate a report to highlight the requirement pass/fail in testing during UAT.
• Constructed Requirements Traceability Matrix to determine the source of the requirement, ensure all requirements are met and locate affected system components when there is a requirements change. Maintained the traceability matrix until business requirements were signed off.

Environment: Waterfall-Scrum hybrid, Rally, MS Office, IBM Cognos, Informatica, MS Project, Apache Tomcat, JavaScript, JSON, CSS, Eclipse, HP ALM, Wireframes, Balsamiq, SQL Server 2012, SharePoint 2013, UML, UAT testing.

Confidential, FRAMINGHAM, MA

BUSINESS ANALYST

Responsibilities:

• Comprehend and analyze the business case for the project and conducted GAP Analysis to understand the limitations of the existing system and contributed to the design of the future system.
• Worked with the Product Owner, SME’s and project manager to better understand and plan the project scope and business value. Performed document analysis to derive business rules from legacy system and validated them.
• Helped PO and PM in creating the project plan to complete the deliverables within the timeframe.
• Worked closely with the RTE to successfully established and promote SAFe in the organization
• Gathered, analyzed, and documented high level business requirements from the business owners and stakeholders by using different elicitation techniques like JAD Sessions, Interviews, Job-Shadowing and Brainstorming Sessions.
• Created artifacts like Business Requirements Document (BRD), Functional Requirements Document (FRD/LLD).
• Analyzed requirements wrote User Stories and managed Agile Lifecycle in JIRA from planning to sprint deployment. Tracked and communicated run team velocity and sprint/release progress.
• Worked with JIRA to defect tracking and monitoring the status of the issues, closing defects etc.
• Used estimation techniques like Planning Poker, T-shirt Sizing for estimating the size of user stories in terms of story points and to complete sprints in time.
• Follow up on Sprint backlog and effectively communicate both externally and internally within the team to keep posting progress to management and seek out approval or assistance whenever bottle neck issues prevail.
• Reviewed and assisted the team in functional testing of the application prior to demo in the sprint review meeting and maintained the Sprint and Release Burn Down chart charts to keep track of the Sprint.
• Effectively manage change by deploying change management techniques such as Change Assessment and Impact Analysis and establish Change Control procedures using Rational ClearQuest.
• Wrote test cases, test plans, and test scenarios and traceability matrices used by the Quality team; User Acceptance Testing issue log for tracking the defects in JIRA and collaborated with system users to conduct UAT.
• Led the User Acceptance Testing (UAT) efforts, and opened/closed defects on QC.
• Worked towards resolving the dependencies and impediments that came across during the project.
• Performed data profiling and match business requirements to the sources of data within systems to cleanse the data and ensure the data quality issues that be corrected in the source system by using data flux tool.
• Documented data mapping specifications from source to target and defining transformation, business and logical rules by using SSIS.
• Assisted in modeling data-mart using Erwin data modelling tool for the further OLAP analysis and in Extraction, Transformation and Loading (ETL) using SSIS.
• Worked on the database to upload the files on the internal server using SQL server in .net environment.
• Logged and tracked the defects using HP Quality Center by creating an error repository and managing it.
• Active part in the testing of the system during Unit testing, Black Box testing, Regression Testing, System Testing.
• Created Requirement traceability matrix (RTM) in excel and then use that in JIRA to map all the Task ID of a requirement for tracing the test cases back to the requirements.
• Used SSRS to generate internal reports to study and analyze the planned interfaces.

Environment: Waterfall-Scrum Hybrid, JIRA, SQL server 2012, MS SharePoint 2013, SSIS, SSAS, Tableau, MS Office suite, MS Visio, HP QC, Rational ClearQuest, XML, ASP.net, visual studio, IIS, SOAP.

Confidential

JR. BUSINESS ANALYST

Responsibilities:

• Served as a liaison between the company, stakeholders, and solutions team to elicit, analyze, validate, and document business requirements and process specifications into system requirements.
• Designed and documented business process flows for tracking products levels, order fulfillment, store sales and merchandising using MS Visio, and validated them with Subject Matter Experts.
• Collaborated with functional managers and back-end application users to identify integration requirements with the supply chain management and warehousing systems.
• Performed GapAnalysis to check the compatibility of the existing inventory control infrastructure with the new business requirements, and determined traceability and dependability between the requirements using Rational RequisitePro.
• Utilized SQL (queries) programming to determine current product sales, supply and demand trends, business logic, and recommended strategies that delivered expected business value.
• Documented and developed test strategies, test plan, test cases using HP QC and tracked all the test scenarios and issues for the application.
• Facilitated UserAcceptanceTesting (UAT) of the various inventory interfaces with stakeholders and users.

Environment: MS Office Suite, Waterfall, IBM Cognos, Windows 2000, Rational Requisite Pro, SQL server, TOAD, Visio, UML, HP QC