Jump to content


Sushil Agrawal

Member Since 21 Nov 2006
Offline Last Active Oct 20 2010 07:28 PM
-----

About Me

Sushilkumar S. Agrawal (MCA)
Contact No.: +91 9970014983
E-mail Id.: sushil.Agrawal@yahoo.com

Objective: Providing quality solutions to complex business problems within scope, budget and tight schedules. Extensive experience in programming, databases and IT support, technical communication. Flexible as regards moving from project to project and in assimilating new technologies. Proven team leadership skills. Now looking to continue making a significant contribution within design and development / leading a technical team or consultancy role on interim basis or permanent management position.

Summary:
· 6 + years experience in Software Development (Application Development + Implementation).
· I have completed MCA and B.Sc. (Computer Science) and good knowledge of VB, SQL Server (PL/SQL, SSIS, SSRS, SSAS), .Net (VB.NET, C#.NET, ADO.NET, ASP.NET), MS Office (VBA) and Crystal Report.
· Have strong problem solving skills, analytical study of the problems and ability to quick learn new technologies.

Present Pursuit: Working as Sr. Software Engineer for AryaOmnitalk Wireless Solutions Pvt. Ltd., Pune since Jul-06. Here I am working on VB, VBA, SQL Server (T-SQL, SSIS, SSRS, SSAS), Crystal report, .Net (C#, VB, ADO, ASP), etc.

<h1 style="text-align: justify;">Technical Skills: -</h1>
Operating Systems : MS-Dos, Windows (9X/NT/2K)
Languages : Visual Basic, VB.Net, C#.Net
Database : MS SQL Server, Ms-Access, Oracle (PL/SQL), and FoxPro
Web technology : ASP. Net, VBScript, ASP, and JavaScript
Others : Crystal Report, MSOffice, Hardware Troubleshooting.
Concept Known : Design & Analysis of Algorithms, Principle of Management & MIS, Database Management Techniques, Managerial Economics, Software Project Management.

Work Experience:

1. Organization: Arya Omnitalk Wireless Solutions Pvt. Ltd., Pune

Arya Omnitalk Wireless Solutions Private Limited, which operates under MPower brand, is a jointly promoted company by the J M Baxi Group and the Lalbhai Group. Today, Arya Omnitalk is the largest Public Mobile Radio Trunking service provider of the country with coverage footprint in 10 cities, including all metropolitan cities. Arya Omnitalk has also pioneered Mobile Data Solutions as part of their vision to become India's most respected Mobile Resource Management outfit, driving the productivity frontier forward in Taxi fleet management, cash transportation and logistics of large scale people transportation within and across cities. All solutions work on multiple wireless backbones such as GPRS, GSM, Radio & Mobitex, giving customers the freedom to choose the most efficient medium. Fleet Vigil is Arya Omnitalk web solution, which is offering complete Internet based vehicle tracking & fleet management solution from www.fleetvigil.com. Auto Router is Arya Omnitalk's routing solution that enables planning and managing shortest path based Pick up and Drop sequence, Chinese postman logic based collection etc



Designation: Sr. Software Engineer (Jul 06 – Till Date)



v Online Vehicle Tracking and Billing System for BMTC.

Client

BMTC (Bangalore Metropolitan Transport Corporation) Bangalore.

Technologies Used

VB.Net, XML, SOAP, ASP Map, Map Object, Visual Basic. SQL Server (T-SQL, SSIS, SSRS, SSAS), Crystal Report, MS Office (VBA).

My Role

Development, Implementation, maintenance and support. / Team size : 5

Details

This project was developed for the specific needs of the Bus Transport Business for BMTC, Bangalore. This project provided facilities for online tracking of Bus's on a digitized map (Using GPS, GIS information), trip generation, trip dispatch, trip accounting, billing, SMS sent as per SMS received, Daily automatic mail sending facility and various vehicle tracking reports etc needed for the Transport Business.

Team

1. Hardware Team

2. Service Team

3. Web Team

4. Standalone Report / Server Team

System

· Report Generation System

· Communicator System

· Database Maintenance System





v Auto router System

Client

1. IBM, Bangalore (KA)

2. IBM, Hyderabad (AP)

Technologies Used

VB.Net, Visual Basic. SQL Server, Crystal Report, MS Office (VBA).

My Role

Design, Development and Implementation. / Team size : 3

Details

Auto Router is Arya Omnitalk's routing solution that enables planning and managing shortest path based Pick up and Drop sequence, Chinese postman logic based collection etc…


v PIS (Passenger Information System)

Client

1. ICTSL, Indore (MP)

2. PMPML, Pune (MH)

3. Prasana Travels (ECO BUS), Jalgaon (MH)

4. GHMC, Hyderabad (AP)

Technologies Used

C#.net, VB.Net, ASP.net, XML, SOAP, ASP Map, Map Object, Visual Basic. SQL Server (T-SQL, SSIS, SSRS, SSAS), Crystal Report, MS Office (VBA).

My Role

Design, Development and Implementation. / Team size : 3

Details

Passenger Information System is providing the information of bus arriving time on the bus stop whenever the digital display installed. ETC..



2. Organization: Prosys Infotech Pvt. Ltd., Pune

Designation: Sr. Programmer (Jun 05 - Jul 06)



v CONWOOD (Real Estate System)

Client

Dynamix Groups of Companies, Mumbai.

Technologies Used

VB.Net, SQL Server, Crystal Report

My Role

Design, Development and Implementation. / Team size : 5

Details

It is use for the real estate organization, to communicate with the client for reminder of payments, to generate the letter through the system, to send the due letters, client statements, reminder to company for the over dues, outstanding of amounts with or without interest rate calculation, status of inventory project wise. It also generates various types of reports and pivots for the analysis.

v E-MIS (Management Information System for Finance Department.)

Client

· TATA Power, Mumbai.

· Honeywell Automation (India) Pvt. Ltd. Pune.

· Alfa Laval, Pune.

Technologies Used

VB, VBA (MS Access, Excel), SQL Server.

My Role

Development / Team size : 3

Details

This software consists of different functionality like taking data from SAP or other application software and converts into required format, then generates the pivots, which are very useful to the management. Its mainly use for the finance department to analysis the database of organization. These works was done for the above clients.

v ERP

Duration

12 Month

Client

· New Ball Bearing Company Pvt. Ltd., Pune.

· Blue Bird (India) Pvt. Ltd., Pune

· Joshi Hospital, Pune

· Ratna Hospital, Pune

Technologies Used

VB, SQL Server, Crystal Report.

My Role

Development / Team size : 5

Details

It is developed for small, medium scale organization. It covers different modules like sales, purchase, inventory, accounts and etc… In this I have contributed in modification of certain programs and report like customer order entry, purchase order entry, GRN entry and etc…









v Time Sheet

Client

Global Sourcing Group, Pune

Technologies Used

ASP, SQL Server.

My Role

Development and Implementation / Team size : 1

Details

It is used for recording the In, Out time of the employees, and it maintains working hours of assign task to the person. As per the working hours system generate the bill of the employee wise particular task wise.

v BG (Bank Guarantee)

Client

Honeywell Automation (India) Pvt. Ltd. Pune.

Technologies Used

ASP, MS Access, SQL Server.

My Role

Development and Implementation / Team size : 1

Details

This software consists of maintaining the records, documentation of Bank Guarantees issue by the company to the clients. It generates different type of reports such as expiry, issue, renewal of BG and etc… It has functionality to communicate with the client, bank through email and maintaining the documents as per the client files. It reduced the work of maintaining the physical file of the BG's and its document.

v Tools Developed



Vertical Form



Text Mode Printing through Crystal Report (Any Printer Print the Report)



3. Organization: G-Tech India, Pune

Designation: Software Developer (Feb 03 – May 05)



v Corona System

Duration

Dec 2004 – May 2005

Client

Corona System Ltd, Pune, India.

Technologies Used

VB, MS Access, Crystal Reports

My Role

Development and Implementation / Team size : 2

Details

This system contain Weight Bridge, Bank reconciliation, Payroll, Sales and Service, Purchase, Transports, Financial accounting & Inventory module. This system developed using Com, ActiveX controls. Generate various type of Report using Data Report, Crystal Report for the management. In Weight Bridge module computer is interface with the weight Bridge machine its function is to pass variable and get weight from the machine.

v Leather World (Bar Code) System

Duration

Aug 2004 – Dec 2004

Client

Leather World, Pune, India

Technologies Used

VB, MS Access, Crystal Reports

My Role

Development and Implementation / Team size : 1

Detail

This is barcode system use for the leather world, Pune. It maintain over all inventory of the shop as will as financial accounting. This system uses the barcode reader for reading the barcode. This system developed by using Com, ActiveX, MS Flex Grid controls

v Technovision System

Duration

Jan 2004 – Jan 2005

Client

Technovision Energy Pvt. Ltd, Pune, India.

Technologies Used

VB, SQL Server, Crystal Reports.

My Role

Development and Implementation / Team size : 2

Details

This system contains payroll, job distribution, job out as well as efficiency of the employee etc…. This system developed by using Com, ActiveX, MS Flex Grid controls.






v Austin Health Care System

Duration

July - Dec 2003

Client

M/s. Austin Health care, Pune, India.

Technologies Used

VB, MS Access, Crystal Reports

My Role

Team Member / Team size : 1

Details

This is the financial accounting software, developed for maintaining the accounts as well as inventory system details. This system keeps the detailed information of medicines present status of stock with its expiry date, Contractors, Suppliers, items, sites, jobs and others. The system records the Transaction about Jobs, Purchase Order, Goods Receipt Note, Purchase order Bills, Payments, Journal Entries etc. Generates the various reports including, Purchase order bills, Trial Balance and Ledger Report.

v Inventory & Accounting System

Duration

Feb – June 2003

Client

· M/s. Sanjaykumar Rasiklal & Company, Pune, India.

· M/s. Om Distributors, Pune.

· M/s Nandal Dairy Farm, Pune, India

Technologies Used

VB, MS Access, Crystal Reports

My Role

Team Member / Team size : 3

Details

This is the financial accounting software, developed for maintaining the accounts details. This system keeps the detailed information of Contractors, Suppliers, items, sites, jobs and others. The system records the Transaction about Jobs, Requisition, Purchase Order, Goods Receipt Note, Purchase order Bills, Payments, Journal Entries etc. Generates the various reports including Requisition, Purchase order bills, Trial Balance and Ledger Report.



4. Organization: M/s. Vardhan Syntex, MIDC, Khamgaon-444303

Designation: Software Developer (Sep 01 – Dec 02)



v AUTOMATION IN STORES DEPT. & TIME OFFICE

Duration

Sep 2001 – Dec 2002

Technologies Used

VB, SQL Server, Crystal Reports, MSOffice

My Role

Team Member / Team size : 3

Details

This system is developed online for one of the famous Textile industry in Maharashtra state, "Vardhan Syntex, Khamgaon". This project is mainly developed for the accounts, sales, purchase, and payroll system. It's was client/server window base application This software was very user friendly and interactive interface to the users. By using ActiveX controls like Tab Controls, MS Flex Grids etc.



Projects / Seminars: -



Seminars: - Presented a seminar on "ASP" in year 2000

- Presented a seminar on "CORBA" in year 2001

Projects:

Sr.No.

Project Name

Client/Institute Name

1.

PHARMACY MANAGEMENT (INVENTORY)

SYSTEM (Project done using the Visual Basic as front end and MS Access as Database, Crystal Report)

Renuka Medical, Nagpur / G.H.R.I.I.T. Nagpur

2.

LIBRARY MANAGEMENT SYSTEM

(Project done using the Visual Basic as front end and Oracle as Backend, , Crystal Report)

G.H.R.I.I.T. Nagpur




Project done using the Foxpro
3.

SHARES AND DEBENTURS

Mr. Pravin Pulliwar, Nagpur / G.H.R.I.I.T. Nagpur

4.

TRAVEL'S SYSTEM

Pratik Travels Khamgaon

5.

EDUCATIONAL INSTITUTE AUTOMATION

Computer Wing, Khamgaon

Personal Details: -
Date of Birth : 5th October 1976
Marital Status : Married
Languages Known : Hindi, English, Marathi
Hobbies : Chess, Photography, Sport

<h1 style="text-align: justify;"> </h1> <h1 style="text-align: justify;">Academic Qualification: -</h1>

Course

Institute & University

Year Of Passing

  • M. C. A.

G. H. Raisoni Institute of Information Technology Nagpur,

Nagpur University

Sep' 2002

  • B.Sc.

(Comp. Sci.)

G. S. Science, Arts & Comm. College Khamgaon,

Amravati University

Oct' 1998



Extra Curricular Activities: -

* Member of College Handball team (B.Sc.) and played inter college Amravati University tournament.
* Candidate of NCC 13th Maharashtra Battalion, Khamgaon and attended it's camps (B.Sc.).
* Member of organizing team for various activities in college gathering in the yr. 2001-2002 (MCA).
* Organized class tour for South India in Feb-02 (MCA).

Yours Sincerely
S. S. Agrawal
Pune.

Community Stats


  • Group Members
  • Active Posts 0
  • Profile Views 547
  • Member Title Newbie
  • Age 37 years old
  • Birthday October 5, 1976
  • Gender
    Male Male
  • Location
    Pune
  • Interests
    Make Friends

Contact Information


0 Neutral

User Tools

Friends

Sushil Agrawal hasn't added any friends yet.

Latest Visitors

  • Photo
    Guest
    04 Jan 2013 - 04:20
  • Photo
    Guest
    03 Jan 2013 - 02:19
  • Photo
    Guest
    21 Dec 2012 - 10:31
  • Photo
    Guest
    13 Dec 2012 - 06:37
  • Photo
    Guest
    11 Dec 2012 - 09:25