pratap kumar somala (somala_pratap@yahoo.co.in)'s Ryze Business Networking Page

S Pratap Kumar

E-mail: pratapkumaronnet At yahoo.com

Mobile: +91-9986024944

Summary:

� Having total 6 years of IT experience in development of Windows and web applications using Microsoft Technologies.

� Proficient in programming using .NET Technologies (ASP.NET, VB.NET, C#, LINQ and ADO.NET).

� Hands of Experience in Visual Basic, ASP, Crystal Reports, SQL Server, Ms Access, Oracle and My SQL.

� Good experience in developing Web services using vb.net and C#.

� Good domain knowledge in fields of Finance, Shipping & Transport System.

� Good Analytical and Programming skills.

� Good interpersonal and communication skills, commitment, result oriented, hardworking with a quest and zeal to learn new technologies and undertake challenging tasks.

Educational Qualifications:

Master of Computer Applications from SPIRTS College, Kadapa Affiliated to Sri Venkateswara University in the year Jun 2004

Technical Skills:

Operating System : Windows XP, Windows 2000, Windows 95/98

Microsoft Technologies : Visual Basic, ASP, .Net Frame work

Databases : Oracle, My SQL, SQL Server

Web Servers : IIS 6.0 / PWS

Web Tools and Technologies: Visual Interdev, HTML, XML, ASP.NET

Reporting Tools : Crystal Reports 8.5/ 9

Other Skills and Interests:

Functional : Transport System, Finance, and Inventory

General : Good Analysis and Designing Skills

Interested Areas : Application Development using Web and Client

Server technologies, extracting data from websites.

Work Profile:

Working with Proactive Infosys India Pvt Ltd, Hyderabad as a Project Technical Manager since July 2008 to till date.

Worked with Nandaki Systems, Bangalore as a Senior Solutions Developer since Sep 2006 to June 2008

Worked with Merit Info Solutions Pvt. LTD, Hyderabad as a Software Engineer from Feb 2004 to Sep 2006.

Project Details:

Project # 0: JH Illustration System

Employer: Proactive Infosys India, Hyderabad

Client: John Hancock Life Insurance Company , (U.S.A.).

Role: Technical Manager

Software: VB.NET, SQL server.

Duration: July 2008�Till Date

Description:

JH Illustrator is a system designed to illustrate insurance products and employee benefit plan concepts. There are around some hundreds of insurance products for marketing. The main aim of this system is to develop a product which will illustrate all there competitive products and employee benefit plan concepts to the customers.

Responsibilities and Tasks Performed

Designing and Developing of Application Framework.
Creating xml file formats depends on the requirement.
Preparing the project plan, UML Diagrams.
Preparing documentation.

Project # 1: Nike ERA

Employer: Nandaki Systems, Bangalore

Client: Maersk Logistics, Netherlands.

Role: Team Member

Software: HTML, ASP.NET, VB.NET, C#, SQL server.

Duration: July 2007�June 2008

Description:

Maersk Logistics has a couple of reports that require feedback from the origins. Instead of sending the raw data to the origins on a weekly basis for feedback, they would like them to start pro-actively reporting �exceptions� in some kind of web based application. The application will provide a web-based interface to view the data allows users in the origins to mark bookings and assign exceptions to them.

Responsibilities and Tasks Performed

Designing and Developing of Application Framework.
Developing Import Module.
Developing web services.
Database Designing and optimization.

� Enhancements Analysis, System design and testing

Project # 2: COWA

Employer: Nandaki Systems, Bangalore

Client: Maersk Line, Netherlands.

Role: Team Member

Software: HTML, ASP.NET, VB.NET, C#, SQL server.

Duration: Sep 2006�Jun 2007

Description:

The system will be web-based Multi Tire Application and developed with using Microsoft .NET framework. These systems will automat all the activities of CEU. It has Two Modules 1) Shipping System, 2) E-Leave

1) Shipping System: When a vessel arrives at a port or is about to arrive, there are a number of tasks that are to be executed by OPS staff. This application will have pro forma task lists per port per service code. The port call will be uploaded from the GSIS system and the supervisors assign the tasks to individual users. Users work on the task and then close the tasks upon completion, optionally entering additional information like number of containers, telex reference and any comments.

2) E-Leave: e-Leave application keeps track of vacation taken by CEU employees in a calendar year and provides necessary reports to HR and Payroll departments. Provide a simple and central mechanism to request and approve vacation. Provide accurate up to the date information to employees on their vacation.

Responsibilities and Tasks Performed

Designing and coding of webpage�s.
Developing web services to import data from Global systems and HRMS System.
Designing the database and optimization.
Handling the Change requests.

Project # 3: Housebrix.com (Real Estate / property Management System)

Employer: Merit Info Solutions (P) Ltd. Hyderabad

Client: Sandee, california real estate broker, USA

Role: Team Member

Software: HTML, ASP.NET, C#, SQL server.

Duration: June 2006�Sep 2006

Description:

Housebrix.com is an online Property / Real estate website to make the home-buying and home-selling process more open and informed, less costly, and more internet oriented. The goal is to expand market reach by giving seller service and support to every customer. This website has two modules Admin Module where the admin can Insert/delete/modify all ads, have option to let ads go through free or to payment page, have details of users and agents when registered emailed to admin, Have an option of sending comments to users. Second module is the user module where a seller or buyer can login into website and search for homes and properties. A user can describe his property / home. A user can upload and download the documents which are sent the admin.

Responsibilities and Tasks Performed

� Preparation of Technical Design Document.

� Preparation of Process flow, code schedule.

� Coding and Development.

� Database creation and optimization.

Project # 4: ischooltest.com (Learning Management System)

Employer: Merit Info Solutions (P) Ltd. Hyderabad

Client: Marcus, USA

Role: Team Member

Software: HTML, ASP.NET, VB.NET, SQL server.

Duration: Jan 2006� May 2006

Description:

Ischooltest.com is an online place for students to practice for their state administered Exit, Assessment, and End-of-Course Test; in the subject areas of mathematics, science, reading, writing, history, English, and social studies. This website has three types of users. Parent User, Student User, and Admin Student can login into website and take test by select subject and state. After completion of test he will get certificate with his name. Parent users related to student who can pay the fees for student. He is having separate account for login into website and knows his children�s test performance. Admin can change user permission depending on the payment.

Responsibilities and Tasks Performed

Designing and coding web pages for Student module.
Generating Reports and creating custom Controls.
Database designing.

Project # 5: AnAppointment.com

Employer: Merit Info Solutions (P) Ltd. Hyderabad

Role: Team Member

Software: HTML, ASP.NET, VB.NET, My SQL

Duration: Jun 2005� Dec 2005

Description:

The project is being developed for the purpose of the Doctor and Patients interaction through a website. It will reduce the time for Doctors and patient by searching and taking appointment in the internet. Doctor�s and Patient�s register with in website. Doctor�s can View, Create, Edit and Cancel Appointments, creating time slots, Locations, Available dates and Timings. Patient�s can view the available dates & timings of Doctors and create an appointment between Doctor and Patient. Once the Patient creates an appointment with a doctor, the appointment details have been sent to both doctor and patient�s mail-id. Patients can also View, Create and Cancel Appointments.

Responsibilities and Tasks Performed

Designing and coding web pages.
Database design.
Preparing the technical document.
Unit testing of the WebPages.

Project # 6: Www.Greatlakessoil.com (GLSEC)

Employer: Merit Info Solutions (P). Ltd.

Client: Great Lakes Soil & Environmental Consultants, Inc. USA

Role: Team Member

Software: ASP, HTML, DHTML, VB Script, Java Script, My SQL

Duration: Mar 2005- May 2005

Description:

Great Lakes Soil & Environmental Consultants, Inc. (GLSEC) provides comprehensive field & laboratory testing and consulting services in the areas of geotechnical, materials and geo-environmental engineering. This website is created to automat all the activities of Great Lakes. It has 7 modules like Projects for post, Projects for report, Employee login, Client login etc. Employees (Admin) can upload projects. This Website is developed for maintaining Employees, Clients, and Projects. All Employees can do the projects and upload into server with reports. Each employee is having some permission like creations new projects, Deleting or updating existing projects. The client is having permission to download reports. Each client and employee is having their own id and password. The client can login into the Website and downloads the projects.

Responsibilities and Tasks Performed

Designing of static web pages.
Designing and Coding for web pages.
Unit testing of the WebPages.

Project # 7: Contact Management system (Clinic and Drug Laboratory)

Employer: Merit Info Solutions (P). Ltd.

Client: Nolster Clinic, USA

Role: Team Member

Software: VB.NET, MS Access.

Duration: July 2004 � Feb 2005

Description:

This project is One of the recruiting processes is to examine the applicant�s physics. In medical terms we call the applicant, a subject. During this process the applicants would be assigned to various clinics across the nation (In US). Each subject is assigned a medical and drug screen collection. Both these actions can take place at different locations or at the same location. During this process, the subject would be communicated via mails and telephone calls that have to be served in the database with a time stamp.

This project involves three modules. One is Master Module used to create new information about the clinics, applicant /Contact information, Carrier information and Contact type, etc. Second Module is Transaction Module, Used to Maintain the Clinic lab Day-to-day Transactions. Transactions like Assigning Clinic to applicant, what are the tests performed by that clinic, how much fees, etc. The fees Collections and generating invoice for each applicant depends on the health source. This information Maintained in transactions Module Reports are generated to show the day-to-day transactions date wise, clinic wise.

Responsibilities and Tasks Performed

Designing , Coding of all modules
Generating reports using crystal reports.

Project # 8: Complete Transport Solutions

Employer: Merit Info Solutions (P) Ltd. Hyderabad

Client: Global Transport Ltd. Hyderabad

Role: Team Member

Software: Visual Basic 6.0, Oracle, Crystal Reports

Duration: Feb 2004� June 2004

Developed for Transport Agencies with over �N� no. of branches all over India the automation covers Freight Management System (FMS), Financial Management System (FIMS), Fleet Management System (FTMS) and Inter Branch Connectivity (IBC). The FMS, FTMS are interlinked dynamically with FIMS and IBC. The related data transfer from one branch to the other and to the head office is the core theme of the project. There are over 70 reports generated on the request of user.

Responsibilities and Tasks Performed

Involved in development of Freight, Fleet, Finance modules and respective reports
Involved in development of inter linking of all the modules.

Pratap Kumar Somala