RAMJI BAJPAI
MIS DATA MANAGER
Sector 49 Noida
Summary
Experienced MIS with over 7+ years of experience in Data Management Industry. Excellent reputation for resolving problems and dedicated MIS professional with history of meeting company goals utilizing consistent and organized practices. Skilled in working under pressure and adapting to new situations and challenges to best enhance the organizational brand.
Seek and maintain full-time position that offers professional challenges utilizing interpersonal skills, excellent time management and problem-solving skills.
Overview
7
7
years of professional experience
Work History
MIS Sales Coordinator
JCBL Limited
Mohali
12.2021 - Current
- Handling queries over the call and making reports
- Generate Daily/Monthly/Yearly reports by using advance excel functions
- Making Dashboards & Charts.
- Prepare presentation in PowerPoint as per the requirement of management.
- Kept detailed records of sales and customer information in CRM software, updating database regularly to maintain top-notch service.
MIS Executive
LITEJOY INTERNATIONAL
New Delhi
06.2015 - 11.2021
- Produced tables, pivot reports and charts for use in key decision-making processes.
- Generated reports each month covering Inventory data.
- Designed internal dashboard for at-a-glance system and project status reporting.
Education
B.Com - Business Administration
IGNOU
2009
Intermediate (10+2) - Commerce
U.P. Board
1999
10th - Commerce
U.P. Board
1996
Skills
I have good knowledge of
- SQL, PowerBI, Visual Basic, C, C, FoxPro, Unix & Linux
KEY SKILLS:
- Microsoft Excel: Vlookup, Pivot, Chart, Dashboard, Countifs, Sumifs, Conditional, Sumproduct, Index, Match and many more Logical and Analytical Functions
- Learning SQL (Joins, Stored Procedures, Loops etc)
- PowerBI (Import Data from MS Access, SQL etc)
- VBA (Macro: Loops, UserForm, Outlook Automation, Events, Workbook Automation, Worksheet Automation, Compile Data, Split Data, VBA Connectivity with SQL MS Access etc
Certification
I have done One Year Diploma Course of ADCM (Advance Diploma in Computer Management) from Pioneer Computers, Allahabad.
Affiliations
I am an enthusiastic and dedicated professional with extensive experience in MIS Reporting System. I can demonstrate a strong ability to manage projects from conception through to successful completion. I perform effectively even within a highly pressurised working environment.
OBJECTIVE : To seek responsible and challenging position, that makes use of the full of my talent and which give me an opportunity and experience for personal growth and professional achievements.
BRIEF SNAPSHOT : Expertise in Microsoft Excel (Macros, Lookup, Charts, Piot-Table, Enhanced Reports, Formatting etc.). All kind of advance functions and Reports methodology.
I am an effective performer with good relationship building & interpersonal skills. strong analytical, problem solving & organizational abilities.
I have a knowledge of Visual Basics, basic knowledge of MS Access. excellent understanding of database principles, structures, theories and practices, strong SQL development skills with PowerBI. Ability to develop applications. Excellent analytical and problem-solving skills.
Additional Information
PERSONAL DETAILS
- Father’s Name : Mr. S.S. Bajpai
- Date of Birth : 10th of August, 1981
- Marital Status : Married
- Nationality : Indian
- Permanent Address: 68, Sharda Nagar, Atarra (Banda) UP – 210201
- Mobile Number : #8178298871, #9716928266
- Current Address : Vill-Barola, Sec-49, Noida (UP)
Accomplishments
- Typing with 60-70 w.p.m. Speed (with 99% Accuracy) in English and Numerical also.
Languages
English
Upper intermediate (B2)
Hindi
Advanced (C1)
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Quote
If you think, you can do anything than you can otherwise you can not
Software
MS Office
SQL
POWER-BI
VISUAL BASIC
C
C
FOXPRO
UNIX
LINUX
Interests
Computer Programming, Swimming, Singing
Working on Computer Programming, Listening Soft Music
I like to work and develop programming on a computer with the help of different programming softwares, I know.
Listening soft music like old songs for refreshment.
Similar Profiles
Nitin RaiNitin Rai
Area Sales Manager at Herbal Chakra Pvt. Ltd. (JCBL Group)Area Sales Manager at Herbal Chakra Pvt. Ltd. (JCBL Group)
Dana AlfreahatDana Alfreahat
Sales Manger at JCBL GroupSales Manger at JCBL Group
Jaylen IrvinJaylen Irvin
Customer Success Associate at JCBL LLCCustomer Success Associate at JCBL LLC
VAISHALI SHARMAVAISHALI SHARMA
E-Commerce Specialist at CEDCOSS PRIVATE LIMITEDE-Commerce Specialist at CEDCOSS PRIVATE LIMITED
Rakesh Mohan BhatnagarRakesh Mohan Bhatnagar
Cluster Head & Branch Head at DCB Bank LtdCluster Head & Branch Head at DCB Bank Ltd