Sobhraj

Summary:

Over 6 years experience in Information Technology with a focus on distributed Client/Server and web enabled applications, specifically on C#, ADO.NET, ASP.NET, C++, SQL server (T-SQL), Oracle and dBase.

Good Expertise in Architectural design, development and implementation of applications with concentration on the designing of systems using Rational Rose for UML.

Experience in Database Programming and Development using SQL Server, Oracle, Access and dBase to include Database Architecture, Logical & Physical Design, Backup, Restore, and Data Integration Performed SQL script with DDL commands for creating Database objects (tables, indexes, triggers, Views, and stored procedures).

Expertise with full Project Life Cycle, have excellent team spirit, communication and interpersonal skills and works well in a team environment.

Expertise in developing Web Services using .NET framework and integrating the functionality of the existing COM components into .NET applications.

Knowledge of XML based data transfer using Diffgrams and creating XML datasets for ADO.NET

Improving performance of the application using T-SQL efficiently and using stored procedures.



Education: Masters in Computer Science. University of South Carolina.

Microsoft Certified Application Developer in Microsoft



Technical Skills:



O/S:Windows 2000/NT/98/95, UNIX (Solaris 2.x), LINUX.

Languages:C#, C++, VB.Net, SQL, PL/SQL, T- SQL, JAVA, C, Crystal Reports and UML

Web Technologies:ASP. Net, ASP, ADO. Net, Infragistics .NET Controls, ADO, XML, XSL, XSLT, HTML, DHTML, VBScript, JavaScript, PHP, and CGI Cold Fusion, CSS, OLEDB, FrontPage, Page Design, Visual InterDev, and Visual Source Safe.

Middleware: COM/COM+, DCOM and MTS

Databases:SQL Server6.5/7.0/2000, Oracle 8.X/7.X, MS Access and dBase.

Web Servers:Microsoft IIS, MTS

Packages: Rational Rose and Visio



Work Experience:

Sr .Net Developer

Bank Of America GWIM,Sep 2005- present

Project: Wealth Management Online

This application aggregates consumer, investment, trust and revolving accounts held by the premier, private and ultra high net worth clients associated with the bank. Users have the ability to view reports on their portfolio data and watch market data feed from Dow Jones. They also have ability to create groups of accounts and run reports based on these groups and communicate with the relationship manager for their specific requests.

Responsibilities:

Forms authentication used for the web application and users are entitled to various tabs within the application based on their line of business.

C# is used for the web application and all the middle tier web services.

Extensive use of user controls to allow reuse.

Oracle is used as the backend.

Involved in design and implementation of the modules within the application.

Used Microsoft Visual Source Safe to manage source code.

Involved in developing ASP.NET pages with client-side script using JavaScript.

XML is used extensively for data transfer.

Implemented functionality for download of reports to excel and pdf.



Sr .Net Developer

Wachovia Securities CIB,Aug 2004 Aug 2005

Project: Matrics (Public Portfolio Management)

This is a trading application used by associates in the bank to do the trading on behalf of their clients. Data from private portfolio is not accessible for the trading application to ensure compliance rules are met. This application aggregates bonds, stocks, derivatives and equities and these can be searched on tickers and cusips.

Responsibilties:

Enhanced security to ensure only public data can be viewed through this application.

AllFusion Harvest is used for version control..

Created ASP.NET User Controls to reduce complexity of user interface design.

Involved in Database Design of the application, creating Complex Queries, tables and indexes and writing stored procedures using SQL Server 2000.

Responsible for technical support, enhancements, troubleshooting, testing, monitoring and maintaining the application.

Involved in implementation and debugging of the web application in C# .NET.

Responsible for technical support, enhancements, troubleshooting, testing, monitoring and maintaining the application.

Extensive use of Stored Procedures to reflect business requirements.

Project: Pipeline

This is a comprehensive application covering commercial loans from inception to pay-off. Includes the ability to track developing information during offering and acceptance as well as loan balance and status during the life of the loan. Application includes graphical data representation with comparative and search functions. This is a pre-portal process before business users within each industry can service the loan request.



Project: Portal Project (Private Portfolio Management)

This intranet application is aimed at implementing a common system for various business units for portfolio management of various high-end customers that Wachovia serves. After the pipeline process of creating a deal each business unit tracks and grades each customer based on the credit risk rating given by the Credit Risk Review. Each business unit has its own set of factors that it uses to determine the grade for each Obligor and obligation a customer has.

Responsibilities:

Involves wrapping security throughout the application to allow business users to service only customers within their industry.

Implement the worksheets to determine the grade of a customer for each business unit and tied them to Credit Approval and Loan status change forms.

Tracking the deals from initial offering, to acceptance and final pay-off of the loan.

Clients are assigned to servicing business unit using client assignments module.

Strong use of user controls to allow optimal code reuse.

Extensive use of JavaScript for client-side validation.

SQL server is used as a backend.

Used Microsoft Data Access Application blocks for database access.

Used C# .NET for implementing the whole application.

Business logic and user-Interface are separated in 2 layers. UI is separated from database access layer.

Consumed web services for getting information from a different project group to get a unique identifier for each new customer that is created through this application.



Sr .NET Developer

JP Morgan Chase, New York City (Client)May 2003 June 2004

Project: Link Enterprise

Linke-JPMC, a financial product is being developed for JPMC using .NET MVC Architecture. This application involves calculation of Pay packages for Employees going out on Assignments to any part of the world. This Application has various modules including Core UI, Core Components, Pay Staging, Cost Projection, Imports-Exports, Dom-Relo, Allowances, and Expat. This application provides provision for calculation in four currencies (Home, Host, Base and Additional) and an Employee has the option of splitting his Compensation in these four currency options. This application provides Cost Analysis by creating What If Illustrations where you can put different employee options and arrive at an amount. You can create multiple What If Illustrations for an Assignment. Based on the analysis, specific Employee can be chosen for the Assignment. This Application was developed to handle both SQL Server and Oracle 8i/9i databases.

Responsibilities:

Senior Developer involved in the design and Implementation of Complex User Interface, Middleware Business Components, System Integration and deployment of the application.

Worked extensively in the Currency, Assignments, Allowances and Illustration using ASP.NET web forms.

Developed Data Access, Action, Business Object and Wrapper classes using C# and C++.

Developed ASP.NET Web Services using C++/C#/SOAP to encapsulate business logic components to be used in distributed environment.

Involved in creation of XML files from the UI to be sent to the component for processing.

Created the ASP.NET pages that intercept the request from the UI and passes it to the appropriate Component for further processing.

Extensive use of Infragistics Net Advantage third party .NET controls in ASP.NET web pages.

Middle-tier Components used XML DOM to process the incoming request from the User, while the response would come out as XML, which was formatted using XSL.

Involved in the creation of the XSL templates for converting the incoming XML.

Involved in creation of JavaScript scripts for Client side validation.

Created Components for implementing the Business Rules for the above modules.

Created Components for database operations in the above Modules, all Components were deployed in COM+.

Environment to make use of the Transactional features and the Security features offered by COM+

Created Stored procedures for both SQL Server and Oracle Databases using TSQL and PL/SQL

Created Triggers, Views, and Indexes for the above modules, which were used extensively for Reports.



. NET Architect/Sr. Programmer

Bell South SBS, Atlanta, GA Oct 2001 Apr 2003



Project: XML Web services

This XML web service is aimed at providing an activation key for the Discrete Trial Trainer software to control the usage of the software by the clientele. The request to the web service is automatically generated when the client installs the software or tries to update the software after expiration. The client software is written in C++ to generate a web method request and handle the response from the web service.

Responsibilities:

Design and develop the ASP.NET XML web service using C#.

Involve in System Software Life Cycle design, development, Testing and documentation.

Good use of XML based Test Harness for performance testing of the web services.

Responsible in preparation of system specs, development of various backend SQL Stored procedures needed to develop business logic, application logic and highly involved in the database design.

Write programs for loading data to XML Files and programs for transforming XML data.

Responsible in the coding and unit testing of the systems, which include data analysis, data access, data structures, data manipulation, technical and user documentation, and software conversions.

ADO. Net is used for database connectivity and SQL DB data provider was used.

Extensive use of T-SQL for ADO.NET

Bell South SBS, Atlanta, GA

Project: E-Bill pay

E-Bill pay module provides variety of convenient bill payment options through internet like onetime Direct Debit, Recurring Direct Debit, Onetime Credit Card and Recurring credit card options.

Responsibilities:

Develop data services, Business services for Bill pay module using C#. Net, ADO.Net.

Develop front-end screens, implement client business rules, coding of application logic in ASP.NET, C#. Net utilizing the power of Microsoft .NET Framework.

Create Dynamic XML files and XSL for presentation.

Developed ASP.Net pages using web form, server, validation, user controls.

Good use of ASP.NET Web Forms, web services, ASP.NET applications, ASP.NET state Management, ASP.NET caching features, configuring ASP.NET optimizations, securing ASP.NET web application.

Use C#. Net to develop COM components.

Use ADO.Net extensively to interact with oracle and SQL 2000 databases.

Create stored procedures, triggers in SQL Server and packages in Access.

Create windows and web services using C# and exposed them through SOAP.

Use C#. Net for Remote to host Remote Objects in IIS and Window Service.

Deploy the crystal reports over the web using ASP.NET code.

Use XML, XSLT for data handling and rendering.

Use Application-Level error handler to detect and write errors into Event log.

Create XML files and XSL for Presentation and transferring Data.



Software Developer

The Bank of New York, New York Aug 2000 - Sep 2001

Project: Data Host System

Data Host System transfers Unit Investment Trust Information between the Bank of New York DB2 and Merrill Lynch Oracle Databases. This application is web-enabled using ASP, VB6, VBScript, JavaScript, HTML, DHTML, ADO and Microsoft SQL Server (T-SQL).

Responsibilities:

Involved in the DB2 Data Base design. Designed and developed the DB2 stored procedures.

Involved in the data base design. Developed stored procedures, functions and triggers.

Supported and maintained several VB6 applications.

Developed a VB6 Business Component ActiveX dll. DCOM, MTS





References: Available on request