Resume

Sign in

Sql Server Management

Location:
Irving, Texas, United States
Salary:
$95K -$105K/Year
Posted:
February 06, 2018

Contact this candidate

Resume:

GEORGE PAPPACHAN

**** ******** **,

Irving TX,

*****-****

Email:- g ac4c68@r.postjobfree.com

Mobile:- +1-469-***-****

SUMMARY

● 6 years of professional experience in software design, development of web and service based Applications.

● Experienced in Full Stack Development.

● Expertise in Agile methodology and Waterfall Model of software development.

● Experienced in Web application development using MVC,ASP.NET, JavaScript, JQuery and SQL Server.

● Experienced in Windows Communication Foundation (WCF) technology.

● Sound knowledge of 3-tier layered architecture.

● Expertise in best coding practises like StyleCop, FxCop.

● Experience in web-based page designs using HTML, CSS, Themes, Master Pages, JavaScript and AJAX.

● Experience with Data Accessing including using Data Adapter, Data Reader and Dataset in ADO.NET for data manipulation.

● H ands on experience with SQL Server 2008,2012,2015

● Extensively worked on writing Stored Procedures, Functions, Views and Database Design.

● Created and maintained SSIS packages to Import/Export data from/to Excel.

● Extensive Knowledge in Application Lifecycle Management tool (TFS) and tracked user stories, task, defects and test case.

● Experienced in Object Oriented Analysis and Design.

● Experienced in developing technical documentation in various stages of Software Development Life Cycle (SDLC).

● Coordinate Development and Testing team interactions.

● Proven ability in motivating and leading development teams.

● Ability to prioritize and distribute tasks in order of importance.

● Good communication skills and Strong decision making and problem solving skills.

● Knowledge in RPA - UiPath.

EXPERIENCE SUMMARY

COMPANY DESIGNATION DURATION

Cognizant Technology Solutions Associate Nov 2011 – Nov 2017 Tech Core Skills

MVC

ASP.NET 4.5

ADO.NET

HTML/CSS

JavaScript

JQuery

WCF

TFS ALM tool

SQL Server

Languages

C#

Frameworks

ASP.Net web

WCF service

Microsoft Enterprise library

Tools

Visual Studio

TFS 2016

SQL Server Management

Studio

Certifications

EDUCATION & CERTIFICATIONS

Education

● Bachelor Of Engineering – Computer Science And Engineering - Ranganathan Engineering College Affiliated to Anna University Coimbatore, Tamil Nadu, India

● +2 – Science with Mathematics – S.N.D.PH.S.S Adimaly, Affiliated to Educational Board Kerala, India.

● S.S.L.C – M.T.S.H.S.S Kottayam, Affiliated to Educational Board Kerala, India. Credential Certification / Version

● Microsoft Certified Professional ID: 9685043

● Emergency Response Team Member

PROJECT EXPERIENCE

Project Name Facility Management System (FMS)

Client Cognizant Technology Solutions India Ltd.

Duration Mar 2013 -Nov 2017

Project Abstract Facility Management System (FMS) is designed to automate overall facility management and asset management of the organization. Key features include the digitization of facility infrastructure, workspace management, and asset management. Facility Infrastructure and workspace module identifies opportunities for better facility utilization and occupancy management. Application automates end to end operation of facility management right from commencement till decommission. Digital document repository is properly titled, classified & manage facility compliance documents with ease & secure. Energy and Maintenance module help to manage effective utilization of consumptions and automate various consumption parameters with external building management system. Technology ● Visual Studio 2015

● C#

● HTML/CSS

● JavaScript

● JQuery

● ADO.NET

● MVC

● SQL Server 2015

● ALM tool (TFS)

● NInject

● Burndown chart.

The application is built on .NET 4.5 with MVC architecture and core business logic centered on Web Api Service.

Role Senior Developer & Team Lead

Responsibilities

● Application development and Team management.

● Used CSS (Cascading Style Sheets) in CSHTML pages.

● Used JavaScript and JQuery for client side validations.

● Implemented Data access layer using ADO.NET: Datasets, Data Readers, Data Command and Data Adapters to

communicate with the SQL Server.

● Involved in the Build and Release activities.

● Implemented SSIS packages to update SQL data

tables

● Created and deployed the Windows Service for Emails.

● Implemented the Email Approval workflow using windows service.

● Implemented best coding practice using StyleCop

and FxCop

● Performed unit testing / integration testing and debugging.

● Closely interacted with Testing Team and ensure all bugs are fixed by Dev Team.

● Closely interacted with Performance Testing Team and ensure all performance issues are resolved.

● Implemented Dependency Injection by Ninject.

● Leading the Multiple Location Team Developments.

● Communication with business team to understand the requirements and followed sprint planning, daily scrum, sprint retrospective, sprint review and product backlog refinement meetings.

● Closely worked with product owner and business

analyst to prioritize requirements and make sure to deliver most valuable features in short cycles.

● Guided the development team to prepare estimation based on the user stories size and make sure to

deliver various sprints on time.

● Developed application Framework based on SOLID

principles.

● Perform coordination activities with vendors to

automate various consumption related data with

BMS system.

● Tracked user stories, task, defects, test cases and code review in TFS

● Communicate progress, risks or issues to Product Owner and development team

● Collaborate and coordinate with SCRUM masters

● Organized Daily Standup calls.

● Removing obstacles that are impeding the team's

progress.

● Coaching teams for promoting agile engineering

practice such as Pair Programming, Continuous

Integration

Project Name Social App

Client Cognizant Technology Solutions India Ltd.

Duration April 2012 - Feb 2013

Project Abstract An Application for users to improve social networking by inviting random people for lunch and to have an interaction. Key features includes sending invite to known people and also to random crowd. Used to send invitation for external Team lunch & Team events. Technology ● Visual Studio 2011,

● C#

● JQuery

● JavaScript

● SQL Server 2012

● ALM tool (TFS)

This application is developed in Single Page Application model (S PA) using Waterfall project methodology .Technologies used are Page methods (Webmethod in aspx.cs) for JQuery Ajax call for Server Side. JQuery, JavaScript and Json are used for Client side. Role Developer

Responsibilities

● Responsible for technical implementation of new

change requests and its delivery.

● Implemented changes in HTML/CSS files.

● Implemented Client side validation using

JQuery/JavaScript.

● Created Tables, Stored Procedures for Database.

● Involved in application and database design phase.

● Implemented change requests as per the

requirements in the application.

● Unit Testing and bug fixing.

● Worked with data analysis team to create various reports and analysis as per the requirement.

● Single point of contact for any discussion with

application’s source information



Contact this candidate