Business Analyst

PRATHIK SANG

Senior Business Analyst/ Scrum Master

Email: ********.****@*****.***

Phone: 407-***-****

Senior Business Systems Analyst over 7+ years of extensive and diversified experience in domains such as Property & Casualty, HealthCare, and E-commerce. Proficient in Software Development Life Cycle methodologies i.e. Waterfall and Agile. Expertise in requirement analysis, design, development and testing.

Professional Summary:

In depth knowledge about Software Development Life Cycle (SDLC) using Agile and Waterfall

Experienced in interacting with business users to identify their needs, gathering requirements and authoring Business Requirement Document (BRD), Functional Requirement Document (FRD) and Software Requirement Specification (SRS) across the deliverables of a project

Proficient in creating Sprint backlog and Product backlog

Conducting Gap Analysis, Business process analysis, SWOT analysis and ROI analysis

Proficient in conducting Joint Application Development (JAD) and Rapid Application Development (RAD) sessions, Fit/Gap sessions, Brain storming sessions and peer review with IT Groups and project team members

Experienced in working closely with user experience team to create user friendly UI, based on usability studies, business needs and efficiency

Experienced with end-to-end business process mapping, business and technical requirements analysis, business planning, modeling, verification, methodology and product development

Competent in transforming business requirements into functional requirements and designing business models using UML diagrams - Use Case diagrams, Activity diagrams, Entity Relationship diagrams, Data flow diagrams and Sequence diagrams

Experienced in creating Unified Modeling Language models using MS Visio, Rational Rose and enterprise architect

Worked with different business users eliciting business rules and various Functional & Non-Functional requirements

Good database experience using Relational Database Management Systems (RDBMS)and MS Access. Worked with various SQL tools with a working knowledge of relational databases and structure

Experienced working with ETL (Extract, Transform and Load) of data into a data warehouse/data mart and Business Intelligence (BI) tools

Worked with Salesforce CRM tool to access the customer’s entitlement, campaign management, lead management and contracts/services information

Experienced designing the Burndown Charts

Well versed with Electronic Data Interchange (EDI), implementation and knowledge of HIPAA code sets, Medicare and Medicaid

Experienced in Medical claims process, claims billing and terminology

Proficient in creating Requirements Traceability Matrix (RTM) using BRDs, FRDs and test cases

Experienced working with project management tools like JIRA and VersionOne to create user stories,

generate reports, maintain log for the system, track defects

Developed test plans and test cases according to business requirements and performed User Acceptance Testing (UAT)

User training on the changes being released and conducting post production activities like getting feedback from users. In case of any issues - doing Root Cause Analysis, prioritizing tasks with business users

Possess excellent written and verbal communication skills. Responsible, self-motivated and organized

TECHNICAL SKILLS:

Domain

Property & Causality, Healthcare, E-Commerce, Construction

SDLC Methodologies

Agile (SCRUM), Waterfall

Document

Management Tools

MS Office- Word, Excel, Access, PowerPoint,

MS Project, Outlook, Office 365

Business

Process Modelling Tools

MS Visio, Enterprise Architect, Rational Rose

Project Management Tools

JIRA, VersionOne, VSTS, Rally

Testing Tools

ALM, Bugzilla

BI Reporting Tools

ETL, Informatica, Cognos, Tableau

CRM

Salesforce, Peoplesoft

Business Process Management tool

Pega

Programming Languages

HTML, XML, SQL

Operating System

Windows, MAC

PROFESSIONAL EXPERIENCE:

Client

The Hartford

Location

Hartford, Connecticut

Duration

May 2017 - Present

Role

Senior Business Analyst/ Scrum Master

The Hartford Financial Services Group, head quartered at Hartford, Connecticut, is a United States-based insurance company that is part of the Fortune 500 list. The company’s earnings are divided between property and casualty operations, group benefits and mutual funds.

Project Description

The project was aimed at developing ETL process to load the target databases with insurance claims to generate Business Intelligence reports.

Responsibilities

Organized and facilitated Agile and Scrum meetings, which included sprint planning, Daily Scrums or standups, Sprint Review and Sprint Retrospective

Conducted various meetings with stake holders and business users to understand and elicit the business requirements

Created and maintained Product Increment, Product Backlog and Sprint Backlog defining new systems operations for the project

Documented all data mapping and transformation processes in the Functional Design documents based on the business requirements

Created Technical Specifications documents based on the functional design document for the ETL coding to build the Data Mart

Performed Data Analysis and Data Validation by writing SQL query.

Worked on daily basis with lead Data Warehouse developers to evaluate impact on current implementation, redesign of all ETL logic

Facilitated walk through to the Development team for data extraction, transformation and loading (ETL process) from source to target systems

Organized the Quality Analyst (QA) walk through to explain proposed changes

Assisted test team in drafting test strategies and test plans to verify accurately any functionality issues and successful system integration

Worked closely with reporting team to generate business intelligence reports using Cognos and visualized these reports using Tableau

Worked with technical experts to improve report performance and performed system testing

Prepared test cases, test scenarios and performed User Acceptance Testing (UAT)

Environment: MS Word, MS Excel, MS PowerPoint, MS Project, MS Visio, MS Outlook, VersionOne Informatica, Tableau, Cognos, Windows XP

Client

Castle Medical, LLC

Location

Smyrna, GA

Duration

Jan 2016 – Apr 2017

Role

Business Analyst/ Project Coordinator

Castle Medical, LLC is a leading national healthcare solutions provider. It supports physicians, patients, and employers through the enhancement of pain management practices and promotion of better health through cutting edge clinical laboratory and genetics testing using state-of-the-art technologies.

Project Description

The project involved user interface development and Claims & Reimbursement processing. It is also for the maintenance of HIPPA health connect systems which involved EDI transaction codes 835 and 837 in its subsystem

Responsibilities

Conducted Joint Application Development (JAD) sessions with stakeholders to elicit requirements

Worked closely with the subject matter experts (SME's) to develop a detailed understanding of all the requirements

Documented and created Business Requirement document (BRD) and Functional Requirement document (FRD)

Designed and developed various UML diagrams like Use cases, Activity diagram and Sequence diagram

Created swim lanes, wireframes, screen mock-ups using MS-Visio to present the visual view of the feature within the website

Worked with multiple teams to improve the overall claim and reimbursement processes

Worked on EDI transactions which are used for submitting and tracking claims and discussed the same with developers and testers

Worked in the full HIPPA compliance life cycle from gap analysis, mapping and testing for processing claims

Worked on EDI transactions: 270, 271, 276, 277 835, and 837

Create weekly reports to inform management about the status of the project

Help in coordinating and managing various areas of the project and assist manager with the determination to finish the project on time and within budget

Played integral part in creating test plan, test scenarios and test cases

Worked closely with testers to create test cases and participated in UAT (User Acceptance Testing)

Environment: SQL Server, Rational Rose, MS Visio, MS Project, MS Office Suite, EDMS.

Client

Veena World

Location

Mumbai, India

Duration

Jul 2014 - Dec 2015

Role

Business Systems Analyst

Veena world is one of the top travel agencies in Mumbai, India offering budget travel package. It is active across every travel segment i.e. Family Group Tours, Specialty Tours, Inbound Holidays, Customized Packages and Corporate Travel

Project description

The project involved enhancing the website with content management system and working with marketing managers to develop a content management strategy. It also involved conducting ecommerce with features like campaign, mass mails.

Responsibilities

Created Product backlog, Sprint backlog and Use cases for content management application including work flow, file management, image management and webpage layout

Worked on eBusiness and eMarketing data collection, design, implementation and reporting

Facilitate JAD sessions involving the management, development and user teams for clarifying requirements and facilitating better communication

Created wireframes, UI Mock-ups, screenshots of the application using MS Visio

Created Use case diagrams, Activity diagrams, Sequence diagrams, Dataflow diagrams using MS Visio

Created and maintained Requirements Traceability Matrix (RTM) document according to BRD and FRD to manage the requirements

Planned and worked with the online marketing team to develop direct-to-customer initiatives.

Worked with various Salesforce standard objects like Accounts, Contacts, Leads, Cases, Reports, and Dashboards

Involved in Salesforce application setup and customized the app to match the functional needs of the organization

Supported and administrated CRM application, CPQ tools enhancement and Google analytics

Worked on email, search engines marketing, display advertising, webcasting, social media and other campaigns with knowledge on CPC, CPM and CPA

Actively interacted with marketing department at the corporate level to discuss about the information services of various products

Keep the management and the team informed about project status and issues that may impact client relations

Environment: Web Logic, Google Analytics, MS Office, MS Outlook, MS Visio, MS Project, Rational Rose, Oracle, Java Script, E-Commerce, Salesforce.

Client

Cigna

Location

Hyderabad, India

Duration

Jan 2013 – Jun 2014

Role

Business System Analyst

Cigna is a global health service company headquartered in Bloomfield, Connecticut. It offers Medicare and Medicaid products & health, life, accident, medical, dental insurance. The company focus on improving health of the customers health by providing preventive care

Project description

The project involved enhancing the website with content management and adding a feature. It also involved digital marketing.

Responsibilities

Involved in complete life cycle of Agile methodology

Facilitated meetings/interviews and JAD sessions with stakeholders and vendors to document the business requirements

Interacted with the stakeholders to review and baseline the design documents

Actively involved in the creating, grooming and sizing of the product backlog, sprint backlog and release backlog to monitor the development process

Created process flow diagrams to define AS-IS and TO-BE process

Conducted milestones planning of the project through walkthroughs and meetings involving various leads from Development, QA and Technical Support teams

Created and managed project templates use case project templates, requirements types and traceability relationships

Designed UI wireframes and data element dictionary related to the screens of dashboard and benefits modules

Created UML based models like Use case diagrams and Sequence diagrams using MS Visio

Created test plan and test cases

Facilitated UAT sessions with stakeholders to validate the requirements

Environment: Web Logic, MS Office suite, MS Visio, Rational Rose, MS Project, Oracle, Java Script, E-Commerce, Salesforce

Client

Bayhealth

Location

Hyderabad, India

Duration

June 2011 – Dec 2012

Role

Business Analyst/Project Coordinator

Bayhealth is a non-profit healthcare system which operates several outpatient facilities across central and southern Delaware. In addition, it also offers numerous outpatient services, patient and family support services, community outreach, and imaging services.

Project Description

The project was aimed at website enhancement which involved addition of few features which helped the patients to select the physician in a specific location and request an appointment online. Also, we added an additional special feature which facilitated the patient to donate/gift the organization or people who served them.

Responsibilities:

Coordinated with the stakeholders and project key personnel to gather functional and non-functional requirements during JAD sessions

Elicited the requirements from the stakeholders and documented them clearly in product backlog and sprint backlog

Conducted sign-off sessions with the stakeholders to lock down the requirements

Conducted weekly standup meetings for the team and documented the minutes

Created various user stories and task in Jira and assigned them to respective developer or testers

Plan, schedule and coordinate various activities like project estimation, project work flow and task management for the entire project

Developed mock-ups screens and visuals for the applications using Rational Rose and Use Cases and Activity diagrams

Keep the project manager and the team informed about the project status and issues that might impact client relations.

Facilitated and participated in sprint review meetings to discuss/ demo the features developed within the sprint with stakeholders/end users

Environment: MS Word, MS Excel, MS Project, MS Visio, JIRA, Rational Rose, Oracle, Java script, Outlook

Contact this candidate