.Net Sql Server Developer Application Data Oracle
Resume:
AMIT KOHLI, MCP
**** ***** ***** ****, ******** City TX 77459 Res: 281-***-**** Cell:
E-mail: ****.*********@*****.***
TECHNICAL SKILLS
Languages/Technologies: C#, VB.Net, ASP.NET, ADO.NET, SOAP, UDDI, Web
Services (.Net), ASP, Visual Basic, T-SQL, PL/SQL, XML,
XSL, XPath, JavaScript, VBScript, DHTML, HTML, CSS, UML
Database Technologies: SQL Server 2005/2000/7/6.5, Oracle
11i/10g/9i/8i/7.3, MS Access
Operating Systems: Windows Server 2003/XP Professional/2000/NT, DOS
Middle-Tier Architecture: COM+, COM, MTS, IIS
Software Packages: MS Visual Studio.Net, MS Visual Studio 6.0, Crystal
Reports, MS Visual Source Safe, PVS Tracker, MS Visio,
JBuilder 3.0
Web Controls: Microsoft .Net DataGrid, Tree Control, ComboBoxes, Tab
Strip Control; Telerik, Infragistics UltraWebGrid 2005
(ASP.NET), WebTabControl, UltraWebMenu;
ProtoView/Infragistics DataGrid, Tree Control; DataDynamics
Pivot Table (Cube Control); SoftwareFX ChartFX
Professional EXPERIENCE
Smith International, Houston, TX 02/2010 - Present
.Net Architect
. Responsible for maintenance and enhancement of a customized .Net
application (Web Forms/.Net 3.5) for mining heart monitoring data.
Utilizes MS Enterprise Library - Data and Caching Blocks; Log4Net for
logging.
. Technologies used include C# (3.5), Silverlight, WCF, WPF, Entity
Framework & SQL Server 2008, CSS/Skins.
. Telerik controls used - AjaxManager, LoadingPanel, AjaxUpdateControl,
TabStrip, PageView, RadGrid, Slider, etc.
Velite Capital Management, Houston, TX 02/2009 - 01/10
.Net Architect
. Responsible for maintenance and enhancement of a customized .Net trading
application (Win Forms/.Net 3.0) covering profit and loss (P&L),
exposure, market risk, deal entry and reporting for physical products
(Natural Gas), futures and options. Utilizes MS Enterprise Library - Data
and Caching Blocks; Log4Net for logging.
. Technologies used include C# (3.0), SQL Server 2005, Web Services, Excel
2007 VBA and Shell scripting.
. Connected to ConfirmHub API for deal reconciliation for trades executed
on CME, NYMEX and ICE. XLInq used for XML parsing.
. Created SSIS process to retrieve settle pricing data.
. Redesign P&L process for Historical data and AUM/VaR reporting. Reports
created in SSRS.
. Maintained various front office trade control C# .Net web applications.
(ASP.Net 3.0).
. Created PL/SQL (Oracle 11i) packages, stored procedures and triggers.
. Created Access 2007 VBA forms.
. Partially converted Win Forms application to WPF. Utilized WPF toolkit
and MV-VM.
Stanford Financial, Houston, TX 12/2008 - 02/2009
.Net Architect
. Gathered requirements; provided system design and development for an n-
tier, object oriented .Net 3.5 (VS 2008) web application, utilized
Telerik Accordion, AjaxManager, LoadingPanel, AjaxUpdateControl.
. Repository created using Entity Framework. Backend is SQL Server 2005
. Developed unit tests using VS 2008 Test Project Template.
. MOSS 2007 - Developed custom web parts.
Spectra Energy, Houston, TX 10/2007 - 11/2008
.Net Architect
. Gathered requirements, provided system design, and developed n-tier,
object oriented .Net 2.0 C# applications in Web Forms, Windows services,
and Web Services utilizing multi-threading, Generics, etc.; and their
corresponding unit tests, XPath, XSLT. Backend is SQL Server 2000 and
2005
. Duke Energy Interface Service: Windows service for data (flat-file format
to SQL Server and vice versa) integration between various third party
software applications for gas measurement and accounting, utilizes
Remoting and SonicMQ Messaging component.
. Gas Quality Lab Analysis: Web Forms application that is a client to a Web
Service (SOA) for data entry and reporting. T-SQL and Sybase on backend.
Reports implemented via SSRS. Utilizes MS Enterprise Library - Data,
Logging and Caching Blocks.
. Domain Specific Framework Application: Enhanced framework application
utilized by other in house applications for standardized functionality
viz. serialization, caching, data access, etc.
. Created script in C# to extract attachments from emails in Outlook,
authenticated using Active Directory.
. Supported user base for GMAS, backend Sybase, maintenance of Perl
scripts.
Halliburton/KBR, Houston, TX 11/2005 - 09/2007
Project Lead
. Rotated through multiple .Net 2.0 n-tier projects in iterations of
requirements gathering, system design and& architecture, development,
refactoring, and testing. Implemented TDD (using NUnit) for the middle-
tier which is object-oriented and multi-threaded (background worker
component and thread pool)
. Candidate Management System Project: ASP.NET 2.0, Web Services, User
Controls, C# 2.0, SQL Express
. Correspondence Tool Project: WinForms, C# 2.0, Documentum API, Oracle 9i
. Expense Report Application: WinForms, C# 2.0. The application integrates
with the corporate SAP database (Payables module)
. Risk Management: ASP.NET 2.0, C# 2.0, front end VB.Net 2.0, Oracle 10g
PL/SQL
. Middle East Security: ASP.NET 2.0, Ajax, C# 2.0, SQL Server 2000
. Risk Control Tracking System: Developed and maintained SQL Server 2000
jobs
. Prototyped a Windows Forms application for candidate location tracking
using NHibernate with SQL 2000
Landata Systems, Inc., Houston, TX 12/2004 - 10/2005
.Net Architect
. Developed, enhanced, and maintained multiple enterprise n-tier object-
oriented applications for the real estate title industry
. Technologies included Web Services (SOA), Web Forms, Windows Forms,
ASP.Net, C# (middle-tier business objects), XPath, XSLT and SQL Server
2000
. Maintained and Enhanced EC Gateway - a message based web service.
. Used NUnit to create unit tests for all the applications worked on as
part of Agile development.
. On two of the projects, also functioned as a business analyst. Met
regularly with the end users to understand/define requirements and create
use cases prior to coding the application
Tek Systems, Houston, TX 09/2004 - 11/2004
Project Lead
. Designed an object-oriented shopping cart for a high school
enrollment/supplies web application. Some of the patterns used were
Abstract Factory, Singleton, Composite, Fa ade, Iterator, Controller,
Template, and Strategy
DISA Inc., Houston, TX 05/2004 - 08/2004
. Created custom ASP.NET web controls in C#
. High-level reports for senior management using SQL server stored
procedures and Crystal Reports
. Enhanced COM+ objects (VB6)
. Trained clients and users on the DISA custom application
. Authored manuals for clients and internal users for installation and
implementation of DISA custom application
. Created/scheduled jobs in SQL Server to aggregate application data on a
nightly basis
Riversand Technologies Inc., Houston, TX 02/2004 - 05/2004
Senior Systems Architect
. Architected an ASP.NET, n-tier reporting application in C#. Backend is an
Oracle datamart in snowflake schema. Leveraged HP custom web controls for
menu and user controls for data entry
. Application conforms to object oriented design. A strongly typed state
object is used to maintain the user's filter selections (Singleton
pattern), and in turn is persisted to the database (to an Oracle BLOB
data type) using the .Net framework's Serialization namespace's
BinaryFormatter class. The application also leverages the User Interface
Process blocks for encapsulation of flow control and state maintenance
for specific use cases (MVC Pattern)
. Designed application specific database for storing queries and security
maintenance
. Created a web-setup project with launch conditions for deployment of the
application
. Used NUnit to test the middle tier and data layer
. Coordinated the efforts of two other team members, an ETL programmer who
created mappings to load the datamart using Informatica and a junior
developer whose responsibility was to develop the front end
Halliburton/KBR, Houston, TX 06/2003 - 01/2004
Consultant
. An ASP.NET, n-tier application written in VB.NET that functions as a
front-end engine for single-table maintenance of any database. The
application utilized Infragistics' NetAdvantage Suite (Web Grid, Web Tab
and Web Menu controls)
. All the controls on the web pages were built dynamically based on
settings in the database i.e. for page and grid configuration
. Created user controls to implement the menu for the application
. Implemented data caching and custom paging to improve performance by
using an overload of the DataAdapter object's Fill method
. Created a work-around to display client-side message boxes to users to
indicate procedure completion of server-side code (i.e. after postback)
. Implemented fragment caching in user controls using the VaryByParam
attribute
. The application used multi-threading to improve performance
Datacert, Houston, TX 01/2003 - 05/2003
Consultant
. Worked on a .Net web-enabled application to facilitate e-billing for
legal firms
. Created business objects and Web Forms/code behind in C# and stored
procedures (T-SQL) for data retrieval for generating Crystal Reports
(drill-downs and on-demand sub-reports)
. The reporting module was architected to be data-driven and the report
objects and the business objects/methods that populate them were
instantiated dynamically using Reflection Assembly's GetTypes and
CreateInstance methods
. Created indexes on key fields in SQL Server 2000 to improve query
performance
. Wrote triggers in T-SQL for SQL Server 2000 to aggregate data on
insertion/modification to improve report performance
Woodlands Technology LLC, The Woodlands, TX 07/2001 - 11/2002
Web Developer
. Worked on a .Net intranet application to analyze/reconcile monthly
invoices for high speed bandwidth usage with internal records. The n-tier
ASP.NET application (code-behind and business objects) was written in
VB.Net. It references assemblies for data access, error-handling and
security written in C#
. Implemented global exception handling using .Net namespaces viz.
Diagnostics, SessionState, Configuration, etc. in conjunction with
attributes of the Web Config file's System Web node
. Created Crystal Reports using the features included in .Net. Created sub-
reports, cross-tab, and list reports
. Extensively used user controls to provided calendar controls
functionality and for maintenance of search criteria on pages
. A customizable ETRM application - utilized to manage the risk component
of trading operations (focus on energy and bandwidth) by providing
comprehensive portfolio valuations and sensitivity analysis. The n-tier
application is web enabled via ASP pages utilizing Microsoft DNA calling
custom components written in VB6 (COM+) using ADODB to connect with the
Oracle 8i backend
. Converted retrieved data into XML strings in the backend (Oracle
packages) using string concatenation - returned as ref cursors to ADODB -
or in the middle tier (data services layer) using the XML DOM. This was
passed via the business services layer to the front end where it was
stored in local variables as a DataSource that was navigated using the
DOM
. Used remote scripting with the XML http object to implement multiple
dependent dropdowns in client-side VBScript
. Used multiple DataGrids or tree controls on web pages to handle one to
many relationships. The data in these web controls was loaded and saved
using hierarchical XML navigated via the DOM
. Used XSL to create the menu for the application using the TransformNodes
method for the XML and XSL objects in a JavaScript file
. Various formats of data display implemented using tools such as ChartFX
(histograms, bar charts) and pivot tables. The data to be displayed was
extracted from the client-side XML data source by creating nodelists
using XPath queries, if required, recursively
Maxim Group, Houston, TX 04/2001 - 07/2001
Web Developer
. Worked on a 2-tier ASP intranet supplier management system, oil industry
safety standards were also incorporated into the application. Various
cross-sections of information were made available to the users, the
criteria being suppliers or their individual contracts and the various
corporate entity levels such as Location, Business Unit, Operating
Center, etc. Responsibilities included enhancement and maintenance of the
application
. Complex table relationships displayed using outer-joins in embedded SQL
to interact with the Oracle 8.0 backend
. Created reports to be displayed as HTML or in Excel format using
response.contenttype = "application/msexcel.vnd"
. Extensively used DHTML to enrich the user experience and mitigate the
number of trips made to the server
. Used DHTML to implement a drop-list based name search functionality
similar to that in Outlook, and for multiple dependent list boxes
. Created indexes in the backend to improve performance
Essential Technology Group, Houston, TX 02/2000 - 03/2001
Consultant
. Worked on an intranet application designed to automate the order
processing for a publishing fulfillment firm using ASP - VBScript for
server side scripting and JavaScript for client side scripting. Backend
used MS Access as a test database and SQL Server 7.0 as a production
database
. Worked on an intranet application for Proactive Intelligence, Inc. The
application is a comprehensive student management system for high school
level and below. Parents can log in and check their child's grades,
attendance, etc. in real time. Business rules were implemented using
stored procedures. Various reports were developed according to the users
specifications for display in HTML format
. Maintained and enhanced website www.esstechgroup.com. Used ColdFusion,
PL/SQL, HTML/DHTML, JavaScript, CSS, and Oracle Application Server
. An intranet application (Product Configurator) for an air-conditioning
manufacturer. ASP, Javascript, COM+.
. An intranet application for employees to view their respective scores in
Employee Referral Scheme. GUI was developed using applets with JDK 1.3.
JDBC was used to access information from the backend. Developed servlets
to handle requests and responses at the server side. Used Access backend
and designed and normalized the database
CompQSoft, Houston, TX 11/1998 - 01/2000
Web Developer
. Assisted in creating and beta-testing shopping cart application, classic
ASP, SQL SERVER 7 stored procedures.
. Tested application for browser compatibility
. URL: http://www.elinkages.com, http://www.passion4art.com
. Developed a Safety Observation System for workers on oil rigs. It keeps
track if the safety system is being followed by the workers. It also
generates graphs and charts to accurately indicate of areas where there
is a safety hazard
. Environment: Visual basic 5.0, Oracle 7.3, Crystal Reports and Windows NT
Adani Exports Ltd., Ahmedabad Gujarat, India 01/1998 - 09/1998
Manager Imports
. Held responsibility for all matters relating to the Directorate General
of Foreign Trade such as preparation of applications for special import
licenses, Duty Entitlement Passbook certificates, and Advance Licenses
for all items exported.
. Commercial negotiation for consideration towards sale of licenses
obtained to other trading organizations
Gujarat High Tech Industries Ltd., Gujarat, India 06/1992 - 12/1997
Executive Director
. Finalized all purchase contracts such as import of coal from South
Africa, packing material (HDPE woven sacks) and transport requirements
for packed cement by truck, rail and sea
. Set up systems for vendor selection and evaluation
. Maximized utilization of continuous 24 hour, 3 shift cement packing plant
with truck placement for three types of cement
. Coordination of banking activity towards issuance and redemption of
letters of credit
Controller, Marketing
. Closely involved in computerization of accounts from inception stage,
selection of software and recruiting of personnel for utilizing the
software
. Developed reports for decision support systems for purchasing,
distribution and sales
. Developed dealers network in high margin market (within 250 miles of
radius of manufacturing facility)
. Maintained constant interaction through promotional efforts with dealers
to motivate them to meet sales targets
EDUCATION
BBA Operations Research and Management Information Systems, University of
Texas, Austin, TX (1992)
Bachelor of Commerce, Dr. Babasaheb Ambedkar Open University, Gujarat,
India (1997)
CERTIFICATIONS/training
Developing and Implementing Web Applications with Microsoft Visual C# .NET
and Microsoft Visual Studio .NET (70-315), Microsoft
Developing and Implementing Web Applications with Microsoft Visual Basic
.NET and Microsoft Visual Studio .NET (70-305), Microsoft
XML and related technologies (Test 141), IBM
Design Patterns (2/1/08), UML, Web Services Concepts, C#, ASP.NET, VB.Net,
ADO.NET, .NET Framework, ASP, JavaScript, VBScript 5.5, HTML 4.0,
Brainbench
Instructor for Comp-u-Learn, Houston; VB.Net, ASP.NET, Visual Basic,
JavaScript, DHTML
Contact this candidate