Developer .Net Business Project Manager Sql Server
Resume:
Gaurav Bangia
Dr
Katy, TX
(Cell) +001 (713)
***********@*****.**
.in
Summary
. Microsoft Certified Solution Developer - MCSD
. 8 years of extensive hands-on experience with C# and the .NET
technology.
. Engaged in analysis, design, development, deployment, and maintenance
of software applications.
. Experienced leading a small team of developers, and also managing
projects independently.
. Strong experience in database design, in Microsoft SQL Server.
. Strong programming skills using C#, VB.NET, ADO.NET, ASP.NET, NUnit
testing XML, XSLT, Web/Windows Services, Win-Forms, SQL 7.0/2000/2005,
T-SQL, Stored procedures, HTML/DHTML, Third Party Controls like
Infragistics, Telerik, Obout)
. Strong experience developing .NET components using standard controls
and custom controls.
. Specialize in building custom deployment packages.
. Extensive Knowledge on .NET Architecture.
. Good understanding of .NET Remoting, AJAX implementation, DTS
Packages/SSIS, Silverlight tools, design patterns and UML for
documentation.
. Expertise in performing application/database tuning and writing Stored
Procedures, Triggers, and Views.
. Strong experience developing world-class multi-tier enterprise
applications using Microsoft .NET technology, and Microsoft Visual
Studio.NET.
. Worked on Crystal Reports for .NET and Sql Server reporting services
(SSRS).
. Excellent communication, organization and leadership skills.
. Creative, motivated, and committed to excellence.
. Team player and strives to maximize productivity while working as a
team.
. Experience in the financial, health care, energy/gas and government
sectors.
Certifications
. Microsoft Certified Solution Developer (MCSD)
. Developing and Implementing Web Applications with Microsoft Visual C#
.NET and the Microsoft Visual Studio .NET (Exam 70-315)
. Designing and Implementing Databases with Microsoft SQL Server 2000
Enterprise Edition (Exam 70-229)
. Developing XML Web Services and Server Components with Microsoft
Visual C# .NET and the Microsoft .NET Framework (Exam 70-320)
Technical Skills
Languages : C#, C++, VB.NET, ASP.NET, SQL, T-SQL, XML, XSLT, VBScript,
JavaScript and HTML/DHTML, CSS
Databases : Microsoft SQL Server 7.0/2000/2005, and Microsoft
Access
Technologies : .NET Framework (1.1/2.0/3.0/3.5), ADO.NET, Web
Services, SSRS.
Operating Systems : Microsoft Windows 98/NT/2000/XP
Web Servers : Microsoft Internet Information Services (IIS) Version
5.1/6/7
Development Tools : Microsoft Visual Studio.NET and Visual Source
Safe, Team Foundation
Server, CORDA
Professional Experience
Employer: Marlabs Inc, NJ, USA Oct 2006 - Present
Architect/Sr. Software Developer Mar 2009 -
Present
Client: Bastion Technologies, Houston, TX
Project: EPICS
EPICS is a contract management tool/product built considering government
agencies requirement for handling contract related operations. Product
allows advanced customization of each contract. The power of the tool
includes creating/managing dynamic workflows for different approval
procedures, creating/managing Task/Delivery Orders and planning budgeting
along with other supportive tools/features.
Role:
. Designed the entire architecture/framework of the product on basis of
the product requirement specification document using ASP.Net 3.5.
Applied singleton and factory method design patterns for entire
application.
. Gathered/documented the product requirements for all modules.
. Followed agile methodology in the development of the product.
. Assisted the project manager and co-team lead in creating the effort
estimation for entire project.
. Designed and developed the database tables with Sql Server 2005, and
business objects with C#.
. Developed custom tool as windows application solution to automatically
generate all generic stored procedures targeting a particular
database.
. Developed the data access, and business layer for the project using C#
programming.
. Developed/designed custom business objects for the project by writing
C# class files.
. Assigned task/module to other developers, responsible for developing
presentation layer (UI).
. Developed the presentation layer for most significant components of
the project including dynamic workflow management/implementation and
entire budgeting system using ASP.Net web forms and user controls.
Created various themes and skin files for the presentation layer.
. Developed few reports for Budgeting and Delivery & task orders system
using SSRS.
. Developed few pages using Silverlight 3.0.
. Developed other windows application solution as an external executable
to be executed daily using Microsoft Windows Scheduler. This was later
rewritten using SSIS.
. Deployment of application as per schedule to different servers.
. Developed web services responsible for communicating globally between
different product/client versions.
. Developed custom licensing solution for the product including major
restriction of application by number of contracts in database. Created
HttpModule to handle licensing and other security issues. Worked with
few asp.net provided Encryption methodologies to encrypt/decrypt the
license file.
. Extended Expression builder class within asp.net to provide customized
solution for dynamic text resources per contract, used for all static
text across application like button's, labels, grid headers etc.
. Developed lot of custom control components for the application, like
editable label control, SuperSmartPanel with features like being
movable, collapse or expandable. Custom grid view as an extended
GridView control, with added on client side features like column re-
sizing, row server side selection, and other cosmetic features like
row mouse over styles etc.
. Performing manual unit/integration testing before forwarding to the
test team.
. Developed installer package for the product, using windows forms to be
installed independently by client.
. Provided guidance to other developers in the team to accomplish their
individual task for the project.
Environment:
ASP.NET 3.5, Infragistics 7.1, DevX 2009, C#, JavaScript, HTML, SSRS, SSIS,
SQL Server 2005, Microsoft Visual Studio 2008, Team foundation server,
AJAX, Web services, Silverlight and Custom controls development.
Sr. Software Developer May 2008 - Feb
2009
Client: Cardinal Health, Houston - TX
Project: Universal Tag Registry (UTR)
Universal Tag registry is a multilingual web solution product.
The product implements RFID (Radio Frequency identification) method for
keeping track of costly products for the clients. Product is intended for
hospitals and health care associations as prospective clients. UTR is a
multi-tier application, in which web service communicates with the
hardware, and pure web application, which acts as a repository.
Role:
. Developed and coded for business objects along with business layer
interfaces and other class implementations.
. Developed and coded for database layer, with all methods which
communicates to the database.
. Developed web methods responsible for interacting with the hardware used
for tracking the products.
. Coded for all required stored procedures required for screens assigned.
. Implemented AJAX through asynchronous update panel controls.
. Coded and developed all major web UI using .net server controls.
. Also developed user controls, commonly used throughout application.
. Developed all screens responsible for master data in the project.
. Coded various client side functions using JavaScript.
. Developed 3 major reports using SSRS.
. Implemented singleton and factory method design patterns.
Environment:
ASP.NET 3.0, C#, JavaScript, HTML, SSRS, SSIS, SQL Server 2005, Microsoft
Visual Studio 2005, Team foundation server, AJAX, XML Web services.
Sr. Software Developer June 2007 - May 2008
Client: Shell Oil, Houston - TX
Project: Global Metrics Excellence (Oct 2007 - May 2008)
Global Metrics Excellence (G-METREX), is the global web-based solution for
storing, reporting, and analyzing Manufacturing work process metrics,
replacing spreadsheets and databases currently being used to track and
report process metrics.
Access to G-METREX is role-based and restricts access to functionality and
data according to security roles assigned to a user profile.
G-METREX allows authorized user to create/define new metrics, or modify
existing metrics. Site administrator can configure the available metric for
capturing data at different levels like Site/Area/Unit.
As user submits data for all variables associated with the metric,
application calculates the metrics value and store in the database.
In case where data is being captured at lower levels than Site, like
Area/Unit, all variable values, system is also responsible to roll-up the
values to higher level as Site.
Project: Global Utilization Tracking System (June 2007 - Oct 2007)
The purpose of the application was to develop and implement a common
enterprise solution for storing, reporting and analyzing capacity
utilization and downtime metrics for the 23 Downstream-One refineries.
These were key drives in Manufacturing's overall program, impacting safety,
reliability, product quality, cost and margin. The system was to enhance
global business decision-making by giving a global perspective of plant-
performance.
Business Justification:
. Reduction in Manual effort would increase data accuracy, and reduce audit
findings.
. One global system will ensure that all data is reported in the same
manner across the world.
. Improves operational and business decision support.
Role:
. Discussed and modified the database schema to meet all the database
requirements.
. Developed the Business logic, Data Access methods responsible for all
classes within the class-object model using C#.
. Developed utility class and methods for centralized usage of session
variables and accessing configuration files and other identified common
methods.
. Created stored procedures within database for all sought of queries,
using views and user defined functions.
. Implemented error handling through different class and try-catch within
application.
. Used MS Application blocks, database access class and methods.
. Implemented third party controls like, Infragistics webgrid, webcombo,
webdatechooser etc on the user interface.
. Used Master-Content page concept through out the application.
. Creating several user controls to be used within application.
. Coding within presentation layer using C# language.
. Unit testing for the application.
. Developed all screens responsible for master data in the project.
. Coding various client side functions using JavaScript.
. Worked on improving overall application performance by different methods
and at different levels.
. Developed/Coded most significant user screen's responsible for Metrics
creation and Metrics data entry.
. Developed significant reports using SSRS tool.
Environment:
ASP.Net 2.0, SQL Server 2005, JavaScript, C#, Microsoft Visual Studio 2005,
Visual Source Safe, Infragistics 7.1, SSRS
project Lead/Developer Feb 2007 - June 07
Client: Lopez Negrete, Houston - TX
Lopez Negrete is a leading advertising company. They are specialized with
branding for their clients, and building commercials covering print, radio
or television media.
A web solution was required to be building to provide an interface to users
to manage the sharing of files. Users can be from the company itself, or
can be their client users or even any external agency as well. Little other
functionality with support of uploading and downloading files, were keeping
track of approval requests/responses, and comments from all the users for
various files.
Different user roles define different set of rules for
accessibility/permissions to the files.
It also maintains history of files downloaded by different users.
Role:
. Understanding the product requirements by gathering user requirements.
. Proposing the project plan.
. Designed the multi-tier architecture for the project.
. Designed the database schema to meet all the requirements.
. Developed the Business logic layer using C#.
. Developed few utility classes for centralized usage of session variables
and accessing configuration files.
. Created stored procedures within database for all sought of queries,
using views and cursors.
. Implemented error handling through different class and try-catch within
application.
. Used ADO.Net for developing customized database access layer.
. Managed data on presentation with typed datasets.
. Implemented controls like, GridView, TreeView, MultiView, Menu, and
Sitemap Path etc on the user interface.
. Used Master-Content page concept through out the application.
. Creating several user controls to be used within application.
. Coding within presentation layer using C# language.
. Unit testing for the application.
. Preparing system-design, and detailed design documentation, and user
manuals.
Environment:
ASP.Net 2.0, SQL Server 2005, JavaScript, C#, Microsoft Visual Studio 2005.
Sr. Web Developer Oct 2006 - Feb
2007
Client: Eduneering, Houston - TX
Eduneering improves business performance, assures compliance, and minimizes
risk by providing tailored knowledge solutions to corporate and government
clients in the pharmaceutical, medical device, healthcare, energy,
manufacturing, casual dining and food sectors.
Product was developed to integrate with their existing product as a
Learning Management System. The product "PROVE" provides enhanced/extended
features over the LMS. It recommends for every employee what all courses
should be taken on the basis of activities the employee performs.
Role:
. Understanding the product requirements by gathering user requirements.
. Designed the database schema to meet all the requirements.
. Created stored procedures within database for all sought of queries,
using views and cursors.
. As application had to integrate with asp and flash applications/database,
views and web services were developed.
. Used CORDA for the purpose of presentation of reports.
. Integrated the applications database through linked server.
. Implemented error handling through different class and try-catch within
application.
. Used ADO.Net for developing Database access layer.
. Worked on performance improvement of stored procedures/queries by
creating appropriate indexes.
. Coding within presentation layer using C# language.
. Developed various DTS package for loading external data feed within
application.
Environment:
ASP.Net 2.0, SQL Server 2005, JavaScript, XML, C#, CORDA, Microsoft Visual
Studio 2005.
Employer: IAP Company Ltd, Gurgaon
Client: Interra IT (India) Ltd, Noida
Sr. Web Developer April 2006 - Sep
2006
Project: Voxiva
Product developed to allow organizations to collect information from and
communicate with distributed networks of people in a timely and systematic
way. It also provides the tools to organize map and analyze the data
collected and make the right decisions.
It enables real-time collection and dissemination of critical data for
public health and safety and other citizen services through multiple access
methods (e.g., phone, SMS, Web, and fax). It delivers real time analytics
and geo-spatial visualization to decision makers so that they can respond
to information rapidly and effectively.
Complete project was divided into number of modules like, Communication/
Notification/ Invitation/Survey Manager. The product was deployed as on
multilingual platform.
Role:
. Held responsibility of designing and developing Business logic and
Presentation layer coding for Communication Manager, and Survey Manager
using C# as the programming language.
. Built several interfaces and abstract classes, as an application was a
product-based model.
. Developed various other business classes and complex stored procedures
and various user-defined functions.
. Implemented Master/Child page conversion at second phase of the project
development.
. Built various user controls such as Data Filter control using XML files
and VB.NET.
. Developed the interface through which task scheduling was done as a part
of Survey manager.
. Implemented AJAX on few web screens. Clicking on the Link button controls
inside the datagrid control, leaded to display more relative information.
. Used third party controls, i.e Telerik controls as Telerik RadTabStrip.
. Created XSLT style sheet for specific XML Document to extract only
relevant code on basis of different parameters and finally transformation
to custom machine/bit language.
Environment:
ASP.Net 2.0, SQL Server 2005, JavaScript, XML, C#, VB.Net Crystal Reports,
Microsoft Visual Studio 2005, Third Party Controls- Telerik R.A.D Controls
Employer: Software Data India, New Delhi
Associate (Microsoft .Net Developer) Oct 2005 - April
2006
Client: Naval Group Insurance Fund, Indian Navy
Purpose of the system was to provide one-stop solution towards Integrated
Data Management for different functional areas of the Naval Group Insurance
Fund of the Indian Navy.
Functional areas included:
. Loan Management.
. Insurance Management.
. Fund Management.
. Financial Accounting.
. Product was based on multi-tier
architecture. Business layer was written
using C# as the language which contained
all the business rules defined.
. Presentation layer coding was done using
VB.NET and JavaScript as the language.
Role:
. Database designing for the modules.
Prepared necessary transaction based
custom/common
stored procedures.
. Developed various custom .NET components for features such as EMI
Calculator/Charts etc.
. Developed a web service that takes stock symbol as a parameter input and
returns the current values against that symbol.
. Build chat component for LAN using .Net Remoting.
. Necessary validations on the page using .NET validation controls.
. Audit trail model was prepared as another customized .NET component.
. Provided dynamic report generation using Crystal Reports for .NET.
. Presentation layer coding for loan management. Used various data binding
components like datagrid, repeater, datalist etc.
. Created several XSD schema for XML Documents created dynamically for
creating dynamic web screens.
Environment:
ASP.NET, C#, VB.NET, JavaScript, HTML, Crystal Reports, SQL Server 2000,
Microsoft Visual Studio 2003, XML, XSLT, XSD Schema.
Softcell Solutions, Faridabad
Software & Web Developer Aug 2003 - Oct
2005
Client: Life Insurance Corporation of India
Purpose of the system was to store the particulars of various agents
working under each Development officer, and timely announces alerts,
sending automated SMS and emails. Training to new agents and new
features/policy scheme training to existing/new agents.
Functional areas included:
. Storing and manipulating data records of various agents under
corresponding Development Officers.
. Dynamically adding news and alerts to be broadcasted to each agent and
sending SMS/Emails.
. Training schedule and material posting.
Role:
. Understanding of client requirements in the application by interacting
with the end users.
. Preparing documentation and cost estimation by using Function units.
. Database designing and creating useful stored procedures with SQL Server
2000.
. COM component (MS COM) wrapping with the .NET framework 1.1 used for
communicating with GSM Modem for sending SMS.
. Designing the complete architecture of the application. (3 Tier). All
data, business and presentation layer coding was done using C# language.
. Created several XSLT stylesheets used for selecting specific report
format. Because of plenty of report formats, use of XSD schema, XSLT
stylesheets and XML Documents was necessary.
. Necessary validations on the page using .NET validation controls.
. Coding for all administrator pages for preparing and maintaining the
training pages.
Environment:
ASP.NET, C#, VB.NET, JavaScript, HTML, Crystal Reports, SQL Server 2000,
COM, Microsoft Visual Studio 2003.
Project:
Client: Indian Bottling Company, India
Client was using one of the commercial accounting packages available in the
market. But the application was not able to meet all the desired
requirements of the client. Application was built on basis of double entry
system/principle, which was fully capable of keeping all the
records/transactions of the business.
Functional areas included:
. Storing and manipulating data records for all the transactions within
financial year.
. Generating desired financial reports and billings.
. Data archiving/migration of previous/financial years.
Role:
. Database designing and writing all the stored
procedures/triggers and indexes in SQL
Server 7.0.
. Creating all financial reports like balance
sheet, trial balance, profit & loss statement
using Crystal Reports.
. Building Data access layer with .NET
component using C# language.
. Components for reading/writing data from/to
other API's like MS Excel etc.
. Data extracted from SQL was in form of XML.
. All business rules defined within number of
business classes coded with C# language.
. Presentation layer with all client side
validations handled with C# and JavaScript
and
.Net validation controls.
Environment:
ASP.NET 1.1, C#, JavaScript, HTML, Crystal Reports, SQL Server 7.0,
Microsoft Visual Studio 2003.
Education
. Masters of Computer Applications (MCA), IGNOU
Contact this candidate