ARUNA SUBRAMANIAN
abnmwo@r.postjobfree.com
SUMMARY: An accomplished Information Technology professional with Fifteen
years experience in the design and development of Internet/Intranet
and Client/Server applications.
SKILLS: ASP.NET 1.1/2.0/3.0/3.5, VB.NET, C#, AJAX, WCF, WPF, Winforms,
Silverlight, ODP.NET, Team Foundation Server,ASP, Visual Studio .NET/2008,
Microsoft.Net framework, Sharepoint Portal Server 2003, Hyperion Performance
suite 8.3,HTML, DHTML, CSS,JavaScript,, Crystal Reports,SQL Server 2000,
MS Access, Excel,VBA,Oracle 9i/10, ICVERIFY, QUANTUM, VERTEX,
WEBWIZARD packages, XML, COM, DCOM, XPEDIO CONTENT
MANAGEMENT PACKAGE, Site Server 3.0, XML,MS Project
EXPERIENCE:
05/08 - present Fidelity – Lender Processing Services, Jacksonville, FL
Senior Web Developer
Involved in the analysis, design and development of an internet
application used by Agents/Lenders for managing and generating required
documents for Real Estate Transactions. There are many types of
documents that need to be generated by the Title Insurance Agents and the
Lenders depending on the type of real estate transaction. The rates for the
policies also have to be calculated and the required documents have to be
generated and sent to appropriate parties prior to closing in order to ensure
a smooth transaction and also to satisfy the legal requirements. This
application was designed to be utilized by the Title Agents and Lenders
throughout the nation to generate policies and other documents required
for a transaction.
Tools Used : Visual Studio.net 2008, ASP.net, C#, Oracle 10,
JavaScript, AJAX,Rational ClearCase, Rational Clear Quest
10/06 –06/30 JP Morgan Chase, Jacksonville, FL
Senior Web Developer
Involved in the analysis, design and development of an intranet Fraud
Management application that is used by fraud analysts and fraud managers
to scrutinize loans that are prospects for fraudulent activity. Users have a
loan queue that they look at and this loan queue is populated with a list of
loans that match the user's specialized skill(s). Users will be able to view
loans, clear the rating of the loan or change it to a suspect after close
scrutiny of the information provided. This application is also used by fraud
managers to view or act on loans that need a second review by a manager.
Involved in the analysis, design and development of a Fraud Data
Manager application that is used to process various Loan Origination
System Data. This data would then be processed by another application
Aruna Subramanian 1
called Fraud Engine and third party vendors to identify any loans that raise
a red flag. This data is updated into the Fraud Management System
database which is utilized by the previously mentioned Fraud
Management application for use by fraud analysts and managers.
Involved in the maintenance and enhancement of an EMail Web Service
that is utilized by the IT department to send/receive emails. This web
service is called by other intranet applications within the MIS department
to send an email to the appropriate contacts in the database for error or
other notification(s).
Involved in the analysis, design, and development of an intranet Customer
Management system used to keep track of Customer details, customer
financials and Recertification. This was written as a replacement of their
existing Customer Management System to capture customer details and
also to keep the customer information up to date in order to meet the rules
and regulations for the mortgage industry.
Tools Used : Visual Studio.net 1.1,2.0, ASP.net, C#, Oracle 9I, Sql
Server 2000, ADO.Net, XML, JavaScript
07/05 – 09/06 Wells Fargo, Arizona
Senior Web Developer
Involved in the design, development of an intranet application used for
Payment tracking which tracks payments from various sources and also
produces reports and charts which provide a great snapshot of the data.
This was used by the Management team to keep operations on track and to
assess the current performance compared to past performance. This system
was developed as a replacement of their older payment tracking system. It
also interacts with other existing systems to pull related data.
Involved in creating test scenarios, unit testing and system integration
testing of the application.
Tools Used : Visual Studio.net, Vb.net, ASP.net, C#, Oracle 9I,
Sharepoint Portal Server 2003,Hyperion Performance Suite 8.3
03/04 – 06/05 IPS Sendero, Arizona
Senior Web Developer
Involved in the development, setup and customization of an intranet
application used by financial clients for Budgeting, Planning, forecasting
and financial consolidation. This application is used by the Management
to gain insight into the key performance indicators that drive success and
for budgeting, planning, and decision-making. Involved in creating test
scenarios, unit testing and system integration testing of the application.
Aruna Subramanian 2
Involved in the development and optimization of an intranet Net Income
Projection application. This application is used to project Net Income
from any given financial instrument(s) for a given period of time.The
income projections are based on the parameters entered and can be
projected for a maximum period of 60 months. Involved in creating test
scenarios,unit testing, system testing and performance testing of the
application.
Tools Used : Visual Studio.net, Vb.net, ASP.net, C#,Microsoft .NET
framework 1.1, ASP, Oracle 9I, Excel 2000
09/01 –01/04 Novartis Pharmaceuticals, New Jersey
Senior Web Developer
Involved in the analysis, design and development of a Sales Tracking
application used to track Sales by Region /division/Category/Product
group. This application was used by the Top Management in the Sales and
Marketing Department to track Sales and the progress of the Department
and its teams. This was developed as a replacement for their older system
written in Excel. Involved extensively in System testing and
implementation of the above system.
Tools Used: Visual Studio.net,ASP.net,VB.net,C# and Oracle8I
Involved in the analysis, design and development of an intranet
application used to keep track of budgeted and actual marketing costs by
different brands of drugs. This application was used by the Sales and
Marketing Department to keep track of the costs. Charts for the web
application were created using Popchart a chart generating tool.
Tools Used: ASP,Oracle 8I, Javascript, Vbscript, Popchart Live,
Popchart Builder, Excel, VBA
03/01 –07/01 Pfizer Pharmaceuticals, New Jersey
Project Lead
Involved in the analysis, redesign and development of an intranet Time
reporting system used by the R&D department to keep track of
development cost by project and skill set.
Managed and lead a team of developers involved in the project.
Tools Used: Windows 2000, COM+, Asp, VB6, Oracle 8I, Crystal
Reports 8.5,Javascript, VBscript, ADSI, Visual Sourcesafe
Aruna Subramanian 3
11/99 - 09/00 Merrill Lynch, New York City
Lead Sr. Web Developer
Involved in the design and development of Content Management System
using Xpedio to manage the submission/publication of web content. Wrote
components to customize the Xpedio product to Merrill’s requirements.
Involved in the maintenance of Content Management System developed
using Site Server 3.0 and Visual basic 6(COM/DCOM) and ASP. This
was later replaced by the new system. This was initially used to manage
the web content/images.
Involved in the design and development of visual basic/xml based tool that
was used by the Application setup team to help facilitate the updates to
various software applications.
Tools used:Visual Interdev 6.0, JavaScript, VBScript, Active Server
Pages (ASP), Visual Basic 6.0,XML,Xpedio Content Management
Package,Java,Site Server 3.0, xml
11/97 – 10/99 SECURITIES TRAINING CORPORATION,
New York City
Lead Web Developer
Involved in the development of Web based E-commerce Order Processing
system where customers can place orders through the Internet/Intranet.
Real time credit card processing was done by interfacing with IC-VERIFY
package. Sales tax calculations were done using QUANTUM package and
interfacing was done through custom-built Active-X components and
custom DLL.
Setup QUANTUM package's Sales & Use Tax module and Returns
module.
Managed Web-site setup and administration on IIS 4.0 web server. Fine
tuned SQL server stored procedures to enhance performance.
Tools Used: Visual Interdev 6.0, DHTML, JavaScript, VBScript,
Active Server Pages (ASP), Crystal Reports, Visual Basic 5.0, VC++
5.0, Macromedia Dream Weaver.
Aruna Subramanian 4
10/96 – 5/98 SYSTEMS & SOFTWARE, New Jersey
Project Lead /Senior Web Developer
Designed and developed multimedia based web applications and applets
using HTML, CGI/Perl, Java, JavaScript and cold fusion. Involved in the
development of Online Customer Tracking Information System using
Java, which keeps track of customer queries and maintain the data for
Customer Support Engineers. JDBC and Servlets are used for server side
programs and database management.
Involved in the development of Production Planning System using
•
Java and JDBC system, which facilitates and provides the data for
Sales Department, Purchase and Finance Departments.
Involved in the development of Complete Inventory Control System,
•
online evaluator using Java.
Involved in the design and development of COM ActiveX Controls
•
and java beans (using Java and Visual Basic), Active Server pages and
JavaScript based interactive applications with Oracle and SQL Server
Databases.
7/96 – 6/97 KPMG PEAT MARWICK, New Jersey
Senior Programmer/Analyst
Involved in the design and development of a package called ARTS (Area
Recruiting Tracking System) used by KPMG Human Resources
department to facilitate recruitment of personnel from various sources
including colleges. Individually coded various GUI front-end screens and
related Script. Used Access/95 database to store various information and
also for reporting purposes. All coding was done using Visual Basic
3.0/4.0 and Crystal reports. Independently responsible for Unit Testing
and System Testing. Also responsible for End-User training. Provided
production support and enhancements to ARTS system.
Involved in the design and development of a SALARY REVIEW
•
system. Employee Data was downloaded from a Mainframe system
into an ACCESS database. Various forms were designed which
loaded employee information such as current salary, bonus,
performance details, which were used by Area Administrators, who
determine any salary hikes/bonuses to be given based on performance
and various other factors. Independently designed and code Various
Salary review reports using Access.
Involved extensively in System testing and implementation of the
•
above system.
Tools Used : Visual Basic 4.0, Access 95 and Crystal Reports.
Aruna Subramanian 5
5/96 – 7/96 ALFRED DUNNER INC., New Jersey
Senior Programmer/Analyst
Solely responsible for the development of Purchase Order Entry system.
Designed Database layouts, Graphic user interface, and provided end-user
training. All development was done using Access 95 in Windows 95
environment running on a LAN.
Tools Used : Access 95
12/96 – 4/96 COAST-TO-COAST CONSULTING INC., New Jersey
Programmer Analyst
Developed a multi-user Customer Order Entry System using Visual Basic
4.0, SQL Server 6.x and Crystal Reports on a Windows NT server where
clients run Win 95.
Developed programs for a Purchasing and Receiving system using Visual
Basic GUI front-end and SQL Server back end. Used Crystal Reports to
print reports. Developed programs for Invoicing module using Visual
Basic 4.0 and Access 95 and Crystal Reports.
Tools Used : Visual Basic 4.0, Sql Server 6.0, Access 95 and Crystal
Reports.
9/92 – 8/95 GOODWILL EXPORTERS LTD.
Programmer
Developed Purchase Order system, which allows users to enter and
maintain PO's, inquire by PO information by vendor. Also print
Open/Closed/Suspended purchase orders report. Also wrote master
maintenance programs to maintain Vendor, Product master, Pricing tables.
All development was done using Access 2.0, Oracle and Visual Basic 3.0
and Crystal Reports in windows 3.1 environment.
Team member in the development of a Customer Returns processing
system. System keeps track of customer returns and gives appropriate
credits against valid returns. The system was developed using Visual
Basic 3.0 front end and Access back-end.
Developed programs for Accounts Receivable Tracking system. Wrote
programs for AR inquiry, Aging analysis inquiry and Aging reports. All
programs were written using Access 2.0.
Team member in the development of a Sales analysis system. Wrote
programs to print Sales Analysis reports such as Sales by division, Sales
Aruna Subramanian 6
by region, sales by product group. Sales figures included comparison with
Actual versus Budgeted figures. All programs were developed and
implemented using FoxPro.
EDUCATION:
Cayuga Community College - Certificate Course in C programming
Diploma in Computer Programming
Institute of Cost and Works Accountants of India – Intermediate
Intermediate level in Cost Accounting
BS in Chemistry
Aruna Subramanian 7