Sql Server Engineer
Resume:
FORAM SHETH Email: ***************@*****.***
(M): 310-***-****
Professional Summary:
IT Expertise Miscellaneous: Over 4+ years in Web Development and Project
Management.
. Strong knowledge of Enterprise Relationship Planning(ERP),Customer
Relationship Management(CRM)
. Expertise knowledge of ASP.NET
. Familiarity with Java script, AJAX Controls,Webservices,WPF,WCF,XML
. Good experience working with Financial including Brokerage and
Trading.
. Ability to manage multiple tasks works independently and quickly adapt
to new technologies.
Overall experience of 4+ years in Web Development
. Page Life Cycle, Database Connectivity,Threetier Architecture, State
management, Dynamic generate Controls, Dynamically bind the data,
Error Handling
. Use of menu, Site map controls
. Expertise in Gridview, AJAX.
. File Uploading, Manage Folders
. Upload the data from Excel,CSV to Sql Server using SQL Bulk Copy
. Create Store procedures, Separate Business Logic file, Make
application in three tier architecture.
. Make Number of applications using AJAX.
. Using of Ajax Control tool kit and use AJAX controls.
. Apply Style sheet, Web user control, master pages
. Javascripts for validations.
. Publish and Upload the Web site
Technical Skills:
Languages and ASP.Net 2003,2005,2008,Web Services,
Technologies Known: AJAX,VB,C#,C,C++,HTML,Java Script,JQuery,XML, FrontPage
98, Dream weaver, Photoshop,
Flash,Silverlight,WPF,WCF,CSS,APACHE,Drupal,OS Commerce
Database Software MS Access,SQL Server 2000,2005,Oracle 9i,My SQL,TOAD
Known:
Operating System Windows 98/2000/XP,2003,Window 7
known:
Education Background:
B.E.C.E. (4 years Computer Engineering from
S.P.C.E.,Visnagar,Gujarat,India),M.C.P. (Microsoft Certified Professional,2006)
Address:
Apt. 307
6324 W 85 th PL.
Los Angelos, CA 90045
Anagram Stock Broking Ltd. Oct 2007- Jan
2009,Mar 2010 - June 2010
Ideal SMS System Mar
2010 - June 2010
Defination: - Ideal SMS system is developed for IDEAL Company which is
located in vapi near Surat, Gujarat. This Company is for managing the tower
which is using in mobile phone. Daily they use different fuel in the
generator. So fuel management is the core part of the software. So daily
they fill the fuel from petrol pump. They manage it by using fleet card.
The core part about the software is to transfer the SMS into Database.
Role: Analyst, Database Designing, Web Developer.
Technologies: ASP.NET 2008, SQL Server 2005, AJAX, COP (software for
transferring SMS to the database)
Responsibilities:
. The core part about the software is to transfer SMS into database. So
using COP software the SMS will send through mobile. it will also
coping into the database. So in the company all transactions are done
through SMS.suppose engineer wants to fill the fuel in the generator.
Then after filling the fuel he will send SMS to his supervisor so
keywords are fix for different utility.
. So once engineer will SMS to his supervisor. Validations are also
there. so if by mistake user has write wrong key word then he will get
the SMS about wrong key word or whatever error. Also he will get
immediately prompt regarding to success or failure of the SMS.after
sending successfully message the same message will also store in the
local database which is connected through modem.e.g. suppose he wants
purchase the fuel then he will sms like FMS GJF41 GJV3 20 A. means FMS
is key work for fuel management system GJF41 is fleet card name GJV3
is the vehicle number 20 is the qty.so engineer has fill 20 liter fuel
through fleet card GJF41 and his vehicle number is GJV3.so in database
it will store his mobile number which will identify employee, and
created_date and rest all columns.
. In third step that same row will transfer from local machine to web
server. using data management tool. so daily the data will transfer
from local machine to web server.
. Engineer has to fill the fuel through fleet card which is already
allocated to particular petrol pump. so all fleet card is assign to
petrol pump.
. Each engineer has his own fleet card so using that fleet card he can
fill the fuel.
. Engineer has to charge the fleet card regularly.
. So everything will be update into the system.
. Software is also fill the record about tenet, location and tenet
details where the tower is located.
. Another part about the software is control panel. so user can manage
roles,profiles,users through control panel
Telemarketing Software
Jan 2008 - Jan 2009
Defination: - Telemarketing Software is the premier telemarketing software
system for making lots of list-based sales calls and setting appointments
and handles the distribution of leads to all The Designation Employee
(level Wise Distribution) Telemarketing Software specifically designed for
outbound and Inbound Customers.
Role:-Web developer, Analyst, Web designing, Database designing
Responsibilities:
. Developed software for the Tele calling company using ASP.Net 2.0 and
SQL Server 2005.
. Create different type of users like Regional manager (RM), Branch
Manager (BM), Team Leader (TL), Agent, Sales Executives (SE).
. Defining Different Roles and assigning it to the user. So according to
the role only user can access the web form. Roles are different for
different type of user .Super administrator can define the Role and
Assign to the User.
. Lead can be generate and it can be distributed through BM to SE. means
first of all the lead will be distribute to RM.RM can distribute it to
BM.again BM user has to distribute it to different different TL.after
that TL can distribute it to Agent. Now Agent has to follow up the
lead and if needed then he/she can distribute the lead to SE.
. As per the hierarchy user can view the report.RM can view the details
about all the leads under his/her region.BM can view the report about
his/her Branch.TL can get the reports for his/her team. Agent can get
the details about the lead which are assigned to him/her same for SE.
. Agent can follow up on the lead and then he/she can update the status
of lead.
. Comparison Report for all type of users are also generated through the
system.
. Same application is made for AVIVA life Insurance Company.
Mutual Fund MIS Software
Oct 2007 - Dec 2007
Defination: - Mutual Fund MIS is software for storage of Client Information
and fill their application form online. The main modules of this software
is Control Panel, Client Registration, Application Registration
Role:-Web developer, Analyst, Web designing, Database designing
Responsibilities:
. Mutual Fund (MIS) was developed for storing the details about the
Clients and the Mutual fund's Forms. The report can be download from
gridview to CSV file.
. Main modules of MIS were Client Registration, Form Registration and
Control Panel.
. The main users of this software is RM(Regional Manager),BM(Branch
Manager),Agent,SR(Sales Representive).So according to the user the
form will fill.So according to hierarchy the details will fill the
hierarchy goes from RM to SR.
Newtech Infosoft Pvt. Ltd. Mar 2009 - Mar
2010
Professional Tax Handling, Provident Fund Management System, Query
Management System
Dec 2009 - Mar 2010
Defination: Ptax & PF handling software is developed for VPD Consultants
Pvt Ltd. Which is consulting company.This Software is to fetch the
information about PF Balance, Form 13, Nomination Details for different
Company's All Employees. In Professional Tax module Employer has to upload
from excel data into SQL Server. Then after VPD User can runtime generate
Chalan (Particular State's JPG Chalan Image) for different state as well as
text file which contain Employee No., Name, Salary Detail, Proffessional
Tax.in QMS employee can send query to VPD user and VPD user can reply to
this queries. Also make control panel to manage users and their roles.
Role: Analyst, Web Development, Project Leader
Technologies: ASP.NET 2008, SQL Server 2005, AJAX
Responsibilities:
. Create Forms which can display information about Personal Information,
Nomination, Form 13,PF Balance Details of all employees. So each
employee has its own user id and password. So user can view his PF
balance. Employer and VPD user can view all the details about PF and
all of any employee.
. Another Login is For Employer. This type of user has to select state
and City and after that month. for single month or for multiple month.
So that all data will be copied from excel to SQL server. (using
SQLbulkcopy so it will take few minutes to upload thousand or even
lacs of records).Once the data are uploaded automatically Email
notification send to VPD so VPD user can Generate the chalan For
particular City.So from this module Employer can upload the in Salary
details Excel sheet City wise and month wise For All companies all
employees. One unique id will be generated ex.s001_32_322_10_2009
(S001 is company code, 32 is code for state, 322 is Code for City, 10
is Month for October,2009 is year. So it means that employer has
upload salary sheet for Company S001 for 32 state's 322 state for
october, 2009.
. Another Login is For VPD user Who can Generate the Chalan which is
uploaded by Employer. Again VPD user has to select Company, State,
City after that User can view all those IDs which are created by the
Employer whose chalan is till not generated So that VPD user can
generate chalan.(two files are created runtime one is text file which
shows the all details about employee id,employee Name, Salary,Ptax
deducted by Company and Actual Ptax and summary of PTax, another JPEG
file is generated runtime. The file is different as per the state's
law of P Tax. Generally this file contains the details about No of
employee, Salary slab, Amount of Ptax and then finally total amount of
PTax.
. Another feature of the system is Query Management System. In Query
management system the Employee or Employer can generate the Query
after that VPD user can Reply on that Query.
. The whole system is AJAX enabled. All pages contain Update panel and
Script manager. As well AJAX controls are also used in the system.
. Data Management module which can transfer the database from one
location to another location using bulk copy.
. Create different challan for government employee. So online they can
fill the form and also they can get the print out of the form
. Control panel which is main part of the application. So here I am
creating two menus (vertical and horizontal) and according to
horizontal menu's item the vertical menu will display dynamically
which only admin user can use it.
. For different company the role and profile is different.
. So dynamically menu will generate.
Customer Relationship Management (CRM) (Mar 2009-Nov 2009)
Defination :- CRM is Customer Relationship Management consists of the
processes a company uses to track and organize its contacts with its
current and prospective customers.CRM Software is to develop to increase
business. Online. Software Includes the whole cycle from Taking Inquiry
from Prospect to Making Lead And his final status.
Role: Analyst, Database Designing, Web Developer.
Technologies: ASP.NET 2.0, SQL Server 2005, AJAX
Responsibilities:
. Control panel is the heart of the system. The main task is Form
creation, Role management. So core part of the control panel is to
create forms master and then role creation so once role is generated
it will be assigned to user. So according to the Role user can get the
permission.Read,Write,Delete,View,Activate some scheme these are
different permissions. While creating the Role the permissions are
defined. And according to the permission only user can get the details
about particular form.(if x Role is defined to the user y and in x
role suppose he can read the details about z form so y user can read
the details about the form but he cannot edit or delete any records.
. Another feature in control panel is hierarchy of the user's
designation. Runtime the hierarchy will be create.means.Hirarchy can
be different from company by company.
. In all web forms the session is managed, without login user cant
access any page or he cannot visit any web form. If he try to open any
web form then the page will automatically redirect to login form. he
has to enter the details about the login and according to the
permission only he can view or update the details about the form.
. Database stores all the details about the username, datetime, modify
username, modify datetime,deleted by, deleted date time for each
records. So system stores track of all entries.
. One good feature of the system is Task Management. So user can enter
its task as well as he can get the details about the task which he has
to complete. Dashboard is also made in the system. So through the
system user can view the all important task for the period. By default
user can get the remaining task details for the current month's
period. The task are display in order to priority.
. To enhance the business lead management is very important. So through
system the data of lead in excel is uploaded in the SQL server
(Through Column mapping) So either all data will be uploaded or none
of the data will upload. So if once all data get upload after that the
all leads will distribute to the all user of the company (the lead
distributes according to the hierarchy of the user.)
. Before working on the lead first authorized user has to approve it.
Once the lead get approve the user can follow on leads. So status of
the lead(Queue,Success,Fail) will be update.
. In system all utilities are provided that user can directly upload all
the data of master tables (from excel or from CSV file).
. The whole system is in three tier architecture. So Store procedure and
business logics files to manage the code of the system. For
validations Java scripts are used.
Content Management System
Nov 2009 - Dec 2009
Defination: To manage Content and display according to the pages.
Role:-Web Developer, Analyst, Database Designing
Environment:-ASP.Net 2008, SQL Server 2005
Responsibilities:
. Create Course Master and in course add the details about Chapters, in
chapters add details about Pages.
. So if user has purchase the particular course then he/she can View the
details about course.
. Editor control is used to modify the content.
Enucleus Pvt Ltd APR 07 - SEP
07
ERP Pro Software:
Defination: E-procurement for making Purchase online.includes inquiry,Approval Quotation, Generationg Order and Billing System.
Role:-Web Developer
Responsibilities:-
. Convert Desktop Application to Web based Software.
. System was already implement in VB so the system is updated from VB to
ASP.NET
. Make Master Form,Web user control,Business logic,Webforms.
. Use javascripts for all type of validation.
. Convert the code from VB to C#.
Institute Management System
Jan 2005 - Jan 2006
Defination: To setup Complete Solution For AHNT, Which is Institute Of
Hardware and Networking, IMS to manage all the Inquries, Registration,
Follow up, Fees Management, Batch Scheduling
Role: Analyst, Web developer, Web designing, Database designing.
Environment: ASP.NET 1.1, SQL server 2000
Role:-Web Developer
Responsibilities:-
. Coded for masters and transaction forms.
. Generate report
Contact this candidate