Summary
Overview
Work History
Education
Skills
Accomplishments
Professional Projects
Technical Skills
Timeline
Generic

Pavan K

Business Analyst

Summary

Business Analyst with 4+ years of IT experience in defining and developing key business software, by analyzing customer needs, business operations and key pain points across various domains. Good experience in handling cross functional teams. Also possess good knowledge of analytical tools such as SQL and APIs.

Overview

4
4
years of professional experience

Work History

Business Analyst

Tech Mahindra
12.2019 - Current
  • Requirement information and Analysis – Have good experience in gathering the requirements and documenting them
  • Stakeholder Communication – Will be acting as a bridge between the technical team and stakeholders
  • Data Analysis – Will be doing enough data research in MS SQL database for the report requirements
  • Strong verbal and communication skills
  • Proficiency in all types of SQL commands, DDL, DML, and TCL
  • Window/Analytical functions
  • Have good knowledge on creating Wireframes
  • Updating, implementing, and maintaining procedures
  • Hands-on experience in joins, Sub-Quires, Aggregate functions, Operators, Views in SQL
  • Good understanding of database concepts, anomalies, and normalization processes
  • Have good knowledge of Entity relationship diagram (ERD)
  • Experience in developing SQL scripts to validate the database tables & and reports data for backend database testing
  • Experience in ETL Testing using Informatica Power Centre and SQL
  • Process Improvement – Have good experience in the Scrum team and used to conduct all the ceremonies and act as a Scrum master as well
  • Contribute to all the agile events
  • Risk Assessment – Will identify and assess project risks and bring them to the notice of concerned teams
  • Involved in Scrum meetings, addressing issues with the Dev team, scrum master, and clients
  • Hands-on Experience in using Project Management Tool like JIRA
  • Participating in weekly core team meetings with the Product team and learning about the roadmap
  • Interested in a challenging Business Analyst/Product Owner
  • Preparing the BRDs (Mapping doc, Data flow diagrams) giving walkthroughs to the team for every release/project and conducting grooming sessions
  • Have experience with AGILE methodology and SCRUM Team
  • Hands-on experience in creating mapping documents for reporting applications
  • Have experience in Master Data Management and Analytics
  • Have good knowledge of the sprint reports
  • Communicating progress clearly to all stakeholders, facilitators, and partners
  • Ability to draw Process flow diagrams using diagrams.net and write User stories.

Education

B.Com -

S.V University

Skills

undefined

Accomplishments

  • Received Pat on the Back award for my performance from client.
  • Certified Business Analyst from Scrum Agile.

Professional Projects

  • Euro Car Parts, As a Business Analyst, I played a central role in the digital transformation project undertaken by Euro Car Parts. Euro Car Parts is one of the largest suppliers of car parts, accessories, and tools in the United Kingdom. Euro Car Parts has a comprehensive e-commerce platform that allows customers to shop for parts and accessories online. The website features intuitive navigation, product search functionality, and detailed product descriptions, making it easy for customers to find the items they need. The company offers technical support and advice to customers, helping them identify the right parts for their vehicles and aiding with installation and troubleshooting. This expertise enhances the customer experience and ensures that customers can make informed decisions when purchasing automotive parts., Involved in requirement gathering from the client., Converting the requirements to user stories (JIRA), Planning the project delivery with the client, technical teams etc., Coordinating with the technical team in delivering the software, Coached the team members on adopting agile methodology for project delivery., Responsible for client communication over project delivery
  • Aster HMS, Project Aster HMS (Hospital Management System) is a comprehensive software solution designed to streamline and automate various administrative and clinical processes within a healthcare facility. The system prioritizes data security and compliance with healthcare regulations, including HIPAA (Health Insurance Portability and Accountability Act) and GDPR (General Data Protection Regulation). It incorporates robust security features such as access controls, encryption, and audit trails to safeguard patient information., Conducted stakeholder interviews and facilitated workshops to gather requirements and understand business needs., Created detailed business requirement documents (BRDs), use cases, and process maps to document current and future state workflows., Collaborated with IT teams to translate business requirements into technical specifications and oversee the development and implementation of system enhancements., Followed agile methodology for project delivery., Coordinated with the development team for project delivery.
  • Shopify e-commerce, Shopify is a leading e-commerce platform that enables businesses to create and manage online stores. It provides a wide range of tools and features to help merchants sell products and services online effectively. Shopify allows users to design and customize their online storefronts easily. It offers a variety of customizable templates and themes, as well as a drag-and-drop interface, enabling merchants to create visually appealing and responsive websites without the need for coding knowledge., Involved in requirement gathering from the product managers onshore., Coordinating with the development team to deliver the product., Analyzed customer data using tools such as excel and SQL., Created various dashboards over Tableau and analyzed data over excel to help deliver this solution and overall product management team.

Technical Skills

JIRA, MS Office, MS Visio, Balsamiq, Figma, Lucid Chart, Postman, SQL, Tableau, MS Teams, Slack, Confluence

Timeline

Business Analyst

Tech Mahindra
12.2019 - Current

B.Com -

S.V University
Pavan KBusiness Analyst