Servicenow Developer / Admin Resume
Sunnyvale, CA
SUMMARY
- Having 8+ years of experience in IT industry with 4 years of very good experience in Service Now Development, Maintenance, Implementation, Support and Administration.
- Having 4 years of experience in the field of Database and implementation in PL/SQL.
- Expertise in Design and configure ITSM (incident, change, problem) in ServiceNow.
- Extensive experience in Software Development Lifecycle (SDLC) managing project scope, requirement definition, resource management, change management, analysis, managing work schedules, project status reporting, project coordination and conflict resolution.
- Expertise in Design and developing custom applications in ServiceNow and utilize its potential in PaaS (Platform - as-a-Service).
- Expertise in Design and development of CMDB (Configuration Management) in ServiceNow.
- Hands-on experience leading all stages of system development efforts including requirement, design, architecture, testing and support.
- Good experience in working with Java Script, CSS, HTML and XHTML.
- Experience with Job scripting with the help of scheduling tool Control-M.
- Good knowledge with Deployment in UNIX Environment.
- Excellent communication and interpersonal skills.
- Experience in developing custom developed application using ServiceNow.
- Implemented ServiceNow ITSM applications Incident, Change, and Helpdesk Management
- Technical implementation of various ServiceNow modules such as Change Management, Incident Management, Problem Management, Service Catalog, Configuration Management
- Developed business requirements and technical design documents for implementing Service-Now.
- Expertise in Oracle Stored subprograms, Packaged subprograms, Cursors, Cursor Variables, Collections, Triggers, Native Dynamic SQL.
- Expertise in distributed query performance tuning by using EXPLAIN PLAN, SQL Trace and TKPROF Utilities, hints provided by oracle.
- Expertise in RDBMS development including Oracle SQL, PL/SQL database backend programming with stored procedures, Functions and packages.
- Experience in Data migration Projects which uses SQL Loader, PL/SQL programming, coding Procedures, triggers and functions
- Expert in Export, Import and SQL*Loader Utilities.
- Experience in data extraction, data migration and Data loading.
- Having production support experience with quickly problem solving capabilities.
TECHNICAL SKILLS
Service Now: Service Now ITSM Service Now Administration and Support (Service Catalog configuration, Incident Management, Problem Management, Change Management, Knowledge Management, Access management (RITM), LDAP, Personalizing Forms, Personalizing Lists, scripting, loading data, Adding and changing dictionary, Business Rules, Configuring SLA’s for incident/request/catalog tasks, Workflows, Notifications, Email configuration, Inbound actions on emails, Maintaining mid servers or configuration, Adding/ modify/ delete Assets, Iframes, Schedule jobs using scripts, Discovery module, Create update sets, Move update sets between instances, testing, Fuji Testing)
Testing Tool: HP Quality Centre 10.0 and 11
CRM Tools: Kana CRM, Clarify
Database: Oracle 9i, Oracle 10G, Sql Server
Operating Systems: Windows 2008, 2003, 2000, XP, UNIX, Sun Solaris 5.9
Tools: / Others: Toad, Clarify, SQL, PL/SQ
PROFESSIONAL EXPERIENCE
Confidential, Sunnyvale, CA
ServiceNow Developer / Admin
Environment: Incident management, Business Rules, Script Include, Client Scripting, Jelly Scripting, Email Notifications, LDAP Integration, Change management, Service Level Management, Survey management, Clone.
Responsibilities:
- Designed a company-wide service catalog that offers a collection of services
- Involved in customization of UI for a knowledge base.
- Created customized login pages, search pages with drop down list in search bar.
- Configured and retrieved the service catalog items from the databases for user friendly in new cms UI pages UI actions.
- Involved in designing, development of Home Page, Place Order for Service Catalog, Knowledge base, Create a service ticket, Schedule a call from the service desk and schedule a time for solving the issues with one to one personally
- Involved in creating of IT New Flash where the day to day news are getting scrolled by using the knowledge articles.
- Designed and developed the application UI configuration with salesforce.
- Extensive experience on job scripting with the help of BMC remedy on Control-M
- Created update sets for configuring in different instances i.e., temp, test, uat, dev and production instances.
- Change module, Incident module, problem module are updated on clients feedback.
- Expertise in server side scripting as well as background scripting.
- Configured Surveys and enabled contact with third party to access the survey modules.
- Developed Inbound actions, contains a third party email can generate an incident/request in ServiceNow.
- Met all service level agreements (SLA’s) and delivered all significant result and deadlines.
- Actively involved in daily Scrum meetings
Confidential, Miami, FL
ServiceNow Developer / Admin
Environment: Service Catalog Workflows, Catalog client script, LDAP, LDAP import sets, SSO, Mid-Server, Business rules, Incident management on desktop and mobile view, Change management, Problem management, Project management, Knowledge management, Javascript, Jellyscript, Asset management, Contract management, Procurements, Reports, Content management, Service Level Management, Survey management, Clone, Upgrade to Fuji.
Responsibilities:
- Gathering the requirements from the customers and preparing the documents and taking sign-off before starting with the development process.
- Designed an Enterprise level service catalog items that offers a collection of services.
- Involved in Designing, Development and Implementation of Service Catalog forms.
- Involved in customization of UI policies/ UI actions for a Catalog Tasks as well as Incident Management.
- Involved in designing, development of Employee Self-service portal, Order guide for Service Catalog, Knowledge base, Create a service ticket, Schedule a call from the service desk and schedule a time for solving the issues with one to one personally.
- Involved in creating the dashboard for individuals in a group contains their My group work, My work, Tickets Created by me.
- Developed and executed the Schedule Reports and Schedule jobs.
- Maintained the On-call rotations order for avoiding the conflicts.
- Scheduling the Discovery to identify the computers/network devices and tracking the devices.
- Involved in creating of My Dashboard where it contains My Requests, My Reports of Incidents and a search bar for searching of Incidents.
- Designed and developed the activity stream for ITIL users can verify the notifications such as ticket/task assignments, Emergency information.
- Linking the relation between short description, category, and sub-category to avoid the time lag to the users.
- Developed complex workflow for On-boarding/ Off-boarding forms.
- Involved in writing of CSS, HTML, XML, JavaScript, Jelly Script, and JQuery.
- Created excel format in project management with the help of UI Pages using Jelly script.
- Configure the schedule jobs that helps to run the discovery schedules using Java scripts.
- Configured SSO using web-services (SOAP/REST) in integration.
- Used Bootstrap framework for the development of responsive pages for desktop, mobile ui, iPad, iPhone and android enabled devices.
- Created update sets for configuring in different instances i.e., temp, test, uat, dev and production instances.
- Configuring and Retiring of assets using customer request.
- Configuring Service level agreements (SLA’s) to Incident/ Request/Task.
- Met all service level agreements (SLA’s) and delivered all significant result and deadlines.
- Involved in Fuji Testing (from Eureka patch 12 to Fuji Patch 10).
- Experience on Support, Customization, VPN Setup, Mid - Server configuration.
- Having production support experience with quickly problem solving capabilities
- Coordinated with Offshore resources and updating the daily scrum status.
- Actively involved in daily Scrum meetings.
Confidential, Charlotte NC
ServiceNow Developer / Admin
Environment: Form Creation, Business Rules, Script Include, Client Scripting, Jelly Scripting, Email Notifications, LDAP Integration
Responsibilities:
- Communicating with end users, identifying their difficulties and changing the applications as per their requirements.
- Implemented ServiceNow ITSM applications using ITIL V3 services best practice processes, methods, testing, and training projects for multiple, diverse organizations.
- Planned and implemented a complex, enterprise wide, six sigma, and global, Infrastructure Asset Management In-sourcing project.
- Orchestrated the efforts of vendors, and internal divisions/departments to internalize new IT Asset Management processes
- Preparing Implementation Plan for every release in ServiceNow and provide Walkthrough to the entire team to execute the steps.
- Planning and coordinating the execution of Implementation along with Technical/Business validations post every Maintenance/Major release in ServiceNow.
- Implementation of Software and Change Management, ServiceNow Change Management.
- Project Managing the development, Testing and Implementation of OIPG Engagement Dashboard for all the Streams of OIPG.
- Implementation of changes to improve automation and efficiencies in Service Now.
- Manage ITIL Processes monitoring overall system performance using the System Performance and System Diagnostic dashboards. Integrating ServiceNow with other systems and customization.
- Development of enterprise application and integration on Salesforce/dot net/Java/JEE/JSP/Servlets with web services SOAP and REST.
- Technical implementation of various ServiceNow modules such as Change Management, Incident Management, Problem Management, Service Catalog, Configuration Management.
- Managed all Change Management Information (ServiceNow).
- Managing ServiceNow (Change Management) ITIL Automate and standardize business processes for all Go-Lives. Consolidating all global IT to a single system of record.
- Monitored the work items that have been given by client and evenly distributed among the team to make sure ETA is met appropriately.
- Have exposure to SAAS (Software as a Service) with experience in Process Implementation (Knowledge Management, Configuration Management and Change Management).
- Involved in Designing, Development and Implementation of CMS (Content Management System) Web Site.
- Involved in daily, weekly and monthly meetings with client on the work progress and discussions on the upcoming work
- Responsible for Development Team Performance and involved in grooming & mentoring team members on various processes
Confidential, Indianapolis
ServiceNow Developer /Admin
Environment: ServiceNow ITSM tool, Java Scripts, SQL, LDAP, HP Quality Centre
Responsibilities:
- ServiceNow ITSM module administration.
- Service Catalog creation, configuration and deployment.
- Routine Support activities for Incident Management, Problem Management, Change Management, Knowledge Management.
- Workflow design and implementation.
- Workflow configuration according to the user interface.
- Work on various ServiceNow customization, enhancements as per Client requirements.
- Access request Management (RITM).
- CMDB and Knowledge Management.
- Create and move update sets to different ServiceNow instances.
- Data Management and report creation.
- Testing of different integration and changes to ServiceNow instances.
- Customer / vendor meetings and Reporting’s
- Documentation and providing user trainings.
Confidential, Lowell, MA
Pl/Sql Developer
Environment: Oracle 10g/9i, SQL, PL/SQL, SQL*Loader, MS Access, UNIX Shell script, TOAD, Oracle Forms 10g,Reports10g,UNIX, Windows XP/2000.owb 10g.
Responsibilities:
- Collaborated with the Business analysts and the DBA for requirements gathering, business analysis, testing and project coordination
- Created process force and deployed into run time depository using ware house builder
- Involved in logical modelling and physical modelling of application.
- Used multiple operators (union, router) for loading data using owb.
- Having strong knowledge in creating and maintaining the owb
- Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
- Involved in developing CRONTAB to schedule the information of crone tries.
- Involved in creation of Conceptual Modelling covering all the business requirements.
- Loaded the data into database tables using SQL*loader from text and excel files.
- Developed data model, SQL Queries, SQL Query tuning process and Schemas. worked with bulk collect to Implement the performance of multi row queries
- Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
- Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
- Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
- Data loaded from legacy systems using PL/SQL and SQL*Loader.
- Remediate Oracle application Custom object components like Forms, report and Concurrent Program (PLSQL code).
- Involved in development of Oracle Forms/Reports, New Screen designs, Modifications.
- Upgraded to Forms 10g, Reports 10g, maintained and troubleshoot Oracle Forms and Reports.
- Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.
- Worked on admin and user editions of discoverer 10g and used AIM (application implementation methodology) in documenting the development tasks.
- Developed Master Detail, Detail reports using tabular and Group above reports.
- Developed Procedures for efficient error handling process by capturing errors into user managed tables.
- Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
- Delivering and deployment of the software using Shell scripting with tools like DSM and ITCM.
- Generated various analytical reports using Microsoft Access.
- Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
- Developed all the OLTP backend processing using Pl/Sql Packages and cursors.
- Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
- Developed UNIX Shell scripts to automate table creation, execute procedures.
- Used Toad for creating PL/SQL (trigger, sequence, stored procedure).
- Used UTI FILE PACKAGES for writing DBMS OUTPUT messages to file.
Confidential, FL
PL/SQL Developer
Environment: Oracle 10g/9i, SQL Navigator 5.5, Rational Clear case 7.0, Quality Center 9.2, UNIX, Win 2000/XP.
Responsibilities:
- Designed, created and tested enhancements to a high performance OLTP client server system processing for both daily and scheduled financial transactions.
- Involved in designing Technical Design Documents based on health care Business requirements.
- Extensively used advanced PL/SQL concepts (e.g., varrays, PL/SQL tables, cursors, user defined object types, exception handling, database packages, nested tables) to manipulate data
- Wrote packages and procedures to move data from one table to another.
- Created indexes on tables to improve performance of the queries
- Used BULK COLLECT to fetch large volume data.
- Used Control - M a third party tool to schedule various others batch processing jobs.
- Involved in the performance tuning of various database queries. The queries retrieved data from different tables in multiple databases.
- Used EXECUTE IMMEDIATE to execute dynamic SQL.
- Used Explain Plan, TK Prof in tuning queries.
- Used analytical functions like LEAD, LAG.
- Raised Siebel exception using plsql packages.
Confidential
Jr. PL/SQL Developer
Environment: Oracle8i/9i, SQL, PL/SQL, SQL*Loader, Toad, Windows NT/XP redesign application involves extensive use of Oracle queries and procedures for seamless application flow. This involves extensive rewrite of queries, procedures in Oracle 8i as the database, which involves multi-user and multiple development location.
Responsibilities:
- Written PL/SQL Stored Procedures, Functions and Packages and Triggers to implement businessrules into the application.
- Used SQL*Loader to load data from Excel file into temporary table and developed PL/SQL program to load data from temporary table into base Tables.
- Developed numerous programs using PL/SQL and many packages to do the validations as per requirements.
- Used Dynamic SQL (DBMS SQL, DBMS DDL) in function and procedure.
- Generate SQL Scripts and create views for reports.
- Used Toad to Extract and test the data in the database.
- Developed Database Triggers to enforce security.
- Involved in Data Extraction using UTL FILES in PL/SQL.
- Prepare technical documents for all the programs developed & generated.
- Responsible in coding and debugging.
