Resume

Sign in

Sql Server .Net

Location:
Norcross, GA
Salary:
67544
Posted:
April 27, 2014

Contact this candidate

Resume:

Prakash Mohan

acdvrg@r.postjobfree.com

Mobile: +1-770-***-****

PROFESSIONAL SUMMARY

• 7+ Years of extensive IT experience in Microsoft.Net technologies in analysis, design,

development, testing and implementing high quality software applications.

• Extensive work experience in .NET Framework, C#.NET, VB.NET, Win forms and ASP.NET .

• Microsoft Certified Professional (MCP) for developing Web Application using ASP.NET and

C#.NET.

• Architected and programmed Desktop, Web Applications and Class Libraries.

• Experience in developing and consuming Web services, WCF, Windows Services using

C#.NET.

• Excellent experience in SQL Server database design, database maintenance, developing queries,

stored procedures, views, triggers, functions, performance tuning, complex joins and security in

SQL Server 2000/2005/2008

• Having very good knowledge in Object Oriented Analysis/Design, Design Patterns, UML and

Visio.

• Having excellent knowledge in Common Language Runtime internal architecture, C# multi

thread programming and memory management.

• Having 3+ years of experience in Insurance domain (Property and Causality Insurance).

• Self-motivated professional with excellent attitude,quick learning, strong troubleshooting,

problem solving and communication skills

• Involved in all phases of the software development lifecycle (SDLC) - Requirements Analysis,

Estimation, Design, Project Planning, Implementation, Review, Deployment, Post Production

Support and RCA.

• Excellent Co-ordination skills – playing the key role of Onsite coordination in the Global

Delivery Model, interacting with various stakeholders like Business users, Business Analyst,

Architect, Offshore development team, QA team and UAT team.

• Excellent communication and presentation skills. Strong analytical abilities combined with

technical competence.

EDUCATION & CERTIFICATIONS

• Master of Business Administration (MBA - Technology Management) – 2008 To Feb, 2010 –

Anna University – 60% – TamilNadu, India

• Bachelor of Engineering (B.E. - Computer science) – 2003 To 2007, from Raja Rajeswari Engg.

College with 73% – TamilNadu, India

• MCP - Microsoft Certified Programmer for developing Web, Windows, and Data Acess &

Sharepoint using C #.net.

TECHNICAL SKILLS

Programming Languages: NET 1.0/2.0/3.0/3.5/4.0 (C#.NET, VB.NET, ASP.NET), ASP 3.0,

VB 6.0, HTML, CSS, JQuery

Development Technologies: Web/Win Forms, WCF, ASP.Net, ADO.Net, AJAX, JavaScript,

HTML, VBScript, Web Services, .Net Framework 4.0, 3.5, 2.0,

1.1, VB.Net

Development Tools: Visual Studio.Net 2010/08/05/03, Visual SourceSafe.

RDBMS: MS-SQL Server 2008/05

XML Related Technologies: XML, SOAP.

Reporting Tools: SQL Server 2005 Reporting Services.

Application Servers: Windows Server 2008/ 2003, IIS.

Version Control: Visual Source Safe 6.0 and TFS

Scripting Language: HTML, XML, and JAVASCRIPT.

Others: Developer Express 7.3.5

WORK EXPERIENCE

Infosys Limited - Technology Analyst - Aug 2010 – Till Date

Experts IN Solution - Sr. Soft Developer - Aug 2009 – July 2010

Kallos Solution - Software Developer - Aug 2007 – July 2009

PROJECT DETAILS

AuMine Spain AON

Duration Dec 2012 – Till date

Technology VS 2010, C#.NET, TFS, SQL Server 2008, Web Service, Windows Service,

ADO.NET

Role Technology Analyst

Company Infosys Limited

Description:

AuMine is a windows based application developed to service as Policy Management System for a major

provider of risk and property insurance brokerage. The application has the capability to perform policy

management activities as well as accounting activities. AuMine is a .Net multiple tier application. The

specialty of this application is that it is not only used by AON, but also by a number of companies owned

by the client.

Responsibilities:

• Created functionality to get the data from database.

• Involved in Database design using MS Visio.

• Creating and maintaining the coding and functional documents.

• Worked with Infragistics controls such as WebDataGrid, Web Slider, WebComboBox.

• SQL Server 2008 Management Studio was used to create objects like tables, stored procedures.

• Involved in change request as per client requirement for enhancement of application.

• Developing new requirements based on client requirement.

• Unit testing and delivery of application.

• Involved in Design, Development, Unit testing, and Integration testing.

• Working as an Onsite Coordinator and Leading a team of 30 offshore team members.

• Maintain and manage existing source bases

• Review and improvise code.

• Run tests and fix bugs.

• Gathering requirements with architects and business analysts to determine functionalities.

• Develop user interfaces and client displays.

• Design, initiate and handle technical designs and complex application features.

AuMine Webservice AON

Duration Oct 2011 – Nov 2012

Technology VS 2010, C#.NET, TFS, WCF, SQL Server 2008, Web Service, ADO.NET

Role Senior System Engineer

Company Infosys Limited

Description:

AuMine is a standard operating platform for an enterprise Underwriting and Policy Admin System that

supports the MGU’s specialty underwriting products and core processes. The services were used to

execute underwriting, rating, or other business rules. These services were consumed through the AuMine

application and in various other websites.

Responsibilities:

• Leading a team to report all the issues to the manager.

• Creating and maintaining the coding and functional documents.

• Involved in change request as per client requirement for enhancement of application.

• Unit testing and delivery of application.

• Involved in Design, Development, Unit testing, and Integration testing.

• Leading a team of 8 offshore team members.

• Maintain and manage existing source bases

• Review and improvise code.

• Run tests and fix bugs.

• Gathering requirements with architects and business analysts to determine functionalities.

AuMine Webservice Testing AON

Duration Oct 2010 – Sept 2011

Technology VS 2010, C#.NET, TFS, WCF, SQL Server 2008, Web Service, ADO.NET

Role Senior System Engineer

Description:

AuMine is a standard operating platform for an enterprise Underwriting and Policy Admin System that

supports the MGU’s specialty underwriting products and core processes. The main objectives of this

project were to carry out an end to end testing of the different modules in Xpress and testing the Web

services in AuMine application. The services were used to execute underwriting, rating, or other business

rules. These services were tested through the testing tool and through the AuMine application to ensure

that the services function as desired.

Responsibilities:

• Involved in the Testing Phase of the Application

• Performed Technical Verification audit for the Application.

• Performed white box testing of the Application.

• Organized Testing Meetings and prepared the Minutes of Meetings.

• Learned the various phases of a real time software development environment.

• Designing & reviewing the test cases and involved in the Test Case walkthroughs and assessment

meetings.

• Responsible for creating test cases for UAT.

• Performing Smoke, System, System Integration, Regression and UAT Co-ordination.

• Leading the Test team and working closely with the Test Manager and the onshore coordinator.

Aon Choice Escalation AON

Duration Aug 2010 – Sept 2010

Technology VS 2010, C#.NET, TFS, ASP.NET, SQL Server 2008, ADO.NET, Microsoft Office

Role Senior System Engineer

Company Infosys Limited

Description:

The prime role of the project team is to develop the application and support the QA(quality assurance)

activities for the Aon Choice Application.

Responsibilities:

• Involved in the Testing Phase of the Application

• Designing & reviewing the test cases and involved in the Test Case walkthroughs and assessment

meetings.

• Performed white box testing of the Application.

• Organized Testing Meetings and prepared the Minutes of Meetings.

• Responsible for creating test cases for UAT.

• Performing Smoke, System, System Integration, Regression and UAT Co-ordination.

• Leading the Test team and working closely with the Test Manager and the onshore coordinator.

Experts IN Retail Salonarthi, Play saloon

Duration Aug 2009 – July 2010

Technology VS 2010, C#.NET, TFS, SQL Server 2008, ADO.NET, Devexpress 7.3.5

Role Senior Software Developer

Company Experts In Solutions

Description:

Experts IN Retail is easy-to-use software for retail businesses to maintain sales, appointments, customer

information, SMS integration, Email integration, employee performance, inventory and attendance.

Experts IN Retail is designed to work in single desktop machine and also LAN environment. This

software integrates seamlessly with POS printers, standard dot matrix printers, and electronic cash

drawers.

Responsibilities:

• Created functionality to get the data from database.

• Involved in Database design using MS Visio.

• Creating and maintaining the coding and functional documents.

• SQL Server 2008 Management Studio was used to create objects like tables, stored procedures.

• Involved in change request as per client requirement for enhancement of application.

• Developing new requirements based on client requirement.

• Unit testing and delivery of application.

• Involved in Design, Development, Unit testing, and Integration testing.

• Maintain and manage existing source bases

• Review and improvise code.

• Run tests and fix bugs.

• Gathering requirements with business analysts to determine functionalities.

• Design, initiate and handle technical designs and complex application features.

Imagine Essence Aromas Imagine Essence

Duration Apr 2009 – July 2009

Technology VS 2010, C#.NET, TFS, ASP.NET, SQL Server 2008, ADO.NET

Role .Net Junior Developer

Company Kallos Soution

Description:

The IEAFF project is primarily developed for the Flavor and fragrances trading. Customer can design

and order their own flavor and fragrances. This project has a two major part Customer facing website

(CFW) and BackOffice operation (BOO).

Website (CFW)

Customer Facing website contain following module. Flavor, Fragrance, Contact handling.

Customer can create their own flavor and create sample order. Then customer get sample once customer

get sample. They can actual order. They can easily repeat the order by place order from order history

whenever they want.

Back office Operation (BO)

When customer enters new ordered. Back office person immediately get alert from home page.

There are three type of person involved in delivering order. Sampler, manufacture, shipper Sampler

provide sample to customer. Customer confirms the sample. Then manufacture starts the production.

Then shipping department sends the goods to customer.

Responsibilities:

• Worked in CSS to apply styles to Web pages.

• Created JavaScript functions to call server side events and for Client Side validations

• Worked with ADO.NET objects Data Adapter, Data Reader, and Dataset to access the database.

• Involved in Change Request maintenance by coordinating with the users.

• Development and testing.

• Development Environment setup

• Project Deployment

• Review of user manuals

Kallos CRM Sricity, Uniware, TVS NET

Duration Apr 2008 – Mar 2009

Technology VS 2010, C#.NET, TFS, ASP.NET, SQL Server 2008, ADO.NET

Role .Net Junior Developer

Company Kallos Soution

Description:

CRM system is the vehicle for sales force automation. By investing in an online CRM system, you can

bring your sales, marketing, support and even back-end business lines under one umbrella.

Clearly defining and promoting your product or service value proposition to Potential buyers.

It is a mechanism by which to assess your current marketing and Sales effectiveness.

SFA can be used to develop a library of information that identifies a customer's needs, preferences and

behavior to assist in developing your value added service for each customer.

Responsibilities:

• Worked in CSS to apply styles to Web pages.

• Created JavaScript functions to call server side events and for Client Side validations

• Worked with ADO.NET objects Data Adapter, Data Reader, and Dataset to access the database.

• Involved in Change Request maintenance by coordinating with the users.

• Development and testing.

• Development Environment setup

• Project Deployment

• Review of user manuals

DBMS Sathyam

Duration Jan 2008 – Mar 2008

Technology VS 2010, C#.NET, TFS, ASP.NET, SQL Server 2008, ADO.NET

Role .Net Junior Developer

Company Kallos Soution

Description:

It is distribution management solution designed based on the principles of Theory of constraints. It helps

to ensure availability of right product at right location at right time. Which means it avoids stock out as

well as excess stock. Kallos had a business tie-up with Satyam Computers for implementing this

product. This was designed, developed and implemented in many places.

Responsibilities:

• Worked in CSS to apply styles to Web pages.

• Created JavaScript functions to call server side events and for Client Side validations

• Worked with ADO.NET objects Data Adapter, Data Reader, and Dataset to access the database.

• Development and testing.

• Project Deployment

Bank Reconcilatin Statement Sundaram Infotech Soln

Duration Aug 2007 – Dec 2007

Technology VS 2010, C#.NET, TFS, ASP.NET, SQL Server 2008, ADO.NET, Javascript

Role .Net Junior Developer

Company Kallos Soution

Description:

A bank reconciliation statement is a statement prepared to reconcile the balance of cash at bank in a

company's own records with the bank statement on a particular date. The Bank Reconciliation Process is

automated for fast processing, easy identification of errors and meet the requirement of less man power.

Responsibilities:

• Worked in CSS to apply styles to Web pages.

• Designing the User Interface using latest AjaxContolToolKit 3.5.

• Worked with ADO.NET objects Data Adapter, Data Reader, and Dataset to access the database.

• Development and testing.



Contact this candidate