Raghavendra Havanur Email and Phone Number

Working USAHerds version 2.0

Analyst who gather and document key business/system requirements by facilitating user meetings and interviewing users. Review functional documentation of legacy system and proposed replacement solution to prepare gap analysis and recommended functional enhancements for target replacement solution.Invovled in project planning, design and training sessions to enhance target system and sunset legacy system.

Working on the data migration project from different source system into Centene data base.Involved in data mapping of different common business objects using Fhir standards.

• Creating visually impactful dashboards using Tableau to transform data into actionable information.• Responsible for retrieving student information from student database using SQL queries.• Worked with Asst. Professor in his research on Leadership qualities by conducting online surveys involving university students, staff & administrators and analysed the data and interpreted the results using excel to develop metrics for improve Business.• Responsible for creating roadmaps of the course work of day to day activities for the students.

The Digital Private Banking (Credit Suisse) project provides search capabilities to Resource Manager (RM) users in RM ECO System to search for their client portfolio easily. Uses the advanced search engine Elastic Search as a backend DB. • Supported requirements triage in MQC to select release specific requirements – identify relationships and dependencies between requirements, estimate technical effort and perform Impact Analysis• Facilitated JAD sessions and design meetings with the Stakeholders, SMEs and Leads of Interfaces.• Worked on intense AGILE sessions leading the team during User story grooming sessions, Sprint Planning, Daily Scrum, and Issue remediation.• Plan, prioritize, and manage project scope and product feature backlog.• Expertise in presentations of demos with Power Points, MS Projects, MS Access, and complex Excel objects (Pivot tables, data trending, live data connection to backend databases, SQL Server and Oracle.• Collaborated with the leadership team and operational managers to estimate requirements, prioritize projects and communicate with key stakeholders.• Plan meetings with end users to write a formal documented needs analysis.• Documented business practices and build process flows for various teams. • Worked with core teams and stakeholders to help plan the scope of all department projects in order to execute highly successful campaigns from start to finish. • Created data dictionary for often used technical terminology for benefit of developers and customers respectively and worked for Request for Proposal (RFP), Request for Information (RFI).• Facilitated communication between developers and business units to implement reporting solutions. • Wrote test plans for testing requirements and bug fixes for media asset management

The TWUL_B2B_TACTICAL (Thames Water and Utilities Ltd.) project dealt with creating a website for commercial customers of Thames water. The Website automates the process of getting meter readings and calculating the bills. The customer can login to the website and check the readings as well as bills.• Accounted for communicating and coordinating with clients.• Strategic thinking in identifying overlapping functions and interdepartmental dependencies resulting in solution recommendations that benefit the whole company. • Trained, mentored and lead junior business analysts in analysis activities throughout the project lifecycle.• Coach the team through adoption of the Agile Scrum process with positive and negative feedback.• Elicited, documented, managed and validated business, functional and non-functional requirements throughout entire scope of SDLC lifecycle via waterfall and agile methodologies.• Observed the team's Agile/Scrum maturity and identify needs for Agile/Scrum principles.• Strong knowledge of SDLC in Agile process in managing defect, enhance, user's stories, sprints and released.• Wrote most complex SQL stored procedures and packages for developers to interface to DB backend.• Worked extensively with various databases to optimize internal software and custom reports utilizing MS Query functions, vlookup, pivot tables and SQL Server.

The purpose of the HONDA NEXTGEN TELEMATICS (TEMPLATE SERVER) (Client: HONDA OF NORTH AMERICA LTD.) project was to build a server to host the templates that are consumed by a Honda link smartphone application. Mobile users can set the user settings, can view all the Honda link templates, modify the existing setting and download the newly launched templates through template server interface services.• Conducts business review sessions and arrive at consensus on the efficient template design.• Created use case diagrams, context diagrams, process flows and Business process modeling to illustrate current and future state business processes for developing a template for ignition control of a car.• Documented client business requirements by leading and participating in JAD sessions. • Analyzed and validated business, functional and non-functional requirements. Liaised between the clients and developers to ensure that all the technical requirements are achieved. • Translated business requirements into technical specifications and create deliverables in different phases of the project life-cycle by decomposing functionality into user stories and business logic.• Critically evaluated information gathered from multiple sources, reconcile conflicts, decompose high-level information into details, develop complex stories from low-level information, and distinguish user requests from the underlying true needs.• Created and updated process flow charts and flow documents. • Organized weekly project status and task review meetings.• Used SQL Server Reporting Services to create web based canned reports as well as customized, very complex reports.• Performed SQL development works to migrate data from current database to new database..• Worked with Scrum Master and Agile team for Sprint planning to maintain adequate Sprint velocity• Worked in Agile development process, monthly Sprint and daily Scrum.

The Purpose of the HONDA CPS(Central Processing Server) (Client: HONDA OF NORTH AMERICA LTD.) project is to handle requests coming to Honda Central server from different Honda clients for helping them with vehicle insurance. Keeping track of file transfer happening from one location to another.• Involved in understanding the current business process, defining scope of the project along with position statement. • Acted as a liaison between the offshore development team and onsite business team • Established Off-shore Project teams within PMO. • Prepared and documented System Requirements and workflows for the Content Management Application tool Interwoven.• Conducted JAD sessions, Video conferencing and coordinated offshore operations with developers to meet deadlines.• Created business use case, functional (FRS) and technical specifications for trading system.• Applied Unified Modeling Language (UML) methodology to create use case diagrams and sequence diagrams.• Gathered requirements, designed, and built annual reports• Worked with clients to better understand their needs and present solutions using structured SDLC approach.• Supported PMO by mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.• Worked extensively on use-cases, user stories and created 120 use cases.