Summary
Overview
Work History
Education
Skills
Affiliations
Accomplishments
Languages
Certification
Timeline
Generic
ABHIJIT BHAVE

ABHIJIT BHAVE

Gandhinagar

Summary

Resourceful and Highly motivated System analyst with deep understanding of domain knowledge and strong foundation in communication. Skilled in analyzing complex systems, identifying errors and resolving them to bring desired results. Proficient in Problem solving and bridging the Gap between Operations team and Customer through clear and concise communication. Adept at using excel, power BI and AI tools like Chat GPT and Gemini to perform Data cleaning, Data transformation and improve overall efficiency.

Overview

3
3
years of professional experience
1
1
Certification

Work History

Senior System Analyst

NEXTGEN CLEARING
Ahmedabad
01.2022 - Current
  • Utilize advanced Excel functions and macros to analyze and manipulate data for tariff configuration.
  • Implement tariffs as per customer's request and move it into production environment.
  • Conduct Quality Analysis on implemented file and identify errors and areas of improvement and correct it to enhance overall efficiency and reliability.
  • Administer the OTRS (Open Ticket Request System) platform, overseeing ticket creation, quality analysis, and resolution processes while adhering to Service Level Agreements (SLA's)
  • Manage communication with customer support team via email, ensuring timely responses and resolution of inquiries or issues related to system functionality or support thus ensuring customer satisfaction.
  • Analyze new customer's data during migration and communicate with them in order to resolve queries and ensure smooth and efficient migration.

Education

BACHELOR'S OF ENGINEERING - ELECTRONICS AND COMMUNICATION ENGINEERING

SAL INSTITUTE OF TECH AND ENGG RESEARCH (GTU)
Ahmedabad, GJ
07-2021

HIGHER SECONDARY - SCIENCE

ST XAVIER'S HIGH SCHOOL
GANDHINAGAR
04-2017

Skills

Technical Skills

Excel:

  • Pivot tables and Pivot Charts
  • Advance Formulas (INDEX-MATCH, X-LOOKUP, IFS)
  • Conditional Formatting and Data Validation
  • VBA and MACROS

SQL:

  • Selecting and retrieving data from databases using SELECT statements
  • Grouping data and applying conditions to groups

POWER BI:

  • Data Transformation using power query
  • Data Visualization

PROMPT ENGINEERING:

  • Design and develop prompts for various tasks like text generation, Data analysis

AI TOOLS:

  • CHAT GPT AND GEMINI

NON TECHNICAL SKILLS:

  • Excellent Communication Skills to collaborate with Stake Holders and deliver successful projects
  • Ability to perform in dynamic environment
  • Data analysis to identify trends and optimize marketing campaigns
  • Problem-solving skills to develop innovative solutions
  • Critical thinking to evaluate complex issues and make informed decisions

Affiliations

  • Trekking Instructor at Invincible NGO
  • Marathon Runner
  • Ex-NCC Cadet holding Cadet Warrant Officer Rank
  • International Karate player holding Brown belt

Accomplishments

  • 3rd All India Rank in Drill competition in NCC
  • Gold Medalist in International Karate Tournament
  • Finished 10km and 21 km marathon in Mumbai and Delhi
  • Secured "A" Grade in NCC C Certificate

Languages

Marathi
First Language
English
Proficient (C2)
C2
Gujarati
Proficient (C2)
C2
Hindi
Proficient (C2)
C2

Certification

LinkedIN Learning

  • “Excel and ChatGPT: Data Analysis Power Tips” https://lnkd.in/dx9XcPw4
  • "Prompt Engineering: How to Talk to the AIs" https://lnkd.in/dvyNaNmz
  • "Introduction to Prompt Engineering for Generative AI" https://lnkd.in/dMeD8PTc
  • “Excel: Macros and VBA for Beginners” https://lnkd.in/dspEcCnc
  • “Operational Excellence Foundations”
  • "Business Analysis: Essential Tools and Techniques"
  • “Scrum: The Basics” https://lnkd.in/dSXkbpCP

Skill Nation

  • Basic to Advance Microsoft Excel ID: 2D08BCDC07F1-2D0B04ED5CE7-83A1EF6145
  • Basic to Advance Power BI for Business Intelligence ID : 2D0B04FBDF5C-2D0B04EDAB6A-83A1EF6145

Timeline

Senior System Analyst

NEXTGEN CLEARING
01.2022 - Current

BACHELOR'S OF ENGINEERING - ELECTRONICS AND COMMUNICATION ENGINEERING

SAL INSTITUTE OF TECH AND ENGG RESEARCH (GTU)

HIGHER SECONDARY - SCIENCE

ST XAVIER'S HIGH SCHOOL
ABHIJIT BHAVE