SUMMARY:

• Over 8+years of experience in IT with over 4 years of good experience on ServiceNow Development, Maintenance and administration.
• Good experience in developing workflow sanding customizing the applications in ServiceNow using Java script, AJAX, HTML and DHTML.
• Extensive experience on technical implementation of various ServiceNow modules such as Change Management, Incident Management, Problem Management, Service Catalog, Configuration Management.
• Extensive experience on Job scripting with the help of BMC Control - M.
• Expertise in Design and development of CMDB (Configuration Management) in ServiceNow.
• Expertise in Design and configure ITSM (incident, change, problem) in ServiceNow.
• Excellent communication and interpersonal skills.
• Experience in application development using various advanced features of Oracle like Bulk Collect, Autonomous Transactions, Dynamic SQL, and Collections.
• Experienced in writing complex PLSQL Procedures or Functions using advanced PLSQL concepts
• Strongly experienced in developing Complex database Triggers, Views and Exception Handlers.
• Experienced in implementing various performance techniques such as Oracle Hints, SQL Rewrite, Indexes, etc.
• Extensive experience in data migration techniques using Oracle External Tables, SQL* loader.
• Experienced in Data Analysis, Data Modeling and Data Profiling.
• Expertise in developing both Logical Modeling and Physical Data Modeling using Erwin.
• Strong experience in creating Materialized views to improve performance of SQL queries.
• Strong understanding of Oracle Data Dictionary and Normalization techniques.

TECHNICAL SKILLS:

Languages: HTML, PL/SQL, SQL, XML, Java/J2EE

Applications: Eclipse, NetBeans, Oracle SQL Developer

Ticketing Tools: ServiceNow(Catalog configuration, Incident Management, Problem Management, Change Management, Knowledge Management, Access management)

Databases: Oracle 8i/9i/10g/11g, MS Access, MS SQL Server 2000/2005, GreenPlum

Operating Systems: Windows, Mac, MS-DOS, Sun Solaris, Linux

Web/App Servers: Apache Tomcat, Web logic Server 8.1/9.2/10, MS IIS 5/6.0, JBoss

Packages/Tools: MS Office Suite, Toad, PuTTY, FrontPage 2000, PG Admin 3

PROFESSIONAL EXPERIENCE:

Confidential, Bloomington, MN

ServiceNow Developer / Admin

Responsibilities:

• Communicating with end users, identifying their difficulties and changing the applications as per their requirements.
• Created various front end forms, and associated Client Scripts, UI policies, including advanced customizations that require modification of UI Pages/Macros.
• Experience with jelly scripting in serviceNow.
• Designed Workflows, along with standard Workflow templates which can be reused.
• Strong knowledge of the server side scripting Business rules and Script Includes.
• Implemented ServiceNow ITSM applications using ITIL V3 services best practice processes, methods, testing, and training projects for multiple, diverse organizations.
• 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.
• Implementation of changes to improve automation and efficiencies in ServiceNow.
• Manage ITIL Processes monitoring overall system performance using the System Performance and System Diagnostic dashboards. Integrating ServiceNow with other systems and customization.
• 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.
• 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.

Environment: Form Creation, Business Rules, Script Include, Client Scripting, Jelly Scripting, Email Notifications.

Confidential, Little Falls, MN

ServiceNow Developer/Admin

Responsibilities:

• New fields were added to support the client requirement along with the set of business and client rules to fulfill client requirement.
• Updating Incident/Problem/Change module based on client feedback.
• Service Catalog (Request Item, Order guide and record producer) has been created based on client requirements. Also Workflow has been created to support the Approval workflow and task assignment.
• Migration of the Manage now(Incident Management), infoweb(Change Management) requests to the Service now.
• Worked on identifying the users, groups, categories and following the ITIL standards while designing these solutions.
• Post Implementation worked as ServiceNow Administrator and supported any issues and resolved them accordingly.
• Review the outage plans and ensure post and pre outage is successful.
• Exposure to new plugins like incident alert management, orchestration and structured problem analysis.
• Created various front end forms, and associated Client Scripts,javascripts, UI policies, including advanced customizations that require modification of UI Pages/Macros.
• Configuring email with the SMTP and POP3 protocols in serviceNow.Creation of advanced workflows.
• Communicating with the end users and understanding the difficulties and as per that improving automation and efficiencies in ServiceNow.
• Fix code issues,source control and migrate the solution to production environment following the IT processes of client.
• Creating new groups and adding users to the groups in serviceNow.
• Created and moved update sets to different ServiceNow instances.

Environment: Manage now, Infoweb, Service now ITSM tool, Java scripts, Workflows and HP quality center.

Confidential, FL

Oracle PL/SQL Developer

Responsibilities:

• Created PL/SQL Stored Procedures, Functions, Triggers and Packages to transfer the data from the intermediary database to the main database using DB Links.
• Designed and developed Risk engine rules to accept inputs and validate the input through defined set of rules and generate the output using PL/SQL procedures.
• Created automated jobs using UNIX Shell scripts to run all the Sql files in a directory by invoking SQL *Plus.
• Extensively used Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming for generating worksheets.
• Created Views, Materialized Views and Indexes for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.
• Created PLSQL infrastructure for Debugging and Error Handling using stored procedures and Functions in packages.
• Created UNIX shell scripts for Encrypting and Decrypting data files.
• Worked with DBA to implement compression on Database tables.
• Worked with DBA to set up Oracle Streams that streams data from OLTP to DWH database.
• Monitoring Autosys jobs in QA, DEV and production.
• Implemented Interval range and Hash partitions to help improve the performance of SQL queries.
• Maintaining different versions for DDL extract of schemas and applications files (version control) using Tortoise SVN.
• Used Exception Handling extensively to debug and display the error messages in the application.
• Involved extensively in Tuning SQL queries and PLSQL scripts by using SQL rewrite, partitions and Indexes.
• Perform data modeling and create/maintain and modify complex database triggers and data migration scripts.
• Used SQL*LOADER and External tables to upload data into the tables.
• Worked on Power Exchange to create Mappings, workflows that loads the data from Flat files coming from source system to Oracle database.
• Monitored Informatica workflows using Informatica workflow monitor.
• Involved in Implementation and end user training.
• Worked on production support, and receive production calls, and working on trouble reports which are received from clients

Environment: Oracle 11g, SQL Developer, SQL Navigator, Tortoise SVN, HP Project and Portfolio Management, Windows XP, UNIX, Secure Shell Client.

Confidential, MA

PL/SQL Developer

Responsibilities:

• Developed PL/SQL Packages, Procedures and Functions for Various Extract Process run through UNIX Jobs.
• Coded PL/SQL Packages and Procedures using Bulk Binding, for all Statements, Dynamic SQL and Cursor Variables.
• Tuned PL/SQL Packages and Procedure to manipulate large no of data using collections like nested tables and arrays.
• Tuned Large Complex Queries and Improved Performance of PL/SQL procedures.
• Created Schema Objects like Tables, Views, Materialized views, Sequences, Constraints, Indexes.
• Developed and Deployed Traders Oracle REPORTS in Oracle Application Server 9i.
• Generated Oracle FORMS and REPORTS using Designer 6i.
• Designed and Developed Reports using Oracle Discoverer 9i.
• Improved Performance of Discoverer Reports using Materialized views.
• Developed UNIX Shell Scripts for Autonomous Jobs.
• Experience in developing logical and physical database design, data modeling using Erwin.
• Provided Productions supports and ongoing user supports for the application.
• Designed Development Documentation and Support Documentations.

Environment: Oracle10g, Oracle FORMS/REPORTS (10g), Designer10g, TOAD, Oracle Application Server 9i and UNIX Shell Scripting.