SUMMARY

• Over 4 years of professional experience as a Business Analyst with expertise in EDI Benefit and Enrollment - 834 transaction. Experience in Data Management and Business Intelligence.
• Experienced in ACA Obamacare Enrollment Companion Guide.
• Experience in Individual and SHOP enrollment transactions.
• Experience in dealing with multiple State Based Marketplaces and Federal Marketplace.
• Experience with EDI tools like Informatica and EDIFECS.
• Strong business analysis skills and an understanding of the Software Development Life Cycle (SDLC) utilizing Rational Unified Process (RUP), Agile (Scrum, XP).
• Experienced in conducting requirement analysis, use case design, test plans and developed database schemas based on the logical models.
• Expert in requirement gathering and documenting the requirements in business requirement documents.
• 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.
• 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

• EDIFECS
• Cognos
• Informatica
• SQL
• Oracle
• MS Visio
• Share Point
• Jira
• Microsoft Office
• MS Project

PROFESSIONAL EXPERIENCE

Confidential

Business Analyst

Responsibilities:

• Worked with lead business analyst in development of the multiple EDI 834 Companion Guide versions for Confidential .
• EDI 834, 999 file analysis and testing.
• Development of test cases for the user requirements.
• Gathered primary input/output requirements and modeled the processes in context diagram using MS Visio.
• Gathered functional requirements from business users.
• Assisted the Project Manager in understanding the project feasibility from Business view point.
• Responsible for creating the Business Requirements Specification Document (BRD) and the Functional Requirement Document (FRD).
• Liaised between technical and business teams for obtaining status/updates as well as sharing best practices.
• Worked directly with business groups to provide hands-on training aged in project work.
• Working closely with users to ensure the project meets business needs and final approval of the Design Specification.
• Definition and management of the User Acceptance Testing program (UAT).
• Involved in maintaining the Requirements Traceability Matrix (RTM) across the deliverables for a project.
• Followed the UML based methods to create: Use Cases and Activity Diagrams.
• Conducted the requirements and design walkthroughs with designers, developers and management staff.
• Performed manual testing and recorded results.
• Executed the test scripts and test cases and validated the test output.

Confidential, IL Chicago

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.

Confidential, TX Austin

Business Analyst

Responsibilities:

• Worked with Agile methodology (Scrum) to Keep project process running and help the Team focused on the current Sprint to achieve
• 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 of the system, and creation of user stories.
• 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.
• Presented and assisted end users for education and training about the new system.

Confidential

Business Analyst

Responsibilities:

• Gathered business requirements through interviews, surveys, prototyping and observing from account managers and UI (User Interface) of the existing broker portal system. Worked with Agile (Scrum) to keep project process running.
• 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.