.Net Sql Server
Resume:
Senthil M
*******@****************.***
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 -
Certification in Securities Industries (Bank of New York Mellon, United
States)
NSE Certification in Capital Markets (Broker Dealer)
Contact this candidate