Profile

User Profile

Sachin Agarwal
Born : 19th July, 1976 ___________________________________________________________

Work Experience
Consultant - Consoftra, Lucknow Nov 2003 – Till date
Ÿ Job involves conducting IT training / developing softwares.
Ÿ It also involves selling life insurance products/mutual funds.
Project
Ÿ MLM System in ASP / SQL Server
No. of people : 3
Client : Digital Solution, Lucknow.
Environment : Windows 2000 / ASP / SQL Server 7
Description : This project is an online accounting system common for a Network
Marketing Company. Functionalities include tree structure of the
network, record keeping of individual clients along with their company
pool, amount statement, payment outstanding, royalty & binary income
calculations presented in a report format.
Responsibilities : System Analysis, Database design and developed some functionalities.

Financial Advisor, AVIVA Life Insurance Company Ltd., Lucknow Nov 2002- May 2003
Ÿ It also involved selling life insurance products.
Ÿ It also required generation of MIS reports and devising marketing strategies.

Software Engineer March 2001-July 2001
PrismSoft Technologies (I) Pvt Ltd, Bhopal (division of PrismSoft Inc., USA)
Ÿ Job involved completing the entire SDLC of US based projects in Java & ASP.
Ÿ It also involved handling operations of the Indian office at Bhopal.
Project
Ÿ Timesheet Application in Java Servlets & JSP
No. of people : 2
Client : PrismSoft Inc, Arizona, USA
Environment : RH Linux 7.0 / JDK1.2 / Tomcat 3.2.1/ MySql
Description : This project is an Employee performance & Project tracking system.
The Manager assigns tasks to the employees who in turn work on
them and fill up their timesheet daily by recording the number of hours
worked, comments and the task status per task. The Employee can
also enter his holiday, sick & vacation status, view tasks assigned for
the current week and the status of the previously submitted
timesheets. The Manager views, approves the timesheet and also can
query a particular Employee or Task status.
Responsibilities : Analysis of the entire project
Configuring the Tomcat server to work with Apache on Linux
Developing the Employee and the manager interfaces with all the
above functionalities.


Chief Course Consultant April 2000-Feb 2001
Sun Infoways Ltd., Lucknow
Ÿ The job involved software development and imparting corporate training on Java, HTML,
JavaScript, VBScript, ASP, SQL, XML & WAP.
Ÿ Trained Corporate batches of Telco & Sahara, Lucknow on Web Technologies.







Technical Skills
Operating System DOS, Windows 95/98, SCO Unix Release V, RH Linux 7.0
Languages/ Scripts C, PL/SQL, Unix shell script, HTML, Java(JDBC, Beans, Servlets,JSP), XML,
WML, JavaScript, VBScript, ASP, WMLScript
RDBMS MS-Foxpro 2.6, Oracle 7, SQL Server 7.0, MySql 3.23.32
Internet Tools Dreamweaver 3.0, Photoshop 5.5, MS-Frontpage 2000
Web Servers JWS 2.0, PWS, IIS 4.0, Tomcat 3.2.1
Concepts Structured System Analysis & Design, Networking, WAP, ERP


Other Software Projects
The following projects were developed while undergoing training at Computer institutes specified along with the projects.

Ÿ Data Management System in Java
No. of people : 2
Institute : Asset International, Lucknow.
Environment : Windows NT / JDK1.2 / MS-Access
Description : This project involved the application of Networking & JDBC.
The client connects to the server, updates database and sends queries
to get the desired output which could then be saved or presented in a report format.
Responsibilities : Network programming using JDBC/ Developing the client/server GUI.

Ÿ Personnel Information System in Foxpro
No. of people : 2
Institute : Tata Infotech, Lucknow
Environment : Windows 95 / Foxpro 2.5
Description : This project involved computerizing the Student Inquiry handling,
Fee handling, Course handling & Report generation operations of
TULEC, Lucknow.
Responsibilities : Developing the student inquiry / fee handling module & the main menu.

Ÿ Information System in Oracle
No. of people : 3
Institute : Tata Infotech, Lucknow
Environment : Unix / Oracle 7
Description : This project is similar to the one made in Foxpro .
Responsibilities : Creation of SQL forms using triggers & report generation.


Educational Accomplishments

Ÿ Post Graduate Diploma in Business Administration (PGDBA 1998-2000) from Jaipuria Institute of Management,
Lucknow in April 2000 with 75% marks. Specialisation in Information Systems & Marketing. Gold Medallist in the
Information Systems discipline of the PGDBA program.
Ÿ Certificate course on Java from Asset International , Lucknow ( Jan-March 2000).
Ÿ Diploma in Professional Business Computing - Tata Infotech Ltd. ( TULEC ), Lucknow in July 1998 with Grade C
Ÿ B.Sc (1994-97) from Lucknow University in Mathematics, Statistics & Physics with 65% marks

Buyer Activity

Provider Activity