SUMMARY

• Over 6 years of experience in IT/Software Development Life Cycle (SDLC), business and functional requirements gathering, requirements analysis, process design and software validation.
• Experience in requirements gathering, writing Use Cases and creating use case diagrams.
• Extensive experience in creating Business Requirement Documents (BRD), Functional Requirement Specifications (FRS).
• Experience in Creating and Maintaining the Requirements Traceability Matrix (RTM), leading JAD/JAR sessions to reduce time spent in moving information between stakeholders and team members.
• Followed Scrum and Agile methodologies in delivering products to the Clients depending on the needs and size of the Project being handled.
• Ability to work independently and manage business requirements with a delivery focused approach and ability to build and maintain strong working relationships with business sponsors and technical specialists.
• Routinely work with subject matter experts, requirement analysts, and business analysts to document as much as possible about user requirements for software development in a variety of formats and software tools including Microsoft Word and Microsoft Excel.
• Worked on Data Integration and Data Migration.
• Experienced in Requirement Analysis, gathering and developing Functional Requirement Documents (FRD) and User Guides.
• Proficient with software development lifecycle (SDLC) and processes in a team environment with emphasis on requirement elicitation, analysis, specification, verification and the ability to apply them in practice.
• Routinely working with IT infrastructure teams starting from requirements gathering based on client request, and providing solutions based on the requirements for all the 3 tier architecture which includes front end, middleware and back end teams.
• Proficiency with Agile and Waterfall models used in software development process.
• Knowledge in Data Modeling and Process Modeling using Visio, Enterprise Architect.
• Extensive experience in analyzing and creating Use Cases, Use Case diagrams, Activity diagrams, Data Flow Diagrams, Business Flow Diagrams, Sequence Diagrams using UML modeling tools such as MS Visio.
• Extensive knowledge of Microsoft Excel, Word, PowerPoint, Project Access, Visio and Outlook.
• Experience in working with end users and the QA team for developing test cases, Black box testing and writing validation rules.
• Expertise in writing SQL Queries for Database Testing.
• Experienced in developing QA Strategies: Test Cases, Test Scripts and Test Procedures and Functional Unit Testing, System Testing and conducting User Acceptance Testing (UAT).
• Managed the release design and deployment within schedule/budget.

TECHNICAL SKILLS

Software: Microsoft Office (Word, Excel, Access, PowerPoint, and Outlook), MS Project, MS Visio

Methodologies: Waterfall, Scrum, XP, Kanban

Testing Tools: Quality Center and JIRA

Document Processes: Use Cases, UML Diagrams, UAT Test plans &cases, Share point

Databases: Oracle 11g/10g/9i, MS Access, SQL server

Operating Systems: Windows 7/XP /98/2000 NT/Vista and Unix

Language: SQL, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential, MINNEAPOLIS

SR. BUSINESS ANALYST

Responsibilities:

• Gather and analyze business requirements.
• Worked within the business areas to create high level scope analysis of the processes/systems impacted and work plan for new system functionality.
• Supports end - to-end tracking from requirements through process/system design, development and testing.
• Constantly verified Requirement Traceability Matrix to determine if each and every Functional requirement is taken care of and a test script is developed and executed for the same.
• Helped developing SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports.
• Prepared Healthcare Reports by using MS Excel and MS Access.
• Translate business requirements into detail technical solutions project briefs.
• Proactively identifies and resolves gaps in solution design versus requirements documentation.
• Conducted JAD session for defining scope, requirements and objectives with various teams
• Gathered requirements from JAD/JAR sections with developers and business clients.
• Worked with User Interface (UI) team to create report mock up's from wire frames to ensure that functionalities are captured and presented on the front end as per the BRD's.
• Involved in Gap Analysis and assisted the development team to understand the To-Be process.
• Analyzed source data coming from different payers like Health first, Aetna.
• Responsible for creating all the documentation of the project.

Environment: Agile Methodology, MS Visio, MS Project, MS PowerPoint, MS Excel, MS Access, Microsoft SQL Server 2012

Confidential

SR. BUSINESS ANALYST / SCRUM MASTER

Responsibilities:

• Responsible for the Project Deliverables Roadmap and reported it to PMO on a weekly basis and presented the progress in the daily meeting.
• Worked with Project Manager for a detailed Project Plan, Timeline and a high level of Resource Allocation and Planning.
• Responsible for identifying and documenting business rules and created use cases.
• Interacted with business users such as Stakeholders, Claim and Policy Representatives, Team Leads and gathered business requirements.
• Part of JAD sessions with business users and development teams to gather business applications and quality requirements.
• Helped the team in identifying and documenting the Risk Issues and tracked the status after assigning target dates.
• Worked with system analyst, developers and testers to collaborate resource allocation and completion of project using MS Project.
• Provided the potential recommendations on the business process by identifying gap between the current systems and future systems, and the systems that really paved the way for cost reductions and profit realization.
• Developed business scenarios for Customers and business users.
• Developed Business Requirements Documents (BRD), Functional Requirements (FRD) and Systems Specifications document
• Created UML diagrams such as Activity Diagram, Sequence Diagram and Use Case Diagram to depict the various processes flow using MS VISIO
• Created Requirement Traceability Matrix (RTM) to make sure all the requirements are covered with test cases.
• Facilitated Sprint planning meetings to coordinate between Clients, Product Owner, Dev and QA teams.
• Shadow and assist some of the Product Owner activities by providing high level estimates, prioritizing stories for the sprint and maintaining backlogs and release plans.
• Resolved impediments for scrum team members by facilitating collaborative meeting.
• Facilitated Sprint review meeting to demonstrate potentially shippable product to stakeholders.

Environment: Erwin, Agile/Scrum, ASP.net, C#.net, SQL SERVER, Balsamiq, MS Project, MS SharePoint, HPQC, Windows, JIRA, Selenium.

Confidential, RALEIGH, NC

BUSINESS SYSTEM ANALYST

Responsibilities:

• Extensively worked with business users and other stakeholders for requirement elicitation.
• Worked as a Liaison between stakeholders and BI developers to develop Business Intelligence solutions.
• Worked with internal architects, assisting in the development of current and target state enterprise data architectures.
• Worked with project team representatives to ensure that logical and physical data models were developed in line with corporate standards and guidelines.
• Facilitated requirement review sessions with SME’s and business users to make sure requirements are feasible.
• Extensively worked on identifying and retrieving the data from multiple sources using SQL for decision making.
• Developed Data Models and done Data Mapping across downstream applications by working closely with Architects.
• Was involved in decision making for implementing Star Schema or Snow Flake Schema into our Data Mart.
• Reverse engineered all the Source Database's using Erwin.
• Responsible for defining the functional requirement documents for each source to target interface.
• Developed processes using ETL tools, SQL to support business reporting requirements.
• Conducted presentations to other lines of business as a Meta role to show value of Tableau as a BI tool.
• Experience in Data Warehouse for the Extraction, Transformations of data from multiple sources & Loading into Data Warehouse.
• Designed and built the Investor month-to-date Dashboard on the BI system (Tableau) to provide the status of investor performance in real time.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Facilitated training sessions for end-users who are non technical.
• Involved in the creation, enhancement and maintenance of new Business Intelligence solutions.
• Documented, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team.
• Documented data quality and traceability documents for each source interface.
• Resolved data discrepancy issues by facilitating meeting with developer and architects.

Environment: Oracle 11g, MS Access 2007, MS Excel 2007, MS Word 2007, MS Outlook 2007, JIRA, Toad, Erwin, Informatica Power Center, Tableau, EXCEL PowerPoint 2007, SharePoint

Confidential, CA

BUSINESS ANALYST

Responsibilities:

• Primary point of contact working with stakeholders to understand their systems, AS-IS process and business needs.
• Performed GAP Analysis to identify the deficiencies of the current system and to identify the requirements for the change in the proposed system.
• Facilitated workshops to capture AS-IS requirements & design TO-BE processes
• Facilitated JAD sessions by inviting SME’s, tech leads and Architects to make sure that gathered requirements are feasible in doing.
• Created Test Scripts, developed SAP User Procedures, Training Curriculum and conducted Training Sessions for all levels of end users.
• Mapped business processes to SAP functionalities.
• Performed in-depth analysis of the systems organizational structure, services and processes and createdAs-Is and To-Be process models.
• Assisted in designing User Interface by creating Static and Dynamic Prototypes for Graphical Representation.
• Derived functional and non-functional requirements to create a Functional Requirements Document.
• Involved in walkthroughs with business team, architects and developers to refine the requirements.
• Generated use-case diagrams using UML.
• Implemented Traceability Matrix and User Requirement Specification Document (URS) to verify the functionality.
• Streamlined clerical work processes and mapped to the automated system
• Involved with the Software Quality Assurance (SQA) Team to develop Test plans.

Environment: MS Visio, UML, Oracle, SQL, MS Office and Windows 2000.

Confidential, Kansas CITY, MO

Business Analyst

Responsibilities:

• Worked with the claims department, IT staff, and relevant Subject Matter Experts (SME's) to analyze and document system requirements and procedural changes.
• Facilitated JAD sessions and review meetings with the users and members of the development team to ensure understanding of the new functionalities.
• Responsible for writing theBusiness Requirement Document (BRD) and the Functional Requirement Document (FRD) for the application.
• Followed UML processes and standard operating procedures in developing Use Cases, Use Case diagrams and other supporting documentation.
• Played a key role in the planning, testing, and implementation of the new enhancements and conversions.
• Performed Gap analysis to check the compatibility of the existing system infrastructure with the new requirements.
• Performed Risk analysis of the requirements to identify the keybusiness risks areas for the project and prioritized the application development and testing.
• Performed requirement walkthroughs with the Development and QA teams with the aim to develop testing strategies and test plans such that test cases reflect user needs.
• Monitored user expectations through user involvement and communication throughout the project lifecycle.
• Tracked and maintained user requested enhancements and changes.
• Participated in User Acceptance testing.
• Agile Software Development Life Cycle.
• Database designing using Normalization Forms, Entity Relationship Design model and application oriented design.
• Creating Databases objects, Schemas, Tables, Indexes (clustered and non clustered), views.
• Design and develop complex SQL queries and appropriate database code such as stored procedures, triggers, functions to support complex business processes.
• Created constraints and rules on database objects.
• Manipulating, Cleansing and Processing Data Using Excel, Access and SQL.
• Responsible for Loading, extracting and validation of client data.
• Reporting aggregated data using the Group Functions.
• Analyzing raw data, drawing conclusions and developing recommendations.
• Document database architecture, codes and user instructions.
• Provide accurate estimates for all assigned project tasks.
• Perform other duties as assigned.

Environment: MS Office, MS Project, SQL Server Enterprise Edition, J2EE, Oracle 9i, MS Visio and Rational Requisite pro.