Business data analyst

Venkata Krishna Kaundinya

Phno: 571-***-****; Email: adxn0b@r.postjobfree.com

LinkedIn: https://www.linkedin.com/in/krishna-kaundinya-771631107/ Summary:

• Business data Analyst with 5+ years of experience health care & insurance and digital marketing platforms.

• Profound with creating dashboards and extracting reports while writing SQL queries.

• Extensively worked with SDLC (Software development life cycle) methodology.

• Excellent written and communication skills for documentation and presentation of business requirements.

• Strong with analyzing and mapping data, identifying business requirements, creating user stories, developing technical requirements and documentation.

• Competent in analyzing and creating Use Case Diagrams, Activity diagrams, using MS Visio.

• Experience in making presentations to senior management with high visibility and worked on high impact projects.

• Designed and implemented SQL queries to perform data validation.

• Excellent knowledge in designing and developing dashboards using by extracting the data from multiple sources (Flat Files, Excel, SQL server).

• Experience in functional documentation of business requirements in the form of Functional Specs and clearly documenting them in JIRA User Stories as well.

• Used SQL Server as a backend database for Power Apps and Business users put data through Power App UI and those tables used in the Power BI report as a data source.

• Research, Identify, and analyze the business domain problems to prevent future occurrences and communicates issues to management.

Skills:

Software Packages MS Office (Word, Advanced Excel, Access, PowerPoint, MS Project, SharePoint

Databases Microsoft SQL

Data Visualization Tools Tableau, Power BI

Application Tools MS Visio

Web Technologies HTML5, CSS3

Programming Languages Java, J2EE

Project Management Tools JIRA, Microsoft VISIO.

Venkata Krishna Kaundinya

Phno: 571-***-****; Email: adxn0b@r.postjobfree.com LinkedIn: https://www.linkedin.com/in/krishna-kaundinya-771631107/ Work Experience:

GlobalTekForceCom, Inc

Client – United Health Care

Business Data Analyst – IT Oct 2022 - Present

Description: This an automated process is driven by using emerging technologies to support contract officers, contract specialists and other procurement officials with award management to automatically track and monitor the performance of awards. Latest technologies are used to Built-in compliance with Un-delivered Orders (UDO) close-out accounting guidelines and policies.

• Work as a Business Data Analyst spearheading a cross-functional team to develop and launch a new application for healthcare system (primarily in the insurance domain), resulting in a 30% reduction in customer complaints and a 20% increase in on-time deliveries.

• Analyze customer feedback and market trends to identify opportunities for new product development related to streamlining application of coupons in the IT Ecosystem, resulting in the introduction of a high-margin product.

• Contribute to the development and launch of a new product line – Insurance Claims, aimed at improving healthcare products distribution efficiencies, which supported huge revenue within its first quarter and increased customer satisfaction rates by 25%.

• Facilitate stakeholder presentations at the leadership level around the products I manage.

• Recognized as a strong technical and financial modelling architect within the organization and responsible for driving New Technical Stack developments and transformations related to Java.

• Led the overall design of large revenue and complex custom services solutions with simple to medium complexity engagements as the business data analyst in the Healthcare space.

• Develop measurement criteria to evaluate programs and projects and develop or review estimates on technical aspects of projects.

• Design quality control and test procedures to ensure the deliverables meet established design and performance goals.

• Profound in identifying, analyzing, and evaluating alternative technology design solutions.

• Involved in identifying opportunities related to improvements in existing processes for coupons application and calculation module for the healthcare insurance applications.

• Involved in documentation standards, solutions, data flows, procedures, and other technical information using JIRA.

• Self-sufficient in creating and extracting reports using Power BI.

• Involved in creating meaningful dashboards for the product using Tableau.

• Stakeholder Management responsibilities were to: o Meet with Business Transformation Teams to understand requirements. o Meet with Program Management teams to understand and help define scope and timelines of the program.

Venkata Krishna Kaundinya

Phno: 571-***-****; Email: adxn0b@r.postjobfree.com LinkedIn: https://www.linkedin.com/in/krishna-kaundinya-771631107/ o Meet with Healthcare Business stakeholders to understand their requirements to delivery Continuous Improvement (CI)/Sustain activities.

o Conduct regular meetings to report and update progress, discuss scope and timelines, understand issues/concerns, and provided suggestions on all programs to Business Stakeholders, Development teams, Business Transformation leaders and Program Management leaders.

• Involved in business requirements gathering and elicitation and documented them in the form of Functional Specs, BRDs (Business Requirement Document) and supported in documenting them in JIRA User Stories as well.

• Involved in writing acceptance Criteria following BDD (Business driven development) in Given- When-Then format in spread sheet and then uploaded them in JIRA User Stories.

• Experience in functional documentation of business requirements in the form of Functional Specs and clearly documenting them in JIRA User Stories as well.

• Experience in supporting DIT Testing, SIT Testing, E2E testing, UAT testing, and PIT testing for delivering individual Features/Stories in different phases/sprints.

• Experience in collaborating with cross-functional teams to design and implement new Healthcare insurance claim process, resulting in an average order processing time reduction of 50%. Google Operations Centre (GOC)

Business Analyst - IT Aug 2019 – Aug 2022

Description: Extracting data from Google spread sheets and various internal tools to determine the total number of tickets worked by the employees and identifying the root-cause of customer dissatisfaction over the digital marketing tool (Google Ads and Google Analytics).

• Supported and worked with Product managers on creating and refining User Stories under features and leading the Sprint planning, Daily Stand-ups, Sprint Demo and Retro Ceremonies.

• Developed and implemented various customizations and reports for business users resulting in automation and process improvements.

• Profound in business analytics tools like Google Analytics.

• Worked on creating dashboards and extracting reports from Google Analytics.

• Worked on data analysis and mapping in MS Excel.

• Worked in Agile methodology to deliver SDLC model defining requirements using JIRA and having responsibilities to:

o Worked with Product Managers to define Features under Epics o Worked with Technical product managers to create Stories and guide them on sprint planning. o Worked with interlocking app owners to align with dependent delivery o Worked with Developers to hand-over requirement as functional specifications and provide detailed design and architectural overview of the solution.

• Automations/Process Improvements: By taking continuous feedback from Business Stakeholders, identified opportunities of improvement, designed and implemented 20+ Automations/Process improvements in various areas which were presented to and greatly appreciated by senior leadership.

Venkata Krishna Kaundinya

Phno: 571-***-****; Email: adxn0b@r.postjobfree.com LinkedIn: https://www.linkedin.com/in/krishna-kaundinya-771631107/

• Written Acceptance Criteria following BDD in Given-When-Then format in User stories.

• Developed and implemented various customizations and reports for business users resulting in automation and process improvements worth millions of dollars.

• Extensively worked on creating and refining User Stories under features and leading the Sprint planning, Stand-ups, Sprint Demo and Retro Ceremonies.

• Worked with / guided the development team to develop the business solutions according to the test results.

• Experience in Business process management (BPM) in order to improve customer experience over the Google Ads tool by suggesting sustainable changes while following the workflow.

• Track and determine incidents that need to be escalated and take appropriate steps.

• Ensured all activities within the service desk are performed at a high level of quality and within defined SLAs.

• Experience in making presentations to senior management with high visibility and worked on high Impact projects which includes preparing documentation for weekly based reviews and monthly based reviews.

• Experience with extracting reports using SQL queries.

• Analyze the system from both the technical and business perspectives and prepare Business Requirement Document (BRD).

Polaris Software Lab

Client: (CITI Asset Management)

Java Developer June 2018 - Aug 2019

Description: MIME (MORTGAGE INVENTORY MANAGEMENT ENVIRONMENT) This application is meant for the usage of the operations group for maintaining and analyzing the inventory of mortgage- based stocks, bonds, options with the company. The application gets data from the source directly into its oracle database using commerce quest. This data is analyzed based on the access availability defined in the prism architecture. It has Modules like Maintenance, Analyze Inventory, and Reports. Maintenance module Display of this menu is controlled by the ACF. The main purpose of this module to create; update delete portfolio, Portfolio Group, Users, views, Product Types. Analyze Inventory module is to design search criteria to view positions, original face of mortgage bonds and Current face values bonds. This module is used to display different reports TBA Portfolio Details, TBA Summary by Broker.

Responsibilities:

• Involved in Requirement Analysis. Preparing Requirement Analysis Document.

• Involved in preparing different Artefacts HLD, LLD using Activity Diagram, Sequence Diagram, Class Diagrams.

• Involved writing code for Request Processor class to extend the functionality of struts Controller. Venkata Krishna Kaundinya

Phno: 571-***-****; Email: adxn0b@r.postjobfree.com LinkedIn: https://www.linkedin.com/in/krishna-kaundinya-771631107/

• Have worked on applied patterns like Session Facade, Service Locator, Front Controller, Abstract Factory, Factory method, Singleton, Data Transfer Object etc.

• Involved in writing code for Action Class, Business Delegate, Session Bean, Entity Bean and DAO.

• Developed Java End Point Service, EJB End Point Service, Secure Web services with RPC, Document Style and of Using Axis 1.3 and JBOSS.

• On the server-side, used Spring MVC with Hibernate to connect with Microsoft SQL Server.

• Experienced in form validation, error handling and event handling using JavaScript and jQuery.

• Involved in Log4J for Logging Errors, debugging, and tracking.

• Experience in developing front end websites with Angular 6.

• Used git for version control and collaboration.

• On the server-side, used Spring MVC with Hibernate to connect with Microsoft SQL Server. Environment: XML, Java, J2ee1.4, JSP, Webservices, Eclipse 3.2, GIT, JavaScript, Eclipse with Lomboz plugin, Axis 1.3 and JBOSS.

Education:

Bachelor’s in technology

References:

Will be provided on request.

Contact this candidate