Sql Server Management

Karthy Paramananthan Phone: 916-***-**** (m)

Email:

********@*****.***

Summary

. 11 years of experience in analysis, design, development, testing, and

implementation of Client/Server and Internet/Intranet solutions.

. 8+ years of strong experience in BMC Remedy ARS 7.5/7.x/6.x/5.x.

. Solid experience in Remedy Server setup and upgrade.

. Extensive experience in developing custom remedy AR System applications.

. Implementing the Remedy ITSM 7.x applications and configuring them

according to the business needs.

. Strong RDBMS skill in using Oracle 8i/9i and SQL Server 2000. Good in

query optimization.

. Extensive knowledge in .NET technology including ASP.NET with C# and

VB.NET, VB 6.0, VBA, BEA Tuxedo, C and Pro*C.

. System Administrator Experience in Windows 2003 and Unix environment.

. Strong knowledge in Crystal Report 8.5/9/10 and Business Objects XI.

Education

. BS in Computer Science from Bharathiar University, India

. Postgraduate diploma in computer science -SSI, India

. DCA, LIBA Informatics center, Loyola College, India

. VB.Net from Los Rios Community College, US

. Basics of Project Management from CSUS, US

Technical Skills

Skills Exp Level Skills Exp Level*

(Yrs * (Yrs

) )

Operating System Databases:

HP UNIX v11 5.0 P ORACLE 8.x/9i 9.5 E

Windows 2000/2003 5.0 E SQL Server 6.5/7.0/2000 5.0 A

GUI: MS Access 97, 2003 10.0 E

VB.NET/ ASP 2.0/3.0 4.0 A Middle-Ware

Crystal Reports 9.0 E Tuxedo Server 6.5 5.0 E

7.0/8.5/11

Remedy MTS 2.5 A

Remedy ARS 8.0 E Web Server:

7.x/6.x/5.x

Mid-Tier 7.4 E IIS 4.0/5.0/6.0 5.0 E

Incident Management 4.0 A Web Technologies:

7.x

Problem Management 4.0 A XML 2.0 P

7.x

Change Management 4.0 A COM/DCOM 1.0 I

7.x

AR Utilities 5.0 P Other

BMC Atrium CMDB 3.0 P Perl 5.6 1.5 I

1.x/2.x

BMC Migrator 7.x 6.5 E Sybase PowerDesigner 9.0 5 P

Languages Other MS Technology

C 5.0 A MS-Project 2000/2003 7.0 A

C++ 1.5 P MS-Visio 2000/2003 7.0 A

Pro *C 7.0 E Microsoft MOM 2.0 I

Java 1.0 B

* B - Beginner; I - Intermediate; P - Proficient; A-Advanced; E - Expert

Professional Experience

Technosoft Corp FEB'01- JAN'10

TIPS System - AR Remedy

Client: Sate of California - OSI-ISAWS (Interim Statewide

Automated Welfare System)

Environment: Remedy 7.5/7.x/6.x/5.x, Crystal Report 8/9/10/XI, Oracle

9i/10g

Role Remedy Administrator/developer supporting 5000+ users base across

California counties.

. Project analysis, scheduling and resource forecasting

. Upgrade Remedy system from 5.x to 6.0.1, 6.0.1 to 6.3, 6.3 to

7.0, 7.0 to 7.1 and 7.1 to 7.5 and CMDB 1.1 to 2.1.

. Integrated Remedy with Interwoven DeskSite application.

. Created Service Level Objectives (SLO) metric for HelpDesk

module.

. Involved in installing, configuring and setting up of data in

CMDB.

. Customized the OOB ITSM modules according to the user

requirements.

. Configured the various Remedy ITSM modules according to

business requirements.

. Configured Remedy Email engine & Mid-Tier.

. Using Topology/Microsoft MOM Gathered Foundation data from

various user groups and uploaded the data into the CMDB data

model.

. Mapped configuration items (CI) to the classes available for

BMC Atrium CMDB, whether in the common Data Model or an

extension Created new attributes for existing BMC Classes in

CMDB

. Worked with reconciliation of existing and new data in CMDB.

. Involved in workflow changes for our homegrown application.

. Configured & worked with Asset Management, Service Desk,

Change Management and Service Level Agreement applications.

. Used Sybase Powerdesigner tool to create Conceptual database

modeling and Physical Database modeling.

. Involved in resource planning of the entire SDLC of a Change

Request using MS-Project

. Created business & technical layout for a business changes

using MS-Visio

. Working with External County users to define maintenance

changes for the application.

. Built a custom Escalation application tool for managers.

. Involved in Database tuning, hot backup and soft backup

process.

. Involve in maintaining and administrating the Oracle database

Server for the REMEDY system.

. Involved in maintaining and administrating the Unix operating

system (HP UX 11.0) for the REMEDY system.

. Undertake feasibility studies, or evaluations of new software

and report findings.

. Involved in Hardware/Software procurements

. Extensive knowledge in preparation of technical reports.

. Manage new software release and Archiving.

. Created various reports for management using Crystal

Reports/Business Objects.

. Wrote various shell scripts to take a Remedy workflow backup.

. Training and mentoring new Programmers.

. Involved in Code Inspection, Testing Plan creation, Test plan

execution and load testing.

Welfare To Work System

Project: ISAWS

Environment: Power builder, Tuxedo 6.5,Oracle 9i,PL/SQL Developer,

Crystal Report 8.5/Business Objects XI and PVCS

Role Sr. Programmer/Analyst

. Involved in the analysis, design and development of the

system.

. Worked with SME's to define application changes.

. Created the documents for IA, Requirements, Design, Test

Plan, Change Summary, PowerPoint Presentation & User Guides.

. Extensive knowledge in PVCS configuration

. Developed various shell script using Korn and Bourne shell.

. Developed various reports using Crystal report 7.0/8.5/11.

. Developed various DB utilities, stored procedure and

triggers.

. Created shell script to SFTP the file to various State

agencies.

Sales Forecasting system solution Dec'00 - jan 01

Client: Condrive Operation Inc. MI

Environment: Visual Basic 6.0, XML, Crystal Report 6.5 and Oracle 8.0

Role Programmer/Analyst

. Developed various user interface module.

. Used OLE script to export data to excel sheet.

. Used XML Dom object to send data to external source.

. Created various stored procedure & triggers.

Compsense

Nov'99- Dec'00

Client: Again Technologies, India

Environment: Visual Basic 6.0, XML, Crystal report 6.5, MTS, COM and

SQL Server

Role Programmer

. Developed various interface screens using Visual basic.

. Used T-SQL to write database procedure, triggers and other

data validation routines.

. Developed and integrate the n-tired COM components with the

middle tier business logic.

. Created various reports using Crystal reports.

. Used XML DOM objects to transfer file from the database.

. Created XSL style sheet to view the relevant information in

the XML file.

. Involved in various testing process like Unit Testing,

Integration Testing, Performance Testing.

web developer

Dec'98 - Oct'99

Client: PSTECH

Environment: ASP, Java Script, VBscript, Visual Interdev, ActiveX-COM,

SQL Server, and IIS4.0

Role Programmer

. Used VB-Script and ASP Objects for server side scripting.

. Used front page for designing the Home page

. Accessed SQL Server database in Active server pages by using

ADO

. Testing of the web site on different browser

web Designer/Developer Mar'98-

Nov'98

Client: Jeevan Blood Bank

Environment: ASP, SQL Server 6.5, VBScript, JavaScript, IIS, and Visual

Interdev

Role Programmer

. Contributed in writing Javascript function for most of the

pages.

. Developed various ASP pages for this web site.

. Database connectivity using ADO, Coding and Testing

. Used third party controls like Ad rotator

Contact this candidate