SUMMARY

• Over 6+ years of experience as a Business Analyst in IT Industry with proficiency in Business gathering, reporting, documentation, process mapping, scheduling, planning, and data analysis.
• Proficient in documenting business Process Design, creating business Requirements Document (BRD), Use case Specifications, Functional Specification Document (FSD), Detailed Design Specifications (DDS), User Interface Specifications (UIS).
• Excellent knowledge in manipulating, cleansing &processing data using Excel, Access, and SQL.
• Exposed to various development methodologies like Waterfall, SDLC, Rational Unified Process, Agile (Scrum), sprint planning, sprint review and sprint retrospective.
• Experienced in gathering business requirements, JAD Sessions, Gap Analysis, UML diagrams, Process Flows, Business Documentation, Data Mapping/ Modeling.
• Proficient in analyzing and creating Unified Modeling Language (UML) diagrams such as Use case diagrams, Activity diagrams, Sequence diagrams, Data flow diagrams, Business flow diagrams using MS Visio.
• Experienced in performing Gap analysis by identifying the existing application, Quality assurance, documenting the enhancements to meet the end - Confidential requirements.
• Comprehensive knowledge, a practical exposure and documenting the As-Is/To-Be processes exercises.
• Extensive experience to analyze and document Business Requirements and System Functional Specifications (SRS) including use cases.
• Outstanding organizational skills including the ability to multitask, prioritize, and manage complex issues. Strong verbal and written communication skills.
• Strong experience with Scrum methodology and well versed in writing user stories in the Jira, pivotal tracker.
• Served as Scrum Master to manage the project and the stories with sprint planning and scrum meetings.
• Experience with Unified Modeling Language (UML) diagrams such as Use Cases, Activity Diagrams, Data Flow Diagram, and Process Flow Diagram using Visio and Axure.
• Proficient in MS Word, Excel (graphs, pivot tables, VLOOKUP), Visio, MS Project and Power point skills.
• Expert in tracking and managing requirements through Requirement Traceability Matrix (RTM)
• Strong Experience in writing Test Plans and Test Cases for User Acceptance Testing (UAT), managing test script execution for System/Integration Testing, Regression Testing, Progression Testing, and conducting Smoke Test.
• Basic understanding of creating dashboards with Tableau and Qlik View software.
• Actively participated in Change Management, performed Impact Analysis, maintained Change Log and closely with the Change Control Board (CCB)
• Creating and maintaining project migration schedule with project documentation requirements.
• Worked with a client relationship focus to ensure full awareness of client business workflow, strategy, issues, requirement, and tools.
• The excellent track record of meeting deadlines and submitting deliverables on time. Experience in reviewing Test plans, Test cases and Test case execution using Test Director.
• Extensive experience in performing Functional, Usability and Stress Testing along with ensuring that the software meets the system requirements.
• Expertise in Database Administration of Test Environment Databases, Data Pools and identifying the performance issues due to inefficient Database Administration.

TECHNICAL SKILLS

• Project Methodologies
• RUP, Waterfall, Agile (SCRUM)
• Business Modeling Tools
• MS Visio, Rational Rose
• Test Management / Testing
• HP Quality Center / Application Lifecycle Management (QC/ALM), Rational Quality Manager
• Databases
• Oracle (11g/12C,10g), SQL Server, MS Access, SQL, PL/SQL
• Tools
• MS PROJECT, SQL, HTML, SharePoint, MS Office
• Data Warehousing
• Data Marts, OLTP, OLAP, ROLAP, MOLAP, Oracle, Query/Reporting, Multidimensional Analysis
• BI/ETL tools
• Informatica, SSIS, OBIEE 11g, Informatica Power Center, SQL * Loader
• Operating System
• Windows, Linux, Unix, Mac, Solaris.
• Documents & Processes
• SRS, Use Cases, UML diagrams, FRS, UAT, Test plans & cases, Business Process Modelling, Project Planning & tracking

PROFESSIONAL EXPERIENCE

Project 1- Business Analyst

Confidential, Washington

Responsibilities:

• Responsible for taking requirements from business users, understanding Business Needs by scheduling meeting one regular basis.
• Involved in creating the Project templates, use case specifications, Change request form, functional specification documents, and Business Requirement documents.
• Mentor teams to effectively use the agile ceremonies like sprint planning, daily stand-ups, and retrospectives and sprint reviews to provide working outcomes in every sprint.
• Designed and analyzed Business Process Model, Use Case model and test procedures based on agile methodology.
• Worked with cross-functional teams for building use cases, demonstrating the business requirements, developing business models; Designed and developed business flow diagrams, activity diagrams, sequence diagrams, object-oriented models using MS Visio.
• Conducted Model reviews with project team members; Publish and communicate models to various IT and business-based teams.
• Conducted data mapping to collect and show relations between data from dashboard function to the ODS table on PeopleSoft database, represented this mapping using ERDs, and Process Modeling DFD's on MS Visio.
• Proactively prepared scenario analysis of different product mix and identified the areas of improvement and solutions to meet the customer needs.
• Organized JAD sessions to flush out requirements, performed Use Case and workflow analysis, outlined business rules, and developed domain object models.
• Utilized Management Information Software (MIS) and Financial Accounting Software (FAS) that ensured daily balancing of accounts and vendor reconciliation.

Environment: Agile, MS Visio, MS Project, Reporting tools, Gap Analysis, GIT, RTM, RCM, SQL, Jira, MS Office, Oracle and Windows.

Project 2- Business Analyst

Confidential of Michigan, Lansing, Michigan

Responsibilities:

• Analyzed and gathered business requirements, identified system interfaces and created the requirements specification document.
• Wrote User Requirements Specification (URS) and Functional requirements specification (FRS) Documents as per the Business requirements and process flow.
• Conducted sprint planning meeting, sprint review meeting, sprint retrospective meeting and backlog refinement meetings.
• Performed Requirement Analysis to Develop Use Cases, Activity Diagrams and Sequence Diagrams.
• Documented conceptual design of Application in System Specification Document.
• Controlled project scope identified and resolved key issues and risks.
• Conducted JAD sessions and meetings with developers, QA team, and users for communicating primary requirements, also discuss different versions of requirements, queries, and clarify the issues.
• Extensively interacted with both user group and development team in coming up with structured charts, Class and sequence diagrams.
• Managed and tracked change control process of requirements and design changes using Rational Requisite Pro. Documented the changes, issues and their impact on the system design and delivery.
• Performed requirement analysis by gathering both functional and non-functional requirements based on interactions with the process owners &stakeholders and document analysis, represented them in Requirements Traceability Matrix (RTM).
• Used Global Data Synchronization Network (GDSN) which connects suppliers and retailers, operators, providers, distributors, and other recipients to the GS1 Global Registry via selected Data Pools.
• Managed plan and design of backup data Center infrastructure build-out and participate in business continuation/disaster recovery planning.

Environment: MS Project, MS office suite, MS Visio, MS PowerPoint, HTML, Gap Analysis, SQL, Agile, Oracle, Microsoft Office Suite, Microsoft Project, SharePoint, ETL testing, SQL.

Project 3- Business Analyst

Confidential, Tampa, FL

Responsibilities:

• Participated in the creation of Business Process Workflow Diagrams and data flow diagrams (DFD) with Stakeholders involved throughout the System Development Life Cycle (SDLC) - AGILE.
• Translated high-level requirements into the functional specification, acted as a liaison between users and the technical team in order to clarify the Business System Design and Process Mapping diagram in Swim Lanes.
• Worked on the coordination of software-mediated data transmission process of Confidential Exchange Data File (SDX) among system users and external agencies as well.
• Worked in an exclusively Agile environment, accepted changes along the project and implemented them by taking it into Change Request Board, performed Impact Analysis that the change may have in the project.
• Experience in conducting JAD sessions in order to understand the feasibility of the requirement in presence of the entire team.
• Perform stakeholder analysis to perform identify team members and build a communication plan to interface with different user groups
• Document detailed Business Requirements Documents (BRD) and Functional Requirement Documents (FRD) using Rational Requisite Pro.
• Documented system requirements and business requirements and created Requirement Traceability Matrix (RTM)
• Experienced in conducting User Experience (UX) session by testing the data in each release and getting approval from the Product Owners.
• Extensively compiled Use Cases after gathering requirements from different business units by taking account of Business Rules, Actors, Pre-condition and Post-condition and Trigger.
• Mapped HIPAA compliant EDI transactions for 837: Confidential claims and 835: payment advice transactions
• Recommended changes for system design, methods, procedures, policies, and workflows affecting Medicare/Medicaid claims processing in compliance with government compliant processes like HIPAA/ EDI formats and accredited standards like ANSI.
• Developed Stored Procedures for the Dataset to build the reports for the client requirements.
• Designed packages that utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate and Derived Column.
• Wrote triggers, stored procedures, functions and packages in PL/SQL to support report groups to utilize by Crystal Report/Oracle Report.
• Worked with development teams in the design of physical databases and in the modification.
• Hand on experience on Oracle database wrote PL/SQL Packages, Store procedure, functions to manipulate data.
• Developed functions, triggers, stored procedures, views, tables, and SQL scripts to meet the requirements of the business users and application development.
• Supported DBA to design, develop and maintain database objects (stored procedures, functions, packages, triggers, views, sequence, indexes, database link, synonyms and table space).

Environment: HIPPA ANSI X12, SDLC, Confidential, CPT and ICD-9 Coding, Rational Rose, Rational Requisite Pro, Microsoft Visio, SAS, Java, MS Word, MS Excel, MS Outlook, MS Access.