Hemlata Somani
4477 Casa Grande Circle	 [Send email to request phone number] 28 0201(H)


PROFESSIONAL EXPERIENCE

Triad Financial 	05/07 – Present
Sr. Application Developer
Application: Loan Origination System and OFAC search Web service

Roles and Responsibilities
•	Design and developed Win forms in C# to display all incoming applications in
different queue as per their status and product type
•	Borrower’s information, Credit History, Collateral Contract detail, Employment
Information and checklist for all required documents are displayed under related
tabs.
•	For each application qualifying programs are displayed as per the
FICO,SRS,product, state, and term User can select one program to calculate the
Final Rate and Final PTI
•	Created the Windows service to check for incoming OFAC request and created the
web service using ASP.NET and C# to retrieve information from Source Check
website.

Medical Capital Financial 	03/05 – 03/07
Sr. Application Developer
Application: Web Application for Investors Relations

Roles and Responsibilities
•	Design and developed Web pages in C# and ASP.NET display investors and
corresponding investments list. Different Agents with proper authorization can
view these pages to see their commission report.
•	Web pages created to display interest payments in batches to investors who are
grouped under particular program. Payment Report is developed using XML/ XSLT. 
•	Developed Forms to merge with excel and word document to send automated
letters and notes to investors.
•	Various Reports are generated using SQL Sever database stored procedures to
fulfill end users requirements.
•	Environment: C#, SQL Server 2005

Wells Fargo Home Mortgage	 08/04 – 02/05
Web Application Developer
Application: Web Application to request Verification of Employment for borrower
to expedite Loan Processing.

Roles and Responsibilities
•	Developed Web Pages to be used by mortgage specialist to submit one or more
Verification of Employment for particular Loan. 
•	Developed Web Pages to display all borrowers and their last five employers’
information respectively.
•	Created web service to access Loan information from legacy system, which will
be displayed in the form and SQL Server database is updated according to user
input.
•	Database is updated every time when Loan is accessed to change the status of
particular Verification request and report is generated accordingly
•	Environment: C#, Attachmate Extra.Sql Server 2000/2005 

Open Country 	08/02 – 05/04
Program Developer
Application: Web Application for corporate employee information along with
internal operations like Sales, online news, discussion forums and human
resources.

Roles and Responsibilities:
•	Changes made in Web configuration file to check users authentication and
authorization against SQL database.
•	Used ASP.NET, Web control tags, Validation Controls and Rich Controls for user
interface and VB.NET language as code behind to display Announcements, message
threads and links to downloadable Documents. 
•	Used ADO.NET objects like Dataset and Data Relation to draw information from
database and used connection object like SQL Command to execute stored procedures
for different modules such as upcoming events.
•	Top movers like product category, Revenue and growth can be displayed using
Xml/Xsl transform.
•	Created various Visual Basic.NET forms to display customer, product, and
category detail and orders list.
•	Environment: ASP.NET, SQL Server, ADO.NET, and Visual basic. NET, C#,
JavaScript, Internet Information Server, HTML, DHTML, CSS, XML/XSL Transform,
Visual Studio,

Maternity Leave	 07/01 – 07/02

Lucent technologies 	07/00 – 06/01
MTS (Member of Technical Staff)
Application: Web Application, offering a visual interface to Anypath Unified
Messaging package.  This application provides a quick easy access to user’s
mailbox remotely and could retrieve multimedia message from message server. User
can record and play back voice messages through telephone or sound card.

Roles and Responsibilities:
•	Worked in development of new features called CLI Restriction and Call Sender
for next release.
•	Wrote design document by discussing with requirement people and Telephone User
interface team.  
•	Worked closely with VC++ developers to get new methods and properties needed
by ASP code for implementing the feature.
•	Modified ASP pages to check for CLI restricted property and display/not
display phone Number in GUI.
•	Wrote JavaScript’s to avoid display of phone number in the end users web page
when it is restricted. 
•	For Call Sender feature developed the Visual Basic program to first check Call
back Number field for Call sender and then the CLI field.
•	Worked closely with language group to get new strings in multiple languages
like Japanese, Spanish.
•	Environment: Visual Basic, Classic ASP, COM objects (Visual C++), VBScript,
JavaScript, (IIS) Internet Information Server, Visual Interdev, SQL Server, HTML,
DHTML, XML.

RecruitMAX Solutions 	08/98 – 04/00
Programmer / Web Developer
Application: HR Package.  
Worked in development of web site for online candidate requisition and getting
profiles for submitted resumes. 

Roles and Responsibilities
•	Involved in server side and client side scripting using VBScript and
JavaScript
•	Involved extensively with the ODBC components to interact with SQL Server
database.
•	Used HTML tags like frameset, form, table, anchor, embed and img.
•	Defined various tables and their relationships in SQL Server database and
modified Stored procedures for maintaining candidate resumes, skills, clients and
users.
•	Created various ASP web pages to add resume information from different
sources.
•	Developed Import, Export programs for adding different skills to database.
•	Developed code for multiple search technique and saving commonly used
searches.
•	Developed XML data conversion programs for converting data from Dice format to
proprietary format.
•	Environment: Visual Basic 6.0, Crystal Reports 7.0, Classic ASP, SQL Server,
ODBC, SQL, HTML, XML etc.

NeTec Systems - Ottawa, Canada	 06/97 – 11/97
Programmer
Application: Sales Support System.

Project: Sales Support System

Roles and Responsibilities:
•	Designed and developed forms to be used by telephone operators of a ‘sporting
Goods Company’ to take orders from customers.
•	Developed PL/SQL programs to create, modify, update various tables in oracle
7.0 using Forms 4.5.
•	Customer inquiries, orders, shipment dates and payments status are recorded
using database triggers.
•	Involved in creation of stored procedures for customer stocks status and
pricing.
•	Environment: Oracle 7.0, Designer, Reports.

Computree Inc., Bombay, India 	08/95 – 02/97
Programmer/Analyst
Application: Financial Accounting.  
Developed financial account package to maintain various types of accounts.

Project: Financial Accounting for trading Company

Roles and Responsibilities:
•	Design and Developed table structures with constraints, indexes.
•	The package can handle General ledger for daily transactions.
•	Also maintain Purchase register and Sales register which automatically updates
Cash and Bank books.
•	As per the company requirement Payable and Receivable amounts could be
computed.
•	Facility is provided to maintain Asset, Liabilities and prepare the Balance
sheet.
•	Application: Payroll System.
Developed payroll system for central railway system.