Post Job Free

Resume

Sign in

Sql Server .Net

Location:
Farmington, MI
Posted:
November 20, 2017

Contact this candidate

Resume:

PRABHAKAR PACHAIMUTHU

ac3ep5@r.postjobfree.com

+1-248-***-****

PROFESSIONAL SUMMARY

12+ years of experience in complete Software Development Life Cycle (SDLC) process that includes analysis, design, development, testing and implementation of various Web and Client / Server applications using Microsoft technologies.

Expertise in Visual Studio 2013/2012/2010/2008, ASP.Net 4.5/4.0, C#, MVC5.0/4.0, MVVM, Razor, ADO.NET, Active Directory, Entity Framework, LINQ 2 SQL, AJAX, Angular JS, Typescript, XML, XSLT, RDLC Reporting Services, Windows Services.

Excellent experience in developing applications using .Net framework 4.5/4.0/3.5 / 2.0

Expertise in Multi-tier/N-Tier architecture development using Object Oriented Programming (OOP), Web API, WCF, Web Services.

Excellent experience in Microsoft SQL Server 2012 / 2008R2 / 2005 / 2000.

Expertise in most common design patterns Strategy Pattern, Factory Method, Singleton and Repository.

Strong knowledge in Database Design and programming in SQL Server using T-SQL.

Strong knowledge in Angular JS, Typescript, JavaScript, JQuery, XML, SOAP, XSD, HTML, Bootstrap and CSS.

Experience in Working with end- users in resolving issues and production support

Strong experience on LINQ to Entities, Entity SQL and native SQL.

Experience in configuration control tools TFS, GIT, CVS and VSS.

Experience in ASP.Net Reporting Services (RDLC Reporting Service) and have exposure in SSRS (SQL Server Reporting Service)

Experience in performing analysis and requirements gathering with customers

Experienced in Query Optimization and Performance Tuning of Stored Procedures, Functions.

Experience in Agile Software Development Lifecycle.

Expertise in Troubleshooting and Debugging any .NET Web, Windows and Service Oriented

Applications.

Experience in Code Reviews, Unit Testing and Documentation skills.

Monitoring services, executing (start/stop/restart) services in Production environment.

Excellent ability to learn and successfully use new tools and environments in a very short time.

TECHNICAL SUMMARY

Programming Languages

C#, VB.NET, ASP.NET

Business Layer

Web API, WCF and Web Services, LINQ 2 SQL, ADO.Net

Database

SQL Server 2012/2008R2/2005/2000

Framework

.Net Framework 4.5/4.0/3.5/2.0, Entity Framework

Web Development

ASP.NET, MVC, Web API, Razor, HTML, XML, XSL,

XSD, XSLT, CSS, Telerik Controls, Kendo UI

Development Tools

Visual Studio.NET 2013/2012/2010/2008, Fiddler, NuGet, IIS

Scripting Languages

AngularJS, JQuery, JavaScript, XML, Bootstrap and CSS

Project Management Tools

TFS, GIT, CVS and VSS

Reporting Tools

SSRS and Crystal Reports

EDUCATION:

Master of Science in Computer Science, Bharathidasan University, India, (2002-2004)

Bachelor of Science in Computer Science, Bharathidasan University, India, (1999-2002)

PROFESSIONAL EXPERIENCE

Guardian Industries, Auburn Hills, MI Jan 2017 to Present

Praevenio (Inspections)

Senior .Net Developer

Responsible for design and development of two modules for the Guardian website namely:

Administration and Execution.

Administration: As any user within a Guardian provided network (public, trusted device, or production) or as a Guardian user authenticated outside a Guardian network will be able to create, modify and delete inspection by accessing inspections.guardian.com. user can configure/create tag, tag validation and reaction for validation for every inspection. Also, user can schedule the inspection.

Execution: Users can execute the inspection by accessing inspections.guardian.com/Execution The tag reactions will occur based on the user input for every inspections and inspection results will be saved to corresponding tables.

Responsibilities:

Involved in gathering requirements, meeting customer and analyzing DB.

Developed application using ASP.NET 4.5, C#, Web API, Kendo UI, IIS7.0, SQL Server 2012.

Used JavaScript/JQUERY to perform validations and catch the events on client's browser

Used TFS to maintain source code in version control.

Used Telerik Kendo UI controls in UI design.

Perform scheduled meetings (Daily Scrum, Requirements Review, Technical Review, Sprint Planning, and Project Status meeting).

Updated existing and created new JavaScript and JQuery code with Bootstrap classes to make it functional.

Created Database Objects like Tables, Stored Procedures, Views, Triggers and Defaults.

Created data model using entity framework.

Implemented and consumed Asp.net Web API Service for all database activities.

Worked in Agile methodology.

Involved in configure, Integration, Build and deploy application on Servers (QA, PROD).

Environment: ASP.NET, MVC 5.0, Web API, C#, Telerik Kendo UI, Visual Studio 2013, Java Script, JQuery, CSS 3, HTML 5, SQL Server 2012.

Guardian Industries, Auburn Hills, MI Aug 2016 to Dec 2016

Praevenio (Maintenance Request)

Senior .Net Developer

As any user within a Guardian provided network (public, trusted device, or production) or as a Guardian user authenticated outside a Guardian network will be able to create a request for work from by accessing maintenance.guardian.com. This website is supporting multi language based on the language or culture selected by the user. The request is pushed to corresponding facilities Praevenio system to work on the request, create work order and complete the request. Also, the request status change and work order information pushed back to maintenance request.

Responsibilities:

Worked with MVC architecture application using Razor engine and web API.

Implementation of the UI using HTML, Telerik Kendo UI, JavaScript, JQuery and Bootstrap

Developed application using ASP.NET 4.5, C#, Web API, Kendo UI, IIS7.0, SQL Server 2012

Created and deployed Web API using ASP.NET and C#, used them to generate the proxy class files based on the web services and consumed in web application

Created responsive UI to support all the devices (Desktop, Tablet and mobile) using HTML5, Bootstrap, Kendo UI and CSS3.

Created and optimized views for user interactions using objects of HTML Helper class, Custom Helpers and JavaScript/jQuery.

Writing the JavaScript, JQuery, JSON and Ajax to handling the Client-side validations

Used TFS for code repository, branching and merging the code, and task allocation.

Created Database Objects like Tables, Stored Procedures, Views, Triggers and Defaults.

Created data model using entity framework.

Created WEB API for all database activities.

Involved in the configure, Integration, Build and deploy application on Test and Production Servers.

Used agile methodology for the SDLC of the project.

Environment: ASP.NET, MVC 5.0, Web API, C#, Kendo UI, Visual Studio 2013, Java Script, JQuery, CSS 3, HTML 5, SQL 2012

PepsiCo Jul 2015 to Jul 2016

Talent Source

Senior .Net Developer

The Talent Source portal is a Web-based application that captures the process that is essential for employees to manage their hiring, staffing, and on boarding needs. This application helps PepsiCo and Cognizant employees to use the Talent Source portal and manage activities related to staffing such as onboard candidates, manage work orders, map skillsets, and other activities concerning workforce management. The users of PepsiCo and Cognizant are involved in the process of recruitment and staffing.

Responsibilities:

Involved in gathering requirements, meeting customer, analyzing existing technologies and reviewing peer documents, designing UML and analyzing DB

Developed application using ASP.NET 4.0, C#, WCF, IIS7.0, SQL Server 2012 and SSRS

Created and deployed Web Services (WCF) using ASP.NET.

Development & deployed Restful Web Services using WCF, consuming client services

Used TFS for code repository and task allocation.

Developed the Web Pages using MVC, HTML, Java Script, JQuery, Bootstrap and CSS

Used Bootstrap for Creating Design Templates for interface components

Used validation controls and created user controls for application using Java Script and JQuery.

Created Database Objects like Tables, Stored Procedures, Views, Triggers and Defaults.

Involved in the configure, Integration, Build and deploy application on Test and Production Servers

Developing automated unit testing using Nunit.

Performance analysis and refractor or redesign the system.

Environment: ASP.NET, MVC 4.0, WCF, C#, XML, Visual Studio, Java Script, JQuery, CSS 3, HTML 5, SQL 2012

Cdeploy (Cognizant) Jun 2014 to Jul 2015

Senior .Net Developer

This application is used to release the associates from project or fill open positions using available associates based on the required skills. Cdeploy comprises four instances to cover up the regions like USA, UK, India and APAC, this application serves as the main source of recruitment and re-allocation of cognizant associates in various projects.

Responsibilities:

Interact with the stakeholders or client to gather requirements.

Responsible for translating application requirements and business process models (BPM) into component and interface specifications.

Implementation of the UI using HTML, CSS, JavaScript, JQuery and Bootstrap

Analysis Requirements into logical and physical for System Analysis and design

Created Server Transactional Views, Models and controllers with MVC 4.0

Used the Telerik controls for rich user interface design pages.

Consumed Remote Web services (WCF) and called the services to implement Data Binding.

Extensively used JQuery in creating efficient and responsive application.

Used the JQuery framework on client side (CSHTML) and CSS for style to usability.

Created Layout page using MVC for the project

Designed the database and Created Database Objects like Tables, Stored Procedures, Views, Triggers, Defaults and Functions.

Used the LINQ queries for processing of the objects through entity frame work.

Involved in the configure, Integration, Build and deploy application on Test and Production Servers

Performance analysis and refractor or redesign the system.

Design and develop the automation tool for regression test to the system.

Develop prototype to improvement proposal for the end client and demonstrate

High level Component re-design

Review the Data model design and review ER diagrams. Improve the performance.

Environment: ASP.NET, MVC 4.0, WCF, C#, XML, Visual Studio, Java Script, JQuery, CSS 3, HTML 5, SQL 2012

PFSS (Cognizant), Chennai, India Jun 2012 to May 2014

Senior Developer

Payroll India: This team is responsible for handling the queries of the ex-associates who have left the organization, associates who have submitted their resignation. The transactions were tracked and processed through email previously. This tool creates the tickets automatically based on the email subject, when an email (with queries of ex-associate) is received in the mailbox. Also, the data of the requester would be fetched from the spreadsheets which are uploaded on weekly basis to the displays the information in the ticket.

Responsibilities:

Involved in gathering requirements, meeting customer, analyzing existing technologies and reviewing peer documents, designing and analyzing DB

Performed code review to ensure standards were followed by junior developers\ third party vendors and business requirements were fulfilled. Assisted junior developers technically and guided them throughout the application life cycle.

Maintained and updated guidelines for coding, navigation, screen layouts and SQL for Stored Procedures.

Used front end web development tools like Ajax, CSS, JavaScript, DHTML, and JQuery

Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.

Created WCF service to update the status.

Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).

Managed Client expectations and requirements to ensure timely deliverables and status reports.

Developed application using ASP.NET 3.0, C#, WCF, IIS, SQL Server 2008 and SSRS

Used TFS as a Version Control System.

Created Database Objects like Tables, Stored Procedures, Views, Triggers and Defaults.

Environment: ASP.NET, MVC 3.0, WCF, C#, XML, Visual Studio, Java Script, JQuery, CSS, HTML, SQL 2008

Cognizant Cloud (CC), Chennai, India Jun 2010 May 2012

Senior Developer

“Cognizant Cloud (CC)” is a common platform for handling all our BPO related tasks. It provides a platform for delivering process automation, accelerators and optimization solutions to clients. The main functional deliverables for CC Core Platform Development is

CC Tools - CCAdminConsole, Process Modeler and Cloud Manager

CC Framework Services - involves development of the components and window services

CC BPO UI - .Net web application for general purpose BPO implementation

Responsibilities:

Created WCF Services responsible for communicating and providing real time data from integrated server to Client Application

Used Web API (API Controllers) for HTTP and REST based GET, POST, PUT, DELETE and returning JSON format

Developed SQL and t-SQL queries to communicate with Data base.

Modified JavaScript and JQuery code with new Bootstrap classes to make it functional

Involved in developing web Pages with rich UI, AJAX, and JQuery using ASP.NET

Played a major role in setting up and deploying the project in testing and in Production environment.

Worked with end users providing support to the project in testing and Production Environment.

Worked with client for maintenance and supporting the application

Environment: ASP.NET, WCF, C#, MS SQL Server 2008, Java Script, JQuery, SSRS

Art.com (Helios & Matheson), Emeryville, CA Oct 2007– May 2010

.Net Developer

Email, Lookup Order and Fraud Management (ELF) Apr 2009 – May 2010

ELF Project consists of four sub projects such as EMS, Fraud Service, ELF Windows’s application and Allposters.com Website change. ELF will support the following features: Order Search and Viewing of Orders, Review and release of orders which are put on hold (auto decline) by fraud service, creating manual CS Task, Assigning and Reassigning CS Tasks, viewing transaction emails sent to customer and Respond to Emails sent by customer. ELF is a Windows application and it was developed using CAB with (Model-View-Controller) MVC pattern, VB.Net, C#, ADO.Net, Microsoft Enterprise Library, Authorization Manager (AzMan), Active Directory (AD).

Responsibilities:

Participated in discussion with onsite coordinator on getting the requirements.

Involved in Email Management System (EMS) using the .NetFramework 2.0, VB.Net and ADO.net.

Worked with onsite development team to create ELF Windows Application using VB.Net, C#, ADO.Net, Crystal Reports, Microsoft Enterprise Library, Authorization Manager (AzMan), Active Directory (AD).

Developed Email Editor Tool using .NetFramework 2.0, C#, ADO.Net and SQL server 2005.

Used Visual Source Safe as a Version Control System.

Created Database Objects like Tables, Stored Procedures, Views, Triggers, Defaults and Functions.

Working with the Business users to extract and generate the reports based on their needs.

Environment: ASP.NET, VB.NET, C#, ADO.NET, XML, Crystal Reports, Authorization Manager, Visual Studio 2005 and Microsoft SQL server 2005

Lightman May 2008 – Mar 2009

Lightman is an application developed for Art.com, California, USA. The User Interface (UI) framework used in Lightman is based on the Microsoft Composite Application Block. We have used a container/shell-based model to host the Lightman application. The shell is constructed through the CAB components and custom-built workspaces. We have used CAB with (Model-View-Controller) MVC pattern in this framework. This application serves the whole process of order processing for Art.Com and their clients.

Responsibilities:

Participated in discussion with business user on getting requirement (change requests and defects).

Explaining the change request to offshore development team and getting implemented the change requests.

Reviewing the code and coordinating the Development team, QA team and making sure that the change was implemented correctly to satisfy the business needs.

Coordinating and deploying the changes to production and informing the user about the changes.

Handled the primary pager and Provided 7 x 24 Production support for application issues.

Designed and developed the Presentation Layer, Business Layer and Data Access Layer using VB.Net, C# and ADO.Net.

Designed the database and Created Database Objects like Tables, Stored Procedures, Views, Triggers, Defaults and Functions.

Environment: VB.NET, C#, ADO.NET, Microsoft Enterprise Library, Crystal Reports, Visual Studio 2005, SQL Server 2005, Authorization Manager and Windows Server 2003

Mat Cutter Feb 2008 – Apr 2008

The Mat cutter application is used to cut the mat automatically. This is used to cut the mat with correct size without wasting mat. This application needs to scan the work order number and get the mats size and opening size from the database. It loads the external component “ECLIPSE” with the opening size & mats Size and automatically cut the mat for the opening size.

Responsibilities:

Participated in discussion with business user on getting requirement.

Developed application on Win Forms using C#, SQL.

Participated in the application deployment in client system.

Created Database Objects like Tables, Stored Procedures, Triggers and views

Created a web service to get the data from database

Gave demo to the end user to get more understanding

Environment: C#, VB.Net, Visual Studio 2005 and SQL Server 2005

Quality Wall Oct 2007 – Feb 2008

This project is used to check the quality of the print, posters, frames, canvas and canvas frames choose the matching mat, molding & glass of the special items. It will load the set of quality questions. First lead will audit the item and select the matching mat, molding and glass. Once pass the item from the Lead, Next the Auditor re-check the item randomly. If the Item passed these two levels of quality check then only the Item status has been changed to ready to ship. This project is used to avoid warehouse users to ship the damaged item to the customer.

Responsibilities:

Developed application on Win Forms using C#, SQL.

Peer review developers code, test cases and other documents.

Testing, Packaging and Deployment.

Created Database Objects like Tables, Stored Procedures, Triggers and views

Environment: C#, VB.Net, Visual Studio 2005 and SQL Server 2005



Contact this candidate