Balaji Mahadevan
[Send email using form at bottom]
[Send email to request phone number] 55-7474
* Over 14 years of experience in Software Design, Development and Implementation
* 10 years of in-depth experience in database architecture, design and
development, administration
and maintenance of SQL Server 2005 / 2000 / 7.0 large scale databases
* Over 4 Years of experience in building enterprise cubes for data mining,
developing Data
warehouse solution using SQL Server Analysis Services 2005, SSAS 2000
* Highly experienced in database server performance tuning and optimization and
troubleshooting
and performance tuning for Complex SQL queries
* Highly experienced in distributed systems and high availability data server,
data modeling, SQL
and stored procedure development· DTS (2000), SSIS OLAP and replication design &
implementation, build and support·
* Microsoft Certified Professional in SQL Server Design and Implementation
* Excellent Interpersonal, Management and Communication skills with ability to
deliver quality
results with minimum supervision
EDUCATION
Master of Technology, (1994) from IIT Roorkee (Formerly University of Roorkee),
India
CERTIFICATIONS
* Microsoft Certified Professional in Installing, Configuring, and Administering
Microsoft
SQL Server 2000 Enterprise Edition (Exam 70-228)
* Microsoft Certified Professional in Designing and Implementing Databases with
Microsoft
SQL Server 2000 Enterprise Edition (Exam 70-229)
* Certified Advanced Coldfusion MX Developer by Macromedia
TECHNICAL ENVIRONMENT
DATABASES:
SQL Server 2005 / 2000 / 7.0, Analysis Services 2005, Visual Studio 2005
Internet Technologies:
ColdFusion 4.0/4.5/5.0, MX, FuseBox, XML, XSLT, Java, JavaScript. DHTML
DESIGN TOOLS:
ERwin, Dream Weaver MX, Flash 5.0/MX.
SOFTWARE:
IDERA, Crystal Reports 8.0, Visio Enterprise, Allaire HomeSite, PC Anywhere,
Visual InterDev 1.0, TODD, Visual Café, Visual SourceSafe
PROJECT EXPERIENCE
http://art.com
http://allposters.com Jan 2008 – Till Date
Title: Senior SQL Server DBA
Responsibilities
* Responsible for 24 Production and staging database servers, including setting
up and maintaining few of
the critical databases in cluster nodes in SAN Environment.
* Performed all aspects of database administration including data modeling, Log
shipping, replication. (MS
SQL Replication and TSQL Replication)
* Monitoring production servers using IDERA database monitoring tool and taking
appropriate measures.
* Responsible for high availability of production database and 24x7 routine
maintenance
* Responsible for performance optimization of database and optimization of SQL
queries.
* Tuning, Optimization and trouble shooting highly expensive database queries /
stored procedures / T-
SQL batches.
* Frequently reviewing, auditing and testing disaster recovery procedure and
maintaining related
documentation.
Environment: SQL Server 2005, IDERA, SSIS
http://cardstore.com July 2004 – Jan 2008
http://touchpoint.com
Title: Senior SQL Server DBA
Client web site to allows consumers to send gift cards along with the greeting
cards to the end users.
The greeting card orders will be physically delivered by USPS mail. Top features
of this site includes
xml based preview engine by which the users can preview the greeting cards along
with gift cards
with customized personal messages inside the greetings card
Responsibilities
* Responsible for 17 Production and staging database servers, performed all
aspects of database
administration including data modeling, Log shipping, replication and recovery.
Created various DTS,
SSIS packages and debugging existing packages.
* Developing data mining reports using analysis services, building cubes
dimensions and pivot tables
* Responsible for high availability of production database and 24x7 routine
maintenance
* Responsible for performance optimization of database and optimization of SQL
queries.
* Re-engineered the database schema, writing and trouble shooting database
queries / stored procedures
/ T-SQL code and batch programs
Environment: SQL Server 2000, Analysis Services, OLAP, ColdFusion MX,
JavaScript
http://lifestyle.isgnovasoft.com Jan
2004 – June 2004
(Client: Mirglobal, NJ)
This system provides complete online administration survey calls by means of
elegant user-friendly
modules. Survey administrator can create call center agents with appropriate
permission levels and
bulk assign survey records. Questions and answers generated during survey are
created dynamically
via Questions module. Dynamic routing of survey questions based on end user
response has been
incorporated in the system. Reports modules facilitates generating aggregate and
detailed reports
based on various parameters like report date and time, status, user agents and
be download as excel
or as word document.
Responsibilities
* Design, development and complete database administration of the whole system.
* Developing analysis services reports using cubes dimensions and pivot tables.
* Designed the system flow and developed user interface for the whole system.
* Responsible for data extraction for reporting purpose and created and
maintained replication to the
staging and report database
* Created Store procedures and Transaction Batch programs and SQL Jobs.
* Used heavy JavaScript and DHTML for client validation and user interface
enhancements.
Environment: SQL Server 2000, ColdFusion MX on Windows 2000 Server, FuseBox,
Crystal Reports
8.0, JavaScript, XML, XSLT, DHTML
EELIAS Reporting System (http://www.eeliasonline.net ) Mar 2003 –
Dec 2003
(Client: University of Maryland, USA)
EELIAS is the Evaluation for Exchange, Language, International, and Area Studies
System for
International Education, a project of The National Foreign Language Center at
The University of
Maryland (NFLC), USA. EELIAS consists of data collection and analysis system, a
management
group of senior scholars in evaluation, data analysis, and international
education, and yearly task
forces representing International Education and Graduate Programs Service
(IEGPS), the Office of
Management and Budget (OMB), and the Title VI and Fulbright-Hays community. The
whole EELIAS
Reporting system was implemented across 15 modules.
Responsibilities
* Project Lead for 4 Member team. Responsible for Development of 3 Modules
using pre-defined client
use cases.
* Data Modeling & Database Design with ERwin, Performance Tuning and
Optimization of Microsoft SQL
Server database
* Troubleshooting Coldfusion pages, accessing SQL Server data, Creating and
debugging stored
procedures.
Environment: SQL Server 2000, ColdFusion 5.0 on Sun-Solaris, Java Script,
ERWIN
https://co-opnetwork.org/darwin July 2001 – Jan 2003
(Client: CO-OP Network, CA, USA)
Senior Project consultant cum Project Lead: The primary goal of this project is
automate the business
process of the co-opnetwork with enhanced functionality and flexible user
interface system. The main
modules of this project include Debit Services, Client Services, Administration,
Contracts, Marketing
and Network Implementation. Each Module has its own business process integrated
with each other.
CO-OP network communicate to credit unions through and extranet module where
complex business
process initiated by Individual Credit unions and submitted to co-opnetwork on
timely basis.
Responsibilities
* Developed plans to reengineer and consolidate business operations and process
into Internet
based flexible user interface system.
* Managing 5 members team. Developed focused project development plans and
streamlined core IT
processes for extranet users (Credit Unions)
* Database Table Designing, Database Design enhancements, Maintenance,
Performance Optimization
* Created various User Defined Functions (UDF) for encapsulating common business
process.
* Creating and maintaining Replication between production and staging databases,
Routine Back up
operations of DB and Transaction logs. Event scheduling and other related daily
database operations
* Database Maintenance, Restoring databases from backup; adding and changing SQL
Server logons,
users, and groups
Environment: SQL Server 2000, ColdFusion 4.5 with Fusebox, DHTML, Java Script,
ERWIN
www.iManager.AutoBytel.com April 2001 – July 2001
(Client: Autobytel.com, Irvine, CA, USA)
The iManager is a online tool for the automobile dealers to take care of their
Purchase Request,
inventory maintenance, Appointment and email storage and notification, multi
task scheduling, various
business and sales report generation and many other features.
Responsibilities
* Project Lead for iManager Menu Module (3 member team)
* Database Design for the iManager Menu Module.
* Optimization and enhancement of existing Store procedure for improved
performance for High and Low
band width users.
* Designed Fuse box architecture and integration with inventory and other
modules
* Optimization and enhancement of existing Coldfusion code for improved
performance for High and Low
bandwidth users.
* Interface design and template coding for iManager express tool.
Environment: SQL Server 2000, ColdFusion 4.5, Fusebox. DHTML, Java Script
www.hotel.com - (Client: IBOS Inc, Orange, CA, USA) Dec 2000
– Mar 2001
This project is one of major on going projects of IBOS Inc., This web site
facilitates online hotel
property registration by various property owners and other subsidiary vendors.
Major functionality
includes but not limited to property Admin section, Regular and Hot deal rate
maintenance, online
promotions and discounts,
Responsibilities
Responsible for SQL Server Database Administration, System Analysis design,
Development and
Implementation,
Duties included installation, administration, and maintenance of SQL Server 7.0
databases, creation and
maintenance of data models using ERWIN, creation and debugging of stored
procedures that interface with
Coldfusion web site
Environment: SQL Server 7.0, Windows NT Server 4.0, Macromedia Dreamweawer 3,
ERWIN
www.hotelsupplies.com - (Client: IBOS Inc, Orange, CA, USA) Feb 2000 – Nov
2000
Hotelsupplies.com is an online portal, aggregating buyers and sellers, enabling
them to efficiently
conduct e-commerce in a secure environment. The comprehensive electronic catalog
system in this
site allows sellers to control product dissemination and promotional activity.
Registered buyers can
buy any product by placing online purchase order system or through RFQ system.
Through RFQ
System buyers can get the different range of quotes from different vendors for a
particular product or
category. This RFQ is cost effective way of purchasing a product though the
online catalog enable
with metadata and advance search capabilities.
Responsibilities
* Database Maintenance / Administration. (Development, Test and Production
versions)
* Administered two multi-gigabyte SQL Server (Production and backup server),
including conducting daily,
weekly and monthly maintenance as well as backup and replication.
* Database Transformation Services (DTS) included designing new DTS program and
debugging existing
program.
* Extensively used CFML, HTML and Java Script for developing the website.
Enhancement of client side
functionality by using CFSCRIPT, STRUCTURES. Extensively used custom tags for
development.
* Re-engineering and Integration of System Architecture for IBOS Vertical market
business model to B2B
business model.
Environment: SQL Server 7.0, ERWIN, ColdFusion 4.0, Windows NT Server 4.0, Java
Script,
Macromedia Dreamweawer 3
www.perfectweddingplanner.com December 1999 – Jan 2000
(Client: Triscope Inc, Long Island, NY, USA)
The purpose of this project is to derive a budget plan for a wedding process
coupled with online
registry and time line process. The budget plan is derived using constant
percentage values for the
each of budgeting items. After deriving the budget, the system calculates the
difference between
actual and anticipated cost for individual budgeted items. In Online registry
section, couples can add
required gift items and quantity to their profile thus by facilitating the users
to purchase those item
online via Online registry section, by using shopping cart feature. This system
provides the time line
process for the registered users to maintain scheduled processes and information
about number of
tasks to complete in the next 14 days and list of those, number of overdue tasks
and list of those,
number of completed tasks and number of total tasks to be completed by wedding
date and so on.
Responsibilities
Creating and debugging store procedures, Daily maintenance of sql server
database and backup, Table
designing, schema generation etc.
Environment: SQL Server 7.0, ColdFusion 4.0, Windows NT Server 4.0, Java Script,
Macromedia
Dreamweawer 3, ERWIN
www.thelawyerpages.com Oct 1999 – Nov 1999
(Client: US Interactive, Philadelphia, USA)
This project consists of creating online subscription for Attorneys and Experts
with multiple user-
friendly options at the time of subscription. Expert subscription consists of -
Pricing for expert witness
screen – which has options like Listing by state, Linking to current existing
web site and creating their
own web page from predefined model templates. In addition option to add logo and
photo to their
dynamically created web site.
Typical features of this site include credit card validation, web page creation
and personalization,
uploading images, user files and documents to the web server, email notification
etc
Responsibilities
* Developing User Interface. Database was developed in Oracle and linked to
ColdFusion.
* Extensively used Custom tags, CFSCRIPT, STRUCTURES, and Java Script for
developing the
website.
* Generating periodical emails. Schedule Programs, Generating Reports.
Environment: ColdFusion 4.0, Windows NT Server 4.0, Java Script, Oracle SQL
*Plus 8.0.4
www.carpetone.com and www.carpetone.com/administration Feb 1999 – Oct
1999
(Client: Capstone Technologies, IN)
The system provides the ability to create a online profile for the users
visiting this site and also
provides the ability to select the carpet based on the Interactive flooring
guide and personal portfolio.
The site was developed for the three groups of people. 1.Administrators who will
control all the
members’ logins, portfolio options and user profile. 2.Members who actually own
the carpet stores.
3.The users visiting this site. Administration features includes but not limited
to creating login,
controlling member profile, creating new stores, brands, ability to dynamically
create a new virtual
directory and uploading store image for a store member. The features includes
generation of Online
discounts and coupons in scheduled periods, email notification to the user,
chat session, feedback
form etc
Responsibilities:
* Designing the Database, User Interface. Involved with discussion with Client,
regarding business
activities.
* Extensively used CFML, HTML and Java Script for developing the website.
* Used CFScript extensively throughout the entire application.
* Created custom tag for routine functionality, Generating Reports.
* Implementing Client and Server side validations using Java Script and Custom
tags.
Environment: ColdFusion 4.0, Windows NT Server 4.0, IIS 4.0, Javascript, Oracle
SQLPlus 8.0.5
Phoenix Banking System Feb 1998 – Jan 1999
(Phoenix International (lbss), Orlando, FL)
This project is an enhancement of the existing banking system, which was
developed by Phoenix. It
provided online solutions for the complex transactions. The various modules,
which were enhanced
were Loan System, Deposit System.
Responsibilities
* Involved in system analysis and design
* Designing / Enhancement of the database for the Loan application modules.
* Developing new module in Loan and Deposit system using Centura
* Creating User Interface.
* Creating and debugging store procedures
* Report Development using Centura Report Windows.
Environment: Centura, Report Windows, Sybase 10, Windows NT
Advanced Integrated Manufacturing Software
Nov 1996
- Jan 1998
(AIMS) Customization - MASCON, Chennai, India
Client: Indokem Overseas Limited:
|
