Post Job Free

Resume

Sign in

Sql Server .Net Developer

Location:
Plainsboro, NJ
Posted:
December 10, 2016

Contact this candidate

Resume:

RadhaKrishnan Appaji

Email: acxukb@r.postjobfree.com

Phone: 609-***-****

LinkedId: https://www.linkedin.com/in/radhakrishnanappaji

Experience Summary:

9.5 years of IT experience in Software Analysis, Design, Development, Implementation, Testing and Supporting distributed, Client/Server and web based business solutions.

Expertise in implementing Web Applications using .NET Framework 1.1/2.0/4.0/4.5 C#.Net, ASP.NET, ADO.NET, WCF, Web API(REST), Web Services (SOAP and WSDL), WebSockets, IIS 7.5, HTML, CSS, XML, JSON, LINQ, nHibernate, Entity, Microsoft Sync Framework, AWS EC2, AWS S3.

Entity Framework 6, jQuery, Java Script, Google API (Google Maps JavaScript API, Google Analytics API), Grunt and Bower

Expertise in developing web applications using MVC3.0/4.0/5.0/6.0 and RAZOR view

Expertise in developing test driven and loosely coupled applications using Unity DI(Structure map, unity, castle windsor) framework

Expertise in TFS 2010, GIT and Jenkins for Build automation.

Developed applications to access data from RDBMS databases like SQL Server 2000/2008, Sql Server 2014/2012 R2, Oracle 8i, 10g

Expertise in NoSQL database like MongoDB (Indexing, Aggregation, Map-reduce), Redis and Cassandra

Extensively used ADO.NET and ODA.NET objects like SQL/OLEDBConnection, SQL/OLEDBCommand, Data Reader, Dataset, Data View and Data Adapter.

Expertise in Database Programming and Development using Microsoft SQL Server 2000/2008 R2/2012 and good experience in SQL, PL/SQL, T-SQL, Triggers, Views, User Defined Functions, Stored Procedures, Ranking Functions and Common Table Expressions.

Over 2 years of experience in SSIS and SSRS, Informatica(Basics)

Excellent experience in all stages of Software Development Life cycle from requirement analysis to implementation & project closure.

Over 3 years of experience on Agile development. Expertise on agile development tools like JIRA.

Experience in design, and development in diverse domains like Insurance, Banking and Media.

Microsoft Certified Professional Developer (MCPD) and completed LOMA level 1 insurance certification.

Technical Skills:

Environment : Visual Studio 2003, 2005, 2010, 2012, 2013 and 2015

Programming : ASP .Net, C#.Net, MVC, Web API, WCF, VB.NET

Web Tools : HTML/DHTML, XML, AJAX, CSS

.Net Framework : 1.1/2.0/4.0/4.5, WCF

Testing & DI framework : Nunit, Ncover, specflow, structuremap, Adobe test and target

Other tools /features : Jenkins, Auto mapper, Chrome extension development, Elmah, Splunk, Log4Net, Mongochef, RedisDesktopManager, Postman, Putty, CloudBerry, Windows Powershell.

Client side Scripting : Java Script, JQuery, jQuery UI, jQGrid, AngularJs

Design Documentation : HLD & LLD

Database : SQL Server 2014/2012/2008 R2, MongoDB, Redis, Cassandra

ETL/Reporting Tools : SSIS, SSRS, Informatica (basics), DTS

Application Server : IIS 6.0/7.0/7.5/8.0

Source Control : GIT, Team Foundation Server 2010

Build Tools : Build Automation TFS, Jenkins

Other Tools : Soap UI, Fiddler, IE developer tools, chrome developer tools, fire bug, IE Tester, MS Office, Plunker

Methodologies : Design Patterns, MVC Patterns, N-Tier architecture, SOLID Principles, Complete SDLC, Agile, Dependency Injection.

Educational Qualification:

Bachelor of Technology (B.Tech) in Electronics and communication engineering, Rajiv Gandhi engineering College, Pondicherry, Pondicherry University, India Jun 2003 – May 2007

Certifications and Other Achievements:

Technical Specialist: Accessing Data with Microsoft .NET Framework 4

Technical Specialist: Web Applications Development with Microsoft .NET Framework 4

Designing and Developing Web Applications Using Microsoft .NET Framework 4.0

Technical Specialist: Windows Communication Foundation Development with Microsoft .NET Framework 4

Technical Specialist: Microsoft SQL Server 2008, Database Development

Technical Specialist: Microsoft .NET Framework 3.5, Windows Communication Foundation Application Development

Technical Specialist: Microsoft .NET Framework 3.5, ASP.NET Application Development

Designing and Implementing Databases with Microsoft® SQL Server™ 2000 Enterprise Edition

Developing XML Web Service and Server Components with Microsoft Visual c# .NET and the Microsoft .NET Framework

LOMA (Level 1)

Professional Summary:

Title : Associated Press Web Feeds

Period : May 2016 – Till date

Client : Associated Press, NJ, USA

Role : Senior .Net Developer

Project

WebFeeds delivers the last three days’ worth of news content to other news organization via an HTTP feed. Associated press Webfeeds is capable of delivering contents in different format and different content based on the request parameters. Currently the webfeed serves more than 140 million requests a day and the current database has a challenge in terms of performance. WebFeeds version 2 is developers to replace the existing webfeeds with the latest technology that can deliver with a better performance.

Responsibilities

Understanding the existing application and discussing the requirement with Client.

Analysis/design and prepared technical documentation.

Consolidating the possible technology’s and creating proof of concept to replace the existing database

Creating design/data structure for the web feeds replacement

Implementing the Web feeds replacement functionality using Redis, MongoDb, C#, web API, nodeJs

Coordinating with the Jenkins deployment team to set up new Jenkins automation build

Ensure that the design follows the SOLID principles, object-oriented design

Assisting the team members in solving complex problems

Reviewing the code check-in and ensure there are no flaws.

Applications : Web Feeds, Edge DB

Languages : Visual Studio 2015, C#, MVC, Asp.Net 4.5, WCF, LINQ, nodeJs, SQL Server, SSRS, SSIS, CSS, HTML, Jquery, Javascript, Web API (REST), Amazon web Services, MongoDb, Redis, AWS EC2, AWS S3..

Tools : TFS

Database : Redis, MongoDb, SQL server 2012

Title : PAR(People and Relationship) and MVP (My View Point)

Period : Mar 2015 – Mar 2016

Client : Ultradata, Australia

Role : Senior .Net Developer

Project

Ultracs 4 is the latest release of Ultradata’s fully integrated retail banking system that allows to deliver a range of parameter driven products along with customer focused service. Coupled with the various delivery channels, and add-on modules, Ultracs 4 offers the most advanced and complete system in the financial services software marketplace.

The solution also provides a powerful single version of the truth, with one database driving the delivery of services to customers via any channel the institution chooses. This central hub for connectivity means management and reporting can now be delivered simply and easily.

Responsibilities

Requirement gathering and discussion with the Client.

Analysis/design and prepared technical documentation.

Implementing the New Payments Platform (Australia's low-value payments) functionality using C#, MVC, angularjs, Entity Framework, WCF, jQuery, Javascript, CSS, HTML

Involved in creating a new Web API project which serves data in the JSON format to the UI for displaying the additional account information.

Involved in writing Stored procedures, T-SQL, User Defined Functions

Fixing the critical QA issues and technically assisting the team members

Ensure that the design follows the SOLID principles, object-oriented design

Assisting the team members in solving complex problems

Setting up the development environment for the release.

Reviewing the code check-in and ensure there are no flaws.

Applications : MVP (My View Point), PAR (People and Relationship)

Languages : Visual Studio 2013, C#, MVC, Asp.Net 4.5, WCF, LINQ, AngularJs, SQL Server 2014, SSRS, SSIS, CSS, HTML, Jquery, Javascript, Web API (REST)

Tools : TFS

RDBMS : SQL server 2014

Title : GEMS (GPS Estate Management System)

Period : July 2014 – Feb 2015

Client : Kuala Lumpur Kepong Berhad, Malaysia

Role : Senior .Net Developer

Project

GEMS application is designed for estate managers to manage and analyze the estate, yield information and the employees. The application provides features to enable GPS navigation, save the navigation tracks in the estate map, Analyze the yield information, employee work combination, create pinpoints and memo on maps.

Responsibilities

Involving in scrum, sprint planning meeting and estimations.

Design and development of the product using Visual 2013 (C#.Net), MVC, WCF, MapInfo, Auto Mapper, nUnit, Structuremap, SSIS, SSRS

Exploring and implementing the GPS navigation functionality using MapInfo API

Fixing the issues on the Jira dashboard based on the priority.

Setting up the development environment for every sprint.

Writing complex Stored Procedures in SQL Server 2012 to query the geographic information from the database

Making sure the all the high priority items are fixed for the planned sprint.

Ensuring the code coverage and unit test cases are up to the best.

Suggesting ideas to the product owners on improving the product.

Making sure the right package is sent to the deployment team for deployment.

Production deployment support.

Operating System : Windows 7

Languages : Visual Studio 2013 (C#.Net), WCF, MapInfo, Auto Mapper, nUnit, Structuremap

Tools : GIT, Jira

RDBMS : SQL server 2012

Apr 2013 to March 2014 (Worked in UK) - April 2014 to June 2014 (Offshore TCS,Chennai)

Title : UKDI eChannel Continuous service improvement

Period : Apr 2013 – June 2014

Client : Aviva Insurance, Norwich UK

Role : Senior .Net Developer

Project

Aviva has the quote and buy application for Home and Motor insurance and a self service application to view, renew and amend the policies. Please find the below live links

Motor:

https://www.direct.aviva.co.uk/quote/direct/motor

Motor Quote & Buy is Web application used by customers to obtain the Aviva Motor quote & Buy policy. The application has options to get a new quote, retrieve an existing quote and buy the policy. The application has features to add more than one vehicle and more than one driver for the vehicle. The application is responsive and can be accessed from any mobile devices. This application connects to various services and database to provide the data required by the customer.

Home:

https://www.direct.aviva.co.uk/quote/Direct/Home

Home Quote & Buy is Web application used by customers to obtain the Aviva household quote & Buy policy. The application has options to get a new quote, retrieve an existing quote and buy the policy. Based on customer choice the application displays different set of questions to the user. The application is responsive and can be accessed from any mobile devices. This application connects to various services and database to provide the data required by the customer.

Mypolicy:

https://www.direct.aviva.co.uk/MyAccount/login

Mypolicy is a self-service application used by customers to maintain their Home and Motor policies. The application provides options to the user to view and download the policy documents, view the policy details, renew the policy and to make amendments to the policy. This application connects to various services and database to provide the data required by the customer.

Multi variant testing is implemented on the above applications to understand the customer preference on user experience and content.

Responsibilities

Involved in scrum, sprint planning meeting, backlog review, retrospective meeting and point based estimations.

Coding/Development using .Net Framework 4.0, Visual Studio 2012 (C#.Net), MVC, WCF, Web API, nUnit, Structuremap, CSS, HTML, Javascript, Jquery, Entity Framework, LINQ

Fixing the issues on the Jira dashboard based on the priority.

Setting up the development environment for each sprint.

Configuring the WCF service configurations to point to the right environment for each sprint.

Making sure the all the high priority items are fixed for the planned sprint.

Ensuring the code coverage and unit test cases are up to the best.

Implementing logging using Log4Net.

Coordinate with the Splunk team to make sure the right data is logged for data analytics and reporting.

Suggesting ideas to the product owners on improving the product.

GIT code checking in gate keeper for the common layer, to ensure if the common changes does not affect the dependencies.

Updating the Jenkins build for each sprint and making sure the right package is sent to the deployment team for deployment.

Assisting the team members when they face any technical issues

Production deployment support.

Achievements

Implemented solution to a major problem causing blockage to implement Adobe test and target.

Implemented Web API project which can collect all the user inputs when the user fills the form. This helps the customer care executives to analyse what issues the customers are facing while filing the Insurance quote.

Operating System : Windows 7

Languages : Visual Studio 2012 (C#.Net), MVC, WCF, Web API (REST), nUnit, Structuremap, CSS. HTML, Javascript, Jquery, Entity Framework, LINQ

Tools : GIT, Jenkins, Jira, Splunk, Adobe test and target, Site catalyst

RDBMS : SQL server, SSIS, SSRS

Title : Adviser Desktop

Period : Feb 2011 – Mar 2013

Client : AXA, UK

Role : Senior .Net Developer

Project

Adviser Desktop: Website is a secure website used by independent financial advisers (IFA) to gain access and administer their client’s pension policies and conduct investment research. This website consists of investment and pension calculation tools and communicates with the Embassy system to display and update the user’s pension policy.

Implemented bug fixing and enhancements on PCS Web, Issue Log, MI Viewer applications.

Responsibilities

Estimation and Impact analysis of the requirements, Change requests and also small enhancements

Preparation of System documentation and design documentation.

Code review, ensuring best practices and coding standards.

Preparing build definition for deployment in source control

Supporting changes for UAT & other project phases.

Operating System : Windows XP

Languages : Visual Studio 2010, MVC 3.0, C# 4.0, WCF, SSRS, SSIS

RDBMS : SQL Server 2008

Title : ELF (Electronic Legal Files)

Period : Feb 2010 – Jan 2011

Client : NBCU, USA

Role : .Net Developer

Project

ELF is a web application developed to maintain the NBCU’s legal documents and its details. The user can view, upload, search, provide access, scan and print the documents using this project.

Responsibilities

Gathering requirements from onsite as well as clients

Development, defect replication and Fix

Guiding the team members in fixing complex issues

Identify, track and analyse root cause of the defects

Operating System : Windows XP

Languages : ASP.NET 4.0, MS-Visual Studio 2010, LINQ, WCF, C# 4.0

RDBMS : MS SQL 2005

Title : ITAM (IT Asset Management)

Period : Dec 2009 – Jan 2010

Client : NBCU, USA

Role : .Net Developer

Project

Unicenter Asset Portfolio Management is an IT ownership management tool that helps manage technology assets throughout their lifecycles. It is a comprehensive solution for managing financial and ownership information of IT Assets of an organization. It supports the entire life cycle of an asset from procurement, acquisition, allocation, use and finally disposition, including legal and cost information. UAPM tool does not provide options for bulk upload of data. So the application is developed to provide bulk upload of contact, asset details to the UAPM database by consuming the web service of UAPM application.

Responsibilities

Design and Development of Web pages, Code.

Coordinating with client directly.

Unit and Regression Testing

Operating System : Windows XP

Languages : MS-Visual Studio 2005 (C#.Net, ASP. Net 2.0), Web Services

RDBMS : SQL Server 2005, Oracle

Dec 2007 to Dec 2009

Title : COMPASS (Contract Management Program Acquisition and Scheduling System)

Period : Dec 2007 – Dec 2009

Client : NBCU, USA

Role : .Net Developer

Project

COMPASS is a System which helps NBC Personnel to deal with Scheduling, Contract Management and Program Accounting of the programs that is telecasted in the channel. COMPASS is a system that provides excellent solution to Programming and Scheduling functions. NBCU staffs use this application to create new programs and to schedule it for broadcasting.

Responsibilities

Defect Replication and Fix.

Coordinating with on-shore team.

Preparation and execution of Test Cases

Operating System : Windows XP

Languages : Visual Studio .NET 2003 (C#.Net), CSS, HTML

RDBMS : Oracle, SQL Server 2000, DTS



Contact this candidate