PROFESSIONAL SUMMARY:

• A Qualified IT Professional with 9 years of experience including 5+ years of experience as a ServiceNow suite developer and administrator.
• Experience in Implementation of Workflow, Incident Management, Problem Management, Change Management and Service Catalog on various business applications.
• Implemented ServiceNow Service Catalog Requests, Asset Management, Configuration Management, Service - Now Administration, Incident and Problem Management, Knowledge Management, Reporting, Gauges, Integration with Web Services.
• Functional knowledge and implementation experience of ITSM frameworks.
• Experience working on different versions of ServiceNow: Aspen, Berlin, Calgary, Eureka
• Create, monitor, modify, and publish service catalog workflows with approvals. Maintain Single Sign-On integration.
• Good knowledge of CMDB and Asset Management Services: Business Services and Configuration item relationships.
• Expertise on creation of workflows for Service Catalog items in Service-Now.
• Working experience of various phases of SDLC such as Requirement Analysis, Design, Code Construction and Test.
• Strong experience in working in various software development practices like Waterfall, Agile
• Hands on Web Development using HTML, JavaScript, Jelly and CSS.
• Expert in writing/Creating Generic Stored Procedures, Functions, Database Triggers, Packages, tables, indexes, views, synonyms, sequences using SQL and PL/SQL. Experience in Data Warehouse applications, directly responsible for the Extraction, Transformation & Loading of data from multiple sources into Data Warehouse.
• Experience in creating Materialized Views. Tuning and optimizing current and new applications utilizing DBMS packages, and enhancing performance through regeneration and rebuild of indexes and creation of views
• Experience in business requirements gathering, define and capture metadata for business rules, creating physical infrastructure, system analysis, design, development and user training associated with the ELT processes.
• Knowledge in OLTP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
• Experience in data analysis, data modeling, system analysis and requirements management, business process modeling in Finance, Banking and Insurance industries.
• Experience in performance tuning of sources, mappings, targets and sessions.
• Experience in Administration activities like Creating and Managing Repositories, Users, User Groups, Folders, Working with Privileges in Repository Manager.

TECHNICAL SKILLS:

ITSM Tools: ServiceNow, ITSM Suite

Operating System: Windows Client (7, Vista, XP - Pro, 2000, etc.), Windows Server (NT, 2000, 2003, 2008), Mac OS-X

Project Management / Tools / Applications: All MS Office suites (incl. 2003), MS Exchange & Outlook, Lotus Domino Notes, Citrix Client, SharePoint, MS Internet Explorer, Firefox, Chrome, Apache, IIS

Languages: Java, HTML, CSS, XML, SQL, C#, VB.NET

Application Servers: Web Logic Server, IBM Web Sphere and Java Web Server

Hardware: Networking

Web Technologies: HTML, JSTL, DHTML, JavaScript, CSS, XML, JSON, AngularJS, Bootstrap, (Agile)

ServiceNow Modules: Incident Management, Change Management, Problem Management, Service Catalog, Service Level Management, CMDB, Data Loading, Start Now, On Call Scheduling, New Call, Web Services, ODBC Connectivity.

Databases: DB2, SQL server, MS-Access, MySQL,Oracle 9i/10g.

WORK EXPERIENCE:

Confidential

Sr. Service Now Developer

Responsibilities:

• Implementation, Customization and Maintenance of ITIL modules such as Incident, Change, Problem, Knowledge, Service Catalog, CMDB in ServiceNow
• Worked on change management module by enhancing the tool to the stakeholders and made it easy to understand.
• Development of Service catalog which includes creating new catalog items, designing workflows and execution plans.
• Loaded Configuration Items (CIs) from Excel files into Service Now using import sets and Transform Maps.
• Created functional and technical specifications documents for various Service Now modules
• Coordinating the instance upgrade activities.
• Created various Business rules, Script includes, Client Scripts, UI Policies, UI Actions and Data Policies.
• Involved in cloning activities like raising the request for cloning and excluding some tables to not come under cloning.
• Worked on CMDB from the scratch
• Created CI relationships and Suggested CI Relationships
• Configured multiple forms for Asset module using Configuration Management Database.
• Created workflows for Standard catalog items, Non Standard catalog item and Change approval process.
• Creating the UI pages to use them in catalog items, Implemented using UI scripts.
• Creating Knowledge articles to document the steps in creating the catalog items.
• Working on different kinds of variables and variable sets.
• Created both inbound Scripted Web Services and inbound Email Actions to create incidents from Emails.
• Worked on Web Services using SOAP Messages and called third party. Good understanding of WSDL, XML.
• Integrated with Active Directory for SSO using SAML 2.0
• Configured multiple Catalog Items Front-end web / GUI components using JavaScript, CSS, HTML5
• Worked on UI Macros to create pages as templates on requirement from the stake holders
• Resolving typical Users access and roles issues by checking active directory and users table.
• Pulling reports and scheduling the reports as per the client requirement.
• Creating database views to pull the reports on variables which are being used by catalog items.
• Writing Catalog client scripts and UI policies to make client side changes.
• Working on order guides, to arrange them in sequential order to make the user comfortable while raising a request.
• Re-designed workflows using workflow editor, Reconciled complicated workflows to simpler form.
• Writing script includes invoking them in reference qualifiers or variable scripting.

Environment: ServiceNow(Eureka), Agile, JavaScript, CSS, HTML 5, Windows 7.

Confidential

Service Now Developer

Responsibilities:

• Assisting client implementing the MSP (Managed Service Provider) instance for Service-Now and Domain separation for Service-Now Instances.
• Worked on the functional requirements and client requirements within ServiceNow.
• Facilitating rollout of new applications and modules.
• Design and implement new functionality using Business Rules, UI Policies, and Access Lists etc.
• Service Catalog and Request Workflow Design and Configuration
• Created various workflows for Incident Management, Change Management, Service Requests and SLA's.
• The service we also provide to clients is a semi managed service for administering their Service desks that has been implemented. This includes various administration tasks within Service desk software.
• Created Buttons and context menus both on form and lists using UI actions
• Designed several email templates by using HTML and jelly scripting and used them in notifications
• Worked with windows team, network team and Asset team in order to check for the data collected through discovery is accurate.
• Written script includes and invoked them in business rules and client scripts
• Imported many CI's using import set tables
• Imported Active Directory to ServiceNow using Data Sources.
• Created data sources and loaded the Service-Now tables with different data formats
• Created transform maps both automatic field mapping and scripting.
• Worked on Berlin, Calgary Versions.
• Worked on Asset Management and loaded the data into it.
• Integrated Fire eye tool with ServiceNow using Email integration i.e. inbound actions scripting.
• Worked on the integration of ServiceNow with Siebel, integrated Service Catalog and Incident module.
• Used JMS integration to fulfill this requirement, worked on Scheduled Jobs and Mid Server Script Includes to fulfill the requirements.

Environment: ServiceNow, JavaScript, XML, HTML 5, CSS, Agile, XHTML, jelly Script, Windows 7.

Confidential

Service Now/Applications Developer

Responsibilities:

• Assisting client implementing the MSP (Managed Service Provider) instance for Service-Now and Domain separation for Service-Now Instances.
• Working with client and functional requirements within Service Now.
• Facilitating rollout of new applications and modules.
• Worked with windows team, network team and Asset team in order to check for the data collected through discovery is accurate.
• Design and implement new functionality using Business Rules, UI Policies, and Access Lists etc.
• Service Catalog and Request Workflow Design and Configuration
• Created various workflows for Incident Management, Change Management, Service Requests and SLA's.
• The service we also provide to clients is a semi managed service for administering their Service desks that has been implemented. This includes various administration tasks within Service desk software.
• Created Buttons and context menus both on form and lists using UI actions
• Designed many email templates by using html and jelly scripting and used them in notifications
• Worked with windows team, network team and Asset team in order to check for the data collected through discovery is accurate.
• Created new Business Rules/Script Includes/Client catalog script/Client Script.
• Configured chat functionality for Service Desk ticketing queue
• Created transform maps for importing CMDB data.
• Written script includes and invoked them in business rules and client scripts
• Imported many CI’s using import set tables
• Imported Active Directory to Service now using data sources.
• Created data sources and loaded the Service-Now tables with different data formats
• Created transform maps both automatic field mapping and scripting
• Also worked on Asset Management and loaded the data into it.
• Integrated Fire eye tool with Service-Now using Email integration i.e. inbound actions scripting.
• Worked on the integration of Service Now with Siebel, integrated Service Catalog and Incident module.
• Used JMS integration to fulfill this requirement, worked on Scheduled Jobs and Mid Server Script Includes to fulfill the requirements.

Environment: Service Now, Java Script, Agile, workflows, Glide Script, CSS

Confidential

Oracle Developer

Responsibilities:

• Assisting client implementing the MSP (Managed Service Provider) instance for Service-Now and Domain separation for Service-Now Instances.
• Worked on the functional requirements and client requirements within ServiceNow.
• Facilitating rollout of new applications and modules.
• Designed and developed Oracle Forms to implement client requirements.
• Developed applications using the VI editor
• Experience in working with Gas Utility industry
• Used BCBS in ODI to deal with cull information from an IBM DB2-based data warehouse containing about 1.2 terabytes of information on healthcare providers and claims for about 2.9 million members
• Developed a feeder program to load external data from legacy system using SQL*Loader into interface tables in PO, INV, OM, AR modules.
• Developed APEX applications(2.1)
• Interfaces are built and automated with Informatica ETL tool, Unix Shell Scripting
• Modified Oracle DB packages, functions, and procedures followed customer requests.
• Modified the forms according to the business requirements.
• Used ODI Designer tool to design data integrity checks and to built transformations
• Used ODI Designer in order to generate documentation for the application.
• Involved in user interface designing using Developer 2000.
• Responsible for technical design documents.
• Designed and developed packages, triggers using PL/SQL in Star Schema.
• Developed new and modified existed Oracle scripts.
• Database performance tuning using Explain Plan and TKPROF.
• Created indexes, Views, constraints.
• Involved in developing packages for User Interfaces.

Environment: Oracle 10g, Db Visualizor, SQL Developer, Eclipse, PL/SQL Developer 7.0.2,Toad 7.3.4, Windows 7.

Confidential

Oracle Developer

Responsibilities:

• Assisting client implementing the MSP (Managed Service Provider) instance for Service-Now and Domain separation for Service-Now Instances.
• Involved in writing critical stored procedures, triggers, and functions in Oracle. Used all advanced features in Oracle for programming.
• Excellent skills in using development, methodologies, standards and procedures.
• Used Oracle applications with legacy systems using Application Programming Interfaces (API)
• Involved in writing the complex stored procedures, triggers and functions in Oracle retaining the business logic.
• Involved in writing complex stored procedures to facilitate functionality for invoking through Java application.
• Involved in writing new database triggers for auditing purposes.
• Involved in tuning stored procedures and optimizing database queries.
• Designed Sources to Targets mappings from primarily Flat files to Oracle using Informatica PowerCenter.
• Involved in dimensional modeling (Star) of the data warehouse to design the business process.
• Created the mappings using transformations such as the Source qualifier, Aggregator, Expression, Lookup, Router, Filter, and Update Strategy.
• Used ERWIN to design logical, physical database structures.

Environment: Oracle 10g, JavaScript, XML, HTML 5, CSS, Agile, Windows 7.

Confidential

Oracle Developer

Responsibilities:

• Analyze the data structures and processing methodologies of the old system, technical specifications and ERD of the old system to understand the transactions performed.
• Map the data into staging tables, and translate old coded values to new ones.
• Involved in Design Phase, created staging tables as an exact replica of the database structure of the system.
• Developed scripts for data upload using the SQL * Loader utility. Data from the legacy system was given in a character delimited flat files.
• Develop conversion routines in PL/SQL, manage and monitor the process of moving the data into the actual Renaissance transaction tables, to track and test the volume and quality of the data.
• Developed Stored Procedures, Functions, Packages, and Triggers as re-usable application programs that translated complex business logic.
• Used Query Optimizer, Tuning Advisors for Performance tuning and optimization of PL/SQL routines.
• Developed Unix Shell Scripts (Korn) to control execution of the conversion routines. .

Environment: Oracle 9i on Sun Solaris 2.6, PL/SQL, SQL * Loader,TOAD,SQL*Plus, Windows 7.

Confidential

Oracle Trainee

Responsibilities:

• Identified, managed and resolved testing issues promptly, which led the team to achieve and surpass project milestones.
• Ensured that team members created defects that were well documented.
• Using PL/SQL Tables and Records in transaction processing using the Oracle 8i feature Bulk Copy and Bulk Collect.
• Implemented the Case Statement Logic in SQL statements to reduce the PL/SQL code using Oracles 9i feature.
• Extensively used IMP and EXP for data transfer from source systems to new application.