Curriculum Vitae
Sunil P. Agrawal
B/***, Rangam Resicom, Opp. Vhala Resedency. Nr. Shreeji villa3, Ajwa road, Vadodara - 390019
Mobile: +91-990*******
Email: ***.*****@*****.***
Summary:
1.5 years of Academic experience.
4 Year of Java Development Experience.
1 year of Android Development Experience.
Excellent Java & android development skills
Strong database connectivity
Social media integration
Extensive Object Oriented Development experience.
Experience encompasses software designing, development and maintenance of the project.
Technical Skills:
Technologies
:
J2EE, JSP, Servlets, Struts2, JSF, Spring 3.0, Hibernate 3.0, JDBC, Java Scripts, JavaMail, REST api, Social Media integration
Database
:
MySQL, Oracle, MS SQL, MS Access
Languages
:
C, C++, Java, Advace Java, XML, HTML, SQL
Tools / Framework
:
Eclipse, Net beans, Dream weaver, Spring tool suit (STS)
Web Server
:
Apache / Tomcat
Version control
:
SVN, GIT
Operating Systems
:
Windows 2000/XP/7, Linux
Employment History:
Employement1: (Freelancer)
Right now, I am working as Freelancer on Java and Android projects.
Project 1: Hair Saloon
Currently I am working on hair saloon project. In this project I am working on mobile application (android) and web application (java).
Web application is used to manage all the details like:
Admin:
Manage saloons
Manage categories
Manage services
View saloon Gallery
View employees
View appointments
Saloon:
Manage account
Manage working time
Manage galleries
Manage categories for own saloon
Manage services for own saloon
Manage employees
Manage employee time schedule
View appointment
Accept / Reject appointment
Assign appointment to employee
Employee:
Manage account
View appointment
Accept / Reject appointment
View time schedule
These details are passed as services to the mobile application where they are being displayed.
Using android application, users can perform the following task.
View saloon list
View saloon categories and services
View employee’s categories and services (specialization)
View saloon’s time schedule
View employee’s time schedule
Book appointment by services
Book appointment by employees
Search for employee / saloon
Project 2: My City
Currently I am working on my city project. In this project I am working on mobile application (android) and web application (java).
Web application is used to manage all the details like:
Manage hospitals
Manage doctors
Manage medical stores
Manage laboratories
Manage advocates
Manage schools
Manage colleges
Manage hostels
Manage NGOs.
Manage government offices.
These details are passed as services to the mobile application where they are being displayed.
Using android application, users can get all the details about particular city like:
List of hospitals
List of doctors
List of medical stores
List of laboratories
List of advocates
List of schools
List of colleges
List of hostels
List of NGOs.
List of government offices.
Technology: Android, Java, Spring 3.0, Hibernate 3.0, MySQL 6.0, Javascript, JQuery, Ajax, Spring Web services
Project 3: Online Educational Portal
The main goal of this web application to provide the portal where the students and teacher are keep in touch with each other.
There are main three users of this system.
Admin
Manage Board, Medium, Standard, Subject, Chapter and Topic
Enroll and manage teachers
Enroll and manage students
Manage Question Bank for MCQ
Upload previous year’s Question Papers
Set question papers for Exam (Automatically or Manually)
Upload material in Text PDF, Word, Video form.
Teacher
Enroll and manage students
Manage Attendance
Manage Exam
Manage Class Tests
Manage Question Bank for MCQ
Upload previous year’s Question Papers
Set question papers for Exam (Automatically or Manually)
Upload material in Text PDF, Word, Video form.
Upload Assignments
Question answer with students
Student
Download material
Read material online
Watch video online for specific topic, chapter and subject
Download assignments
Ask for any query to respective subject teacher
Practice MCQ subject wise, chapter wise and topic wise. All questions and their options are generated randomly every time.
Practice for real time exam where students have to attend questions in time limit. All questions and their options are generated randomly every time.
View hint for specific question while doing practice.
View Progress report in tabular as well as graphical format.
View Attendance report
Technology: Java, Spring 3.0, Hibernate 3.0, MySQL 6.0, Java Scheduler, Javascript, JQuery, Ajax
Project 4: NGO Social Site
This project is for one NGO (Non Government Organization) who is associated with social work. For that, NGO generate funds by event organization.
Responsibilities:
Developed batch jobs that runs automatically at regular interval for result declaration for different activities like lotto, sweep stack, numbers, prize distribution etc.
Developed batch job for ABA (Australian bankers association) file for transaction management.
Report generation in PDF format for statements and invoices.
Social media integration (Fetch contacts from Gmail and Yahoo.)
Technology: Java, Spring 3.0, Hibernate 3.0, MySQL 6.0, Java Scheduler, Javascript, JQuery, Ajax
Project 5: Offline Educational System (My JEE Exam)
This is the desktop application version of educational portal.
This software is only for students which contains following features. This software comes with inbuilt data (Material and Question Bank).
Read material
Practice MCQ subject wise, chapter wise and topic wise. All questions and their options are generated randomly every time.
Practice for real time exam where students have to attend the questions in time limit. All questions and their options are generated randomly every time.
View Progress report in tabular as well as graphical format.
View hint for specific question while doing practice.
Technology: C#, MS Access 2007
Project 6: Auto Sales Management
This web application is developed for auto sales company. The features are as below:
Vehicle model details management
Stock management
Sales management
Customer details management
Challan and Bill report generation in PDF format
Transaction management
Sales report generation
Technology: Java, Spring 3.0, Hibernate 3.0, MySQL 6.0, Javascript, JQuery, Ajax
Project 7: Parasmani Hospital
This web application is developed for hospital which can manage the following things.
Manage Chief complaint details
Manage Group details for drugs
Manage drugs details
Manage patient details
Manage patient vising history details
Manage treatment details
Prescription generation in pdf format
Technology: Java, Spring 3.0, Hibernate 3.0, MySQL 6.0, Javascript, JQuery, Ajax
Project 8: Om Sai Call Center
This software is developed for call center which manages the following things.
Customer details
Customer call details
Customer payment details
Customer transaction details
Bill generation
Technology: VB 6.0, MS Access 2007
Employement2:
I have worked as an assistant professor in MCA (Master of Computer Application) & BCA (Bachelor of Computer Application) department at "The Mandvi Education Society", Mandvi, Surat from 1- July-2014 to 30-Apr-2015.
I was responsible to teach java and android to MCA students.
I was responsible to teach C, C++ and Java to BCA students.
I give full concentration on theory sessions as well as practical sessions.
Employement3:
I Worked with Ultra InfoTech, Vadodara, Gujarat as a Software Engineer from 1- December 2011 to 30-June-2013
Project 1: PROM (Project Management)
This is the web application which is used to manage projects for different clients.
This system also keep the track of employee attendance by login and log out time.
Project Manager:
Responsible to assign task to employees
Keep the track of work
View and timesheet filled by employee
Approve / Reject the timesheet
View employee attendance
Employee:
View the work assigned by employee
Fill the timesheet at end of the week.
View attendance
Technology: Java, Spring 3.0, Hibernate 3.0, MySQL 6.0, Javascript, JQuery, Ajax
Project 2: Voice of Karaoke
This web application is for one organization that organizes different kinds of events.
Responsibilities: Payment integration
Technology: PHP
Project 3: Shubhlaxmi Bangels
This web application is developed for jewellery shop.
Responsibilities: Payment integration
Technology: PHP
Project 4: Payroll
Features:
Company detail management
Employee detail management
Attendance management
Account management
Leave management
Report generation like PF report, Pay slip, Wage slip in pdf format.
Technology: Java, JavaScript, Jsp, Servlet, MySql 6.0
Project 5: Order management System
Features:
Product management
Quotation management
Inquiry management
Order management
Stock management
Sales report generation in pdf format.
Bill generation in pdf format.
Technology: Java, Swing, MySql, JavaMail
Project 6: Complaint Management System
This is government project which has been developed for Indian citizens where Indian people can make complaint for any problem they are facing (like electricity problem) and appropriate actions based on their rights (like directly solve the problem if he / she is having authority, forward complaint to top level etc.) are to be taken by the authorized people hired by Gujarat government. Indian people can also know the status for the complaint they have made. This system also helps Indian people to give some suggestion and request for some recommendation letters.
Technology: Java, JavaScript, Jsp, Servlet, MySql 6.0
Employement4:
I Worked with TCMT College, Vidhyanagar (Anand), Gujarat as a Visiting Faculty from 26-July-2011 to 30-November-2011
I was hired for Java Theory and Practical.
Certificates:
1.Appreciation certificate for “VCAhha Project”.
2.Certificate of Accomplishment for successful completion of “Agile Methods in Outsourced Projects” held in July 2012.
3.Participation certificate for “Best Programmer Contest” conducted by SEMCOM College during January 2008.
4.Certificate of Excellence for clearing of “Level E1 of TCS competency Test” as a part of TCS and Government of Gujarat joint initiative College to Career Program organized during May 2009.
5.Participation certificate for “Relay Race with C++” event at Prayaas-2008.
6.Participation certificate for “Personality Development Programme” conducted by Globarena and H M Patel Career Development Centre at Charutar Vidya Mandal, Gujarat during 2008-2009.
7.Certification of Excellence for co-ordination of “Idea Generation” activity of the session on Entrepreneurship Development conducted during 2008-2009.
8.Certification of Excellence for getting 1st position in the activity of “Transactional Analysis for Amateurs” conducted during 2009-2010.
Educational Qualifications:
MCA (Master of Computer Application), Sardar Patel University, 2010
BCA (Bachelor of Computer Application), Sardar Patel University, 2007
Personal Details:
Date of Birth
:
11th January 1986
Current Address
:
B/403, Rangam Resicom, Opp. Vhala Resedency. Nr. Shreeji villa3, Ajwa road, Vadodara - 390019
Permanent Address
:
At & Post – Rayam, Ta – Bardoli, Dist – Surat, Gujarat
Nationality
:
Indian
Gender
:
Male
Hobbies
:
Playing Cricket, Listening Music
Marital Status
:
Married
Languages Known
:
English, Hindi, Gujarati.
Declaration:
I, Sunil Agrawal, hereby declare that the above-mentioned information is correct as per my best knowledge and I bear the responsibility for the correctness of the above mentioned particulars.
Date : Agrawal Sunil P.