Management Sql Server

Employer Name: Brainware Solutions LLC

Recruiter: Sushma 916-***-****)

Email: *******@*****************.***

Rate: Please discuss with Employer Only

Ketan Patel

Sr. Remedy Consultant

Summary

Ketan Patel has more than 7 years of Information technology experience with

6 plus years of specialization in BMC Remedy Administration, development,

Configuration and the ITSM modules viz., Incident Management, Problem

Management, Change Management, BMC Atrium CMDB, Asset Management and SLM.

Ketan has worked on various domain areas like Finance, Telecommunication.

Six plus years experience as a Remedy Administrator and developer

using various versions of BMC Remedy AR System 6.0/6.3/7.0/7.1/7.5

. ITIL V3 Foundations certified.

. Extensive experience in developing custom AR System applications

involving advanced remedy workflow objects.

. Extensive experience in Installing and upgrading Remedy ARS versions.

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

to the best practices recommended by BMC.

. Supported Users and Customers with Remedy Support issues.

. Debugging and troubleshooting experience with various BMC products

involving ARSystem, Email Engine, Approval server, Assignment Engine,

Incident Management, Problem Management, BMC Atrium CMDB, Change

Management and SLM applications.

. Experience in gathering user requirements and developing the ARSystem

application and customized the ITSM modules following BMC's

recommended guidelines.

. Trained users and clients in Remedy applications and products and

documented the changes and prepared Job-aids for them.

. Have excellent written and oral communication skills.

Technical Skills

Operating System Microsoft Windows XP/ 2000/ Vista, MS-DOS, Sun

Solaris Unix, Red Hat Linux

BMC Tools Remedy AR Server 6.0/7.0/7.1/7.5, Mid Tier,

Assignment Engine, Approval Server, BMC Atrium

Integration Engine, Email Engine, Incident

Management, Problem Management, Change Management,

BMC Atrium CMDB, Asset management, SLM, Remedy

migrator, Remedy Administrator, Remedy import

Databases MS SQL Server 2005, 2000, Oracle 9i, 10g, MS

Access

Internet Technologies ActiveX, Java Script, HTML, DHTML & XML

Languages VB 6.0, C, C++, Java, COBOL, Perl, Assembly

Languages (MIPS Instructions set, 8051

Controller).

Web Servers MS IIS, Apache Tomcat

Reporting Tools Crystal Reports XI

Certifications

. ITIL V3 Foundation Exam

. Microsoft Certified Professional (MCP) Since 2000.

Professional Experience

Dole, Denver, CO

June 2008 - Present

Remedy Developer / Administrator

Project Description:

. Installation of AR Sever 7.1, Assignment Engine, Approval Server,

Email Engine, Incident Management, Change Management, BMC CMDB and

Asset management.

. Upgraded the ARS 6.3 Server to ARS 7.1.

. Customized the OOB ITSM modules according to the user requirements.

. Administered the User Accounts, User Licenses, permissions, Server

Maintenance.

. Developed various custom ARS modules

. Extensively involved in creating Remedy Forms, Active Links, AL

Guides, Filters, Filter Guides, Escalations and Menus for work flow.

. Built Integrations with Incident Management module for Ticket creation

through the HPD:IncidentInterface_create and HPD:IncidentInterface

forms from external systems.

. Configured the various ITSM modules according to business

requirements.

. Gathered the Configuration Items for configuring the CMDB application

to support Incident, Change and the Asset management applications.

. Gathered Foundation data from various user groups and uploaded the

data into the ITSM Foundation data structure using the ITSM Data

Management tool.

. Working with Incident Management, Problem management, Change

Management and Asset Management Applications.

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

. Maintained and Monitored the License usage for peak usage and updated

management with the necessary recommendations.

. Trained the users in the changes and the new remedy modules and

provided documentation to effectively use the system.

. Built a new dev server with ARS 7.5.

Environment: : Remedy ARS 6.3,7.1,7.5, ITSM 7.1, Incident Management 7.0.1,

Change Management 7.0.1, Asset Management, (6.x), Remedy Migrator 7.0,

Problem Management, Remedy Import, CMDB 2.1 Windows 2003/XP, Oracle 10g,

Crystal Reports, TOAD.

Savemart, Modesto, CA

June 2007 - May 2008

Remedy Developer / Administrator

Responsibilities:

. Involved in installing, configuring and customizing the Change

Management module.

. Developed various custom ARS applications.

. Configured the various ITSM modules according to business

requirements.

. Administered the User Accounts, User Licenses, permissions, Server

Maintenance.

. Extensively involved in creating Remedy Forms, Active Links, AL

Guides, Filters, Filter Guides, Escalations and Menus for work flow.

. Working with Incident Management, Problem management, Change

Management and Asset Management Applications.

. Built Integrations with Incident Management module for Ticket creation

through the HPD:IncidentInterface_create and HPD:IncidentInterface

forms from external systems.

. Gathered Foundation data from various user groups and uploaded the

data into the ITSM Foundation data structure using the ITSM

DataManagement tool.

. Maintained and Monitored the License usage for peak usage and updated

management with the necessary recommendations.

. Trained the users in the changes and the new remedy modules and

provided documentation to effectively use the system

Environment: : Remedy ARS (7.x and 6.x), ITSM 7.1, Incident Management

7.0.1, Change Management 7.0.1, Asset Management, (6.x), Remedy Migrator

7.0, SLA, Problem Management, Remedy Import, CMDB 2.0 Windows 2003/XP,

Oracle 10g, Crystal Reports, TOAD.

PNC Bank, Columbus, OH Feb 2005

- June 2007

Remedy Administrator

Responsibilities:

. Customized Remedy Change Management using Remedy workflow objects such

as forms, active links, active link guides, filters, filter guides and

escalations.

. Actively participated as team member in planning, designing and

implementing change management and asset management modules.

. Requirement Gathering, Analysis and Evaluation.

. Involved in Data Migration from Remedy 6.3 to 7.1

. Maintained User accounts, Licenses and developed a Custom Time

tracking application.

. Gathered requirements from various business groups/users. Analyzed

and evaluated these requirements within ITIL framework and industry

best practices. Executed validation scripts.

. Created various Crystal Reports such as Monthly reports, SLA reports

etc., on Demand as well as Scheduled reports

. Documentation of Requirement Analysis workshops.

Environment: Remedy ARS (7.1 and 6.3), Change management (7.1), Asset

management, (7.1), Remedy Migrator 7.1, SLM 7.1, Problem Management 7.1,

Remedy Import, UNIX, Oracle 9i, Crystal Reports XI, TOAD.

Sprint, Anchorage, AK

July 2004 - Feb 2005

Remedy Administrator

Responsibilities:

. Gathered, analyzed and evaluated requirements for upgrading of the

Help Desk module.

. Enhanced and Customized Remedy Change Management 6.0 application by

designing new workflow - using active links, filters and escalations -

to meet the specific requirements of the users.

. Worked actively and effectively on system trouble shooting.

. Configured and Deployed ARS Mid Tier.

. Installation & Configuration of ARS Server 6.3, Remedy Change

Management 6.0 and Approval Engine.

. Deployed workflows to customize Asset Management application.

. Installed and configured Asset Management module with MS SQL.

. Documented and executed test scripts to validate functionalities in

newer version with existing data.

. Administrated, monitored and analyzed Remedy Server and conducted

performance tuning.

Environment: Remedy ARS 6.x, Remedy Helpdesk and Asset Management 6.x /5.x

and MS SQL.

Best Buy, Omaha, NE

March 2003 - June 2004

Remedy Developer / Administrator

Responsibilities:

. Extensively involved in creating Remedy Forms, Active Links, AL

Guides, Filters, Filter Guides, Escalations and Menus for work flow.

. Developed various custom ARS applications.

. Created Several Flashboards which show the server statistics and

performance statistics.

. Installed Mid Tier and configured for optimal performance.

. Administered the User Accounts, User Licenses, permissions, Server

Maintenance.

. Supported and enhanced the existing Remedy Applications.

. Created Crystal reports according to the Users requirements.

Environment: Remedy ARS 6.x, Remedy Helpdesk 5.x, Remedy Migrator 5.x, BMC

CMDB, Remedy Import, Windows 2000/XP, MS SQL Server 2000, CSS, JavaScript,

IIS 6.0, Crystal Reports 9.0.

Genius Minds, Gujarat, India

Sep 2002 to Feb 2003

Computer Faculty

Job Duties:

. Training Students in Courses in C/C++, Oracle, PL/SQL and Visual

Basic.

. Maintained the RDBMS Oracle and SQL Server.

. Used ADO for accessing the database stored procedures and user defined

functions

. Involved in retrieving data using ADO with Visual Basic COM Classes

and presenting it to the UI

. Developed various Forms using Visual Basic and created sample

applications.

. Designed and Developed Forms with various controls to incorporate the

User Interface in Visual Basic

Environment: Visual Basic 6.0, Oracle PL/SQL, PVCS version Control.

Contact this candidate