Remote Data Business Analyst

Venkata Prabhakara Reddy Vendidandi

Phone: 732-***-**** E-mail: ****@*****.***

SUMMARY

** ***** ** ********** ** IT Asset Manager

* **** ********** ** **** Business Analyst.

* ***** ** ****rience working with Flexera for software license management.

About 18 years of experience in the development of IT Service Management (ITSM) applications using ServiceNow, Remedy ARS Software Tools and RDBMS’s.

Software : ServiceNow, Remedy AR System (3.0, 4.0.3, 5.1.2, 7.0.1, 7.4.6), SAP

FI/CO R/3(3.1H)

DBMS : Oracle (7.x, 8.0.6, 8.1.7, 9.2), Sybase, MS SQL Server, MS Access

Operating Systems : HP-UX 10.x, Sun Solaris (2.6, 2.8, 2.9), Windows NT4.0,

Windows XP, Windows 7

Languages : PL/SQL, SQL, HTML

Other Computer Skills : Oracle Developer/2000, Excel, MS Access, MS Word and MS Office

2007, Power point, Crystal Reports (8.5, 9.0), Microsoft Front Page

2000, Netscape Enterprise Server 3.62, Microsoft IIS, IT Masters-

Master AR Suite 4.5, GCARS, Service Request System, VASS Billing

System, AMI, SMS, SCCM, Blazent, Flexera (FlexNet), ServiceNow

and BSM Reporting Tool..

PROFESSIONAL EXPERIENCE

TCS Inc, Edison, NJ 10/11/ 2018 – Current

Client: New York Life Insurance, Lebanon, NJ

Role: IT Asset Manager

Managing Software license management related service requests.

Maintaining Software models data in CMDB.

Improving Software related service request form in ServiceNow.

Enforcing Software license request processes while allocating the licenses.

Supporting Software supplier Vendor audits and annual true ups.

Checking the Invoices in the procurement system Ariba.

IT Asset data quality analysis and reconciliation and data normalization.

Attending Client meeting, gathering the requirements and proving them to the developer’s team.

Hardware data analysis and reconciling with the Configuration data.

Reviewing IT Asset Management process documents and providing suggestions for improvement.

Reviewing leased hardware data in the system.

Working with Security team about the Security Vulnerability based on the installed software reports from SCCM.

Managing software licenses for multiple software manufacturers like Adobe, Tanium, Microsoft etc.

SACC Inc, Santa Clara, CA 09/13/ 2017 – 10/10/2018

Client: Becton Dekinson, Franklin Lakes, NJ

Role: Business Analyst

Auditing supplier managed asset lifecycle processes.

Reviewing supplier managed Resource Unit accuracy and growth (HW/SW Assets)

Verification of supplier provided invoices.

Submitting purchase requisitions, purchase orders.

CI data analysis with the discovery tool data from SCCM and Anti-Virus systems.

Providing custom reports from ServiceNow.

Suggesting improvements for the Asset Billing processes.

SHLV Corporation, Plainsboro, NJ 02/01/ 2017 – 09/11/2017

Client: Educational Testing Service, Princeton, NJ

Role: Business Analyst

IT Asset data quality analysis and reconciliation and data normalization.

Providing custom reports from the Remedy Incident management module.

IT Asset related project management.

Evaluating software security risks.

Computer Sciences Corporation, Falls Church, VA 04/01/ 2008 – 06/30/2016

Client: Educational Testing Service, Princeton, NJ

Role: IT Asset Manager

Managing Asset Management and Cross Functional offshore support teams and provide guidance regarding asset management processes, projects and client initiatives.

Supported thousands of Infrastructure servers located in remote data centers and Cloud environments.

Maintained the Asset Configuration data and it’s relationships with People/user, locations and applications associated with those CIs.

Attended and actively participated in Change/Project Management meetings representing the Configuration Management Team.

Implemented the Configuration Management (CM) functional and physical attributes as well as support new requirements for production operations.

Provided Configuration Management (CM) oversight to verify that CMDB application perform as intended. Identify and document for support its projected life cycle. Facilitate orderly management of CI information and changes.

Worked with the consumers of the CMDB (Infrastructure, Application Support, other Service Management domains, etc) to enhance the CMDB to better serve their needs and enhance ease of use.

Recommended CMDB process improvements based on the current process evaluations.

Generating reports from SCCM and other electronic data discovery tools for analyzing the data for reconciliation and validation and normalization purposes.

Conducting Monthly Asset Inventory Accuracy Audit and generating the SLA reports for the Client.

Generating reports from the Change Management and Incident Management Modules, reviewing the data and getting Remedy updated.

Prepared the annual Budgets for Asset Management team.

Reviewed and approved the documentation related to various asset management processes with RACI charts for ETS account as a part of Quality Management Services.

Responsible for monthly asset auditing and keeping the asset inventory (Desktop PCs, Laptops, Printers, Servers and Network devices) data up to date.

Preparation of PC, Servers, Printer and Load Balancers monthly bill files and to provide justification.

Used applications like Blazent to confirm the usage of the Hardware associated with various bill files and gained the Client confidence on those billing invoices.

Actively involved in various Asset related projects as a subject matter expert from the Project Initiation to Closing.

Manage Enterprise Software License true-up & reconciliation using usage reports from Flexera. Provide support during software publisher audits. Assist with dispute resolution. Recommend audit defense initiatives.

Used Flexera data to resolve conflicts of software usage.

Ensure compliance by comparing current and future usage plans. Assist in resolving non-compliance issues.

Ensuring software license, maintenance, and support renewals and identifying opportunities for software re-harvesting and license optimization.

Software data analysis to drive key business decisions related to optimizing the cost.

Supported Remedy upgrade project implementation as an Application Architect and Developer

Verification of Asset Inventory data in SAP and reconciliation with Asset Inventory database.

Conducting analysis of service request system tickets and providing suggestions to the line of services to improve the asset data quality and Service Request experience to the Client.

Upgrading and Supporting ETS’s xBT Remedy application to 7.6.04 version.

Developed data quality and reporting measures to improve the quality and comprehensiveness of the Asset data.

Worked with the data center teams to capture and update all asset data changes resulting from data center activities.

Supported data migration from Remedy to ServiceNow, generated reports and worked reconciling asset data in CMDB.

Mapping in ServiceNow to show the mix of applications and IT components that support a service and how they are related.

Participated in Asset Management and CMDB process review audits.

Conducted annual Asset Management refresher trainings to the line of services team members and end users.

Engaging CSC and ETS senior management whenever their involvement is needed.

Role: Remedy Developer 01/01/ 2002 – 03/31/2008

Client: Educational Testing Service, Princeton, NJ

Upgraded Remedy Server version from 4.0.3 to 5.1.2, from 5.1.2 to 7.1, from 7.1 to 7.6.4 and Helpdesk application from 4.0 to 5.5, from 5.5 to Service Delivery Module 7.6, SLA from 4.0 to 5.5, from 5.5. to 7.6.4 module and implemented the client customizations.

Installed Flashboards 5.1 and Mid-Tier 5.1.2 applications and also completed upgrading to 7.1 with the customizations.

Created Custom Flashboards.

Created workflow for the Client On-Call process and linked it to the Helpdesk and Change and Task forms.

Created workflow to provide access to the end users to update their individual On-Call schedule.

Responsible for the preparation of upgrade strategy and implementation of the data migration.

Worked on the Remedy system customizations to the HelpDesk 4.0 application to meet the business requirements and working on several other requirements such as Notifications, Service Level Agreements, Access restrictions etc.

Worked on generating several reports from Remedy system.

Worked on linking the custom made Crystal Reports 8.5 and Crystal Reports 9.0 with the Remedy Reporting tool.

Providing the Technical support for the Remedy based trouble tickets.

Supporting the Client’s change requests on Remedy system.

Responsible for performing the monthly Asset Usage reports based on AMI data.

Worked on various Cross Functional Management processes.

Generating the reports from the Computer Associate’s Advanced Helpdesk application.

Responsible for generating asset related reports based on the client requirements.

Preparing monthly bill file for the desktop devices and providing feedback to the Finance department.

Conducting monthly Asset Cycle count for asset accuracy on the filed with the asset database.

Successful in improving/gaining Clients confidence in Asset data in AMI and responsible for Client interaction regarding asset related data.

Educational Testing Service, Princeton, NJ 04/01/ 2001 – 12/31/2001

Role: Remedy Developer

Implemented many workflow Customizations to the HelpDesk 4.0 application to meet the business requirements and working on several other requirements such as Notifications, SLAs, Access restrictions etc.

Worked on data migration for periodically updating the people records.

Installed and customized the Asset Management 4.0 application.

Completed the Installation of the Remedy Web 4.01 and AR Web 4.0 applications.

Worked on generating several Remedy reports.

Worked on linking the custom made Crystal Reports 8.5 with the Remedy Reporting tool.

Providing the Technical support for the Remedy based trouble tickets.

Pelican Systems Inc., E. Remington Drive, Sunnyvale, CA 01/26/1999 – 03/31/2001

Role: Remedy Developer

Installation and customization of AR Web 3.2, HelpDesk Central.

Flash Boards 2.0 - Customization to analyze the Remedy Server performance.

Developed the workflow for enhancing the functionality of the existing Remedy HelpDesk application.

Integrated the Remedy database with Microsoft Access database for enhancing the functionality of the existing Remedy HelpDesk application.

Remedy Help Desk 4.0 - Installation, Configuration and Customization.

Advantage KBS IQ Web Pro Server 2.0.1, IQ Web 2.0.1, IQ Author 1.0 - Installation.

Service Level Agreements (SLA) 4.0 – Installation and Configuration

Remedy System end user training.

EDUCATION & TRAINING

Ph.D. Agronomy, Banaras Hindu University, India.

CAIIB Indian Institute of Bankers.

Oracle RDBMS and Developer 2000.

SAP R/3 FI/CO.

Help Desk 4.0 - Remedy Corp., CA

Asset Management 4.0 - Remedy Corp., CA

AR Web and Remedy Web 3.2 - Remedy Corp., CA

Remedy Distributed Server Option (DSO) - Remedy Corp., CA

Flash Boards 2.0 - Remedy Corp., CA.

Change Management 4.0 – Remedy Corp., CA

AR System 5.x Delta – Remedy Corp., CA

ITIL v3 Foundation Certified – Year 2008

Achieving IT Service Excellence – Year 2011

Six Sigma Green Belt Certified – Year 2011

Contact this candidate