Pratap Kumar Somala

E-mail: pratapkumaronnet at yahoo.com

Mobile: +91-9000510761

 

Summary:

 

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

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

q  Hands of Experience in Visual Basic 6.0, ASP, JavaScript, Crystal Reports, SQL Server, MS Access, Oracle and My SQL.

q  Hands of experience in Designing, Developing, Implementing and Maintaining of the Projects.

q  Hands of experience in Database Design.

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

q  Good Knowledge in WPF, WCF.

q  Experience in converting business requirements into technical specifications.

q  Excellent team player with problem-solving and trouble-shooting capabilities and ability to interface with all levels of management.

q  Exceptional ability to learn new concepts.

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

q  Good Analytical and Programming skills.

q  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 (Application) SKILLS

 

OTHER SKILS AND INTERESTS:

 

Functional : Transport System, Finance, Insurance and Inventory

General : Good Analysis and Designing Skills

Interested Areas : Application Development using Web and Client

Server technologies, extracting data from websites.

PROFESSIONAL EXPERIENCE

SUMMARY OF PROJECTS:

 

Project # 0: MGP (Manulife Global Protector)

Employer: Proactive Infosys India, Hyderabad

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

Role: Technical Manager

Software: VB.NET, ASP.NET, JavaScript, SQL server & MS Access, LINQ, Active Reports 3.0

Duration: Feb 2009–Till Date

 

Description:

MGP is a web & Desktop application for the agents of John Hancock insurance and financial services to assist their prospective insurers in the purchasing process of an insurance product. This application presents a variety of insurance products, accept user input for premium calculation and print reports. Tools Developed for this Product:

 

1)    Authorization Code Generator

2)    System Compiler

3)    Database Updater

4)    Rates Editor

5)    Snap Shot Application

6)    MI Omni Tester

 

Responsibilities and Tasks Performed

q  Design and Development of MGP system.

q  Database designing to accept multiple products.

q  Designing and implementing the rates Database and XML files.

q  Designing and developing the application for Web and Desktop application for multiple insurance products.

q  Preparing the project plan and work allocation.

q  Preparing the Technical documentation.

q  Designed and developed the application tools for system maintenance & testing.

q  Conducting Status Meetings.

 

Project # 1: JH Illustration System

Employer: Proactive Infosys India, Hyderabad

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

Role: Technical Manager

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

Duration: July 2008–Jan 2009

 

Description:

JH Illustrator is a web based 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

q  Designed and Developed of Application framework.

q  Database designing.

q  Created xml file formats depends on the requirement.

q  Prepared the project plan and work allocation.

q  Prepared the Technical documentation.

q  Status meetings.

Project # 2: Nike ERA

Employer: Nandaki Systems, Bangalore

Client: Maersk Logistics, Netherlands.

Role: Team Member

Software: HTML, ASP.NET, VB.NET, JavaScript, 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

q  Designed and Developed of Application Framework.

q  Developed Import Module.

q  Developed web services.

q  Database Designing and optimization.

q  Enhancements Analysis, System design and testing

 

Project # 3: 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 is a 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

q  Designed and coded for webpage’s.

q  Developed web services to import data from Global systems and HRMS System.

q  Designed the database and optimization.

q  Handling the Change requests.

 

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

Employer: Merit Info Solutions. 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

q  Preparation of Technical Design Document.

q  Preparation of Process flow, code schedule.

q  Involved in Development of WebPages.

q  Database creation and optimization.

 

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

Employer: Merit Info Solutions. Hyderabad

Client: Marcus, USA

Role: Team Member

Software: HTML, ASP.NET, VB.NET, SQL server, Visual Basic 6.0.

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

q  Designed and developed web pages for Student module.

q  Generating Reports and creating custom Controls.

q  Database designing.

 

Project # 6: AnAppointment.com

Employer: Merit Info Solutions. 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

q  Designed and developed web pages.

q  Database design.

q  Prepared the technical document.

q  Unit testing of the WebPages.

 

Project # 7: www.Greatlakessoil.com (GLSEC)

Employer: Merit Info Solutions.

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

q  Designed static web pages.

q  Designed and developed web pages.

q  Unit testing of the WebPages.

 

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

Employer: Merit Info Solutions.

Client: Nolster Clinic, USA

Role: Team Member

Software: Visual Basic 6.0, 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

q  Involved in Designing , Coding of all modules

q  Generating reports using crystal reports.

 

Project # 9: Complete Transport Solutions

Employer: Merit Info Solutions. 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

 

q  Involved in development of Freight, Fleet, Finance modules and respective reports

q  Involved in development of inter linking of all the modules.

 

 

 

Pratap Kumar Somala