Pune, India

adxb7p@r.postjobfree.com

+91-917*-**-****

TECHNICAL SKILLS

• SQL

• Stored Procedures

• Triggers

• Joins

• Tracking KPI

• POWER BI

• Microsoft Excel

• MS OFFICE

• Libre Office

• CRM TOOLS -Salesforce

• OPERATING SYSTEMS -LINUX and

WINDOWS

Programming Languages

C/C++ Progamming

Java Progamming

SOFT SKILLS

EDUCATION

PROFILE SUMMARY

1) An IT professional with 3 years 3 month of of working experience. 2) Creating and maintaining Business/Sales/Telecaller reports by using Advance Excel and Created salesforce dashboard.

3) Having thorough understanding of Customer issues, while allocating credit card to Customer.

4) Capable of handling Pan curing Report process.

5) Expertise Skilled in VLOOKUP formula development, Pivot Table generation, and Pivot reporting. Demonstrated ability to use critical and strategic thinking to resolve discrepancies, fill gaps, and sustain quality control benchmarks. Processed data load requests, manually entered data, reconciled data conflicts, and created data extracts and reports.

6) Strong problem-solving skills, decision making based on extensive experience and technical skill enables effective solutions that positively impact customer satisfaction & operational costs. A sincere hardworking professional with relationship management, analytical & coordination skills.

7) Developing and maintaining documentation including requirements, design & user manuals; monitoring the deployment of data to the data warehouse and extracting data from heterogeneous sources. 8) Also experience in professional application and database development with thorough knowledge of different phases of software development lifecycle including analysis, design, development, documentation, deployment and system support. Experience in designing of the database

WORK EXPERIENCE

Teamlease (Working with Bajaj FinServ Pvt. Ltd., Pune) August’2021- Present

• As Associate Credit Card PMG

• Duration: 05 Aug 2021 to 9TH MAY 2023

• In this COE team main role is checking PSF mobility app issues such as allocation issue, move to qc cases, other issues finding.

• Using salesforce creating reports and lead/customer allocation related & other issue solve using SFDC

• To work on resolution of issue, faced while assigning Credit card to customer.

• To generate Business/Sales/Other report dashboard using various tools like Salesforce and Advance Excel.

• To work on highly delicate & responsible daily task i.e., KPI.

• To co-ordinate with TECH team for resolution of issues occurred in day-to-day monitoring process.

• To maintain summary report of issue occurrence and resolution on daily basis

VNS Software Solution August-2020 to July-2021

ONKAR KOLEKAR

A multi-faceted professional with 3.3 years of experience in software development and SQL development professional with strong verbal and written communication skills and solid analytical skills for writing relational database solutions for businesses.

Collaborator

Communicator

Planner

Change Agent

2017

Bachelor of Engineering- Computer

Science and Engineering – 63.33%,

TSSM's BHIVARABAI SAWANT

COLLEGE OF ENGINEERING

2014

3

Diploma Computer Engineer – 59.05

SB Patil Polytechnic, Indapur

2010

SSC– 65.09%, Tulashidas Jadhav

Prashala Tulashidasnagr, Vairag.

PERSONAL DETAILS

Date of Birth: 18th Aug 1994

Languages Known: English, Hindi and

Marathi

Address:

Flat no 106, Near Old Vitthal Temple, Narhe

Gaon, Pune, Maharashtra 411041

Marital Status: Married.

Nationality: Indian.

PAN no-DHTPK1775B

Hobbies-

• As Software Engineer

• Developed/Modified various database objects like Tables, Triggers, Views and Stored Procedures, ad-hoc queries.

• SQL Developer: SQL queries using Joins, Sub-Queries, and Views to retrieve data from the database Support and manipulate data in the database.

• Coordinating with Client to understand requirements, analyses and integrate the requirements in the system.

• Developed/Modified various database objects like Tables, Triggers, Views and Stored Procedures, ad-hoc queries.

• Creating and managing the clustered indexes and non - clustered indexes and optimized queries using execution plan

• Using DDL and DML for writing triggers, stored

procedures, and data manipulation.

• Creating database and database objects like tables, stored procedures, views, triggers, rules, user-defined data types, and functions.

CONCEPT SYSTEMS PVT.LTD September-2017 to

January-2018

Key Responsibilities:

• As internship in developing and testing software

• Work on ERP Projects using dot. Net programming

language

• Creating Small modules in live project

• Collecting requirements from customer

• Creating Test Case and finding bugs in software

• Create user manual for customer or End users.

• Any issue or bug occurred then store in excel and solve it

• Coordinating with Client to understand requirements, analyses and integrate the requirements in the system

• SQL queries using Joins, Sub-Queries, Views to retrieve data from database

• Working on full life cycle development (SDLC) involving in all stages of development.

• Creating the database objects - schemas, tables, indexes, views, user-defined functions, cursors, triggers, stored procedure, constraints, and roles.

DATE-

ONKAR APPASAHEB KOLEKAR

Contact this candidate