PROFESSIONAL SUMMARY

• Business Systems Analyst with 7+years of experience specializing in Healthcare Industry and E - Commerce.
• 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
• Extensive noledge and experience of n-tier architecture, web controls, Mockup Diagrams
• Extensive Experience with Data Mappings from source to destination databases with hands on requirement gathering for ETL and Data Cleansing.
• Experience in scheduled and ad-hoc report generation using MS Excel, SSIS, PowerPivot, Tableau from 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 with 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 Data Analysis, Data Warehousing; writing DDL & DML SQL queries (T-SQL & PL-SQL) especially stored procedures, joins, triggers and views.
• A team player with experience in handling remote teams esp. managing schedules and meeting agenda.

TECHNICAL SKILLS & TOOLS:

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, Agile, MS Office Suite (Word, Excel, Power Point, Outlook), MS SharePoint, MS Visio, MS Project

Data Tools: DB2, MS SQL Server, Oracle, Crystal Reports, PowerPivot.

PROFESSIONAL EXPERIENCE

Business Analyst

Confidential, Houston, TX

Responsibilities:

• Interacted with business heads to finalize teh Business Requirements for teh application
• Derived Functional Requirement Specifications based on User Requirement.
• Understand and articulate business requirements from user interviews and tan convert requirements into technical specifications.
• Prioritized business requirements and segregated them into high level and low level Use Cases, Activity and Sequence according to UML methodology.
• Coordinated between business line, operations and teh technical team throughout teh project.
• Worked with teh business team for teh project requirement review and User Acceptance Testing (UAT).
• Created UAT plans and several other types of test cases for each project to ensure that teh system runs smoothly after teh proposed enhancements.
• Created and maintained teh Requirement Traceability Matrix (RTM) between teh requirements and design documents and test plans.
• 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 teh Q/A test results with analysis to teh stakeholders and users and documented modifications and requirements.
• Worked in an agile environment.
• 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 with emphasis on deliverables.
• Design application solutions, considering user functionality and user interface.
• Successfully conducted JAD sessions, which helped synchronize teh different stakeholders on their objectives and helped teh developers to have a clear-cut picture of teh project.
• Assisted in teh conduction of best support and high-level release testing
• Involved in teh application and database design
• Participated in Gap analysis between stakeholders and user’s needs and proposed solutions.

Environment: Agile, TFS,MS Office, MS Project, Rational Requisite Pro, MS Visio 2010, MS SQL Server, Oracle, ASP.net

Business Analyst

Confidential, Atlanta, Georgia

Responsibilities:

• Worked on requirement gathering process.
• Created a Business Requirement Document for management.
• Identified data requirements and creating Data Mappings between Source and Target Databases to facilitate teh ETL process.
• Created ETL requirements by identifying all transformations and data cleansing needs.
• Created user interface (UI) screens for Web Parts & User controls were mocked up in Microsoft Visio and reviewed with teh end users prior to programming to solicit User Acceptance.
• Worked with end users to define business design solutions (e.g. new workflows, systems, programs, and reports) as well as created data integration requirements for system coupling.
• Created Reports from relational data sources, and tabular models.
• Created workflow diagrams describing how to use teh 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 that teh system runs smoothly after teh proposed enhancements.
• Created and maintained teh Requirement Traceability Matrix (RTM) between teh requirements and design documents.
• Coordinated between business line, operations and teh technical team throughout teh project.
• Gatheird requirements for impacted system and business areas for ICD-10 and their needs to embrace teh changes.
• Participated with risk analyst team (Business driver, policies, Actuarial, environment) for payment integrity
• Created T-SQL statements, stored procedures to query various relational databases.
• Provided Full-Text Search requirements and catalogs for advanced search.

Environment: Agile, TFS,MS Office 2007, MS Project, Rational Requisite Pro, MS Visio 2010, MS SQL Server, Business Intelligence Development Studio,.NET, MS Excel

Business Analyst

Confidential, Titusville, FL

Responsibilities:

• Gatheird all teh required functional requirements
• Coordinated and conducted several JAD sessions with 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.
• Created T-SQL statements, stored procedures to query various relational databases.
• 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 teh claims adjudication workflow, and POS integration.
• Created and maintained teh Requirement Traceability Matrix (RTM) between teh requirements and design documents and test plans.
• Conducted various meetings and interacted with teh SMEs, and developers to discuss Enhancement and Modification Request issues.
• Assisted in developing User Interface (UI) designs and prototypes using Fireworks for web application development.
• Assisted in User Acceptance Test (UAT).
• Worked with QA team for mapping documents, creation of Test Plan, Test Scenarios and Test Cases for unit, system and system integration testing.

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

Business Analyst

Confidential, Farmington, CT

Responsibilities:

• Gatheird all teh functional and nonfunctional requirements.
• Coordinated Interviews and conducted JAD sessions with management, SME, vendors, users and other stakeholders to gather functional requirements.
• Documented requirements and communicated with development team for design and implementation of business solutions.
• Participated in Gap analysis between stakeholders and user’s needs and proposed solutions.
• Worked with 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 with Use Case, Use Case Narrative, Activity Diagrams and Use Case Model using UML (Unified Modeling Language).
• Incorporated stakeholder feedback throughout project lifecycle to ensure project quality and customer satisfaction.
• Participated in user acceptance testing (UAT) of teh application.
• Each phase of software development life cycle created using agile methodology.
• Analyzed HIPAA administrative standards to incorporate in health plan products.
• Evaluate Medicare requirements and benefits in Medicare Health Plans for member enrollment and management (EDI transaction 270/271).
• Worked with QA team for mapping documents, creation of Test Plan, Test Scenarios and Test Cases for unit, system and system integration testing.
• Developed and manages creation of User Manual documentation to communicate features and benefits.

Environment: Agile, UML, Rational Requisite Pro, Visio, MS Project, MS Office

Business Analyst

Confidential, Virginia Beach, VA

Responsibilities:

• Created process flows for HIPAA EDI transactions such as 270, 271, 276, 277 and 820.
• Played an active and lead role in gathering, analyzing, and writing business requirements.
• Involved in Requirement Scoping and analysis of high priority requirements for implementation.
• Designed teh business requirement collection approach based on teh business need and requirement priority. Conducted end user surveys and interviews to come up all teh relevant fields and information required.
• Conducted JAD workshops to achieve consensus on critical and sensitive issues and members privacy requirements. Consulted with legal SMEs to ensure compliance with state medical privacy laws.
• Actively involved in teh creation of comprehensive resource center through collection, documentation and extensive editing of relevant medical literature.
• Used UML to perform Use-Case analysis to capture teh dynamic aspect of teh application.
• Developed UI document with UI designs and mock-ups through wireframes. Utilized Story boards and screen mock-ups to obtain client feedback and approval. Suggested changes when teh user interface was confusing or needed rewording.
• Authored Companion Guide to support all teh information needed to process HIPAA transactions with Confidential .
• Prepared user acceptance criterion and testing strategy that will be utilized by QA team to validate teh addressed functionality of all critical requirements.
• Developed and maintained Test Matrix and Traceability Matrix. Utilized Quality Center to plan and execute tests, track defects and create change alerts. Conducted User Acceptance Testing (UAT).

Environment: HIPAA ANSI X12, Rational Rose, Rational Requisite Pro, Microsoft Visio, SAS, Java, MS word, MS Excel, EDI, Oracle, MS SQL Server

Systems Analyst

Confidential, Chicago, IL

Responsibilities:

• Interacted with business heads to finalize teh Business Requirements for teh application
• Implemented 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 with emphasis on deliverables.
• Successfully conducted JAD sessions, which helped synchronize teh different stakeholders on their objectives and helped teh developers to have a clear-cut picture of teh 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 teh Q/A test results with analysis to teh 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

Analyst

Confidential

Responsibilities

• Primarily involved in gathering requirements for teh GUI (Graphical User Interface) screens and designing teh same.
• Participated in arranged JAD sessions with business users for requirements gathering.
• Participated in preparation of workflow diagrams and presented to developers.
• Participated in preparation of use cases and designed use case diagram, class diagrams and sequence diagrams using Rational Rose.
• Participated in preparation of Software Requirements Specification (SRS) taking functional requirements specification as a base.
• Participated in preparation of non-functional requirements.

Environment: MS Word, MS Excel, SQL, MS Visio, Windows XP