PROFESSIONAL SUMMARY:

• Experience in Business Requirements Gathering, Application Design Specifications, Development and Testing.
• Excellent analytical skills to understand the business processes and functionality, requirements and to translate them to system requirement specifications (SRS).
• Experience in Data Analysis, Gap analysis, Business Requirements, Traceability Matrix.
• Experience in creating Context Diagrams and Unified Modeling Language (UML) diagrams such as Use Case diagrams, Activity diagrams, Class diagrams and Sequence diagrams using MS Visio.
• Experience as JAD (Joint Application Development) Facilitator and Meetings Coordinator ensuring that change and New
• Process is organized, managed, documented, controlled and risk weighted
• Proficient in Tableau Desktop (9.x, 10.x).
• Experience in developing various kinds of Views, Workbooks as per business requirements by utilizing Charts (Bar Graphs, Dual Axis, Pie - Charts, Bubble Charts, Scatter Plots, Heat Maps, Tree Maps, Funnel Charts), Filters, Pages, Calculated Fields, Groups, Parameters, Sets, Dynamic Sorting, Table calculations, Trend lines, Forecasting etc.
• Experience in using burn down charts to prioritize product backlog and track the progress of each sprint.
• Hands on experience in working with Microsoft Project.
• Expertise in Software Development Life Cycle (SDLC) including Waterfall, Agile, RAD, SCRUM, RUP methodology
• Experience on Performing data mapping and data logic on BPM.
• Facilitated as Scrum Master mostly in the absence of Project Manager
• Adapt with scripting Business Requirement Documents (BRDs), Functional Specifications Documents (FSDs)
• Assisted QA’s in various types of testing including Smoke Testing, Functionality Testing, Performance Testing, Volume Testing, Unit Testing, Integrated Testing, System Testing, Positive and Negative Testing, Security Testing, Stress Testing, Load Testing etc.
• Proficient in requirements collection, from clients and processing information to the project team
• Maintained Governance documentation of SharePoint Intranet.
• Prepared Visio and SharePoint workflows for projects, meetings and client use.
• Good expertise in the review and documentation of system test plans, creating and executing test scripts, test cases and data sets on the basis of product release features requirements and technical documents.
• Experience in coordinating sessions to analyze workflows, define requirements and document business processes.
• Understanding of ACH transactions.
• Good Understanding of Full Software Development Life Cycle (SDLC) experience including Analysis, Design and Review of Business and Software Requirement Specifications and Agile software development methodology
• Knowledge on Connected Car technology.
• A self-starter, motivated team player with Leadership abilities with excellent communication and interpersonal skills

TECHNICAL SKILLS:

Project Management: Project planning; Process improvement, resources and timeline; PMBOK Methodology

Methodologies: Agile, Waterfall, RUP, UML, SDLC, Scrum

Change Management Tools: Rational Clear Quest, Rational Clear Case

Business Modeling & Versioning Tools: MS Visio, Visual Paradigm, Rational Rose; Rational Requisite Pro, Rational Clear Case

MS Office: MS Project, MS Word, MS Excel, MS Power Point, MS Access

Programming Languages: Structured Query Language (SQL)

Operating Systems: Windows NT/98/2000/XP/7

Databases: MS Access, Oracle 8i/9i/10g, MS SQL Server 7.0/2000

OLAP Tools: Business Objects XI, Cognos

Testing & Defect Management Tools: Rational clear quest, HP Quality Center, HP ALM

PROFESSIONAL EXPERIENCE:

Confidential, York, MI

Business Analyst

Responsibilities:

• Worked with the user groups to elicit, analyze and document data and reporting requirements
• Held meetings sessions with business process owners Vendors, customer service team and the marketing team for requirements gathering during the definition stage.
• Gathered analyzed and documented requirements and translated business requirements to technical requirements for the developers.
• Maintained requirements in JIRA for tracking and testing purposes.
• Was involved in entering the bugs in JIRA.
• Assisted the project manager in preparation of project charter and project scoping.
• Assisted in simulation of Business Process Models in BPM.
• Prepared the project Milestones with the help of MS Project.
• Validated internal processes to ensure data accuracy and integrity.
• Performed extensive business requirement analysis including Data Analysis and Gap Analysis.
• Used Microsoft Visio extensively to flow out the business requirements and Microsoft PowerPoint for presentations.
• Performed Data mining of the application to determine data properties and structure.
• Created SQL scripts to extract the data from the operational database into simple flat text files.
• Validated XML files using SOAP UI.
• Worked on embedded modem systems for connected vehicles.
• Performed the Back-End Testing to ensure data consistency and accuracy by writing and executing SQL statements on Oracle Database.
• Created HTML and Visio screen mockups to use in prototype review sessions.
• Extensively used SQL statements to query the Oracle Database for Data Validation and Data Integrity.
• Extensively wrote standard and complex SQL queries to perform data validation to make sure test results matched.
• Experience with XML for data presentation and communication.
• Responsible for continuous process improvement and for identifying and maintaining a clear and measurable Development Process that is deployable throughout the enterprise using Agile Methodology.
• Utilized use case diagrams during analysis to capture the requirements.
• Helped creating a common outlook module to auto generates the meeting invitations in Microsoft Outlook.
• Used MS SQL Server Database query for analysis.
• Acted as a liaison between management and development team for requirements and testing.
• Participated in the planning and execution of the User Acceptance Testing (UAT) effort.
• Ensured application forms and reports (UI) followed client’s development standards and guidelines in terms of usage, naming conventions etc.
• Conducted workshops training for internal users.

Environment: Windows 7, Microsoft Office SharePoint 2010, Rational Requisite Pro, MS Office, SQL Server, MS Project, MS Access, UML

Confidential, San Francisco, CA

Business Analyst

Responsibilities:

• Understanding of various regulatory and financial requirements.
• Gathered requirements using SharePoint and created Document Libraries/Lists
• Created and Maintained Project Plans in MS Project 2007/10 and SharePoint Gantt Task List.
• Maintained and created SharePoint 2007 repository for BA group requirement documents for IT auditing standards.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.
• Clarified QA team issues and reviewed test plans and test scripts developed by QA team to make sure that all requirements will be covered in scripts and tested properly
• Participated in the bug review meetings, updated requirements document as per business user feedback and change in functionality of the application.
• Capture the Data Change across time.
• Facilitated Joint Application Development (JAD) sessions with committee of SMEs from various business areas.
• Extensively used JIRA as a project management tool.
• Liaison between business, Development and QA.
• Convert business requirements into technical requirements, write test plans and UAT.
• Conducting requirement gathering sessions, feasibility studies and organizing the software requirements in a structured way.
• Walk through of the mapping documents and BRD's to Dev, QA and UAT teams.
• Developed BPMN flows in VISIO and documented User Stories.
• Exclusively used MS Visio, MS Project and MS Office Suite throughout the project.
• Involved in up-gradation of Tableau Server from 8.x to 10.x and documented for future use.
• Extracted data from different data sources like SQL Server, MySQL and Tableau Server and created queries based on the requirement to provide data visually.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Acted a project manager/business analyst for the Buy-In project and build a new application using service oriented architecture (SOA) and XML to assist the Stock-Borrow Loan team in sending Buy-In requests to DTC for post settlement date clearings.
• Assisted the project manager in preparing the project schedules, milestone tracking, and resource allocation using MS Project
• Created test cases for the application under different releases and wrote SQL Queries to check the data
• Created Traceability Matrix to trace each Test Case and associated them with the registered requirement
• Understanding the SQL code to get the mappings from source to target.
• Clarify the questions from Dev, QA and UAT teams.
• Used data source filters for high volume of data to improve performance of the reports.
• Understanding and mapping product and customer information data.
• Unifying data across the systems by understanding and mapping conformed values from business.

Environment: MS Visio, MS Word, MS Share point, MS Access, JIRA, MS Excel, SQL, Rational Requisite Pro, Windows XP, Tableau

Confidential,San Francisco, CA

Business Analyst

Responsibilities:

• Extracted the Business Requirements from the Business Users and documented it for the developers conducting JAD sessions and Interviews.
• Interacted with client and the Technical Team for requirement gathering and translation of Business Requirement to Technical specifications.
• Conducted Web Meetings with Off-Shore team members to ensure that everybody is on the same page.
• Responsible for the newly enhanced web application with Site core Web Content Management System in Graphic User Interface (GUI).
• Collected weekly status reports to ensure that all deliverables are met on time and on schedule.
• Created Use Cases from the list of requirements and prepared use case diagrams
• Involved in integration testing with added features like color and size.
• Created and maintained an Excel database.
• Worked with Site core Platform specialist for the platform’s core capabilities. Consulted on information architecture, content reusability and strategies for extending the platform through custom development and integration of third-party systems.
• Experience on defining XML schemas for web services.
• Implemented SDLC for the development life cycle and followed the standard process in the application development through agile methodology.
• Attended in daily standup status meeting for outlining goals for the day and discussion of current or potential blockers, enhancement and modification.
• Worked on requirements for various modules covered under Retail and Global E-Commerce and POS apps.
• Handled testing activities for implementing and rollback procedures while deploying enhancements into production.
• Worked closely with the User Acceptance Test Coordinator, Project Manager and Business System Analysts to understand business processes and develop concrete UAT cases.
• Performed Data mining of the application to determine data properties and structure.
• Created SQL scripts to extract the data from the operational database into simple flat text files.
• Performed regression tests on each module and collectively to check for functionality.

Environment: MS Visio, MS Word, MS Share point, MS Access, JIRA, MS Excel, SQL, Rational Requisite Pro, Windows XP

Confidential

Business Analyst

Responsibilities:

• Responsible for continuous process improvement and for identifying and maintaining a clear and measurable Development Process that is deployable throughout the enterprise using Agile Methodology.
• Used use case diagrams during analysis to capture the requirements.
• Attended daily Scrum meetings, kept up-to-date on best practices for JavaScript frameworks and techniques.
• Worked closely with Business teams on aligning business requirements with technical ones.
• Designed and implement front-end projects of various scope.
• Built and maintain the presentation layer of Hotwires site.
• Strict adherence to W3C standards and cross browser compatibilities.
• Designed and implemented multiple new features in hotwire.com related to Hotel Room search and purchase using AJAX, JQuery, Angular JS, CSS3 and HTML5.
• Worked with JQuery Plugins to improve user experience, using Data Table, Data Charts to show the amount, availability of the hotel room left.
• Developed the flow diagrams for business process of the company using Microsoft Visio and analyzed and documented the requirement in Microsoft Word.
• Helped creating a Common Outlook Module to auto generates the Meeting Invitation in Microsoft Outlook.
• Acted as a liaison between management & development team for requirements & QA.
• Participated in the planning and execution of the User Acceptance Testing effort.
• Ensured application forms and reports (UI) followed client’s development standards and guidelines in terms of usage, naming conventions etc.
• Conducted workshops for internal users to provide training.
• Worked with stakeholders on Joint Application development (JAD) during prototyping phase of SDLC.
• Involved throughout the business System Development Life Cycle (SDLC).
• Worked with SCRUM Project Management and Agile Methodologies for Software development Life Cycle.
• Conducted GAP analysis of the different reports that are being presented to clients to accommodate their requirements for the new enhancements.
• Utilized Rational Unified Process (RUP) to configure and develop process, standards, and procedures.
• Facilitated JAD sessions with model diagrams to elicit future state business requirements and to document Business Use Case To-Be artifacts.
• Created SQL scripts to validate the inputs.
• Worked with QA team to develop performance test cases based on projected user load.
• Involved in all stages of testing process - Development of Test scripts and Test cases based upon requirements for Functional Testing, Integration Testing and support for User Acceptance Testing.
• Used Rational tools to document and manage requirements, enhancement requests, and other documentation issues for the application.
• Worked with management to create and communicate critical information to the user community via email and discussion boards.

Environment: Pencil Project, MS Office (Word, Excel, Power Point),JavaScript RUP, Share Point, MS Visio, Microsoft Outlook