SUMMARY

• Focused, result - oriented, and pragmatic business analyst with over 8+ years of experience in working with cross-functional and self-organizing teams.
• Proficient analytical skills to understand the business requirements and document them in Functional Specification Document, Software Requirements Specification (SRS), Business Requirements Document, Requirements Definition Document, General design Document, Test Plan, Test Preparation, Test Scenarios, Test Cases, and Test Execution as well as documenting project processes and procedures.
• Experience in performing GAP Analysis, SWOT analysis, and Risk Analysis.
• Assisted in performing Cost Benefit Analysis, Feasibility Analysis, and Estimation of ROI.
• Experience in different methodologies like Waterfall, Scrum, hybrid of Waterfall-Hybrid, and V-model.
• Proficient in eliciting requirements using JAD sessions, Requirement Workshops, Questionnaire, and Survey with Business Users, SMEs, Project Managers, and Technical Team to understand the business process and stakeholders.
• Facilitated Change Management / Requirement Churn across entire process from project conceptualization to testing through project delivery, software development, and implementation management in business/technical environments.
• Extensive experience in UML Modeling like Activity Diagrams, Sequence Diagrams, and Use Case Diagrams, Process Work Flow Diagrams, Class Diagrams using Rational Rose and MS Visio.
• Experience with various tools for planning, tracking, and managing projects such as Atlassian Jira, Team Foundation Server (TFS), and MS Project Professional and collaboration tool like SharePoint.
• Admin/Owner of Liquid Planner, and kept a constant track of all critical milestones and communicated the status to business and technical teams and keep project on track by identifying blockers, dependencies, and dependents. Also communicated it to Director, Vice President, and Business Users of the project.
• Assisted Data Architect in creating Data Models, such as Conceptual model and Logical model in the form of entities and relationships to capture the user requirements properly in the underlying database.
• Proficient knowledge of Data Warehousing Architecture, Data Analysis, Implementation Approaches, Schemas, and Dimensional Modeling. Hands on experience in translating the business requirements into various types of Dimensions.
• Assisted Data Architect in performing ETL Process using Informatica and SSIS to load the data into the data warehouse from various disparate sources. Assisted in creation of Data Marts and Operational Data Stores and also assisted in deploying an OLAP cube and performing various operations such as Roll-up, Drill-Down, Slice, Dice and Pivot through SSAS, designing and deploying various reports through SSRS, Tableau, and IBM Cognos.
• Used simple SQL queries to verify data mapping and to retrieve data.
• Having the know-how of web technologies like SOA Framework, Ajax, SOAP, Web Services, WSDL, REST, MVC and Three Tier Architecture.
• Knowledge about Client-Side, Server-Side Validation, HTML, and XML.
• Developed user manuals and trained users on newly developed and existing applications.
• Expertise in Analysis of Problem Severity, Defect Tracking System, and Defects Reporting System.
• Good Inter-personal skills gained through interaction with technical and functional teams. Capable of quickly learning and delivering solutions as an individual and as part of a team.
• Excellent communication, written and oral skills, highly-organized, proven ability to plan, self-motivated, capable mentor, problem-solving, critical thinking, conflict resolution, facilitation, commitment, result-oriented, hard-working with quest, and documentation skills along with good process management skills to gather requirements.

TECHNICAL SKILLS

Operating Systems: Windows XP, Vista, 7, 8.1, 10

Modeling Tools: MS Visio, Balsamiq Mockups, Wireframes, Rational Rose

SDLC Methodologies: Waterfall, Agile, Scrum, V-Model

Requirement Management: JIRA, Rally, MS TFS, HP QC, HP ALM

Business Skills: SWOT Analysis, Change Management/Requirement Churn, JAD Sessions, Project Scheduling

Project Management and Collaboration Tools: Liquid Planner, MS Project, SharePoint 2007, 2010, MS TFS

Testing Tools: HP QC v10.0, HP ALM, HP LoadRunner, Fiddler

ETL and Reporting Tools: Informatica, IBM Data Stage, Tableau Desktop, IBM Cognos, Spotfire, SQL Server Data Tools

Languages: HTML, XML, SQL, CSS, Java, JavaScript, jQuery, C, C++

Databases: MS SQL Server 2008 R2, 2012, MS Access, Oracle 10g, 11g

PROFESSIONAL EXPERIENCE

Confidential, Akron, OH

Business Systems Analyst

Responsibilities:

• Involved throughout the agile methodology focusing on Scrum in combination with Waterfall.
• Reviewed and managed Requirement Traceability Matrix (RTM) and managed requirements.
• Conducted GAP analysis on the existing requirements and also derived requirements from existing ones.
• Conducted various walkthrough sessions withbusiness, developers, and test team and communicated my observations from the gap analysis.
• Worked closely with the SME's,businessusers, and developers to facilitate and better understand the project.
• Work closely with the manager to facilitate meetings, be the scribe, and update project plans/schedules.
• Updated Weekly Status Report every Friday and sent across to all Project Managers, Director, and Vice President of our project.
• Admin/Owner of Liquid Planner, where I kept a constant track of all critical milestones and communicated the status to business and technical teams and keep project on track by identifying blockers, dependencies, and dependents.
• Generated reports from based on Liquid Planner and projected the timeline shift to Vice President, and Business Users of our project.
• Assisted the project manager on project management tasks such as project scope development, deliverables identification, and Change Management.
• Maintain and review user stories, tests, and worked on JIRA for bug tracking, issue tracking, and project management functions.
• Experience in creation of High-level Data Flow Diagrams (DFD) to depict the source-to-Target Mapping
• Created Screen Mock ups, Process flows, current and future state diagrams using MS Visio.
• Hands on experience in Data Profiling, ER Diagrams, Data Modeling, Data Mapping, and ETL process consisting of Extracting data from various heterogeneous sources, Data Cleansing, Data Transformation
• Worked withbusinessteam,systemsanalyst, developers, and test team to resolve any follow up on critical milestones.
• Updated Project manager on status of each requirement on weekly basis including risks, issues, accomplishments and progress of each critical milestone.
• Organize requirements and prepared a document for an internal IT audit team adhering to all rules and format that Signet follows, which is called Requirement Definition Document and General Design Document
• Performed Gap analysis between the formats followed for Signet and Zales Corporation, thereby agreeing upon a stringent hybrid format.
• Prepare a Risk matrix that the Signet can possibly face along with identifying the departments that would be affected.

Environment & Tools: Agile methodology, Java, MS Visio, MS Project, MS Office Suite (Word, Excel, PowerPoint), LiquidPlanner, MySQL, HTML, HTML5, CSS, CSS3, Foundation, JavaScript, jQuery, Confluence, HipChat, Hybris Wiki

Confidential, New York City, NY

Business Systems Analyst

Responsibilities:

• Conducted and facilitated various JAD sessions for multiple iterations withbusinessto gather requirements and perform GAP analysis.
• Conducted walkthrough, demos, preparing Questionnaires, Interview, Brainstorming and presentation of the proposed functionality to stakeholders to filter the requirements.
• Proficient in creating "As-Is" and "To-Be" process flow to determine the process and structure the requirements.
• Established traceability matrix for the current processes and proposed changes.
• Proficient in creating Requirement Specification (SRS) and FRD/FDS capturing Process Flows, Use Case Document, Use Case Diagrams, Activity Diagrams, and Sequence Diagrams.
• Good experience on developing Interactive UI's and Mockups using MS Visio and MS Paint for the proposed functionality describing how varioussystemsand actors will interact will each other and what different use cases are involved to accomplish goals.
• Coach junioranalystin various aspects like how to identify and write the requirements, creating process flows.
• Assisted Project Manager in Data Analysis, Feasibility Analysis and SWOT Analysis to check the compatibility of the existingsystem infrastructure with newbusinessrequirements.
• Worked closely with the SME's,businessusers and developers, to facilitate and better understand the project.
• Proficient in working with testing team, providing relevant test scenarios for System Testing, Integration Testing, and Implementation Testing and make sure that the testing results meetsbusinessexpectations.
• Conducted User Acceptance Testing and Quality Assurance Testing to support functional and maintenance releases.
• Hands on experience in Data Profiling, ER Diagrams, Data Modeling, Data Mapping, and ETL process consisting of Extracting data from various heterogeneous sources, Data Cleansing, Data Transformation, and loading into the data storage like Data Warehouse using Spotfire tool.
• Assisted in writing SQL queries like Select, Update, and Joins to retrieve desired information.
• Worked withbusinessteam,systemsanalyst, developers and test team to resolve any follow up and action items.
• Conducted walkthrough sessions withbusiness, developers and test team.
• Comprehensive knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases.

Environment & Tools: Waterfall, Java, XML, Balsamiq Mockups 3.2, MS Visio, Web Services, HP ALM, JVM, JSP, Spring, Hibernate, Tomcat Apache, jQuery, Eclipse, MS SharePoint 2013, Informatica PowerCenter, Oracle 11g, SQL Server 2012, HP LoadRunner, MS Project, MS Office Suite (Word, Excel, PowerPoint), IBM Cognos.

Confidential, Columbus, OH

Business System Analyst / Scrum Master

Responsibilities:

• Involved throughout the agile methodology focusing on Scrum in combination with Waterfall.
• Conducted GAP analysis to derive requirements for existing systems enhancements.
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly.
• Assisted the project manager on project management tasks such as project scope development, deliverables identification, and Change Management.
• Collaborated with project stakeholders throughout SDLC phases to ensure timely delivery of specified business solutions as per the Agile Scrum Methodology.
• Developed Business Requirements Document (BRD), System Requirement Specification (SRS) Functional Requirements Document (FRD), Use Case Document, Use Case Diagrams, Activity Diagrams, and Sequence Diagrams.
• Defined the in-scope and out of scope requirements for the project team to Avoid Scope Creep.
• Worked on JIRA for bug tracking, issue tracking and project management functions.
• Encouraged the use of Scrum Best Practices and Estimation techniques like Planning Poker and T-Shirt Sizing and Prioritization techniques like MoSCoW and Kano.
• Maintained an Impediment Log and encouraged the team to take up tasks which they felt could be addressed.
• Introduced Test Driven Development (TDD) for a sprint as the team were welcome to experiment and improve team collaboration. After observing the benefits, it was employed for the reminder of the project.
• Assisted in Test Plan and Test cases for User Acceptance Testing and coordinated in UAT testing to check any defect, also helped Product Owner to Prioritize Product Backlog Items.
• Helped the team in breaking down the Epics in to User Stories by using INVEST criteria.
• Facilitated Scrum Ceremonies like Sprint Planning Meetings, Daily Standup Meeting, Sprint Review Meetings, and Sprint Retrospective Meetings.
• Reviewed Sprint Burndown and Release Burndown Charts and helped my team keep track of the Sprint and the project against the planned work.
• Tracked and communicated team velocity and also assisted quality analyst in functional testing of the application prior to demo in the sprint review meeting.
• Wrote SQL Queries to extract data from different data sources to map into central repository using SSIS.
• Used SSRS to generate internal reports to study and analyze the planned interfaces.
• Used Ajax to keep an update on fluctuation in market with respect to securities.
• Assisted ETL developers in Data Analysis and Mapping the extracted data and also applying required Transformation using Spotfire.

Environment & Tools: Scrum-Waterfall Hybrid, .Net, C#, ASP.NET, TFS, IIS, MS SQL Server 2012, Web Services, HP ALM, Rational Rose, JIRA, XML, AJAX, JavaScript, jQuery, Web Services, MS Office, SSIS, SSAS, SSRS.

Confidential, Irving, TX

BusinessAnalyst/Scrum Master

Responsibilities:

• Involved throughout the agile methodology focusing on Scrum in combination with Waterfall.
• Gathered user andbusinessrequirements through JAD sessions, interviews, requirement workshop, and User Interface Mockups.
• Analyzed and assisted in Prioritizing user andbusinessrequirements with the Product Owner and Development Team and documenting them in Product Backlog.
• PreparedUse Case diagrams, Activity Diagrams, and Sequence Diagrams that includes modeling of all the activities ofbusinessfrom conceptual to procedural level in MS Visio.
• Assisted the Data Architect in preparing Conceptual and Logical Data Models.
• Prepared BusinessRequirement Documents (BRD), System Requirements Specification (SRS), Use Case Document, and supporting documents.
• Encouraged the use of Scrum Best Practices and Estimation techniques like Planning Poker and T-Shirt Sizing and Prioritization techniques like MoSCoW and Kano.
• Maintained an Impediment Log and encouraged the team to take up tasks which they felt could be addressed.
• Introduced Test Driven Development (TDD) for a sprint as the team were welcome to experiment and improve team collaboration. After observing the benefits, it was employed for the reminder of the project.
• Coordinated with project managers in the preparation of the project plans with any impact due to Requirement Churn.
• Created and managed Requirement Traceability Matrix (RTM) using Requisite Pro.
• Authored progress and status reports which were then submitted to project management on a weekly basis.
• Created Test Cases to check the functionality of application and assisted in User Acceptance Testing.
• Performed Client-Side Validations to check all functionalities of different modules.
• Worked with the testing team to analyze the test results of the application.
• Responsible for managing development activities, testing, UAT and deployment of changes in production environment.
• Conducted the Blackbox, System, Regression, UAT and Smoke Tests for various phases of this application.

Environment & Tools: Waterfall-Scrum Hybrid, SQL Server, Windows 7, Rational Rose, Rational Requisite Pro, Clear Case, Clear Quest, UML, Rational Suite, MS Visio, MS Project, MS Office (MS Word, MS Excel, MS PowerPoint, MS Access), and XML.

Confidential

Java Developer/ Junior Business Analyst

Responsibilities:

• Elicited project requirements by conducting JAD sessions, document analysis, requirements workshops, and interviews with Subject Matter Experts (SME) and stakeholders.
• Participated in thebusinessrequirements analysis meetings and prepared Use Case Diagrams, Class Diagrams, Sequence Diagrams and Activity Diagrams using Rational Rose.
• Developed a high level Business Requirements Document (BRD) and Functional Requirements Specification (FSD) document and had them base-lined from the business owner.
• Involved in designing the user interfaces using JSPs.
• Developed custom tags, JSTL to support custom User Interfaces.
• Developed the application using Spring Framework that leverages classical Model View Layer (MVC) architecture.
• Used Eclipse for writing code for Java Server Pages and Servlets.
• Coordinated with project managers in the preparation of the project plans with any impact due to Change Management.
• Implemented the application using the concrete principles laid down by several design patterns such as MVC, Business Delegate, Data Access Object, Singleton and Factory.
• Developed JUnit test cases for all the developed modules.
• Refactored the application modules by applying Test Driven Development.
• Used CVS for version control across common source code used by developers.
• Used JDBC to invoke Stored Procedures and database connectivity to ORACLE.
• DAO was implemented using spring framework.
• Ensured Client/ Stakeholder satisfaction on delivery of the product.
• Used AJAX and JavaScript for validations and integrating business server side components on the client side with in the browser.
• Involved in Unit testing, Integration testing, Implementation testing, and Customer Support.
• Assisted in developing Java Server Pages for User Interface and Servlets, Java classes for business logic.
• Utilized JavaScript for client side validation.
• Utilized Oracle PL/SQL for database operations using JDBC API.
• Implemented Data Access Object for Oracle RDBMS for DML Operations like Insert, Update, Delete the records.
• Is used for Software Configuration Management and Deployed the Applications on Application Server.
• Prepared Test Cases, Software Documentation, User Manual, and Deployment Document.

Environments & Tools: Core Java, JSP, JavaScript, Servlets, PL/SQL, RDBMS, Apache Tomcat, NetBeans