SUMMARY

• Over 9 years of professional experience as a Business Analyst with expertise in business process analysis, business requirement and business analysis.
• Strong business analysis skills and an understanding of the Software Development Life Cycle (SDLC) utilizing Rational Unified Process (RUP), Agile (Scrum, XP).
• Expert in requirement gathering and documenting the requirements in business requirement documents.
• Experienced in conducting requirement analysis, use case design, test plans and developed database schemas based on the logical models.
• Expertise in Data Quality Management, Data mapping, Data Modeling, Data Analysis, Requirement Analysis, Business Modeling, Data Migration, Data profiling, Dimensional Modeling.
• Worked extensively with Use Cases and Test cases and delivered Functional Specifications and Software Requirement Specification.
• Extensive experience and expertise in EDI Benefit and Enrollment - 834 transaction, ACA Obamacare Enrollment Companion Guide, Individual and SHOP enrollment transactions.
• Experienced in Loan origination automation.
• Functional knowledge of various modules of insurance like channel management, claims management, underwriting and reinsurance.
• Worked with Guide wire Insurance suit (Policy Center).
• Ability to gather business and technical requirements from both formal and informal sessions utilizing a variety of software tools including, Use Cases.
• Expertise with UML tools, applied for developing Use Case Diagrams, Activity and Sequence diagrams.
• Extensive experience with Data Warehousing, Extraction, Transformation and Loading process (ETL).
• Knowledge for working with User Acceptance Testing (UAT) and Functionality Testing.
• Deep understanding of Database management system, Data warehousing concepts, Business Intelligence technologies and Data mining.
• Experienced in Implementing Normalization/Denormalization techniques for optimum performance in OLTP/OLAP database environments for Business Intelligence’s function
• Excellent skills in writing Business Requirement Documents(BRD), Decision Documents, Functional Requirement Documents (FRD), SRS and diagramming skills for drawing UML diagrams such as Class diagrams.
• Developed efficient business relationships with various client teams in order to process and support requirements, develop tactical and strategic plans to implement technology solutions, and effectively manage client expectations.

TECHNICAL SKILLS

• Guide wire
• MS Visio
• Share Point
• QC
• Test Director
• MS SQL Server 2000/2005 (T-SQL)
• Load Runner
• MP
• Erwin
• Oracle
• Jira
• DB2
• SQL
• Microsoft Office
• MS Project
• HP Quality Center
• Web Services
• Waterfall Model
• Agile
• Methodology (SCRUM)
• Rational Unified Process (RUP)

PROFESSIONAL EXPERIENCE

Confidential, AL

Sr.Business Systems Analyst

Responsibilities:

• Performed requirement analysis by gathering both Functional and Non Functional Requirements based on interactions with the Process Owners & Stakeholders
• Involved in GAP analysis around the identification of design rules and System Process Flows, User administration and requirements.
• Assessed the flaws in the existing as-is Underwriting system and made clear recommendations of Business Process Improvements and incorporated them in the future to-be system design.
• Extensively worked in all phases of Software Development Life Cycle (SDLC) Agile deliverables.
• Worked with Scrum team to Keep Scrum process running and help the Team focused on the current Sprint to achieve Sprint goals.
• Interacted with the project team to define system objectives and scope, identified constraints and the measures of success for the system
• Conducted user interviews and JAD sessions to get an understanding of the client’s business process and preparing workshops for SMEs.
• Gathered functional requirements from business users, Product Owners, Stakeholders.
• Document analysis and represented them in Requirements Traceability Matrix (RTM). Developed use cases for Story boarding and wireframes for Interfacing.
• Developed Use Case diagrams, business flow diagrams, Activity/State diagrams and Sequence diagrams using MS Visio so that developers and other stakeholders can understand the business process.
• Assisted the Project Manager in understanding the project feasibility from Business view point and preparing meeting minutes and summary for team.
• Responsible for creating the Business Requirements Specification Document (BRD) and Decision Document in High level for legacy system of Alfa and working with business Leads of EY company for transferring GW Ideas to Alfas Legacy system.
• Worked directly with business groups to provide hands-on training aged in project work.
• Participate in workshops for conducting the team of Policy center for running the project.

Tools: & Technologies: Agile -Scrum, MS Project, MS Office (Excel, Power Point, Microsoft Access, Word), Guide Wire (Policy Center), SharePoint, MS Visio

Confidential, MN

Business Analyst

Responsibilities:

• Developed UAT Test Plan to guide select group of key end-users in testing the business processes on the application
• Performed System testing, Regression testing and UAT for several claim types and test scenarios
• Interacted with stakeholders to get a better understanding of client business processes and gathered requirements.
• Tested the ability to accept an 834 electronic application and validate complete transactions.
• Tested the ability to store Identification number received from the Exchange and create a unique identifier for members received through the Exchange.
• Conducted requirement-gathering sessions with the purpose of creating and defining the Business Requirement Document (BRD).
• Created Swim Lane Diagrams and business logic & calculation spreadsheets for various business processes.
• Performed data mapping to define the Source data on 834 Benefit Enrollment and Employer Group File (EGF) EDI Transfers.
• Created Process Models for (a) Initial Enrollment, First Billing and Payment and (b) Post Enrollment - Subsequent Recurring Billing and Payment.
• Collaborated with vendors (CURAM, CONNECTURE & PWC) in order to ensure smooth transition of requirements from State to Vendors.
• Involved in Small Business Health Option Plans (SHOP) activities across vendors.
• Worked on streamlining SharePoint to meet project policies and processes.
• Performed Data Mapping for State Administration Enrollment Management function to define the data elements, their source and read only/editable parameters.
• Documented and Analyzed impact upstream and downstream when change in editable data elements in State Administration Enrollment Management function is recorded.
• Documented the "Configure Billing Cycle" scenarios and billing rules for the employer.
• Mapped Employer Subscription Service with Enrollment data from CONNECTURE and identified gaps.
• As the processes and methodology moved from waterfall towards agile, wrote requirements in form of User Stories and Acceptance Criteria Documentation.

Tools: & Technologies: MS Project, MS Visio, MS Word, MS Excel, MS PowerPoint, MS SharePoint, JIRA, Windows XP, HIPAA.

Confidential, IL

Business Analyst

Responsibilities:

• Facilitated (JAD) Joint Application Development sessions to resolve issues relating to difference between business requirements and technical design.
• Interacted with the end users to define and document data warehouse business requirements as the foundation for database design, data extraction and analysis.
• Examined Enterprise Data Warehouse (EDW) to ensure compliances with upgrade requirements, and generated documents for the workflow of existing system and desired system that involve multiple RDBMS sources like policy database, billing database.
• Derived functional specifications using UML models including use case diagram, activity diagram, and sequence diagram, and collaborated with software architects and developers to ensure that the applications conform to the requirements and helped to understand the business flow.
• Designing and creating the architecture of data warehousing star schema logical database model.
• Developed detailed ETL process.
• Maintained Traceability Matrix for the current business processes and proposed changes.
• Coordinated with the business testing team to explain and develop the Test Plans, Test cases, Testing & Evaluation strategy and methods for user acceptance testing (UAT).
• Developed test plans with QA team and helped to develop test scenarios for system testing, integration testing and performance testing.
• Conducted UAT, documented and reported user feedbacks to management team, and developed training materials for different end users and assisted in User Training for the new system.

Tools: & Technologies: RUP, MS Visio, MS Office (Excel, PowerPoint, Word), Erwin, MS Project.

Confidential, TX

Business Analyst

Responsibilities:

• Was responsible for creating and reviewing business requirements, functional specifications, project schedules, documentation and test plans.Sprint goals during the billing process.
• Conducted user interviews and JAD sessions with end users, stake holders and developers to gather functional and nonfunctional requirements pertaining to Loan Origination to Loan Processing.
• Assessed the flaws in the existing as-is system and made clear recommendations of business process improvements and incorporated them in the to-be system design.
• Wrote business requirement Document (BRD) and functional requirement specification (FRS) documents as per the business requirements and process flow.
• Developed UML Use Case diagrams for faster and more efficient communication with stakeholders, by utilizing MS Visio.
• Making sure current project requirements are being met by using Requirement Traceability Matrix (RTM)
• Actively involved in creation of the UML diagrams such as sequence, activity and class diagrams for certain modules of the application using MS Visio.
• Assisted and directly involved with QA team in creation of Test Cases and tests implementations.
• Designed and implemented basic SQL queries for QA testing and report / data validation.
• Presented and assisted end users for education and training about the new system.

Tools: & Technologies: Agile -Scrum, Guide wire, MS-Visio, MS Project, MS Office (Excel, Power Point, Word).

Confidential

Business Analyst

Responsibilities:

• Conducted JAD sessions with management, SME (Subject Matter Expertise), vendors, users and other stakeholders for open and pending issues to develop specifications.
• Conducted controlled brainstorming sessions with project focus groups.
• Created job schedules to automate the ETL process.
• Worked on data modeling and produced data mapping and data definition documentation
• Configured the Data mapping between Oracle and SQL Server 2005.
• Designed and implemented basic SQL queries for testing and report/data validat.
• Developed strategies for Data Scrubbing, Cleansing, Enriching, transforming and loading Data in Staging/Data warehouse.
• Prepared high-level Logical Data models and BRD’s (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
• Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams in MS Visio.
• Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions on an ad hoc or scheduled basis.
• Enhanced the job properties for performance tuning.
• Conducted User Acceptance Testing on the application - resolved issues from the participants, prepared and submitted Test Analysis Reports and participated in Product Readiness Review.
• Prepared the documentation of Data Acquisition and Interface System Design.

Tools: & Technologies: Agile - Scrum, MS Access, Erwin, MS Visio, Microsoft Office (Excel, Power Point, Word).