Sai Vinay Kailasam

Sr. Business System analyst

Mail: kailasamsaivinay@gmail.com
Contact: (507)-403-0130
LinkedIn www.linkedin.com/in/sai-vinay-kailasam-639475107
Professional Summary:
● Work experience as Business Analyst in multiple domains Healthcare, ecommerce and e-
learning with solid understanding of Business Requirement Gathering, Business Process
flow, Business Process Modeling, and Data Analysis and Business Process in
Reengineering in Health Care Sector with prime focus on claims adjudication, provider,
eligibility and prior authorization for Medicaid and Medicare programs.

● Extensive experience in business process engineering and Software Development Life

Cycle (SDLC) including analysis, design, development, testing, implementation and
supporting of software application.

● Business Requirements Gathering sessions in the form of questionnaires and business

scenarios with the end users, subject matter experts (SME) and the developers. Gather
user and business requirements through interviews, surveys and prototyping, System
Requirements Specifications (SRS), System Design Specifications, functional
specifications, non-functional specifications and defining project plans.

● Conduct JAD sessions with end users to gather functional and technical requirements,
perform GAP analysis, and document standard business processes and flows.

● Knowledge of HL7 message formatting.

● Extensive experience in creating Wireframes / UI Design using MS Visio.

● Introduced the Agile SCRUM process for the Risk Data team and utilized Microsoft
Team Foundation Server TFS to manage the team's software development lifecycle
including deriving product backlog items, assigning sprint work items to developers and
conducting sprint review meetings.

● HIPAA 4010–5010 Conversion Analysis – Involved in the documentation of HIPAA 5010

changes to EDI 837, 834, 835, 276, 277 Transactions.

● Worked with various versions in Tableau, Tableau Server, Tableau Public, Tableau Reader
and Tableau Online
 ● Able to creatively stretch the capability of Tableau to customize and develop creatively
stunning and dynamic visualizations

● Deep, technical knowledge of both Tableau Desktop and Tableau Server from an
administrative and a consultative standpoint

● Strong oracle SQL skills with good knowledge of RDBMS concepts

● Designing and developing SharePoint 2013 Applications for business intelligence

including designing, developing dashboards and branding SharePoint Sites.

● Planned implemented and supported small and medium scale SharePoint 2013 and 2016
deployment.

● Proficient in UAT, Test Planning, Requirement Study, Developing test scenarios and test
cases, Functional Testing, Regression testing, Production support, Defect Management
and Onsite/offshore coordination

● Efficiently managed QA through all phases of the Software Development/Testing Life

Cycle including Test Planning, Test design, functional test, integration test, system test,
user acceptance, beta, Production release, maintenance, and support

● Vendor Management – Worked as a facilitator for Testing Efforts and New Requirements
between the Healthcare Company and its various Vendors.

● Sound experience in Agile & waterfall testing Methodology, Testing Matrices and Trace
Matrix

● Proficient in Microsoft Office products such as Word, Excel, Access, PowerPoint, and
Visio.

TECHNICAL SKILLS:

Project Methodologies Agile (SCRUM), Waterfall

 Databases MS SQL Server, Oracle. Database

Operating Systems Microsoft Windows XP

Business Modeling Tools MS Visio, Smart Draw.

Requirement Management Tools Confluence

Defect Tracking Tools JIRA, HP-ALM, Quick Test Professional.

Repository Tool Share point

CRM Tool Sales force

Development Methodologies RUP, BABOK, AGILE, Waterfall, Scrum

Reporting Tool Crystal Reports

Other Tool MS Project, MS Office, WORLDOX,

Counsel link MS Outlook, MS Power
Point, MS Excel, SnagIT, Tableau

Professional Experience:

Client: US Bank, Minneapolis, MN Feb 2022 – Till

Date
Role: Sr. Business systems Analyst/Product Owner
Responsibilities:
 Worked on Multiple Applications like ULDD (Uniform Loan Delivery Data), Early Check
where different lenders submit loans to Confidential.
 Worked on QREP (Quality Reporting Enterprise Platform), this application is used by all the
major projects in Confidential for reporting purpose and delivered the reporting application
successfully.
 As a Product Owner took part in backlog grooming Setting the acceptance criteria and
defining the definition of DONE -
 Gathering requirements from stake holders and updating them in the product backlog.
 Managed discursions sessions with SMEs, Business departments, and It Analysts Project
Managers for planning and Requirements Gathering.
 Used group discursion sessions, and one-on-one meetings to identify business and System
Requirements, and documented using Use Case Modeling, Process Flow diagrams and
documentation.
 Identified the key stakeholders and the business users of the application.
 Created product roadmap for the various stages and releases thought the project lifecycle.
 Involved in upgrading the applications from Windows 2008 to Windows 2010.
 Successfully upgraded the applications and fixed all the issues on time which were the
roadblocks for the upgrade in fast paced environment and short time.
 Gained good knowledge on loan origination process and the documents involved in the set up
10O3, Good faith estimate and TIL (Truth in Lending).
 Worked with business users and reporting team to build custom reports and documented the
reporting requirements by using spreadsheets using pivot tables, Logical Excel statements
and graphs.
 Captured, Organized and Tracked requirements in Requisite Pro
 Created analytical models that estimate future credit risk and losses at the account level for
all existing and prospective loan products.
 Worked as an Interface between the loan advisors, brokers and the different teams involved
in the application development for better understanding of the business reporting
functionality.
 Conducted JAD sessions with stakeholders, end users and SME, to determine the critical
business processes and identification key functional requirements.
 Created process flow diagram in MS Visio.
 Conducted timely requirement review sessions with Stakeholders and business and end users
to ensure product verification.
 Actively conducted and participated daily standup meeting with team to know the status and
progress of the requirements.
 Assisted with User Acceptance Testing (UAT), developing and maintaining quality
procedures, and ensuring that appropriate documentation is in place.
 Worked closely with the testing team participating in Unit, GUI, Black box Smoke,
Integration and UAT Testing
 Identified and documented issues, risks, gaps and their impact to the project life cycle.
 Analyzed the Gaps for Training purposes and provided recommendations and alternatives.
 Extensively used and managed all the requirements artifacts in Confluence.
 Maintained all the stories and tasks in JIRA used to know the status of requirements.
 Implemented JIRA Safe methodologies in the project.
 Maintained and reviewed the test cases in HPALM.
 Reviewed test cases and maintained the Requirement Traceability Matrix (RTM).
 Performed Functional and UAT testing before the system went live.
 Involved in creating User Manuals and training users for the application built.

Environment: MS-Office, MS Access, Excel, MS outlook, Snagit9, Confluence, SharePoint,

JIRA, Windows XP, Power point, SQL, HPALM, Tableau

Client: Ameriprise Financial, Minneapolis, MN March 2019 – Jan 2022

Role: Business, Systems Analyst
Responsibilities:

 Actively involved in validating the requirements and applying the RUP framework
throughout the SDLC.
 Involved in designing and developing Data Models and Data Marts that support the
Business Intelligence Data Warehouse.
 Worked closely with the Enterprise Data Warehouse team and Business Intelligence
Architecture team to understand repository objects that support the business requirement
and process
 A strong emphasis on maximizing the return on investment (ROI) as well as maintaining
and improving several key marketing metrics such as Volume/Cost and Cost per booked
loan.
 Presented overview of entire Credit Derivatives trading system to senior leadership teams
of various asset classes.
 Tracked all referral business from the Retail Bank to all other lines of business for
incentive purposes.
 Monitoring the project progress and performance of the team using Agile methodology.
 Drive business proposal for corporate wide enterprise tool, utilizing cost benefit/analysis
to guarantee return on investment (ROI).
 Prepare Test Plans, Test Scripts, Test Cases and manage testing thru Quality Center.
 Gathered requirements for Equities, Asset Management, Risk Management and Fixed
Income
 Involved in creating automated Test Scripts representing various Transactions,
Documenting the Load Testing Process and Methodology. Created meaningful reports for
analysis and integrated the Performance Testing in the SDLC.
 Worked with credit analysis team to identify and document delinquent customer
reporting requirements
 Worked in agile development methodology, carrying on functionality and usability
testing, preparing and evaluating user manuals.
 Analyzed and organized data from systems such as Business Analysis through Excel,
Word and Powerpoint.
 Performed detailed financial analysis including advanced financial modeling, profitability
analysis, return on investment(ROI)/discounted cash flow analysis, monitoring business
issues and impact to bottom line.
 Coordinated the collection of metrics across multiple sources including SQL databases,
manual daily reports, and email driven activities. Wrote SQL and PL/SQL queries to
analyze data.
 Rational ClearCase was used to manage all the changes and change requests in the
projects. Worked with QA team with the aid of ClearQuest for the bug tracking.
 Used SQL queries to test the integrity of data by querying the database
 Creating and executing test Plans, Test cases, Test cycles with in JIRA.
 Provide analytical support for critical corporate initiatives including business function
support for system migrations and consolidations, significant business area process
improvement projects and complex product installations.
 Design migration tools to speed up the systems migration process and prevent manual
operation issues.
 Created packages using Integration Services (SSIS) for data extraction from Flat Files,
Excel
  Handling the projects using Agile Methodology working as a Scrum Master
 Update regarding liquidity and interest rate risk disclosure, familiar with financial
regulations and implications.
 Organized and performed both, the Systems Testing and the UAT

Environment: Windows 2000 Prof/XP, Oracle 8i, MS Access2000, Rational Rose, Requisite
Pro, Jira, Agile, Clear Quest, RUP, MS Visio 2002, SQL, SaaS, UAT, UML, MS Visio

Client: Apollo health care, Nashville , Tennessee April 2017 – Jan 2019
Role: Business Analyst
Responsibilities:

 Conducted weekly meetings for deciding the Policies and Procedures to be followed
while constructing new sites.
 Gathered high-level requirement for all the external projects in a release.
 Performed the requirement analysis, impact analysis and documented the requirements.
 Involved in the full HIPAA compliance lifecycle from GAP analysis, mapping,
implementation, and testing for processing of Medicaid Claims.
 Developing a single application to process data from multiple integration points, convert
the data for reporting purposes and feed data into mainframe system to be compliant to
reporting requirements.
 Performed Analysis on Data mapping between different data models.
 Involved in the full HIPAA compliance lifecycle from GAP analysis, mapping,
implementation, and testing for processing of Medicaid Claims.
 Used different ad-hoc analysis, the Reports assist in defining strategy for each customer
category. Informatics was used for ETL process and Business Objects.
 Created ICD-9-CM/ICD-10-PCS comparison document and dealt with DRGs. shift
through CMS files.
 Documented ICD9 to ICD 10 mappings one to one/one to Many according to the GEM
files from CMS with the functional and structural changes related to the conversion
 Involved in Able to understand and implement Processing ICD-9 ICD-10
 Worked on EDI transactions: X12,835, and 837 P.I to identify key data set elements for
designated record set. Interacted with Claims, Payments and Enrollment hence analyzing
and documenting related business processes
  Executed the test cases and test scenarios using HP Quality center QC .
 As Scrum Master maintained the capacity plan, iteration board, sprint backlog, velocity
charts and burn down charts.
 As Scrum Master facilitated all aspects of the scrum framework, including sprint-
planning sessions, backlog-grooming session, daily scrums product demos, sprint reviews
and sprint retrospectives.
 Prepared Business Requirement Documents BRD's after the collection of Functional
Requirements from System Users that provided appropriate scope of work for technical
team to develop prototype and overall system.
 Facilitated and led JAD sessions aimed at functional requirement walkthroughs for all the
impacting projects and updated the documents based on recommendations if any .
 Created various reports such as billing payment reports, Billing Grouping Payment and
discount reports
 Use HP Quality Center to house all test documentation and report/track all issues and
defects Defect Management .

Environment: Rally, MS Visio, HP QC, UML, MS Office, Agile Scrum, SSRS

Client: Energytech Global, Hyderabad, India Jan 2015 – March 2017

Business Systems Analyst
Responsibilities:
 Actively assisted in the acceptance and validation of the stories by testing the delivered
stories.
 Provided detailed User Interface Document to the development and testing team for clear
understanding of the system.
 Conducted requirement walkthroughs with the development and test teams before the
development and testing phases respectively, to ensure that the requirements are accurately
understood.
 Created and maintained Requirements Traceability Matrix (RTM) to trace technical
requirements to their business requirements and the test case to their functional requirements.
 Worked closely with the QA Team and played a key role bringing in best practices of test-
driven development In an Agile environment.
 Actively participated in the Daily stand up and Weekly status meetings.
 Conducted User Acceptance Testing (UAT) to ensure all the business requirements have
been fulfilled by the application.
 Prepared detailed user manuals and conducted training sessions.
Environment: Agile Methodology, Smart Draw, Microsoft Visio, JIRA, Oracle DB, Java, SQL