VIJAYA RANGARAJAN
New Jersey
[Send email to request phone number] 40-9055
[Send email using form at bottom]
SUMMARY OF QUALIFICATIONS
· More than ten years of experience in the Software Industry.
· Proficient in C#, VB.Net, ASP.Net, MS SQL Server 2000, Sybase 11.x.x, MS
Visual Basic 6.0, Active Server Pages, IIS, MS Access, Unix, COM.
· Well Conversant with Database Application Design and Programming, Data
modeling, designing, developing, performance tuning. Query optimization, use of
show plan, statistics I/O time etc.
· Knowledge of Software quality assurance (QA/test plan, test case/script,
testing)
· Have Application knowledge in:
o Investment Banking and Securities Trading
§ Fixed Income (Mortgage Bond, Convertible bonds, Coupon Rate, Money Market,
Returns), Futures, Tax lots, Settlements.
o Insurance (Policies Issue Tracking and Resolution)
o Pharmaceuticals
§ Office Management (Personnel Information, Time Office)
§ Costing
§ Health Care
· Excellent Communication and interpersonal skills
· Good team player.
SKILLS
GUI Languages: ASP, Visual Basic 5.0/6.0, C#, VB.NET, ASP.Net (.Net 2.0),
Web Services
Relational Databases: SYBASE (11.5&11.9.2), SQL-Server (7.0) SQL-Server 2000,
Oracle 8.0, MS-Access 2000
Programming Languages: Shell Programming, Perl 5.0, HTML, and XML
Scripting Languages: VB Script, JAVA Script, SQL, T-SQL
GUI Tools: FARPOINT Controls, Sheridan Controls
Database Tools: DBArtisan, DTS (Data Transformation Service)
Modeling Tools: ERWIN
Report Writer: Crystal Report Writer, Microsoft Reporting Services
Operating Systems: Unix Solaris, Windows NT 4.0, Windows 2000
EXPERIENCE
Stress Factory Comedy Club Programmer(telecommute) 12/07 - 04/07
Tix system is an online reservation system for the comedy club, so that the
customers can purchase their ticket on their website. The system accepts their
credit card and charges them a gateway software.
This system is developed using ASP.Net, C#, MS SQL SERVER 2005 and MS Reporting
Services.
ElephantGroup Programmer Consultant 09/06 – 11/07
Homes Reconciliation is a tool developed in three tier technology using OOD and
OOP that helps the management and financial department to monitor the inflow of
the revenue for the company. It keeps track of the orders, payments and
integrates with the company accounting system. It also picks up the punch card
data from punch machine using filesystem watcher. This system is developed using
C#, ASP.Net, VB.Net, Winforms, ASP.Net, .Net Framework 2.0, SQL SERVER 2005 and
Microsoft reporting service, JavaScript.
Role:
Presentation Layer:
Developed different UI screens using latest tools like AJAX
Did asynchronous programming (Using delegates and multithreading) for better
presentation.
Used Screen Scraping technology to retrieve the data from other website.
Developed drill down reports using Microsoft Reporting Services.
Business Layer:
Developed webservices as the middle tier for business rules.
Developed in OOP with each business as objects and sent to WebService.
FileSystemWatcher to read the CSV file that is created in a folder.
Developed methods to read from FTP site.
Components:
Developed components to screen scrape any details from
any website.
Modified and maintained a component that display an error message when an error
occurs in salesforce software using TCP/IP classes, Relay Station.
Automatically picks up an email from the POP3 server and reads its contents and
reads the attachment files and saves it in database.
Database Layer:
Designed and created the complete database schema with
audit trails.
Developed stored procedures and User defined functions for data retrieval and
data storage.
Did performance tuning of the stored procedures by optimizing the queries and
involved in complete maintenance of database using DTS and BCP.
Created the logical data model to ensure high performace of the query.
Deployment:
Used ClickOnce technology for the deployment.
ADP, New Jersey Senior Programmer 06/03 – 09/06
TotalChoice (.Net Version) is a payroll processing software that automates the
payrun and prints the paychecks and performs the ACH (Automated Check Handling).
Developed on C#, ASP.Net, SQL Server 2000.
Role:
Worked in the different layers of development
Business Layer
· Developed Business layer ACH processing using C# and OOD (object oriented
design).
· Developed eTime processing for the employees using C# and OOD.
Database Layer
· Developed and maintained around 60 Stored procedures, user-defined functions,
triggers for validation and obtain some business rules.
Presentation Layer
· Developed and maintained different UI screen like employee details, customer
details, bank account using ASP.Net, C#, javascript and HTML.
TotalChoice is a payroll processing system of ADP that automates the payrun of a
company developed using VB6.0, COM+, ASP, JavaScript and SQL Server 2000. Worked
on the eTime (Time and Attendance system) module of the system.
Role:
· Developed COM+ components that interact with database using ADO.
· Developed SQL Server 2000 stored procedures, triggers and user-defined
functions that implement a set of business rules.
· Involved in developing web pages for displaying punch details, accepting TA
details using ASP and JavaScript.
Environment: C#, ASP.NET, VB6, COM, IIS, ASP, SQL-SERVER 2000,WINDOWS-2000.
First Consulting Group, New Jersey Programmer 10/02 –02/03
QBLUE is an automated health care system developed for Horizon BlueCross
BlueShield that processes claims in HIPAA standard, keeps track of member details
and authorizations. The system receives EDI 837 (claims) transactions in X12
format and feeds it to BizTalk server. BizTalk posts each XML to ASPX page that
processes 834 and 837 transactions and updates the database.
Role:
· Developed VB COM object as preprocessor for BizTalk that reads EDI file in X12
format and posts to an ASPX page. Developed VB.NET object as an application
integration component.
· Involved in the maintenance and enhancement of VB, COM+ objects and ASP
scripts
· Developed SQL Server 2000 Stored Procedures, User defined Functions, Triggers,
and Views using TSQL that extracts data and generates the reports. Developed DTS
packages by using different tasks.
Environment: VB6, VB.NET, ASP.NET, XML, BizTalk Server 2000, COM, ERWIN, IIS,
SQL-SERVER 2000, Crystal Reports, WINDOWS-2000
ICICI InfoTech Ltd Programmer Analyst 09/1996 - 05/2002
National Expense Tracking System a Sales Force Automation system for Bristol
Meyers Squibb, is a multi tier application provides a means to control spending
and avoid inadequate monitoring of funds by allowing users to track both planned
and current expenses, budgets and marketing programs using the budget tracking
form.
Role:
· Involved in maintenance of module that downloads the data from vendor’s system
in XML format validates it and updates the stage table by using DOM objects.
· Developed triggers to do the validation and updates the transaction and master
tables.
· Developed and Maintained ActiveX Dlls and Exes using VB6.0. ActiveX Dll that
is called by VB TSR program in turn calls ActiveX Exe asynchronously by using
callback functions.
· Developed DTS (Data Transformation Services) packages for extracting data from
different database like Oracle, Sybase, MS SQL server, DB2 and fed into Nets
database by using stored procedures and different DTS tasks.
Environment: Sybase 11.9.2, Unix, VB 6.0, COM, ADO, XML, DTS, MS SQL
Server7.0/2000, Access 2000, Oracle PL/SQL, DB-Artisan, Windows 2000
Morgan Stanley Portfolio Accounting is an accounting system for Morgan Stanley
that analyzes the portfolios and provides financial statements. MSPA captures
traded data like futures, equities, fixed Income and calculates PL and do the
analysis to provide information like Realized Gain and Loss, Cash Roll, Mark To
Market, Percent Ownership, List about OpenTaxlots, Capital Gains, Details about
Transactions, Transaction Ledger, List of Trade Settlements, Summary about
Dividends, Securities valuation, Money Manager Evaluation, RevaluedPandL etc.
Role:
· Developed and maintained around 80 Sybase stored procedures, triggers, views
that retrieves the data, apply business rules and these are called by reports
(Crystal Report Writer) and UI.
· Worked on performance tuning and optimization of stored procedures. This
system uses 5 databases with average table size of 1 million rows. Each stored
procedure will have an average of 15 table joins.
· Provides full time support of stored procedures in production including the
performance.
· Member of designing and modeling team, created database schema for reporting
database by denormalizing to simplify these stored procedures.
Environment: Sybase SQL Server 11.9.2, Perl, Solaris, VB 6.0, MS Access,
Crystal Reports
Callout Issue Tracking and Resolution Information System is an automated system
for MetLife to track the problem policies and resolve it. After policies are
delivered to policyholders, using a set of business rules identifies the problem
policies and they are allocated to correspondents based on their priority and
load.
Role:
· Designed and developed user interfaces using True Data bound Grid, Tree View
Control, Sheridan controls etc. Developed database routines using REMOTE DATA
OBECTS AND DATA ACCESS OBJECTS. Developed stored procedures and triggers to
download data, periodical updating of tables. Windows API calls are used for
security and messaging.
EDUCATION
· Bachelors in Computer Science (Mar 1992), Madras University, Madras, India
· Masters in Computer Application, Bharathidasan University, India.
|
