Business Analyst

Vaishnavi Davulu

Senior Business Analyst

Email: ***************.****@*****.*** Phone: 617-***-****

Senior Business Analyst with over 8 years of experience in Healthcare, Insurance and real estate domains, collaborating with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities. Business Analyst with in-depth knowledge of data warehousing concepts and in the field of Functional Business Analysis with expertise in End to End SDLC in Waterfall, Agile methodology (Sprint/Scrum) based projects.

PROFESSIONAL SUMMARY:

Proficient in Functional analysis, Business analysis, Requirement Elicitation, Requirement Analysis, Requirement Management and Communication, Impact analysis, As Is- To Be study, Gap analysis and JAD sessions.

Experience in conducting GAP analysis, User Acceptance Testing (UAT), SWOT analysis, Cost benefit analysis and ROI analysis.

Scrum Events: Backlog Grooming, Story- Point Estimation

Agile Scrum Ceremonies: Daily Scrum Call, Sprint Planning, Sprint Review, Sprint Retrospective Meeting.

Scrum Artifacts: Product Backlog, Sprint Backlog, Product Increment and Burn-down Chart.

Skilled in creating and maintaining Functional Specification Documents (FSD), Use Cases, Data field mapping, Process Flow mapping, Requirement Traceability Matrix, performing Impact Assessment and providing Effort estimates.

Assisted business in preparing BRD (Business Requirement Document) and FRD (Functional Requirement Document).

Experience in diversified business domains (Insurance, Property& Casualty, Health care, CRM, E-commerce) with heterogeneous relational databases such as Oracle, Microsoft SQL Server.

Expertise in creating Use case diagrams, use case specifications, Dataflow diagrams using Rational Rose, IBM Rational Software Architect, MS Visio and wireframes using Balsamic, Pencil.

Experience in OOAD (Object Oriented Analysis and Design)

Efficient in Data Modeling with expertise in creating Star & Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin.

Proficient with Data Extraction, Transforming and Loading (ETL) using various tools such as Informatica Power Center.

Experience on source to target mapping, gathering business requirements from business/user, creating source to target mapping document, creating process flows, and DFD.

Expertise in writing SQL queries using Toad and Query Optimization.

Collaborated with Supervisors, SME’s, Product Mangers to find best possible approaches to adhere to CMS guidelines.

Excellent in Data warehousing concepts like OLAP, OLTP, Slowly Changing Dimension (SCD) types (I, II &III) methodologies, Incremental Loads and Change Data Capture (CDC).

Hands on Experience in preparing Test cases, Test plan for UAT (User Acceptance Testing) and creating Product Backlog, Release plan documents.

Proficient in working as lead from both onsite and offshore.

Experienced in team handling, reporting with excellent track record of delivering within stringent timelines.

Excellent communication, analytical, goal-oriented approach, problem identification and solving skills.

TECHNICAL SKILLS:

ETL Tools

Informatica- PowerCenterv 9.x (Mapping Designer, Workflow Manager, Repository Manager, Workflow Monitor)

Data Modeling

Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Conceptual, Logical Data Physical Modeling, Visio

RDBMS

Oracle, MySQL and PostgreSQL

Web Tools

HTML, XML, CSS

Wireframes

Balsamic, Pencil

UML diagrams

Use case diagrams, Rational Rose, Rational Software Architect, Smart draw, MS Visio

Bug Tracking Tools

JIRA, Rally

Operating Systems

Windows XP/7/8/10, UNIX, Mac OSX.

Office Applications

MS Office (Word, Excel, Visio, PowerPoint, Project, Outlook)

Programming Languages

SQL, PL/SQL, T-SQL

Business Intelligence Tools

Tableau, Power BI

Project Methodology

Waterfall, Agile, Hybrid Client Specific

PROFESSIONAL EXPERIENCE:

Atlantis Insurance Agency, Newark, NJ

Role: Senior Business Analyst Jan’19 – Present

Description:

American Family Insurance provides insurance products to customers. This project is a web-based application enabling actions like registering new policy holders on the internet directly and incorporating complete details of the customer and their vehicles. It also helps validate all these service operations at the end.

Responsibilities:

Involved in generating Test cases for property and casualty Insurances for Different Levels of Business.

Gathered all applications used by Property and Casualty users across all business units like Claims, Consumer, Underwriting, Specialty Lines and PCG (Private Client Group).

Reviewed test cases and test data for Business Users.

Implemented traditional Software Development waterfall.

Coordinated meetings to determine needs of customers, as well as to determine the impact of changes.

Developed the Test plans for quality assurance based on functional requirements.

Prepared Use cases and Activity flow diagrams and Workflow diagrams, considering the scope of the project.

Provide support across different domain areas such as Payments, Claims Documentation, and Auto Estimations, Fire Claims etc.

Primarily responsible for managing projects consisting of the processing and delivery of data conversions for insurance agencies.

Responsible for improved service, reduce coding errors, improve consistency, improve profitability, improve cash flow and reduce facultative placement errors through a front-end reinsurance system.

Analyzed scope of the Edge project was to create a Web-based application for agents to submit and maintain commercial insurance claims.

Assisted in creating wireframes for web interface with the GUI design team.

Played a key role in the UAT, and Implementation of system enhancements and conversions.

Documented functional requirements documents (FRD) by interacting with development team for improving client's legacy system.

Conducted status report meetings with the business and the IT team on a weekly basis, as the most important aspect of the project was Data Mapping.

Environment: SQL Server, Windows, Share Point, MS Office, MS Project.

CVS Healthcare, Woonsocket, RI

Role: Business Analyst Sept’17 – Dec’18

Description:

CVS Health is an innovative Pharmacy company acquitted with Target to help people for better health. This project is about POS (Point of sale) of Target CVS. This point of sale application provides interaction between sale person and customer. POS supports to create purchase order based on CVS system prescription information. And also, customer can add any item over the counter which is not part of doctor prescription. This helps CVS to provide an accessible, supportive and personalized health care experience to customers and maintain data of transactions in CVS centralized RX connect system.

Responsibilities:

Worked closely with the Project Management Team to track and maintain project plans, budgets, resource usage, forecast and actual, in enterprise tracking system while also communicating issues and roadblocks pertaining to procedures.

Conducted meetings with users and other stakeholders to elicit, organize and document the requirements and also created project status reports and feasibility reports for stakeholders.

Worked for documenting process flow diagrams and data flow diagrams.

Incorporated closely with team to facilitate the Gap Sessions to make sure the team is on the same page.

Defined User Stories (Functional Stories, Technical User Stories and Service User Stories).

Reviewed and approved Test Scenarios and Test Cases based on user stories.

Documented healthy backlog for 2 sprints, calculating the capacity and velocity of scrum team.

Involved closely with Scrum master to facilitate ceremonies.

Tracing requirements throughout the development process and verifying adherence using the Requirements Traceability Matrix (RTM) and Resource matrix

Participated in Sprint ceremonies (Sprint pre-planning, sprint planning, daily-scrum, sprint review, sprint retrospective) to suggest improvements in scrum process.

Development of business process and technology to support care management and Medicare risk adjustment.

Worked on Quality Center for bug status tracking and maintained and created status reports for the application

Involved in weekly defect review meetings to review the status of defect fixes and upcoming build releases.

Collected test data for UAT sessions and facilitating Defect Triage Meeting.

Actively involved in continuous integration and frequent releases and patch release.

Environment: Windows, Workfront, HP Quality Center(ALM), MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio), Trello boards, SharePoint.

Larsen and Toubro (L&T), Hyderabad, India

Business Analyst Jun ‘15 – Aug ‘17

Description:

The project was all about enhancing the schedule of the project with proper inventory management, so that the project can be completed on time and within budget. For this, the concept of Just in Time Management was used, to increase efficiency and decrease waste, by receiving material only when they are needed, which thereby reduced the inventory costs. In addition, business insurance coverage for transportation, inventory was also introduced.

Responsibilities:

Procurement plan was created

Organized JAD sessions and elucidated the requirements from the stakeholders

Decisions were made on material management and based on this the vendors were selected.

Resource calendars are created, and the project procurement plan is updated according to the availability of resources.

Involved in GAP Analysis with the project leads and other SMEs.

Enhanced the schedule after the brainstorming sessions and documented the limitations

Created a product roadmap for the various stages throughout the project lifecycle.

Change orders are created as the project progresses, and these changes are updated in the procurement documents

Created process flow diagrams in Rational Rose.

Maintained benchmark controls for different activities in the project, company standards and contracts, performed vendor sourcing, costing, pricing and contract negotiation, performed procurement, ensured compliance with service/joint interest contracts.

Responsible for providing analytical support in the Design, Development and Implementation of Project.

Created Models such as Activity Diagrams and Flow Diagrams for the process using Rational Rose

Prepared Scheduling and Estimation reports using MS Project, MS Word, MS Access.

Prepared a detailed summary of the work done on that particular day and checked whether all the resources are available for next day’s work.

Environment: MS Project, Intranet, MS Word, Data base, Oracle

TATA AIG Insurance, Inc., Hyderabad, India

Business Analyst Jan’12 – May’15

Description:

TATA AIG offers personal auto, commercial auto, workers' compensation, homeowners and umbrella insurance. The project was to automate the Insurance claim system by providing real time monitoring for its Auto insurance division. The project involved developing a system in place for online quote applications to obtain reliable quotes in real time from existing web portal. The Project was undertaken to enhance the existing functionality of convenient access to real-time quote information with the ability to download quote information. The application also helped agents to obtain quotes for their customers.

Responsibilities:

Analyzed the system by performing As-Is study and created To-Be process flow in order to determine whether solutions meet the high-level business requirements.

Provide support across different domain areas such as Auto Assignment, Payments, Claims Data and Appointment Logs, Auto Estimations, Flood Claims etc.

Analyzed the Business rules for Claim assignments throughout the New Jersey, so as to have balanced workload for all the claims representatives.

Assisted cross-functional teams from Property and Casualty division business teams such as Annuities, Securities, Policy & Program Evaluation Team, Project Sponsors & Actuaries.

Utilized corporation developed Hybrid approach.

Develop strategies for enhancing or further leveraging these processes.

Elicited business requirements from core business units via JAD sessions, teleconference meetings, semiformal and formal meetings.

Documented the requirements in pre-existing Business requirement document (BRD)

Responsible for process modeling from inception through implementation and post implementation optimization along with associated UI design.

Planned and defined system requirements with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.

Worked closely with user experience (UI/UX) team for creation of wireframes and prototyping for web portal.

Document requirements and provide final technical review and validation of requirements.

Designed quality user stories making sure that they meet INVEST criteria.

Conducted Sprint planning meeting with developers and testers to review user stories, assign story points and cards to a respective sprint.

Engaged in analyzing requirements, identifying various individual logical components, expressing the system design through UML Diagrams.

Coordinated User Acceptance Testing (UAT) on a monthly basis with the Subject Matter Experts (SMEs) to make sure that all the requirements are addressed in the application.

Assisted with the development of user manuals and trainings to help educate users on the new functionality.

Environment: MS Visio, JavaScript, Rally, Pencil, Microsoft Office Tools, SQL Server, Hybrid Methodology

Contact this candidate