Karan Pathak
Patiala
Summary
Motivated and analytical professional with experience in evaluating dashboards and developing KPI reports. Excel Specialist proficient in SQL and POWER BI. Focused collaborator dedicated to interdisciplinary communication.
Overview
7
7
years of professional experience
1
1
Certification
Work History
System Integrator (Database Engineer)
National Council for Teacher Education (NCTE)
NEW DELHI
08.2021 - 06.2024
- Demonstrated ability to gather, clean, analyze, and interpret data from various sources.
- Converted raw data to comprehensive reports using SQL, reducing data preparation time by 20%.
- Prepare and present attractive dashboards to stakeholders using the POWER BI tool.
- Maintenance, handling day-to-day reports, weekly reports, and annual reports using Excel.
- Develop and maintain MIS systems and databases.
- Built a table dashboard to visualize core data every week of manual reporting work.
- Transformed raw data into meaningful insights using Power BI and PostgreSQL, improving the team's decision-making process.
Operations Associate
PAYTM SERVICES
Noida
11.2018 - 08.2021
- Oversaw daily operations, ensuring timely completion of tasks, and adherence to company policies and procedures.
- Implemented advanced Excel functions to automate repetitive data tasks.
- Collaborated with the IT team in developing a centralized data reporting system.
- Maintained and prioritized a to-do list, and followed up to complete tasks on time.
- Assisted in processing raw data into actionable insights.
- Maintenance, handling day-to-day reports, weekly reports, and annual reports.
- Develop and maintain a database in Google Sheets and Excel.
Associate
HCL INFOSYSYEM PVT. LTD.
Noida
06.2017 - 10.2018
- Solved enterprise queries (server room issues) in Dell operations with the chat process (email) both internationally and domestically as well.
- Handling manpower to visit client server rooms.
- Manage the manpower to avoid the SLA breach.
- Maintenance, handling day-to-day reports, weekly reports, and annual reports.
Education
Bachelor of Engineering - Computer-Science Engineering
Chandigarh University
Chandigarh06-2016
Polytechnic DIPLOMA IN INFORMATION TECHNOLOGY -
RIMT Polytechnic College
Mandi Gobindgarh, Punjab06-2013
Skills
- Data analysis
- SQL Query Proficiency in PostgreSQL
- Advanced Excel
- Dashboard Development Using Power BI
- Database design
- Problem solving
- Data visualization
Certification
- JAVA Language Training from Chandigarh
- HTML Language Training from Chandigarh
- PHP Language Training from Patiala, Punjab
Languages
Hindi
First Language
English
Advanced (C1)
C1
Punjabi
Proficient (C2)
C2
Timeline
System Integrator (Database Engineer)
National Council for Teacher Education (NCTE)
08.2021 - 06.2024
Operations Associate
PAYTM SERVICES
11.2018 - 08.2021
Associate
HCL INFOSYSYEM PVT. LTD.
06.2017 - 10.2018
Bachelor of Engineering - Computer-Science Engineering
Chandigarh University
Polytechnic DIPLOMA IN INFORMATION TECHNOLOGY -
RIMT Polytechnic College
Similar Profiles
Frank Angelo KihweleFrank Angelo Kihwele
Information Communication Technology Office at The National Council for Technical And Vocational Education And Training (NACTVET)Information Communication Technology Office at The National Council for Technical And Vocational Education And Training (NACTVET)
Harsh ChetwaniHarsh Chetwani
Documentary Filmmaker at National Council For EducationDocumentary Filmmaker at National Council For Education
Natalia Martinez-LeonNatalia Martinez-Leon
Kiddie Academy at LEAD TEACHER, New Horizons Regional Education CenterKiddie Academy at LEAD TEACHER, New Horizons Regional Education Center