Pune, India
***************@*****.***
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