Experiences at ICT - Group

called on tier 4 accounts in N.Y.state who were exsisting customers of Ikon Business Equipment to upgrade or renew current leases.Program was terminated by Ikon.

I made calls for promoting Discover card, Visa, and Mastercards. I also made calls for Green Mountian Electric supplier. To discuss the benefits of changing electric providers.

Designed and implemented the entire Data Access tier that abstracts the physical database from the business layer. The Data Access was designed to dynamically point to Development, QA or

Production databases depending on the host of the application. The class methods from this library also convert the data types provided by XSD schema to Oracle data types. This data access library is used by TAM, inbound XML Web Services and other scheduled processes, which are developed as Console applications / Windows Services. This library is installed in the GAC.

All database processing run in the context of an Oracle Transaction.

Designed and implemented inbound to ICT XML Web Services using the System.XML

(XMLTextWriter, XMLNodeReader, XMLDocument classes) System.Xml.XPath (XPathDocument,

XPathNodeIterator classes) namespaces.

Extensively used System.IO namespace (StringReader, FileStream classes)

All data validation was based on XSD Schemas.

Designed and implemented the application security model and Web Service security model.

Stored application specific data in web.config. Sensitive application data like connection strings are stored encrypted in the registry for more security.

Designed and normalized the database schema.

Implemented the Database Schema using Sequences, Views, Joins, Unions, and Constraints.

Designed and developed Packages and stored procedures returning Ref Cursors to the business layer using PL/SQL on Oracle 8.17.

Implemented Named programmer-defined exceptions in stored procedures to pass error information to the calling application.

Designed and developed application logging using Database Triggers.

Designed and developed exception logs using Exception Management Application Block.

Designed and developed Critical events and error notification by e-mail and paging.

Extensively used Classes from System.Data.OracleClient namespace.

Extensively used structures like OracleDateTime, OracleBoolean, and OracleNumber to convert from values from Oracle to Dot Net and vice versa.

Used the Windows Installer to deploy the application.

All source code along with documentation is to be handed over to the Trane (A Division of

American Standard). The code has to comply with the software coding standards and conventions of Trane.

NDOC was used to create MSDN style Documentation....