AMIT

Senior Business Analyst/Scrum Master

Email id : ac6hbd@r.postjobfree.com

# 408-***-****

CAREER SUMMARY

9+ years of Industrial experience in Insurance, Healthcare, Banking, Finance, and E- commerce

Highly skilled professional with industrial experience on standard Software Development Life Cycle (SDLC) methodologies like Waterfall, Scrum, Kanban and Waterfall-Scrum Hybrid and have decent understanding on Rational Unified Process.

Proficient in Stakeholder Analysis, Impact Analysis, Risk analysis, Change Management, Dependency Management, Conflict Management Cost-Benefit Analysis and Gap Analysis includes AS-IS and TO-BE analytical techniques.

Seasoned in facilitating Scrum Ceremonies including User Story Workshops, Daily Scrum, Sprint Planning, Sprint Review, Sprint Retrospective and Backlog Refinement meeting.

Performed Business Process Modelling (BPM), Analysis & Re-engineering and providing solutions for issues relating to Risk management and Solution Management processes for better and efficient decision making in time.

Expertise in designing, Mockups, Wire Frames, Prototypes and Power Point Presentation.

Expertise in gathering and managing Requirements and tracked defects working with Jira, Rally (CA Agile), SharePoint Enterprise 2016, HP Application Lifecycle Management (HPALM) and HP Quality Center (HPQC).

Professional experience in Business Analysis, Software Development Life Cycle: System Analysis, Design, Development, Testing, and Implementation on Business Systems in a fast-moving environment.

Experience in administering and customizing Sales Cloud, including Service Console, assignment rules, email-to-case, queues, escalation rules, record types, support processes and settings.

Extensive experience working on Administration, Customization, Configuration, Implementation and Support of Salesforce CRM and Salesforce SFA applications based on Apex Language and leveraging Force.com.

Extensive experience in analyzing and requirements gathering and writing functional specifications including use cases in both waterfall and agile methodologies.

Experience in Developing and evaluating business process Models (BPM).

Proven success as a business analyst through the years, providing a well-balanced understanding of business relationships, business requirements, and technical solutions.

Strong experience in RUP Business Modeling process.

Expertise in UML (class diagrams, object diagrams, GAP Analysis, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams) as a business analysis methodology for application functionality designs.

Design and review of various documents including the Business requirements document (BRD), Software Requirement Specifications (SRS), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents

Worked on MS access for business process management (BPM), customer relationship management (CRM) and leading-edge integration resources.

Worked on AEM upgrade project from AEM 6.0 SP2 to AEM 6.3 using in-place upgrade approach.

Highly skilled and expert in all tiers of AEM technology stack including AEM, JCR, Sling and OSGi technologies, component template development, reports, DAM, workflow components.

Data analytics and Reporting & Proficient in Tableau Desktop, Server, Cognos BI tools, Cognos TM1 and MSBI, Informatica, AWS(Amazon Web Services).

Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie-charts, geographic, Tree Map visualization and other making use of actions, other local and global filters according to the end user requirement.

Constructed and maintained site product access and usability.

Programmed graphics and hotspots, managed database containing thousands of product listings.

Collaborated within a highly organized team of specialists to meet bi-weekly deadlines

Worked on Tableau for generating Geo Access Maps and dashboards for network adequacy in Provider Data Services.

Well versed in in-person as well as live meeting, Joint Application Requirements (JAR) and Joint Application Development (JAD) sessions.

Experienced to provide link between the technical and business views of the system by ensuring that the technical solutions being developed will satisfy the needs of the business

Used MS Excel spread sheet, PowerPoint, MS Visio, and MS Projects.

Experience in creating and maintaining the Requirements Solution Summary Document (SSD).

Working knowledge of health care industry Claims Processing, Medicare, Medicaid and Commercial Claims both from the Health Care Standpoint and the Pharmaceutical Standpoint (PBM).

Sound knowledge in the HealthCare transactions: Eligibility Request/Response (270/271), Claim Status Request/Response (276/277), Benefit Enrollment (834), Health Care Services Request (278), Payment/Advise (835) and Health Care Claims (837).

Well versed with SDLC methodologies like AGILE Scrum, RUP and Water fall

Demonstrated ability to identify root causes of problems, consider both the long and short-term impact of proposed solutions and develop workable solutions. Ability to manage (Multiple) project tasks with changing priorities and tight deadlines. Ability to work well in a team. Open to Team related tasks, team meetings, team interaction and conference calls.

Excellent command over Written and Spoken English Language, Medical Terminologies, Health Care Laws, Policies, Guidelines and Action Plans.

TECHNICAL SKILLS:

Methodologies:

RSA, Agile, Waterfall

Testing tools Servers:

HP Quality Center/ ALM, Cucumber, CRM/Salesforce

Languages

C, VB Script, XML, SQL

Modeling Tools

MS Visio, MS Sharepoint, Tableau

Document Management Tools

MKS, SharePoint, Share Drive

Version Control Systems

Rational Clear Case

Database Management Tool

Reporting Tool:

MS SQL Server, Toad (oracle)

Report builder, Report designer

System Integration Tool

Bizz TALK

Database

MS SQL Server, MS Access, and Oracle, Sybase, AS400

PROFESSIONAL EXPERIENCE:

Grange Insurance, Columbus, OH Feb/2017- Present

Sr.Business Analyst / Scrum Master:

The objective of the project was to continuously develop and refine medical practices to help ensure that care is delivered in the most efficient and effective manner possible. The project was to give the payers a clear vision of claim lifecycle from submission to the organization through payer adjudication. The project is to implement a web-based claims processing and management application.

RESPONSIBILITIES:

Provided life cycle support in FACET’s enhancements to facets workflow and network management suite with pricing and network modeler application – was actively involved in gathering business requirements, assisting in functional design, technical design, and production support documentation for the interfaces

Performed impact analysis during the project to manage requirements churn by checking the feasibility in maintaining triple constraints and discussing them in Daily Scrum Stand-up Meeting.

Actively assisted the product owner in Prioritizing the Product Backlog as per the maximum business value along with proactively working on grooming User Stories in planning activities using INVEST criteria.

Assisted in the creation of Deployment Flow Chart in conjunction with development, infrastructure, and network teams containing information for effectively deploying and maintaining the health admin application.

Was actively involved in designing the data models conducted normalization and de-normalization of data to fit OLTP and OLAP frameworks, slicing and dicing of data marts for analytical decision-making support across the teams

Designed test cases, test plans, test scripts and test scenarios to perform functional testing, regression testing, and defects logging using JIRA. Defined acceptance criteria for user stories for user Acceptance Testing using Cucumber

Tracked issues in JIRA and allocated tasks, managed user stories and the and the RTM during project duration

Tested dashboards data against source system and rectified the defects.

Act as a Tableau Administrator, using Tableau Server for publishing the developed dashboards to server, authentication, authorization, security Tableau Extracts scheduling and refreshments, User Management Adding users and Groups, Content Restriction to users, to content based on access level as a Tableau Content Administrator.

Published dashboards on Tableau Servers and scheduled Tableau data extracts refresh.

Worked on FACETS TriZetto transactions, and Health Insurance Claims Processing System. Was actively involved in analyzing the mainframe reports for the members /eligibility/claims and mapping the fields with FACETS reports

Performed Facets data modeling that included; planning, designing, implementation of the data. Performed testing by developing moderate SQL queries involving joins and un-joins.

Validated basic SQL scripts to verify the application CRUD operations on database using MySQL

Bridged the gap between the internal and external business groups (Claims, billing, provider management, provider agreement management, customer service, capitation) and the project team

Generated UML Diagrams mainly, Use Cases, Activity Diagrams, and Sequence Diagrams to define the interactions between the user and the system using Microsoft Visio

Coordinated with the Web Services team in documenting requests and responses for the REST Web Services in JSON. Manually tested and executed the Web services using Postman and helped the QA team in automation

Supported the team in designing the Test Strategy, Test Cases, and Companion Guide from the development stage to the production stage including internal requirements and external requirements

Environment:Hybrid Agile, MS Project, MS Excel, XML, HTML, MS Office, SharePoint, MS Visio, FACETS, SOAP UI, JSON, Test Director, Tableau 9.2, 10.1, Cucumber, UML, SQL, QTP, Postman, Power Orders

Emblem Health, New York City, NY Sep/2015-Feb/2017

Sr.Business Analyst/Scrum Master:

The objective of the project was to upgrade the existing health insurance system. In this project we developed a web-based application and a direct portal to register insurance policies for prospective clients. A new MMIS system was developed for centralizing all the healthcare transactions this project was a large IT project replacing the Medicaid claims payment system.

RESPONSIBILITIES:

Information regarding the current MMIS system, interfaces, and business processes was elicited during a JAD session.Brainstorming and Laddering sessions were also conducted to elicit specific information.

Worked closely with Business Directors, Project Managers in various business areas to gather, analyze and document the requirements and supported the project manager throughout the development lifecycle.

Created Business Requirements Document (BRD), Systems Requirements Specification (SRS), and Requirements Traceability Matrix (RTM) with the assistance from the business group and IT team members.

Conducted Impact Analysis when there is any change in requirements and updated the Business Requirements Document (BRD) and Systems Requirements Specification (SRS).

Used Rational Requisite Pro for managing the project requirements comprehensively to promote effective communication amongst the team members and reduce the risk.

Created Use Cases to define the role of the users who receive claims, users who process claims, and users who adjudicate claims. Used MS Visio to develop Use Case Diagrams, Activity Diagrams.

PerformedGapAnalysis for HIPAA 4010 837P and 835 transactions and HIPAA 5010 837P and835

Conducted Use Case reviews and identified gaps leading to improvements/enhancements in the same

Worked with HIPAA Team for the implementation of X12 ANSI 270/271 and 276/277 Companion guides for Pharmacy and Dental claims. Cross-functional team member in the implementation of the ANSI X12 involving 837 HIPAA compliance and 835 Remittance Advice.

Wrote Test scenarios and Test Cases for testing the migration of EDI HIPAA 4010 to 5010 and the processing of member enrollment and benefits, batch jobs corresponding to the claims 837 and real time transactions.

RecordedTracking System Defects in Rational Clear Quest. WroteTest Scenarios, Test Cases and executed them.

Environment: Waterfall - Hybrid, MS Visio, UML 2.0, MS Office Suite, MS SharePoint, FACETS, Test Director, UML, SQL, Rational Requisite Pro, Rational Clear Quest

Zions Bank, Salt Lake City, Utah Jun/2014-Aug/2015

Business System Analyst:

The scope of the project was to comply with the new CCAR regulations and prepare CCAR reporting schedules (FRY 14A/Q/M & 9C) for digital banking division and providing in-database computing solutions to integrate with the enterprise level data reports. This project emphasized to create a CCAR data mart that will support the summary level reporting as well as detailed supporting information required by Federal Reserve.

RESPONSIBILITIES:

Create and maintain customer-facing Adobe AEM content management systems.

Involved in the design and development of the AEM 6.2 components and templates.

Fixed styling issues due to upgrade.

Worked on AEM - Sling models, Slightly and Touch UI development.

Organized and conducted Kick-off meetings, developed the Project charter and Project Scope statements to obtain sign-off from business stakeholders, ensured Scope and Deliverables were clearly understood by Sponsors and Team

Identified baselines, crafted and defined the project constraints, project dependencies and project deliverables

Executed Project Management process from initiation to deployment using a Hybrid (Scrum- Kanban) methodology

Published project objectives to increase visibility and created a transparent working environment for the development team.

Created and maintained various artifacts such as Project Charter, Project Management Plan, Stakeholder Registry, RACI Matrix, PI Matrix, CR forms, Change Log files, Risk Register document, Roles Charter and Communication Plans.

Actively involved in Project Risk Management, took corrective actions to mitigate, transfer or accept risk appropriately.

Supported Product Owner to create User Stories that follow the 3Cs pattern (Card, Conversation & Confirmation)

Effectively gathered requirements based on the CCAR regulation for Financial Statements, Interest Rate, Credit Ratings and Investment securities; Elicited them by JAD Sessions, Structured Interviews and Questions/ Surveys.

Elicited requirements by facilitating Brainstorming and JAD session involving Compliance SME’s, Risk Managers, Credit Analysts, Operational Managers, development and QA lead.

Interacted with the SME's and Technical Architects to analyze the data extracts from legacy systems and determine the element source, format and its integrity within the system.

Performed GAPanalysis, identified AS-IS and TO-BE business processes and technology, potential pitfalls, risks, and issues. Drafted and maintained BRD, FRD, and RTM.

Assessed Business Requirements and categorized them into high level and low-level use casesandcreated Activity Diagrams/State Chart Diagrams (UML) using MS-Visio. Assisted UI/UX team in creating UI mock-ups, wireframes.

Gathered CCAR PPNR and supplementary metrics (FY-14) forecast from various business units.

Analyzed CCAR (FR Y-14A/Q/M & 9C schedules of the Income statement and balance sheet), report requirements in AXIOM, which provided seamless drill-down to the exposures level details with flexible Report Position Adjustments.

Supported CCAR and BASEL data acquisition teams to validate and reconcile data coming from various systems.

Assisted in developing good practices for risk modeling procedures related to CCAR/DFAST.

Prepared Sprint Burn Down chart which helped Product Owner and the Dev Team envision progress.

Performed source (digital banking discipline) to target (enterprise level data reports) data mapping based on the common metadata structure. Assisted data analyst in data modeling, data analysis related to Credit Risk.

Designed and implemented basic SQL JOIN queries for QA testing and validated reports generated in Axiom.

Loaded the data into database tables using SQL*loader from TXT and CSV files. Involved in writing stored procedures, views, cursors and triggers using SQL Server. GIT was used for source code management.

Assisted in implementing all stages of development processes including extraction, transformation, and loading (ETL) data from various sources into Data warehouse and Data Marts using Informatica Power Center Designer.

Used Tableau as data visualization tool to communicate information clearly and efficiently via statistical graphics and to create executive dashboards, weekly/monthly reports on the status of key business measurements.

Assisted the team in using ActimizeAnti-Money Laundering suite to provide end-to-end AML detection.

Devised Acceptance Criteria for User Stories for User Acceptance Testing and to perform Functional Testing, Regression Testing and logged defects using JIRA and composed Test Cases for UAT and Regression Testing.

Assisted the QA team in writing and maintaining Selenium Web-Driver scripts for regression and functional testing using a data-driven framework. Assisted in executing browser compatibility and regression tests using Selenium Web-Driver for testing UI for every new build release.

Assisted Quality Analyst team to write Gherkin automation test scripts to execute in Cucumberandto create Cucumber feature files comprising of various Test Scenarios and definitions for BDD.

Environment:AEM 6.2, Agile-Scrum, AXIOM, Tableau (v-9.0), MS Visio, Oracle 12c, JIRA, SQL, Confluence, Bitbucket, GIT, MS Office, Informatica Power Centre v9, Selenium 2.5, Cucumber 2.0, ACTIMIZE, HTML5.0, CSS 3.0

Sun Life Financial,Boston, MA Oct/2013-May/2014

Business Analyst/ Scrum Master:

The project was to completely migrate the Legacy CRM Application on the Premises to the Salesforce CRM to reduce its footprint andoverhead costs that comes up with infrastructure maintenance. As part of this vision, the organization wanted to integrate the migrated Application with the Enterprise Service Bus(ESB) with in a Service Oriented Architecture (SOA).

RESPONSIBILITIES:

Elicited business requirements for the project using interviews, document analysis, surveys, site visits, use case scenarios and used standard template of the organization to develop requirements.

Gather the acceptance down time windows from System Traffic Reports and assist the project management team in Batch processing and Migration Strategy.

Responsible for Stakeholder Analysis, Managing the requirements creating UML diagrams (Use Cases, Activity Diagram and Class Diagram)to capture and represent the dynamic behavior of different applications.

Provided Administrative Support and created Custom objects, fields- Leads, Marketing, Campaign, Dashboard, Sales, and Account for Salesforce Configured security and organizational hierarchy for sales for salesforce implementation.

Involved in Design and development of Workflows rules, Testing, triggers, validation rules and customizations with Salesforce Configured Reports for custom objects and associated them to Dashboard.

Customized page layouts for Salesforce standard and customized workflows, Approval process, objects, Dashboards, Out bound messaging services, Exception to OWD(Org wide Defaults) as per the requirement.

Drafted Data Dictionaries, Data Mappings Artifacts and identified various Transformations required.

Involved in the System Integration Testing (SIT), and perfumed Work Flow- Functionality testing validated Test reports.

Worked on API Documentation and Technical Writing and supported ESB Integration Team on SOA.

Facilitated the Pre UAT (User Acceptance Testing) and UAT; assisted in testing and maintaining quality procedures such as Black box and Regression testing; created all the relevant documents for appropriate users.

Responsible for managing Salesforce application user profile, roles, permission, validation rule.

Communicate with stakeholders to understand the business requirement and translate them into business flows and detailed functional requirement.

Interacted with various business user groups for gathering the requirements forSalesforceimplementation and worked on documentation.

Involved in replication of SalesforceCRM data to Oracle.

Worked with various Salesforce.com standard objects such as Accounts, Contacts, opportunities, Products, Cases, Chatters, Leads, Campaigns, Reports and Dashboards.

Created new custom objects and relationships between objects to better suit the organization's business needs.

Environment: Waterfall-Scrum hybrid, JIRA, Confluence, MS project, MS office Tools (Word, Excel, PPT and Visio), Salesforce CRM, APEX, Data loader, Visual force, Webservices, Force.com IDE, Mule soft ESB, SOA, Guide-wire Suit, XML, WSDL, SOQL.

Snapdeal, Mumbai, India Mar/2012-Jun/2013

Business Systems Analyst:

B2C Application System

I worked on a web-based B2C e-commerce application for online merchandise accessed by potential customers. It has functionalities such as sales, service, order management, renewals, supply chain management to provide customers continuous high-quality experience. Created an integrated product catalogue for customers.

RESPONSIBILITIES:

Identified scope and business rules of the project by working closely with clients.

Hosted JAD sessions with stakeholders, Subject Matter Experts (SME’s)& management personnel to reduce the time spent on gathering requirements. Helped in creating BRD&FRD.

Based on Business value vertically sliced Epics into user stories during Product Backlog Grooming sessions.

Extensively used INVEST criteria to write User stories along with Product owner, development team and Scrum master. Also wrote Acceptance criteria for each user story.

Participated in various scrum ceremonies like Product Backlog grooming sessions, Sprint planning meeting, Daily Scrum, Sprint review meeting, Sprint retrospective.

Liaised between product development team, cross-functional units, Project management team and finance department identifying business process gaps to manage risk ensuring project success.

Created Mock-up and wireframes using UI components for enhancing customer experience using MS-Visio.

Used SQL select, update, delete queries to retrieve, update and remove data from databases to verify browser interaction with Database.

Worked on SOAP, XML and created API gateway for payments in Service oriented architecture (SOA).

Assisted User acceptance testing (UAT) with Sr. Business Analyst in environment setup, identified stakeholders, defined acceptable criteria for scripts to pass. Worked on HP- UFT.

Tracked entire project using Rally, kept track of team involved in each phase, communicated defects to team involved and made sure tickets raised are resolved.

Prepared test reports, success criteria and bugs report using MS-EXCEL, MS-Office.

Worked on functional side with Salesforce business team to identify and capture customers.

Assisted in creating various Tablix, Matrix, snapshot reports using SSRS for analytics and management reports.

Creating different types of SSRS reports like Parameterized, Drill through, Drill down, sub reports using tables, cross tabs and charts.

Applied various SSRS expressions like aggregate functions etc. to apply custom logic to meet the requirements

Environment:Waterfall-Scrum hybrid, Rally, MS-Visio, SQL, LoadRunner, MS Office suite 2010, HTML 5.1, CSS, SQL Server, Wireframes, REST, SOAP, SOA, XML, SSRS, Salesforce CRM, HP-UFT.

Mphasis, India May/2009-Feb/2012

Business System Analyst :

Multi-Agent Decision Support System

Description:

The project dealt with enhancing of clients Multi-Agent Decision Support System (MADSS) which was used for stock trading. This solution was built to dynamically exchange information and knowledge among investment domain. This domain specializes in supporting Technical analysis agent, Fundamental analysis agent, Risk management agent and Decision-making agent. The Decision Support System has the capability to leveraging information technology and domain expertise of investment specialists for Managing the portfolio of investments in the ‘event driven stock market’.

RESPONSIBILITIES:

Analyzed business requirements, documented and segregated them into high level and low-level documents. Created activity diagram, Use cases and Sequence diagram using MS Visio following UML methodology.

Derived Functional Requirement Specifications (FRS) based on User Requirement Specification URS. Understood and articulated business requirements from end-user interviews and converted requirements into technical specifications.

Reviewed Test plans, Test cases, Test case execution using specification documents and Rational Test Manager.

Studied the as-is process by interacting with the SMEs and to arrive at to-be or desired business process.

Performed Smoke Testing to ensure that the compiled software components of the Applications adhere to Performance Criteria and Functional specifications and ensured feasibility of built solutions.

Conducted JAD sessions with SMEs and projects stakeholders such as users, QA analysts, and project management team and compiled High Level Document (BRD).

Assessed scope and impact of business needs throughout by analyzing new application features and functions that needs to be built along with enhancement specification or needs.

Liaison with corporate departments, including Executive, Legal and Information Services to monitor, track and communicate project status and handled vendor relationships.

Environment:UAT, JAD, J2EE, UML, RUP, MS Project, Hyperion Essbase, Visual Basic, Quality Center, XML, MS Office, Rational Rose, Rational Requisite Pro, Unix.

Education:

Bachelor of Technology, M.D.U, INDIA

Contact this candidate