Sql Server Project

RANJITHKUMAR P

Mobile No: +91-812*******

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

CAREER OBJECTIVE

To display my unequaled knowledge of technical analysis, high-graded and applicable IT skills, proven leadership qualities, and desire to learn and grow higher in this sector.

CAREER PROFILE – TECHNICAL ANALYST

Currently working as Technical Analyst in Infosys Pvt. Ltd.

Having 5+ years of experience in developing Applications using Microsoft products.

Hands-on expertise development experience in Asp.Net MVC and SQL Server.

Team Player with strong interpersonal communication and excellent analytical skills.

Exceptional background in analysis, design, development, implementation and testing of software applications and products.

SKILLS

Languages : C#.Net

DBMS : Sqlserver2005/08/12/14

Web Technologies : Asp.Net with Ajax, MVC, Angular JS, Web Services, JQuery, JS, HTML,

JSON

QUALIFICATION

COLLEGE/SCHOOL

BOARD/ UNIVERSITY

YEAR OF PASSING

AGGREGATE

M.C.A

Kakatiya Institute of Technology and Science

Kakatiya University

2011

78.06%

B.Sc (MPC)

Bhargavi Degree & P.G. College

Kakatiya University

2008

78.94%

INTERMEDIATE

Vaagdevi Junior College

Board Of Intermediate Education

2005

84.00%

SSC

Vidya Niketan High School

Board Of Secondary School Education

2003

87.50%

Operating Systems : Windows7/8/10, Windows XP, DOS, Windows Server R2

Working Tools : Visual Studio 2005/08/10/12/13/15, Visual studio Online, Team Foundation

Server, Sql Server Management Studio, Google/Bing Map SVN Server, Adobe

Dream Ware/CS4, Log4Net, Obout UI Tools, Kendo UI Tools

Web Server : IIS, Windows Azure

Frame Work : Entity Frame Work

Basic Knowledge : VB.Net, Windows Azure, WCF, Classic ASP, Angular2, SSIS

ACADEMIC RECORD

WORK EXPERIENCE

Senior System Engineer, Infosys Pvt. Ltd. from Feb 2015 – Present.

Software Engineer, SSG Consulting Pvt Ltd. from Jun 2013 – Jan 2015,

Software Developer, Sejal Technologies-India from Aug 2011 – Jun 2013.

MICRO CERTIFICATIONS

Programming in HTML5 with JavaScript and CSS3

Developing ASP.NET MVC Web Applications

Developing Microsoft Azure and Web Services

PROJECT DETAILS

Microsoft Staffing:

Applications: Internal Global Careers, External Global Careers, University Bulk upload, Staffing DX, Travel Mailer, Candidate Portal, Recruiting Web, Interview Feedback, University Recruiting Tool, Cert Internal and Cert External

Responsibilities: Enhancement and development on all staffing Application

RELO

Duration : Sep 2016–Present

Team Size : 4

Environment : Asp.Net MVC, Entity Frame Work, C#.Net and SQL Server, Angular JS,

JQuery, Ajax, Bootstrap, Visual Studio 2013

Description:

The scope of the project is about internal staffing transfer of their employees. With this application, they will know how much amount should be paid for their employees while they are getting transferred from one place to another.

Responsibilities : Designing UI, Developing Business Logic, Unit test cases, Distribution work.

Staffing Applications Stay Current Activities

Duration : Oct 2016–Present

Responsibilities :

1.ASR2ARM- V6 Migration

2.EGC- LinkedIn Integration

3.Framework Upgrade of all applications

VSO

Duration : June 2016–Oct 2016

Environment : MS Visual Studio 2015, Visual Studio Online

Description:

Migrating All Staffing application into Visual Studio Online, which involves Code Migration, Work Item Migration, Build Management, Release and Deploy applications.

Responsibilities : Build and Release Management

IAAS

Duration : Feb 2016–Apr 2016

Environment : Windows Server, Windows Server R2, SQL Server Management studio

2012/14

Description:

Migration of Staffing Applications: University Bulk upload, Staffing DX, Cert applications into new IAAS Environment, which involves server procurement, Understanding existing application and server information.

Responsibilities : Virtual Server Management, Build and Deploy Management, Team

Management

University Recruiting Tool

Duration : Feb 2015–Jan 2016

Team Size : 8

Environment : Asp.Net MVC, Entity Frame Work, C#.Net and SQL Server, Kendo UI,

JQuery, Ajax, Visual Studio 2013

Description:

This project is use to create the requisition and maintain university information, student information, job profile information, discipline, POD information. Main aim of the project is to create the requisition, which gives job profile based on discipline, area, job description.

Responsibilities : Application Design and Architecture, Backend Developer, Frontend Developer

Quantum - LOS

Duration : Apr 2014–Jan 2015

Team Size : 20

Environment : Asp.Net MVC 2.0, Entity Frame Work 5.0, C#.Net and SQL Server,

WCF, VB.Net, Ajax, MS Visual Studio 2013 Beta

Description:

The projects help bankers manage their loan portfolio and mitigate credit risks by streamlining the lending process. This translates into reducing costs and enabling faster processing times to help grow the bank’s loan portfolio.

Responsibilities : Backend Developer (C#, asp.net mvc2 & SQL), Frontend Helper (JQuery, etc.)

Busted Houses

Duration : Aug 2013 –Mar 2014

Team Size : 6

Environment : MVC 4.0, Entity Frame Work 5.0, C#.Net and SQL Server, WCF,

Google/Bing Map, Windows Azure, MS Visual Studio 2010

Description:

The main objective of the project is to give information regarding Properties (Houses). Busted Houses mainly used for searching the property information for purchasing, selling, home rents etc. This project main aim is to give good resource to the clients, who want their busted houses to reconstruct and sell their property or purchase the property with the comparable of previous years.

Contribution:

oDeveloped application with MVC architectural pattern with their respective purpose and used Entity Frame work for database objects.

oCreating web pages for UI using razor engine and wrote the client side validations and data handling using JQuery.

oUsed Google Map for showing our own data points based on search criteria.

oUsed Map for showing the properties at street level zooming.

oInvolved in creation of database with necessary constraints.

oUsed WCF Services to get the data points.

oWorked in azure Environment for azure web hosting.

oDeveloped methods in Model using Entity objects and stored procedures in database.

URL : http://bustedhouses.com

Swimspot

Duration : Dec 2013 - Jan 2014

Team Size : 12

Environment : MVC 4.0, Entity Frame Work 5.0, C#.Net and SQL Server, VS4.5,

Windows Azure, MS Visual Studio 2012

Domain : E-Commerce

Description:

This project is about online shopping Cart. SwimSpot is the quick, easy and fun destination to buy women's swimwear for the modern sun-lover. Customers can order their products based upon models/designers, look books and products. This is a project of nop-commerce architecture. The project contains modules like Shop, Customize/Bikini-Builder, Look Books, Blog, My account and purchasing etc. Customers can do their Shopping with Brands, Color, Size, Hot Trends etc.

Contribution:

oWorked in search criteria for swim wears on UI and Database Objects.

oWorked in Look books module main page, Top trends page in shopping module.

oWorked in Blog’s Portal module for social network issues, search criteria, main page in this module.

oWorked for Email Part for all mails of shopping for admin and Users with their respective orders, login mails.

URL : http://swimspot.com

TriVerify

Duration : Jun 2013 - Dec 2013

Team Size : 6 (off Shore Team)

Environment : ASP .Net, C#.Net and SQL Server, Visual Studio .NET (4.0)

Domain : Banking Loan

Description:

TriVerify is a project to verify all the security certificates for clients, who are looking for loan for bank. This is a project for the third party clients, who verify and maintains the client information, their loan information. Tri Verify mainly verifies IRS, SSN Orders. Triverify main modules as of Order Creation, Order Processing for SSN, IRS Orders, Accounting, User Information, Loan Information.

Contribution:

oInvolved in Creation of SSN, IRS Process using Asp.Net Controls.

oWorked for SSN Order Processing using Asp.Net, C#.Net.

oDeveloped Presentation, Business and Data Access Layers for respective modules.

oCreating web pages for UI and wrote the client side validations, worked for Grid, asp controls using Obout controls.

oUsed Web services to get data from services.

oWorked for Creation of log files, logging mails using Log4Net.

oWorked in validation, email, encryption process using C#.Net.

oInvolved in creation of database with necessary constraints.

oDeveloped methods in Data Access Layer using ADO.NET objects and stored procedures in database.

ALARM System

Duration : Nov 2012 - May 2013

Team Size : 6

Environment : Asp.Net, C#.Net and SQL Server, Visual Studio .NET (3.5), Adobe Dream ware

Description:

This project reports all the information regarding Library of a College or a group of colleges. Our aim of developing the ALARM related to library management is to support the management by providing the appropriate information in the form of resources and services. However, this application is used to track every operation implemented in entire library.

Modules in LMS:

Acquisition

Administration

Cataloguing

Circulation

Serial control

Web OPAC

Reports

Contribution:

oInvolved in the web form design with html, web controls and Ajax controls.

oDeveloped Presentation, Business and Data Access Layers for respective modules.

oCreating web pages for UI and wrote the client side validations.

oInvolved in creation of database with necessary constraints.

oInvolved in WCF implementation.

oDeveloped methods in Data Access Layer using ADO.NET objects and stored procedures in database.

Swashakthi Chit-Funds

Duration : Jun 2012 - Oct 2012

Team Size : 6

My Role : Software Developer

Environment : Asp.Net, C#.Net and SQL Server, Visual Studio .NET (3.5)

Description:

The main objective of the project is to atomize the details of a Chit-Fund Company Management System and maintaining the financial information. This project is generalized package for chit- fund and finance company, which performs activities like: Maintaining Chit groups & Accepting deposits. In my project we included various modules are Company, Chit, Subscriber, Auction, Surety, Finance Information & Pass Book modules.

Contribution:

oDesign and Analysis for project.

oCreating web pages for UI and wrote the client side validations.

oUsed Ado.Net to implement data access layer.

oInvolved in creation of database with necessary constraints.

oInvolved in coding.

Warangal City Guide Web portal

Duration : Dec 2011 - Apr 2012

Team Size : 4

My Role : Trainee Software

Tools : Visual Studio 2010, Adobe Dream ware CS4, Ipmessenger3.0

Technology : Asp.Net, HTML, CSS, JavaScript, JQuery, PHP

Description:

This project reports all the information regarding Warangal City and Warangal. In this project we include all the information about Warangal history, Warangal places, classifieds, Warangal Education, Warangal offices, Hotels, Banks, Chit funds, and all about Warangal. This project contains mainly three modules Education, supports students, college, online chat, jobs, student Zone and Books Information etc. Places, supports all places of Warangal & it is mostly useful for tourists. Classifieds, supports for Sales information of apartments, plots, vehicles and also for Wishes.

Contribution:

oInvolved in gathering requirements with necessity.

oDesign and Analysis for project.

oCreating web pages for UI and wrote the client side validations.

oUsed Php coding for mailing the content.

oInvolved in JQuery coding for animation of slides.

PERSONAL DETAILS:

Name : Ranjith Kumar P

Father’s Name : Kumara Swamy

Gender : Male

Marital status : Single

Nationality : Indian

Languages known : English, Hindi, Telugu

Date of Birth : 02-04-1989

Declaration

I hereby declare all the information furnished above is true to the best of my knowledge.

Place: Yours Sincerely

Date: (P. Ranjith Kumar)

Contact this candidate