PROFESSIONAL SUMMARY

• Business Analyst wif 7+ years of experience in Oil and Gas, Healthcare, Insurance and E - Commerce.
• Excellent Knowledge of Agile Backlog Grooming, Release Management & Sprint Planning, Estimation-Velocity and Change Management.
• Experience in creating Project Charter, Project Plan, and Project Schedule and Status reports, while keeping schedule, cost and resources at balance.
• Experience in Requirement gathering & Management in individual as well as group settings; Skillfully documented Business Requirements, Use Case Specification, Functional and Non-Functional specification, UML diagrams including Use Case diagram, Activity diagram, Class diagram, Sequence diagram, Data Flow diagram (DFD), Entity-Relationship diagram (ERD), Requirement Traceability Matrix (RTM), Change-Version Control, Training and User Manuals; Workflow Diagrams, Business Process Analysis &Re-engineering, Testing Lifecycle, GAP analysis, risk analysis, cost-benefit analysis
• Experience of n-tier architecture, web controls, Mockup Diagrams, web services implementations in a SOA environment; SEO, Page Indexing, Sitemaps and Robot.txt files
• Experience in scheduled and ad-hoc report generation using MS Excel, SSIS, PowerPivot, ROLAP & MOLAP cubes and other relational data sources using SQL.
• Knowledge of Health Insurance Portability and Accountability Act (HIPAA) standards, Electronic Data Interchange (EDI) and implementation of ASC X12N code sets 4010A/5010, ICD-9, ICD-10 and HL7.
• Experience wif standards for medical transactions like 820 (enrollment), 834 (premium payments), 835 (medical claims payments), 837 (medical claims), 270 (eligibility inquiry), 271 (eligibility response), 276 (claim status), and 277 (claim status response).
• Experience in White Box, Black Box, Unit, Functional, Integration, Back End and System Level Load and Stress Testing.
• Experience in Data Analysis, Data Warehousing; writing DDL & DML SQL queries (T-SQL & PL-SQL) especially stored procedures, joins, triggers and views.
• A team player wif experience in handling remote teams esp. managing schedules and meeting agenda.

TECHNICAL SKILLS:

Business Skills: Business Process Analysis & Design, Gap Analysis, Impact Analysis, JAD/JRP Sessions Requirement Gathering, Change Management and Use Case Modeling, User Stories

Methodologies: Agile (Test Driven Development & SCRUM), RUP, Prototyping and Waterfall

Languages: T-SQL, C#, JAVA, HTML and XML

Tools: Clear Quest, Clear Case, MS Visio, Rational Requisite Pro, HP Quality Center, TFS, Microsoft Team Manager, JIRA, JIRA Agile( Green Hopper), DNN, Moodle, MS Office Suite (Word, Excel, Power Point, Outlook), MS SharePoint, MS Visio, MS Project, and MS FrontPage

Data Tools: DB2, MS SQL Server, Oracle, Teradata, Toad, Crystal Reports, PowerPivot, MicroStrategy, ERWin, BIDS

PROFESSIONAL EXPERIENCE

Business Analyst

Confidential, Houston, TX

Responsibilities:

• Interacted wif business heads to finalize the Business Requirements for the application
• Participated in SCRUM for Project planning and estimation
• Adept in creating Agenda for Sprint Planning and Review Meetings
• Created User Stories to create Product Backlogs and conducted backlog grooming to maintain priority, rank and complexity of each story
• Developed a Use Case Model using MS Visio and developed a detailed project plan wif emphasis on deliverables.
• Successfully conducted JAD sessions, which halped synchronize the different stakeholders on their objectives and halped the developers to has a clear-cut picture of the project.
• Performed Use Case testing to support QA team in adjusting to agile environment.
• Managed various tests, stored test information, reviewed and analyzed test results.
• Conducted presentations of the Q/A test results wif analysis to the stakeholders and users and documented modifications and requirements.
• Assisted in the conduction of best support and high-level release testing
• Involved in the application and database design
• Participated in Gap analysis between stakeholders and user’s needs and proposed solutions.
• Coordinated between business line, operations and the technical team throughout the project.
• Worked wif the business team for the project requirement review and User Acceptance Testing.

Environment: Agile, TFS,MS Office 2007, MS Project, Rational Requisite Pro, MS Visio 2010, MS SQL Server, Oracle, Business Intelligence tool (MS Share Point), Android Apps, JAVA

Business Analyst

Confidential, Houston, TX

Responsibilities:

• Gatheird all the functional and nonfunctional requirements.
• Coordinated Interviews and conducted JAD sessions wif management, SME, vendors, users and other stakeholders to gather functional requirements.
• Documented requirements and communicated wif development team for design and implementation of business solutions.
• Participated in Gap analysis between stakeholders and user’s needs and proposed solutions.
• Worked wif Project Manager and Project lead on detailing Business Requirement Document.
• Maintained Requirement Traceability Matrix.
• Managed Change Request documents and defect tracking.
• Planned and defined system requirements to wire Frames wif Use Case, Use Case Narrative, Activity Diagrams and Use Case Model using UML (Unified Modeling Language).
• Worked wif QA team for mapping documents, creation of Test Plan, Test Scenarios and Test Cases for unit, system and system integration testing.
• Participated in designed the front end pages using HTML, CSS and validations using java script prototype library
• Used SQL statements and procedures to fetch the data from the database

Environment: Agile, TFS,MS Office 2007, MS Project, Rational Requisite Pro, MS Visio 2010, MS SQL Server, Oracle, Business Intelligence tool (MS Share Point), Android Apps, JAVA

Business Analyst

Confidential, Chicago, IL

Responsibilities:

• Interacted wif business heads to finalize the Business Requirements for the application
• Participated in SCRUM for Project planning and estimation
• Adept in creating Agenda for Sprint Planning and Review Meetings
• Created User Stories to create Product Backlogs and conducted backlog grooming to maintain priority, rank and complexity of each story
• Developed a Use Case Model using MS Visio and developed a detailed project plan wif emphasis on deliverables.
• Successfully conducted JAD sessions, which halped synchronize the different stakeholders on their objectives and halped the developers to has a clear-cut picture of the project.
• Performed Use Case testing to support QA team in adjusting to agile environment.
• Managed various tests, stored test information, reviewed and analyzed test results.
• Conducted presentations of the Q/A test results wif analysis to the stakeholders and users and documented modifications and requirements.

Environment: MS SQL Server, Agile, Scrum, SQL, MS Visio, MS Office, UML, Windows XP, HP Quality Center

Business Analyst

Confidential, Atlanta, Georgia

Responsibilities:

• Derived Functional Requirement Specifications based on User Requirement. Understand and articulate business requirements from user interviews and tan convert requirements into technical specifications.
• Conducted interviews wif the SME and gatheird information about Health care Enrolment, Billing and Claims processing leading to creation of user stories, test cases in epics and themes.
• Wrote and designed clear, concise detailed System Requirements Specification documents and user documentation in accordance to guidelines and standards of a level where developers can interpret, design and develop the application wif minimum guidance.
• Created Entity Relation diagrams to represent the relationships existing between designs the internal schema of a database.
• Worked wif QA team to prepare Test Cases and Test Plans to conduct Functional and GUI testing on various screens to ensure user acceptance criteria is met.
• Participated in Backlog Grooming sessions, identified obstacles, planned releases and managed sprints.
• Created and Managed User Stories in Sprints.
• Analyzed HIPAA 5010 related to 837,835, 834 claims.
• Created data warehouse model schemas for faster data processing.
• The user interface (UI) screens for SharePoint Web Parts & User controls were mocked up in Microsoft Visio and reviewed wif the end users prior to programming to solicit User Acceptance.
• Worked wif end users to define business design solutions (e.g. new workflows, systems, programs, and reports) as well as created integration requirements for system coupling.
• Created SharePoint workflow diagrams describing how to use the new system.
• Participated and conducted daily standup meetings and owned daily milestones to gather and create reporting specifications.
• Created UAT plans and several other types of test cases for each project to ensure dat the system runs smoothly after the proposed enhancements.
• Coordinated between business line, operations and the technical team throughout the project.
• Gatheird requirements for impacted system and business areas for ICD-10 and their needs to embrace the changes.
• Created T-SQL statements, stored procedures to query the custom claims OLAP database.

Environment: Agile, TFS,MS Office 2007, MS Project, Rational Requisite Pro, MS Visio 2010, MS SQL Server, Oracle, Business Intelligence tool (MS Share Point), Android Apps, JAVA

Business Analyst

Confidential, Titusville, FL

Responsibilities:

• Gatheird all the required functional requirements
• Coordinated and conducted several JAD sessions wif SMEs, stakeholders, design/development teams and users.
• Prepared Business Requirement Documents (BRDs), Technical Requirement Documents (TRDs) and Case Studies to evaluate business needs for Pharmacy chain.
• Custom solutions were created and tested to resolve operational issues.
• Designed and developed Use Cases, Activity Diagrams, and Sequence Diagrams using UML in Visio to map the claims adjudication workflow.
• Created and maintained the Requirement Traceability Matrix (RTM) between the requirements and design documents and test plans.
• Created Data Migration Plan for migration of data from various sources.
• Conducted various meetings and interacted wif the SMEs, and developers to discuss Enhancement and Modification Request issues.
• Participated in report generation using Excel.
• Assisted in developing user interface (UI) screens for SharePoint Web Parts & User controls were mocked up in Microsoft Visio and reviewed wif the end users prior to programming to solicit User Acceptance.
• Assisted in User Acceptance Test (UAT).

Environment: Windows, MS Visio, Requisite Pro, Bugzilla, UML, SQL, MS Office, .Net, J2EE, HIPPA, EDI.

Buisness Analyst

Confidential

Responsibilities:

• Created Data Migration Plan for migration of data from various sources.
• Conducted Q&A sessions wif the SME’s, to analyze and document the requirements
• Functioned as the primary liaison between the business line and the technical areas
• Organized meetings via WebEx, Lotus Notes and face to face, documented action items and minutes; presented summarizations to the peers and communicated wif clients, regarding issues, using Lotus Notes.
• Created Business Requirement Documents and Functional Requirement Documents.
• Conducted status update meetings weekly, to review the progress of the project.
• Performed rigorous data modeling involving creation of a normalized relational ER model and creating SQL scripts.
• Coordinated in developing test scenarios, test cases and implemented test plan wif QA team
• Analyzed business requirements and segregated them into high level and detailed Use Cases.
• Created Activity and Sequence Diagrams using Rational Rose & MS Visio.
• Frequently updated the requirement and defect status as per the current status of testing.

Environment: Rational Rose, RUP, MS Visio, Crystal Reports, MS office, Requisite Pro, Windows XP, .NET, Oracle