Sreenivas

573-***-**** abl52u@r.postjobfree.com

SUMMARY:

. 8 years of experience in Analysis, Design, Development, Management

and implementation of various applications using Remedy Action

Request System and various intranet, client-server and web based

applications using .Net Framework and Classic ASP

. Developed many applications using AR System 5.x through 7.x such as

Trouble Ticket Applications, Service Request Systems, Time Tracking

Management, Asset Management Applications, Knowledge Base

applications.

. Strong knowledge of using Remedy APIs in C#, .Net environments.

. Expertise in using Remedy tools and utilities such as Remedy

Migrator 7.x, Remedy Import 7.x, Remedy Flashboards, Remedy

Approval Server 7.x, Remedy ChangeId, Remedy Macro Editor, Remedy E-

mail Server, Master AR Suite, Remedy Explorer 6.x.

. Excellent knowledge of Remedy packages such as Remedy Helpdesk

Application 7.x, Remedy Change Management 7.x, and Remedy Asset

Management 5.x.

. Experience of web interface using Remedy Mid-tier 6.3, publishing

and consuming the web services in .Net using C# and XML Schemas.

. Extensive knowledge of creating and using Remedy workflow such as

Remedy Forms, Active Links, AL Guides, Filters, Filter Guides and

Escalations etc.

. Experience in working with ITSM 7.x.

. Experience in applying BMC Remedy ARS and ITSM Patches.

. Experience in creating Reports using Remedy ODBC Drivers and OLEDB

with Crystal Reports 9.0.

. Experience in developing applications in .Net Framework, ASP.NET,

ADO.NET, C#, VB.NET, Visual Studio 6.0, ASP and integration with

Crystal Reports.

. Good experience in design, modeling and development of Databases

SQL Server (Transact-SQL), Oracle (PL/SQL).

. Excellent knowledge of HTML, DHTML, ASP, PHP, XML and XSL/XSLT and

JavaScript, VB Script.

. Experience with .NET Remoting, Web Services, APIs, and COM/DCOM.

. Experience in database design and server-side programming in SQL

Server 2005, MS-Access and Oracle.

. Proficient in creating Stored Procedures, Functions, Triggers, DTS

packages using T-SQL.

. Experience in developing the business reports using Crystal

Reports.

. Excellent communication skills both verbal and written and ability

to work on own besides being a valuable and contributing team

player.

. A keen planner & strategist with expertise in handling projects for

improving efficiency to meet the deadlines as per requirement.

EDUCATION:

Master of Science in Computer Science, INDIA.

TECHNICAL SKILLS

Remedy Software and Utilities:

Remedy Action Request System 7.x/6.3/5.x/4.x, Remedy

Midtier 7.x,

Remedy Migrator 7.x, Remedy Import 7.x, Remedy AR

Suite,

Remedy Approval Server 6.x, Remedy DevPlus 6.x,

Remedy APIs using C, .Net environments,

Remedy HD 5.x, CM 5.x, and AM 5.x packages, ITSM

7.X(IM,CM,PM,TM,AM)

Remedy Knowledge Management 7.1 Patch 1

. NET Technologies:

ASP.NET, ADO.NET, VB.NET, C#, XML Web Services

Web Technologies:

HTML, DHTML, CSS, XML, XSL, XSLT, VB Script,

JavaScript,

FrontPage, Adobe PhotoShop and Macromedia Dream

Weaver MX.

Languages:

C, C++, C#, VB.NET, VB, VC++, Java, SQL, PL/SQL, T-

SQL.

Operating Systems:

Windows NT/95/98/2000/XP, Linux, UNIX and MS-DOS.

Databases:

SQL Server 2000/7.x, Oracle 10g, MS-Access, My SQL.

Middleware:

COM, COM+, DCOM, ODBC, ADO and ActiveX.

Web Servers:

Internet Information Server (IIS)

SunOne 6.1 Webserver.

Reporting Tools:

Crystal Reports 9.X

PROFESSIONAL EXPERIENCE

Cameron International, Houston TX Jul'08 - Present

Sr. Remedy Lead Developer/Admin

Responsibilities

. Gathered requirements from various business groups/users.

. Acted as the Subject Matter Expert (SME) to answer all

implementation and technical related questions from Management as

well as user community.

. Upgraded ARS 7.1 to 7.5 with ITSM suite 7.5.

. Requirement gathering, analyzing the requirements Designing the

application.

Installing BMC Remedy AR System 7.5 and BMC Remedy ITSM 7.5 Suite

of applications in a Server Group Load Balancing and failover

environment.

. Procure the license keys from BMC Remedy and install them on AR

System 7.5 server.

. Configuration of the BMC Remedy ITSM 7.5 suite of applications.

. Data conversion and mapping from the current system to ITSM 7.5

forms.

. Data Load: BMC Remedy Data Import tool and BMC Remedy ITSM Data

Management tool was used to populate Foundational data Process data

and Transactional data.

. Customizing the BMC Remedy ITSM 7.5 Suite of applications according

to the client requirements.

. Customizing BMC Atrium Core 7.5 application: Adding additional

attribute to existing classes and creating new classes.

. Used AIE to populate data in Atrium Core and ITSM applications.

. Used SLA's for performance tracing of different groups in the

Organization for reporting purposes.

. Implemented SLA module to track the efficiency of various groups

within the operations department.

. Administration and Support of ITSM 7.5 Applications.

. Analyzed and evaluated these requirements within ITIL framework and

industry best practices.

. Installation of Service Request Management 2.2 on ITSM 7.x.

. Created Adhoc Reports Weekly Monthly Based of Status and Based of

Priority

And Also Open Pending Closed Cases per Assigne and Assigned Group.

. Created various Crystal Reports such as Monthly reports, SLA

Reports etc., on Demand as well as Scheduled reports.

. Implementation/Customization of BMC Remedy Service Request

management.

. Involved in System test, Integration test and Regression test.

. Definitions and Data migration from one server to another.

. Testing existing functionality after migration.

Environment: ITSM 7.x, ARS 7.x running on Windows 2003 EE, Remedy

Approval Engine, Remedy E-mail Engine using SQL Server 2005.

AT&T, MO Jan'07 - Jul'08

Sr Remedy Developer/Admin

Description

Worked on the project Dry Loop, Remedy is used to perform Integrated

Service Trouble Management (ISTM) function. ISTM is responsible for

facilitating responses to customer-initiated troubles by forwarding the

service trouble ticket to the appropriate factories, correlating

customer initiated troubles and Network detected fault, providing

outage information.

The Remedy Action Request System, a rapid application development

environment for automating and maintaining business processes, is used

as the core component of ISTM. ISTM will leverage the core ARS

environment and capabilities but will configure BLS-specific ticketing

forms, workflow, rules and following functionalities:

. Receipt of customer-initiated trouble tickets from the CI layer

that are due to technical issues and must be referred to the

Bellsouth Internet Customer Support (BICS) group

. The creation of a corresponding Service Trouble Ticket for the

Customer Service Trouble Ticket

. Referral of Service Trouble Tickets to the DSL Transport/IP

factories

. Receipt of status/closure notifications from the factories

. Forwarding of change in the Service Trouble Ticket status to the

CI Layer

Responsibilities:

. Involved in upgrading Remedy system from ARS 6.0.1 to ARS 7.x

. Involved in upgrading the ITSM suite from 6.0 to 7.0

. Involved in installing and configuring CMDB 2.0

. Identified and defined new CIs in BMC Atrium CMDB.

. Worked on Common Request System, Problem Tracking, Time Tracking

System Remedy application projects.

. Involved in the development of web interface using Remedy Mid-tier

web services consumed in .Net environment using C# and XML Schemas.

. Created and maintained documentations such as Functional design

documents, detailed design documents, data flow diagrams, data

entity relationships documents for all the internal projects.

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

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

. Deployed all of the developed internal applications on the web

using Remedy 7.x and 6.3 Mid tier.

. Created various Crystal Reports such as Monthly reports, SLA

Reports etc., on Demand as well as Scheduled reports.

. Extensively involved in the customization of Remedy Helpdesk

Application 5.6 for the support center department.

. Involved in coordinating with off shore and updating the client.

. Involved in System test, Integration test and Regression test.

Environment: Remedy ARS 7.x and 6.x, Remedy Migrator 7.x, Remedy E-mail

Server, Remedy Approval Server, Remedy ITSM 7.0, Remedy Import 7.x, BMC

Atrium CMDB, C#, C++, Windows 2000/XP, Oracle 9i/10g, Crystal Reports

9.x, .Net, XML.

Alliance Bernstein, NYC, New york

Oct'04 - Dec'06

Remedy Developer/Administrator

Description

Worked on enhancing and modifying the existing helpdesk application by

modifying

the workflow. Created a web application for running Crystal reports and

creating

bar graphs, pie charts on demand.

Responsibilities

. Worked with the end clients in gathering the Business requirements.

. Involved in Design & Analysis of the Customer Specifications,

Development and Customization of the Application.

. Installed and Configured Remedy Action Request System 7.x

. Involved in implementation of Remedy Flashboards for various SLA,

CTID problem ticket statistics.

. Supported and enhanced the existing Remedy Application.

. Created Several Flashboards which show the server statistics and

performance statistics.

. Created a Stand alone web Application through which Users run reports on

demand and see the aging reports.

. Worked on upgrading Midtier from 6.0 to 6.3

. Involved with the configuring of SLA's depending on requirements of

various groups.

. Configured different approval rules and roles for the current

setup.

. Was instrumental in identifying CI's / Classes and relationships

while setting up CMDB with BMC Patrol.

. Designed different service reports to be used by the Quality

department using crystal reports.

. Created and maintained documentations such as Functional design

documents, detailed design documents, data flow diagrams, data

entity relationships documents for all the internal projects.

. Involved in creating Remedy Forms, Active Links, AL Guides,

Filters, Filter Guides, and Escalations for work flow.

. Involved in migration of definitions and data using Remedy Migrator

6.0.3, import, export tools, from development to acceptance and

production system.

. Administrated, monitored and analyzed Remedy Server 7.x and

conducted performance tuning.

. Involved in changing the Macros.

. Worked on CTI restructuring while maintaining the old CTIs for search

purpose.

. Automated the process of removing Terminated Employee Profile from AR

System through the use of APIs.

Environment: Remedy ARS 6.x, Remedy Email and Approval Server, Remedy

Helpdesk 5.x, Remedy Migrator 5.x, Remedy Import, Windows 2000/XP, MS

SQLServer 2000, CSS, Macromedia DreamWeaver, JavaScript, VBScript,

VB.NET, VS.NET, IIS 6.0, Crystal Reports 9.0.

Compass Bank, Montgomery, AL July'03

- Sep'04

Remedy Developer / Administrator

Description

Worked for several projects such as Service Request System, Trouble

Ticket System, Conference Call and Knowledge Base Remedy Applications.

The Service Request system keeps track of all the requests in the

technology division and the requests needs approvals from the

application owners, manager and supervisor.

The Trouble ticket system keeps track of problems which will be

escalated to higher priority, if they doesn't completed within their

SLA period.

The Conference Call Reservation application is used to make the

conference call reservation, the conference calls can be one time or

recursive calls.

The Knowledge Base application keeps track of previous problems,

solutions and their root causes and will be useful for the support

center members to provide the previous solutions.

Responsibilities

. Assisted business units in the development of systems

requirements and functional specifications.

. Involved in the business analysis of the applications and

finding the common shared data between the applications implemented

with new design to utilize centralized data.

. Created and maintained documentations such as Functional design

documents, detailed design documents, data flow diagrams, data

entity relationships documents for all the internal projects.

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

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

. Deployed all of the developed internal applications on the web

using Remedy 6.3 Mid tier.

. Involved in installing and configuring Remedy Approval server

and integrated with our internal CRS application by defining

various roles and rules of the approval server. Developed web pages

using ASP.NET, C#, HTML, DHTML, and IIS.

. Created various Crystal Reports such as Monthly reports, SLA

Reports etc., on Demand as well as Scheduled reports.

. Involved in upgrading Remedy system from ARS 5.1.2 to ARS 6.0.1

to ARS 6.3.0

. Involved in migration of definitions and data using Remedy

Migrator 5.x, import, export tools, from development to production

system.

. Involved in the development of web interface using Remedy Mid-

tier web services and consumed in .Net environment using C# and XML

Schemas.

. Also involved for implementing SQL Server DTS packages for

processing, transforming and loading data into SQL Server database.

. Developed various Charts and Graphs like Bar Chart, Line graphs,

Pie Charts etc by using Chart Expert of Crystal Reports.

Environment: Remedy ARS 6.x, Remedy Migrator 5.x, Remedy Import, C#,

C++, Windows 2000/XP, MS SQL Server 2000,.Net, XML, VS.NET, ASP.NET,

XML, XSL, XPATH, CSS, Front Page, JavaScript, VB.NET, C#, ADO.NET, IIS,

SQL Server 2000, Crystal Reports.

Knology Corporation, Atlanta, GA

Oct'01 - July'03

Remedy Developer

Description

Worked for Convlite (Convergence Light) Trouble Management, TMS,

project for High Speed Data customers. Whenever the Powerlink customers

calls for the troubles, customer is being verified through the billing

interface, provided by CSG Billing system and the network devices

connected to the customer are verified through the 'Network

Troubleshoot Toolkit' and escalated to the appropriate managers.

Responsibilities

. Involved in Collection, Design & Analysis of the Customer

Specifications, Development and Customization of the Application.

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

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

. Involved in the development of 'Network Troubleshoot Toolkit'

and is being implemented in C language using SNMP calls to the

appropriate CMTS, CMs and the routers and the troubleshoot

information is provided back to the TMS through C Remedy API

interface.

. Also used Remedy Master ARSuite software for analyzing the

Remedy workflow and documentation purposes.

. Involved in upgrading Remedy system from ARS 4.5.7 to ARS 5.0.1

version.

. Also involved in generating the emails and escalating to the

appropriate managers depending upon the business rules of the

applications.

. Involved in the implementation of external processes to read

the data from the Oracle tables of legacy systems, process the

records and inserts or updates to the Remedy Schemas using C Remedy

APIs.

. Developed various monthly and SLA reports using Crystal

Reports.

. Developed SQL stored procedures for data manipulation and

querying data.

. Developed Role base Security to authorize the request member to

a specific Role.

. Created Tables, Indexes for performance improvement and also

rewrote stored procedures to increase performance.

. Created user defined functions for String Manipulations and for

formatting dates etc.

Environment: Remedy AR System Software 5.x, Master ARSuite Tools, C,

C++, UNIX Solaris 2.8, SQLPlus, PL/SQL, Oracle 9.x, Java, XML, JSP.

Surf India, Bangalore, India

Jun'00 -Sept'01

Web Developer

Dealer Inventory Management, Order tracking and Content management

[EPSON]

Description:

Developed a web based application tool for EPSON Product Dealers to

keep track of inventory and track orders. The wholesale dealer can log

into the system and manage the inventory and catalogue data such as

product information, quantity, price etc. The Dealer can also use the

order tracking module to update the status of individual orders placed

by the retailers. Retailers can use the catalogue to place orders and

use the Order Tracking module to track order status. The content

management software allows frequent update of contents on the web site.

The application also allows for communication between the Dealer and

Retailers on any specific order.

Responsibilities:

. Performed analysis and design of the system. Worked with users to gather

requirement specification.

. Created the SRS Documentation after the initial study of requirement.

. Created a three layered architecture and flow architecture for the

system

. Developed the application using ASP as front end, VB, ActiveX DLL, COM

+ as middle tier and SQL Server 2000 as back end.

. Developed Business Logic layer using VB COM and ADO to access data from

back end SQL Server 2000

. Developed reusable JavaScript functions for form validations and

navigation.

. Involved in the logical and physical design of Relational database

design using SQL Server 2000

. Used stored procedures, user defined functions, views and triggers for

improved performance of database

. Created standard reports and custom report writer using Crystal Reports

at different management levels

. Prepared training manual and was involved in training users.

. Created User Interface design using Adobe Photoshop. Integrated the User

Interface with the web application by Hand Coding HTML and cross browser

DHTML.

Environment: Visual Studio.Net, ASP, VB 6.0, ActiveX DLL, COM+, IIS,

SQL Server 2000, ADO, T-SQL, Visual Source safe 6.0, Crystal Reports,

JavaScript, HTML, DHTML, CSS, Windows 2000, Adobe Photoshop, Macromedia

Dream weaver, Macromedia Homesite.

Contact this candidate