Sai Kalyan Alwala
A Professional with 14 years’ experience as a Senior 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.
Knowledge about HIPAA, Medicare and Medicaid (CMS) claims, claims processing, ICD-9/ ICD-10 using DSM-5, 4010 and 5010 standards. Knowledgeable in-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, Pharmacy, Patient Accounting, HIM, Claim Processing functions.
Experienced with Oracle E-Business Suite (Procure to Pay) and Oracle PeopleSoft Financials.
Hands on experience in data warehousing, data analysis, and/or data visualization. Good understanding of Section 508 Compliance testing using standard tools.
Experience working with teams located in different geographies and time-zones
Experience in PeopleSoft HRMS (Core HR, NA Payroll, Security), Financials (Accounts Payable, Receivable), E-Business Suite (Procure to Pay)
Experience with enterprise upgrades to workstation OS, Microsoft Project Server, and Microsoft Exchange.
Software Methodologies/ Models:
Requirement Management Tools:
IBM Rational Requisite Pro, Blueprint
Windows, Linux, UNIX
Database Management Systems:
MS SQL Server, MySQL, MS Access, Oracle
PeopleSoft HCM 8.X, 9.X
C, C++, Java, Unix
Testing Tools and Defect Tracking Tools:
ALM/ HP Quality Center, HP LoadRunner/Performance Center, JIRA
Business Modeling Tools:
MS Visio, Rational Rose
Content Management Tools:
SharePoint, Apache Subversion (SVN), TFS.
MS Office (Excel, Word, PowerPoint), MS Project, Adobe Photoshop
NYS OFFICE OF MENTAL HEALTH 10/19-Present
Business Systems Analyst
New York State OMH supports various applications for Psychiatric facilities and other Mental Health facilities across New York State to support billing of the patients (inpatient and outpatient) across New York state. The COBS, UBS applications support a combined of 2.5 million New Yorkers with their billing requirements.
Currently working on Billing Enhancements project supporting three billing systems COBS, UBS and IBS CASH.
Responsible for creating business requirements document, requirements traceability matrix for various deliverables.
Presented on various topics of best business analysis practices to other BAs on the team.
Created business process flows for COBS (Comprehensive Outpatient Billing System) and UBS (Uniform Billing System).
Reviewed and Analyzed various EDI 835 and 837 remits for defining the as-is and to-be processes.
Defined business rules across multiple systems for streamlining the business processes.
Environment: MS Office Suite, Blues 2006 (QA, Production), Microsoft SharePoint, Balsamiq, Cisco WebEx.
NYC DEPARTMENT OF EDUCATION 07/19-09/19
Lead Systems Analyst
Currently working for NYC DOE as a Lead Systems Analyst. The SESIS (Special Education Students Information
System) serves over 250,000 students who need special education/services in all the five boroughs of the NYC
Metropolitan area which is the largest public-school system in the United States.
Perform Impact Analysis on various tickets along with App Dev Team and testing team to identify downstream impacts.
Lead Elaboration sessions (JAD sessions) for new projects in the field of Encounter Attendance and New account referrals.
Responsible for compliance with State and City Mandates.
Train Junior Business and System Analysts on SDLC methodologies.
Environment: MS Office Suite, HP Quality Center, SESIS environments (testing, staging, QA, production), AQL Server management studio, UX Pin.
NYS Department of Health
08/16 – 05/19
New York State of Health is the official Healthcare Marketplace for State of New York. The Health Benefits exchange (NYSoH) serves millions of people with their Health Insurance on Plan Selection, Provider Selection, Deductibles to be paid etc.
Currently working on the NYSoH application as Business Analyst.
Making sure that the Change Requests are carried right from their initiation to deployment by coordinating with various business stakeholders, vendors by following multiple deadlines and getting concurrences on multiple documents accordingly.
Providing feedback on various specification documents and then sending them for baselining so that the testing team creates test scenarios on the baselined document.
Validated the EDI 834 Reconciliation of various Issuers records and provided detailed documentation of the validated records to the Operations Team.
Worked on three VLP (Verify Lawful Presence) Change requests whose ROM (Rough Order Magnitude) was determined to be more than 5000 hours and made sure that the CRs have been delivered on time.
Created Specification documents for 3 technical Change Requests which increased the efficiency of processing EDI 834s.
Coordinated multiple meetings between Policy, Systems and Vendor teams for agreement on various change request related items.
Provided all the teams with detailed notes of various meetings with Policy and the business.
Microsoft Exchange, IBM Rational Jazz, MS Word, MS Excel, MS PowerPoint, NYSOH EIT environment (testing), Cisco WebEx.
State of Connecticut, Judicial Branch
01/16 – 05/16
Senior Business Analyst
CDCS (Contractor Data Collection System) is a web-based system used statewide approximately by 800 users in 120 sites. The team attempts to release a new version about 4 times annually, this project include Juvenile and Adult Programs, Electronic Referrals, Conversion from SSIS package to WCF Services.
The next project is CCAS (Contract Compliance Auditing System), which is used by CSSD staff in Programs and Services. It records the results of visits and a location’s compliance with contractual requirement. This system requires maintenance such as addition of new programs, locations, address changes, etc.
Created Business Requirements Document for the State’s Inventory Database System.
Performed Regression testing of the CDCS system before the move to production for one of the releases.
Participated in Data Quality Reviews at 5 locations throughout Connecticut to check the authenticity of those programs.
Closely monitored Client Notification messages.
Currently working with CYFSC (Child, Youth and Family Support Center) for tracking various Child/Youth/Family related processes that are sponsored by the State of CT.
Extensively participated in Testing the CMIS application (this system feeds information to CDCS) in various assessments.
Worked on eliminating close to 800 duplicate records in CDCS so that the system performance can be increased.
Microsoft Visual Studio, 2012(Team Foundation Server), CMIS, CDCS, CCAS, MS-Office Suite (Word, Excel, Visio, Project), Balsamiq.
NYS PEOPLESOFT CENTER OF EXCELLENCE
12/13 – 12/15
Senior Business/ Systems Analyst
The aim of the project was to streamline the HR processes of the New York State HR system and this project has an impact on 200,000 NY State employees.
Part of the team that drafted the Statement of Work, Project Kick off Meeting Review Document and preparing the agenda for Fit/Gap Sessions.
Participated in 35 Fit/Gap sessions to understand the State’s requirement for extra customization on the PeopleSoft HR system.
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 for various agencies.
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.
Documented Technical and Functional Specifications for the HCM Project.
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.
Worked on Oracle E-Business Suite (Procure to Pay) when working for New York State Department of Tax and Finance.
PeopleSoft HCM (Core HR, Payroll modules), MS office suite, HP Load Runner, LATS (Leave and Accrual Tracking System), Office 365.
Magellan Health Services
08/13 – 11/13
Senior Business Analyst
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.
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.
Worked on Procure to Pay module to assist in Magellan’s internal project with various Clients.
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.
Oracle E-Business Suite (Procure to Pay), MS Word, MS Excel, SQL Server Management Studio (2008 R2), SharePoint 2010, JOBRUNNER, QC.
05/12 – 07/13
Senior Business Analyst
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.
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.
Rational Unified Process (RUP), UML, SQL server, Blueprint, Cognos, SharePoint 2010, MS Office Tools – MS Word, MS Excel, MS Access, MS Visio, QC.
DISCOVER FINANCIAL SERVICES
10/10 – 04/12
Systems Analyst/ Business Analyst
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.
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.
Agile/Scrum Methodology, TDD, Oracle, Java, Rational Rose, Rational Requisite Pro, MS Office, JIRA.
Business Analyst, Systems Analyst
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.
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.
UML, Agile/SCRUM, HTML, XML, SQL Server 2003, UNIX, IBM Rational Rose, MS office suite and MS Visio, Flat files searching, QC.
National Informatics Center (NIC)
10/06 – 06/08
Business Analyst/System Analyst
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
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.
Wrote 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.
Agile Methodology, Pair Programming, SQL Server, Rational Rose, Cognos, MS Access, MS Word, MS Power Point, HP QC, QTP
Life Insurance Corporation (LIC)
01/05 – 09/06
Business Analyst/ Systems Analyst
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.
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
PHI Masking in Group Insurance Mainframe and crystal reports
Inspro ETL Creation
Agile SDLC, Oracle, Cognos BI, Enterprise View, SQL, IBM Rational Requisite Pro, IBM Rational ClearCase, IBM Rational Clear Quest, MS Access.
Bachelor of Technology
Computer Science and Engineering
Jawaharlal Nehru Technological University