Business Analyst
Resume:
NISHANT PATEL
Silver Spring, MD 20904
Email: ***********@*****.***
Summary:
• Over 5+years of experience as a Business Analyst with solid understanding of Business Requirement Gathering, Business Process Flow, Business Process Modeling.
• Experience working with SQL (2000/2005), ETL using SSIS, Reporting services using SSRS.
• Thorough understanding of various phases of Software Development Life Cycle (SDLC), like Requirements Gathering, Analysis/Design, Development and Testing and Practical knowledge of Rational Unified Process (RUP), Waterfall, Agile methodologies.
• Worked with leading Financial, Health Care and Retail Services Solutions domains.
• Organized many Joint Application Developments (JAD) sessions and Joint Requirement Planning sessions (JRP), walkthrough, Interviews, Workshops and Rapid Application Development (RAD) sessions with end-user/clients/stake holders and the IT group.
• Proficient in analyzing and creating UML, Use Case Diagram, Sequence Diagram, Activity diagram, Data flow diagrams and Business flow diagrams using MS Visio.
• Good experience with conducting GAP analysis.
• Proficient in the use of tools like Rational Rose, Requisite Pro, Rational Clear Case and MS Visio.
• Experience in tracing requirements throughout the development process using the Requirements Traceability Matrix (RTM)
• Data warehousing design and development and Star/Snowflake schema data modeling.
• Experience in Fine Tuning SQL queries and T-SQL queries & improving the performance of the Database.
• Knowledge in writing queries using Structured Query Language (SQL) to manipulate the data from database.
• Experience of creating repots using SSRS and creating packages using ETL (SSIS) tool from the scratch.
• Extensive experience in System Testing and User Acceptance Testing (UAT) and Proficiency in designing Test Plans and Test Cases.
• Expertise in Technical Writing and developing User Manuals for the end users.
• Ability to work independently and manage business requirements with a delivery-focused approach and the ability to build and maintain strong working relationships with business sponsors and technical specialists.
TECHNICAL SKILLS:
Operating System : Windows (Word, Excel, Access, Outlook), 2000/XP, MS DOS
Languages : T-SQL, PL/SQL
RDBMS : SQL Server (7.0, 2000. 20005), Oracle (7.3, 8i, 9i)
Web : HTML, XML, IIS 3.0/4.0
Database Tools : SQL Server Enterprise Manager, SQL Profiler, SQL Analyzer, DTS Import/Export, OLAP Services, SQL Agents Jobs, SSAS, SSRS, SSIS
Methodologies : SDLC, Waterfall, RUP, AGILE and RAD
Business Tools : Rational Rose, MS Visio, Rational Requisite Pro, Clear Quest
EDUCATION:
University of Maryland University College Adelphi, MD Master in Biosecurity and Biodefense Pursing
Johnson & Wales University Providence, RI
BS in Electronic Engineering 10/07
K.B.P. Polytechnic Maharashtra, India Diploma in Electronic & Communications Engineering 05/2003
Master Computer Academy Gujarat, India Diploma in Computer Applications (DCA) 07/2000
WORK EXPRIENCE:
National Institutes of Health (NIH), Rockville, MD July 2009 – Feb 2011 Role: Business Analyst
• Involved in assisting the Project Manager in planning, scheduling, and controlling projects based on schedules and requirements outlined by the business.
• Conducted interviews with key business users to collect requirements and business process information.
• Conducted JAD sessions with the key business users and stakeholders.
• Conducted weekly and monthly meetings to review the business processes and the project progress.
• Took care that there is no gap in the requirement gathering phase.
• Created and reviewed Business Requirement Document (BRD) and Functional Requirement Specification (FRS) documents for various Research and Financial projects based on the information provided by the business.
• Involved in analysis of HIPAA compliance and took part in discussions for designing the healthcare transactions to be HIPAA compliant.
• Involved in Data Analysis & Mapping to track all data elements used in the application from the user interface through different interfaces to the target databases in which they are stored.
• Helped QA Team in writing test cases, test plans and tested the final application to verify whether all the User Requirements were catered to by the application.
• Working very closely with other developers for their SQL requirements, work with Business Analyst and end users to understand the report requirements.
• Used Rational Clear Quest for defect tracking and change management request.
• Collected test metrics weekly from the ClearQuest defects database that reflected the status of the test execution and the state of the defects, and presented weekly status report to Project Manager.
• Identified bugs and tracked them to completion using Rational ClearQuest
• Coordinated and prioritized outstanding defects and system requests based on business requirements.
• Supported development of detailed project plans, work assignments, and target dates.
• Organized and performed functional and regression testing and support for User Acceptance Testing (UAT).
• Deployed all the project work using VSS.
Environment:
SQL Server 2000/2005,Oracle 9i, MS Project, MS Visio, Access, Excel, MS Office, Rational ClearQuest, Requisite Pro, VSS.
Magellan Health Services, Columbia, MD Oct 2008 – May 09
Role: Business Analyst/ SQL Developer
Responsibilities:
• Performed Reviews and Audits for internal and external activities for the existing system at Magellan Health care and prepare activity/process flow using MS Visio.
• Prepared process flow/activity diagram for existing system using MS Visio and re-engineer the design based on business requirements.
• Gathered Business Requirements, created Functional Requirements Document (FRD) and analysed data/work-flows, defined the scope, financial projections and cost/benefit analysis; progressed from Problem Statement to well-documented designs. Prepared user guidelines for easy access of the application.
• Used RUP process to Conduct Data Analysis to find missing data fields in the application and customize them and extensively used Rational RequisitePro.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, using UML and Business Process Modelling.
• Conducted JAD sessions to get input on how to implement the application on the project.
• Gathered Business requirements for Integration points and mapped them with Functional requirements and extensively used MS Excel during the course of the project.
• Worked as an Interface between the users and the different teams involved in the application development for better understanding of the business and IT processes.
• Analysed Business Requirements from Black Box testing perspective; reviewed Test Strategy, Traceability Matrices and Test Plans to ensure that test cases reflect user needs for the functional, performance, usability and security requirements.
• Created sample Wire frames to make system better understood by Business and technology teams.
• Followed the UML based methods by using Visio to create Use Cases, Activity Diagrams, Sequence Diagrams, and Class Diagrams.
• Experience in the documentation of system and business requirements and specifications, design and development of use and test-case scenarios and GAP analysis, developing test plans, test scripts using SQL, conducting, User Acceptance Testing (UAT) training, and implementing new processes and technology.
Environment:
SQL Server 2000/2005, MS Project, MS Visio, Access, Excel, Rational RequisitePro, MS Office, MKS
Alta Resources, Neenah, WI Jan 08 – Aug 08
Role: Business Analyst/ SQL Developer
Responsibilities:
• Performed requirements gathering and documented them in the BRD from the business users of the system while adhering to SDLC (Software Development Life Cycle) industry best practices.
• Interacted with Software development team and Business users as a liaison in helping developers to understand the business requirements thereby ensuring the proposed applications comply with the business specifications.
• Adopted Scrum/Agile Methodology for product development
• Devised and prepared concise and effective User Stories.
• Prepared PowerPoint presentations for the clients to present the updates
• Determined precise and accurate User Story acceptance criteria used by developers
• Performed Gap Analysis by identifying existing technologies, documenting the enhancements to meet the end state requirements
• Generated Unified Modeling Language (UML) diagrams such as Use Case diagrams, Activity and sequence diagrams to demonstrate critical processes.
• Created a field-to-field data map that was used as a main specification document for the conversion program using MS Word and MS Excel
• Developed Requirement Traceability Matrix (RTM) for maintaining/updating system requirements using MS Excel.
• Prioritized defects and system problems, ensuring accuracy and deadlines were met. Identified and participated in resolution of business system issues.
• Successfully conducted JAD sessions, which helped synchronize the different Business users on their objectives
• Monitored change requests, documented requirements, integrated them with Use Cases and checked the Business Readiness as well determined activities of flow using Requisite Pro
• Performed user testing of systems (User Acceptance Testing), developing and maintaining quality procedures
• Involved in Functional, Regression, Smoke and Performance testing
Environment:
SQL Server 2000/2005, MS Project, MS Visio, Access, Excel, Requisite Pro, MS Office, TFS
Aurobindo Pharmacy, HYD, India July 03 – Jan 05
Role: Business Analyst/ SQL Developer, Trainee
Responsibilities:
• Responsible for defining the scope of the project and gathering Business Requirements
• Performed Gap and Risk analysis of existing system and evaluated benefits of new system
• Extensively used UML based Methodology to create the Business Object Model
• Reviewed Technical Designs created by the development teams and validated them against functional specifications and provided useful suggestions
• Created Source to Target Mapping Documents based on the Business requirements and System requirements documents
• Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, fund Reports, Portfolio Report, sub-reports, charts, parameterized reports, conditional and dynamic reports
• Created numbers of complex formula in sub report using different type of variables likes shared variable and retrieved them from master report and installing and maintaining MS SQL Server 2000
• Worked with QA team to create Test Plan and Test Cases for User Acceptance Testing
• Entered the various defects found during System Testing and User Acceptance Testing in BugZilla updated the status of the defects in BugZilla periodically, based on the progress
• Coordinated work plans between project manager and client using MS Project
• Created documentation for training and Help Desk teams
• Involved in Project Management activities like documentation and implementation throughout the project lifecycle.
Environment:
SQL Server 2000, MS Project, MS Visio, Access, Excel, BugZilla, MS Office
Contact this candidate