## BIO
**Database Developer / Database Admin**
o Administer Microsoft SQL Server 7.0/2000 database running on windows 2000 Server and MYSQL database running on UNIX Server.
o Upgrade SQL Server 7.0 database to SQL Server 2000.
o Create and design Database, Tables, Stored Procedures, and Database Diagrams using SQL Server
o Responsible for creating Server Logins, Database Users and assigning permissions.
o Designed databases using Normalizations rules for several applications such as CRM and BackOffice Tool.
o Responsible for Database tuning and optimization of SQL Server Database.
o Setup SQL Server 7.0/2000 Backup/Recovery model.
o Replicate SQL Server Development Database with SQL Server Production Database.
o Create DTS Packages to transfer Data from and to Text files, Excel files And Access files.
o Create Jobs and Maintenance plans using SQL Server Enterprise Manager.
o Write scripts to clean up data and sanity check SQL Server 7.0/2000 database.
o Create Database Diagrams for SQL Server 7.0/2000 Databases
o Create extensive T-SQL queries to create Reports.
o Responsible for writing any sort of T-SQL using joins, group by and cursors.
o Wrote some custom ASP scripts to transfer single table access database to multi table SQL Server database using ASP ADO object , VBScript and SQL
o Installed and configure MYSQL ODBC client (MYODBC) on windows 2000 server.
o Responsible Administration MYSQL Database running on Linux box
o Installed and configured SQL Server 7.0/2000 on Windows 2000 Server.
**Internet Programmer**
o **<u>CRM</u>**
· Developed CRM (Customer Relationship Management) system using ASP 3.0(Active Server Pages), ADO, JavaScript and SQL Server 7.0/2000. This is a sophisticated system keeps track of clients for Advisories (more than 700) while they are In Process and after there products are build.
**<u>SUMMARY</u>**
o Different login levels for each user. Depending on that user can and cannot perform certain task.
o Ability to search by Demographic information, Contact name, Company Information, Product attributes like URL, current status, notes and actions
o Ability to add/modify/view notes for each product which logs user and current date
o Ability to add/modify/view/log actions taken during and after product development
o Ability to view/modify product attributes
o User can send notes to other users as messages, which sends message to other users both in CRM and as email
o Develop DynamicStatemachine using ASP, SQL and JavaScript
o Ability to add/remove developer by admin. Products are also searchable by developers
o Wrote sanity check script using VBScript and SQL which sends email to admin for the CRM tool to clean up database
o Create Generic form for product attributes. Form gets product attributes from database and dumps it back to database on submission. Form gets created on the fly depending on attributes in database.
o Create Atomized mail merge, which merge word document with client information in SQL server database to create word documents like Order form, workbook on the fly using VBScript, ASP, SQL and Microsoft word mail merge.
o Created a Reporting tool where Admin can create bunch of Reports using T SQL and user with certain permissions can run those reports using ASP, SQL and JavaScript.
o Create and apply Style Sheet (CSS) through out the CRM tool
o **<u>BACKOFFICE TOOL</u>**
· BackOffice provides interface to financial advisors to modify their sites periodically. They can change existing content or add new content to their websites through BackOffice application. It also allows changing look and provides some other features.
**Laguages/RDBMs Used**: ASP, SQL Server 7.0/2000, ADO, JavaScript, Perl and third party ActiveX components
**<u>SUMMARY</u>**
o Developed and Integrate content management system for BackOffice tool where Broker/Dealer for financial advisors can approve or reject before changes made by advisors show up on their websites using ASP, SQL, JavaScript, perl, MYSQL.
o Developed a tool call FANS using which Advisors can send periodic emails to their clients. Advisors can create their own emails or they can use content provided by AdvisorSites. Also provide the facility for saving email and send them later. This tool is developed using ASP, SQL, JavaScript, and ASP Email.
o Installed and configured SSL (Secure Socket Layer) for some of the Advisors sites in IIS 5.0
o Installed third party ActiveX object, WYSIWYG (what you see is what you get), from ASP Modules and Implement with existing BackOffice Application. This Object provides friendly interface to clients to edit text on their websites and text for emails.
o Add a feature t
## Area of Expertise
I have more than 4 years of experience working on ASP and SQL Server. I have extensive experience administering SQL Server Database. I also have experience of administering windows 2000 Server and IIS 5.0. Besides ASP I can program in JAVA, C++ and Perl. I have understanding of TCP/IP networking. I have configured Cisco Pix 501 firewall and maintained it. I am also responsible for version controlling using Visual source safe and deploying new developments. I have designed, developed and managed CRM and BackOffice tools for my current company. Besides SQL Server I am also administering MYSQL Database running on linux.
