VBA Word Programmer

ASHISH GUPTA

Vikas Nagar,Lucknow

Ph:(Mob.) 923-***-****

E-mail:************@*****.***

CAREER SUMMARY

Web Application Developer, Macro Developer, and Project Analyst for e-Learning, E-Testing, User Grievances Management And Handling web applications. Particularly experience in Microsoft Platform tools like ASP.NET, ADO.NET, AJAX.NET, XML for web application development and Macro development using VBA 6.0.

SOFTWARE EXPOSURE

Internet Technologies : ASP.Net 3.5, VB.NET, C#, PHP 5.0, ASP 2.0

Front End Tool : VBA 6.0, VSTO

RDBMS/Back End : SQL Server 2005, MS ACCESS 2003, MY SQL 5.5

PROFESSIONAL QUALIFICATION

B.E.(Electronics & Communication) from M.S.R.I.T.,Bangalore,1998

OBJECTIVE

To work in a creative and challenging environment using cutting edge technologies where I could constantly learn and successfully deliver solutions to problems.

PRESENT JOB

[UPTEC, Lucknow] (From November ‘06 till now)

Working as Systems Officer. Worked on investorhelpline.in and testmate.in websites for high-profile Web Company clientele, with strong emphasis on user-centered design, usability standards, and human factors testing. Currently working on Mailer web application.

Project Title : Mailer (From March '10 till now)

Project Description : Mailer software is for sending bulk email. Personalize any HTML matter like mail merge and email it.

Send personalized email messages to customers from SQL database or Excel worksheet. Also facilitate user to correct and resend wrong email addresses, Pause and resume. It also keeps track of Success, Failed mails, total mails to send.

Technologies Used : ASP.NET 3.5

Team Size and Role : Design and developed alone

Project Title : Authoring Tool (From Jan '09 to Feb ‘10)

Project Description : A Word template for making questionnaires, editing questionnaires for testmate.in website. We first enter questions in word document using tool, made using macros, supported by math writing and Painting applicacations. Then Authoring tool is used for converting document to a form which is compatible with testmate engine.

Technologies Used : VBA 6.0, HTML

Team Size and Role : Design and developed alone

Project Title : Investor Helpline Website (From Jan '08 to Dec '08)

Project Description : “Investor Helpline” is a free of charge dedicated online portal to handle investor grievances administered by different authorities i.e. Ministry of Corporate Affairs, Securities and Exchange Board of India (SEBI) and Reserve Bank of India (RBI) in a focused and sustained manner. It is sponsored by Investor Education and Protection Fund under Ministry of Corporate Affairs (MCA). Right from filing of grievances to tracking status and interaction with administrator has been made online to make it user-friendly.

The primary objective of Investor Helpline is to assist investors- free of charge- in redressal of their grievances. It provides a facility, to the investors, to lodge their grievance on the website itself. Once the grievance is accepted, on-line, Helpline will process, forward and follow-it-up with the concerned entities/authorities for redressal. Registered user would be able to track the progress and status of his/her grievance on the website

It provides a forum where investors can lodge their grievance(s), free of charge, through the internet, for assistance in redressal. “Investor Helpline” is a free of charge dedicated online portal to handle investor grievances administered by different authorities i.e. Ministry of Corporate Affairs, Securities and Exchange Board of India (SEBI) and Reserve Bank of India (RBI) in a focused and sustained manner. It is sponsored by Investor Education and Protection Fund under Ministry of Corporate Affairs (MCA). Right from filing of grievances to tracking status and interaction with administrator has been made online to make it user-friendly.

Technologies Used : ASP.NET 2.0, MS SQL SERVER 2005

Team Size and Role : Three, Developed final stage and testing

URL : http://www.investorhelpline.in

Project Title : Testmate Website (From November '06 to Dec '07)

Project Description : Testmate is a unique testing/assessment tool jointly developed by UPTEC and McGraw-Hill Education India. The services provided at testmate site are primarily focused on assessment and learning for competitive entrance examinations, for graduate and post-graduate courses.

Testmate is based on a powerful dot-net technology based web software engine that makes it surpass the features available in any other engine currently available on the net. Some of its salient features are:

The engine is based on innovative extensions to e-learning standards that include user registration, courseware/test selection, course-attempt planning, attempt and analysis of attempt.

User Registration is absolutely FREE. As a registered user one can also take various Tests that available for demonstration purposes. This is as per TRY before BUY policy of testmate.

Easy schemes for purchasing Practice-Unit Kits for going through paid versions of tests.

Test data contains extensive logic with different difficulty levels, topic priorities and subject priority settings to prepare a dynamically controlled test-session that is most near to the real life examination as set by panel of experts.

Full Length and Unit Testing Modes.

Facilities of setting your own test-plan by changing test-duration and no. of questions.

Automatic Paper Setting with new questions coming in each test-paper.

Large question data-bank created as per ISO-9000-2000 standards.

Test-Session with comfortable navigation and timing facilities.

Detailed Performance Charting of each test-session with Test, Unit and Sub-Unit level performance records.

Performance record details carry informations like questions presented, questions attempted, questions correct, percentage of accuracy and marks.

Graphical and tabulated analysis tools with comparison of scores with own self and with other users.

All performance records of a user are stored on the server till the expiry of user account.

Review of questions presented in a session is available with detailed solutions where ever applicable. Answer keys are always shown in each review session.

Marking pattern of each test is separately adjustable.

Negative marking may also be set if desired.

Marking pattern is settable at each sub-unit level.

Detailed course coverage of each test is displayed.

Test data is maintained at back-end with version control, expiry control and starting date control.

This site provides a lot of practice before a student take the examinations in real life. The services provided at testmate site are primarily focused on assessment and learning for competitive entrance examinations, for graduate and post-graduate courses.

Technologies Used : ASP.NET 2.0, MS SQL SERVER 2005

Team Size and Role : Three, Development and testing

URL : http://www.testmate.in

[MK Groups, Lucknow] (From December ‘05 to Nov ‘06)

Worked as Engineer Web Analyst. Developed www.MKInfosystems.com and www.groupasa.in websites.

Project Title : Group ASA Corporate Website (From December '05 to Nov '06)

Technologies Used : ASP 2.0, MS Access 2000

URL : http://www.groupasa.in

Project Title : M. K. Info Systems Corporate Website (From December '05 to Nov '06)

Technologies Used : ASP 2.0, MS Access 2000

URL : http://www.mkinfosystems.com

[Media Masters, Lucknow] (From Jan ‘05 to December ‘05)

Worked as Web Developer.

Project Title : Shopping Cart For www.JuneJacobs.com (From Jan '05 to December '05)

Technologies Used : ASP 2.0, MS Access 2000

URL : http://www.JuneJacobs.com

Project Title : Greater East Texas Chamber of Commerce (From Jan '05 to December '05)

Project Description : The Greater East Texas Chamber of Commerce develops a network of business, civic, governmental, and non-profit entities in order to promote community, growth, commerce and tourism for the East Texas region

Technologies Used : PHP 5.0, Mysql 5.5

[Amartech Convergence, Lucknow] (From Feb ‘04 to Dec ‘04)

Worked as Web Developer.

Project Title : Help Desk (From Feb '04 to May '04)

Project Description : This website is ticket based helpdesk for a software. New tickets can be

Posted, tracked, closed based on problems.

Technologies Used : ASP 2.0, MS Access 2000

Project Title : AmarJobs (From May '04 to Dec '04)

Project Description : This website is a Job Portal

Software Used : ASP 2.0, MS Access 2000

[Times computing Inc.] (From April,02 to Feb,04)

Worked with study center of sikkim manipal University, Times computing Inc as a instructor to MIT,BIT students.

[Information Systems & Solutions India (P) Ltd. (ISSI), Lucknow.] (From September,1999 to April,02)

Worked as a Programmer in the India Office of an American Company, Information Systems & Services Incorporated (ISSI), Maryland, USA .

Project Title : Appraisal System (From Mar,2000 to Jan,2001)

Project Description : Fully functional Web based application which allows Online Examination and

management of Question bank.

Technologies Used : ASP 2.0, VBScript, JavaScript, HTML, SQL Server

Project Title : Web site for OSAW Agro industries (From Jan,2001 to Mar,2001)

Project Description : An interactive Web site for OSAW Agro industries, one of

client’s in the domestic market.

Technologies Used : ASP 2.0, VBScript, JavaScript

URL : http://www.agrosaw.com/

Project Title : Information Systems & Solutions India Ltd Corporate Website (From Mar,2001 to June,2001)

Technologies Used : ASP 2.0, VBScript, JavaScript

URL : http://www.issiindia.com/

Project Title : Ref-Search (From September,1999 to Mar,2000)

Project Description : Application in VFP, which allows search on

various Scientific Papers published in Science Journals and Magazines.

Software Used : VFP.

Project Title : Project Management System (From Mar,2001 to June,2001)

Project Description : Fully functional Web based application which allows management of tasks and

generates management reports.

Technologies Used : ASP 2.0, VBScript, JavaScript

Project Title : World Trade Systems (From June,2001 to Apr,2002)

Project Description : World trade systems provide international trading companies with documentation needed for export customs clearance in the seller's country ,import customs clearance in the buyer's country and multiple mode(air,sea,ground) and multiple route leg shipment from seller's warehouse to buyer's warehouse.WTS supports batch and interactive interfaces to the seller's and or buyers Enterprise business system.

Technologies Used : JSP, JavaScript

URL : www.worldtradesystems.com

BACKGROUND SUMMARY

A self motivated individual with convincing communication skills, immense organizational capabilities and an ability to establish inter-personal relationship.

PERSONAL DETAILS

Gender : Male

Nationality : Indian

Contact No : 923-***-****

Language Known : Hindi and English

(Ashish Gupta)

Contact this candidate