Post Job Free

Resume

Sign in

.Net Sql Server

Location:
India
Posted:
March 30, 2015

Contact this candidate

Resume:

Senthil M

acoyah@r.postjobfree.com

571-***-****

EXPERIENCE SUMMARY:

. 8+ years experience in requirement analysis, design, development,

testing and maintenance of N-Tier applications using Microsoft

Technologies.

. Experience in developing application using Visual Studio (2008/10/13)

and .NET Framework (ASP.NET, C#,ADO.NET, WCF,ASP.NET MVC, Entity

framework)

. Microsoft Certified Technology Specialist (MCTS) in SQL Server and Web

Technology

. Strong and excellent understanding of .NET Framework and SQL Server

architecture

. Good understanding of Object Oriented Programming concepts.

. Worked extensively with SQL profiler and execution plans

. Expertise in writing T-SQL programming, Views, Normalization, Stored

Procedures, Triggers and Functions.

. Proficient in using LINQ queries and experience in multi thread

programming.

. Good experience in developing reports using Crystal Reports and

packages using SSIS

. Good experience to SDLC, Functional/Design Specifications

. Experience in project development using Agile methodology.

. Experience in Investment banking, Asset Management, Mutual funds, OTC

derivatives(Credit, Swaps, Options, Exotic) and Capital markets

software domains.

. Completed NCFM certification in Financial and Capital Market.

. Highly motivated, detail oriented, ability to work independently and

as a part of the team with

excellent Technical, Analytical and Communication skills.

TECHNICAL SKILLS:

Languages Visual C #

Framework .NET Framework 4.0, 3.5, 2.0, 1.1, Entity

framework 6

Web Technologies ASP.NET, ADO.NET, ASP.NET MVC 4, AJAX, Web

Service,WPF, WCF, Silver light, Web API

Markup Language HTML, DHTML,CSS, XML, Razor, JSON

Scripting Language JavaScript, JQuery

Databases MS-SQL Server 2005/08/12

ETL Tool SSIS 2008

Reporting Tools Crystal Reports

Version Controlling CVS, Visual Source Safe

Tools

Web Servers IIS 6, 7.5

Development IDE Visual Studio 2008/10/12, SQL Management

Studio

Performance Tools ANT profiler, SQL Profiler

Third party tools Log4Net, ASPOSE, WinSCP, NUnit

No SQL MongoDB (Basics)

PROFESSIONAL EXPERIENCE:

BNY Mellon

June 2013

- Present

Role: Senior Developer/Tech Lead

Derivatives Pricing Exchange (DPX)

Derivatives Pricing Exchange (DPX) is an OTC derivative pricing interface

and warehouse with suites of applications which would serve as repository

for derivatives reference data and price information. DPX would be able to

take in economic details of the

Derivatives instruments via manual entry and data feed from various

internal accounting systems. DPX would also be able to send the price

request and receive the price response from independent third party pricing

vendors Markit, Bear Stearns, Investor Analytics and Standard and Poor's.

Based on the client preference, price request is made to vendors and final

price is send to source platform such as IAS/Invest One/SUMMIT/XENTIS.

Responsibilities:

. Application architecture and design.

. Involved in UI, web service and database design. Implemented highly re-

usable generic core components. Experience in layered architecture

development

. Created WCF Service using basic HTTP Binding.

. Written SQL stored procedures, functions, triggers and views. Involved

in SQL Server performance tuning.

. Application development for downloading OTC pricing data from various

vendors (Markit/ SD/S&P, etc) and managing the pricing data warehouse.

. Provide support to OTC operations and Quant's team for ad-hoc

reporting

. Developed tools to help operations team to view market data and to do

instant pricing.

. Developed ETL packages to enrich and upload the asset details to

downstream application for re-conciliation.

. Developed windows services to upload the price details into database

at market pricing window time.

. Developed various SWAP price reports to send the pricing details to

accounting system and clients.

. Actively involved in unit testing, manual testing, regression testing,

negative tests, data driven tests.

. Actively participated in conferences among the Quantitative analysts

team, operations team, pricing groups, business analysts, senior

management and QAs on production and maintenance issues.

. Involved in onsite-offshore co-ordination and communication with

clients and stakeholders.

. Involved actively in design discussion and peer reviews.

. Created unit test cases and test driven development.

. Created new releases in version controls using Visual source safe.

. Code deployment and monitoring in all regions- Development, QA, UAT,

PROD.

Environment: .Net Framework 3.5/4.0, ASP.NET 3.5, ASP.NET MVC, Web API,

Silver light, C#,JQuery, Microsoft Visual Studio 2010, WCF, SQL Server

2008, SQL Server Integration Services (SSIS), XML, Windows Services, WPF,

ASPOSE DLL, log4net,WinSCP, Visual Source Safe

BNY Mellon

Apr 2010

- June 2013

Role: Senior Developer

Derivative Pricing Exchange - FinCAD Integration

The DPX-FinCAD integration project is to load the FinCAD supplied prices

into DPX application. The DPX application communicates with FinCAD

libraries. The DPX application uses the Market data provided by the

external vendors like Bloomberg, Reuters, iCAP (Inter Capital) and CMA

(Credit Market Analysis) to generate the prices out of FinCAD libraries.

The DPX-APV application generates various pricing reports to compare the

prices.

Responsibilities:

. Involved in Requirements gathering, Design & Analysis of the Customer

Specifications, development and customization of the Application.

. Designed and developed various abstract classes, interfaces, classes

to construct the business logic using C#.NET.

. Experience in XML, Reading the XML file and assigning the required

contents to respective objects

. Experience in changing the existing web service into WCF service.

. Experience in writing SQL stored procedures, functions, triggers

. Experience in SQL Server performance tuning.

. Implemented LINQ to Entities for data retrieving, querying, storage

and manipulation.

. Work closely with business to define development estimates according

to Agile Methodology.

. Used JavaScript for triggering Pop-ups with a CSS-class, dynamic

forms that include built-in error checking.

. Involved in Build, Deployment, Versioning, Unit testing and

Maintenance of the application.

Environment: .Net Framework 3.5, ASP.NET 3.5 and C# 3.5, Microsoft Visual

Studio .NET 2008, XML, JavaScript, CSS, JQuery, SQL Server 2005

Servion Global Solutions, Chennai, India

Mar 2009 - Mar 2010

Role: Developer

Credit Cards Outbound Call Center Solutions

This project involves the implementation of Outbound dialer and automates

the process of calling the customers based on their delinquent list from

vision plus host. The business logic is implemented through windows

services. The Outbound dialer helps in automatic dialing of the customer

number without having the agent to manually pick the phone and dial the

customer number. Campaigns will be created in dialer database to call the

delinquent customers.

Responsibilities:

. Developed web-based application with ASP.NET 2.0 and C# 2.0 as code

behind following 3-Tier architecture.

. Developed windows service for batch processing

. Implemented web based front end using ASP.NET, Javascript, Ajax

Controls, CSS, HTML and business logic using C #.

. Used Master pages, CSS, HTML, JavaScript, and ASP.NET Server Controls

on web forms.

. Partially worked on Membership Provider, Role Provider and Profile

Provider to enable user membership.

. Incorporated with Ajax Toolkit, Script Manager, Update panel and AJAX

Timer.

. Extensively used ASP.NET Data Grid and Data List controls for

displaying the data.

. Extensively implemented Data Access Layer using ADO.NET.

. Designed Database, writing stored-procedures, Triggers, functions &

Views in SQL Server.

. Used Session state, View state, Cookies and Query strings to persist

and transfer data between pages.

. Created, implemented and deployed web services.

. Used Request, Response, and Server objects to manage page navigation.

. Designed and generated reports using Crystal Reports

Environment: .Net Framework 3.0, Microsoft Visual Studio 2008, C# 3.0, ADO

.NET, HTML, XML, CSS3, JavaScript, Windows Service, SQL Server 2005, CVS,

Crystal Reports, log4Net

Servion Global Solutions, Chennai, India

Dec 2007 - Feb 2009

Role: Developer

Broadridge CRM

The solicitation application is used by call center agents and managers to

facilitate functions such as list creation, screen pop, vote collection and

related customer processes as well as reporting and searching for records.

The solicitation center solution replaces the existing dialer with Cisco

infrastructure call center for outbound and inbound calls and integrates

with Witness Call Logger to provide an end-to-end state of the art contact

center solution. Broadridge provides complete proxy process management and

a variety of voting options that help mutual fund companies and insurance

companies reach quorum quickly and efficiently. As the proxy processing

agent for more than 800 brokers, banks and other nominees, Broadridge

currently provides proxy services to over 450 mutual fund families. With

Broadridge, shareowners have several options to vote -- traditional paper

ballots, telephone or via the Internet. Shareowners can call toll free

numbers to vote. The primary channel for most inbound calls is an IVR

application. Inbound calls to agents are generally follow-ups to

solicitation calls and mass material mailings.

Responsibilities:

. Developed web-based application with ASP.NET 2.0 and C# 2.0 as code

behind following 3-Tier architecture.

. Implemented web based front end using ASP.NET, Javascript, Ajax

Controls, CSS, HTML and business logic using C#.

. Used Master pages, CSS, HTML, JavaScript, and ASP.NET Server Controls

on web forms.

. Partially worked on Membership Provider, Role Provider and Profile

Provider to enable user membership.

. Incorporated with Ajax Toolkit, Script Manager, Update panel and AJAX

Timer.

. Extensively used ASP.NET Data Grid and Data List controls for

displaying the data.

. Extensively implemented Data Access Layer using ADO.NET.

. Designed Database, writing stored-procedures, Triggers, functions &

Views in SQL Server.

. Used SessionState, ViewState, Cookies and Query strings to persist

and transfer data between pages.

. Created, implemented and deployed web services.

. Used Request, Response, and Server objects to manage page navigation.

. Designed and generated reports using Crystal Reports

Environment: .Net Framework 2.0, Microsoft Visual Studio 2005,ASP.NET 2.0,

C# 2.0, ADO .NET, HTML,XML, CSS3, JavaScript, WSDL, Oracle 10g, CVS

KHEC Solutions, Chenai, India

Mar 2007 - Nov 2007

Role: Developer

Lovinbuggies.com

An on-line shop that carries a comprehensive line of automobile spare

parts, findings and supplies.

The end user can select one or more products as per his/her liking and can

buy them easily. In admin module,

the administrator can add/modify/delete any number of categories/

subcategories and unlimited products etc.,

The admin can also specify New products, Special Offers etc., The order

information that are placed through the

front end can be viewed in the admin panel and the admin is also has the

ability to mark an order as complete/cancel/pending etc., There is a

mailing list integrated with the admin module, with which the admin can

send mails to the customers.

Responsibilities:

. Requirement gathering and analysis.

. Application design and development.

. Used Style sheets for achieving uniformity through all the pages.

. Created test scripts for unit, integration and regression testing.

. Involved in UI design, validations and content management.

.

. Implemented application logging and error handling with log4net.

. Involved in Production deployment and support.

.

Environment: .Net Framework 2.0, ASP.NET 2.0, ADO.NET,C# 2.0,CSS, SQL

Server 2005,log4Net,Visual Source Safe Paypal,Authorize.Net Payment

gateways

Vinsat Technologies, Chennai, India

Jun 2006 - Mar 2007

Role: Developer

Network2buy.com

An Online profile matching service, which introduces a completely new way

of buying property.

Here a user can join forces with 1, 2 or 3 others to buy. It builds a UK

wide co-buyer network to help anyone who wants to buy, to find others to

help them achieve this. It introduces two types of membership, residential

and commercial. Here the users can register free, and then create their

profile free telling others who they are and what they are looking for in a

property and a buying partner. The users can also post their advertisements

regarding their property for sale. The site also provides an option to

search other profiles. If the profile is matched, then the user can

exchange their contact details and they could be taking their first

exciting step towards the property ladder.

Responsibilities:

. Requirement gathering and analysis.

. Application design and development.

. Used Style sheets for achieving uniformity through all the pages.

. Created test scripts for unit, integration and regression testing.

. Involved in UI design, validations and content management..

. Implemented application logging and error handling with log4net.

. Involved in Production deployment and support.

Environment: .Net Framework 2.0, ASP.NET 2.0, ADO.NET,C# 2.0,CSS, SQL

Server 2005,log4Net,Visual Source Safe PayPal Payment gateways, Adobe

Photoshop CS2

Education:

Anna University at Chennai, India

Bachelor of Engineering (B.E) in Computer Science

2001 - 2005

Technical Certification:

Microsoft Certified Technology Specialist (SQL Server)

Microsoft Corporation, License MCP ID: 5885514

Microsoft Certified Technology Specialist (Web Technology)

Microsoft Corporation

Microsoft Certified Professional Developer (Web Technology)

Microsoft Corporation

Domain Certification:

NSE Certification in Financial Markets (National Stock Exchange, NCFM ID -

000********)

Certification in Securities Industries (Bank of New York Mellon, United

States)

NSE Certification in Capital Markets (Broker Dealer)



Contact this candidate