PRATEEK KUMAR
H.NO- 282, KHERA KHURD, DELHI
Summary
Highly motivated and detail-oriented MIS Executive with a strong foundation in Advanced Excel, including proficiency in complex formulas and data analysis techniques. Successfully completed two projects creating functional dashboards in Advanced Excel, demonstrating practical expertise in data visualization and reporting. Eager to apply analytical skills, technical knowledge, and innovative problem-solving in a dynamic role to support business operations and decision-making. Seeking to contribute to an organization by leveraging my Excel expertise and fresh perspective as an entry-level MIS Executive.
Overview
1
1
Certification
Work History
Intern
YOGI DIGI PVT.LTD
FARIDABAD
12.2022 - 06.2023
- Inputted customer data into computer database accurately and quickly.
- Created spreadsheets to track customer orders and shipping information.
- Reviewed source documents for completeness prior to entering them into the database.
- Updated existing data records and deleted unnecessary files.
- Performed basic administrative duties such as filing, copying, scanning.
- Conducted quality assurance checks on all entries to ensure accuracy of data entry.
- Identified errors in source materials before they were entered into the system.
- Processed high volumes of paperwork in a timely manner to meet tight deadlines.
- Scanned and stored files and records electronically to reduce paper files and secure data.
- Utilized various software programs including MS Office Suite and specialized applications.
Education
B.Tech - Mechanical Engineering
ST.ANDREWS INSTITUTE OF TECHNOLOGY AND MANAGEMENT
GURUGOAN08-2022
DIPLOMA - Mechanical Engineering
HINDU INSTITUTE OF TECHNOLOGY AND MANAGEMENT
SONIPAT, HARYANA06-2019
NON-MEDICAL - XII
ST.JOHNS PUBLIC SCHOOL
KHERA KHURD, DELHI05-2016
SECONDARY - X
ST. JOHNS PUBLIC SCHOOL
KHERA KHURD, DELHI05-2014
Skills
Advanced Formulas and Functions
- Array Formulas: Use array formulas for complex calculations across multiple cells For example, SUMPRODUCT and TRANSPOSE
- Dynamic Arrays: Utilize new functions like FILTER, UNIQUE, and SORT to handle dynamic ranges and filtering
- Lookup Functions: Master VLOOKUP, HLOOKUP, INDEX, MATCH, and the newer XLOOKUP for advanced data retrieval
- Logical Functions: Implement IF, AND, OR, IFS, and SWITCH for decision-making
- Text Functions: Use TEXTJOIN, SPLIT, LEFT, MID, RIGHT, FIND, and SEARCH for text manipulation
- Good Typing Speed (35 WPM)
- Quick Learner
- Dashboard creation
Languages
Hindi
First Language
English
Intermediate (B1)
B1
HOBBIES
- Playing Badminton & VolleyBall
- Travelling
- Riding
Accomplishments
- I Got a Medal in Olympic Mathematics Competition.
Certification
- Certificate of Completion AUTOCAD 2D,3D.
- Certificate of International Olympiad of Mathematics.
Timeline
Intern
YOGI DIGI PVT.LTD
12.2022 - 06.2023
B.Tech - Mechanical Engineering
ST.ANDREWS INSTITUTE OF TECHNOLOGY AND MANAGEMENT
DIPLOMA - Mechanical Engineering
HINDU INSTITUTE OF TECHNOLOGY AND MANAGEMENT
NON-MEDICAL - XII
ST.JOHNS PUBLIC SCHOOL
SECONDARY - X
ST. JOHNS PUBLIC SCHOOL
Similar Profiles
Srikanth SivaSrikanth Siva
Assistant Project Manager, Client Services at Digi Quest India Pvt.LtdAssistant Project Manager, Client Services at Digi Quest India Pvt.Ltd
APEXA RATHODAPEXA RATHOD
Web Developer at Yogi companiesWeb Developer at Yogi companies
Atrri MukherjjeeAtrri Mukherjjee
Director at Radha Karam Yogi Build Tech Pvt LtdDirector at Radha Karam Yogi Build Tech Pvt Ltd
Saksham MauryaSaksham Maurya
DevOps Solution Architect – Assistant Consultant at Tata Consultancy ServicesDevOps Solution Architect – Assistant Consultant at Tata Consultancy Services
JITENDRA JANGIDJITENDRA JANGID
Assistant Manager - Consulting & Analytics at ICICI Lombard General Insurance CoAssistant Manager - Consulting & Analytics at ICICI Lombard General Insurance Co