Sql Server .Net
Resume:
Prakash Mohan
**************@*****.***
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