Sai Kalyan

Senior Business Analyst

Phone# 316-***-****

Email: acs051@r.postjobfree.com

Summary

Professional with 9 years’ experience as a Business Analyst in various domains. Expertise in different phases of Software Development Life Cycle (SDLC) with proficiency in Agile, Scrum, RUP and Waterfall Methodologies. Extensive experience in Unified Modeling Language (UML) diagrams such as Use case Diagrams (UCD), Sequence Diagrams and Activity Diagrams and State Diagrams.

Thoroughly experienced in creating requirement specifications by facilitating Joint Application Design (JAD) sessions and structuring interviews.

Excellent Knowledge of Business Requirement Document(BRD), Functional Requirement Document(FRD), Project life cycle with outstanding Business Analysis, Project Planning, Workflow, Execution and Control with ability to support multiple simultaneous short term projects.

Experience in creating and maintaining Requirement Traceability Matrices (RTM), conducting GAP Analysis, SWOT Analysis.

Expertise in writing SQL queries to extract data from different databases and perform data analysis.

Thorough experience in creating Scope and Vision Document, SRS, BRD, FRD by utilizing various modeling techniques including UML, BPMN, Wireframes.

Exposure to Automated Testing tools such as ALM Quality Center, and Load Runner.

Experience writing test cases, automated test script and recording the results.

Knowledge about HIPAA, Medicare and Medicaid (CMS) claims, claims processing, ICD-9/ICD-10, 4010 and 5010 standards.

Solid Knowledge about Patient Enrollment Process & Life Cycle of a Claim

Excellent verbal/written skills and can perform well both independently and as a team member

Experience and good understanding of the hospital system including Registration, Scheduling, Laboratory, Pharmacy, Patient Accounting, HIM, Claim Processing functions.

Experience in Health Care Industry with exposure to Electronic Medical and Health Records (EHR)

Experience with enterprise upgrades to workstation OS, Microsoft Project Server, and Microsoft Exchange.

Technical Skills

Software Methodologies/Models

Waterfall, Agile(Scrum), RUP

Requirement Management Tools

IBM Rational Requisite Pro, Blueprint

Operating Systems

Windows, Linux, UNIX

Database Management Systems

MS SQL Server, MySQL, MS Access, Oracle

Enterprise Tools

PeopleSoft HCM 8.X, 9.X

Programming Languages

C, C++, Java, Unix

Testing Tools

ALM/ HP Quality Center, QuickTest Professional, HP

LoadRunner/Performance Center

Business Modeling Tools

MS Visio, Rational Rose

Content Management Tools

SharePoint, Apache Subversion(SVN)

Defect Tracking Tools

JIRA

Documentation Tools

MS Office (Excel, Word, PowerPoint), MS Project, Adobe Photoshop.

Domain Knowledge

Healthcare, Finance

EDUCATION:

B.Tech- Computer Science and Engineering

Professional Experience

Client: New York State Office of IT Services, Albany, NY December’ 2013-Present

Role: Senior Business/ Systems Analyst

Project Description:

The aim of the project was to streamline the HR processes of the New York State HR system and this projected has an impact on 200,000 NY State employees.

Responsibilities:

Performed Data Mapping of the existing system and the PeopleSoft system by running query so that the non-delivered fields are discovered.

Created and Developed Business Process Designs for the Transaction Approval Process.

Created over 300 test scripts during various phases of testing.

Spearheaded Load/Performance Testing of the Application and the average time per transaction was reduced from 58 seconds to 12.58 seconds.

Created Test Scripts for Master File Reconciliation.

Tracked up all the open issues for which tickets have been opened and prioritized them and made sure that they were closed before the conversion was done.

Worked with PMs, Leads (Technical and Functional), SMEs, Project Director and Delivery Managers at various stages of the project.

Environments Used: PeopleSoft HCM (Core HR, Payroll modules), MS office suite, HP Load Runner, LATS (Leave and Accrual Tracking System), Office 365.

Client: Magellan Health Services, St Louis, MO

Aug’2013 – Present

Role: Senior Business Analyst

Project Description:

The Client Interface Support (CIS) team’s primary aim was to convert the already existing records to AUTHAUTOMATION which was a 3 step process, the last one being Production. The Scope of the Project was to upload the complete authorizations to the AUTHAUTOMATION Prod and then submit them to the respective Client.

Responsibilities

Business Requirement Documentation of the Client’s Development Process with detailed description of the Clients database and table names and implementation dates with milestones.

Testing the Correctness of EDI 278 and 834 Response files.

Generating AUTH_IDs, BATCH_IDs and RUN_IDs for various CENTENE and COVENTRY CLIENTS (Total number of clients=40).

Manually Running the Job Extracts in AUTHAUTOMATION and checking their statuses using JOBRUNNER.

Processing Response of the EDI 278 Response Files and promoting them to QA.

Involved in creating Test Cases and participated in Manual Testing.

COVENTRY and CENTENE Client Response file testing using SQL Server.

Environment: MS Word, MS Excel, SQL Server Management Studio (2008 R2), SharePoint 2010, JOBRUNNER, QC.

Client: Rex Healthcare, Raleigh, NC May’2012- July’2013

Role: Senior Business Analyst

Project Description:

The Rex Healthcare Hospital had to comply with CMS mandated ICD-10 requirements within very tight deadlines. The scope of the project was to collect the detailed information from various areas of the hospital and gather the requirement regarding all the applications, which were currently in use in hospital. The purpose of the project was to define the roadmap for implementation and analyze the collected data in order to fulfill the change from ICD-9 to ICD-10.

Responsibilities:

Identified risks, problems, requirements and concerns of the Hospital in order to comply with ICD-10 changes. Actively worked on Data analysis and Report analysis with respect to ICD-10 impact.

Performed baseline assessment of Hospital-Provider systems and related interfaces. The existing service level agreements and/or policies and operational business procedures for readiness to comply with HIPAA as well as ICD-10 requirements.

Gathered requirements by conducting interviews with end users. Prepared use cases, functional & system requirement specifications so that developers can understand the business process and rules according to their perspective.

Planned and organized UAT sessions with business users and tracked defects using defect tracking tools.

Highly involved in documenting department workflows and process flows with respect to applications. Analyzed System flows of various departments of the hospital.

Collected the information related to ongoing application upgrade and their impact on ICD-10 implementation and created awareness within the departments regarding the need, impact, benefits and risks of ICD-10 code application.

Involved in providing education about the ICD-10 standards, its requirements, complexity and accuracy to Physicians and Nurses of the hospital. Re-Organized the collected data and prepared documentation for implementation.

Figured out the requirement of training in various departments of the hospital based on their daily work.

Performed impact analysis on applications for deadliness of ICD-10 conversion. Additionally, was also responsible to meet the information demands of our business users by delivering timely, accurate, meaningful and standardized data and reporting

Mapped the collected data with the existing data provided by the hospital departments. Also, Used Word, Excel and Visio as a working tool and SQL scripts/queries for data verification and validation.

Experienced in using EHR technology to submit clinical quality and other measurement.

Experience working with patient access portal while performing UAT.

Creation of test data and testing of programs developed for data migration.

Conduct test development, execution, and administration of test phases, including functional testing.

Environment: Rational Unified Process (RUP),UML, SQL server, Blueprint, Cognos, SharePoint 2010, MS Office Tools – MS Word, MS Excel, MS Access, MS Visio, QC.

Client: Aetna Inc, Hartford, CT

March’2011-April’2012

Role: Senior Business Analyst

Project Description:

Plan Sponsor Information Layer (PSIL) is the repository of all plan sponsors enrolled into Aetna for both traditional and HMO plans. The Scope of the project was to create a PSIL which generates PSID which uniquely identifies a plan sponsor. PSIL maintains plan as well as plan sponsor data.

Responsibilities:

Responsible for Requirements gathering and Assessing the Requirements

Conducted thorough business process analysis to understand the existing workflows, document current processes and systems, develop use cases and create requirements for new systems and manage requirement changes.

Involved in the Estimation and creating a Detailed Design about the requirements and creating a Scope & Vision document

Work with the technical team to ensure that the requirements were being incorporated into the system design and testing.

Performed Self Testing & Integration Testing to test the correctness of the developed project at each and every stage throughout the course of the project.

Independent and Group Review sessions were done after specific milestones were reached during the project to keep track of the project deadlines.

Involved with the QA team during the testing of the project.

Create workflows and architecture design documents to translate business needs into visual images.

Report to senior management providing them with the progress updates.

Developed test cases and automated test scripts.

Major Projects:

ICD10 compliance

HMO Group Migration

Control Number scalability

Environment: SDLC Agile Methodology, Cognos BI, MS Visio, IBM Requisite Pro, IBM Rational Clear Case, IBM Rational Clear Quest, MS Access, MS Office, Oracle, SharePoint 2007, HP Quality Center.

Client: Discover, Riverbrooks, IL October’2010 - February’2011

Role: Systems Analyst/ Business Analyst

Project Description

Discover is one of the leading direct bank and electronic payment services company. The Direct bank operates the company’s flagship credit card business and offers an array of banking products such as private student loans, personal loans, savings account and prepaid cards. The payment businesses-Discover Network, PULSE ATM/Debit and Diners Club International- together process billions of transactions a year in credit, debit and prepaid markets around the world.

The Scope of the project was to develop a platform for multi-currency management to hedge foreign currency exposure risk resulting from the cross border payment transactions.

Responsibilities

Studied and elicited the requirements for multi-currency platform for cross border payment by interacting with the managers, development team and treasury department.

Creating Business Requirement Document (BRD) based on the documented requirements and created workflow diagrams.

Involved in test case review meetings.

Prepared Screen mock-ups by coordinating with different business users to illustrate the user requirements.

Participated in validating automation tests for terms and conditions and other website specifications.

Liaised between merchant services and treasury business units to gather requirements.

Established test methodologies, test cases, scripts and user acceptance testing.

Environment: Agile/Scrum Methodology, TDD, Oracle, Java, Rational Rose, Rational Requisite Pro, MS Office, JIRA.

Client: Reliance Healthcare, Baroda, India June’2008 - Aug’2010

Role: Business Analyst, Systems Analyst

Project Description:

Reliance Health is the outcome of the late visionary Dhirubhai Ambani's (1932-forever) dream to herald a health revolution in India by leveraging technology and delivering the healthcare to the doorsteps of India's vast population.

Reliance Health is set to transform the Healthcare Landscape of India by venturing into: Managed Care Administration; Healthcare Delivery and Integrated Health; Health Informatics and KPO; Consumer Health.

Reliance Health believes that above health initiatives of Reliance Group will refurbish the Indian Health industry to compete with best in the world while meeting the basic healthcare needs of Indian population.

Responsibilities:

The User requirements collected from the stakeholders were converted into Functional Requirements. Functional Requirements Document

Worked with stakeholders on Joint Application development (JAD) during prototyping phase of SDLC

Worked with SCRUM Project Management and Agile Methodologies FOR Software Development Life Cycle

Data flow and work flow diagrams were created to clarify the functional requirements.

Used SQL Server 2003 as a backend Database Server and Crystal Reports to generate reports

Use cases and use case models were created to help developers in understanding the requirements and for the test team to create functional test cases.

Interacted with the QA team to analyze and review the requirements document and make sure all the requirements are covered by at least one or more test cases.

Worked with QA team to develop performance test cases based on projected user load.

Used Rational tools to document and manage requirements, enhancement requests, and other documentation issues for the application

Assisted in writing the system test strategy, that contains test scenarios and test scripts for functional testing of interfaces & verifies the fields are populated with proper data into Order Management System.

Analyzed and reviewed the System requirements/Test plans and documented Test cases for functional, GUI and backend testing.

Manage application defects in Mercury Quality Center and testing with collaboration with the vendor and QA team. Developing test plans, (UAT) user acceptance testing.

Environment: UML, Agile/SCRUM, HTML, XML, SQL Server 2003, UNIX, IBM Rational Rose, MS office suite and MS Visio, Flat files searching, QC.

Client: National Informatics Center (NIC), Hyderabad, India October’2006 - June’2008

Role: Business Analyst/System Analyst

Project Description:

NIC is a Central Government Organization which specializes in the field of Information Technology and has its branches in all the states in India. The Project was named “Offline Forms Processing” and the aim of the project was to create application forms in order to apply for Driving License online, giving the users the ability to download the form offline and submit it online by just uploading the completed form; and the information of that form is entered into the database and the complete data is stored in a Data Warehouse

Responsibilities:

Responsible for the requirements gathering from RTO (Regional Transport Offices) and technical team.

Creating Reports by using Cognos BI.

Extraction of data related to a specific RTO.

Developed the Use case diagrams, Activity diagrams and Sequence Diagrams throughout the course of the project.

Coordinated with the QA team in testing.

Created the Functional and Non Functional Requirements for the Project.

Written SQL queries for extraction of the data and testing its correctness.

Developed Standard Operating Procedures (SOP) and recovery plans for the Cognos BI financial database and web portal services.

Managed the testing of the BI application with HP Test Tools, QTP & QC and User acceptance testing.

Environment: Agile Methodology, Pair Programming, SQL Server, Rational Rose, Cognos, MS Access, MS Word, MS Power Point, HP QC, QTP

Client: Life Insurance Corporation (LIC), Hyderabad, India January’2005 - September’2006

Role: Business Analyst/ Systems Analyst

Project Description

Group Insurance and Web Reporting (GIWR) maintains two databases, transactional and reporting. It administers life, long term disability and shot term disability claims. Apart from common life and disability benefits GI also supports premium waiver and survivor income benefits. The web reporting part of GIWR caters to the reporting needs of various plan sponsors and LIC administrators who need data in the form of reports to do trend analysis and to take major marketing decisions.

Responsibilities:

Actively worked on Business requirement gathering, analysis and Data analysis.

Analyzed the existing web based application to determine existing functionalities and perform gap analysis for new functionalities.

Gathered user and business requirements through interviews, surveys, prototyping and observing from portfolio managers and User Interface

Conducted JAD sessions for user interviews to gather requirements.

Wrote Use Cases for EDI transactions.

Created UML diagrams including Data Flow Diagrams, Activity Diagrams, and Sequence Diagrams using MS Visio.

Perform SQL queries to do database testing

Coordinated between test team, development and business team in clarifying the functionality issues and requirement specification

Major Projects:

PHI Masking in Group Insurance Mainframe and crystal reports

ATLAS Decommission

Inspro ETL Creation

Environment: Agile SDLC, Oracle, Cognos BI, Enterprise View, SQL, IBM Rational Requisite Pro, IBM Rational ClearCase, IBM Rational Clear Quest, MS Access.

Contact this candidate