Saraswathy Jothivelu

Freelance Database Programmer & Database Designer

Location:Sunnyvale, California, United States
2 Skills
Saraswathy Jothivelu
Phone: 408-446-1975
Cell: 408-544-0134


• Over 12 years of experience in analysis, design, development, testing, maintenance and implementation of software applications.
• Worked extensively with SQL Server (2000, 6.5, 7.0), Oracle (10,9i, 8.0) and SYBASE databases.
• Strong skills in Microsoft.Net, Visual Studio.Net 2002/2003/2005, C#, VB.Net, ASP.Net, and ADO.Net.
• Extensive background in MS technologies including Visual Interdev 6.0, Visual Basic (6.0, 5.0, 4.0,3.0), ASP 2.0, ADO, ODBC, COM, DCOM, COM+, and MTS.
• Good skills in Crystal Reports, EXCEL Pivot tables, Excel reports with VBA Programming.

Technical Skills

Operating Systems Windows XP, Windows 2000, Windows NT 4 / 3.51, UNIX
Languages C, C++, PL/SQL
GUI Visual C#, Visual Studio.Net 2005, VB.Net, Infragistics, Visual Basic (6.0, 5.0, 4.0, 3.0), Visual Interdev 6.0, Power Builder (6.0, 5.0, 4.0, 3.0), COM, DCOM, COM+, Lotus Notes (4.6,R5), VBA Programming, VBA Macros, Crystal Report
Database SQL Server (2000,7.0, 6.5), Oracle (10g,9.0,8.0, 7.3,7.1), MS Access, Sybase,MySQL, DB2
Tools Telerik, Windows 2000 Administrative Tools, Clonesecurityprincipal, IADS Tools, ERWIN, ADSI (Active Directory Service Interface), SQL Loader, SQL Plus 8.0, ROBO HELP, Novadigm, Tally, Dimensions, MS SQL Server Analysis Services, HBX Web Analytics, Google Analytics, Digital River Ecommerce tool,
Web Technologies Microsoft.Net, ASP.NET, CSS, C#, HTML 4.0, DHTML, XML, XDDS, SOAP, Java 1.1, CGI Scripts, Java Scripts, Java Applets, Active Server Pages, MTS (Microsoft Transaction Server), Internet Information Server 4.0, Umbraco, Dreamweaver, Vignette,PHP


University of Madras, Tamil Nadu, India
BS Degree in Computer Science Engineering June 1991 – May 1995

Professional Experience

Employer: Crimson consulting, CA
Seagate Technology, Sunnyvale, CA Feb 2010 – Till Date

Designed, and developed Seagate Online store for Offer and Promotion Management, Product Management and Pricing.

Roles and Responsibilities:

• Design and Developed custom landing page for any promotions in JavaScript, HTML, CSS
• Develop Database Stored Procedures, SQL Query in SQL Server as needed for web sites, and other web based applications
• Analyzed the data for Ecommerce real time transactions in SQL Server Analysis services.
• Develop any Ecommerce related site changes that relates with “Buy Now”, that integrates to the store
• Implement Omniture tracking code and Google Analytics Tracking code for all the custom built pages
• Design and Develop Category page, Product page in DR
• Create and deploy Promotion code, Discount, Shipping discount, Up sell, Cross sell, Bundle offers
• Price Update whenever there is a price change as per Pricing team within DR
• Integrate the product pages to the website
• Maintain day-to-day tickets related to the store for US, Employee store
• Create content page for any new product launch
• Maintain Ecommerce DR related activities

Environment: HTML, CSS, JavaScript, Pricespider, SQL Server 2000, SQL Server Analysis services, Global commerce manager (Digital River), Google web Analytics, RSS, Feed burner, Adobe Photoshop.

Employer: Level 6, CA
SanDisk Inc, Milpitas, CA April 2008 – Jan 2010

Umbraco CMS developed for SanDisk web site using ASP.Net, C#, XML, SQL Server 2005.

APMPricingUtility tool is developed in C#, which will do the automation of the price update to the SanDisk Corporate web site.

Driver download is web application developed with ASP.Net, SQL Server, and help in downloading the device driver software for the SanDisk Products.

Developed Ecommerce related Product pages, Outlet store page, Landing pages, and integrated Store with SanDisk web site, for all SanDisk products. Updated the Page Builder by using HTML Code, JavaScript, CSS, for the US Consumer store, with snowflakes theme for the holiday season

RSS landing page developed to have the latest Press releases, SanDisk Product Announcement, Weekly sale using ASP.Net, C#, Java script, CSS

Email Campaign using Cheetah mail for weekly sale email, or any specific Campaign.

Analyzed Google Web Analytics tracking code and implemented to SanDisk web sites.

Roles and Responsibilities:

• Analyzed the requirement for automation price update and developed C# for APMPricingUtility
• Developed driver download page, Delta Export tool and many Landing pages in ASP.Net, SQL Server 2005, JavaScript, HTML, CSS
• Develop Database Stored Procedures, SQL Query in SQL Server as needed for web sites, and other web based applications
• Develop any Ecommerce related site changes that relates with “Buy Now”, that integrates to the store
• Recommend site changes to make the website efficient
• Implement Google Analytics Tracking code for all the sites
• Responsible and maintain Online Web Portal for Online Marketing in Sprocket using SharePoint
• Design and Develop new Landing page, Category page, Product page in DR
• Create and deploy Promotion code, Discount, Shipping discount, Up sell, Cross sell, Bundle offers
• Price Update whenever there is a price change as per Pricing team within DR
• Integrate the product pages to the website
• Maintain day-to-day tickets related to the store for US, Employee store, Italy, France, Germany, Spain, UK Stores
• Maintain website by updating the content using the content management system for all the regional sites
• Create content page for any new product launch
• Create HTML Code for sending Email using Cheetah mail for Email campaign
• Create any RSS Feeds for corporate site
• Maintain Ecommerce DR related activities

Environment: C#, ASP.Net 2.0, Dot net 3.5, ADO.NET, HTML, CSS, SQL Server 2005, IIS 6.0, IIS Service Manager,
JavaScript, Cheetah mail, Global commerce manager (Digital River), Google web Analytics, RSS, Feed burner, Adobe Photoshop,

Employer: Robert Half Technology, A February 2007 – Aug 2007
Colliers International, San Jose, CA

Market Report Uploader is the web based system that has the facility of uploading the market reports created by the Brokers.
This system already existed in Classic ASP and Visual Basic. New features were done in ASP.NET, VB.NET. All the pages were migrated to ASP.Net with ADO.NET Functionalities.

DeBi is the ASP.Net application that has been used by the Brokers of Colliers.

TheROCK, is the desktop application that is used majorly by Researchers to add a new Property, to look into different companies. This desktop application is the entry for DeBi.


? Analyzed the existing Market Repot uploader which was done using Visual basic and ASP.
? Design changes were made to incorporate the latest Dot net technology including ADO.NET, VB.NET, ASP.NET Controls, and AJAX controls with Infragistics.
? Datasets, Data reader were used in the place of Record set.
? COMObjects were utilized by importing them to Dot net as Library using TLBImpot and Class wrapper.
? All ASP Pages were changed to Aspx files. Have used SQL SERVER 2000 for all the three applications.
Environment: VB.Net, Visual basic 6.0, ASP, ADO, Dot net 1.1, ADO.NET, HTML, CSS, SQL Server 2000, IIS 6.0, IIS Service Manager,Crystal Reports XI, ASP.NET 1.1, JavaScript, Infragistics

Web archives, Campbell, CA

This is a short contract of updating the existing asp pages to aspx website, of adjusting the Digital asset management for retail companies such as street sense etc., Existing system were migrated to ASP.NET. The system was developed using VB.NET, JavaScript, ASP.NET, and SQL SERVER 2000.

Environment: Visual Basic, ASP, VB.NET, ASP.Net, JavaScript

Chordiant Software, Cupertino, CA

Business Process Management projects provide processing of the Web based Forms and delivering to the right candidate for further approval. These projects were developed for Finance, HR department.


? Designed and Coded the ASP.Net web forms using C#, AJAX Controls.
? Designed the Workflow model using Captaris Workflow 6.0 for all the Business Processing task such as Request
? Automated the email generation once, the Request, Approval task were ready.
? Also created forms for further notification of the Task Completion.

Employer: Innominds Inc, Santa Clara, CA September 2006 – January 2007

Projects worked under Innominds:

Charles Schwab, San Francisco, CA Senior Application Developer
IVR Real time alerts September 2006 - January 2007

Real time alerts process for IVR is a console application in C# that would get the ftp files from a DBRM Server, and loop through and get all the files in the directory. This process will also load the data into Oracle database. This process would run every 15 minutes, and send automatically e-mail every morning, having the total data loaded the previous day.

? Analyzed the existing database, and the existing Visual basic application.
? Created and re-engineered the Visual basic application to C# Console application.
? Included C# features such as System.IO, Directory services, FTP Services,
? Have used, for data rendering.
? Designed and Coded the C# Application for IVR Process, to transfer the files using edtFTP Tool.
? Used Oracle Client for C#.
? Developed PLSQL Stored procedures, for loading the data, making the IVR Alerts work to send alerts to the users.
? Automated the e-mail generation for sending alerts with client’s comments to the Users.
Environment: C#, Dot net 2.0, ADO.NET, VB 6.0, ADO, HTML, CSS, Visual SourceSafe, AJAX, Oracle 10.0, PL/SQL 7.2, SQL Loader, Log4Net, edtFTP

Vacation from March 2006 – July 2006

Employer: 3i People Inc October 2003 – August 2006

Projects worked under 3i people

Cisco Systems, San Jose, CA Sr. Software Developer
GSES (Global System Engineer Specialization) September 2005 Till Feb 2006

This system has the detailed description, of Specialization such, as the SE Certification date, Certification progress, with each
Sub-component of a specialization.
VT report is another report application, developed in Excel with different pivot tables, graphs, charts, to show the Theater Virtual Team members, in each specialization.
Siebel has been used tremendously to quickly bring, the Certification data. These downloaded data, again cleaned, and utilized in the development of other reports.

? Requirements Gathering, Analysis, Design, Prototype, Coding, Testing and Deployment and Supported the application.
? Analyzed the different raw Data Source such as EMS (Education Management System), COLT (Test), and CERT (Certification).
? Used Business Objects 5.1 frequently, in getting the information, from various other resources.
? Analyzed and developed Reporting tools to show SE Summary, Specialization Assignment, and the Progress of the Specialization using Visual basic.
? Wrote challenging Visual basic scripts using VBA Programming like Chopping the excel rows, transforming into different sheets by Theater (Region) specified, Chopped the data by SED and SEM.
? Developed reports, after cleansing the data from Siebel and Business Objects 5.1.
? Developed installation steps for all the reports.
Environment: Visual Basic, VBA Programming, Excel Pivot tables, Macros, ADO, MS Access 2000, Oracle, SQL Server 2000, MS Excel 2000, Siebel Portal, Business Objects 5.1

State Compensation Insurance Fund, SFO, CA Senior Application Developer
Injury and Illness Prevention Program (IIPP) August 2004 August 2005

The Injury and Illness Prevention Program (IIPP) is a universal, mandatory program required for all California employers. IIPP Builder web-based application will allow customers brokers/policyholders/State Agencies) to navigate through a series of inquiries and/or checklists, which will facilitate the creation, modification and evaluation of Policyholders IIPP.


? Analyzed the SCIF IIPP Builder Administration Component to the creation, modification and publishing processes and workflows for the IIPP Builder Templates.
? Java script was used for client validation, for the style sheet management for controlling the menus, loading the menus, menu management
? User Controls were created in C# for displaying the breadcrumb, and to have the section title for all the pages.
Configuration components were written in C# to authenticate the users with respect to the remote file in the remote place.
? Created the prototype of the new version of IIPP 2.0. In Java script having the complete mockup application as the original one.
Environment: Visual Studio.NET, C#, Web forms, IIS, XML, XSL,Xpath, HTML, CSS, VB.Net, SQL Server 2000, Java script, ASP.Net, ADO.Net

Brocade, San Jose, CA Senior Application Developer
Scheduling and Imaging Process Nov 2003 July 2004

The Scheduling System is for Education department of Brocade. This Application will provide facility for scheduling the classes, administrate class, and administrate instructors, students. This System would be also useful in imaging the devices for the classes, maintain privilege for students, instructors.

The Imaging process is the module that would automatically do the actual Imaging for the selected list of computers. The Imaging process is dependent on the scheduling system as; Imaging would be changing for different type of courses.

Environment: Visual Studio.NET, C#, VB.Net, Web forms, ASP.Net, Active Directory, HTML, XML, XSL, XPATH, ADO.Net, MS Access 2000, MS Excel 2000

Universal Studio (UMG), Los Angeles, CA Senior Application Developer
DAVe 5.0 July 2003 Oct 2003

Dave 5.0 is the windows based application developed in Microsoft .Net and C#. This system is basically for music downloading for the Business partners for UMG/UMI.

Environment: Visual C#. Net, Win forms, Microsoft.Net Framework, Visual studio.Net 2002/2003, IIS, Visual SourceSafe 6.0, XML, XSL, SQL Server 2000, XML Web Services, SOAP, XDDS, Music Metadata, Infragistcs, MS Excel 2000, ADO. Net, Windows 2000, Windows XP

Charles Schwab, San Francisco, CA Senior Software Engineer
Feb 2003 June 2003

Environment: Visual Basic.Net, ASP.Net, VBScript, Essbase 5.0.2, Essbase application manager, MS Excel 2000, Oracle, VBA Programming, ADO, DAO, Windows NT 4.0, Windows 2000

Employer: Phoenix Technologies Ltd., San Jose, CA Jan 2002 – Jan 2003

HRIS and Help desk application Oct 2001 To Jan 2003
Phoenix Technologies Ltd., San Jose, CA Senior Applications Developer

Employer: 3i People Inc, Atlanta, GA Oct 2001 – Dec 2001

Projects worked under 3i people

HRIS and Help desk application Oct 2001 To Dec 2001
Phoenix Technologies Ltd., San Jose, CA Senior Applications Developer

Employer: Master Minds Inc, Columbus, OH May 1998 – September 2001

Projects worked under Master Minds Inc

PC and Laptop Asset Management System Nov 2000 to Sept 2001
American Honda, Torrance, CA Sr. Programmer Analyst

Web Interface for Windows 2000 Cloning July 2000 October 2000
Boeing, Seattle, WA Sr. Programmer Analyst

Fastrax Mar 2000 to June 2000
RR Donnelley Financials, Atlanta, GA Sr. Programmer Analyst

Motion Picture Industry Health and Pension Plan Feb 2000 to Mar 2000
Motion Picture Industry, Los Angeles, CA Sr. Programmer Analyst
Environment: Visual Basic 6.0, SQL Server 7.0, ADO 2.0, COM, Crystal Reports 6.0, Windows NT 4.0

Integrex Litigation IS Support April 99 to Jan 2000
Owens Corning USA (Granville, Ohio) Senior System Analyst

Company Dossier Nov 98 to Apr 99
Lexis-Nexis USA (Dayton, Ohio) Senior Analyst

Employer: Master Minds India Pvt Ltd, Chennai, India Apr 97 – April 98

Projects worked under Master Minds India Pvt Ltd

Status Report of OCSE Information Systems Apr 97 to April 98
State of Arkansas, USA Senior Programmer Analyst

Employer: California Software India Pvt Ltd, Chennai, India May 96 – Apr 97

Barge Scheduling System Dec 96 Apr 97
Chemoil Corporation, CA, USA Software Engineer

Internet design of Calsoft May 96 Nov 96
California Software Labs, CA, USA Software Engineer

Employer: Lastech Pvt Ltd, Chennai, India March 95 – May 96