Trushar Patel
Tsp10000@gmail.com
(256) 655-4530
Summary:
5+ years of experience in analysis, design and development of client/server,
web based, n-tier application.
Expert in developing window application, web application, window services and
web services in Microsoft Visual Studio .Net IDE using C#, VB.NET, ASP.NET,
ADO.NET and SQL Server.
Hands on experience with all phases of Software Development Life Cycle
(SDLC), Quality Assurance Methodologies and Good Knowledge on Software Quality
and process.
Extensive development experience in XML Schema, DTD, XSLT, WSDL, AJAX,
JavaScript, SOAP & Web Services.
Worked extensively with Data Adapter, Dataset, Data reader as part of ADO.NET
to access and update database.
Experienced in Object Oriented Programming (OOP) and in gathering customer
requirements and functional requirements
Experience in writing Database Queries, Stored procedures, Triggers, Cursors
in SQL Server.
Good working knowledge in designing Use Case, Class, Sequence, Collaboration,
State Component, Deployment, Activity diagrams using UML.
Exceptional ability to adapt to latest technologies, perseverance, innovative
and organized.
Possess strong team building skills and competencies needed to analyze
problems, respond to changing needs.
Skill Set:
Microsoft Technologies ASP.Net , C#.NET , VB.Net,ADO.NET, ADO,ASP, Web Services
Scripting Languages Java Script, VB Script
Programming Languages C, C++, Visual Basic6.0, Java
XMLRelated Technologies XML, XLST, XPath, XML Schema SOAP
Operating Systems UNIX, MS Windows (2000/XP/NT/vista), DOS
Markup Language HTML, DHTML
Application Server IIS, Apache
Reporting Tools Crystal Reports
RDBMS Oracle , SQL Server, MS Access, PL/SQL
Data Modeling UML, MS Visio
Work Experience:
Merrill Lynch, Hopewell, NJ March 2009 Feb 2010
Trade Entry System
.Net Developer
Description:
In this project all trades are entered into Trade Entry System
(TES) before the end of the trading day via a trade ticket frame. Once the trade
has been successfully added it will appear in the Trader's window. Here traders
can edit their trade before sending the trade to the Operations window. Once the
trade is in the Operations window Operators will verify and add additional
details (such as the Bloomberg lookup code) before sending the trade into the
accounting system Virtual Portfolio Management (VPM). Upon success the trade will
turn green VPM Id recorded and no further modification is allowed.
Responsibilities:
Designed web based user interface in ASP.Net with Web forms HTML Controls and
Web Controls and also Created Cascading Style Sheet and integrated styles in user
interface for client application.
Created SQL queries, stored procedures, and implemented SQL queries in the C#
code to provide features like upload/download files from/to spreadsheet for
client application.
Implemented the filtering/sorting criteria related to Refresh and Filter
option in Grid View.
Changed the windows services to implement new format for file naming
conventions.
Extensively worked on T-SQL stored procedures, functions and Triggers to
Create and modify existing tables and stored procedures in ADO.Net and tested
them on testing and production servers.
Created XML files and XSL/XSLT/XPATH for Presentation and transferring Data to
HTML page.
Design and development of reports using Crystal reports.
Environment:
Windows XP, Visual Studio 2005, Visual Source Safe, C# .Net, ASP.Net, ADO.Net,
HTML, XML, SQL Server 2005, Crystal Reports.
ING Financial Markets LLC, New York
Oct 2008 Feb 2009
Revenue Tracking System
.Net Developer
Description:
ING is a global financial institution offering banking, insurance and asset
management. I was part of the design and development team responsible for the
development of a Revenue Tracking System where the entire sales plan, revenue
plan and a number of reports such as sales report, sales forecast report etc. of
the company are estimated.
Responsibilities:
Developed the application entirely using C# as the front end and SQL server
2000 as the back-end.
Created Web Services components in C# using SOAP and WSDL.
Extensive involvement in gathering requirement analysis and develop case
analysis using UML.
Built queries in T-SQL, which are needed for the reports.
Report generation using Crystal reports.
Compiled class libraries to share data between different servers in the XML
format
Extensive use of Visio 5.0
Environment:
C#.NET, ASP.NET, ADO.NET, Web services, Win XP, SQL Server 2000,
Transact-SQL,
Crystal Reports, Visio 5.0
Kandar Software Pvt Ltd (Bangalore, India)
Sept 2007 Aug2008
Record Management.
.Net Developer
Description:
Health care information system is a high performance, user-friendly online
information system to keep track of the medical records throughout the center.
This product can be configured around various RDBMS in client/server environment.
It provides a powerful way of user driven application with transparency, security
and ease in data access. The system shall also assist users in decision support
and information references. This product has been developed to cater to the needs
of Hospitals and Corporate Hospitals, Nursing Homes. Relevant modules of the
project are being web enabled.
Responsibilities:
Involved in software Development Life Cycle (SDLC) Process included Analysis,
Design, Programming, Testing and Documentation.
Developed core functionality with the .NET Framework using C#, ASP.NET,
ADO.NET, JavaScript and MS SQL Server2000.
Used C# for developing the Business Logic as per client request.
Used List controls like Data grid control and Data List Control for display of
data.
Used Visual Studio.Net for developing VB. Net and ASP. Net web applications.
Used ADO.Net for database programming and connection to database.
Developed XML applications for fewer loads on database.
Environment:
C#, VB.Net, ASP.Net, ADO.Net, SQL Server 2000, T-SQL, Windows 2000,
IIS 5.0, .Net Frame Work, HTML, DHTML, Java Script, XML.
ARYANS InfoTech (Bangalore, India)
April 2007 Aug 2007
Telecom Service Registration System
Description:
A Telecom Service Registration System is a web-based application
that gives a line-of-business executive an automated way to make telecom service
registration and fault reporting system. Gives the business executive of service
availability also generate a report for planning, installation and maintenance
departments. This project client was BSNL (Bharat Sanchar Nigam Limited).
Responsibilities:
Defined the available services and requirements
Developed system using ASP.NET, C#, ADO.Net, SQL Server 2000 and Crystal
Reports
Implemented security by using forms authentication and role based
authorization.
Developed dynamic UI behavior using DHTML, JavaScript.
Database design and writing complex queries and stored procedures
Environment:
Visual Studio .NET 2003, C#, ASP.NET, ADO.NET, DHTML, JavaScript,
Crystal Reports, SQL Server 2000, Visual Source Safe
ARYANS InfoTech (Bangalore, India)
Jan 2007 April 2007
Student Database Management System
Description:
The Region Office wanted to develop an application to keep a track all the
students registered with its local centers. This application kept a record of
students enrolled at a particular center along with the course registered. The
Database Management System picked up the location of a center just by entering
the Center ID.
Role & Responsibilities:
Developed a Web Application to maintain student database
Designed user interface, developed database and coding
Created Custom Web Controls in the form of Composite and Derived Controls
Used Data Grids extensively for development of user controls
Used various data control and display elements like Data Grids, Data Sets,
Data Views, Data Adaptors to extract data from the backend
Various function like addition, deletion of a student & updating student
information or grades could be performed
Involved in successful deployment of the application.
Environment:
C#, ASP.NET, ADO.NET, SQL Server 2000, Visual Studio.Net 2003, Win 2000, IIS
6.0
Bharat Petroleum Corporation Ltd (Bangalore, India) Jan 2006 to
Dec 2006
Laboratory Information Management System
.NET Developer
Description:
Bharat Petroleum Corporation Ltd. (BPCL) is among the top three
petroleum refinery and marketing companies in India. BPCL's priority was to
enhance information flow from its Laboratory Information Management System
(LIMS), to provide users at its plant access to information on the status and
quality of products processed at the plants. The new system provides business
intelligence analysis on product quality. It also gives management information
system data on test results, and quality parameters for products manufactured in
various BPCL plants. BPCL developers used Web technology to provide authorized
users across the organization access to the system on its corporate intranet.
Responsibilities:
Responsible for designing, developing, testing, deployment and maintenance of
the application.
Designed user interface using .NET IDE and Web controls.
Provided Windows based and Form Based Security for Authentication.
Designed and implemented database in SQL Server 2000.
Wrote SQL Stored Procedures.
Used ADO.NET objects.
Use .NET Validation controls to perform server side validation.
Created numerous Functions, Triggers, Indexes and Stored Procedures.
Environment:
C#.NET, ASP.NET, XML, SQL Server 2000, Visual Studio.NET 2003, IIS,
Crystal Reports.
Education:
MCA in, Bangalore University, India,
BBA in, S.P.University, India
|