Sql Server Developer .Net Project Management Manager
Resume:
Santhosh Xavier
Phone: 732-***-**** E-
mail: *********@*****.***
Summary
Results oriented .Net professional with 12 years of extensive experience in
analysis, design and development of technology projects. I have
successfully implemented technology strategies for improving existing
systems.
. Proven problem solving skills. Identified performance issues and
eliminated the root causes in software projects.
. Winner of outstanding performance award from Thomson Financial.
. Strong C# programming skills in Winforms, Webforms and WCF
. Exceptionally good at database programming with more than 9 years of
hands on experience in SQL Server.
. 1.5 years of good experience in Oracle 10g
. Good record of successful completion of projects under deadline in a fast-
paced environment.
. Ability to work in both team-oriented and self-directed environments.
. Evaluated Business Rule Engine for .Net. This includes Blaze Advisor
(Fair Isaac), Haley
. Proficient in Object Oriented Design and Development Techniques (OOP),
COM, TCP/IP and Multithreading.
. Over 3 years of experience as a successful team lead. Hands on experience
leading all stages of system development (SDLC) efforts including high
level implementation plan, cost and resources estimation, work allocation
and cost benefit analysis.
. Excellent analytical, communication and presentation skills.
. Ability to interface with clients / customers and effectively assess
their requirements.
. Thorough experience in writing system specification requirements, design,
development, integration, testing, implementation, post implementation
support and end user training.
Professional Experience
Senior Lead Dot Net Developer (LI-Identity Billerica, MA) Jun2009
- Present
ID-Suite is a patented and integrated hardware and software solution that
provides identity and document verification across state, government, and
international agencies. It is a comprehensive product solution strategy to
solve the problem of issuing secure credentials to qualified candidates
only and managing the usage of these secure credentials.
Environment: C#, Winforms, WCF, COM+, Framework 3.5, Visual Studio 2008,
MVP, MS SQL Server 2005, ADO.Net, Truecrypt, Telelogic Synergy.
. Reporting directly to the director for research and development, well
handled the user requirements, development and co-coordination with QA
. Fine tuned application code to improve performance and implemented
multithreading
. Developed WCF webservice for database layer and for uploading profile
updates by different systems and data entry screens for multiple legal
documents using C# and MVP design pattern.
. Developed ASP.net modules for reporting and transaction analysis.
. Designed and developed a critical database monitor windows service
with multithreading. This is implemented using SQL Sever logon
trigger and event wait handlers. It also included CLR integration
. Designed and developed API for automating TrueCrypt.
Senior Lead Dot Net Developer (Merrill Lynch, NY) Feb2008 -
Jun 2009
Brisk is Options Trading System with electronic trading capabilities,
designed to fulfill the needs of market makers, proprietary traders, and
risk managers in an integrated fashion. This robust, scalable system allows
addition of new products, markets, and valuation models with minimal impact
on the end user.
Environment: C#, Winforms, Framework 2.0, Visual Studio 2003/2005, C++, MS
SQL Server 2005, ADO.Net, Syncfusion grid, ComponentOne True DBgrid, COM
Interop VSS, Visual Basic 6.0, InstallShield v12, .Net framework 1.1/2.0
. Achieved significant improvements in GUI for displaying option live
quotes.
. Significant contributor for design changes for implementing Option
Symbology Initiative (OSI). This was done with minimal impact to
current architecture.
. Successfully migrated legacy order router, risk portfolio with Greeks
and PNL components to C# multithreading applications/servers
. Implemented sockets, COM Interop, Windows API for inter process
communication, web services for admin use, ADO.Net and SQL Server
database
. Provided critical tech level production support.
. Worked as a key member of a team for the Requirement gathering,
Analysis and preparation of design documents.
Senior Lead Dot Net Developer (Ajinomoto, FortLee, NJ) Apr
2007 - Jan2008
Amino vital Golf is an online shopping website intended for selling
Ajinomoto's new range of amino vital products for golfers. ASG Safari's
Mine builder is used for developing various data cubes. Senior management
and marketing team uses these data cubes for analyzing sales and company
performance.
Environment: C#, ASP.NET, Framework 2.0, WebForms, WebServices, Visual
Studio 2005, Internet Information Server (IIS) 6.0, MS SQL Server 2005,
Visual Studio 2005, ADO.Net, HTML, JavaScript, Microsoft Enterprise
Library, ASG Safari Minebuilder, QUASK Workflow, .Net framework 2.0
. Implemented UPS tracking capability for the online shopping system.
. Implemented Enterprise Data Application Blocks for Data access layer
. Worked independently, reporting to the director.
. Held primary responsibility for Database design.
. Evaluated ASG Safari Mine builder for its data analysis capability.
. Developed data cubes using ASG Safari products
. Managed requirement gathering, analysis and preparation of design
documents.
Technical Leader (Thomson Financial - Rockville, MD) Dec 2005 -
Apr 2007
Source List system (SOL) is a web based application, intended to house and
manages Source Lists. The main objective of the system is to act as a Risk
reduction tool so that all content set analysts adhere to the directions as
per the Source List for data entry / modification or checking.
Environment: C# 2.0, ASP.NET 2.0, WebForms, IIS 6.0, MS SQL Server 2000,
ADO.Net, HTML, JavaScript, VSS, Master pages, .Net framework 2.0
. Lead a team of 3 and successfully completed the project in time.
Handled complete project estimation, work allocation, technical
decisions, requirement gathering, analysis and preparation of design
documents including ER diagrams and use case diagrams.
. Developed the prototype and finalized the user requirements.
. Was having the primary responsibility in Database and application
design.
. Implemented WebForms and Master pages concept using C# and ASP.net,
web sitemap with navigation control using ASP.net and excel style
multi row update using Data grid Control.
. Implemented Login controls and thorough knowledge of authentication
methods.
. Implemented SQL bulk copy for uploading data from excels into SQL
Server, reports using SQL Server Reporting Services (SSRS) and quick
access application link on Internet Explorer
. Thorough understanding of Entire SDLC Process.
. Was responsible for setting up Development, QA and production
environments.
Ownership Collection Master (OCM) is used by Thomson content team for
managing ownership related data. Ownership content helps corporate clients
identify security holdings and possessions. Ownership content is a valuable
resource to identify institutional and portfolio holdings and beneficial
holders of global securities.
Environment: C#, WinForms, ASP.NET, Framwork1.1, Visual Studio 2003 IIS6.0,
Oracle10g, Web services, ADO.Net, Xceed data Grid, XML, CVS,
Multithreading
. Successfully lead a team of 5, done project estimation, work
allocation, technical decisions, code review and CMM audit
. Responsible for Requirement gathering, Analysis, functional specs and
designing.
. Developed the prototype for the project and finalized the user
requirements.
. Implemented multithreading during the initial load and background
processing.
. Designed and Implemented 'Insider' and N-SAR module using C# and win
forms and development of web services using C#.
. Involved in production support and maintenance.
. Implemented Xceed grid which used XML based style sheet for rich
display, typed dataset and Model-view-controller (MVC) design pattern.
Sr. Dot Net Developer (Thomson Financial (Primark) Bangalore, India)
Jan 2002 - Nov 2005
'Response' tool is a combination of Web based application developed in
ASP.Net/C#, alerting Service in VB.Net and Reporting Database. This system
is used to track and report all problems/troubles/issues for data support
areas for Global Quality Assurance and Compliance group's (GQAC) of Thomson
Financial.
Environment: C#, VB.Net, VB.6.0, ASP.NET, IIS 5.0, MS-SQLServer2000, COM,
Webforms IE Web Control, VB Script, VBA, JavaScript, HTML, CSS, ADO.Net,
Linked Server, DTS, Application Center, VSS, .Net Data Web Controls, SQL
Server Web Assistant, .Net framework 1.1
. Created Views, complex queries, stored procedures and Triggers in SQL
server 2000., used Linked server to interface two different SQL server
databases for data transfer, developed User defined functions in SQL
Server and reports using SQL Server Reporting Services (SSRS)
. Involved in the quality assurance activities for the entire Project.
. Developed DTS packages to upload data from multiple Excel files which
includes validation of data.
. Designed Reporting database and implemented de-normalization
techniques.
. Designed and implemented Log shipping for Reporting database.
. Used VB Script/CDonts in DTS package to enable e-mailing capabilities
from SQL server.
. Managed Dev, QA and production environments
. Designed and implemented GUI using ASP.Net WebForms,.NET web user
controls, IE Web Controls for multi tab capability in webpage, User
Authentication module in ASP.Net, Web Assistant to generate scheduled
reports and winform based escalation module to escalate outstanding
queries,
'Project Management Online (PMO)' system provides a central place to track
the status, target, date, manager and resources associated with each
ongoing project. At a basic level, PMO is a web site and project database,
but more importantly PMO is a management and communication tool that
supports enterprise project management and oversight of the entire
portfolio of projects.
Environment: ASP.Net, ADO.Net, WebForms, VB.Net, SQL Server 2000, IIS 5.0,
VB Script, JavaScript,HTML, CSS, ADO.Net, .Net framework 1.1
. Successfully handled the complete Database design, created Views,
complex queries, stored procedures and Triggers in SQL server 2000.
. Designed and developed web user controls in .Net.
. Designed and coded Proposal module which takes request for project and
takes through different phases of approval.
. Designed and Implemented Web variety reports with Excel download
capability and Time Track module to track individual's resource
utilization and generate reports.
'Chronicle Application' is a client-server application designed & developed
to load and analyze Securities data supplied across the globe.
Environment: VB.Net, WinForms, VB 6.0, COM, ADO.Net, SQLServer 2000, DTS,
VB Script, Infragistics, ActiveX Controls, MQSeries, Infragistics
. Developed GUI/ ActiveX Controls for Data Analysts to view & update
corporate changes, Dividends and Results Published data.
. Designed and implemented business tier layer.
. Implemented Infragistics grid control to display hierarchical data.
. Wrote stored procedures, views and triggers in SQL Server 2000.
. Involved in code review and technical improvement activities.
. Designed and developed DTS packages to upload formatted data to SQL
server 2000.
Sr. Software Developer (Royal Electric Company, Bangalore, India)
Feb - Dec 2001
Environment: Visual Basic 6.0, COM, WIN 32 API, Crystal Reports and SQL
Server 7.0, Active X Controls.
Project Management Software is a multi user application that handles the
entire requirement of an electrical company. The main modules include
Tender, Project Monitoring, Purchase & Stores Management and Payroll.
. Involved in System study, Client Interaction, Team Management, Design
and Coding, Unit testing and Integration testing.
. Developed COM/Active-X Controls in VB, designed and implemented
business tier and database layer.
. Hold critical role in Database design, created complex queries, stored
procedures and Triggers in SQL server.
. Implemented reporting features using Crystal Reports. And Involved in
the development of the Help module.
Software Developer (L&T, NLC Bangalore, India)
Sep 2000- Jan 2001
Environment: Visual Basic 6.0, Lookout, MS Access, COM, ActiveX, VBA, DAO,
Win32 API
Energy Management System implements Energy Management SCADA software that
will perform data acquisition of electrical parameters from energy meters
and provide a user interface that will enable visualization and monitoring
of these data.
. Implemented Win32 API, Grid and Tree View control for better GUI,
developed interface to read data from serial port which connects to
Data Collection Device and designed and implemented Excel interaction
layer.
. Completed unit and Integration testing and involved in the packaging
and deployment.
Software Developer (KALKI communication, Bangalore, India) July 1998 -
Aug. 2000
Environment: Visual Basic 5.0/6.0, COM/DCOM, ASP, JavaScript and SQL Server
6.5/7.0, MS Access, My SQL, Crystal Report, Install Shield, RDO
'Resume Manager' is a complete enterprise solution for recruitment and
manpower planning. It automates all stages of recruitment - collection of
resumes, sorting, screening, short-listing, and joining formalities.
. Designed and modified MS Flex grid to display and input data, designed
multiple ActiveX DLLs which act as plug-ins for Resume manager main
module. This included features for project management and visa-
processing.
. Implemented licensing to handle piracy of the software and set up demo
period for the software. This component handles registry manipulation
Win 32 APIs and DLL developed in C.
. Created Views, complex queries, stored procedures and Triggers in SQL
server 6.5.
. Implemented MCI control to record voice and Winsock control to send
the file to remote machine.
Education
Master in Computer Applications (MCA).
Contact this candidate