Professional Summary Active Member of IIBA.org

Nikhil is a Senior Business System Analyst with more than 9 years’ experience in domains such as Healthcare/Insurance, Retail, E-commerce and Investment Banking. Proficient in Business Process Engineering and SDLC Software Development Life Cycle methodologies such as Waterfall, RUP and Agile including analysis, design, development and testing of software. Understanding of ITIL (Information Technology Infrastructure Library), SDLC (Software Delivery Lifecycle), and project management fundamentals.

Strong ability to bridge gap between Business and Technology by working with the project Delivery Teams, Business Stakeholders, End Users, IT Architect and Developers to document the product’s Vision, Scope, Business System Requirements and Technical Specifications.

Experienced in Agile using Rational Team Concert to document stories and executed Sprints.

Expertise creating Use Cases, Functional Specifications and Activity Diagrams. Interviewed SMEs and Stakeholders to get a better understanding of client business processes and gather business requirement. Worked with key stakeholders develops data visualization reports and dashboards to provide information that facilitates decision making. Blend business and technical experience to interpret and deliver on reporting needs.

Conducted peer reviews about the Product Backlog, Sprint Backlog. Clear understanding and innovative in designing the Burndown Charts. Prepared and maintain Requirement Traceability Matrix (RTM) throughout the project lifecycle.

Experience in conducting/participating in JAD sessions for project definition involving analysing requirements, Creating Prototypes, User Interface. Proven skill of Business Intelligence (COGNOS, Share Point) and data visualization tools (Excel).

Expert in conducting GAP Analysis

oPerformed GAP analysis of Business rules and Requirements to identify and validate requirements.

User Acceptance Testing (UAT)

oFacilitated UAT sessions with the defined Acceptance Criteria and with references for users by writing and maintaining user documentation and other trainings needed.

SWOT Analysis

oConducted SWOT analysis to realize and identify project objectives.

Cost Benefit Analysis and ROI Analysis

oAssisted in Cost Benefit Analysis and Return on Investments Analysis.

Good understanding of Business process flow modelling using UML tools, Use case modelling and Entity Relationship Modelling. Advanced knowledge of Toad, PowerPivot, MSBI (SSRS, SSIS, SSAS), and other data extraction, mining, visualization and reporting tools such as Crystal reports, Cognos, Informatica and Business Objects.

DB skills include SQL, PL/SQL and SQL tools (SQL Developer, TOAD, etc.) with a working knowledge of relational databases and structure.

Worked with User Experience (UX) and User Interface (UI) teams while driving the Functional requirements and Wireframes. Experience in writing Use Cases, Test Cases Test scripts, RACI matrix, Test Cases and Test Execution strategies.

Experience on healthcare Insurance payer systems (ikaSystems, Xcelys, DIAMOND 950, Peradigm, AMISYS, xpress, etc.). Solid Knowledge of Medicare, Medicaid & Private Insurances; Expertise in Provider & Payer Claims Processing Systems; High-level knowledge of both ICD 9 & ICD 10; End to end project implementation from Initiation, Planning, Execution, Control and Project Closure; Ability to plan and implement information technology strategies/roadmap and build teams for large-scale technology implementations.

Adept knowledge in RDBMS such as Oracle, MS SQL Server, and MS Access and also SQL queries and Stored Procedures. Knowledge of Healthcare Management operations; experienced with technology related to utilization management, provider network and contracting, pricing, medical policy, quality and other care management domains.

Good exposure on Comprehensive Capital Analysis and Review (CCAR) and other regulatory framework introduced by the Federal Reserve in order to assess, regulate, and supervise large banks and financial institutions - collectively referred to in the framework as Bank Holding Companies (BHCs).

Excellent Interpersonal Skills, Effective Writing & Oral Communication and Presentation skills.

Developed reports to communicate schedules, issues, risks and project changes to project stakeholders and project managers.

Provided the necessary documentation in a project such as: statement of work (SOW), business requirements, use cases, functional specifications, data requirements and documentation for business training materials.

Coordinated and delivered project to work with various stakeholders worldwide to gather information relevant for the Volcker metrics reporting requirements, RENTD and other analytics to support Market Making Activities.

Have strong knowledge of Fixed Income & Equity and has been a significant party in multiple successful enterprise project deliveries. Good experience with Microsoft Excel, PowerPoint, Projects, Access and SQL.

Knowledge of Investment Banking systems and processes – sub-ledger, ledger, regulatory reporting and reconciliation systems

Skills Summary:

Domain

Healthcare/Insurance, Retail, E-commerce and Investment

Methodologies

Agile, Agile/Scrum, Waterfall

Testing Tool

HP Quality Center/ ALM, Jira, Clear Quest, BugZilla, Rally

Requirement management tools

Blueprints, Rational Requisite Pro, DOORS

Business Modelling tools

MS Visio, Enterprise Architecture, iRise, Balsamiq, Pencil, Rational Rose

Document Creation/Management

MS Office - Word, Excel (PowerPivot), Outlook, PowerPoint, MS Project

CRM

Salesforce, PeopleSoft, MS Dynamics CRM

Content management

MS – Share Point

BI/ Reporting tools

Crystal reports, Cognos, Informatica, Business Objects, MSBI (SSRS, SSIS, SSAS)

Database

Oracle, MySQL, SQL

Language

HTML, XML, Java, SQL

Operating System

Windows, Unix

BA Deliverables

Created/ revised/ executed the following:

Business Analysis Planning, Process Maps, Business Process Models, Requirements Specifications, Use Case Scenarios, User Acceptance Testing, Data Flow Diagrams, Data Dictionaries, Data Modeling or Data Use Cases and Data Analysis.

Education:

Bachelors in Computer Science.

Experience:

Client: PHH, Mount Laurel, NJ March 2015 – Till Date

Role: Senior Business Analyst

Project: eSign and eDelivery, Error Handling

Project Description:

PHH needs to eliminate its current document management system being used for various Borrowers across the United States. The Borrower uploads the documents on the PHH side and they are further imaged and archived in their current system. For Lead/Loan purposes via the Loan Operating System (LOS), the documents need to be generated, imaged and then, archived for further transactions. Various Guidelines set by DODDFRANK Act were implemented to cover for any financial risks. In the new system, a new Vendor application will be integrated into the current system for the above mentioned purposes. Also, worked on the process to handle errors pertaining to the vendor integration or on the vendor’s side. Errors at PHH’s side were already a part of the existing system.

Roles & Responsibilities:

Working with a team of 11 other BAs to integrate various modules into one single system. Gather requirements around the existing system for the development team to work on the technical changes required.

Created Project plan for the identified work stream, covering both business change and IT scope.

Monitored progress of project status, milestones, achievements and budgetary standing for the project; ensure resolution and/or effective escalation of issues within Steering Committees.

Managed priorities and issues across teams, mediating and resolving conflicts to develop strong cross team cooperation.

Documented each type of data system with use cases so that key business processes and supported performance measures can be established. Developed specifications for dashboards and reports as defined by the business sponsors. Developed data requirements and Data Dictionaries.

Worked closely with Data Base Reporting to identify data sharing and data delivery methods and tools. Worked closely with the Business Users in identifying business rules to aid in the functional specifications of tasks.

Worked closely with the teams in property and casualty insurance.

Closely work with the vendor to gather requirements (errors, emails, imaging, archiving) on the vendor’s side.

Work with various departments – Legal, Audit, Compliance, Sales, Clients to understand the Business side of the requirements.

Worked with Helpdesk team to define business challenges (e.g. Concerns with the existing systems).

Responsible for preparing Business Requirement Document (BRD) and then translating into functional specifications and test plans.

Organized daily SCRUM meetings and distributed daily tasks to address issues raised in these meetings

Performed analysis on existing systems, recommended enhancements, and implemented strategies to streamline current processes

Performed systems analysis to determine feasibility; develop software code to test newly developed features

Assisted in setting realistic project expectations and in evaluating the impact of changes on the project plans accordingly and conducted project related presentations.

Involved in Testing by using SQL and work with QA together to develop test Scenarios and test cases

Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio

Environment: SCRUM Agile, MS Dynamics CRM, Windows 7, Microsoft Visio, Caliber RM, LoanSpan, CA$H.

Client: Health Spring, Nashville, TN Aug’14 – Feb’15

Role: Business System Analyst

Project: COMPASS project

Description Based in Nashville, Tennessee, Health Spring got its start in 2000 and is now one of the country’s largest and fastest-growing coordinated care plans whose primary focus is Medicare Advantage plans. Health Spring currently owns and operates Medicare Advantage plans in Alabama, Delaware, Florida, Georgia, Illinois, Maryland, Mississippi, New Jersey, Pennsylvania, Tennessee, Texas, and Washington, D.C., as well as a national stand-alone prescription drug plan.

Health Spring has initiated a project called COMPASS. Within the COMPASS project, they wanted to migrate data in existing legacy system to FACETS.

Responsibilities:

Worked on Member Management, Eligibility, Claims, and Provider modules within FACETS. Conducted extensive analysis on migration and conversion of Provider and Member data, Group configurations, premium billing, benefit set-ups, fee schedules, provider pricing, capitation set-ups, etc from Legacy system to FACETS. Clarified QA team issues and reviewed test plans and test scripts developed by development team and QA team to make sure all requirements have been covered in scripts and tested properly.

Used MS SQL Manager Studio 2008 to query the MS SQL database.

Involved in documenting the business process by identifying the requirements and also involved in finding the system requirements. Worked in creating interfaces for various external vendors. Created Technical Specifications for the 835 and 837 I and P files with their changed and new contents to create 5010 complaint files. Performed User Acceptance Test (UAT) for 5010 and ICD 10 codes.

Facilitated Joint Application Development (JAD) sessions with all IT group members for communicating & managing expectations and to discuss various means for integrations with current system using an adoption through execution strategy. Performed the analysis of the earlier systems, generated a detailed requirements document describing new system architecture through use cases diagrams and activity diagrams using MS Visio. Identified and documented the requirements for 5010 conversions.

Collected the information related to ongoing application upgrade and their impact on ICD-10 implementation and impact, benefits and risks of ICD-10 code application. Re-Organized the collected data and prepared documentation for implementation.

Facilitated data mapping activities and helped with the expansion of membership and provider data model.

Created workflow diagrams, process flow and data flow diagrams. Assisted team with Data Mapping and Data Extracting Strategies for data migration. Involved in creating use case diagrams for the purpose of the team to understand the workflow of the system. Experience in Provider Contracting and Credentialing.

Analyzing the business needs for the reports and documenting the requirements in SSRS forms.

Facilitated JAD sessions and captured meeting minutes. Analyzed EDI ANSI X12 file mapping and reported in analysis spreadsheet. Performed validation of 837 (P, I) & 835 format files

Effectively communicated user acceptance test results between users and development team and provided recommendations for change control requests (CCR).

Environment: Facets 4.8, MS Visio, Word Excel, PowerPoint, Rational Rose, Requisite Pro, SQL.

Client: Heartland industrial partners, Stamford CT Aug’13 – July’14

Role: Sr. Business Analyst (Private Equity)

Project: Enhance the Existing Business Application Software to Issue Federal and State K1’s

Heartland Industrial Partners specializes in acquiring buyout, venture capital, special situations, mezzanine and fund-of-funds limited partnership interests in the secondary market. This project involved enhancement of the existing business software application based on the new regulation, which will help ease in issuing partner K1’s by incorporating the book tax difference work paper to calculate the taxable income and identify the M1, M2 and M3 for tax and book purpose. During the project US GAPP principles, IRS regulations, Federal and State compliance was followed and maintained.

Responsibilities:

Gathered detailed business and technical requirements and participated in the definitions/Understanding of Business rules and data standards.

Liaison with business sponsors to understand business functioning and detailed processes, gather requirements and deliver appropriate solutions.

Discussed operational scenarios, identify issues and errors and resolve them. Review all the work products being delivered to the end user.

Leveraged strong relationships with both the business and technology teams to collect high quality requirements resulting in successful end products.

Completed all deliverables and project tasks in a timely manner with a high degree of quality by successfully multi-tasking and by prioritizing tasks appropriately.

Demonstrated users as how to create business workflows.

Interfaced with team leaders, identify and analyze the given information, procedures and decision flows, evaluated existing procedures, methods and technical documentation. Communicated with executives, managers and other stakeholders regarding project scope.

Used MS-Visio for flow-charting, Use- Case process model and architectural design of the application.

Responsible for business process analysis that includes requirements facilitation, definition & analysis, alternatives, software selection, prototyping, business process design and mapping.

Conducted meetings and JAD sessions for project definition, resource identifications and deliverable prototype identification.

Developed Functional Requirement Document and Use Case Specification document.

Coordinated with developers to ensure understanding of the user requirements.

Conducted structured walkthroughs with developers and subject matter experts to validate the requirements.

Interacted with the technical team in resolving the bugs and other technical issues.

Designed and developed use cases, and sequence diagrams using UML.

Performed Gap Analysis of the processes to identify and validate requirements.

Document all outcomes including minutes, action items, and next steps; track and resolve all action items in support of the sessions.

Coordinated with the testing team to formulate manual test cases.

Environment: Windows XP, HTML, MS Visio, MS Office 2007, MS Project, Share point, Java, Scrum/Agile.

Client: JPMC, NY Aug’12 – July’ 13

Role: Business System Analyst (Mortgage Industry)

Project: Regulatory Consent Order

JPMorgan Chase & Co. is a leading global financial services firm and one of the largest banking institutions in the United States with operations worldwide. JPMorgan and firms purchased, Bear Stearns and Washington Mutual, sold risky mortgage securities during the housing bubble while misrepresenting their quality. These securities later failed in huge numbers, playing a key role in the 2008 crisis. JPMC project involved an AS-IS study of their home loan mortgage software systems in order for us to identify the validation checks for the entire loan processing system. The observation forms the AS-IS study became an input for enhancements in existing home loan software systems with validation checks which complied with the regulatory order, federal and state compliance.

Responsibilities:

Analysed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).

Employed SDLC for the purpose of monitoring the project and also followed the step-by-step procedure.

Study the current state of the processes. Prepare the AS-IS process map and the TO-BE scenario.

Authored functional requirements and conduced User Interviews to identify and document the data discrepancies.

Prepared Requirement Traceability Matrix in order to map the requirements effectively with the factors.

Also implemented Change Management techniques for successfully monitoring and fine-tuning the project changes to obtain the desired production results and to meet Client deadlines.

Developed mapping of various physical to business layer objects within.

Created reporting wireframes and layouts after talking with Business users.

Documented the current process and business opportunity by interviewing stakeholders and end users to elicit better understanding of the business need.

Conducted JAD Sessions for requirements capturing.

Prepared Business Requirements document for the Reporting application based on the requirements gathered.

Created traceability of elements in various insurances within data warehouse to data mart.

Worked on personalization of the Wireframe screens using Balsamiq tool for a user based on this profile.

Work with the development, User Interface (UI), testing and other work streams to ensure effective communication of requirements. Also, serve as liaison for all other phases of the project and ensure that project deliverables meet the business requirements and expectations.

Identified testing scenarios and defined test cases for detailed functional testing.

Wrote SQL scripts for generating reports.

Built Use cases from the requirements gathered to create use case diagrams and Use case documents.

Extensively used MS Visio for customizing and filtering requirements to maximize the informative value of each requirement.

Environment: MS Office 2007 Suite, Java, J2EE, Oracle, UML, MS Visio, JIRA, Agile/Scrum, STAR Schema, Balsamiq, Enterprise Architect, Share Point.

Client: Exostar, Herndon, VA Mar’11- July’12

Role: Sr. Business Analyst (e-Commerce Industry)

Project: Procure Pass

Procure Pass is a B2B e-Commerce web application that enables buyers to search for items, create requisitions and manage the purchase order lifecycle. A Business Process Reengineering (BPR) methodology has been applied to the existing versions of Procure Pass to achieve maximum customer acceptance. The intuitive catalog-based shopping cart has configurable workflows, approvals and e-mail notifications. Advanced search capabilities allow for easy navigation though millions of catalog line items. Additionally, Procure Pass offers buyers secure access to supplier Web sites while consistently applying standard workflows and maintaining spend visibility.

Responsibilities:

Applied BPR to the existing Procure Pass versions of the software to achieve maximum customer acceptance and gather requirements based on the new data that becomes available at every sprint.

Analyzed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).

Employed SDLC for the purpose of monitoring the project and also followed the step-by-step procedure.

Study the current state of the processes. Prepare the AS-IS process map and the TO-BE scenario.

Work with the development, UI, testing and other work streams to ensure effective communication of requirements. Also, serve as liaison for all other phases of the project and ensure that project deliverables meet the business requirements and expectations.

Created reporting wireframes and layouts after talking with Business users.

Documented the current process and business opportunity by interviewing stakeholders and end users to elicit better understanding of the business need.

Conducted JAD Sessions for requirements capturing.

Discussed operational scenarios, identify issues and errors and resolve them. Review all the work products being delivered to the end user.

Leveraged strong relationships with both the business and technology teams to collect high quality requirements resulting in successful end products.

Completed all deliverables and project tasks in a timely manner with a high degree of quality by successfully multi-tasking and by prioritizing tasks appropriately.

Developed Functional Requirement Document and Use Case Specification document.

Coordinated with developers to ensure understanding of the user requirements.

Conducted structured walkthroughs with developers and subject matter experts to validate the requirements.

Interacted with the technical team in resolving the bugs and other technical issues.

Designed and developed Use cases and Sequence diagrams using UML.

Performed Gap Analysis of the processes to identify and validate requirements

Document all outcomes including minutes, action items, and next steps; track and resolve all action items in support of the sessions.

Environment: BPR, HP ALM, Oracle 11g, TOAD, HTML, Excel, Outlook, Java, SQL, MS Visio, MS Office 2010, MS Project 2010.

Client: TriStar Health, Brentwood, TN April’ 09 – Feb ’11

Role: Business Analyst

The project's main purpose was to increase the efficiency and throughput on payments from carriers. In addition, the scope was expanded to improve the tracking processes for medical claims submitted to the carriers.

Responsibilities:

Conducted GAP Analysis to understand the reason for delays in submitting claims to the carriers and documented findings.

Heavily involved in authoring the Project Standards, Project Charter and Project Scope documents.

Organized requirement gathering sessions with Stakeholders to get a better understanding of claims processes and gathered requirements to create the Business Requirement Document (BRD).

Conducted user interviews to analyse the requirements and managed changes by implementing a formal change management methodology using SharePoint.

Created current and future state Process flow diagram using MS Visio and conducted walk-through sessions of the process flows with the vendor and client to validate them.

Tracked stakeholder requested enhancements and maintained changes using Requirement Traceability Matrix (RTM).

Assisted the project manager in developing and updating timelines for project delivery, implementing milestones, managing risks, issue and resources for successful completion of the entire project by using MS Project.

Continually interacted with the business and technical teams to ensure consistency in ideas and other work processes related to the project.

Coordinated and performed UAT (User Acceptance Testing) to assess if the system could support day-to-day business and user scenarios and ensure the system was sufficient and correct for business usage.

Environment: Waterfall, MS Visio, MS Share Point, MS Office 2003, Oracle Database and QTP.

Client: Booz Allen Hamilton (PBGC), Washington, DC Aug’ 06 – March’09

Role: Business Analyst

The Risk Management and Early Warning (RMEW) system provides risk management, early warning and document management features to the Department of Insurance Supervision and Compliance (DISC) and the Office of Chief Counsel (OCC). The goal of the project is to promptly identify, evaluate and monitor all potentially significant risks of the insurance program.

Responsibilities:

Worked with key Stakeholders of the projects to identify and finalize the requirements. Collaborated with clients, end users, and developers and ensured technical requirements are thorough using standard tools and modeling techniques.

Established solid working relationships with open communication with customer and business via meetings and interviews. Created mockups and prototypes for the JAD sessions. Responsible for creating the Business Requirements Specification Document (BRD) and the Functional Specifications Document (FSD)

Designed Business Process Model (Activity diagrams, Sequence diagrams and Collaboration diagrams)

Documented detailed analysis of end-to-end business processes, functional design, workflow mapping and action items, issues and ensured accurate and complete information.

Created the Requirement documents and traceability matrix using Requisite Pro. Created design document with more detailed and technical information on the requirements. Evaluated selection, develop strategies, project and implementation plans based on thorough research and input from stakeholders.

Resolved conflict with business units to overcome conflicts in requirements and arrive at common feasible solution

Managed changed by working with business units to determine and document the business process and workflow changes. Provided continuous support in forecasting & reporting, global consolidated P&L, including variance reporting and analysis.

Provided project management support in the areas of initiation, planning, RFP and software evaluation and selection process. Assisted with large system migration projects which will involve data mining, analysis and key project management skills.

Experienced in infrastructure design and deployment across a variety of technology platforms.

Being the main POC for the RMEW team for the production support, provided support to the users to troubleshoot the issue within the SLA

Used Clear Quest to maintain and track the requested enhancements and changes

Created Project management plans for managing on time delivery using MS Project along with writing test cases, unit and systems integration test plans in Quality Center.

Environment: Water Fall, Rational Rose, Rational Requisite Pro, MS Visio, MS Office 2003, Oracle, SQL

Contact this candidate