Candidates About

Renu Sanjiva Rai

SUMMARY

•       Result oriented professional with 10 years of professional IT experience with strong focus on Business & Systems Analysis along with data analysis background in various domains like Healthcare, Lifesciences (Pharma), Medical billing, Educational services and Telecom.

•       Extensive experience in Software Development Lifecycle Process (SDLC), Iterative, Waterfall and Agile (SCRUM & KANBAN) methodologies.

•       Solid understanding of different business management strategies in Business Processes such as Business Process Automation, Business Process Improvement and Business Process Re-engineering.

•       Experience in conducting gap analysis, impact analysis, root cause analysis, and cost analysis along with in depth knowledge of the AS-IS and TO-BE business processes to identify system restrictions and potentials.

•       Skilled in providing comprehensive walkthroughs with the aid of wireframes, prototypes, Data Flow Diagrams, ER diagrams and UML diagrams (Activity, Sequence, Use Case).

•       Strong testing experience in performing Functional Testing, Smoke Testing, Regression Testing, Progression Testing and User Acceptance Testing (UAT).

•       Excellent analytical and problem solving skills; listening, oral, and written communication/ presentation skills.

SKILL SET:

Requirements Management Tools: Power Designer, Requisite Pro, Confluence

Business Modeling Tools: Smart Draw, MS Visio, Prototyper Just in Mind, UML 2.0, Pega 7, Balsamiq, RSM

Defect Management Tools: Bugzilla, SILK Central, Jira, HP Quality Center, RQM

Reporting Tools: Crystal reports, Business objects (BO), Tableau, Google Analytics

Methodology:  Agile (SCRUM, KANBAN), Waterfall, Iterative. Knowledge of Lean Six Sigma principles, Scaled Agile Framework (SAFe).

Database Tools/IDE: T-SQL, MS Visual Studio 2010, SQL Server Management Studio, SOAP, Rest. MS SQL Server 2008 R2/2008/2005/2000,

Microsoft Tools : MS Visio 2010 , MS Excel , MS Word , MS PowerPoint , MS Access , SharePoint, Pivot Table.

EXPERIENCE:

Fundamental Key Responsibilities (Jan 2008 – Jan 2018)

•       Conducted Requirements Elicitation with Product owners to determine capabilities and features.

•       Participated in prioritizing the features and user stories with product owners and senior business system analyst.

•       Participated in the daily stand up meeting to provide updates related to the given task to the rest of the team.

•       Conducted gap analysis and root cause analysis for implementation to understand as Is Process and To Be process.

•       Participated in poker planning to make faster and more accurate estimation for completing the given task.

•       Created business requirement documents like Lean Business case, EPIC hypothesis, User stories, Functional Requirements Document (FRD), Non Functional requirement document (NFR) from several Use Case scenarios.

•       Documented the system interaction and business rules in the necessary documents like, Use Case and User interface document, software component specification, Application interface document.

•       Collected requirements and conducted analysis for Digital Marketing Technological web applications.

•       Designed and developed various UML diagrams including Use Case Diagrams, Activity Diagrams, and Sequence Diagrams using RSM/ MS Visio.

•       Provide walk-through of the documents to product owners and development teams to ensure uniform understanding of the business scope, and detailed business and functional requirements. Maintained the cross communication between the different teams in the project. Defining the RACI chart to avoid conflicts

•       Assisted testing teams in Test plan, Regression testing and Black box testing. Participated in Navigation testing, Smoke testing and UAT testing of each build during the various phases of the application

•       Used basic SQL to verify the integrity and consistency of the data in the database.

•       Document scope for the User Acceptance Testing and triage UAT defects.

•       Extensively used Jira and Silk central for issue tracking

•       Widely used Requirements Traceability Matrix (RTM) for identifying and tracing the linkages among several connected project artifacts to analyze the impact of a desired change.

•       Facilitated Change Management for the Project by performing Impact Analysis for Change Requests obtained during early stages of the Project Life Cycle.

•       Create user manual of the existing system technology and process improvements.

•       Organized and participated in Release walkthroughs, demos & presentations of the new releases and documenting the feedback.

CLIENTS & PROJECTS

Verizon Wireless, Warren, NJ        (Telecom Industry)                            July 2017 -  Jan 2018

Role:  Business Systems Analyst

Description:  As a business Analyst, supported in implementation of HP Pie encryption for PII & PCI information for all the POS web services call.Worked as a portfolio Manager allocating resources and keeping track on resources - off shore and on shore for the whole POS team. Generated reports for the higher management for presentation of resource allocation and status of the different projects.

Responsibilities:

 Involved in the project lifecycle from inception to implementation

•        Conducted Elicitation with the Product owners (Compliance and Security team) to determine and gather requirements. Prepared User Stories in Jira and prioritized the user stories with the product owners based on business value and story points using Fibonacci method.

•         Groomed the user stories in each sprint and added the user acceptance Criteria’s for each user stories. Conducted Gap analysis and impact analysis by identifying all the systems impacted by the HP Pie encryption.

•        Presented Bi-weekly project status report with help of MS PowerPoint to senior & executive management.

•        As portfolio manager, performed demand management for various initiatives and teams, based on capacity & initiative sequencing. Generated high level analytics on program /project progression for senior and executive leadership.

 Environment - MS Excel, MS outlook, MS SQL, MS word, MS Visio, MS Pivot, Oracle, SAP,  MS SQL Server 2008, MS Power point, IE11,XML Format, Jira, SOAP, SaaS, Kanban, Clarity.

Medical Diagnostic Laboratories, Hamilton, NJ                                        Jan 2016 -  July 2017  

(Life Sciences & Medical billing domain)

Role:  Senior Business System Analyst 

Description:  Worked on multiple initiatives as business systems analyst for the Medical billing system & R&D clinical research systems. The Medical billing systems have all the pricing, diagnostics codes and claims information of the clients, entered through order entry module. The R&D clinical research system is a repository of patient clinical information which is fed by the cytologist and physiologist on the outcome of clinical tests conducted for the patient. The purpose of these systems were to provide a secure web channel for physicians and the patients to access these results and to generate electronic invoices to patients and insurance carriers.

Responsibilities:

Involved in the project lifecycle from inception to implementation

•        Conducted Elicitation with the Business stakeholders (Product owners) such as Billing department,  Actuarial team, Customer service, IT department, Accession team, Quality check – Pathology team, R&D team and Admin team to determine and gather requirements.

•        Conducted Gap analysis and Impact analysis to understand the current as in process and to be process. Prepared Mock ups, Swim lanes, Flow Chart, Wireframe and Activity diagram to explain the Current Business process flow and to be Business process flow.

•        Data Mapping to consolidate data from various clinical sources such as an EMR with the R&D system to provide accurate information of the patient to support clinical data repository.

•        Created Tableau Dashboard for sales team to view reports.

•        Gathered and elaborated user stories for web analytics like search engine optimization (SEO), funnel, conversion and goals reporting.

•        Used Salesforce Customer Relationship management to store Customer information such sales opportunities related to particular location.

•        Implemented regulation such as 21 CFR Part 11 guidelines for the application.

•        Prepared SOP document for the end user and participated in Release walkthroughs by presenting end users the new releases and documenting the feedback from the end users.

Environment - MS Excel, MS outlook, MS SQL, MS word, MS Visio, Wiki, MS SQL Server 2008, Balsamiq, MS Power point, IE11,XML Format, Jira, SOAP,  MVC, Git server, SaaS, Service tracker.

Atlas                                                                                                               Oct 2015 – Dec 2015

Client: Bristol-Myers Squibb, Pennington, NJ (Life Sciences Domain)

Role: Senior Business Analyst

Description: This Agile project was a fast pace project. This project purpose was to replace the drug discovery current Service Tracker application and the Literature/ Patent Search Request form from old cold fusion server to customized SharePoint application. The purpose was to create a new web based application for the end user i.e Requestors and the Analysts to create/ update the request form and create a customized SharePoint dashboard for the requestors and the analysts to track the requests.

Environment - MS Excel, MS outlook, MS SQL, MS word, MS Visio, Wiki, MS SQL Server 2008, Balsamiq, MS Power point, IE11,XML Format, Jira, SOAP,  MVC, Git server, SaaS, Service tracker.

Thomas Matthew Associates                                                            September 2014 - May 2015

Client: Education Testing Service (ETS), Ewing, NJ (Educational services domain)

Role: Business Systems Analyst

Description:  This Agile SCRUM project was to build a web based application for the purchasing of vouchers on behalf of the students of different brands. These vouchers can be later used by the students / ETS customer representatives while scheduling the test for a test taker in both the models i.e Candidate self-serve Model (CSS MODEL) and Test center staff Associate Model (TCA Model).

Environment - MS Excel, MS outlook, MS SQL, MS word, MS Visio, MS SharePoint, MS SQL Server 2008, Just in Mind, MS Power point, Power Designer, web sphere Application server windows7,  XML Format, JIRA. SOAP.

IKON Software Services                                                                  Jan 2008 – March 2014       

Client: WELLPOINT/Anthem – New York, NY                         Feb2010 – March 2014

(Healthcare Domain)

Role: Business System Analyst

Project: Health Exchange Product / Quoting System (Nov 2012 – March 2014)

https://shop.anthem.com

Description:   This project was to build a web based quoting system as part of the Health Care Reform (ACA) mandate which offered the Health exchange based plans to the subscribers. The modules for the integration of the product and rating system was the key to this web based system and I worked as the business systems analyst supporting this integration.

•        Project SME was around the healthcare products offered for the individual market segment as part of ACA implementation of Qualified Health Plans (QHP), Essential Health Benefits (EHB), Cost Share Reduction (CSR), Subsidies, SERFF templates, Exchanges and Direct Enrollment flow.

•        Work with Actuarial team to understand the rating area and service areas where products are to be offered and documenting the business rules around service and rating areas.

Environment: Rational Tools, MS SQL Server 2008, Justinmind, Web sphere Application Server, Windows 7, HIPPA.

Project: Enterprise Product System (Mar 2011 – Nov 2012)

Description: This project was to setup an enterprise repository for the healthcare plans / products for all market segments within the enterprise. This was a product configurator which comprised all the attributes for sales, utilization management and claims adjudication. The system also has an administrative web UI for benefit administrators to configure product benefits.

•   Analyze product benefits consuming systems like SBC / Evidence of Coverage (EOC) generator, Web portals, Claims systems, Care management systems and aid them in documenting the benefit mapping documents for the required benefits for the respective systems.

•   Impact analysis of ICD9 – ICD 10 migration on product system

Environment: Rational Tools, MS SQL Server 2008, Management Studio, Web sphere Application Server, Windows 7, MS Visio, MS word, Sharepoint, Facets.

Project: Senior Online System (Feb 2010 – Feb 2011)

https://shop.anthem.com/medicare

Description: The project was to build an online insurance quoting application that would help the users to find the right insurance for Senior Medicare, Part-D and Medicare Supplement plans. The user can learn about insurance, get a quote, retrieve a quote or buy an online insurance policy. For the first time applicant, the user creates a login profile with a valid user id and password. After authentication of this information, they can submit their enrollment and pay their payments online. Also they could contact the representative in case of any online collaborative assistance.

Environment: MS Excel, Teradata, Mainframes, Oracle 11g, MS PowerPoint, MS Word, MS Visio, MS Share Point, MS Outlook, UML, JCL.

Client:  Qwest, Minneapolis, MN     (Telecom domain)                    Jan 2008 – Dec 2009

Role: Business Analyst

Qwest, now a subsidiary of CenturyLink, was a telecommunications carrier that provided local service in 14 western US states. Qwest used the Amdocs Billing System API for billing the customers. The project involved customization and testing of billing system. The job responsibilities included gathering requirements for various billing modules of system like Billing and Price Plan.

Deitya Pvt. Ltd, Bangalore, India                                                                Jan 2005 – Dec 2006

Role: SQL Server Developer

Environment: MS SQL Server 2008, MS Excel, Windows 97/2000/XP, Microsoft Power Point, Microsoft Share Point Server, T-SQL, MS Access and SSIS

EDUCATION: 

            Master of Science in Accountancy, University of Phoenix 2013

`

Bachelor’s in Commerce, Pune University, India 2003

Diploma in computer science, Pune University, India 2004