Business Systems Analyst

NIKHIL REDDY VADDI

Lead Systems Analyst / Sr. Systems Analyst/ Sr. Business Analyst/ Business Analyst

Email: ******@*****.*** Ph. #: 717-***-****

Professional Summary:

Nine Plus (9+) years of total IT experience in the Business requirements gathering and analysis, application design, development and testing of software systems in diverse domains such as Financial, Health care, Insurance, Pharmaceutical.

Adept with different SDLC methodologies- Waterfall, Rapid Application Development (RAD), Rational Unified Process (RUP) and Agile (SCRUM).

Good understanding of AS-IS and TO-BE process, and performed GAP analysis by identifying existing technologies and documenting effective solutions.

Expertise in conducting Stakeholder Analysis to get a clear understanding of the process stakeholders, and their roles & responsibilities towards the project.

Proactive in collaborating with external customers, and internal application engineers to analyze system needs, and deliver artifacts such as Requirements Specs, Progress Reports and Training Manuals.

Highly skilled in writing Business Requirements Documents (BRD’s), Functional Requirements Documents (FRD’s), Request for Proposals (RFP’s), Statement of Work (SOW).

Excellent in facilitating Joint Application Development (JAD) sessions, and interviewing Subject Matter Experts (SMEs) for eliciting functional requirements that support high-level business needs.

Well-versed with different requirement elicitation techniques - Document analysis, Interface analysis, Prototyping, Reverse Engineering, Survey, Interview, Brainstorming, Requirements Workshop.

Competent in creating User Stories, Use Cases, Activity flow diagrams, and data flow diagrams using UML Tools - MS Visio, Enterprise Architect, Rational Rose.

Adept at developing prototypes like wireframes, screen mockups, navigation flows.

Expertise in creating Requirements Traceability Matrix (RTM) to control numerous project artifacts.

Proficient in executing SQL queries against databases to check for ER relations with the requirements.

Experience with Business Intelligence tool (COGNOS), SQL Server Management Reporting Tool.

Extensive knowledge in Data Warehousing and Data mart concepts as well as in designing data marts (including Fact, Aggregated Fact and Dimensional tables).

Analyzed Data Migration across different systems

Good knowledge of XML for analysis, review, and approval of proposed XML resources.

Adept in working with Senior Management and Project Managers, in maintaining the architecture (solution design), Cost benefit analysis, and scope and change control.

Experience with compliance standards and regulatory requirements.

Knowledge of SWOT analysis, impact analysis, risk analysis and ROI analysis.

Proficient in conducting User Acceptance testing extensively at both company and clients premises.

Expertise in assisting testing teams with test plans, test cases, test scenarios, formulating test approaches with load testing, integration testing, regression testing, and manage defects using various defect tracking Systems.

Highly skilled in multitasking, fast-paced work schedules with strong project management orientation.

Good understanding of change management and release management.

Proactive in coordinating with Distributed Teams for onsite- offshore model, and communicate effectively with Business partners, management, IT organization and the client community.

Outstanding written and verbal skills with explicit attention to detail during requirements elicitation.

Excellent leadership, Interpersonal, and analytical skills, with ability to handle challenges with ease.

TECHNICAL SKILLS:

Methodologies

RUP, Agile, Waterfall, RAD, V-Model, Business Process Re-engineering

Databases

Oracle, MS Access, DB2, MySQL, MS SQL

Documenting and Modeling Tools

TOAD, Rational Rose, MS Visio, MS Project S Office (Word/Excel/Access/ Power Point), MS SharePoint, MS Outlook, Magic Draw

Languages

C, C++, C#, Java, .NET, SQL, HTML, XML

Testing Tools

Rational Test Suite, Quality Center, BUGZILLA, JIRA, Load Runner

Rational Tools

IBM Rational Software Architect 8.0.3, Requisite Pro.7.1.3.03 Clear case, Clear Quest, Rose

TECHNICAL SKILLS:

Microsoft Tools

MS Office Suite 2007-2010, MS Project 2007-2010, MS Visio 2007-2010, MS SharePoint 2007-2010

Requirement Management Tool

ALM(Application Lifecycle Management)

Operating Systems

Windows 2000/2003/NT/XP/7

Business Intelligence and Reporting

Crystal Reports, COCNOGS 8/7.3

Data warehousing Tools

Informatica 8.6

EDUCATION:

Master of Science in Information Systems

PROFESSIONAL EXPERIENCE

Sun Life Financial, Wellesley Hills, MA JAN’14–PRESENT

Lead Business Systems Analyst

Working as Lead Business Systems Analyst across multiple projects

Project#1: Benefit Profile Tool

The Project mainly focused on building an application for the sales and marketing team to generate BPT reports and also view the reports that were generated. The Benefit Profile is a tool that benchmarks relevant marketplace data, and helps paint a picture of facts and recommendations for clients industry. It was created to help brokers and clients understand what benefit packages are common in the industry, and helps to make recommendations that will best fit the client’s needs. BPT reports can be generated for single Census, Two Census and Industry level data (50+ Lives and Under 50 Lives) using BPT application.

Project#2: Customer Event Lake

The goal of the project is create an application that will enable Client Relationship Executives (CRE’s) and Client Advocates (CA’s) to have ready access to answer customer inquiries. Currently tracking down some answers is very cumbersome, and requires making multiple calls or sending emails to several different departments, which use different systems to house status, policy and customer information. The project employed 'Big Data' methodology to pull information across traditional databases, as well as log files, email repositories, other non-traditional sources and provide a single, consolidated location for business data – the “Data Lake” - which is sourced and refreshed at regular intervals.

Project#3: National Accounts Employer Reporting & Analytics

The purpose of the project is to build an application which will help users to generate the reports automatically. Reports are produced manually by the Underwriters, Claims and CRE teams which are very time consuming. Current SLF reports have data integrity concerns, and report formats are inflexible. Automating and generally improving the creation of customer reports will align SLF with industry standards. This will create analytic capabilities and enhance efficiency to support account management, underwriting, claims, and sales SLF prospective and in-force customers expect SLF to have certain reporting and analytic capabilities. These capabilities are compulsory for SLF to continue to remain competitive in the marketplace, and to continue to grow the National Accounts business.

Project#4: EOI Single-Sign On

The idea of this project is to create the ability to allow third party enrollment platforms connect with our current online Evidence of Insurability (EOI) submission process in order to make doing business with SLF easier for our clients and to capture more accurate member data at an earlier stage. This connection is dependent upon the successfully implementation of a secure single sign on (SSO) connection between our Customers’ enrollment platforms and our (SLF’s) Plan Members website (where online EOIs are submitted).

Responsibilities:

Effectively lead a team of Systems Analyst’s, managed and distributed the work to the team members accordingly.

Scheduled and facilitated JAD sessions for gathering requirements from various stakeholders like EBI’s, EBR’s, VPL’s (Sales and Marketing Team), Underwriters, and CRE’s and performed Gap Analysis by looking the current state and future state.

Worked with Project Manager in defining, refining project objective, scope, risk and assumptions. Followed Agile Methodology.

Created Inception Document which clearly describes the project background, Goals, Constraints, Assumptions, current process and the scope of work.

Worked with business and technical team to document end to end business process flow diagram.

Assisted in creating and reviewing the Requirement Level Estimate (RLE), Business System Analyst Schedule, Systems Analyst task summary.

Gathered and documented UX\UI (visual) requirements (using Microsoft excel and power point), Functional and Non Functional requirements in Business Technical Requirement Document and use case (using Microsoft word and requisite pro) and prepared requirement traceability matrix(RTM).

Created Report Specification Document which captures High level reporting requirements, Report Parameters, wireframes, data extraction rules etc. for BOXI and SSRS Reports.

Executed simple and complex SQL queries on SQL Server/Oracle database to generate BI reports and review expected results.

Worked in eliciting the requirements for migration of the data from existing life claims systems to new system for better reporting capabilities.

Guided and helped systems analyst to document use case, helped in documenting what steps are involved (main steps, alternative steps and exceptional steps).

Created multiple BAU Business process flows which helped in identifying multiple source systems and data points which made Hadoop and Big Data Developers load appropriate Data to the Data Lake.

Constructed Use Case Models and Use Case Diagram using Magic Draw.

Prepared data dictionary stating what data elements are involved, what is the business definition, format and possible values for all data elements involved with in various systems and documented data mapping documents for various systems.

Maintained Action Items list by assigning an owner, priority, due date and reviewed with business team, systems analyst, developers and test team on weekly basis to resolve any outstanding items that are open.

Documented and gathered roles based access rules, security rules.

Conducted walkthrough sessions with business, UX\UI designers, developers and test team.

Participated in User Acceptance Testing (UAT) and created training materials to facilitate the training of applications for different users.

Environment: Microsoft Office Suite (Outlook, Access, Excel, Word), Windows 7, Lotus Notes, SnagIt, Magic Draw, Cold Fusion, Java, Hadoop, JIRA, ALM

WellPoint, Wallingford, CT JAN’13–DEC’13

Sr. Systems Analyst

Focused on building a new Utilization Management (UM) platform called as Anthem Care Management Platform (ACMP). This is an initiative that is being developed by WellPoint to improve the structure and processes of Care Management and Disease Management which will enable WellPoint to catch and leapfrog the competitors and create a clinically integrated platform and consumer experience.

Responsibilities:

Organized Knowledge transfer meetings with the Delivery lead and the Project Manager to understand current state and scope of the Ongoing Project.

Worked closely with Business Champion, SMEs, and Stakeholders to identify the Business Requirements.

Conducted and facilitated various Joint Application Development (JAD) sessions for multiple iterations with business (Intakes, Clinicians, Physicians, External Customers, Designers and Developers) to gather requirements and perform GAP analysis.

Prepared and distributed meeting minutes, questionnaire and agenda for various meetings with business, managers, technical team.

Worked with business to document end to end business process flow. Using MS Visio.

Gathered and documented UX\UI (visual) requirements, integration requirements for web services, Functional and Non Functional requirements and Use Cases.

Loaded the Requirements in Requisite Pro, Traced back the requirements to the high level features capture by Business team and prepared Requirement Traceability Matrix (RTM).

Gathered detailed requirements stating what steps, and data would Intake, Clinician (nurse), Non Clinical Staff (NCS), Physician and WATSON would need in order to perform utilization management on submitted requests by Provider.

Prepared Use Case Models and Use Case Diagram using Rational Software Architect (RSA) describing how various systems and actors will interact will each other and what different use cases are involved to accomplish goals.

Worked with business and IT to prepare and document routing and integration rules between different systems.

Documented and gathered business and technical requirements for Queue Assignments and Queue Re-Assignments.

Prepared Data Dictionary stating what data elements are involved, what is the business definition, format and possible values for all data elements involved with in various systems and documented data mapping documents for various systems.

Prepared Security Grid by gathering roles based access rules, security rules.

Conducted walkthrough sessions with business, UX\UI designers, and developers and testing team.

Worked with business team, systems analyst’s, developers and testing team to resolve any follow up’s and action items.

Followed the formal change control process.

Assisted Training people by participating in the Training sessions that were organized by Learning Experience group.

Environment: XP\2000, Microsoft Office Suite (Outlook, Access, Excel, Word), Lotus Notes, SnagIt, IBM Rational Software Architect 8.0.3, Requisite Pro.7.1.3.03

PRUDENTIAL FINANCIAL, SHELTON, CT SEP’ 11 – DEC’ 12

Sr. Business Analyst

Senior Business Analyst for the “Pru Inside” project-It is a $60M new product line developed by Prudential to have an advantage over its competitors in the annuities marketplace. This project was initiated to launch a new business line which requires a new policy administration system implementation. This product includes a standard offering with additional options available to an external Partner to combine a retirement income guarantee with an external Partner’s Managed Account program

Responsibilities:

Worked closely with SMEs, and identified, analyzed the core Business requirements of the ongoing project.

Facilitated interviews, Business Meetings and workshops with users to gather requirements.

Extracted, discussed, and refined business requirements from business users and created Business Requirement Document’s (BRD’s).

Converted Business Requirements Documents into Functional Specifications Documents (FSD) and Software Requirement Document (SRD) and maintained Requirements Traceability Matrix (RTM).

Participated in creating User manuals. Documented all user and system requirements along with the work flow process.

Successfully used waterfall Analysis Model for gathering requirements.

Lead status meetings with team members to discuss problem identification, prioritization and resolution, scope creep.

Worked extensively on Context Diagrams and Information Flow Diagram using UML.

Conducted JAD sessions to allow different stakeholders to communicate their perspectives, resolve issues, and reach agreements.

Responsible for driving business requirements definition and scope as it relates to the definition of deliverables with in the Business Intelligence environment.

Gathered Data requirements for delivering reports, dashboards and ad-hoc capabilities using COGNOS.

Created Report mock-ups using MS-Excel.

Part of Project Management team responsible for adopting standards for change control and version management of documents. Drafted and analyzed project Deliverables, and created Checklists for Checkpoints in the project.

Worked with Solution Engineers and Project IT Leads in preparing the Requirements Level Estimates (RLE).

Created Data requirement Document (DRD) which served as Data dictionary for all the Business approved definitions.

Worked with the Stewardship team to get the Data Element approval.

Used ALM (Application Lifecycle Management) for documenting and tracking the requirements captured in the Business Requirement Document’s across different projects.

Developed Requirements Traceability Matrix for maintaining system requirements using MS Excel.

Interacted with Production and Design teams for change requests and problem report documentation.

Performed Knowledge Transfer of the elicited requirements to the DB Architect for Database Design.

Assisted the Database team in Data Migration, from MS Excel to SQL Server Reporting Service, using SQL Loader for the future system.

Retrieved data from database for Data Validation and Data Integrity tests using SQL queries.

Analyzed User requirements in Stakeholder meetings to document changes, and implemented procedures to test changes using Rational Clear Quest.

Assisted the Testing team in creating Test Plans, Test Scenarios, Test Cases and collect Test Data for successful completion of Integration Testing and Functional Testing.

Environment: COGNOS, Oracle 11g/10g, ALM, ODS( Operational Data Source), UML with Rational Rose, MS Access, MS Project, MS-Visio, MS-Outlook, Oracle, SQL, SQL Server 2008/2005 Maestro, 2003, Erwin, UNIX, Informatica 8.6

INDEPENDENT HEALTH ASSOCIATION, BUFFALO, NY MAY’ 10 – AUG’11

Sr. Business Analyst

Independent Health has become one of the major forces in the provision of employee health care benefits in the northeast, operating health plans in the eight counties of Western New York with offices in Buffalo and Jamestown. Worked on Health Care Claims processing and Health Vision load program for EMPI.

Responsibilities:

Understand the overall functional architecture & Coordinated with Business group to gather functional & business requirements for the Data warehouse & Business Intelligence Initiatives.

Conducted JAD and interview sessions with the client to determine user requirements and goals

Extensive interaction / meetings with Stakeholders.

Assisted Project Manager and User managers to conduct Market Research and Feasibility Studies, and to develop Scope/Vision Documents, developing project plans, tracking progress and analyzing workloads using M.S. Project.

Facilitated collection of Functional Requirements Specification (FRS) from system users and prepared of Business Requirement Documents (BRD) by using Rational Requisite Pro along with applied MS-Visio for creating Use Case Models and Use Case Specification documents.

Created Mockups in MS Access, and Burn-down Charts to track the project progress.

Worked on data management, data lifecycle management and the integration of applications.

Conducted Root Cause Analysis on existing data, and assisted the DB team in Data Transformation.

Developed Use Case diagrams, Activity diagrams, and Sequence diagrams using MS Visio.

Performed the role of a Scrum Master in delegating working with the scrum team.

Facilitated Sprint Planning meetings, and authored user stories and epics.

Executed SQL queries to retrieve data and test the application against the requirements.

Outlined processes, with the Development team, to map data from Flat files to Database tables.

Performed Build Acceptance Testing to check integrity of the system delivered by the Developers.

Conducted walkthroughs on functional requirements for the system with System Testers.

Used JIRA as the defect tracking tool while performing UAT (Alpha) with the business users.

Assisted in defining and reviewing the Non-Functional requirements for designing the GUI including security, integration, performance, and quality requirements.

Worked with Development and QA teams to ensure successful delivery and implementation of new platforms, and driving overall process improvement for new strategic initiatives.

Provided knowledge transfer to Testing teams to work on Test Plans, Test Cases and Test Scenarios.

Environment: RUP, UML with Rational Rose, Rational Requisite Pro, MS Access, MS Project, MS-Visio, MS-Outlook, SQL, Erwin, Oracle 11g/10g, SQL Server 2008/2005 Maestro, 2003,UNIX.

MASSMUTUAL, SPRINGFIELD, MA MAY’ 09 – APR’ 10

Sr. Business Analyst

MassMutual provides investment services to individuals and corporate clients. The investment type could be Mutual Funds, Brokerage, CRIA (Corporate registered investment advisor) across a range of products using FIX protocol. The software developed had to be integrated within the MassMutual framework. Additionally a credit card authorization application using XiPay was designed. This product is similar to Fiserv's CheckFree Investment Management Software.

Responsibilities:

Determined user/business/functional requirements. Created vision, scope and use case documents; business process models, use case diagrams, activity diagrams and state chart diagrams.

Facilitated changes to the SharePoint governance policies, procedures and processes.

Performed business process analysis and created business process diagrams using the industry standard BPMN modeling tools like VISIO.

Performed GAP and Risk analysis of existing system and evaluated benefits of new system.

Conducted Joint Application Development (JAD) sessions with stakeholders throughout SDLC to resolve open issues and created minutes of meting for the sessions conducted.

Responsible for managing and translating business requirements and information architecture requirements into functional specifications for the SharePoint development team.

Collected, documented the BRD and FRD managed the documents using Caliber RM for multiple projects

Used MS SharePoint as a data repository for Document and Content Management

Coordinated work plans between project manager and client using MS Project.

Analyzed and assessed the clients systems and business processes using business process diagrams.

Expertise in leveraging wireframes or prototypes during the requirements process.

Designed and developed Use Cases, Activity Diagrams and Sequence Diagrams and Change Management documents.

Used SQL to query the database for performing data analysis and data modeling using Erwin.

Adept at mentoring the business stakeholders and technical team on the system functionalities.

Wrote SQL queries to extract data from the tables and for validation of data.

Worked with ETL teams in defining the data transformation required for the migration.

Assisted in building a business analysis process model using Rational Rose and Visio.

Performed requirement analysis, developed all the use cases and workflows.

Worked with QA team to design test plan and test cases for User Acceptance Testing (UAT).

Assist the technical team in understanding and developing the appropriate functionality.

Environment: Windows, UNIX, Rational Rose, SQL, Rational Clear Quest, MS Access, MS Project, MS-Visio, MS-Outlook, Oracle, SQL, Oracle 11g/10g, SQL Server 2008/2005 Maestro, Reflection FTP, Visio 2003, Erwin.

CITI GROUP, WARREN, NJ JAN’07 – APR’09

Business Analyst

Citibank issues credit cards, secured cards, several kinds of loans, consumer charge cards. The company mainly markets its cards via direct mail, the Internet, and television. The project was implemented as a Data Warehousing and BI initiative to process data for Customer Information, Credit Cards and the analyzed data was used for marketing, Credit Cards Processing, Billing, Payment, etc.,

Responsibilities:

Responsible for Business Analysis and System Analysis. Gathered user/business requirements by Interviewing the end users and business representatives and conducting JAD sessions.

Analyzed business requirements and created Functional Specifications for Member, Provider, Enrollment, Eligibility and Benefits Services/ Applications.

Assisted Project Manager to create Project Charter, Scope and planning.

Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly.

Created Business Rules Documents for interfaces developed by EDI development team.

Created Non-Functional Requirement documents to capture SLA’s (Service Level Agreement), traceability, monitoring and alerting functionalities.

Prepared Requirement Traceability Matrix to keep track of requirements against the services being developed.

Interacted with business users to capture reporting requirements and provided them to development team.

Created Data Mapping Documents between different databases and Flat files (fixed length and Comma separated).

Provided weekly and monthly status report to the management and recommended process improvement.

Responsible for processing of Project Documents, Project Plans, Team Member Co-ordination, Scheduling Meetings, Task Assignment, Monitoring efforts on Timely basis, daily and weekly status report creation, Quality checks, diagnosis and issue resolution, Project tracking, Project documentation.

Worked as liaison between Development and Quality Assurance.

Developed the Test plans for quality assurance based on functional requirements.

Made Changes in requirements document and kept version control in SharePoint so that all team leaders and other responsible associates can stay tuned to latest information or artifacts.

Reviewed Test cases to ensure all the functional scenarios are captured.

Environment: Oracle 10g/9i, Sybase, SQL,UML, Rational Suite: RUP, Microsoft Suite (Access, Excel, Word, PowerPoint, Visio, MS Project) Windows 2003 & XP, SharePoint, Maestro, SQL server 2005/2000,Toad, Erwin 7.2/4.5, SQL, Unix Shell Scripting, Designer, Windows XP 2003.

BMS, PRINCETON, NJ AUG ’05 – DEC’06

Business Analyst

The main purpose of the project was to build a Data mart on Sales and Marketing Department. This Data mart which is a part of Sales & Marketing DW would help the Sales Managers and Key Business Decision Makers at BMS to made decisions to improve marketing, sales, and promotional effectiveness by making it faster and easier to analyze multisource data and to quickly uncover hidden opportunities and risks in the market.

Responsibilities:

Analyzed operating procedures and policies on an ongoing basis, recommend and implement improvement plans where appropriate.

Responsible for planning for working sessions with client stakeholders, developing questionnaires or sample requirements to help with requirements brainstorming, lead some facilitated sessions, take thorough notes.

Utilized Agile Process to configure and develop process, standards, and procedures.

Facilitated JAD sessions in defining, documenting the business needs and Business Process Flows.

Worked with SME’s, Business users, Architects, Data Modelers, and ETL developers to translate requirements into technical specifications and executed SQL queries to validate the correctness and completeness of the ETL processes to resolve data integrity issues.

Performed Requirement Analysis by gathering both functional and non-functional requirements based on interaction with the process owners and stakeholders.

Analyzed requirements to identify ambiguous, incomplete and incorrect requirements and prepared Requirement specifications.

Performed Backend testing by writing manual SQL queries.

Responsible for documenting business processes for ‘AS-IS’ and ‘TO-BE’ scenarios and perform GAP analysis

Modeled ‘TO-BE’ Scenarios by creating UML Activity Diagrams in MS Visio.

Worked on Wire frames to create the design of the Web-based E-portal application.

Created, modified, linked and maintained requirements traceability using Requisite Pro.

Conducted walkthroughs with Development Team, Solutions Architect and Stakeholders.

Authored progress and completion reports, which were then submitted to project management on a weekly basis.

Involved in writing and executing simple SQL queries against the database to check for the ER relations with the requirements document.

Executed UAT test cases and reported defects and bugs to development team using Quality Center.

Offered inputs to establish formal Change Control Process.

Assisted in designing tests plans, test scenarios and test case for integration, regression and user acceptance testing (UAT) to improve overall quality of the application.

Environment: Oracle 8i/9i, Sybase, SQL, UML, Rational Suite: RUP, Microsoft Suite (Access, Excel, Word, PowerPoint, Visio, And MS Project) Windows 2003 & XP, Erwin 4.0.

*** References provided upon request***

Contact this candidate